SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for ke_alarm_clusters -- ---------------------------- DROP TABLE IF EXISTS `ke_alarm_clusters`; CREATE TABLE `ke_alarm_clusters` ( `id` bigint NOT NULL AUTO_INCREMENT, `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `server` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `alarm_times` int NULL DEFAULT NULL, `alarm_max_times` int NULL DEFAULT NULL, `alarm_level` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_normal` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Y', `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Y', `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_alarm_clusters -- ---------------------------- -- ---------------------------- -- Table structure for ke_alarm_config -- ---------------------------- DROP TABLE IF EXISTS `ke_alarm_config`; CREATE TABLE `ke_alarm_config` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `alarm_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `alarm_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `http_method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `alarm_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`cluster`, `alarm_group`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_alarm_config -- ---------------------------- -- ---------------------------- -- Table structure for ke_alarm_consumer -- ---------------------------- DROP TABLE IF EXISTS `ke_alarm_consumer`; CREATE TABLE `ke_alarm_consumer` ( `id` bigint NOT NULL AUTO_INCREMENT, `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `topic` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lag` bigint NULL DEFAULT NULL, `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `alarm_times` int NULL DEFAULT NULL, `alarm_max_times` int NULL DEFAULT NULL, `alarm_level` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_normal` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Y', `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Y', `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_alarm_consumer -- ---------------------------- -- ---------------------------- -- Table structure for ke_alarm_crontab -- ---------------------------- DROP TABLE IF EXISTS `ke_alarm_crontab`; CREATE TABLE `ke_alarm_crontab` ( `id` bigint NOT NULL, `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `crontab` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Y', `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`, `type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_alarm_crontab -- ---------------------------- -- ---------------------------- -- Table structure for ke_connect_config -- ---------------------------- DROP TABLE IF EXISTS `ke_connect_config`; CREATE TABLE `ke_connect_config` ( `id` bigint NOT NULL AUTO_INCREMENT, `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `connect_uri` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `alive` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_connect_config -- ---------------------------- -- ---------------------------- -- Table structure for ke_consumer_bscreen -- ---------------------------- DROP TABLE IF EXISTS `ke_consumer_bscreen`; CREATE TABLE `ke_consumer_bscreen` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `logsize` bigint NULL DEFAULT NULL, `difflogsize` bigint NULL DEFAULT NULL, `offsets` bigint NULL DEFAULT NULL, `diffoffsets` bigint NULL DEFAULT NULL, `lag` bigint NULL DEFAULT NULL, `timespan` bigint NULL DEFAULT NULL, `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, INDEX `idx_timespan`(`timespan`) USING BTREE, INDEX `idx_tm_cluster_diffoffsets`(`tm`, `cluster`, `diffoffsets`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_consumer_bscreen -- ---------------------------- -- ---------------------------- -- Table structure for ke_consumer_group -- ---------------------------- DROP TABLE IF EXISTS `ke_consumer_group`; CREATE TABLE `ke_consumer_group` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `topic` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `status` int NULL DEFAULT NULL, PRIMARY KEY (`cluster`, `group`, `topic`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_consumer_group -- ---------------------------- -- ---------------------------- -- Table structure for ke_consumer_group_summary -- ---------------------------- DROP TABLE IF EXISTS `ke_consumer_group_summary`; CREATE TABLE `ke_consumer_group_summary` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `topic_number` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `coordinator` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `active_topic` int NULL DEFAULT NULL, `active_thread_total` int NULL DEFAULT NULL, PRIMARY KEY (`cluster`, `group`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_consumer_group_summary -- ---------------------------- -- ---------------------------- -- Table structure for ke_logsize -- ---------------------------- DROP TABLE IF EXISTS `ke_logsize`; CREATE TABLE `ke_logsize` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `logsize` bigint NULL DEFAULT NULL, `diffval` bigint NULL DEFAULT NULL, `timespan` bigint NULL DEFAULT NULL, `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, INDEX `idx_timespan`(`timespan`) USING BTREE, INDEX `idx_tm_topic`(`tm`, `topic`) USING BTREE, INDEX `idx_tm_cluster_diffval`(`tm`, `cluster`, `diffval`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_logsize -- ---------------------------- -- ---------------------------- -- Table structure for ke_metrics -- ---------------------------- DROP TABLE IF EXISTS `ke_metrics`; CREATE TABLE `ke_metrics` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `broker` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `timespan` bigint NULL DEFAULT NULL, `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_metrics -- ---------------------------- -- ---------------------------- -- Table structure for ke_metrics_offline -- ---------------------------- DROP TABLE IF EXISTS `ke_metrics_offline`; CREATE TABLE `ke_metrics_offline` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `one` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `mean` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `five` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `fifteen` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`cluster`, `key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_metrics_offline -- ---------------------------- -- ---------------------------- -- Table structure for ke_p_role -- ---------------------------- DROP TABLE IF EXISTS `ke_p_role`; CREATE TABLE `ke_p_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'role name', `seq` tinyint NOT NULL COMMENT 'rank', `description` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'role describe', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_p_role -- ---------------------------- INSERT INTO `ke_p_role` VALUES (1, 'Administrator', 1, 'Have all permissions'); INSERT INTO `ke_p_role` VALUES (2, 'Devs', 2, 'Own add or delete'); INSERT INTO `ke_p_role` VALUES (3, 'Tourist', 3, 'only viewer'); -- ---------------------------- -- Table structure for ke_resources -- ---------------------------- DROP TABLE IF EXISTS `ke_resources`; CREATE TABLE `ke_resources` ( `resource_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'resource name', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `parent_id` int NOT NULL, PRIMARY KEY (`resource_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_resources -- ---------------------------- INSERT INTO `ke_resources` VALUES (1, 'System', '/system', -1); INSERT INTO `ke_resources` VALUES (2, 'User', '/system/user', 1); INSERT INTO `ke_resources` VALUES (3, 'Role', '/system/role', 1); INSERT INTO `ke_resources` VALUES (4, 'Resource', '/system/resource', 1); INSERT INTO `ke_resources` VALUES (5, 'Notice', '/system/notice', 1); INSERT INTO `ke_resources` VALUES (6, 'Topic', '/topic', -1); INSERT INTO `ke_resources` VALUES (7, 'Message', '/topic/message', 6); INSERT INTO `ke_resources` VALUES (8, 'Create', '/topic/create', 6); INSERT INTO `ke_resources` VALUES (9, 'Alarm', '/alarm', -1); INSERT INTO `ke_resources` VALUES (10, 'Add', '/alarm/add', 9); INSERT INTO `ke_resources` VALUES (11, 'Modify', '/alarm/modify', 9); INSERT INTO `ke_resources` VALUES (12, 'Cluster', '/cluster', -1); INSERT INTO `ke_resources` VALUES (13, 'ZkCli', '/cluster/zkcli', 12); INSERT INTO `ke_resources` VALUES (14, 'UserDelete', '/system/user/delete', 1); INSERT INTO `ke_resources` VALUES (15, 'UserModify', '/system/user/modify', 1); INSERT INTO `ke_resources` VALUES (16, 'Mock', '/topic/mock', 6); INSERT INTO `ke_resources` VALUES (18, 'Create', '/alarm/create', 9); INSERT INTO `ke_resources` VALUES (19, 'History', '/alarm/history', 9); INSERT INTO `ke_resources` VALUES (20, 'Manager', '/topic/manager', 6); INSERT INTO `ke_resources` VALUES (21, 'PasswdReset', '/system/user/reset', 1); INSERT INTO `ke_resources` VALUES (22, 'Config', '/alarm/config', 9); INSERT INTO `ke_resources` VALUES (23, 'List', '/alarm/list', 9); INSERT INTO `ke_resources` VALUES (24, 'Hub', '/topic/hub', 6); -- ---------------------------- -- Table structure for ke_role_resource -- ---------------------------- DROP TABLE IF EXISTS `ke_role_resource`; CREATE TABLE `ke_role_resource` ( `id` bigint NOT NULL AUTO_INCREMENT, `role_id` int NOT NULL, `resource_id` int NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_role_resource -- ---------------------------- INSERT INTO `ke_role_resource` VALUES (1, 1, 1); INSERT INTO `ke_role_resource` VALUES (2, 1, 2); INSERT INTO `ke_role_resource` VALUES (3, 1, 3); INSERT INTO `ke_role_resource` VALUES (4, 1, 4); INSERT INTO `ke_role_resource` VALUES (5, 1, 5); INSERT INTO `ke_role_resource` VALUES (6, 1, 7); INSERT INTO `ke_role_resource` VALUES (7, 1, 8); INSERT INTO `ke_role_resource` VALUES (8, 1, 10); INSERT INTO `ke_role_resource` VALUES (9, 1, 11); INSERT INTO `ke_role_resource` VALUES (10, 1, 13); INSERT INTO `ke_role_resource` VALUES (11, 2, 7); INSERT INTO `ke_role_resource` VALUES (12, 2, 8); INSERT INTO `ke_role_resource` VALUES (13, 2, 13); INSERT INTO `ke_role_resource` VALUES (14, 2, 10); INSERT INTO `ke_role_resource` VALUES (15, 2, 11); INSERT INTO `ke_role_resource` VALUES (16, 1, 14); INSERT INTO `ke_role_resource` VALUES (17, 1, 15); INSERT INTO `ke_role_resource` VALUES (18, 1, 16); INSERT INTO `ke_role_resource` VALUES (19, 1, 18); INSERT INTO `ke_role_resource` VALUES (20, 1, 19); INSERT INTO `ke_role_resource` VALUES (21, 1, 20); INSERT INTO `ke_role_resource` VALUES (22, 1, 21); INSERT INTO `ke_role_resource` VALUES (23, 1, 22); INSERT INTO `ke_role_resource` VALUES (24, 1, 23); INSERT INTO `ke_role_resource` VALUES (25, 1, 24); -- ---------------------------- -- Table structure for ke_sql_history -- ---------------------------- DROP TABLE IF EXISTS `ke_sql_history`; CREATE TABLE `ke_sql_history` ( `id` bigint NOT NULL AUTO_INCREMENT, `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `host` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ksql` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `spend_time` bigint NULL DEFAULT NULL, `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_sql_history -- ---------------------------- -- ---------------------------- -- Table structure for ke_topic_rank -- ---------------------------- DROP TABLE IF EXISTS `ke_topic_rank`; CREATE TABLE `ke_topic_rank` ( `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `tkey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `tvalue` bigint NULL DEFAULT NULL, PRIMARY KEY (`cluster`, `topic`, `tkey`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_topic_rank -- ---------------------------- -- ---------------------------- -- Table structure for ke_user_role -- ---------------------------- DROP TABLE IF EXISTS `ke_user_role`; CREATE TABLE `ke_user_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `role_id` tinyint NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_user_role -- ---------------------------- INSERT INTO `ke_user_role` VALUES (1, 1, 1); -- ---------------------------- -- Table structure for ke_users -- ---------------------------- DROP TABLE IF EXISTS `ke_users`; CREATE TABLE `ke_users` ( `id` bigint NOT NULL AUTO_INCREMENT, `rtxno` int NOT NULL, `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `realname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ke_users -- ---------------------------- INSERT INTO `ke_users` VALUES (1, 1000, 'admin', '123456', 'admin@email.com', 'Administrator'); SET FOREIGN_KEY_CHECKS = 1;
