db.pgsql.create.tpl Maven / Gradle / Ivy
create table ${ db.table.schema }.${ db.table.name } (
${ db.table.id } bigint not null,
${ db.table.description } CHARACTER VARYING(255) not null,
${ db.table.version } bigint not null,
${ db.table.timestamp } timestamp not null,
primary key (${ db.table.id })
);
alter table ${db.table.schema }.${ db.table.name } add constraint ${ db.table.name }_uk1 unique(${ db.table.version });
create sequence ${ db.table.schema }.${ db.table.name }_sq INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9999999999;
© 2015 - 2025 Weber Informatics LLC | Privacy Policy