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     </changeSet>
  20     <changeSet author="gustavo (generated)" id="1468267753605-2">
  21         <createTable tableName="ad_description">
  22             <column autoIncrement="true" name="id" type="BIGINT">
  23                 <constraints primaryKey="true"/>
  24             </column>
  25             <column name="laguage_id" type="BIGINT">
  26                 <constraints nullable="false"/>
  27             </column>
  28             <column name="ad_id" type="BIGINT"/>
  29             <column name="ad_name" type="VARCHAR(255)">
  30                 <constraints nullable="false"/>
  31             </column>
  32             <column name="ad_description" type="LONGTEXT"/>
  33             <column name="ad_mobile_text" type="VARCHAR(500)">
  34                 <constraints nullable="false"/>
  35             </column>
  36             <column name="ad_link" type="VARCHAR(3000)">
  37                 <constraints nullable="false"/>
  38             </column>
  39         </createTable>
  40     </changeSet>
  41     <changeSet author="gustavo (generated)" id="1468267753605-3">
  42         <createTable tableName="con_test">
  43             <column name="a" type="CHAR(1)"/>
  44         </createTable>
  45     </changeSet>
  46     <changeSet author="gustavo (generated)" id="1468267753605-4">
  47         <addUniqueConstraint columnNames="id" constraintName="id" deferrable="false" disabled="false" initiallyDeferred="false" tableName="ad"/>
  48     </changeSet>
  49     <changeSet author="gustavo (generated)" id="1468267753605-5">
  50         <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"/>
  51     </changeSet>
  52 </databaseChangeLog>