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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of com.liferay.commerce.currency.service

Liferay Commerce Currency Service

There is a newer version: 4.0.52

create table CommerceCurrency (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	commerceCurrencyId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	code_ VARCHAR(75) null,
	name STRING null,
	symbol VARCHAR(75) null,
	rate BIGDECIMAL null,
	formatPattern STRING null,
	maxFractionDigits INTEGER,
	minFractionDigits INTEGER,
	roundingMode VARCHAR(75) null,
	primary_ BOOLEAN,
	priority DOUBLE,
	active_ BOOLEAN,
	lastPublishDate DATE null
);