test.script

一个由jsp+servlet+MySQL简单的新闻发布系统

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE USERINFO(ACCOUNT VARCHAR(16) NOT NULL PRIMARY KEY,NAME VARCHAR(30),SEX CHAR(2),BIRTHDAY DATE,HOMEPLACE VARCHAR(80),TEL VARCHAR(16),QQ VARCHAR(10),EMAIL VARCHAR(30),MYSHOW VARCHAR(1000))
CREATE MEMORY TABLE USER(ID INTEGER NOT NULL PRIMARY KEY,ACCOUNT VARCHAR(16),PASSWORD VARCHAR(16))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO USERINFO VALUES('luchao7285','\u9646\u8d85','\u7537','1984-09-08','\u6b66\u6c49','13987654321','87654321','[e-mail]','aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ')
INSERT INTO USER VALUES(1,'luchao','19840908')