--- /dev/null
+drop database lportal;
+create database lportal encoding = 'UNICODE';
+\c lportal;
+
+create table Account_ (
+ accountId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentAccountId bigint,
+ name varchar(75) null,
+ legalName varchar(75) null,
+ legalId varchar(75) null,
+ legalType varchar(75) null,
+ sicCode varchar(75) null,
+ tickerSymbol varchar(75) null,
+ industry varchar(75) null,
+ type_ varchar(75) null,
+ size_ varchar(75) null
+);
+
+create table Address (
+ addressId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ street1 varchar(75) null,
+ street2 varchar(75) null,
+ street3 varchar(75) null,
+ city varchar(75) null,
+ zip varchar(75) null,
+ regionId bigint,
+ countryId bigint,
+ typeId integer,
+ mailing bool,
+ primary_ bool
+);
+
+create table AnnouncementsDelivery (
+ deliveryId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ type_ varchar(75) null,
+ email bool,
+ sms bool,
+ website bool
+);
+
+create table AnnouncementsEntry (
+ uuid_ varchar(75) null,
+ entryId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ title varchar(75) null,
+ content text null,
+ url text null,
+ type_ varchar(75) null,
+ displayDate timestamp null,
+ expirationDate timestamp null,
+ priority integer,
+ alert bool
+);
+
+create table AnnouncementsFlag (
+ flagId bigint not null primary key,
+ userId bigint,
+ createDate timestamp null,
+ entryId bigint,
+ value integer
+);
+
+create table BlogsEntry (
+ uuid_ varchar(75) null,
+ entryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ title varchar(150) null,
+ urlTitle varchar(150) null,
+ content text null,
+ displayDate timestamp null,
+ draft bool,
+ allowTrackbacks bool,
+ trackbacks text null
+);
+
+create table BlogsStatsUser (
+ statsUserId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ entryCount integer,
+ lastPostDate timestamp null,
+ ratingsTotalEntries integer,
+ ratingsTotalScore double precision,
+ ratingsAverageScore double precision
+);
+
+create table BookmarksEntry (
+ uuid_ varchar(75) null,
+ entryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ folderId bigint,
+ name varchar(255) null,
+ url text null,
+ comments text null,
+ visits integer,
+ priority integer
+);
+
+create table BookmarksFolder (
+ uuid_ varchar(75) null,
+ folderId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentFolderId bigint,
+ name varchar(75) null,
+ description text null
+);
+
+create table BrowserTracker (
+ browserTrackerId bigint not null primary key,
+ userId bigint,
+ browserKey bigint
+);
+
+create table CalEvent (
+ uuid_ varchar(75) null,
+ eventId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ title varchar(75) null,
+ description text null,
+ startDate timestamp null,
+ endDate timestamp null,
+ durationHour integer,
+ durationMinute integer,
+ allDay bool,
+ timeZoneSensitive bool,
+ type_ varchar(75) null,
+ repeating bool,
+ recurrence text null,
+ remindBy integer,
+ firstReminder integer,
+ secondReminder integer
+);
+
+create table ClassName_ (
+ classNameId bigint not null primary key,
+ value varchar(200) null
+);
+
+create table Company (
+ companyId bigint not null primary key,
+ accountId bigint,
+ webId varchar(75) null,
+ key_ text null,
+ virtualHost varchar(75) null,
+ mx varchar(75) null,
+ homeURL text null,
+ logoId bigint,
+ system bool
+);
+
+create table Contact_ (
+ contactId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ accountId bigint,
+ parentContactId bigint,
+ firstName varchar(75) null,
+ middleName varchar(75) null,
+ lastName varchar(75) null,
+ prefixId integer,
+ suffixId integer,
+ male bool,
+ birthday timestamp null,
+ smsSn varchar(75) null,
+ aimSn varchar(75) null,
+ facebookSn varchar(75) null,
+ icqSn varchar(75) null,
+ jabberSn varchar(75) null,
+ msnSn varchar(75) null,
+ mySpaceSn varchar(75) null,
+ skypeSn varchar(75) null,
+ twitterSn varchar(75) null,
+ ymSn varchar(75) null,
+ employeeStatusId varchar(75) null,
+ employeeNumber varchar(75) null,
+ jobTitle varchar(100) null,
+ jobClass varchar(75) null,
+ hoursOfOperation varchar(75) null
+);
+
+create table Counter (
+ name varchar(75) not null primary key,
+ currentId bigint
+);
+
+create table Country (
+ countryId bigint not null primary key,
+ name varchar(75) null,
+ a2 varchar(75) null,
+ a3 varchar(75) null,
+ number_ varchar(75) null,
+ idd_ varchar(75) null,
+ active_ bool
+);
+
+create table CyrusUser (
+ userId varchar(75) not null primary key,
+ password_ varchar(75) not null
+);
+
+create table CyrusVirtual (
+ emailAddress varchar(75) not null primary key,
+ userId varchar(75) not null
+);
+
+create table DLFileEntry (
+ uuid_ varchar(75) null,
+ fileEntryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ versionUserId bigint,
+ versionUserName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ folderId bigint,
+ name varchar(255) null,
+ title varchar(255) null,
+ description text null,
+ version double precision,
+ size_ integer,
+ readCount integer,
+ extraSettings text null
+);
+
+create table DLFileRank (
+ fileRankId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ folderId bigint,
+ name varchar(255) null
+);
+
+create table DLFileShortcut (
+ uuid_ varchar(75) null,
+ fileShortcutId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ folderId bigint,
+ toFolderId bigint,
+ toName varchar(255) null
+);
+
+create table DLFileVersion (
+ fileVersionId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ folderId bigint,
+ name varchar(255) null,
+ version double precision,
+ size_ integer
+);
+
+create table DLFolder (
+ uuid_ varchar(75) null,
+ folderId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentFolderId bigint,
+ name varchar(100) null,
+ description text null,
+ lastPostDate timestamp null
+);
+
+create table EmailAddress (
+ emailAddressId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ address varchar(75) null,
+ typeId integer,
+ primary_ bool
+);
+
+create table ExpandoColumn (
+ columnId bigint not null primary key,
+ companyId bigint,
+ tableId bigint,
+ name varchar(75) null,
+ type_ integer,
+ defaultData text null,
+ typeSettings text null
+);
+
+create table ExpandoRow (
+ rowId_ bigint not null primary key,
+ companyId bigint,
+ tableId bigint,
+ classPK bigint
+);
+
+create table ExpandoTable (
+ tableId bigint not null primary key,
+ companyId bigint,
+ classNameId bigint,
+ name varchar(75) null
+);
+
+create table ExpandoValue (
+ valueId bigint not null primary key,
+ companyId bigint,
+ tableId bigint,
+ columnId bigint,
+ rowId_ bigint,
+ classNameId bigint,
+ classPK bigint,
+ data_ text null
+);
+
+create table Group_ (
+ groupId bigint not null primary key,
+ companyId bigint,
+ creatorUserId bigint,
+ classNameId bigint,
+ classPK bigint,
+ parentGroupId bigint,
+ liveGroupId bigint,
+ name varchar(75) null,
+ description text null,
+ type_ integer,
+ typeSettings text null,
+ friendlyURL varchar(100) null,
+ active_ bool
+);
+
+create table Groups_Orgs (
+ groupId bigint not null,
+ organizationId bigint not null,
+ primary key (groupId, organizationId)
+);
+
+create table Groups_Permissions (
+ groupId bigint not null,
+ permissionId bigint not null,
+ primary key (groupId, permissionId)
+);
+
+create table Groups_Roles (
+ groupId bigint not null,
+ roleId bigint not null,
+ primary key (groupId, roleId)
+);
+
+create table Groups_UserGroups (
+ groupId bigint not null,
+ userGroupId bigint not null,
+ primary key (groupId, userGroupId)
+);
+
+create table IGFolder (
+ uuid_ varchar(75) null,
+ folderId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentFolderId bigint,
+ name varchar(75) null,
+ description text null
+);
+
+create table IGImage (
+ uuid_ varchar(75) null,
+ imageId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ folderId bigint,
+ name varchar(75) null,
+ description text null,
+ smallImageId bigint,
+ largeImageId bigint,
+ custom1ImageId bigint,
+ custom2ImageId bigint
+);
+
+create table Image (
+ imageId bigint not null primary key,
+ modifiedDate timestamp null,
+ text_ text null,
+ type_ varchar(75) null,
+ height integer,
+ width integer,
+ size_ integer
+);
+
+create table JournalArticle (
+ uuid_ varchar(75) null,
+ id_ bigint not null primary key,
+ resourcePrimKey bigint,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ articleId varchar(75) null,
+ version double precision,
+ title varchar(100) null,
+ urlTitle varchar(150) null,
+ description text null,
+ content text null,
+ type_ varchar(75) null,
+ structureId varchar(75) null,
+ templateId varchar(75) null,
+ displayDate timestamp null,
+ approved bool,
+ approvedByUserId bigint,
+ approvedByUserName varchar(75) null,
+ approvedDate timestamp null,
+ expired bool,
+ expirationDate timestamp null,
+ reviewDate timestamp null,
+ indexable bool,
+ smallImage bool,
+ smallImageId bigint,
+ smallImageURL varchar(75) null
+);
+
+create table JournalArticleImage (
+ articleImageId bigint not null primary key,
+ groupId bigint,
+ articleId varchar(75) null,
+ version double precision,
+ elInstanceId varchar(75) null,
+ elName varchar(75) null,
+ languageId varchar(75) null,
+ tempImage bool
+);
+
+create table JournalArticleResource (
+ resourcePrimKey bigint not null primary key,
+ groupId bigint,
+ articleId varchar(75) null
+);
+
+create table JournalContentSearch (
+ contentSearchId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ privateLayout bool,
+ layoutId bigint,
+ portletId varchar(200) null,
+ articleId varchar(75) null
+);
+
+create table JournalFeed (
+ uuid_ varchar(75) null,
+ id_ bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ feedId varchar(75) null,
+ name varchar(75) null,
+ description text null,
+ type_ varchar(75) null,
+ structureId varchar(75) null,
+ templateId varchar(75) null,
+ rendererTemplateId varchar(75) null,
+ delta integer,
+ orderByCol varchar(75) null,
+ orderByType varchar(75) null,
+ targetLayoutFriendlyUrl varchar(75) null,
+ targetPortletId varchar(75) null,
+ contentField varchar(75) null,
+ feedType varchar(75) null,
+ feedVersion double precision
+);
+
+create table JournalStructure (
+ uuid_ varchar(75) null,
+ id_ bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ structureId varchar(75) null,
+ parentStructureId varchar(75) null,
+ name varchar(75) null,
+ description text null,
+ xsd text null
+);
+
+create table JournalTemplate (
+ uuid_ varchar(75) null,
+ id_ bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ templateId varchar(75) null,
+ structureId varchar(75) null,
+ name varchar(75) null,
+ description text null,
+ xsl text null,
+ langType varchar(75) null,
+ cacheable bool,
+ smallImage bool,
+ smallImageId bigint,
+ smallImageURL varchar(75) null
+);
+
+create table Layout (
+ plid bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ privateLayout bool,
+ layoutId bigint,
+ parentLayoutId bigint,
+ name text null,
+ title text null,
+ description text null,
+ type_ varchar(75) null,
+ typeSettings text null,
+ hidden_ bool,
+ friendlyURL varchar(100) null,
+ iconImage bool,
+ iconImageId bigint,
+ themeId varchar(75) null,
+ colorSchemeId varchar(75) null,
+ wapThemeId varchar(75) null,
+ wapColorSchemeId varchar(75) null,
+ css text null,
+ priority integer,
+ dlFolderId bigint
+);
+
+create table LayoutSet (
+ layoutSetId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ privateLayout bool,
+ logo bool,
+ logoId bigint,
+ themeId varchar(75) null,
+ colorSchemeId varchar(75) null,
+ wapThemeId varchar(75) null,
+ wapColorSchemeId varchar(75) null,
+ css text null,
+ pageCount integer,
+ virtualHost varchar(75) null
+);
+
+create table ListType (
+ listTypeId integer not null primary key,
+ name varchar(75) null,
+ type_ varchar(75) null
+);
+
+create table MBBan (
+ banId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ banUserId bigint
+);
+
+create table MBCategory (
+ uuid_ varchar(75) null,
+ categoryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentCategoryId bigint,
+ name varchar(75) null,
+ description text null,
+ threadCount integer,
+ messageCount integer,
+ lastPostDate timestamp null
+);
+
+create table MBDiscussion (
+ discussionId bigint not null primary key,
+ classNameId bigint,
+ classPK bigint,
+ threadId bigint
+);
+
+create table MBMailingList (
+ uuid_ varchar(75) null,
+ mailingListId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ categoryId bigint,
+ emailAddress varchar(75) null,
+ inProtocol varchar(75) null,
+ inServerName varchar(75) null,
+ inServerPort integer,
+ inUseSSL bool,
+ inUserName varchar(75) null,
+ inPassword varchar(75) null,
+ inReadInterval integer,
+ outEmailAddress varchar(75) null,
+ outCustom bool,
+ outServerName varchar(75) null,
+ outServerPort integer,
+ outUseSSL bool,
+ outUserName varchar(75) null,
+ outPassword varchar(75) null,
+ active_ bool
+);
+
+create table MBMessage (
+ uuid_ varchar(75) null,
+ messageId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ categoryId bigint,
+ threadId bigint,
+ parentMessageId bigint,
+ subject varchar(75) null,
+ body text null,
+ attachments bool,
+ anonymous bool,
+ priority double precision
+);
+
+create table MBMessageFlag (
+ messageFlagId bigint not null primary key,
+ userId bigint,
+ modifiedDate timestamp null,
+ threadId bigint,
+ messageId bigint,
+ flag integer
+);
+
+create table MBStatsUser (
+ statsUserId bigint not null primary key,
+ groupId bigint,
+ userId bigint,
+ messageCount integer,
+ lastPostDate timestamp null
+);
+
+create table MBThread (
+ threadId bigint not null primary key,
+ groupId bigint,
+ categoryId bigint,
+ rootMessageId bigint,
+ messageCount integer,
+ viewCount integer,
+ lastPostByUserId bigint,
+ lastPostDate timestamp null,
+ priority double precision
+);
+
+create table MembershipRequest (
+ membershipRequestId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ groupId bigint,
+ comments text null,
+ replyComments text null,
+ replyDate timestamp null,
+ replierUserId bigint,
+ statusId integer
+);
+
+create table Organization_ (
+ organizationId bigint not null primary key,
+ companyId bigint,
+ parentOrganizationId bigint,
+ leftOrganizationId bigint,
+ rightOrganizationId bigint,
+ name varchar(100) null,
+ type_ varchar(75) null,
+ recursable bool,
+ regionId bigint,
+ countryId bigint,
+ statusId integer,
+ comments text null
+);
+
+create table OrgGroupPermission (
+ organizationId bigint not null,
+ groupId bigint not null,
+ permissionId bigint not null,
+ primary key (organizationId, groupId, permissionId)
+);
+
+create table OrgGroupRole (
+ organizationId bigint not null,
+ groupId bigint not null,
+ roleId bigint not null,
+ primary key (organizationId, groupId, roleId)
+);
+
+create table OrgLabor (
+ orgLaborId bigint not null primary key,
+ organizationId bigint,
+ typeId integer,
+ 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 table PasswordPolicy (
+ passwordPolicyId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ defaultPolicy bool,
+ name varchar(75) null,
+ description text null,
+ changeable bool,
+ changeRequired bool,
+ minAge bigint,
+ checkSyntax bool,
+ allowDictionaryWords bool,
+ minLength integer,
+ history bool,
+ historyCount integer,
+ expireable bool,
+ maxAge bigint,
+ warningTime bigint,
+ graceLimit integer,
+ lockout bool,
+ maxFailure integer,
+ lockoutDuration bigint,
+ requireUnlock bool,
+ resetFailureCount bigint
+);
+
+create table PasswordPolicyRel (
+ passwordPolicyRelId bigint not null primary key,
+ passwordPolicyId bigint,
+ classNameId bigint,
+ classPK bigint
+);
+
+create table PasswordTracker (
+ passwordTrackerId bigint not null primary key,
+ userId bigint,
+ createDate timestamp null,
+ password_ varchar(75) null
+);
+
+create table Permission_ (
+ permissionId bigint not null primary key,
+ companyId bigint,
+ actionId varchar(75) null,
+ resourceId bigint
+);
+
+create table Phone (
+ phoneId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ number_ varchar(75) null,
+ extension varchar(75) null,
+ typeId integer,
+ primary_ bool
+);
+
+create table PluginSetting (
+ pluginSettingId bigint not null primary key,
+ companyId bigint,
+ pluginId varchar(75) null,
+ pluginType varchar(75) null,
+ roles text null,
+ active_ bool
+);
+
+create table PollsChoice (
+ uuid_ varchar(75) null,
+ choiceId bigint not null primary key,
+ questionId bigint,
+ name varchar(75) null,
+ description varchar(1000) null
+);
+
+create table PollsQuestion (
+ uuid_ varchar(75) null,
+ questionId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ title varchar(500) null,
+ description text null,
+ expirationDate timestamp null,
+ lastVoteDate timestamp null
+);
+
+create table PollsVote (
+ voteId bigint not null primary key,
+ userId bigint,
+ questionId bigint,
+ choiceId bigint,
+ voteDate timestamp null
+);
+
+create table Portlet (
+ id_ bigint not null primary key,
+ companyId bigint,
+ portletId varchar(200) null,
+ roles text null,
+ active_ bool
+);
+
+create table PortletItem (
+ portletItemId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ portletId varchar(75) null,
+ classNameId bigint
+);
+
+create table PortletPreferences (
+ portletPreferencesId bigint not null primary key,
+ ownerId bigint,
+ ownerType integer,
+ plid bigint,
+ portletId varchar(200) null,
+ preferences text null
+);
+
+create table RatingsEntry (
+ entryId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ score double precision
+);
+
+create table RatingsStats (
+ statsId bigint not null primary key,
+ classNameId bigint,
+ classPK bigint,
+ totalEntries integer,
+ totalScore double precision,
+ averageScore double precision
+);
+
+create table Region (
+ regionId bigint not null primary key,
+ countryId bigint,
+ regionCode varchar(75) null,
+ name varchar(75) null,
+ active_ bool
+);
+
+create table Release_ (
+ releaseId bigint not null primary key,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ buildNumber integer,
+ buildDate timestamp null,
+ verified bool,
+ testString varchar(1024) null
+);
+
+create table Resource_ (
+ resourceId bigint not null primary key,
+ codeId bigint,
+ primKey varchar(255) null
+);
+
+create table ResourceAction (
+ resourceActionId bigint not null primary key,
+ name varchar(75) null,
+ actionId varchar(75) null,
+ bitwiseValue bigint
+);
+
+create table ResourceCode (
+ codeId bigint not null primary key,
+ companyId bigint,
+ name varchar(255) null,
+ scope integer
+);
+
+create table ResourcePermission (
+ resourcePermissionId bigint not null primary key,
+ companyId bigint,
+ name varchar(255) null,
+ scope integer,
+ primKey varchar(255) null,
+ roleId bigint,
+ actionIds bigint
+);
+
+create table Role_ (
+ roleId bigint not null primary key,
+ companyId bigint,
+ classNameId bigint,
+ classPK bigint,
+ name varchar(75) null,
+ title text null,
+ description text null,
+ type_ integer,
+ subtype varchar(75) null
+);
+
+create table Roles_Permissions (
+ roleId bigint not null,
+ permissionId bigint not null,
+ primary key (roleId, permissionId)
+);
+
+create table SCFrameworkVersi_SCProductVers (
+ frameworkVersionId bigint not null,
+ productVersionId bigint not null,
+ primary key (frameworkVersionId, productVersionId)
+);
+
+create table SCFrameworkVersion (
+ frameworkVersionId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ url text null,
+ active_ bool,
+ priority integer
+);
+
+create table SCLicense (
+ licenseId bigint not null primary key,
+ name varchar(75) null,
+ url text null,
+ openSource bool,
+ active_ bool,
+ recommended bool
+);
+
+create table SCLicenses_SCProductEntries (
+ licenseId bigint not null,
+ productEntryId bigint not null,
+ primary key (licenseId, productEntryId)
+);
+
+create table SCProductEntry (
+ productEntryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ type_ varchar(75) null,
+ tags varchar(255) null,
+ shortDescription text null,
+ longDescription text null,
+ pageURL text null,
+ author varchar(75) null,
+ repoGroupId varchar(75) null,
+ repoArtifactId varchar(75) null
+);
+
+create table SCProductScreenshot (
+ productScreenshotId bigint not null primary key,
+ companyId bigint,
+ groupId bigint,
+ productEntryId bigint,
+ thumbnailId bigint,
+ fullImageId bigint,
+ priority integer
+);
+
+create table SCProductVersion (
+ productVersionId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ productEntryId bigint,
+ version varchar(75) null,
+ changeLog text null,
+ downloadPageURL text null,
+ directDownloadURL varchar(2000) null,
+ repoStoreArtifact bool
+);
+
+create table ServiceComponent (
+ serviceComponentId bigint not null primary key,
+ buildNamespace varchar(75) null,
+ buildNumber bigint,
+ buildDate bigint,
+ data_ text null
+);
+
+create table Shard (
+ shardId bigint not null primary key,
+ classNameId bigint,
+ classPK bigint,
+ name varchar(75) null
+);
+
+create table ShoppingCart (
+ cartId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ itemIds text null,
+ couponCodes varchar(75) null,
+ altShipping integer,
+ insure bool
+);
+
+create table ShoppingCategory (
+ categoryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentCategoryId bigint,
+ name varchar(75) null,
+ description text null
+);
+
+create table ShoppingCoupon (
+ couponId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ code_ varchar(75) null,
+ name varchar(75) null,
+ description text null,
+ startDate timestamp null,
+ endDate timestamp null,
+ active_ bool,
+ limitCategories text null,
+ limitSkus text null,
+ minOrder double precision,
+ discount double precision,
+ discountType varchar(75) null
+);
+
+create table ShoppingItem (
+ itemId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ categoryId bigint,
+ sku varchar(75) null,
+ name varchar(200) null,
+ description text null,
+ properties text null,
+ fields_ bool,
+ fieldsQuantities text null,
+ minQuantity integer,
+ maxQuantity integer,
+ price double precision,
+ discount double precision,
+ taxable bool,
+ shipping double precision,
+ useShippingFormula bool,
+ requiresShipping bool,
+ stockQuantity integer,
+ featured_ bool,
+ sale_ bool,
+ smallImage bool,
+ smallImageId bigint,
+ smallImageURL varchar(75) null,
+ mediumImage bool,
+ mediumImageId bigint,
+ mediumImageURL varchar(75) null,
+ largeImage bool,
+ largeImageId bigint,
+ largeImageURL varchar(75) null
+);
+
+create table ShoppingItemField (
+ itemFieldId bigint not null primary key,
+ itemId bigint,
+ name varchar(75) null,
+ values_ text null,
+ description text null
+);
+
+create table ShoppingItemPrice (
+ itemPriceId bigint not null primary key,
+ itemId bigint,
+ minQuantity integer,
+ maxQuantity integer,
+ price double precision,
+ discount double precision,
+ taxable bool,
+ shipping double precision,
+ useShippingFormula bool,
+ status integer
+);
+
+create table ShoppingOrder (
+ orderId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ number_ varchar(75) null,
+ tax double precision,
+ shipping double precision,
+ altShipping varchar(75) null,
+ requiresShipping bool,
+ insure bool,
+ insurance double precision,
+ couponCodes varchar(75) null,
+ couponDiscount double precision,
+ billingFirstName varchar(75) null,
+ billingLastName varchar(75) null,
+ billingEmailAddress varchar(75) null,
+ billingCompany varchar(75) null,
+ billingStreet varchar(75) null,
+ billingCity varchar(75) null,
+ billingState varchar(75) null,
+ billingZip varchar(75) null,
+ billingCountry varchar(75) null,
+ billingPhone varchar(75) null,
+ shipToBilling bool,
+ shippingFirstName varchar(75) null,
+ shippingLastName varchar(75) null,
+ shippingEmailAddress varchar(75) null,
+ shippingCompany varchar(75) null,
+ shippingStreet varchar(75) null,
+ shippingCity varchar(75) null,
+ shippingState varchar(75) null,
+ shippingZip varchar(75) null,
+ shippingCountry varchar(75) null,
+ shippingPhone varchar(75) null,
+ ccName varchar(75) null,
+ ccType varchar(75) null,
+ ccNumber varchar(75) null,
+ ccExpMonth integer,
+ ccExpYear integer,
+ ccVerNumber varchar(75) null,
+ comments text null,
+ ppTxnId varchar(75) null,
+ ppPaymentStatus varchar(75) null,
+ ppPaymentGross double precision,
+ ppReceiverEmail varchar(75) null,
+ ppPayerEmail varchar(75) null,
+ sendOrderEmail bool,
+ sendShippingEmail bool
+);
+
+create table ShoppingOrderItem (
+ orderItemId bigint not null primary key,
+ orderId bigint,
+ itemId varchar(75) null,
+ sku varchar(75) null,
+ name varchar(200) null,
+ description text null,
+ properties text null,
+ price double precision,
+ quantity integer,
+ shippedDate timestamp null
+);
+
+create table SocialActivity (
+ activityId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ mirrorActivityId bigint,
+ classNameId bigint,
+ classPK bigint,
+ type_ integer,
+ extraData text null,
+ receiverUserId bigint
+);
+
+create table SocialRelation (
+ uuid_ varchar(75) null,
+ relationId bigint not null primary key,
+ companyId bigint,
+ createDate timestamp null,
+ userId1 bigint,
+ userId2 bigint,
+ type_ integer
+);
+
+create table SocialRequest (
+ uuid_ varchar(75) null,
+ requestId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ type_ integer,
+ extraData text null,
+ receiverUserId bigint,
+ status integer
+);
+
+create table Subscription (
+ subscriptionId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ frequency varchar(75) null
+);
+
+create table TagsAsset (
+ assetId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ visible bool,
+ startDate timestamp null,
+ endDate timestamp null,
+ publishDate timestamp null,
+ expirationDate timestamp null,
+ mimeType varchar(75) null,
+ title varchar(255) null,
+ description text null,
+ summary text null,
+ url text null,
+ height integer,
+ width integer,
+ priority double precision,
+ viewCount integer
+);
+
+create table TagsAssets_TagsEntries (
+ assetId bigint not null,
+ entryId bigint not null,
+ primary key (assetId, entryId)
+);
+
+create table TagsEntry (
+ entryId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ parentEntryId bigint,
+ name varchar(75) null,
+ vocabularyId bigint
+);
+
+create table TagsProperty (
+ propertyId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ entryId bigint,
+ key_ varchar(75) null,
+ value varchar(255) null
+);
+
+create table TagsSource (
+ sourceId bigint not null primary key,
+ parentSourceId bigint,
+ name varchar(75) null,
+ acronym varchar(75) null
+);
+
+create table TagsVocabulary (
+ vocabularyId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ description varchar(75) null,
+ folksonomy bool
+);
+
+create table TasksProposal (
+ proposalId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK varchar(75) null,
+ name varchar(75) null,
+ description text null,
+ publishDate timestamp null,
+ dueDate timestamp null
+);
+
+create table TasksReview (
+ reviewId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ proposalId bigint,
+ assignedByUserId bigint,
+ assignedByUserName varchar(75) null,
+ stage integer,
+ completed bool,
+ rejected bool
+);
+
+create table User_ (
+ uuid_ varchar(75) null,
+ userId bigint not null primary key,
+ companyId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ defaultUser bool,
+ contactId bigint,
+ password_ varchar(75) null,
+ passwordEncrypted bool,
+ passwordReset bool,
+ passwordModifiedDate timestamp null,
+ reminderQueryQuestion varchar(75) null,
+ reminderQueryAnswer varchar(75) null,
+ graceLoginCount integer,
+ screenName varchar(75) null,
+ emailAddress varchar(75) null,
+ openId varchar(1024) null,
+ portraitId bigint,
+ languageId varchar(75) null,
+ timeZoneId varchar(75) null,
+ greeting varchar(255) null,
+ comments text null,
+ firstName varchar(75) null,
+ middleName varchar(75) null,
+ lastName varchar(75) null,
+ jobTitle varchar(75) null,
+ loginDate timestamp null,
+ loginIP varchar(75) null,
+ lastLoginDate timestamp null,
+ lastLoginIP varchar(75) null,
+ lastFailedLoginDate timestamp null,
+ failedLoginAttempts integer,
+ lockout bool,
+ lockoutDate timestamp null,
+ agreedToTermsOfUse bool,
+ active_ bool
+);
+
+create table UserGroup (
+ userGroupId bigint not null primary key,
+ companyId bigint,
+ parentUserGroupId bigint,
+ name varchar(75) null,
+ description text null
+);
+
+create table UserGroupRole (
+ userId bigint not null,
+ groupId bigint not null,
+ roleId bigint not null,
+ primary key (userId, groupId, roleId)
+);
+
+create table UserIdMapper (
+ userIdMapperId bigint not null primary key,
+ userId bigint,
+ type_ varchar(75) null,
+ description varchar(75) null,
+ externalUserId varchar(75) null
+);
+
+create table Users_Groups (
+ userId bigint not null,
+ groupId bigint not null,
+ primary key (userId, groupId)
+);
+
+create table Users_Orgs (
+ userId bigint not null,
+ organizationId bigint not null,
+ primary key (userId, organizationId)
+);
+
+create table Users_Permissions (
+ userId bigint not null,
+ permissionId bigint not null,
+ primary key (userId, permissionId)
+);
+
+create table Users_Roles (
+ userId bigint not null,
+ roleId bigint not null,
+ primary key (userId, roleId)
+);
+
+create table Users_UserGroups (
+ userGroupId bigint not null,
+ userId bigint not null,
+ primary key (userGroupId, userId)
+);
+
+create table UserTracker (
+ userTrackerId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ modifiedDate timestamp null,
+ sessionId varchar(200) null,
+ remoteAddr varchar(75) null,
+ remoteHost varchar(75) null,
+ userAgent varchar(200) null
+);
+
+create table UserTrackerPath (
+ userTrackerPathId bigint not null primary key,
+ userTrackerId bigint,
+ path_ text null,
+ pathDate timestamp null
+);
+
+create table Vocabulary (
+ vocabularyId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ description varchar(75) null,
+ folksonomy bool
+);
+
+create table WebDAVProps (
+ webDavPropsId bigint not null primary key,
+ companyId bigint,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ props text null
+);
+
+create table Website (
+ websiteId bigint not null primary key,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ classNameId bigint,
+ classPK bigint,
+ url text null,
+ typeId integer,
+ primary_ bool
+);
+
+create table WikiNode (
+ uuid_ varchar(75) null,
+ nodeId bigint not null primary key,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ name varchar(75) null,
+ description text null,
+ lastPostDate timestamp null
+);
+
+create table WikiPage (
+ uuid_ varchar(75) null,
+ pageId bigint not null primary key,
+ resourcePrimKey bigint,
+ groupId bigint,
+ companyId bigint,
+ userId bigint,
+ userName varchar(75) null,
+ createDate timestamp null,
+ modifiedDate timestamp null,
+ nodeId bigint,
+ title varchar(255) null,
+ version double precision,
+ minorEdit bool,
+ content text null,
+ summary text null,
+ format varchar(75) null,
+ head bool,
+ parentTitle varchar(75) null,
+ redirectTitle varchar(75) null
+);
+
+create table WikiPageResource (
+ resourcePrimKey bigint not null primary key,
+ nodeId bigint,
+ title varchar(75) null
+);
+
+
+
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (1, 'Canada', 'CA', 'CAN', '124', '001', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (2, 'China', 'CN', 'CHN', '156', '086', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (3, 'France', 'FR', 'FRA', '250', '033', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (4, 'Germany', 'DE', 'DEU', '276', '049', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (5, 'Hong Kong', 'HK', 'HKG', '344', '852', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (6, 'Hungary', 'HU', 'HUN', '348', '036', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (7, 'Israel', 'IL', 'ISR', '376', '972', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (8, 'Italy', 'IT', 'ITA', '380', '039', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (9, 'Japan', 'JP', 'JPN', '392', '081', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (10, 'South Korea', 'KR', 'KOR', '410', '082', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (11, 'Netherlands', 'NL', 'NLD', '528', '031', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (12, 'Portugal', 'PT', 'PRT', '620', '351', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (13, 'Russia', 'RU', 'RUS', '643', '007', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (14, 'Singapore', 'SG', 'SGP', '702', '065', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (15, 'Spain', 'ES', 'ESP', '724', '034', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (16, 'Turkey', 'TR', 'TUR', '792', '090', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (17, 'Vietnam', 'VM', 'VNM', '704', '084', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (18, 'United Kingdom', 'GB', 'GBR', '826', '044', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (19, 'United States', 'US', 'USA', '840', '001', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (20, 'Afghanistan', 'AF', 'AFG', '4', '093', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (21, 'Albania', 'AL', 'ALB', '8', '355', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (22, 'Algeria', 'DZ', 'DZA', '12', '213', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (23, 'American Samoa', 'AS', 'ASM', '16', '684', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (24, 'Andorra', 'AD', 'AND', '20', '376', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (25, 'Angola', 'AO', 'AGO', '24', '244', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (26, 'Anguilla', 'AI', 'AIA', '660', '264', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (27, 'Antarctica', 'AQ', 'ATA', '10', '672', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (28, 'Antigua', 'AG', 'ATG', '28', '268', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (29, 'Argentina', 'AR', 'ARG', '32', '054', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (30, 'Armenia', 'AM', 'ARM', '51', '374', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (31, 'Aruba', 'AW', 'ABW', '533', '297', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (32, 'Australia', 'AU', 'AUS', '36', '061', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (33, 'Austria', 'AT', 'AUT', '40', '043', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (34, 'Azerbaijan', 'AZ', 'AZE', '31', '994', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (35, 'Bahamas', 'BS', 'BHS', '44', '242', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (36, 'Bahrain', 'BH', 'BHR', '48', '973', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (37, 'Bangladesh', 'BD', 'BGD', '50', '880', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (38, 'Barbados', 'BB', 'BRB', '52', '246', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (39, 'Belarus', 'BY', 'BLR', '112', '375', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (40, 'Belgium', 'BE', 'BEL', '56', '032', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (41, 'Belize', 'BZ', 'BLZ', '84', '501', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (42, 'Benin', 'BJ', 'BEN', '204', '229', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (43, 'Bermuda', 'BM', 'BMU', '60', '441', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (44, 'Bhutan', 'BT', 'BTN', '64', '975', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (45, 'Bolivia', 'BO', 'BOL', '68', '591', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (46, 'Bosnia-Herzegovina', 'BA', 'BIH', '70', '387', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (47, 'Botswana', 'BW', 'BWA', '72', '267', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (48, 'Brazil', 'BR', 'BRA', '76', '055', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (49, 'British Virgin Islands', 'VG', 'VGB', '92', '284', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (50, 'Brunei', 'BN', 'BRN', '96', '673', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (51, 'Bulgaria', 'BG', 'BGR', '100', '359', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (52, 'Burkina Faso', 'BF', 'BFA', '854', '226', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (53, 'Burma (Myanmar)', 'MM', 'MMR', '104', '095', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (54, 'Burundi', 'BI', 'BDI', '108', '257', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (55, 'Cambodia', 'KH', 'KHM', '116', '855', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (56, 'Cameroon', 'CM', 'CMR', '120', '237', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (57, 'Cape Verde Island', 'CV', 'CPV', '132', '238', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (58, 'Cayman Islands', 'KY', 'CYM', '136', '345', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (59, 'Central African Republic', 'CF', 'CAF', '140', '236', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (60, 'Chad', 'TD', 'TCD', '148', '235', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (61, 'Chile', 'CL', 'CHL', '152', '056', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (62, 'Christmas Island', 'CX', 'CXR', '162', '061', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (63, 'Cocos Islands', 'CC', 'CCK', '166', '061', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (64, 'Colombia', 'CO', 'COL', '170', '057', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (65, 'Comoros', 'KM', 'COM', '174', '269', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (66, 'Republic of Congo', 'CD', 'COD', '180', '242', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (67, 'Democratic Republic of Congo', 'CG', 'COG', '178', '243', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (68, 'Cook Islands', 'CK', 'COK', '184', '682', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (69, 'Costa Rica', 'CR', 'CRI', '188', '506', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (70, 'Croatia', 'HR', 'HRV', '191', '385', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (71, 'Cuba', 'CU', 'CUB', '192', '053', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (72, 'Cyprus', 'CY', 'CYP', '196', '357', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (73, 'Czech Republic', 'CZ', 'CZE', '203', '420', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (74, 'Denmark', 'DK', 'DNK', '208', '045', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (75, 'Djibouti', 'DJ', 'DJI', '262', '253', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (76, 'Dominica', 'DM', 'DMA', '212', '767', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (77, 'Dominican Republic', 'DO', 'DOM', '214', '809', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (78, 'Ecuador', 'EC', 'ECU', '218', '593', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (79, 'Egypt', 'EG', 'EGY', '818', '020', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (80, 'El Salvador', 'SV', 'SLV', '222', '503', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (81, 'Equatorial Guinea', 'GQ', 'GNQ', '226', '240', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (82, 'Eritrea', 'ER', 'ERI', '232', '291', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (83, 'Estonia', 'EE', 'EST', '233', '372', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (84, 'Ethiopia', 'ET', 'ETH', '231', '251', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (85, 'Faeroe Islands', 'FO', 'FRO', '234', '298', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (86, 'Falkland Islands', 'FK', 'FLK', '238', '500', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (87, 'Fiji Islands', 'FJ', 'FJI', '242', '679', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (88, 'Finland', 'FI', 'FIN', '246', '358', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (89, 'French Guiana', 'GF', 'GUF', '254', '594', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (90, 'French Polynesia', 'PF', 'PYF', '258', '689', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (91, 'Gabon', 'GA', 'GAB', '266', '241', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (92, 'Gambia', 'GM', 'GMB', '270', '220', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (93, 'Georgia', 'GE', 'GEO', '268', '995', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (94, 'Ghana', 'GH', 'GHA', '288', '233', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (95, 'Gibraltar', 'GI', 'GIB', '292', '350', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (96, 'Greece', 'GR', 'GRC', '300', '030', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (97, 'Greenland', 'GL', 'GRL', '304', '299', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (98, 'Grenada', 'GD', 'GRD', '308', '473', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (99, 'Guadeloupe', 'GP', 'GLP', '312', '590', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (100, 'Guam', 'GU', 'GUM', '316', '671', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (101, 'Guatemala', 'GT', 'GTM', '320', '502', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (102, 'Guinea', 'GN', 'GIN', '324', '224', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (103, 'Guinea-Bissau', 'GW', 'GNB', '624', '245', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (104, 'Guyana', 'GY', 'GUY', '328', '592', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (105, 'Haiti', 'HT', 'HTI', '332', '509', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (106, 'Honduras', 'HN', 'HND', '340', '504', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (107, 'Iceland', 'IS', 'ISL', '352', '354', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (108, 'India', 'IN', 'IND', '356', '091', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (109, 'Indonesia', 'ID', 'IDN', '360', '062', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (110, 'Iran', 'IR', 'IRN', '364', '098', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (111, 'Iraq', 'IQ', 'IRQ', '368', '964', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (112, 'Ireland', 'IE', 'IRL', '372', '353', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (113, 'Ivory Coast', 'CI', 'CIV', '384', '225', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (114, 'Jamaica', 'JM', 'JAM', '388', '876', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (115, 'Jordan', 'JO', 'JOR', '400', '962', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (116, 'Kazakhstan', 'KZ', 'KAZ', '398', '007', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (117, 'Kenya', 'KE', 'KEN', '404', '254', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (118, 'Kiribati', 'KI', 'KIR', '408', '686', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (119, 'Kuwait', 'KW', 'KWT', '414', '965', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (120, 'North Korea', 'KP', 'PRK', '408', '850', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (121, 'Kyrgyzstan', 'KG', 'KGZ', '471', '996', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (122, 'Laos', 'LA', 'LAO', '418', '856', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (123, 'Latvia', 'LV', 'LVA', '428', '371', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (124, 'Lebanon', 'LB', 'LBN', '422', '961', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (125, 'Lesotho', 'LS', 'LSO', '426', '266', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (126, 'Liberia', 'LR', 'LBR', '430', '231', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (127, 'Libya', 'LY', 'LBY', '434', '218', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (128, 'Liechtenstein', 'LI', 'LIE', '438', '423', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (129, 'Lithuania', 'LT', 'LTU', '440', '370', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (130, 'Luxembourg', 'LU', 'LUX', '442', '352', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (131, 'Macau', 'MO', 'MAC', '446', '853', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (132, 'Macedonia', 'MK', 'MKD', '807', '389', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (133, 'Madagascar', 'MG', 'MDG', '450', '261', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (134, 'Malawi', 'MW', 'MWI', '454', '265', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (135, 'Malaysia', 'MY', 'MYS', '458', '060', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (136, 'Maldives', 'MV', 'MDV', '462', '960', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (137, 'Mali', 'ML', 'MLI', '466', '223', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (138, 'Malta', 'MT', 'MLT', '470', '356', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (139, 'Marshall Islands', 'MH', 'MHL', '584', '692', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (140, 'Martinique', 'MQ', 'MTQ', '474', '596', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (141, 'Mauritania', 'MR', 'MRT', '478', '222', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (142, 'Mauritius', 'MU', 'MUS', '480', '230', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (143, 'Mayotte Island', 'YT', 'MYT', '175', '269', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (144, 'Mexico', 'MX', 'MEX', '484', '052', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (145, 'Micronesia', 'FM', 'FSM', '583', '691', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (146, 'Moldova', 'MD', 'MDA', '498', '373', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (147, 'Monaco', 'MC', 'MCO', '492', '377', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (148, 'Mongolia', 'MN', 'MNG', '496', '976', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (149, 'Montenegro', 'ME', 'MNE', '499', '382', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (150, 'Montserrat', 'MS', 'MSR', '500', '664', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (151, 'Morocco', 'MA', 'MAR', '504', '212', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (152, 'Mozambique', 'MZ', 'MOZ', '508', '258', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (153, 'Namibia', 'NA', 'NAM', '516', '264', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (154, 'Nauru', 'NR', 'NRU', '520', '674', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (155, 'Nepal', 'NP', 'NPL', '524', '977', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (156, 'Netherlands Antilles', 'AN', 'ANT', '530', '599', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (157, 'New Caledonia', 'NC', 'NCL', '540', '687', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (158, 'New Zealand', 'NZ', 'NZL', '554', '064', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (159, 'Nicaragua', 'NI', 'NIC', '558', '505', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (160, 'Niger', 'NE', 'NER', '562', '227', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (161, 'Nigeria', 'NG', 'NGA', '566', '234', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (162, 'Niue', 'NU', 'NIU', '570', '683', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (163, 'Norfolk Island', 'NF', 'NFK', '574', '672', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (164, 'Norway', 'NO', 'NOR', '578', '047', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (165, 'Oman', 'OM', 'OMN', '512', '968', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (166, 'Pakistan', 'PK', 'PAK', '586', '092', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (167, 'Palau', 'PW', 'PLW', '585', '680', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (168, 'Palestine', 'PS', 'PSE', '275', '970', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (169, 'Panama', 'PA', 'PAN', '591', '507', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (170, 'Papua New Guinea', 'PG', 'PNG', '598', '675', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (171, 'Paraguay', 'PY', 'PRY', '600', '595', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (172, 'Peru', 'PE', 'PER', '604', '051', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (173, 'Philippines', 'PH', 'PHL', '608', '063', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (174, 'Poland', 'PL', 'POL', '616', '048', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (175, 'Puerto Rico', 'PR', 'PRI', '630', '787', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (176, 'Qatar', 'QA', 'QAT', '634', '974', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (177, 'Reunion Island', 'RE', 'REU', '638', '262', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (178, 'Romania', 'RO', 'ROU', '642', '040', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (179, 'Rwanda', 'RW', 'RWA', '646', '250', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (180, 'St. Helena', 'SH', 'SHN', '654', '290', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (181, 'St. Kitts', 'KN', 'KNA', '659', '869', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (182, 'St. Lucia', 'LC', 'LCA', '662', '758', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (183, 'St. Pierre & Miquelon', 'PM', 'SPM', '666', '508', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (184, 'St. Vincent', 'VC', 'VCT', '670', '784', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (185, 'San Marino', 'SM', 'SMR', '674', '378', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (186, 'Sao Tome & Principe', 'ST', 'STP', '678', '239', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (187, 'Saudi Arabia', 'SA', 'SAU', '682', '966', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (188, 'Senegal', 'SN', 'SEN', '686', '221', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (189, 'Serbia', 'RS', 'SRB', '688', '381', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (190, 'Seychelles', 'SC', 'SYC', '690', '248', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (191, 'Sierra Leone', 'SL', 'SLE', '694', '249', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (192, 'Slovakia', 'SK', 'SVK', '703', '421', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (193, 'Slovenia', 'SI', 'SVN', '705', '386', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (194, 'Solomon Islands', 'SB', 'SLB', '90', '677', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (195, 'Somalia', 'SO', 'SOM', '706', '252', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (196, 'South Africa', 'ZA', 'ZAF', '710', '027', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (197, 'Sri Lanka', 'LK', 'LKA', '144', '094', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (198, 'Sudan', 'SD', 'SDN', '736', '095', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (199, 'Suriname', 'SR', 'SUR', '740', '597', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (200, 'Swaziland', 'SZ', 'SWZ', '748', '268', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (201, 'Sweden', 'SE', 'SWE', '752', '046', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (202, 'Switzerland', 'CH', 'CHE', '756', '041', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (203, 'Syria', 'SY', 'SYR', '760', '963', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (204, 'Taiwan', 'TW', 'TWN', '158', '886', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (205, 'Tajikistan', 'TJ', 'TJK', '762', '992', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (206, 'Tanzania', 'TZ', 'TZA', '834', '255', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (207, 'Thailand', 'TH', 'THA', '764', '066', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (208, 'Togo', 'TG', 'TGO', '768', '228', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (209, 'Tonga', 'TO', 'TON', '776', '676', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (210, 'Trinidad & Tobago', 'TT', 'TTO', '780', '868', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (211, 'Tunisia', 'TN', 'TUN', '788', '216', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (212, 'Turkmenistan', 'TM', 'TKM', '795', '993', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (213, 'Turks & Caicos', 'TC', 'TCA', '796', '649', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (214, 'Tuvalu', 'TV', 'TUV', '798', '688', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (215, 'Uganda', 'UG', 'UGA', '800', '256', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (216, 'Ukraine', 'UA', 'UKR', '804', '380', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (217, 'United Arab Emirates', 'AE', 'ARE', '784', '971', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (218, 'Uruguay', 'UY', 'URY', '858', '598', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (219, 'Uzbekistan', 'UZ', 'UZB', '860', '998', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (220, 'Vanuatu', 'VU', 'VUT', '548', '678', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (221, 'Vatican City', 'VA', 'VAT', '336', '039', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (222, 'Venezuela', 'VE', 'VEN', '862', '058', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (223, 'Wallis & Futuna', 'WF', 'WLF', '876', '681', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (224, 'Western Samoa', 'EH', 'ESH', '732', '685', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (225, 'Yemen', 'YE', 'YEM', '887', '967', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (226, 'Zambia', 'ZM', 'ZMB', '894', '260', true);
+insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (227, 'Zimbabwe', 'ZW', 'ZWE', '716', '263', true);
+
+insert into Region (regionId, countryId, regionCode, name, active_) values (1001, 1, 'AB', 'Alberta', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1002, 1, 'BC', 'British Columbia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1003, 1, 'MB', 'Manitoba', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1004, 1, 'NB', 'New Brunswick', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1005, 1, 'NL', 'Newfoundland and Labrador', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1006, 1, 'NT', 'Northwest Territories', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1007, 1, 'NS', 'Nova Scotia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1008, 1, 'NU', 'Nunavut', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1009, 1, 'ON', 'Ontario', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1010, 1, 'PE', 'Prince Edward Island', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1011, 1, 'QC', 'Quebec', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1012, 1, 'SK', 'Saskatchewan', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (1013, 1, 'YT', 'Yukon', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3001, 3, 'A', 'Alsace', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3002, 3, 'B', 'Aquitaine', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3003, 3, 'C', 'Auvergne', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3004, 3, 'P', 'Basse-Normandie', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3005, 3, 'D', 'Bourgogne', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3006, 3, 'E', 'Bretagne', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3007, 3, 'F', 'Centre', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3008, 3, 'G', 'Champagne-Ardenne', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3009, 3, 'H', 'Corse', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3010, 3, 'GF', 'Guyane', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3011, 3, 'I', 'Franche Comté', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3012, 3, 'GP', 'Guadeloupe', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3013, 3, 'Q', 'Haute-Normandie', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3014, 3, 'J', 'ÃŽle-de-France', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3015, 3, 'K', 'Languedoc-Roussillon', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3016, 3, 'L', 'Limousin', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3017, 3, 'M', 'Lorraine', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3018, 3, 'MQ', 'Martinique', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3019, 3, 'N', 'Midi-Pyrénées', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3020, 3, 'O', 'Nord Pas de Calais', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3021, 3, 'R', 'Pays de la Loire', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3022, 3, 'S', 'Picardie', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3023, 3, 'T', 'Poitou-Charentes', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3024, 3, 'U', 'Provence-Alpes-Côte-d\'Azur', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3025, 3, 'RE', 'Réunion', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (3026, 3, 'V', 'Rhône-Alpes', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4001, 4, 'BW', 'Baden-Württemberg', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4002, 4, 'BY', 'Bayern', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4003, 4, 'BE', 'Berlin', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4004, 4, 'BR', 'Brandenburg', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4005, 4, 'HB', 'Bremen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4006, 4, 'HH', 'Hamburg', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4007, 4, 'HE', 'Hessen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4008, 4, 'MV', 'Mecklenburg-Vorpommern', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4009, 4, 'NI', 'Niedersachsen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4010, 4, 'NW', 'Nordrhein-Westfalen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4011, 4, 'RP', 'Rheinland-Pfalz', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4012, 4, 'SL', 'Saarland', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4013, 4, 'SN', 'Sachsen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4014, 4, 'ST', 'Sachsen-Anhalt', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4015, 4, 'SH', 'Schleswig-Holstein', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (4016, 4, 'TH', 'Thüringen', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8001, 8, 'AG', 'Agrigento', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8002, 8, 'AL', 'Alessandria', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8003, 8, 'AN', 'Ancona', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8004, 8, 'AO', 'Aosta', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8005, 8, 'AR', 'Arezzo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8006, 8, 'AP', 'Ascoli Piceno', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8007, 8, 'AT', 'Asti', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8008, 8, 'AV', 'Avellino', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8009, 8, 'BA', 'Bari', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8010, 8, 'BT', 'Barletta-Andria-Trani', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8011, 8, 'BL', 'Belluno', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8012, 8, 'BN', 'Benevento', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8013, 8, 'BG', 'Bergamo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8014, 8, 'BI', 'Biella', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8015, 8, 'BO', 'Bologna', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8016, 8, 'BZ', 'Bolzano', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8017, 8, 'BS', 'Brescia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8018, 8, 'BR', 'Brindisi', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8019, 8, 'CA', 'Cagliari', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8020, 8, 'CL', 'Caltanissetta', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8021, 8, 'CB', 'Campobasso', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8022, 8, 'CI', 'Carbonia-Iglesias', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8023, 8, 'CE', 'Caserta', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8024, 8, 'CT', 'Catania', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8025, 8, 'CZ', 'Catanzaro', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8026, 8, 'CH', 'Chieti', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8027, 8, 'CO', 'Como', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8028, 8, 'CS', 'Cosenza', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8029, 8, 'CR', 'Cremona', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8030, 8, 'KR', 'Crotone', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8031, 8, 'CN', 'Cuneo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8032, 8, 'EN', 'Enna', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8033, 8, 'FM', 'Fermo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8034, 8, 'FE', 'Ferrara', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8035, 8, 'FI', 'Firenze', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8036, 8, 'FG', 'Foggia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8037, 8, 'FC', 'Forli-Cesena', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8038, 8, 'FR', 'Frosinone', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8039, 8, 'GE', 'Genova', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8040, 8, 'GO', 'Gorizia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8041, 8, 'GR', 'Grosseto', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8042, 8, 'IM', 'Imperia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8043, 8, 'IS', 'Isernia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8044, 8, 'AQ', 'L''Aquila', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8045, 8, 'SP', 'La Spezia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8046, 8, 'LT', 'Latina', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8047, 8, 'LE', 'Lecce', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8048, 8, 'LC', 'Lecco', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8049, 8, 'LI', 'Livorno', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8050, 8, 'LO', 'Lodi', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8051, 8, 'LU', 'Lucca', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8052, 8, 'MC', 'Macerata', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8053, 8, 'MN', 'Mantova', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8054, 8, 'MS', 'Massa-Carrara', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8055, 8, 'MT', 'Matera', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8056, 8, 'MA', 'Medio Campidano', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8057, 8, 'ME', 'Messina', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8058, 8, 'MI', 'Milano', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8059, 8, 'MO', 'Modena', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8060, 8, 'MZ', 'Monza', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8061, 8, 'NA', 'Napoli', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8062, 8, 'NO', 'Novara', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8063, 8, 'NU', 'Nuoro', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8064, 8, 'OG', 'Ogliastra', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8065, 8, 'OT', 'Olbia-Tempio', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8066, 8, 'OR', 'Oristano', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8067, 8, 'PD', 'Padova', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8068, 8, 'PA', 'Palermo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8069, 8, 'PR', 'Parma', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8070, 8, 'PV', 'Pavia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8071, 8, 'PG', 'Perugia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8072, 8, 'PU', 'Pesaro e Urbino', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8073, 8, 'PE', 'Pescara', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8074, 8, 'PC', 'Piacenza', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8075, 8, 'PI', 'Pisa', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8076, 8, 'PT', 'Pistoia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8077, 8, 'PN', 'Pordenone', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8078, 8, 'PZ', 'Potenza', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8079, 8, 'PO', 'Prato', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8080, 8, 'RG', 'Ragusa', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8081, 8, 'RA', 'Ravenna', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8082, 8, 'RC', 'Reggio Calabria', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8083, 8, 'RE', 'Reggio Emilia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8084, 8, 'RI', 'Rieti', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8085, 8, 'RN', 'Rimini', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8086, 8, 'RM', 'Roma', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8087, 8, 'RO', 'Rovigo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8088, 8, 'SA', 'Salerno', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8089, 8, 'SS', 'Sassari', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8090, 8, 'SV', 'Savona', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8091, 8, 'SI', 'Siena', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8092, 8, 'SR', 'Siracusa', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8093, 8, 'SO', 'Sondrio', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8094, 8, 'TA', 'Taranto', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8095, 8, 'TE', 'Teramo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8096, 8, 'TR', 'Terni', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8097, 8, 'TO', 'Torino', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8098, 8, 'TP', 'Trapani', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8099, 8, 'TN', 'Trento', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8100, 8, 'TV', 'Treviso', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8101, 8, 'TS', 'Trieste', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8102, 8, 'UD', 'Udine', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8103, 8, 'VA', 'Varese', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8104, 8, 'VE', 'Venezia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8105, 8, 'VB', 'Verbano-Cusio-Ossola', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8106, 8, 'VC', 'Vercelli', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8107, 8, 'VR', 'Verona', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8108, 8, 'VV', 'Vibo Valentia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8109, 8, 'VI', 'Vicenza', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (8110, 8, 'VT', 'Viterbo', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15001, 15, 'AN', 'Andalusia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15002, 15, 'AR', 'Aragon', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15003, 15, 'AS', 'Asturias', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15004, 15, 'IB', 'Balearic Islands', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15005, 15, 'PV', 'Basque Country', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15006, 15, 'CN', 'Canary Islands', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15007, 15, 'CB', 'Cantabria', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15008, 15, 'CL', 'Castile and Leon', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15009, 15, 'CM', 'Castile-La Mancha', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15010, 15, 'CT', 'Catalonia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15011, 15, 'CE', 'Ceuta', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15012, 15, 'EX', 'Extremadura', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15013, 15, 'GA', 'Galicia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15014, 15, 'LO', 'La Rioja', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15015, 15, 'M', 'Madrid', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15016, 15, 'ML', 'Melilla', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15017, 15, 'MU', 'Murcia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15018, 15, 'NA', 'Navarra', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (15019, 15, 'VC', 'Valencia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19001, 19, 'AL', 'Alabama', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19002, 19, 'AK', 'Alaska', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19003, 19, 'AZ', 'Arizona', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19004, 19, 'AR', 'Arkansas', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19005, 19, 'CA', 'California', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19006, 19, 'CO', 'Colorado', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19007, 19, 'CT', 'Connecticut', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19008, 19, 'DC', 'District of Columbia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19009, 19, 'DE', 'Delaware', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19010, 19, 'FL', 'Florida', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19011, 19, 'GA', 'Georgia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19012, 19, 'HI', 'Hawaii', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19013, 19, 'ID', 'Idaho', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19014, 19, 'IL', 'Illinois', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19015, 19, 'IN', 'Indiana', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19016, 19, 'IA', 'Iowa', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19017, 19, 'KS', 'Kansas', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19018, 19, 'KY', 'Kentucky ', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19019, 19, 'LA', 'Louisiana ', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19020, 19, 'ME', 'Maine', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19021, 19, 'MD', 'Maryland', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19022, 19, 'MA', 'Massachusetts', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19023, 19, 'MI', 'Michigan', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19024, 19, 'MN', 'Minnesota', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19025, 19, 'MS', 'Mississippi', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19026, 19, 'MO', 'Missouri', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19027, 19, 'MT', 'Montana', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19028, 19, 'NE', 'Nebraska', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19029, 19, 'NV', 'Nevada', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19030, 19, 'NH', 'New Hampshire', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19031, 19, 'NJ', 'New Jersey', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19032, 19, 'NM', 'New Mexico', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19033, 19, 'NY', 'New York', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19034, 19, 'NC', 'North Carolina', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19035, 19, 'ND', 'North Dakota', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19036, 19, 'OH', 'Ohio', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19037, 19, 'OK', 'Oklahoma ', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19038, 19, 'OR', 'Oregon', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19039, 19, 'PA', 'Pennsylvania', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19040, 19, 'PR', 'Puerto Rico', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19041, 19, 'RI', 'Rhode Island', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19042, 19, 'SC', 'South Carolina', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19043, 19, 'SD', 'South Dakota', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19044, 19, 'TN', 'Tennessee', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19045, 19, 'TX', 'Texas', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19046, 19, 'UT', 'Utah', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19047, 19, 'VT', 'Vermont', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19048, 19, 'VA', 'Virginia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19049, 19, 'WA', 'Washington', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19050, 19, 'WV', 'West Virginia', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19051, 19, 'WI', 'Wisconsin', true);
+insert into Region (regionId, countryId, regionCode, name, active_) values (19052, 19, 'WY', 'Wyoming', true);
+
+--
+-- List types for accounts
+--
+
+insert into ListType (listTypeId, name, type_) values (10000, 'Billing', 'com.liferay.portal.model.Account.address');
+insert into ListType (listTypeId, name, type_) values (10001, 'Other', 'com.liferay.portal.model.Account.address');
+insert into ListType (listTypeId, name, type_) values (10002, 'P.O. Box', 'com.liferay.portal.model.Account.address');
+insert into ListType (listTypeId, name, type_) values (10003, 'Shipping', 'com.liferay.portal.model.Account.address');
+
+insert into ListType (listTypeId, name, type_) values (10004, 'E-mail', 'com.liferay.portal.model.Account.emailAddress');
+insert into ListType (listTypeId, name, type_) values (10005, 'E-mail 2', 'com.liferay.portal.model.Account.emailAddress');
+insert into ListType (listTypeId, name, type_) values (10006, 'E-mail 3', 'com.liferay.portal.model.Account.emailAddress');
+
+insert into ListType (listTypeId, name, type_) values (10007, 'Fax', 'com.liferay.portal.model.Account.phone');
+insert into ListType (listTypeId, name, type_) values (10008, 'Local', 'com.liferay.portal.model.Account.phone');
+insert into ListType (listTypeId, name, type_) values (10009, 'Other', 'com.liferay.portal.model.Account.phone');
+insert into ListType (listTypeId, name, type_) values (10010, 'Toll-Free', 'com.liferay.portal.model.Account.phone');
+insert into ListType (listTypeId, name, type_) values (10011, 'TTY', 'com.liferay.portal.model.Account.phone');
+
+insert into ListType (listTypeId, name, type_) values (10012, 'Intranet', 'com.liferay.portal.model.Account.website');
+insert into ListType (listTypeId, name, type_) values (10013, 'Public', 'com.liferay.portal.model.Account.website');
+
+--
+-- List types for contacts
+--
+
+insert into ListType (listTypeId, name, type_) values (11000, 'Business', 'com.liferay.portal.model.Contact.address');
+insert into ListType (listTypeId, name, type_) values (11001, 'Other', 'com.liferay.portal.model.Contact.address');
+insert into ListType (listTypeId, name, type_) values (11002, 'Personal', 'com.liferay.portal.model.Contact.address');
+
+insert into ListType (listTypeId, name, type_) values (11003, 'E-mail', 'com.liferay.portal.model.Contact.emailAddress');
+insert into ListType (listTypeId, name, type_) values (11004, 'E-mail 2', 'com.liferay.portal.model.Contact.emailAddress');
+insert into ListType (listTypeId, name, type_) values (11005, 'E-mail 3', 'com.liferay.portal.model.Contact.emailAddress');
+
+insert into ListType (listTypeId, name, type_) values (11006, 'Business', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11007, 'Business Fax', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11008, 'Mobile', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11009, 'Other', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11010, 'Pager', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11011, 'Personal', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11012, 'Personal Fax', 'com.liferay.portal.model.Contact.phone');
+insert into ListType (listTypeId, name, type_) values (11013, 'TTY', 'com.liferay.portal.model.Contact.phone');
+
+insert into ListType (listTypeId, name, type_) values (11014, 'Dr.', 'com.liferay.portal.model.Contact.prefix');
+insert into ListType (listTypeId, name, type_) values (11015, 'Mr.', 'com.liferay.portal.model.Contact.prefix');
+insert into ListType (listTypeId, name, type_) values (11016, 'Mrs.', 'com.liferay.portal.model.Contact.prefix');
+insert into ListType (listTypeId, name, type_) values (11017, 'Ms.', 'com.liferay.portal.model.Contact.prefix');
+
+insert into ListType (listTypeId, name, type_) values (11020, 'II', 'com.liferay.portal.model.Contact.suffix');
+insert into ListType (listTypeId, name, type_) values (11021, 'III', 'com.liferay.portal.model.Contact.suffix');
+insert into ListType (listTypeId, name, type_) values (11022, 'IV', 'com.liferay.portal.model.Contact.suffix');
+insert into ListType (listTypeId, name, type_) values (11023, 'Jr.', 'com.liferay.portal.model.Contact.suffix');
+insert into ListType (listTypeId, name, type_) values (11024, 'PhD.', 'com.liferay.portal.model.Contact.suffix');
+insert into ListType (listTypeId, name, type_) values (11025, 'Sr.', 'com.liferay.portal.model.Contact.suffix');
+
+insert into ListType (listTypeId, name, type_) values (11026, 'Blog', 'com.liferay.portal.model.Contact.website');
+insert into ListType (listTypeId, name, type_) values (11027, 'Business', 'com.liferay.portal.model.Contact.website');
+insert into ListType (listTypeId, name, type_) values (11028, 'Other', 'com.liferay.portal.model.Contact.website');
+insert into ListType (listTypeId, name, type_) values (11029, 'Personal', 'com.liferay.portal.model.Contact.website');
+
+--
+-- List types for organizations
+--
+
+insert into ListType (listTypeId, name, type_) values (12000, 'Billing', 'com.liferay.portal.model.Organization.address');
+insert into ListType (listTypeId, name, type_) values (12001, 'Other', 'com.liferay.portal.model.Organization.address');
+insert into ListType (listTypeId, name, type_) values (12002, 'P.O. Box', 'com.liferay.portal.model.Organization.address');
+insert into ListType (listTypeId, name, type_) values (12003, 'Shipping', 'com.liferay.portal.model.Organization.address');
+
+insert into ListType (listTypeId, name, type_) values (12004, 'E-mail', 'com.liferay.portal.model.Organization.emailAddress');
+insert into ListType (listTypeId, name, type_) values (12005, 'E-mail 2', 'com.liferay.portal.model.Organization.emailAddress');
+insert into ListType (listTypeId, name, type_) values (12006, 'E-mail 3', 'com.liferay.portal.model.Organization.emailAddress');
+
+insert into ListType (listTypeId, name, type_) values (12007, 'Fax', 'com.liferay.portal.model.Organization.phone');
+insert into ListType (listTypeId, name, type_) values (12008, 'Local', 'com.liferay.portal.model.Organization.phone');
+insert into ListType (listTypeId, name, type_) values (12009, 'Other', 'com.liferay.portal.model.Organization.phone');
+insert into ListType (listTypeId, name, type_) values (12010, 'Toll-Free', 'com.liferay.portal.model.Organization.phone');
+insert into ListType (listTypeId, name, type_) values (12011, 'TTY', 'com.liferay.portal.model.Organization.phone');
+
+insert into ListType (listTypeId, name, type_) values (12012, 'Administrative', 'com.liferay.portal.model.Organization.service');
+insert into ListType (listTypeId, name, type_) values (12013, 'Contracts', 'com.liferay.portal.model.Organization.service');
+insert into ListType (listTypeId, name, type_) values (12014, 'Donation', 'com.liferay.portal.model.Organization.service');
+insert into ListType (listTypeId, name, type_) values (12015, 'Retail', 'com.liferay.portal.model.Organization.service');
+insert into ListType (listTypeId, name, type_) values (12016, 'Training', 'com.liferay.portal.model.Organization.service');
+
+insert into ListType (listTypeId, name, type_) values (12017, 'Full Member', 'com.liferay.portal.model.Organization.status');
+insert into ListType (listTypeId, name, type_) values (12018, 'Provisional Member', 'com.liferay.portal.model.Organization.status');
+
+insert into ListType (listTypeId, name, type_) values (12019, 'Intranet', 'com.liferay.portal.model.Organization.website');
+insert into ListType (listTypeId, name, type_) values (12020, 'Public', 'com.liferay.portal.model.Organization.website');
+
+
+
+insert into Counter values ('com.liferay.counter.model.Counter', 10000);
+
+
+insert into Release_ (releaseId, createDate, modifiedDate, buildNumber, verified) values (1, current_timestamp, current_timestamp, 5203, false);
+
+
+create table QUARTZ_JOB_DETAILS (
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ DESCRIPTION varchar(120) null,
+ JOB_CLASS_NAME varchar(128) not null,
+ IS_DURABLE bool not null,
+ IS_VOLATILE bool not null,
+ IS_STATEFUL bool not null,
+ REQUESTS_RECOVERY bool not null,
+ JOB_DATA bytea null,
+ primary key (JOB_NAME, JOB_GROUP)
+);
+
+create table QUARTZ_JOB_LISTENERS (
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ JOB_LISTENER varchar(80) not null,
+ primary key (JOB_NAME, JOB_GROUP, JOB_LISTENER)
+);
+
+create table QUARTZ_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ IS_VOLATILE bool not null,
+ DESCRIPTION varchar(120) null,
+ NEXT_FIRE_TIME bigint null,
+ PREV_FIRE_TIME bigint null,
+ PRIORITY integer null,
+ TRIGGER_STATE varchar(16) not null,
+ TRIGGER_TYPE varchar(8) not null,
+ START_TIME bigint not null,
+ END_TIME bigint null,
+ CALENDAR_NAME varchar(80) null,
+ MISFIRE_INSTR integer null,
+ JOB_DATA bytea null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_SIMPLE_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ REPEAT_COUNT bigint not null,
+ REPEAT_INTERVAL bigint not null,
+ TIMES_TRIGGERED bigint not null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_CRON_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ CRON_EXPRESSION varchar(80) not null,
+ TIME_ZONE_ID varchar(80),
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_BLOB_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ BLOB_DATA bytea null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_TRIGGER_LISTENERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ TRIGGER_LISTENER varchar(80) not null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER)
+);
+
+create table QUARTZ_CALENDARS (
+ CALENDAR_NAME varchar(80) not null primary key,
+ CALENDAR bytea not null
+);
+
+create table QUARTZ_PAUSED_TRIGGER_GRPS (
+ TRIGGER_GROUP varchar(80) not null primary key
+);
+
+create table QUARTZ_FIRED_TRIGGERS (
+ ENTRY_ID varchar(95) not null primary key,
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ IS_VOLATILE bool not null,
+ INSTANCE_NAME varchar(80) not null,
+ FIRED_TIME bigint not null,
+ PRIORITY integer not null,
+ STATE varchar(16) not null,
+ JOB_NAME varchar(80) null,
+ JOB_GROUP varchar(80) null,
+ IS_STATEFUL bool null,
+ REQUESTS_RECOVERY bool null
+);
+
+create table QUARTZ_SCHEDULER_STATE (
+ INSTANCE_NAME varchar(80) not null primary key,
+ LAST_CHECKIN_TIME bigint not null,
+ CHECKIN_INTERVAL bigint not null
+);
+
+create table QUARTZ_LOCKS (
+ LOCK_NAME varchar(40) not null primary key
+);
+
+commit;
+
+insert into QUARTZ_LOCKS values('TRIGGER_ACCESS');
+insert into QUARTZ_LOCKS values('JOB_ACCESS');
+insert into QUARTZ_LOCKS values('CALENDAR_ACCESS');
+insert into QUARTZ_LOCKS values('STATE_ACCESS');
+insert into QUARTZ_LOCKS values('MISFIRE_ACCESS');
+
+create index IX_F7655CC3 on QUARTZ_TRIGGERS (NEXT_FIRE_TIME);
+create index IX_9955EFB5 on QUARTZ_TRIGGERS (TRIGGER_STATE);
+create index IX_8040C593 on QUARTZ_TRIGGERS (TRIGGER_STATE, NEXT_FIRE_TIME);
+create index IX_804154AF on QUARTZ_FIRED_TRIGGERS (INSTANCE_NAME);
+create index IX_BAB9A1F7 on QUARTZ_FIRED_TRIGGERS (JOB_GROUP);
+create index IX_ADEE6A17 on QUARTZ_FIRED_TRIGGERS (JOB_NAME);
+create index IX_64B194F2 on QUARTZ_FIRED_TRIGGERS (TRIGGER_GROUP);
+create index IX_5FEABBC on QUARTZ_FIRED_TRIGGERS (TRIGGER_NAME);
+create index IX_20D8706C on QUARTZ_FIRED_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP);
+
+
+
+commit;
+
+
+create index IX_93D5AD4E on Address (companyId);
+create index IX_ABD7DAC0 on Address (companyId, classNameId);
+create index IX_71CB1123 on Address (companyId, classNameId, classPK);
+create index IX_923BD178 on Address (companyId, classNameId, classPK, mailing);
+create index IX_9226DBB4 on Address (companyId, classNameId, classPK, primary_);
+create index IX_5BC8B0D4 on Address (userId);
+
+create index IX_6EDB9600 on AnnouncementsDelivery (userId);
+create unique index IX_BA4413D5 on AnnouncementsDelivery (userId, type_);
+
+create index IX_A6EF0B81 on AnnouncementsEntry (classNameId, classPK);
+create index IX_14F06A6B on AnnouncementsEntry (classNameId, classPK, alert);
+create index IX_D49C2E66 on AnnouncementsEntry (userId);
+create index IX_1AFBDE08 on AnnouncementsEntry (uuid_);
+
+create index IX_9C7EB9F on AnnouncementsFlag (entryId);
+create unique index IX_4539A99C on AnnouncementsFlag (userId, entryId, value);
+
+create index IX_72EF6041 on BlogsEntry (companyId);
+create index IX_E0D90212 on BlogsEntry (companyId, displayDate, draft);
+create index IX_81A50303 on BlogsEntry (groupId);
+create index IX_DA53AFD4 on BlogsEntry (groupId, displayDate, draft);
+create unique index IX_DB780A20 on BlogsEntry (groupId, urlTitle);
+create index IX_C07CA83D on BlogsEntry (groupId, userId);
+create index IX_B88E740E on BlogsEntry (groupId, userId, displayDate, draft);
+create index IX_69157A4D on BlogsEntry (uuid_);
+create unique index IX_1B1040FD on BlogsEntry (uuid_, groupId);
+
+create index IX_90CDA39A on BlogsStatsUser (companyId, entryCount);
+create index IX_43840EEB on BlogsStatsUser (groupId);
+create index IX_28C78D5C on BlogsStatsUser (groupId, entryCount);
+create unique index IX_82254C25 on BlogsStatsUser (groupId, userId);
+create index IX_BB51F1D9 on BlogsStatsUser (userId);
+
+create index IX_443BDC38 on BookmarksEntry (folderId);
+create index IX_E52FF7EF on BookmarksEntry (groupId);
+create index IX_E2E9F129 on BookmarksEntry (groupId, userId);
+create index IX_B670BA39 on BookmarksEntry (uuid_);
+create unique index IX_EAA02A91 on BookmarksEntry (uuid_, groupId);
+
+create index IX_2ABA25D7 on BookmarksFolder (companyId);
+create index IX_7F703619 on BookmarksFolder (groupId);
+create index IX_967799C0 on BookmarksFolder (groupId, parentFolderId);
+create index IX_451E7AE3 on BookmarksFolder (uuid_);
+create unique index IX_DC2F8927 on BookmarksFolder (uuid_, groupId);
+
+create unique index IX_E7B95510 on BrowserTracker (userId);
+
+create index IX_D6FD9496 on CalEvent (companyId);
+create index IX_12EE4898 on CalEvent (groupId);
+create index IX_4FDDD2BF on CalEvent (groupId, repeating);
+create index IX_FCD7C63D on CalEvent (groupId, type_);
+create index IX_F6006202 on CalEvent (remindBy);
+create index IX_C1AD2122 on CalEvent (uuid_);
+create unique index IX_5CCE79C8 on CalEvent (uuid_, groupId);
+
+create unique index IX_B27A301F on ClassName_ (value);
+
+create index IX_38EFE3FD on Company (logoId);
+create index IX_12566EC2 on Company (mx);
+create index IX_35E3E7C6 on Company (system);
+create unique index IX_975996C0 on Company (virtualHost);
+create unique index IX_EC00543C on Company (webId);
+
+create index IX_66D496A3 on Contact_ (companyId);
+
+create unique index IX_717B97E1 on Country (a2);
+create unique index IX_717B9BA2 on Country (a3);
+create index IX_25D734CD on Country (active_);
+create unique index IX_19DA007B on Country (name);
+
+create index IX_4CB1B2B4 on DLFileEntry (companyId);
+create index IX_24A846D1 on DLFileEntry (folderId);
+create unique index IX_8F6C75D0 on DLFileEntry (folderId, name);
+create index IX_A9951F17 on DLFileEntry (folderId, title);
+create index IX_F4AF5636 on DLFileEntry (groupId);
+create index IX_43261870 on DLFileEntry (groupId, userId);
+create index IX_64F0FE40 on DLFileEntry (uuid_);
+create unique index IX_BC2E7E6A on DLFileEntry (uuid_, groupId);
+
+create unique index IX_CE705D48 on DLFileRank (companyId, userId, folderId, name);
+create index IX_40B56512 on DLFileRank (folderId, name);
+create index IX_BAFB116E on DLFileRank (groupId, userId);
+create index IX_EED06670 on DLFileRank (userId);
+
+create index IX_E56EC6AD on DLFileShortcut (folderId);
+create index IX_CA2708A2 on DLFileShortcut (toFolderId, toName);
+create index IX_4831EBE4 on DLFileShortcut (uuid_);
+create unique index IX_FDB4A946 on DLFileShortcut (uuid_, groupId);
+
+create index IX_9CD91DB6 on DLFileVersion (folderId, name);
+create unique index IX_6C5E6512 on DLFileVersion (folderId, name, version);
+
+create index IX_A74DB14C on DLFolder (companyId);
+create index IX_F2EA1ACE on DLFolder (groupId);
+create index IX_49C37475 on DLFolder (groupId, parentFolderId);
+create unique index IX_902FD874 on DLFolder (groupId, parentFolderId, name);
+create index IX_51556082 on DLFolder (parentFolderId, name);
+create index IX_CBC408D8 on DLFolder (uuid_);
+create unique index IX_3CC1DED2 on DLFolder (uuid_, groupId);
+
+create index IX_1BB072CA on EmailAddress (companyId);
+create index IX_49D2DEC4 on EmailAddress (companyId, classNameId);
+create index IX_551A519F on EmailAddress (companyId, classNameId, classPK);
+create index IX_2A2CB130 on EmailAddress (companyId, classNameId, classPK, primary_);
+create index IX_7B43CD8 on EmailAddress (userId);
+
+create index IX_A8C0CBE8 on ExpandoColumn (tableId);
+create unique index IX_FEFC8DA7 on ExpandoColumn (tableId, name);
+
+create index IX_D3F5D7AE on ExpandoRow (tableId);
+create unique index IX_81EFBFF5 on ExpandoRow (tableId, classPK);
+
+create index IX_B5AE8A85 on ExpandoTable (companyId, classNameId);
+create unique index IX_37562284 on ExpandoTable (companyId, classNameId, name);
+
+create index IX_B29FEF17 on ExpandoValue (classNameId, classPK);
+create index IX_F7DD0987 on ExpandoValue (columnId);
+create unique index IX_9DDD21E5 on ExpandoValue (columnId, rowId_);
+create index IX_9112A7A0 on ExpandoValue (rowId_);
+create index IX_F0566A77 on ExpandoValue (tableId);
+create index IX_1BD3F4C on ExpandoValue (tableId, classPK);
+create index IX_CA9AFB7C on ExpandoValue (tableId, columnId);
+create unique index IX_D27B03E7 on ExpandoValue (tableId, columnId, classPK);
+create index IX_B71E92D5 on ExpandoValue (tableId, rowId_);
+
+create unique index IX_D0D5E397 on Group_ (companyId, classNameId, classPK);
+create unique index IX_5DE0BE11 on Group_ (companyId, classNameId, liveGroupId, name);
+create unique index IX_5BDDB872 on Group_ (companyId, friendlyURL);
+create unique index IX_BBCA55B on Group_ (companyId, liveGroupId, name);
+create unique index IX_5AA68501 on Group_ (companyId, name);
+create index IX_16218A38 on Group_ (liveGroupId);
+create index IX_7B590A7A on Group_ (type_, active_);
+
+create index IX_75267DCA on Groups_Orgs (groupId);
+create index IX_6BBB7682 on Groups_Orgs (organizationId);
+
+create index IX_C48736B on Groups_Permissions (groupId);
+create index IX_EC97689D on Groups_Permissions (permissionId);
+
+create index IX_84471FD2 on Groups_Roles (groupId);
+create index IX_3103EF3D on Groups_Roles (roleId);
+
+create index IX_31FB749A on Groups_UserGroups (groupId);
+create index IX_3B69160F on Groups_UserGroups (userGroupId);
+
+create index IX_60214CF6 on IGFolder (companyId);
+create index IX_206498F8 on IGFolder (groupId);
+create index IX_1A605E9F on IGFolder (groupId, parentFolderId);
+create unique index IX_9BBAFB1E on IGFolder (groupId, parentFolderId, name);
+create index IX_F73C0982 on IGFolder (uuid_);
+create unique index IX_B10EFD68 on IGFolder (uuid_, groupId);
+
+create index IX_E597322D on IGImage (custom1ImageId);
+create index IX_D9E0A34C on IGImage (custom2ImageId);
+create index IX_4438CA80 on IGImage (folderId);
+create index IX_BCB13A3F on IGImage (folderId, name);
+create index IX_63820A7 on IGImage (groupId);
+create index IX_BE79E1E1 on IGImage (groupId, userId);
+create index IX_64F0B572 on IGImage (largeImageId);
+create index IX_D3D32126 on IGImage (smallImageId);
+create index IX_265BB0F1 on IGImage (uuid_);
+create unique index IX_E97342D9 on IGImage (uuid_, groupId);
+
+create index IX_6A925A4D on Image (size_);
+
+create index IX_DFF98523 on JournalArticle (companyId);
+create index IX_9356F865 on JournalArticle (groupId);
+create index IX_68C0F69C on JournalArticle (groupId, articleId);
+create index IX_8DBF1387 on JournalArticle (groupId, articleId, approved);
+create unique index IX_85C52EEC on JournalArticle (groupId, articleId, version);
+create index IX_2E207659 on JournalArticle (groupId, structureId);
+create index IX_8DEAE14E on JournalArticle (groupId, templateId);
+create index IX_22882D02 on JournalArticle (groupId, urlTitle);
+create index IX_76186981 on JournalArticle (resourcePrimKey, approved);
+create index IX_EF9B7028 on JournalArticle (smallImageId);
+create index IX_F029602F on JournalArticle (uuid_);
+create unique index IX_3463D95B on JournalArticle (uuid_, groupId);
+
+create index IX_3B51BB68 on JournalArticleImage (groupId);
+create index IX_158B526F on JournalArticleImage (groupId, articleId, version);
+create unique index IX_103D6207 on JournalArticleImage (groupId, articleId, version, elInstanceId, elName, languageId);
+create index IX_D4121315 on JournalArticleImage (tempImage);
+
+create index IX_F8433677 on JournalArticleResource (groupId);
+create unique index IX_88DF994A on JournalArticleResource (groupId, articleId);
+
+create index IX_6838E427 on JournalContentSearch (groupId, articleId);
+create index IX_20962903 on JournalContentSearch (groupId, privateLayout);
+create index IX_7CC7D73E on JournalContentSearch (groupId, privateLayout, articleId);
+create index IX_B3B318DC on JournalContentSearch (groupId, privateLayout, layoutId);
+create index IX_7ACC74C9 on JournalContentSearch (groupId, privateLayout, layoutId, portletId);
+create unique index IX_C3AA93B8 on JournalContentSearch (groupId, privateLayout, layoutId, portletId, articleId);
+
+create index IX_35A2DB2F on JournalFeed (groupId);
+create unique index IX_65576CBC on JournalFeed (groupId, feedId);
+create index IX_50C36D79 on JournalFeed (uuid_);
+create unique index IX_39031F51 on JournalFeed (uuid_, groupId);
+
+create index IX_B97F5608 on JournalStructure (groupId);
+create index IX_CA0BD48C on JournalStructure (groupId, parentStructureId);
+create unique index IX_AB6E9996 on JournalStructure (groupId, structureId);
+create index IX_8831E4FC on JournalStructure (structureId);
+create index IX_6702CA92 on JournalStructure (uuid_);
+create unique index IX_42E86E58 on JournalStructure (uuid_, groupId);
+
+create index IX_77923653 on JournalTemplate (groupId);
+create index IX_1701CB2B on JournalTemplate (groupId, structureId);
+create unique index IX_E802AA3C on JournalTemplate (groupId, templateId);
+create index IX_25FFB6FA on JournalTemplate (smallImageId);
+create index IX_1B12CA20 on JournalTemplate (templateId);
+create index IX_2857419D on JournalTemplate (uuid_);
+create unique index IX_62D1B3AD on JournalTemplate (uuid_, groupId);
+
+create index IX_C7FBC998 on Layout (companyId);
+create index IX_FAD05595 on Layout (dlFolderId);
+create index IX_C099D61A on Layout (groupId);
+create index IX_705F5AA3 on Layout (groupId, privateLayout);
+create unique index IX_BC2C4231 on Layout (groupId, privateLayout, friendlyURL);
+create unique index IX_7162C27C on Layout (groupId, privateLayout, layoutId);
+create index IX_6DE88B06 on Layout (groupId, privateLayout, parentLayoutId);
+create index IX_1A1B61D2 on Layout (groupId, privateLayout, type_);
+create index IX_23922F7D on Layout (iconImageId);
+
+create index IX_A40B8BEC on LayoutSet (groupId);
+create unique index IX_48550691 on LayoutSet (groupId, privateLayout);
+create index IX_5ABC2905 on LayoutSet (virtualHost);
+
+create index IX_2932DD37 on ListType (type_);
+
+create index IX_69951A25 on MBBan (banUserId);
+create index IX_5C3FF12A on MBBan (groupId);
+create unique index IX_8ABC4E3B on MBBan (groupId, banUserId);
+create index IX_48814BBA on MBBan (userId);
+
+create index IX_BC735DCF on MBCategory (companyId);
+create index IX_BB870C11 on MBCategory (groupId);
+create index IX_ED292508 on MBCategory (groupId, parentCategoryId);
+create index IX_C2626EDB on MBCategory (uuid_);
+create unique index IX_F7D28C2F on MBCategory (uuid_, groupId);
+
+create index IX_79D0120B on MBDiscussion (classNameId);
+create unique index IX_33A4DE38 on MBDiscussion (classNameId, classPK);
+create unique index IX_B5CA2DC on MBDiscussion (threadId);
+
+create index IX_BFEB984F on MBMailingList (active_);
+create unique index IX_ADA16FE7 on MBMailingList (categoryId);
+create index IX_4115EC7A on MBMailingList (uuid_);
+create unique index IX_E858F170 on MBMailingList (uuid_, groupId);
+
+create index IX_3C865EE5 on MBMessage (categoryId);
+create index IX_138C7F1E on MBMessage (categoryId, threadId);
+create index IX_51A8D44D on MBMessage (classNameId, classPK);
+create index IX_B1432D30 on MBMessage (companyId);
+create index IX_5B153FB2 on MBMessage (groupId);
+create index IX_8EB8C5EC on MBMessage (groupId, userId);
+create index IX_75B95071 on MBMessage (threadId);
+create index IX_A7038CD7 on MBMessage (threadId, parentMessageId);
+create index IX_C57B16BC on MBMessage (uuid_);
+create unique index IX_8D12316E on MBMessage (uuid_, groupId);
+
+create index IX_D180D4AE on MBMessageFlag (messageId);
+create index IX_A6973A8E on MBMessageFlag (messageId, flag);
+create index IX_C1C9A8FD on MBMessageFlag (threadId);
+create index IX_3CFD579D on MBMessageFlag (threadId, flag);
+create index IX_7B2917BE on MBMessageFlag (userId);
+create unique index IX_E9EB6194 on MBMessageFlag (userId, messageId, flag);
+create index IX_2EA537D7 on MBMessageFlag (userId, threadId, flag);
+
+create index IX_A00A898F on MBStatsUser (groupId);
+create index IX_FAB5A88B on MBStatsUser (groupId, messageCount);
+create unique index IX_9168E2C9 on MBStatsUser (groupId, userId);
+create index IX_847F92B5 on MBStatsUser (userId);
+
+create index IX_CB854772 on MBThread (categoryId);
+create index IX_19D8B60A on MBThread (categoryId, lastPostDate);
+create index IX_95C0EA45 on MBThread (groupId);
+
+create index IX_8A1CC4B on MembershipRequest (groupId);
+create index IX_C28C72EC on MembershipRequest (groupId, statusId);
+create index IX_66D70879 on MembershipRequest (userId);
+
+create index IX_A425F71A on OrgGroupPermission (groupId);
+create index IX_6C53DA4E on OrgGroupPermission (permissionId);
+
+create index IX_4A527DD3 on OrgGroupRole (groupId);
+create index IX_AB044D1C on OrgGroupRole (roleId);
+
+create index IX_6AF0D434 on OrgLabor (organizationId);
+
+create index IX_834BCEB6 on Organization_ (companyId);
+create unique index IX_E301BDF5 on Organization_ (companyId, name);
+create index IX_418E4522 on Organization_ (companyId, parentOrganizationId);
+
+create index IX_2C1142E on PasswordPolicy (companyId, defaultPolicy);
+create unique index IX_3FBFA9F4 on PasswordPolicy (companyId, name);
+
+create index IX_C3A17327 on PasswordPolicyRel (classNameId, classPK);
+create index IX_ED7CF243 on PasswordPolicyRel (passwordPolicyId, classNameId, classPK);
+
+create index IX_326F75BD on PasswordTracker (userId);
+
+create unique index IX_4D19C2B8 on Permission_ (actionId, resourceId);
+create index IX_F090C113 on Permission_ (resourceId);
+
+create index IX_9F704A14 on Phone (companyId);
+create index IX_A2E4AFBA on Phone (companyId, classNameId);
+create index IX_9A53569 on Phone (companyId, classNameId, classPK);
+create index IX_812CE07A on Phone (companyId, classNameId, classPK, primary_);
+create index IX_F202B9CE on Phone (userId);
+
+create index IX_B9746445 on PluginSetting (companyId);
+create unique index IX_7171B2E8 on PluginSetting (companyId, pluginId, pluginType);
+
+create index IX_EC370F10 on PollsChoice (questionId);
+create unique index IX_D76DD2CF on PollsChoice (questionId, name);
+create index IX_6660B399 on PollsChoice (uuid_);
+
+create index IX_9FF342EA on PollsQuestion (groupId);
+create index IX_51F087F4 on PollsQuestion (uuid_);
+create unique index IX_F3C9F36 on PollsQuestion (uuid_, groupId);
+
+create index IX_D5DF7B54 on PollsVote (choiceId);
+create index IX_12112599 on PollsVote (questionId);
+create unique index IX_1BBFD4D3 on PollsVote (questionId, userId);
+
+create index IX_80CC9508 on Portlet (companyId);
+create unique index IX_12B5E51D on Portlet (companyId, portletId);
+
+create index IX_96BDD537 on PortletItem (groupId, classNameId);
+create index IX_D699243F on PortletItem (groupId, name, portletId, classNameId);
+create index IX_2C61314E on PortletItem (groupId, portletId);
+create index IX_E922D6C0 on PortletItem (groupId, portletId, classNameId);
+create index IX_8E71167F on PortletItem (groupId, portletId, classNameId, name);
+create index IX_33B8CE8D on PortletItem (groupId, portletId, name);
+
+create index IX_E4F13E6E on PortletPreferences (ownerId, ownerType, plid);
+create unique index IX_C7057FF7 on PortletPreferences (ownerId, ownerType, plid, portletId);
+create index IX_F15C1C4F on PortletPreferences (plid);
+create index IX_D340DB76 on PortletPreferences (plid, portletId);
+
+create index IX_16184D57 on RatingsEntry (classNameId, classPK);
+create unique index IX_B47E3C11 on RatingsEntry (userId, classNameId, classPK);
+
+create unique index IX_A6E99284 on RatingsStats (classNameId, classPK);
+
+create index IX_2D9A426F on Region (active_);
+create index IX_16D87CA7 on Region (countryId);
+create index IX_11FB3E42 on Region (countryId, active_);
+
+create index IX_81F2DB09 on ResourceAction (name);
+create unique index IX_EDB9986E on ResourceAction (name, actionId);
+
+create index IX_717FDD47 on ResourceCode (companyId);
+create unique index IX_A32C097E on ResourceCode (companyId, name, scope);
+create index IX_AACAFF40 on ResourceCode (name);
+
+create index IX_60B99860 on ResourcePermission (companyId, name, scope);
+create index IX_2200AA69 on ResourcePermission (companyId, name, scope, primKey);
+create unique index IX_8D83D0CE on ResourcePermission (companyId, name, scope, primKey, roleId);
+create index IX_A37A0588 on ResourcePermission (roleId);
+
+create index IX_2578FBD3 on Resource_ (codeId);
+create unique index IX_67DE7856 on Resource_ (codeId, primKey);
+
+create index IX_449A10B9 on Role_ (companyId);
+create unique index IX_A88E424E on Role_ (companyId, classNameId, classPK);
+create unique index IX_EBC931B8 on Role_ (companyId, name);
+create index IX_CBE204 on Role_ (type_, subtype);
+
+create index IX_7A3619C6 on Roles_Permissions (permissionId);
+create index IX_E04E486D on Roles_Permissions (roleId);
+
+create index IX_3BB93ECA on SCFrameworkVersi_SCProductVers (frameworkVersionId);
+create index IX_E8D33FF9 on SCFrameworkVersi_SCProductVers (productVersionId);
+
+create index IX_C98C0D78 on SCFrameworkVersion (companyId);
+create index IX_272991FA on SCFrameworkVersion (groupId);
+create index IX_6E1764F on SCFrameworkVersion (groupId, active_);
+
+create index IX_1C841592 on SCLicense (active_);
+create index IX_5327BB79 on SCLicense (active_, recommended);
+
+create index IX_27006638 on SCLicenses_SCProductEntries (licenseId);
+create index IX_D7710A66 on SCLicenses_SCProductEntries (productEntryId);
+
+create index IX_5D25244F on SCProductEntry (companyId);
+create index IX_72F87291 on SCProductEntry (groupId);
+create index IX_98E6A9CB on SCProductEntry (groupId, userId);
+create index IX_7311E812 on SCProductEntry (repoGroupId, repoArtifactId);
+
+create index IX_AE8224CC on SCProductScreenshot (fullImageId);
+create index IX_467956FD on SCProductScreenshot (productEntryId);
+create index IX_DA913A55 on SCProductScreenshot (productEntryId, priority);
+create index IX_6C572DAC on SCProductScreenshot (thumbnailId);
+
+create index IX_7020130F on SCProductVersion (directDownloadURL);
+create index IX_8377A211 on SCProductVersion (productEntryId);
+
+create index IX_7338606F on ServiceComponent (buildNamespace);
+create unique index IX_4F0315B8 on ServiceComponent (buildNamespace, buildNumber);
+
+create index IX_DA5F4359 on Shard (classNameId, classPK);
+create index IX_941BA8C3 on Shard (name);
+
+create index IX_C28B41DC on ShoppingCart (groupId);
+create unique index IX_FC46FE16 on ShoppingCart (groupId, userId);
+create index IX_54101CC8 on ShoppingCart (userId);
+
+create index IX_5F615D3E on ShoppingCategory (groupId);
+create index IX_1E6464F5 on ShoppingCategory (groupId, parentCategoryId);
+
+create unique index IX_DC60CFAE on ShoppingCoupon (code_);
+create index IX_3251AF16 on ShoppingCoupon (groupId);
+
+create index IX_C8EACF2E on ShoppingItem (categoryId);
+create unique index IX_1C717CA6 on ShoppingItem (companyId, sku);
+create index IX_903DC750 on ShoppingItem (largeImageId);
+create index IX_D217AB30 on ShoppingItem (mediumImageId);
+create index IX_FF203304 on ShoppingItem (smallImageId);
+
+create index IX_6D5F9B87 on ShoppingItemField (itemId);
+
+create index IX_EA6FD516 on ShoppingItemPrice (itemId);
+
+create index IX_1D15553E on ShoppingOrder (groupId);
+create index IX_119B5630 on ShoppingOrder (groupId, userId, ppPaymentStatus);
+create unique index IX_D7D6E87A on ShoppingOrder (number_);
+create index IX_F474FD89 on ShoppingOrder (ppTxnId);
+
+create index IX_B5F82C7A on ShoppingOrderItem (orderId);
+
+create index IX_82E39A0C on SocialActivity (classNameId);
+create index IX_A853C757 on SocialActivity (classNameId, classPK);
+create index IX_64B1BC66 on SocialActivity (companyId);
+create index IX_2A2468 on SocialActivity (groupId);
+create unique index IX_8F32DEC9 on SocialActivity (groupId, userId, createDate, classNameId, classPK, type_, receiverUserId);
+create index IX_1271F25F on SocialActivity (mirrorActivityId);
+create index IX_1F00C374 on SocialActivity (mirrorActivityId, classNameId, classPK);
+create index IX_121CA3CB on SocialActivity (receiverUserId);
+create index IX_3504B8BC on SocialActivity (userId);
+
+create index IX_61171E99 on SocialRelation (companyId);
+create index IX_95135D1C on SocialRelation (companyId, type_);
+create index IX_C31A64C6 on SocialRelation (type_);
+create index IX_5A40CDCC on SocialRelation (userId1);
+create index IX_4B52BE89 on SocialRelation (userId1, type_);
+create unique index IX_12A92145 on SocialRelation (userId1, userId2, type_);
+create index IX_5A40D18D on SocialRelation (userId2);
+create index IX_3F9C2FA8 on SocialRelation (userId2, type_);
+create index IX_F0CA24A5 on SocialRelation (uuid_);
+
+create index IX_D3425487 on SocialRequest (classNameId, classPK, type_, receiverUserId, status);
+create index IX_A90FE5A0 on SocialRequest (companyId);
+create index IX_32292ED1 on SocialRequest (receiverUserId);
+create index IX_D9380CB7 on SocialRequest (receiverUserId, status);
+create index IX_80F7A9C2 on SocialRequest (userId);
+create unique index IX_36A90CA7 on SocialRequest (userId, classNameId, classPK, type_, receiverUserId);
+create index IX_CC86A444 on SocialRequest (userId, classNameId, classPK, type_, status);
+create index IX_AB5906A8 on SocialRequest (userId, status);
+create index IX_49D5872C on SocialRequest (uuid_);
+create unique index IX_4F973EFE on SocialRequest (uuid_, groupId);
+
+create index IX_786D171A on Subscription (companyId, classNameId, classPK);
+create unique index IX_2E1A92D4 on Subscription (companyId, userId, classNameId, classPK);
+create index IX_54243AFD on Subscription (userId);
+create index IX_E8F34171 on Subscription (userId, classNameId);
+
+create unique index IX_1AB6D6D2 on TagsAsset (classNameId, classPK);
+create index IX_AB3D8BCB on TagsAsset (companyId);
+
+create index IX_B22F3A1 on TagsAssets_TagsEntries (assetId);
+create index IX_A02A8023 on TagsAssets_TagsEntries (entryId);
+
+create index IX_EE55ED49 on TagsEntry (parentEntryId, vocabularyId);
+create index IX_28E8954 on TagsEntry (vocabularyId);
+
+create index IX_C134234 on TagsProperty (companyId);
+create index IX_EB974D08 on TagsProperty (companyId, key_);
+create index IX_5200A629 on TagsProperty (entryId);
+create unique index IX_F505253D on TagsProperty (entryId, key_);
+
+create index IX_E0D51848 on TagsVocabulary (companyId, folksonomy);
+create index IX_9F26308A on TagsVocabulary (groupId, folksonomy);
+create unique index IX_F9E51044 on TagsVocabulary (groupId, name);
+
+create unique index IX_181A4A1B on TasksProposal (classNameId, classPK);
+create index IX_7FB27324 on TasksProposal (groupId);
+create index IX_6EEC675E on TasksProposal (groupId, userId);
+
+create index IX_4D0C7F8D on TasksReview (proposalId);
+create index IX_70AFEA01 on TasksReview (proposalId, stage);
+create index IX_1894B29A on TasksReview (proposalId, stage, completed);
+create index IX_41AFC20C on TasksReview (proposalId, stage, completed, rejected);
+create index IX_36F512E6 on TasksReview (userId);
+create unique index IX_5C6BE4C7 on TasksReview (userId, proposalId);
+
+create index IX_524FEFCE on UserGroup (companyId);
+create unique index IX_23EAD0D on UserGroup (companyId, name);
+create index IX_69771487 on UserGroup (companyId, parentUserGroupId);
+
+create index IX_1B988D7A on UserGroupRole (groupId);
+create index IX_871412DF on UserGroupRole (groupId, roleId);
+create index IX_887A2C95 on UserGroupRole (roleId);
+create index IX_887BE56A on UserGroupRole (userId);
+create index IX_4D040680 on UserGroupRole (userId, groupId);
+
+create unique index IX_41A32E0D on UserIdMapper (type_, externalUserId);
+create index IX_E60EA987 on UserIdMapper (userId);
+create unique index IX_D1C44A6E on UserIdMapper (userId, type_);
+
+create index IX_29BA1CF5 on UserTracker (companyId);
+create index IX_46B0AE8E on UserTracker (sessionId);
+create index IX_E4EFBA8D on UserTracker (userId);
+
+create index IX_14D8BCC0 on UserTrackerPath (userTrackerId);
+
+create index IX_3A1E834E on User_ (companyId);
+create index IX_6EF03E4E on User_ (companyId, defaultUser);
+create unique index IX_615E9F7A on User_ (companyId, emailAddress);
+create unique index IX_C5806019 on User_ (companyId, screenName);
+create unique index IX_9782AD88 on User_ (companyId, userId);
+create unique index IX_5ADBE171 on User_ (contactId);
+create index IX_762F63C6 on User_ (emailAddress);
+create index IX_A9ED7DD3 on User_ (openId);
+create index IX_A18034A4 on User_ (portraitId);
+create index IX_E0422BDA on User_ (uuid_);
+
+create index IX_C4F9E699 on Users_Groups (groupId);
+create index IX_F10B6C6B on Users_Groups (userId);
+
+create index IX_7EF4EC0E on Users_Orgs (organizationId);
+create index IX_FB646CA6 on Users_Orgs (userId);
+
+create index IX_8AE58A91 on Users_Permissions (permissionId);
+create index IX_C26AA64D on Users_Permissions (userId);
+
+create index IX_C19E5F31 on Users_Roles (roleId);
+create index IX_C1A01806 on Users_Roles (userId);
+
+create index IX_66FF2503 on Users_UserGroups (userGroupId);
+create index IX_BE8102D6 on Users_UserGroups (userId);
+
+create unique index IX_97DFA146 on WebDAVProps (classNameId, classPK);
+
+create index IX_96F07007 on Website (companyId);
+create index IX_4F0F0CA7 on Website (companyId, classNameId);
+create index IX_F960131C on Website (companyId, classNameId, classPK);
+create index IX_1AA07A6D on Website (companyId, classNameId, classPK, primary_);
+create index IX_F75690BB on Website (userId);
+
+create index IX_5D6FE3F0 on WikiNode (companyId);
+create index IX_B480A672 on WikiNode (groupId);
+create unique index IX_920CD8B1 on WikiNode (groupId, name);
+create index IX_6C112D7C on WikiNode (uuid_);
+create unique index IX_7609B2AE on WikiNode (uuid_, groupId);
+
+create index IX_A2001730 on WikiPage (format);
+create index IX_C8A9C476 on WikiPage (nodeId);
+create index IX_E7F635CA on WikiPage (nodeId, head);
+create index IX_65E84AF4 on WikiPage (nodeId, head, parentTitle);
+create index IX_46EEF3C8 on WikiPage (nodeId, parentTitle);
+create index IX_1ECC7656 on WikiPage (nodeId, redirectTitle);
+create index IX_997EEDD2 on WikiPage (nodeId, title);
+create index IX_E745EA26 on WikiPage (nodeId, title, head);
+create unique index IX_3D4AF476 on WikiPage (nodeId, title, version);
+create index IX_9C0E478F on WikiPage (uuid_);
+create unique index IX_899D3DFB on WikiPage (uuid_, groupId);
+
+create unique index IX_21277664 on WikiPageResource (nodeId, title);
+
+