| 12345678910111213141516171819202122232425262728293031323334353637 |
- /* ---------------------------------------------------- */
- /* Generated by Enterprise Architect Version 12.0 */
- /* Created On : 05-Jan-2017 8:54:40 AM */
- /* DBMS : MySql */
- /* ---------------------------------------------------- */
- SET FOREIGN_KEY_CHECKS=0
- /* Drop Tables */
- DROP TABLE IF EXISTS `topics` CASCADE
- ;
- /* Create Tables */
- CREATE TABLE `topics`
- (
- `id` VARCHAR(32) NOT NULL COMMENT 'ID',
- `session_id` VARCHAR(50) NOT NULL COMMENT 'MUC会话ID',
- `name` VARCHAR(50) COMMENT '议题名称',
- `create_time` TIMESTAMP(0) COMMENT '创建时间',
- `end_by` VARCHAR(50) COMMENT '结束人ID',
- `end_time` TIMESTAMP(0) COMMENT '结束时间',
- `start_message_id` INTEGER COMMENT '消息起始ID',
- `end_message_id` INTEGER COMMENT '消息结束ID',
- `status` INT COMMENT '议题状态，0新建，1已回复未结束，10结束',
- CONSTRAINT `PK_topics` PRIMARY KEY (`id`)
- ) COMMENT='议题，仅MUC模式使用。'
- ;
- /* Create Primary Keys, Indexes, Uniques, Checks */
- ALTER TABLE `topics`
- ADD INDEX `IXFK_topics_sessions` (`session_id` ASC)
- ;
- SET FOREIGN_KEY_CHECKS=1
|
