Source

cloudster / docs / cloudster_brain_brain / brain.script

1
2
3
4
5
6
7
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE BRAINSYSTEMINFO(GUID VARCHAR_IGNORECASE,VERSION INTEGER,MINVERSION INTEGER,OWNERID INTEGER,CREATIONDATETIME TIMESTAMP,DBSERVERCONNECT VARCHAR_IGNORECASE,FILESERVERROOT VARCHAR_IGNORECASE,NOTESCSS VARCHAR_IGNORECASE,XMLEXTRAS VARCHAR_IGNORECASE)
CREATE USER SA PASSWORD "M0R3BR@1NS!!"
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO BRAINSYSTEMINFO VALUES('Placeholder Brain Data',7045,6070,NULL,'2012-08-21 12:01:07.863000000',NULL,'Placeholder File Path',NULL,NULL)