Revision 1 -
(download)
(annotate)
Wed Jul 28 10:05:51 2010 UTC
(13 years, 10 months ago)
by dgarcia File size: 484 byte(s)
First code commit
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE USER_TBL(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,ACCOUNTING_GROUP VARCHAR(255),ACCOUNTING_USERNAME VARCHAR(255) NOT NULL,PASSWORD VARCHAR(255) NOT NULL,SEE_ACCOUNTING_GROUP_DATA BOOLEAN,SEE_ALL BOOLEAN,USERNAME VARCHAR(255) NOT NULL,CONSTRAINT SYS_CT_46 UNIQUE(USERNAME))
ALTER TABLE USER_TBL ALTER COLUMN ID RESTART WITH 1
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10