2bYsdfGY

1-- phpMyAdmin SQL Dump
2-- version 4.4.15.10
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: 2019-01-28 12:11:35
7-- 服务器版本： 5.5.59-log
8-- PHP Version: 5.4.45
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `FFXIV`
21--
22
23-- --------------------------------------------------------
24
25--
26-- 表的结构 `ffxivbot_customreply`
27--
28
29CREATE TABLE IF NOT EXISTS `ffxivbot_customreply` (
30  `id` int(11) NOT NULL,
31  `value` longtext CHARACTER SET utf8mb4 NOT NULL,
32  `group_id` varchar(16) NOT NULL,
33  `key` longtext CHARACTER SET utf8mb4 NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=3797 DEFAULT CHARSET=utf8;
35
36--
37-- 转存表中的数据 `ffxivbot_customreply`
38--
39
40INSERT INTO `ffxivbot_customreply` (`id`, `value`, `group_id`, `key`) VALUES
41(565, 'guna', '80670535', '/沙雕'),
42(566, '宇宙无敌螺旋霹雳托马斯爆炸可爱', '80670535', '/大哥！'),
43(567, '五百斤的胖子(●´∀｀●)', '80670535', '/花花'),
44(568, '爸爸', '80670535', '/儿砸！'),
45(569, '你的rbq坏掉啦！！！！！', '80670535', '/星河'),
46(570, '一次5毛，包夜1毛5', '80670535', '/勾勾'),
47(736, '$val', '80670535', '/$常用网站'),
48(737, 'FF14维基https://ff14.huijiwiki.com/wiki/%E9%A6%96%E9%A1%B5', '80670535', '/常用网站'),
49(740, 'https://ff14.huijiwiki.com/wiki/%E9%A6%96%E9%A1%B5', '80670535', '/wiki'),
50(741, 'https://www.ffsusu.com/', '80670535', '/susu'),
51(742, '混蛋！自己去公告置顶里看啊！！！！', '80670535', '/本群须知'),
52(743, 'https://weibo.com/3174579633/Fx9tJ2UVU', '80670535', '/连接大合集'),
53(765, '中国区紫水服务器人最多，但是这个群大多玩家都在萌芽池，人也不少，推荐来萌芽池哦！老服限制创建的话可以等凌晨或者工作日上午人少的时候就可以创建了~', '80670535', '/哪里人多'),
54(770, '[CQ:image,file=C3680CC63C10FC894FAB6A87BEB152F7.jpg,url=https://gchat.qpic.cn/gchatpic_new/383050364/2023670535-2953565060-C3680CC63C10FC894FAB6A87BEB152F7/0?vuin=2946352625&term=2]', '80670535', '/房价'),
55(784, 'http://ff.sdo.com/shop/', '80670535', '/商城'),
56(785, '直升之后跟着主线走就好，如果喜欢做任务就可以把支线也清了，觉得的烦不清也没事，然后注意下一按带蓝色加好的任务，那种任务有一些做完会开启一些功能，如果是让打蛮神可以先放一放', '80670535', '/任务'),
57(789, 'http://act.ff.sdo.com/project/20180511ontheroad/index.html', '80670535', '/招募链接'),
58(886, '[CQ:image,file=7ABA24FB6C5C5D17383F4B0B6458FC8C.jpg,url=https://gchat.qpic.cn/gchatpic_new/383050364/2023670535-2689240796-7ABA24FB6C5C5D17383F4B0B6458FC8C/0?vuin=2946352625&term=2]', '80670535', '/解限'),
59(890, '睿智，煞笔，敲里吗！！！！！！！！！！！！！！！', '80670535', '/三三'),
60(895, 'http://ff.sdo.com/web7/news/news.html?id=297439', '80670535', '/新人'),
61(896, '自己什么样心理没点B数吗？', '80670535', '/征婚'),
62(897, '给没有你这么丑的，还是好好当直男吧，乖', '80670535', '/搞基'),
63(900, 'https://www.bilibili.com/video/av20747968/', '80670535', '/尤雷卡我武器'),
64(901, '[CQ:image,file=3DAF85F7DCE831623B13F26D179355B4.png,url=https://gchat.qpic.cn/gchatpic_new/383050364/2023670535-2189186745-3DAF85F7DCE831623B13F26D179355B4/0?vuin=2946352625&term=2]https://www.bilibili.com/video/av20747968/', '80670535', '/尤雷卡武器'),
65(902, 'https://www.bilibili.com/video/av11286019/?p=7', '80670535', '/魂武古武');
66
67--
68-- Indexes for dumped tables
69--
70
71--
72-- Indexes for table `ffxivbot_customreply`
73--
74ALTER TABLE `ffxivbot_customreply`
75  ADD PRIMARY KEY (`id`),
76  ADD KEY `ffxivbot_customreply_group_id_7bfb020a_fk_ffxivbot_` (`group_id`);
77
78--
79-- AUTO_INCREMENT for dumped tables
80--
81
82--
83-- AUTO_INCREMENT for table `ffxivbot_customreply`
84--
85ALTER TABLE `ffxivbot_customreply`
86  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3797;
87--
88-- 限制导出的表
89--
90
91--
92-- 限制表 `ffxivbot_customreply`
93--
94ALTER TABLE `ffxivbot_customreply`
95  ADD CONSTRAINT `ffxivbot_customreply_group_id_7bfb020a_fk_ffxivbot_` FOREIGN KEY (`group_id`) REFERENCES `ffxivbot_qqgroup` (`group_id`);
96
97/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
98/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
99/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;