數據庫 · 云平臺

~~~[sql] /* Navicat Premium Data Transfer Source Server : test.ikecin.com Source Server Type : MySQL Source Server Version : 50717 Source Host : test.ikecin.com:3306 Source Schema : ikecloud_v2_test3 Target Server Type : MySQL Target Server Version : 50717 File Encoding : 65001 Date: 23/01/2019 10:27:57 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin_named_user -- ---------------------------- DROP TABLE IF EXISTS `admin_named_user`; CREATE TABLE `admin_named_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用戶名', `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE, CONSTRAINT `admin_named_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '命名用戶登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_oauth_user -- ---------------------------- DROP TABLE IF EXISTS `admin_oauth_user`; CREATE TABLE `admin_oauth_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'open_id', `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '第三方登錄類型，qq、wechat等', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', `ext` json NULL COMMENT '額外信息', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`, `open_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `admin_oauth_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '第三方登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_phone_user -- ---------------------------- DROP TABLE IF EXISTS `admin_phone_user`; CREATE TABLE `admin_phone_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, UNIQUE INDEX `phone`(`phone`) USING BTREE, CONSTRAINT `admin_phone_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '手機號登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_user_config -- ---------------------------- DROP TABLE IF EXISTS `admin_user_config`; CREATE TABLE `admin_user_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `configs` json NULL COMMENT '配置項', `user_id` int(11) NOT NULL COMMENT '所屬用戶', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `admin_user_config_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶配置信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_user_info -- ---------------------------- DROP TABLE IF EXISTS `admin_user_info`; CREATE TABLE `admin_user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用戶昵稱', `recent_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for auth_group -- ---------------------------- DROP TABLE IF EXISTS `auth_group`; CREATE TABLE `auth_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶組中文名稱', `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父組 id', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '狀態 0 禁用 1 正常 ', `rules` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶組擁有的規則id，多個規則\",\"隔開', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶組表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for auth_group_access -- ---------------------------- DROP TABLE IF EXISTS `auth_group_access`; CREATE TABLE `auth_group_access` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用戶id', `group_id` int(11) NOT NULL COMMENT '用戶組id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uid`(`uid`, `group_id`) USING BTREE, CONSTRAINT `auth_group_access_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶組明細表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for auth_rule -- ---------------------------- DROP TABLE IF EXISTS `auth_rule`; CREATE TABLE `auth_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '規則唯一標識', `title` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '規則中文名稱', `type` tinyint(4) NOT NULL DEFAULT 1, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '狀態 0 禁用 1 正常 ', `condition` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '規則表達式，為空表示存在就驗證，不為空表示按照條件驗證', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 93 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '規則表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for device -- ---------------------------- DROP TABLE IF EXISTS `device`; CREATE TABLE `device` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設備默認名', `sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設備編號', `type` tinyint(4) NOT NULL COMMENT '設備類型', `subtype` tinyint(4) NOT NULL COMMENT '設備子類型', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '設備表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for device_apply -- ---------------------------- DROP TABLE IF EXISTS `device_apply`; CREATE TABLE `device_apply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設備序號', `num` int(11) NOT NULL COMMENT '數量', `user_id` int(11) NOT NULL COMMENT '用戶 id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '審核狀態 0 未審核 1成功 2 失敗', `delete_time` timestamp(0) NULL DEFAULT NULL, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, `download_num` int(11) NULL DEFAULT 0 COMMENT '下載次數', PRIMARY KEY (`id`) USING BTREE, INDEX `useid`(`user_id`) USING BTREE, CONSTRAINT `useid` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 116 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '設備 sn 申請表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for device_empower -- ---------------------------- DROP TABLE IF EXISTS `device_empower`; CREATE TABLE `device_empower` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設備編號', `user_id` int(11) NOT NULL COMMENT '用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_empower_sn`(`sn`, `user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25749 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理授權代理設備表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for device_group -- ---------------------------- DROP TABLE IF EXISTS `device_group`; CREATE TABLE `device_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分組名', `description` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分組描述', `parent_id` int(11) NULL DEFAULT NULL COMMENT '父分組id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`, `name`) USING BTREE, INDEX `create_time`(`create_time`) USING BTREE, CONSTRAINT `device_group_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶設備表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for device_statistics -- ---------------------------- DROP TABLE IF EXISTS `device_statistics`; CREATE TABLE `device_statistics` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sn` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設備序號', `value` json NOT NULL COMMENT '設備相關的數據', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `sn`(`sn`) USING BTREE, INDEX `create_time`(`create_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '設備信息收集表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `version` bigint(20) NOT NULL, `migration_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `start_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `end_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `breakpoint` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`version`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_permissions -- ---------------------------- DROP TABLE IF EXISTS `rbac_permissions`; CREATE TABLE `rbac_permissions` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`ID`) USING BTREE, INDEX `Lft`(`Lft`) USING BTREE, INDEX `Rght`(`Rght`) USING BTREE, INDEX `Title`(`Title`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_rolepermissions -- ---------------------------- DROP TABLE IF EXISTS `rbac_rolepermissions`; CREATE TABLE `rbac_rolepermissions` ( `RoleID` int(11) NOT NULL, `PermissionID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`RoleID`, `PermissionID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_roles -- ---------------------------- DROP TABLE IF EXISTS `rbac_roles`; CREATE TABLE `rbac_roles` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`ID`) USING BTREE, INDEX `Lft`(`Lft`) USING BTREE, INDEX `Rght`(`Rght`) USING BTREE, INDEX `Title`(`Title`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_userroles -- ---------------------------- DROP TABLE IF EXISTS `rbac_userroles`; CREATE TABLE `rbac_userroles` ( `UserID` int(11) NOT NULL, `RoleID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`UserID`, `RoleID`) USING BTREE, CONSTRAINT `rbac_userroles_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_device -- ---------------------------- DROP TABLE IF EXISTS `user_device`; CREATE TABLE `user_device` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用戶定義設備名', `device_id` int(11) NOT NULL COMMENT '用戶設備', `user_id` int(11) NOT NULL COMMENT '用戶id', `group_id` int(11) NULL DEFAULT NULL COMMENT '設備所在分組', `password` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '設備密碼', `position` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '設備所在位置', `remark` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '設備備注信息', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `device_id`(`device_id`, `user_id`) USING BTREE, INDEX `create_time`(`create_time`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `group_id`(`group_id`) USING BTREE, CONSTRAINT `user_device_ibfk_1` FOREIGN KEY (`device_id`) REFERENCES `device` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_device_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_device_ibfk_3` FOREIGN KEY (`group_id`) REFERENCES `device_group` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶設備表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_info -- ---------------------------- DROP TABLE IF EXISTS `user_info`; CREATE TABLE `user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用戶昵稱', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名', `avatar` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '頭像地址', `gender` enum('male','female','secret') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'secret' COMMENT '性別 male 男 female 女 secret 保密', `address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所在地址', `login_num` smallint(6) NOT NULL DEFAULT 0 COMMENT '登錄次數', `last_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄', `company_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名稱', `expire_date` datetime(0) NOT NULL DEFAULT '2099-12-31 23:59:59' COMMENT '賬戶到期時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態 0 未認證 1 正常 2 鎖定', `remarks` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '備注信息', `position` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所在位置', `parent_id` int(11) NOT NULL DEFAULT 1 COMMENT '上級管理 id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, `power` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '[]' COMMENT '申請sn 權限', PRIMARY KEY (`id`) USING BTREE, INDEX `create_time`(`create_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_log -- ---------------------------- DROP TABLE IF EXISTS `user_log`; CREATE TABLE `user_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `content` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作內容', `category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作類別分配設備之類', `result` enum('success','fail') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'success' COMMENT '操作結果', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶操作記錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_login -- ---------------------------- DROP TABLE IF EXISTS `user_login`; CREATE TABLE `user_login` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶資料', `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手機號', `username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄用戶名', `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '郵箱號', `qq` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'qq登錄的標志', `wechat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信登錄的標志', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `phone`(`phone`, `user_id`) USING BTREE, UNIQUE INDEX `username`(`username`, `user_id`) USING BTREE, UNIQUE INDEX `email`(`email`, `user_id`) USING BTREE, UNIQUE INDEX `qq`(`qq`, `user_id`) USING BTREE, UNIQUE INDEX `wechat`(`wechat`, `user_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_login_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶登錄表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; ~~~ >[info] 其中用到的表有： user_login 、 user_info 、 device_empower 、 device_apply 、 auth_group 、 auth_group_access 、 auth_rule