Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 2.21 KB | None | 0 0
  1. <changeSet id="2d4d5b8d-c571-4fc7-bcf7-28888efb2c8c" author="martin">
  2.         <createTable tableName="token">
  3.             <column name="id" type="VARCHAR(255)">
  4.                 <constraints nullable="false"/>
  5.             </column>
  6.             <column name="token" type="VARCHAR(255)">
  7.                 <constraints nullable="false"/>
  8.             </column>
  9.             <column name="time_generate" type="datetime(6)">
  10.                 <constraints nullable="false"/>
  11.             </column>
  12.             <column name="user_id" type="VARCHAR(255)">
  13.                 <constraints nullable="false"/>
  14.             </column>
  15.         </createTable>
  16.     </changeSet>
  17.     <changeSet author="martin" id="f2065804-0ca9-4a80-99d1-b5b4fa5c0db0">
  18.         <createIndex indexName="FK_1459773192024-41" tableName="token">
  19.             <column name="user_id"/>
  20.         </createIndex>
  21.     </changeSet>
  22.     <changeSet author="martin" id="add-foreign-key-on-token">
  23.         <addForeignKeyConstraint baseColumnNames="user_id" baseTableName="token"
  24.                                 constraintName="FK_1459773192024-41" deferrable="false"
  25.                                 initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION"
  26.                                 referencedColumnNames="id" referencedTableName="user"/>
  27.     </changeSet>
  28. <changeSet id="add-version-to-token-table" author="martin">
  29.         <addColumn tableName="token">
  30.             <column name="version" type="BIGINT">
  31.                 <constraints nullable="false"/>
  32.             </column>
  33.         </addColumn>
  34.     </changeSet>
  35.  
  36.     <changeSet id="drop-date-of-generation-column" author="martin">
  37.         <dropColumn tableName="token" columnName="time_generate"/>
  38.     </changeSet>
  39.  
  40.  
  41.     <changeSet id="adding-date-created-and-date-modified-to-token-table" author="martin">
  42.         <addColumn tableName="token">
  43.             <column name="date_created" type="datetime(6)">
  44.                 <constraints nullable="false"/>
  45.             </column>
  46.         </addColumn>
  47.         <addColumn tableName="token">
  48.             <column name="last_updated" type="datetime(6)">
  49.                 <constraints nullable="false"/>
  50.             </column>
  51.         </addColumn>
  52.     </changeSet>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement