Skip to content

Instantly share code, notes, and snippets.

@goyalmohit
Created February 17, 2019 22:20
Show Gist options
  • Select an option

  • Save goyalmohit/d119218d11d30251b099904ddeee4182 to your computer and use it in GitHub Desktop.

Select an option

Save goyalmohit/d119218d11d30251b099904ddeee4182 to your computer and use it in GitHub Desktop.
Sample changeset for liquibase
<changeSet author="mohit" id="91">
<createTable tableName="Customers">
<column name="CustomerID" type="nchar(5)">
<constraints primaryKey="true" primaryKeyName="PK_Customers"/>
</column>
<column name="CompanyName" type="nvarchar(40)">
<constraints nullable="false"/>
</column>
<column name="ContactName" type="nvarchar(30)"/>
<column name="ContactTitle" type="nvarchar(30)"/>
<column name="Address" type="nvarchar(60)"/>
<column name="City" type="nvarchar(15)"/>
<column name="Region" type="nvarchar(15)"/>
<column name="PostalCode" type="nvarchar(10)"/>
<column name="Country" type="nvarchar(15)"/>
<column name="Phone" type="nvarchar(24)"/>
<column name="Fax" type="nvarchar(24)"/>
</createTable>
</changeSet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment