CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE DEFINITION_VIEW_PREFERENCES(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,DEFINITION_NAME VARCHAR(255) NOT NULL,SHOW_OWN_VALUE BOOLEAN,VISIBLE_FIELDS VARBINARY(255),CONSTRAINT SYS_CT_46 UNIQUE(DEFINITION_NAME))
CREATE MEMORY TABLE JSEC_PERMISSION(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,POSSIBLE_ACTIONS VARCHAR(255) NOT NULL,TYPE VARCHAR(255) NOT NULL,CONSTRAINT SYS_CT_50 UNIQUE(TYPE))
CREATE MEMORY TABLE JSEC_ROLE(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,CONSTRAINT SYS_CT_54 UNIQUE(NAME))
CREATE MEMORY TABLE JSEC_ROLE_PERMISSION_REL(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,ACTIONS VARCHAR(255) NOT NULL,PERMISSION_ID BIGINT NOT NULL,ROLE_ID BIGINT NOT NULL,TARGET VARCHAR(255) NOT NULL,CONSTRAINT FK6DF5807A79330777 FOREIGN KEY(PERMISSION_ID) REFERENCES JSEC_PERMISSION(ID),CONSTRAINT FK6DF5807AB2A74BD7 FOREIGN KEY(ROLE_ID) REFERENCES JSEC_ROLE(ID))
CREATE MEMORY TABLE JSEC_USER(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,PASSWORD_HASH VARCHAR(255) NOT NULL,USERNAME VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE JSEC_USER_PERMISSION_REL(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,ACTIONS VARCHAR(255) NOT NULL,PERMISSION_ID BIGINT NOT NULL,TARGET VARCHAR(255),USER_ID BIGINT NOT NULL,CONSTRAINT FK28FF608579330777 FOREIGN KEY(PERMISSION_ID) REFERENCES JSEC_PERMISSION(ID),CONSTRAINT FK28FF608557D20FB7 FOREIGN KEY(USER_ID) REFERENCES JSEC_USER(ID))
CREATE MEMORY TABLE JSEC_USER_ROLE_REL(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,ROLE_ID BIGINT NOT NULL,USER_ID BIGINT NOT NULL,CONSTRAINT FK238F64AC57D20FB7 FOREIGN KEY(USER_ID) REFERENCES JSEC_USER(ID),CONSTRAINT FK238F64ACB2A74BD7 FOREIGN KEY(ROLE_ID) REFERENCES JSEC_ROLE(ID))
CREATE MEMORY TABLE ENTITY(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL,MY_ID VARCHAR(255) NOT NULL,OBJECT_CLASS VARCHAR(255) NOT NULL,OWN_NAME VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ENTITY_ATT_CONTENT_TYPE(ATT_CONTENT_TYPE BIGINT,ATT_CONTENT_TYPE_IDX VARCHAR(255),ATT_CONTENT_TYPE_ELT VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ENTITY_ATT_VALUE(ATT_VALUE BIGINT,ATT_VALUE_IDX VARCHAR(255),ATT_VALUE_ELT VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ENTITY_LINK_SINKS(LINK_SINKS BIGINT,LINK_SINKS_IDX VARCHAR(255),LINK_SINKS_ELT VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ENTITY_LINK_SRCS(LINK_SRCS BIGINT,LINK_SRCS_IDX VARCHAR(255),LINK_SRCS_ELT VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ISLAMIC_CALENDER(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VERSION BIGINT NOT NULL)
ALTER TABLE DEFINITION_VIEW_PREFERENCES ALTER COLUMN ID RESTART WITH 1
ALTER TABLE JSEC_PERMISSION ALTER COLUMN ID RESTART WITH 1
ALTER TABLE JSEC_ROLE ALTER COLUMN ID RESTART WITH 3
ALTER TABLE JSEC_ROLE_PERMISSION_REL ALTER COLUMN ID RESTART WITH 1
ALTER TABLE JSEC_USER ALTER COLUMN ID RESTART WITH 12
ALTER TABLE JSEC_USER_PERMISSION_REL ALTER COLUMN ID RESTART WITH 1
ALTER TABLE JSEC_USER_ROLE_REL ALTER COLUMN ID RESTART WITH 3
ALTER TABLE ENTITY ALTER COLUMN ID RESTART WITH 1
ALTER TABLE ISLAMIC_CALENDER ALTER COLUMN ID RESTART WITH 1
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO JSEC_ROLE VALUES(1,0,'Administrator')
INSERT INTO JSEC_ROLE VALUES(2,0,'User')
INSERT INTO JSEC_USER VALUES(1,0,'d033e22ae348aeb5660fc2140aec35850c4da997','admin')
INSERT INTO JSEC_USER VALUES(2,0,'12dea96fec20593566ab75692c9949596833adc9','user')
INSERT INTO JSEC_USER VALUES(4,0,'91281995ca794fafdd10db37a46c5a0786bc0d2a','rmunsky')
INSERT INTO JSEC_USER VALUES(5,0,'bf9661defa3daecacfde5bde0214c4a439351d4d','saddsaa')
INSERT INTO JSEC_USER VALUES(6,0,'asasddas','asdasdsad')
INSERT INTO JSEC_USER VALUES(7,0,'2','1')
INSERT INTO JSEC_USER VALUES(8,0,'22','2')
INSERT INTO JSEC_USER VALUES(9,0,'33','22')
INSERT INTO JSEC_USER VALUES(10,0,'22','222')
INSERT INTO JSEC_USER VALUES(11,13,'8effee409c625e1a2d8f5033631840e6ce1dcb64','55')
INSERT INTO JSEC_USER_ROLE_REL VALUES(1,0,1,1)
INSERT INTO JSEC_USER_ROLE_REL VALUES(2,0,2,2)