Annotation of /src/main/db2.script

Parent Directory | Revision Log

---

Revision 1 - (view) (download)

1 :	dgarcia	1	CREATE SCHEMA PUBLIC AUTHORIZATION DBA
2 :			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))
3 :			ALTER TABLE USER_TBL ALTER COLUMN ID RESTART WITH 1
4 :			CREATE USER SA PASSWORD ""
5 :			GRANT DBA TO SA
6 :			SET WRITE_DELAY 10

---

root@forge.cesga.es	ViewVC Help
Powered by ViewVC 1.0.0