-------------------------------------------------------- -- File created - Wednesday-September-03-2008 -------------------------------------------------------- -- DROP TABLE "TADCAMPAIGNS" cascade constraints; -- DROP TABLE "TADCREATIVES" cascade constraints; -- DROP TABLE "TADIPWHITELIST" cascade constraints; -- DROP TABLE "TADPLACEMENTDETAILS" cascade constraints; -- DROP TABLE "TADPLACEMENTS" cascade constraints; -- DROP TABLE "TADSTATS" cascade constraints; -- DROP TABLE "TADZONES" cascade constraints; -- DROP TABLE "TCAPTCHA" cascade constraints; -- DROP TABLE "TCLASSEXTEND" cascade constraints; -- DROP TABLE "TCLASSEXTENDATTRIBUTES" cascade constraints; -- DROP TABLE "TCLASSEXTENDDATA" cascade constraints; -- DROP TABLE "TCLASSEXTENDDATAUSERACTIVITY" cascade constraints; -- DROP TABLE "TCLASSEXTENDSETS" cascade constraints; -- DROP TABLE "TCONTENT" cascade constraints; -- DROP TABLE "TCONTENTASSIGNMENTS" cascade constraints; -- DROP TABLE "TCONTENTCATEGORIES" cascade constraints; -- DROP TABLE "TCONTENTCATEGORYASSIGN" cascade constraints; -- DROP TABLE "TCONTENTCOMMENTS" cascade constraints; -- DROP TABLE "TCONTENTDISPLAYTITLEAPPROVALS" cascade constraints; -- DROP TABLE "TCONTENTEVENTREMINDERS" cascade constraints; -- DROP TABLE "TCONTENTFEEDADVANCEDPARAMS" cascade constraints; -- DROP TABLE "TCONTENTFEEDITEMS" cascade constraints; -- DROP TABLE "TCONTENTFEEDS" cascade constraints; -- DROP TABLE "TCONTENTOBJECTS" cascade constraints; -- DROP TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" cascade constraints; -- DROP TABLE "TCONTENTRATINGS" cascade constraints; -- DROP TABLE "TCONTENTRELATED" cascade constraints; -- DROP TABLE "TCONTENTSTATS" cascade constraints; -- DROP TABLE "TCONTENTTAGS" cascade constraints; -- DROP TABLE "TEMAILRETURNSTATS" cascade constraints; -- DROP TABLE "TEMAILS" cascade constraints; -- DROP TABLE "TEMAILSTATS" cascade constraints; -- DROP TABLE "TFILES" cascade constraints; -- DROP TABLE "TFORMRESPONSEPACKETS" cascade constraints; -- DROP TABLE "TFORMRESPONSEQUESTIONS" cascade constraints; -- DROP TABLE "TGLOBALS" cascade constraints; -- DROP TABLE "TMAILINGLIST" cascade constraints; -- DROP TABLE "TMAILINGLISTMEMBERS" cascade constraints; -- DROP TABLE "TPERMISSIONS" cascade constraints; -- DROP TABLE "TREDIRECTS" cascade constraints; -- DROP TABLE "TSESSIONTRACKING" cascade constraints; -- DROP TABLE "TSETTINGS" cascade constraints; -- DROP TABLE "TSYSTEMOBJECTS" cascade constraints; -- DROP TABLE "TUSERADDRESSES" cascade constraints; -- DROP TABLE "TUSERS" cascade constraints; -- DROP TABLE "TUSERSFAVORITES" cascade constraints; -- DROP TABLE "TUSERSINTERESTS" cascade constraints; -- DROP TABLE "TUSERSMEMB" cascade constraints; -- DROP TABLE "TUSERSTAGS" cascade constraints; -- DROP SEQUENCE "TADPLACEMENTDETAILS_DETAILID_S"; -- DROP SEQUENCE "TADSTATS_STATID_SEQ"; -- DROP SEQUENCE "TCLASSEXTENDATTRIBUTES_ATTRIBU"; -- DROP SEQUENCE "TCLASSEXTENDDATAUSERACTIVITY_D"; -- DROP SEQUENCE "TCLASSEXTENDDATA_DATAID_SEQ"; -- DROP SEQUENCE "TCONTENTTAGS_TAGID_SEQ"; -- DROP SEQUENCE "TCONTENT_TCONTENT_ID_SEQ"; -- DROP SEQUENCE "TSESSIONTRACKING_TRACKINGID_SE"; -- DROP SEQUENCE "TUSERSTAGS_TAGID_SEQ"; -- DROP PACKAGE "sql_utilities"; -------------------------------------------------------- -- DDL for Sequence TADPLACEMENTDETAILS_DETAILID_S -------------------------------------------------------- CREATE SEQUENCE "TADPLACEMENTDETAILS_DETAILID_S" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TADSTATS_STATID_SEQ -------------------------------------------------------- CREATE SEQUENCE "TADSTATS_STATID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TCLASSEXTENDATTRIBUTES_ATTRIBU -------------------------------------------------------- CREATE SEQUENCE "TCLASSEXTENDATTRIBUTES_ATTRIBU" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 19537201 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TCLASSEXTENDDATAUSERACTIVITY_D -------------------------------------------------------- CREATE SEQUENCE "TCLASSEXTENDDATAUSERACTIVITY_D" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 321 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TCLASSEXTENDDATA_DATAID_SEQ -------------------------------------------------------- CREATE SEQUENCE "TCLASSEXTENDDATA_DATAID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TCONTENTTAGS_TAGID_SEQ -------------------------------------------------------- CREATE SEQUENCE "TCONTENTTAGS_TAGID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TCONTENT_TCONTENT_ID_SEQ -------------------------------------------------------- CREATE SEQUENCE "TCONTENT_TCONTENT_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 221 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TSESSIONTRACKING_TRACKINGID_SE -------------------------------------------------------- CREATE SEQUENCE "TSESSIONTRACKING_TRACKINGID_SE" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 361 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence TUSERSTAGS_TAGID_SEQ -------------------------------------------------------- CREATE SEQUENCE "TUSERSTAGS_TAGID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Table TADCAMPAIGNS -------------------------------------------------------- CREATE TABLE "TADCAMPAIGNS" ( "CAMPAIGNID" CHAR(35), "USERID" CHAR(35), "DATECREATED" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "NAME" VARCHAR2(50), "STARTDATE" DATE, "ENDDATE" DATE, "ISACTIVE" NUMBER(10,0), "NOTES" CLOB ) lob (NOTES) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TADCREATIVES -------------------------------------------------------- CREATE TABLE "TADCREATIVES" ( "CREATIVEID" CHAR(35), "USERID" CHAR(35), "DATECREATED" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "NAME" VARCHAR2(50), "CREATIVETYPE" VARCHAR2(50), "FILEID" VARCHAR2(35), "MEDIATYPE" VARCHAR2(50), "REDIRECTURL" VARCHAR2(100), "ALTTEXT" VARCHAR2(100), "NOTES" CLOB, "ISACTIVE" NUMBER(10,0), "HEIGHT" NUMBER(10,0), "WIDTH" NUMBER(10,0), "TEXTBODY" CLOB ) lob (NOTES, TEXTBODY) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TADIPWHITELIST -------------------------------------------------------- CREATE TABLE "TADIPWHITELIST" ( "IP" VARCHAR2(50), "SITEID" VARCHAR2(50) ) ; -------------------------------------------------------- -- DDL for Table TADPLACEMENTDETAILS -------------------------------------------------------- CREATE TABLE "TADPLACEMENTDETAILS" ( "DETAILID" NUMBER(10,0), "PLACEMENTID" CHAR(35), "PLACEMENTTYPE" CHAR(35), "PLACEMENTVALUE" NUMBER(10,0) DEFAULT '0' ) ; -------------------------------------------------------- -- DDL for Table TADPLACEMENTS -------------------------------------------------------- CREATE TABLE "TADPLACEMENTS" ( "PLACEMENTID" CHAR(35), "CAMPAIGNID" CHAR(35), "ADZONEID" CHAR(35), "CREATIVEID" CHAR(35), "DATECREATED" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "STARTDATE" DATE, "ENDDATE" DATE, "COSTPERIMP" FLOAT(126), "COSTPERCLICK" FLOAT(126), "ISEXCLUSIVE" NUMBER(10,0), "BILLABLE" FLOAT(126), "BUDGET" NUMBER(10,0), "ISACTIVE" NUMBER(10,0), "NOTES" CLOB ) lob (NOTES) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TADSTATS -------------------------------------------------------- CREATE TABLE "TADSTATS" ( "STATID" NUMBER(10,0), "PLACEMENTID" CHAR(35), "STATHOUR" NUMBER(10,0), "STATDATE" DATE, "TYPE" VARCHAR2(50), "COUNTER" NUMBER(10,0) ) ; -------------------------------------------------------- -- DDL for Table TADZONES -------------------------------------------------------- CREATE TABLE "TADZONES" ( "ADZONEID" CHAR(35), "SITEID" VARCHAR2(25), "DATECREATED" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "NAME" VARCHAR2(50), "CREATIVETYPE" VARCHAR2(50), "NOTES" CLOB, "ISACTIVE" NUMBER(10,0), "HEIGHT" NUMBER(10,0), "WIDTH" NUMBER(10,0) ) lob (NOTES) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCAPTCHA -------------------------------------------------------- CREATE TABLE "TCAPTCHA" ( "LETTERID" NUMBER(10,0) DEFAULT '0', "LETTER" CHAR(1), "IMAGEFILE" VARCHAR2(50) ) ; -------------------------------------------------------- -- DDL for Table TCLASSEXTEND -------------------------------------------------------- CREATE TABLE "TCLASSEXTEND" ( "SUBTYPEID" CHAR(35), "SITEID" VARCHAR2(25), "BASETABLE" VARCHAR2(50), "BASEKEYFIELD" VARCHAR2(50), "DATATABLE" VARCHAR2(50), "TYPE" VARCHAR2(50), "SUBTYPE" VARCHAR2(50), "ISACTIVE" NUMBER(3,0), "NOTES" CLOB, "LASTUPDATE" DATE, "DATECREATED" DATE, "LASTUPDATEBY" VARCHAR2(100) ) lob (NOTES) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCLASSEXTENDATTRIBUTES -------------------------------------------------------- CREATE TABLE "TCLASSEXTENDATTRIBUTES" ( "ATTRIBUTEID" NUMBER(10,0), "EXTENDSETID" CHAR(35), "SITEID" VARCHAR2(25), "NAME" VARCHAR2(100), "LABEL" CLOB, "HINT" CLOB, "TYPE" VARCHAR2(100), "ORDERNO" NUMBER(10,0), "ISACTIVE" NUMBER(3,0), "REQUIRED" VARCHAR2(50), "VALIDATION" VARCHAR2(50), "REGEX" CLOB, "MESSAGE" CLOB, "DEFAULTVALUE" VARCHAR2(100), "OPTIONLIST" CLOB, "OPTIONLABELLIST" CLOB ) lob (LABEL, HINT, REGEX, MESSAGE, OPTIONLIST, OPTIONLABELLIST) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCLASSEXTENDDATA -------------------------------------------------------- CREATE TABLE "TCLASSEXTENDDATA" ( "DATAID" NUMBER(10,0), "BASEID" CHAR(35), "ATTRIBUTEID" NUMBER(10,0), "SITEID" VARCHAR2(25), "ATTRIBUTEVALUE" CLOB ) lob (ATTRIBUTEVALUE) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCLASSEXTENDDATAUSERACTIVITY -------------------------------------------------------- CREATE TABLE "TCLASSEXTENDDATAUSERACTIVITY" ( "DATAID" NUMBER(10,0), "BASEID" CHAR(35), "ATTRIBUTEID" NUMBER(10,0), "SITEID" VARCHAR2(25), "ATTRIBUTEVALUE" CLOB ) lob (ATTRIBUTEVALUE) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCLASSEXTENDSETS -------------------------------------------------------- CREATE TABLE "TCLASSEXTENDSETS" ( "EXTENDSETID" CHAR(35), "SUBTYPEID" CHAR(35), "CATEGORYID" CLOB, "SITEID" VARCHAR2(25), "NAME" VARCHAR2(50), "ORDERNO" NUMBER(10,0), "ISACTIVE" NUMBER(3,0) ) lob (CATEGORYID) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCONTENT -------------------------------------------------------- CREATE TABLE "TCONTENT" ( "TCONTENT_ID" NUMBER(10,0), "SITEID" VARCHAR2(25), "MODULEID" CHAR(35), "PARENTID" CHAR(35), "CONTENTID" CHAR(35), "CONTENTHISTID" CHAR(35), "REMOTEID" VARCHAR2(255), "REMOTEURL" VARCHAR2(255), "REMOTEPUBDATE" VARCHAR2(50), "REMOTESOURCEURL" VARCHAR2(255), "REMOTESOURCE" VARCHAR2(255), "CREDITS" VARCHAR2(255), "FILEID" CHAR(35), "TEMPLATE" VARCHAR2(50), "TYPE" VARCHAR2(25), "SUBTYPE" VARCHAR2(25), "ACTIVE" NUMBER(3,0) DEFAULT '0', "ORDERNO" NUMBER(10,0), "TITLE" VARCHAR2(255), "MENUTITLE" VARCHAR2(255), "SUMMARY" CLOB, "FILENAME" VARCHAR2(255), "METADESC" CLOB, "METAKEYWORDS" CLOB, "BODY" CLOB, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "LASTUPDATEBYID" VARCHAR2(50), "DISPLAYSTART" DATE, "DISPLAYSTOP" DATE, "DISPLAY" NUMBER(3,0), "APPROVED" NUMBER(3,0), "ISNAV" NUMBER(3,0), "RESTRICTED" NUMBER(3,0), "RESTRICTGROUPS" VARCHAR2(255), "TARGET" VARCHAR2(25), "TARGETPARAMS" VARCHAR2(255), "RESPONSECHART" NUMBER(3,0), "RESPONSEMESSAGE" CLOB, "RESPONSESENDTO" VARCHAR2(50), "RESPONSEDISPLAYFIELDS" CLOB, "MODULEASSIGN" VARCHAR2(255), "DISPLAYTITLE" NUMBER(3,0), "NOTES" CLOB, "INHERITOBJECTS" VARCHAR2(25), "ISFEATURE" NUMBER(3,0), "RELEASEDATE" DATE, "ISLOCKED" NUMBER(3,0), "NEXTN" NUMBER(10,0), "SORTBY" VARCHAR2(50), "SORTDIRECTION" VARCHAR2(50), "FEATURESTART" DATE, "FEATURESTOP" DATE, "FORCESSL" NUMBER(3,0) DEFAULT '0', "AUDIENCE" CLOB, "KEYPOINTS" CLOB, "SEARCHEXCLUDE" NUMBER(3,0), "PATH" CLOB, "TAGS" CLOB ) lob (SUMMARY, METADESC, METAKEYWORDS, BODY, AUDIENCE, KEYPOINTS, TAGS, RESPONSEMESSAGE, PATH, NOTES) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCONTENTASSIGNMENTS -------------------------------------------------------- CREATE TABLE "TCONTENTASSIGNMENTS" ( "CONTENTID" CHAR(35), "CONTENTHISTID" CHAR(35), "SITEID" VARCHAR2(25), "USERID" CHAR(35) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTCATEGORIES -------------------------------------------------------- CREATE TABLE "TCONTENTCATEGORIES" ( "CATEGORYID" CHAR(35), "SITEID" VARCHAR2(25), "PARENTID" CHAR(35), "DATECREATED" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "NAME" VARCHAR2(50), "NOTES" CLOB, "ISINTERESTGROUP" NUMBER(10,0), "ISACTIVE" NUMBER(10,0), "ISOPEN" NUMBER(10,0), "SORTBY" VARCHAR2(50), "SORTDIRECTION" VARCHAR2(50), "RESTRICTGROUPS" VARCHAR2(255), "PATH" CLOB ) lob (NOTES, PATH) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCONTENTCATEGORYASSIGN -------------------------------------------------------- CREATE TABLE "TCONTENTCATEGORYASSIGN" ( "CONTENTHISTID" CHAR(35), "CATEGORYID" CHAR(35), "CONTENTID" CHAR(35), "ISFEATURE" NUMBER(10,0), "ORDERNO" NUMBER(10,0), "SITEID" VARCHAR2(25), "FEATURESTART" DATE, "FEATURESTOP" DATE ) ; -------------------------------------------------------- -- DDL for Table TCONTENTCOMMENTS -------------------------------------------------------- CREATE TABLE "TCONTENTCOMMENTS" ( "COMMENTID" CHAR(35), "CONTENTID" CHAR(35), "CONTENTHISTID" CHAR(35), "URL" VARCHAR2(50), "NAME" VARCHAR2(50), "ENTERED" DATE, "EMAIL" VARCHAR2(50), "SITEID" VARCHAR2(25), "IP" VARCHAR2(50), "ISAPPROVED" NUMBER(3,0) DEFAULT '0', "COMMENTS" CLOB ) lob (COMMENTS) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCONTENTDISPLAYTITLEAPPROVALS -------------------------------------------------------- CREATE TABLE "TCONTENTDISPLAYTITLEAPPROVALS" ( "CONTENTID" CHAR(35), "ISAPPROVED" NUMBER(3,0), "EMAIL" VARCHAR2(150), "SITEID" VARCHAR2(25) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTEVENTREMINDERS -------------------------------------------------------- CREATE TABLE "TCONTENTEVENTREMINDERS" ( "CONTENTID" CHAR(35), "SITEID" VARCHAR2(35), "EMAIL" VARCHAR2(200), "REMINDDATE" DATE, "REMINDHOUR" NUMBER(10,0), "REMINDMINUTE" NUMBER(10,0), "REMINDINTERVAL" NUMBER(10,0), "ISSENT" NUMBER(10,0) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTFEEDADVANCEDPARAMS -------------------------------------------------------- CREATE TABLE "TCONTENTFEEDADVANCEDPARAMS" ( "PARAMID" CHAR(35), "FEEDID" CHAR(35), "PARAM" FLOAT(126), "RELATIONSHIP" VARCHAR2(50), "FIELD" VARCHAR2(100), "CONDITION" VARCHAR2(50), "CRITERIA" VARCHAR2(200), "DATATYPE" VARCHAR2(50) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTFEEDITEMS -------------------------------------------------------- CREATE TABLE "TCONTENTFEEDITEMS" ( "FEEDID" CHAR(35), "ITEMID" CHAR(35), "TYPE" VARCHAR2(50) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTFEEDS -------------------------------------------------------- CREATE TABLE "TCONTENTFEEDS" ( "FEEDID" CHAR(35), "SITEID" VARCHAR2(35), "PARENTID" CHAR(35), "NAME" VARCHAR2(250), "ISACTIVE" NUMBER(3,0), "ISPUBLIC" NUMBER(3,0), "ISDEFAULT" NUMBER(3,0), "ISFEATURESONLY" NUMBER(3,0), "DESCRIPTION" CLOB, "MAXITEMS" NUMBER(10,0), "ALLOWHTML" NUMBER(3,0), "LANG" VARCHAR2(50), "LASTUPDATEBY" VARCHAR2(100), "LASTUPDATE" DATE, "DATECREATED" DATE, "RESTRICTED" NUMBER(3,0), "RESTRICTGROUPS" CLOB, "VERSION" VARCHAR2(50), "CHANNELLINK" VARCHAR2(250), "TYPE" VARCHAR2(50), "SORTBY" VARCHAR2(50), "SORTDIRECTION" VARCHAR2(50), "NEXTN" NUMBER(10,0), "DISPLAYNAME" NUMBER(3,0), "DISPLAYRATINGS" NUMBER(3,0), "DISPLAYCOMMENTS" NUMBER(3,0) ) lob (DESCRIPTION) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TCONTENTOBJECTS -------------------------------------------------------- CREATE TABLE "TCONTENTOBJECTS" ( "CONTENTHISTID" CHAR(35), "OBJECTID" VARCHAR2(100), "OBJECT" VARCHAR2(50), "CONTENTID" CHAR(35), "NAME" VARCHAR2(255), "ORDERNO" NUMBER(10,0), "SITEID" VARCHAR2(25), "COLUMNID" NUMBER(10,0) DEFAULT '0' ) ; -------------------------------------------------------- -- DDL for Table TCONTENTPUBLICSUBMISSIONAPPROV -------------------------------------------------------- CREATE TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" ( "CONTENTID" CHAR(35), "ISAPPROVED" NUMBER(10,0), "EMAIL" VARCHAR2(150), "SITEID" VARCHAR2(25) ) ; COMMENT ON TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" IS 'ORIGINAL NAME:tcontentpublicsubmissionapprovals'; -------------------------------------------------------- -- DDL for Table TCONTENTRATINGS -------------------------------------------------------- CREATE TABLE "TCONTENTRATINGS" ( "CONTENTID" CHAR(35), "USERID" CHAR(35), "SITEID" VARCHAR2(35), "RATE" NUMBER(10,0), "ENTERED" DATE DEFAULT SYSDATE ) ; -------------------------------------------------------- -- DDL for Table TCONTENTRELATED -------------------------------------------------------- CREATE TABLE "TCONTENTRELATED" ( "CONTENTHISTID" CHAR(35), "RELATEDID" CHAR(35), "CONTENTID" CHAR(35), "SITEID" VARCHAR2(25) ) ; -------------------------------------------------------- -- DDL for Table TCONTENTSTATS -------------------------------------------------------- CREATE TABLE "TCONTENTSTATS" ( "CONTENTID" CHAR(35), "SITEID" VARCHAR2(25), "VIEWS" NUMBER(10,0) DEFAULT '0', "RATING" FLOAT(126) DEFAULT '0', "TOTALVOTES" NUMBER(10,0) DEFAULT '0', "UPVOTES" NUMBER(10,0) DEFAULT '0', "DOWNVOTES" NUMBER(10,0) DEFAULT '0', "COMMENTS" NUMBER(10,0) DEFAULT '0' ) ; -------------------------------------------------------- -- DDL for Table TCONTENTTAGS -------------------------------------------------------- CREATE TABLE "TCONTENTTAGS" ( "TAGID" NUMBER(10,0), "CONTENTID" CHAR(35), "CONTENTHISTID" CHAR(35), "SITEID" VARCHAR2(25), "TAG" VARCHAR2(100) ) ; -------------------------------------------------------- -- DDL for Table TEMAILRETURNSTATS -------------------------------------------------------- CREATE TABLE "TEMAILRETURNSTATS" ( "EMAILID" CHAR(35), "EMAIL" VARCHAR2(50), "URL" VARCHAR2(500), "CREATED" DATE ) ; -------------------------------------------------------- -- DDL for Table TEMAILS -------------------------------------------------------- CREATE TABLE "TEMAILS" ( "EMAILID" CHAR(35), "SITEID" VARCHAR2(25), "SUBJECT" VARCHAR2(255), "BODYTEXT" CLOB, "BODYHTML" CLOB, "CREATEDDATE" DATE, "DELIVERYDATE" DATE, "STATUS" NUMBER(3,0), "GROUPLIST" CLOB, "LASTUPDATEBY" VARCHAR2(50), "LASTUPDATEBYID" VARCHAR2(35), "NUMBERSENT" NUMBER(10,0) DEFAULT '0', "REPLYTO" VARCHAR2(50), "FORMAT" VARCHAR2(50), "FROMLABEL" VARCHAR2(50), "ISDELETED" NUMBER(3,0) DEFAULT '0' ) lob (BODYHTML, BODYTEXT, GROUPLIST) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TEMAILSTATS -------------------------------------------------------- CREATE TABLE "TEMAILSTATS" ( "EMAILID" CHAR(35), "EMAIL" CHAR(35), "EMAILOPEN" NUMBER(10,0) DEFAULT '0', "RETURNCLICK" NUMBER(10,0) DEFAULT '0', "BOUNCE" NUMBER(10,0) DEFAULT '0', "SENT" NUMBER(10,0) DEFAULT '0', "CREATED" DATE ) ; -------------------------------------------------------- -- DDL for Table TFILES -------------------------------------------------------- CREATE TABLE "TFILES" ( "FILEID" CHAR(35), "CONTENTID" CHAR(35), "SITEID" VARCHAR2(25), "MODULEID" CHAR(35), "FILENAME" VARCHAR2(200), "IMAGE" BLOB, "IMAGESMALL" BLOB, "IMAGEMEDIUM" BLOB, "FILESIZE" NUMBER(10,0), "CONTENTTYPE" VARCHAR2(50), "CONTENTSUBTYPE" VARCHAR2(50), "FILEEXT" VARCHAR2(50), "CREATED" DATE ) lob (IMAGE, IMAGESMALL, IMAGEMEDIUM) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TFORMRESPONSEPACKETS -------------------------------------------------------- CREATE TABLE "TFORMRESPONSEPACKETS" ( "RESPONSEID" CHAR(35), "FORMID" CHAR(35), "SITEID" VARCHAR2(25), "FIELDLIST" CLOB, "DATA" CLOB, "ENTERED" DATE ) lob (FIELDLIST, DATA) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TFORMRESPONSEQUESTIONS -------------------------------------------------------- CREATE TABLE "TFORMRESPONSEQUESTIONS" ( "RESPONSEID" CHAR(35), "FORMID" CHAR(35), "FORMFIELD" VARCHAR2(50), "FORMVALUE" CLOB, "POLLVALUE" VARCHAR2(255) ) lob (FORMVALUE) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TGLOBALS -------------------------------------------------------- CREATE TABLE "TGLOBALS" ( "APPRELOAD" DATE, "LOADLIST" CLOB ) ; -------------------------------------------------------- -- DDL for Table TMAILINGLIST -------------------------------------------------------- CREATE TABLE "TMAILINGLIST" ( "MLID" CHAR(35), "SITEID" VARCHAR2(25), "NAME" VARCHAR2(50), "DESCRIPTION" CLOB, "LASTUPDATE" DATE, "ISPURGE" NUMBER(10,0), "ISPUBLIC" NUMBER(10,0) ) lob (DESCRIPTION) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TMAILINGLISTMEMBERS -------------------------------------------------------- CREATE TABLE "TMAILINGLISTMEMBERS" ( "MLID" CHAR(35), "EMAIL" VARCHAR2(100), "SITEID" VARCHAR2(25), "FNAME" VARCHAR2(50), "LNAME" VARCHAR2(50), "COMPANY" VARCHAR2(50), "ISVERIFIED" NUMBER(3,0) DEFAULT '0' ) ; -------------------------------------------------------- -- DDL for Table TPERMISSIONS -------------------------------------------------------- CREATE TABLE "TPERMISSIONS" ( "CONTENTID" CHAR(35), "GROUPID" CHAR(35), "SITEID" VARCHAR2(25), "TYPE" VARCHAR2(50) ) ; -------------------------------------------------------- -- DDL for Table TREDIRECTS -------------------------------------------------------- CREATE TABLE "TREDIRECTS" ( "REDIRECTID" CHAR(35), "URL" CLOB, "CREATED" DATE ) ; -------------------------------------------------------- -- DDL for Table TSESSIONTRACKING -------------------------------------------------------- CREATE TABLE "TSESSIONTRACKING" ( "TRACKINGID" NUMBER(10,0), "CONTENTID" CHAR(35), "SITEID" VARCHAR2(25), "USERID" CHAR(35), "REMOTE_ADDR" VARCHAR2(50), "SERVER_NAME" VARCHAR2(20), "USER_AGENT" VARCHAR2(200), "SCRIPT_NAME" VARCHAR2(200), "URLTOKEN" VARCHAR2(130), "ENTERED" DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss'), "COUNTRY" VARCHAR2(50), "LANG" VARCHAR2(50), "LOCALE" VARCHAR2(50), "KEYWORDS" VARCHAR2(200), "ORIGINALURLTOKEN" VARCHAR2(130), "QUERY_STRING" VARCHAR2(400), "REFERER" VARCHAR2(255) ) ; -------------------------------------------------------- -- DDL for Table TSETTINGS -------------------------------------------------------- CREATE TABLE "TSETTINGS" ( "SITEID" VARCHAR2(25), "SITE" VARCHAR2(50), "MAXNESTLEVEL" NUMBER(10,0), "PAGELIMIT" NUMBER(10,0), "LOCKING" VARCHAR2(50), "DOMAIN" VARCHAR2(50), "EXPORTLOCATION" VARCHAR2(100), "FILEDIR" VARCHAR2(50), "CONTACT" VARCHAR2(50), "MAILSERVERIP" VARCHAR2(50), "MAILSERVERUSERNAME" VARCHAR2(50), "MAILSERVERPASSWORD" VARCHAR2(50), "EMAILBROADCASTER" NUMBER(10,0), "EXTRANET" NUMBER(10,0), "EXTRANETPUBLICREG" NUMBER(10,0), "EXTRANETPUBLICREGNOTIFY" VARCHAR2(50), "EXTRANETSSL" NUMBER(10,0), "CACHE" NUMBER(10,0), "VIEWDEPTH" NUMBER(10,0), "NEXTN" NUMBER(10,0), "DATACOLLECTION" NUMBER(10,0), "COLUMNCOUNT" NUMBER(10,0), "COLUMNNAMES" VARCHAR2(255), "PRIMARYCOLUMN" NUMBER(10,0), "PUBLICSUBMISSION" NUMBER(10,0), "ADMANAGER" NUMBER(10,0), "ARCHIVEDATE" DATE, "CONTACTNAME" VARCHAR2(50), "CONTACTADDRESS" VARCHAR2(50), "CONTACTCITY" VARCHAR2(50), "CONTACTSTATE" VARCHAR2(50), "CONTACTZIP" VARCHAR2(50), "CONTACTEMAIL" VARCHAR2(50), "CONTACTPHONE" VARCHAR2(50), "PRIVATEUSERPOOLID" VARCHAR2(50), "PUBLICUSERPOOLID" VARCHAR2(50), "ADVERTISERUSERPOOLID" VARCHAR2(50), "ORDERNO" NUMBER(10,0), "EMAILBROADCASTERLIMIT" NUMBER(10,0) DEFAULT '0', "FEEDMANAGER" NUMBER(10,0), "DISPLAYPOOLID" VARCHAR2(50), "GALLERYMAINSCALEBY" VARCHAR2(50), "GALLERYMAINSCALE" NUMBER(10,0), "GALLERYSMALLSCALEBY" VARCHAR2(50), "GALLERYSMALLSCALE" NUMBER(10,0), "GALLERYMEDIUMSCALEBY" VARCHAR2(50), "GALLERYMEDIUMSCALE" NUMBER(10,0), "SENDLOGINSCRIPT" CLOB, "MAILINGLISTCONFIRMSCRIPT" CLOB, "PUBLICSUBMISSIONAPPROVALSCRIPT" CLOB, "REMINDERSCRIPT" CLOB, "LOGINURL" VARCHAR2(255), "EDITPROFILEURL" VARCHAR2(255), "COMMENTAPPROVALDEFAULT" NUMBER(3,0), "DEPLOY" NUMBER(3,0), "LASTDEPLOYMENT" DATE, "ACCOUNTACTIVATIONSCRIPT" CLOB, "GOOGLEAPIKEY" VARCHAR2(100), "USEDEFAULTSMTPSERVER" NUMBER(3,0) ) lob (SENDLOGINSCRIPT, MAILINGLISTCONFIRMSCRIPT, PUBLICSUBMISSIONAPPROVALSCRIPT, REMINDERSCRIPT, ACCOUNTACTIVATIONSCRIPT) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TSYSTEMOBJECTS -------------------------------------------------------- CREATE TABLE "TSYSTEMOBJECTS" ( "OBJECT" VARCHAR2(50), "SITEID" VARCHAR2(25), "NAME" VARCHAR2(50), "ORDERNO" NUMBER(10,0) ) ; -------------------------------------------------------- -- DDL for Table TUSERADDRESSES -------------------------------------------------------- CREATE TABLE "TUSERADDRESSES" ( "ADDRESSID" CHAR(35), "USERID" CHAR(35), "SITEID" VARCHAR2(25), "ADDRESSNAME" VARCHAR2(50), "ADDRESS1" VARCHAR2(50), "ADDRESS2" VARCHAR2(50), "CITY" VARCHAR2(50), "STATE" VARCHAR2(50), "ZIP" VARCHAR2(50), "COUNTRY" VARCHAR2(50), "PHONE" VARCHAR2(50), "FAX" VARCHAR2(50), "ISPRIMARY" NUMBER(3,0), "ADDRESSNOTES" CLOB, "ADDRESSURL" VARCHAR2(200), "LONGITUDE" FLOAT(126), "LATITUDE" FLOAT(126), "ADDRESSEMAIL" VARCHAR2(100), "HOURS" CLOB ) lob (ADDRESSNOTES, HOURS) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TUSERS -------------------------------------------------------- CREATE TABLE "TUSERS" ( "USERID" CHAR(35), "GROUPNAME" VARCHAR2(50), "FNAME" VARCHAR2(50), "LNAME" VARCHAR2(50), "USERNAME" VARCHAR2(50), "PASSWORD" VARCHAR2(50), "PASSWORDCREATED" DATE, "EMAIL" VARCHAR2(50), "COMPANY" VARCHAR2(50), "JOBTITLE" VARCHAR2(50), "MOBILEPHONE" VARCHAR2(50), "WEBSITE" VARCHAR2(255), "TYPE" NUMBER(10,0), "SUBTYPE" VARCHAR2(50), "EXT" NUMBER(10,0), "CONTACTFORM" CLOB, "ADMIN" NUMBER(10,0), "S2" NUMBER(10,0), "LASTLOGIN" DATE, "LASTUPDATE" DATE, "LASTUPDATEBY" VARCHAR2(50), "LASTUPDATEBYID" VARCHAR2(35), "PERM" NUMBER(3,0), "INACTIVE" NUMBER(3,0), "ISPUBLIC" NUMBER(10,0), "SITEID" VARCHAR2(50), "SUBSCRIBE" NUMBER(10,0), "NOTES" CLOB, "DESCRIPTION" CLOB, "INTERESTS" CLOB, "KEEPPRIVATE" NUMBER(3,0), "PHOTOFILEID" VARCHAR2(35), "IMNAME" VARCHAR2(100), "IMSERVICE" VARCHAR2(50), "CREATED" DATE DEFAULT SYSDATE, "REMOTEID" VARCHAR2(35), "TAGS" CLOB ) lob (NOTES,DESCRIPTION,INTERESTS,TAGS) store as (tablespace users); -------------------------------------------------------- -- DDL for Table TUSERSFAVORITES -------------------------------------------------------- CREATE TABLE "TUSERSFAVORITES" ( "FAVORITEID" CHAR(35), "USERID" CHAR(35), "FAVORITENAME" VARCHAR2(100), "TYPE" VARCHAR2(30), "SITEID" VARCHAR2(35), "DATECREATED" DATE DEFAULT SYSDATE, "COLUMNNUMBER" NUMBER(10,0), "ROWNUMBER" NUMBER(10,0), "MAXRSSITEMS" NUMBER(10,0), "FAVORITE" VARCHAR2(400) ) ; -------------------------------------------------------- -- DDL for Table TUSERSINTERESTS -------------------------------------------------------- CREATE TABLE "TUSERSINTERESTS" ( "USERID" CHAR(35), "CATEGORYID" CHAR(35) ) ; -------------------------------------------------------- -- DDL for Table TUSERSMEMB -------------------------------------------------------- CREATE TABLE "TUSERSMEMB" ( "USERID" CHAR(35), "GROUPID" CHAR(35) ) ; -------------------------------------------------------- -- DDL for Table TUSERSTAGS -------------------------------------------------------- CREATE TABLE "TUSERSTAGS" ( "TAGID" NUMBER(10,0), "USERID" CHAR(35), "SITEID" VARCHAR2(25), "TAG" VARCHAR2(100) ) ; -------------------------------------------------------- -- Constraints for Table TADCAMPAIGNS -------------------------------------------------------- ALTER TABLE "TADCAMPAIGNS" ADD CONSTRAINT "PRIMARY_16" PRIMARY KEY ("CAMPAIGNID") ENABLE; ALTER TABLE "TADCAMPAIGNS" MODIFY ("CAMPAIGNID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADCREATIVES -------------------------------------------------------- ALTER TABLE "TADCREATIVES" ADD CONSTRAINT "PRIMARY_9" PRIMARY KEY ("CREATIVEID") ENABLE; ALTER TABLE "TADCREATIVES" MODIFY ("CREATIVEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADIPWHITELIST -------------------------------------------------------- ALTER TABLE "TADIPWHITELIST" MODIFY ("IP" NOT NULL ENABLE); ALTER TABLE "TADIPWHITELIST" MODIFY ("SITEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADPLACEMENTDETAILS -------------------------------------------------------- ALTER TABLE "TADPLACEMENTDETAILS" ADD CONSTRAINT "PRIMARY_10" PRIMARY KEY ("DETAILID") ENABLE; ALTER TABLE "TADPLACEMENTDETAILS" MODIFY ("DETAILID" NOT NULL ENABLE); ALTER TABLE "TADPLACEMENTDETAILS" MODIFY ("PLACEMENTID" NOT NULL ENABLE); ALTER TABLE "TADPLACEMENTDETAILS" MODIFY ("PLACEMENTTYPE" NOT NULL ENABLE); ALTER TABLE "TADPLACEMENTDETAILS" MODIFY ("PLACEMENTVALUE" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADPLACEMENTS -------------------------------------------------------- ALTER TABLE "TADPLACEMENTS" ADD CONSTRAINT "PRIMARY_17" PRIMARY KEY ("PLACEMENTID") ENABLE; ALTER TABLE "TADPLACEMENTS" MODIFY ("PLACEMENTID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADSTATS -------------------------------------------------------- ALTER TABLE "TADSTATS" ADD CONSTRAINT "PRIMARY_32" PRIMARY KEY ("STATID") ENABLE; ALTER TABLE "TADSTATS" MODIFY ("STATID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TADZONES -------------------------------------------------------- ALTER TABLE "TADZONES" ADD CONSTRAINT "PRIMARY_24" PRIMARY KEY ("ADZONEID") ENABLE; ALTER TABLE "TADZONES" MODIFY ("ADZONEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCAPTCHA -------------------------------------------------------- ALTER TABLE "TCAPTCHA" MODIFY ("LETTERID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCLASSEXTEND -------------------------------------------------------- ALTER TABLE "TCLASSEXTEND" ADD CONSTRAINT "PRIMARY_29" PRIMARY KEY ("SUBTYPEID") ENABLE; ALTER TABLE "TCLASSEXTEND" MODIFY ("SUBTYPEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCLASSEXTENDATTRIBUTES -------------------------------------------------------- ALTER TABLE "TCLASSEXTENDATTRIBUTES" ADD CONSTRAINT "PRIMARY" PRIMARY KEY ("ATTRIBUTEID") ENABLE; ALTER TABLE "TCLASSEXTENDATTRIBUTES" MODIFY ("ATTRIBUTEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCLASSEXTENDDATA -------------------------------------------------------- ALTER TABLE "TCLASSEXTENDDATA" ADD CONSTRAINT "PRIMARY_1" PRIMARY KEY ("DATAID") ENABLE; ALTER TABLE "TCLASSEXTENDDATA" MODIFY ("DATAID" NOT NULL ENABLE); ALTER TABLE "TCLASSEXTENDDATA" MODIFY ("BASEID" NOT NULL ENABLE); ALTER TABLE "TCLASSEXTENDDATA" MODIFY ("ATTRIBUTEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCLASSEXTENDDATAUSERACTIVITY -------------------------------------------------------- ALTER TABLE "TCLASSEXTENDDATAUSERACTIVITY" ADD CONSTRAINT "PRIMARY_11" PRIMARY KEY ("DATAID") ENABLE; ALTER TABLE "TCLASSEXTENDDATAUSERACTIVITY" MODIFY ("DATAID" NOT NULL ENABLE); ALTER TABLE "TCLASSEXTENDDATAUSERACTIVITY" MODIFY ("BASEID" NOT NULL ENABLE); ALTER TABLE "TCLASSEXTENDDATAUSERACTIVITY" MODIFY ("ATTRIBUTEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCLASSEXTENDSETS -------------------------------------------------------- ALTER TABLE "TCLASSEXTENDSETS" ADD CONSTRAINT "PRIMARY_34" PRIMARY KEY ("EXTENDSETID") ENABLE; ALTER TABLE "TCLASSEXTENDSETS" MODIFY ("EXTENDSETID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENT -------------------------------------------------------- ALTER TABLE "TCONTENT" ADD CONSTRAINT "PRIMARY_5" PRIMARY KEY ("TCONTENT_ID") ENABLE; ALTER TABLE "TCONTENT" MODIFY ("TCONTENT_ID" NOT NULL ENABLE); ALTER TABLE "TCONTENT" MODIFY ("FORCESSL" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTASSIGNMENTS -------------------------------------------------------- ALTER TABLE "TCONTENTASSIGNMENTS" ADD CONSTRAINT "PRIMARY_30" PRIMARY KEY ("CONTENTID", "CONTENTHISTID", "SITEID", "USERID") ENABLE; ALTER TABLE "TCONTENTASSIGNMENTS" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTASSIGNMENTS" MODIFY ("CONTENTHISTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTASSIGNMENTS" MODIFY ("SITEID" NOT NULL ENABLE); ALTER TABLE "TCONTENTASSIGNMENTS" MODIFY ("USERID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTCATEGORIES -------------------------------------------------------- ALTER TABLE "TCONTENTCATEGORIES" ADD CONSTRAINT "PRIMARY_6" PRIMARY KEY ("CATEGORYID") ENABLE; ALTER TABLE "TCONTENTCATEGORIES" MODIFY ("CATEGORYID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTCATEGORYASSIGN -------------------------------------------------------- ALTER TABLE "TCONTENTCATEGORYASSIGN" ADD CONSTRAINT "PRIMARY_19" PRIMARY KEY ("CONTENTHISTID", "CATEGORYID") ENABLE; ALTER TABLE "TCONTENTCATEGORYASSIGN" MODIFY ("CONTENTHISTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTCATEGORYASSIGN" MODIFY ("CATEGORYID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTCOMMENTS -------------------------------------------------------- ALTER TABLE "TCONTENTCOMMENTS" ADD CONSTRAINT "PRIMARY_12" PRIMARY KEY ("COMMENTID") ENABLE; ALTER TABLE "TCONTENTCOMMENTS" MODIFY ("COMMENTID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTDISPLAYTITLEAPPROVALS -------------------------------------------------------- ALTER TABLE "TCONTENTDISPLAYTITLEAPPROVALS" MODIFY ("CONTENTID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTEVENTREMINDERS -------------------------------------------------------- ALTER TABLE "TCONTENTEVENTREMINDERS" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTEVENTREMINDERS" MODIFY ("SITEID" NOT NULL ENABLE); ALTER TABLE "TCONTENTEVENTREMINDERS" MODIFY ("EMAIL" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTFEEDADVANCEDPARAMS -------------------------------------------------------- ALTER TABLE "TCONTENTFEEDADVANCEDPARAMS" ADD CONSTRAINT "PRIMARY_31" PRIMARY KEY ("PARAMID") ENABLE; ALTER TABLE "TCONTENTFEEDADVANCEDPARAMS" MODIFY ("PARAMID" NOT NULL ENABLE); ALTER TABLE "TCONTENTFEEDADVANCEDPARAMS" MODIFY ("FEEDID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTFEEDITEMS -------------------------------------------------------- ALTER TABLE "TCONTENTFEEDITEMS" MODIFY ("FEEDID" NOT NULL ENABLE); ALTER TABLE "TCONTENTFEEDITEMS" MODIFY ("ITEMID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTFEEDS -------------------------------------------------------- ALTER TABLE "TCONTENTFEEDS" ADD CONSTRAINT "PRIMARY_21" PRIMARY KEY ("FEEDID") ENABLE; ALTER TABLE "TCONTENTFEEDS" MODIFY ("FEEDID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTOBJECTS -------------------------------------------------------- ALTER TABLE "TCONTENTOBJECTS" ADD CONSTRAINT "PRIMARY_27" PRIMARY KEY ("CONTENTHISTID", "OBJECTID", "OBJECT", "COLUMNID") ENABLE; ALTER TABLE "TCONTENTOBJECTS" MODIFY ("CONTENTHISTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTOBJECTS" MODIFY ("OBJECTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTOBJECTS" MODIFY ("OBJECT" NOT NULL ENABLE); ALTER TABLE "TCONTENTOBJECTS" MODIFY ("COLUMNID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTPUBLICSUBMISSIONAPPROV -------------------------------------------------------- ALTER TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" ADD CONSTRAINT "PRIMARY_13" PRIMARY KEY ("CONTENTID", "SITEID") ENABLE; ALTER TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" MODIFY ("ISAPPROVED" NOT NULL ENABLE); ALTER TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" MODIFY ("EMAIL" NOT NULL ENABLE); ALTER TABLE "TCONTENTPUBLICSUBMISSIONAPPROV" MODIFY ("SITEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTRATINGS -------------------------------------------------------- ALTER TABLE "TCONTENTRATINGS" ADD CONSTRAINT "PRIMARY_14" PRIMARY KEY ("CONTENTID", "USERID", "SITEID") ENABLE; ALTER TABLE "TCONTENTRATINGS" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTRATINGS" MODIFY ("USERID" NOT NULL ENABLE); ALTER TABLE "TCONTENTRATINGS" MODIFY ("SITEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTRELATED -------------------------------------------------------- ALTER TABLE "TCONTENTRELATED" ADD CONSTRAINT "PRIMARY_22" PRIMARY KEY ("CONTENTHISTID", "RELATEDID", "CONTENTID", "SITEID") ENABLE; ALTER TABLE "TCONTENTRELATED" MODIFY ("CONTENTHISTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTRELATED" MODIFY ("RELATEDID" NOT NULL ENABLE); ALTER TABLE "TCONTENTRELATED" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTRELATED" MODIFY ("SITEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTSTATS -------------------------------------------------------- ALTER TABLE "TCONTENTSTATS" ADD CONSTRAINT "PRIMARY_23" PRIMARY KEY ("CONTENTID", "SITEID") ENABLE; ALTER TABLE "TCONTENTSTATS" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("SITEID" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("VIEWS" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("RATING" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("TOTALVOTES" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("UPVOTES" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("DOWNVOTES" NOT NULL ENABLE); ALTER TABLE "TCONTENTSTATS" MODIFY ("COMMENTS" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TCONTENTTAGS -------------------------------------------------------- ALTER TABLE "TCONTENTTAGS" ADD CONSTRAINT "PRIMARY_33" PRIMARY KEY ("TAGID") ENABLE; ALTER TABLE "TCONTENTTAGS" MODIFY ("TAGID" NOT NULL ENABLE); ALTER TABLE "TCONTENTTAGS" MODIFY ("CONTENTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTTAGS" MODIFY ("CONTENTHISTID" NOT NULL ENABLE); ALTER TABLE "TCONTENTTAGS" MODIFY ("SITEID" NOT NULL ENABLE); ALTER TABLE "TCONTENTTAGS" MODIFY ("TAG" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TEMAILS -------------------------------------------------------- ALTER TABLE "TEMAILS" ADD CONSTRAINT "PRIMARY_28" PRIMARY KEY ("EMAILID") ENABLE; ALTER TABLE "TEMAILS" MODIFY ("EMAILID" NOT NULL ENABLE); ALTER TABLE "TEMAILS" MODIFY ("NUMBERSENT" NOT NULL ENABLE); ALTER TABLE "TEMAILS" MODIFY ("ISDELETED" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TEMAILSTATS -------------------------------------------------------- ALTER TABLE "TEMAILSTATS" MODIFY ("EMAILOPEN" NOT NULL ENABLE); ALTER TABLE "TEMAILSTATS" MODIFY ("RETURNCLICK" NOT NULL ENABLE); ALTER TABLE "TEMAILSTATS" MODIFY ("BOUNCE" NOT NULL ENABLE); ALTER TABLE "TEMAILSTATS" MODIFY ("SENT" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TFILES -------------------------------------------------------- ALTER TABLE "TFILES" ADD CONSTRAINT "PRIMARY_20" PRIMARY KEY ("FILEID") ENABLE; ALTER TABLE "TFILES" MODIFY ("FILEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TFORMRESPONSEPACKETS -------------------------------------------------------- ALTER TABLE "TFORMRESPONSEPACKETS" ADD CONSTRAINT "PRIMARY_7" PRIMARY KEY ("RESPONSEID") ENABLE; ALTER TABLE "TFORMRESPONSEPACKETS" MODIFY ("RESPONSEID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TMAILINGLISTMEMBERS -------------------------------------------------------- ALTER TABLE "TMAILINGLISTMEMBERS" MODIFY ("ISVERIFIED" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TREDIRECTS -------------------------------------------------------- ALTER TABLE "TREDIRECTS" ADD CONSTRAINT "PRIMARY_15" PRIMARY KEY ("REDIRECTID") ENABLE; ALTER TABLE "TREDIRECTS" MODIFY ("REDIRECTID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TSESSIONTRACKING -------------------------------------------------------- ALTER TABLE "TSESSIONTRACKING" ADD CONSTRAINT "PRIMARY_8" PRIMARY KEY ("TRACKINGID") ENABLE; ALTER TABLE "TSESSIONTRACKING" MODIFY ("TRACKINGID" NOT NULL ENABLE); ALTER TABLE "TSESSIONTRACKING" MODIFY ("URLTOKEN" NOT NULL ENABLE); ALTER TABLE "TSESSIONTRACKING" MODIFY ("ENTERED" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TSETTINGS -------------------------------------------------------- ALTER TABLE "TSETTINGS" MODIFY ("EMAILBROADCASTERLIMIT" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERADDRESSES -------------------------------------------------------- ALTER TABLE "TUSERADDRESSES" ADD CONSTRAINT "PRIMARY_3" PRIMARY KEY ("ADDRESSID") ENABLE; ALTER TABLE "TUSERADDRESSES" MODIFY ("ADDRESSID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERS -------------------------------------------------------- ALTER TABLE "TUSERS" ADD CONSTRAINT "PRIMARY_25" PRIMARY KEY ("USERID") ENABLE; ALTER TABLE "TUSERS" MODIFY ("USERID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERSFAVORITES -------------------------------------------------------- ALTER TABLE "TUSERSFAVORITES" ADD CONSTRAINT "PRIMARY_2" PRIMARY KEY ("FAVORITEID") ENABLE; ALTER TABLE "TUSERSFAVORITES" MODIFY ("FAVORITEID" NOT NULL ENABLE); ALTER TABLE "TUSERSFAVORITES" MODIFY ("USERID" NOT NULL ENABLE); ALTER TABLE "TUSERSFAVORITES" MODIFY ("TYPE" NOT NULL ENABLE); ALTER TABLE "TUSERSFAVORITES" MODIFY ("DATECREATED" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERSINTERESTS -------------------------------------------------------- ALTER TABLE "TUSERSINTERESTS" ADD CONSTRAINT "PRIMARY_26" PRIMARY KEY ("USERID", "CATEGORYID") ENABLE; ALTER TABLE "TUSERSINTERESTS" MODIFY ("USERID" NOT NULL ENABLE); ALTER TABLE "TUSERSINTERESTS" MODIFY ("CATEGORYID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERSMEMB -------------------------------------------------------- ALTER TABLE "TUSERSMEMB" ADD CONSTRAINT "PRIMARY_4" PRIMARY KEY ("USERID", "GROUPID") ENABLE; ALTER TABLE "TUSERSMEMB" MODIFY ("USERID" NOT NULL ENABLE); ALTER TABLE "TUSERSMEMB" MODIFY ("GROUPID" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table TUSERSTAGS -------------------------------------------------------- ALTER TABLE "TUSERSTAGS" ADD CONSTRAINT "PRIMARY_18" PRIMARY KEY ("TAGID") ENABLE; ALTER TABLE "TUSERSTAGS" MODIFY ("TAGID" NOT NULL ENABLE); ALTER TABLE "TUSERSTAGS" MODIFY ("USERID" NOT NULL ENABLE); ALTER TABLE "TUSERSTAGS" MODIFY ("SITEID" NOT NULL ENABLE); ALTER TABLE "TUSERSTAGS" MODIFY ("TAG" NOT NULL ENABLE); -------------------------------------------------------- -- DDL for Index CASELESS_MENUTITLE_INDEX -------------------------------------------------------- CREATE INDEX "CASELESS_MENUTITLE_INDEX" ON "TCONTENT" (NLSSORT("MENUTITLE",'nls_sort=''BINARY_CI''')) ; -------------------------------------------------------- -- DDL for Index CASELESS_TITLE_INDEX -------------------------------------------------------- CREATE INDEX "CASELESS_TITLE_INDEX" ON "TCONTENT" (NLSSORT("TITLE",'nls_sort=''BINARY_CI''')) ; -------------------------------------------------------- -- DDL for Index IDX_ENTERED -------------------------------------------------------- CREATE INDEX "IDX_ENTERED" ON "TCONTENTRATINGS" ("ENTERED") ; -------------------------------------------------------- -- DDL for Index IDX_ENTERED_1 -------------------------------------------------------- CREATE INDEX "IDX_ENTERED_1" ON "TSESSIONTRACKING" ("ENTERED") ; -------------------------------------------------------- -- DDL for Index INDEX_2 -------------------------------------------------------- CREATE INDEX "INDEX_2" ON "TCLASSEXTENDATTRIBUTES" ("EXTENDSETID") ; -------------------------------------------------------- -- DDL for Index INDEX_2_1 -------------------------------------------------------- CREATE INDEX "INDEX_2_1" ON "TCLASSEXTENDDATA" ("BASEID") ; -------------------------------------------------------- -- DDL for Index INDEX_2_2 -------------------------------------------------------- CREATE INDEX "INDEX_2_2" ON "TCLASSEXTENDDATAUSERACTIVITY" ("BASEID") ; -------------------------------------------------------- -- DDL for Index INDEX_2_3 -------------------------------------------------------- CREATE INDEX "INDEX_2_3" ON "TCONTENTTAGS" ("CONTENTHISTID") ; -------------------------------------------------------- -- DDL for Index INDEX_2_4 -------------------------------------------------------- CREATE INDEX "INDEX_2_4" ON "TUSERADDRESSES" ("LONGITUDE") ; -------------------------------------------------------- -- DDL for Index INDEX_2_5 -------------------------------------------------------- CREATE INDEX "INDEX_2_5" ON "TCLASSEXTENDSETS" ("SUBTYPEID") ; -------------------------------------------------------- -- DDL for Index INDEX_2_6 -------------------------------------------------------- CREATE INDEX "INDEX_2_6" ON "TUSERSTAGS" ("USERID") ; -------------------------------------------------------- -- DDL for Index INDEX_3 -------------------------------------------------------- CREATE INDEX "INDEX_3" ON "TCLASSEXTENDDATA" ("ATTRIBUTEID") ; -------------------------------------------------------- -- DDL for Index INDEX_3_1 -------------------------------------------------------- CREATE INDEX "INDEX_3_1" ON "TCONTENTTAGS" ("SITEID") ; -------------------------------------------------------- -- DDL for Index INDEX_3_2 -------------------------------------------------------- CREATE INDEX "INDEX_3_2" ON "TUSERADDRESSES" ("LATITUDE") ; -------------------------------------------------------- -- DDL for Index INDEX_3_3 -------------------------------------------------------- CREATE INDEX "INDEX_3_3" ON "TUSERSTAGS" ("SITEID") ; -------------------------------------------------------- -- DDL for Index INDEX_3_4 -------------------------------------------------------- CREATE INDEX "INDEX_3_4" ON "TCLASSEXTENDDATAUSERACTIVITY" ("ATTRIBUTEID") ; -------------------------------------------------------- -- DDL for Index INDEX_4 -------------------------------------------------------- CREATE INDEX "INDEX_4" ON "TCONTENTTAGS" ("CONTENTID") ; -------------------------------------------------------- -- DDL for Index INDEX_4_1 -------------------------------------------------------- CREATE INDEX "INDEX_4_1" ON "TUSERSTAGS" ("TAG") ; -------------------------------------------------------- -- DDL for Index INDEX_4_2 -------------------------------------------------------- CREATE INDEX "INDEX_4_2" ON "TUSERADDRESSES" ("USERID") ; -------------------------------------------------------- -- DDL for Index INDEX_5 -------------------------------------------------------- CREATE INDEX "INDEX_5" ON "TCONTENTTAGS" ("TAG") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENT -------------------------------------------------------- CREATE INDEX "IX_TCONTENT" ON "TCONTENT" ("CONTENTID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENTCATEGORIES -------------------------------------------------------- CREATE INDEX "IX_TCONTENTCATEGORIES" ON "TCONTENTCATEGORIES" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENTCOMMENTS -------------------------------------------------------- CREATE INDEX "IX_TCONTENTCOMMENTS" ON "TCONTENTCOMMENTS" ("CONTENTID") ; ALTER INDEX "IX_TCONTENTCOMMENTS" UNUSABLE; -------------------------------------------------------- -- DDL for Index IX_TCONTENTFEEDS -------------------------------------------------------- CREATE INDEX "IX_TCONTENTFEEDS" ON "TCONTENTFEEDS" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENTOBJECTS -------------------------------------------------------- CREATE INDEX "IX_TCONTENTOBJECTS" ON "TCONTENTOBJECTS" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENT_1 -------------------------------------------------------- CREATE INDEX "IX_TCONTENT_1" ON "TCONTENT" ("CONTENTHISTID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENT_2 -------------------------------------------------------- CREATE INDEX "IX_TCONTENT_2" ON "TCONTENT" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENT_3 -------------------------------------------------------- CREATE INDEX "IX_TCONTENT_3" ON "TCONTENT" ("PARENTID") ; -------------------------------------------------------- -- DDL for Index IX_TCONTENT_4 -------------------------------------------------------- CREATE INDEX "IX_TCONTENT_4" ON "TCONTENT" ("REMOTEID") ; -------------------------------------------------------- -- DDL for Index IX_TEMAILS -------------------------------------------------------- CREATE INDEX "IX_TEMAILS" ON "TEMAILS" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TFORMRESPONSEPACKETS -------------------------------------------------------- CREATE INDEX "IX_TFORMRESPONSEPACKETS" ON "TFORMRESPONSEPACKETS" ("FORMID", "SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TSESSIONTRACKING -------------------------------------------------------- CREATE INDEX "IX_TSESSIONTRACKING" ON "TSESSIONTRACKING" ("SITEID") ; -------------------------------------------------------- -- DDL for Index IX_TSESSIONTRACKING_1 -------------------------------------------------------- CREATE INDEX "IX_TSESSIONTRACKING_1" ON "TSESSIONTRACKING" ("CONTENTID") ; -------------------------------------------------------- -- DDL for Index IX_TSESSIONTRACKING_2 -------------------------------------------------------- CREATE INDEX "IX_TSESSIONTRACKING_2" ON "TSESSIONTRACKING" ("URLTOKEN") ; -------------------------------------------------------- -- DDL for Index IX_TSESSIONTRACKING_3 -------------------------------------------------------- CREATE INDEX "IX_TSESSIONTRACKING_3" ON "TSESSIONTRACKING" ("USERID") ; -------------------------------------------------------- -- DDL for Package SQL_UTILITIES -------------------------------------------------------- CREATE OR REPLACE PACKAGE "SQL_UTILITIES" AS identity NUMBER(10); END sql_utilities; / -------------------------------------------------------- -- DDL for Trigger TADPLACEMENTDETAILS_DETAILID_T -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TADPLACEMENTDETAILS_DETAILID_T" BEFORE INSERT OR UPDATE ON tadplacementdetails FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.detailID IS NULL THEN SELECT tadplacementdetails_detailID_S.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(detailID) INTO v_newVal FROM tadplacementdetails; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tadplacementdetails_detailID_S.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.detailID := v_newVal; END IF; END; / ALTER TRIGGER "TADPLACEMENTDETAILS_DETAILID_T" ENABLE; -------------------------------------------------------- -- DDL for Trigger TADSTATS_STATID_TRG -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TADSTATS_STATID_TRG" BEFORE INSERT OR UPDATE ON tadstats FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.statID IS NULL THEN SELECT tadstats_statID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(statID) INTO v_newVal FROM tadstats; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tadstats_statID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.statID := v_newVal; END IF; END; / ALTER TRIGGER "TADSTATS_STATID_TRG" ENABLE; -------------------------------------------------------- -- DDL for Trigger TCLASSEXTENDATTRIBUTES_ATTRI_1 -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TCLASSEXTENDATTRIBUTES_ATTRI_1" BEFORE INSERT OR UPDATE ON tclassextendattributes FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.attributeID IS NULL THEN SELECT tclassextendattributes_attribu.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(attributeID) INTO v_newVal FROM tclassextendattributes; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tclassextendattributes_attribu.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.attributeID := v_newVal; END IF; END; / ALTER TRIGGER "TCLASSEXTENDATTRIBUTES_ATTRI_1" ENABLE; -------------------------------------------------------- -- DDL for Trigger TCLASSEXTENDDATAUSERACTIVITY_1 -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TCLASSEXTENDDATAUSERACTIVITY_1" BEFORE INSERT OR UPDATE ON tclassextenddatauseractivity FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.dataID IS NULL THEN SELECT tclassextenddatauseractivity_d.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(dataID) INTO v_newVal FROM tclassextenddatauseractivity; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tclassextenddatauseractivity_d.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.dataID := v_newVal; END IF; END; / ALTER TRIGGER "TCLASSEXTENDDATAUSERACTIVITY_1" ENABLE; -------------------------------------------------------- -- DDL for Trigger TCLASSEXTENDDATA_DATAID_TRG -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TCLASSEXTENDDATA_DATAID_TRG" BEFORE INSERT OR UPDATE ON tclassextenddata FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.dataID IS NULL THEN SELECT tclassextenddata_dataID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(dataID) INTO v_newVal FROM tclassextenddata; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tclassextenddata_dataID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.dataID := v_newVal; END IF; END; / ALTER TRIGGER "TCLASSEXTENDDATA_DATAID_TRG" ENABLE; -------------------------------------------------------- -- DDL for Trigger TCONTENTTAGS_TAGID_TRG -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TCONTENTTAGS_TAGID_TRG" BEFORE INSERT OR UPDATE ON tcontenttags FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.tagID IS NULL THEN SELECT tcontenttags_tagID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(tagID) INTO v_newVal FROM tcontenttags; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tcontenttags_tagID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.tagID := v_newVal; END IF; END; / ALTER TRIGGER "TCONTENTTAGS_TAGID_TRG" ENABLE; -------------------------------------------------------- -- DDL for Trigger TCONTENT_TCONTENT_ID_TRG -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TCONTENT_TCONTENT_ID_TRG" BEFORE INSERT OR UPDATE ON tcontent FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.TContent_ID IS NULL THEN SELECT tcontent_TContent_ID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(TContent_ID) INTO v_newVal FROM tcontent; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tcontent_TContent_ID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.TContent_ID := v_newVal; END IF; END; / ALTER TRIGGER "TCONTENT_TCONTENT_ID_TRG" ENABLE; -------------------------------------------------------- -- DDL for Trigger TSESSIONTRACKING_TRACKINGID_TR -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TSESSIONTRACKING_TRACKINGID_TR" BEFORE INSERT OR UPDATE ON tsessiontracking FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.trackingID IS NULL THEN SELECT tsessiontracking_trackingID_SE.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(trackingID) INTO v_newVal FROM tsessiontracking; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tsessiontracking_trackingID_SE.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.trackingID := v_newVal; END IF; END; / ALTER TRIGGER "TSESSIONTRACKING_TRACKINGID_TR" ENABLE; -------------------------------------------------------- -- DDL for Trigger TUSERSTAGS_TAGID_TRG -------------------------------------------------------- CREATE OR REPLACE TRIGGER "TUSERSTAGS_TAGID_TRG" BEFORE INSERT OR UPDATE ON tuserstags FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.tagID IS NULL THEN SELECT tuserstags_tagID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT max(tagID) INTO v_newVal FROM tuserstags; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT tuserstags_tagID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; -- save this to emulate @@identity sql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.tagID := v_newVal; END IF; END; / ALTER TRIGGER "TUSERSTAGS_TAGID_TRG" ENABLE; --------------------------------------------------- -- DATA FOR TABLE TSETTINGS -- FILTER = none used --------------------------------------------------- REM INSERTING into TSETTINGS Insert into TSETTINGS (SITEID,SITE,MAXNESTLEVEL,PAGELIMIT,LOCKING,DOMAIN,EXPORTLOCATION,FILEDIR,CONTACT,MAILSERVERIP,MAILSERVERUSERNAME,MAILSERVERPASSWORD,EMAILBROADCASTER,EXTRANET,EXTRANETPUBLICREG,EXTRANETPUBLICREGNOTIFY,EXTRANETSSL,CACHE,VIEWDEPTH,NEXTN,DATACOLLECTION,COLUMNCOUNT,COLUMNNAMES,PRIMARYCOLUMN,PUBLICSUBMISSION,ADMANAGER,ARCHIVEDATE,CONTACTNAME,CONTACTADDRESS,CONTACTCITY,CONTACTSTATE,CONTACTZIP,CONTACTEMAIL,CONTACTPHONE,PRIVATEUSERPOOLID,PUBLICUSERPOOLID,ADVERTISERUSERPOOLID,ORDERNO,EMAILBROADCASTERLIMIT,FEEDMANAGER,DISPLAYPOOLID,GALLERYMAINSCALEBY,GALLERYMAINSCALE,GALLERYSMALLSCALEBY,GALLERYSMALLSCALE,GALLERYMEDIUMSCALEBY,GALLERYMEDIUMSCALE,SENDLOGINSCRIPT,MAILINGLISTCONFIRMSCRIPT,PUBLICSUBMISSIONAPPROVALSCRIPT,REMINDERSCRIPT,LOGINURL,EDITPROFILEURL,COMMENTAPPROVALDEFAULT,DEPLOY,LASTDEPLOYMENT,ACCOUNTACTIVATIONSCRIPT,GOOGLEAPIKEY,USEDEFAULTSMTPSERVER) values ('default','Default',null,1000,'none','localhost','export1',null,'info@gosava.com','mail.server.com','dev@studiosquared.com','rogerdarby13',1,1,1,null,0,0,1,20,1,3,'Left Column^Main Content^Right Column',2,0,1,null,null,null,null,null,null,null,null,'default','default','default',1,0,1,'default','y',100,'y',100,'y',100,null,null,null,null,'?display=login','?display=editProfile',0,0,null,null,null,0); --------------------------------------------------- -- END DATA FOR TABLE TSETTINGS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTFEEDADVANCEDPARAMS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTFEEDADVANCEDPARAMS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTFEEDADVANCEDPARAMS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TMAILINGLISTMEMBERS -- FILTER = none used --------------------------------------------------- REM INSERTING into TMAILINGLISTMEMBERS --------------------------------------------------- -- END DATA FOR TABLE TMAILINGLISTMEMBERS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TUSERSTAGS -- FILTER = none used --------------------------------------------------- REM INSERTING into TUSERSTAGS --------------------------------------------------- -- END DATA FOR TABLE TUSERSTAGS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TUSERSFAVORITES -- FILTER = none used --------------------------------------------------- REM INSERTING into TUSERSFAVORITES --------------------------------------------------- -- END DATA FOR TABLE TUSERSFAVORITES --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TSYSTEMOBJECTS -- FILTER = none used --------------------------------------------------- REM INSERTING into TSYSTEMOBJECTS Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('event_reminder_form','default','Event Reminder Form',12); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('forward_email','default','Forward Email',13); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('site_map','default','Site Map',2); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('peer_nav','default','Peer Navigation',3); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('sub_nav','default','Sub Navigation',4); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('standard_nav','default','Standard Navigation',5); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('portal_nav','default','Portal Navigation',6); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('comments','default','Accept Comments',9); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('seq_nav','default','Sequential Nav',8); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('payPalCart','default','PayPal Shopping Cart',14); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('rater','default','Content Rater',16); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('favorites','default','User Favorites',17); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('dragable_feeds','default','Dragable Feeds',18); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('related_content','default','Related Content',19); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('user_tools','default','User Tools',20); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('tag_cloud','default','Tag Cloud',21); Insert into TSYSTEMOBJECTS (OBJECT,SITEID,NAME,ORDERNO) values ('IASiteMap','default','IA Site Map',22); --------------------------------------------------- -- END DATA FOR TABLE TSYSTEMOBJECTS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCLASSEXTENDDATA -- FILTER = none used --------------------------------------------------- REM INSERTING into TCLASSEXTENDDATA --------------------------------------------------- -- END DATA FOR TABLE TCLASSEXTENDDATA --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTFEEDS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTFEEDS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTFEEDS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTEVENTREMINDERS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTEVENTREMINDERS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTEVENTREMINDERS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TEMAILSTATS -- FILTER = none used --------------------------------------------------- REM INSERTING into TEMAILSTATS --------------------------------------------------- -- END DATA FOR TABLE TEMAILSTATS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCAPTCHA -- FILTER = none used --------------------------------------------------- REM INSERTING into TCAPTCHA Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (1,'a','a.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (2,'b','b.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (3,'c','c.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (4,'d','d.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (5,'e','e.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (6,'f','f.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (7,'g','g.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (8,'h','h.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (9,'i','i.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (10,'j','j.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (11,'k','k.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (12,'l','l.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (13,'m','m.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (14,'n','n.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (15,'o','o.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (16,'p','p.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (17,'q','q.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (18,'r','r.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (19,'s','s.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (20,'t','t.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (21,'u','u.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (22,'v','v.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (23,'w','w.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (24,'x','x.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (25,'y','y.gif'); Insert into TCAPTCHA (LETTERID,LETTER,IMAGEFILE) values (26,'z','z.gif'); --------------------------------------------------- -- END DATA FOR TABLE TCAPTCHA --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTASSIGNMENTS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTASSIGNMENTS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTASSIGNMENTS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTDISPLAYTITLEAPPROVALS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTDISPLAYTITLEAPPROVALS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTDISPLAYTITLEAPPROVALS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TEMAILS -- FILTER = none used --------------------------------------------------- REM INSERTING into TEMAILS --------------------------------------------------- -- END DATA FOR TABLE TEMAILS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADPLACEMENTS -- FILTER = none used --------------------------------------------------- REM INSERTING into TADPLACEMENTS --------------------------------------------------- -- END DATA FOR TABLE TADPLACEMENTS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TUSERSINTERESTS -- FILTER = none used --------------------------------------------------- REM INSERTING into TUSERSINTERESTS --------------------------------------------------- -- END DATA FOR TABLE TUSERSINTERESTS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TUSERS -- FILTER = none used --------------------------------------------------- REM INSERTING into TUSERS Insert into TUSERS (USERID,GROUPNAME,FNAME,LNAME,USERNAME,PASSWORD,PASSWORDCREATED,EMAIL,COMPANY,JOBTITLE,MOBILEPHONE,WEBSITE,TYPE,SUBTYPE,EXT,CONTACTFORM,ADMIN,S2,LASTLOGIN,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,PERM,INACTIVE,ISPUBLIC,SITEID,SUBSCRIBE,NOTES,DESCRIPTION,INTERESTS,KEEPPRIVATE,PHOTOFILEID,IMNAME,IMSERVICE,CREATED,REMOTEID,TAGS) values ('22FC551F-FABE-EA01-C6EDD0885DDC1682',null,'Admin','User','admin','21232F297A57A5A743894A0E4A801FC3',to_timestamp('24-SEP-07 04.49.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),'admin@localhost.com',null,null,null,null,2,'Default',null,null,null,1,to_timestamp('02-SEP-08 03.53.59.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-AUG-08 07.03.09.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),'Admin User','22FC551F-FABE-EA01-C6EDD0885DDC1682',0,0,0,'default',0,null,null,null,0,null,null,null,to_timestamp('24-SEP-07 04.49.02.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),null,null); Insert into TUSERS (USERID,GROUPNAME,FNAME,LNAME,USERNAME,PASSWORD,PASSWORDCREATED,EMAIL,COMPANY,JOBTITLE,MOBILEPHONE,WEBSITE,TYPE,SUBTYPE,EXT,CONTACTFORM,ADMIN,S2,LASTLOGIN,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,PERM,INACTIVE,ISPUBLIC,SITEID,SUBSCRIBE,NOTES,DESCRIPTION,INTERESTS,KEEPPRIVATE,PHOTOFILEID,IMNAME,IMSERVICE,CREATED,REMOTEID,TAGS) values ('6300EE15-1320-5CC2-F9F48B9DBBA54D9F','Admin',null,null,null,null,null,null,null,null,null,null,1,'Default',null,null,null,0,null,to_timestamp('24-SEP-07 04.49.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),'System',null,1,0,0,'default',0,null,null,null,0,null,null,null,to_timestamp('24-SEP-07 04.49.02.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),null,null); --------------------------------------------------- -- END DATA FOR TABLE TUSERS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENT -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENT Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (1,'default','00000000000000000000000000000000003','00000000000000000000000000000000END','00000000000000000000000000000000003','6300ED4A-1320-5CC3-F9D6A2D279E386D0',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Components',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (2,'default','00000000000000000000000000000000004','00000000000000000000000000000000END','00000000000000000000000000000000004','6300ED59-1320-5CC3-F9706221E0EFF7A2',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Forms',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (4,'default','00000000000000000000000000000000006','00000000000000000000000000000000END','00000000000000000000000000000000006','6300ED79-1320-5CC3-F92E6325C26664B6',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Advertising',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (5,'default','00000000000000000000000000000000000','00000000000000000000000000000000END','00000000000000000000000000000000000','6300ED88-1320-5CC3-F9E241684D21FEC9',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Site Manager',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (6,'default','00000000000000000000000000000000008','00000000000000000000000000000000END','00000000000000000000000000000000008','6300ED98-1320-5CC3-F9398EB23A57CBD0',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Site Members',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (7,'default','00000000000000000000000000000000005','00000000000000000000000000000000END','00000000000000000000000000000000005','6300EDA8-1320-5CC3-F93DF074187C935E',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Email Broadcaster',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (8,'default','00000000000000000000000000000000009','00000000000000000000000000000000END','00000000000000000000000000000000009','6300EDB7-1320-5CC3-F9D664F38EBBD2D0',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Mailing Lists',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (9,'default','00000000000000000000000000000000010','00000000000000000000000000000000END','00000000000000000000000000000000010','6300EDC7-1320-5CC3-F9DB8034C9626B70',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Categories',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (10,'default','00000000000000000000000000000000011','00000000000000000000000000000000END','00000000000000000000000000000000011','6300EDD6-1320-5CC3-F9625545444B880F',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Content Collections',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (11,'default','00000000000000000000000000000000012','00000000000000000000000000000000END','00000000000000000000000000000000012','6300EDE6-1320-5CC3-F94E2FCEF5DE046D',null,null,null,null,null,null,null,null,'Module','Default',1,null,'Filemanager Manager',null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,null); Insert into TCONTENT (TCONTENT_ID,SITEID,MODULEID,PARENTID,CONTENTID,CONTENTHISTID,REMOTEID,REMOTEURL,REMOTEPUBDATE,REMOTESOURCEURL,REMOTESOURCE,CREDITS,FILEID,TEMPLATE,TYPE,SUBTYPE,ACTIVE,ORDERNO,TITLE,MENUTITLE,SUMMARY,FILENAME,METADESC,METAKEYWORDS,BODY,LASTUPDATE,LASTUPDATEBY,LASTUPDATEBYID,DISPLAYSTART,DISPLAYSTOP,DISPLAY,APPROVED,ISNAV,RESTRICTED,RESTRICTGROUPS,TARGET,TARGETPARAMS,RESPONSECHART,RESPONSEMESSAGE,RESPONSESENDTO,RESPONSEDISPLAYFIELDS,MODULEASSIGN,DISPLAYTITLE,NOTES,INHERITOBJECTS,ISFEATURE,RELEASEDATE,ISLOCKED,NEXTN,SORTBY,SORTDIRECTION,FEATURESTART,FEATURESTOP,FORCESSL,AUDIENCE,KEYPOINTS,SEARCHEXCLUDE,PATH,TAGS) values (201,'default','00000000000000000000000000000000000','00000000000000000000000000000000END','00000000000000000000000000000000001','25D40CD9-07FD-7B66-B7A4514DADB379DD',null,null,null,null,null,null,null,'default.cfm','Page','Default',1,1,'Home Page','Home Page',null,null,null,null,null,to_timestamp('02-SEP-08 06.29.26.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),'Admin User','22FC551F-FABE-EA01-C6EDD0885DDC1682',null,null,1,1,0,0,null,'_self',null,0,null,null,null,null,0,null,'Cascade',0,null,0,10,'orderno','asc',null,null,0,null,null,0,'',null); --------------------------------------------------- -- END DATA FOR TABLE TCONTENT --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TGLOBALS -- FILTER = none used --------------------------------------------------- REM INSERTING into TGLOBALS Insert into TGLOBALS (APPRELOAD,LOADLIST) values (to_timestamp('02-SEP-08 11.18.54.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),null); --------------------------------------------------- -- DATA FOR TABLE TMAILINGLIST -- FILTER = none used --------------------------------------------------- REM INSERTING into TMAILINGLIST Insert into TMAILINGLIST (MLID,SITEID,NAME,DESCRIPTION,LASTUPDATE,ISPURGE,ISPUBLIC) values ('22FC551F-FABE-EA01-C6EDD0885DDC1680','default','Please Remove Me from All Lists','',to_timestamp('24-SEP-07 04.49.00.000000000 PM','DD-MON-RR HH.MI.SS.FF AM'),1,1); --------------------------------------------------- -- END DATA FOR TABLE TMAILINGLIST --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TSESSIONTRACKING -- FILTER = none used --------------------------------------------------- REM INSERTING into TSESSIONTRACKING --------------------------------------------------- -- END DATA FOR TABLE TSESSIONTRACKING --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADSTATS -- FILTER = none used --------------------------------------------------- REM INSERTING into TADSTATS --------------------------------------------------- -- END DATA FOR TABLE TADSTATS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADPLACEMENTDETAILS -- FILTER = none used --------------------------------------------------- REM INSERTING into TADPLACEMENTDETAILS --------------------------------------------------- -- END DATA FOR TABLE TADPLACEMENTDETAILS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TFORMRESPONSEQUESTIONS -- FILTER = none used --------------------------------------------------- REM INSERTING into TFORMRESPONSEQUESTIONS --------------------------------------------------- -- END DATA FOR TABLE TFORMRESPONSEQUESTIONS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TUSERSMEMB -- FILTER = none used --------------------------------------------------- REM INSERTING into TUSERSMEMB --------------------------------------------------- -- END DATA FOR TABLE TUSERSMEMB --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTTAGS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTTAGS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTTAGS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADZONES -- FILTER = none used --------------------------------------------------- REM INSERTING into TADZONES --------------------------------------------------- -- END DATA FOR TABLE TADZONES --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTRATINGS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTRATINGS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTRATINGS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TFORMRESPONSEPACKETS -- FILTER = none used --------------------------------------------------- REM INSERTING into TFORMRESPONSEPACKETS --------------------------------------------------- -- END DATA FOR TABLE TFORMRESPONSEPACKETS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTFEEDITEMS -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTFEEDITEMS --------------------------------------------------- -- END DATA FOR TABLE TCONTENTFEEDITEMS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADIPWHITELIST -- FILTER = none used --------------------------------------------------- REM INSERTING into TADIPWHITELIST --------------------------------------------------- -- END DATA FOR TABLE TADIPWHITELIST --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TEMAILRETURNSTATS -- FILTER = none used --------------------------------------------------- REM INSERTING into TEMAILRETURNSTATS --------------------------------------------------- -- END DATA FOR TABLE TEMAILRETURNSTATS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTCATEGORIES -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTCATEGORIES --------------------------------------------------- -- END DATA FOR TABLE TCONTENTCATEGORIES --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TADCAMPAIGNS -- FILTER = none used --------------------------------------------------- REM INSERTING into TADCAMPAIGNS --------------------------------------------------- -- END DATA FOR TABLE TADCAMPAIGNS --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTRELATED -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTRELATED --------------------------------------------------- -- END DATA FOR TABLE TCONTENTRELATED --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTPUBLICSUBMISSIONAPPROV -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTPUBLICSUBMISSIONAPPROV --------------------------------------------------- -- END DATA FOR TABLE TCONTENTPUBLICSUBMISSIONAPPROV --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE TCONTENTCATEGORYASSIGN -- FILTER = none used --------------------------------------------------- REM INSERTING into TCONTENTCATEGORYASSIGN --------------------------------------------------- -- END DATA FOR TABLE TCONTENTCATEGORYASSIGN --------------------------------------------------- COMMIT;