/*Table structure for table `t_operation_message` */
DROP TABLE IF EXISTS `t_operation_message`;
CREATE TABLE `t_operation_message` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`topic` varchar(255) NOT NULL COMMENT '消息主題',
`retry_count` int(11) DEFAULT '0' COMMENT '重試次數',
`detail` json DEFAULT NULL COMMENT '消息數據',
`message_status` int(11) NOT NULL COMMENT '狀態',
`create_time` datetime NOT NULL COMMENT '創建時間',
`update_time` datetime NOT NULL COMMENT '更新時間',
PRIMARY KEY (`id`),
KEY `idx_topic_status` (`topic`,`message_status`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COMMENT='操作消息表';
/*Table structure for table `t_process_lock` */
DROP TABLE IF EXISTS `t_process_lock`;
CREATE TABLE `t_process_lock` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`lock_name` varchar(150) NOT NULL COMMENT '鎖名稱',
`address` varchar(40) DEFAULT NULL COMMENT '地址',
`update_time` datetime DEFAULT NULL COMMENT '更新時間',
`ver` bigint(20) DEFAULT NULL COMMENT '版本',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_lock_name` (`lock_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COMMENT='處理鎖';
CREATE TABLE `t_user` (
`pkId` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`id` VARCHAR(20) NOT NULL COMMENT 'ID',
`avatar` VARCHAR(200) DEFAULT NULL COMMENT '頭像',
`email` VARCHAR(100) DEFAULT NULL COMMENT '郵箱',
`last_login_date` DATETIME DEFAULT NULL,
`last_login_ip` VARCHAR(255) DEFAULT NULL,
`last_login_location` VARCHAR(255) DEFAULT NULL,
`login_fail_times` INT(11) DEFAULT NULL,
`nickname` VARCHAR(50) DEFAULT NULL,
`password` VARCHAR(100) NOT NULL,
`mobile` VARCHAR(100) DEFAULT NULL,
`user_status` TINYINT(2) DEFAULT NULL,
`username` VARCHAR(100) NOT NULL,
`gender` VARCHAR(10) DEFAULT NULL,
`create_time` DATETIME NOT NULL,
`update_time` DATETIME NOT NULL,
PRIMARY KEY (`pkId`),
UNIQUE KEY `uni_user_username` (`username`),
UNIQUE KEY `uni_user_email` (`email`),
UNIQUE KEY `uni_user_id` (`id`),
UNIQUE KEY `uni_user_mobile` (`mobile`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT='用戶信息';
CREATE TABLE `t_message` (
`pk_id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`id` VARCHAR(20) NOT NULL COMMENT '消息ID',
`session_id` VARCHAR(20) NOT NULL COMMENT '會話ID',
`to_user_id` VARCHAR(20) NOT NULL COMMENT '接受用戶',
`user_id` VARCHAR(20) NOT NULL COMMENT '用戶ID',
`user_type` VARCHAR(20) NOT NULL COMMENT '用戶類型',
`content` JSON DEFAULT NULL COMMENT '消息數據',
`message_type` INT(20) NOT NULL COMMENT '消息類型',
`ref_biz_id` VARCHAR(60) DEFAULT NULL COMMENT '引用ID',
`ref_biz_type` INT(10) DEFAULT NULL COMMENT '引用類型',
`biz_code` VARCHAR(20) NOT NULL COMMENT '業務碼',
`message_status` TINYINT NOT NULL COMMENT '消息狀態',
`create_time` DATETIME NOT NULL COMMENT '創建時間',
`update_time` DATETIME NOT NULL COMMENT '更新時間',
`ver` BIGINT(20) DEFAULT 0 COMMENT '版本',
PRIMARY KEY (`pk_id`),
KEY `index_to_session_user_id_biz` (`session_id`,`biz_code`),
KEY `index_session_ref` (`session_id`,`biz_code`,`ref_biz_type`,`ref_biz_id`),
UNIQUE KEY `index_message_id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COMMENT='消息表';
