<changeSetauthor="666"id="tb_visitor_information"><preConditionsonError="MARK_RAN"onFail="MARK_RAN"><not><tableExiststableName="tb_visitor_information"/></not></preConditions><createTableremarks="访客个人信息表"tableName="tb_visitor_information"><columnname="person_id"remarks="人员id"type="VARCHAR(64)"><constraintsnullable="false"/></column><columnname="unit"remarks="单位"type="VARCHAR(128)"/><columnname="cert_pic_url"remarks="证件照图片url"type="VARCHAR(1024)"/><columnname="create_time"remarks="创建时间"type="TIMESTAMP(6) WITHOUT TIME ZONE"/><columnname="update_time"remarks="更新时间"type="TIMESTAMP(6) WITHOUT TIME ZONE"/><columnname="create_user"remarks="创建人id"type="VARCHAR(128)"/><columnname="create_user_name"remarks="创建人姓名"type="VARCHAR(128)"/><columnname="visit_num"defaultValue="0"remarks="访问次数"type="INT"/></createTable></changeSet>
写法二:使用sql标签
写法和原生sql语句一样,更加简单(推荐使用)
<changeSetid="tb_door_group"author="litairan"><comment>门禁点分组</comment><sql>
create table if not exists tb_door_group
(
id varchar(32) not null constraint tb_door_group_pk primary key,
name varchar(64) not null
);
comment on table tb_door_group is '门禁分组';
comment on column tb_door_group.id is 'ID';
comment on column tb_door_group.name is '名称';
create index if not exists tb_door_group_id_uindex on tb_door_group (id);
</sql></changeSet>