Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mvn clean liquibase:update -Dt1Schema=t1 -Dt2Schema=t2
- <changeSet id="0" author="admin">
- <createTable tableName="t1" remarks="t1" schemaName="${t1Schema}">
- <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
- <constraints primaryKey="true" nullable="false"/>
- </column>
- </createTable>
- <createTable tableName="t2" remarks="t2" schemaName="${t1Schema}">
- <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
- <constraints primaryKey="true" nullable="false"/>
- </column>
- <column name="t1_id" type="BIGINT" remarks="t1 id">
- <constraints nullable="true" deferrable="true" foreignKeyName="fk_t1_t2" referencedTableName="${t1Schema}.t1" referencedColumnNames="id"/>
- </column>
- </createTable>
- </changeSet>
- <changeSet id="0" author="admin">
- <createTable tableName="t1" remarks="t1" schemaName="${t1Schema}">
- <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
- <constraints primaryKey="true" nullable="false"/>
- </column>
- </createTable>
- <createTable tableName="t2" remarks="t2" schemaName="${t1Schema}">
- <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
- <constraints primaryKey="true" nullable="false"/>
- </column>
- <column name="t1_id" type="BIGINT" remarks="t1 id">
- <constraints nullable="true"/>
- </column>
- </createTable>
- </changeSet>
- <changeSet id="1" author="admin">
- <addForeignKeyConstraint baseColumnNames="t1_id" baseTableName="${t1Schema}.t2" constraintName="fk_t1_t2" referencedColumnNames="id" referencedTableName="${t1Schema}.t1"/>
- </changeSet>
- <plugin>
- <groupId>org.liquibase</groupId>
- <artifactId>liquibase-maven-plugin</artifactId>
- <version>3.5.1</version>
- <configuration>
- <changeLogFile>src/main/resources/schema1.xml</changeLogFile>
- <changeLogFile>src/main/resources/schema2.xml</changeLogFile>
- <driver>org.postgresql.Driver</driver>
- <url>jdbc:postgresql://localhost:5432/postgres</url>
- <username>postgres</username>
- <password>postgres</password>
- </configuration>
- </plugin>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement