default-db.script

来自「SSH示范」· SCRIPT 代码 · 共 24 行

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE USER(GUID VARCHAR(50) NOT NULL PRIMARY KEY,ROLEID VARCHAR(50),USERID VARCHAR(50),PASSWORD VARCHAR(50),USERNAME VARCHAR(50),FLG VARCHAR(2))
CREATE MEMORY TABLE ROLE(GUID VARCHAR(50) NOT NULL PRIMARY KEY,ROLENAME VARCHAR(50))
CREATE MEMORY TABLE AREA(GUID VARCHAR(50) NOT NULL PRIMARY KEY,AREANAME VARCHAR(50),TIMENUM VARCHAR(20),USERID VARCHAR(50),FLG VARCHAR(2))
CREATE MEMORY TABLE CUSTOMER(GUID VARCHAR(50) NOT NULL PRIMARY KEY,AREAID VARCHAR(50),USERID VARCHAR(50),CUSTOMERNAME VARCHAR(50),ADDRESS VARCHAR(100),CREATETIME TIMESTAMP,UPDATETIME TIMESTAMP)
CREATE MEMORY TABLE WAREHOUSE(GUID VARCHAR(50) NOT NULL PRIMARY KEY,WAREHOUSEID VARCHAR(20),WAREHOUSENAME VARCHAR(100),CREATETIME TIMESTAMP,UPDATETIME TIMESTAMP)
CREATE MEMORY TABLE SALESPERSONS(GUID VARCHAR(50) NOT NULL PRIMARY KEY,PERSONNAME VARCHAR(50),REMARK VARCHAR(1000),CREATETIME TIMESTAMP,UPDATETIME TIMESTAMP)
CREATE MEMORY TABLE ORDERINFO(GUID VARCHAR(50) NOT NULL PRIMARY KEY,AREAID VARCHAR(50),USERID VARCHAR(50),ORDERNO VARCHAR(20),ORDERDATE TIMESTAMP,CUSTOMERNAME VARCHAR(50),ADDRESS VARCHAR(100),WAREHOUSEID VARCHAR(100),INPUTDATE TIMESTAMP,EFFECTIVEINFO VARCHAR(3000),PRINTINGDATE TIMESTAMP,HANDMADE VARCHAR(1000),HANDMADEFLG VARCHAR(10),REMARK VARCHAR(4000),SHORTING VARCHAR(3000),AMOUNT VARCHAR(20),TRACK VARCHAR(3000),SALESPERSONS VARCHAR(50),OK VARCHAR(2),CREATETIME TIMESTAMP,UPDATETIME TIMESTAMP)
CREATE MEMORY TABLE PAYMENT(GUID VARCHAR(50) NOT NULL PRIMARY KEY,USERID VARCHAR(50),PAYDATE TIMESTAMP,CUSTOMERNAME VARCHAR(50),CASH VARCHAR(20),REMARK VARCHAR(2000),CREATETIME TIMESTAMP,UPDATETIME TIMESTAMP)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO USER VALUES('A89F1F21-9FC7-1D9C-AA23-48FA7CED7029','KD7E3151-3Wk9-18W7-h012-8AWt1G347CTO','test','09:8F:6B:CD:46:21:D3:73:CA:DE:4E:83:26:27:B4:F6','\u4e00\u822c\u7528\u6237','0')
INSERT INTO USER VALUES('AD7E3151-3889-1857-E012-8AB71G347CF5','WD7E3151-3W89-18W7-E012-8AW71G347CW5','admin','21:23:2F:29:7A:57:A5:A7:43:89:4A:0E:4A:80:1F:C3','administator','0')
INSERT INTO ROLE VALUES('KD7E3151-3Wk9-18W7-h012-8AWt1G347CTO','user')
INSERT INTO ROLE VALUES('WD7E3151-3W89-18W7-E012-8AW71G347CW5','admin')
INSERT INTO AREA VALUES('86A80803-2B27-A425-95CF-73DD8077F181','\u4e0a\u6d77\u5730\u533a','060706173937276','A89F1F21-9FC7-1D9C-AA23-48FA7CED7029','0')
INSERT INTO AREA VALUES('BF30D6FC-8613-CECB-6CC5-6C7601D8A753','\u534e\u5357\u5730\u533a','060803144538452','A89F1F21-9FC7-1D9C-AA23-48FA7CED7029','0')
INSERT INTO AREA VALUES('E7B9D335-7A14-A4F8-F33B-C97EF80EEAD6','\u6c5f\u6d59\u5730\u533a','060721175606763','A89F1F21-9FC7-1D9C-AA23-48FA7CED7029','0')
INSERT INTO WAREHOUSE VALUES('03F46BFC-550E-60AB-CB79-AACA244F8EFE','SZD001','SZD002','2006-08-03 14:46:00.994000000','2006-08-03 14:46:00.994000000')
INSERT INTO WAREHOUSE VALUES('722B22A3-4BCE-D0BD-BA46-EBB165BF0F4E','SZD002','SZD003','2006-08-03 14:44:19.999000000','2006-08-03 14:44:19.999000000')
INSERT INTO WAREHOUSE VALUES('7401DA98-9E41-9A48-C6F0-A420704E45F2','SZD003','SZD004','2006-08-03 14:46:00.974000000','2006-08-03 14:46:00.974000000')