default.script

来自「用ｍａｐ ｂｕｆｆｅｒ进行ｍａｐ存取」· SCRIPT 代码 · 共 12 行

CREATE TABLE COMPANY(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255),COMMENT VARCHAR(255))
CREATE TABLE EMPLOYEE(ID VARCHAR(255) NOT NULL PRIMARY KEY,NAME VARCHAR(255),MSN VARCHAR(255),COMPANY BIGINT NOT NULL,COMMENT VARCHAR(255),CONSTRAINT FK4AFD4ACEB7D4C117 FOREIGN KEY(COMPANY) REFERENCES COMPANY(ID),CONSTRAINT FK4AFD4ACEAD431CA9 FOREIGN KEY(COMPANY) REFERENCES COMPANY(ID))
CREATE TABLE GUESTBOOKMESSAGE(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255),EMAIL VARCHAR(255),CONTENT VARCHAR(255),POSTTIME TIMESTAMP)
CREATE TABLE HIBERNATE_UNIQUE_KEY(NEXT_HI INTEGER)
CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60
INSERT INTO COMPANY VALUES(262144,'asas','sdsdfsdf')
INSERT INTO GUESTBOOKMESSAGE VALUES(65536,'aaa','[e-mail]','\u7559\u8a00sssss\u5185\u5bb9ddddd','2006-05-26 16:35:23.312')
INSERT INTO GUESTBOOKMESSAGE VALUES(98304,'name','email@neulion','content','2006-05-26 16:29:00.078')
INSERT INTO GUESTBOOKMESSAGE VALUES(360448,'','','','2007-07-04 17:16:01.281')
INSERT INTO HIBERNATE_UNIQUE_KEY VALUES(12)