CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE KEYSTORE(KEYID BIGINT NOT NULL PRIMARY KEY,ALIAS VARCHAR(255) NOT NULL,TYPE VARCHAR(32) NOT NULL,ALGORITHM VARCHAR(32) NOT NULL,KEYSPEC LONGVARCHAR NOT NULL)
CREATE MEMORY TABLE CONFVERSION(CONFVERSIONID BIGINT NOT NULL PRIMARY KEY,BUILDNUMBER INTEGER NOT NULL,INSTALLDATE TIMESTAMP,VERSIONTAG VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODDATE TIMESTAMP,CONSTRAINT SYS_CT_47 UNIQUE(BUILDNUMBER))
CREATE MEMORY TABLE OS_USER_GROUP(GROUP_ID BIGINT NOT NULL,USER_ID BIGINT NOT NULL,PRIMARY KEY(USER_ID,GROUP_ID))
CREATE MEMORY TABLE PLUGINDATA(PLUGINDATAID BIGINT NOT NULL PRIMARY KEY,PLUGINKEY VARCHAR(255) NOT NULL,FILENAME VARCHAR(255) NOT NULL,LASTMODDATE TIMESTAMP,DATA LONGVARBINARY,CONSTRAINT SYS_CT_51 UNIQUE(PLUGINKEY),CONSTRAINT SYS_CT_52 UNIQUE(FILENAME))
CREATE MEMORY TABLE EXTRNLNKS(LINKID BIGINT NOT NULL PRIMARY KEY,CONTENTTYPE VARCHAR(255) NOT NULL,VIEWCOUNT INTEGER NOT NULL,URL VARCHAR(255) NOT NULL,CONTENTID BIGINT NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP)
CREATE INDEX EL_CONTENTID_IDX ON EXTRNLNKS(CONTENTID)
CREATE MEMORY TABLE EXTERNAL_ENTITIES(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255),TYPE VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ATTACHMENTS(ATTACHMENTID BIGINT NOT NULL PRIMARY KEY,TITLE VARCHAR(255) NOT NULL,CONTENTTYPE VARCHAR(255) NOT NULL,PAGEID BIGINT NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,FILESIZE BIGINT,ATTACHMENT_COMMENT VARCHAR(255),ATTVERSION INTEGER,PREVVER BIGINT,CONSTRAINT FK54475F9017D4A070 FOREIGN KEY(PREVVER) REFERENCES ATTACHMENTS(ATTACHMENTID))
CREATE INDEX ATT_PAGEID_IDX ON ATTACHMENTS(PAGEID)
CREATE INDEX ATT_PREVVER_IDX ON ATTACHMENTS(PREVVER)
CREATE MEMORY TABLE OS_USER(ID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(255) NOT NULL,PASSWD VARCHAR(255),CONSTRAINT SYS_CT_59 UNIQUE(USERNAME))
CREATE MEMORY TABLE CONFANCESTORS(DESCENDENTID BIGINT NOT NULL,ANCESTORID BIGINT NOT NULL,ANCESTORPOSITION INTEGER NOT NULL,PRIMARY KEY(DESCENDENTID,ANCESTORPOSITION))
CREATE MEMORY TABLE SPACES(SPACEID BIGINT NOT NULL PRIMARY KEY,SPACENAME VARCHAR(255),SPACEKEY VARCHAR(255) NOT NULL,SPACEDESCID BIGINT,HOMEPAGE BIGINT,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,SPACETYPE VARCHAR(255),SPACEGROUPID BIGINT,CONSTRAINT SYS_CT_63 UNIQUE(SPACEKEY))
CREATE INDEX S_SPACEDESCID_IDX ON SPACES(SPACEDESCID)
CREATE INDEX S_SPACEGROUPID_IDX ON SPACES(SPACEGROUPID)
CREATE INDEX S_HOMEPAGE_IDX ON SPACES(HOMEPAGE)
CREATE MEMORY TABLE LABEL(LABELID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255),OWNER VARCHAR(255),NAMESPACE VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODDATE TIMESTAMP)
CREATE INDEX L_OWNER_IDX ON LABEL(OWNER)
CREATE INDEX L_NAME_IDX ON LABEL(NAME)
CREATE INDEX L_NAMESPACE_IDX ON LABEL(NAMESPACE)
CREATE MEMORY TABLE EXTERNAL_MEMBERS(EXTENTITYID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,PRIMARY KEY(GROUPID,EXTENTITYID),CONSTRAINT FKD8C8D8A5F25E5D5F FOREIGN KEY(EXTENTITYID) REFERENCES EXTERNAL_ENTITIES(ID))
CREATE MEMORY TABLE LOCAL_MEMBERS(USERID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,PRIMARY KEY(GROUPID,USERID))
CREATE MEMORY TABLE SPACEGROUPS(SPACEGROUPID BIGINT NOT NULL PRIMARY KEY,SPACEGROUPNAME VARCHAR(255),SPACEGROUPKEY VARCHAR(255) NOT NULL,LICENSEKEY LONGVARCHAR,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT SYS_CT_69 UNIQUE(SPACEGROUPKEY))
CREATE MEMORY TABLE CONTENT(CONTENTID BIGINT NOT NULL PRIMARY KEY,CONTENTTYPE VARCHAR(255) NOT NULL,TITLE VARCHAR(255),VERSION INTEGER,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,VERSIONCOMMENT LONGVARCHAR,PREVVER BIGINT,CONTENT_STATUS VARCHAR(255),SPACEID BIGINT,PARENTID BIGINT,MESSAGEID VARCHAR(255),DRAFTPAGEID VARCHAR(255),DRAFTSPACEKEY VARCHAR(255),DRAFTTYPE VARCHAR(255),DRAFTPAGEVERSION INTEGER,PAGEID BIGINT,PARENTCOMMENTID BIGINT,USERNAME VARCHAR(255),CONSTRAINT FK6382C0598C38FBEA FOREIGN KEY(PAGEID) REFERENCES CONTENT(CONTENTID),CONSTRAINT FK6382C05974B18345 FOREIGN KEY(PARENTID) REFERENCES CONTENT(CONTENTID),CONSTRAINT FK6382C05917D4A070 FOREIGN KEY(PREVVER) REFERENCES CONTENT(CONTENTID),CONSTRAINT FK6382C059B97E9230 FOREIGN KEY(PARENTCOMMENTID) REFERENCES CONTENT(CONTENTID),CONSTRAINT FK6382C059B2DC6081 FOREIGN KEY(SPACEID) REFERENCES SPACES(SPACEID))
CREATE INDEX C_DRAFTSPACEKEY_IDX ON CONTENT(DRAFTSPACEKEY)
CREATE INDEX C_PARENTCOMMID_IDX ON CONTENT(PARENTCOMMENTID)
CREATE INDEX C_TITLE_IDX ON CONTENT(TITLE)
CREATE INDEX C_SPACEID_IDX ON CONTENT(SPACEID)
CREATE INDEX C_DRAFTTYPE_IDX ON CONTENT(DRAFTTYPE)
CREATE INDEX C_DRAFTPAGEID_IDX ON CONTENT(DRAFTPAGEID)
CREATE INDEX C_PARENTID_IDX ON CONTENT(PARENTID)
CREATE INDEX C_USERNAME_IDX ON CONTENT(USERNAME)
CREATE INDEX C_PREVVER_IDX ON CONTENT(PREVVER)
CREATE INDEX C_MESSAGEID_IDX ON CONTENT(MESSAGEID)
CREATE INDEX C_CONTENTTYPE_IDX ON CONTENT(CONTENTTYPE)
CREATE INDEX C_PAGEID_IDX ON CONTENT(PAGEID)
CREATE MEMORY TABLE LINKS(LINKID BIGINT NOT NULL PRIMARY KEY,DESTPAGETITLE VARCHAR(255),DESTSPACEKEY VARCHAR(255) NOT NULL,CONTENTID BIGINT NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FK45157998DD41734 FOREIGN KEY(CONTENTID) REFERENCES CONTENT(CONTENTID))
CREATE INDEX L_CONTENTID_IDX ON LINKS(CONTENTID)
CREATE INDEX L_DESTSPACEKEY_IDX ON LINKS(DESTSPACEKEY)
CREATE MEMORY TABLE OS_PROPERTYENTRY(ENTITY_NAME VARCHAR(125) NOT NULL,ENTITY_ID BIGINT NOT NULL,ENTITY_KEY VARCHAR(200) NOT NULL,KEY_TYPE INTEGER,BOOLEAN_VAL BOOLEAN,DOUBLE_VAL DOUBLE,STRING_VAL VARCHAR(255),TEXT_VAL LONGVARCHAR,LONG_VAL BIGINT,INT_VAL INTEGER,DATE_VAL TIMESTAMP,PRIMARY KEY(ENTITY_NAME,ENTITY_ID,ENTITY_KEY))
CREATE INDEX OSPE_ENTITYID_IDX ON OS_PROPERTYENTRY(ENTITY_ID)
CREATE MEMORY TABLE BANDANA(BANDANAID BIGINT NOT NULL PRIMARY KEY,BANDANACONTEXT VARCHAR(255),BANDANAKEY VARCHAR(100),BANDANAVALUE LONGVARCHAR)
CREATE INDEX BAND_CONTEXT_IDX ON BANDANA(BANDANACONTEXT)
CREATE INDEX BAND_KEY_IDX ON BANDANA(BANDANAKEY)
CREATE MEMORY TABLE DECORATOR(DECORATORID BIGINT NOT NULL PRIMARY KEY,SPACEKEY VARCHAR(255),DECORATORNAME VARCHAR(255),BODY LONGVARCHAR,LASTMODDATE TIMESTAMP)
CREATE INDEX DEC_NAME_IDX ON DECORATOR(DECORATORNAME)
CREATE INDEX DEC_KEY_IDX ON DECORATOR(SPACEKEY)
CREATE MEMORY TABLE BODYCONTENT(BODYCONTENTID BIGINT NOT NULL PRIMARY KEY,BODY LONGVARCHAR,CONTENTID BIGINT,CONSTRAINT FKA898D4778DD41734 FOREIGN KEY(CONTENTID) REFERENCES CONTENT(CONTENTID))
CREATE INDEX BODY_CONTENT_IDX ON BODYCONTENT(CONTENTID)
CREATE MEMORY TABLE CLUSTERSAFETY(CLUSTERSAFETYID BIGINT NOT NULL PRIMARY KEY,SAFETYNUMBER INTEGER)
CREATE MEMORY TABLE SPACEPERMISSIONS(PERMID BIGINT NOT NULL PRIMARY KEY,SPACEID BIGINT,PERMTYPE VARCHAR(255) NOT NULL,PERMGROUPNAME VARCHAR(255),PERMUSERNAME VARCHAR(255),CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FKD33F23BEB2DC6081 FOREIGN KEY(SPACEID) REFERENCES SPACES(SPACEID))
CREATE INDEX SP_PUNAME_IDX ON SPACEPERMISSIONS(PERMUSERNAME)
CREATE INDEX SP_PGNAME_IDX ON SPACEPERMISSIONS(PERMGROUPNAME)
CREATE INDEX SP_PERMTYPE_IDX ON SPACEPERMISSIONS(PERMTYPE)
CREATE INDEX SP_SPACEID_IDX ON SPACEPERMISSIONS(SPACEID)
CREATE MEMORY TABLE CONTENT_LABEL(ID BIGINT NOT NULL PRIMARY KEY,LABELID BIGINT NOT NULL,CONTENTID BIGINT NOT NULL,SPACEKEY VARCHAR(255),OWNER VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODDATE TIMESTAMP,CONSTRAINT FKF0E7436E8DD41734 FOREIGN KEY(CONTENTID) REFERENCES CONTENT(CONTENTID),CONSTRAINT FKF0E7436E27072AEF FOREIGN KEY(LABELID) REFERENCES LABEL(LABELID))
CREATE INDEX CL_SPACEKEY_IDX ON CONTENT_LABEL(SPACEKEY)
CREATE INDEX CL_CONTENTID_IDX ON CONTENT_LABEL(CONTENTID)
CREATE INDEX CL_LABELID_IDX ON CONTENT_LABEL(LABELID)
CREATE INDEX CL_LASTMODDATE_IDX ON CONTENT_LABEL(LASTMODDATE)
CREATE MEMORY TABLE TRACKBACKLINKS(LINKID BIGINT NOT NULL PRIMARY KEY,CONTENTTYPE VARCHAR(255) NOT NULL,VIEWCOUNT INTEGER NOT NULL,URL VARCHAR(255) NOT NULL,TITLE VARCHAR(255),BLOGNAME VARCHAR(255),EXCERPT VARCHAR(255),CONTENTID BIGINT NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FKF6977A478DD41734 FOREIGN KEY(CONTENTID) REFERENCES CONTENT(CONTENTID))
CREATE INDEX TBL_CONTENTID_IDX ON TRACKBACKLINKS(CONTENTID)
CREATE MEMORY TABLE CONTENTLOCK(CONTENTLOCKID BIGINT NOT NULL PRIMARY KEY,TITLE VARCHAR(20),GROUPNAME VARCHAR(255),EXPIRYDATE TIMESTAMP,CONTENT BIGINT,CREATOR VARCHAR(255),COMMENTSTR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FK692CA9046382C059 FOREIGN KEY(CONTENT) REFERENCES CONTENT(CONTENTID))
CREATE INDEX CL_TITLE_IDX ON CONTENTLOCK(TITLE)
CREATE INDEX CL_CONTENT_IDX ON CONTENTLOCK(CONTENT)
CREATE MEMORY TABLE PAGETEMPLATES(TEMPLATEID BIGINT NOT NULL PRIMARY KEY,TEMPLATENAME VARCHAR(255) NOT NULL,TEMPLATEDESC VARCHAR(255),LABELS VARCHAR(255),CONTENT LONGVARCHAR,SPACEID BIGINT,PREVVER BIGINT,VERSION INTEGER NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FKBC7CE96AB2DC6081 FOREIGN KEY(SPACEID) REFERENCES SPACES(SPACEID),CONSTRAINT FKBC7CE96A17D4A070 FOREIGN KEY(PREVVER) REFERENCES PAGETEMPLATES(TEMPLATEID))
CREATE INDEX PT_PREVVER_IDX ON PAGETEMPLATES(PREVVER)
CREATE INDEX PT_SPACEID_IDX ON PAGETEMPLATES(SPACEID)
CREATE MEMORY TABLE NOTIFICATIONS(NOTIFICATIONID BIGINT NOT NULL PRIMARY KEY,PAGEID BIGINT,SPACEID BIGINT,USERNAME VARCHAR(255) NOT NULL,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP,CONSTRAINT FK594ACC88C38FBEA FOREIGN KEY(PAGEID) REFERENCES CONTENT(CONTENTID),CONSTRAINT FK594ACC8B2DC6081 FOREIGN KEY(SPACEID) REFERENCES SPACES(SPACEID))
CREATE INDEX N_SPACEID_IDX ON NOTIFICATIONS(SPACEID)
CREATE INDEX N_PAGEID_IDX ON NOTIFICATIONS(PAGEID)
CREATE MEMORY TABLE CONTENT_PERM(ID BIGINT NOT NULL PRIMARY KEY,CP_TYPE VARCHAR(10) NOT NULL,USERNAME VARCHAR(255),GROUPNAME VARCHAR(255),CPS_ID BIGINT,CREATOR VARCHAR(255),CREATIONDATE TIMESTAMP,LASTMODIFIER VARCHAR(255),LASTMODDATE TIMESTAMP)
CREATE INDEX CP_OS_IDX ON CONTENT_PERM(CPS_ID)
CREATE INDEX CP_GN_IDX ON CONTENT_PERM(GROUPNAME)
CREATE INDEX CP_UN_IDX ON CONTENT_PERM(USERNAME)
CREATE MEMORY TABLE GROUPS(ID BIGINT NOT NULL PRIMARY KEY,GROUPNAME VARCHAR(255) NOT NULL)
CREATE MEMORY TABLE ATTACHMENTDATA(ATTACHMENTDATAID BIGINT NOT NULL PRIMARY KEY,ATTVERSION INTEGER NOT NULL,DATA LONGVARBINARY,ATTACHMENTID BIGINT,CONSTRAINT FK9DC3E34D34A4917E FOREIGN KEY(ATTACHMENTID) REFERENCES ATTACHMENTS(ATTACHMENTID))
CREATE INDEX ATTCH_DATA_IDX ON ATTACHMENTDATA(ATTACHMENTID)
CREATE MEMORY TABLE OS_GROUP(ID BIGINT NOT NULL PRIMARY KEY,GROUPNAME VARCHAR(255) NOT NULL,CONSTRAINT SYS_CT_88 UNIQUE(GROUPNAME))
CREATE MEMORY TABLE USERS(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,PASSWORD VARCHAR(255),EMAIL VARCHAR(255),CREATED TIMESTAMP,FULLNAME VARCHAR(255),CONSTRAINT SYS_CT_91 UNIQUE(NAME))
CREATE MEMORY TABLE CONTENT_PERM_SET(ID BIGINT NOT NULL PRIMARY KEY,CONT_PERM_TYPE VARCHAR(10) NOT NULL,CONTENT_ID BIGINT,CREATIONDATE TIMESTAMP,LASTMODDATE TIMESTAMP,CONSTRAINT FKBF45A7992CAF22C1 FOREIGN KEY(CONTENT_ID) REFERENCES CONTENT(CONTENTID))
CREATE INDEX CPS_CONTENT_IDX ON CONTENT_PERM_SET(CONTENT_ID)
CREATE MEMORY TABLE INDEXQUEUEENTRIES(ENTRYID BIGINT NOT NULL PRIMARY KEY,CREATIONDATE TIMESTAMP,TYPE INTEGER,HANDLE VARCHAR(255))
CREATE MEMORY TABLE HIBERNATE_UNIQUE_KEY(NEXT_HI INTEGER)
ALTER TABLE OS_USER_GROUP ADD CONSTRAINT FK93247246F73AEE0F FOREIGN KEY(USER_ID) REFERENCES OS_USER(ID)
ALTER TABLE OS_USER_GROUP ADD CONSTRAINT FK932472461E2E76DB FOREIGN KEY(GROUP_ID) REFERENCES OS_GROUP(ID)
ALTER TABLE EXTRNLNKS ADD CONSTRAINT FK97C10FE78DD41734 FOREIGN KEY(CONTENTID) REFERENCES CONTENT(CONTENTID)
ALTER TABLE ATTACHMENTS ADD CONSTRAINT FK54475F908C38FBEA FOREIGN KEY(PAGEID) REFERENCES CONTENT(CONTENTID)
ALTER TABLE CONFANCESTORS ADD CONSTRAINT FK9494E23C37E35A2E FOREIGN KEY(ANCESTORID) REFERENCES CONTENT(CONTENTID)
ALTER TABLE CONFANCESTORS ADD CONSTRAINT FK9494E23CC45E94DC FOREIGN KEY(DESCENDENTID) REFERENCES CONTENT(CONTENTID)
ALTER TABLE SPACES ADD CONSTRAINT FK9228242D16994414 FOREIGN KEY(SPACEGROUPID) REFERENCES SPACEGROUPS(SPACEGROUPID)
ALTER TABLE SPACES ADD CONSTRAINT FK9228242D11B7BFEE FOREIGN KEY(HOMEPAGE) REFERENCES CONTENT(CONTENTID)
ALTER TABLE SPACES ADD CONSTRAINT FK9228242D2C72D3D2 FOREIGN KEY(SPACEDESCID) REFERENCES CONTENT(CONTENTID)
ALTER TABLE EXTERNAL_MEMBERS ADD CONSTRAINT FKD8C8D8A5117D5FDA FOREIGN KEY(GROUPID) REFERENCES GROUPS(ID)
ALTER TABLE LOCAL_MEMBERS ADD CONSTRAINT FK6B8FB445117D5FDA FOREIGN KEY(GROUPID) REFERENCES GROUPS(ID)
ALTER TABLE LOCAL_MEMBERS ADD CONSTRAINT FK6B8FB445CE2B3226 FOREIGN KEY(USERID) REFERENCES USERS(ID)
ALTER TABLE CONTENT_PERM ADD CONSTRAINT FKBD74B31676E33274 FOREIGN KEY(CPS_ID) REFERENCES CONTENT_PERM_SET(ID)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO KEYSTORE VALUES(491521,'confluence:9131454','public','RSA','MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqqyREFnAe9XTv3ZIPxz61K3g2h1HzO4k+tF3czMjXD7GeLeMw97K0k8uL4ac+UEuEOz/YQ9sBpleNa+Pcx9VwuT3hOr49uBlHkaNpWHV7x5iWeJ7/Cr0m+jM0G45AdYhBVe3bTOrfmv3eok9+7M3EpPaZCs8BNq0T3GDt1CApuRnj8u/M7VVQiidroqzB5qUTz++Jvo5K7gA5TLijJBzbNPxbdZdMFbRt7f4G8SIECRMmTcFaMzLfY3xw6v4ZBfZeOtyOXhAGfBL2EGv2Eap0bSIindAB4Kc5gXYHVsipTPH/Klhno6IOwwPgJpP6MDXwzHA7RAJSXVRX/whwXA1kQIDAQAB')
INSERT INTO KEYSTORE VALUES(491522,'confluence:9131454','private','RSA','MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCqrJEQWcB71dO/dkg/HPrUreDaHUfM7iT60XdzMyNcPsZ4t4zD3srSTy4vhpz5QS4Q7P9hD2wGmV41r49zH1XC5PeE6vj24GUeRo2lYdXvHmJZ4nv8KvSb6MzQbjkB1iEFV7dtM6t+a/d6iT37szcSk9pkKzwE2rRPcYO3UICm5GePy78ztVVCKJ2uirMHmpRPP74m+jkruADlMuKMkHNs0/Ft1l0wVtG3t/gbxIgQJEyZNwVozMt9jfHDq/hkF9l463I5eEAZ8EvYQa/YRqnRtIiKd0AHgpzmBdgdWyKlM8f8qWGejog7DA+Amk/owNfDMcDtEAlJdVFf/CHBcDWRAgMBAAECggEBAKQpL66GZXm3BeCWqI7sFOcUB75Dg5g9Rxxo9Xe8rDpBtyzNf3u2g2cd+dKEq9+jLefhzRFSgBko01DX+CZG8XpwOROD3su2sgwY2I1GOTuyAe9qxM6bkoOTu8yO+A4oI8K7yBYlKMKEnpkiAJhknIgl5l2KqEQTCHORP5vGtrfOTxEEXid6Viyvvz3dV7O//RMEYTc57THhDDbXyoXAKHJLPswy1LaAuEN4TU5GiHQY2R0SKfXoIUZUYRS1NMWekKTROjZ1p1+MzJqpBOJgbqEt8XPddc58ZP+kXiMq892JJ/MDIe8pPUimh+QjFmMXe+OsRKzfBidbQXZs12Rc1wECgYEA1OvJ0Fp+C10BxK2rfRLVgn8xQ9RaZlIRV6y1Ue19oyM8YFlC9GnYGWGSn1rypwZ6/oTpKXjMuNMWkE2msqRk/fExifoWUQyB8HhzP39b2kpryt27FlG5JuM5/B/tT1BPoNPKYeouoSVh9rgItIICa0y1Gchns1FD56hXVrmatukCgYEAzTSakkly0ZdIfZ7ZX2AqKCtg1mILQ6dyIims4VGXeZyzfKWV5Bl/4OHpsWwnN7FEy1FraYJ4WhVydgGRxEiQFbBMPkfc4eOueV03hw9Szhel+YdxDpTqPq5un7UzYY1FupAw5pS7u2lGzp2bEUORBh/vQfuf7M7YNca5xhqDsGkCgYBJyc0O381+sqTCPE2J8tT7fIjeMOGDRD2uXLQZyGwZ9UQfP8/sVCIH6cCeaS5eo+hL/FOxg6OvCbhwGfkDP+Wf+85nOrwxKlx9scB+6Ow0IkZo756+hWPdDjIyJf5f1j1CRyOD+1xdjE7+6ZhathOQi+zXGpSVmDwoNDbQX1I2wQKBgBMJjk2EAuLu5grBceknQsH3RESfU+wy3KPOufstVqAxqXUm54EB3JtAWi3bmsfP6lHye8SOFhxFYRkRjDRphvR8JpaglB1gwg8AVuZwxX3ZM8yyhAqWRiUKibjHVrz2HkHwnpjFs6TvX2JLvNcdLZcj305/yZZumiBjD1kRnKYBAoGAIBEgy6YmmYylOOZQsWEi5ydAax+sUKe7n/xOfBLB9flY9UiAow/1r3ZxgeiFSbTwQqQ4gPBt0KAtXiJfnVK0btf4zvVjANgmaPSbqsTGk4vZrociebgf0/GxCN7vvq+bUbWvoWreacpfgdWV60n4ZFquqMoxIvOVbSbbKSb7/cI=')
INSERT INTO LOCAL_MEMBERS VALUES(393217,327681)
INSERT INTO LOCAL_MEMBERS VALUES(393217,327682)
INSERT INTO CONTENT VALUES(425985,'USERINFO',NULL,1,NULL,'2008-01-15 15:48:30.989000000',NULL,'2008-01-15 15:48:30.989000000','',NULL,'current',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin')
INSERT INTO BANDANA VALUES(1,'_GLOBAL','atlassian.confluence.settings','<settings>\u000a  <allowCamelCase>false</allowCamelCase>\u000a  <allowTrackbacks>false</allowTrackbacks>\u000a  <allowThreadedComments>true</allowThreadedComments>\u000a  <viewSpaceGoesToSpaceSummary>false</viewSpaceGoesToSpaceSummary>\u000a  <externalUserManagement>false</externalUserManagement>\u000a  <denyPublicSignup>false</denyPublicSignup>\u000a  <emailAdminMessageOff>false</emailAdminMessageOff>\u000a  <almostSupportPeriodEndMessageOff>false</almostSupportPeriodEndMessageOff>\u000a  <supportPeriodEndMessageOff>false</supportPeriodEndMessageOff>\u000a  <baseUrlAdminMessageOff>false</baseUrlAdminMessageOff>\u000a  <allowRemoteApi>true</allowRemoteApi>\u000a  <allowRemoteApiAnonymous>false</allowRemoteApiAnonymous>\u000a  <gzippingResponse>false</gzippingResponse>\u000a  <disableLogo>false</disableLogo>\u000a  <sharedMode>false</sharedMode>\u000a  <captchaSettings>\u000a    <enableCaptcha>false</enableCaptcha>\u000a    <captchaGroups class="list"/>\u000a    <exclude>registered</exclude>\u000a  </captchaSettings>\u000a  <customHtmlSettings>\u000a    <beforeHeadEnd></beforeHeadEnd>\u000a    <afterBodyStart></afterBodyStart>\u000a    <beforeBodyEnd></beforeBodyEnd>\u000a  </customHtmlSettings>\u000a  <colourSchemesSettings>\u000a    <colourSchemeType>custom</colourSchemeType>\u000a  </colourSchemesSettings>\u000a  <attachmentMaxSize>10485760</attachmentMaxSize>\u000a  <draftSaveInterval>30000</draftSaveInterval>\u000a  <maxAttachmentsInUI>5</maxAttachmentsInUI>\u000a  <siteTitle>Confluence</siteTitle>\u000a  <emailAddressVisibility>email.address.public</emailAddressVisibility>\u000a  <defaultEncoding>UTF-8</defaultEncoding>\u000a  <maxThumbHeight>200</maxThumbHeight>\u000a  <maxThumbWidth>200</maxThumbWidth>\u000a  <backupAttachmentsDaily>true</backupAttachmentsDaily>\u000a  <nofollowExternalLinks>true</nofollowExternalLinks>\u000a  <indexingLanguage>english</indexingLanguage>\u000a  <globalDefaultLocale>en_GB</globalDefaultLocale>\u000a  <dailyBackupFilePrefix>daily-backup-</dailyBackupFilePrefix>\u000a  <dailyBackupDateFormatPattern>yyyy_MM_dd</dailyBackupDateFormatPattern>\u000a  <supportRequestEmail>confluence-autosupportrequests@atlassian.com</supportRequestEmail>\u000a  <enableWysiwyg>true</enableWysiwyg>\u000a  <useWysiwygByDefault>true</useWysiwygByDefault>\u000a  <numberOfBreadcrumbAncestors>1</numberOfBreadcrumbAncestors>\u000a  <defaultSpaceHomepageTitle>Home</defaultSpaceHomepageTitle>\u000a  <defaultSpaceHomepageContent>This is the home page for the {0} space.</defaultSpaceHomepageContent>\u000a  <defaultPersonalSpaceHomepageContent>This is the home page for the {0} space.</defaultPersonalSpaceHomepageContent>\u000a  <baseUrl>http://localhost:8083</baseUrl>\u000a  <attachmentDataStore>file.system.based.attachments.storage</attachmentDataStore>\u000a  <displayLinkIcons>false</displayLinkIcons>\u000a  <confluenceHttpParameters>\u000a    <connectionTimeout>10000</connectionTimeout>\u000a    <socketTimeout>10000</socketTimeout>\u000a    <enabled>true</enabled>\u000a  </confluenceHttpParameters>\u000a</settings>')
INSERT INTO BANDANA VALUES(294913,'_GLOBAL','atlassian.confluence.css.resource.counter','<int>1</int>')
INSERT INTO BANDANA VALUES(294914,'_GLOBAL','confluence.server.id','<string>AMDP-IFB2-3AFQ-2PJU</string>')
INSERT INTO CLUSTERSAFETY VALUES(262145,971145893)
INSERT INTO SPACEPERMISSIONS VALUES(360449,NULL,'USECONFLUENCE','confluence-users',NULL,NULL,'2008-01-15 15:48:30.472000000',NULL,'2008-01-15 15:48:30.472000000')
INSERT INTO SPACEPERMISSIONS VALUES(360450,NULL,'USECONFLUENCE','confluence-administrators',NULL,NULL,'2008-01-15 15:48:30.478000000',NULL,'2008-01-15 15:48:30.478000000')
INSERT INTO SPACEPERMISSIONS VALUES(360451,NULL,'PERSONALSPACE','confluence-users',NULL,NULL,'2008-01-15 15:48:30.479000000',NULL,'2008-01-15 15:48:30.479000000')
INSERT INTO SPACEPERMISSIONS VALUES(360452,NULL,'PERSONALSPACE','confluence-administrators',NULL,NULL,'2008-01-15 15:48:30.479000000',NULL,'2008-01-15 15:48:30.479000000')
INSERT INTO SPACEPERMISSIONS VALUES(360453,NULL,'ADMINISTRATECONFLUENCE','confluence-administrators',NULL,NULL,'2008-01-15 15:48:30.479000000',NULL,'2008-01-15 15:48:30.479000000')
INSERT INTO SPACEPERMISSIONS VALUES(360454,NULL,'SYSTEMADMINISTRATOR','confluence-administrators',NULL,NULL,'2008-01-15 15:48:30.479000000',NULL,'2008-01-15 15:48:30.479000000')
INSERT INTO SPACEPERMISSIONS VALUES(360455,NULL,'CREATESPACE','confluence-administrators',NULL,NULL,'2008-01-15 15:48:30.479000000',NULL,'2008-01-15 15:48:30.479000000')
INSERT INTO GROUPS VALUES(327681,'confluence-administrators')
INSERT INTO GROUPS VALUES(327682,'confluence-users')
INSERT INTO USERS VALUES(393217,'admin','x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==','','2008-01-15 15:48:30.983000000','admin')
INSERT INTO INDEXQUEUEENTRIES VALUES(458753,'2008-01-15 15:48:30.990000000',1,'com.atlassian.confluence.user.PersonalInformation-425985')
INSERT INTO INDEXQUEUEENTRIES VALUES(458754,'2008-01-15 15:49:42.346000000',25,'ds')
INSERT INTO HIBERNATE_UNIQUE_KEY VALUES(16)
