<?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">

    <!--输出实体[T_BOOK]数据结构 -->
    <changeSet author="root" id="T_BOOK">
        <createTable tableName="T_BOOK" remarks="书">
            <column name="BOOKID" remarks="书标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_BOOK_BOOKID"/>
            </column>
            <column name="BOOKNAME" remarks="书名称" type="VARCHAR(200)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DATE" remarks="日期" type="DATETIME">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="FIELD" remarks="属性" type="VARCHAR(100)">
            </column>
            <column name="FIELD10" remarks="日期" type="DATETIME">
            </column>
            <column name="FIELD11" remarks="属性11" type="VARCHAR(100)">
            </column>
            <column name="FIELD12" remarks="属性12" type="VARCHAR(100)">
            </column>
            <column name="FIELD13" remarks="属性13" type="VARCHAR(100)">
            </column>
            <column name="FIELD14" remarks="属性14" type="VARCHAR(100)">
            </column>
            <column name="FIELD15" remarks="属性15" type="VARCHAR(100)">
            </column>
            <column name="FIELD16" remarks="属性16" type="VARCHAR(100)">
            </column>
            <column name="FIELD17" remarks="属性17" type="VARCHAR(100)">
            </column>
            <column name="FIELD18" remarks="属性18" type="VARCHAR(100)">
            </column>
            <column name="FIELD19" remarks="属性19" type="VARCHAR(100)">
            </column>
            <column name="FIELD2" remarks="属性2" type="VARCHAR(100)">
            </column>
            <column name="FIELD20" remarks="属性20" type="VARCHAR(100)">
            </column>
            <column name="FIELD21" remarks="属性21" type="VARCHAR(100)">
            </column>
            <column name="FIELD22" remarks="属性22" type="VARCHAR(100)">
            </column>
            <column name="FIELD23" remarks="属性23" type="DECIMAL(38,2)">
            </column>
            <column name="FIELD3" remarks="属性3" type="VARCHAR(100)">
            </column>
            <column name="FIELD4" remarks="属性4" type="VARCHAR(100)">
            </column>
            <column name="FIELD5" remarks="属性5" type="VARCHAR(100)">
            </column>
            <column name="FIELD6" remarks="属性6" type="VARCHAR(100)">
            </column>
            <column name="FIELD7" remarks="属性7" type="VARCHAR(100)">
            </column>
            <column name="FIELD8" remarks="属性8" type="VARCHAR(100)">
            </column>
            <column name="FIELD9" remarks="属性9" type="VARCHAR(100)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="TYPE" remarks="类型" type="VARCHAR(100)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_BOOKTYPE]数据结构 -->
    <changeSet author="root" id="T_BOOKTYPE">
        <createTable tableName="T_BOOKTYPE" remarks="书籍类别">
            <column name="BOOKTYPEID" remarks="书籍类别标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_BOOKTYPE_BOOKTYPEID"/>
            </column>
            <column name="BOOKTYPENAME" remarks="书籍类别名称" type="VARCHAR(200)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_BXD]数据结构 -->
    <changeSet author="root" id="T_BXD">
        <createTable tableName="T_BXD" remarks="报销单">
            <column name="BXDID" remarks="报销单标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_BXD_BXDID"/>
            </column>
            <column name="BXDNAME" remarks="报销单名称" type="VARCHAR(200)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_BXDMX]数据结构 -->
    <changeSet author="root" id="T_BXDMX">
        <createTable tableName="T_BXDMX" remarks="报销单明细">
            <column name="BXDID" remarks="报销单标识" type="VARCHAR(100)">
            </column>
            <column name="BXDMXID" remarks="报销单明细标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_BXDMX_BXDMXID"/>
            </column>
            <column name="BXDMXNAME" remarks="报销单明细名称" type="VARCHAR(200)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_PHONE]数据结构 -->
    <changeSet author="root" id="T_PHONE">
        <createTable tableName="T_PHONE" remarks="手机">
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </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>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="PHONEID" remarks="手机标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_PHONE_PHONEID"/>
            </column>
            <column name="PHONENAME" remarks="手机名称" type="VARCHAR(200)">
            </column>
            <column name="PHONETYPE" remarks="手机型号" type="VARCHAR(100)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_PRINT]数据结构 -->
    <changeSet author="root" id="T_PRINT">
        <createTable tableName="T_PRINT" remarks="PRINT">
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="PRINTID" remarks="PRINT标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_PRINT_PRINTID"/>
            </column>
            <column name="PRINTNAME" remarks="PRINT名称" type="VARCHAR(200)">
            </column>
            <column name="STUNO" remarks="PRINTMODEL" type="VARCHAR(100)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_RAWMATERIAL]数据结构 -->
    <changeSet author="root" id="T_RAWMATERIAL">
        <createTable tableName="T_RAWMATERIAL" remarks="原材料">
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="PAYID" remarks="支付标识" type="VARCHAR(100)">
            </column>
            <column name="RAWMATERIALID" remarks="原材料标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_RAWMATERIAL_RAWMATERIALID"/>
            </column>
            <column name="RAWMATERIALNAME" remarks="原材料名称" type="VARCHAR(200)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_REGINFO]数据结构 -->
    <changeSet author="root" id="T_REGINFO">
        <createTable tableName="T_REGINFO" remarks="学员登记信息">
            <column name="ADDRESS" remarks="家庭住址" type="VARCHAR(100)">
            </column>
            <column name="AGE" remarks="年龄" type="INT">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPARTMENT" remarks="单位" type="VARCHAR(100)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="FIELD" remarks="属性" type="VARCHAR(100)">
            </column>
            <column name="NAME" remarks="学员姓名" type="VARCHAR(100)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="REGINFOID" remarks="学员登记信息标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_REGINFO_REGINFOID"/>
            </column>
            <column name="REGINFONAME" remarks="学员登记信息名称" type="VARCHAR(200)">
            </column>
            <column name="STUDENTID" remarks="学生标识" type="VARCHAR(100)">
            </column>
            <column name="STUNO" remarks="学员编号" type="VARCHAR(100)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_REGINFOF]数据结构 -->
    <changeSet author="root" id="T_REGINFOF">
        <createTable tableName="T_REGINFOF" remarks="学员登记信息测试fzh">
            <column name="ADDRESS" remarks="家庭住址" type="VARCHAR(100)">
            </column>
            <column name="AGE" remarks="年龄" type="VARCHAR(100)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPARTMENT" remarks="单位" type="VARCHAR(100)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="NAME" remarks="学员姓名" type="VARCHAR(100)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="REGINFOFID" remarks="学员登记信息测试fzh标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_REGINFOF_REGINFOFID"/>
            </column>
            <column name="REGINFOFNAME" remarks="学员登记信息测试fzh名称" type="VARCHAR(200)">
            </column>
            <column name="STUNO" remarks="学员编号" type="VARCHAR(100)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_STUDENT]数据结构 -->
    <changeSet author="root" id="T_STUDENT">
        <createTable tableName="T_STUDENT" remarks="学生">
            <column name="ADDRESS" remarks="地址" type="VARCHAR(100)">
            </column>
            <column name="AGE" remarks="年龄" type="INT">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="DEPARTMENT" remarks="单位" type="VARCHAR(100)">
            </column>
            <column name="DEPTID" remarks="组织部门标识" type="VARCHAR(60)">
            </column>
            <column name="FIELD" remarks="属性" type="VARCHAR(100)">
            </column>
            <column name="NAME" remarks="姓名" type="VARCHAR(100)">
            </column>
            <column name="ORGID" remarks="组织机构标识" type="VARCHAR(60)">
            </column>
            <column name="STUDENTID" remarks="学生标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_STUDENT_STUDENTID"/>
            </column>
            <column name="STUDENTNAME" remarks="学生名称" type="VARCHAR(200)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

    <!--输出实体[T_TEST]数据结构 -->
    <changeSet author="root" id="T_TEST">
        <createTable tableName="T_TEST" remarks="测试实体">
            <column name="AMOUNT" remarks="金额" type="DECIMAL(38,2)">
            </column>
            <column name="CREATEDATE" remarks="建立时间" type="DATETIME">
            </column>
            <column name="CREATEMAN" remarks="建立人" type="VARCHAR(60)">
            </column>
            <column name="TESTID" remarks="测试实体标识" type="VARCHAR(100)">
                <constraints primaryKey="true" primaryKeyName="PK_T_TEST_TESTID"/>
            </column>
            <column name="TESTNAME" remarks="测试实体名称" type="VARCHAR(200)">
            </column>
            <column name="UPDATEDATE" remarks="更新时间" type="DATETIME">
            </column>
            <column name="UPDATEMAN" remarks="更新人" type="VARCHAR(60)">
            </column>
        </createTable>
    </changeSet>

</databaseChangeLog>
