92 lines
3.7 KiB
SQL
92 lines
3.7 KiB
SQL
CREATE TABLE IF NOT EXISTS `zt_im_chat` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`gid` char(40) NOT NULL DEFAULT '',
|
|
`name` varchar(60) NOT NULL DEFAULT '',
|
|
`type` varchar(20) NOT NULL DEFAULT 'group',
|
|
`admins` varchar(255) NOT NULL DEFAULT '',
|
|
`committers` varchar(255) NOT NULL DEFAULT '',
|
|
`subject` mediumint(8) unsigned NOT NULL DEFAULT 0,
|
|
`public` enum('0', '1') NOT NULL DEFAULT '0',
|
|
`createdBy` varchar(30) NOT NULL DEFAULT '',
|
|
`createdDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`editedBy` varchar(30) NOT NULL DEFAULT '',
|
|
`editedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`lastActiveTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dismissDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`id`),
|
|
KEY `gid` (`gid`),
|
|
KEY `name` (`name`),
|
|
KEY `type` (`type`),
|
|
KEY `public` (`public`),
|
|
KEY `createdBy` (`createdBy`),
|
|
KEY `editedBy` (`editedBy`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
CREATE TABLE IF NOT EXISTS `zt_im_chatuser` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`cgid` char(40) NOT NULL DEFAULT '',
|
|
`user` mediumint(8) NOT NULL DEFAULT 0,
|
|
`order` smallint(5) NOT NULL DEFAULT 0,
|
|
`star` enum('0', '1') NOT NULL DEFAULT '0',
|
|
`hide` enum('0', '1') NOT NULL DEFAULT '0',
|
|
`mute` enum('0', '1') NOT NULL DEFAULT '0',
|
|
`freeze` enum('0', '1') NOT NULL DEFAULT '0',
|
|
`join` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`quit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`category` varchar(40) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`),
|
|
KEY `cgid` (`cgid`),
|
|
KEY `user` (`user`),
|
|
KEY `order` (`order`),
|
|
KEY `star` (`star`),
|
|
KEY `hide` (`hide`),
|
|
UNIQUE KEY `chatuser` (`cgid`, `user`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
CREATE TABLE IF NOT EXISTS `zt_im_client` (
|
|
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
|
`version` char(30) NOT NULL DEFAULT '',
|
|
`desc` varchar(100) NOT NULL DEFAULT '',
|
|
`changeLog` text NOT NULL,
|
|
`strategy` varchar(10) NOT NULL DEFAULT '',
|
|
`downloads` text NOT NULL,
|
|
`createdDate` datetime NOT NULL,
|
|
`createdBy` varchar(30) NOT NULL DEFAULT '',
|
|
`editedDate` datetime NOT NULL,
|
|
`editedBy` varchar(30) NOT NULL DEFAULT '',
|
|
`status` enum('released','wait') NOT NULL DEFAULT 'wait',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
CREATE TABLE IF NOT EXISTS `zt_im_message` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`gid` char(40) NOT NULL DEFAULT '',
|
|
`cgid` char(40) NOT NULL DEFAULT '',
|
|
`user` varchar(30) NOT NULL DEFAULT '',
|
|
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`order` bigint(8) unsigned NOT NULL,
|
|
`type` enum('normal', 'broadcast', 'notify') NOT NULL DEFAULT 'normal',
|
|
`content` text NOT NULL DEFAULT '',
|
|
`contentType` enum('text', 'plain', 'emotion', 'image', 'file', 'object', 'code') NOT NULL DEFAULT 'text',
|
|
`data` text NOT NULL DEFAULT '',
|
|
`deleted` enum('0','1') NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
KEY `mgid` (`gid`),
|
|
KEY `mcgid` (`cgid`),
|
|
KEY `muser` (`user`),
|
|
KEY `mtype` (`type`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
CREATE TABLE IF NOT EXISTS `zt_im_messagestatus` (
|
|
`user` mediumint(8) NOT NULL DEFAULT 0,
|
|
`message` int(11) unsigned NOT NULL,
|
|
`status` enum('waiting','sent','readed','deleted') NOT NULL DEFAULT 'waiting',
|
|
UNIQUE KEY `user` (`user`,`message`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
CREATE TABLE IF NOT EXISTS `zt_im_queue` (
|
|
`id` mediumint(8) unsigned NOT NULL auto_increment,
|
|
`type` char(30) NOT NULL,
|
|
`content` text NOT NULL,
|
|
`addDate` datetime NOT NULL,
|
|
`processDate` datetime NOT NULL,
|
|
`result` text NOT NULL,
|
|
`status` char(30) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|