Last active
December 12, 2016 07:21
-
-
Save punkmonday/cfbeaf129f13112e59e6d0e1404745e3 to your computer and use it in GitHub Desktop.
Scripts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| registry=https://registry.npm.taobao.org | |
| prefix=C:/Users/w4u/.npm-packages |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| call mvn archetype:generate -DgroupId=au.com.w4u -DartifactId=au.com.w4u.demo.jsf.portlet -DarchetypeGroupId=com.liferay.faces.archetype -DarchetypeArtifactId=com.liferay.faces.archetype.jsf.portlet -DarchetypeVersion=5.0.0 -DinteractiveMode=false | |
| call mvn archetype:generate -DgroupId=au.com.w4u -DartifactId=au.com.w4u.demo.alloy.portlet -DarchetypeGroupId=com.liferay.faces.archetype -DarchetypeArtifactId=com.liferay.faces.archetype.alloy.portlet -DarchetypeVersion=5.0.0 -DinteractiveMode=false | |
| call mvn archetype:generate -DgroupId=au.com.w4u -DartifactId=au.com.w4u.demo.primefaces.portlet -DarchetypeGroupId=com.liferay.faces.archetype -DarchetypeArtifactId=com.liferay.faces.archetype.primefaces.portlet -DarchetypeVersion=5.0.0 -DinteractiveMode=false | |
| call mvn archetype:generate -DgroupId=au.com.w4u -DartifactId=au.com.w4u.demo.icefaces.portlet -DarchetypeGroupId=com.liferay.faces.archetype -DarchetypeArtifactId=com.liferay.faces.archetype.icefaces.portlet -DarchetypeVersion=5.0.0 -DinteractiveMode=false | |
| call mvn archetype:generate -DgroupId=au.com.w4u -DartifactId=au.com.w4u.demo.richfaces.portlet -DarchetypeGroupId=com.liferay.faces.archetype -DarchetypeArtifactId=com.liferay.faces.archetype.richfaces.portlet -DarchetypeVersion=5.0.0 -DinteractiveMode=false |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| bamboo | |
| project会建立一个目录 | |
| stage也会建立一个目录 | |
| job会同时一起运行,无法建立顺序执行(在同一个目录) | |
| task会顺序执行 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://kinolien.github.io/gitzip/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET DATABASE UNIQUE NAME HSQLDB56592CA891 | |
| SET DATABASE GC 0 | |
| SET DATABASE DEFAULT RESULT MEMORY ROWS 0 | |
| SET DATABASE EVENT LOG LEVEL 0 | |
| SET DATABASE TRANSACTION CONTROL LOCKS | |
| SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED | |
| SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE | |
| SET DATABASE TEXT TABLE DEFAULTS '' | |
| SET DATABASE SQL NAMES FALSE | |
| SET DATABASE SQL REFERENCES FALSE | |
| SET DATABASE SQL SIZE TRUE | |
| SET DATABASE SQL TYPES FALSE | |
| SET DATABASE SQL TDC DELETE TRUE | |
| SET DATABASE SQL TDC UPDATE TRUE | |
| SET DATABASE SQL TRANSLATE TTI TYPES TRUE | |
| SET DATABASE SQL CONCAT NULLS TRUE | |
| SET DATABASE SQL UNIQUE NULLS TRUE | |
| SET DATABASE SQL CONVERT TRUNCATE TRUE | |
| SET DATABASE SQL AVG SCALE 0 | |
| SET DATABASE SQL DOUBLE NAN TRUE | |
| SET FILES WRITE DELAY 0 | |
| SET FILES BACKUP INCREMENT TRUE | |
| SET FILES CACHE SIZE 10000 | |
| SET FILES CACHE ROWS 50000 | |
| SET FILES SCALE 32 | |
| SET FILES LOB SCALE 32 | |
| SET FILES DEFRAG 0 | |
| SET FILES NIO TRUE | |
| SET FILES NIO SIZE 256 | |
| SET FILES LOG TRUE | |
| SET FILES LOG SIZE 50 | |
| CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' | |
| ALTER USER SA SET LOCAL TRUE | |
| CREATE SCHEMA PUBLIC AUTHORIZATION DBA | |
| SET SCHEMA PUBLIC | |
| CREATE MEMORY TABLE PUBLIC.ACCOUNT_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,ACCOUNTID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PARENTACCOUNTID BIGINT,NAME VARCHAR(75),LEGALNAME VARCHAR(75),LEGALID VARCHAR(75),LEGALTYPE VARCHAR(75),SICCODE VARCHAR(75),TICKERSYMBOL VARCHAR(75),INDUSTRY VARCHAR(75),TYPE_ VARCHAR(75),SIZE_ VARCHAR(75)) | |
| CREATE MEMORY TABLE PUBLIC.ADDRESS(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),ADDRESSID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,STREET1 VARCHAR(75),STREET2 VARCHAR(75),STREET3 VARCHAR(75),CITY VARCHAR(75),ZIP VARCHAR(75),REGIONID BIGINT,COUNTRYID BIGINT,TYPEID BIGINT,MAILING BIT(1),PRIMARY_ BIT(1)) | |
| CREATE INDEX IX_923BD178 ON PUBLIC.ADDRESS(COMPANYID,CLASSNAMEID,CLASSPK,MAILING) | |
| CREATE INDEX IX_9226DBB4 ON PUBLIC.ADDRESS(COMPANYID,CLASSNAMEID,CLASSPK,PRIMARY_) | |
| CREATE INDEX IX_5BC8B0D4 ON PUBLIC.ADDRESS(USERID) | |
| CREATE INDEX IX_8FCB620E ON PUBLIC.ADDRESS(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.ANNOUNCEMENTSDELIVERY(DELIVERYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,TYPE_ VARCHAR(75),EMAIL BIT(1),SMS BIT(1),WEBSITE BIT(1)) | |
| CREATE UNIQUE INDEX IX_BA4413D5 ON PUBLIC.ANNOUNCEMENTSDELIVERY(USERID,TYPE_) | |
| CREATE MEMORY TABLE PUBLIC.ANNOUNCEMENTSENTRY(UUID_ VARCHAR(75),ENTRYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,TITLE VARCHAR(75),CONTENT VARCHAR(16777216),URL VARCHAR(16777216),TYPE_ VARCHAR(75),DISPLAYDATE TIMESTAMP,EXPIRATIONDATE TIMESTAMP,PRIORITY INTEGER,ALERT BIT(1)) | |
| CREATE INDEX IX_14F06A6B ON PUBLIC.ANNOUNCEMENTSENTRY(CLASSNAMEID,CLASSPK,ALERT) | |
| CREATE INDEX IX_D49C2E66 ON PUBLIC.ANNOUNCEMENTSENTRY(USERID) | |
| CREATE INDEX IX_F2949120 ON PUBLIC.ANNOUNCEMENTSENTRY(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.ANNOUNCEMENTSFLAG(FLAGID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,CREATEDATE TIMESTAMP,ENTRYID BIGINT,VALUE INTEGER) | |
| CREATE INDEX IX_9C7EB9F ON PUBLIC.ANNOUNCEMENTSFLAG(ENTRYID) | |
| CREATE UNIQUE INDEX IX_4539A99C ON PUBLIC.ANNOUNCEMENTSFLAG(USERID,ENTRYID,VALUE) | |
| CREATE MEMORY TABLE PUBLIC.ASSETCATEGORY(UUID_ VARCHAR(75),CATEGORYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PARENTCATEGORYID BIGINT,LEFTCATEGORYID BIGINT,RIGHTCATEGORYID BIGINT,NAME VARCHAR(75),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),VOCABULARYID BIGINT,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_C7F39FCA ON PUBLIC.ASSETCATEGORY(GROUPID,NAME,VOCABULARYID) | |
| CREATE INDEX IX_852EA801 ON PUBLIC.ASSETCATEGORY(GROUPID,PARENTCATEGORYID,NAME,VOCABULARYID) | |
| CREATE INDEX IX_87603842 ON PUBLIC.ASSETCATEGORY(GROUPID,PARENTCATEGORYID,VOCABULARYID) | |
| CREATE INDEX IX_2008FACB ON PUBLIC.ASSETCATEGORY(GROUPID,VOCABULARYID) | |
| CREATE INDEX IX_D61ABE08 ON PUBLIC.ASSETCATEGORY(NAME,VOCABULARYID) | |
| CREATE UNIQUE INDEX IX_BE4DF2BF ON PUBLIC.ASSETCATEGORY(PARENTCATEGORYID,NAME,VOCABULARYID) | |
| CREATE INDEX IX_B185E980 ON PUBLIC.ASSETCATEGORY(PARENTCATEGORYID,VOCABULARYID) | |
| CREATE INDEX IX_BBAF6928 ON PUBLIC.ASSETCATEGORY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_E8D019AA ON PUBLIC.ASSETCATEGORY(UUID_,GROUPID) | |
| CREATE INDEX IX_287B1F89 ON PUBLIC.ASSETCATEGORY(VOCABULARYID) | |
| CREATE MEMORY TABLE PUBLIC.ASSETCATEGORYPROPERTY(CATEGORYPROPERTYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CATEGORYID BIGINT,KEY_ VARCHAR(75),VALUE VARCHAR(75)) | |
| CREATE UNIQUE INDEX IX_DBD111AA ON PUBLIC.ASSETCATEGORYPROPERTY(CATEGORYID,KEY_) | |
| CREATE INDEX IX_52340033 ON PUBLIC.ASSETCATEGORYPROPERTY(COMPANYID,KEY_) | |
| CREATE MEMORY TABLE PUBLIC.ASSETENTRIES_ASSETCATEGORIES(COMPANYID BIGINT NOT NULL,CATEGORYID BIGINT NOT NULL,ENTRYID BIGINT NOT NULL,PRIMARY KEY(CATEGORYID,ENTRYID)) | |
| CREATE INDEX IX_A188F560 ON PUBLIC.ASSETENTRIES_ASSETCATEGORIES(CATEGORYID) | |
| CREATE INDEX IX_38A65B55 ON PUBLIC.ASSETENTRIES_ASSETCATEGORIES(COMPANYID) | |
| CREATE INDEX IX_E119938A ON PUBLIC.ASSETENTRIES_ASSETCATEGORIES(ENTRYID) | |
| CREATE MEMORY TABLE PUBLIC.ASSETENTRIES_ASSETTAGS(COMPANYID BIGINT NOT NULL,ENTRYID BIGINT NOT NULL,TAGID BIGINT NOT NULL,PRIMARY KEY(ENTRYID,TAGID)) | |
| CREATE INDEX IX_112337B8 ON PUBLIC.ASSETENTRIES_ASSETTAGS(COMPANYID) | |
| CREATE INDEX IX_2ED82CAD ON PUBLIC.ASSETENTRIES_ASSETTAGS(ENTRYID) | |
| CREATE INDEX IX_B2A61B55 ON PUBLIC.ASSETENTRIES_ASSETTAGS(TAGID) | |
| CREATE MEMORY TABLE PUBLIC.ASSETENTRY(ENTRYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,CLASSUUID VARCHAR(75),CLASSTYPEID BIGINT,LISTABLE BIT(1),VISIBLE BIT(1),STARTDATE TIMESTAMP,ENDDATE TIMESTAMP,PUBLISHDATE TIMESTAMP,EXPIRATIONDATE TIMESTAMP,MIMETYPE VARCHAR(75),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),SUMMARY VARCHAR(16777216),URL VARCHAR(16777216),LAYOUTUUID VARCHAR(75),HEIGHT INTEGER,WIDTH INTEGER,PRIORITY DOUBLE,VIEWCOUNT INTEGER) | |
| CREATE UNIQUE INDEX IX_1E9D371D ON PUBLIC.ASSETENTRY(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_7306C60 ON PUBLIC.ASSETENTRY(COMPANYID) | |
| CREATE INDEX IX_75D42FF9 ON PUBLIC.ASSETENTRY(EXPIRATIONDATE) | |
| CREATE INDEX IX_1EBA6821 ON PUBLIC.ASSETENTRY(GROUPID,CLASSUUID) | |
| CREATE INDEX IX_FEC4A201 ON PUBLIC.ASSETENTRY(LAYOUTUUID) | |
| CREATE INDEX IX_2E4E3885 ON PUBLIC.ASSETENTRY(PUBLISHDATE) | |
| CREATE INDEX IX_9029E15A ON PUBLIC.ASSETENTRY(VISIBLE) | |
| CREATE MEMORY TABLE PUBLIC.ASSETLINK(LINKID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,ENTRYID1 BIGINT,ENTRYID2 BIGINT,TYPE_ INTEGER,WEIGHT INTEGER) | |
| CREATE UNIQUE INDEX IX_8F542794 ON PUBLIC.ASSETLINK(ENTRYID1,ENTRYID2,TYPE_) | |
| CREATE INDEX IX_14D5A20D ON PUBLIC.ASSETLINK(ENTRYID1,TYPE_) | |
| CREATE INDEX IX_91F132C ON PUBLIC.ASSETLINK(ENTRYID2,TYPE_) | |
| CREATE MEMORY TABLE PUBLIC.ASSETTAG(UUID_ VARCHAR(75),TAGID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(75),ASSETCOUNT INTEGER,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_D63322F9 ON PUBLIC.ASSETTAG(GROUPID,NAME) | |
| CREATE INDEX IX_84C501E4 ON PUBLIC.ASSETTAG(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_B6ACB166 ON PUBLIC.ASSETTAG(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.ASSETTAGSTATS(TAGSTATSID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,TAGID BIGINT,CLASSNAMEID BIGINT,ASSETCOUNT INTEGER) | |
| CREATE INDEX IX_50702693 ON PUBLIC.ASSETTAGSTATS(CLASSNAMEID) | |
| CREATE UNIQUE INDEX IX_56682CC4 ON PUBLIC.ASSETTAGSTATS(TAGID,CLASSNAMEID) | |
| CREATE MEMORY TABLE PUBLIC.ASSETVOCABULARY(UUID_ VARCHAR(75),VOCABULARYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(75),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),SETTINGS_ VARCHAR(16777216),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_B22D908C ON PUBLIC.ASSETVOCABULARY(COMPANYID) | |
| CREATE UNIQUE INDEX IX_C0AAD74D ON PUBLIC.ASSETVOCABULARY(GROUPID,NAME) | |
| CREATE INDEX IX_C4E6FD10 ON PUBLIC.ASSETVOCABULARY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_1B2B8792 ON PUBLIC.ASSETVOCABULARY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.BLOGSENTRY(UUID_ VARCHAR(75),ENTRYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,TITLE VARCHAR(150),SUBTITLE VARCHAR(16777216),URLTITLE VARCHAR(150),DESCRIPTION VARCHAR(16777216),CONTENT VARCHAR(16777216),DISPLAYDATE TIMESTAMP,ALLOWPINGBACKS BIT(1),ALLOWTRACKBACKS BIT(1),TRACKBACKS VARCHAR(16777216),COVERIMAGECAPTION VARCHAR(16777216),COVERIMAGEFILEENTRYID BIGINT,COVERIMAGEURL VARCHAR(16777216),SMALLIMAGE BIT(1),SMALLIMAGEFILEENTRYID BIGINT,SMALLIMAGEID BIGINT,SMALLIMAGEURL VARCHAR(16777216),LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_BB0C2905 ON PUBLIC.BLOGSENTRY(COMPANYID,DISPLAYDATE,STATUS) | |
| CREATE INDEX IX_EB2DCE27 ON PUBLIC.BLOGSENTRY(COMPANYID,STATUS) | |
| CREATE INDEX IX_A5F57B61 ON PUBLIC.BLOGSENTRY(COMPANYID,USERID,STATUS) | |
| CREATE INDEX IX_2672F77F ON PUBLIC.BLOGSENTRY(DISPLAYDATE,STATUS) | |
| CREATE INDEX IX_F0E73383 ON PUBLIC.BLOGSENTRY(GROUPID,DISPLAYDATE,STATUS) | |
| CREATE INDEX IX_1EFD8EE9 ON PUBLIC.BLOGSENTRY(GROUPID,STATUS) | |
| CREATE UNIQUE INDEX IX_DB780A20 ON PUBLIC.BLOGSENTRY(GROUPID,URLTITLE) | |
| CREATE INDEX IX_DA04F689 ON PUBLIC.BLOGSENTRY(GROUPID,USERID,DISPLAYDATE,STATUS) | |
| CREATE INDEX IX_49E15A23 ON PUBLIC.BLOGSENTRY(GROUPID,USERID,STATUS) | |
| CREATE INDEX IX_5E8307BB ON PUBLIC.BLOGSENTRY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_1B1040FD ON PUBLIC.BLOGSENTRY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.BLOGSSTATSUSER(STATSUSERID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,ENTRYCOUNT INTEGER,LASTPOSTDATE TIMESTAMP,RATINGSTOTALENTRIES INTEGER,RATINGSTOTALSCORE DOUBLE,RATINGSAVERAGESCORE DOUBLE) | |
| CREATE INDEX IX_90CDA39A ON PUBLIC.BLOGSSTATSUSER(COMPANYID,ENTRYCOUNT) | |
| CREATE INDEX IX_28C78D5C ON PUBLIC.BLOGSSTATSUSER(GROUPID,ENTRYCOUNT) | |
| CREATE UNIQUE INDEX IX_82254C25 ON PUBLIC.BLOGSSTATSUSER(GROUPID,USERID) | |
| CREATE INDEX IX_507BA031 ON PUBLIC.BLOGSSTATSUSER(USERID,LASTPOSTDATE) | |
| CREATE MEMORY TABLE PUBLIC.BROWSERTRACKER(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,BROWSERTRACKERID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,BROWSERKEY BIGINT) | |
| CREATE UNIQUE INDEX IX_E7B95510 ON PUBLIC.BROWSERTRACKER(USERID) | |
| CREATE MEMORY TABLE PUBLIC.CLASSNAME_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,CLASSNAMEID BIGINT NOT NULL PRIMARY KEY,VALUE VARCHAR(200)) | |
| CREATE UNIQUE INDEX IX_B27A301F ON PUBLIC.CLASSNAME_(VALUE) | |
| CREATE MEMORY TABLE PUBLIC.CLUSTERGROUP(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,CLUSTERGROUPID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(75),CLUSTERNODEIDS VARCHAR(75),WHOLECLUSTER BIT(1)) | |
| CREATE MEMORY TABLE PUBLIC.COMPANY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,COMPANYID BIGINT NOT NULL PRIMARY KEY,ACCOUNTID BIGINT,WEBID VARCHAR(75),KEY_ VARCHAR(16777216),MX VARCHAR(75),HOMEURL VARCHAR(16777216),LOGOID BIGINT,SYSTEM BIT(1),MAXUSERS INTEGER,ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_38EFE3FD ON PUBLIC.COMPANY(LOGOID) | |
| CREATE INDEX IX_12566EC2 ON PUBLIC.COMPANY(MX) | |
| CREATE INDEX IX_35E3E7C6 ON PUBLIC.COMPANY(SYSTEM) | |
| CREATE UNIQUE INDEX IX_EC00543C ON PUBLIC.COMPANY(WEBID) | |
| CREATE MEMORY TABLE PUBLIC.CONTACT_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,CONTACTID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,ACCOUNTID BIGINT,PARENTCONTACTID BIGINT,EMAILADDRESS VARCHAR(75),FIRSTNAME VARCHAR(75),MIDDLENAME VARCHAR(75),LASTNAME VARCHAR(75),PREFIXID BIGINT,SUFFIXID BIGINT,MALE BIT(1),BIRTHDAY TIMESTAMP,SMSSN VARCHAR(75),FACEBOOKSN VARCHAR(75),JABBERSN VARCHAR(75),SKYPESN VARCHAR(75),TWITTERSN VARCHAR(75),EMPLOYEESTATUSID VARCHAR(75),EMPLOYEENUMBER VARCHAR(75),JOBTITLE VARCHAR(100),JOBCLASS VARCHAR(75),HOURSOFOPERATION VARCHAR(75)) | |
| CREATE INDEX IX_B8C28C53 ON PUBLIC.CONTACT_(ACCOUNTID) | |
| CREATE INDEX IX_791914FA ON PUBLIC.CONTACT_(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_66D496A3 ON PUBLIC.CONTACT_(COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.COUNTER(NAME VARCHAR(75) NOT NULL PRIMARY KEY,CURRENTID BIGINT) | |
| CREATE MEMORY TABLE PUBLIC.COUNTRY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,COUNTRYID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(75),A2 VARCHAR(75),A3 VARCHAR(75),NUMBER_ VARCHAR(75),IDD_ VARCHAR(75),ZIPREQUIRED BIT(1),ACTIVE_ BIT(1)) | |
| CREATE UNIQUE INDEX IX_717B97E1 ON PUBLIC.COUNTRY(A2) | |
| CREATE UNIQUE INDEX IX_717B9BA2 ON PUBLIC.COUNTRY(A3) | |
| CREATE INDEX IX_25D734CD ON PUBLIC.COUNTRY(ACTIVE_) | |
| CREATE UNIQUE INDEX IX_19DA007B ON PUBLIC.COUNTRY(NAME) | |
| CREATE MEMORY TABLE PUBLIC.DLCONTENT(CONTENTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,REPOSITORYID BIGINT,PATH_ VARCHAR(255),VERSION VARCHAR(75),DATA_ BLOB(1G),SIZE_ BIGINT) | |
| CREATE UNIQUE INDEX IX_FDD1AAA8 ON PUBLIC.DLCONTENT(COMPANYID,REPOSITORYID,PATH_,VERSION) | |
| CREATE MEMORY TABLE PUBLIC.DLFILEENTRY(UUID_ VARCHAR(75),FILEENTRYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,REPOSITORYID BIGINT,FOLDERID BIGINT,TREEPATH VARCHAR(16777216),NAME VARCHAR(255),FILENAME VARCHAR(255),EXTENSION VARCHAR(75),MIMETYPE VARCHAR(75),TITLE VARCHAR(255),DESCRIPTION VARCHAR(16777216),EXTRASETTINGS VARCHAR(16777216),FILEENTRYTYPEID BIGINT,VERSION VARCHAR(75),SIZE_ BIGINT,READCOUNT INTEGER,SMALLIMAGEID BIGINT,LARGEIMAGEID BIGINT,CUSTOM1IMAGEID BIGINT,CUSTOM2IMAGEID BIGINT,MANUALCHECKINREQUIRED BIT(1),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_5444C427 ON PUBLIC.DLFILEENTRY(COMPANYID,FILEENTRYTYPEID) | |
| CREATE INDEX IX_772ECDE7 ON PUBLIC.DLFILEENTRY(FILEENTRYTYPEID) | |
| CREATE INDEX IX_8F6C75D0 ON PUBLIC.DLFILEENTRY(FOLDERID,NAME) | |
| CREATE INDEX IX_BAF654E5 ON PUBLIC.DLFILEENTRY(GROUPID,FILEENTRYTYPEID) | |
| CREATE INDEX IX_29D0AF28 ON PUBLIC.DLFILEENTRY(GROUPID,FOLDERID,FILEENTRYTYPEID) | |
| CREATE UNIQUE INDEX IX_DF37D92E ON PUBLIC.DLFILEENTRY(GROUPID,FOLDERID,FILENAME) | |
| CREATE UNIQUE INDEX IX_5391712 ON PUBLIC.DLFILEENTRY(GROUPID,FOLDERID,NAME) | |
| CREATE UNIQUE INDEX IX_ED5CA615 ON PUBLIC.DLFILEENTRY(GROUPID,FOLDERID,TITLE) | |
| CREATE INDEX IX_D20C434D ON PUBLIC.DLFILEENTRY(GROUPID,USERID,FOLDERID) | |
| CREATE INDEX IX_D9492CF6 ON PUBLIC.DLFILEENTRY(MIMETYPE) | |
| CREATE INDEX IX_1B352F4A ON PUBLIC.DLFILEENTRY(REPOSITORYID,FOLDERID) | |
| CREATE INDEX IX_25F5CAB9 ON PUBLIC.DLFILEENTRY(SMALLIMAGEID,LARGEIMAGEID,CUSTOM1IMAGEID,CUSTOM2IMAGEID) | |
| CREATE INDEX IX_31079DE8 ON PUBLIC.DLFILEENTRY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_BC2E7E6A ON PUBLIC.DLFILEENTRY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILEENTRYMETADATA(UUID_ VARCHAR(75),FILEENTRYMETADATAID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,DDMSTORAGEID BIGINT,DDMSTRUCTUREID BIGINT,FILEENTRYID BIGINT,FILEVERSIONID BIGINT) | |
| CREATE UNIQUE INDEX IX_7332B44F ON PUBLIC.DLFILEENTRYMETADATA(DDMSTRUCTUREID,FILEVERSIONID) | |
| CREATE INDEX IX_4F40FE5E ON PUBLIC.DLFILEENTRYMETADATA(FILEENTRYID) | |
| CREATE INDEX IX_1FE9C04 ON PUBLIC.DLFILEENTRYMETADATA(FILEVERSIONID) | |
| CREATE INDEX IX_E69431B7 ON PUBLIC.DLFILEENTRYMETADATA(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILEENTRYTYPE(UUID_ VARCHAR(75),FILEENTRYTYPEID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,FILEENTRYTYPEKEY VARCHAR(75),NAME VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_5B6BEF5F ON PUBLIC.DLFILEENTRYTYPE(GROUPID,FILEENTRYTYPEKEY) | |
| CREATE INDEX IX_5B03E942 ON PUBLIC.DLFILEENTRYTYPE(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_1399D844 ON PUBLIC.DLFILEENTRYTYPE(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILEENTRYTYPES_DLFOLDERS(COMPANYID BIGINT NOT NULL,FILEENTRYTYPEID BIGINT NOT NULL,FOLDERID BIGINT NOT NULL,PRIMARY KEY(FILEENTRYTYPEID,FOLDERID)) | |
| CREATE INDEX IX_2E64D9F9 ON PUBLIC.DLFILEENTRYTYPES_DLFOLDERS(COMPANYID) | |
| CREATE INDEX IX_5BB6AD6C ON PUBLIC.DLFILEENTRYTYPES_DLFOLDERS(FILEENTRYTYPEID) | |
| CREATE INDEX IX_6E00A2EC ON PUBLIC.DLFILEENTRYTYPES_DLFOLDERS(FOLDERID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILERANK(FILERANKID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE TIMESTAMP,FILEENTRYID BIGINT,ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_38F0315 ON PUBLIC.DLFILERANK(COMPANYID,USERID,FILEENTRYID) | |
| CREATE INDEX IX_A65A1F8B ON PUBLIC.DLFILERANK(FILEENTRYID) | |
| CREATE INDEX IX_4E96195B ON PUBLIC.DLFILERANK(GROUPID,USERID,ACTIVE_) | |
| CREATE INDEX IX_EED06670 ON PUBLIC.DLFILERANK(USERID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILESHORTCUT(UUID_ VARCHAR(75),FILESHORTCUTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,REPOSITORYID BIGINT,FOLDERID BIGINT,TOFILEENTRYID BIGINT,TREEPATH VARCHAR(16777216),ACTIVE_ BIT(1),LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_8571953E ON PUBLIC.DLFILESHORTCUT(COMPANYID,STATUS) | |
| CREATE INDEX IX_17EE3098 ON PUBLIC.DLFILESHORTCUT(GROUPID,FOLDERID,ACTIVE_,STATUS) | |
| CREATE INDEX IX_4B7247F6 ON PUBLIC.DLFILESHORTCUT(TOFILEENTRYID) | |
| CREATE INDEX IX_29AE81C4 ON PUBLIC.DLFILESHORTCUT(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_FDB4A946 ON PUBLIC.DLFILESHORTCUT(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.DLFILEVERSION(UUID_ VARCHAR(75),FILEVERSIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,REPOSITORYID BIGINT,FOLDERID BIGINT,FILEENTRYID BIGINT,TREEPATH VARCHAR(16777216),FILENAME VARCHAR(255),EXTENSION VARCHAR(75),MIMETYPE VARCHAR(75),TITLE VARCHAR(255),DESCRIPTION VARCHAR(16777216),CHANGELOG VARCHAR(75),EXTRASETTINGS VARCHAR(16777216),FILEENTRYTYPEID BIGINT,VERSION VARCHAR(75),SIZE_ BIGINT,CHECKSUM VARCHAR(75),LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_A0A283F4 ON PUBLIC.DLFILEVERSION(COMPANYID,STATUS) | |
| CREATE INDEX IX_D47BB14D ON PUBLIC.DLFILEVERSION(FILEENTRYID,STATUS) | |
| CREATE UNIQUE INDEX IX_E2815081 ON PUBLIC.DLFILEVERSION(FILEENTRYID,VERSION) | |
| CREATE INDEX IX_DFD809D3 ON PUBLIC.DLFILEVERSION(GROUPID,FOLDERID,STATUS) | |
| CREATE INDEX IX_9BE769ED ON PUBLIC.DLFILEVERSION(GROUPID,FOLDERID,TITLE,VERSION) | |
| CREATE INDEX IX_FFB3395C ON PUBLIC.DLFILEVERSION(MIMETYPE) | |
| CREATE INDEX IX_95E9E44E ON PUBLIC.DLFILEVERSION(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_C99B2650 ON PUBLIC.DLFILEVERSION(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.DLFOLDER(UUID_ VARCHAR(75),FOLDERID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,REPOSITORYID BIGINT,MOUNTPOINT BIT(1),PARENTFOLDERID BIGINT,TREEPATH VARCHAR(16777216),NAME VARCHAR(255),DESCRIPTION VARCHAR(16777216),LASTPOSTDATE TIMESTAMP,DEFAULTFILEENTRYTYPEID BIGINT,HIDDEN_ BIT(1),RESTRICTIONTYPE INTEGER,LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_E79BE432 ON PUBLIC.DLFOLDER(COMPANYID,STATUS) | |
| CREATE INDEX IX_C88430AB ON PUBLIC.DLFOLDER(GROUPID,MOUNTPOINT,PARENTFOLDERID,HIDDEN_,STATUS) | |
| CREATE INDEX IX_CE360BF6 ON PUBLIC.DLFOLDER(GROUPID,PARENTFOLDERID,HIDDEN_,STATUS) | |
| CREATE UNIQUE INDEX IX_902FD874 ON PUBLIC.DLFOLDER(GROUPID,PARENTFOLDERID,NAME) | |
| CREATE INDEX IX_51556082 ON PUBLIC.DLFOLDER(PARENTFOLDERID,NAME) | |
| CREATE INDEX IX_6F63F140 ON PUBLIC.DLFOLDER(REPOSITORYID,MOUNTPOINT) | |
| CREATE INDEX IX_6747B2BC ON PUBLIC.DLFOLDER(REPOSITORYID,PARENTFOLDERID) | |
| CREATE INDEX IX_DA448450 ON PUBLIC.DLFOLDER(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_3CC1DED2 ON PUBLIC.DLFOLDER(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.DLSYNCEVENT(SYNCEVENTID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,MODIFIEDTIME BIGINT,EVENT VARCHAR(75),TYPE_ VARCHAR(75),TYPEPK BIGINT) | |
| CREATE INDEX IX_3D8E1607 ON PUBLIC.DLSYNCEVENT(MODIFIEDTIME) | |
| CREATE UNIQUE INDEX IX_57D82B06 ON PUBLIC.DLSYNCEVENT(TYPEPK) | |
| CREATE MEMORY TABLE PUBLIC.EMAILADDRESS(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),EMAILADDRESSID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,ADDRESS VARCHAR(75),TYPEID BIGINT,PRIMARY_ BIT(1)) | |
| CREATE INDEX IX_2A2CB130 ON PUBLIC.EMAILADDRESS(COMPANYID,CLASSNAMEID,CLASSPK,PRIMARY_) | |
| CREATE INDEX IX_7B43CD8 ON PUBLIC.EMAILADDRESS(USERID) | |
| CREATE INDEX IX_F74AB912 ON PUBLIC.EMAILADDRESS(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.EXPANDOCOLUMN(COLUMNID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,TABLEID BIGINT,NAME VARCHAR(75),TYPE_ INTEGER,DEFAULTDATA VARCHAR(16777216),TYPESETTINGS VARCHAR(16777216)) | |
| CREATE UNIQUE INDEX IX_FEFC8DA7 ON PUBLIC.EXPANDOCOLUMN(TABLEID,NAME) | |
| CREATE MEMORY TABLE PUBLIC.EXPANDOROW(ROWID_ BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,MODIFIEDDATE TIMESTAMP,TABLEID BIGINT,CLASSPK BIGINT) | |
| CREATE INDEX IX_49EB3118 ON PUBLIC.EXPANDOROW(CLASSPK) | |
| CREATE UNIQUE INDEX IX_81EFBFF5 ON PUBLIC.EXPANDOROW(TABLEID,CLASSPK) | |
| CREATE MEMORY TABLE PUBLIC.EXPANDOTABLE(TABLEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CLASSNAMEID BIGINT,NAME VARCHAR(75)) | |
| CREATE UNIQUE INDEX IX_37562284 ON PUBLIC.EXPANDOTABLE(COMPANYID,CLASSNAMEID,NAME) | |
| CREATE MEMORY TABLE PUBLIC.EXPANDOVALUE(VALUEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,TABLEID BIGINT,COLUMNID BIGINT,ROWID_ BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,DATA_ VARCHAR(16777216)) | |
| CREATE INDEX IX_B29FEF17 ON PUBLIC.EXPANDOVALUE(CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_9DDD21E5 ON PUBLIC.EXPANDOVALUE(COLUMNID,ROWID_) | |
| CREATE INDEX IX_9112A7A0 ON PUBLIC.EXPANDOVALUE(ROWID_) | |
| CREATE INDEX IX_1BD3F4C ON PUBLIC.EXPANDOVALUE(TABLEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_D27B03E7 ON PUBLIC.EXPANDOVALUE(TABLEID,COLUMNID,CLASSPK) | |
| CREATE INDEX IX_B71E92D5 ON PUBLIC.EXPANDOVALUE(TABLEID,ROWID_) | |
| CREATE MEMORY TABLE PUBLIC.EXPORTIMPORTCONFIGURATION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,EXPORTIMPORTCONFIGURATIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(200),DESCRIPTION VARCHAR(16777216),TYPE_ INTEGER,SETTINGS_ VARCHAR(16777216),STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_1827A2E5 ON PUBLIC.EXPORTIMPORTCONFIGURATION(COMPANYID) | |
| CREATE INDEX IX_38FA468D ON PUBLIC.EXPORTIMPORTCONFIGURATION(GROUPID,STATUS) | |
| CREATE INDEX IX_47CC6234 ON PUBLIC.EXPORTIMPORTCONFIGURATION(GROUPID,TYPE_,STATUS) | |
| CREATE MEMORY TABLE PUBLIC.GROUP_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),GROUPID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CREATORUSERID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,PARENTGROUPID BIGINT,LIVEGROUPID BIGINT,TREEPATH VARCHAR(16777216),GROUPKEY VARCHAR(150),NAME VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),TYPE_ INTEGER,TYPESETTINGS VARCHAR(16777216),MANUALMEMBERSHIP BIT(1),MEMBERSHIPRESTRICTION INTEGER,FRIENDLYURL VARCHAR(255),SITE BIT(1),REMOTESTAGINGGROUPCOUNT INTEGER,INHERITCONTENT BIT(1),ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_8257E37B ON PUBLIC.GROUP_(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_BD3CB13A ON PUBLIC.GROUP_(CLASSNAMEID,GROUPID,COMPANYID,PARENTGROUPID) | |
| CREATE INDEX IX_DDC91A87 ON PUBLIC.GROUP_(COMPANYID,ACTIVE_) | |
| CREATE UNIQUE INDEX IX_D0D5E397 ON PUBLIC.GROUP_(COMPANYID,CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_A729E3A6 ON PUBLIC.GROUP_(COMPANYID,CLASSNAMEID,LIVEGROUPID,GROUPKEY) | |
| CREATE INDEX IX_ABE2D54 ON PUBLIC.GROUP_(COMPANYID,CLASSNAMEID,PARENTGROUPID) | |
| CREATE UNIQUE INDEX IX_5BDDB872 ON PUBLIC.GROUP_(COMPANYID,FRIENDLYURL) | |
| CREATE UNIQUE INDEX IX_ACD2B296 ON PUBLIC.GROUP_(COMPANYID,GROUPKEY) | |
| CREATE UNIQUE INDEX IX_AACD15F0 ON PUBLIC.GROUP_(COMPANYID,LIVEGROUPID,GROUPKEY) | |
| CREATE INDEX IX_D4BFF38B ON PUBLIC.GROUP_(COMPANYID,PARENTGROUPID,SITE,INHERITCONTENT) | |
| CREATE INDEX IX_63A2AABD ON PUBLIC.GROUP_(COMPANYID,SITE) | |
| CREATE INDEX IX_16218A38 ON PUBLIC.GROUP_(LIVEGROUPID) | |
| CREATE INDEX IX_7B590A7A ON PUBLIC.GROUP_(TYPE_,ACTIVE_) | |
| CREATE INDEX IX_26CC761A ON PUBLIC.GROUP_(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_754FBB1C ON PUBLIC.GROUP_(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.GROUPS_ORGS(COMPANYID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,ORGANIZATIONID BIGINT NOT NULL,PRIMARY KEY(GROUPID,ORGANIZATIONID)) | |
| CREATE INDEX IX_8BFD4548 ON PUBLIC.GROUPS_ORGS(COMPANYID) | |
| CREATE INDEX IX_75267DCA ON PUBLIC.GROUPS_ORGS(GROUPID) | |
| CREATE INDEX IX_6BBB7682 ON PUBLIC.GROUPS_ORGS(ORGANIZATIONID) | |
| CREATE MEMORY TABLE PUBLIC.GROUPS_ROLES(COMPANYID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,ROLEID BIGINT NOT NULL,PRIMARY KEY(GROUPID,ROLEID)) | |
| CREATE INDEX IX_557D8550 ON PUBLIC.GROUPS_ROLES(COMPANYID) | |
| CREATE INDEX IX_84471FD2 ON PUBLIC.GROUPS_ROLES(GROUPID) | |
| CREATE INDEX IX_3103EF3D ON PUBLIC.GROUPS_ROLES(ROLEID) | |
| CREATE MEMORY TABLE PUBLIC.GROUPS_USERGROUPS(COMPANYID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,USERGROUPID BIGINT NOT NULL,PRIMARY KEY(GROUPID,USERGROUPID)) | |
| CREATE INDEX IX_676FC818 ON PUBLIC.GROUPS_USERGROUPS(COMPANYID) | |
| CREATE INDEX IX_31FB749A ON PUBLIC.GROUPS_USERGROUPS(GROUPID) | |
| CREATE INDEX IX_3B69160F ON PUBLIC.GROUPS_USERGROUPS(USERGROUPID) | |
| CREATE MEMORY TABLE PUBLIC.IMAGE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,IMAGEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,MODIFIEDDATE TIMESTAMP,TYPE_ VARCHAR(75),HEIGHT INTEGER,WIDTH INTEGER,SIZE_ INTEGER) | |
| CREATE INDEX IX_6A925A4D ON PUBLIC.IMAGE(SIZE_) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUT(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),PLID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PRIVATELAYOUT BIT(1),LAYOUTID BIGINT,PARENTLAYOUTID BIGINT,NAME VARCHAR(16777216),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),KEYWORDS VARCHAR(16777216),ROBOTS VARCHAR(16777216),TYPE_ VARCHAR(75),TYPESETTINGS VARCHAR(16777216),HIDDEN_ BIT(1),FRIENDLYURL VARCHAR(255),ICONIMAGEID BIGINT,THEMEID VARCHAR(75),COLORSCHEMEID VARCHAR(75),CSS VARCHAR(16777216),PRIORITY INTEGER,LAYOUTPROTOTYPEUUID VARCHAR(75),LAYOUTPROTOTYPELINKENABLED BIT(1),SOURCEPROTOTYPELAYOUTUUID VARCHAR(75),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_C7FBC998 ON PUBLIC.LAYOUT(COMPANYID) | |
| CREATE UNIQUE INDEX IX_BC2C4231 ON PUBLIC.LAYOUT(GROUPID,PRIVATELAYOUT,FRIENDLYURL) | |
| CREATE UNIQUE INDEX IX_7162C27C ON PUBLIC.LAYOUT(GROUPID,PRIVATELAYOUT,LAYOUTID) | |
| CREATE INDEX IX_7399B71E ON PUBLIC.LAYOUT(GROUPID,PRIVATELAYOUT,PARENTLAYOUTID,PRIORITY) | |
| CREATE INDEX IX_8CE8C0D9 ON PUBLIC.LAYOUT(GROUPID,PRIVATELAYOUT,SOURCEPROTOTYPELAYOUTUUID) | |
| CREATE INDEX IX_1A1B61D2 ON PUBLIC.LAYOUT(GROUPID,PRIVATELAYOUT,TYPE_) | |
| CREATE INDEX IX_23922F7D ON PUBLIC.LAYOUT(ICONIMAGEID) | |
| CREATE INDEX IX_B529BFD3 ON PUBLIC.LAYOUT(LAYOUTPROTOTYPEUUID) | |
| CREATE INDEX IX_39A18ECC ON PUBLIC.LAYOUT(SOURCEPROTOTYPELAYOUTUUID) | |
| CREATE INDEX IX_2CE4BE84 ON PUBLIC.LAYOUT(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_E118C537 ON PUBLIC.LAYOUT(UUID_,GROUPID,PRIVATELAYOUT) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTBRANCH(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,LAYOUTBRANCHID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),LAYOUTSETBRANCHID BIGINT,PLID BIGINT,NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),MASTER BIT(1)) | |
| CREATE INDEX IX_A705FF94 ON PUBLIC.LAYOUTBRANCH(LAYOUTSETBRANCHID,PLID,MASTER) | |
| CREATE UNIQUE INDEX IX_FD57097D ON PUBLIC.LAYOUTBRANCH(LAYOUTSETBRANCHID,PLID,NAME) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTFRIENDLYURL(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),LAYOUTFRIENDLYURLID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PLID BIGINT,PRIVATELAYOUT BIT(1),FRIENDLYURL VARCHAR(255),LANGUAGEID VARCHAR(75),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_EAB317C8 ON PUBLIC.LAYOUTFRIENDLYURL(COMPANYID) | |
| CREATE UNIQUE INDEX IX_A6FC2B28 ON PUBLIC.LAYOUTFRIENDLYURL(GROUPID,PRIVATELAYOUT,FRIENDLYURL,LANGUAGEID) | |
| CREATE INDEX IX_59051329 ON PUBLIC.LAYOUTFRIENDLYURL(PLID,FRIENDLYURL) | |
| CREATE UNIQUE INDEX IX_C5762E72 ON PUBLIC.LAYOUTFRIENDLYURL(PLID,LANGUAGEID) | |
| CREATE INDEX IX_F4321A54 ON PUBLIC.LAYOUTFRIENDLYURL(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_326525D6 ON PUBLIC.LAYOUTFRIENDLYURL(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTPROTOTYPE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),LAYOUTPROTOTYPEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),SETTINGS_ VARCHAR(16777216),ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_557A639F ON PUBLIC.LAYOUTPROTOTYPE(COMPANYID,ACTIVE_) | |
| CREATE INDEX IX_63ED2532 ON PUBLIC.LAYOUTPROTOTYPE(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTREVISION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,LAYOUTREVISIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,LAYOUTSETBRANCHID BIGINT,LAYOUTBRANCHID BIGINT,PARENTLAYOUTREVISIONID BIGINT,HEAD BIT(1),MAJOR BIT(1),PLID BIGINT,PRIVATELAYOUT BIT(1),NAME VARCHAR(16777216),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),KEYWORDS VARCHAR(16777216),ROBOTS VARCHAR(16777216),TYPESETTINGS VARCHAR(16777216),ICONIMAGEID BIGINT,THEMEID VARCHAR(75),COLORSCHEMEID VARCHAR(75),CSS VARCHAR(16777216),STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_43E8286A ON PUBLIC.LAYOUTREVISION(HEAD,PLID) | |
| CREATE INDEX IX_E10AC39 ON PUBLIC.LAYOUTREVISION(LAYOUTSETBRANCHID,HEAD,PLID) | |
| CREATE INDEX IX_13984800 ON PUBLIC.LAYOUTREVISION(LAYOUTSETBRANCHID,LAYOUTBRANCHID,PLID) | |
| CREATE INDEX IX_4A84AF43 ON PUBLIC.LAYOUTREVISION(LAYOUTSETBRANCHID,PARENTLAYOUTREVISIONID,PLID) | |
| CREATE INDEX IX_70DA9ECB ON PUBLIC.LAYOUTREVISION(LAYOUTSETBRANCHID,PLID,STATUS) | |
| CREATE INDEX IX_7FFAE700 ON PUBLIC.LAYOUTREVISION(LAYOUTSETBRANCHID,STATUS) | |
| CREATE INDEX IX_8EC3D2BC ON PUBLIC.LAYOUTREVISION(PLID,STATUS) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTSET(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,LAYOUTSETID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PRIVATELAYOUT BIT(1),LOGOID BIGINT,THEMEID VARCHAR(75),COLORSCHEMEID VARCHAR(75),CSS VARCHAR(16777216),PAGECOUNT INTEGER,SETTINGS_ VARCHAR(16777216),LAYOUTSETPROTOTYPEUUID VARCHAR(75),LAYOUTSETPROTOTYPELINKENABLED BIT(1)) | |
| CREATE UNIQUE INDEX IX_48550691 ON PUBLIC.LAYOUTSET(GROUPID,PRIVATELAYOUT) | |
| CREATE INDEX IX_72BBA8B7 ON PUBLIC.LAYOUTSET(LAYOUTSETPROTOTYPEUUID) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTSETBRANCH(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,LAYOUTSETBRANCHID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PRIVATELAYOUT BIT(1),NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),MASTER BIT(1),LOGOID BIGINT,THEMEID VARCHAR(75),COLORSCHEMEID VARCHAR(75),CSS VARCHAR(16777216),SETTINGS_ VARCHAR(16777216),LAYOUTSETPROTOTYPEUUID VARCHAR(75),LAYOUTSETPROTOTYPELINKENABLED BIT(1)) | |
| CREATE INDEX IX_CCF0DA29 ON PUBLIC.LAYOUTSETBRANCH(GROUPID,PRIVATELAYOUT,MASTER) | |
| CREATE UNIQUE INDEX IX_5FF18552 ON PUBLIC.LAYOUTSETBRANCH(GROUPID,PRIVATELAYOUT,NAME) | |
| CREATE MEMORY TABLE PUBLIC.LAYOUTSETPROTOTYPE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),LAYOUTSETPROTOTYPEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),SETTINGS_ VARCHAR(16777216),ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_9178FC71 ON PUBLIC.LAYOUTSETPROTOTYPE(COMPANYID,ACTIVE_) | |
| CREATE INDEX IX_D9FFCA84 ON PUBLIC.LAYOUTSETPROTOTYPE(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.LISTTYPE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,LISTTYPEID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(75),TYPE_ VARCHAR(75)) | |
| CREATE INDEX IX_77729718 ON PUBLIC.LISTTYPE(NAME,TYPE_) | |
| CREATE INDEX IX_2932DD37 ON PUBLIC.LISTTYPE(TYPE_) | |
| CREATE MEMORY TABLE PUBLIC.MBBAN(UUID_ VARCHAR(75),BANID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,BANUSERID BIGINT,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_69951A25 ON PUBLIC.MBBAN(BANUSERID) | |
| CREATE UNIQUE INDEX IX_8ABC4E3B ON PUBLIC.MBBAN(GROUPID,BANUSERID) | |
| CREATE INDEX IX_48814BBA ON PUBLIC.MBBAN(USERID) | |
| CREATE INDEX IX_4F841574 ON PUBLIC.MBBAN(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_2A3B68F6 ON PUBLIC.MBBAN(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBCATEGORY(UUID_ VARCHAR(75),CATEGORYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PARENTCATEGORYID BIGINT,NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),DISPLAYSTYLE VARCHAR(75),THREADCOUNT INTEGER,MESSAGECOUNT INTEGER,LASTPOSTDATE TIMESTAMP,LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_D1642361 ON PUBLIC.MBCATEGORY(CATEGORYID,GROUPID,PARENTCATEGORYID,STATUS) | |
| CREATE INDEX IX_E15A5DB5 ON PUBLIC.MBCATEGORY(COMPANYID,STATUS) | |
| CREATE INDEX IX_C295DBEE ON PUBLIC.MBCATEGORY(GROUPID,PARENTCATEGORYID,STATUS) | |
| CREATE INDEX IX_DA84A9F7 ON PUBLIC.MBCATEGORY(GROUPID,STATUS) | |
| CREATE INDEX IX_13DF4E6D ON PUBLIC.MBCATEGORY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_F7D28C2F ON PUBLIC.MBCATEGORY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBDISCUSSION(UUID_ VARCHAR(75),DISCUSSIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,THREADID BIGINT,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_33A4DE38 ON PUBLIC.MBDISCUSSION(CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_B5CA2DC ON PUBLIC.MBDISCUSSION(THREADID) | |
| CREATE INDEX IX_7E965757 ON PUBLIC.MBDISCUSSION(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_F7AAC799 ON PUBLIC.MBDISCUSSION(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBMAILINGLIST(UUID_ VARCHAR(75),MAILINGLISTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CATEGORYID BIGINT,EMAILADDRESS VARCHAR(75),INPROTOCOL VARCHAR(75),INSERVERNAME VARCHAR(75),INSERVERPORT INTEGER,INUSESSL BIT(1),INUSERNAME VARCHAR(75),INPASSWORD VARCHAR(75),INREADINTERVAL INTEGER,OUTEMAILADDRESS VARCHAR(75),OUTCUSTOM BIT(1),OUTSERVERNAME VARCHAR(75),OUTSERVERPORT INTEGER,OUTUSESSL BIT(1),OUTUSERNAME VARCHAR(75),OUTPASSWORD VARCHAR(75),ALLOWANONYMOUS BIT(1),ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_BFEB984F ON PUBLIC.MBMAILINGLIST(ACTIVE_) | |
| CREATE UNIQUE INDEX IX_76CE9CDD ON PUBLIC.MBMAILINGLIST(GROUPID,CATEGORYID) | |
| CREATE INDEX IX_FC61676E ON PUBLIC.MBMAILINGLIST(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_E858F170 ON PUBLIC.MBMAILINGLIST(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBMESSAGE(UUID_ VARCHAR(75),MESSAGEID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,CATEGORYID BIGINT,THREADID BIGINT,ROOTMESSAGEID BIGINT,PARENTMESSAGEID BIGINT,SUBJECT VARCHAR(75),BODY VARCHAR(16777216),FORMAT VARCHAR(75),ANONYMOUS BIT(1),PRIORITY DOUBLE,ALLOWPINGBACKS BIT(1),ANSWER BIT(1),LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_F6687633 ON PUBLIC.MBMESSAGE(CLASSNAMEID,CLASSPK,STATUS) | |
| CREATE INDEX IX_1AD93C16 ON PUBLIC.MBMESSAGE(COMPANYID,STATUS) | |
| CREATE INDEX IX_4257DB85 ON PUBLIC.MBMESSAGE(GROUPID,CATEGORYID,STATUS) | |
| CREATE INDEX IX_CBFDBF0A ON PUBLIC.MBMESSAGE(GROUPID,CATEGORYID,THREADID,ANSWER) | |
| CREATE INDEX IX_385E123E ON PUBLIC.MBMESSAGE(GROUPID,CATEGORYID,THREADID,STATUS) | |
| CREATE INDEX IX_ED39AC98 ON PUBLIC.MBMESSAGE(GROUPID,STATUS) | |
| CREATE INDEX IX_377858D2 ON PUBLIC.MBMESSAGE(GROUPID,USERID,STATUS) | |
| CREATE INDEX IX_9D7C3B23 ON PUBLIC.MBMESSAGE(THREADID,ANSWER) | |
| CREATE INDEX IX_A7038CD7 ON PUBLIC.MBMESSAGE(THREADID,PARENTMESSAGEID) | |
| CREATE INDEX IX_9DC8E57 ON PUBLIC.MBMESSAGE(THREADID,STATUS) | |
| CREATE INDEX IX_4A4BB4ED ON PUBLIC.MBMESSAGE(USERID,CLASSNAMEID,CLASSPK,STATUS) | |
| CREATE INDEX IX_3321F142 ON PUBLIC.MBMESSAGE(USERID,CLASSNAMEID,STATUS) | |
| CREATE INDEX IX_57CA9FEC ON PUBLIC.MBMESSAGE(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_8D12316E ON PUBLIC.MBMESSAGE(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBSTATSUSER(STATSUSERID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,MESSAGECOUNT INTEGER,LASTPOSTDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_9168E2C9 ON PUBLIC.MBSTATSUSER(GROUPID,USERID) | |
| CREATE INDEX IX_847F92B5 ON PUBLIC.MBSTATSUSER(USERID) | |
| CREATE MEMORY TABLE PUBLIC.MBTHREAD(UUID_ VARCHAR(75),THREADID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CATEGORYID BIGINT,ROOTMESSAGEID BIGINT,ROOTMESSAGEUSERID BIGINT,MESSAGECOUNT INTEGER,VIEWCOUNT INTEGER,LASTPOSTBYUSERID BIGINT,LASTPOSTDATE TIMESTAMP,PRIORITY DOUBLE,QUESTION BIT(1),LASTPUBLISHDATE TIMESTAMP,STATUS INTEGER,STATUSBYUSERID BIGINT,STATUSBYUSERNAME VARCHAR(75),STATUSDATE TIMESTAMP) | |
| CREATE INDEX IX_41F6DC8A ON PUBLIC.MBTHREAD(CATEGORYID,PRIORITY) | |
| CREATE INDEX IX_50F1904A ON PUBLIC.MBTHREAD(GROUPID,CATEGORYID,LASTPOSTDATE) | |
| CREATE INDEX IX_485F7E98 ON PUBLIC.MBTHREAD(GROUPID,CATEGORYID,STATUS) | |
| CREATE INDEX IX_E1E7142B ON PUBLIC.MBTHREAD(GROUPID,STATUS) | |
| CREATE INDEX IX_AEDD9CB5 ON PUBLIC.MBTHREAD(LASTPOSTDATE,PRIORITY) | |
| CREATE INDEX IX_CC993ECB ON PUBLIC.MBTHREAD(ROOTMESSAGEID) | |
| CREATE INDEX IX_F8CA2AB9 ON PUBLIC.MBTHREAD(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_3A200B7B ON PUBLIC.MBTHREAD(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MBTHREADFLAG(UUID_ VARCHAR(75),THREADFLAGID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,THREADID BIGINT,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_8CB0A24A ON PUBLIC.MBTHREADFLAG(THREADID) | |
| CREATE UNIQUE INDEX IX_33781904 ON PUBLIC.MBTHREADFLAG(USERID,THREADID) | |
| CREATE INDEX IX_DCE308C5 ON PUBLIC.MBTHREADFLAG(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_FEB0FC87 ON PUBLIC.MBTHREADFLAG(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.MEMBERSHIPREQUEST(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,MEMBERSHIPREQUESTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE TIMESTAMP,COMMENTS VARCHAR(16777216),REPLYCOMMENTS VARCHAR(16777216),REPLYDATE TIMESTAMP,REPLIERUSERID BIGINT,STATUSID BIGINT) | |
| CREATE INDEX IX_C28C72EC ON PUBLIC.MEMBERSHIPREQUEST(GROUPID,STATUSID) | |
| CREATE INDEX IX_35AA8FA6 ON PUBLIC.MEMBERSHIPREQUEST(GROUPID,USERID,STATUSID) | |
| CREATE INDEX IX_66D70879 ON PUBLIC.MEMBERSHIPREQUEST(USERID) | |
| CREATE MEMORY TABLE PUBLIC.ORGANIZATION_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),ORGANIZATIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PARENTORGANIZATIONID BIGINT,TREEPATH VARCHAR(16777216),NAME VARCHAR(100),TYPE_ VARCHAR(75),RECURSABLE BIT(1),REGIONID BIGINT,COUNTRYID BIGINT,STATUSID BIGINT,COMMENTS VARCHAR(16777216),LOGOID BIGINT) | |
| CREATE UNIQUE INDEX IX_E301BDF5 ON PUBLIC.ORGANIZATION_(COMPANYID,NAME) | |
| CREATE INDEX IX_418E4522 ON PUBLIC.ORGANIZATION_(COMPANYID,PARENTORGANIZATIONID) | |
| CREATE INDEX IX_A9D85BA6 ON PUBLIC.ORGANIZATION_(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.ORGGROUPROLE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,ORGANIZATIONID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,ROLEID BIGINT NOT NULL,COMPANYID BIGINT,PRIMARY KEY(ORGANIZATIONID,GROUPID,ROLEID)) | |
| CREATE INDEX IX_4A527DD3 ON PUBLIC.ORGGROUPROLE(GROUPID) | |
| CREATE INDEX IX_AB044D1C ON PUBLIC.ORGGROUPROLE(ROLEID) | |
| CREATE MEMORY TABLE PUBLIC.ORGLABOR(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,ORGLABORID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,ORGANIZATIONID BIGINT,TYPEID BIGINT,SUNOPEN INTEGER,SUNCLOSE INTEGER,MONOPEN INTEGER,MONCLOSE INTEGER,TUEOPEN INTEGER,TUECLOSE INTEGER,WEDOPEN INTEGER,WEDCLOSE INTEGER,THUOPEN INTEGER,THUCLOSE INTEGER,FRIOPEN INTEGER,FRICLOSE INTEGER,SATOPEN INTEGER,SATCLOSE INTEGER) | |
| CREATE INDEX IX_6AF0D434 ON PUBLIC.ORGLABOR(ORGANIZATIONID) | |
| CREATE MEMORY TABLE PUBLIC.PASSWORDPOLICY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),PASSWORDPOLICYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,DEFAULTPOLICY BIT(1),NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),CHANGEABLE BIT(1),CHANGEREQUIRED BIT(1),MINAGE BIGINT,CHECKSYNTAX BIT(1),ALLOWDICTIONARYWORDS BIT(1),MINALPHANUMERIC INTEGER,MINLENGTH INTEGER,MINLOWERCASE INTEGER,MINNUMBERS INTEGER,MINSYMBOLS INTEGER,MINUPPERCASE INTEGER,REGEX VARCHAR(75),HISTORY BIT(1),HISTORYCOUNT INTEGER,EXPIREABLE BIT(1),MAXAGE BIGINT,WARNINGTIME BIGINT,GRACELIMIT INTEGER,LOCKOUT BIT(1),MAXFAILURE INTEGER,LOCKOUTDURATION BIGINT,REQUIREUNLOCK BIT(1),RESETFAILURECOUNT BIGINT,RESETTICKETMAXAGE BIGINT) | |
| CREATE INDEX IX_2C1142E ON PUBLIC.PASSWORDPOLICY(COMPANYID,DEFAULTPOLICY) | |
| CREATE UNIQUE INDEX IX_3FBFA9F4 ON PUBLIC.PASSWORDPOLICY(COMPANYID,NAME) | |
| CREATE INDEX IX_E4D7EF87 ON PUBLIC.PASSWORDPOLICY(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.PASSWORDPOLICYREL(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PASSWORDPOLICYRELID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,PASSWORDPOLICYID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT) | |
| CREATE UNIQUE INDEX IX_C3A17327 ON PUBLIC.PASSWORDPOLICYREL(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_CD25266E ON PUBLIC.PASSWORDPOLICYREL(PASSWORDPOLICYID) | |
| CREATE MEMORY TABLE PUBLIC.PASSWORDTRACKER(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PASSWORDTRACKERID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,CREATEDATE TIMESTAMP,PASSWORD_ VARCHAR(75)) | |
| CREATE INDEX IX_326F75BD ON PUBLIC.PASSWORDTRACKER(USERID) | |
| CREATE MEMORY TABLE PUBLIC.PHONE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),PHONEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,NUMBER_ VARCHAR(75),EXTENSION VARCHAR(75),TYPEID BIGINT,PRIMARY_ BIT(1)) | |
| CREATE INDEX IX_812CE07A ON PUBLIC.PHONE(COMPANYID,CLASSNAMEID,CLASSPK,PRIMARY_) | |
| CREATE INDEX IX_F202B9CE ON PUBLIC.PHONE(USERID) | |
| CREATE INDEX IX_B271FA88 ON PUBLIC.PHONE(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.PLUGINSETTING(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PLUGINSETTINGID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,PLUGINID VARCHAR(75),PLUGINTYPE VARCHAR(75),ROLES VARCHAR(16777216),ACTIVE_ BIT(1)) | |
| CREATE UNIQUE INDEX IX_7171B2E8 ON PUBLIC.PLUGINSETTING(COMPANYID,PLUGINID,PLUGINTYPE) | |
| CREATE MEMORY TABLE PUBLIC.PORTALPREFERENCES(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PORTALPREFERENCESID BIGINT NOT NULL PRIMARY KEY,OWNERID BIGINT,OWNERTYPE INTEGER,PREFERENCES VARCHAR(16777216)) | |
| CREATE INDEX IX_D1F795F1 ON PUBLIC.PORTALPREFERENCES(OWNERID,OWNERTYPE) | |
| CREATE MEMORY TABLE PUBLIC.PORTLET(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,ID_ BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,PORTLETID VARCHAR(200),ROLES VARCHAR(16777216),ACTIVE_ BIT(1)) | |
| CREATE UNIQUE INDEX IX_12B5E51D ON PUBLIC.PORTLET(COMPANYID,PORTLETID) | |
| CREATE MEMORY TABLE PUBLIC.PORTLETITEM(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PORTLETITEMID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,NAME VARCHAR(75),PORTLETID VARCHAR(200),CLASSNAMEID BIGINT) | |
| CREATE INDEX IX_96BDD537 ON PUBLIC.PORTLETITEM(GROUPID,CLASSNAMEID) | |
| CREATE INDEX IX_D699243F ON PUBLIC.PORTLETITEM(GROUPID,NAME,PORTLETID,CLASSNAMEID) | |
| CREATE INDEX IX_E922D6C0 ON PUBLIC.PORTLETITEM(GROUPID,PORTLETID,CLASSNAMEID) | |
| CREATE MEMORY TABLE PUBLIC.PORTLETPREFERENCES(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,PORTLETPREFERENCESID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,OWNERID BIGINT,OWNERTYPE INTEGER,PLID BIGINT,PORTLETID VARCHAR(200),PREFERENCES VARCHAR(16777216)) | |
| CREATE UNIQUE INDEX IX_C7057FF7 ON PUBLIC.PORTLETPREFERENCES(OWNERID,OWNERTYPE,PLID,PORTLETID) | |
| CREATE INDEX IX_C9A3FCE2 ON PUBLIC.PORTLETPREFERENCES(OWNERID,OWNERTYPE,PORTLETID) | |
| CREATE INDEX IX_D5EDA3A1 ON PUBLIC.PORTLETPREFERENCES(OWNERTYPE,PLID,PORTLETID) | |
| CREATE INDEX IX_A3B2A80C ON PUBLIC.PORTLETPREFERENCES(OWNERTYPE,PORTLETID) | |
| CREATE INDEX IX_D340DB76 ON PUBLIC.PORTLETPREFERENCES(PLID,PORTLETID) | |
| CREATE INDEX IX_8E6DA3A1 ON PUBLIC.PORTLETPREFERENCES(PORTLETID) | |
| CREATE MEMORY TABLE PUBLIC.RATINGSENTRY(UUID_ VARCHAR(75),ENTRYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,SCORE DOUBLE) | |
| CREATE INDEX IX_A1A8CB8B ON PUBLIC.RATINGSENTRY(CLASSNAMEID,CLASSPK,SCORE) | |
| CREATE UNIQUE INDEX IX_B47E3C11 ON PUBLIC.RATINGSENTRY(USERID,CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_9F242DF6 ON PUBLIC.RATINGSENTRY(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.RATINGSSTATS(STATSID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,TOTALENTRIES INTEGER,TOTALSCORE DOUBLE,AVERAGESCORE DOUBLE) | |
| CREATE UNIQUE INDEX IX_A6E99284 ON PUBLIC.RATINGSSTATS(CLASSNAMEID,CLASSPK) | |
| CREATE MEMORY TABLE PUBLIC.RECENTLAYOUTBRANCH(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RECENTLAYOUTBRANCHID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,LAYOUTBRANCHID BIGINT,LAYOUTSETBRANCHID BIGINT,PLID BIGINT) | |
| CREATE INDEX IX_B91F79BD ON PUBLIC.RECENTLAYOUTBRANCH(GROUPID) | |
| CREATE INDEX IX_351E86E8 ON PUBLIC.RECENTLAYOUTBRANCH(LAYOUTBRANCHID) | |
| CREATE UNIQUE INDEX IX_C27D6369 ON PUBLIC.RECENTLAYOUTBRANCH(USERID,LAYOUTSETBRANCHID,PLID) | |
| CREATE MEMORY TABLE PUBLIC.RECENTLAYOUTREVISION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RECENTLAYOUTREVISIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,LAYOUTREVISIONID BIGINT,LAYOUTSETBRANCHID BIGINT,PLID BIGINT) | |
| CREATE INDEX IX_8D8A2724 ON PUBLIC.RECENTLAYOUTREVISION(GROUPID) | |
| CREATE INDEX IX_DA0788DA ON PUBLIC.RECENTLAYOUTREVISION(LAYOUTREVISIONID) | |
| CREATE UNIQUE INDEX IX_4C600BD0 ON PUBLIC.RECENTLAYOUTREVISION(USERID,LAYOUTSETBRANCHID,PLID) | |
| CREATE MEMORY TABLE PUBLIC.RECENTLAYOUTSETBRANCH(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RECENTLAYOUTSETBRANCHID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,LAYOUTSETBRANCHID BIGINT,LAYOUTSETID BIGINT) | |
| CREATE INDEX IX_711995A5 ON PUBLIC.RECENTLAYOUTSETBRANCH(GROUPID) | |
| CREATE INDEX IX_23FF0700 ON PUBLIC.RECENTLAYOUTSETBRANCH(LAYOUTSETBRANCHID) | |
| CREATE UNIQUE INDEX IX_4654D204 ON PUBLIC.RECENTLAYOUTSETBRANCH(USERID,LAYOUTSETID) | |
| CREATE MEMORY TABLE PUBLIC.REGION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,REGIONID BIGINT NOT NULL PRIMARY KEY,COUNTRYID BIGINT,REGIONCODE VARCHAR(75),NAME VARCHAR(75),ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_2D9A426F ON PUBLIC.REGION(ACTIVE_) | |
| CREATE INDEX IX_11FB3E42 ON PUBLIC.REGION(COUNTRYID,ACTIVE_) | |
| CREATE UNIQUE INDEX IX_A2635F5C ON PUBLIC.REGION(COUNTRYID,REGIONCODE) | |
| CREATE MEMORY TABLE PUBLIC.RELEASE_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RELEASEID BIGINT NOT NULL PRIMARY KEY,CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,SERVLETCONTEXTNAME VARCHAR(75),SCHEMAVERSION VARCHAR(75),BUILDNUMBER INTEGER,BUILDDATE TIMESTAMP,VERIFIED BIT(1),STATE_ INTEGER,TESTSTRING VARCHAR(1024)) | |
| CREATE UNIQUE INDEX IX_8BD6BCA7 ON PUBLIC.RELEASE_(SERVLETCONTEXTNAME) | |
| CREATE MEMORY TABLE PUBLIC.REPOSITORY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),REPOSITORYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),PORTLETID VARCHAR(200),TYPESETTINGS VARCHAR(16777216),DLFOLDERID BIGINT,LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_60C8634C ON PUBLIC.REPOSITORY(GROUPID,NAME,PORTLETID) | |
| CREATE INDEX IX_F543EA4 ON PUBLIC.REPOSITORY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_11641E26 ON PUBLIC.REPOSITORY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.REPOSITORYENTRY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),REPOSITORYENTRYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,REPOSITORYID BIGINT,MAPPEDID VARCHAR(255),MANUALCHECKINREQUIRED BIT(1),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_9BDCF489 ON PUBLIC.REPOSITORYENTRY(REPOSITORYID,MAPPEDID) | |
| CREATE INDEX IX_D3B9AF62 ON PUBLIC.REPOSITORYENTRY(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_354AA664 ON PUBLIC.REPOSITORYENTRY(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.RESOURCEACTION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RESOURCEACTIONID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255),ACTIONID VARCHAR(75),BITWISEVALUE BIGINT) | |
| CREATE UNIQUE INDEX IX_EDB9986E ON PUBLIC.RESOURCEACTION(NAME,ACTIONID) | |
| CREATE MEMORY TABLE PUBLIC.RESOURCEBLOCK(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RESOURCEBLOCKID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,GROUPID BIGINT,NAME VARCHAR(75),PERMISSIONSHASH VARCHAR(75),REFERENCECOUNT BIGINT) | |
| CREATE UNIQUE INDEX IX_AEEA209C ON PUBLIC.RESOURCEBLOCK(COMPANYID,GROUPID,NAME,PERMISSIONSHASH) | |
| CREATE INDEX IX_2D4CC782 ON PUBLIC.RESOURCEBLOCK(COMPANYID,NAME) | |
| CREATE MEMORY TABLE PUBLIC.RESOURCEBLOCKPERMISSION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RESOURCEBLOCKPERMISSIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,RESOURCEBLOCKID BIGINT,ROLEID BIGINT,ACTIONIDS BIGINT) | |
| CREATE UNIQUE INDEX IX_D63D20BB ON PUBLIC.RESOURCEBLOCKPERMISSION(RESOURCEBLOCKID,ROLEID) | |
| CREATE INDEX IX_20A2E3D9 ON PUBLIC.RESOURCEBLOCKPERMISSION(ROLEID) | |
| CREATE MEMORY TABLE PUBLIC.RESOURCEPERMISSION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RESOURCEPERMISSIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,NAME VARCHAR(255),SCOPE INTEGER,PRIMKEY VARCHAR(255),PRIMKEYID BIGINT,ROLEID BIGINT,OWNERID BIGINT,ACTIONIDS BIGINT,VIEWACTIONID BIT(1)) | |
| CREATE UNIQUE INDEX IX_8D83D0CE ON PUBLIC.RESOURCEPERMISSION(COMPANYID,NAME,SCOPE,PRIMKEY,ROLEID) | |
| CREATE INDEX IX_49AEC6F3 ON PUBLIC.RESOURCEPERMISSION(COMPANYID,NAME,SCOPE,PRIMKEYID,ROLEID,VIEWACTIONID) | |
| CREATE INDEX IX_26284944 ON PUBLIC.RESOURCEPERMISSION(COMPANYID,PRIMKEY) | |
| CREATE INDEX IX_F6BAE86A ON PUBLIC.RESOURCEPERMISSION(COMPANYID,SCOPE,PRIMKEY) | |
| CREATE INDEX IX_D5F1E2A2 ON PUBLIC.RESOURCEPERMISSION(NAME) | |
| CREATE INDEX IX_A37A0588 ON PUBLIC.RESOURCEPERMISSION(ROLEID) | |
| CREATE INDEX IX_F4555981 ON PUBLIC.RESOURCEPERMISSION(SCOPE) | |
| CREATE MEMORY TABLE PUBLIC.RESOURCETYPEPERMISSION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,RESOURCETYPEPERMISSIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,GROUPID BIGINT,NAME VARCHAR(75),ROLEID BIGINT,ACTIONIDS BIGINT) | |
| CREATE UNIQUE INDEX IX_BA497163 ON PUBLIC.RESOURCETYPEPERMISSION(COMPANYID,GROUPID,NAME,ROLEID) | |
| CREATE INDEX IX_7D81F66F ON PUBLIC.RESOURCETYPEPERMISSION(COMPANYID,NAME,ROLEID) | |
| CREATE INDEX IX_A82690E2 ON PUBLIC.RESOURCETYPEPERMISSION(ROLEID) | |
| CREATE MEMORY TABLE PUBLIC.ROLE_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),ROLEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,NAME VARCHAR(75),TITLE VARCHAR(16777216),DESCRIPTION VARCHAR(16777216),TYPE_ INTEGER,SUBTYPE VARCHAR(75)) | |
| CREATE UNIQUE INDEX IX_A88E424E ON PUBLIC.ROLE_(COMPANYID,CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_EBC931B8 ON PUBLIC.ROLE_(COMPANYID,NAME) | |
| CREATE INDEX IX_F3E1C6FC ON PUBLIC.ROLE_(COMPANYID,TYPE_) | |
| CREATE INDEX IX_F436EC8E ON PUBLIC.ROLE_(NAME) | |
| CREATE INDEX IX_5EB4E2FB ON PUBLIC.ROLE_(SUBTYPE) | |
| CREATE INDEX IX_CBE204 ON PUBLIC.ROLE_(TYPE_,SUBTYPE) | |
| CREATE INDEX IX_B9FF6043 ON PUBLIC.ROLE_(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.SERVICECOMPONENT(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,SERVICECOMPONENTID BIGINT NOT NULL PRIMARY KEY,BUILDNAMESPACE VARCHAR(75),BUILDNUMBER BIGINT,BUILDDATE BIGINT,DATA_ VARCHAR(16777216)) | |
| CREATE UNIQUE INDEX IX_4F0315B8 ON PUBLIC.SERVICECOMPONENT(BUILDNAMESPACE,BUILDNUMBER) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITY(ACTIVITYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE BIGINT,ACTIVITYSETID BIGINT,MIRRORACTIVITYID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,PARENTCLASSNAMEID BIGINT,PARENTCLASSPK BIGINT,TYPE_ INTEGER,EXTRADATA VARCHAR(16777216),RECEIVERUSERID BIGINT) | |
| CREATE INDEX IX_F542E9BC ON PUBLIC.SOCIALACTIVITY(ACTIVITYSETID) | |
| CREATE INDEX IX_D0E9029E ON PUBLIC.SOCIALACTIVITY(CLASSNAMEID,CLASSPK,TYPE_) | |
| CREATE INDEX IX_64B1BC66 ON PUBLIC.SOCIALACTIVITY(COMPANYID) | |
| CREATE INDEX IX_FB604DC7 ON PUBLIC.SOCIALACTIVITY(GROUPID,USERID,CLASSNAMEID,CLASSPK,TYPE_,RECEIVERUSERID) | |
| CREATE UNIQUE INDEX IX_8F32DEC9 ON PUBLIC.SOCIALACTIVITY(GROUPID,USERID,CREATEDATE,CLASSNAMEID,CLASSPK,TYPE_,RECEIVERUSERID) | |
| CREATE INDEX IX_1F00C374 ON PUBLIC.SOCIALACTIVITY(MIRRORACTIVITYID,CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_121CA3CB ON PUBLIC.SOCIALACTIVITY(RECEIVERUSERID) | |
| CREATE INDEX IX_3504B8BC ON PUBLIC.SOCIALACTIVITY(USERID) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITYACHIEVEMENT(ACTIVITYACHIEVEMENTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE BIGINT,NAME VARCHAR(75),FIRSTINGROUP BIT(1)) | |
| CREATE INDEX IX_83E16F2F ON PUBLIC.SOCIALACTIVITYACHIEVEMENT(GROUPID,FIRSTINGROUP) | |
| CREATE INDEX IX_8F6408F0 ON PUBLIC.SOCIALACTIVITYACHIEVEMENT(GROUPID,NAME) | |
| CREATE INDEX IX_AABC18E9 ON PUBLIC.SOCIALACTIVITYACHIEVEMENT(GROUPID,USERID,FIRSTINGROUP) | |
| CREATE UNIQUE INDEX IX_D4390CAA ON PUBLIC.SOCIALACTIVITYACHIEVEMENT(GROUPID,USERID,NAME) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITYCOUNTER(ACTIVITYCOUNTERID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,NAME VARCHAR(75),OWNERTYPE INTEGER,CURRENTVALUE INTEGER,TOTALVALUE INTEGER,GRACEVALUE INTEGER,STARTPERIOD INTEGER,ENDPERIOD INTEGER,ACTIVE_ BIT(1)) | |
| CREATE INDEX IX_A4B9A23B ON PUBLIC.SOCIALACTIVITYCOUNTER(CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_1B7E3B67 ON PUBLIC.SOCIALACTIVITYCOUNTER(GROUPID,CLASSNAMEID,CLASSPK,NAME,OWNERTYPE,ENDPERIOD) | |
| CREATE UNIQUE INDEX IX_374B35AE ON PUBLIC.SOCIALACTIVITYCOUNTER(GROUPID,CLASSNAMEID,CLASSPK,NAME,OWNERTYPE,STARTPERIOD) | |
| CREATE INDEX IX_926CDD04 ON PUBLIC.SOCIALACTIVITYCOUNTER(GROUPID,CLASSNAMEID,CLASSPK,OWNERTYPE) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITYLIMIT(ACTIVITYLIMITID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,ACTIVITYTYPE INTEGER,ACTIVITYCOUNTERNAME VARCHAR(75),VALUE VARCHAR(75)) | |
| CREATE INDEX IX_B15863FA ON PUBLIC.SOCIALACTIVITYLIMIT(CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_F1C1A617 ON PUBLIC.SOCIALACTIVITYLIMIT(GROUPID,USERID,CLASSNAMEID,CLASSPK,ACTIVITYTYPE,ACTIVITYCOUNTERNAME) | |
| CREATE INDEX IX_6F9EDE9F ON PUBLIC.SOCIALACTIVITYLIMIT(USERID) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITYSET(ACTIVITYSETID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE BIGINT,MODIFIEDDATE BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,TYPE_ INTEGER,EXTRADATA VARCHAR(16777216),ACTIVITYCOUNT INTEGER) | |
| CREATE INDEX IX_4460FA14 ON PUBLIC.SOCIALACTIVITYSET(CLASSNAMEID,CLASSPK,TYPE_) | |
| CREATE INDEX IX_9BE30DDF ON PUBLIC.SOCIALACTIVITYSET(GROUPID,USERID,CLASSNAMEID,TYPE_) | |
| CREATE INDEX IX_F71071BD ON PUBLIC.SOCIALACTIVITYSET(GROUPID,USERID,TYPE_) | |
| CREATE INDEX IX_62AC101A ON PUBLIC.SOCIALACTIVITYSET(USERID,CLASSNAMEID,CLASSPK,TYPE_) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALACTIVITYSETTING(ACTIVITYSETTINGID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,CLASSNAMEID BIGINT,ACTIVITYTYPE INTEGER,NAME VARCHAR(75),VALUE VARCHAR(1024)) | |
| CREATE INDEX IX_384788CD ON PUBLIC.SOCIALACTIVITYSETTING(GROUPID,ACTIVITYTYPE) | |
| CREATE INDEX IX_D984AABA ON PUBLIC.SOCIALACTIVITYSETTING(GROUPID,CLASSNAMEID,ACTIVITYTYPE,NAME) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALRELATION(UUID_ VARCHAR(75),RELATIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CREATEDATE BIGINT,USERID1 BIGINT,USERID2 BIGINT,TYPE_ INTEGER) | |
| CREATE INDEX IX_95135D1C ON PUBLIC.SOCIALRELATION(COMPANYID,TYPE_) | |
| CREATE INDEX IX_C31A64C6 ON PUBLIC.SOCIALRELATION(TYPE_) | |
| CREATE INDEX IX_4B52BE89 ON PUBLIC.SOCIALRELATION(USERID1,TYPE_) | |
| CREATE UNIQUE INDEX IX_12A92145 ON PUBLIC.SOCIALRELATION(USERID1,USERID2,TYPE_) | |
| CREATE INDEX IX_3F9C2FA8 ON PUBLIC.SOCIALRELATION(USERID2,TYPE_) | |
| CREATE INDEX IX_5B30F663 ON PUBLIC.SOCIALRELATION(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.SOCIALREQUEST(UUID_ VARCHAR(75),REQUESTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,CREATEDATE BIGINT,MODIFIEDDATE BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,TYPE_ INTEGER,EXTRADATA VARCHAR(16777216),RECEIVERUSERID BIGINT,STATUS INTEGER) | |
| CREATE INDEX IX_D3425487 ON PUBLIC.SOCIALREQUEST(CLASSNAMEID,CLASSPK,TYPE_,RECEIVERUSERID,STATUS) | |
| CREATE INDEX IX_A90FE5A0 ON PUBLIC.SOCIALREQUEST(COMPANYID) | |
| CREATE INDEX IX_D9380CB7 ON PUBLIC.SOCIALREQUEST(RECEIVERUSERID,STATUS) | |
| CREATE UNIQUE INDEX IX_36A90CA7 ON PUBLIC.SOCIALREQUEST(USERID,CLASSNAMEID,CLASSPK,TYPE_,RECEIVERUSERID) | |
| CREATE INDEX IX_CC86A444 ON PUBLIC.SOCIALREQUEST(USERID,CLASSNAMEID,CLASSPK,TYPE_,STATUS) | |
| CREATE INDEX IX_AB5906A8 ON PUBLIC.SOCIALREQUEST(USERID,STATUS) | |
| CREATE INDEX IX_8D42897C ON PUBLIC.SOCIALREQUEST(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_4F973EFE ON PUBLIC.SOCIALREQUEST(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.SUBSCRIPTION(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,SUBSCRIPTIONID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,FREQUENCY VARCHAR(75)) | |
| CREATE INDEX IX_786D171A ON PUBLIC.SUBSCRIPTION(COMPANYID,CLASSNAMEID,CLASSPK) | |
| CREATE UNIQUE INDEX IX_2E1A92D4 ON PUBLIC.SUBSCRIPTION(COMPANYID,USERID,CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_1290B81 ON PUBLIC.SUBSCRIPTION(GROUPID,USERID) | |
| CREATE INDEX IX_E8F34171 ON PUBLIC.SUBSCRIPTION(USERID,CLASSNAMEID) | |
| CREATE MEMORY TABLE PUBLIC.SYSTEMEVENT(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,SYSTEMEVENTID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,CLASSUUID VARCHAR(75),REFERRERCLASSNAMEID BIGINT,PARENTSYSTEMEVENTID BIGINT,SYSTEMEVENTSETKEY BIGINT,TYPE_ INTEGER,EXTRADATA VARCHAR(16777216)) | |
| CREATE INDEX IX_FFCBB747 ON PUBLIC.SYSTEMEVENT(GROUPID,CLASSNAMEID,CLASSPK,TYPE_) | |
| CREATE INDEX IX_A19C89FF ON PUBLIC.SYSTEMEVENT(GROUPID,SYSTEMEVENTSETKEY) | |
| CREATE MEMORY TABLE PUBLIC.TEAM(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),TEAMID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,GROUPID BIGINT,NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE UNIQUE INDEX IX_143DC786 ON PUBLIC.TEAM(GROUPID,NAME) | |
| CREATE INDEX IX_5D47F637 ON PUBLIC.TEAM(UUID_,COMPANYID) | |
| CREATE UNIQUE INDEX IX_39F69E79 ON PUBLIC.TEAM(UUID_,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.TICKET(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,TICKETID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CREATEDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,KEY_ VARCHAR(75),TYPE_ INTEGER,EXTRAINFO VARCHAR(16777216),EXPIRATIONDATE TIMESTAMP) | |
| CREATE INDEX IX_1E8DFB2E ON PUBLIC.TICKET(CLASSNAMEID,CLASSPK,TYPE_) | |
| CREATE INDEX IX_B2468446 ON PUBLIC.TICKET(KEY_) | |
| CREATE MEMORY TABLE PUBLIC.TRASHENTRY(ENTRYID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,SYSTEMEVENTSETKEY BIGINT,TYPESETTINGS VARCHAR(16777216),STATUS INTEGER) | |
| CREATE UNIQUE INDEX IX_B35F73D5 ON PUBLIC.TRASHENTRY(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_2674F2A8 ON PUBLIC.TRASHENTRY(COMPANYID) | |
| CREATE INDEX IX_FC4EEA64 ON PUBLIC.TRASHENTRY(GROUPID,CLASSNAMEID) | |
| CREATE INDEX IX_6CAAE2E8 ON PUBLIC.TRASHENTRY(GROUPID,CREATEDATE) | |
| CREATE MEMORY TABLE PUBLIC.TRASHVERSION(VERSIONID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,ENTRYID BIGINT,CLASSNAMEID BIGINT,CLASSPK BIGINT,TYPESETTINGS VARCHAR(16777216),STATUS INTEGER) | |
| CREATE UNIQUE INDEX IX_630A643B ON PUBLIC.TRASHVERSION(CLASSNAMEID,CLASSPK) | |
| CREATE INDEX IX_72D58D37 ON PUBLIC.TRASHVERSION(ENTRYID,CLASSNAMEID) | |
| CREATE MEMORY TABLE PUBLIC.USERNOTIFICATIONDELIVERY(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERNOTIFICATIONDELIVERYID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,PORTLETID VARCHAR(200),CLASSNAMEID BIGINT,NOTIFICATIONTYPE INTEGER,DELIVERYTYPE INTEGER,DELIVER BIT(1)) | |
| CREATE UNIQUE INDEX IX_8B6E3ACE ON PUBLIC.USERNOTIFICATIONDELIVERY(USERID,PORTLETID,CLASSNAMEID,NOTIFICATIONTYPE,DELIVERYTYPE) | |
| CREATE MEMORY TABLE PUBLIC.USER_(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),USERID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,DEFAULTUSER BIT(1),CONTACTID BIGINT,PASSWORD_ VARCHAR(75),PASSWORDENCRYPTED BIT(1),PASSWORDRESET BIT(1),PASSWORDMODIFIEDDATE TIMESTAMP,DIGEST VARCHAR(255),REMINDERQUERYQUESTION VARCHAR(75),REMINDERQUERYANSWER VARCHAR(75),GRACELOGINCOUNT INTEGER,SCREENNAME VARCHAR(75),EMAILADDRESS VARCHAR(75),FACEBOOKID BIGINT,GOOGLEUSERID VARCHAR(75),LDAPSERVERID BIGINT,OPENID VARCHAR(1024),PORTRAITID BIGINT,LANGUAGEID VARCHAR(75),TIMEZONEID VARCHAR(75),GREETING VARCHAR(255),COMMENTS VARCHAR(16777216),FIRSTNAME VARCHAR(75),MIDDLENAME VARCHAR(75),LASTNAME VARCHAR(75),JOBTITLE VARCHAR(100),LOGINDATE TIMESTAMP,LOGINIP VARCHAR(75),LASTLOGINDATE TIMESTAMP,LASTLOGINIP VARCHAR(75),LASTFAILEDLOGINDATE TIMESTAMP,FAILEDLOGINATTEMPTS INTEGER,LOCKOUT BIT(1),LOCKOUTDATE TIMESTAMP,AGREEDTOTERMSOFUSE BIT(1),EMAILADDRESSVERIFIED BIT(1),STATUS INTEGER) | |
| CREATE INDEX IX_BCFDA257 ON PUBLIC.USER_(COMPANYID,CREATEDATE,MODIFIEDDATE) | |
| CREATE INDEX IX_C6EA4F34 ON PUBLIC.USER_(COMPANYID,DEFAULTUSER,STATUS) | |
| CREATE UNIQUE INDEX IX_615E9F7A ON PUBLIC.USER_(COMPANYID,EMAILADDRESS) | |
| CREATE INDEX IX_1D731F03 ON PUBLIC.USER_(COMPANYID,FACEBOOKID) | |
| CREATE INDEX IX_B6E3AE1 ON PUBLIC.USER_(COMPANYID,GOOGLEUSERID) | |
| CREATE INDEX IX_EE8ABD19 ON PUBLIC.USER_(COMPANYID,MODIFIEDDATE) | |
| CREATE INDEX IX_89509087 ON PUBLIC.USER_(COMPANYID,OPENID) | |
| CREATE UNIQUE INDEX IX_C5806019 ON PUBLIC.USER_(COMPANYID,SCREENNAME) | |
| CREATE INDEX IX_F6039434 ON PUBLIC.USER_(COMPANYID,STATUS) | |
| CREATE UNIQUE INDEX IX_9782AD88 ON PUBLIC.USER_(COMPANYID,USERID) | |
| CREATE UNIQUE INDEX IX_5ADBE171 ON PUBLIC.USER_(CONTACTID) | |
| CREATE INDEX IX_762F63C6 ON PUBLIC.USER_(EMAILADDRESS) | |
| CREATE INDEX IX_A18034A4 ON PUBLIC.USER_(PORTRAITID) | |
| CREATE INDEX IX_405CC0E ON PUBLIC.USER_(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.USERGROUP(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),USERGROUPID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,PARENTUSERGROUPID BIGINT,NAME VARCHAR(75),DESCRIPTION VARCHAR(16777216),ADDEDBYLDAPIMPORT BIT(1)) | |
| CREATE UNIQUE INDEX IX_23EAD0D ON PUBLIC.USERGROUP(COMPANYID,NAME) | |
| CREATE INDEX IX_69771487 ON PUBLIC.USERGROUP(COMPANYID,PARENTUSERGROUPID) | |
| CREATE INDEX IX_72394F8E ON PUBLIC.USERGROUP(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.USERGROUPGROUPROLE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERGROUPID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,ROLEID BIGINT NOT NULL,COMPANYID BIGINT,PRIMARY KEY(USERGROUPID,GROUPID,ROLEID)) | |
| CREATE INDEX IX_CAB0CCC8 ON PUBLIC.USERGROUPGROUPROLE(GROUPID,ROLEID) | |
| CREATE INDEX IX_1CDF88C ON PUBLIC.USERGROUPGROUPROLE(ROLEID) | |
| CREATE INDEX IX_73C52252 ON PUBLIC.USERGROUPGROUPROLE(USERGROUPID,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.USERGROUPROLE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,ROLEID BIGINT NOT NULL,COMPANYID BIGINT,PRIMARY KEY(USERID,GROUPID,ROLEID)) | |
| CREATE INDEX IX_871412DF ON PUBLIC.USERGROUPROLE(GROUPID,ROLEID) | |
| CREATE INDEX IX_887A2C95 ON PUBLIC.USERGROUPROLE(ROLEID) | |
| CREATE INDEX IX_4D040680 ON PUBLIC.USERGROUPROLE(USERID,GROUPID) | |
| CREATE MEMORY TABLE PUBLIC.USERGROUPS_TEAMS(COMPANYID BIGINT NOT NULL,TEAMID BIGINT NOT NULL,USERGROUPID BIGINT NOT NULL,PRIMARY KEY(TEAMID,USERGROUPID)) | |
| CREATE INDEX IX_2AC5356C ON PUBLIC.USERGROUPS_TEAMS(COMPANYID) | |
| CREATE INDEX IX_31FB0B08 ON PUBLIC.USERGROUPS_TEAMS(TEAMID) | |
| CREATE INDEX IX_7F187E63 ON PUBLIC.USERGROUPS_TEAMS(USERGROUPID) | |
| CREATE MEMORY TABLE PUBLIC.USERIDMAPPER(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERIDMAPPERID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,TYPE_ VARCHAR(75),DESCRIPTION VARCHAR(75),EXTERNALUSERID VARCHAR(75)) | |
| CREATE UNIQUE INDEX IX_41A32E0D ON PUBLIC.USERIDMAPPER(TYPE_,EXTERNALUSERID) | |
| CREATE UNIQUE INDEX IX_D1C44A6E ON PUBLIC.USERIDMAPPER(USERID,TYPE_) | |
| CREATE MEMORY TABLE PUBLIC.USERNOTIFICATIONEVENT(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),USERNOTIFICATIONEVENTID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,TYPE_ VARCHAR(200),TIMESTAMP BIGINT,DELIVERYTYPE INTEGER,DELIVERBY BIGINT,DELIVERED BIT(1),PAYLOAD VARCHAR(16777216),ACTIONREQUIRED BIT(1),ARCHIVED BIT(1)) | |
| CREATE INDEX IX_BF29100B ON PUBLIC.USERNOTIFICATIONEVENT(TYPE_) | |
| CREATE INDEX IX_5CE95F03 ON PUBLIC.USERNOTIFICATIONEVENT(USERID,ACTIONREQUIRED,ARCHIVED) | |
| CREATE INDEX IX_3DBB361A ON PUBLIC.USERNOTIFICATIONEVENT(USERID,ARCHIVED) | |
| CREATE INDEX IX_E32CC19 ON PUBLIC.USERNOTIFICATIONEVENT(USERID,DELIVERED,ACTIONREQUIRED) | |
| CREATE INDEX IX_C4EFBD45 ON PUBLIC.USERNOTIFICATIONEVENT(USERID,DELIVERYTYPE,ACTIONREQUIRED,ARCHIVED) | |
| CREATE INDEX IX_A87A585C ON PUBLIC.USERNOTIFICATIONEVENT(USERID,DELIVERYTYPE,ARCHIVED) | |
| CREATE INDEX IX_A6F83617 ON PUBLIC.USERNOTIFICATIONEVENT(USERID,DELIVERYTYPE,DELIVERED,ACTIONREQUIRED) | |
| CREATE INDEX IX_8FB65EC1 ON PUBLIC.USERNOTIFICATIONEVENT(USERID,TYPE_,DELIVERYTYPE,DELIVERED) | |
| CREATE INDEX IX_A6BAFDFE ON PUBLIC.USERNOTIFICATIONEVENT(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.USERS_GROUPS(COMPANYID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,USERID BIGINT NOT NULL,PRIMARY KEY(GROUPID,USERID)) | |
| CREATE INDEX IX_3499B657 ON PUBLIC.USERS_GROUPS(COMPANYID) | |
| CREATE INDEX IX_C4F9E699 ON PUBLIC.USERS_GROUPS(GROUPID) | |
| CREATE INDEX IX_F10B6C6B ON PUBLIC.USERS_GROUPS(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERS_ORGS(COMPANYID BIGINT NOT NULL,ORGANIZATIONID BIGINT NOT NULL,USERID BIGINT NOT NULL,PRIMARY KEY(ORGANIZATIONID,USERID)) | |
| CREATE INDEX IX_5FBB883C ON PUBLIC.USERS_ORGS(COMPANYID) | |
| CREATE INDEX IX_7EF4EC0E ON PUBLIC.USERS_ORGS(ORGANIZATIONID) | |
| CREATE INDEX IX_FB646CA6 ON PUBLIC.USERS_ORGS(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERS_ROLES(COMPANYID BIGINT NOT NULL,ROLEID BIGINT NOT NULL,USERID BIGINT NOT NULL,PRIMARY KEY(ROLEID,USERID)) | |
| CREATE INDEX IX_F987A0DC ON PUBLIC.USERS_ROLES(COMPANYID) | |
| CREATE INDEX IX_C19E5F31 ON PUBLIC.USERS_ROLES(ROLEID) | |
| CREATE INDEX IX_C1A01806 ON PUBLIC.USERS_ROLES(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERS_TEAMS(COMPANYID BIGINT NOT NULL,TEAMID BIGINT NOT NULL,USERID BIGINT NOT NULL,PRIMARY KEY(TEAMID,USERID)) | |
| CREATE INDEX IX_799F8283 ON PUBLIC.USERS_TEAMS(COMPANYID) | |
| CREATE INDEX IX_4D06AD51 ON PUBLIC.USERS_TEAMS(TEAMID) | |
| CREATE INDEX IX_A098EFBF ON PUBLIC.USERS_TEAMS(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERS_USERGROUPS(COMPANYID BIGINT NOT NULL,USERID BIGINT NOT NULL,USERGROUPID BIGINT NOT NULL,PRIMARY KEY(USERID,USERGROUPID)) | |
| CREATE INDEX IX_BB65040C ON PUBLIC.USERS_USERGROUPS(COMPANYID) | |
| CREATE INDEX IX_66FF2503 ON PUBLIC.USERS_USERGROUPS(USERGROUPID) | |
| CREATE INDEX IX_BE8102D6 ON PUBLIC.USERS_USERGROUPS(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERTRACKER(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERTRACKERID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,MODIFIEDDATE TIMESTAMP,SESSIONID VARCHAR(200),REMOTEADDR VARCHAR(75),REMOTEHOST VARCHAR(75),USERAGENT VARCHAR(200)) | |
| CREATE INDEX IX_29BA1CF5 ON PUBLIC.USERTRACKER(COMPANYID) | |
| CREATE INDEX IX_46B0AE8E ON PUBLIC.USERTRACKER(SESSIONID) | |
| CREATE INDEX IX_E4EFBA8D ON PUBLIC.USERTRACKER(USERID) | |
| CREATE MEMORY TABLE PUBLIC.USERTRACKERPATH(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,USERTRACKERPATHID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERTRACKERID BIGINT,PATH_ VARCHAR(16777216),PATHDATE TIMESTAMP) | |
| CREATE INDEX IX_14D8BCC0 ON PUBLIC.USERTRACKERPATH(USERTRACKERID) | |
| CREATE MEMORY TABLE PUBLIC.VIRTUALHOST(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,VIRTUALHOSTID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,LAYOUTSETID BIGINT,HOSTNAME VARCHAR(75)) | |
| CREATE UNIQUE INDEX IX_A083D394 ON PUBLIC.VIRTUALHOST(COMPANYID,LAYOUTSETID) | |
| CREATE UNIQUE INDEX IX_431A3960 ON PUBLIC.VIRTUALHOST(HOSTNAME) | |
| CREATE MEMORY TABLE PUBLIC.WEBDAVPROPS(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,WEBDAVPROPSID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,PROPS VARCHAR(16777216)) | |
| CREATE UNIQUE INDEX IX_97DFA146 ON PUBLIC.WEBDAVPROPS(CLASSNAMEID,CLASSPK) | |
| CREATE MEMORY TABLE PUBLIC.WEBSITE(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,UUID_ VARCHAR(75),WEBSITEID BIGINT NOT NULL PRIMARY KEY,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,URL VARCHAR(16777216),TYPEID BIGINT,PRIMARY_ BIT(1),LASTPUBLISHDATE TIMESTAMP) | |
| CREATE INDEX IX_1AA07A6D ON PUBLIC.WEBSITE(COMPANYID,CLASSNAMEID,CLASSPK,PRIMARY_) | |
| CREATE INDEX IX_F75690BB ON PUBLIC.WEBSITE(USERID) | |
| CREATE INDEX IX_712BCD35 ON PUBLIC.WEBSITE(UUID_,COMPANYID) | |
| CREATE MEMORY TABLE PUBLIC.WORKFLOWDEFINITIONLINK(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,WORKFLOWDEFINITIONLINKID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,TYPEPK BIGINT,WORKFLOWDEFINITIONNAME VARCHAR(75),WORKFLOWDEFINITIONVERSION INTEGER) | |
| CREATE INDEX IX_A4DB1F0F ON PUBLIC.WORKFLOWDEFINITIONLINK(COMPANYID,WORKFLOWDEFINITIONNAME,WORKFLOWDEFINITIONVERSION) | |
| CREATE INDEX IX_705B40EE ON PUBLIC.WORKFLOWDEFINITIONLINK(GROUPID,COMPANYID,CLASSNAMEID,CLASSPK,TYPEPK) | |
| CREATE MEMORY TABLE PUBLIC.WORKFLOWINSTANCELINK(MVCCVERSION BIGINT DEFAULT 0 NOT NULL,WORKFLOWINSTANCELINKID BIGINT NOT NULL PRIMARY KEY,GROUPID BIGINT,COMPANYID BIGINT,USERID BIGINT,USERNAME VARCHAR(75),CREATEDATE TIMESTAMP,MODIFIEDDATE TIMESTAMP,CLASSNAMEID BIGINT,CLASSPK BIGINT,WORKFLOWINSTANCEID BIGINT) | |
| CREATE INDEX IX_415A7007 ON PUBLIC.WORKFLOWINSTANCELINK(GROUPID,COMPANYID,CLASSNAMEID,CLASSPK) | |
| ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 | |
| SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC | |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC | |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC | |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC | |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC | |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC | |
| GRANT DBA TO SA | |
| SET SCHEMA SYSTEM_LOBS | |
| INSERT INTO BLOCKS VALUES(0,2147483647,0) | |
| SET SCHEMA PUBLIC | |
| INSERT INTO COUNTER VALUES('com.liferay.counter.kernel.model.Counter',20000) | |
| INSERT INTO COUNTRY VALUES(0,1,'canada','CA','CAN','124','001','1','1') | |
| INSERT INTO COUNTRY VALUES(0,2,'china','CN','CHN','156','086','1','1') | |
| INSERT INTO COUNTRY VALUES(0,3,'france','FR','FRA','250','033','1','1') | |
| INSERT INTO COUNTRY VALUES(0,4,'germany','DE','DEU','276','049','1','1') | |
| INSERT INTO COUNTRY VALUES(0,5,'hong-kong','HK','HKG','344','852','1','1') | |
| INSERT INTO COUNTRY VALUES(0,6,'hungary','HU','HUN','348','036','1','1') | |
| INSERT INTO COUNTRY VALUES(0,7,'israel','IL','ISR','376','972','1','1') | |
| INSERT INTO COUNTRY VALUES(0,8,'italy','IT','ITA','380','039','1','1') | |
| INSERT INTO COUNTRY VALUES(0,9,'japan','JP','JPN','392','081','0','1') | |
| INSERT INTO COUNTRY VALUES(0,10,'south-korea','KR','KOR','410','082','1','1') | |
| INSERT INTO COUNTRY VALUES(0,11,'netherlands','NL','NLD','528','031','1','1') | |
| INSERT INTO COUNTRY VALUES(0,12,'portugal','PT','PRT','620','351','1','1') | |
| INSERT INTO COUNTRY VALUES(0,13,'russia','RU','RUS','643','007','1','1') | |
| INSERT INTO COUNTRY VALUES(0,14,'singapore','SG','SGP','702','065','1','1') | |
| INSERT INTO COUNTRY VALUES(0,15,'spain','ES','ESP','724','034','1','1') | |
| INSERT INTO COUNTRY VALUES(0,16,'turkey','TR','TUR','792','090','1','1') | |
| INSERT INTO COUNTRY VALUES(0,17,'vietnam','VN','VNM','704','084','1','1') | |
| INSERT INTO COUNTRY VALUES(0,18,'united-kingdom','GB','GBR','826','044','1','1') | |
| INSERT INTO COUNTRY VALUES(0,19,'united-states','US','USA','840','001','1','1') | |
| INSERT INTO COUNTRY VALUES(0,20,'afghanistan','AF','AFG','4','093','1','1') | |
| INSERT INTO COUNTRY VALUES(0,21,'albania','AL','ALB','8','355','1','1') | |
| INSERT INTO COUNTRY VALUES(0,22,'algeria','DZ','DZA','12','213','1','1') | |
| INSERT INTO COUNTRY VALUES(0,23,'american-samoa','AS','ASM','16','684','1','1') | |
| INSERT INTO COUNTRY VALUES(0,24,'andorra','AD','AND','20','376','1','1') | |
| INSERT INTO COUNTRY VALUES(0,25,'angola','AO','AGO','24','244','0','1') | |
| INSERT INTO COUNTRY VALUES(0,26,'anguilla','AI','AIA','660','264','1','1') | |
| INSERT INTO COUNTRY VALUES(0,27,'antarctica','AQ','ATA','10','672','1','1') | |
| INSERT INTO COUNTRY VALUES(0,28,'antigua-barbuda','AG','ATG','28','268','0','1') | |
| INSERT INTO COUNTRY VALUES(0,29,'argentina','AR','ARG','32','054','1','1') | |
| INSERT INTO COUNTRY VALUES(0,30,'armenia','AM','ARM','51','374','1','1') | |
| INSERT INTO COUNTRY VALUES(0,31,'aruba','AW','ABW','533','297','0','1') | |
| INSERT INTO COUNTRY VALUES(0,32,'australia','AU','AUS','36','061','1','1') | |
| INSERT INTO COUNTRY VALUES(0,33,'austria','AT','AUT','40','043','1','1') | |
| INSERT INTO COUNTRY VALUES(0,34,'azerbaijan','AZ','AZE','31','994','1','1') | |
| INSERT INTO COUNTRY VALUES(0,35,'bahamas','BS','BHS','44','242','0','1') | |
| INSERT INTO COUNTRY VALUES(0,36,'bahrain','BH','BHR','48','973','1','1') | |
| INSERT INTO COUNTRY VALUES(0,37,'bangladesh','BD','BGD','50','880','1','1') | |
| INSERT INTO COUNTRY VALUES(0,38,'barbados','BB','BRB','52','246','1','1') | |
| INSERT INTO COUNTRY VALUES(0,39,'belarus','BY','BLR','112','375','1','1') | |
| INSERT INTO COUNTRY VALUES(0,40,'belgium','BE','BEL','56','032','1','1') | |
| INSERT INTO COUNTRY VALUES(0,41,'belize','BZ','BLZ','84','501','0','1') | |
| INSERT INTO COUNTRY VALUES(0,42,'benin','BJ','BEN','204','229','0','1') | |
| INSERT INTO COUNTRY VALUES(0,43,'bermuda','BM','BMU','60','441','1','1') | |
| INSERT INTO COUNTRY VALUES(0,44,'bhutan','BT','BTN','64','975','1','1') | |
| INSERT INTO COUNTRY VALUES(0,45,'bolivia','BO','BOL','68','591','1','1') | |
| INSERT INTO COUNTRY VALUES(0,46,'bosnia-herzegovina','BA','BIH','70','387','1','1') | |
| INSERT INTO COUNTRY VALUES(0,47,'botswana','BW','BWA','72','267','0','1') | |
| INSERT INTO COUNTRY VALUES(0,48,'brazil','BR','BRA','76','055','1','1') | |
| INSERT INTO COUNTRY VALUES(0,49,'british-virgin-islands','VG','VGB','92','284','1','1') | |
| INSERT INTO COUNTRY VALUES(0,50,'brunei','BN','BRN','96','673','1','1') | |
| INSERT INTO COUNTRY VALUES(0,51,'bulgaria','BG','BGR','100','359','1','1') | |
| INSERT INTO COUNTRY VALUES(0,52,'burkina-faso','BF','BFA','854','226','0','1') | |
| INSERT INTO COUNTRY VALUES(0,53,'burma-myanmar','MM','MMR','104','095','1','1') | |
| INSERT INTO COUNTRY VALUES(0,54,'burundi','BI','BDI','108','257','0','1') | |
| INSERT INTO COUNTRY VALUES(0,55,'cambodia','KH','KHM','116','855','1','1') | |
| INSERT INTO COUNTRY VALUES(0,56,'cameroon','CM','CMR','120','237','1','1') | |
| INSERT INTO COUNTRY VALUES(0,57,'cape-verde-island','CV','CPV','132','238','1','1') | |
| INSERT INTO COUNTRY VALUES(0,58,'cayman-islands','KY','CYM','136','345','1','1') | |
| INSERT INTO COUNTRY VALUES(0,59,'central-african-republic','CF','CAF','140','236','0','1') | |
| INSERT INTO COUNTRY VALUES(0,60,'chad','TD','TCD','148','235','1','1') | |
| INSERT INTO COUNTRY VALUES(0,61,'chile','CL','CHL','152','056','1','1') | |
| INSERT INTO COUNTRY VALUES(0,62,'christmas-island','CX','CXR','162','061','1','1') | |
| INSERT INTO COUNTRY VALUES(0,63,'cocos-islands','CC','CCK','166','061','1','1') | |
| INSERT INTO COUNTRY VALUES(0,64,'colombia','CO','COL','170','057','1','1') | |
| INSERT INTO COUNTRY VALUES(0,65,'comoros','KM','COM','174','269','0','1') | |
| INSERT INTO COUNTRY VALUES(0,66,'republic-of-congo','CD','COD','180','242','0','1') | |
| INSERT INTO COUNTRY VALUES(0,67,'democratic-republic-of-congo','CG','COG','178','243','0','1') | |
| INSERT INTO COUNTRY VALUES(0,68,'cook-islands','CK','COK','184','682','0','1') | |
| INSERT INTO COUNTRY VALUES(0,69,'costa-rica','CR','CRI','188','506','1','1') | |
| INSERT INTO COUNTRY VALUES(0,70,'croatia','HR','HRV','191','385','1','1') | |
| INSERT INTO COUNTRY VALUES(0,71,'cuba','CU','CUB','192','053','1','1') | |
| INSERT INTO COUNTRY VALUES(0,72,'cyprus','CY','CYP','196','357','1','1') | |
| INSERT INTO COUNTRY VALUES(0,73,'czech-republic','CZ','CZE','203','420','1','1') | |
| INSERT INTO COUNTRY VALUES(0,74,'denmark','DK','DNK','208','045','1','1') | |
| INSERT INTO COUNTRY VALUES(0,75,'djibouti','DJ','DJI','262','253','0','1') | |
| INSERT INTO COUNTRY VALUES(0,76,'dominica','DM','DMA','212','767','0','1') | |
| INSERT INTO COUNTRY VALUES(0,77,'dominican-republic','DO','DOM','214','809','1','1') | |
| INSERT INTO COUNTRY VALUES(0,78,'ecuador','EC','ECU','218','593','1','1') | |
| INSERT INTO COUNTRY VALUES(0,79,'egypt','EG','EGY','818','020','1','1') | |
| INSERT INTO COUNTRY VALUES(0,80,'el-salvador','SV','SLV','222','503','1','1') | |
| INSERT INTO COUNTRY VALUES(0,81,'equatorial-guinea','GQ','GNQ','226','240','0','1') | |
| INSERT INTO COUNTRY VALUES(0,82,'eritrea','ER','ERI','232','291','0','1') | |
| INSERT INTO COUNTRY VALUES(0,83,'estonia','EE','EST','233','372','1','1') | |
| INSERT INTO COUNTRY VALUES(0,84,'ethiopia','ET','ETH','231','251','1','1') | |
| INSERT INTO COUNTRY VALUES(0,85,'faeroe-islands','FO','FRO','234','298','1','1') | |
| INSERT INTO COUNTRY VALUES(0,86,'falkland-islands','FK','FLK','238','500','1','1') | |
| INSERT INTO COUNTRY VALUES(0,87,'fiji-islands','FJ','FJI','242','679','0','1') | |
| INSERT INTO COUNTRY VALUES(0,88,'finland','FI','FIN','246','358','1','1') | |
| INSERT INTO COUNTRY VALUES(0,89,'french-guiana','GF','GUF','254','594','1','1') | |
| INSERT INTO COUNTRY VALUES(0,90,'french-polynesia','PF','PYF','258','689','1','1') | |
| INSERT INTO COUNTRY VALUES(0,91,'gabon','GA','GAB','266','241','1','1') | |
| INSERT INTO COUNTRY VALUES(0,92,'gambia','GM','GMB','270','220','0','1') | |
| INSERT INTO COUNTRY VALUES(0,93,'georgia','GE','GEO','268','995','1','1') | |
| INSERT INTO COUNTRY VALUES(0,94,'ghana','GH','GHA','288','233','0','1') | |
| INSERT INTO COUNTRY VALUES(0,95,'gibraltar','GI','GIB','292','350','1','1') | |
| INSERT INTO COUNTRY VALUES(0,96,'greece','GR','GRC','300','030','1','1') | |
| INSERT INTO COUNTRY VALUES(0,97,'greenland','GL','GRL','304','299','1','1') | |
| INSERT INTO COUNTRY VALUES(0,98,'grenada','GD','GRD','308','473','0','1') | |
| INSERT INTO COUNTRY VALUES(0,99,'guadeloupe','GP','GLP','312','590','1','1') | |
| INSERT INTO COUNTRY VALUES(0,100,'guam','GU','GUM','316','671','1','1') | |
| INSERT INTO COUNTRY VALUES(0,101,'guatemala','GT','GTM','320','502','1','1') | |
| INSERT INTO COUNTRY VALUES(0,102,'guinea','GN','GIN','324','224','0','1') | |
| INSERT INTO COUNTRY VALUES(0,103,'guinea-bissau','GW','GNB','624','245','1','1') | |
| INSERT INTO COUNTRY VALUES(0,104,'guyana','GY','GUY','328','592','0','1') | |
| INSERT INTO COUNTRY VALUES(0,105,'haiti','HT','HTI','332','509','1','1') | |
| INSERT INTO COUNTRY VALUES(0,106,'honduras','HN','HND','340','504','1','1') | |
| INSERT INTO COUNTRY VALUES(0,107,'iceland','IS','ISL','352','354','1','1') | |
| INSERT INTO COUNTRY VALUES(0,108,'india','IN','IND','356','091','1','1') | |
| INSERT INTO COUNTRY VALUES(0,109,'indonesia','ID','IDN','360','062','1','1') | |
| INSERT INTO COUNTRY VALUES(0,110,'iran','IR','IRN','364','098','1','1') | |
| INSERT INTO COUNTRY VALUES(0,111,'iraq','IQ','IRQ','368','964','1','1') | |
| INSERT INTO COUNTRY VALUES(0,112,'ireland','IE','IRL','372','353','0','1') | |
| INSERT INTO COUNTRY VALUES(0,113,'ivory-coast','CI','CIV','384','225','1','1') | |
| INSERT INTO COUNTRY VALUES(0,114,'jamaica','JM','JAM','388','876','1','1') | |
| INSERT INTO COUNTRY VALUES(0,115,'jordan','JO','JOR','400','962','1','1') | |
| INSERT INTO COUNTRY VALUES(0,116,'kazakhstan','KZ','KAZ','398','007','1','1') | |
| INSERT INTO COUNTRY VALUES(0,117,'kenya','KE','KEN','404','254','1','1') | |
| INSERT INTO COUNTRY VALUES(0,118,'kiribati','KI','KIR','408','686','0','1') | |
| INSERT INTO COUNTRY VALUES(0,119,'kuwait','KW','KWT','414','965','1','1') | |
| INSERT INTO COUNTRY VALUES(0,120,'north-korea','KP','PRK','408','850','0','1') | |
| INSERT INTO COUNTRY VALUES(0,121,'kyrgyzstan','KG','KGZ','471','996','1','1') | |
| INSERT INTO COUNTRY VALUES(0,122,'laos','LA','LAO','418','856','1','1') | |
| INSERT INTO COUNTRY VALUES(0,123,'latvia','LV','LVA','428','371','1','1') | |
| INSERT INTO COUNTRY VALUES(0,124,'lebanon','LB','LBN','422','961','1','1') | |
| INSERT INTO COUNTRY VALUES(0,125,'lesotho','LS','LSO','426','266','1','1') | |
| INSERT INTO COUNTRY VALUES(0,126,'liberia','LR','LBR','430','231','1','1') | |
| INSERT INTO COUNTRY VALUES(0,127,'libya','LY','LBY','434','218','1','1') | |
| INSERT INTO COUNTRY VALUES(0,128,'liechtenstein','LI','LIE','438','423','1','1') | |
| INSERT INTO COUNTRY VALUES(0,129,'lithuania','LT','LTU','440','370','1','1') | |
| INSERT INTO COUNTRY VALUES(0,130,'luxembourg','LU','LUX','442','352','1','1') | |
| INSERT INTO COUNTRY VALUES(0,131,'macau','MO','MAC','446','853','0','1') | |
| INSERT INTO COUNTRY VALUES(0,132,'macedonia','MK','MKD','807','389','1','1') | |
| INSERT INTO COUNTRY VALUES(0,133,'madagascar','MG','MDG','450','261','1','1') | |
| INSERT INTO COUNTRY VALUES(0,134,'malawi','MW','MWI','454','265','0','1') | |
| INSERT INTO COUNTRY VALUES(0,135,'malaysia','MY','MYS','458','060','1','1') | |
| INSERT INTO COUNTRY VALUES(0,136,'maldives','MV','MDV','462','960','1','1') | |
| INSERT INTO COUNTRY VALUES(0,137,'mali','ML','MLI','466','223','0','1') | |
| INSERT INTO COUNTRY VALUES(0,138,'malta','MT','MLT','470','356','1','1') | |
| INSERT INTO COUNTRY VALUES(0,139,'marshall-islands','MH','MHL','584','692','1','1') | |
| INSERT INTO COUNTRY VALUES(0,140,'martinique','MQ','MTQ','474','596','1','1') | |
| INSERT INTO COUNTRY VALUES(0,141,'mauritania','MR','MRT','478','222','0','1') | |
| INSERT INTO COUNTRY VALUES(0,142,'mauritius','MU','MUS','480','230','0','1') | |
| INSERT INTO COUNTRY VALUES(0,143,'mayotte-island','YT','MYT','175','269','1','1') | |
| INSERT INTO COUNTRY VALUES(0,144,'mexico','MX','MEX','484','052','1','1') | |
| INSERT INTO COUNTRY VALUES(0,145,'micronesia','FM','FSM','583','691','1','1') | |
| INSERT INTO COUNTRY VALUES(0,146,'moldova','MD','MDA','498','373','1','1') | |
| INSERT INTO COUNTRY VALUES(0,147,'monaco','MC','MCO','492','377','1','1') | |
| INSERT INTO COUNTRY VALUES(0,148,'mongolia','MN','MNG','496','976','1','1') | |
| INSERT INTO COUNTRY VALUES(0,149,'montenegro','ME','MNE','499','382','1','1') | |
| INSERT INTO COUNTRY VALUES(0,150,'montserrat','MS','MSR','500','664','0','1') | |
| INSERT INTO COUNTRY VALUES(0,151,'morocco','MA','MAR','504','212','1','1') | |
| INSERT INTO COUNTRY VALUES(0,152,'mozambique','MZ','MOZ','508','258','1','1') | |
| INSERT INTO COUNTRY VALUES(0,153,'namibia','NA','NAM','516','264','1','1') | |
| INSERT INTO COUNTRY VALUES(0,154,'nauru','NR','NRU','520','674','0','1') | |
| INSERT INTO COUNTRY VALUES(0,155,'nepal','NP','NPL','524','977','1','1') | |
| INSERT INTO COUNTRY VALUES(0,156,'netherlands-antilles','AN','ANT','530','599','1','1') | |
| INSERT INTO COUNTRY VALUES(0,157,'new-caledonia','NC','NCL','540','687','1','1') | |
| INSERT INTO COUNTRY VALUES(0,158,'new-zealand','NZ','NZL','554','064','1','1') | |
| INSERT INTO COUNTRY VALUES(0,159,'nicaragua','NI','NIC','558','505','1','1') | |
| INSERT INTO COUNTRY VALUES(0,160,'niger','NE','NER','562','227','1','1') | |
| INSERT INTO COUNTRY VALUES(0,161,'nigeria','NG','NGA','566','234','1','1') | |
| INSERT INTO COUNTRY VALUES(0,162,'niue','NU','NIU','570','683','0','1') | |
| INSERT INTO COUNTRY VALUES(0,163,'norfolk-island','NF','NFK','574','672','1','1') | |
| INSERT INTO COUNTRY VALUES(0,164,'norway','NO','NOR','578','047','1','1') | |
| INSERT INTO COUNTRY VALUES(0,165,'oman','OM','OMN','512','968','1','1') | |
| INSERT INTO COUNTRY VALUES(0,166,'pakistan','PK','PAK','586','092','1','1') | |
| INSERT INTO COUNTRY VALUES(0,167,'palau','PW','PLW','585','680','1','1') | |
| INSERT INTO COUNTRY VALUES(0,168,'palestine','PS','PSE','275','970','1','1') | |
| INSERT INTO COUNTRY VALUES(0,169,'panama','PA','PAN','591','507','1','1') | |
| INSERT INTO COUNTRY VALUES(0,170,'papua-new-guinea','PG','PNG','598','675','1','1') | |
| INSERT INTO COUNTRY VALUES(0,171,'paraguay','PY','PRY','600','595','1','1') | |
| INSERT INTO COUNTRY VALUES(0,172,'peru','PE','PER','604','051','1','1') | |
| INSERT INTO COUNTRY VALUES(0,173,'philippines','PH','PHL','608','063','1','1') | |
| INSERT INTO COUNTRY VALUES(0,174,'poland','PL','POL','616','048','1','1') | |
| INSERT INTO COUNTRY VALUES(0,175,'puerto-rico','PR','PRI','630','787','1','1') | |
| INSERT INTO COUNTRY VALUES(0,176,'qatar','QA','QAT','634','974','0','1') | |
| INSERT INTO COUNTRY VALUES(0,177,'reunion-island','RE','REU','638','262','1','1') | |
| INSERT INTO COUNTRY VALUES(0,178,'romania','RO','ROU','642','040','1','1') | |
| INSERT INTO COUNTRY VALUES(0,179,'rwanda','RW','RWA','646','250','0','1') | |
| INSERT INTO COUNTRY VALUES(0,180,'st-helena','SH','SHN','654','290','1','1') | |
| INSERT INTO COUNTRY VALUES(0,181,'st-kitts','KN','KNA','659','869','0','1') | |
| INSERT INTO COUNTRY VALUES(0,182,'st-lucia','LC','LCA','662','758','0','1') | |
| INSERT INTO COUNTRY VALUES(0,183,'st-pierre-miquelon','PM','SPM','666','508','1','1') | |
| INSERT INTO COUNTRY VALUES(0,184,'st-vincent','VC','VCT','670','784','1','1') | |
| INSERT INTO COUNTRY VALUES(0,185,'san-marino','SM','SMR','674','378','1','1') | |
| INSERT INTO COUNTRY VALUES(0,186,'sao-tome-principe','ST','STP','678','239','0','1') | |
| INSERT INTO COUNTRY VALUES(0,187,'saudi-arabia','SA','SAU','682','966','1','1') | |
| INSERT INTO COUNTRY VALUES(0,188,'senegal','SN','SEN','686','221','1','1') | |
| INSERT INTO COUNTRY VALUES(0,189,'serbia','RS','SRB','688','381','1','1') | |
| INSERT INTO COUNTRY VALUES(0,190,'seychelles','SC','SYC','690','248','0','1') | |
| INSERT INTO COUNTRY VALUES(0,191,'sierra-leone','SL','SLE','694','249','0','1') | |
| INSERT INTO COUNTRY VALUES(0,192,'slovakia','SK','SVK','703','421','1','1') | |
| INSERT INTO COUNTRY VALUES(0,193,'slovenia','SI','SVN','705','386','1','1') | |
| INSERT INTO COUNTRY VALUES(0,194,'solomon-islands','SB','SLB','90','677','0','1') | |
| INSERT INTO COUNTRY VALUES(0,195,'somalia','SO','SOM','706','252','0','1') | |
| INSERT INTO COUNTRY VALUES(0,196,'south-africa','ZA','ZAF','710','027','1','1') | |
| INSERT INTO COUNTRY VALUES(0,197,'sri-lanka','LK','LKA','144','094','1','1') | |
| INSERT INTO COUNTRY VALUES(0,198,'sudan','SD','SDN','736','095','1','1') | |
| INSERT INTO COUNTRY VALUES(0,199,'suriname','SR','SUR','740','597','0','1') | |
| INSERT INTO COUNTRY VALUES(0,200,'swaziland','SZ','SWZ','748','268','1','1') | |
| INSERT INTO COUNTRY VALUES(0,201,'sweden','SE','SWE','752','046','1','1') | |
| INSERT INTO COUNTRY VALUES(0,202,'switzerland','CH','CHE','756','041','1','1') | |
| INSERT INTO COUNTRY VALUES(0,203,'syria','SY','SYR','760','963','0','1') | |
| INSERT INTO COUNTRY VALUES(0,204,'taiwan','TW','TWN','158','886','1','1') | |
| INSERT INTO COUNTRY VALUES(0,205,'tajikistan','TJ','TJK','762','992','1','1') | |
| INSERT INTO COUNTRY VALUES(0,206,'tanzania','TZ','TZA','834','255','0','1') | |
| INSERT INTO COUNTRY VALUES(0,207,'thailand','TH','THA','764','066','1','1') | |
| INSERT INTO COUNTRY VALUES(0,208,'togo','TG','TGO','768','228','1','1') | |
| INSERT INTO COUNTRY VALUES(0,209,'tonga','TO','TON','776','676','0','1') | |
| INSERT INTO COUNTRY VALUES(0,210,'trinidad-tobago','TT','TTO','780','868','0','1') | |
| INSERT INTO COUNTRY VALUES(0,211,'tunisia','TN','TUN','788','216','1','1') | |
| INSERT INTO COUNTRY VALUES(0,212,'turkmenistan','TM','TKM','795','993','1','1') | |
| INSERT INTO COUNTRY VALUES(0,213,'turks-caicos','TC','TCA','796','649','1','1') | |
| INSERT INTO COUNTRY VALUES(0,214,'tuvalu','TV','TUV','798','688','0','1') | |
| INSERT INTO COUNTRY VALUES(0,215,'uganda','UG','UGA','800','256','0','1') | |
| INSERT INTO COUNTRY VALUES(0,216,'ukraine','UA','UKR','804','380','1','1') | |
| INSERT INTO COUNTRY VALUES(0,217,'united-arab-emirates','AE','ARE','784','971','0','1') | |
| INSERT INTO COUNTRY VALUES(0,218,'uruguay','UY','URY','858','598','1','1') | |
| INSERT INTO COUNTRY VALUES(0,219,'uzbekistan','UZ','UZB','860','998','1','1') | |
| INSERT INTO COUNTRY VALUES(0,220,'vanuatu','VU','VUT','548','678','0','1') | |
| INSERT INTO COUNTRY VALUES(0,221,'vatican-city','VA','VAT','336','039','1','1') | |
| INSERT INTO COUNTRY VALUES(0,222,'venezuela','VE','VEN','862','058','1','1') | |
| INSERT INTO COUNTRY VALUES(0,223,'wallis-futuna','WF','WLF','876','681','1','1') | |
| INSERT INTO COUNTRY VALUES(0,224,'western-samoa','WS','WSM','882','685','1','1') | |
| INSERT INTO COUNTRY VALUES(0,225,'yemen','YE','YEM','887','967','0','1') | |
| INSERT INTO COUNTRY VALUES(0,226,'zambia','ZM','ZMB','894','260','1','1') | |
| INSERT INTO COUNTRY VALUES(0,227,'zimbabwe','ZW','ZWE','716','263','0','1') | |
| INSERT INTO COUNTRY VALUES(0,228,'aland-islands','AX','ALA','248','359','1','1') | |
| INSERT INTO COUNTRY VALUES(0,229,'bonaire-st-eustatius-saba','BQ','BES','535','599','1','1') | |
| INSERT INTO COUNTRY VALUES(0,230,'bouvet-island','BV','BVT','74','047','1','1') | |
| INSERT INTO COUNTRY VALUES(0,231,'british-indian-ocean-territory','IO','IOT','86','246','1','1') | |
| INSERT INTO COUNTRY VALUES(0,232,'curacao','CW','CUW','531','599','1','1') | |
| INSERT INTO COUNTRY VALUES(0,233,'french-southern-territories','TF','ATF','260','033','0','1') | |
| INSERT INTO COUNTRY VALUES(0,234,'guernsey','GG','GGY','831','044','1','1') | |
| INSERT INTO COUNTRY VALUES(0,235,'heard-island-mcdonald-islands','HM','HMD','334','061','1','1') | |
| INSERT INTO COUNTRY VALUES(0,236,'isle-of-man','IM','IMN','833','044','1','1') | |
| INSERT INTO COUNTRY VALUES(0,237,'jersey','JE','JEY','832','044','1','1') | |
| INSERT INTO COUNTRY VALUES(0,238,'northern-mariana-islands','MP','MNP','580','670','1','1') | |
| INSERT INTO COUNTRY VALUES(0,239,'pitcairn','PN','PCN','612','649','1','1') | |
| INSERT INTO COUNTRY VALUES(0,240,'south-georgia-south-sandwich-islands','GS','SGS','239','044','1','1') | |
| INSERT INTO COUNTRY VALUES(0,241,'south-sudan','SS','SSD','728','211','1','1') | |
| INSERT INTO COUNTRY VALUES(0,242,'sint-maarten','SX','SXM','534','721','1','1') | |
| INSERT INTO COUNTRY VALUES(0,243,'st-barthelemy','BL','BLM','652','590','1','1') | |
| INSERT INTO COUNTRY VALUES(0,244,'st-martin','MF','MAF','663','590','1','1') | |
| INSERT INTO COUNTRY VALUES(0,245,'tokelau','TK','TKL','772','690','0','1') | |
| INSERT INTO COUNTRY VALUES(0,246,'timor-leste','TL','TLS','626','670','1','1') | |
| INSERT INTO COUNTRY VALUES(0,247,'united-states-minor-outlying-islands','UM','UMI','581','699','1','1') | |
| INSERT INTO COUNTRY VALUES(0,248,'united-states-virgin-islands','VI','VIR','850','340','1','1') | |
| INSERT INTO COUNTRY VALUES(0,249,'western-sahara','EH','ESH','732','212','1','1') | |
| INSERT INTO LISTTYPE VALUES(0,10000,'billing','com.liferay.portal.kernel.model.Account.address') | |
| INSERT INTO LISTTYPE VALUES(0,10001,'other','com.liferay.portal.kernel.model.Account.address') | |
| INSERT INTO LISTTYPE VALUES(0,10002,'p-o-box','com.liferay.portal.kernel.model.Account.address') | |
| INSERT INTO LISTTYPE VALUES(0,10003,'shipping','com.liferay.portal.kernel.model.Account.address') | |
| INSERT INTO LISTTYPE VALUES(0,10004,'email-address','com.liferay.portal.kernel.model.Account.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,10005,'email-address-2','com.liferay.portal.kernel.model.Account.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,10006,'email-address-3','com.liferay.portal.kernel.model.Account.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,10007,'fax','com.liferay.portal.kernel.model.Account.phone') | |
| INSERT INTO LISTTYPE VALUES(0,10008,'local','com.liferay.portal.kernel.model.Account.phone') | |
| INSERT INTO LISTTYPE VALUES(0,10009,'other','com.liferay.portal.kernel.model.Account.phone') | |
| INSERT INTO LISTTYPE VALUES(0,10010,'toll-free','com.liferay.portal.kernel.model.Account.phone') | |
| INSERT INTO LISTTYPE VALUES(0,10011,'tty','com.liferay.portal.kernel.model.Account.phone') | |
| INSERT INTO LISTTYPE VALUES(0,10012,'intranet','com.liferay.portal.kernel.model.Account.website') | |
| INSERT INTO LISTTYPE VALUES(0,10013,'public','com.liferay.portal.kernel.model.Account.website') | |
| INSERT INTO LISTTYPE VALUES(0,11000,'business','com.liferay.portal.kernel.model.Contact.address') | |
| INSERT INTO LISTTYPE VALUES(0,11001,'other','com.liferay.portal.kernel.model.Contact.address') | |
| INSERT INTO LISTTYPE VALUES(0,11002,'personal','com.liferay.portal.kernel.model.Contact.address') | |
| INSERT INTO LISTTYPE VALUES(0,11003,'email-address','com.liferay.portal.kernel.model.Contact.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,11004,'email-address-2','com.liferay.portal.kernel.model.Contact.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,11005,'email-address-3','com.liferay.portal.kernel.model.Contact.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,11006,'business','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11007,'business-fax','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11008,'mobile-phone','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11009,'other','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11010,'pager','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11011,'personal','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11012,'personal-fax','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11013,'tty','com.liferay.portal.kernel.model.Contact.phone') | |
| INSERT INTO LISTTYPE VALUES(0,11014,'dr','com.liferay.portal.kernel.model.Contact.prefix') | |
| INSERT INTO LISTTYPE VALUES(0,11015,'mr','com.liferay.portal.kernel.model.Contact.prefix') | |
| INSERT INTO LISTTYPE VALUES(0,11016,'mrs','com.liferay.portal.kernel.model.Contact.prefix') | |
| INSERT INTO LISTTYPE VALUES(0,11017,'ms','com.liferay.portal.kernel.model.Contact.prefix') | |
| INSERT INTO LISTTYPE VALUES(0,11020,'ii','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11021,'iii','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11022,'iv','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11023,'jr','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11024,'phd','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11025,'sr','com.liferay.portal.kernel.model.Contact.suffix') | |
| INSERT INTO LISTTYPE VALUES(0,11026,'blog','com.liferay.portal.kernel.model.Contact.website') | |
| INSERT INTO LISTTYPE VALUES(0,11027,'business','com.liferay.portal.kernel.model.Contact.website') | |
| INSERT INTO LISTTYPE VALUES(0,11028,'other','com.liferay.portal.kernel.model.Contact.website') | |
| INSERT INTO LISTTYPE VALUES(0,11029,'personal','com.liferay.portal.kernel.model.Contact.website') | |
| INSERT INTO LISTTYPE VALUES(0,12000,'billing','com.liferay.portal.kernel.model.Organization.address') | |
| INSERT INTO LISTTYPE VALUES(0,12001,'other','com.liferay.portal.kernel.model.Organization.address') | |
| INSERT INTO LISTTYPE VALUES(0,12002,'p-o-box','com.liferay.portal.kernel.model.Organization.address') | |
| INSERT INTO LISTTYPE VALUES(0,12003,'shipping','com.liferay.portal.kernel.model.Organization.address') | |
| INSERT INTO LISTTYPE VALUES(0,12004,'email-address','com.liferay.portal.kernel.model.Organization.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,12005,'email-address-2','com.liferay.portal.kernel.model.Organization.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,12006,'email-address-3','com.liferay.portal.kernel.model.Organization.emailAddress') | |
| INSERT INTO LISTTYPE VALUES(0,12007,'fax','com.liferay.portal.kernel.model.Organization.phone') | |
| INSERT INTO LISTTYPE VALUES(0,12008,'local','com.liferay.portal.kernel.model.Organization.phone') | |
| INSERT INTO LISTTYPE VALUES(0,12009,'other','com.liferay.portal.kernel.model.Organization.phone') | |
| INSERT INTO LISTTYPE VALUES(0,12010,'toll-free','com.liferay.portal.kernel.model.Organization.phone') | |
| INSERT INTO LISTTYPE VALUES(0,12011,'tty','com.liferay.portal.kernel.model.Organization.phone') | |
| INSERT INTO LISTTYPE VALUES(0,12012,'administrative','com.liferay.portal.kernel.model.Organization.service') | |
| INSERT INTO LISTTYPE VALUES(0,12013,'contracts','com.liferay.portal.kernel.model.Organization.service') | |
| INSERT INTO LISTTYPE VALUES(0,12014,'donation','com.liferay.portal.kernel.model.Organization.service') | |
| INSERT INTO LISTTYPE VALUES(0,12015,'retail','com.liferay.portal.kernel.model.Organization.service') | |
| INSERT INTO LISTTYPE VALUES(0,12016,'training','com.liferay.portal.kernel.model.Organization.service') | |
| INSERT INTO LISTTYPE VALUES(0,12017,'full-member','com.liferay.portal.kernel.model.Organization.status') | |
| INSERT INTO LISTTYPE VALUES(0,12018,'provisional-member','com.liferay.portal.kernel.model.Organization.status') | |
| INSERT INTO LISTTYPE VALUES(0,12019,'intranet','com.liferay.portal.kernel.model.Organization.website') | |
| INSERT INTO LISTTYPE VALUES(0,12020,'public','com.liferay.portal.kernel.model.Organization.website') | |
| INSERT INTO REGION VALUES(0,1001,1,'AB','Alberta','1') | |
| INSERT INTO REGION VALUES(0,1002,1,'BC','British Columbia','1') | |
| INSERT INTO REGION VALUES(0,1003,1,'MB','Manitoba','1') | |
| INSERT INTO REGION VALUES(0,1004,1,'NB','New Brunswick','1') | |
| INSERT INTO REGION VALUES(0,1005,1,'NL','Newfoundland and Labrador','1') | |
| INSERT INTO REGION VALUES(0,1006,1,'NT','Northwest Territories','1') | |
| INSERT INTO REGION VALUES(0,1007,1,'NS','Nova Scotia','1') | |
| INSERT INTO REGION VALUES(0,1008,1,'NU','Nunavut','1') | |
| INSERT INTO REGION VALUES(0,1009,1,'ON','Ontario','1') | |
| INSERT INTO REGION VALUES(0,1010,1,'PE','Prince Edward Island','1') | |
| INSERT INTO REGION VALUES(0,1011,1,'QC','Quebec','1') | |
| INSERT INTO REGION VALUES(0,1012,1,'SK','Saskatchewan','1') | |
| INSERT INTO REGION VALUES(0,1013,1,'YT','Yukon','1') | |
| INSERT INTO REGION VALUES(0,2001,2,'CN-34','Anhui','1') | |
| INSERT INTO REGION VALUES(0,2002,2,'CN-92','Aomen','1') | |
| INSERT INTO REGION VALUES(0,2003,2,'CN-11','Beijing','1') | |
| INSERT INTO REGION VALUES(0,2004,2,'CN-50','Chongqing','1') | |
| INSERT INTO REGION VALUES(0,2005,2,'CN-35','Fujian','1') | |
| INSERT INTO REGION VALUES(0,2006,2,'CN-62','Gansu','1') | |
| INSERT INTO REGION VALUES(0,2007,2,'CN-44','Guangdong','1') | |
| INSERT INTO REGION VALUES(0,2008,2,'CN-45','Guangxi','1') | |
| INSERT INTO REGION VALUES(0,2009,2,'CN-52','Guizhou','1') | |
| INSERT INTO REGION VALUES(0,2010,2,'CN-46','Hainan','1') | |
| INSERT INTO REGION VALUES(0,2011,2,'CN-13','Hebei','1') | |
| INSERT INTO REGION VALUES(0,2012,2,'CN-23','Heilongjiang','1') | |
| INSERT INTO REGION VALUES(0,2013,2,'CN-41','Henan','1') | |
| INSERT INTO REGION VALUES(0,2014,2,'CN-42','Hubei','1') | |
| INSERT INTO REGION VALUES(0,2015,2,'CN-43','Hunan','1') | |
| INSERT INTO REGION VALUES(0,2016,2,'CN-32','Jiangsu','1') | |
| INSERT INTO REGION VALUES(0,2017,2,'CN-36','Jiangxi','1') | |
| INSERT INTO REGION VALUES(0,2018,2,'CN-22','Jilin','1') | |
| INSERT INTO REGION VALUES(0,2019,2,'CN-21','Liaoning','1') | |
| INSERT INTO REGION VALUES(0,2020,2,'CN-15','Nei Mongol','1') | |
| INSERT INTO REGION VALUES(0,2021,2,'CN-64','Ningxia','1') | |
| INSERT INTO REGION VALUES(0,2022,2,'CN-63','Qinghai','1') | |
| INSERT INTO REGION VALUES(0,2023,2,'CN-61','Shaanxi','1') | |
| INSERT INTO REGION VALUES(0,2024,2,'CN-37','Shandong','1') | |
| INSERT INTO REGION VALUES(0,2025,2,'CN-31','Shanghai','1') | |
| INSERT INTO REGION VALUES(0,2026,2,'CN-14','Shanxi','1') | |
| INSERT INTO REGION VALUES(0,2027,2,'CN-51','Sichuan','1') | |
| INSERT INTO REGION VALUES(0,2028,2,'CN-71','Taiwan','1') | |
| INSERT INTO REGION VALUES(0,2029,2,'CN-12','Tianjin','1') | |
| INSERT INTO REGION VALUES(0,2030,2,'CN-91','Xianggang','1') | |
| INSERT INTO REGION VALUES(0,2031,2,'CN-65','Xinjiang','1') | |
| INSERT INTO REGION VALUES(0,2032,2,'CN-54','Xizang','1') | |
| INSERT INTO REGION VALUES(0,2033,2,'CN-53','Yunnan','1') | |
| INSERT INTO REGION VALUES(0,2034,2,'CN-33','Zhejiang','1') | |
| INSERT INTO REGION VALUES(0,3001,3,'A','Alsace','1') | |
| INSERT INTO REGION VALUES(0,3002,3,'B','Aquitaine','1') | |
| INSERT INTO REGION VALUES(0,3003,3,'C','Auvergne','1') | |
| INSERT INTO REGION VALUES(0,3004,3,'P','Basse-Normandie','1') | |
| INSERT INTO REGION VALUES(0,3005,3,'D','Bourgogne','1') | |
| INSERT INTO REGION VALUES(0,3006,3,'E','Bretagne','1') | |
| INSERT INTO REGION VALUES(0,3007,3,'F','Centre','1') | |
| INSERT INTO REGION VALUES(0,3008,3,'G','Champagne-Ardenne','1') | |
| INSERT INTO REGION VALUES(0,3009,3,'H','Corse','1') | |
| INSERT INTO REGION VALUES(0,3010,3,'GF','Guyane','1') | |
| INSERT INTO REGION VALUES(0,3011,3,'I','Franche Comt\u00e9','1') | |
| INSERT INTO REGION VALUES(0,3012,3,'GP','Guadeloupe','1') | |
| INSERT INTO REGION VALUES(0,3013,3,'Q','Haute-Normandie','1') | |
| INSERT INTO REGION VALUES(0,3014,3,'J','\u00cele-de-France','1') | |
| INSERT INTO REGION VALUES(0,3015,3,'K','Languedoc-Roussillon','1') | |
| INSERT INTO REGION VALUES(0,3016,3,'L','Limousin','1') | |
| INSERT INTO REGION VALUES(0,3017,3,'M','Lorraine','1') | |
| INSERT INTO REGION VALUES(0,3018,3,'MQ','Martinique','1') | |
| INSERT INTO REGION VALUES(0,3019,3,'N','Midi-Pyr\u00e9n\u00e9es','1') | |
| INSERT INTO REGION VALUES(0,3020,3,'O','Nord Pas de Calais','1') | |
| INSERT INTO REGION VALUES(0,3021,3,'R','Pays de la Loire','1') | |
| INSERT INTO REGION VALUES(0,3022,3,'S','Picardie','1') | |
| INSERT INTO REGION VALUES(0,3023,3,'T','Poitou-Charentes','1') | |
| INSERT INTO REGION VALUES(0,3024,3,'U','Provence-Alpes-C\u00f4te-d''Azur','1') | |
| INSERT INTO REGION VALUES(0,3025,3,'RE','R\u00e9union','1') | |
| INSERT INTO REGION VALUES(0,3026,3,'V','Rh\u00f4ne-Alpes','1') | |
| INSERT INTO REGION VALUES(0,4001,4,'BW','Baden-W\u00fcrttemberg','1') | |
| INSERT INTO REGION VALUES(0,4002,4,'BY','Bayern','1') | |
| INSERT INTO REGION VALUES(0,4003,4,'BE','Berlin','1') | |
| INSERT INTO REGION VALUES(0,4004,4,'BB','Brandenburg','1') | |
| INSERT INTO REGION VALUES(0,4005,4,'HB','Bremen','1') | |
| INSERT INTO REGION VALUES(0,4006,4,'HH','Hamburg','1') | |
| INSERT INTO REGION VALUES(0,4007,4,'HE','Hessen','1') | |
| INSERT INTO REGION VALUES(0,4008,4,'MV','Mecklenburg-Vorpommern','1') | |
| INSERT INTO REGION VALUES(0,4009,4,'NI','Niedersachsen','1') | |
| INSERT INTO REGION VALUES(0,4010,4,'NW','Nordrhein-Westfalen','1') | |
| INSERT INTO REGION VALUES(0,4011,4,'RP','Rheinland-Pfalz','1') | |
| INSERT INTO REGION VALUES(0,4012,4,'SL','Saarland','1') | |
| INSERT INTO REGION VALUES(0,4013,4,'SN','Sachsen','1') | |
| INSERT INTO REGION VALUES(0,4014,4,'ST','Sachsen-Anhalt','1') | |
| INSERT INTO REGION VALUES(0,4015,4,'SH','Schleswig-Holstein','1') | |
| INSERT INTO REGION VALUES(0,4016,4,'TH','Th\u00fcringen','1') | |
| INSERT INTO REGION VALUES(0,8001,8,'AG','Agrigento','1') | |
| INSERT INTO REGION VALUES(0,8002,8,'AL','Alessandria','1') | |
| INSERT INTO REGION VALUES(0,8003,8,'AN','Ancona','1') | |
| INSERT INTO REGION VALUES(0,8004,8,'AO','Aosta','1') | |
| INSERT INTO REGION VALUES(0,8005,8,'AR','Arezzo','1') | |
| INSERT INTO REGION VALUES(0,8006,8,'AP','Ascoli Piceno','1') | |
| INSERT INTO REGION VALUES(0,8007,8,'AT','Asti','1') | |
| INSERT INTO REGION VALUES(0,8008,8,'AV','Avellino','1') | |
| INSERT INTO REGION VALUES(0,8009,8,'BA','Bari','1') | |
| INSERT INTO REGION VALUES(0,8010,8,'BT','Barletta-Andria-Trani','1') | |
| INSERT INTO REGION VALUES(0,8011,8,'BL','Belluno','1') | |
| INSERT INTO REGION VALUES(0,8012,8,'BN','Benevento','1') | |
| INSERT INTO REGION VALUES(0,8013,8,'BG','Bergamo','1') | |
| INSERT INTO REGION VALUES(0,8014,8,'BI','Biella','1') | |
| INSERT INTO REGION VALUES(0,8015,8,'BO','Bologna','1') | |
| INSERT INTO REGION VALUES(0,8016,8,'BZ','Bolzano','1') | |
| INSERT INTO REGION VALUES(0,8017,8,'BS','Brescia','1') | |
| INSERT INTO REGION VALUES(0,8018,8,'BR','Brindisi','1') | |
| INSERT INTO REGION VALUES(0,8019,8,'CA','Cagliari','1') | |
| INSERT INTO REGION VALUES(0,8020,8,'CL','Caltanissetta','1') | |
| INSERT INTO REGION VALUES(0,8021,8,'CB','Campobasso','1') | |
| INSERT INTO REGION VALUES(0,8022,8,'CI','Carbonia-Iglesias','1') | |
| INSERT INTO REGION VALUES(0,8023,8,'CE','Caserta','1') | |
| INSERT INTO REGION VALUES(0,8024,8,'CT','Catania','1') | |
| INSERT INTO REGION VALUES(0,8025,8,'CZ','Catanzaro','1') | |
| INSERT INTO REGION VALUES(0,8026,8,'CH','Chieti','1') | |
| INSERT INTO REGION VALUES(0,8027,8,'CO','Como','1') | |
| INSERT INTO REGION VALUES(0,8028,8,'CS','Cosenza','1') | |
| INSERT INTO REGION VALUES(0,8029,8,'CR','Cremona','1') | |
| INSERT INTO REGION VALUES(0,8030,8,'KR','Crotone','1') | |
| INSERT INTO REGION VALUES(0,8031,8,'CN','Cuneo','1') | |
| INSERT INTO REGION VALUES(0,8032,8,'EN','Enna','1') | |
| INSERT INTO REGION VALUES(0,8033,8,'FM','Fermo','1') | |
| INSERT INTO REGION VALUES(0,8034,8,'FE','Ferrara','1') | |
| INSERT INTO REGION VALUES(0,8035,8,'FI','Firenze','1') | |
| INSERT INTO REGION VALUES(0,8036,8,'FG','Foggia','1') | |
| INSERT INTO REGION VALUES(0,8037,8,'FC','Forli-Cesena','1') | |
| INSERT INTO REGION VALUES(0,8038,8,'FR','Frosinone','1') | |
| INSERT INTO REGION VALUES(0,8039,8,'GE','Genova','1') | |
| INSERT INTO REGION VALUES(0,8040,8,'GO','Gorizia','1') | |
| INSERT INTO REGION VALUES(0,8041,8,'GR','Grosseto','1') | |
| INSERT INTO REGION VALUES(0,8042,8,'IM','Imperia','1') | |
| INSERT INTO REGION VALUES(0,8043,8,'IS','Isernia','1') | |
| INSERT INTO REGION VALUES(0,8044,8,'AQ','L''Aquila','1') | |
| INSERT INTO REGION VALUES(0,8045,8,'SP','La Spezia','1') | |
| INSERT INTO REGION VALUES(0,8046,8,'LT','Latina','1') | |
| INSERT INTO REGION VALUES(0,8047,8,'LE','Lecce','1') | |
| INSERT INTO REGION VALUES(0,8048,8,'LC','Lecco','1') | |
| INSERT INTO REGION VALUES(0,8049,8,'LI','Livorno','1') | |
| INSERT INTO REGION VALUES(0,8050,8,'LO','Lodi','1') | |
| INSERT INTO REGION VALUES(0,8051,8,'LU','Lucca','1') | |
| INSERT INTO REGION VALUES(0,8052,8,'MC','Macerata','1') | |
| INSERT INTO REGION VALUES(0,8053,8,'MN','Mantova','1') | |
| INSERT INTO REGION VALUES(0,8054,8,'MS','Massa-Carrara','1') | |
| INSERT INTO REGION VALUES(0,8055,8,'MT','Matera','1') | |
| INSERT INTO REGION VALUES(0,8056,8,'MA','Medio Campidano','1') | |
| INSERT INTO REGION VALUES(0,8057,8,'ME','Messina','1') | |
| INSERT INTO REGION VALUES(0,8058,8,'MI','Milano','1') | |
| INSERT INTO REGION VALUES(0,8059,8,'MO','Modena','1') | |
| INSERT INTO REGION VALUES(0,8060,8,'MB','Monza e Brianza','1') | |
| INSERT INTO REGION VALUES(0,8061,8,'NA','Napoli','1') | |
| INSERT INTO REGION VALUES(0,8062,8,'NO','Novara','1') | |
| INSERT INTO REGION VALUES(0,8063,8,'NU','Nuoro','1') | |
| INSERT INTO REGION VALUES(0,8064,8,'OG','Ogliastra','1') | |
| INSERT INTO REGION VALUES(0,8065,8,'OT','Olbia-Tempio','1') | |
| INSERT INTO REGION VALUES(0,8066,8,'OR','Oristano','1') | |
| INSERT INTO REGION VALUES(0,8067,8,'PD','Padova','1') | |
| INSERT INTO REGION VALUES(0,8068,8,'PA','Palermo','1') | |
| INSERT INTO REGION VALUES(0,8069,8,'PR','Parma','1') | |
| INSERT INTO REGION VALUES(0,8070,8,'PV','Pavia','1') | |
| INSERT INTO REGION VALUES(0,8071,8,'PG','Perugia','1') | |
| INSERT INTO REGION VALUES(0,8072,8,'PU','Pesaro e Urbino','1') | |
| INSERT INTO REGION VALUES(0,8073,8,'PE','Pescara','1') | |
| INSERT INTO REGION VALUES(0,8074,8,'PC','Piacenza','1') | |
| INSERT INTO REGION VALUES(0,8075,8,'PI','Pisa','1') | |
| INSERT INTO REGION VALUES(0,8076,8,'PT','Pistoia','1') | |
| INSERT INTO REGION VALUES(0,8077,8,'PN','Pordenone','1') | |
| INSERT INTO REGION VALUES(0,8078,8,'PZ','Potenza','1') | |
| INSERT INTO REGION VALUES(0,8079,8,'PO','Prato','1') | |
| INSERT INTO REGION VALUES(0,8080,8,'RG','Ragusa','1') | |
| INSERT INTO REGION VALUES(0,8081,8,'RA','Ravenna','1') | |
| INSERT INTO REGION VALUES(0,8082,8,'RC','Reggio Calabria','1') | |
| INSERT INTO REGION VALUES(0,8083,8,'RE','Reggio Emilia','1') | |
| INSERT INTO REGION VALUES(0,8084,8,'RI','Rieti','1') | |
| INSERT INTO REGION VALUES(0,8085,8,'RN','Rimini','1') | |
| INSERT INTO REGION VALUES(0,8086,8,'RM','Roma','1') | |
| INSERT INTO REGION VALUES(0,8087,8,'RO','Rovigo','1') | |
| INSERT INTO REGION VALUES(0,8088,8,'SA','Salerno','1') | |
| INSERT INTO REGION VALUES(0,8089,8,'SS','Sassari','1') | |
| INSERT INTO REGION VALUES(0,8090,8,'SV','Savona','1') | |
| INSERT INTO REGION VALUES(0,8091,8,'SI','Siena','1') | |
| INSERT INTO REGION VALUES(0,8092,8,'SR','Siracusa','1') | |
| INSERT INTO REGION VALUES(0,8093,8,'SO','Sondrio','1') | |
| INSERT INTO REGION VALUES(0,8094,8,'TA','Taranto','1') | |
| INSERT INTO REGION VALUES(0,8095,8,'TE','Teramo','1') | |
| INSERT INTO REGION VALUES(0,8096,8,'TR','Terni','1') | |
| INSERT INTO REGION VALUES(0,8097,8,'TO','Torino','1') | |
| INSERT INTO REGION VALUES(0,8098,8,'TP','Trapani','1') | |
| INSERT INTO REGION VALUES(0,8099,8,'TN','Trento','1') | |
| INSERT INTO REGION VALUES(0,8100,8,'TV','Treviso','1') | |
| INSERT INTO REGION VALUES(0,8101,8,'TS','Trieste','1') | |
| INSERT INTO REGION VALUES(0,8102,8,'UD','Udine','1') | |
| INSERT INTO REGION VALUES(0,8103,8,'VA','Varese','1') | |
| INSERT INTO REGION VALUES(0,8104,8,'VE','Venezia','1') | |
| INSERT INTO REGION VALUES(0,8105,8,'VB','Verbano-Cusio-Ossola','1') | |
| INSERT INTO REGION VALUES(0,8106,8,'VC','Vercelli','1') | |
| INSERT INTO REGION VALUES(0,8107,8,'VR','Verona','1') | |
| INSERT INTO REGION VALUES(0,8108,8,'VV','Vibo Valentia','1') | |
| INSERT INTO REGION VALUES(0,8109,8,'VI','Vicenza','1') | |
| INSERT INTO REGION VALUES(0,8110,8,'VT','Viterbo','1') | |
| INSERT INTO REGION VALUES(0,11001,11,'DR','Drenthe','1') | |
| INSERT INTO REGION VALUES(0,11002,11,'FL','Flevoland','1') | |
| INSERT INTO REGION VALUES(0,11003,11,'FR','Friesland','1') | |
| INSERT INTO REGION VALUES(0,11004,11,'GE','Gelderland','1') | |
| INSERT INTO REGION VALUES(0,11005,11,'GR','Groningen','1') | |
| INSERT INTO REGION VALUES(0,11006,11,'LI','Limburg','1') | |
| INSERT INTO REGION VALUES(0,11007,11,'NB','Noord-Brabant','1') | |
| INSERT INTO REGION VALUES(0,11008,11,'NH','Noord-Holland','1') | |
| INSERT INTO REGION VALUES(0,11009,11,'OV','Overijssel','1') | |
| INSERT INTO REGION VALUES(0,11010,11,'UT','Utrecht','1') | |
| INSERT INTO REGION VALUES(0,11011,11,'ZE','Zeeland','1') | |
| INSERT INTO REGION VALUES(0,11012,11,'ZH','Zuid-Holland','1') | |
| INSERT INTO REGION VALUES(0,15001,15,'AN','Andalusia','1') | |
| INSERT INTO REGION VALUES(0,15002,15,'AR','Aragon','1') | |
| INSERT INTO REGION VALUES(0,15003,15,'AS','Asturias','1') | |
| INSERT INTO REGION VALUES(0,15004,15,'IB','Balearic Islands','1') | |
| INSERT INTO REGION VALUES(0,15005,15,'PV','Basque Country','1') | |
| INSERT INTO REGION VALUES(0,15006,15,'CN','Canary Islands','1') | |
| INSERT INTO REGION VALUES(0,15007,15,'CB','Cantabria','1') | |
| INSERT INTO REGION VALUES(0,15008,15,'CL','Castile and Leon','1') | |
| INSERT INTO REGION VALUES(0,15009,15,'CM','Castile-La Mancha','1') | |
| INSERT INTO REGION VALUES(0,15010,15,'CT','Catalonia','1') | |
| INSERT INTO REGION VALUES(0,15011,15,'CE','Ceuta','1') | |
| INSERT INTO REGION VALUES(0,15012,15,'EX','Extremadura','1') | |
| INSERT INTO REGION VALUES(0,15013,15,'GA','Galicia','1') | |
| INSERT INTO REGION VALUES(0,15014,15,'LO','La Rioja','1') | |
| INSERT INTO REGION VALUES(0,15015,15,'M','Madrid','1') | |
| INSERT INTO REGION VALUES(0,15016,15,'ML','Melilla','1') | |
| INSERT INTO REGION VALUES(0,15017,15,'MU','Murcia','1') | |
| INSERT INTO REGION VALUES(0,15018,15,'NA','Navarra','1') | |
| INSERT INTO REGION VALUES(0,15019,15,'VC','Valencia','1') | |
| INSERT INTO REGION VALUES(0,19001,19,'AL','Alabama','1') | |
| INSERT INTO REGION VALUES(0,19002,19,'AK','Alaska','1') | |
| INSERT INTO REGION VALUES(0,19003,19,'AZ','Arizona','1') | |
| INSERT INTO REGION VALUES(0,19004,19,'AR','Arkansas','1') | |
| INSERT INTO REGION VALUES(0,19005,19,'CA','California','1') | |
| INSERT INTO REGION VALUES(0,19006,19,'CO','Colorado','1') | |
| INSERT INTO REGION VALUES(0,19007,19,'CT','Connecticut','1') | |
| INSERT INTO REGION VALUES(0,19008,19,'DC','District of Columbia','1') | |
| INSERT INTO REGION VALUES(0,19009,19,'DE','Delaware','1') | |
| INSERT INTO REGION VALUES(0,19010,19,'FL','Florida','1') | |
| INSERT INTO REGION VALUES(0,19011,19,'GA','Georgia','1') | |
| INSERT INTO REGION VALUES(0,19012,19,'HI','Hawaii','1') | |
| INSERT INTO REGION VALUES(0,19013,19,'ID','Idaho','1') | |
| INSERT INTO REGION VALUES(0,19014,19,'IL','Illinois','1') | |
| INSERT INTO REGION VALUES(0,19015,19,'IN','Indiana','1') | |
| INSERT INTO REGION VALUES(0,19016,19,'IA','Iowa','1') | |
| INSERT INTO REGION VALUES(0,19017,19,'KS','Kansas','1') | |
| INSERT INTO REGION VALUES(0,19018,19,'KY','Kentucky ','1') | |
| INSERT INTO REGION VALUES(0,19019,19,'LA','Louisiana ','1') | |
| INSERT INTO REGION VALUES(0,19020,19,'ME','Maine','1') | |
| INSERT INTO REGION VALUES(0,19021,19,'MD','Maryland','1') | |
| INSERT INTO REGION VALUES(0,19022,19,'MA','Massachusetts','1') | |
| INSERT INTO REGION VALUES(0,19023,19,'MI','Michigan','1') | |
| INSERT INTO REGION VALUES(0,19024,19,'MN','Minnesota','1') | |
| INSERT INTO REGION VALUES(0,19025,19,'MS','Mississippi','1') | |
| INSERT INTO REGION VALUES(0,19026,19,'MO','Missouri','1') | |
| INSERT INTO REGION VALUES(0,19027,19,'MT','Montana','1') | |
| INSERT INTO REGION VALUES(0,19028,19,'NE','Nebraska','1') | |
| INSERT INTO REGION VALUES(0,19029,19,'NV','Nevada','1') | |
| INSERT INTO REGION VALUES(0,19030,19,'NH','New Hampshire','1') | |
| INSERT INTO REGION VALUES(0,19031,19,'NJ','New Jersey','1') | |
| INSERT INTO REGION VALUES(0,19032,19,'NM','New Mexico','1') | |
| INSERT INTO REGION VALUES(0,19033,19,'NY','New York','1') | |
| INSERT INTO REGION VALUES(0,19034,19,'NC','North Carolina','1') | |
| INSERT INTO REGION VALUES(0,19035,19,'ND','North Dakota','1') | |
| INSERT INTO REGION VALUES(0,19036,19,'OH','Ohio','1') | |
| INSERT INTO REGION VALUES(0,19037,19,'OK','Oklahoma ','1') | |
| INSERT INTO REGION VALUES(0,19038,19,'OR','Oregon','1') | |
| INSERT INTO REGION VALUES(0,19039,19,'PA','Pennsylvania','1') | |
| INSERT INTO REGION VALUES(0,19040,19,'PR','Puerto Rico','1') | |
| INSERT INTO REGION VALUES(0,19041,19,'RI','Rhode Island','1') | |
| INSERT INTO REGION VALUES(0,19042,19,'SC','South Carolina','1') | |
| INSERT INTO REGION VALUES(0,19043,19,'SD','South Dakota','1') | |
| INSERT INTO REGION VALUES(0,19044,19,'TN','Tennessee','1') | |
| INSERT INTO REGION VALUES(0,19045,19,'TX','Texas','1') | |
| INSERT INTO REGION VALUES(0,19046,19,'UT','Utah','1') | |
| INSERT INTO REGION VALUES(0,19047,19,'VT','Vermont','1') | |
| INSERT INTO REGION VALUES(0,19048,19,'VA','Virginia','1') | |
| INSERT INTO REGION VALUES(0,19049,19,'WA','Washington','1') | |
| INSERT INTO REGION VALUES(0,19050,19,'WV','West Virginia','1') | |
| INSERT INTO REGION VALUES(0,19051,19,'WI','Wisconsin','1') | |
| INSERT INTO REGION VALUES(0,19052,19,'WY','Wyoming','1') | |
| INSERT INTO REGION VALUES(0,32001,32,'ACT','Australian Capital Territory','1') | |
| INSERT INTO REGION VALUES(0,32002,32,'NSW','New South Wales','1') | |
| INSERT INTO REGION VALUES(0,32003,32,'NT','Northern Territory','1') | |
| INSERT INTO REGION VALUES(0,32004,32,'QLD','Queensland','1') | |
| INSERT INTO REGION VALUES(0,32005,32,'SA','South Australia','1') | |
| INSERT INTO REGION VALUES(0,32006,32,'TAS','Tasmania','1') | |
| INSERT INTO REGION VALUES(0,32007,32,'VIC','Victoria','1') | |
| INSERT INTO REGION VALUES(0,32008,32,'WA','Western Australia','1') | |
| INSERT INTO REGION VALUES(0,33001,33,'AT-1','Burgenland','1') | |
| INSERT INTO REGION VALUES(0,33002,33,'AT-2','K\u00e4rnten','1') | |
| INSERT INTO REGION VALUES(0,33003,33,'AT-3','Nieder\u00f6sterreich','1') | |
| INSERT INTO REGION VALUES(0,33004,33,'AT-4','Ober\u00f6sterreich','1') | |
| INSERT INTO REGION VALUES(0,33005,33,'AT-5','Salzburg','1') | |
| INSERT INTO REGION VALUES(0,33006,33,'AT-6','Steiermark','1') | |
| INSERT INTO REGION VALUES(0,33007,33,'AT-7','Tirol','1') | |
| INSERT INTO REGION VALUES(0,33008,33,'AT-8','Vorarlberg','1') | |
| INSERT INTO REGION VALUES(0,33009,33,'AT-9','Vienna','1') | |
| INSERT INTO REGION VALUES(0,144001,144,'MX-AGS','Aguascalientes','1') | |
| INSERT INTO REGION VALUES(0,144002,144,'MX-BCN','Baja California','1') | |
| INSERT INTO REGION VALUES(0,144003,144,'MX-BCS','Baja California Sur','1') | |
| INSERT INTO REGION VALUES(0,144004,144,'MX-CAM','Campeche','1') | |
| INSERT INTO REGION VALUES(0,144005,144,'MX-CHP','Chiapas','1') | |
| INSERT INTO REGION VALUES(0,144006,144,'MX-CHI','Chihuahua','1') | |
| INSERT INTO REGION VALUES(0,144007,144,'MX-COA','Coahuila','1') | |
| INSERT INTO REGION VALUES(0,144008,144,'MX-COL','Colima','1') | |
| INSERT INTO REGION VALUES(0,144009,144,'MX-DUR','Durango','1') | |
| INSERT INTO REGION VALUES(0,144010,144,'MX-GTO','Guanajuato','1') | |
| INSERT INTO REGION VALUES(0,144011,144,'MX-GRO','Guerrero','1') | |
| INSERT INTO REGION VALUES(0,144012,144,'MX-HGO','Hidalgo','1') | |
| INSERT INTO REGION VALUES(0,144013,144,'MX-JAL','Jalisco','1') | |
| INSERT INTO REGION VALUES(0,144014,144,'MX-MEX','Mexico','1') | |
| INSERT INTO REGION VALUES(0,144015,144,'MX-MIC','Michoacan','1') | |
| INSERT INTO REGION VALUES(0,144016,144,'MX-MOR','Morelos','1') | |
| INSERT INTO REGION VALUES(0,144017,144,'MX-NAY','Nayarit','1') | |
| INSERT INTO REGION VALUES(0,144018,144,'MX-NLE','Nuevo Leon','1') | |
| INSERT INTO REGION VALUES(0,144019,144,'MX-OAX','Oaxaca','1') | |
| INSERT INTO REGION VALUES(0,144020,144,'MX-PUE','Puebla','1') | |
| INSERT INTO REGION VALUES(0,144021,144,'MX-QRO','Queretaro','1') | |
| INSERT INTO REGION VALUES(0,144023,144,'MX-ROO','Quintana Roo','1') | |
| INSERT INTO REGION VALUES(0,144024,144,'MX-SLP','San Luis Potos\u00ed','1') | |
| INSERT INTO REGION VALUES(0,144025,144,'MX-SIN','Sinaloa','1') | |
| INSERT INTO REGION VALUES(0,144026,144,'MX-SON','Sonora','1') | |
| INSERT INTO REGION VALUES(0,144027,144,'MX-TAB','Tabasco','1') | |
| INSERT INTO REGION VALUES(0,144028,144,'MX-TAM','Tamaulipas','1') | |
| INSERT INTO REGION VALUES(0,144029,144,'MX-TLX','Tlaxcala','1') | |
| INSERT INTO REGION VALUES(0,144030,144,'MX-VER','Veracruz','1') | |
| INSERT INTO REGION VALUES(0,144031,144,'MX-YUC','Yucatan','1') | |
| INSERT INTO REGION VALUES(0,144032,144,'MX-ZAC','Zacatecas','1') | |
| INSERT INTO REGION VALUES(0,164001,164,'01','\u00d8stfold','1') | |
| INSERT INTO REGION VALUES(0,164002,164,'02','Akershus','1') | |
| INSERT INTO REGION VALUES(0,164003,164,'03','Oslo','1') | |
| INSERT INTO REGION VALUES(0,164004,164,'04','Hedmark','1') | |
| INSERT INTO REGION VALUES(0,164005,164,'05','Oppland','1') | |
| INSERT INTO REGION VALUES(0,164006,164,'06','Buskerud','1') | |
| INSERT INTO REGION VALUES(0,164007,164,'07','Vestfold','1') | |
| INSERT INTO REGION VALUES(0,164008,164,'08','Telemark','1') | |
| INSERT INTO REGION VALUES(0,164009,164,'09','Aust-Agder','1') | |
| INSERT INTO REGION VALUES(0,164010,164,'10','Vest-Agder','1') | |
| INSERT INTO REGION VALUES(0,164011,164,'11','Rogaland','1') | |
| INSERT INTO REGION VALUES(0,164012,164,'12','Hordaland','1') | |
| INSERT INTO REGION VALUES(0,164013,164,'14','Sogn og Fjordane','1') | |
| INSERT INTO REGION VALUES(0,164014,164,'15','M\u00f8re of Romsdal','1') | |
| INSERT INTO REGION VALUES(0,164015,164,'16','S\u00f8r-Tr\u00f8ndelag','1') | |
| INSERT INTO REGION VALUES(0,164016,164,'17','Nord-Tr\u00f8ndelag','1') | |
| INSERT INTO REGION VALUES(0,164017,164,'18','Nordland','1') | |
| INSERT INTO REGION VALUES(0,164018,164,'19','Troms','1') | |
| INSERT INTO REGION VALUES(0,164019,164,'20','Finnmark','1') | |
| INSERT INTO REGION VALUES(0,202001,202,'AG','Aargau','1') | |
| INSERT INTO REGION VALUES(0,202002,202,'AR','Appenzell Ausserrhoden','1') | |
| INSERT INTO REGION VALUES(0,202003,202,'AI','Appenzell Innerrhoden','1') | |
| INSERT INTO REGION VALUES(0,202004,202,'BL','Basel-Landschaft','1') | |
| INSERT INTO REGION VALUES(0,202005,202,'BS','Basel-Stadt','1') | |
| INSERT INTO REGION VALUES(0,202006,202,'BE','Bern','1') | |
| INSERT INTO REGION VALUES(0,202007,202,'FR','Fribourg','1') | |
| INSERT INTO REGION VALUES(0,202008,202,'GE','Geneva','1') | |
| INSERT INTO REGION VALUES(0,202009,202,'GL','Glarus','1') | |
| INSERT INTO REGION VALUES(0,202010,202,'GR','Graub\u00fcnden','1') | |
| INSERT INTO REGION VALUES(0,202011,202,'JU','Jura','1') | |
| INSERT INTO REGION VALUES(0,202012,202,'LU','Lucerne','1') | |
| INSERT INTO REGION VALUES(0,202013,202,'NE','Neuch\u00e2tel','1') | |
| INSERT INTO REGION VALUES(0,202014,202,'NW','Nidwalden','1') | |
| INSERT INTO REGION VALUES(0,202015,202,'OW','Obwalden','1') | |
| INSERT INTO REGION VALUES(0,202016,202,'SH','Schaffhausen','1') | |
| INSERT INTO REGION VALUES(0,202017,202,'SZ','Schwyz','1') | |
| INSERT INTO REGION VALUES(0,202018,202,'SO','Solothurn','1') | |
| INSERT INTO REGION VALUES(0,202019,202,'SG','St. Gallen','1') | |
| INSERT INTO REGION VALUES(0,202020,202,'TG','Thurgau','1') | |
| INSERT INTO REGION VALUES(0,202021,202,'TI','Ticino','1') | |
| INSERT INTO REGION VALUES(0,202022,202,'UR','Uri','1') | |
| INSERT INTO REGION VALUES(0,202023,202,'VS','Valais','1') | |
| INSERT INTO REGION VALUES(0,202024,202,'VD','Vaud','1') | |
| INSERT INTO REGION VALUES(0,202025,202,'ZG','Zug','1') | |
| INSERT INTO REGION VALUES(0,202026,202,'ZH','Z\u00fcrich','1') | |
| INSERT INTO RELEASE_ VALUES(0,1,'2016-08-04 22:28:34.826000','2016-08-04 22:28:34.826000','portal','7.0.2',7002,NULL,'0',NULL,NULL) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mvn archetype:generate -Dfilter=liferay |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 示例(非正式命令): | |
| export database: | |
| mysqldump -u username -p alfresco_new > alfresco.sql | |
| import database: | |
| create database alfresco_test; | |
| mysql -u username -p alfresco_test < alfresco.sql; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| JAVA_TOOL_OPTIONS | |
| -Dfile.encoding=UTF-8 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <build> | |
| <plugins> | |
| <plugin> | |
| <groupId>org.apache.maven.plugins</groupId> | |
| <artifactId>maven-compiler-plugin</artifactId> | |
| <version>2.3.2</version> | |
| <configuration> | |
| <source>1.8</source> | |
| <target>1.8</target> | |
| </configuration> | |
| </plugin> | |
| <plugin> | |
| <artifactId>maven-surefire-plugin</artifactId> | |
| <version>2.12.4</version> | |
| <configuration> | |
| <parallel>classes</parallel> | |
| <threadCount>1</threadCount> | |
| <includes> | |
| <include>**/*Test.java</include> | |
| </includes> | |
| </configuration> | |
| </plugin> | |
| <plugin> | |
| <groupId>org.apache.maven.plugins</groupId> | |
| <artifactId>maven-antrun-plugin</artifactId> | |
| <version>1.7</version> | |
| <executions> | |
| <execution> | |
| <id>Deploy War to Liferay</id> | |
| <phase>install</phase> | |
| <goals> | |
| <goal>run</goal> | |
| </goals> | |
| <configuration> | |
| <target> | |
| <copy todir="${liferay.home}/deploy"> | |
| <fileset dir="target"> | |
| <include name="${project.artifactId}*.war" /> | |
| </fileset> | |
| </copy> | |
| </target> | |
| </configuration> | |
| </execution> | |
| <execution> | |
| <id>clean</id> | |
| <phase>clean</phase> | |
| <goals> | |
| <goal>run</goal> | |
| </goals> | |
| <configuration> | |
| <target> | |
| <delete failonerror="false" includeemptydirs="true" verbose="true"> | |
| <fileset dir="${liferay.home}/deploy" includes="${project.artifactId}*.war" /> | |
| </delete> | |
| <delete failonerror="false" includeemptydirs="true" verbose="true"> | |
| <fileset dir="${liferay.home}/deploy/${project.artifactId}" /> | |
| <fileset dir="${liferay.home}/deploy/${project.artifactId}-${project.version}" /> | |
| <fileset dir="${liferay.home}/deploy/${project.artifactId}.war" /> | |
| <fileset dir="${liferay.home}/deploy"> | |
| <include name="*${project.artifactId}.war.deployed" /> | |
| </fileset> | |
| </delete> | |
| <delete failonerror="false" includeemptydirs="true" verbose="true"> | |
| <fileset dir="${liferay.home}/osgi/war"> | |
| <include name="${project.artifactId}*.war" /> | |
| </fileset> | |
| </delete> | |
| </target> | |
| </configuration> | |
| </execution> | |
| </executions> | |
| </plugin> | |
| </plugins> | |
| <resources> | |
| <resource> | |
| <directory>src/main/resources</directory> | |
| <filtering>true</filtering> | |
| </resource> | |
| </resources> | |
| </build> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if exist "%CATALINA_HOME%/jre${jdk.windows.version}/win" ( | |
| if not "%JAVA_HOME%" == "" ( | |
| set JAVA_HOME= | |
| ) | |
| set "JRE_HOME=%CATALINA_HOME%/jre${jdk.windows.version}/win" | |
| ) | |
| set "CATALINA_OPTS=%CATALINA_OPTS% -Dfile.encoding=UTF8 -Djava.net.preferIPv4Stack=true -Dorg.apache.catalina.loader.WebappClassLoader.ENABLE_CLEAR_REFERENCES=false -Duser.timezone=GMT -Xmx1024m -XX:MaxPermSize=256m" | |
| set "JMX_OPTS=-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.port=8099 -Dcom.sun.management.jmxremote.ssl=false" | |
| set "CATALINA_OPTS=%CATALINA_OPTS% %JMX_OPTS%" | |
| set "DEBUG_OPTS=-agentlib:jdwp=transport=dt_socket,address=9000,server=y,suspend=n" | |
| set "CATALINA_OPTS=%CATALINA_OPTS% %DEBUG_OPTS%" | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "layoutTemplateId": "1_column", | |
| "publicPages": [ | |
| { | |
| "columns": [ | |
| [ | |
| { | |
| "portletId": "com_liferay_hello_world_web_portlet_HelloWorldPortlet" | |
| } | |
| ] | |
| ], | |
| "friendlyURL": "/home", | |
| "nameMap": { | |
| "en_US": "Welcome", | |
| "fr_FR": "Bienvenue" | |
| }, | |
| "title": "Welcome" | |
| } | |
| ] | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "layoutTemplateId": "1_column", | |
| "publicPages": [ | |
| { | |
| "friendlyURL": "/home", | |
| "layouts": [ | |
| { | |
| "friendlyURL": "/newss", | |
| "name": "Child Page 1", | |
| "title": "Child Page 1" | |
| }, | |
| { | |
| "friendlyURL": "/web-designs", | |
| "name": "Child Page 2", | |
| "title": "Child Page 2" | |
| } | |
| ], | |
| "name": "Home", | |
| "title": "Home" | |
| }, | |
| { | |
| "friendlyURL": "/about-w4u", | |
| "layouts": [ | |
| { | |
| "friendlyURL": "/about-us", | |
| "name": "About Us", | |
| "title": "About Us" | |
| }, | |
| { | |
| "friendlyURL": "/service", | |
| "name": "Service", | |
| "title": "Service" | |
| }, | |
| { | |
| "friendlyURL": "/solutions", | |
| "name": "Solutions", | |
| "title": "Solutions" | |
| }, | |
| { | |
| "friendlyURL": "/portfolio", | |
| "name": "Portfolio", | |
| "title": "Portfolio" | |
| }, | |
| { | |
| "friendlyURL": "/products", | |
| "name": "Products", | |
| "title": "Products" | |
| }, | |
| { | |
| "friendlyURL": "/languages", | |
| "name": "Language", | |
| "title": "Language" | |
| } | |
| ], | |
| "name": "About W4U", | |
| "title": "About W4U" | |
| } | |
| ] | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| svn copy http://example.com/repos/myproject/trunk http://example.com/repos/myproject/branches/releaseForAug -m "create branch for release on August" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
mvn archetype:generate -Dfilter=liferay