FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
Kilo/db.sql at master · HTTP-RPC/Kilo · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
HTTP-RPC
/
Kilo
Public
Uh oh!
There was an error while loading.
Please reload this page
.
Notifications
You must be signed in to change notification settings
Fork
62
Star
339
Code
Pull requests
0
Discussions
Actions
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Discussions
Actions
Security and quality
Insights
Expand file tree
Breadcrumbs
Kilo
/
db.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
106 lines (86 loc) · 3.04 KB
Breadcrumbs
Kilo
/
db.sql
Copy path
File metadata and controls
106 lines (86 loc) · 3.04 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
drop
schema
if exists demo;
create
schema
demo
;
use demo;
create
table
owner
(
name
varchar
(
20
),
primary key
(name)
);
insert into
owner (name)
values
(
'
Harold
'
);
insert into
owner (name)
values
(
'
Gwen
'
);
insert into
owner (name)
values
(
'
Benny
'
);
insert into
owner (name)
values
(
'
Diane
'
);
create
table
pet
(
name
varchar
(
20
),
owner
varchar
(
20
),
species
varchar
(
20
),
sex
char
(
1
),
birth
date
,
death
date
,
primary key
(name),
foreign key
(owner)
references
owner(name)
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Fluffy
'
,
'
Harold
'
,
'
cat
'
,
'
f
'
,
'
1993-02-04
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Claws
'
,
'
Gwen
'
,
'
cat
'
,
'
m
'
,
'
1994-03-17
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Buffy
'
,
'
Harold
'
,
'
dog
'
,
'
f
'
,
'
1989-05-13
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Fang
'
,
'
Benny
'
,
'
dog
'
,
'
m
'
,
'
1990-08-27
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Bowser
'
,
'
Diane
'
,
'
dog
'
,
'
m
'
,
'
1979-08-31
'
,
'
1995-07-29
'
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Chirpy
'
,
'
Gwen
'
,
'
bird
'
,
'
f
'
,
'
1998-09-11
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Whistler
'
,
'
Gwen
'
,
'
bird
'
,
null
,
'
1997-12-09
'
,
null
);
insert into
pet (name, owner, species, sex, birth, death)
values
(
'
Slim
'
,
'
Benny
'
,
'
snake
'
,
'
m
'
,
'
1996-04-29
'
,
null
);
create
table
item
(
id
int
not null
auto_increment,
description
varchar
(
1024
)
not null
,
price double
not null
,
size tinyint
not null
,
color
varchar
(
128
)
not null
,
weight double
not null
,
created
bigint
not null
,
primary key
(id)
);
create
table
bulk_upload_test
(
id
int
not null
auto_increment,
text1
varchar
(
32
)
not null
,
text2
varchar
(
32
)
not null
,
number1 double
not null
,
number2 double
not null
,
number3 double
not null
,
primary key
(id)
);
create
table
whitespace_test
(
value
varchar
(
32
)
not null
);
create
table
temporal_accessor_test
(
id
int
not null
auto_increment,
local_date
date
not null
,
local_time
time
not null
,
instant
bigint
not null
,
timestamp
bigint
not null
,
primary key
(id)
);
create
table
json_test
(
id
int
not null
auto_increment,
list
varchar
(
1024
)
not null
,
map
varchar
(
1024
)
not null
,
record
varchar
(
1024
)
not null
,
primary key
(id)
);
create
table
xml_test
(
id
int
not null
auto_increment,
xml
varchar
(
1024
)
not null
,
primary key
(id)
);
drop
user
if exists
'
demo
'
@
'
%
'
;
create
user
'
demo
'@
'
%
'
identified by
'
demo123!
'
;
grant
select
, insert,
update
,
delete
on
demo.
*
to
'
demo
'
@
'
%
'
;
grant
select
on
employees.
*
to
'
demo
'
@
'
%
'
;
grant
select
on
sakila.
*
to
'
demo
'
@
'
%
'
;
flush privileges;
use employees;
drop
view
if exists employee_details;
create
view
employee_details
as
select
employees.
*
, (
select
json_arrayagg(json_object(
'
salary
'
, salary,
'
fromDate
'
, from_date,
'
toDate
'
, to_date
))
from
salaries
where
salaries
.
emp_no
=
employees
.
emp_no
)
as
salaries
from
employees;
Back
|
FazBrowse Home
|
New Git URL