EXPORT:V10.02.01
ULPORTAL
RUSERS
2048
0
20
0
i Mon Aug 11 0:8:15 2008lportal.dmp d `$
#G###A# i d `$
#G###A# +00:00 BYTE UNUSED 2 INTERPRETED DISABLE:ALL
METRICSU
METRICSUpre-schema procedural objects and actions
PROCACTION
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'XE', inst_scn=>'1377707');
COMMIT; END;
METRICEU 11
METRICSUforeign function library names for user
METRICEU 11
METRICSUPUBLIC type synonyms
METRICEU 11
METRICSUprivate type synonyms
METRICEU 11
METRICSUobject type definitions for user
METRICEU 11
METRICSUpre-schema procedural objects and actions
METRICEU 11
METRICSUdatabase links
METRICEU 11
METRICSUsequence numbers
METRICEU 11
METRICSUcluster definitions
METRICEU 11
METRICSUXDB Schemas by user
METRICEU 11
TABLE "ACCOUNT_"
CREATE TABLE "ACCOUNT_" ("ACCOUNTID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTACCOUNTID" NUMBER(30, 0), "NAME" VARCHAR2(75), "LEGALNAME" VARCHAR2(75), "LEGALID" VARCHAR2(75), "LEGALTYPE" VARCHAR2(75), "SICCODE" VARCHAR2(75), "TICKERSYMBOL" VARCHAR2(75), "INDUSTRY" VARCHAR2(75), "TYPE_" VARCHAR2(75), "SIZE_" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "ACCOUNT_" ("ACCOUNTID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "PARENTACCOUNTID", "NAME", "LEGALNAME", "LEGALID", "LEGALTYPE", "SICCODE", "TICKERSYMBOL", "INDUSTRY", "TYPE_", "SIZE_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
K i K i K i K i K i K i K i K i K i K i xl 1 xl 1 Liferay
Liferay, Inc.
ALTER TABLE "ACCOUNT_" ADD PRIMARY KEY ("ACCOUNTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "ADDRESS"
CREATE TABLE "ADDRESS" ("ADDRESSID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "STREET1" VARCHAR2(75), "STREET2" VARCHAR2(75), "STREET3" VARCHAR2(75), "CITY" VARCHAR2(75), "ZIP" VARCHAR2(75), "REGIONID" NUMBER(30, 0), "COUNTRYID" NUMBER(30, 0), "TYPEID" NUMBER(30, 0), "MAILING" NUMBER(1, 0), "PRIMARY_" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "ADDRESS" ("ADDRESSID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "CLASSNAMEID", "CLASSPK", "STREET1", "STREET2", "STREET3", "CITY", "ZIP", "REGIONID", "COUNTRYID", "TYPEID", "MAILING", "PRIMARY_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
K i K i K i K i K i K i
CREATE INDEX "IX_93D5AD4E" ON "ADDRESS" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_ABD7DAC0" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_71CB1123" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_923BD178" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" , "MAILING" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_9226DBB4" ON "ADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" , "PRIMARY_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_5BC8B0D4" ON "ADDRESS" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "ADDRESS" ADD PRIMARY KEY ("ADDRESSID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "ANNOUNCEMENTSDELIVERY"
CREATE TABLE "ANNOUNCEMENTSDELIVERY" ("DELIVERYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "TYPE_" VARCHAR2(75), "EMAIL" NUMBER(1, 0), "SMS" NUMBER(1, 0), "WEBSITE" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "ANNOUNCEMENTSDELIVERY" ("DELIVERYID", "COMPANYID", "USERID", "TYPE_", "EMAIL", "SMS", "WEBSITE") VALUES (:1, :2, :3, :4, :5, :6, :7)
K i
CREATE INDEX "IX_6EDB9600" ON "ANNOUNCEMENTSDELIVERY" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_BA4413D5" ON "ANNOUNCEMENTSDELIVERY" ("USERID" , "TYPE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "ANNOUNCEMENTSDELIVERY" ADD PRIMARY KEY ("DELIVERYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "ANNOUNCEMENTSENTRY"
CREATE TABLE "ANNOUNCEMENTSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "TITLE" VARCHAR2(75), "CONTENT" VARCHAR2(4000), "URL" VARCHAR2(4000), "TYPE_" VARCHAR2(75), "DISPLAYDATE" TIMESTAMP (6), "EXPIRATIONDATE" TIMESTAMP (6), "PRIORITY" NUMBER(30, 0), "ALERT" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "ANNOUNCEMENTSENTRY" ("UUID_", "ENTRYID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "CLASSNAMEID", "CLASSPK", "TITLE", "CONTENT", "URL", "TYPE_", "DISPLAYDATE", "EXPIRATIONDATE", "PRIORITY", "ALERT") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
K i K i K i i i K i
CREATE INDEX "IX_A6EF0B81" ON "ANNOUNCEMENTSENTRY" ("CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_14F06A6B" ON "ANNOUNCEMENTSENTRY" ("CLASSNAMEID" , "CLASSPK" , "ALERT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D49C2E66" ON "ANNOUNCEMENTSENTRY" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1AFBDE08" ON "ANNOUNCEMENTSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "ANNOUNCEMENTSENTRY" ADD PRIMARY KEY ("ENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "ANNOUNCEMENTSFLAG"
CREATE TABLE "ANNOUNCEMENTSFLAG" ("FLAGID" NUMBER(30, 0) NOT NULL ENABLE, "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "ENTRYID" NUMBER(30, 0), "VALUE" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "ANNOUNCEMENTSFLAG" ("FLAGID", "USERID", "CREATEDATE", "ENTRYID", "VALUE") VALUES (:1, :2, :3, :4, :5)
CREATE INDEX "IX_9C7EB9F" ON "ANNOUNCEMENTSFLAG" ("ENTRYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_4539A99C" ON "ANNOUNCEMENTSFLAG" ("USERID" , "ENTRYID" , "VALUE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "ANNOUNCEMENTSFLAG" ADD PRIMARY KEY ("FLAGID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "BLOGSCATEGORY"
CREATE TABLE "BLOGSCATEGORY" ("CATEGORYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTCATEGORYID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "BLOGSCATEGORY" ("CATEGORYID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "PARENTCATEGORYID", "NAME", "DESCRIPTION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
K i K i i
ALTER TABLE "BLOGSCATEGORY" ADD PRIMARY KEY ("CATEGORYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "BLOGSENTRY"
CREATE TABLE "BLOGSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "TITLE" VARCHAR2(150), "URLTITLE" VARCHAR2(150), "CONTENT" CLOB, "DISPLAYDATE" TIMESTAMP (6), "DRAFT" NUMBER(1, 0), "ALLOWTRACKBACKS" NUMBER(1, 0), "TRACKBACKS" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("TRACKBACKS") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "BLOGSENTRY" ("UUID_", "ENTRYID", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "TITLE", "URLTITLE", "CONTENT", "DISPLAYDATE", "DRAFT", "ALLOWTRACKBACKS", "TRACKBACKS") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
K i K i i i p i p i CONTENT
TRACKBACKS
CREATE INDEX "IX_72EF6041" ON "BLOGSENTRY" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_3D3D30B0" ON "BLOGSENTRY" ("COMPANYID" , "DRAFT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_81A50303" ON "BLOGSENTRY" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_5FF14FAE" ON "BLOGSENTRY" ("GROUPID" , "DRAFT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_DB780A20" ON "BLOGSENTRY" ("GROUPID" , "URLTITLE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_C07CA83D" ON "BLOGSENTRY" ("GROUPID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_BC2A3534" ON "BLOGSENTRY" ("GROUPID" , "USERID" , "DRAFT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_69157A4D" ON "BLOGSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1B1040FD" ON "BLOGSENTRY" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "BLOGSENTRY" ADD PRIMARY KEY ("ENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "BLOGSSTATSUSER"
CREATE TABLE "BLOGSSTATSUSER" ("STATSUSERID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "ENTRYCOUNT" NUMBER(30, 0), "LASTPOSTDATE" TIMESTAMP (6), "RATINGSTOTALENTRIES" NUMBER(30, 0), "RATINGSTOTALSCORE" NUMBER(30, 20), "RATINGSAVERAGESCORE" NUMBER(30, 20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "BLOGSSTATSUSER" ("STATSUSERID", "GROUPID", "COMPANYID", "USERID", "ENTRYCOUNT", "LASTPOSTDATE", "RATINGSTOTALENTRIES", "RATINGSTOTALSCORE", "RATINGSAVERAGESCORE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
CREATE INDEX "IX_90CDA39A" ON "BLOGSSTATSUSER" ("COMPANYID" , "ENTRYCOUNT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_43840EEB" ON "BLOGSSTATSUSER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_28C78D5C" ON "BLOGSSTATSUSER" ("GROUPID" , "ENTRYCOUNT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_82254C25" ON "BLOGSSTATSUSER" ("GROUPID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_BB51F1D9" ON "BLOGSSTATSUSER" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "BLOGSSTATSUSER" ADD PRIMARY KEY ("STATSUSERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "BOOKMARKSENTRY"
CREATE TABLE "BOOKMARKSENTRY" ("UUID_" VARCHAR2(75), "ENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(300), "URL" VARCHAR2(4000), "COMMENTS" VARCHAR2(4000), "VISITS" NUMBER(30, 0), "PRIORITY" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "BOOKMARKSENTRY" ("UUID_", "ENTRYID", "COMPANYID", "USERID", "CREATEDATE", "MODIFIEDDATE", "FOLDERID", "NAME", "URL", "COMMENTS", "VISITS", "PRIORITY") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
K i ,i i i
CREATE INDEX "IX_443BDC38" ON "BOOKMARKSENTRY" ("FOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_B670BA39" ON "BOOKMARKSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "BOOKMARKSENTRY" ADD PRIMARY KEY ("ENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "BOOKMARKSFOLDER"
CREATE TABLE "BOOKMARKSFOLDER" ("UUID_" VARCHAR2(75), "FOLDERID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTFOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "BOOKMARKSFOLDER" ("UUID_", "FOLDERID", "GROUPID", "COMPANYID", "USERID", "CREATEDATE", "MODIFIEDDATE", "PARENTFOLDERID", "NAME", "DESCRIPTION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
K i K i i
CREATE INDEX "IX_2ABA25D7" ON "BOOKMARKSFOLDER" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_7F703619" ON "BOOKMARKSFOLDER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_967799C0" ON "BOOKMARKSFOLDER" ("GROUPID" , "PARENTFOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_451E7AE3" ON "BOOKMARKSFOLDER" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_DC2F8927" ON "BOOKMARKSFOLDER" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "BOOKMARKSFOLDER" ADD PRIMARY KEY ("FOLDERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "CALEVENT"
CREATE TABLE "CALEVENT" ("UUID_" VARCHAR2(75), "EVENTID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "TITLE" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "STARTDATE" TIMESTAMP (6), "ENDDATE" TIMESTAMP (6), "DURATIONHOUR" NUMBER(30, 0), "DURATIONMINUTE" NUMBER(30, 0), "ALLDAY" NUMBER(1, 0), "TIMEZONESENSITIVE" NUMBER(1, 0), "TYPE_" VARCHAR2(75), "REPEATING" NUMBER(1, 0), "RECURRENCE" CLOB, "REMINDBY" VARCHAR2(75), "FIRSTREMINDER" NUMBER(30, 0), "SECONDREMINDER" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("RECURRENCE") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "CALEVENT" ("UUID_", "EVENTID", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "TITLE", "DESCRIPTION", "STARTDATE", "ENDDATE", "DURATIONHOUR", "DURATIONMINUTE", "ALLDAY", "TIMEZONESENSITIVE", "TYPE_", "REPEATING", "RECURRENCE", "REMINDBY", "FIRSTREMINDER", "SECONDREMINDER") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
K i K i K i i K i p i K i
RECURRENCE
CREATE INDEX "IX_12EE4898" ON "CALEVENT" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_4FDDD2BF" ON "CALEVENT" ("GROUPID" , "REPEATING" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_FCD7C63D" ON "CALEVENT" ("GROUPID" , "TYPE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_C1AD2122" ON "CALEVENT" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_5CCE79C8" ON "CALEVENT" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "CALEVENT" ADD PRIMARY KEY ("EVENTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "CLASSNAME_"
CREATE TABLE "CLASSNAME_" ("CLASSNAMEID" NUMBER(30, 0) NOT NULL ENABLE, "VALUE" VARCHAR2(200)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "CLASSNAME_" ("CLASSNAMEID", "VALUE") VALUES (:1, :2)
i % com.liferay.portal.model.Organization
com.liferay.portal.model.User
CREATE INDEX "IX_B27A301F" ON "CLASSNAME_" ("VALUE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "CLASSNAME_"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_B27A301F"',NULL,NULL,NULL,2,1,2,1,1,1,0,0); END;
ALTER TABLE "CLASSNAME_" ADD PRIMARY KEY ("CLASSNAMEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "COMPANY"
CREATE TABLE "COMPANY" ("COMPANYID" NUMBER(30, 0) NOT NULL ENABLE, "ACCOUNTID" NUMBER(30, 0), "WEBID" VARCHAR2(75), "KEY_" CLOB, "VIRTUALHOST" VARCHAR2(75), "MX" VARCHAR2(75), "LOGOID" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("KEY_") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "COMPANY" ("COMPANYID", "ACCOUNTID", "WEBID", "KEY_", "VIRTUALHOST", "MX", "LOGOID") VALUES (:1, :2, :3, :4, :5, :6, :7)
K i p i K i K i KEY_ liferay.com localhost liferay.com
CREATE INDEX "IX_38EFE3FD" ON "COMPANY" ("LOGOID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_12566EC2" ON "COMPANY" ("MX" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COMPANY"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_12566EC2"',NULL,NULL,NULL,1,1,1,1,1,1,0,0); END;
CREATE INDEX "IX_975996C0" ON "COMPANY" ("VIRTUALHOST" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COMPANY"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_975996C0"',NULL,NULL,NULL,1,1,1,1,1,1,0,0); END;
CREATE INDEX "IX_EC00543C" ON "COMPANY" ("WEBID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COMPANY"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_EC00543C"',NULL,NULL,NULL,1,1,1,1,1,1,0,0); END;
ALTER TABLE "COMPANY" ADD PRIMARY KEY ("COMPANYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "CONTACT_"
CREATE TABLE "CONTACT_" ("CONTACTID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "ACCOUNTID" NUMBER(30, 0), "PARENTCONTACTID" NUMBER(30, 0), "FIRSTNAME" VARCHAR2(75), "MIDDLENAME" VARCHAR2(75), "LASTNAME" VARCHAR2(75), "PREFIXID" NUMBER(30, 0), "SUFFIXID" NUMBER(30, 0), "MALE" NUMBER(1, 0), "BIRTHDAY" TIMESTAMP (6), "SMSSN" VARCHAR2(75), "AIMSN" VARCHAR2(75), "FACEBOOKSN" VARCHAR2(75), "ICQSN" VARCHAR2(75), "JABBERSN" VARCHAR2(75), "MSNSN" VARCHAR2(75), "MYSPACESN" VARCHAR2(75), "SKYPESN" VARCHAR2(75), "TWITTERSN" VARCHAR2(75), "YMSN" VARCHAR2(75), "EMPLOYEESTATUSID" VARCHAR2(75), "EMPLOYEENUMBER" VARCHAR2(75), "JOBTITLE" VARCHAR2(100), "JOBCLASS" VARCHAR2(75), "HOURSOFOPERATION" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "CONTACT_" ("CONTACTID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "ACCOUNTID", "PARENTCONTACTID", "FIRSTNAME", "MIDDLENAME", "LASTNAME", "PREFIXID", "SUFFIXID", "MALE", "BIRTHDAY", "SMSSN", "AIMSN", "FACEBOOKSN", "ICQSN", "JABBERSN", "MSNSN", "MYSPACESN", "SKYPESN", "TWITTERSN", "YMSN", "EMPLOYEESTATUSID", "EMPLOYEENUMBER", "JOBTITLE", "JOBCLASS", "HOURSOFOPERATION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30)
K i K i K i K i K i K i K i K i K i K i K i K i K i K i K i K i d i K i K i xl 1 xl 1 w
Joe Bloggs xl 1 xl 1 Joe Bloggs w Z
Joe Bloggs xl 1 xl 1 Test LAX 1 w _
Joe Bloggs xl 1 xl 1 Test LAX 2 w d
Joe Bloggs xl 1 xl 1 Test LAX 3 w
Joe Bloggs xl 1 xl 1 Test LAX 4 w
Joe Bloggs xl 1 xl 1 Test LAX 5 w
Joe Bloggs xl 1 xl 1 Test LAX 6 w
Joe Bloggs xl 1 xl 1 Test LAX 7 w
Joe Bloggs xl 1 xl 1 Test LAX 8 w
Joe Bloggs xl 1 xl 1 Test LAX 9 w #
Joe Bloggs xl 1 xl 1 Test LAX 10 w (
Joe Bloggs xl 1 xl 1 Test LAX 11 w -
Joe Bloggs xl 1 xl 1 Test LAX 12 w 2
Joe Bloggs xl 1 xl 1 Test LAX 13 w 7
Joe Bloggs xl 1 xl 1 Test LAX 14 w <
Joe Bloggs xl 1 xl 1 Test LAX 15 w A
Joe Bloggs xl 1 xl 1 Test LAX 16 w F
Joe Bloggs xl 1 xl 1 Test LAX 17 w K
Joe Bloggs xl 1 xl 1 Test LAX 18 w P
Joe Bloggs xl 1 xl 1 Test LAX 19 w U
Joe Bloggs xl 1 xl 1 Test LAX 20 w Z
Joe Bloggs xl 1 xl 1 Test LAX 21 w _
Joe Bloggs xl 1 xl 1 Test LAX 22 w d
Joe Bloggs xl 1 xl 1 Test LAX 23 w
Joe Bloggs xl 1 xl 1 Test LAX 24 w
Joe Bloggs xl 1 xl 1 Test LAX 25 w
Joe Bloggs xl 1 xl 1 Test LAX 26 w
Joe Bloggs xl 1 xl 1 Test LAX 27 w
Joe Bloggs xl 1 xl 1 Test LAX 28 w
Joe Bloggs xl 1 xl 1 Test LAX 29 w #
Joe Bloggs xl 1 xl 1 Test LAX 30 w (
Joe Bloggs xl 1 xl 1 Test LAX 31 w -
Joe Bloggs xl 1 xl 1 Test LAX 32 w 2
Joe Bloggs xl 1 xl 1 Test LAX 33 w 7
Joe Bloggs xl 1 xl 1 Test LAX 34 w <
Joe Bloggs xl 1 xl 1 Test LAX 35 w A
Joe Bloggs xl 1 xl 1 Test LAX 36 w F
Joe Bloggs xl 1 xl 1 Test LAX 37 w K
Joe Bloggs xl 1 xl 1 Test LAX 38 w P
Joe Bloggs xl 2 xl 2 Test LAX 39 w U
Joe Bloggs xl 2 xl 2 Test LAX 40 w Z
Joe Bloggs xl 2 xl 2 Test LAX 41 w _
Joe Bloggs xl 2 xl 2 Test LAX 42 w d
Joe Bloggs xl 2 xl 2 Test LAX 43 w
Joe Bloggs xl 2 xl 2 Test LAX 44 w
Joe Bloggs xl 2 xl 2 Test LAX 45 w
Joe Bloggs xl 2 xl 2 Test LAX 46 w
Joe Bloggs xl 2 xl 2 Test LAX 47 w
Joe Bloggs xl 2 xl 2 Test LAX 48 w
Joe Bloggs xl 2 xl 2 Test LAX 49 w #
Joe Bloggs xl 2 xl 2 Test LAX 50 w (
Joe Bloggs xl 2 xl 2 Test LAX 51 w -
Joe Bloggs xl 2 xl 2 Test LAX 52 w 2
Joe Bloggs xl 2 xl 2 Test LAX 53 w 7
Joe Bloggs xl 2 xl 2 Test LAX 54 w <
Joe Bloggs xl 2 xl 2 Test LAX 55 w A
Joe Bloggs xl 2 xl 2 Test LAX 56 w F
Joe Bloggs xl 2 xl 2 Test LAX 57 w K
Joe Bloggs xl 2 xl 2 Test LAX 58 w P
Joe Bloggs xl 2 xl 2 Test LAX 59 w U
Joe Bloggs xl 2 xl 2 Test LAX 60 w Z
Joe Bloggs xl 2 xl 2 Test LAX 61 w _
Joe Bloggs xl 2 xl 2 Test LAX 62 w d
Joe Bloggs xl 2 xl 2 Test LAX 63 w
Joe Bloggs xl 2 xl 2 Test LAX 64 w
Joe Bloggs xl 2 xl 2 Test LAX 65 w
Joe Bloggs xl 2 xl 2 Test LAX 66 w
Joe Bloggs xl 3 xl 3 Test LAX 67 w
Joe Bloggs xl 3 xl 3 Test LAX 68 w
Joe Bloggs xl 3 xl 3 Test LAX 69 w #
Joe Bloggs xl 3 xl 3 Test LAX 70 w (
Joe Bloggs xl 3 xl 3 Test LAX 71 w -
Joe Bloggs xl 3 xl 3 Test LAX 72 w 2
Joe Bloggs xl 3 xl 3 Test LAX 73 w 7
Joe Bloggs xl 3 xl 3 Test LAX 74 w <
Joe Bloggs xl 3 xl 3 Test LAX 75 w A
Joe Bloggs xl 3 xl 3 Test LAX 76 w F
Joe Bloggs xl 3 xl 3 Test LAX 77 w K
Joe Bloggs xl 3 xl 3 Test LAX 78 w P
Joe Bloggs xl 3 xl 3 Test LAX 79 w U
Joe Bloggs xl 3 xl 3 Test LAX 80 w Z
Joe Bloggs xl 3 xl 3 Test LAX 81 w _
Joe Bloggs xl 4 xl 4 Test LAX 82 w d
Joe Bloggs xl 4 xl 4 Test LAX 83 w
Joe Bloggs xl 4 xl 4 Test LAX 84 w
Joe Bloggs xl 4 xl 4 Test LAX 85 w
Joe Bloggs xl 4 xl 4 Test LAX 86 w
Joe Bloggs xl 4 xl 4 Test LAX 87 w
Joe Bloggs xl 4 xl 4 Test LAX 88 w
Joe Bloggs xl 4 xl 4 Test LAX 89 w #
Joe Bloggs xl 4 xl 4 Test LAX 90 w (
Joe Bloggs xl 4 xl 4 Test LAX 91 w -
Joe Bloggs xl 5 xl 5 Test LAX 92 w 2
Joe Bloggs xl 5 xl 5 Test LAX 93 w 7
Joe Bloggs xl 5 xl 5 Test LAX 94 w <
Joe Bloggs xl 5 xl 5 Test LAX 95 w A
Joe Bloggs xl 5 xl 5 Test LAX 96 w F
Joe Bloggs xl 6 xl 6 Test LAX 97 w K
Joe Bloggs xl 6 xl 6 Test LAX 98 w P
Joe Bloggs xl 6 xl 6 Test LAX 99 w U
Joe Bloggs xl 6 xl 6 Test LAX 100 w Z
Joe Bloggs xl 6 xl 6 Test SFO 1 w _
Joe Bloggs xl 6 xl 6 Test SFO 2 w d
Joe Bloggs xl 6 xl 6 Test SFO 3 w
Joe Bloggs xl 6 xl 6 Test SFO 4 w
Joe Bloggs xl 6 xl 6 Test SFO 5 w
Joe Bloggs xl 6 xl 6 Test SFO 6 w
Joe Bloggs xl 6 xl 6 Test SFO 7 w
Joe Bloggs xl 6 xl 6 Test SFO 8 w
Joe Bloggs xl 6 xl 6 Test SFO 9 w #
Joe Bloggs xl 7 xl 7 Test SFO 10 w (
Joe Bloggs xl 7 xl 7 Test ORD 1 w -
Joe Bloggs xl 7 xl 7 Test ORD 2 w 2
Joe Bloggs xl 8 xl 8 Test ORD 3 w 7
Joe Bloggs xl 8 xl 8 Test ORD 4 w <
Joe Bloggs xl 8 xl 8 Test ORD 5 w A
Joe Bloggs xl 8 xl 8 Test ORD 6 w F
Joe Bloggs xl 9 xl 9 Test ORD 7 w K
Joe Bloggs xl 9 xl 9 Test ORD 8 w P
Joe Bloggs xl 9 xl 9 Test ORD 9 w U
Joe Bloggs xl 9 xl 9 Test ORD 10 w Z
Joe Bloggs xl 9 xl 9 Test NYC 1 w _
Joe Bloggs xl 9 xl 9 Test NYC 2 w d
Joe Bloggs xl 9 xl 9 Test NYC 3 w
Joe Bloggs xl 9 xl 9 Test NYC 4 w
Joe Bloggs xl 9 xl 9 Test NYC 5 w
Joe Bloggs xl 9 xl 9 Test NYC 6 w
Joe Bloggs xl : xl : Test NYC 7 w
Joe Bloggs xl : xl : Test NYC 8 w
Joe Bloggs xl : xl : Test NYC 9 w #
Joe Bloggs xl : xl : Test NYC 10 w (
Joe Bloggs xl ; xl ; Test GRU 1 w -
Joe Bloggs xl ; xl ; Test GRU 2 w 2
Joe Bloggs xl ; xl ; Test GRU 3 w 7
Joe Bloggs xl ; xl ; Test GRU 4 w <
Joe Bloggs xl ; xl ; Test GRU 5 w A
Joe Bloggs xl ; xl ; Test GRU 6 w F
Joe Bloggs xl ; xl ; Test GRU 7 w K
Joe Bloggs xl ; xl ; Test GRU 8 w P
Joe Bloggs xl ; xl ; Test GRU 9 w U
Joe Bloggs xl ; xl ; Test GRU 10 w Z
Joe Bloggs xl ; xl ; Test FRA 1 w _
Joe Bloggs xl ; xl ; Test FRA 2 w d
Joe Bloggs xl ; xl ; Test FRA 3 w
Joe Bloggs xl ; xl ; Test FRA 4 w
Joe Bloggs xl ; xl ; Test FRA 5 w
Joe Bloggs xl < xl < Test FRA 6 w
Joe Bloggs xl < xl < Test FRA 7 w
Joe Bloggs xl < xl < Test FRA 8 w
Joe Bloggs xl < xl < Test FRA 9 w #
Joe Bloggs xl < xl < Test FRA 10 w (
Joe Bloggs xl < xl < Test MAD 1 w -
Joe Bloggs xl < xl < Test MAD 2 w 2
Joe Bloggs xl < xl < Test MAD 3 w 7
Joe Bloggs xl < xl < Test MAD 4 w <
Joe Bloggs xl < xl < Test MAD 5 w A
Joe Bloggs xl < xl < Test MAD 6 w F
Joe Bloggs xl < xl < Test MAD 7 w K
Joe Bloggs xl < xl < Test MAD 8 w P
Joe Bloggs xl < xl < Test MAD 9 w U
Joe Bloggs xl < xl < Test MAD 10 w Z
Joe Bloggs xl < xl < Test DLC 1 w _
Joe Bloggs xl < xl < Test DLC 2 w d
Joe Bloggs xl < xl < Test DLC 3 w
Joe Bloggs xl < xl < Test DLC 4 w
Joe Bloggs xl < xl < Test DLC 5 w
Joe Bloggs xl < xl < Test DLC 6 w
Joe Bloggs xl < xl < Test DLC 7 w
Joe Bloggs xl < xl < Test DLC 8 w
Joe Bloggs xl < xl < Test DLC 9 w
#
Joe Bloggs xl < xl < Test DLC 10 w
(
Joe Bloggs xl < xl < Test HKG 1 w
-
Joe Bloggs xl < xl < Test HKG 2 w
2
Joe Bloggs xl xl Test HKG 3 w
7
Joe Bloggs xl xl Test HKG 4 w
<
Joe Bloggs xl xl Test HKG 5 w
A
Joe Bloggs xl xl Test HKG 6 w
F
Joe Bloggs xl xl Test HKG 7 w
K
Joe Bloggs xl xl Test HKG 8 w
P
Joe Bloggs xl xl Test HKG 9 w
U
Joe Bloggs xl xl Test HKG 10 w
Z
Joe Bloggs xl xl Test KUL 1 w
_
Joe Bloggs xl xl Test KUL 2 w
d
Joe Bloggs xl xl Test KUL 3 w
Joe Bloggs xl xl Test KUL 4 w
Joe Bloggs xl xl Test KUL 5 w
Joe Bloggs xl xl Test KUL 6 w
Joe Bloggs xl xl Test KUL 7 w
Joe Bloggs xl xl Test KUL 8 w
Joe Bloggs xl xl Test KUL 9 w #
Joe Bloggs xl xl Test KUL 10 w
CREATE INDEX "IX_66D496A3" ON "CONTACT_" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "CONTACT_"
^ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_66D496A3"',NULL,NULL,NULL,192,1,1,1,2,2,0,0); END;
ALTER TABLE "CONTACT_" ADD PRIMARY KEY ("CONTACTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "COUNTER"
CREATE TABLE "COUNTER" ("NAME" VARCHAR2(75) NOT NULL ENABLE, "CURRENTID" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "COUNTER" ("NAME", "CURRENTID") VALUES (:1, :2)
K i ! com.liferay.counter.model.Counter
ALTER TABLE "COUNTER" ADD PRIMARY KEY ("NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "COUNTRY"
CREATE TABLE "COUNTRY" ("COUNTRYID" NUMBER(30, 0) NOT NULL ENABLE, "NAME" VARCHAR2(75), "A2" VARCHAR2(75), "A3" VARCHAR2(75), "NUMBER_" VARCHAR2(75), "IDD_" VARCHAR2(75), "ACTIVE_" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "COUNTRY" ("COUNTRYID", "NAME", "A2", "A3", "NUMBER_", "IDD_", "ACTIVE_") VALUES (:1, :2, :3, :4, :5, :6, :7)
K i K i K i K i K i Canada CA CAN 124 001 China CN CHN 156 086 France FR FRA 250 033 Germany DE DEU 276 049 Hong Kong HK HKG 344 852 Hungary HU HUN 348 036 Israel IL ISR 376 972 Italy IT ITA 380 039
Japan JP JPN 392 081 South Korea KR KOR 410 082 Netherlands NL NLD 528 031
Portugal PT PRT 620 351 Russia RU RUS 643 007 Singapore SG SGP 702 065 Spain ES ESP 724 034 Turkey TR TUR 792 090 Vietnam VM VNM 704 084 United Kingdom GB GBR 826 044
United States US USA 840 001 Afghanistan AF AFG 4 093 Albania AL ALB 8 355 Algeria DZ DZA 12 213 American Samoa AS ASM 16 684 Andorra AD AND 20 376 Angola AO AGO 24 244 Anguilla AI AIA 660 264
Antarctica AQ ATA 10 672 Antigua AG ATG 28 268 Argentina AR ARG 32 054 Armenia AM ARM 51 374 Aruba AW ABW 533 297 ! Australia AU AUS 36 061 " Austria AT AUT 40 043 #
Azerbaijan AZ AZE 31 994 $ Bahamas BS BHS 44 242 % Bahrain BH BHR 48 973 &
Bangladesh BD BGD 50 880 ' Barbados BB BRB 52 246 ( Belarus BY BLR 112 375 ) Belgium BE BEL 56 032 * Belize BZ BLZ 84 501 + Benin BJ BEN 204 229 , Bermuda BM BMU 60 441 - Bhutan BT BTN 64 975 . Bolivia BO BOL 68 591 / Bosnia-Herzegovina BA BIH 70 387 0 Botswana BW BWA 72 267 1 Brazil BR BRA 76 055 2 British Virgin Islands VG VGB 92 284 3 Brunei BN BRN 96 673 4 Bulgaria BG BGR 100 359 5 Burkina Faso BF BFA 854 226 6 Burma (Myanmar) MM MMR 104 095 7 Burundi BI BDI 108 257 8 Cambodia KH KHM 116 855 9 Cameroon CM CMR 120 237 : Cape Verde Island CV CPV 132 238 ; Cayman Islands KY CYM 136 345 < Central African Republic CF CAF 140 236 = Chad TD TCD 148 235 > Chile CL CHL 152 056 ? Christmas Island CX CXR 162 061 @
Cocos Islands CC CCK 166 061 A Colombia CO COL 170 057 B Comoros KM COM 174 269 C Republic of Congo CD COD 180 242 D Democratic Republic of Congo CG COG 178 243 E Cook Islands CK COK 184 682 F
Costa Rica CR CRI 188 506 G Croatia HR HRV 191 385 H Cuba CU CUB 192 053 I Cyprus CY CYP 196 357 J Czech Republic CZ CZE 203 420 K Denmark DK DNK 208 045 L Djibouti DJ DJI 262 253 M Dominica DM DMA 212 767 N Dominican Republic DO DOM 214 809 O Ecuador EC ECU 218 593 P Egypt EG EGY 818 020 Q El Salvador SV SLV 222 503 R Equatorial Guinea GQ GNQ 226 240 S Eritrea ER ERI 232 291 T Estonia EE EST 233 372 U Ethiopia ET ETH 231 251 V Faeroe Islands FO FRO 234 298 W Falkland Islands FK FLK 238 500 X Fiji Islands FJ FJI 242 679 Y Finland FI FIN 246 358 Z
French Guiana GF GUF 254 594 [ French Polynesia PF PYF 258 689 \ Gabon GA GAB 266 241 ] Gambia GM GMB 270 220 ^ Georgia GE GEO 268 995 _ Ghana GH GHA 288 233 ` Gibraltar GI GIB 292 350 a Greece GR GRC 300 030 b Greenland GL GRL 304 299 c Grenada GD GRD 308 473 d
Guadeloupe GP GLP 312 590 Guam GU GUM 316 671 Guatemala GT GTM 320 502 Guinea GN GIN 324 224
Guinea-Bissau GW GNB 624 245 Guyana GY GUY 328 592 Haiti HT HTI 332 509 Honduras HN HND 340 504 Iceland IS ISL 352 354 India IN IND 356 091
Indonesia ID IDN 360 062 Iran IR IRN 364 098 Iraq IQ IRQ 368 964
Ireland IE IRL 372 353 Ivory Coast CI CIV 384 225 Jamaica JM JAM 388 876 Jordan JO JOR 400 962
Kazakhstan KZ KAZ 398 007 Kenya KE KEN 404 254 Kiribati KI KIR 408 686 Kuwait KW KWT 414 965 North Korea KP PRK 408 850
Kyrgyzstan KG KGZ 471 996 Laos LA LAO 418 856 Latvia LV LVA 428 371 Lebanon LB LBN 422 961 Lesotho LS LSO 426 266 Liberia LR LBR 430 231 Libya LY LBY 434 218
Liechtenstein LI LIE 438 423 Lithuania LT LTU 440 370
Luxembourg LU LUX 442 352 Macau MO MAC 446 853 ! Macedonia MK MKD 807 389 "
Madagascar MG MDG 450 261 # Malawi MW MWI 454 265 $ Malaysia MY MYS 458 060 % Maldives MV MDV 462 960 & Mali ML MLI 466 223 ' Malta MT MLT 470 356 ( Marshall Islands MH MHL 584 692 )
Martinique MQ MTQ 474 596 *
Mauritania MR MRT 478 222 + Mauritius MU MUS 480 230 , Mayotte Island YT MYT 175 269 - Mexico MX MEX 484 052 .
Micronesia FM FSM 583 691 / Moldova MD MDA 498 373 0 Monaco MC MCO 492 377 1 Mongolia MN MNG 496 976 2
Montenegro ME MNE 499 382 3
Montserrat MS MSR 500 664 4 Morocco MA MAR 504 212 5
Mozambique MZ MOZ 508 258 6 Namibia NA NAM 516 264 7 Nauru NR NRU 520 674 8 Nepal NP NPL 524 977 9 Netherlands Antilles AN ANT 530 599 :
New Caledonia NC NCL 540 687 ; New Zealand NZ NZL 554 064 < Nicaragua NI NIC 558 505 = Niger NE NER 562 227 > Nigeria NG NGA 566 234 ? Niue NU NIU 570 683 @ Norfolk Island NF NFK 574 672 A Norway NO NOR 578 047 B Oman OM OMN 512 968 C Pakistan PK PAK 586 092 D Palau PW PLW 585 680 E Palestine PS PSE 275 970 F Panama PA PAN 591 507 G Papua New Guinea PG PNG 598 675 H Paraguay PY PRY 600 595 I Peru PE PER 604 051 J Philippines PH PHL 608 063 K Poland PL POL 616 048 L Puerto Rico PR PRI 630 787 M Qatar QA QAT 634 974 N Reunion Island RE REU 638 262 O Romania RO ROU 642 040 P Rwanda RW RWA 646 250 Q
St. Helena SH SHN 654 290 R St. Kitts KN KNA 659 869 S St. Lucia LC LCA 662 758 T St. Pierre & Miquelon PM SPM 666 508 U St. Vincent VC VCT 670 784 V
San Marino SM SMR 674 378 W Sao Tome & Principe ST STP 678 239 X Saudi Arabia SA SAU 682 966 Y Senegal SN SEN 686 221 Z Serbia RS SRB 688 381 [
Seychelles SC SYC 690 248 \ Sierra Leone SL SLE 694 249 ] Slovakia SK SVK 703 421 ^ Slovenia SI SVN 705 386 _ Solomon Islands SB SLB 90 677 ` Somalia SO SOM 706 252 a South Africa ZA ZAF 710 027 b Sri Lanka LK LKA 144 094 c Sudan SD SDN 736 095 d Suriname SR SUR 740 597 Swaziland SZ SWZ 748 268 Sweden SE SWE 752 046 Switzerland CH CHE 756 041 Syria SY SYR 760 963 Taiwan TW TWN 158 886
Tajikistan TJ TJK 762 992 Tanzania TZ TZA 834 255 Thailand TH THA 764 066 Togo TG TGO 768 228
Tonga TO TON 776 676 Trinidad & Tobago TT TTO 780 868 Tunisia TN TUN 788 216
Turkmenistan TM TKM 795 993 Turks & Caicos TC TCA 796 649 Tuvalu TV TUV 798 688 Uganda UG UGA 800 256 Ukraine UA UKR 804 380 United Arab Emirates AE ARE 784 971 Uruguay UY URY 858 598
Uzbekistan UZ UZB 860 998 Vanuatu VU VUT 548 678 Vatican City VA VAT 336 039 Venezuela VE VEN 862 058 Wallis & Futuna WF WLF 876 681
Western Samoa EH ESH 732 685 Yemen YE YEM 887 967 Zambia ZM ZMB 894 260 Zimbabwe ZW ZWE 716 263
CREATE INDEX "IX_717B97E1" ON "COUNTRY" ("A2" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COUNTRY"
a BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_717B97E1"',NULL,NULL,NULL,227,1,227,1,1,24,0,0); END;
CREATE INDEX "IX_717B9BA2" ON "COUNTRY" ("A3" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COUNTRY"
a BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_717B9BA2"',NULL,NULL,NULL,227,1,227,1,1,22,0,0); END;
CREATE INDEX "IX_25D734CD" ON "COUNTRY" ("ACTIVE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COUNTRY"
^ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_25D734CD"',NULL,NULL,NULL,227,1,1,1,2,2,0,0); END;
CREATE INDEX "IX_19DA007B" ON "COUNTRY" ("NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "COUNTRY"
` BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_19DA007B"',NULL,NULL,NULL,227,1,227,1,1,8,0,0); END;
ALTER TABLE "COUNTRY" ADD PRIMARY KEY ("COUNTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "CYRUSUSER"
CREATE TABLE "CYRUSUSER" ("USERID" VARCHAR2(75) NOT NULL ENABLE, "PASSWORD_" VARCHAR2(75) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "CYRUSUSER" ("USERID", "PASSWORD_") VALUES (:1, :2)
K i K i
ALTER TABLE "CYRUSUSER" ADD PRIMARY KEY ("USERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "CYRUSVIRTUAL"
CREATE TABLE "CYRUSVIRTUAL" ("EMAILADDRESS" VARCHAR2(75) NOT NULL ENABLE, "USERID" VARCHAR2(75) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "CYRUSVIRTUAL" ("EMAILADDRESS", "USERID") VALUES (:1, :2)
K i K i
ALTER TABLE "CYRUSVIRTUAL" ADD PRIMARY KEY ("EMAILADDRESS") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "DLFILEENTRY"
CREATE TABLE "DLFILEENTRY" ("UUID_" VARCHAR2(75), "FILEENTRYID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "VERSIONUSERID" NUMBER(30, 0), "VERSIONUSERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(300), "TITLE" VARCHAR2(300), "DESCRIPTION" VARCHAR2(4000), "VERSION" NUMBER(30, 20), "SIZE_" NUMBER(30, 0), "READCOUNT" NUMBER(30, 0), "EXTRASETTINGS" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("EXTRASETTINGS") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "DLFILEENTRY" ("UUID_", "FILEENTRYID", "COMPANYID", "USERID", "USERNAME", "VERSIONUSERID", "VERSIONUSERNAME", "CREATEDATE", "MODIFIEDDATE", "FOLDERID", "NAME", "TITLE", "DESCRIPTION", "VERSION", "SIZE_", "READCOUNT", "EXTRASETTINGS") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
K i K i K i ,i ,i i p i
EXTRASETTINGS
CREATE INDEX "IX_4CB1B2B4" ON "DLFILEENTRY" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_24A846D1" ON "DLFILEENTRY" ("FOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_8F6C75D0" ON "DLFILEENTRY" ("FOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_A9951F17" ON "DLFILEENTRY" ("FOLDERID" , "TITLE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_64F0FE40" ON "DLFILEENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "DLFILEENTRY" ADD PRIMARY KEY ("FILEENTRYID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "DLFILERANK"
CREATE TABLE "DLFILERANK" ("FILERANKID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(300)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "DLFILERANK" ("FILERANKID", "COMPANYID", "USERID", "CREATEDATE", "FOLDERID", "NAME") VALUES (:1, :2, :3, :4, :5, :6)
,i
CREATE INDEX "IX_CE705D48" ON "DLFILERANK" ("COMPANYID" , "USERID" , "FOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_40B56512" ON "DLFILERANK" ("FOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_EED06670" ON "DLFILERANK" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "DLFILERANK" ADD PRIMARY KEY ("FILERANKID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "DLFILESHORTCUT"
CREATE TABLE "DLFILESHORTCUT" ("UUID_" VARCHAR2(75), "FILESHORTCUTID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "TOFOLDERID" NUMBER(30, 0), "TONAME" VARCHAR2(300)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "DLFILESHORTCUT" ("UUID_", "FILESHORTCUTID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "FOLDERID", "TOFOLDERID", "TONAME") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
K i K i ,i
CREATE INDEX "IX_E56EC6AD" ON "DLFILESHORTCUT" ("FOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_CA2708A2" ON "DLFILESHORTCUT" ("TOFOLDERID" , "TONAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_4831EBE4" ON "DLFILESHORTCUT" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "DLFILESHORTCUT" ADD PRIMARY KEY ("FILESHORTCUTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "DLFILEVERSION"
CREATE TABLE "DLFILEVERSION" ("FILEVERSIONID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(300), "VERSION" NUMBER(30, 20), "SIZE_" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "DLFILEVERSION" ("FILEVERSIONID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "FOLDERID", "NAME", "VERSION", "SIZE_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
K i ,i
CREATE INDEX "IX_9CD91DB6" ON "DLFILEVERSION" ("FOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_6C5E6512" ON "DLFILEVERSION" ("FOLDERID" , "NAME" , "VERSION" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "DLFILEVERSION" ADD PRIMARY KEY ("FILEVERSIONID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "DLFOLDER"
CREATE TABLE "DLFOLDER" ("UUID_" VARCHAR2(75), "FOLDERID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTFOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(100), "DESCRIPTION" VARCHAR2(4000), "LASTPOSTDATE" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "DLFOLDER" ("UUID_", "FOLDERID", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "PARENTFOLDERID", "NAME", "DESCRIPTION", "LASTPOSTDATE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
K i K i d i i
CREATE INDEX "IX_A74DB14C" ON "DLFOLDER" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_F2EA1ACE" ON "DLFOLDER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_49C37475" ON "DLFOLDER" ("GROUPID" , "PARENTFOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_902FD874" ON "DLFOLDER" ("GROUPID" , "PARENTFOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_51556082" ON "DLFOLDER" ("PARENTFOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_CBC408D8" ON "DLFOLDER" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_3CC1DED2" ON "DLFOLDER" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "DLFOLDER" ADD PRIMARY KEY ("FOLDERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "EMAILADDRESS"
CREATE TABLE "EMAILADDRESS" ("EMAILADDRESSID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "ADDRESS" VARCHAR2(75), "TYPEID" NUMBER(30, 0), "PRIMARY_" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "EMAILADDRESS" ("EMAILADDRESSID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "CLASSNAMEID", "CLASSPK", "ADDRESS", "TYPEID", "PRIMARY_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
K i K i
CREATE INDEX "IX_1BB072CA" ON "EMAILADDRESS" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_49D2DEC4" ON "EMAILADDRESS" ("COMPANYID" , "CLASSNAMEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_551A519F" ON "EMAILADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_2A2CB130" ON "EMAILADDRESS" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" , "PRIMARY_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_7B43CD8" ON "EMAILADDRESS" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "EMAILADDRESS" ADD PRIMARY KEY ("EMAILADDRESSID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "EXPANDOCOLUMN"
CREATE TABLE "EXPANDOCOLUMN" ("COLUMNID" NUMBER(30, 0) NOT NULL ENABLE, "TABLEID" NUMBER(30, 0), "NAME" VARCHAR2(75), "TYPE_" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "EXPANDOCOLUMN" ("COLUMNID", "TABLEID", "NAME", "TYPE_") VALUES (:1, :2, :3, :4)
K i
CREATE INDEX "IX_A8C0CBE8" ON "EXPANDOCOLUMN" ("TABLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_FEFC8DA7" ON "EXPANDOCOLUMN" ("TABLEID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "EXPANDOCOLUMN" ADD PRIMARY KEY ("COLUMNID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "EXPANDOROW"
CREATE TABLE "EXPANDOROW" ("ROWID_" NUMBER(30, 0) NOT NULL ENABLE, "TABLEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "EXPANDOROW" ("ROWID_", "TABLEID", "CLASSPK") VALUES (:1, :2, :3)
CREATE INDEX "IX_D3F5D7AE" ON "EXPANDOROW" ("TABLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_81EFBFF5" ON "EXPANDOROW" ("TABLEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "EXPANDOROW" ADD PRIMARY KEY ("ROWID_") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "EXPANDOTABLE"
CREATE TABLE "EXPANDOTABLE" ("TABLEID" NUMBER(30, 0) NOT NULL ENABLE, "CLASSNAMEID" NUMBER(30, 0), "NAME" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "EXPANDOTABLE" ("TABLEID", "CLASSNAMEID", "NAME") VALUES (:1, :2, :3)
K i
CREATE INDEX "IX_F0A86A4F" ON "EXPANDOTABLE" ("CLASSNAMEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_DED782CE" ON "EXPANDOTABLE" ("CLASSNAMEID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "EXPANDOTABLE" ADD PRIMARY KEY ("TABLEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "EXPANDOVALUE"
CREATE TABLE "EXPANDOVALUE" ("VALUEID" NUMBER(30, 0) NOT NULL ENABLE, "TABLEID" NUMBER(30, 0), "COLUMNID" NUMBER(30, 0), "ROWID_" NUMBER(30, 0), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "DATA_" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "EXPANDOVALUE" ("VALUEID", "TABLEID", "COLUMNID", "ROWID_", "CLASSNAMEID", "CLASSPK", "DATA_") VALUES (:1, :2, :3, :4, :5, :6, :7)
i
CREATE INDEX "IX_B29FEF17" ON "EXPANDOVALUE" ("CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_F7DD0987" ON "EXPANDOVALUE" ("COLUMNID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_9DDD21E5" ON "EXPANDOVALUE" ("COLUMNID" , "ROWID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_9112A7A0" ON "EXPANDOVALUE" ("ROWID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_F0566A77" ON "EXPANDOVALUE" ("TABLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_886B68D1" ON "EXPANDOVALUE" ("TABLEID" , "COLUMNID" , "CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_B5984EDA" ON "EXPANDOVALUE" ("TABLEID" , "COLUMNID" , "ROWID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_B71E92D5" ON "EXPANDOVALUE" ("TABLEID" , "ROWID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "EXPANDOVALUE" ADD PRIMARY KEY ("VALUEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "GROUPS_ORGS"
CREATE TABLE "GROUPS_ORGS" ("GROUPID" NUMBER(30, 0) NOT NULL ENABLE, "ORGANIZATIONID" NUMBER(30, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "GROUPS_ORGS" ("GROUPID", "ORGANIZATIONID") VALUES (:1, :2)
ALTER TABLE "GROUPS_ORGS" ADD PRIMARY KEY ("GROUPID", "ORGANIZATIONID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "GROUPS_PERMISSIONS"
CREATE TABLE "GROUPS_PERMISSIONS" ("GROUPID" NUMBER(30, 0) NOT NULL ENABLE, "PERMISSIONID" NUMBER(30, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "GROUPS_PERMISSIONS" ("GROUPID", "PERMISSIONID") VALUES (:1, :2)
CREATE INDEX "LIFERAY_001" ON "GROUPS_PERMISSIONS" ("PERMISSIONID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "GROUPS_PERMISSIONS" ADD PRIMARY KEY ("GROUPID", "PERMISSIONID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "GROUPS_ROLES"
CREATE TABLE "GROUPS_ROLES" ("GROUPID" NUMBER(30, 0) NOT NULL ENABLE, "ROLEID" NUMBER(30, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "GROUPS_ROLES" ("GROUPID", "ROLEID") VALUES (:1, :2)
ALTER TABLE "GROUPS_ROLES" ADD PRIMARY KEY ("GROUPID", "ROLEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "GROUPS_USERGROUPS"
CREATE TABLE "GROUPS_USERGROUPS" ("GROUPID" NUMBER(30, 0) NOT NULL ENABLE, "USERGROUPID" NUMBER(30, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "GROUPS_USERGROUPS" ("GROUPID", "USERGROUPID") VALUES (:1, :2)
ALTER TABLE "GROUPS_USERGROUPS" ADD PRIMARY KEY ("GROUPID", "USERGROUPID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "GROUP_"
CREATE TABLE "GROUP_" ("GROUPID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "CREATORUSERID" NUMBER(30, 0), "CLASSNAMEID" NUMBER(30, 0), "CLASSPK" NUMBER(30, 0), "PARENTGROUPID" NUMBER(30, 0), "LIVEGROUPID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "TYPE_" NUMBER(30, 0), "TYPESETTINGS" VARCHAR2(4000), "FRIENDLYURL" VARCHAR2(100), "ACTIVE_" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "GROUP_" ("GROUPID", "COMPANYID", "CREATORUSERID", "CLASSNAMEID", "CLASSPK", "PARENTGROUPID", "LIVEGROUPID", "NAME", "DESCRIPTION", "TYPE_", "TYPESETTINGS", "FRIENDLYURL", "ACTIVE_") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
K i i i d i Guest /guest 18 24 28 ! 32 % $ 36 ) ( 40 - , 44 1 0 48 5 4 52 9 8 56 = < 60 A @ 64 E D 68 I H 72 M L 76 Q P 80 T
83 [ Y
Y 90 ` ^
^ 95 c
c 100
105
110
115
120
125
130 $ "
" 135 ) '
' 140 . ,
, 145 3 1
1 150 8 6
6 155 = ;
; 160 B @
@ 165 G E
E 170 L J
J 175 Q O
O 180 V T
T 185 [ Y
Y 190 ` ^
^ 195 c
c 200
205
210
215
220
225
230 $ "
" 235 ) '
' 240 . ,
, 245 3 1
1 250 8 6
6 255 = ;
; 260 B @
@ 265 G E
E 270 L J
J 275 Q O
O 280 V T
T 285 [ Y
Y 290 ` ^
^ 295 c
c 300
305
310
315
320
325
330 $ "
" 335 ) '
' 340 . ,
, 345 3 1
1 350 8 6
6 355 = ;
; 360 B @
@ 365 G E
E 370 L J
J 375 Q O
O 380 V T
T 385 [ Y
Y 390 ` ^
^ 395 c
c 400
405
410
415
420
425
430 $ "
" 435 ) '
' 440 . ,
, 445 3 1
1 450 8 6
6 455 = ;
; 460 B @
@ 465 G E
E 470 L J
J 475 Q O
O 480 V T
T 485 [ Y
Y 490 ` ^
^ 495 c
c 500
505
510
515
520
525
530 $ "
" 535 ) '
' 540 . ,
, 545 3 1
1 550 8 6
6 555 = ;
; 560 B @
@ 565 G E
E 570 L J
J 575 Q O
O 580 V T
T 585 [ Y
Y 590 ` ^
^ 595 c
c 600
605
610
615
620
625
630 $ "
" 635 ) '
' 640 . ,
, 645 3 1
1 650 8 6
6 655 = ;
; 660 B @
@ 665 G E
E 670 L J
J 675 Q O
O 680 V T
T 685 [ Y
Y 690 ` ^
^ 695 c
c 700
705
710
715
720
725
730 $ "
" 735 ) '
' 740 . ,
, 745 3 1
1 750 8 6
6 755 = ;
; 760 B @
@ 765 G E
E 770 L J
J 775 Q O
O 780 V T
T 785 [ Y
Y 790 ` ^
^ 795 c
c 800
805
810
815
820
825
830 $ "
" 835 ) '
' 840 . ,
, 845 3 1
1 850 8 6
6 855 = ;
; 860 B @
@ 865 G E
E 870 L J
J 875 Q O
O 880 V T
T 885 [ Y
Y 890 ` ^
^ 895
c
c 900
905
910
915
920
925
930
$
"
" 935
)
'
' 940
.
,
, 945
3
1
1 950
8
6
6 955
=
;
; 960
B
@
@ 965
G
E
E 970
L
J
J 975
Q
O
O 980
V
T
T 985
[
Y
Y 990
`
^
^ 995
c
c 1000
1005
1010
1015
1020
1025
1030 $ "
" 1035
CREATE INDEX "IX_D0D5E397" ON "GROUP_" ("COMPANYID" , "CLASSNAMEID" , "CLASSPK" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "GROUP_"
` BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_D0D5E397"',NULL,NULL,NULL,208,1,208,1,1,2,0,0); END;
CREATE INDEX "IX_5BDDB872" ON "GROUP_" ("COMPANYID" , "FRIENDLYURL" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "GROUP_"
^ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_5BDDB872"',NULL,NULL,NULL,208,1,2,1,1,2,0,0); END;
CREATE INDEX "IX_5AA68501" ON "GROUP_" ("COMPANYID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "GROUP_"
` BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_5AA68501"',NULL,NULL,NULL,208,1,208,1,1,5,0,0); END;
CREATE INDEX "IX_16218A38" ON "GROUP_" ("LIVEGROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "GROUP_"
^ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_16218A38"',NULL,NULL,NULL,208,1,1,1,2,2,0,0); END;
ALTER TABLE "GROUP_" ADD PRIMARY KEY ("GROUPID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "IGFOLDER"
CREATE TABLE "IGFOLDER" ("UUID_" VARCHAR2(75), "FOLDERID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "PARENTFOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "IGFOLDER" ("UUID_", "FOLDERID", "GROUPID", "COMPANYID", "USERID", "CREATEDATE", "MODIFIEDDATE", "PARENTFOLDERID", "NAME", "DESCRIPTION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
K i K i i
CREATE INDEX "IX_60214CF6" ON "IGFOLDER" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_206498F8" ON "IGFOLDER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1A605E9F" ON "IGFOLDER" ("GROUPID" , "PARENTFOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_9BBAFB1E" ON "IGFOLDER" ("GROUPID" , "PARENTFOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_F73C0982" ON "IGFOLDER" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_B10EFD68" ON "IGFOLDER" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "IGFOLDER" ADD PRIMARY KEY ("FOLDERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "IGIMAGE"
CREATE TABLE "IGIMAGE" ("UUID_" VARCHAR2(75), "IMAGEID" NUMBER(30, 0) NOT NULL ENABLE, "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FOLDERID" NUMBER(30, 0), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "SMALLIMAGEID" NUMBER(30, 0), "LARGEIMAGEID" NUMBER(30, 0), "CUSTOM1IMAGEID" NUMBER(30, 0), "CUSTOM2IMAGEID" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "IGIMAGE" ("UUID_", "IMAGEID", "COMPANYID", "USERID", "CREATEDATE", "MODIFIEDDATE", "FOLDERID", "NAME", "DESCRIPTION", "SMALLIMAGEID", "LARGEIMAGEID", "CUSTOM1IMAGEID", "CUSTOM2IMAGEID") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
K i K i i
CREATE INDEX "IX_E597322D" ON "IGIMAGE" ("CUSTOM1IMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D9E0A34C" ON "IGIMAGE" ("CUSTOM2IMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_4438CA80" ON "IGIMAGE" ("FOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_BCB13A3F" ON "IGIMAGE" ("FOLDERID" , "NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_64F0B572" ON "IGIMAGE" ("LARGEIMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D3D32126" ON "IGIMAGE" ("SMALLIMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_265BB0F1" ON "IGIMAGE" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "IGIMAGE" ADD PRIMARY KEY ("IMAGEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "IMAGE"
CREATE TABLE "IMAGE" ("IMAGEID" NUMBER(30, 0) NOT NULL ENABLE, "MODIFIEDDATE" TIMESTAMP (6), "TEXT_" CLOB, "TYPE_" VARCHAR2(75), "HEIGHT" NUMBER(30, 0), "WIDTH" NUMBER(30, 0), "SIZE_" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("TEXT_") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "IMAGE" ("IMAGEID", "MODIFIEDDATE", "TEXT_", "TYPE_", "HEIGHT", "WIDTH", "SIZE_") VALUES (:1, :2, :3, :4, :5, :6, :7)
p i K i TEXT_
CREATE INDEX "IX_6A925A4D" ON "IMAGE" ("SIZE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "IMAGE" ADD PRIMARY KEY ("IMAGEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALARTICLE"
CREATE TABLE "JOURNALARTICLE" ("UUID_" VARCHAR2(75), "ID_" NUMBER(30, 0) NOT NULL ENABLE, "RESOURCEPRIMKEY" NUMBER(30, 0), "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "ARTICLEID" VARCHAR2(75), "VERSION" NUMBER(30, 20), "TITLE" VARCHAR2(100), "DESCRIPTION" VARCHAR2(4000), "CONTENT" CLOB, "TYPE_" VARCHAR2(75), "STRUCTUREID" VARCHAR2(75), "TEMPLATEID" VARCHAR2(75), "DISPLAYDATE" TIMESTAMP (6), "APPROVED" NUMBER(1, 0), "APPROVEDBYUSERID" NUMBER(30, 0), "APPROVEDBYUSERNAME" VARCHAR2(75), "APPROVEDDATE" TIMESTAMP (6), "EXPIRED" NUMBER(1, 0), "EXPIRATIONDATE" TIMESTAMP (6), "REVIEWDATE" TIMESTAMP (6), "INDEXABLE" NUMBER(1, 0), "SMALLIMAGE" NUMBER(1, 0), "SMALLIMAGEID" NUMBER(30, 0), "SMALLIMAGEURL" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "JOURNALARTICLE" ("UUID_", "ID_", "RESOURCEPRIMKEY", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "ARTICLEID", "VERSION", "TITLE", "DESCRIPTION", "CONTENT", "TYPE_", "STRUCTUREID", "TEMPLATEID", "DISPLAYDATE", "APPROVED", "APPROVEDBYUSERID", "APPROVEDBYUSERNAME", "APPROVEDDATE", "EXPIRED", "EXPIRATIONDATE", "REVIEWDATE", "INDEXABLE", "SMALLIMAGE", "SMALLIMAGEID", "SMALLIMAGEURL") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
K i K i K i d i i p i K i K i K i K i K i CONTENT
CREATE INDEX "IX_DFF98523" ON "JOURNALARTICLE" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_9356F865" ON "JOURNALARTICLE" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_68C0F69C" ON "JOURNALARTICLE" ("GROUPID" , "ARTICLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_8DBF1387" ON "JOURNALARTICLE" ("GROUPID" , "ARTICLEID" , "APPROVED" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_85C52EEC" ON "JOURNALARTICLE" ("GROUPID" , "ARTICLEID" , "VERSION" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_2E207659" ON "JOURNALARTICLE" ("GROUPID" , "STRUCTUREID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_8DEAE14E" ON "JOURNALARTICLE" ("GROUPID" , "TEMPLATEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_EF9B7028" ON "JOURNALARTICLE" ("SMALLIMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_F029602F" ON "JOURNALARTICLE" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_3463D95B" ON "JOURNALARTICLE" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALARTICLE" ADD PRIMARY KEY ("ID_") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALARTICLEIMAGE"
CREATE TABLE "JOURNALARTICLEIMAGE" ("ARTICLEIMAGEID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "ARTICLEID" VARCHAR2(75), "VERSION" NUMBER(30, 20), "ELNAME" VARCHAR2(75), "LANGUAGEID" VARCHAR2(75), "TEMPIMAGE" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "JOURNALARTICLEIMAGE" ("ARTICLEIMAGEID", "GROUPID", "ARTICLEID", "VERSION", "ELNAME", "LANGUAGEID", "TEMPIMAGE") VALUES (:1, :2, :3, :4, :5, :6, :7)
K i K i K i
CREATE INDEX "IX_3B51BB68" ON "JOURNALARTICLEIMAGE" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_158B526F" ON "JOURNALARTICLEIMAGE" ("GROUPID" , "ARTICLEID" , "VERSION" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D67292FC" ON "JOURNALARTICLEIMAGE" ("GROUPID" , "ARTICLEID" , "VERSION" , "ELNAME" , "LANGUAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D4121315" ON "JOURNALARTICLEIMAGE" ("TEMPIMAGE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALARTICLEIMAGE" ADD PRIMARY KEY ("ARTICLEIMAGEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALARTICLERESOURCE"
CREATE TABLE "JOURNALARTICLERESOURCE" ("RESOURCEPRIMKEY" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "ARTICLEID" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "JOURNALARTICLERESOURCE" ("RESOURCEPRIMKEY", "GROUPID", "ARTICLEID") VALUES (:1, :2, :3)
K i
CREATE INDEX "IX_F8433677" ON "JOURNALARTICLERESOURCE" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_88DF994A" ON "JOURNALARTICLERESOURCE" ("GROUPID" , "ARTICLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALARTICLERESOURCE" ADD PRIMARY KEY ("RESOURCEPRIMKEY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALCONTENTSEARCH"
CREATE TABLE "JOURNALCONTENTSEARCH" ("CONTENTSEARCHID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "PRIVATELAYOUT" NUMBER(1, 0), "LAYOUTID" NUMBER(30, 0), "PORTLETID" VARCHAR2(200), "ARTICLEID" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "JOURNALCONTENTSEARCH" ("CONTENTSEARCHID", "GROUPID", "COMPANYID", "PRIVATELAYOUT", "LAYOUTID", "PORTLETID", "ARTICLEID") VALUES (:1, :2, :3, :4, :5, :6, :7)
i K i
CREATE INDEX "IX_6838E427" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "ARTICLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_20962903" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "PRIVATELAYOUT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_7CC7D73E" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "PRIVATELAYOUT" , "ARTICLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_B3B318DC" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "PRIVATELAYOUT" , "LAYOUTID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_7ACC74C9" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "PRIVATELAYOUT" , "LAYOUTID" , "PORTLETID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_C3AA93B8" ON "JOURNALCONTENTSEARCH" ("GROUPID" , "PRIVATELAYOUT" , "LAYOUTID" , "PORTLETID" , "ARTICLEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALCONTENTSEARCH" ADD PRIMARY KEY ("CONTENTSEARCHID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALFEED"
CREATE TABLE "JOURNALFEED" ("UUID_" VARCHAR2(75), "ID_" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "FEEDID" VARCHAR2(75), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "TYPE_" VARCHAR2(75), "STRUCTUREID" VARCHAR2(75), "TEMPLATEID" VARCHAR2(75), "RENDERERTEMPLATEID" VARCHAR2(75), "DELTA" NUMBER(30, 0), "ORDERBYCOL" VARCHAR2(75), "ORDERBYTYPE" VARCHAR2(75), "TARGETLAYOUTFRIENDLYURL" VARCHAR2(75), "TARGETPORTLETID" VARCHAR2(75), "CONTENTFIELD" VARCHAR2(75), "FEEDTYPE" VARCHAR2(75), "FEEDVERSION" NUMBER(30, 20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "JOURNALFEED" ("UUID_", "ID_", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "FEEDID", "NAME", "DESCRIPTION", "TYPE_", "STRUCTUREID", "TEMPLATEID", "RENDERERTEMPLATEID", "DELTA", "ORDERBYCOL", "ORDERBYTYPE", "TARGETLAYOUTFRIENDLYURL", "TARGETPORTLETID", "CONTENTFIELD", "FEEDTYPE", "FEEDVERSION") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
K i K i K i K i i K i K i K i K i K i K i K i K i K i K i
CREATE INDEX "IX_35A2DB2F" ON "JOURNALFEED" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_65576CBC" ON "JOURNALFEED" ("GROUPID" , "FEEDID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_50C36D79" ON "JOURNALFEED" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_39031F51" ON "JOURNALFEED" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALFEED" ADD PRIMARY KEY ("ID_") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALSTRUCTURE"
CREATE TABLE "JOURNALSTRUCTURE" ("UUID_" VARCHAR2(75), "ID_" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "STRUCTUREID" VARCHAR2(75), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "XSD" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("XSD") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "JOURNALSTRUCTURE" ("UUID_", "ID_", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "STRUCTUREID", "NAME", "DESCRIPTION", "XSD") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
K i K i K i K i i p i XSD
CREATE INDEX "IX_B97F5608" ON "JOURNALSTRUCTURE" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_AB6E9996" ON "JOURNALSTRUCTURE" ("GROUPID" , "STRUCTUREID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_8831E4FC" ON "JOURNALSTRUCTURE" ("STRUCTUREID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_6702CA92" ON "JOURNALSTRUCTURE" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_42E86E58" ON "JOURNALSTRUCTURE" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALSTRUCTURE" ADD PRIMARY KEY ("ID_") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "JOURNALTEMPLATE"
CREATE TABLE "JOURNALTEMPLATE" ("UUID_" VARCHAR2(75), "ID_" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "USERID" NUMBER(30, 0), "USERNAME" VARCHAR2(75), "CREATEDATE" TIMESTAMP (6), "MODIFIEDDATE" TIMESTAMP (6), "TEMPLATEID" VARCHAR2(75), "STRUCTUREID" VARCHAR2(75), "NAME" VARCHAR2(75), "DESCRIPTION" VARCHAR2(4000), "XSL" CLOB, "LANGTYPE" VARCHAR2(75), "CACHEABLE" NUMBER(1, 0), "SMALLIMAGE" NUMBER(1, 0), "SMALLIMAGEID" NUMBER(30, 0), "SMALLIMAGEURL" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("XSL") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "JOURNALTEMPLATE" ("UUID_", "ID_", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "TEMPLATEID", "STRUCTUREID", "NAME", "DESCRIPTION", "XSL", "LANGTYPE", "CACHEABLE", "SMALLIMAGE", "SMALLIMAGEID", "SMALLIMAGEURL") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
K i K i K i K i K i i p i K i K i XSL
CREATE INDEX "IX_77923653" ON "JOURNALTEMPLATE" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1701CB2B" ON "JOURNALTEMPLATE" ("GROUPID" , "STRUCTUREID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_E802AA3C" ON "JOURNALTEMPLATE" ("GROUPID" , "TEMPLATEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_25FFB6FA" ON "JOURNALTEMPLATE" ("SMALLIMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1B12CA20" ON "JOURNALTEMPLATE" ("TEMPLATEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_2857419D" ON "JOURNALTEMPLATE" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_62D1B3AD" ON "JOURNALTEMPLATE" ("UUID_" , "GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "JOURNALTEMPLATE" ADD PRIMARY KEY ("ID_") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "LAYOUT"
CREATE TABLE "LAYOUT" ("PLID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "PRIVATELAYOUT" NUMBER(1, 0), "LAYOUTID" NUMBER(30, 0), "PARENTLAYOUTID" NUMBER(30, 0), "NAME" VARCHAR2(4000), "TITLE" VARCHAR2(4000), "DESCRIPTION" VARCHAR2(4000), "TYPE_" VARCHAR2(75), "TYPESETTINGS" CLOB, "HIDDEN_" NUMBER(1, 0), "FRIENDLYURL" VARCHAR2(100), "ICONIMAGE" NUMBER(1, 0), "ICONIMAGEID" NUMBER(30, 0), "THEMEID" VARCHAR2(75), "COLORSCHEMEID" VARCHAR2(75), "WAPTHEMEID" VARCHAR2(75), "WAPCOLORSCHEMEID" VARCHAR2(75), "CSS" VARCHAR2(4000), "PRIORITY" NUMBER(30, 0), "DLFOLDERID" NUMBER(30, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("TYPESETTINGS") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
INSERT INTO "LAYOUT" ("PLID", "GROUPID", "COMPANYID", "PRIVATELAYOUT", "LAYOUTID", "PARENTLAYOUTID", "NAME", "TITLE", "DESCRIPTION", "TYPE_", "TYPESETTINGS", "HIDDEN_", "FRIENDLYURL", "ICONIMAGE", "ICONIMAGEID", "THEMEID", "COLORSCHEMEID", "WAPTHEMEID", "WAPCOLORSCHEMEID", "CSS", "PRIORITY", "DLFOLDERID") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
i i i K i p i d i K i K i K i K i i TYPESETTINGS K
Liferay, Inc. Extranet
portlet J J i l a y o u t J @ p l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
c o l u m n - 1 = 3 ,
c o l u m n - 2 = 1 9 , p l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
c o l u m n - 1 = 3 ,
c o l u m n - 2 = 1 9 , K
Liferay, Inc. Intranet
portlet J J i l a y o u t J @ p l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
c o l u m n - 1 = 3 ,
c o l u m n - 2 = 1 9 , p l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
c o l u m n - 1 = 3 ,
c o l u m n - 2 = 1 9 , W T 9
Home
portlet J J i c o l u m n J @ c o l u m n - 1 = 7 1 _ I N S T A N C E _ O Y 0 d , 8 2 , 2 3 , 6 1 ,
c o l u m n - 2 = 9 , 7 9 , 2 9 , 8 , 1 9 ,
l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
/home c o l u m n - 1 = 7 1 _ I N S T A N C E _ O Y 0 d , 8 2 , 2 3 , 6 1 ,
c o l u m n - 2 = 9 , 7 9 , 2 9 , 8 , 1 9 ,
l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
X T <
Plugins
portlet
J J i c o l u m n J @ p c o l u m n - 1 =
c o l u m n - 2 = 1 1 1 ,
l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
/plugins p c o l u m n - 1 =
c o l u m n - 2 = 1 1 1 ,
l a y o u t - t e m p l a t e - i d = 2 _ c o l u m n s _ i i
CREATE INDEX "IX_C7FBC998" ON "LAYOUT" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_C7FBC998"',NULL,NULL,NULL,4,1,1,1,1,1,0,0); END;
CREATE INDEX "IX_FAD05595" ON "LAYOUT" ("DLFOLDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_C099D61A" ON "LAYOUT" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_C099D61A"',NULL,NULL,NULL,4,1,2,1,1,1,0,0); END;
CREATE INDEX "IX_705F5AA3" ON "LAYOUT" ("GROUPID" , "PRIVATELAYOUT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_705F5AA3"',NULL,NULL,NULL,4,1,3,1,1,1,0,0); END;
CREATE INDEX "IX_BC2C4231" ON "LAYOUT" ("GROUPID" , "PRIVATELAYOUT" , "FRIENDLYURL" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_BC2C4231"',NULL,NULL,NULL,4,1,4,1,1,1,0,0); END;
CREATE INDEX "IX_7162C27C" ON "LAYOUT" ("GROUPID" , "PRIVATELAYOUT" , "LAYOUTID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_7162C27C"',NULL,NULL,NULL,4,1,4,1,1,1,0,0); END;
CREATE INDEX "IX_6DE88B06" ON "LAYOUT" ("GROUPID" , "PRIVATELAYOUT" , "PARENTLAYOUTID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_6DE88B06"',NULL,NULL,NULL,4,1,3,1,1,1,0,0); END;
CREATE INDEX "IX_1A1B61D2" ON "LAYOUT" ("GROUPID" , "PRIVATELAYOUT" , "TYPE_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ANALSTATS IR "LAYOUT"
\ BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IX_1A1B61D2"',NULL,NULL,NULL,4,1,3,1,1,1,0,0); END;
CREATE INDEX "IX_23922F7D" ON "LAYOUT" ("ICONIMAGEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING
ALTER TABLE "LAYOUT" ADD PRIMARY KEY ("PLID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE
TABLE "LAYOUTSET"
CREATE TABLE "LAYOUTSET" ("LAYOUTSETID" NUMBER(30, 0) NOT NULL ENABLE, "GROUPID" NUMBER(30, 0), "COMPANYID" NUMBER(30, 0), "PRIVATELAYOUT" NUMBER(1, 0), "LOGO" NUMBER(1, 0), "LOGOID" NUMBER(30, 0), "THEMEID" VARCHAR2(75), "COLORSCHEMEID" VARCHAR2(75), "WAPTHEMEID" VARCHAR2(75), "WAPCOLORSCHEMEID" VARCHAR2(75), "CSS" VARCHAR2(4000), "PAGECOUNT" NUMBER(30, 0), "VIRTUALHOST" VARCHAR2(75)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS
INSERT INTO "LAYOUTSET" ("LAYOUTSETID", "GROUPID", "COMPANYID", "PRIVATELAYOUT", "LOGO", "LOGOID", "THEMEID", "COLORSCHEMEID", "WAPTHEMEID", "WAPCOLORSCHEMEID", "CSS", "PAGECOUNT", "VIRTUALHOST") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
K i K i K i K i i K i classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 " ! classic 01 # ! classic 01 & % classic 01 ' % classic 01 * ) classic 01 + ) classic 01 . - classic 01 / - classic 01 2 1 classic 01 3 1 classic 01 6 5 classic 01 7 5 classic 01 : 9 classic 01 ; 9 classic 01 > = classic 01 ? = classic 01 B A classic 01 C A classic 01 F E classic 01 G E classic 01 J I classic 01 K I classic 01 N M classic 01 O M classic 01 R Q classic 01 S Q classic 01 U T classic 01 V T classic 01 \ [ classic 01 ] [ classic 01 a ` classic 01 b ` classic 01 classic 01 classic 01 classic 01 classic 01 classic 01
classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 classic 01 ! classic 01 % $ classic 01 & $ classic 01 * ) classic 01 + ) classic 01 / . classic 01 0 . classic 01 4 3 classic 01 5 3 classic 01 9 8 classic 01 : 8 classic 01 > = classic 01 ? = classic 01 C B classic 01 D B classic 01 H G classic 01 I G classic 01 M L classic 01 N L classic 01 R Q classic 01 S Q classic 01 W V classic 01 X V classic 01 \ [ classic 01 ] [ classic 01 a ` classic 01 b ` classic 01 class