<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<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.6.xsd">

    <!--输出实体[BXD]数据结构 -->
    <changeSet author="root" id="tab-bxd-38-1">
        <createTable tableName="T_BXD">
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="BXDNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="BXDID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_BXD"/>
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[BXDMX]数据结构 -->
    <changeSet author="root" id="tab-bxdmx-36-2">
        <createTable tableName="T_BXDMX">
                <column name="BXDMXID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_BXDMX"/>
                </column>
                <column name="BXDMXNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="BXDID" remarks="" type="VARCHAR(100)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[BOOK]数据结构 -->
    <changeSet author="root" id="tab-book-408-3">
        <createTable tableName="T_BOOK">
                <column name="BOOKNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="BOOKID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_BOOK"/>
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="TYPE" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD2" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD3" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD4" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD5" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD6" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD7" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD8" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD9" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD10" remarks="" type="DATETIME">
                </column>
                <column name="DATE" remarks="" type="DATETIME">
                </column>
                <column name="FIELD11" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD12" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD13" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD14" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD15" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD16" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD17" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD18" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD19" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD20" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD21" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD22" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD23" remarks="" type="DECIMAL(38,2)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[BOOKTYPE]数据结构 -->
    <changeSet author="root" id="tab-booktype-15-4">
        <createTable tableName="T_BOOKTYPE">
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="BOOKTYPENAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="BOOKTYPEID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_BOOKTYPE"/>
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[PRINT]数据结构 -->
    <changeSet author="root" id="tab-print-17-5">
        <createTable tableName="T_PRINT">
                <column name="PRINTNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="PRINTID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_PRINT"/>
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="STUNO" remarks="" type="VARCHAR(100)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[PHONE]数据结构 -->
    <changeSet author="root" id="tab-phone-269-6">
        <createTable tableName="T_PHONE">
                <column name="PHONEID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_PHONE"/>
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="PHONENAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="PHONETYPE" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD" remarks="" type="TEXT(1048576)">
                </column>
                <column name="FIELD2" remarks="" type="DATETIME">
                </column>
                <column name="MONEY" remarks="" type="DECIMAL(38,2)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[REGINFO]数据结构 -->
    <changeSet author="root" id="tab-reginfo-209-8">
        <createTable tableName="T_REGINFO">
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="REGINFONAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="REGINFOID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_REGINFO"/>
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="STUNO" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD" remarks="" type="VARCHAR(100)">
                </column>
                <column name="NAME" remarks="" type="VARCHAR(100)">
                </column>
                <column name="DEPARTMENT" remarks="" type="VARCHAR(100)">
                </column>
                <column name="AGE" remarks="" type="INT">
                </column>
                <column name="ADDRESS" remarks="" type="VARCHAR(100)">
                </column>
                <column name="STUDENTID" remarks="" type="VARCHAR(100)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[REGINFOF]数据结构 -->
    <changeSet author="root" id="tab-reginfof-43-9">
        <createTable tableName="T_REGINFOF">
                <column name="REGINFOFID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_REGINFOF"/>
                </column>
                <column name="REGINFOFNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="STUNO" remarks="" type="VARCHAR(100)">
                </column>
                <column name="NAME" remarks="" type="VARCHAR(100)">
                </column>
                <column name="DEPARTMENT" remarks="" type="VARCHAR(100)">
                </column>
                <column name="AGE" remarks="" type="VARCHAR(100)">
                </column>
                <column name="ADDRESS" remarks="" type="VARCHAR(100)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[STUDENT]数据结构 -->
    <changeSet author="root" id="tab-student-81-10">
        <createTable tableName="T_STUDENT">
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="STUDENTID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_STUDENT"/>
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="STUDENTNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="ORGID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="DEPTID" remarks="" type="VARCHAR(60)">
                </column>
                <column name="NAME" remarks="" type="VARCHAR(100)">
                </column>
                <column name="FIELD" remarks="" type="VARCHAR(100)">
                </column>
                <column name="AGE" remarks="" type="INT">
                </column>
                <column name="ADDRESS" remarks="" type="VARCHAR(100)">
                </column>
                <column name="DEPARTMENT" remarks="" type="VARCHAR(100)">
                </column>
        </createTable>
    </changeSet>

    <!--输出实体[TEST]数据结构 -->
    <changeSet author="root" id="tab-test-53-11">
        <createTable tableName="T_TEST">
                <column name="CREATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="TESTID" remarks="" type="VARCHAR(100)">
                    <constraints primaryKey="true" primaryKeyName="PK_TEST"/>
                </column>
                <column name="TESTNAME" remarks="" type="VARCHAR(200)">
                </column>
                <column name="CREATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="UPDATEDATE" remarks="" type="DATETIME">
                </column>
                <column name="UPDATEMAN" remarks="" type="VARCHAR(60)">
                </column>
                <column name="AMOUNT" remarks="" type="DECIMAL(38,2)">
                </column>
        </createTable>
    </changeSet>


    <!--输出实体[BXDMX]外键关系 -->
    <changeSet author="root" id="fk-bxdmx-36-12">
       <addForeignKeyConstraint baseColumnNames="BXDID" baseTableName="T_BXDMX" constraintName="F821DB7B87E31B879F" deferrable="false" initiallyDeferred="false" onDelete="RESTRICT" onUpdate="RESTRICT" referencedColumnNames="BXDID" referencedTableName="T_BXD" validate="true"/>
    </changeSet>

    <!--输出实体[REGINFO]外键关系 -->
    <changeSet author="root" id="fk-reginfo-209-13">
       <addForeignKeyConstraint baseColumnNames="STUDENTID" baseTableName="T_REGINFO" constraintName="F328B6E61632896255" deferrable="false" initiallyDeferred="false" onDelete="RESTRICT" onUpdate="RESTRICT" referencedColumnNames="STUDENTID" referencedTableName="T_STUDENT" validate="true"/>
    </changeSet>

</databaseChangeLog>
