-
Notifications
You must be signed in to change notification settings - Fork 0
/
calcite_test.base.schema.sql
51 lines (46 loc) · 1.09 KB
/
calcite_test.base.schema.sql
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
CREATE TABLE `account`
(
`acctno` int not null,
`type` varchar(20) not null,
`balance` int not null
);
CREATE TABLE `bonus`
(
`ename` varchar(20) not null,
`job` varchar(10) not null,
`sal` int not null,
`comm` int not null
);
CREATE TABLE `dept`
(
`deptno` int primary key not null,
`name` varchar(10) not null
);
CREATE TABLE `emp`
(
`empno` int primary key not null,
`ename` varchar(20) not null,
`job` varchar(10) not null,
`mgr` int null,
`hiredate` int not null,
`sal` int not null,
`comm` int not null,
`deptno` int not null references dept (deptno),
`slacker` tinyint
);
CREATE TABLE `T`
(
`K0` varchar(20) not null,
`C1` varchar(20),
`F1_A0` int not null,
`F2_A0` tinyint not null,
`F0_C0` int not null,
`F1_C0` int,
`F0_C1` int not null,
`F1_C2` int not null,
`F2_C3` int not null
);
CREATE TABLE ANON
(
c INT
);