devDB.script

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE MOTU(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,SEQID VARCHAR(255) NOT NULL,SEQUENCE VARCHAR(255) NOT NULL)
ALTER TABLE MOTU ALTER COLUMN ID RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO MOTU VALUES(1,0,'ABC001','cgatgcgcgctatagctagcgtagctgatcgta')
INSERT INTO MOTU VALUES(2,0,'ABC002','cgattatgctagctagtcgagtcgatc')