-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        8.0.12 - MySQL Community Server - GPL
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- 导出 erp 的数据库结构
CREATE DATABASE IF NOT EXISTS `erp` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `erp`;

-- 导出  表 erp.sys_menu 结构
CREATE TABLE IF NOT EXISTS `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) DEFAULT NULL COMMENT 'PID',
  `isMenu` int(11) DEFAULT NULL COMMENT '是否菜单',
  `title` varchar(150) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '标题',
  `icon` varchar(150) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '图标',
  `href` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '链接',
  `menuAuth` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT 'menuAuth',
  `target` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT '_self' COMMENT 'target',
  `checkArr` int(11) DEFAULT NULL COMMENT '是否数组',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `locked` int(11) DEFAULT '1' COMMENT '锁定',
  `disabled` int(11) DEFAULT '1' COMMENT '是否显示',
  `create_time` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC;

-- 正在导出表  erp.sys_menu 的数据：~40 rows (大约)
INSERT INTO `sys_menu` (`id`, `pid`, `isMenu`, `title`, `icon`, `href`, `menuAuth`, `target`, `checkArr`, `sort`, `locked`, `disabled`, `create_time`, `update_time`) VALUES
	(2, 0, 0, 'ERP管理系统', 'fa-home', '/ERP', '', '_self', 0, 1, 1, 1, NULL, '2023-05-26 10:55:14'),
	(3, 0, 0, 'MES制造系统', 'fa-home', '/MES', '', '_self', 0, 2, 1, 1, NULL, '2021-11-20 10:33:51'),
	(4, 0, 0, 'SYS基础设置', 'fa-home', '/SYS', '', '_self', 0, 3, 1, 1, NULL, '2023-05-26 00:51:02'),
	(5, 2, 0, '采购管理', 'fa-cart-plus', 'page/layui/PDtable.html', '', '_self', 0, 4, 1, 1, NULL, '2023-05-26 10:55:33'),
	(6, 2, 0, '销售管理', 'fa-jpy', '/url6', '', '_self', 0, 5, 1, 1, NULL, '2023-05-26 10:55:51'),
	(7, 2, 0, '存库管理', 'fa-adjust', '/page/404.html', '', '_self', 0, 6, 1, 1, NULL, '2023-05-26 10:55:53'),
	(8, 2, 0, '财务会计', 'fa-jpy', '', '', '_self', 0, 7, 1, 1, NULL, '2023-05-26 10:55:57'),
	(9, 2, 0, '人事管理', 'fa-users', '', '', '_self', 0, 8, 1, 1, NULL, '2023-05-26 10:55:58'),
	(10, 11, 0, '供应商资料', 'fa-angle-right', '', '', '_self', 0, 9, 1, 1, NULL, '2023-05-26 10:55:48'),
	(11, 5, 0, '采购计划表', 'fa-angle-right', '/url11', '', '_self', 0, 10, 1, 1, NULL, '2023-05-26 10:55:47'),
	(12, 5, 0, '采购申请单', 'fa-angle-right', '', '', '_self', 0, 11, 1, 1, NULL, '2023-05-26 10:55:48'),
	(13, 5, 0, '采购退货单', '', '', '', '_self', 0, 12, 1, 1, NULL, '2023-05-26 10:55:49'),
	(14, 14, 0, '客户资料', 'fa-angle-right', '', '', '_self', 0, 13, 0, 1, NULL, '2021-11-29 22:36:05'),
	(15, 6, 0, '客户订单', 'fa-address-book-o', '', '', '_self', 0, 14, 1, 1, NULL, '2023-05-26 10:55:52'),
	(16, 7, 0, '库存查询', 'fa-amazon', '', '', '_self', 0, 15, 1, 1, NULL, '2023-05-26 10:55:54'),
	(17, 7, 0, '库存入库', 'fa-address-book-o', '', '', '_self', 0, 16, 1, 1, NULL, '2023-05-26 10:55:55'),
	(18, 7, 0, '库存出库', 'fa-caret-right', '', '', '_self', 0, 17, 1, 1, NULL, '2023-05-26 10:55:55'),
	(19, 7, 0, '库存盘点', '', '', '', '_self', 0, 18, 1, 1, NULL, '2023-05-26 10:55:56'),
	(20, 2, 0, '报表分析', 'fa-pie-chart', '', '', '_self', 0, 19, 1, 1, NULL, '2021-11-30 20:06:13'),
	(21, 20, 0, '采购报表', NULL, '', '', '_self', 0, 20, 1, 1, NULL, '2021-12-13 17:54:34'),
	(22, 20, 0, '销售报表', NULL, '', '', '_self', 0, 21, 1, 1, NULL, '2021-12-13 17:54:36'),
	(23, 20, 0, '仓库报表', NULL, '', '', '_self', 0, 22, 1, 1, NULL, '2021-12-13 17:54:37'),
	(24, 20, 0, '财务报表', NULL, '', '', '_self', 0, 23, 1, 1, NULL, '2021-12-13 17:54:38'),
	(25, 20, 0, '人事报表', NULL, '', '', '_self', 0, 24, 1, 1, NULL, '2021-12-13 17:54:39'),
	(26, 3, 0, '生产工单', 'fa-desktop', '', '', '_self', 0, 25, 1, 1, NULL, '2021-11-30 19:08:21'),
	(27, 3, 0, '人员管理', 'fa-user', 'page/table.html', '', '_self', 0, 26, 1, 1, NULL, '2023-05-26 10:56:00'),
	(28, 3, 0, '设备管理', 'fa-cog', '', '', '_self', 0, 27, 1, 1, NULL, '2023-05-26 10:56:01'),
	(29, 3, 0, '工艺研发', 'fa-clipboard', '', '', '_self', 0, 28, 1, 1, NULL, '2023-05-26 10:56:02'),
	(30, 3, 0, '质量管控', 'fa-warning', '', '', '_self', 0, 29, 1, 1, NULL, '2023-05-26 10:56:03'),
	(31, 4, 0, '网站设置', 'fa-cogs', 'page/webSetting.html', '', '_self', 0, 30, 1, 1, NULL, '2023-05-26 10:56:04'),
	(32, 4, 0, '菜单管理', 'fa-align-justify', 'dpage/table.php?table=sys_table&tb_name=sys_menu', '', '_self', 0, 31, 1, 1, NULL, '2021-11-30 19:44:58'),
	(34, 4, 0, '角色权限', 'fa-user', 'dpage/table.php?table=sys_table&tb_name=sys_role', '', '_self', 0, 33, 1, 1, NULL, '2021-12-02 20:01:27'),
	(35, 4, 0, '用户管理', 'fa-group', 'dpage/table.php?table=sys_table&tb_name=sys_user', '', '_self', 0, 34, 1, 1, NULL, '2021-12-08 20:26:39'),
	(36, 4, 0, '操作日志', 'fa-calendar', '/url36', '', '_self', 0, 35, 1, 1, NULL, '2021-12-13 17:52:34'),
	(37, 4, 0, '数据库备份', 'fa-database', '/url37', '', '_self', 0, 36, 1, 1, NULL, '2021-12-13 17:52:46'),
	(38, 5, 1, '查询', 'fa-angle-right', '', '/Pd/Retrieve', '_self', 0, NULL, 1, 1, NULL, '2023-05-26 10:55:46'),
	(39, 5, 1, '添加', 'fa-angle-right', '', '/Pd/Create', '_self', 0, NULL, 1, 1, NULL, '2023-05-26 10:55:45'),
	(40, 5, 1, '修改', 'fa-angle-right', '', '/Pd/Update', '_self', 0, NULL, 1, 1, NULL, '2023-05-26 10:55:44'),
	(41, 5, 1, '删除', 'fa-angle-right', '', '/Pd/Delete', '_self', 0, NULL, 1, 1, NULL, '2023-05-26 10:55:42'),
	(46, 4, 0, '表头管理', 'fa-user', 'dpage/table.php?table=sys_table&tb_name=sys_table', NULL, '_self', 0, 32, 1, 1, NULL, NULL);

-- 导出  表 erp.sys_role 结构
CREATE TABLE IF NOT EXISTS `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `role_name` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '角色名',
  `role_code` varchar(150) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '角色代号',
  `role_remark` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '角色备注',
  `role_menu` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '角色权限',
  `disabled` int(11) DEFAULT '1' COMMENT '是否显示',
  `create_time` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;

-- 正在导出表  erp.sys_role 的数据：~4 rows (大约)
INSERT INTO `sys_role` (`id`, `role_name`, `role_code`, `role_remark`, `role_menu`, `disabled`, `create_time`) VALUES
	(1, '管理员', 'admin', '全部权限', '2,5,41,40,39,38,11,10,12,13,6,15,7,16,17,18,19,20,21,22,23,24,25,3,26,27,28,29,30,4,31,32,34,35,36,37,46', 1, '2023-05-26 00:20:59'),
	(2, '普通用户', 'user', '默认权限', '2,5,11,10,12,13,4,31,32,34,35,36,37', 1, '2021-12-13 16:39:57'),
	(3, '游客', 'guest', '游客权限', '2,5', 1, '2021-12-07 22:15:00'),
	(6, '采购员', 'caiou', '采购权限', '2,6,9,4,12', 1, NULL);

-- 导出  表 erp.sys_table 结构
CREATE TABLE IF NOT EXISTS `sys_table` (
  `id` varchar(128) CHARACTER SET utf8 COLLATE utf8_tolower_ci DEFAULT NULL,
  `sort1` int(10) unsigned NOT NULL,
  `tb_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_tolower_ci DEFAULT NULL,
  `field` varchar(64) CHARACTER SET utf8 COLLATE utf8_tolower_ci DEFAULT NULL,
  `width` bigint(21) DEFAULT NULL,
  `title` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `sort` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `templet` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `isvsible` int(1) NOT NULL DEFAULT '0',
  `style` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 正在导出表  erp.sys_table 的数据：54 rows
/*!40000 ALTER TABLE `sys_table` DISABLE KEYS */;
INSERT INTO `sys_table` (`id`, `sort1`, `tb_name`, `field`, `width`, `title`, `sort`, `templet`, `isvsible`, `style`) VALUES
	('sys_menucheckArr', 9, 'sys_menu', 'checkArr', 80, '是否数组', 'true', '', 0, ''),
	('sys_menucreate_time', 13, 'sys_menu', 'create_time', 200, '创建时间', 'true', '', 0, ''),
	('sys_menudisabled', 12, 'sys_menu', 'disabled', 80, '是否显示', 'true', '', 0, ''),
	('sys_menuhref', 6, 'sys_menu', 'href', 200, '链接', 'true', '', 1, ''),
	('sys_menuicon', 5, 'sys_menu', 'icon', 150, '图标', 'true', '', 1, ''),
	('sys_menuid', 1, 'sys_menu', 'id', 80, 'ID', 'true', '', 1, ''),
	('sys_menuisMenu', 3, 'sys_menu', 'isMenu', 80, '是否菜单', 'true', '', 0, ''),
	('sys_menulocked', 11, 'sys_menu', 'locked', 80, '锁定', 'true', '', 0, ''),
	('sys_menumenuAuth', 7, 'sys_menu', 'menuAuth', 100, 'menuAuth', 'true', '', 0, ''),
	('sys_menupid', 2, 'sys_menu', 'pid', 80, 'PID', 'true', '', 1, ''),
	('sys_menusort', 10, 'sys_menu', 'sort', 80, '排序', 'true', '', 0, ''),
	('sys_menutarget', 8, 'sys_menu', 'target', 100, 'target', 'true', '', 0, ''),
	('sys_menutitle', 4, 'sys_menu', 'title', 150, '标题', 'true', '', 1, ''),
	('sys_menuupdate_time', 14, 'sys_menu', 'update_time', 200, '更新时间', 'true', '', 0, ''),
	('sys_rolecreate_time', 7, 'sys_role', 'create_time', 200, '创建时间', 'true', '', 0, ''),
	('sys_roledisabled', 6, 'sys_role', 'disabled', 80, '是否显示', 'true', '', 0, ''),
	('sys_roleid', 1, 'sys_role', 'id', 80, 'ID', 'true', '', 1, ''),
	('sys_rolerole_code', 3, 'sys_role', 'role_code', 150, '角色代号', 'true', '', 1, ''),
	('sys_rolerole_menu', 5, 'sys_role', 'role_menu', 200, '角色权限', 'true', '', 1, ''),
	('sys_rolerole_name', 2, 'sys_role', 'role_name', 100, '角色名', 'true', '', 1, ''),
	('sys_rolerole_remark', 4, 'sys_role', 'role_remark', 100, '角色备注', 'true', '', 1, ''),
	('sys_tablefield', 4, 'sys_table', 'field', 100, '字段名', 'true', '', 1, ''),
	('sys_tableid', 1, 'sys_table', 'id', 150, 'ID', 'true', '', 1, ''),
	('sys_tableisvsible', 9, 'sys_table', 'isvsible', 80, '是否显示', 'true', '', 1, ''),
	('sys_tablesort', 7, 'sys_table', 'sort', 80, '排序', 'false', '', 0, ''),
	('sys_tablesort1', 2, 'sys_table', 'sort1', 100, '排序1', 'true', '', 1, ''),
	('sys_tablestyle', 10, 'sys_table', 'style', 200, '样式', 'true', '', 1, ''),
	('sys_tabletb_name', 3, 'sys_table', 'tb_name', 120, '表名', 'true', '', 1, ''),
	('sys_tabletemplet', 8, 'sys_table', 'templet', 200, '自定义样式', 'true', '', 1, ''),
	('sys_tabletitle', 6, 'sys_table', 'title', 200, '标题', 'true', '', 1, ''),
	('sys_tablewidth', 5, 'sys_table', 'width', 80, '宽度', 'true', '', 1, ''),
	('sys_usercreate_time', 9, 'sys_user', 'create_time', 150, '创建时间', 'true', '', 0, ''),
	('sys_userdisabled', 8, 'sys_user', 'disabled', 80, '是否显示', 'true', '', 0, ''),
	('sys_useremail', 12, 'sys_user', 'email', 100, '邮箱', 'true', '', 1, ''),
	('sys_userid', 1, 'sys_user', 'id', 80, 'ID', 'true', '', 1, ''),
	('sys_userlocked', 7, 'sys_user', 'locked', 80, '是否锁定', 'true', '', 0, ''),
	('sys_usernick_name', 4, 'sys_user', 'nick_name', 100, '昵称', 'true', '', 1, ''),
	('sys_userphone', 11, 'sys_user', 'phone', 100, '电话', 'true', '', 1, ''),
	('sys_userpw', 3, 'sys_user', 'pw', 100, '密码', 'true', '', 1, ''),
	('sys_userremark', 13, 'sys_user', 'remark', 200, '备注', 'true', '', 1, ''),
	('sys_userrole', 6, 'sys_user', 'role', 80, '权限', 'true', '', 1, ''),
	('sys_usersex', 5, 'sys_user', 'sex', 80, '性别', 'true', '', 1, ''),
	('sys_userupdate_time', 10, 'sys_user', 'update_time', 150, '更新时间', 'true', '', 0, ''),
	('sys_userusername', 2, 'sys_user', 'username', 100, '用户名', 'true', '', 1, ''),
	('tbinfofield', 4, 'tbinfo', 'field', 64, '', 'true', '', 1, ''),
	('tbinfoid', 1, 'tbinfo', 'id', 128, '', 'true', '', 1, ''),
	('tbinfoisvsible', 9, 'tbinfo', 'isvsible', 80, '', 'true', '', 1, ''),
	('tbinfosort', 7, 'tbinfo', 'sort', 4, '', 'true', '', 1, ''),
	('tbinfosort1', 2, 'tbinfo', 'sort1', 80, '', 'true', '', 1, ''),
	('tbinfostyle', 10, 'tbinfo', 'style', 6, '', 'true', '', 1, ''),
	('tbinfotb_name', 3, 'tbinfo', 'tb_name', 64, '', 'true', '', 1, ''),
	('tbinfotemplet', 8, 'tbinfo', 'templet', 6, '', 'true', '', 1, ''),
	('tbinfotitle', 6, 'tbinfo', 'title', 200, '', 'true', '', 1, ''),
	('tbinfowidth', 5, 'tbinfo', 'width', 80, '', 'true', '', 1, '');
/*!40000 ALTER TABLE `sys_table` ENABLE KEYS */;

-- 导出  表 erp.sys_user 结构
CREATE TABLE IF NOT EXISTS `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '用户名',
  `pw` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '密码',
  `nick_name` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '昵称',
  `sex` varchar(80) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT '' COMMENT '性别',
  `role` int(11) DEFAULT '3' COMMENT '权限',
  `locked` int(11) DEFAULT '0' COMMENT '是否锁定',
  `disabled` int(11) DEFAULT '0' COMMENT '是否显示',
  `create_time` varchar(150) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(150) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '更新时间',
  `phone` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '电话',
  `email` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '邮箱',
  `remark` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;

-- 正在导出表  erp.sys_user 的数据：~3 rows (大约)
INSERT INTO `sys_user` (`id`, `username`, `pw`, `nick_name`, `sex`, `role`, `locked`, `disabled`, `create_time`, `update_time`, `phone`, `email`, `remark`) VALUES
	(1, 'admin', '123456', '超级管理员', '男', 1, 1, 1, '2021-10-01 19:49:56', '2023-11-27 14:43:38', '135026541', '550329175@qq.com', '我是一个狠人'),
	(2, 'test', '123456', '测试员', '女', 2, 1, 1, '2021-12-09 23:29:38', '2023-11-27 11:36:45', '1366666', '3654@163.com', 'dddd'),
	(6, 'xw', '123456', '肖文', '男', 1, 0, 0, '2023-11-27 12:18:33', '2023-11-27 14:49:12', '17620010557', '550329175@qq.com', '老板');

-- 导出  视图 erp.tbinfo 结构
-- 创建临时表以解决视图依赖性错误
CREATE TABLE `tbinfo` (
	`id` VARCHAR(128) NULL COLLATE 'utf8_tolower_ci',
	`sort1` INT(10) UNSIGNED NOT NULL,
	`tb_name` VARCHAR(64) NULL COLLATE 'utf8_tolower_ci',
	`field` VARCHAR(64) NULL COLLATE 'utf8_tolower_ci',
	`width` BIGINT(21) NULL,
	`title` TEXT NOT NULL COLLATE 'utf8_bin',
	`sort` VARCHAR(4) NOT NULL COLLATE 'utf8mb4_general_ci',
	`templet` VARCHAR(6) NOT NULL COLLATE 'utf8mb4_general_ci',
	`isvsible` INT(1) NOT NULL,
	`style` VARCHAR(6) NOT NULL COLLATE 'utf8mb4_general_ci'
) ENGINE=MyISAM;

-- 移除临时表并创建最终视图结构
DROP TABLE IF EXISTS `tbinfo`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `tbinfo` AS select concat(`a`.`TABLE_NAME`,`a`.`COLUMN_NAME`) AS `id`,`a`.`ORDINAL_POSITION` AS `sort1`,`a`.`TABLE_NAME` AS `tb_name`,`a`.`COLUMN_NAME` AS `field`,if(isnull(`a`.`CHARACTER_MAXIMUM_LENGTH`),80,if((`a`.`CHARACTER_MAXIMUM_LENGTH` > 200),200,`a`.`CHARACTER_MAXIMUM_LENGTH`)) AS `width`,`a`.`COLUMN_COMMENT` AS `title`,'true' AS `sort`,'      ' AS `templet`,1 AS `isvsible`,'      ' AS `style` from `information_schema`.`COLUMNS` `a` where (`a`.`TABLE_SCHEMA` = 'erp') order by `a`.`ORDINAL_POSITION`;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;