1-- SYSTABLE
2create database if not exists calpontsys;
3
4use calpontsys;
5
6drop table if exists systable restrict;
7drop table if exists syscolumn restrict;
8
9create table if not exists systable (tablename varchar(128),
10                       `schema` varchar(128),
11                       objectid int,
12                       createdate date,
13                       lastupdate date,
14                       init int,
15                       next int,
16                       numofrows int,
17                       avgrowlen int,
18                       numofblocks int,
19					   autoincrement int) engine=columnstore comment='SCHEMA SYNC ONLY';
20
21-- SYSCOLUMN
22create table if not exists syscolumn (`schema` varchar(128),
23                        tablename varchar(128),
24                        columnname varchar(128),
25                        objectid integer,
26                        dictobjectid integer,
27                        listobjectid integer,
28                        treeobjectid integer,
29                        datatype integer,
30                        columnlength integer,
31                        columnposition integer,
32                        lastupdate date,
33                        defaultvalue varchar(64),
34                        nullable integer,
35                        scale integer,
36                        prec integer,
37                        autoincrement char(1),
38                        distcount integer,
39                        nullcount integer,
40                        minvalue varchar(64),
41                        `maxvalue` varchar(64),
42                        compressiontype integer,
43						nextvalue bigint) engine=columnstore comment='SCHEMA SYNC ONLY';
44