• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addAutoIncrement.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.

liquibase.harness.change.expectedSql.postgresql.addAutoIncrement.sql Maven / Gradle / Ivy

CREATE TABLE public.autoincrement_test ("intColumn" INTEGER NOT NULL, "dateColumn" date, CONSTRAINT autoincrement_test_pkey PRIMARY KEY ("intColumn"))
CREATE SEQUENCE  IF NOT EXISTS public."autoincrement_test_intColumn_seq"
ALTER TABLE public.autoincrement_test ALTER COLUMN  "intColumn" SET NOT NULL
ALTER TABLE public.autoincrement_test ALTER COLUMN  "intColumn" SET DEFAULT nextval('public."autoincrement_test_intColumn_seq"')
ALTER SEQUENCE public."autoincrement_test_intColumn_seq" OWNED BY public.autoincrement_test."intColumn"