/* Navicat MySQL Data Transfer Source Server : xiaomo2017(106.15.188.160) Source Server Version : 50717 Source Host : 106.15.188.160:3306 Source Database : xiaomo Target Server Type : MYSQL Target Server Version : 50717 File Encoding : 65001 Date: 2017-08-28 16:50:30 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `salt` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `user_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_user -- ---------------------------- INSERT INTO `admin_user` VALUES ('1', '2017-08-11 17:22:32', 'string', '2017-08-11 17:34:06', '11dbb64dac563eb66c5bedca104ef581', 'yg7djoh6yf', '0', 'string'); -- ---------------------------- -- Table structure for change_log -- ---------------------------- DROP TABLE IF EXISTS `change_log`; CREATE TABLE `change_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `online_time` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of change_log -- ---------------------------- INSERT INTO `change_log` VALUES ('1', '2017-08-11 17:35:34', 'string', '2017-08-11 17:35:34', 'string'); -- ---------------------------- -- Table structure for link -- ---------------------------- DROP TABLE IF EXISTS `link`; CREATE TABLE `link` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of link -- ---------------------------- -- ---------------------------- -- Table structure for shikigame -- ---------------------------- DROP TABLE IF EXISTS `shikigame`; CREATE TABLE `shikigame` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `des` varchar(255) DEFAULT NULL, `get_way` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `level` varchar(255) DEFAULT NULL, `seiyou` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `star` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of shikigame -- ---------------------------- INSERT INTO `shikigame` VALUES ('1', null, '匣ä¸å°‘女', null, '', '抽å¡ã€ç¢Žç‰‡åˆæˆ', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628104915566.jpeg', 'SR', 'å°æ¸…水亚美', '女', '★★'); INSERT INTO `shikigame` VALUES ('2', null, 'å°æ¾ä¸¸', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321193.jpeg', 'SR', '芽野爱衣', '女', '★★'); INSERT INTO `shikigame` VALUES ('3', null, '以津真天', null, '', '抽奖ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321133.jpeg', 'SR', 'ä½è—¤èªç¾Ž', '女', '★★'); INSERT INTO `shikigame` VALUES ('4', null, '鸩', null, '', '碎片ã€æŠ½å¡', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321247.jpeg', 'SR', '户æ¾é¥', '女', '★★'); INSERT INTO `shikigame` VALUES ('5', null, '彼岸花', null, '', '抽å¡ã€ç¢Žç‰‡åˆæˆ', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321038.jpeg', 'SSR', '大原沙耶香', '女', '★★'); INSERT INTO `shikigame` VALUES ('6', null, '万年竹', null, '', '神龛兑æ¢', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425111533689.jpeg', 'SR', '立花慎之介', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('7', null, 'è’', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425110822062.jpeg', 'SSR', 'å¹³å·å¤§è¾…', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('8', null, '金鱼姬', null, '', '活动ã€æŠ½å¡', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425102028952.jpeg', 'SR', '内田真礼', '女', '★★'); INSERT INTO `shikigame` VALUES ('9', null, '夜å‰', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215123933616.jpeg', 'SR', 'å°è¥¿å…‹å¹¸', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('10', null, '烟烟罗', null, '', '抽å¡ã€ç¢Žç‰‡åˆæˆ', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215123707014.jpeg', 'SR', '甲æ–田裕å', '女', '★★'); INSERT INTO `shikigame` VALUES ('11', null, '辉夜姬', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215113029024.jpeg', 'SSR', '竹达彩奈', '女', '★★'); INSERT INTO `shikigame` VALUES ('12', null, '花鸟å·', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215112700922.jpeg', 'SSR', 'æ—©è§æ²™ç»‡', '女', '★★'); INSERT INTO `shikigame` VALUES ('13', null, 'å¤ç¬¼ç«', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214170613314.jpeg', 'R', 'æ¾å†ˆç¥¯ä¸ž', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('14', null, '黑童å', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214170026831.jpeg', 'SR', 'æ‰ç”°æ™ºå’Œ', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('15', null, '白童å', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214165135364.jpeg', 'SR', 'ä¸æ‘æ‚ ä¸€', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('16', null, 'é’åŠä¸»', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214172404430.jpeg', 'SR', '细谷佳æ£', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('17', null, 'æç¯å°åƒ§', null, '', '抽å¡ï¼Œç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161114141227302.jpeg', 'N', 'æ‚ æœ¨ç¢§', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('18', null, '一目连', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161111163947709.jpeg', 'SSR', '绿å·å…‰', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('19', null, '般若', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161111163328046.jpeg', 'SR', '梶裕贵', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('20', null, 'å”纸伞妖', null, '', '抽å¡ï¼Œç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161103100753671.jpeg', 'N', 'å°æž—优', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('21', null, '寄生é‚', null, '', 'ç« èŠ‚å二', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014155409432.jpeg', 'N', 'æ— ', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('22', null, '帚神', null, '', '妖气å°å°ã€ç« 节åå››', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014154807857.jpeg', 'N', '-', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('23', null, '盗墓å°é¬¼', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014154249087.jpeg', 'N', '新谷真弓', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('24', null, '赤舌', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014153630952.jpeg', 'N', '森久ä¿ç¥¥å¤ªéƒŽ', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('25', null, 'é¦–æ— ', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161013132716253.jpeg', 'R', '石å·ç•Œäºº', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('26', null, '络新妇', null, '', '抽奖ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012162340089.jpeg', 'SR', '井上喜久å', '女', '★★'); INSERT INTO `shikigame` VALUES ('27', null, '樱花妖', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012155327721.jpeg', 'SR', '能登麻美å', '女', '★★'); INSERT INTO `shikigame` VALUES ('28', null, '妖刀姬', null, '', '抽å¡ã€ç¢Žç‰‡', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012152409709.jpeg', 'SSR', '井泽诗织', '女', '★★'); INSERT INTO `shikigame` VALUES ('29', null, '清姬', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926104658402.jpeg', 'SR', 'è¡Œæˆæ¡ƒå§¬', '女', '★★'); INSERT INTO `shikigame` VALUES ('30', null, '河童', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926104424533.jpeg', 'R', 'ä¿å¿—总一朗', '女', '★★'); INSERT INTO `shikigame` VALUES ('31', null, '鸦天狗', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102711340.jpeg', 'R', 'å°æž—优', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('32', null, '食å‘鬼', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102255825.jpeg', 'R', '间宫康弘', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('33', null, '山童', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102013107.jpeg', 'R', 'ä¿å¿—总一朗', '女', '★★'); INSERT INTO `shikigame` VALUES ('34', null, '觉', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101743950.jpeg', 'R', 'ç”±åŠ å¥ˆ', '女', '★★'); INSERT INTO `shikigame` VALUES ('35', null, 'é’蛙瓷器', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101422781.jpeg', 'R', 'å‰é‡Žè£•è¡Œ', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('36', null, '犬神', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101100598.jpeg', 'SR', '关俊彦', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('37', null, '三尾ç‹', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926100725543.jpeg', 'R', '泽城美雪', '女', '★★'); INSERT INTO `shikigame` VALUES ('38', null, '独眼å°åƒ§', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095821891.jpeg', 'R', 'å°æž—优', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('39', null, '管ç‹', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095543173.jpeg', 'R', 'æ¾ç”°å¥ä¸€éƒŽ', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('40', null, 'è¤è‰', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095401921.jpeg', 'R', '诹访彩花', '女', '★★'); INSERT INTO `shikigame` VALUES ('41', null, 'ä¹å‘½çŒ«', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095022134.jpeg', 'R', '新谷真弓', '女', '★★'); INSERT INTO `shikigame` VALUES ('42', null, '童男', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094814879.jpeg', 'R', '井上麻里奈', 'ç”·', '★★★'); INSERT INTO `shikigame` VALUES ('43', null, 'å¸è¡€å§¬', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094600059.jpeg', 'SR', 'ç”±åŠ å¥ˆ', '女', '★★'); INSERT INTO `shikigame` VALUES ('44', null, 'æƒ æ¯”å¯¿', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094357103.jpeg', 'SR', '茶风林', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('45', null, '跳跳哥哥', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094121029.jpeg', 'SR', '远藤大辅', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('46', null, '雪女', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926093300209.jpeg', 'SR', '诹访彩花', '女', '★★'); INSERT INTO `shikigame` VALUES ('47', null, '茨木童å', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926093041921.jpeg', 'SSR', 'ç¦å±±æ¶¦', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('48', null, 'è’å·ä¹‹ä¸»', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923170213025.jpeg', 'SSR', 'å安æ¦äºº', 'ç”·', '★★★'); INSERT INTO `shikigame` VALUES ('49', null, 'é…’åžç«¥å', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165754494.jpeg', 'SSR', '阪å£å‘¨å¹³', 'ç”·', '★★★'); INSERT INTO `shikigame` VALUES ('50', null, 'å°é¹¿ç”·', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165614197.jpeg', 'SSR', 'å·è¥¿å¥å¾', 'ç”·', '★★★'); INSERT INTO `shikigame` VALUES ('51', null, '阎é”', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165311983.jpeg', 'SSR', '能登麻美å', '女', '★★'); INSERT INTO `shikigame` VALUES ('52', null, '山兔', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165039787.jpeg', 'R', '丰崎爱生', '女', '★★'); INSERT INTO `shikigame` VALUES ('53', null, '鲤鱼精', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201701/999/image/388/388/hd/20170119113153623.jpeg', 'R', 'æ‚ æœ¨ç¢§', '女', '★★'); INSERT INTO `shikigame` VALUES ('54', null, '白狼', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923163557641.jpeg', 'SR', '桑岛法å', '女', '★★'); INSERT INTO `shikigame` VALUES ('55', null, '桃花妖', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923163207205.jpeg', 'SR', 'æ°´æ ‘å¥ˆå¥ˆ', '女', '★★'); INSERT INTO `shikigame` VALUES ('56', null, '妖ç‹', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920181314803.jpeg', 'SR', '岛崎信长', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('57', null, '椒图', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920180651005.jpeg', 'R', '能登麻美å', '女', '★★'); INSERT INTO `shikigame` VALUES ('58', null, '鬼女红å¶', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920180215320.jpeg', 'SR', '桑岛法å', '女', '★★'); INSERT INTO `shikigame` VALUES ('59', null, '大天狗', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175835892.jpeg', 'SSR', 'å‰é‡Žæ™ºæ˜', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('60', null, '两é¢ä½›', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175602498.jpeg', 'SSR', '井上和彦', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('61', null, 'é’è¡Œç¯', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175352199.jpeg', 'SSR', 'æ°´æ ‘å¥ˆå¥ˆ', '女', '★★'); INSERT INTO `shikigame` VALUES ('62', null, '姑获鸟', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175142834.jpeg', 'SR', 'è¡Œæˆæ¡ƒå§¬', '女', '★★'); INSERT INTO `shikigame` VALUES ('63', null, '二å£å¥³', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174727153.jpeg', 'SR', '新谷真弓', '女', '★★'); INSERT INTO `shikigame` VALUES ('64', null, '凤凰ç«', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174540667.jpeg', 'SR', '井上麻里奈', '女', '★★'); INSERT INTO `shikigame` VALUES ('65', null, '骨女', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174232252.jpeg', 'SR', '诹访彩花', '女', '★★'); INSERT INTO `shikigame` VALUES ('66', null, '鬼使白', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174054507.jpeg', 'SR', '铃æ‘å¥ä¸€', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('67', null, '鬼使黑', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155914788.jpeg', 'SR', 'ä¸äº•å’Œå“‰', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('68', null, 'æµ·åŠä¸»', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155617178.jpeg', 'SR', '关俊彦', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('69', null, '傀儡师', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155205681.jpeg', 'SR', '能登麻美å', '女', '★★'); INSERT INTO `shikigame` VALUES ('70', null, 'åŸå©†', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920151321465.jpeg', 'SR', '钉宫ç†æƒ ', '女', '★★'); INSERT INTO `shikigame` VALUES ('71', null, '判官', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920151047481.jpeg', 'SR', '石田彰', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('72', null, '食梦貘', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150850532.jpeg', 'SR', '西谷修一', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('73', null, '妖ç´å¸ˆ', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150636794.jpeg', 'SR', '岛崎信长', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('74', null, '镰鼬', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150447931.jpeg', 'SR', '间宫康弘', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('75', null, 'è´è¶ç²¾', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150221571.jpeg', 'R', 'æ‚ æœ¨ç¢§', '女', '★★'); INSERT INTO `shikigame` VALUES ('76', null, '狸猫', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920145918831.jpeg', 'R', 'ä¿å¿—总一朗', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('77', null, '跳跳弟弟', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919192452025.jpeg', 'R', '高山å—', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('78', null, '跳跳妹妹', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919192104507.jpeg', 'R', '诹访彩花', '女', '★★'); INSERT INTO `shikigame` VALUES ('79', null, 'é“é¼ ', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919191747925.jpeg', 'R', '石田彰', '女', '★★'); INSERT INTO `shikigame` VALUES ('80', null, '童女', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919111719964.png', 'R', 'åŠ éšˆäºšè¡£', '女', '★★'); INSERT INTO `shikigame` VALUES ('81', null, '巫蛊师', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919111049876.jpeg', 'R', '间宫康弘', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('82', null, 'æ¦å£«ä¹‹çµ', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919110029060.jpeg', 'R', '井上和彦', 'ç”·', '★★'); INSERT INTO `shikigame` VALUES ('83', null, '雨女', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919103128584.jpeg', 'R', 'åŠ éšˆäºšè¡£', '女', '★★'); INSERT INTO `shikigame` VALUES ('84', null, '饿鬼', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919101843632.jpeg', 'R', '井上麻里奈', '女', '★★'); INSERT INTO `shikigame` VALUES ('85', null, '座敷童å', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919102039254.jpeg', 'R', '竹内顺å', '女', '★★'); INSERT INTO `shikigame` VALUES ('86', null, '兵佣', null, '', '抽å¡,碎片', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919102003545.jpeg', 'R', '石田彰', 'ç”·', '★★'); -- ---------------------------- -- Table structure for system_set -- ---------------------------- DROP TABLE IF EXISTS `system_set`; CREATE TABLE `system_set` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `beian_number` varchar(255) DEFAULT NULL, `beian_url` varchar(255) DEFAULT NULL, `from_year` int(11) DEFAULT NULL, `icon` varchar(255) DEFAULT NULL, `site_name` varchar(255) DEFAULT NULL, `to_year` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of system_set -- ---------------------------- INSERT INTO `system_set` VALUES ('1', '2017-08-28 16:46:20', 'xiaomo', '2017-08-28 16:46:25', '我的备案å·', 'https://xxx.xxx.xxx', '2015', 'https://image.xiaom.info/logo/avatar.png', 'å°èŽ«çš„åšå®¢', '2017'); -- ---------------------------- -- Table structure for technology -- ---------------------------- DROP TABLE IF EXISTS `technology`; CREATE TABLE `technology` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `img_url` varchar(255) DEFAULT NULL, `summary` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of technology -- ---------------------------- -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `register_time` bigint(20) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `gender` int(11) DEFAULT NULL, `img_url` varchar(255) DEFAULT NULL, `nick_name` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `phone` bigint(20) DEFAULT NULL, `salt` varchar(255) DEFAULT NULL, `validate_code` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- -- ---------------------------- -- Table structure for works -- ---------------------------- DROP TABLE IF EXISTS `works`; CREATE TABLE `works` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `complete_time` varchar(255) DEFAULT NULL, `img_url` varchar(255) DEFAULT NULL, `summary` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of works -- ----------------------------