From 6d519474e44855682043d3c40db2c86a6822caca Mon Sep 17 00:00:00 2001 From: lrj <owen.stl@gmail.com> Date: 星期三, 24 九月 2025 19:37:59 +0800 Subject: [PATCH] 修改员工和评委的设置 --- db.sql | 552 +++++++++++++++++++++++++++++++------------------------ 1 files changed, 312 insertions(+), 240 deletions(-) diff --git a/db.sql b/db.sql index c3ce285..bb5e6e1 100644 --- a/db.sql +++ b/db.sql @@ -1,326 +1,398 @@ -- Database schema dump for ryc +-- Generated at: Wed Sep 24 16:07:24 GMT+08:00 2025 -- Table: t_activity -CREATE TABLE t_activity ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_activity` ( + `id` bigint NOT NULL AUTO_INCREMENT, `pid` bigint NOT NULL DEFAULT '0', - `path` varchar(255) NOT NULL, - `name` varchar(128) NOT NULL, - `description` text, + `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `signup_deadline` datetime NOT NULL, - `match_time` datetime, - `address` varchar(255), + `match_time` datetime DEFAULT NULL, + `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `rating_scheme_id` bigint NOT NULL, - `player_max` int COMMENT '浜烘暟涓婇檺', + `player_max` int DEFAULT NULL COMMENT '浜烘暟涓婇檺', `state` int NOT NULL DEFAULT '1' COMMENT '0:鏈彂甯冿紝 1锛氬彂甯冿細2锛氬叧闂�', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + KEY `fk_t_activity_rating_scheme` (`rating_scheme_id`) USING BTREE, + KEY `idx_t_activity_deadline` (`signup_deadline`) USING BTREE, + CONSTRAINT `fk_t_activity_rating_scheme` FOREIGN KEY (`rating_scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_activity_judge -CREATE TABLE t_activity_judge ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_activity_judge` ( + `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, `stage_id` bigint NOT NULL, `judge_id` bigint NOT NULL, - `description` varchar(255), - `state` int, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `state` int DEFAULT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `uq_stage_judge` (`stage_id`,`judge_id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- Table: t_activity_player +CREATE TABLE `t_activity_player` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `activity_id` bigint NOT NULL, + `stage_id` bigint NOT NULL COMMENT '姣旇禌闃舵锛岄�昏緫鍜宼_activity_judge 淇濇寔涓�鑷淬��', + `player_id` bigint NOT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `judge_id` bigint DEFAULT NULL COMMENT '璇勫', + `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, + `total_score` decimal(19,4) DEFAULT NULL COMMENT '浣庡垎', + `rank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鍚嶆', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- Table: t_activity_player_rating +CREATE TABLE `t_activity_player_rating` ( + `id` bigint NOT NULL, + `activity_id` bigint NOT NULL, + `activity_player_id` bigint DEFAULT NULL, + `stage_id` bigint NOT NULL, + `player_id` bigint NOT NULL COMMENT '鍐椾綑瀛楁', + `judge_id` bigint DEFAULT NULL, + `total_score` decimal(19,2) DEFAULT NULL, + `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '璇勪环鍐呭', + `state` int NOT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Table: t_activity_player_rating_item -CREATE TABLE t_activity_player_rating_item ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_activity_player_rating_item` ( + `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, + `activity_player_id` bigint NOT NULL, + `activity_player_rating_id` bigint NOT NULL, + `stage_id` bigint NOT NULL, `player_id` bigint NOT NULL, + `judge_id` bigint NOT NULL, `rating_scheme_id` bigint NOT NULL, `rating_item_id` bigint NOT NULL, `score` decimal(10,2) NOT NULL, - `feedback` text, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, + `state` int NOT NULL DEFAULT '1', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; --- Table: t_avtivity_player -CREATE TABLE t_avtivity_player ( - `id` bigint NOT NULL auto_increment, - `activity_id` bigint NOT NULL, - `player_id` bigint NOT NULL, - `description` varchar(255), - `reject_reason` varchar(255), - `judge_id` bigint COMMENT '璇勫', - `feedback` text, - `total_score` decimal(19,4) COMMENT '浣庡垎', - `rank` varchar(255) COMMENT '鍚嶆', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); - --- Table: t_carousel -- 杞挱鍥� -CREATE TABLE t_carousel ( - `id` bigint NOT NULL auto_increment, - `title` varchar(128) NOT NULL, - `description` varchar(255), - `sort_order` int NOT NULL, +-- Table: t_carousel +CREATE TABLE `t_carousel` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `sort_order` int DEFAULT NULL, `state` int NOT NULL DEFAULT '1' COMMENT '0:鍏抽棴锛�1锛氫娇鐢�', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='杞挱鍥�'; -- Table: t_employee -CREATE TABLE t_employee ( - `id` bigint NOT NULL auto_increment, - `name` varchar(64) NOT NULL, - `phone` varchar(32) NOT NULL, - `password` varchar(128) NOT NULL, - `status` varchar(16) NOT NULL, +CREATE TABLE `t_employee` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `user_id` bigint NOT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', - `role_code` varchar(32) NOT NULL, - `user_id` bigint NOT NULL -); + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `phone` (`phone`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_employee_role -CREATE TABLE t_employee_role ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_employee_role` ( + `id` bigint NOT NULL AUTO_INCREMENT, `employee_id` bigint NOT NULL, `role_id` bigint NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + KEY `fk_t_user_role_role` (`role_id`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_judge -CREATE TABLE t_judge ( - `id` bigint NOT NULL auto_increment, - `name` varchar(64) NOT NULL, - `user_id` bigint, - `phone` varchar(32) NOT NULL, - `gender` int, +CREATE TABLE `t_judge` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `user_id` bigint DEFAULT NULL, + `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `gender` int DEFAULT NULL, `state` int NOT NULL DEFAULT '1', - `role_id` bigint, - `description` varchar(255), - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `role_id` bigint DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + `title` varchar(128) DEFAULT NULL COMMENT '鑱屼綅/澶磋', + `company` varchar(128) DEFAULT NULL COMMENT '鍏徃/鏈烘瀯', + `introduction` text COMMENT '涓汉浠嬬粛', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `phone` (`phone`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_judge_tag -CREATE TABLE t_judge_tag ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_judge_tag` ( + `id` bigint NOT NULL AUTO_INCREMENT, `judge_id` bigint NOT NULL, `tag_id` bigint NOT NULL, `state` int NOT NULL DEFAULT '1', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + KEY `fk_t_judge_major_tag` (`tag_id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_media -CREATE TABLE t_media ( - `id` int NOT NULL auto_increment, - `name` varchar(255), +CREATE TABLE `t_media` ( + `id` int NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `target_type` int NOT NULL, `target_id` bigint NOT NULL, `media_type` int NOT NULL, - `path` varchar(500) NOT NULL COMMENT '鑵捐浜戠殑瀛樺偍妗跺湴鍧�', - `thumb_path` varchar(500), - `file_ext` varchar(20) NOT NULL, + `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鑵捐浜戠殑瀛樺偍妗跺湴鍧�', + `thumb_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `file_ext` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `file_size` int NOT NULL, - `duration` int COMMENT '瑙嗛鐨勯暱搴︾', - `description` varchar(255), - `state` varchar(255), - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `duration` int DEFAULT NULL COMMENT '瑙嗛鐨勯暱搴︾', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_notification_task -CREATE TABLE t_notification_task ( - `id` bigint NOT NULL auto_increment, - `type` varchar(32) NOT NULL, - `channel` varchar(64) NOT NULL, - `target_type` varchar(32) NOT NULL COMMENT '1:瀛﹀憳锛�2锛氳瘎濮旓紝3锛氬伐浣滀汉鍛�', +CREATE TABLE `t_notification_task` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `channel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `target_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1:瀛﹀憳锛�2锛氳瘎濮旓紝3锛氬伐浣滀汉鍛�', `target_id` bigint NOT NULL, - `payload` text COMMENT '娑堟伅鍐呭', - `error_message` varchar(512), + `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '娑堟伅鍐呭', + `error_message` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `retry_count` int NOT NULL, - `next_retry_at` datetime, + `next_retry_at` datetime DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_permission -CREATE TABLE t_permission ( - `id` bigint NOT NULL auto_increment, - `code` varchar(128) NOT NULL, - `name` varchar(128) NOT NULL, - `category` varchar(64), - `description` varchar(255), +CREATE TABLE `t_permission` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `code` (`code`) USING BTREE, + KEY `idx_t_permission_code` (`code`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_player -CREATE TABLE t_player ( - `id` bigint NOT NULL auto_increment, - `name` varchar(64) NOT NULL, - `phone` varchar(32) NOT NULL, +CREATE TABLE `t_player` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `role_id` bigint NOT NULL, - `description` varchar(255), - `gender` int COMMENT '0:濂筹紝1锛氱敺', - `education` varchar(32), - `introduction` text, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `gender` int DEFAULT NULL COMMENT '0:濂筹紝1锛氱敺', + `education` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `audit_state` int NOT NULL COMMENT '0绛夊緟瀹℃牳锛�1锛氬鏍搁�氳繃锛�2锛氫笉閫氳繃', - `reject_reason` varchar(255), - `final_score` decimal(10,2), + `reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `final_score` decimal(10,2) DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', - `user_id` bigint NOT NULL -); + `user_id` bigint NOT NULL, + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `phone` (`phone`) USING BTREE, + KEY `idx_t_player_activity_status` (`audit_state`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_rating_item -CREATE TABLE t_rating_item ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_rating_item` ( + `id` bigint NOT NULL AUTO_INCREMENT, `scheme_id` bigint NOT NULL, - `name` varchar(128) NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `max_score` int NOT NULL, `order_no` int NOT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + KEY `idx_t_rating_item_scheme` (`scheme_id`) USING BTREE, + CONSTRAINT `fk_t_rating_item_scheme` FOREIGN KEY (`scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_rating_scheme -CREATE TABLE t_rating_scheme ( - `id` bigint NOT NULL auto_increment, - `name` varchar(128) NOT NULL, - `description` varchar(512), +CREATE TABLE `t_rating_scheme` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_region -CREATE TABLE t_region ( - `id` bigint NOT NULL auto_increment, +CREATE TABLE `t_region` ( + `id` bigint NOT NULL AUTO_INCREMENT, `pid` bigint NOT NULL COMMENT '鑷叧鑱�', - `name` varchar(64) NOT NULL, - `code` varchar(32) NOT NULL, + `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `level` int NOT NULL, `leaf_flag` tinyint(1) NOT NULL DEFAULT '0', - `full_path` varchar(256), + `full_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `code` (`code`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_role -CREATE TABLE t_role ( - `id` bigint NOT NULL auto_increment, - `code` varchar(64) NOT NULL, - `name` varchar(128) NOT NULL, - `description` varchar(255), +CREATE TABLE `t_role` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `code` (`code`) USING BTREE, + KEY `idx_t_role_code` (`code`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_role_permission -CREATE TABLE t_role_permission ( - `id` int NOT NULL auto_increment, +CREATE TABLE `t_role_permission` ( + `id` int NOT NULL AUTO_INCREMENT, `role_id` bigint NOT NULL, `permission_id` bigint NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + KEY `fk_t_role_permission_perm` (`permission_id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_tag -CREATE TABLE t_tag ( - `id` bigint NOT NULL auto_increment, - `name` varchar(64) NOT NULL, - `code` varchar(64) NOT NULL, - `category` varchar(32) NOT NULL, - `description` varchar(255), +CREATE TABLE `t_tag` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `category` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, - `version` bigint NOT NULL DEFAULT '0' -); + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, + `version` bigint NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE KEY `code` (`code`) USING BTREE, + KEY `idx_t_tag_category` (`category`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_user -CREATE TABLE t_user ( - `id` bigint NOT NULL auto_increment, - `name` varchar(255) NOT NULL, - `gender` int, - `phone` varchar(20), - `birthday` date, - `wx_openid` varchar(50) NOT NULL, - `wx_unionid` varchar(50) NOT NULL, - `wx_oa_openid` varchar(50), - `password` varchar(255), +CREATE TABLE `t_user` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `gender` int DEFAULT NULL, + `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `birthday` date DEFAULT NULL, + `wx_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `wx_unionid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `wx_oa_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, - `create_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED, - `create_user_id` bigint, - `update_time` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' DEFAULT_GENERATED on update CURRENT_TIMESTAMP, - `update_user_id` bigint, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `create_user_id` bigint DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', - `mobile` varchar(20) -); + `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE, + KEY `uq_openid` (`wx_openid`) USING BTREE, + KEY `uq_unionid` (`wx_unionid`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + -- Gitblit v1.8.0