SQLSolver/sqlsolver_data/schemas/calcite_test.base.schema.sql at main · khaiwang/SQLSolver · GitHub

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
);