final.script

合并几个数据库结构相同的数据库文件。hsql数据库文件合并

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE TEXT TABLE USERS(ID VARCHAR NOT NULL PRIMARY KEY,PASSWORD VARCHAR NOT NULL)
SET TABLE USERS SOURCE "users.csv;encoding=utf-8"
CREATE TEXT TABLE USERANS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,USERID VARCHAR,OPTIONS VARCHAR,SCORE INTEGER,DATE TIMESTAMP,TESTTYPE VARCHAR,CONSTRAINT SYS_FK_51 FOREIGN KEY(USERID) REFERENCES USERS(ID) ON DELETE CASCADE)
SET TABLE USERANS SOURCE "userans.csv;encoding=utf-8"
CREATE TEXT TABLE USERPQ(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,USERID VARCHAR,BEDTIME INTEGER,DELAYTIME INTEGER,SLEEPTIME INTEGER,OPTIONS VARCHAR,SCOREA INTEGER,SCOREB INTEGER,SCOREC INTEGER,SCORED INTEGER,SCOREE INTEGER,SCOREF INTEGER,SCOREG INTEGER,DATE TIMESTAMP,CONSTRAINT SYS_FK_64 FOREIGN KEY(USERID) REFERENCES USERS(ID) ON DELETE CASCADE)
SET TABLE USERPQ SOURCE "userpq.csv;encoding=utf-8"
CREATE TEXT TABLE USERFS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,USERID VARCHAR,PHYSICAL INTEGER,MENTAL INTEGER,OPTIONS VARCHAR,DATE TIMESTAMP,CONSTRAINT SYS_FK_69 FOREIGN KEY(USERID) REFERENCES USERS(ID) ON DELETE CASCADE)
SET TABLE USERFS SOURCE "userfs.csv;encoding=utf-8"
ALTER TABLE USERANS ALTER COLUMN ID RESTART WITH 0
ALTER TABLE USERPQ ALTER COLUMN ID RESTART WITH 0
ALTER TABLE USERFS ALTER COLUMN ID RESTART WITH 0
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10