Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Without author's permission, this code is only for learning and cannot be used for other purposes.
Clone or download
wechat_robot_plus.sql 29.30 KB
Copy Edit Web IDE Raw Blame History
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50612
Source Host : localhost:3306
Source Database : wechat_robot_plus
Target Server Type : MYSQL
Target Server Version : 50612
File Encoding : 65001
Date: 2014-01-17 15:39:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for wxmsg_access
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_access`;
CREATE TABLE `wxmsg_access` (
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
`node_id` int(10) unsigned NOT NULL DEFAULT '0',
`parent_node_id` int(10) unsigned NOT NULL DEFAULT '0',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0',
KEY `group_id` (`group_id`) USING BTREE,
KEY `node_id` (`node_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_access
-- ----------------------------
INSERT INTO `wxmsg_access` VALUES ('1', '35', '9', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '9', '4', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '68', '7', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '25', '7', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '8', '7', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '23', '7', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '27', '7', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '7', '4', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '67', '5', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '6', '5', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '31', '5', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '5', '4', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '4', '0', '0');
INSERT INTO `wxmsg_access` VALUES ('1', '47', '42', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '46', '42', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '43', '42', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '72', '42', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '42', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '71', '60', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '60', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '58', '56', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '56', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '59', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '64', '61', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '63', '61', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '65', '61', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '62', '61', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '61', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '54', '52', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '55', '52', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '53', '52', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '52', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '50', '48', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '51', '48', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '49', '48', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '48', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '45', '40', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '44', '40', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '41', '40', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '40', '39', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '39', '0', '0');
INSERT INTO `wxmsg_access` VALUES ('1', '24', '1', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '11', '1', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '22', '1', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '38', '1', '1');
INSERT INTO `wxmsg_access` VALUES ('1', '1', '0', '0');
INSERT INTO `wxmsg_access` VALUES ('1', '10', '9', '2');
INSERT INTO `wxmsg_access` VALUES ('1', '70', '9', '2');
-- ----------------------------
-- Table structure for wxmsg_blacklists
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_blacklists`;
CREATE TABLE `wxmsg_blacklists` (
`member_id` int(10) unsigned NOT NULL,
`description` varchar(200) NOT NULL DEFAULT '',
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_blacklists
-- ----------------------------
-- ----------------------------
-- Table structure for wxmsg_commands
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_commands`;
CREATE TABLE `wxmsg_commands` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`command` varchar(50) NOT NULL DEFAULT '',
`p_cmd_id` int(10) unsigned NOT NULL DEFAULT '0',
`data_regex` varchar(100) NOT NULL DEFAULT '',
`is_expire` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_with_plugin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`plugin_name` varchar(100) NOT NULL DEFAULT '',
`plugin_function` varchar(100) NOT NULL DEFAULT '',
`reply_msgtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
`pic_url` text NOT NULL,
`link_url` text NOT NULL,
`music_url` text NOT NULL,
`hqmusic_url` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `command` (`command`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_commands
-- ----------------------------
INSERT INTO `wxmsg_commands` VALUES ('2', 'err_invlid_command', '0', '', '0', '0', '', '', '1', '无效的命令', '', '', '', '', '', '');
INSERT INTO `wxmsg_commands` VALUES ('3', 'err_command_expired', '0', '', '0', '0', '', '', '1', '命令输入超时', '', '', '', '', '', '');
INSERT INTO `wxmsg_commands` VALUES ('4', 'err_incorrect_parent_command', '0', '', '0', '0', '', '', '1', '命令流程错误', '', '', '', '', '', '');
INSERT INTO `wxmsg_commands` VALUES ('8', 'err_incorrect_command_data', '0', '', '0', '0', '', '', '1', '命令参数不正确', '', '', '', '', '', '');
INSERT INTO `wxmsg_commands` VALUES ('9', 'err_save_user_datas_failed', '0', '', '0', '0', '', '', '1', '用户数据保存失败', '', '', '', '', '', '');
INSERT INTO `wxmsg_commands` VALUES ('21', 'test', '0', '123', '0', '1', 'plugin_demo', 'run', '1', '', '', '', '', '', '', '');
-- ----------------------------
-- Table structure for wxmsg_group
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_group`;
CREATE TABLE `wxmsg_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_name` varchar(50) NOT NULL DEFAULT '',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`description` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `group_name` (`group_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_group
-- ----------------------------
INSERT INTO `wxmsg_group` VALUES ('1', 'admin_group', '1', '');
-- ----------------------------
-- Table structure for wxmsg_keywords
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_keywords`;
CREATE TABLE `wxmsg_keywords` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`for_msgtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`keyword` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_keywords
-- ----------------------------
INSERT INTO `wxmsg_keywords` VALUES ('2', '3', 'subscribe', '订阅事件');
INSERT INTO `wxmsg_keywords` VALUES ('3', '1', 'help_contents', '用于绑定帮助信息');
-- ----------------------------
-- Table structure for wxmsg_member
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_member`;
CREATE TABLE `wxmsg_member` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_opn_id` varchar(50) NOT NULL DEFAULT '',
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`last_cmd` varchar(50) NOT NULL DEFAULT '',
`last_cmd_id` int(10) unsigned NOT NULL DEFAULT '0',
`last_time` int(10) unsigned NOT NULL DEFAULT '0',
`data` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_opn_id` (`user_opn_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_member
-- ----------------------------
INSERT INTO `wxmsg_member` VALUES ('1', 'user1', '1384768258', 'test', '21', '1385697090', '{\"test\":\"1231\"}');
INSERT INTO `wxmsg_member` VALUES ('2', 'ope8Ej_nmoB81OATsJSTCswOy_rQ', '1389941639', '', '0', '0', '');
-- ----------------------------
-- Table structure for wxmsg_menu
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_menu`;
CREATE TABLE `wxmsg_menu` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(50) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`key` varchar(200) NOT NULL DEFAULT '',
`url` text NOT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0',
`description` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_menu
-- ----------------------------
-- ----------------------------
-- Table structure for wxmsg_msgbox
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_msgbox`;
CREATE TABLE `wxmsg_msgbox` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`member_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_opn_id` varchar(50) NOT NULL DEFAULT '',
`platform_opn_id` varchar(50) NOT NULL DEFAULT '',
`msgtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`post_time` int(10) unsigned NOT NULL DEFAULT '0',
`wx_msg_id` varchar(50) NOT NULL DEFAULT '0',
`reply_msgtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`reply_content` text NOT NULL,
`reply_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_opn_id` (`user_opn_id`) USING BTREE,
KEY `platform_opn_id` (`platform_opn_id`) USING BTREE,
KEY `member_id` (`member_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_msgbox
-- ----------------------------
INSERT INTO `wxmsg_msgbox` VALUES ('1', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1384764519\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1384764519', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1384768258');
INSERT INTO `wxmsg_msgbox` VALUES ('2', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1384764519\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1384764519', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1384768594');
INSERT INTO `wxmsg_msgbox` VALUES ('3', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1384764519\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1384764519', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1384768595');
INSERT INTO `wxmsg_msgbox` VALUES ('4', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1384764519\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1384764519', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1384768595');
INSERT INTO `wxmsg_msgbox` VALUES ('5', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1384764519\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1384764519', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1384768596');
INSERT INTO `wxmsg_msgbox` VALUES ('6', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696637\",\"MsgType\":\"text\",\"Content\":\"aaa\",\"MsgId\":\"1234567890123456\"}', '1385696637', '2147483647', '1', '{\"id\":\"5\",\"for_key_id\":\"3\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u60a8\\u8f93\\u5165\\u7684\\u547d\\u4ee4\\u65e0\\u6cd5\\u8bc6\\u522b,\\u8bf7\\u68c0\\u67e5\\u540e\\u518d\\u8bd5~\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1385696640');
INSERT INTO `wxmsg_msgbox` VALUES ('7', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696648\",\"MsgType\":\"text\",\"Content\":\"aaa#\",\"MsgId\":\"1234567890123456\"}', '1385696648', '2147483647', '1', '{\"id\":\"2\",\"command\":\"err_invlid_command\",\"p_cmd_id\":\"0\",\"data_regex\":\"\",\"is_expire\":\"0\",\"is_with_plugin\":\"0\",\"plugin_name\":\"\",\"plugin_function\":\"\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u65e0\\u6548\\u7684\\u547d\\u4ee4\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1385696650');
INSERT INTO `wxmsg_msgbox` VALUES ('8', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696648\",\"MsgType\":\"text\",\"Content\":\"aaa#\",\"MsgId\":\"1234567890123456\"}', '1385696648', '2147483647', '1', '{\"id\":\"2\",\"command\":\"err_invlid_command\",\"p_cmd_id\":\"0\",\"data_regex\":\"\",\"is_expire\":\"0\",\"is_with_plugin\":\"0\",\"plugin_name\":\"\",\"plugin_function\":\"\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u65e0\\u6548\\u7684\\u547d\\u4ee4\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1385696667');
INSERT INTO `wxmsg_msgbox` VALUES ('9', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696718\",\"MsgType\":\"text\",\"Content\":\"test#123\",\"MsgId\":\"1234567890123456\"}', '1385696718', '2147483647', '1', '{\"id\":\"9\",\"command\":\"err_save_user_datas_failed\",\"p_cmd_id\":\"0\",\"data_regex\":\"\",\"is_expire\":\"0\",\"is_with_plugin\":\"0\",\"plugin_name\":\"\",\"plugin_function\":\"\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u7528\\u6237\\u6570\\u636e\\u4fdd\\u5b58\\u5931\\u8d25\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1385696721');
INSERT INTO `wxmsg_msgbox` VALUES ('10', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696718\",\"MsgType\":\"text\",\"Content\":\"test#123\",\"MsgId\":\"1234567890123456\"}', '1385696718', '2147483647', '0', '{\"reply_msgtype\":\"text\",\"content\":\"id=1\\nuser_opn_id=user1\\ncreate_time=1384768258\\nlast_cmd=test\\nlast_cmd_id=21\\nlast_time=0\\ndata={}\\n\"}', '1385696781');
INSERT INTO `wxmsg_msgbox` VALUES ('11', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696718\",\"MsgType\":\"text\",\"Content\":\"test#123\",\"MsgId\":\"1234567890123456\"}', '1385696718', '2147483647', '0', '{\"reply_msgtype\":\"text\",\"content\":\"id=1\\nuser_opn_id=user1\\ncreate_time=1384768258\\nlast_cmd=test\\nlast_cmd_id=21\\nlast_time=1385696844\\ndata={}\\n\"}', '1385696844');
INSERT INTO `wxmsg_msgbox` VALUES ('12', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696718\",\"MsgType\":\"text\",\"Content\":\"test#123\",\"MsgId\":\"1234567890123456\"}', '1385696718', '2147483647', '1', '{\"id\":\"8\",\"command\":\"err_incorrect_command_data\",\"p_cmd_id\":\"0\",\"data_regex\":\"\",\"is_expire\":\"0\",\"is_with_plugin\":\"0\",\"plugin_name\":\"\",\"plugin_function\":\"\",\"reply_msgtype_id\":\"1\",\"content\":\"\\u547d\\u4ee4\\u53c2\\u6570\\u4e0d\\u6b63\\u786e\",\"title\":\"\",\"description\":\"\",\"pic_url\":\"\",\"link_url\":\"\",\"music_url\":\"\",\"hqmusic_url\":\"\",\"reply_msgtype\":\"text\"}', '1385696950');
INSERT INTO `wxmsg_msgbox` VALUES ('13', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385696718\",\"MsgType\":\"text\",\"Content\":\"test#123\",\"MsgId\":\"1234567890123456\"}', '1385696718', '2147483647', '0', '{\"reply_msgtype\":\"text\",\"content\":\"id=1\\nuser_opn_id=user1\\ncreate_time=1384768258\\nlast_cmd=test\\nlast_cmd_id=21\\nlast_time=1385696986\\ndata={\\\"test\\\":\\\"123\\\"}\\n\"}', '1385696986');
INSERT INTO `wxmsg_msgbox` VALUES ('14', '1', 'user1', 'platform', '1', '{\"ToUserName\":\"platform\",\"FromUserName\":\"user1\",\"CreateTime\":\"1385697089\",\"MsgType\":\"text\",\"Content\":\"test#1231\",\"MsgId\":\"1234567890123456\"}', '1385697089', '2147483647', '0', '{\"reply_msgtype\":\"text\",\"content\":\"id=1\\nuser_opn_id=user1\\ncreate_time=1384768258\\nlast_cmd=test\\nlast_cmd_id=21\\nlast_time=1385697090\\ndata={\\\"test\\\":\\\"1231\\\"}\\n\"}', '1385697090');
-- ----------------------------
-- Table structure for wxmsg_msgtype
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_msgtype`;
CREATE TABLE `wxmsg_msgtype` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type_name` varchar(10) NOT NULL DEFAULT '',
`description` text NOT NULL,
`for_reply` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `type_name` (`type_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_msgtype
-- ----------------------------
INSERT INTO `wxmsg_msgtype` VALUES ('1', 'text', '文本', '1');
INSERT INTO `wxmsg_msgtype` VALUES ('2', 'image', '图片', '0');
INSERT INTO `wxmsg_msgtype` VALUES ('3', 'event', '事件推送', '0');
INSERT INTO `wxmsg_msgtype` VALUES ('4', 'location', '地理位置', '0');
INSERT INTO `wxmsg_msgtype` VALUES ('5', 'link', '超链接', '0');
INSERT INTO `wxmsg_msgtype` VALUES ('6', 'news', '图文超链接', '1');
INSERT INTO `wxmsg_msgtype` VALUES ('7', 'voice', '语音', '0');
INSERT INTO `wxmsg_msgtype` VALUES ('8', 'music', '音频', '1');
-- ----------------------------
-- Table structure for wxmsg_node
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_node`;
CREATE TABLE `wxmsg_node` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`class` varchar(50) NOT NULL DEFAULT '',
`method` varchar(50) NOT NULL DEFAULT '',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0',
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`hide` tinyint(1) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`description` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_node
-- ----------------------------
INSERT INTO `wxmsg_node` VALUES ('1', '首页', '0', 'home/home', 'index', '0', '0', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('4', '系统管理', '0', 'admin/admin', 'index', '0', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('11', '个人信息', '1', 'home/home', 'changepwd', '1', '99', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('5', '用户管理', '4', 'admin/user', 'index', '1', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('6', '新增用户', '5', 'admin/user', 'add', '2', '0', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('7', '用户组管理', '4', 'admin/group', 'index', '1', '2', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('8', '新增用户组', '7', 'admin/group', 'add', '2', '0', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('9', '节点管理', '4', 'admin/node', 'index', '1', '99', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('10', '新增节点', '9', 'admin/node', 'add', '2', '0', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('22', '显示子菜单', '1', 'home/home', 'menu', '1', '0', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('23', '编辑权限', '7', 'admin/access', 'edit', '2', '0', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('24', 'ajax入口', '1', 'home/home', 'ajax', '1', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('25', '权限ajax入口', '7', 'admin/access', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('27', '编辑用户组', '7', 'admin/group', 'edit', '2', '0', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('68', 'ajax入口', '7', 'admin/group', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('31', '编辑用户', '5', 'admin/user', 'edit', '2', '0', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('70', 'ajax入口', '9', 'admin/node', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('35', '编辑节点', '9', 'admin/node', 'edit', '2', '0', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('38', '导航页', '1', 'home/home', 'base', '1', '0', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('39', '微信平台管理', '0', '', 'index', '0', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('40', '关键字', '39', 'weixin/keywords', 'index', '1', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('41', '新增关键字', '40', 'weixin/keywords', 'add', '2', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('42', '回复', '39', 'weixin/reply', 'index', '1', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('43', 'ajax入口', '42', 'weixin/reply', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('44', '编辑', '40', 'weixin/keywords', 'edit', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('45', 'ajax入口', '40', 'weixin/keywords', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('46', '新增回复', '42', 'weixin/reply', 'add', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('47', '编辑回复', '42', 'weixin/reply', 'edit', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('48', '命令', '39', 'weixin/commands', 'index', '1', '2', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('49', '新增命令', '48', 'weixin/commands', 'add', '2', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('50', '编辑命令', '48', 'weixin/commands', 'edit', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('51', 'ajax入口', '48', 'weixin/commands', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('52', '消息类型', '39', 'weixin/msgtype', 'index', '1', '3', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('53', '新增类型', '52', 'weixin/msgtype', 'add', '2', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('54', 'ajax入口', '52', 'weixin/msgtype', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('55', '编辑类型', '52', 'weixin/msgtype', 'edit', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('56', '黑名单', '39', 'weixin/blacklist', 'index', '1', '9', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('58', 'ajax入口', '56', 'weixin/blacklist', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('59', '消息箱', '39', 'weixin/msgbox', 'index', '1', '8', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('60', '设置', '39', 'weixin/settings', 'index', '1', '99', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('61', '菜单', '39', 'weixin/menu', 'index', '1', '4', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('62', '新增菜单', '61', 'weixin/menu', 'add', '2', '1', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('63', 'ajax入口', '61', 'weixin/menu', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('64', '编辑菜单', '61', 'weixin/menu', 'edit', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('65', '远端操作', '61', 'weixin/menu', 'remoteoperation', '2', '2', '0', '1', '');
INSERT INTO `wxmsg_node` VALUES ('67', 'ajax入口', '5', 'admin/user', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('71', 'ajax入口', '60', 'weixin/settings', 'ajax', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('72', '上传', '42', 'weixin/reply', 'doupload', '2', '99', '1', '1', '');
INSERT INTO `wxmsg_node` VALUES ('73', '上传', '48', 'weixin/commands', 'doupload', '2', '99', '1', '1', '');
-- ----------------------------
-- Table structure for wxmsg_reply
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_reply`;
CREATE TABLE `wxmsg_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`for_key_id` int(10) unsigned NOT NULL DEFAULT '0',
`reply_msgtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`content` text NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
`pic_url` text NOT NULL,
`link_url` text NOT NULL,
`music_url` text NOT NULL,
`hqmusic_url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_reply
-- ----------------------------
INSERT INTO `wxmsg_reply` VALUES ('2', '2', '1', '接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件接收到用户订阅事件', '', '', '', '', '', '');
INSERT INTO `wxmsg_reply` VALUES ('5', '3', '1', '您输入的命令无法识别,请检查后再试~', '', '', '', '', '', '');
-- ----------------------------
-- Table structure for wxmsg_settings
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_settings`;
CREATE TABLE `wxmsg_settings` (
`key` varchar(200) NOT NULL DEFAULT '',
`value` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_settings
-- ----------------------------
INSERT INTO `wxmsg_settings` VALUES ('access_token', '');
INSERT INTO `wxmsg_settings` VALUES ('access_token_expire_time', '');
INSERT INTO `wxmsg_settings` VALUES ('appid', 'AppIdAppIdAppIdApp');
INSERT INTO `wxmsg_settings` VALUES ('appsecret', 'AppSecretAppSecretAppSecretAppSe');
INSERT INTO `wxmsg_settings` VALUES ('cmd_expire_time', '300');
INSERT INTO `wxmsg_settings` VALUES ('cmd_sign', '#');
INSERT INTO `wxmsg_settings` VALUES ('help_keyword', 'help_contents');
INSERT INTO `wxmsg_settings` VALUES ('pause_notice', '系统维护中,请稍后访问');
INSERT INTO `wxmsg_settings` VALUES ('run_mode', 'pause');
INSERT INTO `wxmsg_settings` VALUES ('token', 'TokenTokenTokenTokenTokenTokenTo');
INSERT INTO `wxmsg_settings` VALUES ('event_cmd_prefix', 'cmd_');
-- ----------------------------
-- Table structure for wxmsg_user
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_user`;
CREATE TABLE `wxmsg_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL DEFAULT '',
`password` varchar(40) NOT NULL DEFAULT '',
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`create_ip` char(15) NOT NULL DEFAULT '0',
`last_login_time` int(10) unsigned NOT NULL DEFAULT '0',
`last_login_ip` char(15) NOT NULL DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_user
-- ----------------------------
INSERT INTO `wxmsg_user` VALUES ('1', 'admin0', '7f2ebe1822c842d763a2d3115a740d99d9fe5465', '0', '0', '1389939369', '127.0.0.1', '1');
-- ----------------------------
-- Table structure for wxmsg_user_group
-- ----------------------------
DROP TABLE IF EXISTS `wxmsg_user_group`;
CREATE TABLE `wxmsg_user_group` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
KEY `user_id` (`user_id`) USING BTREE,
KEY `group_id` (`group_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wxmsg_user_group
-- ----------------------------
INSERT INTO `wxmsg_user_group` VALUES ('1', '1');

Comment ( 0 )

Sign in for post a comment