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

CREATE SEQUENCE  IF NOT EXISTS test_sequence START WITH 1 INCREMENT BY 1 MINVALUE 1
ALTER TABLE authors ADD sequence_referenced_column numeric
ALTER TABLE authors ALTER COLUMN  sequence_referenced_column SET DEFAULT nextval('test_sequence')
ALTER SEQUENCE test_sequence OWNED BY authors.sequence_referenced_column