• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addNotNullConstraintWithValues.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.addNotNullConstraintWithValues.sql Maven / Gradle / Ivy

CREATE TABLE public.lb45 (name CHAR(20))
INSERT INTO public.lb45 (name) VALUES ('marcel')
ALTER TABLE public.lb45 ADD "columnWithInitialValue" BIGINT
UPDATE public.lb45 SET "columnWithInitialValue" = 0
ALTER TABLE public.lb45 ALTER COLUMN  "columnWithInitialValue" SET NOT NULL
ALTER TABLE public.lb45 ADD "columnWithConstraintInSeparateChange" BIGINT
UPDATE public.lb45 SET "columnWithConstraintInSeparateChange" = 0
ALTER TABLE public.lb45 ALTER COLUMN  "columnWithConstraintInSeparateChange" SET NOT NULL