1INSTALL PLUGIN infinidb SONAME 'libcalmysql.dll';
2CREATE FUNCTION calgetstats RETURNS STRING SONAME 'libcalmysql.dll';
3CREATE FUNCTION calsettrace RETURNS INTEGER SONAME 'libcalmysql.dll';
4CREATE FUNCTION calsetparms RETURNS STRING SONAME 'libcalmysql.dll';
5CREATE FUNCTION calflushcache RETURNS INTEGER SONAME 'libcalmysql.dll';
6CREATE FUNCTION calgettrace RETURNS STRING SONAME 'libcalmysql.dll';
7CREATE FUNCTION calgetversion RETURNS STRING SONAME 'libcalmysql.dll';
8CREATE FUNCTION calonlinealter RETURNS INTEGER SONAME 'libcalmysql.dll';
9CREATE FUNCTION calviewtablelock RETURNS STRING SONAME 'libcalmysql.dll';
10CREATE FUNCTION calcleartablelock RETURNS STRING SONAME 'libcalmysql.dll';
11CREATE FUNCTION calgetsqlcount RETURNS STRING SONAME 'libcalmysql.dll';
12CREATE FUNCTION mcssystemready RETURNS INTEGER SONAME 'libcalmysql.dll';
13CREATE FUNCTION mcssystemreadonly RETURNS INTEGER SONAME 'libcalmysql.dll';
14
15create database if not exists calpontsys;
16use calpontsys;
17
18drop table if exists systable restrict;
19drop table if exists syscolumn restrict;
20
21-- SYSTABLE
22create table if not exists systable (
23	tablename varchar(128),
24	`schema` varchar(128),
25	objectid int,
26	createdate date,
27	lastupdate date,
28	init int,
29	next int,
30	numofrows int,
31	avgrowlen int,
32	numofblocks int,
33	autoincrement int
34	) engine=infinidb comment='SCHEMA SYNC ONLY';
35
36-- SYSCOLUMN
37create table if not exists syscolumn (
38	`schema` varchar(128),
39	tablename varchar(128),
40	columnname varchar(128),
41	objectid int,
42	dictobjectid int,
43	listobjectid int,
44	treeobjectid int,
45	datatype int,
46	columnlength int,
47	columnposition int,
48	lastupdate date,
49	defaultvalue varchar(64),
50	nullable int,
51	scale int,
52	prec int,
53	autoincrement char(1),
54	distcount int,
55	nullcount int,
56	minvalue varchar(64),
57	maxvalue varchar(64),
58	compressiontype int,
59	nextvalue bigint
60	) engine=infinidb comment='SCHEMA SYNC ONLY';
61
62