Friday, August 1, 2014
Monday, August 15, 2011
questions for Mule course
1. how pooling and singletons work together:
<flow name="Test1"><vm:inbound-endpoint path="VMQ413" exchange-pattern="one-way"/>
<component>
<method-entry-point-resolver>
<include-entry-point method="next"/>
</method-entry-point-resolver>
<spring-object bean="QM413"/>
</component>
<component>
<method-entry-point-resolver>
<include-entry-point method="update"/>
</method-entry-point-resolver>
<spring-object bean="QM413"/>
</component>
// will the previous 2 components be a synchronized entry point to this flow? <filter ref="notNull"/>
<pooled-component>
<spring-object bean="QR413"/>
<pooling-profile maxActive="10" maxIdle="5" maxWait="3" initialisationPolicy="INITIALISE_ALL"/>
</pooled-component>
<async> // what does this do, for a vm queue insert? <vm:outbound-endpoint path="VMQ413" exchange-pattern="one-way"/>
</async>
</flow>
2. deployment: we are worried about having lots of Java code in our bus. Are we going to hurt our performance as a web service proxy, by having all these applications inside the Mule JVM?
3. Exception handling. What kind of info gets into the exception message? Is there a way to indicate what we were doing at the time (eg. the message that was being processed?)
4. How to tell if we're using the EE or CE Mule?
Is it the same in Maven:
<dependency>
<groupId>org.mule</groupId>
<artifactId>mule</artifactId>
<version>3.1.2</version>
<type>pom</type>
</dependency>
3. Exception handling. What kind of info gets into the exception message? Is there a way to indicate what we were doing at the time (eg. the message that was being processed?)
4. How to tell if we're using the EE or CE Mule?
Is it the same in Maven:
<dependency>
<groupId>org.mule</groupId>
<artifactId>mule</artifactId>
<version>3.1.2</version>
<type>pom</type>
</dependency>
Monday, July 18, 2011
liferay database scripts
the script for minimal oracle installation:
drop user &1 cascade;create user &1 identified by &2;grant connect,resource to &1;connect &1/&2;set define off;
create table Account_ (accountId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,parentAccountId number(30,0),name varchar2(300) null,legalName varchar2(300) null,legalId varchar2(300) null,legalType varchar2(300) null,sicCode varchar2(300) null,tickerSymbol varchar2(300) null,industry varchar2(300) null,type_ varchar2(300) null,size_ varchar2(300) null);
create table Address (addressId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),street1 varchar2(300) null,street2 varchar2(300) null,street3 varchar2(300) null,city varchar2(300) null,zip varchar2(300) null,regionId number(30,0),countryId number(30,0),typeId number(30,0),mailing number(1, 0),primary_ number(1, 0));
create table AnnouncementsDelivery (deliveryId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),type_ varchar2(300) null,email number(1, 0),sms number(1, 0),website number(1, 0));
create table AnnouncementsEntry (uuid_ varchar2(300) null,entryId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),title varchar2(300) null,content varchar2(4000) null,url varchar2(4000) null,type_ varchar2(300) null,displayDate timestamp null,expirationDate timestamp null,priority number(30,0),alert number(1, 0));
create table AnnouncementsFlag (flagId number(30,0) not null primary key,userId number(30,0),createDate timestamp null,entryId number(30,0),value number(30,0));
create table AssetCategory (uuid_ varchar2(300) null,categoryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,parentCategoryId number(30,0),leftCategoryId number(30,0),rightCategoryId number(30,0),name varchar2(300) null,title varchar2(4000) null,vocabularyId number(30,0));
create table AssetCategoryProperty (categoryPropertyId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,categoryId number(30,0),key_ varchar2(300) null,value varchar2(300) null);
create table AssetEntries_AssetCategories (entryId number(30,0) not null,categoryId number(30,0) not null,primary key (entryId, categoryId));
create table AssetEntries_AssetTags (entryId number(30,0) not null,tagId number(30,0) not null,primary key (entryId, tagId));
create table AssetEntry (entryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),classUuid varchar2(300) null,visible number(1, 0),startDate timestamp null,endDate timestamp null,publishDate timestamp null,expirationDate timestamp null,mimeType varchar2(300) null,title varchar2(1020) null,description varchar2(4000) null,summary varchar2(4000) null,url varchar2(4000) null,height number(30,0),width number(30,0),priority number(30,20),viewCount number(30,0));
create table AssetLink (linkId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,entryId1 number(30,0),entryId2 number(30,0),type_ number(30,0),weight number(30,0));
create table AssetTag (tagId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,assetCount number(30,0));
create table AssetTagProperty (tagPropertyId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,tagId number(30,0),key_ varchar2(300) null,value varchar2(1020) null);
create table AssetTagStats (tagStatsId number(30,0) not null primary key,tagId number(30,0),classNameId number(30,0),assetCount number(30,0));
create table AssetVocabulary (uuid_ varchar2(300) null,vocabularyId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,title varchar2(4000) null,description varchar2(4000) null,settings_ varchar2(4000) null);
create table BlogsEntry (uuid_ varchar2(300) null,entryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,title varchar2(600) null,urlTitle varchar2(600) null,content clob null,displayDate timestamp null,allowPingbacks number(1, 0),allowTrackbacks number(1, 0),trackbacks clob null,status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table BlogsStatsUser (statsUserId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),entryCount number(30,0),lastPostDate timestamp null,ratingsTotalEntries number(30,0),ratingsTotalScore number(30,20),ratingsAverageScore number(30,20));
create table BookmarksEntry (uuid_ varchar2(300) null,entryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,modifiedDate timestamp null,folderId number(30,0),name varchar2(1020) null,url varchar2(4000) null,comments varchar2(4000) null,visits number(30,0),priority number(30,0));
create table BookmarksFolder (uuid_ varchar2(300) null,folderId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,modifiedDate timestamp null,parentFolderId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table BrowserTracker (browserTrackerId number(30,0) not null primary key,userId number(30,0),browserKey number(30,0));
create table CalEvent (uuid_ varchar2(300) null,eventId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,title varchar2(300) null,description varchar2(4000) null,startDate timestamp null,endDate timestamp null,durationHour number(30,0),durationMinute number(30,0),allDay number(1, 0),timeZoneSensitive number(1, 0),type_ varchar2(300) null,repeating number(1, 0),recurrence clob null,remindBy number(30,0),firstReminder number(30,0),secondReminder number(30,0));
create table ClassName_ (classNameId number(30,0) not null primary key,value varchar2(800) null);
create table ClusterGroup (clusterGroupId number(30,0) not null primary key,name varchar2(300) null,clusterNodeIds varchar2(300) null,wholeCluster number(1, 0));
create table Company (companyId number(30,0) not null primary key,accountId number(30,0),webId varchar2(300) null,key_ clob null,virtualHost varchar2(300) null,mx varchar2(300) null,homeURL varchar2(4000) null,logoId number(30,0),system number(1, 0),maxUsers number(30,0));
create table Contact_ (contactId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,accountId number(30,0),parentContactId number(30,0),firstName varchar2(300) null,middleName varchar2(300) null,lastName varchar2(300) null,prefixId number(30,0),suffixId number(30,0),male number(1, 0),birthday timestamp null,smsSn varchar2(300) null,aimSn varchar2(300) null,facebookSn varchar2(300) null,icqSn varchar2(300) null,jabberSn varchar2(300) null,msnSn varchar2(300) null,mySpaceSn varchar2(300) null,skypeSn varchar2(300) null,twitterSn varchar2(300) null,ymSn varchar2(300) null,employeeStatusId varchar2(300) null,employeeNumber varchar2(300) null,jobTitle varchar2(400) null,jobClass varchar2(300) null,hoursOfOperation varchar2(300) null);
create table Counter (name varchar2(300) not null primary key,currentId number(30,0));
create table Country (countryId number(30,0) not null primary key,name varchar2(300) null,a2 varchar2(300) null,a3 varchar2(300) null,number_ varchar2(300) null,idd_ varchar2(300) null,active_ number(1, 0));
create table CyrusUser (userId varchar2(300) not null primary key,password_ varchar2(300) not null);
create table CyrusVirtual (emailAddress varchar2(300) not null primary key,userId varchar2(300) not null);
create table DLFileEntry (uuid_ varchar2(300) null,fileEntryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,versionUserId number(30,0),versionUserName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,folderId number(30,0),name varchar2(1020) null,extension varchar2(300) null,title varchar2(1020) null,description varchar2(4000) null,extraSettings clob null,version varchar2(300) null,size_ number(30,0),readCount number(30,0));
create table DLFileRank (fileRankId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,folderId number(30,0),name varchar2(1020) null);
create table DLFileShortcut (uuid_ varchar2(300) null,fileShortcutId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,folderId number(30,0),toFolderId number(30,0),toName varchar2(1020) null,status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table DLFileVersion (fileVersionId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,folderId number(30,0),name varchar2(1020) null,extension varchar2(300) null,title varchar2(300) null,description varchar2(4000) null,changeLog varchar2(300) null,extraSettings varchar2(300) null,version varchar2(300) null,size_ number(30,0),status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table DLFolder (uuid_ varchar2(300) null,folderId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,parentFolderId number(30,0),name varchar2(400) null,description varchar2(4000) null,lastPostDate timestamp null);
create table EmailAddress (emailAddressId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),address varchar2(300) null,typeId number(30,0),primary_ number(1, 0));
create table ExpandoColumn (columnId number(30,0) not null primary key,companyId number(30,0),tableId number(30,0),name varchar2(300) null,type_ number(30,0),defaultData varchar2(4000) null,typeSettings clob null);
create table ExpandoRow (rowId_ number(30,0) not null primary key,companyId number(30,0),tableId number(30,0),classPK number(30,0));
create table ExpandoTable (tableId number(30,0) not null primary key,companyId number(30,0),classNameId number(30,0),name varchar2(300) null);
create table ExpandoValue (valueId number(30,0) not null primary key,companyId number(30,0),tableId number(30,0),columnId number(30,0),rowId_ number(30,0),classNameId number(30,0),classPK number(30,0),data_ varchar2(4000) null);
create table Group_ (groupId number(30,0) not null primary key,companyId number(30,0),creatorUserId number(30,0),classNameId number(30,0),classPK number(30,0),parentGroupId number(30,0),liveGroupId number(30,0),name varchar2(300) null,description varchar2(4000) null,type_ number(30,0),typeSettings varchar2(4000) null,friendlyURL varchar2(400) null,active_ number(1, 0));
create table Groups_Orgs (groupId number(30,0) not null,organizationId number(30,0) not null,primary key (groupId, organizationId));
create table Groups_Permissions (groupId number(30,0) not null,permissionId number(30,0) not null,primary key (groupId, permissionId));
create table Groups_Roles (groupId number(30,0) not null,roleId number(30,0) not null,primary key (groupId, roleId));
create table Groups_UserGroups (groupId number(30,0) not null,userGroupId number(30,0) not null,primary key (groupId, userGroupId));
create table IGFolder (uuid_ varchar2(300) null,folderId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,modifiedDate timestamp null,parentFolderId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table IGImage (uuid_ varchar2(300) null,imageId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,modifiedDate timestamp null,folderId number(30,0),name varchar2(300) null,description varchar2(4000) null,smallImageId number(30,0),largeImageId number(30,0),custom1ImageId number(30,0),custom2ImageId number(30,0));
create table Image (imageId number(30,0) not null primary key,modifiedDate timestamp null,text_ clob null,type_ varchar2(300) null,height number(30,0),width number(30,0),size_ number(30,0));
create table JournalArticle (uuid_ varchar2(300) null,id_ number(30,0) not null primary key,resourcePrimKey number(30,0),groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,articleId varchar2(300) null,version number(30,20),title varchar2(1200) null,urlTitle varchar2(600) null,description varchar2(4000) null,content clob null,type_ varchar2(300) null,structureId varchar2(300) null,templateId varchar2(300) null,displayDate timestamp null,expirationDate timestamp null,reviewDate timestamp null,indexable number(1, 0),smallImage number(1, 0),smallImageId number(30,0),smallImageURL varchar2(4000) null,status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table JournalArticleImage (articleImageId number(30,0) not null primary key,groupId number(30,0),articleId varchar2(300) null,version number(30,20),elInstanceId varchar2(300) null,elName varchar2(300) null,languageId varchar2(300) null,tempImage number(1, 0));
create table JournalArticleResource (uuid_ varchar2(300) null,resourcePrimKey number(30,0) not null primary key,groupId number(30,0),articleId varchar2(300) null);
create table JournalContentSearch (contentSearchId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),privateLayout number(1, 0),layoutId number(30,0),portletId varchar2(800) null,articleId varchar2(300) null);
create table JournalFeed (uuid_ varchar2(300) null,id_ number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,feedId varchar2(300) null,name varchar2(300) null,description varchar2(4000) null,type_ varchar2(300) null,structureId varchar2(300) null,templateId varchar2(300) null,rendererTemplateId varchar2(300) null,delta number(30,0),orderByCol varchar2(300) null,orderByType varchar2(300) null,targetLayoutFriendlyUrl varchar2(1020) null,targetPortletId varchar2(300) null,contentField varchar2(300) null,feedType varchar2(300) null,feedVersion number(30,20));
create table JournalStructure (uuid_ varchar2(300) null,id_ number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,structureId varchar2(300) null,parentStructureId varchar2(300) null,name varchar2(300) null,description varchar2(4000) null,xsd clob null);
create table JournalTemplate (uuid_ varchar2(300) null,id_ number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,templateId varchar2(300) null,structureId varchar2(300) null,name varchar2(300) null,description varchar2(4000) null,xsl clob null,langType varchar2(300) null,cacheable number(1, 0),smallImage number(1, 0),smallImageId number(30,0),smallImageURL varchar2(4000) null);
create table Layout (uuid_ varchar2(300) null,plid number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),privateLayout number(1, 0),layoutId number(30,0),parentLayoutId number(30,0),name varchar2(4000) null,title varchar2(4000) null,description varchar2(4000) null,type_ varchar2(300) null,typeSettings clob null,hidden_ number(1, 0),friendlyURL varchar2(1020) null,iconImage number(1, 0),iconImageId number(30,0),themeId varchar2(300) null,colorSchemeId varchar2(300) null,wapThemeId varchar2(300) null,wapColorSchemeId varchar2(300) null,css varchar2(4000) null,priority number(30,0),layoutPrototypeId number(30,0),dlFolderId number(30,0));
create table LayoutPrototype (layoutPrototypeId number(30,0) not null primary key,companyId number(30,0),name varchar2(4000) null,description varchar2(4000) null,settings_ varchar2(4000) null,active_ number(1, 0));
create table LayoutSet (layoutSetId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),privateLayout number(1, 0),logo number(1, 0),logoId number(30,0),themeId varchar2(300) null,colorSchemeId varchar2(300) null,wapThemeId varchar2(300) null,wapColorSchemeId varchar2(300) null,css varchar2(4000) null,pageCount number(30,0),virtualHost varchar2(300) null,settings_ varchar2(4000) null,layoutSetPrototypeId number(30,0));
create table LayoutSetPrototype (layoutSetPrototypeId number(30,0) not null primary key,companyId number(30,0),name varchar2(4000) null,description varchar2(4000) null,settings_ varchar2(4000) null,active_ number(1, 0));
create table ListType (listTypeId number(30,0) not null primary key,name varchar2(300) null,type_ varchar2(300) null);
create table Lock_ (uuid_ varchar2(300) null,lockId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,className varchar2(300) null,key_ varchar2(800) null,owner varchar2(300) null,inheritable number(1, 0),expirationDate timestamp null);
create table MBBan (banId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,banUserId number(30,0));
create table MBCategory (uuid_ varchar2(300) null,categoryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,parentCategoryId number(30,0),name varchar2(300) null,description varchar2(4000) null,threadCount number(30,0),messageCount number(30,0),lastPostDate timestamp null);
create table MBDiscussion (discussionId number(30,0) not null primary key,classNameId number(30,0),classPK number(30,0),threadId number(30,0));
create table MBMailingList (uuid_ varchar2(300) null,mailingListId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,categoryId number(30,0),emailAddress varchar2(300) null,inProtocol varchar2(300) null,inServerName varchar2(300) null,inServerPort number(30,0),inUseSSL number(1, 0),inUserName varchar2(300) null,inPassword varchar2(300) null,inReadInterval number(30,0),outEmailAddress varchar2(300) null,outCustom number(1, 0),outServerName varchar2(300) null,outServerPort number(30,0),outUseSSL number(1, 0),outUserName varchar2(300) null,outPassword varchar2(300) null,active_ number(1, 0));
create table MBMessage (uuid_ varchar2(300) null,messageId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),categoryId number(30,0),threadId number(30,0),rootMessageId number(30,0),parentMessageId number(30,0),subject varchar2(300) null,body clob null,attachments number(1, 0),anonymous number(1, 0),priority number(30,20),allowPingbacks number(1, 0),status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table MBMessageFlag (messageFlagId number(30,0) not null primary key,userId number(30,0),modifiedDate timestamp null,threadId number(30,0),messageId number(30,0),flag number(30,0));
create table MBStatsUser (statsUserId number(30,0) not null primary key,groupId number(30,0),userId number(30,0),messageCount number(30,0),lastPostDate timestamp null);
create table MBThread (threadId number(30,0) not null primary key,groupId number(30,0),categoryId number(30,0),rootMessageId number(30,0),messageCount number(30,0),viewCount number(30,0),lastPostByUserId number(30,0),lastPostDate timestamp null,priority number(30,20),status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table MembershipRequest (membershipRequestId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),createDate timestamp null,groupId number(30,0),comments varchar2(4000) null,replyComments varchar2(4000) null,replyDate timestamp null,replierUserId number(30,0),statusId number(30,0));
create table Organization_ (organizationId number(30,0) not null primary key,companyId number(30,0),parentOrganizationId number(30,0),leftOrganizationId number(30,0),rightOrganizationId number(30,0),name varchar2(400) null,type_ varchar2(300) null,recursable number(1, 0),regionId number(30,0),countryId number(30,0),statusId number(30,0),comments varchar2(4000) null);
create table OrgGroupPermission (organizationId number(30,0) not null,groupId number(30,0) not null,permissionId number(30,0) not null,primary key (organizationId, groupId, permissionId));
create table OrgGroupRole (organizationId number(30,0) not null,groupId number(30,0) not null,roleId number(30,0) not null,primary key (organizationId, groupId, roleId));
create table OrgLabor (orgLaborId number(30,0) not null primary key,organizationId number(30,0),typeId number(30,0),sunOpen number(30,0),sunClose number(30,0),monOpen number(30,0),monClose number(30,0),tueOpen number(30,0),tueClose number(30,0),wedOpen number(30,0),wedClose number(30,0),thuOpen number(30,0),thuClose number(30,0),friOpen number(30,0),friClose number(30,0),satOpen number(30,0),satClose number(30,0));
create table PasswordPolicy (passwordPolicyId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,defaultPolicy number(1, 0),name varchar2(300) null,description varchar2(4000) null,changeable number(1, 0),changeRequired number(1, 0),minAge number(30,0),checkSyntax number(1, 0),allowDictionaryWords number(1, 0),minAlphanumeric number(30,0),minLength number(30,0),minLowerCase number(30,0),minNumbers number(30,0),minSymbols number(30,0),minUpperCase number(30,0),history number(1, 0),historyCount number(30,0),expireable number(1, 0),maxAge number(30,0),warningTime number(30,0),graceLimit number(30,0),lockout number(1, 0),maxFailure number(30,0),lockoutDuration number(30,0),requireUnlock number(1, 0),resetFailureCount number(30,0),resetTicketMaxAge number(30,0));
create table PasswordPolicyRel (passwordPolicyRelId number(30,0) not null primary key,passwordPolicyId number(30,0),classNameId number(30,0),classPK number(30,0));
create table PasswordTracker (passwordTrackerId number(30,0) not null primary key,userId number(30,0),createDate timestamp null,password_ varchar2(300) null);
create table Permission_ (permissionId number(30,0) not null primary key,companyId number(30,0),actionId varchar2(300) null,resourceId number(30,0));
create table Phone (phoneId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),number_ varchar2(300) null,extension varchar2(300) null,typeId number(30,0),primary_ number(1, 0));
create table PluginSetting (pluginSettingId number(30,0) not null primary key,companyId number(30,0),pluginId varchar2(300) null,pluginType varchar2(300) null,roles varchar2(4000) null,active_ number(1, 0));
create table PollsChoice (uuid_ varchar2(300) null,choiceId number(30,0) not null primary key,questionId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table PollsQuestion (uuid_ varchar2(300) null,questionId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,title varchar2(4000) null,description varchar2(4000) null,expirationDate timestamp null,lastVoteDate timestamp null);
create table PollsVote (voteId number(30,0) not null primary key,userId number(30,0),questionId number(30,0),choiceId number(30,0),voteDate timestamp null);
create table Portlet (id_ number(30,0) not null primary key,companyId number(30,0),portletId varchar2(800) null,roles varchar2(4000) null,active_ number(1, 0));
create table PortletItem (portletItemId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,portletId varchar2(300) null,classNameId number(30,0));
create table PortletPreferences (portletPreferencesId number(30,0) not null primary key,ownerId number(30,0),ownerType number(30,0),plid number(30,0),portletId varchar2(800) null,preferences clob null);
create table RatingsEntry (entryId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),score number(30,20));
create table RatingsStats (statsId number(30,0) not null primary key,classNameId number(30,0),classPK number(30,0),totalEntries number(30,0),totalScore number(30,20),averageScore number(30,20));
create table Region (regionId number(30,0) not null primary key,countryId number(30,0),regionCode varchar2(300) null,name varchar2(300) null,active_ number(1, 0));
create table Release_ (releaseId number(30,0) not null primary key,createDate timestamp null,modifiedDate timestamp null,servletContextName varchar2(300) null,buildNumber number(30,0),buildDate timestamp null,verified number(1, 0),testString varchar2(4000) null);
create table Resource_ (resourceId number(30,0) not null primary key,codeId number(30,0),primKey varchar2(1020) null);
create table ResourceAction (resourceActionId number(30,0) not null primary key,name varchar2(1020) null,actionId varchar2(300) null,bitwiseValue number(30,0));
create table ResourceCode (codeId number(30,0) not null primary key,companyId number(30,0),name varchar2(1020) null,scope number(30,0));
create table ResourcePermission (resourcePermissionId number(30,0) not null primary key,companyId number(30,0),name varchar2(1020) null,scope number(30,0),primKey varchar2(1020) null,roleId number(30,0),actionIds number(30,0));
create table Role_ (roleId number(30,0) not null primary key,companyId number(30,0),classNameId number(30,0),classPK number(30,0),name varchar2(300) null,title varchar2(4000) null,description varchar2(4000) null,type_ number(30,0),subtype varchar2(300) null);
create table Roles_Permissions (roleId number(30,0) not null,permissionId number(30,0) not null,primary key (roleId, permissionId));
create table SCFrameworkVersi_SCProductVers (frameworkVersionId number(30,0) not null,productVersionId number(30,0) not null,primary key (frameworkVersionId, productVersionId));
create table SCFrameworkVersion (frameworkVersionId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,url varchar2(4000) null,active_ number(1, 0),priority number(30,0));
create table SCLicense (licenseId number(30,0) not null primary key,name varchar2(300) null,url varchar2(4000) null,openSource number(1, 0),active_ number(1, 0),recommended number(1, 0));
create table SCLicenses_SCProductEntries (licenseId number(30,0) not null,productEntryId number(30,0) not null,primary key (licenseId, productEntryId));
create table SCProductEntry (productEntryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,type_ varchar2(300) null,tags varchar2(1020) null,shortDescription varchar2(4000) null,longDescription varchar2(4000) null,pageURL varchar2(4000) null,author varchar2(300) null,repoGroupId varchar2(300) null,repoArtifactId varchar2(300) null);
create table SCProductScreenshot (productScreenshotId number(30,0) not null primary key,companyId number(30,0),groupId number(30,0),productEntryId number(30,0),thumbnailId number(30,0),fullImageId number(30,0),priority number(30,0));
create table SCProductVersion (productVersionId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,productEntryId number(30,0),version varchar2(300) null,changeLog varchar2(4000) null,downloadPageURL varchar2(4000) null,directDownloadURL varchar2(4000) null,repoStoreArtifact number(1, 0));
create table ServiceComponent (serviceComponentId number(30,0) not null primary key,buildNamespace varchar2(300) null,buildNumber number(30,0),buildDate number(30,0),data_ clob null);
create table Shard (shardId number(30,0) not null primary key,classNameId number(30,0),classPK number(30,0),name varchar2(300) null);
create table ShoppingCart (cartId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,itemIds varchar2(4000) null,couponCodes varchar2(300) null,altShipping number(30,0),insure number(1, 0));
create table ShoppingCategory (categoryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,parentCategoryId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table ShoppingCoupon (couponId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,code_ varchar2(300) null,name varchar2(300) null,description varchar2(4000) null,startDate timestamp null,endDate timestamp null,active_ number(1, 0),limitCategories varchar2(4000) null,limitSkus varchar2(4000) null,minOrder number(30,20),discount number(30,20),discountType varchar2(300) null);
create table ShoppingItem (itemId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,categoryId number(30,0),sku varchar2(300) null,name varchar2(800) null,description varchar2(4000) null,properties varchar2(4000) null,fields_ number(1, 0),fieldsQuantities varchar2(4000) null,minQuantity number(30,0),maxQuantity number(30,0),price number(30,20),discount number(30,20),taxable number(1, 0),shipping number(30,20),useShippingFormula number(1, 0),requiresShipping number(1, 0),stockQuantity number(30,0),featured_ number(1, 0),sale_ number(1, 0),smallImage number(1, 0),smallImageId number(30,0),smallImageURL varchar2(4000) null,mediumImage number(1, 0),mediumImageId number(30,0),mediumImageURL varchar2(4000) null,largeImage number(1, 0),largeImageId number(30,0),largeImageURL varchar2(4000) null);
create table ShoppingItemField (itemFieldId number(30,0) not null primary key,itemId number(30,0),name varchar2(300) null,values_ varchar2(4000) null,description varchar2(4000) null);
create table ShoppingItemPrice (itemPriceId number(30,0) not null primary key,itemId number(30,0),minQuantity number(30,0),maxQuantity number(30,0),price number(30,20),discount number(30,20),taxable number(1, 0),shipping number(30,20),useShippingFormula number(1, 0),status number(30,0));
create table ShoppingOrder (orderId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,number_ varchar2(300) null,tax number(30,20),shipping number(30,20),altShipping varchar2(300) null,requiresShipping number(1, 0),insure number(1, 0),insurance number(30,20),couponCodes varchar2(300) null,couponDiscount number(30,20),billingFirstName varchar2(300) null,billingLastName varchar2(300) null,billingEmailAddress varchar2(300) null,billingCompany varchar2(300) null,billingStreet varchar2(300) null,billingCity varchar2(300) null,billingState varchar2(300) null,billingZip varchar2(300) null,billingCountry varchar2(300) null,billingPhone varchar2(300) null,shipToBilling number(1, 0),shippingFirstName varchar2(300) null,shippingLastName varchar2(300) null,shippingEmailAddress varchar2(300) null,shippingCompany varchar2(300) null,shippingStreet varchar2(300) null,shippingCity varchar2(300) null,shippingState varchar2(300) null,shippingZip varchar2(300) null,shippingCountry varchar2(300) null,shippingPhone varchar2(300) null,ccName varchar2(300) null,ccType varchar2(300) null,ccNumber varchar2(300) null,ccExpMonth number(30,0),ccExpYear number(30,0),ccVerNumber varchar2(300) null,comments varchar2(4000) null,ppTxnId varchar2(300) null,ppPaymentStatus varchar2(300) null,ppPaymentGross number(30,20),ppReceiverEmail varchar2(300) null,ppPayerEmail varchar2(300) null,sendOrderEmail number(1, 0),sendShippingEmail number(1, 0));
create table ShoppingOrderItem (orderItemId number(30,0) not null primary key,orderId number(30,0),itemId varchar2(300) null,sku varchar2(300) null,name varchar2(800) null,description varchar2(4000) null,properties varchar2(4000) null,price number(30,20),quantity number(30,0),shippedDate timestamp null);
create table SocialActivity (activityId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate number(30,0),mirrorActivityId number(30,0),classNameId number(30,0),classPK number(30,0),type_ number(30,0),extraData varchar2(4000) null,receiverUserId number(30,0));
create table SocialEquityAssetEntry (equityAssetEntryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),assetEntryId number(30,0),informationK number(30,20),informationB number(30,20));
create table SocialEquityGroupSetting (equityGroupSettingId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),classNameId number(30,0),type_ number(30,0),enabled number(1, 0));
create table SocialEquityHistory (equityHistoryId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate timestamp null,personalEquity number(30,0));
create table SocialEquityLog (equityLogId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),assetEntryId number(30,0),actionId varchar2(300) null,actionDate number(30,0),active_ number(1, 0),expiration number(30,0),type_ number(30,0),value number(30,0));
create table SocialEquitySetting (equitySettingId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),classNameId number(30,0),actionId varchar2(300) null,dailyLimit number(30,0),lifespan number(30,0),type_ number(30,0),uniqueEntry number(1, 0),value number(30,0));
create table SocialEquityUser (equityUserId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),contributionK number(30,20),contributionB number(30,20),participationK number(30,20),participationB number(30,20),rank number(30,0));
create table SocialRelation (uuid_ varchar2(300) null,relationId number(30,0) not null primary key,companyId number(30,0),createDate number(30,0),userId1 number(30,0),userId2 number(30,0),type_ number(30,0));
create table SocialRequest (uuid_ varchar2(300) null,requestId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),createDate number(30,0),modifiedDate number(30,0),classNameId number(30,0),classPK number(30,0),type_ number(30,0),extraData varchar2(4000) null,receiverUserId number(30,0),status number(30,0));
create table Subscription (subscriptionId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),frequency varchar2(300) null);
create table TasksProposal (proposalId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK varchar2(300) null,name varchar2(300) null,description varchar2(4000) null,publishDate timestamp null,dueDate timestamp null);
create table TasksReview (reviewId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,proposalId number(30,0),assignedByUserId number(30,0),assignedByUserName varchar2(300) null,stage number(30,0),completed number(1, 0),rejected number(1, 0));
create table Team (teamId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,groupId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table Ticket (ticketId number(30,0) not null primary key,companyId number(30,0),createDate timestamp null,classNameId number(30,0),classPK number(30,0),key_ varchar2(300) null,expirationDate timestamp null);
create table User_ (uuid_ varchar2(300) null,userId number(30,0) not null primary key,companyId number(30,0),createDate timestamp null,modifiedDate timestamp null,defaultUser number(1, 0),contactId number(30,0),password_ varchar2(300) null,passwordEncrypted number(1, 0),passwordReset number(1, 0),passwordModifiedDate timestamp null,digest varchar2(1020) null,reminderQueryQuestion varchar2(300) null,reminderQueryAnswer varchar2(300) null,graceLoginCount number(30,0),screenName varchar2(300) null,emailAddress varchar2(300) null,facebookId number(30,0),openId varchar2(4000) null,portraitId number(30,0),languageId varchar2(300) null,timeZoneId varchar2(300) null,greeting varchar2(1020) null,comments varchar2(4000) null,firstName varchar2(300) null,middleName varchar2(300) null,lastName varchar2(300) null,jobTitle varchar2(400) null,loginDate timestamp null,loginIP varchar2(300) null,lastLoginDate timestamp null,lastLoginIP varchar2(300) null,lastFailedLoginDate timestamp null,failedLoginAttempts number(30,0),lockout number(1, 0),lockoutDate timestamp null,agreedToTermsOfUse number(1, 0),active_ number(1, 0));
create table UserGroup (userGroupId number(30,0) not null primary key,companyId number(30,0),parentUserGroupId number(30,0),name varchar2(300) null,description varchar2(4000) null);
create table UserGroupGroupRole (userGroupId number(30,0) not null,groupId number(30,0) not null,roleId number(30,0) not null,primary key (userGroupId, groupId, roleId));
create table UserGroupRole (userId number(30,0) not null,groupId number(30,0) not null,roleId number(30,0) not null,primary key (userId, groupId, roleId));
create table UserIdMapper (userIdMapperId number(30,0) not null primary key,userId number(30,0),type_ varchar2(300) null,description varchar2(300) null,externalUserId varchar2(300) null);
create table Users_Groups (userId number(30,0) not null,groupId number(30,0) not null,primary key (userId, groupId));
create table Users_Orgs (userId number(30,0) not null,organizationId number(30,0) not null,primary key (userId, organizationId));
create table Users_Permissions (userId number(30,0) not null,permissionId number(30,0) not null,primary key (userId, permissionId));
create table Users_Roles (userId number(30,0) not null,roleId number(30,0) not null,primary key (userId, roleId));
create table Users_Teams (userId number(30,0) not null,teamId number(30,0) not null,primary key (userId, teamId));
create table Users_UserGroups (userGroupId number(30,0) not null,userId number(30,0) not null,primary key (userGroupId, userId));
create table UserTracker (userTrackerId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),modifiedDate timestamp null,sessionId varchar2(800) null,remoteAddr varchar2(300) null,remoteHost varchar2(300) null,userAgent varchar2(800) null);
create table UserTrackerPath (userTrackerPathId number(30,0) not null primary key,userTrackerId number(30,0),path_ varchar2(4000) null,pathDate timestamp null);
create table Vocabulary (vocabularyId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,description varchar2(300) null,folksonomy number(1, 0));
create table WebDAVProps (webDavPropsId number(30,0) not null primary key,companyId number(30,0),createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),props clob null);
create table Website (websiteId number(30,0) not null primary key,companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),url varchar2(4000) null,typeId number(30,0),primary_ number(1, 0));
create table WikiNode (uuid_ varchar2(300) null,nodeId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,name varchar2(300) null,description varchar2(4000) null,lastPostDate timestamp null);
create table WikiPage (uuid_ varchar2(300) null,pageId number(30,0) not null primary key,resourcePrimKey number(30,0),groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,nodeId number(30,0),title varchar2(1020) null,version number(30,20),minorEdit number(1, 0),content clob null,summary varchar2(4000) null,format varchar2(300) null,head number(1, 0),parentTitle varchar2(1020) null,redirectTitle varchar2(1020) null,status number(30,0),statusByUserId number(30,0),statusByUserName varchar2(300) null,statusDate timestamp null);
create table WikiPageResource (uuid_ varchar2(300) null,resourcePrimKey number(30,0) not null primary key,nodeId number(30,0),title varchar2(1020) null);
create table WorkflowDefinitionLink (workflowDefinitionLinkId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),workflowDefinitionName varchar2(300) null,workflowDefinitionVersion number(30,0));
create table WorkflowInstanceLink (workflowInstanceLinkId number(30,0) not null primary key,groupId number(30,0),companyId number(30,0),userId number(30,0),userName varchar2(300) null,createDate timestamp null,modifiedDate timestamp null,classNameId number(30,0),classPK number(30,0),workflowInstanceId number(30,0));
insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (1, 'Canada', 'CA', 'CAN', '124', '001', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (2, 'China', 'CN', 'CHN', '156', '086', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (3, 'France', 'FR', 'FRA', '250', '033', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (4, 'Germany', 'DE', 'DEU', '276', '049', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (5, 'Hong Kong', 'HK', 'HKG', '344', '852', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (6, 'Hungary', 'HU', 'HUN', '348', '036', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (7, 'Israel', 'IL', 'ISR', '376', '972', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (8, 'Italy', 'IT', 'ITA', '380', '039', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (9, 'Japan', 'JP', 'JPN', '392', '081', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (10, 'South Korea', 'KR', 'KOR', '410', '082', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (11, 'Netherlands', 'NL', 'NLD', '528', '031', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (12, 'Portugal', 'PT', 'PRT', '620', '351', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (13, 'Russia', 'RU', 'RUS', '643', '007', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (14, 'Singapore', 'SG', 'SGP', '702', '065', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (15, 'Spain', 'ES', 'ESP', '724', '034', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (16, 'Turkey', 'TR', 'TUR', '792', '090', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (17, 'Vietnam', 'VM', 'VNM', '704', '084', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (18, 'United Kingdom', 'GB', 'GBR', '826', '044', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (19, 'United States', 'US', 'USA', '840', '001', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (20, 'Afghanistan', 'AF', 'AFG', '4', '093', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (21, 'Albania', 'AL', 'ALB', '8', '355', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (22, 'Algeria', 'DZ', 'DZA', '12', '213', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (23, 'American Samoa', 'AS', 'ASM', '16', '684', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (24, 'Andorra', 'AD', 'AND', '20', '376', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (25, 'Angola', 'AO', 'AGO', '24', '244', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (26, 'Anguilla', 'AI', 'AIA', '660', '264', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (27, 'Antarctica', 'AQ', 'ATA', '10', '672', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (28, 'Antigua', 'AG', 'ATG', '28', '268', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (29, 'Argentina', 'AR', 'ARG', '32', '054', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (30, 'Armenia', 'AM', 'ARM', '51', '374', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (31, 'Aruba', 'AW', 'ABW', '533', '297', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (32, 'Australia', 'AU', 'AUS', '36', '061', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (33, 'Austria', 'AT', 'AUT', '40', '043', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (34, 'Azerbaijan', 'AZ', 'AZE', '31', '994', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (35, 'Bahamas', 'BS', 'BHS', '44', '242', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (36, 'Bahrain', 'BH', 'BHR', '48', '973', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (37, 'Bangladesh', 'BD', 'BGD', '50', '880', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (38, 'Barbados', 'BB', 'BRB', '52', '246', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (39, 'Belarus', 'BY', 'BLR', '112', '375', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (40, 'Belgium', 'BE', 'BEL', '56', '032', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (41, 'Belize', 'BZ', 'BLZ', '84', '501', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (42, 'Benin', 'BJ', 'BEN', '204', '229', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (43, 'Bermuda', 'BM', 'BMU', '60', '441', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (44, 'Bhutan', 'BT', 'BTN', '64', '975', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (45, 'Bolivia', 'BO', 'BOL', '68', '591', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (46, 'Bosnia-Herzegovina', 'BA', 'BIH', '70', '387', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (47, 'Botswana', 'BW', 'BWA', '72', '267', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (48, 'Brazil', 'BR', 'BRA', '76', '055', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (49, 'British Virgin Islands', 'VG', 'VGB', '92', '284', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (50, 'Brunei', 'BN', 'BRN', '96', '673', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (51, 'Bulgaria', 'BG', 'BGR', '100', '359', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (52, 'Burkina Faso', 'BF', 'BFA', '854', '226', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (53, 'Burma (Myanmar)', 'MM', 'MMR', '104', '095', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (54, 'Burundi', 'BI', 'BDI', '108', '257', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (55, 'Cambodia', 'KH', 'KHM', '116', '855', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (56, 'Cameroon', 'CM', 'CMR', '120', '237', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (57, 'Cape Verde Island', 'CV', 'CPV', '132', '238', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (58, 'Cayman Islands', 'KY', 'CYM', '136', '345', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (59, 'Central African Republic', 'CF', 'CAF', '140', '236', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (60, 'Chad', 'TD', 'TCD', '148', '235', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (61, 'Chile', 'CL', 'CHL', '152', '056', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (62, 'Christmas Island', 'CX', 'CXR', '162', '061', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (63, 'Cocos Islands', 'CC', 'CCK', '166', '061', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (64, 'Colombia', 'CO', 'COL', '170', '057', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (65, 'Comoros', 'KM', 'COM', '174', '269', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (66, 'Republic of Congo', 'CD', 'COD', '180', '242', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (67, 'Democratic Republic of Congo', 'CG', 'COG', '178', '243', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (68, 'Cook Islands', 'CK', 'COK', '184', '682', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (69, 'Costa Rica', 'CR', 'CRI', '188', '506', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (70, 'Croatia', 'HR', 'HRV', '191', '385', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (71, 'Cuba', 'CU', 'CUB', '192', '053', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (72, 'Cyprus', 'CY', 'CYP', '196', '357', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (73, 'Czech Republic', 'CZ', 'CZE', '203', '420', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (74, 'Denmark', 'DK', 'DNK', '208', '045', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (75, 'Djibouti', 'DJ', 'DJI', '262', '253', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (76, 'Dominica', 'DM', 'DMA', '212', '767', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (77, 'Dominican Republic', 'DO', 'DOM', '214', '809', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (78, 'Ecuador', 'EC', 'ECU', '218', '593', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (79, 'Egypt', 'EG', 'EGY', '818', '020', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (80, 'El Salvador', 'SV', 'SLV', '222', '503', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (81, 'Equatorial Guinea', 'GQ', 'GNQ', '226', '240', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (82, 'Eritrea', 'ER', 'ERI', '232', '291', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (83, 'Estonia', 'EE', 'EST', '233', '372', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (84, 'Ethiopia', 'ET', 'ETH', '231', '251', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (85, 'Faeroe Islands', 'FO', 'FRO', '234', '298', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (86, 'Falkland Islands', 'FK', 'FLK', '238', '500', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (87, 'Fiji Islands', 'FJ', 'FJI', '242', '679', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (88, 'Finland', 'FI', 'FIN', '246', '358', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (89, 'French Guiana', 'GF', 'GUF', '254', '594', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (90, 'French Polynesia', 'PF', 'PYF', '258', '689', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (91, 'Gabon', 'GA', 'GAB', '266', '241', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (92, 'Gambia', 'GM', 'GMB', '270', '220', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (93, 'Georgia', 'GE', 'GEO', '268', '995', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (94, 'Ghana', 'GH', 'GHA', '288', '233', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (95, 'Gibraltar', 'GI', 'GIB', '292', '350', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (96, 'Greece', 'GR', 'GRC', '300', '030', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (97, 'Greenland', 'GL', 'GRL', '304', '299', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (98, 'Grenada', 'GD', 'GRD', '308', '473', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (99, 'Guadeloupe', 'GP', 'GLP', '312', '590', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (100, 'Guam', 'GU', 'GUM', '316', '671', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (101, 'Guatemala', 'GT', 'GTM', '320', '502', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (102, 'Guinea', 'GN', 'GIN', '324', '224', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (103, 'Guinea-Bissau', 'GW', 'GNB', '624', '245', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (104, 'Guyana', 'GY', 'GUY', '328', '592', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (105, 'Haiti', 'HT', 'HTI', '332', '509', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (106, 'Honduras', 'HN', 'HND', '340', '504', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (107, 'Iceland', 'IS', 'ISL', '352', '354', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (108, 'India', 'IN', 'IND', '356', '091', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (109, 'Indonesia', 'ID', 'IDN', '360', '062', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (110, 'Iran', 'IR', 'IRN', '364', '098', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (111, 'Iraq', 'IQ', 'IRQ', '368', '964', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (112, 'Ireland', 'IE', 'IRL', '372', '353', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (113, 'Ivory Coast', 'CI', 'CIV', '384', '225', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (114, 'Jamaica', 'JM', 'JAM', '388', '876', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (115, 'Jordan', 'JO', 'JOR', '400', '962', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (116, 'Kazakhstan', 'KZ', 'KAZ', '398', '007', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (117, 'Kenya', 'KE', 'KEN', '404', '254', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (118, 'Kiribati', 'KI', 'KIR', '408', '686', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (119, 'Kuwait', 'KW', 'KWT', '414', '965', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (120, 'North Korea', 'KP', 'PRK', '408', '850', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (121, 'Kyrgyzstan', 'KG', 'KGZ', '471', '996', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (122, 'Laos', 'LA', 'LAO', '418', '856', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (123, 'Latvia', 'LV', 'LVA', '428', '371', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (124, 'Lebanon', 'LB', 'LBN', '422', '961', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (125, 'Lesotho', 'LS', 'LSO', '426', '266', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (126, 'Liberia', 'LR', 'LBR', '430', '231', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (127, 'Libya', 'LY', 'LBY', '434', '218', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (128, 'Liechtenstein', 'LI', 'LIE', '438', '423', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (129, 'Lithuania', 'LT', 'LTU', '440', '370', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (130, 'Luxembourg', 'LU', 'LUX', '442', '352', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (131, 'Macau', 'MO', 'MAC', '446', '853', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (132, 'Macedonia', 'MK', 'MKD', '807', '389', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (133, 'Madagascar', 'MG', 'MDG', '450', '261', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (134, 'Malawi', 'MW', 'MWI', '454', '265', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (135, 'Malaysia', 'MY', 'MYS', '458', '060', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (136, 'Maldives', 'MV', 'MDV', '462', '960', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (137, 'Mali', 'ML', 'MLI', '466', '223', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (138, 'Malta', 'MT', 'MLT', '470', '356', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (139, 'Marshall Islands', 'MH', 'MHL', '584', '692', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (140, 'Martinique', 'MQ', 'MTQ', '474', '596', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (141, 'Mauritania', 'MR', 'MRT', '478', '222', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (142, 'Mauritius', 'MU', 'MUS', '480', '230', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (143, 'Mayotte Island', 'YT', 'MYT', '175', '269', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (144, 'Mexico', 'MX', 'MEX', '484', '052', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (145, 'Micronesia', 'FM', 'FSM', '583', '691', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (146, 'Moldova', 'MD', 'MDA', '498', '373', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (147, 'Monaco', 'MC', 'MCO', '492', '377', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (148, 'Mongolia', 'MN', 'MNG', '496', '976', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (149, 'Montenegro', 'ME', 'MNE', '499', '382', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (150, 'Montserrat', 'MS', 'MSR', '500', '664', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (151, 'Morocco', 'MA', 'MAR', '504', '212', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (152, 'Mozambique', 'MZ', 'MOZ', '508', '258', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (153, 'Namibia', 'NA', 'NAM', '516', '264', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (154, 'Nauru', 'NR', 'NRU', '520', '674', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (155, 'Nepal', 'NP', 'NPL', '524', '977', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (156, 'Netherlands Antilles', 'AN', 'ANT', '530', '599', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (157, 'New Caledonia', 'NC', 'NCL', '540', '687', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (158, 'New Zealand', 'NZ', 'NZL', '554', '064', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (159, 'Nicaragua', 'NI', 'NIC', '558', '505', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (160, 'Niger', 'NE', 'NER', '562', '227', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (161, 'Nigeria', 'NG', 'NGA', '566', '234', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (162, 'Niue', 'NU', 'NIU', '570', '683', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (163, 'Norfolk Island', 'NF', 'NFK', '574', '672', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (164, 'Norway', 'NO', 'NOR', '578', '047', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (165, 'Oman', 'OM', 'OMN', '512', '968', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (166, 'Pakistan', 'PK', 'PAK', '586', '092', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (167, 'Palau', 'PW', 'PLW', '585', '680', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (168, 'Palestine', 'PS', 'PSE', '275', '970', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (169, 'Panama', 'PA', 'PAN', '591', '507', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (170, 'Papua New Guinea', 'PG', 'PNG', '598', '675', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (171, 'Paraguay', 'PY', 'PRY', '600', '595', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (172, 'Peru', 'PE', 'PER', '604', '051', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (173, 'Philippines', 'PH', 'PHL', '608', '063', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (174, 'Poland', 'PL', 'POL', '616', '048', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (175, 'Puerto Rico', 'PR', 'PRI', '630', '787', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (176, 'Qatar', 'QA', 'QAT', '634', '974', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (177, 'Reunion Island', 'RE', 'REU', '638', '262', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (178, 'Romania', 'RO', 'ROU', '642', '040', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (179, 'Rwanda', 'RW', 'RWA', '646', '250', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (180, 'St. Helena', 'SH', 'SHN', '654', '290', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (181, 'St. Kitts', 'KN', 'KNA', '659', '869', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (182, 'St. Lucia', 'LC', 'LCA', '662', '758', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (183, 'St. Pierre & Miquelon', 'PM', 'SPM', '666', '508', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (184, 'St. Vincent', 'VC', 'VCT', '670', '784', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (185, 'San Marino', 'SM', 'SMR', '674', '378', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (186, 'Sao Tome & Principe', 'ST', 'STP', '678', '239', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (187, 'Saudi Arabia', 'SA', 'SAU', '682', '966', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (188, 'Senegal', 'SN', 'SEN', '686', '221', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (189, 'Serbia', 'RS', 'SRB', '688', '381', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (190, 'Seychelles', 'SC', 'SYC', '690', '248', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (191, 'Sierra Leone', 'SL', 'SLE', '694', '249', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (192, 'Slovakia', 'SK', 'SVK', '703', '421', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (193, 'Slovenia', 'SI', 'SVN', '705', '386', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (194, 'Solomon Islands', 'SB', 'SLB', '90', '677', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (195, 'Somalia', 'SO', 'SOM', '706', '252', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (196, 'South Africa', 'ZA', 'ZAF', '710', '027', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (197, 'Sri Lanka', 'LK', 'LKA', '144', '094', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (198, 'Sudan', 'SD', 'SDN', '736', '095', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (199, 'Suriname', 'SR', 'SUR', '740', '597', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (200, 'Swaziland', 'SZ', 'SWZ', '748', '268', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (201, 'Sweden', 'SE', 'SWE', '752', '046', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (202, 'Switzerland', 'CH', 'CHE', '756', '041', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (203, 'Syria', 'SY', 'SYR', '760', '963', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (204, 'Taiwan', 'TW', 'TWN', '158', '886', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (205, 'Tajikistan', 'TJ', 'TJK', '762', '992', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (206, 'Tanzania', 'TZ', 'TZA', '834', '255', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (207, 'Thailand', 'TH', 'THA', '764', '066', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (208, 'Togo', 'TG', 'TGO', '768', '228', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (209, 'Tonga', 'TO', 'TON', '776', '676', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (210, 'Trinidad & Tobago', 'TT', 'TTO', '780', '868', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (211, 'Tunisia', 'TN', 'TUN', '788', '216', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (212, 'Turkmenistan', 'TM', 'TKM', '795', '993', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (213, 'Turks & Caicos', 'TC', 'TCA', '796', '649', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (214, 'Tuvalu', 'TV', 'TUV', '798', '688', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (215, 'Uganda', 'UG', 'UGA', '800', '256', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (216, 'Ukraine', 'UA', 'UKR', '804', '380', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (217, 'United Arab Emirates', 'AE', 'ARE', '784', '971', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (218, 'Uruguay', 'UY', 'URY', '858', '598', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (219, 'Uzbekistan', 'UZ', 'UZB', '860', '998', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (220, 'Vanuatu', 'VU', 'VUT', '548', '678', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (221, 'Vatican City', 'VA', 'VAT', '336', '039', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (222, 'Venezuela', 'VE', 'VEN', '862', '058', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (223, 'Wallis & Futuna', 'WF', 'WLF', '876', '681', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (224, 'Western Samoa', 'EH', 'ESH', '732', '685', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (225, 'Yemen', 'YE', 'YEM', '887', '967', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (226, 'Zambia', 'ZM', 'ZMB', '894', '260', 1);insert into Country (countryId, name, a2, a3, number_, idd_, active_) values (227, 'Zimbabwe', 'ZW', 'ZWE', '716', '263', 1);
insert into Region (regionId, countryId, regionCode, name, active_) values (1001, 1, 'AB', 'Alberta', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1002, 1, 'BC', 'British Columbia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1003, 1, 'MB', 'Manitoba', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1004, 1, 'NB', 'New Brunswick', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1005, 1, 'NL', 'Newfoundland and Labrador', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1006, 1, 'NT', 'Northwest Territories', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1007, 1, 'NS', 'Nova Scotia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1008, 1, 'NU', 'Nunavut', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1009, 1, 'ON', 'Ontario', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1010, 1, 'PE', 'Prince Edward Island', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1011, 1, 'QC', 'Quebec', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1012, 1, 'SK', 'Saskatchewan', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (1013, 1, 'YT', 'Yukon', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3001, 3, 'A', 'Alsace', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3002, 3, 'B', 'Aquitaine', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3003, 3, 'C', 'Auvergne', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3004, 3, 'P', 'Basse-Normandie', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3005, 3, 'D', 'Bourgogne', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3006, 3, 'E', 'Bretagne', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3007, 3, 'F', 'Centre', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3008, 3, 'G', 'Champagne-Ardenne', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3009, 3, 'H', 'Corse', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3010, 3, 'GF', 'Guyane', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3011, 3, 'I', 'Franche Comté', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3012, 3, 'GP', 'Guadeloupe', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3013, 3, 'Q', 'Haute-Normandie', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3014, 3, 'J', 'Île-de-France', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3015, 3, 'K', 'Languedoc-Roussillon', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3016, 3, 'L', 'Limousin', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3017, 3, 'M', 'Lorraine', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3018, 3, 'MQ', 'Martinique', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3019, 3, 'N', 'Midi-Pyrénées', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3020, 3, 'O', 'Nord Pas de Calais', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3021, 3, 'R', 'Pays de la Loire', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3022, 3, 'S', 'Picardie', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3023, 3, 'T', 'Poitou-Charentes', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3024, 3, 'U', 'Provence-Alpes-Côte-d''Azur', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3025, 3, 'RE', 'Réunion', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (3026, 3, 'V', 'Rhône-Alpes', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4001, 4, 'BW', 'Baden-Württemberg', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4002, 4, 'BY', 'Bayern', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4003, 4, 'BE', 'Berlin', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4004, 4, 'BR', 'Brandenburg', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4005, 4, 'HB', 'Bremen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4006, 4, 'HH', 'Hamburg', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4007, 4, 'HE', 'Hessen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4008, 4, 'MV', 'Mecklenburg-Vorpommern', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4009, 4, 'NI', 'Niedersachsen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4010, 4, 'NW', 'Nordrhein-Westfalen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4011, 4, 'RP', 'Rheinland-Pfalz', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4012, 4, 'SL', 'Saarland', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4013, 4, 'SN', 'Sachsen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4014, 4, 'ST', 'Sachsen-Anhalt', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4015, 4, 'SH', 'Schleswig-Holstein', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (4016, 4, 'TH', 'Thüringen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8001, 8, 'AG', 'Agrigento', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8002, 8, 'AL', 'Alessandria', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8003, 8, 'AN', 'Ancona', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8004, 8, 'AO', 'Aosta', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8005, 8, 'AR', 'Arezzo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8006, 8, 'AP', 'Ascoli Piceno', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8007, 8, 'AT', 'Asti', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8008, 8, 'AV', 'Avellino', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8009, 8, 'BA', 'Bari', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8010, 8, 'BT', 'Barletta-Andria-Trani', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8011, 8, 'BL', 'Belluno', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8012, 8, 'BN', 'Benevento', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8013, 8, 'BG', 'Bergamo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8014, 8, 'BI', 'Biella', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8015, 8, 'BO', 'Bologna', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8016, 8, 'BZ', 'Bolzano', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8017, 8, 'BS', 'Brescia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8018, 8, 'BR', 'Brindisi', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8019, 8, 'CA', 'Cagliari', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8020, 8, 'CL', 'Caltanissetta', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8021, 8, 'CB', 'Campobasso', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8022, 8, 'CI', 'Carbonia-Iglesias', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8023, 8, 'CE', 'Caserta', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8024, 8, 'CT', 'Catania', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8025, 8, 'CZ', 'Catanzaro', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8026, 8, 'CH', 'Chieti', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8027, 8, 'CO', 'Como', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8028, 8, 'CS', 'Cosenza', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8029, 8, 'CR', 'Cremona', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8030, 8, 'KR', 'Crotone', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8031, 8, 'CN', 'Cuneo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8032, 8, 'EN', 'Enna', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8033, 8, 'FM', 'Fermo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8034, 8, 'FE', 'Ferrara', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8035, 8, 'FI', 'Firenze', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8036, 8, 'FG', 'Foggia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8037, 8, 'FC', 'Forli-Cesena', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8038, 8, 'FR', 'Frosinone', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8039, 8, 'GE', 'Genova', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8040, 8, 'GO', 'Gorizia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8041, 8, 'GR', 'Grosseto', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8042, 8, 'IM', 'Imperia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8043, 8, 'IS', 'Isernia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8044, 8, 'AQ', 'L''Aquila', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8045, 8, 'SP', 'La Spezia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8046, 8, 'LT', 'Latina', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8047, 8, 'LE', 'Lecce', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8048, 8, 'LC', 'Lecco', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8049, 8, 'LI', 'Livorno', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8050, 8, 'LO', 'Lodi', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8051, 8, 'LU', 'Lucca', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8052, 8, 'MC', 'Macerata', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8053, 8, 'MN', 'Mantova', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8054, 8, 'MS', 'Massa-Carrara', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8055, 8, 'MT', 'Matera', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8056, 8, 'MA', 'Medio Campidano', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8057, 8, 'ME', 'Messina', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8058, 8, 'MI', 'Milano', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8059, 8, 'MO', 'Modena', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8060, 8, 'MZ', 'Monza', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8061, 8, 'NA', 'Napoli', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8062, 8, 'NO', 'Novara', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8063, 8, 'NU', 'Nuoro', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8064, 8, 'OG', 'Ogliastra', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8065, 8, 'OT', 'Olbia-Tempio', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8066, 8, 'OR', 'Oristano', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8067, 8, 'PD', 'Padova', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8068, 8, 'PA', 'Palermo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8069, 8, 'PR', 'Parma', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8070, 8, 'PV', 'Pavia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8071, 8, 'PG', 'Perugia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8072, 8, 'PU', 'Pesaro e Urbino', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8073, 8, 'PE', 'Pescara', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8074, 8, 'PC', 'Piacenza', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8075, 8, 'PI', 'Pisa', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8076, 8, 'PT', 'Pistoia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8077, 8, 'PN', 'Pordenone', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8078, 8, 'PZ', 'Potenza', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8079, 8, 'PO', 'Prato', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8080, 8, 'RG', 'Ragusa', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8081, 8, 'RA', 'Ravenna', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8082, 8, 'RC', 'Reggio Calabria', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8083, 8, 'RE', 'Reggio Emilia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8084, 8, 'RI', 'Rieti', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8085, 8, 'RN', 'Rimini', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8086, 8, 'RM', 'Roma', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8087, 8, 'RO', 'Rovigo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8088, 8, 'SA', 'Salerno', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8089, 8, 'SS', 'Sassari', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8090, 8, 'SV', 'Savona', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8091, 8, 'SI', 'Siena', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8092, 8, 'SR', 'Siracusa', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8093, 8, 'SO', 'Sondrio', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8094, 8, 'TA', 'Taranto', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8095, 8, 'TE', 'Teramo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8096, 8, 'TR', 'Terni', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8097, 8, 'TO', 'Torino', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8098, 8, 'TP', 'Trapani', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8099, 8, 'TN', 'Trento', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8100, 8, 'TV', 'Treviso', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8101, 8, 'TS', 'Trieste', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8102, 8, 'UD', 'Udine', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8103, 8, 'VA', 'Varese', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8104, 8, 'VE', 'Venezia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8105, 8, 'VB', 'Verbano-Cusio-Ossola', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8106, 8, 'VC', 'Vercelli', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8107, 8, 'VR', 'Verona', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8108, 8, 'VV', 'Vibo Valentia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8109, 8, 'VI', 'Vicenza', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (8110, 8, 'VT', 'Viterbo', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15001, 15, 'AN', 'Andalusia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15002, 15, 'AR', 'Aragon', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15003, 15, 'AS', 'Asturias', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15004, 15, 'IB', 'Balearic Islands', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15005, 15, 'PV', 'Basque Country', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15006, 15, 'CN', 'Canary Islands', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15007, 15, 'CB', 'Cantabria', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15008, 15, 'CL', 'Castile and Leon', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15009, 15, 'CM', 'Castile-La Mancha', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15010, 15, 'CT', 'Catalonia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15011, 15, 'CE', 'Ceuta', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15012, 15, 'EX', 'Extremadura', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15013, 15, 'GA', 'Galicia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15014, 15, 'LO', 'La Rioja', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15015, 15, 'M', 'Madrid', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15016, 15, 'ML', 'Melilla', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15017, 15, 'MU', 'Murcia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15018, 15, 'NA', 'Navarra', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (15019, 15, 'VC', 'Valencia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19001, 19, 'AL', 'Alabama', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19002, 19, 'AK', 'Alaska', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19003, 19, 'AZ', 'Arizona', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19004, 19, 'AR', 'Arkansas', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19005, 19, 'CA', 'California', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19006, 19, 'CO', 'Colorado', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19007, 19, 'CT', 'Connecticut', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19008, 19, 'DC', 'District of Columbia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19009, 19, 'DE', 'Delaware', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19010, 19, 'FL', 'Florida', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19011, 19, 'GA', 'Georgia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19012, 19, 'HI', 'Hawaii', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19013, 19, 'ID', 'Idaho', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19014, 19, 'IL', 'Illinois', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19015, 19, 'IN', 'Indiana', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19016, 19, 'IA', 'Iowa', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19017, 19, 'KS', 'Kansas', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19018, 19, 'KY', 'Kentucky ', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19019, 19, 'LA', 'Louisiana ', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19020, 19, 'ME', 'Maine', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19021, 19, 'MD', 'Maryland', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19022, 19, 'MA', 'Massachusetts', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19023, 19, 'MI', 'Michigan', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19024, 19, 'MN', 'Minnesota', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19025, 19, 'MS', 'Mississippi', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19026, 19, 'MO', 'Missouri', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19027, 19, 'MT', 'Montana', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19028, 19, 'NE', 'Nebraska', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19029, 19, 'NV', 'Nevada', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19030, 19, 'NH', 'New Hampshire', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19031, 19, 'NJ', 'New Jersey', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19032, 19, 'NM', 'New Mexico', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19033, 19, 'NY', 'New York', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19034, 19, 'NC', 'North Carolina', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19035, 19, 'ND', 'North Dakota', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19036, 19, 'OH', 'Ohio', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19037, 19, 'OK', 'Oklahoma ', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19038, 19, 'OR', 'Oregon', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19039, 19, 'PA', 'Pennsylvania', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19040, 19, 'PR', 'Puerto Rico', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19041, 19, 'RI', 'Rhode Island', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19042, 19, 'SC', 'South Carolina', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19043, 19, 'SD', 'South Dakota', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19044, 19, 'TN', 'Tennessee', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19045, 19, 'TX', 'Texas', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19046, 19, 'UT', 'Utah', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19047, 19, 'VT', 'Vermont', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19048, 19, 'VA', 'Virginia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19049, 19, 'WA', 'Washington', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19050, 19, 'WV', 'West Virginia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19051, 19, 'WI', 'Wisconsin', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (19052, 19, 'WY', 'Wyoming', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32001, 32, 'ACT', 'Australian Capital Territory', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32002, 32, 'NSW', 'New South Wales', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32003, 32, 'NT', 'Northern Territory', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32004, 32, 'QLD', 'Queensland', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32005, 32, 'SA', 'South Australia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32006, 32, 'TAS', 'Tasmania', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32007, 32, 'VIC', 'Victoria', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (32008, 32, 'WA', 'Western Australia', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202001, 202, 'AG', 'Aargau', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202002, 202, 'AR', 'Appenzell Ausserrhoden', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202003, 202, 'AI', 'Appenzell Innerrhoden', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202004, 202, 'BL', 'Basel-Landschaft', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202005, 202, 'BS', 'Basel-Stadt', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202006, 202, 'BE', 'Bern', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202007, 202, 'FR', 'Fribourg', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202008, 202, 'GE', 'Geneva', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202009, 202, 'GL', 'Glarus', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202010, 202, 'GR', 'Graubünden', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202011, 202, 'JU', 'Jura', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202012, 202, 'LU', 'Lucerne', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202013, 202, 'NE', 'Neuchâtel', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202014, 202, 'NW', 'Nidwalden', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202015, 202, 'OW', 'Obwalden', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202016, 202, 'SH', 'Schaffhausen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202017, 202, 'SZ', 'Schwyz', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202018, 202, 'SO', 'Solothurn', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202019, 202, 'SG', 'St. Gallen', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202020, 202, 'TG', 'Thurgau', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202021, 202, 'TI', 'Ticino', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202022, 202, 'UR', 'Uri', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202023, 202, 'VS', 'Valais', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202024, 202, 'VD', 'Vaud', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202025, 202, 'ZG', 'Zug', 1);insert into Region (regionId, countryId, regionCode, name, active_) values (202026, 202, 'ZH', 'Zürich', 1);
---- 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, servletContextName, buildNumber, verified) values (1, sysdate, sysdate, 'portal', 6006, 0);
create table QUARTZ_JOB_DETAILS (JOB_NAME varchar2(320) not null,JOB_GROUP varchar2(320) not null,DESCRIPTION varchar2(480) null,JOB_CLASS_NAME varchar2(512) not null,IS_DURABLE number(1, 0) not null,IS_VOLATILE number(1, 0) not null,IS_STATEFUL number(1, 0) not null,REQUESTS_RECOVERY number(1, 0) not null,JOB_DATA blob null,primary key (JOB_NAME, JOB_GROUP));
create table QUARTZ_JOB_LISTENERS (JOB_NAME varchar2(320) not null,JOB_GROUP varchar2(320) not null,JOB_LISTENER varchar2(320) not null,primary key (JOB_NAME, JOB_GROUP, JOB_LISTENER));
create table QUARTZ_TRIGGERS (TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,JOB_NAME varchar2(320) not null,JOB_GROUP varchar2(320) not null,IS_VOLATILE number(1, 0) not null,DESCRIPTION varchar2(480) null,NEXT_FIRE_TIME number(30,0) null,PREV_FIRE_TIME number(30,0) null,PRIORITY number(30,0) null,TRIGGER_STATE varchar2(64) not null,TRIGGER_TYPE varchar2(32) not null,START_TIME number(30,0) not null,END_TIME number(30,0) null,CALENDAR_NAME varchar2(320) null,MISFIRE_INSTR number(30,0) null,JOB_DATA blob null,primary key (TRIGGER_NAME, TRIGGER_GROUP));
create table QUARTZ_SIMPLE_TRIGGERS (TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,REPEAT_COUNT number(30,0) not null,REPEAT_INTERVAL number(30,0) not null,TIMES_TRIGGERED number(30,0) not null,primary key (TRIGGER_NAME, TRIGGER_GROUP));
create table QUARTZ_CRON_TRIGGERS (TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,CRON_EXPRESSION varchar2(320) not null,TIME_ZONE_ID varchar2(320),primary key (TRIGGER_NAME, TRIGGER_GROUP));
create table QUARTZ_BLOB_TRIGGERS (TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,BLOB_DATA blob null,primary key (TRIGGER_NAME, TRIGGER_GROUP));
create table QUARTZ_TRIGGER_LISTENERS (TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,TRIGGER_LISTENER varchar2(320) not null,primary key (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER));
create table QUARTZ_CALENDARS (CALENDAR_NAME varchar2(320) not null primary key,CALENDAR blob not null);
create table QUARTZ_PAUSED_TRIGGER_GRPS (TRIGGER_GROUP varchar2(320) not null primary key);
create table QUARTZ_FIRED_TRIGGERS (ENTRY_ID varchar2(380) not null primary key,TRIGGER_NAME varchar2(320) not null,TRIGGER_GROUP varchar2(320) not null,IS_VOLATILE number(1, 0) not null,INSTANCE_NAME varchar2(320) not null,FIRED_TIME number(30,0) not null,PRIORITY number(30,0) not null,STATE varchar2(64) not null,JOB_NAME varchar2(320) null,JOB_GROUP varchar2(320) null,IS_STATEFUL number(1, 0) null,REQUESTS_RECOVERY number(1, 0) null);
create table QUARTZ_SCHEDULER_STATE (INSTANCE_NAME varchar2(320) not null primary key,LAST_CHECKIN_TIME number(30,0) not null,CHECKIN_INTERVAL number(30,0) not null);
create table QUARTZ_LOCKS (LOCK_NAME varchar2(160) 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_E639E2F6 on AssetCategory (groupId);create index IX_D61ABE08 on AssetCategory (name, vocabularyId);create index IX_7BB1826B on AssetCategory (parentCategoryId);create index IX_9DDD15EA on AssetCategory (parentCategoryId, name);create unique index IX_BE4DF2BF on AssetCategory (parentCategoryId, name, vocabularyId);create index IX_B185E980 on AssetCategory (parentCategoryId, vocabularyId);create index IX_4D37BB00 on AssetCategory (uuid_);create unique index IX_E8D019AA on AssetCategory (uuid_, groupId);create index IX_287B1F89 on AssetCategory (vocabularyId);
create index IX_99DA856 on AssetCategoryProperty (categoryId);create unique index IX_DBD111AA on AssetCategoryProperty (categoryId, key_);create index IX_8654719F on AssetCategoryProperty (companyId);create index IX_52340033 on AssetCategoryProperty (companyId, key_);
create index IX_A188F560 on AssetEntries_AssetCategories (categoryId);create index IX_E119938A on AssetEntries_AssetCategories (entryId);
create index IX_2ED82CAD on AssetEntries_AssetTags (entryId);create index IX_B2A61B55 on AssetEntries_AssetTags (tagId);
create unique index IX_1E9D371D on AssetEntry (classNameId, classPK);create index IX_FC1F9C7B on AssetEntry (classUuid);create index IX_7306C60 on AssetEntry (companyId);create index IX_1EBA6821 on AssetEntry (groupId, classUuid);
create index IX_128516C8 on AssetLink (entryId1);create index IX_56E0AB21 on AssetLink (entryId1, entryId2);create index IX_8F542794 on AssetLink (entryId1, entryId2, type_);create index IX_14D5A20D on AssetLink (entryId1, type_);create index IX_12851A89 on AssetLink (entryId2);create index IX_91F132C on AssetLink (entryId2, type_);
create index IX_7C9E46BA on AssetTag (groupId);
create index IX_DFF1F063 on AssetTagProperty (companyId);create index IX_13805BF7 on AssetTagProperty (companyId, key_);create index IX_3269E180 on AssetTagProperty (tagId);create unique index IX_2C944354 on AssetTagProperty (tagId, key_);
create index IX_50702693 on AssetTagStats (classNameId);create index IX_9464CA on AssetTagStats (tagId);create unique index IX_56682CC4 on AssetTagStats (tagId, classNameId);
create index IX_B22D908C on AssetVocabulary (companyId);create index IX_B6B8CA0E on AssetVocabulary (groupId);create unique index IX_C0AAD74D on AssetVocabulary (groupId, name);create index IX_55F58818 on AssetVocabulary (uuid_);create unique index IX_1B2B8792 on AssetVocabulary (uuid_, groupId);
create index IX_72EF6041 on BlogsEntry (companyId);create index IX_430D791F on BlogsEntry (companyId, displayDate);create index IX_BB0C2905 on BlogsEntry (companyId, displayDate, status);create index IX_EB2DCE27 on BlogsEntry (companyId, status);create index IX_8CACE77B on BlogsEntry (companyId, userId);create index IX_A5F57B61 on BlogsEntry (companyId, userId, status);create index IX_81A50303 on BlogsEntry (groupId);create index IX_621E19D on BlogsEntry (groupId, displayDate);create index IX_F0E73383 on BlogsEntry (groupId, displayDate, status);create index IX_1EFD8EE9 on BlogsEntry (groupId, status);create unique index IX_DB780A20 on BlogsEntry (groupId, urlTitle);create index IX_FBDE0AA3 on BlogsEntry (groupId, userId, displayDate);create index IX_DA04F689 on BlogsEntry (groupId, userId, displayDate, status);create index IX_49E15A23 on BlogsEntry (groupId, userId, status);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_507BA031 on BlogsStatsUser (userId, lastPostDate);
create index IX_E52FF7EF on BookmarksEntry (groupId);create index IX_5200100C on BookmarksEntry (groupId, folderId);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_F4AF5636 on DLFileEntry (groupId);create index IX_93CF8193 on DLFileEntry (groupId, folderId);create unique index IX_5391712 on DLFileEntry (groupId, folderId, name);create unique index IX_ED5CA615 on DLFileEntry (groupId, folderId, title);create index IX_43261870 on DLFileEntry (groupId, userId);create index IX_D20C434D on DLFileEntry (groupId, userId, folderId);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_B0051937 on DLFileShortcut (groupId, folderId);create index IX_ECCE311D on DLFileShortcut (groupId, folderId, status);create index IX_55C736AC on DLFileShortcut (groupId, toFolderId, toName);create index IX_346A0992 on DLFileShortcut (groupId, toFolderId, toName, status);create index IX_4831EBE4 on DLFileShortcut (uuid_);create unique index IX_FDB4A946 on DLFileShortcut (uuid_, groupId);
create index IX_B413F1EC on DLFileVersion (groupId, folderId, name);create index IX_94E784D2 on DLFileVersion (groupId, folderId, name, status);create unique index IX_2F8FED9C on DLFileVersion (groupId, 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 index IX_ABA5CEC2 on Group_ (companyId);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_63820A7 on IGImage (groupId);create index IX_8956B2C4 on IGImage (groupId, folderId);create index IX_AAE8DF83 on IGImage (groupId, folderId, name);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_323DF109 on JournalArticle (companyId, status);create index IX_9356F865 on JournalArticle (groupId);create index IX_68C0F69C on JournalArticle (groupId, articleId);create index IX_4D5CD982 on JournalArticle (groupId, articleId, status);create unique index IX_85C52EEC on JournalArticle (groupId, articleId, version);create index IX_301D024B on JournalArticle (groupId, status);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_D2D249E8 on JournalArticle (groupId, urlTitle, status);create index IX_33F49D16 on JournalArticle (resourcePrimKey);create index IX_3E2765FC on JournalArticle (resourcePrimKey, status);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_DCD1FAC1 on JournalArticleResource (uuid_);create unique index IX_84AB0309 on JournalArticleResource (uuid_, groupId);
create index IX_9207CB31 on JournalContentSearch (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_D0822724 on Layout (uuid_);create unique index IX_CED31606 on Layout (uuid_, groupId);
create index IX_30616AAA on LayoutPrototype (companyId);create index IX_557A639F on LayoutPrototype (companyId, active_);
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_55F63D98 on LayoutSetPrototype (companyId);create index IX_9178FC71 on LayoutSetPrototype (companyId, active_);
create index IX_2932DD37 on ListType (type_);
create index IX_228562AD on Lock_ (className, key_);create index IX_E3F1286B on Lock_ (expirationDate);create index IX_13C5CD3A on Lock_ (uuid_);
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_76CE9CDD on MBMailingList (groupId, categoryId);create index IX_4115EC7A on MBMailingList (uuid_);create unique index IX_E858F170 on MBMailingList (uuid_, groupId);
create index IX_51A8D44D on MBMessage (classNameId, classPK);create index IX_F6687633 on MBMessage (classNameId, classPK, status);create index IX_B1432D30 on MBMessage (companyId);create index IX_1AD93C16 on MBMessage (companyId, status);create index IX_5B153FB2 on MBMessage (groupId);create index IX_1073AB9F on MBMessage (groupId, categoryId);create index IX_4257DB85 on MBMessage (groupId, categoryId, status);create index IX_B674AB58 on MBMessage (groupId, categoryId, threadId);create index IX_385E123E on MBMessage (groupId, categoryId, threadId, status);create index IX_ED39AC98 on MBMessage (groupId, status);create index IX_8EB8C5EC on MBMessage (groupId, userId);create index IX_377858D2 on MBMessage (groupId, userId, status);create index IX_75B95071 on MBMessage (threadId);create index IX_A7038CD7 on MBMessage (threadId, parentMessageId);create index IX_9DC8E57 on MBMessage (threadId, status);create index IX_7A040C32 on MBMessage (userId);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_41F6DC8A on MBThread (categoryId, priority);create index IX_95C0EA45 on MBThread (groupId);create index IX_9A2D11B2 on MBThread (groupId, categoryId);create index IX_50F1904A on MBThread (groupId, categoryId, lastPostDate);create index IX_485F7E98 on MBThread (groupId, categoryId, status);create index IX_E1E7142B on MBThread (groupId, status);
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_CD25266E on PasswordPolicyRel (passwordPolicyId);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_8BD6BCA7 on Release_ (servletContextName);
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_2F80C17C on ResourcePermission (roleId, scope);
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_5EB4E2FB on Role_ (subtype);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 unique index IX_1C717CA6 on ShoppingItem (companyId, sku);create index IX_FEFE7D76 on ShoppingItem (groupId, categoryId);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 unique index IX_22F6B5CB on SocialEquityAssetEntry (assetEntryId);
create unique index IX_E4F84168 on SocialEquityGroupSetting (groupId, classNameId, type_);
create index IX_DB6958D2 on SocialEquityLog (assetEntryId, actionId, actionDate, active_, type_);create index IX_FEB4055A on SocialEquityLog (assetEntryId, actionId, active_, type_);create index IX_E8DA181D on SocialEquityLog (assetEntryId, type_, active_);create index IX_15A017B on SocialEquityLog (userId, actionId, actionDate, active_, type_);create index IX_3525A383 on SocialEquityLog (userId, actionId, active_, type_);create unique index IX_55B2F00C on SocialEquityLog (userId, assetEntryId, actionId, actionDate, active_, type_);
create index IX_F3AAD60D on SocialEquitySetting (groupId, classNameId, actionId);create unique index IX_903C1B28 on SocialEquitySetting (groupId, classNameId, actionId, type_);
create index IX_6B42B3E7 on SocialEquityUser (groupId);create index IX_945E27C7 on SocialEquityUser (groupId, rank);create unique index IX_D65D3521 on SocialEquityUser (groupId, userId);create index IX_166A8F03 on SocialEquityUser (rank);create index IX_6ECBD5D on SocialEquityUser (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_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_AE6E9907 on Team (groupId);create unique index IX_143DC786 on Team (groupId, name);
create index IX_B2468446 on Ticket (key_);
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_CCBE4063 on UserGroupGroupRole (groupId);create index IX_CAB0CCC8 on UserGroupGroupRole (groupId, roleId);create index IX_1CDF88C on UserGroupGroupRole (roleId);create index IX_DCDED558 on UserGroupGroupRole (userGroupId);create index IX_73C52252 on UserGroupGroupRole (userGroupId, groupId);
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_5204C37B on User_ (companyId, active_);create index IX_6EF03E4E on User_ (companyId, defaultUser);create unique index IX_615E9F7A on User_ (companyId, emailAddress);create index IX_1D731F03 on User_ (companyId, facebookId);create index IX_89509087 on User_ (companyId, openId);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_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_4D06AD51 on Users_Teams (teamId);create index IX_A098EFBF on Users_Teams (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_9F7655DA on WikiPage (nodeId, head, parentTitle, status);create index IX_432F0AB0 on WikiPage (nodeId, head, status);create index IX_46EEF3C8 on WikiPage (nodeId, parentTitle);create index IX_1ECC7656 on WikiPage (nodeId, redirectTitle);create index IX_546F2D5C on WikiPage (nodeId, status);create index IX_997EEDD2 on WikiPage (nodeId, title);create index IX_E745EA26 on WikiPage (nodeId, title, head);create index IX_BEA33AB8 on WikiPage (nodeId, title, status);create unique index IX_3D4AF476 on WikiPage (nodeId, title, version);create index IX_B771D67 on WikiPage (resourcePrimKey, nodeId);create index IX_94D1054D on WikiPage (resourcePrimKey, nodeId, status);create unique index IX_2CD67C81 on WikiPage (resourcePrimKey, nodeId, version);create index IX_FBBE7C96 on WikiPage (userId, nodeId, status);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);create index IX_BE898221 on WikiPageResource (uuid_);
create index IX_A8B0D276 on WorkflowDefinitionLink (companyId);create index IX_A4DB1F0F on WorkflowDefinitionLink (companyId, workflowDefinitionName, workflowDefinitionVersion);create index IX_B6EE8C9E on WorkflowDefinitionLink (groupId, companyId, classNameId);
create index IX_415A7007 on WorkflowInstanceLink (groupId, companyId, classNameId, classPK);
quit
Subscribe to:
Posts (Atom)