superdesk_superservice/sql/ming/sql.sql

   ALTER TABLE `tb_phone_message` 
   ADD COLUMN `total` INT NULL COMMENT '消息总数' ;
   ALTER TABLE `tb_email_send` 
   ADD COLUMN `total` INT NULL COMMENT '消息总数' ;
   ALTER TABLE `tb_wxtemplate_message` 
   ADD COLUMN `total` INT NULL COMMENT '消息总数' ;

   ALTER TABLE `tb_phone_message` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NULL  COMMENT '消息总数'
   ALTER TABLE `tb_email_send` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NULL  COMMENT '消息总数'
   ALTER TABLE `tb_wxtemplate_message` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NULL  COMMENT '消息总数'

   ALTER TABLE `tb_phone_message` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NOT NULL COMMENT '消息总数';
   ALTER TABLE `tb_email_send` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NOT NULL COMMENT '消息总数';
   ALTER TABLE `tb_wxtemplate_message` 
   CHANGE `total` `total` INT(11) DEFAULT '0' NOT NULL COMMENT '消息总数';

   DROP TABLE IF EXISTS `tb_wxtemplate_config_para`;

CREATE TABLE `tb_wxtemplate_config_para` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL COMMENT '对应type表的id',
  `name` varchar(255) DEFAULT NULL COMMENT '参数1',
  `param_key` varchar(255) DEFAULT NULL COMMENT '参数2',
  `value` text COMMENT '参数3',
  `message_id` int(11) DEFAULT NULL COMMENT '对应审核表的id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


alter table tb_phone_message
   add column msgCost int(11) DEFAULT '0' NULL COMMENT '短信消耗数' after `total`

CREATE TABLE `tr_app_user_floor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL COMMENT '楼宇id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `creator` varchar(25) DEFAULT NULL COMMENT '创建人',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `floor_id` int(11) DEFAULT NULL COMMENT '楼层id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

ALTER TABLE `tb_app_notice`   
  ADD COLUMN `content_txt` TEXT NULL  COMMENT '内容纯文本' AFTER `content`;
  
ALTER TABLE `tb_email_send`   
  ADD COLUMN `content_txt` TEXT NULL  COMMENT '内容纯文本' AFTER `email_centent`;