Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. mvn clean liquibase:update -Dt1Schema=t1 -Dt2Schema=t2
  2.  
  3. <changeSet id="0" author="admin">
  4. <createTable tableName="t1" remarks="t1" schemaName="${t1Schema}">
  5. <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
  6. <constraints primaryKey="true" nullable="false"/>
  7. </column>
  8. </createTable>
  9.  
  10. <createTable tableName="t2" remarks="t2" schemaName="${t1Schema}">
  11. <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
  12. <constraints primaryKey="true" nullable="false"/>
  13. </column>
  14. <column name="t1_id" type="BIGINT" remarks="t1 id">
  15. <constraints nullable="true" deferrable="true" foreignKeyName="fk_t1_t2" referencedTableName="${t1Schema}.t1" referencedColumnNames="id"/>
  16. </column>
  17. </createTable>
  18. </changeSet>
  19.  
  20. <changeSet id="0" author="admin">
  21. <createTable tableName="t1" remarks="t1" schemaName="${t1Schema}">
  22. <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
  23. <constraints primaryKey="true" nullable="false"/>
  24. </column>
  25. </createTable>
  26.  
  27. <createTable tableName="t2" remarks="t2" schemaName="${t1Schema}">
  28. <column name="id" type="BIGINT" autoIncrement="true" remarks="id">
  29. <constraints primaryKey="true" nullable="false"/>
  30. </column>
  31. <column name="t1_id" type="BIGINT" remarks="t1 id">
  32. <constraints nullable="true"/>
  33. </column>
  34. </createTable>
  35. </changeSet>
  36.  
  37. <changeSet id="1" author="admin">
  38. <addForeignKeyConstraint baseColumnNames="t1_id" baseTableName="${t1Schema}.t2" constraintName="fk_t1_t2" referencedColumnNames="id" referencedTableName="${t1Schema}.t1"/>
  39. </changeSet>
  40.  
  41. <plugin>
  42. <groupId>org.liquibase</groupId>
  43. <artifactId>liquibase-maven-plugin</artifactId>
  44. <version>3.5.1</version>
  45. <configuration>
  46. <changeLogFile>src/main/resources/schema1.xml</changeLogFile>
  47. <changeLogFile>src/main/resources/schema2.xml</changeLogFile>
  48. <driver>org.postgresql.Driver</driver>
  49. <url>jdbc:postgresql://localhost:5432/postgres</url>
  50. <username>postgres</username>
  51. <password>postgres</password>
  52. </configuration>
  53. </plugin>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement