Log In | Get Help   
Home My Page Projects Code Snippets Project Openings Accounting and Billing Portal
Summary Activity Forums Tracker Lists Tasks Docs Surveys News SCM Files
[abportal] View of /src/main/db2.script
[abportal] / src / main / db2.script Repository:
ViewVC logotype

View of /src/main/db2.script

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1 - (download) (annotate)
Wed Jul 28 10:05:51 2010 UTC (13 years, 9 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

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

Powered By FusionForge