hsql.script

主要对各种数据库性能进行测试

CREATE TABLE PERSON(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1)  NOT NULL PRIMARY KEY,NAME VARCHAR(32),NAME3 VARCHAR(32),NAME4 VARCHAR(32),NAME5 VARCHAR(32),NAME6 VARCHAR(32),NAME7 VARCHAR(32),NAME8 VARCHAR(32),NAME9 VARCHAR(32),NAME10 INTEGER)
CREATE INDEX PERSON_IDX ON PERSON(ID)
CREATE INDEX PERSON_IDX2 ON PERSON(NAME)
CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60