PageRenderTime 164ms CodeModel.GetById 2ms app.highlight 152ms RepoModel.GetById 1ms app.codeStats 1ms

/sql/portal-tables.sql

https://github.com/edgonzales/liferay-portal
SQL | 2390 lines | 2222 code | 168 blank | 0 comment | 0 complexity | b28943f9a9df7019d750722f9074b8cf MD5 | raw file

Large files files are truncated, but you can click here to view the full file

   1create table Account_ (
   2	accountId LONG not null primary key,
   3	companyId LONG,
   4	userId LONG,
   5	userName VARCHAR(75) null,
   6	createDate DATE null,
   7	modifiedDate DATE null,
   8	parentAccountId LONG,
   9	name VARCHAR(75) null,
  10	legalName VARCHAR(75) null,
  11	legalId VARCHAR(75) null,
  12	legalType VARCHAR(75) null,
  13	sicCode VARCHAR(75) null,
  14	tickerSymbol VARCHAR(75) null,
  15	industry VARCHAR(75) null,
  16	type_ VARCHAR(75) null,
  17	size_ VARCHAR(75) null
  18);
  19
  20create table Address (
  21	uuid_ VARCHAR(75) null,
  22	addressId LONG not null primary key,
  23	companyId LONG,
  24	userId LONG,
  25	userName VARCHAR(75) null,
  26	createDate DATE null,
  27	modifiedDate DATE null,
  28	classNameId LONG,
  29	classPK LONG,
  30	street1 VARCHAR(75) null,
  31	street2 VARCHAR(75) null,
  32	street3 VARCHAR(75) null,
  33	city VARCHAR(75) null,
  34	zip VARCHAR(75) null,
  35	regionId LONG,
  36	countryId LONG,
  37	typeId INTEGER,
  38	mailing BOOLEAN,
  39	primary_ BOOLEAN
  40);
  41
  42create table AnnouncementsDelivery (
  43	deliveryId LONG not null primary key,
  44	companyId LONG,
  45	userId LONG,
  46	type_ VARCHAR(75) null,
  47	email BOOLEAN,
  48	sms BOOLEAN,
  49	website BOOLEAN
  50);
  51
  52create table AnnouncementsEntry (
  53	uuid_ VARCHAR(75) null,
  54	entryId LONG not null primary key,
  55	companyId LONG,
  56	userId LONG,
  57	userName VARCHAR(75) null,
  58	createDate DATE null,
  59	modifiedDate DATE null,
  60	classNameId LONG,
  61	classPK LONG,
  62	title VARCHAR(75) null,
  63	content TEXT null,
  64	url STRING null,
  65	type_ VARCHAR(75) null,
  66	displayDate DATE null,
  67	expirationDate DATE null,
  68	priority INTEGER,
  69	alert BOOLEAN
  70);
  71
  72create table AnnouncementsFlag (
  73	flagId LONG not null primary key,
  74	userId LONG,
  75	createDate DATE null,
  76	entryId LONG,
  77	value INTEGER
  78);
  79
  80create table AssetCategory (
  81	uuid_ VARCHAR(75) null,
  82	categoryId LONG not null primary key,
  83	groupId LONG,
  84	companyId LONG,
  85	userId LONG,
  86	userName VARCHAR(75) null,
  87	createDate DATE null,
  88	modifiedDate DATE null,
  89	parentCategoryId LONG,
  90	leftCategoryId LONG,
  91	rightCategoryId LONG,
  92	name VARCHAR(75) null,
  93	title STRING null,
  94	description STRING null,
  95	vocabularyId LONG
  96);
  97
  98create table AssetCategoryProperty (
  99	categoryPropertyId LONG not null primary key,
 100	companyId LONG,
 101	userId LONG,
 102	userName VARCHAR(75) null,
 103	createDate DATE null,
 104	modifiedDate DATE null,
 105	categoryId LONG,
 106	key_ VARCHAR(75) null,
 107	value VARCHAR(75) null
 108);
 109
 110create table AssetEntries_AssetCategories (
 111	categoryId LONG not null,
 112	entryId LONG not null,
 113	primary key (categoryId, entryId)
 114);
 115
 116create table AssetEntries_AssetTags (
 117	entryId LONG not null,
 118	tagId LONG not null,
 119	primary key (entryId, tagId)
 120);
 121
 122create table AssetEntry (
 123	entryId LONG not null primary key,
 124	groupId LONG,
 125	companyId LONG,
 126	userId LONG,
 127	userName VARCHAR(75) null,
 128	createDate DATE null,
 129	modifiedDate DATE null,
 130	classNameId LONG,
 131	classPK LONG,
 132	classUuid VARCHAR(75) null,
 133	classTypeId LONG,
 134	visible BOOLEAN,
 135	startDate DATE null,
 136	endDate DATE null,
 137	publishDate DATE null,
 138	expirationDate DATE null,
 139	mimeType VARCHAR(75) null,
 140	title STRING null,
 141	description STRING null,
 142	summary STRING null,
 143	url STRING null,
 144	layoutUuid VARCHAR(75) null,
 145	height INTEGER,
 146	width INTEGER,
 147	priority DOUBLE,
 148	viewCount INTEGER
 149);
 150
 151create table AssetLink (
 152	linkId LONG not null primary key,
 153	companyId LONG,
 154	userId LONG,
 155	userName VARCHAR(75) null,
 156	createDate DATE null,
 157	entryId1 LONG,
 158	entryId2 LONG,
 159	type_ INTEGER,
 160	weight INTEGER
 161);
 162
 163create table AssetTag (
 164	tagId LONG not null primary key,
 165	groupId LONG,
 166	companyId LONG,
 167	userId LONG,
 168	userName VARCHAR(75) null,
 169	createDate DATE null,
 170	modifiedDate DATE null,
 171	name VARCHAR(75) null,
 172	assetCount INTEGER
 173);
 174
 175create table AssetTagProperty (
 176	tagPropertyId LONG not null primary key,
 177	companyId LONG,
 178	userId LONG,
 179	userName VARCHAR(75) null,
 180	createDate DATE null,
 181	modifiedDate DATE null,
 182	tagId LONG,
 183	key_ VARCHAR(75) null,
 184	value VARCHAR(255) null
 185);
 186
 187create table AssetTagStats (
 188	tagStatsId LONG not null primary key,
 189	tagId LONG,
 190	classNameId LONG,
 191	assetCount INTEGER
 192);
 193
 194create table AssetVocabulary (
 195	uuid_ VARCHAR(75) null,
 196	vocabularyId LONG not null primary key,
 197	groupId LONG,
 198	companyId LONG,
 199	userId LONG,
 200	userName VARCHAR(75) null,
 201	createDate DATE null,
 202	modifiedDate DATE null,
 203	name VARCHAR(75) null,
 204	title STRING null,
 205	description STRING null,
 206	settings_ STRING null
 207);
 208
 209create table BackgroundTask (
 210	backgroundTaskId LONG not null primary key,
 211	groupId LONG,
 212	companyId LONG,
 213	userId LONG,
 214	userName VARCHAR(75) null,
 215	createDate DATE null,
 216	modifiedDate DATE null,
 217	name VARCHAR(75) null,
 218	servletContextNames VARCHAR(255) null,
 219	taskExecutorClassName VARCHAR(200) null,
 220	taskContext TEXT null,
 221	completed BOOLEAN,
 222	completionDate DATE null,
 223	status INTEGER,
 224	statusMessage TEXT null
 225);
 226
 227create table BlogsEntry (
 228	uuid_ VARCHAR(75) null,
 229	entryId LONG not null primary key,
 230	groupId LONG,
 231	companyId LONG,
 232	userId LONG,
 233	userName VARCHAR(75) null,
 234	createDate DATE null,
 235	modifiedDate DATE null,
 236	title VARCHAR(150) null,
 237	urlTitle VARCHAR(150) null,
 238	description STRING null,
 239	content TEXT null,
 240	displayDate DATE null,
 241	allowPingbacks BOOLEAN,
 242	allowTrackbacks BOOLEAN,
 243	trackbacks TEXT null,
 244	smallImage BOOLEAN,
 245	smallImageId LONG,
 246	smallImageURL STRING null,
 247	status INTEGER,
 248	statusByUserId LONG,
 249	statusByUserName VARCHAR(75) null,
 250	statusDate DATE null
 251);
 252
 253create table BlogsStatsUser (
 254	statsUserId LONG not null primary key,
 255	groupId LONG,
 256	companyId LONG,
 257	userId LONG,
 258	entryCount INTEGER,
 259	lastPostDate DATE null,
 260	ratingsTotalEntries INTEGER,
 261	ratingsTotalScore DOUBLE,
 262	ratingsAverageScore DOUBLE
 263);
 264
 265create table BookmarksEntry (
 266	uuid_ VARCHAR(75) null,
 267	entryId LONG not null primary key,
 268	groupId LONG,
 269	companyId LONG,
 270	userId LONG,
 271	userName VARCHAR(75) null,
 272	createDate DATE null,
 273	modifiedDate DATE null,
 274	resourceBlockId LONG,
 275	folderId LONG,
 276	treePath STRING null,
 277	name VARCHAR(255) null,
 278	url STRING null,
 279	description STRING null,
 280	visits INTEGER,
 281	priority INTEGER,
 282	status INTEGER,
 283	statusByUserId LONG,
 284	statusByUserName VARCHAR(75) null,
 285	statusDate DATE null
 286);
 287
 288create table BookmarksFolder (
 289	uuid_ VARCHAR(75) null,
 290	folderId LONG not null primary key,
 291	groupId LONG,
 292	companyId LONG,
 293	userId LONG,
 294	userName VARCHAR(75) null,
 295	createDate DATE null,
 296	modifiedDate DATE null,
 297	resourceBlockId LONG,
 298	parentFolderId LONG,
 299	treePath STRING null,
 300	name VARCHAR(75) null,
 301	description STRING null,
 302	status INTEGER,
 303	statusByUserId LONG,
 304	statusByUserName VARCHAR(75) null,
 305	statusDate DATE null
 306);
 307
 308create table BrowserTracker (
 309	browserTrackerId LONG not null primary key,
 310	userId LONG,
 311	browserKey LONG
 312);
 313
 314create table CalEvent (
 315	uuid_ VARCHAR(75) null,
 316	eventId LONG not null primary key,
 317	groupId LONG,
 318	companyId LONG,
 319	userId LONG,
 320	userName VARCHAR(75) null,
 321	createDate DATE null,
 322	modifiedDate DATE null,
 323	title VARCHAR(75) null,
 324	description STRING null,
 325	location STRING null,
 326	startDate DATE null,
 327	endDate DATE null,
 328	durationHour INTEGER,
 329	durationMinute INTEGER,
 330	allDay BOOLEAN,
 331	timeZoneSensitive BOOLEAN,
 332	type_ VARCHAR(75) null,
 333	repeating BOOLEAN,
 334	recurrence TEXT null,
 335	remindBy INTEGER,
 336	firstReminder INTEGER,
 337	secondReminder INTEGER
 338);
 339
 340create table ClassName_ (
 341	classNameId LONG not null primary key,
 342	value VARCHAR(200) null
 343);
 344
 345create table ClusterGroup (
 346	clusterGroupId LONG not null primary key,
 347	name VARCHAR(75) null,
 348	clusterNodeIds VARCHAR(75) null,
 349	wholeCluster BOOLEAN
 350);
 351
 352create table Company (
 353	companyId LONG not null primary key,
 354	accountId LONG,
 355	webId VARCHAR(75) null,
 356	key_ TEXT null,
 357	mx VARCHAR(75) null,
 358	homeURL STRING null,
 359	logoId LONG,
 360	system BOOLEAN,
 361	maxUsers INTEGER,
 362	active_ BOOLEAN
 363);
 364
 365create table Contact_ (
 366	contactId LONG not null primary key,
 367	companyId LONG,
 368	userId LONG,
 369	userName VARCHAR(75) null,
 370	createDate DATE null,
 371	modifiedDate DATE null,
 372	classNameId LONG,
 373	classPK LONG,
 374	accountId LONG,
 375	parentContactId LONG,
 376	emailAddress VARCHAR(75) null,
 377	firstName VARCHAR(75) null,
 378	middleName VARCHAR(75) null,
 379	lastName VARCHAR(75) null,
 380	prefixId INTEGER,
 381	suffixId INTEGER,
 382	male BOOLEAN,
 383	birthday DATE null,
 384	smsSn VARCHAR(75) null,
 385	aimSn VARCHAR(75) null,
 386	facebookSn VARCHAR(75) null,
 387	icqSn VARCHAR(75) null,
 388	jabberSn VARCHAR(75) null,
 389	msnSn VARCHAR(75) null,
 390	mySpaceSn VARCHAR(75) null,
 391	skypeSn VARCHAR(75) null,
 392	twitterSn VARCHAR(75) null,
 393	ymSn VARCHAR(75) null,
 394	employeeStatusId VARCHAR(75) null,
 395	employeeNumber VARCHAR(75) null,
 396	jobTitle VARCHAR(100) null,
 397	jobClass VARCHAR(75) null,
 398	hoursOfOperation VARCHAR(75) null
 399);
 400
 401create table Counter (
 402	name VARCHAR(75) not null primary key,
 403	currentId LONG
 404);
 405
 406create table Country (
 407	countryId LONG not null primary key,
 408	name VARCHAR(75) null,
 409	a2 VARCHAR(75) null,
 410	a3 VARCHAR(75) null,
 411	number_ VARCHAR(75) null,
 412	idd_ VARCHAR(75) null,
 413	zipRequired BOOLEAN,
 414	active_ BOOLEAN
 415);
 416
 417create table CyrusUser (
 418	userId VARCHAR(75) not null primary key,
 419	password_ VARCHAR(75) not null
 420);
 421
 422create table CyrusVirtual (
 423	emailAddress VARCHAR(75) not null primary key,
 424	userId VARCHAR(75) not null
 425);
 426
 427create table DDLRecord (
 428	uuid_ VARCHAR(75) null,
 429	recordId LONG not null primary key,
 430	groupId LONG,
 431	companyId LONG,
 432	userId LONG,
 433	userName VARCHAR(75) null,
 434	versionUserId LONG,
 435	versionUserName VARCHAR(75) null,
 436	createDate DATE null,
 437	modifiedDate DATE null,
 438	DDMStorageId LONG,
 439	recordSetId LONG,
 440	version VARCHAR(75) null,
 441	displayIndex INTEGER
 442);
 443
 444create table DDLRecordSet (
 445	uuid_ VARCHAR(75) null,
 446	recordSetId LONG not null primary key,
 447	groupId LONG,
 448	companyId LONG,
 449	userId LONG,
 450	userName VARCHAR(75) null,
 451	createDate DATE null,
 452	modifiedDate DATE null,
 453	DDMStructureId LONG,
 454	recordSetKey VARCHAR(75) null,
 455	name STRING null,
 456	description STRING null,
 457	minDisplayRows INTEGER,
 458	scope INTEGER
 459);
 460
 461create table DDLRecordVersion (
 462	recordVersionId LONG not null primary key,
 463	groupId LONG,
 464	companyId LONG,
 465	userId LONG,
 466	userName VARCHAR(75) null,
 467	createDate DATE null,
 468	DDMStorageId LONG,
 469	recordSetId LONG,
 470	recordId LONG,
 471	version VARCHAR(75) null,
 472	displayIndex INTEGER,
 473	status INTEGER,
 474	statusByUserId LONG,
 475	statusByUserName VARCHAR(75) null,
 476	statusDate DATE null
 477);
 478
 479create table DDMContent (
 480	uuid_ VARCHAR(75) null,
 481	contentId LONG not null primary key,
 482	groupId LONG,
 483	companyId LONG,
 484	userId LONG,
 485	userName VARCHAR(75) null,
 486	createDate DATE null,
 487	modifiedDate DATE null,
 488	name STRING null,
 489	description STRING null,
 490	xml TEXT null
 491);
 492
 493create table DDMStorageLink (
 494	uuid_ VARCHAR(75) null,
 495	storageLinkId LONG not null primary key,
 496	classNameId LONG,
 497	classPK LONG,
 498	structureId LONG
 499);
 500
 501create table DDMStructure (
 502	uuid_ VARCHAR(75) null,
 503	structureId LONG not null primary key,
 504	groupId LONG,
 505	companyId LONG,
 506	userId LONG,
 507	userName VARCHAR(75) null,
 508	createDate DATE null,
 509	modifiedDate DATE null,
 510	parentStructureId LONG,
 511	classNameId LONG,
 512	structureKey VARCHAR(75) null,
 513	name STRING null,
 514	description STRING null,
 515	xsd TEXT null,
 516	storageType VARCHAR(75) null,
 517	type_ INTEGER
 518);
 519
 520create table DDMStructureLink (
 521	structureLinkId LONG not null primary key,
 522	classNameId LONG,
 523	classPK LONG,
 524	structureId LONG
 525);
 526
 527create table DDMTemplate (
 528	uuid_ VARCHAR(75) null,
 529	templateId LONG not null primary key,
 530	groupId LONG,
 531	companyId LONG,
 532	userId LONG,
 533	userName VARCHAR(75) null,
 534	createDate DATE null,
 535	modifiedDate DATE null,
 536	classNameId LONG,
 537	classPK LONG,
 538	templateKey VARCHAR(75) null,
 539	name STRING null,
 540	description STRING null,
 541	type_ VARCHAR(75) null,
 542	mode_ VARCHAR(75) null,
 543	language VARCHAR(75) null,
 544	script TEXT null,
 545	cacheable BOOLEAN,
 546	smallImage BOOLEAN,
 547	smallImageId LONG,
 548	smallImageURL VARCHAR(75) null
 549);
 550
 551create table DLContent (
 552	contentId LONG not null primary key,
 553	groupId LONG,
 554	companyId LONG,
 555	repositoryId LONG,
 556	path_ VARCHAR(255) null,
 557	version VARCHAR(75) null,
 558	data_ BLOB,
 559	size_ LONG
 560);
 561
 562create table DLFileEntry (
 563	uuid_ VARCHAR(75) null,
 564	fileEntryId LONG not null primary key,
 565	groupId LONG,
 566	companyId LONG,
 567	userId LONG,
 568	userName VARCHAR(75) null,
 569	createDate DATE null,
 570	modifiedDate DATE null,
 571	classNameId LONG,
 572	classPK LONG,
 573	repositoryId LONG,
 574	folderId LONG,
 575	treePath STRING null,
 576	name VARCHAR(255) null,
 577	extension VARCHAR(75) null,
 578	mimeType VARCHAR(75) null,
 579	title VARCHAR(255) null,
 580	description STRING null,
 581	extraSettings TEXT null,
 582	fileEntryTypeId LONG,
 583	version VARCHAR(75) null,
 584	size_ LONG,
 585	readCount INTEGER,
 586	smallImageId LONG,
 587	largeImageId LONG,
 588	custom1ImageId LONG,
 589	custom2ImageId LONG,
 590	manualCheckInRequired BOOLEAN
 591);
 592
 593create table DLFileEntryMetadata (
 594	uuid_ VARCHAR(75) null,
 595	fileEntryMetadataId LONG not null primary key,
 596	DDMStorageId LONG,
 597	DDMStructureId LONG,
 598	fileEntryTypeId LONG,
 599	fileEntryId LONG,
 600	fileVersionId LONG
 601);
 602
 603create table DLFileEntryType (
 604	uuid_ VARCHAR(75) null,
 605	fileEntryTypeId LONG not null primary key,
 606	groupId LONG,
 607	companyId LONG,
 608	userId LONG,
 609	userName VARCHAR(75) null,
 610	createDate DATE null,
 611	modifiedDate DATE null,
 612	fileEntryTypeKey VARCHAR(75) null,
 613	name STRING null,
 614	description STRING null
 615);
 616
 617create table DLFileEntryTypes_DDMStructures (
 618	structureId LONG not null,
 619	fileEntryTypeId LONG not null,
 620	primary key (structureId, fileEntryTypeId)
 621);
 622
 623create table DLFileEntryTypes_DLFolders (
 624	fileEntryTypeId LONG not null,
 625	folderId LONG not null,
 626	primary key (fileEntryTypeId, folderId)
 627);
 628
 629create table DLFileRank (
 630	fileRankId LONG not null primary key,
 631	groupId LONG,
 632	companyId LONG,
 633	userId LONG,
 634	createDate DATE null,
 635	fileEntryId LONG,
 636	active_ BOOLEAN
 637);
 638
 639create table DLFileShortcut (
 640	uuid_ VARCHAR(75) null,
 641	fileShortcutId LONG not null primary key,
 642	groupId LONG,
 643	companyId LONG,
 644	userId LONG,
 645	userName VARCHAR(75) null,
 646	createDate DATE null,
 647	modifiedDate DATE null,
 648	repositoryId LONG,
 649	folderId LONG,
 650	toFileEntryId LONG,
 651	treePath STRING null,
 652	active_ BOOLEAN,
 653	status INTEGER,
 654	statusByUserId LONG,
 655	statusByUserName VARCHAR(75) null,
 656	statusDate DATE null
 657);
 658
 659create table DLFileVersion (
 660	uuid_ VARCHAR(75) null,
 661	fileVersionId LONG not null primary key,
 662	groupId LONG,
 663	companyId LONG,
 664	userId LONG,
 665	userName VARCHAR(75) null,
 666	createDate DATE null,
 667	modifiedDate DATE null,
 668	repositoryId LONG,
 669	folderId LONG,
 670	fileEntryId LONG,
 671	treePath STRING null,
 672	extension VARCHAR(75) null,
 673	mimeType VARCHAR(75) null,
 674	title VARCHAR(255) null,
 675	description STRING null,
 676	changeLog VARCHAR(75) null,
 677	extraSettings TEXT null,
 678	fileEntryTypeId LONG,
 679	version VARCHAR(75) null,
 680	size_ LONG,
 681	checksum VARCHAR(75) null,
 682	status INTEGER,
 683	statusByUserId LONG,
 684	statusByUserName VARCHAR(75) null,
 685	statusDate DATE null
 686);
 687
 688create table DLFolder (
 689	uuid_ VARCHAR(75) null,
 690	folderId LONG not null primary key,
 691	groupId LONG,
 692	companyId LONG,
 693	userId LONG,
 694	userName VARCHAR(75) null,
 695	createDate DATE null,
 696	modifiedDate DATE null,
 697	repositoryId LONG,
 698	mountPoint BOOLEAN,
 699	parentFolderId LONG,
 700	treePath STRING null,
 701	name VARCHAR(100) null,
 702	description STRING null,
 703	lastPostDate DATE null,
 704	defaultFileEntryTypeId LONG,
 705	hidden_ BOOLEAN,
 706	overrideFileEntryTypes BOOLEAN,
 707	status INTEGER,
 708	statusByUserId LONG,
 709	statusByUserName VARCHAR(75) null,
 710	statusDate DATE null
 711);
 712
 713create table DLSyncEvent (
 714	syncEventId LONG not null primary key,
 715	modifiedTime LONG,
 716	event VARCHAR(75) null,
 717	type_ VARCHAR(75) null,
 718	typePK LONG
 719);
 720
 721create table EmailAddress (
 722	uuid_ VARCHAR(75) null,
 723	emailAddressId LONG not null primary key,
 724	companyId LONG,
 725	userId LONG,
 726	userName VARCHAR(75) null,
 727	createDate DATE null,
 728	modifiedDate DATE null,
 729	classNameId LONG,
 730	classPK LONG,
 731	address VARCHAR(75) null,
 732	typeId INTEGER,
 733	primary_ BOOLEAN
 734);
 735
 736create table ExpandoColumn (
 737	columnId LONG not null primary key,
 738	companyId LONG,
 739	tableId LONG,
 740	name VARCHAR(75) null,
 741	type_ INTEGER,
 742	defaultData STRING null,
 743	typeSettings TEXT null
 744);
 745
 746create table ExpandoRow (
 747	rowId_ LONG not null primary key,
 748	companyId LONG,
 749	modifiedDate DATE null,
 750	tableId LONG,
 751	classPK LONG
 752);
 753
 754create table ExpandoTable (
 755	tableId LONG not null primary key,
 756	companyId LONG,
 757	classNameId LONG,
 758	name VARCHAR(75) null
 759);
 760
 761create table ExpandoValue (
 762	valueId LONG not null primary key,
 763	companyId LONG,
 764	tableId LONG,
 765	columnId LONG,
 766	rowId_ LONG,
 767	classNameId LONG,
 768	classPK LONG,
 769	data_ STRING null
 770);
 771
 772create table Group_ (
 773	uuid_ VARCHAR(75) null,
 774	groupId LONG not null primary key,
 775	companyId LONG,
 776	creatorUserId LONG,
 777	classNameId LONG,
 778	classPK LONG,
 779	parentGroupId LONG,
 780	liveGroupId LONG,
 781	treePath STRING null,
 782	name VARCHAR(150) null,
 783	description STRING null,
 784	type_ INTEGER,
 785	typeSettings TEXT null,
 786	manualMembership BOOLEAN,
 787	membershipRestriction INTEGER,
 788	friendlyURL VARCHAR(255) null,
 789	site BOOLEAN,
 790	remoteStagingGroupCount INTEGER,
 791	active_ BOOLEAN
 792);
 793
 794create table Groups_Orgs (
 795	groupId LONG not null,
 796	organizationId LONG not null,
 797	primary key (groupId, organizationId)
 798);
 799
 800create table Groups_Roles (
 801	groupId LONG not null,
 802	roleId LONG not null,
 803	primary key (groupId, roleId)
 804);
 805
 806create table Groups_UserGroups (
 807	groupId LONG not null,
 808	userGroupId LONG not null,
 809	primary key (groupId, userGroupId)
 810);
 811
 812create table Image (
 813	imageId LONG not null primary key,
 814	modifiedDate DATE null,
 815	type_ VARCHAR(75) null,
 816	height INTEGER,
 817	width INTEGER,
 818	size_ INTEGER
 819);
 820
 821create table JournalArticle (
 822	uuid_ VARCHAR(75) null,
 823	id_ LONG not null primary key,
 824	resourcePrimKey LONG,
 825	groupId LONG,
 826	companyId LONG,
 827	userId LONG,
 828	userName VARCHAR(75) null,
 829	createDate DATE null,
 830	modifiedDate DATE null,
 831	folderId LONG,
 832	classNameId LONG,
 833	classPK LONG,
 834	treePath STRING null,
 835	articleId VARCHAR(75) null,
 836	version DOUBLE,
 837	title STRING null,
 838	urlTitle VARCHAR(150) null,
 839	description STRING null,
 840	content TEXT null,
 841	type_ VARCHAR(75) null,
 842	structureId VARCHAR(75) null,
 843	templateId VARCHAR(75) null,
 844	layoutUuid VARCHAR(75) null,
 845	displayDate DATE null,
 846	expirationDate DATE null,
 847	reviewDate DATE null,
 848	indexable BOOLEAN,
 849	smallImage BOOLEAN,
 850	smallImageId LONG,
 851	smallImageURL STRING null,
 852	status INTEGER,
 853	statusByUserId LONG,
 854	statusByUserName VARCHAR(75) null,
 855	statusDate DATE null
 856);
 857
 858create table JournalArticleImage (
 859	articleImageId LONG not null primary key,
 860	groupId LONG,
 861	articleId VARCHAR(75) null,
 862	version DOUBLE,
 863	elInstanceId VARCHAR(75) null,
 864	elName VARCHAR(75) null,
 865	languageId VARCHAR(75) null,
 866	tempImage BOOLEAN
 867);
 868
 869create table JournalArticleResource (
 870	uuid_ VARCHAR(75) null,
 871	resourcePrimKey LONG not null primary key,
 872	groupId LONG,
 873	articleId VARCHAR(75) null
 874);
 875
 876create table JournalContentSearch (
 877	contentSearchId LONG not null primary key,
 878	groupId LONG,
 879	companyId LONG,
 880	privateLayout BOOLEAN,
 881	layoutId LONG,
 882	portletId VARCHAR(200) null,
 883	articleId VARCHAR(75) null
 884);
 885
 886create table JournalFeed (
 887	uuid_ VARCHAR(75) null,
 888	id_ LONG not null primary key,
 889	groupId LONG,
 890	companyId LONG,
 891	userId LONG,
 892	userName VARCHAR(75) null,
 893	createDate DATE null,
 894	modifiedDate DATE null,
 895	feedId VARCHAR(75) null,
 896	name VARCHAR(75) null,
 897	description STRING null,
 898	type_ VARCHAR(75) null,
 899	structureId VARCHAR(75) null,
 900	templateId VARCHAR(75) null,
 901	rendererTemplateId VARCHAR(75) null,
 902	delta INTEGER,
 903	orderByCol VARCHAR(75) null,
 904	orderByType VARCHAR(75) null,
 905	targetLayoutFriendlyUrl VARCHAR(255) null,
 906	targetPortletId VARCHAR(75) null,
 907	contentField VARCHAR(75) null,
 908	feedFormat VARCHAR(75) null,
 909	feedVersion DOUBLE
 910);
 911
 912create table JournalFolder (
 913	uuid_ VARCHAR(75) null,
 914	folderId LONG not null primary key,
 915	groupId LONG,
 916	companyId LONG,
 917	userId LONG,
 918	userName VARCHAR(75) null,
 919	createDate DATE null,
 920	modifiedDate DATE null,
 921	parentFolderId LONG,
 922	treePath STRING null,
 923	name VARCHAR(100) null,
 924	description STRING null,
 925	status INTEGER,
 926	statusByUserId LONG,
 927	statusByUserName VARCHAR(75) null,
 928	statusDate DATE null
 929);
 930
 931create table Layout (
 932	uuid_ VARCHAR(75) null,
 933	plid LONG not null primary key,
 934	groupId LONG,
 935	companyId LONG,
 936	userId LONG,
 937	userName VARCHAR(75) null,
 938	createDate DATE null,
 939	modifiedDate DATE null,
 940	privateLayout BOOLEAN,
 941	layoutId LONG,
 942	parentLayoutId LONG,
 943	name STRING null,
 944	title STRING null,
 945	description STRING null,
 946	keywords STRING null,
 947	robots STRING null,
 948	type_ VARCHAR(75) null,
 949	typeSettings TEXT null,
 950	hidden_ BOOLEAN,
 951	friendlyURL VARCHAR(255) null,
 952	iconImage BOOLEAN,
 953	iconImageId LONG,
 954	themeId VARCHAR(75) null,
 955	colorSchemeId VARCHAR(75) null,
 956	wapThemeId VARCHAR(75) null,
 957	wapColorSchemeId VARCHAR(75) null,
 958	css TEXT null,
 959	priority INTEGER,
 960	layoutPrototypeUuid VARCHAR(75) null,
 961	layoutPrototypeLinkEnabled BOOLEAN,
 962	sourcePrototypeLayoutUuid VARCHAR(75) null
 963);
 964
 965create table LayoutBranch (
 966	LayoutBranchId LONG not null primary key,
 967	groupId LONG,
 968	companyId LONG,
 969	userId LONG,
 970	userName VARCHAR(75) null,
 971	layoutSetBranchId LONG,
 972	plid LONG,
 973	name VARCHAR(75) null,
 974	description STRING null,
 975	master BOOLEAN
 976);
 977
 978create table LayoutFriendlyURL (
 979	uuid_ VARCHAR(75) null,
 980	layoutFriendlyURLId LONG not null primary key,
 981	groupId LONG,
 982	companyId LONG,
 983	userId LONG,
 984	userName VARCHAR(75) null,
 985	createDate DATE null,
 986	modifiedDate DATE null,
 987	plid LONG,
 988	privateLayout BOOLEAN,
 989	friendlyURL VARCHAR(255) null,
 990	languageId VARCHAR(75) null
 991);
 992
 993create table LayoutPrototype (
 994	uuid_ VARCHAR(75) null,
 995	layoutPrototypeId LONG not null primary key,
 996	companyId LONG,
 997	userId LONG,
 998	userName VARCHAR(75) null,
 999	createDate DATE null,
1000	modifiedDate DATE null,
1001	name STRING null,
1002	description STRING null,
1003	settings_ STRING null,
1004	active_ BOOLEAN
1005);
1006
1007create table LayoutRevision (
1008	layoutRevisionId LONG not null primary key,
1009	groupId LONG,
1010	companyId LONG,
1011	userId LONG,
1012	userName VARCHAR(75) null,
1013	createDate DATE null,
1014	modifiedDate DATE null,
1015	layoutSetBranchId LONG,
1016	layoutBranchId LONG,
1017	parentLayoutRevisionId LONG,
1018	head BOOLEAN,
1019	major BOOLEAN,
1020	plid LONG,
1021	privateLayout BOOLEAN,
1022	name STRING null,
1023	title STRING null,
1024	description STRING null,
1025	keywords STRING null,
1026	robots STRING null,
1027	typeSettings TEXT null,
1028	iconImage BOOLEAN,
1029	iconImageId LONG,
1030	themeId VARCHAR(75) null,
1031	colorSchemeId VARCHAR(75) null,
1032	wapThemeId VARCHAR(75) null,
1033	wapColorSchemeId VARCHAR(75) null,
1034	css TEXT null,
1035	status INTEGER,
1036	statusByUserId LONG,
1037	statusByUserName VARCHAR(75) null,
1038	statusDate DATE null
1039);
1040
1041create table LayoutSet (
1042	layoutSetId LONG not null primary key,
1043	groupId LONG,
1044	companyId LONG,
1045	createDate DATE null,
1046	modifiedDate DATE null,
1047	privateLayout BOOLEAN,
1048	logo BOOLEAN,
1049	logoId LONG,
1050	themeId VARCHAR(75) null,
1051	colorSchemeId VARCHAR(75) null,
1052	wapThemeId VARCHAR(75) null,
1053	wapColorSchemeId VARCHAR(75) null,
1054	css TEXT null,
1055	pageCount INTEGER,
1056	settings_ TEXT null,
1057	layoutSetPrototypeUuid VARCHAR(75) null,
1058	layoutSetPrototypeLinkEnabled BOOLEAN
1059);
1060
1061create table LayoutSetBranch (
1062	layoutSetBranchId LONG not null primary key,
1063	groupId LONG,
1064	companyId LONG,
1065	userId LONG,
1066	userName VARCHAR(75) null,
1067	createDate DATE null,
1068	modifiedDate DATE null,
1069	privateLayout BOOLEAN,
1070	name VARCHAR(75) null,
1071	description STRING null,
1072	master BOOLEAN,
1073	logo BOOLEAN,
1074	logoId LONG,
1075	themeId VARCHAR(75) null,
1076	colorSchemeId VARCHAR(75) null,
1077	wapThemeId VARCHAR(75) null,
1078	wapColorSchemeId VARCHAR(75) null,
1079	css TEXT null,
1080	settings_ TEXT null,
1081	layoutSetPrototypeUuid VARCHAR(75) null,
1082	layoutSetPrototypeLinkEnabled BOOLEAN
1083);
1084
1085create table LayoutSetPrototype (
1086	uuid_ VARCHAR(75) null,
1087	layoutSetPrototypeId LONG not null primary key,
1088	companyId LONG,
1089	userId LONG,
1090	userName VARCHAR(75) null,
1091	createDate DATE null,
1092	modifiedDate DATE null,
1093	name STRING null,
1094	description STRING null,
1095	settings_ STRING null,
1096	active_ BOOLEAN
1097);
1098
1099create table ListType (
1100	listTypeId INTEGER not null primary key,
1101	name VARCHAR(75) null,
1102	type_ VARCHAR(75) null
1103);
1104
1105create table Lock_ (
1106	uuid_ VARCHAR(75) null,
1107	lockId LONG not null primary key,
1108	companyId LONG,
1109	userId LONG,
1110	userName VARCHAR(75) null,
1111	createDate DATE null,
1112	className VARCHAR(75) null,
1113	key_ VARCHAR(200) null,
1114	owner VARCHAR(255) null,
1115	inheritable BOOLEAN,
1116	expirationDate DATE null
1117);
1118
1119create table MBBan (
1120	uuid_ VARCHAR(75) null,
1121	banId LONG not null primary key,
1122	groupId LONG,
1123	companyId LONG,
1124	userId LONG,
1125	userName VARCHAR(75) null,
1126	createDate DATE null,
1127	modifiedDate DATE null,
1128	banUserId LONG
1129);
1130
1131create table MBCategory (
1132	uuid_ VARCHAR(75) null,
1133	categoryId LONG not null primary key,
1134	groupId LONG,
1135	companyId LONG,
1136	userId LONG,
1137	userName VARCHAR(75) null,
1138	createDate DATE null,
1139	modifiedDate DATE null,
1140	parentCategoryId LONG,
1141	name VARCHAR(75) null,
1142	description STRING null,
1143	displayStyle VARCHAR(75) null,
1144	threadCount INTEGER,
1145	messageCount INTEGER,
1146	lastPostDate DATE null,
1147	status INTEGER,
1148	statusByUserId LONG,
1149	statusByUserName VARCHAR(75) null,
1150	statusDate DATE null
1151);
1152
1153create table MBDiscussion (
1154	uuid_ VARCHAR(75) null,
1155	discussionId LONG not null primary key,
1156	groupId LONG,
1157	companyId LONG,
1158	userId LONG,
1159	userName VARCHAR(75) null,
1160	createDate DATE null,
1161	modifiedDate DATE null,
1162	classNameId LONG,
1163	classPK LONG,
1164	threadId LONG
1165);
1166
1167create table MBMailingList (
1168	uuid_ VARCHAR(75) null,
1169	mailingListId LONG not null primary key,
1170	groupId LONG,
1171	companyId LONG,
1172	userId LONG,
1173	userName VARCHAR(75) null,
1174	createDate DATE null,
1175	modifiedDate DATE null,
1176	categoryId LONG,
1177	emailAddress VARCHAR(75) null,
1178	inProtocol VARCHAR(75) null,
1179	inServerName VARCHAR(75) null,
1180	inServerPort INTEGER,
1181	inUseSSL BOOLEAN,
1182	inUserName VARCHAR(75) null,
1183	inPassword VARCHAR(75) null,
1184	inReadInterval INTEGER,
1185	outEmailAddress VARCHAR(75) null,
1186	outCustom BOOLEAN,
1187	outServerName VARCHAR(75) null,
1188	outServerPort INTEGER,
1189	outUseSSL BOOLEAN,
1190	outUserName VARCHAR(75) null,
1191	outPassword VARCHAR(75) null,
1192	allowAnonymous BOOLEAN,
1193	active_ BOOLEAN
1194);
1195
1196create table MBMessage (
1197	uuid_ VARCHAR(75) null,
1198	messageId LONG not null primary key,
1199	groupId LONG,
1200	companyId LONG,
1201	userId LONG,
1202	userName VARCHAR(75) null,
1203	createDate DATE null,
1204	modifiedDate DATE null,
1205	classNameId LONG,
1206	classPK LONG,
1207	categoryId LONG,
1208	threadId LONG,
1209	rootMessageId LONG,
1210	parentMessageId LONG,
1211	subject VARCHAR(75) null,
1212	body TEXT null,
1213	format VARCHAR(75) null,
1214	anonymous BOOLEAN,
1215	priority DOUBLE,
1216	allowPingbacks BOOLEAN,
1217	answer BOOLEAN,
1218	status INTEGER,
1219	statusByUserId LONG,
1220	statusByUserName VARCHAR(75) null,
1221	statusDate DATE null
1222);
1223
1224create table MBStatsUser (
1225	statsUserId LONG not null primary key,
1226	groupId LONG,
1227	userId LONG,
1228	messageCount INTEGER,
1229	lastPostDate DATE null
1230);
1231
1232create table MBThread (
1233	uuid_ VARCHAR(75) null,
1234	threadId LONG not null primary key,
1235	groupId LONG,
1236	companyId LONG,
1237	userId LONG,
1238	userName VARCHAR(75) null,
1239	createDate DATE null,
1240	modifiedDate DATE null,
1241	categoryId LONG,
1242	rootMessageId LONG,
1243	rootMessageUserId LONG,
1244	messageCount INTEGER,
1245	viewCount INTEGER,
1246	lastPostByUserId LONG,
1247	lastPostDate DATE null,
1248	priority DOUBLE,
1249	question BOOLEAN,
1250	status INTEGER,
1251	statusByUserId LONG,
1252	statusByUserName VARCHAR(75) null,
1253	statusDate DATE null
1254);
1255
1256create table MBThreadFlag (
1257	uuid_ VARCHAR(75) null,
1258	threadFlagId LONG not null primary key,
1259	groupId LONG,
1260	companyId LONG,
1261	userId LONG,
1262	userName VARCHAR(75) null,
1263	createDate DATE null,
1264	modifiedDate DATE null,
1265	threadId LONG
1266);
1267
1268create table MDRAction (
1269	uuid_ VARCHAR(75) null,
1270	actionId LONG not null primary key,
1271	groupId LONG,
1272	companyId LONG,
1273	userId LONG,
1274	userName VARCHAR(75) null,
1275	createDate DATE null,
1276	modifiedDate DATE null,
1277	classNameId LONG,
1278	classPK LONG,
1279	ruleGroupInstanceId LONG,
1280	name STRING null,
1281	description STRING null,
1282	type_ VARCHAR(255) null,
1283	typeSettings TEXT null
1284);
1285
1286create table MDRRule (
1287	uuid_ VARCHAR(75) null,
1288	ruleId LONG not null primary key,
1289	groupId LONG,
1290	companyId LONG,
1291	userId LONG,
1292	userName VARCHAR(75) null,
1293	createDate DATE null,
1294	modifiedDate DATE null,
1295	ruleGroupId LONG,
1296	name STRING null,
1297	description STRING null,
1298	type_ VARCHAR(255) null,
1299	typeSettings TEXT null
1300);
1301
1302create table MDRRuleGroup (
1303	uuid_ VARCHAR(75) null,
1304	ruleGroupId LONG not null primary key,
1305	groupId LONG,
1306	companyId LONG,
1307	userId LONG,
1308	userName VARCHAR(75) null,
1309	createDate DATE null,
1310	modifiedDate DATE null,
1311	name STRING null,
1312	description STRING null
1313);
1314
1315create table MDRRuleGroupInstance (
1316	uuid_ VARCHAR(75) null,
1317	ruleGroupInstanceId LONG not null primary key,
1318	groupId LONG,
1319	companyId LONG,
1320	userId LONG,
1321	userName VARCHAR(75) null,
1322	createDate DATE null,
1323	modifiedDate DATE null,
1324	classNameId LONG,
1325	classPK LONG,
1326	ruleGroupId LONG,
1327	priority INTEGER
1328);
1329
1330create table MembershipRequest (
1331	membershipRequestId LONG not null primary key,
1332	groupId LONG,
1333	companyId LONG,
1334	userId LONG,
1335	createDate DATE null,
1336	comments STRING null,
1337	replyComments STRING null,
1338	replyDate DATE null,
1339	replierUserId LONG,
1340	statusId INTEGER
1341);
1342
1343create table Organization_ (
1344	uuid_ VARCHAR(75) null,
1345	organizationId LONG not null primary key,
1346	companyId LONG,
1347	userId LONG,
1348	userName VARCHAR(75) null,
1349	createDate DATE null,
1350	modifiedDate DATE null,
1351	parentOrganizationId LONG,
1352	treePath STRING null,
1353	name VARCHAR(100) null,
1354	type_ VARCHAR(75) null,
1355	recursable BOOLEAN,
1356	regionId LONG,
1357	countryId LONG,
1358	statusId INTEGER,
1359	comments STRING null
1360);
1361
1362create table OrgGroupRole (
1363	organizationId LONG not null,
1364	groupId LONG not null,
1365	roleId LONG not null,
1366	primary key (organizationId, groupId, roleId)
1367);
1368
1369create table OrgLabor (
1370	orgLaborId LONG not null primary key,
1371	organizationId LONG,
1372	typeId INTEGER,
1373	sunOpen INTEGER,
1374	sunClose INTEGER,
1375	monOpen INTEGER,
1376	monClose INTEGER,
1377	tueOpen INTEGER,
1378	tueClose INTEGER,
1379	wedOpen INTEGER,
1380	wedClose INTEGER,
1381	thuOpen INTEGER,
1382	thuClose INTEGER,
1383	friOpen INTEGER,
1384	friClose INTEGER,
1385	satOpen INTEGER,
1386	satClose INTEGER
1387);
1388
1389create table PasswordPolicy (
1390	uuid_ VARCHAR(75) null,
1391	passwordPolicyId LONG not null primary key,
1392	companyId LONG,
1393	userId LONG,
1394	userName VARCHAR(75) null,
1395	createDate DATE null,
1396	modifiedDate DATE null,
1397	defaultPolicy BOOLEAN,
1398	name VARCHAR(75) null,
1399	description STRING null,
1400	changeable BOOLEAN,
1401	changeRequired BOOLEAN,
1402	minAge LONG,
1403	checkSyntax BOOLEAN,
1404	allowDictionaryWords BOOLEAN,
1405	minAlphanumeric INTEGER,
1406	minLength INTEGER,
1407	minLowerCase INTEGER,
1408	minNumbers INTEGER,
1409	minSymbols INTEGER,
1410	minUpperCase INTEGER,
1411	regex VARCHAR(75) null,
1412	history BOOLEAN,
1413	historyCount INTEGER,
1414	expireable BOOLEAN,
1415	maxAge LONG,
1416	warningTime LONG,
1417	graceLimit INTEGER,
1418	lockout BOOLEAN,
1419	maxFailure INTEGER,
1420	lockoutDuration LONG,
1421	requireUnlock BOOLEAN,
1422	resetFailureCount LONG,
1423	resetTicketMaxAge LONG
1424);
1425
1426create table PasswordPolicyRel (
1427	passwordPolicyRelId LONG not null primary key,
1428	passwordPolicyId LONG,
1429	classNameId LONG,
1430	classPK LONG
1431);
1432
1433create table PasswordTracker (
1434	passwordTrackerId LONG not null primary key,
1435	userId LONG,
1436	createDate DATE null,
1437	password_ VARCHAR(75) null
1438);
1439
1440create table Phone (
1441	uuid_ VARCHAR(75) null,
1442	phoneId LONG not null primary key,
1443	companyId LONG,
1444	userId LONG,
1445	userName VARCHAR(75) null,
1446	createDate DATE null,
1447	modifiedDate DATE null,
1448	classNameId LONG,
1449	classPK LONG,
1450	number_ VARCHAR(75) null,
1451	extension VARCHAR(75) null,
1452	typeId INTEGER,
1453	primary_ BOOLEAN
1454);
1455
1456create table PluginSetting (
1457	pluginSettingId LONG not null primary key,
1458	companyId LONG,
1459	pluginId VARCHAR(75) null,
1460	pluginType VARCHAR(75) null,
1461	roles STRING null,
1462	active_ BOOLEAN
1463);
1464
1465create table PollsChoice (
1466	uuid_ VARCHAR(75) null,
1467	choiceId LONG not null primary key,
1468	groupId LONG,
1469	companyId LONG,
1470	userId LONG,
1471	userName VARCHAR(75) null,
1472	createDate DATE null,
1473	modifiedDate DATE null,
1474	questionId LONG,
1475	name VARCHAR(75) null,
1476	description STRING null
1477);
1478
1479create table PollsQuestion (
1480	uuid_ VARCHAR(75) null,
1481	questionId LONG not null primary key,
1482	groupId LONG,
1483	companyId LONG,
1484	userId LONG,
1485	userName VARCHAR(75) null,
1486	createDate DATE null,
1487	modifiedDate DATE null,
1488	title STRING null,
1489	description STRING null,
1490	expirationDate DATE null,
1491	lastVoteDate DATE null
1492);
1493
1494create table PollsVote (
1495	uuid_ VARCHAR(75) null,
1496	voteId LONG not null primary key,
1497	groupId LONG,
1498	companyId LONG,
1499	userId LONG,
1500	userName VARCHAR(75) null,
1501	createDate DATE null,
1502	modifiedDate DATE null,
1503	questionId LONG,
1504	choiceId LONG,
1505	voteDate DATE null
1506);
1507
1508create table PortalPreferences (
1509	portalPreferencesId LONG not null primary key,
1510	ownerId LONG,
1511	ownerType INTEGER,
1512	preferences TEXT null
1513);
1514
1515create table Portlet (
1516	id_ LONG not null primary key,
1517	companyId LONG,
1518	portletId VARCHAR(200) null,
1519	roles STRING null,
1520	active_ BOOLEAN
1521);
1522
1523create table PortletItem (
1524	portletItemId LONG not null primary key,
1525	groupId LONG,
1526	companyId LONG,
1527	userId LONG,
1528	userName VARCHAR(75) null,
1529	createDate DATE null,
1530	modifiedDate DATE null,
1531	name VARCHAR(75) null,
1532	portletId VARCHAR(200) null,
1533	classNameId LONG
1534);
1535
1536create table PortletPreferences (
1537	portletPreferencesId LONG not null primary key,
1538	ownerId LONG,
1539	ownerType INTEGER,
1540	plid LONG,
1541	portletId VARCHAR(200) null,
1542	preferences TEXT null
1543);
1544
1545create table RatingsEntry (
1546	entryId LONG not null primary key,
1547	companyId LONG,
1548	userId LONG,
1549	userName VARCHAR(75) null,
1550	createDate DATE null,
1551	modifiedDate DATE null,
1552	classNameId LONG,
1553	classPK LONG,
1554	score DOUBLE
1555);
1556
1557create table RatingsStats (
1558	statsId LONG not null primary key,
1559	classNameId LONG,
1560	classPK LONG,
1561	totalEntries INTEGER,
1562	totalScore DOUBLE,
1563	averageScore DOUBLE
1564);
1565
1566create table Region (
1567	regionId LONG not null primary key,
1568	countryId LONG,
1569	regionCode VARCHAR(75) null,
1570	name VARCHAR(75) null,
1571	active_ BOOLEAN
1572);
1573
1574create table Release_ (
1575	releaseId LONG not null primary key,
1576	createDate DATE null,
1577	modifiedDate DATE null,
1578	servletContextName VARCHAR(75) null,
1579	buildNumber INTEGER,
1580	buildDate DATE null,
1581	verified BOOLEAN,
1582	state_ INTEGER,
1583	testString VARCHAR(1024) null
1584);
1585
1586create table Repository (
1587	uuid_ VARCHAR(75) null,
1588	repositoryId LONG not null primary key,
1589	groupId LONG,
1590	companyId LONG,
1591	userId LONG,
1592	userName VARCHAR(75) null,
1593	createDate DATE null,
1594	modifiedDate DATE null,
1595	classNameId LONG,
1596	name VARCHAR(75) null,
1597	description STRING null,
1598	portletId VARCHAR(200) null,
1599	typeSettings TEXT null,
1600	dlFolderId LONG
1601);
1602
1603create table RepositoryEntry (
1604	uuid_ VARCHAR(75) null,
1605	repositoryEntryId LONG not null primary key,
1606	groupId LONG,
1607	companyId LONG,
1608	userId LONG,
1609	userName VARCHAR(75) null,
1610	createDate DATE null,
1611	modifiedDate DATE null,
1612	repositoryId LONG,
1613	mappedId VARCHAR(75) null,
1614	manualCheckInRequired BOOLEAN
1615);
1616
1617create table ResourceAction (
1618	resourceActionId LONG not null primary key,
1619	name VARCHAR(255) null,
1620	actionId VARCHAR(75) null,
1621	bitwiseValue LONG
1622);
1623
1624create table ResourceBlock (
1625	resourceBlockId LONG not null primary key,
1626	companyId LONG,
1627	groupId LONG,
1628	name VARCHAR(75) null,
1629	permissionsHash VARCHAR(75) null,
1630	referenceCount LONG
1631);
1632
1633create table ResourceBlockPermission (
1634	resourceBlockPermissionId LONG not null primary key,
1635	resourceBlockId LONG,
1636	roleId LONG,
1637	actionIds LONG
1638);
1639
1640create table ResourcePermission (
1641	resourcePermissionId LONG not null primary key,
1642	companyId LONG,
1643	name VARCHAR(255) null,
1644	scope INTEGER,
1645	primKey VARCHAR(255) null,
1646	roleId LONG,
1647	ownerId LONG,
1648	actionIds LONG
1649);
1650
1651create table ResourceTypePermission (
1652	resourceTypePermissionId LONG not null primary key,
1653	companyId LONG,
1654	groupId LONG,
1655	name VARCHAR(75) null,
1656	roleId LONG,
1657	actionIds LONG
1658);
1659
1660create table Role_ (
1661	uuid_ VARCHAR(75) null,
1662	roleId LONG not null primary key,
1663	companyId LONG,
1664	userId LONG,
1665	userName VARCHAR(75) null,
1666	createDate DATE null,
1667	modifiedDate DATE null,
1668	classNameId LONG,
1669	classPK LONG,
1670	name VARCHAR(75) null,
1671	title STRING null,
1672	description STRING null,
1673	type_ INTEGER,
1674	subtype VARCHAR(75) null
1675);
1676
1677create table SCFrameworkVersi_SCProductVers (
1678	frameworkVersionId LONG not null,
1679	productVersionId LONG not null,
1680	primary key (frameworkVersionId, productVersionId)
1681);
1682
1683create table SCFrameworkVersion (
1684	frameworkVersionId LONG not null primary key,
1685	groupId LONG,
1686	companyId LONG,
1687	userId LONG,
1688	userName VARCHAR(75) null,
1689	createDate DATE null,
1690	modifiedDate DATE null,
1691	name VARCHAR(75) null,
1692	url STRING null,
1693	active_ BOOLEAN,
1694	priority INTEGER
1695);
1696
1697create table SCLicense (
1698	licenseId LONG not null primary key,
1699	name VARCHAR(75) null,
1700	url STRING null,
1701	openSource BOOLEAN,
1702	active_ BOOLEAN,
1703	recommended BOOLEAN
1704);
1705
1706create table SCLicenses_SCProductEntries (
1707	licenseId LONG not null,
1708	productEntryId LONG not null,
1709	primary key (licenseId, productEntryId)
1710);
1711
1712create table SCProductEntry (
1713	productEntryId LONG not null primary key,
1714	groupId LONG,
1715	companyId LONG,
1716	userId LONG,
1717	userName VARCHAR(75) null,
1718	createDate DATE null,
1719	modifiedDate DATE null,
1720	name VARCHAR(75) null,
1721	type_ VARCHAR(75) null,
1722	tags VARCHAR(255) null,
1723	shortDescription STRING null,
1724	longDescription STRING null,
1725	pageURL STRING null,
1726	author VARCHAR(75) null,
1727	repoGroupId VARCHAR(75) null,
1728	repoArtifactId VARCHAR(75) null
1729);
1730
1731create table SCProductScreenshot (
1732	productScreenshotId LONG not null primary key,
1733	companyId LONG,
1734	groupId LONG,
1735	productEntryId LONG,
1736	thumbnailId LONG,
1737	fullImageId LONG,
1738	priority INTEGER
1739);
1740
1741create table SCProductVersion (
1742	productVersionId LONG not null primary key,
1743	companyId LONG,
1744	userId LONG,
1745	userName VARCHAR(75) null,
1746	createDate DATE null,
1747	modifiedDate DATE null,
1748	productEntryId LONG,
1749	version VARCHAR(75) null,
1750	changeLog STRING null,
1751	downloadPageURL STRING null,
1752	directDownloadURL VARCHAR(2000) null,
1753	repoStoreArtifact BOOLEAN
1754);
1755
1756create table ServiceComponent (
1757	serviceComponentId LONG not null primary key,
1758	buildNamespace VARCHAR(75) null,
1759	buildNumber LONG,
1760	buildDate LONG,
1761	data_ TEXT null
1762);
1763
1764create table Shard (
1765	shardId LONG not null primary key,
1766	classNameId LONG,
1767	classPK LONG,
1768	name VARCHAR(75) null
1769);
1770
1771create table ShoppingCart (
1772	cartId LONG not null primary key,
1773	groupId LONG,
1774	companyId LONG,
1775	userId LONG,
1776	userName VARCHAR(75) null,
1777	createDate DATE null,
1778	modifiedDate DATE null,
1779	itemIds STRING null,
1780	couponCodes VARCHAR(75) null,
1781	altShipping INTEGER,
1782	insure BOOLEAN
1783);
1784
1785create table ShoppingCategory (
1786	categoryId LONG not null primary key,
1787	groupId LONG,
1788	companyId LONG,
1789	userId LONG,
1790	userName VARCHAR(75) null,
1791	createDate DATE null,
1792	modifiedDate DATE null,
1793	parentCategoryId LONG,
1794	name VARCHAR(75) null,
1795	description STRING null
1796);
1797
1798create table ShoppingCoupon (
1799	couponId LONG not null primary key,
1800	groupId LONG,
1801	companyId LONG,
1802	userId LONG,
1803	userName VARCHAR(75) null,
1804	createDate DATE null,
1805	modifiedDate DATE null,
1806	code_ VARCHAR(75) null,
1807	name VARCHAR(75) null,
1808	description STRING null,
1809	startDate DATE null,
1810	endDate DATE null,
1811	active_ BOOLEAN,
1812	limitCategories STRING null,
1813	limitSkus STRING null,
1814	minOrder DOUBLE,
1815	discount DOUBLE,
1816	discountType VARCHAR(75) null
1817);
1818
1819create table ShoppingItem (
1820	itemId LONG not null primary key,
1821	groupId LONG,
1822	companyId LONG,
1823	userId LONG,
1824	userName VARCHAR(75) null,
1825	createDate DATE null,
1826	modifiedDate DATE null,
1827	categoryId LONG,
1828	sku VARCHAR(75) null,
1829	name VARCHAR(200) null,
1830	description STRING null,
1831	properties STRING null,
1832	fields_ BOOLEAN,
1833	fieldsQuantities STRING null,
1834	minQuantity INTEGER,
1835	maxQuantity INTEGER,
1836	price DOUBLE,
1837	discount DOUBLE,
1838	taxable BOOLEAN,
1839	shipping DOUBLE,
1840	useShippingFormula BOOLEAN,
1841	requiresShipping BOOLEAN,
1842	stockQuantity INTEGER,
1843	featured_ BOOLEAN,
1844	sale_ BOOLEAN,
1845	smallImage BOOLEAN,
1846	smallImageId LONG,
1847	smallImageURL STRING null,
1848	mediumImage BOOLEAN,
1849	mediumImageId LONG,
1850	mediumImageURL STRING null,
1851	largeImage BOOLEAN,
1852	largeImageId LONG,
1853	largeImageURL STRING null
1854);
1855
1856create table ShoppingItemField (
1857	itemFieldId LONG not null primary key,
1858	itemId LONG,
1859	name VARCHAR(75) null,
1860	values_ STRING null,
1861	description STRING null
1862);
1863
1864create table ShoppingItemPrice (
1865	itemPriceId LONG not null primary key,
1866	itemId LONG,
1867	minQuantity INTEGER,
1868	maxQuantity INTEGER,
1869	price DOUBLE,
1870	discount DOUBLE,
1871	taxable BOOLEAN,
1872	shipping DOUBLE,
1873	useShippingFormula BOOLEAN,
1874	status INTEGER
1875);
1876
1877create table ShoppingOrder (
1878	orderId LONG not null primary key,
1879	groupId LONG,
1880	companyId LONG,
1881	userId LONG,
1882	userName VARCHAR(75) null,
1883	createDate DATE null,
1884	modifiedDate DATE null,
1885	number_ VARCHAR(75) null,
1886	tax DOUBLE,
1887	shipping DOUBLE,
1888	altShipping VARCHAR(75) null,
1889	requiresShipping BOOLEAN,
1890	insure BOOLEAN,
1891	insurance DOUBLE,
1892	couponCodes VARCHAR(75) null,
1893	couponDiscount DOUBLE,
1894	billingFirstName VARCHAR(75) null,
1895	billingLastName VARCHAR(75) null,
1896	billingEmailAddress VARCHAR(75) null,
1897	billingCompany VARCHAR(75) null,
1898	billingStreet VARCHAR(75) null,
1899	billingCity VARCHAR(75) null,
1900	billingState VARCHAR(75) null,
1901	billingZip VARCHAR(75) null,
1902	billingCountry VARCHAR(75) null,
1903	billingPhone VARCHAR(75) null,
1904	shipToBilling BOOLEAN,
1905	shippingFirstName VARCHAR(75) null,
1906	shippingLastName VARCHAR(75) null,
1907	shippingEmailAddress VARCHAR(75) null,
1908	shippingCompany VARCHAR(75) null,
1909	shippingStreet VARCHAR(75) null,
1910	shippingCity VARCHAR(75) null,
1911	shippingState VARCHAR(75) null,
1912	shippingZip VARCHAR(75) null,
1913	shippingCountry VARCHAR(75) null,
1914	shippingPhone VARCHAR(75) null,
1915	ccName VARCHAR(75) null,
1916	ccType VARCHAR(75) null,
1917	ccNumber VARCHAR(75) null,
1918	ccExpMonth INTEGER,
1919	ccExpYear INTEGER,
1920	ccVerNumber VARCHAR(75) null,
1921	comments STRING null,
1922	ppTxnId VARCHAR(75) null,
1923	ppPaymentStatus VARCHAR(75) null,
1924	ppPaymentGross DOUBLE,
1925	ppReceiverEmail VARCHAR(75) null,
1926	ppPayerEmail VARCHAR(75) null,
1927	sendOrderEmail BOOLEAN,
1928	sendShippingEmail BOOLEAN
1929);
1930
1931create table ShoppingOrderItem (
1932	orderItemId LONG not null primary key,
1933	orderId LONG,
1934	itemId VARCHAR(75) null,
1935	sku VARCHAR(75) null,
1936	name VARCHAR(200) null,
1937	description STRING null,
1938	properties STRING null,
1939	price DOUBLE,
1940	quantity INTEGER,
1941	shippedDate DATE null
1942);
1943
1944create table SocialActivity (
1945	activityId LONG not null primary key,
1946	groupId LONG,
1947	companyId LONG,
1948	userId LONG,
1949	createDate LONG,
1950	activitySetId LONG,
1951	mirrorActivityId LONG,
1952	classNameId LONG,
1953	classPK LONG,
1954	parentClassNameId LONG,
1955	parentClassPK LONG,
1956	type_ INTEGER,
1957	extraData STRING null,
1958	receiverUserId LONG
1959);
1960
1961create table SocialActivityAchievement (
1962	activityAchievementId LONG not null primary key,
1963	groupId LONG,
1964	companyId LONG,
1965	userId LONG,
1966	createDate LONG,
1967	name VARCHAR(75) null,
1968	firstInGroup BOOLEAN
1969);
1970
1971create table SocialActivityCounter (
1972	activityCounterId LONG not null primary key,
1973	groupId LONG,
1974	companyId LONG,
1975	classNameId LONG,
1976	classPK LONG,
1977	name VARCHAR(75) null,
1978	ownerType INTEGER,
1979	currentValue INTEGER,
1980	totalValue INTEGER,
1981	graceValue INTEGER,
1982	startPeriod INTEGER,
1983	endPeriod INTEGER,
1984	active_ BOOLEAN
1985);
1986
1987create table SocialActivityLimit (
1988	activityLimitId LONG not null primary key,
1989	groupId LONG,
1990	companyId LONG,
1991	userId LONG,
1992	classNameId LONG,
1993	classPK LONG,
1994	activityType INTEGER,
1995	activityCounterName VARCHAR(75) null,
1996	value VARCHAR(75) null
1997);
1998
1999create table SocialActivitySet (
2000	activitySetId LONG not null primary key,
2001	groupId LONG,
2002	companyId LONG,
2003	userId LONG,
2004	createDate LONG,
2005	modifiedDate LONG,
2006	classNameId LONG,
2007	classPK LONG,
2008	type_ INTEGER,
2009	extraData STRING null,
2010	activityCount INTEGER
2011);
2012
2013create table SocialActivitySetting (
2014	activitySettingId LONG not null primary key,
2015	groupId LONG,
2016	companyId LONG,
2017	classNameId LONG,
2018	activityType INTEGER,
2019	name VARCHAR(75) null,
2020	value VARCHAR(1024) null
2021);
2022
2023create table SocialRelation (
2024	uuid_ VARCHAR(75) null,
2025	relationId LONG not null primary key,
2026	companyId LONG,
2027	createDate LONG,
2028	userId1 LONG,
2029	userId2 LONG,
2030	type_ INTEGER
2031);
2032
2033create table SocialRequest (
2034	uuid_ VARCHAR(75) null,
2035	requestId LONG not null primary key,
2036	groupId LONG,
2037	companyId LONG,
2038	userId LONG,
2039	createDate LONG,
2040	modifiedDate LONG,
2041	classNameId LONG,
2042	classPK LONG,
2043	type_ INTEGER,
2044	extraData STRING null,
2045	receiverUserId LONG,
2046	status INTEGER
2047);
2048
2049create table Subscription (
2050	subscriptionId LONG not null primary key,
2051	companyId LONG,
2052	userId LONG,
2053	userName VARCHAR(75) null,
2054	createDate DATE null,
2055	modifiedDate DATE null,
2056	classNameId LONG,
2057	classPK LONG,
2058	frequency VARCHAR(75) null
2059);
2060
2061create table SystemEvent (
2062	systemEventId LONG not null primary key,
2063	groupId LONG,
2064	companyId LONG,
2065	userId LONG,
2066	userName VARCHAR(75) null,
2067	createDate DATE null,
2068	classNameId LONG,
2069	classPK LONG,
2070	classUuid VARCHAR(75) null,
2071	referrerClassNameId LONG,
2072	parentSystemEventId LONG,
2073	systemEventSetKey LONG,
2074	type_ INTEGER,
2075	extraData TEXT null
2076);
2077
2078create table Team (
2079	teamId LONG not null primary key,
2080	companyId LONG,
2081	userId LONG,
2082	userName VARCHAR(75) null,
2083	createDate DATE null,
2084	modifiedDate DATE null,
2085	groupId LONG,
2086	name VARCHAR(75) null,
2087	description STRING null
2088);
2089
2090create table Ticket (
2091	ticketId LONG not null primary key,
2092	companyId LONG,
2093	createDate DATE null,
2094	classNameId LONG,
2095	classPK LONG,
2096	key_ VARCHAR(75) null,
2097	type_ INTEGER,
2098	extraInfo TEXT null,
2099	expirationDate DATE null
2100);
2101
2102create table TrashEntry (
2103	entryId LONG not null primary key,
2104	groupId LONG,
2105	companyId LONG,
2106	userId LONG,
2107	userName VARCHAR(75) null,
2108	createDate DATE null,
2109	classNameId LONG,
2110	classPK LONG,
2111	systemEventSetKey LONG,
2112	typeSettings TEXT null,
2113	status INTEGER
2114);
2115
2116create table TrashVersion (
2117	versionId LONG not null primary key,
2118	entryId LONG,
2119	classNameId LONG,
2120	classPK LONG,
2121	status INTEGER
2122);
2123
2124create table UserNotificationDelivery (
2125	userNotificationDeliveryId LONG not null primary key,
2126	companyId LONG,
2127	userId LONG,
2128	portletId VARCHAR(200) null,
2129	classNameId LONG,
2130	notificationType INTEGER,
2131	deliveryType INTEGER,
2132	deliver BOOLEAN
2133);
2134
2135create table User_ (
2136	uuid_ VARCHAR(75) null,
2137	userId LONG not null primary key,
2138	companyId LONG,
2139	createDate DATE null,
2140	modifiedDate DATE null,
2141	defaultUser BOOLEAN,
2142	contactId LONG,
2143	password_ VARCHAR(75) null,
2144	passwordEncrypted BOOLEAN,
2145	passwordReset BOOLEAN,
2146	passwordModifiedDate DATE null,
2147	digest VARCHAR(255) null,
2148	reminderQueryQuestion VARCHAR(75) null,
2149	reminderQueryAnswer VARCHAR(75) null,
2150	graceLoginCount INTEGER,
2151	screenName VARCHAR(75) null,
2152	emailAddress VARCHAR(75) null,
2153	facebookId LONG,
2154	ldapServerId LONG,
2155	openId VARCHAR(1024) null,
2156	portraitId LONG,
2157	languageId VARCHAR(75) null,
2158	timeZoneId VARCHAR(75) null,
2159	greeting VARCHAR(255) null,
2160	comments STRING null,
2161	firstName VARCHAR(75) null,
2162	middleName VARCHAR(75) null,
2163	lastName VARCHAR(75) null,
2164	jobTitle VARCHAR(100) null,
2165	loginDate DATE null,
2166	loginIP VARCHAR(75) null,
2167	lastLoginDate DATE null,
2168	lastLoginIP VARCHAR(75) null,
2169	lastFailedLoginDate DATE null,
2170	failedLoginAttempts INTEGER,
2171	lockout BOOLEAN,
2172	lockoutDate DATE null,
2173	agreedToTermsOfUse BOOLEAN,
2174	emailAddressVerified BOOLEAN,
2175	status INTEGER
2176);
2177
2178create table UserGroup (
2179	uuid_ VARCHAR(75) null,
2180	userGroupId LONG not null primary key,
2181	companyId LONG,
2182	userId LONG,
2183	userName VARCHAR(75) null,
2184	createDate DATE null,
2185	modifiedDate DATE null,
2186	parentUserGroupId LONG,
2187	name VARCHAR(75) null,
2188	description STRING null,
2189	addedByLDAPImport BOOLEAN
2190);
2191
2192create table UserGroupGroupRole (
2193	userGroupId LONG not null,
2194	groupId LONG not null,
2195	roleId LONG not null,
2196	primary key (userGroupId, groupId, roleId)
2197);
2198
2199create table UserGroupRole (
2200	userId LONG not null,
2201	groupId LONG not null,
2202	roleId LONG not null,
2203	primary key (userId, groupId, roleId)
2204);
2205
2206create table UserGroups_Teams (
2207	teamId LONG not null,
2208	userGroupId LONG not null,
2209	primary key (teamId, userGroupId)
2210);
2211
2212create table UserIdMapper (
2213	userIdMapperId LONG not null primary key,
2214	userId LONG,
2215	type_ VARCHAR(75) null,
2216	description VARCHAR(75) null,
2217	externalUserId VARCHAR(75) null
2218);
2219
2220create table UserNotificationEvent (
2221	uuid_ VARCHAR(75) null,
2222	userNotificationEventId LONG not null primary key,
2223	companyId LONG,
2224	userId LONG,
2225	type_ VARCHAR(75) null,
2226	timestamp LONG,
2227	deliverBy LONG,
2228	delivered BOOLEAN,
2229	payload TEXT null,
2230	archived BOOLEAN
2231);
2232
2233create table Users_Groups (
2234	groupId LONG not null,
2235	userId LONG not null,
2236	primary key (groupId, userId)
2237);
2238
2239create table Users_Orgs (
2240	organizationId LONG not null,
2241	userId LONG not null,
2242	primary key (organizationId, userId)
2243);
2244
2245create table Users_Roles (
2246	roleId LONG not null,
2247	userId LONG not null,
2248	primary key (roleId, userId)
2249);
2250
2251create table Users_Teams (
2252	teamId LONG not null,
2253	userId LONG not null,
2254	primary key (teamId, userId)
2255);
2256
2257create table Users_UserGroups (
2258	userId LONG not null,
2259	userGroupId LONG not null,
2260	primary key (userId, userGroupId)
2261);
2262
2263create table UserTracker (
2264	userTrackerId LONG not null primary key,
2265	companyId LONG,
2266	userId LONG,
2267	modifiedDate DATE null,
2268	sessionId VARCHAR(200) null,
2269	remoteAddr VARCHAR(75) null,
2270	remoteHost VARCHAR(75) null,
2271	userAgent VARCHAR(200) null
2272);
2273
2274create table UserTrackerPath (
2275	userTrackerPathId LONG not null primary key,
2276	userTrackerId LONG,
2277	path_ STRING null,
2278	pathDate DATE null
2279);
2280
2281create table VirtualHost (
2282	virtualHostId LONG not null primary key,
2283	companyId LONG,
2284	layoutSetId LONG,
2285	hostname VARCHAR(75) null
2286);
2287
2288create table WebDAVProps (
2289	webDavPropsId LONG not null primary key,
2290	companyId LONG,
2291	createDate DATE null,
2292	modifiedDate DATE null,
2293	classNameId LONG,
2294	classPK LONG,
2295	props TEXT null
2296);
2297
2298create table Website (
2299	uuid_ VARCHAR(75) null,
2300	websiteId LONG not null primary key,
2301	companyId LONG,
2302	userId LONG,
2303	userName VARCHAR(75) null,
2304	createDate DATE null,
2305	modifiedDate DATE null,
2306	classNameId LONG,
2307	classPK LONG,
2308	url STRING null,
2309	typeId INTEGER,
2310	primary_ BOOLEAN
2311);
2312
2313create table WikiNode (
2314	uuid_ VARCHAR(75) null,
2315	nodeId LONG not null primary key,
2316	groupId LONG,
2317	companyId LONG,
2318	userId LONG,
2319	userName VARCHAR(75) null,
2320	createDate DATE null,
2321	modifiedDate DATE null,
2322	name VARCHAR(75) null,
2323	description STRING null,
2324	lastPostDate DATE null,
2325	status INTEGER,
2326	statusByUserId LONG,
2327	statusByUserName VARCHAR(75) null,
2328	statusDate DATE null
2329);
2330
2331create table WikiPage (
2332	uuid_ VARCHAR(75) null,
2333	pageId LONG not null primary key,
2334	resourcePrimKey LONG,
2335	groupId LONG,
2336	companyId LONG,
2337	userId LONG,
2338	userName VARCHAR(75) null,
2339	createDate DATE null,
2340	modifiedDate DATE null,
2341	nodeId LONG,
2342	title VARCHAR(255) null,
2343	version DOUBLE,
2344	minorEdit BOOLEAN,
2345	content TEXT null,
2346	summary STRING null,
2347	format VARCHAR(75) null,
2348	head BOOLEAN,
2349	parentTitle VARCHAR(255) null,
2350	redirectTitle VARCHAR(255) null,
2351	status INTEGER,
2352	statusByUserId LONG,
2353	statusByUserName VARCHAR(75) null,
2354	statusDate DATE null
2355);
2356
2357create table WikiPageResource (
2358	uuid_ VARCHAR(75) null,
2359	resourcePrimKey LONG not null primary key,
2360	nodeId LONG,
2361	title VARCHAR(255) null
2362);
2363
2364create table WorkflowDefinitionLink (
2365	workflowDefinitionLinkId LONG not null primary ke

Large files files are truncated, but you can click here to view the full file