Skip to content

Instantly share code, notes, and snippets.

@irwinv
Created January 10, 2013 13:11
Show Gist options
  • Save irwinv/4501953 to your computer and use it in GitHub Desktop.
Save irwinv/4501953 to your computer and use it in GitHub Desktop.
Exemples create table with liquibase
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
<changeSet id="2013-01-08-1506" author="peowpeowforce">
<createTable tableName="agence">
<column name="id" type="INT">
<constraints primaryKey="true" nullable="false"/>
</column>
<column name="adresse" type="VARCHAR(100)"/>
<column name="chef_agence" type="VARCHAR(50)"/>
<column name="cle" type="VARCHAR(3)"/>
<column name="codepostale" type="INT"/>
<column name="commune" type="VARCHAR(30)"/>
<column name="coordonnees" type="VARCHAR(30)"/>
<column name="cout_W" type="INT"/>
<column name="dispnible" defaultValue="OUI"/>
<column name="email" type="VARCHAR(100)"/>
<column name="fax" type="INT"/>
<column name="googlemap_address" type="VARCHAR(100)"/>
<column name="libelle" type="VARCHAR(30)"/>
<column name="ouverture1_horaires" type="VARCHAR(50)"/>
<column name="ouverture1_texte" type="VARCHAR(50)"/>
<column name="sympal_slug" type="VARCHAR(30)"/>
<column name="telephone" type="INT"/>
<column name="telephone_redirection" type="INT"/>
</createTable>
</changeSet>
</databaseChangeLog>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment