--- /dev/null
+create table Account_ (
+ accountId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentAccountId int64,
+ name varchar(75),
+ legalName varchar(75),
+ legalId varchar(75),
+ legalType varchar(75),
+ sicCode varchar(75),
+ tickerSymbol varchar(75),
+ industry varchar(75),
+ type_ varchar(75),
+ size_ varchar(75)
+);
+
+create table Address (
+ addressId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ street1 varchar(75),
+ street2 varchar(75),
+ street3 varchar(75),
+ city varchar(75),
+ zip varchar(75),
+ regionId int64,
+ countryId int64,
+ typeId integer,
+ mailing smallint,
+ primary_ smallint
+);
+
+create table AnnouncementsDelivery (
+ deliveryId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ type_ varchar(75),
+ email smallint,
+ sms smallint,
+ website smallint
+);
+
+create table AnnouncementsEntry (
+ uuid_ varchar(75),
+ entryId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ title varchar(75),
+ content varchar(4000),
+ url varchar(4000),
+ type_ varchar(75),
+ displayDate timestamp,
+ expirationDate timestamp,
+ priority integer,
+ alert smallint
+);
+
+create table AnnouncementsFlag (
+ flagId int64 not null primary key,
+ userId int64,
+ createDate timestamp,
+ entryId int64,
+ value integer
+);
+
+create table BlogsEntry (
+ uuid_ varchar(75),
+ entryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ title varchar(150),
+ urlTitle varchar(150),
+ content blob,
+ displayDate timestamp,
+ draft smallint,
+ allowTrackbacks smallint,
+ trackbacks blob
+);
+
+create table BlogsStatsUser (
+ statsUserId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ entryCount integer,
+ lastPostDate timestamp,
+ ratingsTotalEntries integer,
+ ratingsTotalScore double precision,
+ ratingsAverageScore double precision
+);
+
+create table BookmarksEntry (
+ uuid_ varchar(75),
+ entryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ folderId int64,
+ name varchar(255),
+ url varchar(4000),
+ comments varchar(4000),
+ visits integer,
+ priority integer
+);
+
+create table BookmarksFolder (
+ uuid_ varchar(75),
+ folderId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentFolderId int64,
+ name varchar(75),
+ description varchar(4000)
+);
+
+create table BrowserTracker (
+ browserTrackerId int64 not null primary key,
+ userId int64,
+ browserKey int64
+);
+
+create table CalEvent (
+ uuid_ varchar(75),
+ eventId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ title varchar(75),
+ description varchar(4000),
+ startDate timestamp,
+ endDate timestamp,
+ durationHour integer,
+ durationMinute integer,
+ allDay smallint,
+ timeZoneSensitive smallint,
+ type_ varchar(75),
+ repeating smallint,
+ recurrence blob,
+ remindBy integer,
+ firstReminder integer,
+ secondReminder integer
+);
+
+create table Contacts_Card (
+ cardId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ associatedUserId int64,
+ emailAddress varchar(75),
+ fullName varchar(75),
+ comments varchar(75)
+);
+
+create table ClassName_ (
+ classNameId int64 not null primary key,
+ value varchar(200)
+);
+
+create table Company (
+ companyId int64 not null primary key,
+ accountId int64,
+ webId varchar(75),
+ key_ blob,
+ virtualHost varchar(75),
+ mx varchar(75),
+ homeURL varchar(4000),
+ logoId int64,
+ system smallint
+);
+
+create table Contact_ (
+ contactId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ accountId int64,
+ parentContactId int64,
+ firstName varchar(75),
+ middleName varchar(75),
+ lastName varchar(75),
+ prefixId integer,
+ suffixId integer,
+ male smallint,
+ birthday timestamp,
+ smsSn varchar(75),
+ aimSn varchar(75),
+ facebookSn varchar(75),
+ icqSn varchar(75),
+ jabberSn varchar(75),
+ msnSn varchar(75),
+ mySpaceSn varchar(75),
+ skypeSn varchar(75),
+ twitterSn varchar(75),
+ ymSn varchar(75),
+ employeeStatusId varchar(75),
+ employeeNumber varchar(75),
+ jobTitle varchar(100),
+ jobClass varchar(75),
+ hoursOfOperation varchar(75)
+);
+
+create table Counter (
+ name varchar(75) not null primary key,
+ currentId int64
+);
+
+create table Country (
+ countryId int64 not null primary key,
+ name varchar(75),
+ a2 varchar(75),
+ a3 varchar(75),
+ number_ varchar(75),
+ idd_ varchar(75),
+ active_ smallint
+);
+
+create table CyrusUser (
+ userId varchar(75) not null primary key,
+ password_ varchar(75) not null
+);
+
+create table CyrusVirtual (
+ emailAddress varchar(75) not null primary key,
+ userId varchar(75) not null
+);
+
+create table DLFileEntry (
+ uuid_ varchar(75),
+ fileEntryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ versionUserId int64,
+ versionUserName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ folderId int64,
+ name varchar(255),
+ title varchar(255),
+ description varchar(4000),
+ version double precision,
+ size_ integer,
+ readCount integer,
+ extraSettings blob
+);
+
+create table DLFileRank (
+ fileRankId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ folderId int64,
+ name varchar(255)
+);
+
+create table DLFileShortcut (
+ uuid_ varchar(75),
+ fileShortcutId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ folderId int64,
+ toFolderId int64,
+ toName varchar(255)
+);
+
+create table DLFileVersion (
+ fileVersionId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ folderId int64,
+ name varchar(255),
+ version double precision,
+ size_ integer
+);
+
+create table DLFolder (
+ uuid_ varchar(75),
+ folderId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentFolderId int64,
+ name varchar(100),
+ description varchar(4000),
+);
+
+create table EmailAddress (
+ emailAddressId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ address varchar(75),
+ typeId integer,
+ primary_ smallint
+);
+
+create table ExpandoColumn (
+ columnId int64 not null primary key,
+ companyId int64,
+ tableId int64,
+ name varchar(75),
+ type_ integer,
+ defaultData varchar(4000),
+ typeSettings blob
+);
+
+create table ExpandoRow (
+ rowId_ int64 not null primary key,
+ companyId int64,
+ tableId int64,
+ classPK int64
+);
+
+create table ExpandoTable (
+ tableId int64 not null primary key,
+ companyId int64,
+ classNameId int64,
+ name varchar(75)
+);
+
+create table ExpandoValue (
+ valueId int64 not null primary key,
+ companyId int64,
+ tableId int64,
+ columnId int64,
+ rowId_ int64,
+ classNameId int64,
+ classPK int64,
+ data_ varchar(4000)
+);
+
+create table Group_ (
+ groupId int64 not null primary key,
+ companyId int64,
+ creatorUserId int64,
+ classNameId int64,
+ classPK int64,
+ parentGroupId int64,
+ liveGroupId int64,
+ name varchar(75),
+ description varchar(4000),
+ type_ integer,
+ typeSettings varchar(4000),
+ friendlyURL varchar(100),
+ active_ smallint
+);
+
+create table Groups_Orgs (
+ groupId int64 not null,
+ organizationId int64 not null,
+ primary key (groupId, organizationId)
+);
+
+create table Groups_Permissions (
+ groupId int64 not null,
+ permissionId int64 not null,
+ primary key (groupId, permissionId)
+);
+
+create table Groups_Roles (
+ groupId int64 not null,
+ roleId int64 not null,
+ primary key (groupId, roleId)
+);
+
+create table Groups_UserGroups (
+ groupId int64 not null,
+ userGroupId int64 not null,
+ primary key (groupId, userGroupId)
+);
+
+create table HiddenEntry (
+ folderId int64 not null primary key
+);
+
+create table IGFolder (
+ uuid_ varchar(75),
+ folderId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentFolderId int64,
+ name varchar(75),
+ description varchar(4000)
+);
+
+create table IGImage (
+ uuid_ varchar(75),
+ imageId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ folderId int64,
+ name varchar(75),
+ description varchar(4000),
+ smallImageId int64,
+ largeImageId int64,
+ custom1ImageId int64,
+ custom2ImageId int64
+);
+
+create table Image (
+ imageId int64 not null primary key,
+ modifiedDate timestamp,
+ text_ blob,
+ type_ varchar(75),
+ height integer,
+ width integer,
+ size_ integer
+);
+
+create table JournalArticle (
+ uuid_ varchar(75),
+ id_ int64 not null primary key,
+ resourcePrimKey int64,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ articleId varchar(75),
+ version double precision,
+ title varchar(100),
+ urlTitle varchar(150),
+ description varchar(4000),
+ content blob,
+ type_ varchar(75),
+ structureId varchar(75),
+ templateId varchar(75),
+ displayDate timestamp,
+ approved smallint,
+ approvedByUserId int64,
+ approvedByUserName varchar(75),
+ approvedDate timestamp,
+ expired smallint,
+ expirationDate timestamp,
+ reviewDate timestamp,
+ indexable smallint,
+ smallImage smallint,
+ smallImageId int64,
+ smallImageURL varchar(75)
+);
+
+create table JournalArticleImage (
+ articleImageId int64 not null primary key,
+ groupId int64,
+ articleId varchar(75),
+ version double precision,
+ elInstanceId varchar(75),
+ elName varchar(75),
+ languageId varchar(75),
+ tempImage smallint
+);
+
+create table JournalArticleResource (
+ resourcePrimKey int64 not null primary key,
+ groupId int64,
+ articleId varchar(75)
+);
+
+create table JournalContentSearch (
+ contentSearchId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ privateLayout smallint,
+ layoutId int64,
+ portletId varchar(200),
+ articleId varchar(75)
+);
+
+create table JournalFeed (
+ uuid_ varchar(75),
+ id_ int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ feedId varchar(75),
+ name varchar(75),
+ description varchar(4000),
+ type_ varchar(75),
+ structureId varchar(75),
+ templateId varchar(75),
+ rendererTemplateId varchar(75),
+ delta integer,
+ orderByCol varchar(75),
+ orderByType varchar(75),
+ targetLayoutFriendlyUrl varchar(75),
+ targetPortletId varchar(75),
+ contentField varchar(75),
+ feedType varchar(75),
+ feedVersion double precision
+);
+
+create table JournalStructure (
+ uuid_ varchar(75),
+ id_ int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ structureId varchar(75),
+ parentStructureId varchar(75),
+ name varchar(75),
+ description varchar(4000),
+ xsd blob
+);
+
+create table JournalTemplate (
+ uuid_ varchar(75),
+ id_ int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ templateId varchar(75),
+ structureId varchar(75),
+ name varchar(75),
+ description varchar(4000),
+ xsl blob,
+ langType varchar(75),
+ cacheable smallint,
+ smallImage smallint,
+ smallImageId int64,
+ smallImageURL varchar(75)
+);
+
+create table Layout (
+ plid int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ privateLayout smallint,
+ layoutId int64,
+ parentLayoutId int64,
+ name varchar(4000),
+ title varchar(4000),
+ description varchar(4000),
+ type_ varchar(75),
+ typeSettings blob,
+ hidden_ smallint,
+ friendlyURL varchar(100),
+ iconImage smallint,
+ iconImageId int64,
+ themeId varchar(75),
+ colorSchemeId varchar(75),
+ wapThemeId varchar(75),
+ wapColorSchemeId varchar(75),
+ css varchar(4000),
+ priority integer,
+ dlFolderId int64
+);
+
+create table LayoutSet (
+ layoutSetId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ privateLayout smallint,
+ logo smallint,
+ logoId int64,
+ themeId varchar(75),
+ colorSchemeId varchar(75),
+ wapThemeId varchar(75),
+ wapColorSchemeId varchar(75),
+ css varchar(4000),
+ pageCount integer,
+ virtualHost varchar(75)
+);
+
+create table ListType (
+ listTypeId integer not null primary key,
+ name varchar(75),
+ type_ varchar(75)
+);
+
+create table MBBan (
+ banId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ banUserId int64
+);
+
+create table MBCategory (
+ uuid_ varchar(75),
+ categoryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentCategoryId int64,
+ name varchar(75),
+ description varchar(4000),
+ threadCount integer,
+ messageCount integer,
+ lastPostDate timestamp
+);
+
+create table MBDiscussion (
+ discussionId int64 not null primary key,
+ classNameId int64,
+ classPK int64,
+ threadId int64
+);
+
+create table MBMailingList (
+ uuid_ varchar(75),
+ mailingListId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ categoryId int64,
+ emailAddress varchar(75),
+ inProtocol varchar(75),
+ inServerName varchar(75),
+ inServerPort integer,
+ inUseSSL smallint,
+ inUserName varchar(75),
+ inPassword varchar(75),
+ inReadInterval integer,
+ outEmailAddress varchar(75),
+ outCustom smallint,
+ outServerName varchar(75),
+ outServerPort integer,
+ outUseSSL smallint,
+ outUserName varchar(75),
+ outPassword varchar(75),
+ active_ smallint
+);
+
+create table MBMessage (
+ uuid_ varchar(75),
+ messageId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ categoryId int64,
+ threadId int64,
+ parentMessageId int64,
+ subject varchar(75),
+ body blob,
+ attachments smallint,
+ anonymous smallint,
+ priority double precision
+);
+
+create table MBMessageFlag (
+ messageFlagId int64 not null primary key,
+ userId int64,
+ modifiedDate timestamp,
+ threadId int64,
+ messageId int64,
+ flag integer
+);
+
+create table MBStatsUser (
+ statsUserId int64 not null primary key,
+ groupId int64,
+ userId int64,
+ messageCount integer,
+ lastPostDate timestamp
+);
+
+create table MBThread (
+ threadId int64 not null primary key,
+ groupId int64,
+ categoryId int64,
+ rootMessageId int64,
+ messageCount integer,
+ viewCount integer,
+ lastPostByUserId int64,
+ lastPostDate timestamp,
+ priority double precision
+);
+
+create table MembershipRequest (
+ membershipRequestId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ groupId int64,
+ comments varchar(4000),
+ replyComments varchar(4000),
+ replyDate timestamp,
+ replierUserId int64,
+ statusId integer
+);
+
+create table Organization_ (
+ organizationId int64 not null primary key,
+ companyId int64,
+ parentOrganizationId int64,
+ leftOrganizationId int64,
+ rightOrganizationId int64,
+ name varchar(100),
+ type_ varchar(75),
+ recursable smallint,
+ regionId int64,
+ countryId int64,
+ statusId integer,
+ comments varchar(4000)
+);
+
+create table OrgGroupPermission (
+ organizationId int64 not null,
+ groupId int64 not null,
+ permissionId int64 not null,
+ primary key (organizationId, groupId, permissionId)
+);
+
+create table OrgGroupRole (
+ organizationId int64 not null,
+ groupId int64 not null,
+ roleId int64 not null,
+ primary key (organizationId, groupId, roleId)
+);
+
+create table OrgLabor (
+ orgLaborId int64 not null primary key,
+ organizationId int64,
+ typeId integer,
+ sunOpen integer,
+ sunClose integer,
+ monOpen integer,
+ monClose integer,
+ tueOpen integer,
+ tueClose integer,
+ wedOpen integer,
+ wedClose integer,
+ thuOpen integer,
+ thuClose integer,
+ friOpen integer,
+ friClose integer,
+ satOpen integer,
+ satClose integer
+);
+
+create table PasswordPolicy (
+ passwordPolicyId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ defaultPolicy smallint,
+ name varchar(75),
+ description varchar(4000),
+ changeable smallint,
+ changeRequired smallint,
+ minAge int64,
+ checkSyntax smallint,
+ allowDictionaryWords smallint,
+ minLength integer,
+ history smallint,
+ historyCount integer,
+ expireable smallint,
+ maxAge int64,
+ warningTime int64,
+ graceLimit integer,
+ lockout smallint,
+ maxFailure integer,
+ lockoutDuration int64,
+ requireUnlock smallint,
+ resetFailureCount int64
+);
+
+create table PasswordPolicyRel (
+ passwordPolicyRelId int64 not null primary key,
+ passwordPolicyId int64,
+ classNameId int64,
+ classPK int64
+);
+
+create table PasswordTracker (
+ passwordTrackerId int64 not null primary key,
+ userId int64,
+ createDate timestamp,
+ password_ varchar(75)
+);
+
+create table Permission_ (
+ permissionId int64 not null primary key,
+ companyId int64,
+ actionId varchar(75),
+ resourceId int64
+);
+
+create table Phone (
+ phoneId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ number_ varchar(75),
+ extension varchar(75),
+ typeId integer,
+ primary_ smallint
+);
+
+create table PluginSetting (
+ pluginSettingId int64 not null primary key,
+ companyId int64,
+ pluginId varchar(75),
+ pluginType varchar(75),
+ roles varchar(4000),
+ active_ smallint
+);
+
+create table PollsChoice (
+ uuid_ varchar(75),
+ choiceId int64 not null primary key,
+ questionId int64,
+ name varchar(75),
+ description varchar(1000)
+);
+
+create table PollsQuestion (
+ uuid_ varchar(75),
+ questionId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ title varchar(500),
+ description varchar(4000),
+ expirationDate timestamp,
+ lastVoteDate timestamp
+);
+
+create table PollsVote (
+ voteId int64 not null primary key,
+ userId int64,
+ questionId int64,
+ choiceId int64,
+ voteDate timestamp
+);
+
+create table Portlet (
+ id_ int64 not null primary key,
+ companyId int64,
+ portletId varchar(200),
+ roles varchar(4000),
+ active_ smallint
+);
+
+create table PortletItem (
+ portletItemId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ portletId varchar(75),
+ classNameId int64
+);
+
+create table PortletPreferences (
+ portletPreferencesId int64 not null primary key,
+ ownerId int64,
+ ownerType integer,
+ plid int64,
+ portletId varchar(200),
+ preferences blob
+);
+
+create table RatingsEntry (
+ entryId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ score double precision
+);
+
+create table RatingsStats (
+ statsId int64 not null primary key,
+ classNameId int64,
+ classPK int64,
+ totalEntries integer,
+ totalScore double precision,
+ averageScore double precision
+);
+
+create table Region (
+ regionId int64 not null primary key,
+ countryId int64,
+ regionCode varchar(75),
+ name varchar(75),
+ active_ smallint
+);
+
+create table Release_ (
+ releaseId int64 not null primary key,
+ createDate timestamp,
+ modifiedDate timestamp,
+ buildNumber integer,
+ buildDate timestamp,
+ verified smallint,
+ testString varchar(1024)
+);
+
+create table Resource_ (
+ resourceId int64 not null primary key,
+ codeId int64,
+ primKey varchar(255)
+);
+
+create table ResourceAction (
+ resourceActionId int64 not null primary key,
+ name varchar(75),
+ actionId varchar(75),
+ bitwiseValue int64
+);
+
+create table ResourceCode (
+ codeId int64 not null primary key,
+ companyId int64,
+ name varchar(255),
+ scope integer
+);
+
+create table ResourcePermission (
+ resourcePermissionId int64 not null primary key,
+ companyId int64,
+ name varchar(255),
+ scope integer,
+ primKey varchar(255),
+ roleId int64,
+ actionIds int64
+);
+
+create table Role_ (
+ roleId int64 not null primary key,
+ companyId int64,
+ classNameId int64,
+ classPK int64,
+ name varchar(75),
+ title varchar(4000),
+ description varchar(4000),
+ type_ integer,
+ subtype varchar(75)
+);
+
+create table Roles_Permissions (
+ roleId int64 not null,
+ permissionId int64 not null,
+ primary key (roleId, permissionId)
+);
+
+create table SCFrameworkVersi_SCProductVers (
+ frameworkVersionId int64 not null,
+ productVersionId int64 not null,
+ primary key (frameworkVersionId, productVersionId)
+);
+
+create table SCFrameworkVersion (
+ frameworkVersionId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ url varchar(4000),
+ active_ smallint,
+ priority integer
+);
+
+create table SCLicense (
+ licenseId int64 not null primary key,
+ name varchar(75),
+ url varchar(4000),
+ openSource smallint,
+ active_ smallint,
+ recommended smallint
+);
+
+create table SCLicenses_SCProductEntries (
+ licenseId int64 not null,
+ productEntryId int64 not null,
+ primary key (licenseId, productEntryId)
+);
+
+create table SCProductEntry (
+ productEntryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ type_ varchar(75),
+ tags varchar(255),
+ shortDescription varchar(4000),
+ longDescription varchar(4000),
+ pageURL varchar(4000),
+ author varchar(75),
+ repoGroupId varchar(75),
+ repoArtifactId varchar(75)
+);
+
+create table SCProductScreenshot (
+ productScreenshotId int64 not null primary key,
+ companyId int64,
+ groupId int64,
+ productEntryId int64,
+ thumbnailId int64,
+ fullImageId int64,
+ priority integer
+);
+
+create table SCProductVersion (
+ productVersionId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ productEntryId int64,
+ version varchar(75),
+ changeLog varchar(4000),
+ downloadPageURL varchar(4000),
+ directDownloadURL varchar(2000),
+ repoStoreArtifact smallint
+);
+
+create table ServiceComponent (
+ serviceComponentId int64 not null primary key,
+ buildNamespace varchar(75),
+ buildNumber int64,
+ buildDate int64,
+ data_ blob
+);
+
+create table Shard (
+ shardId int64 not null primary key,
+ classNameId int64,
+ classPK int64,
+ name varchar(75)
+);
+
+create table ShoppingCart (
+ cartId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ itemIds varchar(4000),
+ couponCodes varchar(75),
+ altShipping integer,
+ insure smallint
+);
+
+create table ShoppingCategory (
+ categoryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentCategoryId int64,
+ name varchar(75),
+ description varchar(4000)
+);
+
+create table ShoppingCoupon (
+ couponId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ code_ varchar(75),
+ name varchar(75),
+ description varchar(4000),
+ startDate timestamp,
+ endDate timestamp,
+ active_ smallint,
+ limitCategories varchar(4000),
+ limitSkus varchar(4000),
+ minOrder double precision,
+ discount double precision,
+ discountType varchar(75)
+);
+
+create table ShoppingItem (
+ itemId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ categoryId int64,
+ sku varchar(75),
+ name varchar(200),
+ description varchar(4000),
+ properties varchar(4000),
+ fields_ smallint,
+ fieldsQuantities varchar(4000),
+ minQuantity integer,
+ maxQuantity integer,
+ price double precision,
+ discount double precision,
+ taxable smallint,
+ shipping double precision,
+ useShippingFormula smallint,
+ requiresShipping smallint,
+ stockQuantity integer,
+ featured_ smallint,
+ sale_ smallint,
+ smallImage smallint,
+ smallImageId int64,
+ smallImageURL varchar(75),
+ mediumImage smallint,
+ mediumImageId int64,
+ mediumImageURL varchar(75),
+ largeImage smallint,
+ largeImageId int64,
+ largeImageURL varchar(75)
+);
+
+create table ShoppingItemField (
+ itemFieldId int64 not null primary key,
+ itemId int64,
+ name varchar(75),
+ values_ varchar(4000),
+ description varchar(4000)
+);
+
+create table ShoppingItemPrice (
+ itemPriceId int64 not null primary key,
+ itemId int64,
+ minQuantity integer,
+ maxQuantity integer,
+ price double precision,
+ discount double precision,
+ taxable smallint,
+ shipping double precision,
+ useShippingFormula smallint,
+ status integer
+);
+
+create table ShoppingOrder (
+ orderId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ number_ varchar(75),
+ tax double precision,
+ shipping double precision,
+ altShipping varchar(75),
+ requiresShipping smallint,
+ insure smallint,
+ insurance double precision,
+ couponCodes varchar(75),
+ couponDiscount double precision,
+ billingFirstName varchar(75),
+ billingLastName varchar(75),
+ billingEmailAddress varchar(75),
+ billingCompany varchar(75),
+ billingStreet varchar(75),
+ billingCity varchar(75),
+ billingState varchar(75),
+ billingZip varchar(75),
+ billingCountry varchar(75),
+ billingPhone varchar(75),
+ shipToBilling smallint,
+ shippingFirstName varchar(75),
+ shippingLastName varchar(75),
+ shippingEmailAddress varchar(75),
+ shippingCompany varchar(75),
+ shippingStreet varchar(75),
+ shippingCity varchar(75),
+ shippingState varchar(75),
+ shippingZip varchar(75),
+ shippingCountry varchar(75),
+ shippingPhone varchar(75),
+ ccName varchar(75),
+ ccType varchar(75),
+ ccNumber varchar(75),
+ ccExpMonth integer,
+ ccExpYear integer,
+ ccVerNumber varchar(75),
+ comments varchar(4000),
+ ppTxnId varchar(75),
+ ppPaymentStatus varchar(75),
+ ppPaymentGross double precision,
+ ppReceiverEmail varchar(75),
+ ppPayerEmail varchar(75),
+ sendOrderEmail smallint,
+ sendShippingEmail smallint
+);
+
+create table ShoppingOrderItem (
+ orderItemId int64 not null primary key,
+ orderId int64,
+ itemId varchar(75),
+ sku varchar(75),
+ name varchar(200),
+ description varchar(4000),
+ properties varchar(4000),
+ price double precision,
+ quantity integer,
+ shippedDate timestamp
+);
+
+create table SocialActivity (
+ activityId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ mirrorActivityId int64,
+ classNameId int64,
+ classPK int64,
+ type_ integer,
+ extraData varchar(4000),
+ receiverUserId int64
+);
+
+create table SocialRelation (
+ uuid_ varchar(75),
+ relationId int64 not null primary key,
+ companyId int64,
+ createDate timestamp,
+ userId1 int64,
+ userId2 int64,
+ type_ integer
+);
+
+create table SocialRequest (
+ uuid_ varchar(75),
+ requestId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ type_ integer,
+ extraData varchar(4000),
+ receiverUserId int64,
+ status integer
+);
+
+create table Subscription (
+ subscriptionId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ frequency varchar(75)
+);
+
+create table TagsAsset (
+ assetId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ visible smallint,
+ startDate timestamp,
+ endDate timestamp,
+ publishDate timestamp,
+ expirationDate timestamp,
+ mimeType varchar(75),
+ title varchar(255),
+ description varchar(4000),
+ summary varchar(4000),
+ url varchar(4000),
+ height integer,
+ width integer,
+ priority double precision,
+ viewCount integer
+);
+
+create table TagsAssets_TagsEntries (
+ assetId int64 not null,
+ entryId int64 not null,
+ primary key (assetId, entryId)
+);
+
+create table TagsEntry (
+ entryId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ parentEntryId int64,
+ name varchar(75),
+ vocabularyId int64
+);
+
+create table TagsProperty (
+ propertyId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ entryId int64,
+ key_ varchar(75),
+ value varchar(255)
+);
+
+create table TagsSource (
+ sourceId int64 not null primary key,
+ parentSourceId int64,
+ name varchar(75),
+ acronym varchar(75)
+);
+
+create table TagsVocabulary (
+ vocabularyId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ description varchar(75),
+ folksonomy smallint
+);
+
+create table TasksProposal (
+ proposalId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK varchar(75),
+ name varchar(75),
+ description varchar(4000),
+ publishDate timestamp,
+ dueDate timestamp
+);
+
+create table TasksReview (
+ reviewId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ proposalId int64,
+ assignedByUserId int64,
+ assignedByUserName varchar(75),
+ stage integer,
+ completed smallint,
+ rejected smallint
+);
+
+create table User_ (
+ uuid_ varchar(75),
+ userId int64 not null primary key,
+ companyId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ defaultUser smallint,
+ contactId int64,
+ password_ varchar(75),
+ passwordEncrypted smallint,
+ passwordReset smallint,
+ passwordModifiedDate timestamp,
+ reminderQueryQuestion varchar(75),
+ reminderQueryAnswer varchar(75),
+ graceLoginCount integer,
+ screenName varchar(75),
+ emailAddress varchar(75),
+ openId varchar(1024),
+ portraitId int64,
+ languageId varchar(75),
+ timeZoneId varchar(75),
+ greeting varchar(255),
+ comments varchar(4000),
+ firstName varchar(75),
+ middleName varchar(75),
+ lastName varchar(75),
+ jobTitle varchar(75),
+ loginDate timestamp,
+ loginIP varchar(75),
+ lastLoginDate timestamp,
+ lastLoginIP varchar(75),
+ lastFailedLoginDate timestamp,
+ failedLoginAttempts integer,
+ lockout smallint,
+ lockoutDate timestamp,
+ agreedToTermsOfUse smallint,
+ active_ smallint
+);
+
+create table UserGroup (
+ userGroupId int64 not null primary key,
+ companyId int64,
+ parentUserGroupId int64,
+ name varchar(75),
+ description varchar(4000)
+);
+
+create table UserGroupRole (
+ userId int64 not null,
+ groupId int64 not null,
+ roleId int64 not null,
+ primary key (userId, groupId, roleId)
+);
+
+create table UserIdMapper (
+ userIdMapperId int64 not null primary key,
+ userId int64,
+ type_ varchar(75),
+ description varchar(75),
+ externalUserId varchar(75)
+);
+
+create table Users_Groups (
+ userId int64 not null,
+ groupId int64 not null,
+ primary key (userId, groupId)
+);
+
+create table Users_Orgs (
+ userId int64 not null,
+ organizationId int64 not null,
+ primary key (userId, organizationId)
+);
+
+create table Users_Permissions (
+ userId int64 not null,
+ permissionId int64 not null,
+ primary key (userId, permissionId)
+);
+
+create table Users_Roles (
+ userId int64 not null,
+ roleId int64 not null,
+ primary key (userId, roleId)
+);
+
+create table Users_UserGroups (
+ userGroupId int64 not null,
+ userId int64 not null,
+ primary key (userGroupId, userId)
+);
+
+create table UserTracker (
+ userTrackerId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ modifiedDate timestamp,
+ sessionId varchar(200),
+ remoteAddr varchar(75),
+ remoteHost varchar(75),
+ userAgent varchar(200)
+);
+
+create table UserTrackerPath (
+ userTrackerPathId int64 not null primary key,
+ userTrackerId int64,
+ path_ varchar(4000),
+ pathDate timestamp
+);
+
+create table Vocabulary (
+ vocabularyId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ description varchar(75),
+ folksonomy smallint
+);
+
+create table WebDAVProps (
+ webDavPropsId int64 not null primary key,
+ companyId int64,
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ props blob
+);
+
+create table Website (
+ websiteId int64 not null primary key,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ classNameId int64,
+ classPK int64,
+ url varchar(4000),
+ typeId integer,
+ primary_ smallint
+);
+
+create table WikiNode (
+ uuid_ varchar(75),
+ nodeId int64 not null primary key,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ name varchar(75),
+ description varchar(4000),
+ lastPostDate timestamp
+);
+
+create table WikiPage (
+ uuid_ varchar(75),
+ pageId int64 not null primary key,
+ resourcePrimKey int64,
+ groupId int64,
+ companyId int64,
+ userId int64,
+ userName varchar(75),
+ createDate timestamp,
+ modifiedDate timestamp,
+ nodeId int64,
+ title varchar(255),
+ version double precision,
+ minorEdit smallint,
+ content blob,
+ summary varchar(4000),
+ format varchar(75),
+ head smallint,
+ parentTitle varchar(75),
+ redirectTitle varchar(75)
+);
+
+create table WikiPageResource (
+ resourcePrimKey int64 not null primary key,
+ nodeId int64,
+ title varchar(75)
+);
+
+
+
+
+
+--
+-- List types for accounts
+--
+
+
+
+
+
+--
+-- List types for contacts
+--
+
+
+
+
+
+
+
+--
+-- List types for organizations
+--
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+create table QUARTZ_JOB_DETAILS (
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ DESCRIPTION varchar(120),
+ JOB_CLASS_NAME varchar(128) not null,
+ IS_DURABLE smallint not null,
+ IS_VOLATILE smallint not null,
+ IS_STATEFUL smallint not null,
+ REQUESTS_RECOVERY smallint not null,
+ JOB_DATA blob,
+ primary key (JOB_NAME, JOB_GROUP)
+);
+
+create table QUARTZ_JOB_LISTENERS (
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ JOB_LISTENER varchar(80) not null,
+ primary key (JOB_NAME, JOB_GROUP, JOB_LISTENER)
+);
+
+create table QUARTZ_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ JOB_NAME varchar(80) not null,
+ JOB_GROUP varchar(80) not null,
+ IS_VOLATILE smallint not null,
+ DESCRIPTION varchar(120),
+ NEXT_FIRE_TIME int64,
+ PREV_FIRE_TIME int64,
+ PRIORITY integer,
+ TRIGGER_STATE varchar(16) not null,
+ TRIGGER_TYPE varchar(8) not null,
+ START_TIME int64 not null,
+ END_TIME int64,
+ CALENDAR_NAME varchar(80),
+ MISFIRE_INSTR integer,
+ JOB_DATA blob,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_SIMPLE_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ REPEAT_COUNT int64 not null,
+ REPEAT_INTERVAL int64 not null,
+ TIMES_TRIGGERED int64 not null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_CRON_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ CRON_EXPRESSION varchar(80) not null,
+ TIME_ZONE_ID varchar(80),
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_BLOB_TRIGGERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ BLOB_DATA blob,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP)
+);
+
+create table QUARTZ_TRIGGER_LISTENERS (
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ TRIGGER_LISTENER varchar(80) not null,
+ primary key (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER)
+);
+
+create table QUARTZ_CALENDARS (
+ CALENDAR_NAME varchar(80) not null primary key,
+ CALENDAR blob not null
+);
+
+create table QUARTZ_PAUSED_TRIGGER_GRPS (
+ TRIGGER_GROUP varchar(80) not null primary key
+);
+
+create table QUARTZ_FIRED_TRIGGERS (
+ ENTRY_ID varchar(95) not null primary key,
+ TRIGGER_NAME varchar(80) not null,
+ TRIGGER_GROUP varchar(80) not null,
+ IS_VOLATILE smallint not null,
+ INSTANCE_NAME varchar(80) not null,
+ FIRED_TIME int64 not null,
+ PRIORITY integer not null,
+ STATE varchar(16) not null,
+ JOB_NAME varchar(80),
+ JOB_GROUP varchar(80),
+ IS_STATEFUL smallint,
+ REQUESTS_RECOVERY smallint
+);
+
+create table QUARTZ_SCHEDULER_STATE (
+ INSTANCE_NAME varchar(80) not null primary key,
+ LAST_CHECKIN_TIME int64 not null,
+ CHECKIN_INTERVAL int64 not null
+);
+
+create table QUARTZ_LOCKS (
+ LOCK_NAME varchar(40) not null primary key
+);
+
+commit;
+
+
+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;