liquibase-单表模板

单张表的模板

 

 1 <?xml version="1.0" encoding="utf-8"?>
 2 <databaseChangeLog
 3     xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
 4     xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
 5     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 6     xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd
 7                         http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
 8 
 9     <!--
10         Added the entity xxxx.
11     -->
12     <changeSet id="2020" author="dongfang">
13         <createTable tableName="" remarks="">
14             <column name="id" type="bigint" autoIncrement="${autoIncrement}">
15                 <constraints primaryKey="true"/>
16             </column>
17 
18 
19             <column name="" type="varchar(30)" remarks=""/>
20             <column name="" type="varchar(30)" remarks="">
21                 <constraints nullable="false"/>
22             </column>
23 
24 
25             <column name="created_by" type="bigint" remarks="创建人"/>
26             <column name="created_time" type="datetime" remarks="创建时间"/>
27             <column name="updated_by" type="bigint" remarks="修改人"/>
28             <column name="updated_time" type="datetime" remarks="修改时间"/>
29             <column name="deleted" type="boolean" remarks="是否删除"/>
30         </createTable>
31         <!--index information-->
32         <createIndex tableName="" indexName="idx_">
33             <column name=""></column>
34         </createIndex>
35         <createIndex tableName="" indexName="idx_">
36             <column name=""></column>
37         </createIndex>
38     </changeSet>
39 
40 </databaseChangeLog>

 

posted on 2020-08-05 18:10  东方1024  阅读(125)  评论(0)    收藏  举报

导航