²EXPORT:V09.02.00
ULPORTAL
RUSERS
2048
0
20
0
²ig Wed Apr 9 10:35:23 2008lportal.dmp d `$
#G###A°# ƒig d `$
#G###A°# ƒ ² ² -08:00 BYTE INTERPRETED
PROCACTION
ýÿ BEGIN
m sys.dbms_logrep_imp.instantiate_schema(schema_name=>'LPORTAL', export_db_name=>'ORCL', inst_scn=>'4486584');
COMMIT; END;
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) 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 #0 xl #0 € 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) 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) 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) 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) 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) 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) 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) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_5BC8B0D4" ON "ADDRESS" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) 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) 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) 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) 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) 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) 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) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_D49C2E66" ON "ANNOUNCEMENTSENTRY" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_1AFBDE08" ON "ANNOUNCEMENTSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) 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) 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) 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) 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) 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) 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)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))
INSERT INTO "BLOGSENTRY" ("UUID_", "ENTRYID", "GROUPID", "COMPANYID", "USERID", "USERNAME", "CREATEDATE", "MODIFIEDDATE", "TITLE", "URLTITLE", "CONTENT", "DISPLAYDATE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
K i K i ´ ´ – i – i p i ´ CONTENT ÿÿ
CREATE INDEX "IX_72EF6041" ON "BLOGSENTRY" ("COMPANYID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_8CACE77B" ON "BLOGSENTRY" ("COMPANYID" , "USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_81A50303" ON "BLOGSENTRY" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_69157A4D" ON "BLOGSENTRY" ("UUID_" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) 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) 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) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_43840EEB" ON "BLOGSSTATSUSER" ("GROUPID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) TABLESPACE "SYSTEM" LOGGING
CREATE INDEX "IX_BB51F1D9" ON "BLOGSSTATSUSER" ("USERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) 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) 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) 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 ´ ´ bundles/glassfish-3.1.2.2/bin" />