zentao/db/upgradexuanxuan2.5.7.sql

ALTER TABLE `zt_im_chatuser` ADD `freeze` ENUM('0', '1') NOT NULL DEFAULT '0'  AFTER `mute`;
ALTER TABLE `zt_im_message` CHANGE `contentType` `contentType` ENUM('text', 'plain', 'emotion', 'image', 'file', 'code', 'object')  CHARACTER SET utf8mb4  COLLATE utf8mb4_general_ci  NOT NULL  DEFAULT 'text';
ALTER TABLE `zt_im_client` CHANGE `version` `version` char(30) NOT NULL DEFAULT '';

-- DROP TABLE IF EXISTS `zt_im_queue`;
CREATE TABLE IF NOT EXISTS `zt_im_queue` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `type` char(30) NOT NULL,
  `content` text NULL,
  `addDate` datetime NULL,
  `processDate` datetime NULL,
  `result` text NULL,
  `status` char(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;