--
-- Host: localhost    Database: bui
-- ------------------------------------------------------


--
-- Table structure for table `admin_customers`
--

CREATE TABLE `admin_customers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  `tel` varchar(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_customers`
--

INSERT INTO `admin_customers` VALUES (1,'卡莱威盾','阿斯顿发生','15082910657','2019-11-29 01:02:17','2019-12-09 08:04:39'),(2,'燕姿','阿斯蒂芬啊','18945676548','2019-11-29 09:28:07','2019-12-20 07:47:19');

--
-- Table structure for table `admin_menus`
--

CREATE TABLE `admin_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级ID',
  `order` int(11) NOT NULL DEFAULT '0' COMMENT '菜单排序',
  `type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `uri` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URI',
  `routes` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路由,如url:/menu,controller:MenuController',
  `perm_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限标识',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_menus`
--

INSERT INTO `admin_menus` VALUES (1,0,1,'PC','首页','index','url:index',NULL,'2019-11-14 06:23:22','2019-11-15 05:58:58'),(2,0,2,'PC','系统设置','system','url:system',NULL,'2019-11-14 06:24:00','2019-11-19 08:33:31'),(3,1,1,'PC','配补货','#','url:#',NULL,'2019-11-14 06:26:44','2019-12-06 01:34:51'),(4,1,2,'PC','报表','#','url:#',NULL,'2019-11-14 06:27:10','2019-11-26 02:03:55'),(5,2,1,'PC','权限设置','#','url:#',NULL,'2019-11-14 06:27:50','2019-11-19 09:19:32'),(6,3,1,'PC','直营配补货','pbh','url:pbh','pbhlist','2019-11-14 09:16:44','2019-12-06 01:34:39'),(7,3,2,'PC','经销配补货','kspbh','url:kspbh','kspbhlist','2019-11-14 09:24:44','2019-11-30 09:07:44'),(8,3,3,'PC','日常调货','rcdh','url:rcdh','rcdhlist','2019-11-14 09:25:03','2019-11-30 09:08:57'),(9,5,1,'PC','用户管理','users','url:users','userlist','2019-11-14 09:29:42','2019-11-19 08:28:31'),(10,5,2,'PC','角色管理','roles','url:roles','rolelist','2019-11-14 09:30:10','2019-11-19 08:28:43'),(11,5,3,'PC','权限管理','permissions','url:permissions','perlist','2019-11-14 09:30:46','2019-11-19 09:22:51'),(12,5,4,'PC','菜单管理','menus','url:menus','menulist','2019-11-14 09:31:08','2019-11-19 09:20:51'),(16,4,1,'PC','新品动销汇总','xpdxhz','url:xpdxhz','xpdxhzlist','2019-11-15 06:00:20','2019-11-20 02:19:14'),(17,4,2,'PC','新品销售汇总','xpxshz','url:xpxshz','xpxshzlist','2019-11-15 06:00:37','2019-11-19 08:28:03'),(18,4,3,'PC','店铺销售数据分析','dpxstjfx','url:dpxstjfx','dpxstjfxlist','2019-11-21 03:20:40','2019-11-26 01:39:43'),(19,4,4,'PC','店铺销售库存分析','dpxskcfx','url:dpxskcfx','dpxskcfxlist','2019-11-26 02:04:43','2019-11-26 02:04:43'),(20,4,5,'PC','店铺销售环比分析','dpxshbfx','url:dpxshbfx','dpxshbfxlist','2019-11-26 03:23:19','2019-11-26 03:23:19'),(21,4,6,'PC','店铺各季节销售占比','dpjjxszb','url:dpjjxszb','dpjjxszblist','2019-11-26 07:03:23','2019-11-26 07:04:34'),(22,4,7,'PC','店铺各季节库存占比','dpjjkczb','url:dpjjkczb','dpjjkczblist','2019-11-26 07:04:17','2019-11-26 07:04:17'),(23,0,3,'MOBILE','手机','mobile','url:mobile',NULL,'2019-11-28 07:04:49','2019-11-28 07:04:49'),(24,2,2,'PC','客户设置','#','url:#',NULL,'2019-11-28 07:22:21','2019-12-09 06:54:07'),(25,24,1,'PC','客户信息','customers','url:customers','customlist','2019-11-28 07:27:07','2019-12-09 06:54:12'),(28,23,2,'MOBILE','库存','stock','url:stock',NULL,'2019-12-03 02:47:40','2019-12-03 02:47:40'),(29,28,1,'MOBILE','库存汇总','spkcbb','url:spkcbb',NULL,'2019-12-03 02:48:10','2019-12-09 10:19:29'),(30,23,1,'MOBILE','会员','member','url:member',NULL,'2019-12-09 10:22:58','2019-12-09 10:23:38'),(31,30,1,'MOBILE','会员消费','hyxfbb','url:hyxfbb',NULL,'2019-12-09 10:24:23','2019-12-09 10:24:23'),(32,3,5,'PC','丽宣配补货','lxpbh','url:lxpbh','lxpbhlist','2019-12-16 03:24:12','2019-12-19 09:21:18'),(33,3,4,'PC','丽宣日常调货','lxrcdh','url:lxrcdh','lxrcdhlist','2019-12-24 06:53:35','2019-12-24 07:11:12'),(34,3,6,'PC','终端叫货','zdjh','url:zdjh',NULL,'2020-01-10 08:42:20','2020-01-10 08:42:20'),(35,4,0,'PC','周期不动销产品','zqbdx','url:zqbdx',NULL,'2020-01-16 02:44:44','2020-01-16 02:44:44');

--
-- Table structure for table `admin_permission_menu`
--

CREATE TABLE `admin_permission_menu` (
  `permission_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  KEY `permission_menu_permission_id_menu_id_index` (`permission_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_permission_menu`
--


--
-- Table structure for table `admin_permission_role`
--

CREATE TABLE `admin_permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_permission_role`
--

INSERT INTO `admin_permission_role` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(9,2),(10,2),(20,2),(21,2);

--
-- Table structure for table `admin_permissions`
--

CREATE TABLE `admin_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限名 英文',
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示名 中文',
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `controllers` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对应的controllers',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_permissions`
--

INSERT INTO `admin_permissions` VALUES (1,'userlist','用户管理查看','用户管理查看','UserController@get','2019-11-14 03:34:50','2019-11-18 08:53:48'),(2,'userhandle','用户管理编辑','用户管理编辑','UserController@post','2019-11-14 03:34:50','2019-11-15 08:14:51'),(3,'rolelist','角色管理查看','角色管理查看','RoleController@get','2019-11-14 03:34:50','2019-11-14 03:34:50'),(4,'rolehandle','角色管理编辑','角色管理编辑','RoleController@post','2019-11-14 03:34:50','2019-11-14 03:34:50'),(5,'perlist','权限管理查看','权限管理查看','PermissionController@get','2019-11-14 03:34:50','2019-11-14 03:34:50'),(6,'perhandle','权限管理编辑','权限管理编辑','PermissionController@post','2019-11-14 03:34:50','2019-11-14 03:34:50'),(7,'menulist','菜单管理查看','菜单管理查看','MenuController@get','2019-11-14 03:34:50','2019-11-18 10:05:46'),(8,'menuhandle','菜单管理编辑','菜单管理编辑','MenuController@post','2019-11-14 03:34:50','2019-11-14 03:34:50'),(9,'pbhlist','直营配补货查看','直营配补货查看','PbhController@get','2019-11-14 03:34:50','2019-11-14 03:37:53'),(10,'pbhhandle','直营配补货编辑','直营配补货编辑','PbhController@post','2019-11-14 03:38:53','2019-11-14 03:38:53'),(11,'kspbhlist','经销配补货查看','经销配补货查看','KspbhController@get','2019-11-14 03:40:12','2019-11-14 03:40:12'),(12,'Kspbhhandle','经销配补货编辑','经销配补货编辑','KspbhController@post','2019-11-14 03:41:16','2019-11-14 03:41:16'),(13,'rcdhlist','日常调货查看','日常调货查看','RcdhController@get','2019-11-14 03:41:48','2019-11-14 03:41:48'),(14,'rcdhhandle','日查调货编辑','日常调货编辑','RcdhController@post','2019-11-14 03:42:16','2019-11-14 03:42:16'),(15,'xpdxhzlist','新品动销汇总查看','新品动销汇总查看','XpdxhzController@get','2019-11-14 03:43:14','2019-11-14 03:43:14'),(16,'xpdxhzhandle','新品动销汇总编辑','新品动销汇总编辑','XpdxhzController@post','2019-11-14 03:43:55','2019-11-14 03:43:55'),(17,'xpxshzlist','新品销售汇总查看','新品销售汇总查看','XpxshzController@get','2019-11-14 03:44:54','2019-11-14 03:44:54'),(18,'xpxshzhandle','新品销售汇总编辑','新品销售汇总编辑','XpxshzController@post','2019-11-14 03:45:37','2019-11-14 03:45:37'),(19,'selecthandle','筛选条件','仓库选择，商品选择，门店选择','SelectController@post','2019-11-19 05:57:20','2019-11-19 05:57:20'),(20,'userinfolist','用户信息查看','用户信息查看','UserController@userInfo','2019-11-20 02:32:15','2019-11-20 02:32:15'),(21,'saveinfohandle','用户信息编辑','用户信息编辑','UserController@saveInfo','2019-11-20 02:33:08','2019-11-20 02:33:08'),(22,'dpxstjfxlist','店铺销售统计分析查看','店铺销售统计分析查看','DpxstjfxController@get','2019-11-21 03:18:56','2019-11-21 03:18:56'),(23,'dpxstjfxhandle','店铺销售统计分析编辑','店铺销售统计分析编辑','DpxstjfxController@post','2019-11-21 03:19:50','2019-11-21 03:19:50'),(24,'dpxskcfxlist','店铺销售库存分析查看','店铺销售库存分析及预算天数查看','DpxskcfxController@get','2019-11-26 01:59:57','2019-11-26 02:01:38'),(25,'dpxskcfxhandle','店铺销售库存分析编辑','店铺销售库存分析及预算天数编辑','DpxskcfxController@post','2019-11-26 02:01:03','2019-11-26 02:01:03'),(26,'dpxshbfxlist','店铺销售环比分析查看','店铺销售环比分析查看','DpxshbfxController@get','2019-11-26 03:22:15','2019-11-26 03:22:15'),(27,'dpxshbfxhandle','店铺销售环比分析编辑','店铺销售环比分析编辑','DpxshbfxController@post','2019-11-26 03:22:50','2019-11-26 03:22:50'),(28,'dpjjkczblist','店铺各季节库存占比查看','店铺各季节库存占比查看','DpjjkczbController@get','2019-11-26 06:58:11','2019-11-26 06:58:11'),(29,'dpjjkczbhandle','店铺各季节库存占比编辑','店铺各季节库存占比编辑','DpjjkczbController@post','2019-11-26 06:58:45','2019-11-26 06:58:45'),(30,'dpjjxszblist','店铺各季节销售占比查看','店铺各季节销售占比查看','DpjjxszbController@get','2019-11-26 07:00:22','2019-11-26 07:00:22'),(31,'dpjjxszbhandle','店铺各季节销售占比编辑','店铺各季节销售占比编辑','DpjjxszbController@post','2019-11-26 07:01:47','2019-11-26 07:01:47'),(32,'customlist','客户信息查看','客户信息查看','CustomerController@get','2019-11-28 08:05:03','2019-11-28 08:05:03'),(33,'customhandle','客户信息编辑','客户信息编辑','CustomerController@post','2019-11-28 08:05:34','2019-11-28 08:05:34'),(34,'lxpbhlist','丽宣配补货查看','丽宣配补货查看','LxpbhController@get','2019-12-16 03:26:52','2019-12-16 03:26:52'),(35,'lxpbhhandel','丽宣配补货编辑','丽宣配补货编辑','LxpbhController@post','2019-12-16 03:27:57','2019-12-16 03:27:57'),(36,'dblist','客户数据库配置查看','客户数据库配置查看','DatabaseController@get','2019-12-19 09:30:25','2019-12-19 09:30:25'),(37,'dbhandle','客户数据库配置编辑','客户数据库配置编辑','DatabaseController@post','2019-12-19 09:31:05','2019-12-19 09:31:05'),(38,'lxrcdhlist','丽宣日常调货查看','丽宣日常调货查看','LxrcdhController@get','2019-12-24 07:09:02','2019-12-24 07:09:02'),(39,'lxrcdhhandle','丽宣日常调货编辑','丽宣日常调货编辑','LxrcdhController@post','2019-12-24 07:10:55','2019-12-24 07:10:55');

--
-- Table structure for table `admin_role_menu`
--

CREATE TABLE `admin_role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  KEY `role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_role_menu`
--

INSERT INTO `admin_role_menu` VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,15),(1,16),(1,17),(1,18),(1,19),(1,20),(1,21),(1,22),(1,23),(1,24),(1,25),(1,28),(1,29),(1,30),(1,31),(1,32),(1,33),(1,34),(1,35),(2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9),(2,11),(2,12),(2,16),(2,17),(2,18),(2,19),(2,20),(2,21),(2,22),(2,24),(2,25),(2,34),(2,35);

--
-- Table structure for table `admin_role_user`
--

CREATE TABLE `admin_role_user` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_role_user`
--

INSERT INTO `admin_role_user` VALUES (1,1),(2,1),(2,2),(3,2),(4,2),(5,2),(7,2),(8,2),(10,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(45,2),(46,2),(47,2),(48,2),(49,2),(50,2),(51,2),(52,2),(53,2),(54,2),(55,2),(56,2),(57,2),(58,2),(59,2),(60,2),(61,2),(62,2),(63,2),(64,2),(65,2),(66,2),(67,2),(68,2),(69,2),(70,2);

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名',
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示名',
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_roles`
--

INSERT INTO `admin_roles` VALUES (1,'admin','超级管理员','最高级的权限','2019-11-14 03:34:50','2019-11-14 03:34:50'),(2,'mduser','门店用户','只能进行查看','2019-11-14 06:00:11','2019-12-19 09:32:59');

--
-- Table structure for table `admin_users_cangku`
--

CREATE TABLE `admin_users_cangku` (
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `CKDM` varchar(50) DEFAULT NULL COMMENT '仓库代码',
  `CKMC` varchar(50) DEFAULT NULL COMMENT '仓库名称',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_cangku`
--

INSERT INTO `admin_users_cangku` VALUES (3,'Z002','Z002','2019-12-02 11:38:28'),(3,'Z003','Z003','2019-12-02 11:38:28'),(1,'301061','301061店铺','2019-12-05 08:59:45');

--
-- Table structure for table `admin_users_gonghuoshang`
--

CREATE TABLE `admin_users_gonghuoshang` (
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `GHSDM` varchar(50) DEFAULT NULL COMMENT '供货商代码',
  `GHSMC` varchar(50) DEFAULT NULL COMMENT '供货商名称',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_gonghuoshang`
--

INSERT INTO `admin_users_gonghuoshang` VALUES (3,'999','成本调差供货商','2019-12-02 11:36:03'),(3,'ZB_999','总部供货商','2019-12-02 11:36:03'),(1,'999','成本调差供货商','2019-12-05 09:00:17'),(1,'ZB_999','总部供货商','2019-12-05 09:00:17'),(1,'W4159','月亮人','2019-12-05 09:00:17'),(1,'W4158','新丝路女裤','2019-12-05 09:00:17'),(1,'W4161','缔梵茜','2019-12-05 09:00:17');

--
-- Table structure for table `admin_users_kehu`
--

CREATE TABLE `admin_users_kehu` (
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `KHDM` varchar(50) DEFAULT NULL COMMENT '客户代码',
  `KHMC` varchar(50) DEFAULT NULL COMMENT '客户名称',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_kehu`
--

INSERT INTO `admin_users_kehu` VALUES (3,'Z001','Z001','2019-12-02 11:07:23'),(3,'Z002','Z002','2019-12-02 11:07:23'),(1,'301088','301088店铺','2019-12-05 08:37:05');

--
-- Table structure for table `admin_users_log`
--

CREATE TABLE `admin_users_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `operation_name` varchar(50) DEFAULT NULL COMMENT '操作名',
  `operator` varchar(255) DEFAULT NULL COMMENT '操作人',
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_log`
--

INSERT INTO `admin_users_log` VALUES (1,1,'品牌管理操作成功','系统管理员','2019-12-05 08:20:28'),(2,3,'品牌管理操作成功','系统管理员','2019-12-05 08:20:41'),(3,1,'客户管理操作成功','系统管理员','2019-12-05 08:37:05'),(4,1,'供货商管理操作成功','匡自强','2019-12-05 08:38:50'),(5,3,'品牌管理操作成功','匡自强','2019-12-05 08:39:12'),(6,1,'仓库管理操作成功','系统管理员','2019-12-05 08:59:45'),(7,1,'供货商管理操作成功','系统管理员','2019-12-05 09:00:17'),(8,3,'品牌管理操作成功','系统管理员','2019-12-06 01:25:55'),(9,3,'品牌管理操作成功','系统管理员','2019-12-16 02:31:51');

--
-- Table structure for table `admin_users_pinpai`
--

CREATE TABLE `admin_users_pinpai` (
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `PPDM` varchar(50) DEFAULT NULL COMMENT '品牌代码',
  `PPMC` varchar(50) DEFAULT NULL COMMENT '品牌名称',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_pinpai`
--

INSERT INTO `admin_users_pinpai` VALUES (1,'唯姿轩特卖','T0001','2019-12-05 08:20:28'),(3,'000','未定义','2019-12-16 02:31:50'),(3,'娅丽达','001','2019-12-16 02:31:50');

--
-- Table structure for table `admin_users_quyu`
--

CREATE TABLE `admin_users_quyu` (
  `pid` int(11) DEFAULT NULL COMMENT '用户id',
  `QYDM` varchar(50) DEFAULT NULL COMMENT '区域代码',
  `QYMC` varchar(50) DEFAULT NULL COMMENT '区域名称',
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_users_quyu`
--

INSERT INTO `admin_users_quyu` VALUES (1,'001','1区','2019-12-02 10:49:00'),(1,'002','2区','2019-12-02 10:49:00');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (28,'2014_10_12_000000_create_admin_users_table',1),(29,'2014_10_12_100000_create_password_resets_table',1),(30,'2017_07_04_104719_create_admin_roles_table',1),(31,'2017_07_04_104933_create_admin_menus_table',1),(32,'2017_07_04_104933_create_admin_permission_menu_table',1),(33,'2017_07_04_104933_create_admin_permission_role_table',1),(34,'2017_07_04_104933_create_admin_permissions_table',1),(35,'2017_07_04_104933_create_admin_role_menu_table',1),(36,'2017_07_04_104933_create_admin_role_user_table',1);


