text: drop table if exists ums_growth_change_history;
  drop table if exists ums_integration_change_history;
  drop table if exists ums_member;
  drop table if exists ums_member_collect_spu;
  drop table if exists ums_member_collect_subject;
  drop table if exists ums_member_level;
  drop table if exists ums_member_login_log;
  drop table if exists ums_member_receive_address;
  drop table if exists ums_member_statistics_info;
  /*==============================================================*/
  /* Table: ums_growth_change_history                             */
  /*==============================================================*/
  create table ums_growth_change_history (
     id bigint not null auto_increment comment 'id',
     member_id bigint comment 'member_id',
     create_time datetime comment 'create_time',
     change_count int comment '改变的值（正负计数）',
     note varchar(0) comment '备注',
     source_type tinyint comment '积分来源[0-购物，1-管理员修改]',
     primary key (id)
  );
  alter table ums_growth_change_history comment '成长值变化历史记录';
  /*==============================================================*/
  /* Table: ums_integration_change_history                        */
  /*==============================================================*/
  create table ums_integration_change_history (
     id bigint not null auto_increment comment 'id',
     member_id bigint comment 'member_id',
     create_time datetime comment 'create_time',
     change_count int comment '变化的值',
     note varchar(255) comment '备注',
     source_tyoe tinyint comment '来源[0->购物；1->管理员修改;2->活动]',
     primary key (id)
  );
  alter table ums_integration_change_history comment '积分变化历史记录';
  /*==============================================================*/
  /* Table: ums_member                                            */
  /*==============================================================*/
  create table ums_member (
     id bigint not null auto_increment comment 'id',
     level_id bigint comment '会员等级id',
     username char(64) comment '用户名',
     password varchar(64) comment '密码',
     nickname varchar(64) comment '昵称',
     mobile varchar(20) comment '手机号码',
     email varchar(64) comment '邮箱',
     header varchar(500) comment '头像',
     gender tinyint comment '性别',
     birth date comment '生日',
     city varchar(500) comment '所在城市',
     job varchar(255) comment '职业',
     sign varchar(255) comment '个性签名',
     source_type tinyint comment '用户来源',
     integration int comment '积分',
     growth int comment '成长值',
     status tinyint comment '启用状态',
     create_time datetime comment '注册时间',
     primary key (id)
  );
  alter table ums_member comment '会员';
  /*==============================================================*/
  /* Table: ums_member_collect_spu                                */
  /*==============================================================*/
  create table ums_member_collect_spu (
     id bigint not null comment 'id',
     member_id bigint comment '会员id',
     spu_id bigint comment 'spu_id',
     spu_name varchar(500) comment 'spu_name',
     spu_img varchar(500) comment 'spu_img',
     create_time datetime comment 'create_time',
     primary key (id)
  );
  alter table ums_member_collect_spu comment '会员收藏的商品';
  /*==============================================================*/
  /* Table: ums_member_collect_subject                            */
  /*==============================================================*/
  create table ums_member_collect_subject (
     id bigint not null auto_increment comment 'id',
     subject_id bigint comment 'subject_id',
     subject_name varchar(255) comment 'subject_name',
     subject_img varchar(500) comment 'subject_img',
     subject_urll varchar(500) comment '活动url',
     primary key (id)
  );
  alter table ums_member_collect_subject comment '会员收藏的专题活动';
  /*==============================================================*/
  /* Table: ums_member_level                                      */
  /*==============================================================*/
  create table ums_member_level (
     id bigint not null auto_increment comment 'id',
     name varchar(100) comment '等级名称',
     growth_point int comment '等级需要的成长值',
     default_status tinyint comment '是否为默认等级[0->不是；1->是]',
     free_freight_point decimal(18, 4) comment '免运费标准',
     comment_growth_point int comment '每次评价获取的成长值',
     priviledge_free_freight tinyint comment '是否有免邮特权',
     priviledge_member_price tinyint comment '是否有会员价格特权',
     priviledge_birthday tinyint comment '是否有生日特权',
     note varchar(255) comment '备注',
     primary key (id)
  );
  alter table ums_member_level comment '会员等级';
  /*==============================================================*/
  /* Table: ums_member_login_log                                  */
  /*==============================================================*/
  create table ums_member_login_log (
     id bigint not null auto_increment comment 'id',
     member_id bigint comment 'member_id',
     create_time datetime comment '创建时间',
     ip varchar(64) comment 'ip',
     city varchar(64) comment 'city',
     login_type tinyint(1) comment '登录类型[1-web，2-app]',
     primary key (id)
  );
  alter table ums_member_login_log comment '会员登录记录';
  /*==============================================================*/
  /* Table: ums_member_receive_address                            */
  /*==============================================================*/
  create table ums_member_receive_address (
     id bigint not null auto_increment comment 'id',
     member_id bigint comment 'member_id',
     name varchar(255) comment '收货人姓名',
     phone varchar(64) comment '电话',
     post_code varchar(64) comment '邮政编码',
     province varchar(100) comment '省份/直辖市',
     city varchar(100) comment '城市',
     region varchar(100) comment '区',
     detail_address varchar(255) comment '详细地址(街道)',
     areacode varchar(15) comment '省市区代码',
     default_status tinyint(1) comment '是否默认',
     primary key (id)
  );
  alter table ums_member_receive_address comment '会员收货地址';
  /*==============================================================*/
  /* Table: ums_member_statistics_info                            */
  /*==============================================================*/
  create table ums_member_statistics_info (
     id bigint not null auto_increment comment 'id',
     member_id bigint comment '会员id',
     consume_amount decimal(18, 4) comment '累计消费金额',
     coupon_amount decimal(18, 4) comment '累计优惠金额',
     order_count int comment '订单数量',
     coupon_count int comment '优惠券数量',
     comment_count int comment '评价数',
     return_order_count int comment '退货数量',
     login_count int comment '登录次数',
     attend_count int comment '关注数量',
     fans_count int comment '粉丝数量',
     collect_product_count int comment '收藏的商品数量',
     collect_subject_count int comment '收藏的专题活动数量',
     collect_comment_count int comment '收藏的评论数量',
     invite_friend_count int comment '邀请的朋友数量',
     primary key (id)
  );
  alter table ums_member_statistics_info comment '会员统计信息';