git.gumartinm.name Git - JavaForFun/blob

   1 <?xml version="1.1" encoding="UTF-8" standalone="no"?>
   2 <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">
   3     <changeSet author="gustavo (generated)" id="1468267753605-1">
   4         <createTable tableName="AD">
   5             <column autoIncrement="true" name="ID" type="BIGINT">
   6                 <constraints primaryKey="true"/>
   7             </column>
   8             <column name="COMPANY_ID" type="BIGINT"/>
   9             <column name="COMPANY_CATEG_ID" type="BIGINT"/>
  10             <column name="AD_GPS" type="BLOB"/>
  11             <column name="AD_MOBILE_IMAGE" type="VARCHAR(255)"/>
  12             <column defaultValueComputed="CURRENT_TIMESTAMP" name="CREATED_AT" type="TIMESTAMP">
  13                 <constraints nullable="false"/>
  14             </column>
  15             <column defaultValue="0000-00-00 00:00:00" name="UPDATED_AT" type="TIMESTAMP">
  16                 <constraints nullable="false"/>
  17             </column>
  18         </createTable>
  19         <modifySql dbms="mysql">
  20             <append value="ENGINE=InnoDB CHARSET=utf8 COLLATE utf8_unicode_ci"/>
  21         </modifySql>
  22     </changeSet>
  23     <changeSet author="gustavo (generated)" id="1468267753605-2">
  24         <createTable tableName="AD_DESCRIPTION">
  25             <column autoIncrement="true" name="ID" type="BIGINT">
  26                 <constraints primaryKey="true"/>
  27             </column>
  28             <column name="LANGUAGE_ID" type="BIGINT">
  29                 <constraints nullable="false"/>
  30             </column>
  31             <column name="AD_ID" type="BIGINT"/>
  32             <column name="AD_NAME" type="VARCHAR(255)">
  33                 <constraints nullable="false"/>
  34             </column>
  35             <column name="AD_DESCRIPTION" type="LONGTEXT"/>
  36             <column name="AD_MOBILE_TEXT" type="VARCHAR(500)">
  37                 <constraints nullable="false"/>
  38             </column>
  39             <column name="AD_LINK" type="VARCHAR(3000)">
  40                 <constraints nullable="false"/>
  41             </column>
  42         </createTable>
  43         <modifySql dbms="mysql">
  44             <append value="ENGINE=InnoDB CHARSET=utf8 COLLATE utf8_unicode_ci"/>
  45         </modifySql>
  46     </changeSet>
  47     <changeSet author="gustavo (generated)" id="1468267753605-3">
  48         <createTable tableName="con_test">
  49             <column name="a" type="CHAR(1)"/>
  50         </createTable>
  51     </changeSet>
  52     <changeSet author="gustavo (generated)" id="1468267753605-4">
  53         <addUniqueConstraint columnNames="ID" constraintName="ID" deferrable="false" disabled="false" initiallyDeferred="false" tableName="AD"/>
  54     </changeSet>
  55     <changeSet author="gustavo (generated)" id="1468267753605-5">
  56         <addForeignKeyConstraint baseColumnNames="AD_ID" baseTableName="AD_DESCRIPTION" constraintName="AD_DESCRIPTION_ibfk_1" deferrable="false" initiallyDeferred="false" onDelete="CASCADE" onUpdate="NO ACTION" referencedColumnNames="ID" referencedTableName="AD"/>
  57     </changeSet>
  58 </databaseChangeLog>