• Home
• com.liferay
• com.liferay.asset.list.service
• 3.0.86
• source code
• tables.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

META-INF.sql.tables.sql Maven / Gradle / Ivy

create table AssetListEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	assetListEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryKey VARCHAR(75) null,
	title VARCHAR(75) null,
	type_ INTEGER,
	assetEntrySubtype VARCHAR(255) null,
	assetEntryType VARCHAR(255) null,
	lastPublishDate DATE null,
	primary key (assetListEntryId, ctCollectionId)
);

create table AssetListEntryAssetEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	assetListEntryAssetEntryRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryId LONG,
	assetEntryId LONG,
	segmentsEntryId LONG,
	position INTEGER,
	lastPublishDate DATE null,
	primary key (assetListEntryAssetEntryRelId, ctCollectionId)
);

create table AssetListEntrySegmentsEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	alEntrySegmentsEntryRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryId LONG,
	priority INTEGER,
	segmentsEntryId LONG,
	typeSettings TEXT null,
	lastPublishDate DATE null,
	primary key (alEntrySegmentsEntryRelId, ctCollectionId)
);

create table AssetListEntryUsage (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	assetListEntryUsageId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	containerKey VARCHAR(255) null,
	containerType LONG,
	key_ VARCHAR(255) null,
	plid LONG,
	type_ INTEGER,
	lastPublishDate DATE null,
	primary key (assetListEntryUsageId, ctCollectionId)
);