登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 50

dunzd/HQCRM最简易的客户管理系统

forked from 中星科技/HQCRM最简易的客户管理系统 
代码 Issues 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
crm.sql 117.24 KB
一键复制 编辑 原始数据 按行查看 历史
dunzd 提交于 2021-05-08 15:44 . 修改忽略文件和说明文件
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148
/*

 Navicat Premium Data Transfer



 Source Server         : 本地数据库

 Source Server Type    : MySQL

 Source Server Version : 50726

 Source Host           : 127.0.0.1:3306

 Source Schema         : hq



 Target Server Type    : MySQL

 Target Server Version : 50726

 File Encoding         : 65001



 Date: 08/05/2021 15:35:55

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for hq_admin

-- ----------------------------

DROP TABLE IF EXISTS `hq_admin`;

CREATE TABLE `hq_admin`  (

  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,

  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员用户名',

  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员密码',

  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0禁用/1启动',

  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上次登录时间',

  `last_login_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',

  `login_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录次数',

  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_admin

-- ----------------------------

INSERT INTO `hq_admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, 1620459233, '127.0.0.1', 1167, 'd', 1555249039, 1620459233);



-- ----------------------------

-- Table structure for hq_admin_log

-- ----------------------------

DROP TABLE IF EXISTS `hq_admin_log`;

CREATE TABLE `hq_admin_log`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `admin_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id',

  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员用户名',

  `useragent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',

  `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求链接',

  `method` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求类型',

  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资源类型',

  `param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求参数',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日志备注',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 537 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员日志' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_admin_log

-- ----------------------------

INSERT INTO `hq_admin_log` VALUES (490, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1619702131);

INSERT INTO `hq_admin_log` VALUES (491, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620292008);

INSERT INTO `hq_admin_log` VALUES (492, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620292017);

INSERT INTO `hq_admin_log` VALUES (493, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620292023);

INSERT INTO `hq_admin_log` VALUES (494, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620292077);

INSERT INTO `hq_admin_log` VALUES (495, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620292094);

INSERT INTO `hq_admin_log` VALUES (496, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/uploads/del.html?id=214', 'POST', 'json', '{\"id\":\"214\"}', '删除了图片', 1620292244);

INSERT INTO `hq_admin_log` VALUES (497, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620292269);

INSERT INTO `hq_admin_log` VALUES (498, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620292323);

INSERT INTO `hq_admin_log` VALUES (499, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/store/add_taocan.html', 'POST', 'json', '{\"name\":\"\\u5fae\\u4fe1\\u4e92\\u8054\\u5957\\u9910\",\"description\":\"\",\"rules\":\"210,211,212,215,216,217,213,218,219,220,221,222,214\"}', '添加了套餐', 1620293999);

INSERT INTO `hq_admin_log` VALUES (500, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/admin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620297402);

INSERT INTO `hq_admin_log` VALUES (501, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', '127.0.0.1', 'http://hq.com/admin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620297413);

INSERT INTO `hq_admin_log` VALUES (502, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620297464);

INSERT INTO `hq_admin_log` VALUES (503, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit.html?id=179', 'POST', 'json', '{\"id\":\"179\",\"exp_time\":\"2038-01-19\",\"taocan\":\"6\",\"name\":\"dddd\",\"contact\":\"1212\",\"mobile\":\"14567890765\"}', '修改了商家', 1620349606);

INSERT INTO `hq_admin_log` VALUES (504, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', '127.0.0.1', 'http://hq.com/lnadmin/store/del.html?id=179', 'POST', 'json', '{\"id\":\"179\"}', '删除了商家', 1620349698);

INSERT INTO `hq_admin_log` VALUES (505, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620350086);

INSERT INTO `hq_admin_log` VALUES (506, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620351975);

INSERT INTO `hq_admin_log` VALUES (507, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620354818);

INSERT INTO `hq_admin_log` VALUES (508, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit.html?id=177', 'POST', 'json', '{\"id\":\"177\",\"exp_time\":\"2038-01-19\",\"taocan\":\"6\",\"name\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"contact\":\"\\u9ec4\\u9752\",\"mobile\":\"13459401111\"}', '修改了商家', 1620355099);

INSERT INTO `hq_admin_log` VALUES (509, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit_taocan.html?id=5', 'POST', 'json', '{\"id\":\"5\",\"status\":\"0\",\"_verify\":\"0\"}', '修改了套餐', 1620355133);

INSERT INTO `hq_admin_log` VALUES (510, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit_taocan.html?id=5', 'POST', 'json', '{\"id\":\"5\",\"status\":\"1\",\"_verify\":\"0\"}', '修改了套餐', 1620370671);

INSERT INTO `hq_admin_log` VALUES (511, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/add.html', 'POST', 'json', '{\"pid\":\"0\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\",\"url\":\"\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\",\"id\":\"\"}', '添加了用户权限规则', 1620371058);

INSERT INTO `hq_admin_log` VALUES (512, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/add.html', 'POST', 'json', '{\"pid\":\"223\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\",\"url\":\"\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\",\"id\":\"\"}', '添加了用户权限规则', 1620371115);

INSERT INTO `hq_admin_log` VALUES (513, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"sort_order\":\"0\",\"_verify\":\"0\"}', '修改了用户权限规则', 1620371129);

INSERT INTO `hq_admin_log` VALUES (514, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/add_taocan.html', 'POST', 'json', '{\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\\u5957\\u9910\",\"description\":\"\",\"rules\":\"223,224\"}', '添加了套餐', 1620371197);

INSERT INTO `hq_admin_log` VALUES (515, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"pid\":\"223\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\",\"url\":\"hy\\/hygl\\/index\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\"}', '修改了用户权限规则', 1620371403);

INSERT INTO `hq_admin_log` VALUES (516, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620371966);

INSERT INTO `hq_admin_log` VALUES (517, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620371979);

INSERT INTO `hq_admin_log` VALUES (518, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"pid\":\"223\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\",\"url\":\"hy\\/index\\/index\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\"}', '修改了用户权限规则', 1620372407);

INSERT INTO `hq_admin_log` VALUES (519, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"pid\":\"223\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\",\"url\":\"hy\\/hygl\\/index\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\"}', '修改了用户权限规则', 1620372638);

INSERT INTO `hq_admin_log` VALUES (520, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"status\":\"0\",\"_verify\":\"0\"}', '修改了用户权限规则', 1620381739);

INSERT INTO `hq_admin_log` VALUES (521, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"status\":\"1\",\"_verify\":\"0\"}', '修改了用户权限规则', 1620381740);

INSERT INTO `hq_admin_log` VALUES (522, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/edit.html?id=224', 'POST', 'json', '{\"id\":\"224\",\"pid\":\"223\",\"name\":\"\\u9ec4\\u9875\\u5217\\u8868\",\"url\":\"hy\\/hygl\\/index\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\"}', '修改了用户权限规则', 1620381768);

INSERT INTO `hq_admin_log` VALUES (523, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/add.html?pid=224', 'POST', 'json', '{\"pid\":\"224\",\"name\":\"\\u6dfb\\u52a0\",\"url\":\"hy\\/hygl\\/add\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\",\"id\":\"\"}', '添加了用户权限规则', 1620381812);

INSERT INTO `hq_admin_log` VALUES (524, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/add.html?pid=224', 'POST', 'json', '{\"pid\":\"224\",\"name\":\"\\u7f16\\u8f91\",\"url\":\"hy\\/hygl\\/edit\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\",\"id\":\"\"}', '添加了用户权限规则', 1620381859);

INSERT INTO `hq_admin_log` VALUES (525, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620386152);

INSERT INTO `hq_admin_log` VALUES (526, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620386599);

INSERT INTO `hq_admin_log` VALUES (527, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/store/edit.html?id=177', 'POST', 'json', '{\"id\":\"177\",\"exp_time\":\"2038-01-19\",\"taocan\":\"5\",\"name\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"contact\":\"\\u9ec4\\u9752\",\"mobile\":\"13459401111\"}', '修改了商家', 1620386626);

INSERT INTO `hq_admin_log` VALUES (528, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/store/edit_taocan.html?id=7', 'POST', 'json', '{\"id\":\"7\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\\u5957\\u9910\",\"description\":\"\",\"rules\":\"223,224,13,14,15,16,17,18,164,165,192,204\"}', '修改了套餐', 1620387025);

INSERT INTO `hq_admin_log` VALUES (529, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620432139);

INSERT INTO `hq_admin_log` VALUES (530, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store_auth/add.html?pid=13', 'POST', 'json', '{\"pid\":\"13\",\"name\":\"\\u9ec4\\u9875\\u5b57\\u6bb5\",\"url\":\"hy\\/setting\\/field\",\"icon\":\"\",\"type\":\"nav\",\"sort_order\":\"0\",\"id\":\"\"}', '添加了用户权限规则', 1620432390);

INSERT INTO `hq_admin_log` VALUES (531, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620433102);

INSERT INTO `hq_admin_log` VALUES (532, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit.html?id=181', 'POST', 'json', '{\"id\":\"181\",\"exp_time\":\"2038-01-19\",\"taocan\":\"5\",\"name\":\"\\u9ec4\\u9875\\u5957\\u9910\",\"contact\":\"\\u9ec4\\u9875\\u6d4b\\u8bd5\",\"mobile\":\"15910000000\"}', '修改了商家', 1620433150);

INSERT INTO `hq_admin_log` VALUES (533, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit_taocan.html?id=7', 'POST', 'json', '{\"id\":\"7\",\"name\":\"\\u9ec4\\u9875\\u7ba1\\u7406\\u5957\\u9910\",\"description\":\"\",\"rules\":\"223,224,13,14,15,16,17,18,164,165,192,204,227\"}', '修改了套餐', 1620433168);

INSERT INTO `hq_admin_log` VALUES (534, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/store/edit.html?id=181', 'POST', 'json', '{\"id\":\"181\",\"exp_time\":\"2038-01-19\",\"taocan\":\"7\",\"name\":\"\\u9ec4\\u9875\\u5957\\u9910\",\"contact\":\"\\u9ec4\\u9875\\u6d4b\\u8bd5\",\"mobile\":\"15910000000\"}', '修改了商家', 1620433180);

INSERT INTO `hq_admin_log` VALUES (535, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620458947);

INSERT INTO `hq_admin_log` VALUES (536, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0', '127.0.0.1', 'http://hq.com/lnadmin/index/login.html', 'POST', 'json', '{\"username\":\"admin\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620459233);



-- ----------------------------

-- Table structure for hq_auth_group

-- ----------------------------

DROP TABLE IF EXISTS `hq_auth_group`;

CREATE TABLE `hq_auth_group`  (

  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,

  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `status` tinyint(1) NOT NULL DEFAULT 1,

  `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限组' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_auth_group

-- ----------------------------

INSERT INTO `hq_auth_group` VALUES (1, '超级管理员', '', 1, '6,43,44,110,111,120,121,122,112,117,118,119,113,114,115,116,125,126,127,128,129,130,131,132,4,123,92,124,45,68,69,70,103,5,16,37,38,39,18,53,17,40,41,42,15,22,23,24');



-- ----------------------------

-- Table structure for hq_auth_group_access

-- ----------------------------

DROP TABLE IF EXISTS `hq_auth_group_access`;

CREATE TABLE `hq_auth_group_access`  (

  `uid` smallint(5) UNSIGNED NOT NULL DEFAULT 0,

  `group_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限授权' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_auth_group_access

-- ----------------------------

INSERT INTO `hq_auth_group_access` VALUES (1, 1);

INSERT INTO `hq_auth_group_access` VALUES (2, 1);



-- ----------------------------

-- Table structure for hq_auth_rule

-- ----------------------------

DROP TABLE IF EXISTS `hq_auth_rule`;

CREATE TABLE `hq_auth_rule`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序',

  `type` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'nav,auth',

  `index` tinyint(1) NOT NULL DEFAULT 0 COMMENT '快捷导航',

  `status` tinyint(1) NOT NULL DEFAULT 1,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 129 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限规则' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_auth_rule

-- ----------------------------

INSERT INTO `hq_auth_rule` VALUES (4, 0, '系统设置', '', 'layui-icon-set', 5, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (5, 0, '管理员管理', '', 'layui-icon-auz', 6, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (6, 0, '控制台', 'lnadmin/index/home', 'layui-icon-home', 1, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (15, 5, '权限规则', 'lnadmin/auth/rule', 'fa fa-th-list', 3, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (16, 5, '管理员列表', 'lnadmin/admin/index', 'fa fa-user', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (17, 5, '角色管理', 'lnadmin/auth/group', 'fa fa-users', 2, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (18, 5, '操作日志', 'lnadmin/admin/log', 'fa fa-clock-o', 1, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (22, 15, '添加', 'lnadmin/auth/addRule', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (23, 15, '编辑', 'lnadmin/auth/editRule', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (24, 15, '删除', 'lnadmin/auth/delRule', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (37, 16, '添加', 'lnadmin/admin/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (38, 16, '编辑', 'lnadmin/admin/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (39, 16, '删除', 'lnadmin/admin/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (40, 17, '添加', 'lnadmin/auth/addGroup', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (41, 17, '编辑', 'lnadmin/auth/editGroup', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (42, 17, '删除', 'lnadmin/auth/delGroup', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (43, 6, '修改密码', 'lnadmin/index/editPassword', '', 2, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (44, 6, '清除缓存', 'lnadmin/index/clear', '', 3, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (45, 4, '上传设置', 'lnadmin/config/upload', 'fa fa-upload', 4, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (53, 18, '一键清空', 'lnadmin/admin/truncate', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (68, 45, '上传图片', 'lnadmin/index/uploadimage', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (69, 45, '上传文件', 'lnadmin/index/uploadfile', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (70, 45, '上传视频', 'lnadmin/index/uploadvideo', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (92, 4, '配置信息', 'lnadmin/config/param', '', 2, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (103, 4, '上传管理', 'lnadmin/uploads/index', '', 10, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (110, 0, '商户管理', 'lnadmin/store/index', 'layui-icon-user', 2, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (111, 110, '商户列表', 'lnadmin/store/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (112, 110, '套餐管理', 'lnadmin/store/taocan', '', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (113, 110, '权限列表', 'lnadmin/store_auth/rule', '', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (114, 113, '添加', 'lnadmin/store_auth/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (115, 113, '编辑', 'lnadmin/store_auth/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (116, 113, '删除', 'lnadmin/store_auth/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (117, 112, '添加', 'lnadmin/store/add_taocan', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (118, 112, '编辑', 'lnadmin/store/edit_taocan', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (119, 112, '删除', 'lnadmin/store/del_taocan', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (120, 111, '新增', 'lnadmin/store/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (121, 111, '编辑', 'lnadmin/store/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (122, 111, '删除', 'lnadmin/store/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (123, 4, '系统信息', 'lnadmin/config/setting', '', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (124, 4, '系统设置', 'lnadmin/config/system', '', 3, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (125, 110, '字典管理', 'lnadmin/dict/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (126, 125, '新增', 'lnadmin/dict/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (127, 125, '编辑', 'lnadmin/dict/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_auth_rule` VALUES (128, 125, '删除', 'lnadmin/dict/del', '', 0, 'auth', 0, 1);



-- ----------------------------

-- Table structure for hq_crm_contract

-- ----------------------------

DROP TABLE IF EXISTS `hq_crm_contract`;

CREATE TABLE `hq_crm_contract`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `customer_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户ID',

  `contract_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号',

  `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '签单人',

  `datetime` int(11) NOT NULL DEFAULT 0 COMMENT '签单日期',

  `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '起始日期',

  `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '到期时间',

  `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同文件',

  `photo` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '合同照片',

  `product` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联产品',

  `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '合同金额',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同备注',

  `get_product` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不可删,读取关联产品',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户 合同表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_crm_customer

-- ----------------------------

DROP TABLE IF EXISTS `hq_crm_customer`;

CREATE TABLE `hq_crm_customer`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',

  `company` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',

  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',

  `wechat` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',

  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

  `phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '固话',

  `province` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省',

  `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市',

  `region` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区',

  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',

  `lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '坐标LAT',

  `lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '坐标LNG',

  `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '出生年月',

  `category_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户分类',

  `from_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户来源',

  `industry_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户行业',

  `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户标签',

  `status` int(10) NOT NULL DEFAULT 0 COMMENT '客户状态',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户备注',

  `sort_order` int(10) NULL DEFAULT 100 COMMENT '排序',

  `draw_time` int(11) NOT NULL DEFAULT 0 COMMENT '公海领取时间',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_crm_customer

-- ----------------------------

INSERT INTO `hq_crm_customer` VALUES (1, 181, 300, '惠之予昆', 'http://hq.com/uploads/store_181/20210507\\a32ddd928a61ca06b6e4460255b56ffe.jpg', '公众号', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, NULL, 100, 0, 1620389330, 1620390873, 1620390873);

INSERT INTO `hq_crm_customer` VALUES (2, 181, 300, '惠之予昆', 'http://hq.com/uploads/store_181/20210507\\a32ddd928a61ca06b6e4460255b56ffe.jpg', '公众号', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, NULL, 100, 0, 1620389340, 1620389340, 0);

INSERT INTO `hq_crm_customer` VALUES (3, 181, 300, '惠之予昆', 'http://hq.com/uploads/store_181/20210507\\a32ddd928a61ca06b6e4460255b56ffe.jpg', '公众号', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, NULL, 1000, 0, 1620389549, 1620433880, 0);

INSERT INTO `hq_crm_customer` VALUES (4, 181, 300, ' s', 'http://hq.com/uploads/store_181/20210507\\aa8455229cbdd088c32bfc353790776b.jpg', 's', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, NULL, 100, 0, 1620389796, 1620389796, 0);

INSERT INTO `hq_crm_customer` VALUES (5, 181, 300, ' s', 'http://hq.com/uploads/store_181/20210507\\aa8455229cbdd088c32bfc353790776b.jpg', 's', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, NULL, 100, 0, 1620390122, 1620390761, 0);

INSERT INTO `hq_crm_customer` VALUES (6, 177, 294, '测试公司', '', '测试姓名', '15922222222', '15922222222', '1591111111@qq.com', '15922222222', '北京', '北京市', '东城区', '东直门大街15-4号', '', '', 1620403200, 3, 2, 1, '暂无', 2, '待签单', 100, 0, 1620445828, 1620445828, 0);



-- ----------------------------

-- Table structure for hq_crm_field

-- ----------------------------

DROP TABLE IF EXISTS `hq_crm_field`;

CREATE TABLE `hq_crm_field`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',

  `field` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段参数',

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段名称',

  `is_status` tinyint(5) NOT NULL DEFAULT 1 COMMENT '状态 0不启用 1启用',

  `is_show` tinyint(5) NOT NULL DEFAULT 1 COMMENT '列表显示 0不显示 1显示',

  `is_required` tinyint(5) NOT NULL DEFAULT 0 COMMENT '必填 0否 1是',

  `sort_order` int(10) NOT NULL DEFAULT 100 COMMENT '排序',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 223 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户 字段列表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_crm_field

-- ----------------------------

INSERT INTO `hq_crm_field` VALUES (118, 177, 'text', 'company', '公司', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (119, 177, 'text', 'name', '姓名', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (120, 177, 'image', 'image', '图片', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (121, 177, 'text', 'mobile', '手机', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (122, 177, 'text', 'wechat', '微信', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (123, 177, 'text', 'email', '邮箱', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (124, 177, 'text', 'phone', '电话', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (125, 177, 'address', 'address', '地址', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (126, 177, 'date', 'birthday', '生日', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (127, 177, 'category', 'category', '分类', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (128, 177, 'from', 'from', '来源', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (129, 177, 'industry', 'industry', '行业', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (130, 177, 'tag', 'tag', '标签', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (131, 177, 'status', 'status', '状态', 1, 1, 1, 100);

INSERT INTO `hq_crm_field` VALUES (132, 177, 'text', 'remark', '备注', 1, 1, 1, 100);



-- ----------------------------

-- Table structure for hq_crm_setting

-- ----------------------------

DROP TABLE IF EXISTS `hq_crm_setting`;

CREATE TABLE `hq_crm_setting`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置名称',

  `jdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'JDATA',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户 设置表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_crm_setting

-- ----------------------------

INSERT INTO `hq_crm_setting` VALUES (2, 177, 'crm', '{\"pool_import\":\"1\",\"pool_mobile\":\"1\",\"pool_drawnum\":\"0\",\"pool_recovery\":\"0\",\"crm_mobile\":\"1\"}');

INSERT INTO `hq_crm_setting` VALUES (3, 178, 'crm', '{\"pool_import\":\"1\",\"pool_mobile\":\"1\",\"pool_drawnum\":\"0\",\"pool_recovery\":\"0\",\"crm_mobile\":\"1\"}');

INSERT INTO `hq_crm_setting` VALUES (4, 181, 'crm', NULL);



-- ----------------------------

-- Table structure for hq_crm_track

-- ----------------------------

DROP TABLE IF EXISTS `hq_crm_track`;

CREATE TABLE `hq_crm_track`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `customer_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户ID',

  `user_id` int(10) NULL DEFAULT NULL COMMENT '操作用户',

  `type` tinyint(5) NOT NULL DEFAULT 1 COMMENT '类型 0系统记录 1用户记录',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户 跟进表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_crm_track

-- ----------------------------

INSERT INTO `hq_crm_track` VALUES (1, 181, 5, 300, 0, '添加了客户给黄页测试', 1620390122, 1620390122, 0);

INSERT INTO `hq_crm_track` VALUES (2, 181, 14, 300, 0, '添加了客户给黄页测试', 1620435550, 1620435550, 0);

INSERT INTO `hq_crm_track` VALUES (3, 181, 15, 300, 0, '添加了客户给黄页测试', 1620435576, 1620435576, 0);

INSERT INTO `hq_crm_track` VALUES (4, 181, 16, 300, 0, '添加了客户给黄页测试', 1620437514, 1620437514, 0);

INSERT INTO `hq_crm_track` VALUES (5, 181, 17, 300, 0, '添加了客户给黄页测试', 1620438602, 1620438602, 0);

INSERT INTO `hq_crm_track` VALUES (6, 181, 18, 300, 0, '添加了客户给黄页测试', 1620439070, 1620439070, 0);

INSERT INTO `hq_crm_track` VALUES (7, 181, 19, 300, 0, '添加了客户给黄页测试', 1620444691, 1620444691, 0);

INSERT INTO `hq_crm_track` VALUES (8, 177, 6, 294, 0, '添加了客户给黄佳慧', 1620445828, 1620445828, 0);



-- ----------------------------

-- Table structure for hq_dict

-- ----------------------------

DROP TABLE IF EXISTS `hq_dict`;

CREATE TABLE `hq_dict`  (

  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `auth_id` int(3) NOT NULL DEFAULT 0 COMMENT '所属权限',

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典类目名称',

  `is_level` tinyint(5) NOT NULL DEFAULT 0 COMMENT '是否多级 0否 1是',

  `is_image` tinyint(5) NOT NULL DEFAULT 0 COMMENT '是否图片 0否 1是',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_dict

-- ----------------------------

INSERT INTO `hq_dict` VALUES (13, 183, '客户分类', 0, 0);

INSERT INTO `hq_dict` VALUES (14, 183, '客户来源', 0, 0);

INSERT INTO `hq_dict` VALUES (15, 183, '客户行业', 0, 0);

INSERT INTO `hq_dict` VALUES (16, 194, '产品管理', 0, 0);



-- ----------------------------

-- Table structure for hq_dict_data

-- ----------------------------

DROP TABLE IF EXISTS `hq_dict_data`;

CREATE TABLE `hq_dict_data`  (

  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(3) NOT NULL DEFAULT 0 COMMENT '商家ID',

  `dict_id` int(3) NOT NULL DEFAULT 0 COMMENT '字典ID',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',

  `sort_order` tinyint(10) NOT NULL DEFAULT 100 COMMENT '排序',

  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他值',

  `is_default` tinyint(10) NOT NULL DEFAULT 0 COMMENT '是否默认 0否 1是',

  `status` tinyint(10) NOT NULL DEFAULT 1 COMMENT '状态 0禁用 1启用',

  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  `pid` int(5) NOT NULL DEFAULT 0 COMMENT '上级ID',

  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_dict_data

-- ----------------------------

INSERT INTO `hq_dict_data` VALUES (1, 177, 15, '金融行业', 100, NULL, 1, 1, 1620445700, 1620445700, 0, 0, NULL, '');

INSERT INTO `hq_dict_data` VALUES (2, 177, 14, '销售转化', 100, NULL, 1, 1, 1620445719, 1620445719, 0, 0, NULL, '');

INSERT INTO `hq_dict_data` VALUES (3, 177, 13, '工人', 100, NULL, 1, 1, 1620445728, 1620445728, 0, 0, NULL, '');

INSERT INTO `hq_dict_data` VALUES (4, 177, 16, '物超所值', 100, NULL, 1, 1, 1620445740, 1620445740, 0, 0, NULL, '');



-- ----------------------------

-- Table structure for hq_hy_customer

-- ----------------------------

DROP TABLE IF EXISTS `hq_hy_customer`;

CREATE TABLE `hq_hy_customer`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',

  `company` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',

  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',

  `wechat` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',

  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

  `phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '固话',

  `province` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省',

  `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市',

  `region` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区',

  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',

  `lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '坐标LAT',

  `lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '坐标LNG',

  `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '出生年月',

  `category_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户分类',

  `from_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户来源',

  `industry_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户行业',

  `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户标签',

  `status` int(10) NOT NULL DEFAULT 0 COMMENT '客户状态',

  `wxtype_id` int(10) NULL DEFAULT NULL COMMENT '微信类型（1公众号，2小程序，3h5,4其他)',

  `appid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信appid',

  `appsecret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信appsecret',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户备注',

  `sort_order` int(10) NULL DEFAULT 100 COMMENT '排序',

  `draw_time` int(11) NOT NULL DEFAULT 0 COMMENT '公海领取时间',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_hy_customer

-- ----------------------------

INSERT INTO `hq_hy_customer` VALUES (18, 181, 300, '1', 'http://hq.com/uploads/store_181/20210508\\4f3b41f489bd8eefa827fc8ae70500ab.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, 1, '3', '4', NULL, 100, 0, 1620439070, 1620439070, 0);

INSERT INTO `hq_hy_customer` VALUES (19, 181, 300, '2222222', 'http://hq.com/uploads/store_181/20210508\\8e676c0b09568502aa0857d5f5c5c5d8.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 0, 2, '2222222', '22222222', NULL, 100, 0, 1620444691, 1620444691, 0);



-- ----------------------------

-- Table structure for hq_hy_field

-- ----------------------------

DROP TABLE IF EXISTS `hq_hy_field`;

CREATE TABLE `hq_hy_field`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',

  `field` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段参数',

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段名称',

  `is_status` tinyint(5) NOT NULL DEFAULT 1 COMMENT '状态 0不启用 1启用',

  `is_show` tinyint(5) NOT NULL DEFAULT 1 COMMENT '列表显示 0不显示 1显示',

  `is_required` tinyint(5) NOT NULL DEFAULT 0 COMMENT '必填 0否 1是',

  `sort_order` int(10) NOT NULL DEFAULT 100 COMMENT '排序',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 254 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '黄页字段列表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_hy_field

-- ----------------------------

INSERT INTO `hq_hy_field` VALUES (249, 181, 'text', 'company', '名称', 1, 1, 1, 100);

INSERT INTO `hq_hy_field` VALUES (250, 181, 'wxtype', 'wxtype', '类型', 1, 1, 1, 100);

INSERT INTO `hq_hy_field` VALUES (251, 181, 'image', 'image', '图片', 1, 1, 1, 100);

INSERT INTO `hq_hy_field` VALUES (252, 181, 'text', 'appid', 'Appid', 1, 1, 1, 100);

INSERT INTO `hq_hy_field` VALUES (253, 181, 'text', 'appsecret', 'Appsecret', 1, 1, 1, 100);



-- ----------------------------

-- Table structure for hq_notice

-- ----------------------------

DROP TABLE IF EXISTS `hq_notice`;

CREATE TABLE `hq_notice`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `customer_id` int(10) NOT NULL DEFAULT 0 COMMENT '客户ID',

  `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',

  `datetime` int(11) NOT NULL DEFAULT 0 COMMENT '日期',

  `type` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息内容',

  `status` tinyint(5) NOT NULL DEFAULT 0 COMMENT '状态 0待办 1已办',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_store

-- ----------------------------

DROP TABLE IF EXISTS `hq_store`;

CREATE TABLE `hq_store`  (

  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户名称',

  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'LOGO',

  `contact` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',

  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',

  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `taocan` int(3) NOT NULL DEFAULT 0 COMMENT '套餐ID',

  `admin_id` int(3) NOT NULL DEFAULT 0 COMMENT '管理员ID',

  `exp_time` int(11) NOT NULL DEFAULT 0 COMMENT '过期时间',

  `status` int(3) NOT NULL DEFAULT 1 COMMENT '状态',

  `wechat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公众号',

  `wxapp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '小程序',

  `wxpay` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '微信支付',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 182 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商家列表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_store

-- ----------------------------

INSERT INTO `hq_store` VALUES (177, '阿波罗云', 'http://hq.com/uploads/store_177/20210508\\f7ce56337bd79a46ea23407057dc9cb7.jpg', '黄青', '13459401111', '北京', '北京市', '朝阳区', '建国路93号万达广场6号楼', '211', 5, 293, 2147443200, 1, '{\"appid\":\"wx97b86655ce66c\",\"appsecret\":\"5d66e5b7c1596fdae853f131af96ea34\"}', '{\"appid\":\"\",\"appsecret\":\"\"}', '{\"mch_id\":\"\",\"key\":\"\",\"certpem\":\"\",\"keypem\":\"\"}', 1608815252, 1620445751, 0);

INSERT INTO `hq_store` VALUES (179, 'dddd', NULL, '1212', '14567890765', NULL, NULL, NULL, NULL, NULL, 6, 298, 2147443200, 1, NULL, NULL, NULL, 1620345486, 1620349698, 1620349698);

INSERT INTO `hq_store` VALUES (180, '测试活动', NULL, '测试', '15910101010', NULL, NULL, NULL, NULL, NULL, 6, 299, 2147483647, 1, NULL, NULL, NULL, 1620370611, 1620370611, 0);

INSERT INTO `hq_store` VALUES (181, '黄页套餐', NULL, '黄页测试', '15910000000', NULL, NULL, NULL, NULL, NULL, 7, 300, 2147443200, 1, NULL, NULL, NULL, 1620371243, 1620433180, 0);



-- ----------------------------

-- Table structure for hq_store_auth

-- ----------------------------

DROP TABLE IF EXISTS `hq_store_auth`;

CREATE TABLE `hq_store_auth`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序',

  `type` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'nav,auth',

  `index` tinyint(1) NOT NULL DEFAULT 0 COMMENT '快捷导航',

  `status` tinyint(1) NOT NULL DEFAULT 1,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 228 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户 权限规则' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_store_auth

-- ----------------------------

INSERT INTO `hq_store_auth` VALUES (1, 0, '工作台', '', 'layui-icon-home', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (2, 0, '成员管理', '', 'layui-icon-user', 9, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (3, 2, '成员列表', 'store/user/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (4, 2, '部门设置', 'store/group/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (5, 2, '操作日志', 'store/log/index', '', 5, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (6, 3, '添加', 'store/user/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (7, 3, '编辑', 'store/user/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (8, 3, '删除', 'store/user/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (9, 4, '添加', 'store/group/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (10, 4, '编辑', 'store/group/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (11, 4, '删除', 'store/group/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (12, 5, '一键清空', 'store/log/truncate', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (13, 0, '系统配置', '', 'layui-icon-set', 10, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (14, 13, '账户配置', 'store/shop/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (15, 13, '字典管理', 'store/dict/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (16, 15, '添加', 'store/dict/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (17, 15, '编辑', 'store/dict/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (18, 15, '删除', 'store/dict/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (109, 2, '角色管理', 'store/rule/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (110, 109, '添加', 'store/rule/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (111, 109, '编辑', 'store/rule/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (112, 109, '删除', 'store/rule/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (164, 15, '设为默认', 'store/dict/edit_default', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (165, 13, '系统续费', 'store/index/renew', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (182, 0, '客户管理', '', 'layui-icon-user', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (183, 182, '客户列表', 'crm/customer/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (184, 183, '添加', 'crm/customer/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (185, 183, '编辑', 'crm/customer/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (186, 183, '删除', 'crm/customer/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (187, 183, '转移', 'crm/customer/transfer', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (188, 182, '跟进记录', 'crm/track/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (189, 188, '添加', 'crm/track/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (190, 188, '编辑', 'crm/track/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (191, 188, '删除', 'crm/track/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (192, 13, 'CRM字段', 'crm/setting/field', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (193, 183, '导入客户', 'crm/customer/import', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (194, 182, '合同管理', 'crm/contract/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (195, 194, '添加', 'crm/contract/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (196, 194, '编辑', 'crm/contract/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (197, 194, '删除', 'crm/contract/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (198, 1, '我的工作台', 'store/index/home', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (199, 1, '消息中心', 'store/notice/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (200, 182, '公海客户', 'crm/customer/pool', '', 2, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (201, 183, '领取', 'crm/customer/receive', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (203, 183, '详情', 'crm/customer/detail', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (204, 13, 'CRM配置', 'crm/setting/crm', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (209, 183, '转入公海', 'crm/customer/transfer_pool', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (210, 0, '微信互联', '', 'layui-icon-login-wechat', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (211, 210, '微信用户', 'wechat/user/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (212, 210, '自定义菜单', 'wechat/menu/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (213, 210, '模板消息', 'wechat/template/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (214, 210, '公众号配置', 'wechat/setting/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (215, 212, '添加菜单', 'wechat/menu/add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (216, 212, '编辑', 'wechat/menu/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (217, 212, '删除', 'wechat/menu/del', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (218, 213, '更新模板消息', 'wechat/template/update', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (219, 213, '编辑模板', 'wechat/template/edit', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (220, 213, '任务列表', 'wechat/template/task', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (221, 213, '添加发送任务', 'wechat/template/task_add', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (222, 213, '批量发送消息', 'wechat/template/task_send', '', 0, 'auth', 0, 1);

INSERT INTO `hq_store_auth` VALUES (223, 0, '黄页管理', '', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (224, 223, '黄页列表', 'hy/hygl/index', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (225, 224, '添加', 'hy/hygl/add', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (226, 224, '编辑', 'hy/hygl/edit', '', 0, 'nav', 0, 1);

INSERT INTO `hq_store_auth` VALUES (227, 13, '黄页字段', 'hy/setting/field', '', 0, 'nav', 0, 1);



-- ----------------------------

-- Table structure for hq_store_group

-- ----------------------------

DROP TABLE IF EXISTS `hq_store_group`;

CREATE TABLE `hq_store_group`  (

  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` smallint(5) NULL DEFAULT NULL COMMENT '商户ID',

  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',

  `pid` int(11) NULL DEFAULT 0 COMMENT '上级ID',

  `person` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主管',

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '部门介绍',

  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态',

  `sort_order` int(5) NOT NULL DEFAULT 0 COMMENT '排序',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 228 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户 部门表\r\n' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_store_group

-- ----------------------------

INSERT INTO `hq_store_group` VALUES (215, 177, '总经理', 0, NULL, '', 1, 0, 1608815252, 1608867853, 0);

INSERT INTO `hq_store_group` VALUES (216, 177, '财务部', 215, NULL, '', 1, 0, 1608864027, 1608873120, 0);

INSERT INTO `hq_store_group` VALUES (217, 177, '技术部', 216, NULL, '', 1, 0, 1608864057, 1608867952, 0);

INSERT INTO `hq_store_group` VALUES (218, 177, '大老爷', 217, NULL, '', 1, 0, 1608864382, 1609307665, 0);

INSERT INTO `hq_store_group` VALUES (221, 177, '000', 216, NULL, '', 1, 0, 1608868872, 1608869052, 0);

INSERT INTO `hq_store_group` VALUES (222, 177, '恩恩', 215, NULL, '', 1, 0, 1608871647, 1608871667, 0);

INSERT INTO `hq_store_group` VALUES (223, 178, '总经理', 0, NULL, '', 1, 0, 1609126544, 1609126544, 0);

INSERT INTO `hq_store_group` VALUES (224, 178, '业务员', 223, NULL, '', 1, 0, 1609141325, 1609141325, 0);

INSERT INTO `hq_store_group` VALUES (225, 179, '总经理', 0, NULL, '', 1, 0, 1620345486, 1620345486, 0);

INSERT INTO `hq_store_group` VALUES (226, 180, '总经理', 0, NULL, '', 1, 0, 1620370611, 1620370611, 0);

INSERT INTO `hq_store_group` VALUES (227, 181, '总经理', 0, NULL, '', 1, 0, 1620371243, 1620371243, 0);



-- ----------------------------

-- Table structure for hq_store_log

-- ----------------------------

DROP TABLE IF EXISTS `hq_store_log`;

CREATE TABLE `hq_store_log`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `store_id` smallint(5) NOT NULL COMMENT '商家ID',

  `user_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id',

  `client` smallint(3) NOT NULL DEFAULT 0 COMMENT '客户端',

  `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求链接',

  `method` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求类型',

  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资源类型',

  `param` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求参数',

  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日志备注',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8075 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户 操作日志' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_store_log

-- ----------------------------

INSERT INTO `hq_store_log` VALUES (7946, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620292806, 1620292806, 0);

INSERT INTO `hq_store_log` VALUES (7947, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620292874, 1620292874, 0);

INSERT INTO `hq_store_log` VALUES (7948, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/shop/index.html', 'POST', 'json', '{\"logo\":\"http:\\/\\/hq.com\\/uploads\\/store_177\\/20210506\\\\a5cbd6c7f47a918f08b6e063fad5bd57.jpg\",\"name\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"contact\":\"\\u9ec4\\u9752\",\"mobile\":\"13459401111\",\"shengshi\":\"\\u5317\\u4eac,\\u5317\\u4eac\\u5e02,\\u671d\\u9633\\u533a\",\"address\":\"\",\"lat\":\"\",\"lng\":\"\",\"remark\":\"211\",\"province\":\"\",\"city\":\"\",\"area\":\"\"}', '修改了系统信息', 1620292905, 1620292905, 0);

INSERT INTO `hq_store_log` VALUES (7949, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/shop/index.html', 'POST', 'json', '{\"logo\":\"http:\\/\\/hq.com\\/uploads\\/store_177\\/20210506\\\\a5cbd6c7f47a918f08b6e063fad5bd57.jpg\",\"name\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"contact\":\"\\u9ec4\\u9752\",\"mobile\":\"13459401111\",\"shengshi\":\"\\u5317\\u4eac,\\u5317\\u4eac\\u5e02,\\u671d\\u9633\\u533a\",\"address\":\"\\u5efa\\u56fd\\u8def93\\u53f7\\u4e07\\u8fbe\\u5e7f\\u573a6\\u53f7\\u697c\",\"lat\":\"39.910222\",\"lng\":\"116.472256\",\"remark\":\"211\",\"province\":\"\",\"city\":\"\",\"area\":\"\"}', '修改了系统信息', 1620293081, 1620293081, 0);

INSERT INTO `hq_store_log` VALUES (7950, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620293139, 1620293139, 0);

INSERT INTO `hq_store_log` VALUES (7951, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620293142, 1620293142, 0);

INSERT INTO `hq_store_log` VALUES (7952, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620293238, 1620293238, 0);

INSERT INTO `hq_store_log` VALUES (7953, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620293241, 1620293241, 0);

INSERT INTO `hq_store_log` VALUES (7954, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620355087, 1620355087, 0);

INSERT INTO `hq_store_log` VALUES (7955, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620355110, 1620355110, 0);

INSERT INTO `hq_store_log` VALUES (7956, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620355112, 1620355112, 0);

INSERT INTO `hq_store_log` VALUES (7957, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620355143, 1620355143, 0);

INSERT INTO `hq_store_log` VALUES (7958, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620355145, 1620355145, 0);

INSERT INTO `hq_store_log` VALUES (7959, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620355170, 1620355170, 0);

INSERT INTO `hq_store_log` VALUES (7960, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620355193, 1620355193, 0);

INSERT INTO `hq_store_log` VALUES (7961, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620370622, 1620370622, 0);

INSERT INTO `hq_store_log` VALUES (7962, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910101010\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620370631, 1620370631, 0);

INSERT INTO `hq_store_log` VALUES (7963, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620370757, 1620370757, 0);

INSERT INTO `hq_store_log` VALUES (7964, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620370766, 1620370766, 0);

INSERT INTO `hq_store_log` VALUES (7965, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620371251, 1620371251, 0);

INSERT INTO `hq_store_log` VALUES (7966, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620371261, 1620371261, 0);

INSERT INTO `hq_store_log` VALUES (7967, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620371277, 1620371277, 0);

INSERT INTO `hq_store_log` VALUES (7968, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620371281, 1620371281, 0);

INSERT INTO `hq_store_log` VALUES (7969, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620371285, 1620371285, 0);

INSERT INTO `hq_store_log` VALUES (7970, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620371286, 1620371286, 0);

INSERT INTO `hq_store_log` VALUES (7971, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620371288, 1620371288, 0);

INSERT INTO `hq_store_log` VALUES (7972, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620371289, 1620371289, 0);

INSERT INTO `hq_store_log` VALUES (7973, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620371293, 1620371293, 0);

INSERT INTO `hq_store_log` VALUES (7974, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620371304, 1620371304, 0);

INSERT INTO `hq_store_log` VALUES (7975, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620372419, 1620372419, 0);

INSERT INTO `hq_store_log` VALUES (7976, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620372431, 1620372431, 0);

INSERT INTO `hq_store_log` VALUES (7977, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620372507, 1620372507, 0);

INSERT INTO `hq_store_log` VALUES (7978, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620372684, 1620372684, 0);

INSERT INTO `hq_store_log` VALUES (7979, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620372686, 1620372686, 0);

INSERT INTO `hq_store_log` VALUES (7980, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620372788, 1620372788, 0);

INSERT INTO `hq_store_log` VALUES (7981, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620372790, 1620372790, 0);

INSERT INTO `hq_store_log` VALUES (7982, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379123, 1620379123, 0);

INSERT INTO `hq_store_log` VALUES (7983, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379125, 1620379125, 0);

INSERT INTO `hq_store_log` VALUES (7984, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379179, 1620379179, 0);

INSERT INTO `hq_store_log` VALUES (7985, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379182, 1620379182, 0);

INSERT INTO `hq_store_log` VALUES (7986, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379589, 1620379589, 0);

INSERT INTO `hq_store_log` VALUES (7987, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379591, 1620379591, 0);

INSERT INTO `hq_store_log` VALUES (7988, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379686, 1620379686, 0);

INSERT INTO `hq_store_log` VALUES (7989, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910101010\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379693, 1620379693, 0);

INSERT INTO `hq_store_log` VALUES (7990, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379700, 1620379700, 0);

INSERT INTO `hq_store_log` VALUES (7991, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13459401111\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379707, 1620379707, 0);

INSERT INTO `hq_store_log` VALUES (7992, 177, 293, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620379948, 1620379948, 0);

INSERT INTO `hq_store_log` VALUES (7993, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910101010\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620379954, 1620379954, 0);

INSERT INTO `hq_store_log` VALUES (7994, 180, 299, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620380221, 1620380221, 0);

INSERT INTO `hq_store_log` VALUES (7995, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620380229, 1620380229, 0);

INSERT INTO `hq_store_log` VALUES (7996, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620381025, 1620381025, 0);

INSERT INTO `hq_store_log` VALUES (7997, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620381295, 1620381295, 0);

INSERT INTO `hq_store_log` VALUES (7998, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620381298, 1620381298, 0);

INSERT INTO `hq_store_log` VALUES (7999, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381507, 1620381507, 0);

INSERT INTO `hq_store_log` VALUES (8000, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381511, 1620381511, 0);

INSERT INTO `hq_store_log` VALUES (8001, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381515, 1620381515, 0);

INSERT INTO `hq_store_log` VALUES (8002, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620381516, 1620381516, 0);

INSERT INTO `hq_store_log` VALUES (8003, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620381518, 1620381518, 0);

INSERT INTO `hq_store_log` VALUES (8004, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381519, 1620381519, 0);

INSERT INTO `hq_store_log` VALUES (8005, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381523, 1620381523, 0);

INSERT INTO `hq_store_log` VALUES (8006, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381527, 1620381527, 0);

INSERT INTO `hq_store_log` VALUES (8007, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620381529, 1620381529, 0);

INSERT INTO `hq_store_log` VALUES (8008, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620381535, 1620381535, 0);

INSERT INTO `hq_store_log` VALUES (8009, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620381536, 1620381536, 0);

INSERT INTO `hq_store_log` VALUES (8010, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620385087, 1620385087, 0);

INSERT INTO `hq_store_log` VALUES (8011, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620385091, 1620385091, 0);

INSERT INTO `hq_store_log` VALUES (8012, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620385242, 1620385242, 0);

INSERT INTO `hq_store_log` VALUES (8013, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620385262, 1620385262, 0);

INSERT INTO `hq_store_log` VALUES (8014, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620385459, 1620385459, 0);

INSERT INTO `hq_store_log` VALUES (8015, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620385559, 1620385559, 0);

INSERT INTO `hq_store_log` VALUES (8016, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620385784, 1620385784, 0);

INSERT INTO `hq_store_log` VALUES (8017, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620385786, 1620385786, 0);

INSERT INTO `hq_store_log` VALUES (8018, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620386552, 1620386552, 0);

INSERT INTO `hq_store_log` VALUES (8019, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620386662, 1620386662, 0);

INSERT INTO `hq_store_log` VALUES (8020, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620388576, 1620388576, 0);

INSERT INTO `hq_store_log` VALUES (8021, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620388651, 1620388651, 0);

INSERT INTO `hq_store_log` VALUES (8022, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620388844, 1620388844, 0);

INSERT INTO `hq_store_log` VALUES (8023, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620388999, 1620388999, 0);

INSERT INTO `hq_store_log` VALUES (8024, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620389217, 1620389217, 0);

INSERT INTO `hq_store_log` VALUES (8025, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620389328, 1620389328, 0);

INSERT INTO `hq_store_log` VALUES (8026, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620389386, 1620389386, 0);

INSERT INTO `hq_store_log` VALUES (8027, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620389741, 1620389741, 0);

INSERT INTO `hq_store_log` VALUES (8028, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620389769, 1620389769, 0);

INSERT INTO `hq_store_log` VALUES (8029, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620389789, 1620389789, 0);

INSERT INTO `hq_store_log` VALUES (8030, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\" s\",\"name\":\"s\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210507\\\\aa8455229cbdd088c32bfc353790776b.jpg\"}', '添加了客户', 1620390122, 1620390122, 0);

INSERT INTO `hq_store_log` VALUES (8031, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/edit.html?id=5', 'POST', 'json', '{\"id\":\"5\",\"sort_order\":\"100\",\"_verify\":\"0\"}', '修改了客户信息', 1620390761, 1620390761, 0);

INSERT INTO `hq_store_log` VALUES (8032, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/edit.html?id=3', 'POST', 'json', '{\"id\":\"3\",\"sort_order\":\"1\",\"_verify\":\"0\"}', '修改了客户信息', 1620390767, 1620390767, 0);

INSERT INTO `hq_store_log` VALUES (8033, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/edit.html?id=3', 'POST', 'json', '{\"id\":\"3\",\"sort_order\":\"1000\",\"_verify\":\"0\"}', '修改了客户信息', 1620390778, 1620390778, 0);

INSERT INTO `hq_store_log` VALUES (8034, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=1', 'POST', 'json', '{\"id\":\"1\"}', '删除客户', 1620390873, 1620390873, 0);

INSERT INTO `hq_store_log` VALUES (8035, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620431725, 1620431725, 0);

INSERT INTO `hq_store_log` VALUES (8036, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/logout.html', 'GET', 'xml', '[]', '退出了后台系统', 1620433122, 1620433122, 0);

INSERT INTO `hq_store_log` VALUES (8037, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620433124, 1620433124, 0);

INSERT INTO `hq_store_log` VALUES (8038, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620433294, 1620433294, 0);

INSERT INTO `hq_store_log` VALUES (8039, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620433615, 1620433615, 0);

INSERT INTO `hq_store_log` VALUES (8040, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/clear.html', 'GET', 'xml', '[]', '清理了缓存', 1620433617, 1620433617, 0);

INSERT INTO `hq_store_log` VALUES (8041, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620433708, 1620433708, 0);

INSERT INTO `hq_store_log` VALUES (8042, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/edit.html?id=3', 'POST', 'json', '{\"id\":\"3\",\"company\":\"\\u60e0\\u4e4b\\u4e88\\u6606\",\"name\":\"\\u516c\\u4f17\\u53f7\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210507\\\\a32ddd928a61ca06b6e4460255b56ffe.jpg\",\"Appid\":\"1\",\"Appsecret\":\"2\"}', '修改了客户信息', 1620433880, 1620433880, 0);

INSERT INTO `hq_store_log` VALUES (8043, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620434735, 1620434735, 0);

INSERT INTO `hq_store_log` VALUES (8044, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620434957, 1620434957, 0);

INSERT INTO `hq_store_log` VALUES (8045, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\"\\u60e0\\u4e4b\\u4e88\\u6606\",\"name\":\"1\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210508\\\\c8d9e0f85ebeefc0513e4c7a66cc8bd5.jpg\",\"Appid\":\"1\",\"Appsecret\":\"2\"}', '添加了客户', 1620435576, 1620435576, 0);

INSERT INTO `hq_store_log` VALUES (8046, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=6', 'POST', 'json', '{\"id\":\"6\"}', '删除客户', 1620435584, 1620435584, 0);

INSERT INTO `hq_store_log` VALUES (8047, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=9', 'POST', 'json', '{\"id\":\"9\"}', '删除客户', 1620435588, 1620435588, 0);

INSERT INTO `hq_store_log` VALUES (8048, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=8', 'POST', 'json', '{\"id\":\"8\"}', '删除客户', 1620435593, 1620435593, 0);

INSERT INTO `hq_store_log` VALUES (8049, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=7', 'POST', 'json', '{\"id\":\"7\"}', '删除客户', 1620435599, 1620435599, 0);

INSERT INTO `hq_store_log` VALUES (8050, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=10', 'POST', 'json', '{\"id\":\"10\"}', '删除客户', 1620435604, 1620435604, 0);

INSERT INTO `hq_store_log` VALUES (8051, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=11', 'POST', 'json', '{\"id\":\"11\"}', '删除客户', 1620435608, 1620435608, 0);

INSERT INTO `hq_store_log` VALUES (8052, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=12', 'POST', 'json', '{\"id\":\"12\"}', '删除客户', 1620435614, 1620435614, 0);

INSERT INTO `hq_store_log` VALUES (8053, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=13', 'POST', 'json', '{\"id\":\"13\"}', '删除客户', 1620435618, 1620435618, 0);

INSERT INTO `hq_store_log` VALUES (8054, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=14', 'POST', 'json', '{\"id\":\"14\"}', '删除客户', 1620435622, 1620435622, 0);

INSERT INTO `hq_store_log` VALUES (8055, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/del.html?id=15', 'POST', 'json', '{\"id\":\"15\"}', '删除客户', 1620437498, 1620437498, 0);

INSERT INTO `hq_store_log` VALUES (8056, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620437509, 1620437509, 0);

INSERT INTO `hq_store_log` VALUES (8057, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\" \\u65e0\\u60c5\\u4e8c\\u4e03\",\"name\":\"1\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210508\\\\399ff617d5a5062b5892107cdaa9b793.jpg\",\"Appid\":\" 1\",\"Appsecret\":\"2\"}', '添加了客户', 1620437514, 1620437514, 0);

INSERT INTO `hq_store_log` VALUES (8058, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620438598, 1620438598, 0);

INSERT INTO `hq_store_log` VALUES (8059, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\"1\",\"name\":\"1\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210508\\\\8a3779e84012801dc2b1c80a9ee7308e.jpg\",\"Appid\":\"2\",\"Appsecret\":\"3\"}', '添加了客户', 1620438602, 1620438602, 0);

INSERT INTO `hq_store_log` VALUES (8060, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620438783, 1620438783, 0);

INSERT INTO `hq_store_log` VALUES (8061, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620438875, 1620438875, 0);

INSERT INTO `hq_store_log` VALUES (8062, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"15910000000\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620438971, 1620438971, 0);

INSERT INTO `hq_store_log` VALUES (8063, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620439024, 1620439024, 0);

INSERT INTO `hq_store_log` VALUES (8064, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\"1\",\"wxtype\":\"1\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210508\\\\4f3b41f489bd8eefa827fc8ae70500ab.jpg\",\"appid\":\"3\",\"appsecret\":\"4\"}', '添加了客户', 1620439070, 1620439070, 0);

INSERT INTO `hq_store_log` VALUES (8065, 181, 300, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620444681, 1620444681, 0);

INSERT INTO `hq_store_log` VALUES (8066, 181, 300, 0, '127.0.0.1', 'http://hq.com/hy/hygl/add.html', 'POST', 'json', '{\"company\":\"2222222\",\"wxtype\":\"2\",\"image\":\"http:\\/\\/hq.com\\/uploads\\/store_181\\/20210508\\\\8e676c0b09568502aa0857d5f5c5c5d8.jpg\",\"appid\":\"2222222\",\"appsecret\":\"22222222\"}', '添加了客户', 1620444691, 1620444691, 0);

INSERT INTO `hq_store_log` VALUES (8067, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/index/login.html', 'POST', 'json', '{\"username\":\"13055556455\",\"password\":\"123456\",\"remember_user\":\"on\"}', '登录了后台系统', 1620445580, 1620445580, 0);

INSERT INTO `hq_store_log` VALUES (8068, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/dict/add.html?dict_id=15', 'POST', 'json', '{\"dict_id\":\"15\",\"name\":\"\\u91d1\\u878d\\u884c\\u4e1a\",\"remark\":\"\"}', '添加了字典', 1620445700, 1620445700, 0);

INSERT INTO `hq_store_log` VALUES (8069, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/dict/add.html?dict_id=14', 'POST', 'json', '{\"dict_id\":\"14\",\"name\":\"\\u9500\\u552e\\u8f6c\\u5316\",\"remark\":\"\"}', '添加了字典', 1620445719, 1620445719, 0);

INSERT INTO `hq_store_log` VALUES (8070, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/dict/add.html?dict_id=13', 'POST', 'json', '{\"dict_id\":\"13\",\"name\":\"\\u5de5\\u4eba\",\"remark\":\"\"}', '添加了字典', 1620445728, 1620445728, 0);

INSERT INTO `hq_store_log` VALUES (8071, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/dict/add.html?dict_id=16', 'POST', 'json', '{\"dict_id\":\"16\",\"name\":\"\\u7269\\u8d85\\u6240\\u503c\",\"remark\":\"\"}', '添加了字典', 1620445740, 1620445740, 0);

INSERT INTO `hq_store_log` VALUES (8072, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/uploads/uploadImage', 'POST', 'json', '[]', '上传了图片', 1620445748, 1620445748, 0);

INSERT INTO `hq_store_log` VALUES (8073, 177, 294, 0, '127.0.0.1', 'http://hq.com/store/shop/index.html', 'POST', 'json', '{\"logo\":\"http:\\/\\/hq.com\\/uploads\\/store_177\\/20210508\\\\f7ce56337bd79a46ea23407057dc9cb7.jpg\",\"name\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"contact\":\"\\u9ec4\\u9752\",\"mobile\":\"13459401111\",\"shengshi\":\"\\u5317\\u4eac,\\u5317\\u4eac\\u5e02,\\u671d\\u9633\\u533a\",\"address\":\"\\u5efa\\u56fd\\u8def93\\u53f7\\u4e07\\u8fbe\\u5e7f\\u573a6\\u53f7\\u697c\",\"lat\":\"\",\"lng\":\"\",\"remark\":\"211\",\"province\":\"\",\"city\":\"\",\"area\":\"\"}', '修改了系统信息', 1620445751, 1620445751, 0);

INSERT INTO `hq_store_log` VALUES (8074, 177, 294, 0, '127.0.0.1', 'http://hq.com/crm/customer/add.html', 'POST', 'json', '{\"company\":\"\\u6d4b\\u8bd5\\u516c\\u53f8\",\"name\":\"\\u6d4b\\u8bd5\\u59d3\\u540d\",\"image\":\"\",\"mobile\":\"15922222222\",\"wechat\":\"15922222222\",\"email\":\"1591111111@qq.com\",\"phone\":\"15922222222\",\"shengshi\":\"\\u5317\\u4eac,\\u5317\\u4eac\\u5e02,\\u4e1c\\u57ce\\u533a\",\"province\":\"\",\"city\":\"\",\"region\":\"\",\"address\":\"\\u4e1c\\u76f4\\u95e8\\u5927\\u885715-4\\u53f7\",\"lat\":\"\",\"lng\":\"\",\"birthday\":\"2021-05-08\",\"category_id\":\"3\",\"from_id\":\"2\",\"industry_id\":\"1\",\"tag\":\"\\u6682\\u65e0\",\"status\":\"2\",\"remark\":\"\\u5f85\\u7b7e\\u5355\",\"user_id\":\"294\"}', '添加了客户', 1620445828, 1620445828, 0);



-- ----------------------------

-- Table structure for hq_store_rule

-- ----------------------------

DROP TABLE IF EXISTS `hq_store_rule`;

CREATE TABLE `hq_store_rule`  (

  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,

  `store_id` smallint(5) NULL DEFAULT NULL,

  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `pid` int(11) NULL DEFAULT 0 COMMENT '上级',

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `status` tinyint(1) NOT NULL DEFAULT 1,

  `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `sort_order` int(5) NOT NULL DEFAULT 0 COMMENT '排序',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 222 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户 用户角色' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_store_rule

-- ----------------------------

INSERT INTO `hq_store_rule` VALUES (215, 177, '总经理', 0, '', 1, '1,198,199,182,183,184,185,186,187,193,201,203,209,188,189,190,191,194,195,196,197,200,210,211,212,213,214,2,3,6,7,8,4,9,10,11,109,110,111,112,5,12,13,14,15,16,17,18,164,165,192,204', 0, 1608815252, 1609307528, 0);

INSERT INTO `hq_store_rule` VALUES (216, 177, '副总', 0, '', 1, '1,198,199,182,183,184,185,186,203,188,189,190,191,194,195,196,197,200,210,211,212,213,214', 0, 1608879408, 1609145798, 0);

INSERT INTO `hq_store_rule` VALUES (217, 178, '总经理', 0, '', 1, '1,198,199,182,183,184,185,186,187,193,201,203,209,188,189,190,191,194,195,196,197,200,210,211,212,213,214,2,3,6,7,8,4,9,10,11,109,110,111,112,5,12,13,14,15,16,17,18,164,165,192,204', 0, 1609126544, 1609126544, 0);

INSERT INTO `hq_store_rule` VALUES (218, 178, '业务员', 0, '', 1, '1,198,199,182,183,184,185,186,187,193,201,203,209,188,189,190,191,194,195,196,197,200', 0, 1609141287, 1609141451, 0);

INSERT INTO `hq_store_rule` VALUES (219, 179, '总经理', 0, '', 1, '210,211,212,215,216,217,213,218,219,220,221,222,214', 0, 1620345486, 1620345486, 0);

INSERT INTO `hq_store_rule` VALUES (220, 180, '总经理', 0, '', 1, '210,211,212,215,216,217,213,218,219,220,221,222,214', 0, 1620370611, 1620370611, 0);

INSERT INTO `hq_store_rule` VALUES (221, 181, '总经理', 0, '', 1, '223,224', 0, 1620371243, 1620371243, 0);



-- ----------------------------

-- Table structure for hq_system

-- ----------------------------

DROP TABLE IF EXISTS `hq_system`;

CREATE TABLE `hq_system`  (

  `id` int(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置字段',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置名称',

  `jdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置参数',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_system

-- ----------------------------

INSERT INTO `hq_system` VALUES (1, 'website', '网站配置', '{\"logo\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200813\\/9f5c379e923352382fd0de260868d262.jpg\",\"sitename\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"title\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"keywords\":\"131232\",\"description\":\"42\",\"copyright\":\"\\u963f\\u6ce2\\u7f57\\u4e91\",\"beian\":\"\\u4eacICP\\u590718022286\\u53f7\"}');

INSERT INTO `hq_system` VALUES (2, 'qiniu', '七牛配置', '{\"model\":\"qiniu\",\"ak\":\"\",\"sk\":\"\",\"bucket\":\"\",\"domain\":\"\",\"type\":\"0\"}');

INSERT INTO `hq_system` VALUES (3, 'weixin', '公众号配置', '{\"model\":\"weixin\",\"appid\":\"\",\"appsecret\":\"\",\"token\":\"\",\"aes_key\":\"\",\"type\":\"0\"}');

INSERT INTO `hq_system` VALUES (4, 'wxapp', '小程序配置', '{\"model\":\"wxapp\",\"appid\":\"\",\"appsecret\":\"\",\"type\":\"0\"}');

INSERT INTO `hq_system` VALUES (5, 'wxpay', '微信支付配置', '{\"model\":\"wxpay\",\"appid\":\"\",\"mch_id\":\"\",\"key\":\"\",\"notify_url\":\"\",\"certpem\":\"\",\"keypem\":\"\",\"type\":\"0\"}');

INSERT INTO `hq_system` VALUES (6, 'qcloudsms', '腾讯云短信', '{\"model\":\"qcloudsms\",\"appid\":\"\",\"appkey\":\"\",\"type\":\"0\"}');

INSERT INTO `hq_system` VALUES (7, 'system', '参数配置', '{\"is_captcha\":\"0\"}');

INSERT INTO `hq_system` VALUES (10, 'upload_setting', '上传选项', NULL);



-- ----------------------------

-- Table structure for hq_taocan

-- ----------------------------

DROP TABLE IF EXISTS `hq_taocan`;

CREATE TABLE `hq_taocan`  (

  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,

  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',

  `status` tinyint(1) NOT NULL DEFAULT 1,

  `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '套餐' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_taocan

-- ----------------------------

INSERT INTO `hq_taocan` VALUES (5, '默认套餐', '', 1, '1,198,199,182,183,184,185,186,187,193,201,203,209,188,189,190,191,194,195,196,197,200,210,211,212,213,214,2,3,6,7,8,4,9,10,11,109,110,111,112,5,12,13,14,15,16,17,18,164,165,192,204', 1594197300, 1620370671, 0);

INSERT INTO `hq_taocan` VALUES (6, '微信互联套餐', '', 1, '210,211,212,215,216,217,213,218,219,220,221,222,214', 1620293999, 1620293999, 0);

INSERT INTO `hq_taocan` VALUES (7, '黄页管理套餐', '', 1, '223,224,13,14,15,16,17,18,164,165,192,204,227', 1620371197, 1620433168, 0);



-- ----------------------------

-- Table structure for hq_uploads

-- ----------------------------

DROP TABLE IF EXISTS `hq_uploads`;

CREATE TABLE `hq_uploads`  (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `store_id` int(5) NULL DEFAULT 0 COMMENT '商户ID',

  `user_id` int(5) UNSIGNED NULL DEFAULT 0 COMMENT '用户ID',

  `storage` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存储位置',

  `file_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存储域名',

  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',

  `file_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件大小',

  `mine` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `status` int(3) NULL DEFAULT 1 COMMENT '状态',

  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 230 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_uploads

-- ----------------------------

INSERT INTO `hq_uploads` VALUES (213, 0, 1, 'local', '', 'uploads/20210506\\ba042c602dd989a739e69d261c8c5808.jpg', '5932', 'image/jpeg', 1, 1620292077, 1620372967, 1620372967);

INSERT INTO `hq_uploads` VALUES (214, 0, 1, 'local', '', 'uploads/20210506\\1360ded681a8ff8cec41cdbcb9225f7e.jpg', '5932', 'image/jpeg', 1, 1620292094, 1620292244, 1620292244);

INSERT INTO `hq_uploads` VALUES (215, 0, 1, 'local', '', 'uploads/20210506\\0127231e8a24b9781afb0432745c4099.jpg', '5932', 'image/jpeg', 1, 1620292269, 1620372972, 1620372972);

INSERT INTO `hq_uploads` VALUES (216, 0, 1, 'local', '', 'uploads/20210506\\691b2b8ccd886131e62f578584968319.jpg', '5932', 'image/jpeg', 1, 1620292323, 1620372975, 1620372975);

INSERT INTO `hq_uploads` VALUES (217, 177, 294, 'local', '', 'uploads/store_177/20210506\\a5cbd6c7f47a918f08b6e063fad5bd57.jpg', '5932', 'image/jpeg', 1, 1620292874, 1620372979, 1620372979);

INSERT INTO `hq_uploads` VALUES (218, 0, 1, 'local', '', 'uploads/20210507\\66b1363250d7746b860f95579d215790.jpg', '5932', 'image/jpeg', 1, 1620371966, 1620371966, 0);

INSERT INTO `hq_uploads` VALUES (219, 0, 1, 'local', '', 'uploads/20210507\\4092736ab9b684290566759d2a567f2c.jpg', '5932', 'image/jpeg', 1, 1620371979, 1620371979, 0);

INSERT INTO `hq_uploads` VALUES (220, 181, 300, 'local', '', 'uploads/store_181/20210507\\a32ddd928a61ca06b6e4460255b56ffe.jpg', '5932', 'image/jpeg', 1, 1620389328, 1620389328, 0);

INSERT INTO `hq_uploads` VALUES (221, 181, 300, 'local', '', 'uploads/store_181/20210507\\aa8455229cbdd088c32bfc353790776b.jpg', '5932', 'image/jpeg', 1, 1620389789, 1620389789, 0);

INSERT INTO `hq_uploads` VALUES (222, 181, 300, 'local', '', 'uploads/store_181/20210508\\c8d9e0f85ebeefc0513e4c7a66cc8bd5.jpg', '5932', 'image/jpeg', 1, 1620434957, 1620434957, 0);

INSERT INTO `hq_uploads` VALUES (223, 181, 300, 'local', '', 'uploads/store_181/20210508\\399ff617d5a5062b5892107cdaa9b793.jpg', '5932', 'image/jpeg', 1, 1620437509, 1620437509, 0);

INSERT INTO `hq_uploads` VALUES (224, 181, 300, 'local', '', 'uploads/store_181/20210508\\8a3779e84012801dc2b1c80a9ee7308e.jpg', '5932', 'image/jpeg', 1, 1620438598, 1620438598, 0);

INSERT INTO `hq_uploads` VALUES (225, 181, 300, 'local', '', 'uploads/store_181/20210508\\090fef7571988f995a09647645070b73.jpg', '5932', 'image/jpeg', 1, 1620438783, 1620438783, 0);

INSERT INTO `hq_uploads` VALUES (226, 181, 300, 'local', '', 'uploads/store_181/20210508\\bf0192e984c7a37e478bb771ea7dffa7.jpg', '5932', 'image/jpeg', 1, 1620438875, 1620438875, 0);

INSERT INTO `hq_uploads` VALUES (227, 181, 300, 'local', '', 'uploads/store_181/20210508\\4f3b41f489bd8eefa827fc8ae70500ab.jpg', '5932', 'image/jpeg', 1, 1620439024, 1620439024, 0);

INSERT INTO `hq_uploads` VALUES (228, 181, 300, 'local', '', 'uploads/store_181/20210508\\8e676c0b09568502aa0857d5f5c5c5d8.jpg', '5932', 'image/jpeg', 1, 1620444681, 1620444681, 0);

INSERT INTO `hq_uploads` VALUES (229, 177, 294, 'local', '', 'uploads/store_177/20210508\\f7ce56337bd79a46ea23407057dc9cb7.jpg', '5932', 'image/jpeg', 1, 1620445748, 1620445748, 0);



-- ----------------------------

-- Table structure for hq_user

-- ----------------------------

DROP TABLE IF EXISTS `hq_user`;

CREATE TABLE `hq_user`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(8) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `mobile` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机',

  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `avatarurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',

  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0禁用/1启动',

  `openid` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小程序appid',

  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上次登录时间',

  `last_login_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',

  `login_count` int(11) NOT NULL DEFAULT 0 COMMENT '登录次数',

  `sort_order` smallint(5) NULL DEFAULT 0 COMMENT '排序',

  `group_id` int(3) NULL DEFAULT NULL COMMENT '所属部门',

  `rule_id` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色管理',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 301 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商户 用户表\r\n' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_user

-- ----------------------------

INSERT INTO `hq_user` VALUES (293, 177, '13459401111', 'e10adc3949ba59abbe56e057f20f883e', '黄青', NULL, 1, NULL, 1620379707, '127.0.0.1', 76, 0, 215, '216', 1608815252, 1620379707, 0);

INSERT INTO `hq_user` VALUES (294, 177, '13055556455', 'e10adc3949ba59abbe56e057f20f883e', '黄佳慧', NULL, 1, NULL, 1620445580, '127.0.0.1', 46, 0, 216, '215', 1608864778, 1620445580, 0);

INSERT INTO `hq_user` VALUES (298, 179, '14567890765', '0e774d072ad2e9c0052de3e72e7fe303', '1212', NULL, 1, NULL, 0, '', 0, 0, 225, '219', 1620345486, 1620345486, 0);

INSERT INTO `hq_user` VALUES (299, 180, '15910101010', 'e10adc3949ba59abbe56e057f20f883e', '测试', NULL, 1, NULL, 1620379954, '127.0.0.1', 3, 0, 226, '220', 1620370611, 1620379954, 0);

INSERT INTO `hq_user` VALUES (300, 181, '15910000000', 'e10adc3949ba59abbe56e057f20f883e', '黄页测试', NULL, 1, NULL, 1620438971, '127.0.0.1', 28, 0, 227, '221', 1620371243, 1620438971, 0);



-- ----------------------------

-- Table structure for hq_wechat

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat`;

CREATE TABLE `hq_wechat`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',

  `openid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'OPENID',

  `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',

  `gender` tinyint(5) NULL DEFAULT NULL COMMENT '性别',

  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市',

  `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',

  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家',

  `avatarurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',

  `unionid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'UNIONID',

  `status` tinyint(5) NOT NULL DEFAULT 1 COMMENT '状态 0禁用 1启用',

  `store_id` int(5) NOT NULL DEFAULT 0 COMMENT '默认商户 0无商户',

  `user_id` int(5) NOT NULL DEFAULT 0 COMMENT '绑定用户',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_menu

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_menu`;

CREATE TABLE `hq_wechat_menu`  (

  `id` int(5) NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(5) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `pid` smallint(5) NULL DEFAULT 0 COMMENT '按钮级别 0 button 1 sub_button',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单标题',

  `sub_button` smallint(2) NULL DEFAULT 0 COMMENT '菜单类型 0无子菜单 1有子菜单',

  `type` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单的响应动作类型，view表示网页类型，click表示点击类型，miniprogram表示小程序类型',

  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单Value',

  `key` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单KEY值',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网页 链接',

  `media_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '素材ID',

  `appid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序APPID',

  `pagepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序路径',

  `sort_order` smallint(3) NULL DEFAULT 0 COMMENT '排序',

  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_news

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_news`;

CREATE TABLE `hq_wechat_news`  (

  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(5) NULL DEFAULT NULL COMMENT '商户ID',

  `media_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'MEDIAID',

  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',

  `thumb_media_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图文消息的封面',

  `show_cover_pic` int(2) NULL DEFAULT NULL COMMENT '是否显示封面0不显示 1显示',

  `author` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',

  `digest` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '摘要',

  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '详情',

  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图文URL',

  `content_source_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阅读原文',

  `thumb_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图地址',

  `need_open_comment` int(5) NULL DEFAULT NULL,

  `only_fans_can_comment` int(5) NULL DEFAULT NULL,

  `sort_order` int(3) NULL DEFAULT 0 COMMENT '序列',

  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NOT NULL COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_reply

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_reply`;

CREATE TABLE `hq_wechat_reply`  (

  `id` int(5) NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(5) NULL DEFAULT NULL COMMENT '商户ID',

  `keyword` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',

  `type` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',

  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',

  `mediaid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'MediaId',

  `status` int(2) NULL DEFAULT 1 COMMENT '状态',

  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_template

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_template`;

CREATE TABLE `hq_wechat_template`  (

  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(5) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `template_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板ID',

  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板标题',

  `primary_industry` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板大类',

  `deputy_industry` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板小类',

  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板内容',

  `example` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板范例',

  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跳转URL',

  `appid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'APPID',

  `pagepath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跳转链接',

  `jdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发送数据',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_template_task

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_template_task`;

CREATE TABLE `hq_wechat_template_task`  (

  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `store_id` int(10) NOT NULL DEFAULT 0 COMMENT '商户ID',

  `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',

  `tid` int(10) NOT NULL DEFAULT 0 COMMENT '任务ID',

  `status` int(5) NOT NULL DEFAULT 0 COMMENT '状态 0待发 1已发',

  `error` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '错误提示',

  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信 模板消息任务表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hq_wechat_type

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_type`;

CREATE TABLE `hq_wechat_type`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hq_wechat_type

-- ----------------------------

INSERT INTO `hq_wechat_type` VALUES (1, '公众号');

INSERT INTO `hq_wechat_type` VALUES (2, '小程序');

INSERT INTO `hq_wechat_type` VALUES (3, 'H5');

INSERT INTO `hq_wechat_type` VALUES (4, '其他');



-- ----------------------------

-- Table structure for hq_wechat_user

-- ----------------------------

DROP TABLE IF EXISTS `hq_wechat_user`;

CREATE TABLE `hq_wechat_user`  (

  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `store_id` int(5) NULL DEFAULT 0 COMMENT '商户ID',

  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',

  `gender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '性别',

  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家',

  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',

  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',

  `avatarurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',

  `unionid` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'UNIONID',

  `openid` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'OPENID',

  `sort_order` smallint(5) NULL DEFAULT 0 COMMENT '排序',

  `language` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言',

  `subscribe` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '关注与否',

  `subscribe_time` int(10) NULL DEFAULT 0 COMMENT '关注时间',

  `subscribe_scene` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关注渠道',

  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',

  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',

  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',

  `is_getinfo` int(5) NOT NULL DEFAULT 0 COMMENT '是否获取信息 0否 1是',

  `error` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `id`(`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员' ROW_FORMAT = Dynamic;



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/dunzd/hqcrm.git
git@gitee.com:dunzd/hqcrm.git
dunzd
hqcrm
HQCRM最简易的客户管理系统
develop
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部