• Home
• com.liferay
• com.liferay.search.experiences.service
• 3.0.77
• 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 SXPBlueprint (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	sxpBlueprintId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	configurationJSON TEXT null,
	description STRING null,
	elementInstancesJSON TEXT null,
	schemaVersion VARCHAR(75) null,
	title STRING null,
	version VARCHAR(75) null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null
);

create table SXPElement (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	sxpElementId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	description STRING null,
	elementDefinitionJSON TEXT null,
	fallbackDescription STRING null,
	fallbackTitle VARCHAR(500) null,
	hidden_ BOOLEAN,
	readOnly BOOLEAN,
	schemaVersion VARCHAR(75) null,
	title STRING null,
	type_ INTEGER,
	version VARCHAR(75) null,
	status INTEGER
);