Parameters

Links

http://www.liquibase.org/manual/column Column tag
http://www.liquibase.org/manual/add_auto-increment Add Auto-Increment
http://www.liquibase.org/manual/create_table Create Table

SQL

To run an external SQL script:

<sqlFile path="module/gateway_tables.sql"/>

Table

Alter

<changeSet id="2" author="pat">
  <dropNotNullConstraint tableName="stores" columnName="height" columnDataType="int"/>
  <addDefaultValue tableName="stores" columnName="height" defaultValue="NULL"/>
</changeSet>

Create

To create a table. This example creates an auto increment field as a primary key as well as a foreign key:

<createTable tableName="personal_media_disk">
  <column name="id" type="BIGINT" autoIncrement="true">
    <constraints primaryKey="true" primaryKeyName="PK_personal_media_disk" nullable="false"/>
  </column>
  <column name="code" type="VARCHAR(10)">
    <constraints nullable="false"/>
  </column>
  <column name="response" type="VARCHAR(100)">
    <constraints nullable="false"/>
  </column>
  <column name="inbound_sms_id" type="INT">
    <constraints foreignKeyName="FK_inbound_sms_id" nullable="false" references="inbound_sms(id)"/>
  </column>
</createTable>

<changeSet id="1" author="patrick">
    <createTable tableName="department">
        <column name="id" type="int" autoIncrement="true">
            <constraints primaryKey="true" nullable="false"/>
        </column>
    </createTable>
</changeSet>

Insert

To insert data:

<insert tableName="email_account">
    <column name="email_server_id" valueNumeric="1"/>
    <column name="username" value="my_user"/>
    <column name="password" value="my_password"/>
</insert>