测试专用数据表＆记录

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for prefix_user
-- ----------------------------
DROP TABLE IF EXISTS `prefix_user`;
CREATE TABLE `prefix_user`  (
  `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID（自增主键）',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `sex` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别，可选值：0=保密|1=男|2=女',
  `birth` smallint(6) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出生年份，示例：2003',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of prefix_user
-- ----------------------------
INSERT INTO `prefix_user` VALUES (1, '刘一', 1, 2001);
INSERT INTO `prefix_user` VALUES (2, '陈二', 2, 2002);
INSERT INTO `prefix_user` VALUES (3, '张三', 1, 2003);
INSERT INTO `prefix_user` VALUES (4, '李四', 2, 2004);
INSERT INTO `prefix_user` VALUES (5, '王五', 1, 2005);
INSERT INTO `prefix_user` VALUES (6, '赵六', 2, 2006);
INSERT INTO `prefix_user` VALUES (7, '孙七', 1, 2007);
INSERT INTO `prefix_user` VALUES (8, '周八', 2, 2008);
INSERT INTO `prefix_user` VALUES (9, '吴九', 1, 2009);
INSERT INTO `prefix_user` VALUES (10, '郑十', 2, 2010);

SET FOREIGN_KEY_CHECKS = 1;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for prefix_article
-- ----------------------------
DROP TABLE IF EXISTS `prefix_article`;
CREATE TABLE `prefix_article`  (
  `aid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文章标题',
  `click` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点击次数',
  PRIMARY KEY (`aid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9528 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '文章表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of prefix_article
-- ----------------------------
INSERT INTO `prefix_article` VALUES (9527, 'PHP是世界上最好の语言', 1024);

SET FOREIGN_KEY_CHECKS = 1;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for prefix_hero
-- ----------------------------
DROP TABLE IF EXISTS `prefix_hero`;
CREATE TABLE `prefix_hero`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `constellation` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '星宿',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '梁山好汉表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of prefix_hero
-- ----------------------------
INSERT INTO `prefix_hero` VALUES (1, '宋江', '呼保义', '天魁星');
INSERT INTO `prefix_hero` VALUES (2, '卢俊义', '玉麒麟', '天罡星');
INSERT INTO `prefix_hero` VALUES (3, '吴用', '智多星', '天机星');
INSERT INTO `prefix_hero` VALUES (4, '公孙胜', '入云龙', '天闲星');
INSERT INTO `prefix_hero` VALUES (5, '关胜', '大刀', '天勇星');
INSERT INTO `prefix_hero` VALUES (6, '林冲', '豹子头', '天雄星');
INSERT INTO `prefix_hero` VALUES (7, '秦明', '霹雳火', '天猛星');
INSERT INTO `prefix_hero` VALUES (8, '呼延灼', '双鞭', '天威星');
INSERT INTO `prefix_hero` VALUES (9, '花荣', '小李广', '天英星');
INSERT INTO `prefix_hero` VALUES (10, '柴进', '小旋风', '天贵星');
INSERT INTO `prefix_hero` VALUES (11, '李应', '扑天雕', '天富星');
INSERT INTO `prefix_hero` VALUES (12, '朱仝', '美髯公', '天满星');
INSERT INTO `prefix_hero` VALUES (13, '鲁智深', '花和尚', '天孤星');
INSERT INTO `prefix_hero` VALUES (14, '武松', '行者', '天伤星');
INSERT INTO `prefix_hero` VALUES (15, '董平', '双枪将', '天立星');
INSERT INTO `prefix_hero` VALUES (16, '张清', '没羽箭', '天捷星');
INSERT INTO `prefix_hero` VALUES (17, '杨志', '青面兽', '天暗星');
INSERT INTO `prefix_hero` VALUES (18, '徐宁', '金枪手', '天祐星');
INSERT INTO `prefix_hero` VALUES (19, '索超', '急先锋', '天空星');
INSERT INTO `prefix_hero` VALUES (20, '戴宗', '神行太保', '天速星');
INSERT INTO `prefix_hero` VALUES (21, '刘唐', '赤发鬼', '天异星');
INSERT INTO `prefix_hero` VALUES (22, '李逵', '黑旋风', '天杀星');
INSERT INTO `prefix_hero` VALUES (23, '史进', '九纹龙', '天微星');
INSERT INTO `prefix_hero` VALUES (24, '穆弘', '没遮拦', '天究星');
INSERT INTO `prefix_hero` VALUES (25, '雷横', '插翅虎', '天退星');
INSERT INTO `prefix_hero` VALUES (26, '李俊', '混江龙', '天寿星');
INSERT INTO `prefix_hero` VALUES (27, '阮小二', '立地太岁', '天剑星');
INSERT INTO `prefix_hero` VALUES (28, '张横', '船火儿', '天平星');
INSERT INTO `prefix_hero` VALUES (29, '阮小五', '短命二郎', '天罪星');
INSERT INTO `prefix_hero` VALUES (30, '张顺', '浪里白条', '天损星');
INSERT INTO `prefix_hero` VALUES (31, '阮小七', '活阎罗', '天败星');
INSERT INTO `prefix_hero` VALUES (32, '杨雄', '病关索', '天牢星');
INSERT INTO `prefix_hero` VALUES (33, '石秀', '拼命三郎', '天慧星');
INSERT INTO `prefix_hero` VALUES (34, '解珍', '两头蛇', '天暴星');
INSERT INTO `prefix_hero` VALUES (35, '解宝', '双尾蝎', '天哭星');
INSERT INTO `prefix_hero` VALUES (36, '燕青', '浪子', '天巧星');
INSERT INTO `prefix_hero` VALUES (37, '朱武', '神机军师', '地魁星');
INSERT INTO `prefix_hero` VALUES (38, '黄信', '镇三山', '地煞星');
INSERT INTO `prefix_hero` VALUES (39, '孙立', '病尉迟', '地勇星');
INSERT INTO `prefix_hero` VALUES (40, '宣赞', '丑郡马', '地杰星');
INSERT INTO `prefix_hero` VALUES (41, '郝思文', '井木犴', '地雄星');
INSERT INTO `prefix_hero` VALUES (42, '韩滔', '百胜将', '地威星');
INSERT INTO `prefix_hero` VALUES (43, '彭玘', '天目将', '地英星');
INSERT INTO `prefix_hero` VALUES (44, '单廷珪', '圣水将', '地奇星');
INSERT INTO `prefix_hero` VALUES (45, '魏定国', '神火将', '地猛星');
INSERT INTO `prefix_hero` VALUES (46, '萧让', '圣手书生', '地文星');
INSERT INTO `prefix_hero` VALUES (47, '裴宣', '铁面孔目', '地正星');
INSERT INTO `prefix_hero` VALUES (48, '欧鹏', '摩云金翅', '地阔星');
INSERT INTO `prefix_hero` VALUES (49, '邓飞', '火眼狻猊', '地阖星');
INSERT INTO `prefix_hero` VALUES (50, '燕顺', '锦毛虎', '地强星');
INSERT INTO `prefix_hero` VALUES (51, '杨林', '锦豹子', '地暗星');
INSERT INTO `prefix_hero` VALUES (52, '凌振', '轰天雷', '地轴星');
INSERT INTO `prefix_hero` VALUES (53, '蒋敬', '神算子', '地会星');
INSERT INTO `prefix_hero` VALUES (54, '吕方', '小温侯', '地佐星');
INSERT INTO `prefix_hero` VALUES (55, '郭盛', '赛仁贵', '地佑星');
INSERT INTO `prefix_hero` VALUES (56, '安道全', '神医', '地灵星');
INSERT INTO `prefix_hero` VALUES (57, '皇甫端', '紫髯伯', '地兽星');
INSERT INTO `prefix_hero` VALUES (58, '王英', '矮脚虎', '地微星');
INSERT INTO `prefix_hero` VALUES (59, '扈三娘', '一丈青', '地慧星');
INSERT INTO `prefix_hero` VALUES (60, '鲍旭', '丧门神', '地暴星');
INSERT INTO `prefix_hero` VALUES (61, '樊瑞', '混世魔王', '地然星');
INSERT INTO `prefix_hero` VALUES (62, '孔明', '毛头星', '地猖星');
INSERT INTO `prefix_hero` VALUES (63, '孔亮', '独火星', '地狂星');
INSERT INTO `prefix_hero` VALUES (64, '项充', '八臂哪吒', '地飞星');
INSERT INTO `prefix_hero` VALUES (65, '李衮', '飞天大圣', '地走星');
INSERT INTO `prefix_hero` VALUES (66, '金大坚', '玉臂匠', '地巧星');
INSERT INTO `prefix_hero` VALUES (67, '马麟', '铁笛仙', '地明星');
INSERT INTO `prefix_hero` VALUES (68, '童威', '出洞蛟', '地进星');
INSERT INTO `prefix_hero` VALUES (69, '童猛', '翻江蜃', '地退星');
INSERT INTO `prefix_hero` VALUES (70, '孟康', '玉幡竿', '地满星');
INSERT INTO `prefix_hero` VALUES (71, '侯健', '通臂猿', '地遂星');
INSERT INTO `prefix_hero` VALUES (72, '陈达', '跳涧虎', '地周星');
INSERT INTO `prefix_hero` VALUES (73, '杨春', '白花蛇', '地隐星');
INSERT INTO `prefix_hero` VALUES (74, '郑天寿', '白面郎君', '地异星');
INSERT INTO `prefix_hero` VALUES (75, '陶宗旺', '九尾龟', '地理星');
INSERT INTO `prefix_hero` VALUES (76, '宋清', '铁扇子', '地俊星');
INSERT INTO `prefix_hero` VALUES (77, '乐和', '铁叫子', '地乐星');
INSERT INTO `prefix_hero` VALUES (78, '龚旺', '花项虎', '地捷星');
INSERT INTO `prefix_hero` VALUES (79, '丁得孙', '中箭虎', '地速星');
INSERT INTO `prefix_hero` VALUES (80, '穆春', '小遮拦', '地镇星');
INSERT INTO `prefix_hero` VALUES (81, '曹正', '操刀鬼', '地羁星');
INSERT INTO `prefix_hero` VALUES (82, '宋万', '云里金刚', '地魔星');
INSERT INTO `prefix_hero` VALUES (83, '杜迁', '摸着天', '地妖星');
INSERT INTO `prefix_hero` VALUES (84, '薛永', '病大虫', '地幽星');
INSERT INTO `prefix_hero` VALUES (85, '李忠', '打虎将', '地僻星');
INSERT INTO `prefix_hero` VALUES (86, '周通', '小霸王', '地空星');
INSERT INTO `prefix_hero` VALUES (87, '汤隆', '金钱豹子', '地孤星');
INSERT INTO `prefix_hero` VALUES (88, '杜兴', '鬼脸儿', '地全星');
INSERT INTO `prefix_hero` VALUES (89, '邹渊', '出林龙', '地短星');
INSERT INTO `prefix_hero` VALUES (90, '邹润', '独角龙', '地角星');
INSERT INTO `prefix_hero` VALUES (91, '朱贵', '旱地忽律', '地囚星');
INSERT INTO `prefix_hero` VALUES (92, '朱富', '笑面虎', '地藏星');
INSERT INTO `prefix_hero` VALUES (93, '施恩', '金眼彪', '地伏星');
INSERT INTO `prefix_hero` VALUES (94, '蔡福', '铁臂膊', '地平星');
INSERT INTO `prefix_hero` VALUES (95, '蔡庆', '一枝花', '地损星');
INSERT INTO `prefix_hero` VALUES (96, '李立', '催命判官', '地奴星');
INSERT INTO `prefix_hero` VALUES (97, '李云', '青眼虎', '地察星');
INSERT INTO `prefix_hero` VALUES (98, '焦挺', '没面目', '地恶星');
INSERT INTO `prefix_hero` VALUES (99, '石勇', '石将军', '地丑星');
INSERT INTO `prefix_hero` VALUES (100, '孙新', '小尉迟', '地数星');
INSERT INTO `prefix_hero` VALUES (101, '顾大嫂', '母大虫', '地阴星');
INSERT INTO `prefix_hero` VALUES (102, '张青', '菜园子', '地刑星');
INSERT INTO `prefix_hero` VALUES (103, '孙二娘', '母夜叉', '地壮星');
INSERT INTO `prefix_hero` VALUES (104, '王定六', '活闪婆', '地劣星');
INSERT INTO `prefix_hero` VALUES (105, '郁保四', '险道神', '地健星');
INSERT INTO `prefix_hero` VALUES (106, '白胜', '白日鼠', '地耗星');
INSERT INTO `prefix_hero` VALUES (107, '时迁', '鼓上蚤', '地贼星');
INSERT INTO `prefix_hero` VALUES (108, '段景住', '金毛犬', '地狗星');

SET FOREIGN_KEY_CHECKS = 1;