liquibase-schema-only.xml

<changeSet author="ben (generated)" id="1227303685425-51">
        <createTable tableName="person">
            <column autoIncrement="true" name="person_id" type="int">
                <constraints nullable="false" primaryKey="true"/>
            </column>
            <column defaultValue="" name="gender" type="varchar(50)"/>
            <column name="birthdate" type="DATE"/>
            <column defaultValueBoolean="false" name="birthdate_estimated" type="BOOLEAN">
                <constraints nullable="false"/>
            </column>
            <column defaultValueBoolean="false" name="dead" type="BOOLEAN">
                <constraints nullable="false"/>
            </column>
            <column name="death_date" type="DATETIME"/>
            <column name="cause_of_death" type="int"/>
            <column defaultValueNumeric="0" name="creator" type="int">
                <constraints nullable="true"/>
            </column>
            <column name="date_created" type="DATETIME">
                <constraints nullable="false"/>
            </column>
            <column name="changed_by" type="int"/>
            <column name="date_changed" type="DATETIME"/>
            <column defaultValueBoolean="false" name="voided" type="BOOLEAN">
                <constraints nullable="false"/>
            </column>
            <column name="voided_by" type="int"/>
            <column name="date_voided" type="DATETIME"/>
            <column name="void_reason" type="varchar(255)"/>
            <column name="uuid" type="char(38)" />
        </createTable>
        <modifySql dbms="mssql">
            <replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
        </modifySql>
    </changeSet>