Guest User

Untitled

a guest
Jul 23rd, 2012
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. <changeSet id="feedback-2012-07-23-12:16" author="harshadura">
  2.  
  3. <preConditions onFail="MARK_RAN">
  4. <not><tableExists tableName="feedback_userAccess"/></not>
  5. </preConditions>
  6.  
  7. <comment>
  8. Creating the Feedback User Access tables
  9. </comment>
  10.  
  11. <createTable tableName="feedback_userAccess">
  12. <column name="feedback_id" type="int">
  13. <constraints primaryKey="true" nullable="false" />
  14. </column>
  15. <column name="user_id" type="int">
  16. </column>
  17. </createTable>
  18.  
  19. <addForeignKeyConstraint constraintName="fk_feedback_id"
  20. referencedTableName="feedback_feedback" baseColumnNames="feedback_id"
  21. baseTableName="feedback_userAccess" referencedColumnNames="feedback_id" />
  22.  
  23. </changeSet>
Advertisement
Add Comment
Please, Sign In to add comment