SQL/shop.sql · pony1223/餐掌柜

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 366

pony1223/餐掌柜

forked from 江苏传智播客教育科技股份有限公司/餐掌柜

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (1)

管理

master

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 1

标签 0

restkeeper

SQL

shop.sql

shop.sql 27.85 KB

/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 8.0.18 : Database - restkeeper_shop
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`restkeeper_shop` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `restkeeper_shop`;

/*Table structure for table `t_brand` */

DROP TABLE IF EXISTS `t_brand`;

CREATE TABLE `t_brand` (
 `brand_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户id',
 `brand_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店名称',
 `logo` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '图片地址',
 `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '所属分类',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户号id',
 `contact` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '门店联系人',
 `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人电话',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`brand_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='品牌管理';

/*Data for the table `t_brand` */

insert into `t_brand`(`brand_id`,`brand_name`,`logo`,`category`,`shop_id`,`contact`,`contact_phone`,`is_deleted`,`last_update_time`) values 
('1227424251418324993','王牌','','甜点饮品','f3deb','张三','15116921201',0,'2020年02月12日 10:48:41'),
('1227426950394228738','品牌一号','','甜点饮品','f3deb','张三','16127123243',0,'2020年02月12日 10:59:24'),
('1237215343973302273','1','','小吃/快餐','f3deb','1','1',0,'2020年03月10日 11:14:59'),
('1237215423144984577','2','','中餐','f3deb','2','23',0,'2020年03月10日 11:15:18'),
('1253143752393936897','招牌面馆','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587607725379_head.jpg','甜点饮品','f3deb','李立群','18701012087',0,'2020年04月23日 10:08:48'),
('1253494599820849154','小程序品牌','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587691364360_西餐.png','西餐','f3deb','刘俊杰','18940843614',0,'2020年04月24日 09:22:56'),
('1253526699982811137','老诚一锅','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587699027228_企业微信截图_15876095228073.png','小吃/快餐','2j15tjny','张三','18810703325',0,'2020年04月24日 11:30:29'),
('1254594679076392962','222','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587953653987_5555.png','小吃/快餐','f3deb','22','222',0,'2020年04月27日 10:14:15'),
('1254962205648019457','田老师红烧肉','','小吃/快餐','f3deb','田老师','13041139705',0,'2020年04月28日 10:34:41'),
('1255431445563928578','产品栈','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588153132203_wechat_logo.png','中餐','m1fhdqqt','毕鹏','13301131116',0,'2020年04月29日 17:39:16'),
('1255496092300181506','连线家','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588168567499_wechat_logo.png','甜点饮品','pifh8xt1','毕鹏','13301131116',0,'2020年04月29日 21:56:09'),
('1255513583621537794','测试','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588172737227_02.png','小吃/快餐','naw94n44','test','test',0,'2020年04月29日 23:05:39'),
('1257933744001527810','11','','小吃/快餐','f3deb','111','22',0,'2020年05月06日 15:22:31'),
('1260074056257937409','string','string','string','f3deb','string','string',0,'2020年05月12日 13:07:21'),
('1260150834901065729','肯德基','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1589278340275_未标题-1 - 副本(1).jpg','西餐','f3deb','老黑','13297555524',0,'2020年05月12日 18:12:26'),
('1282344389773901825','餐掌柜','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1594569699810_logo.434226c3.png','中餐','f3deb','播仔','13301131116',0,'2020年07月13日 00:01:42'),
('1282569865368977409','2323','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1594623458681_22222.jpg','中餐','f3deb','32','23232',0,'2020年07月13日 14:57:40'),
('1288661282889736194','九毛九','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1596075764895_test4.jpeg','美食广场(档口)','yc2peo7n','郝燕','13261698937',0,'2020年07月30日 10:22:47'),
('1288673966251122689','品牌1','','甜点饮品','yc2peo7n','测试1','13261698937',0,'2020年07月30日 11:13:11'),
('1288674332921372673','品牌2','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1596078876647_f6acc1a3d36a4c7fa25a96b9409da134.png','甜点饮品','yc2peo7n','测试2','13261698937',0,'2020年07月30日 11:14:38'),
('1292745959145521153','测试品牌','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1597049628147_u=2988309327,3913417527&fm=111&gp=0.jpg','甜点饮品','f3deb','测试','13261698937',0,'2020年08月10日 16:53:49'),
('1327578572028645378','12','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605354363265_二维码图片_10月28日18时25分19秒.png','串串香','f3deb','12','123',0,'2020年11月14日 19:46:11'),
('1328884816614096897','tree flower','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605665799822_下载.png','自助餐','f3deb','peter','18500000000',0,'2020年11月18日 10:16:44'),
('1329623959610617858','123','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605842029561_二维码图片_10月28日18时25分19秒.png','甜点饮品','f3deb','山村','16578903452',0,'2020年11月20日 11:13:50'),
('1336252429358870530','好吃点','','甜点饮品','f3deb','席靖宇','17683905468',0,'2020年12月08日 18:13:00');

/*Table structure for table `t_store` */

DROP TABLE IF EXISTS `t_store`;

CREATE TABLE `t_store` (
 `store_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店主键id',
 `store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店名称',
 `brand_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '品牌id',
 `province` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(省)',
 `city` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(市)',
 `area` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(区)',
 `address` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '详细地址',
 `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态(营业中1,已停用0)',
 `contact` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '门店联系人',
 `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人电话',
 `store_manager_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管理员id',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户id',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`store_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门店信息账号';

/*Data for the table `t_store` */

insert into `t_store`(`store_id`,`store_name`,`brand_id`,`province`,`city`,`area`,`address`,`status`,`contact`,`contact_phone`,`store_manager_id`,`is_deleted`,`shop_id`,`last_update_time`) values 
('1205130634214969345','门店1','1205130625968967682','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,'1205130634617622530',1,'f3deb','2019年12月12日 22:21:48'),
('1205130634395324417','收银端北京','1253143752393936897','天津市','天津市','河东区','北京 海淀 清华池',1,'楼老师','18810703325','1205130634617622530',0,'f3deb','2020年11月16日 13:09:17'),
('1206211976528871425','门店1','1205130625968967682','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'null','2019年12月15日 21:58:40'),
('1206216301732823041','门店1','1206216280392204290','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019年12月15日 22:15:51'),
('1206476527887405057','门店1','1206476367023263745','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019年12月16日 15:29:54'),
('1206476814614208513','门店1','1206476753285095425','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019年12月16日 15:31:03'),
('1206477268886712321','门店1','1206477198929915905','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019年12月16日 15:32:51'),
('1206479085242642434','门店1','1206479006180012033','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019年12月16日 15:40:04'),
('1227430144197341186','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020年02月12日 11:12:06'),
('1227431391646265346','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020年02月12日 11:17:03'),
('1227446499520884738','收银端','1227426950394228738','北京市','北京市','东城区','asdf',1,'asdf','asdf','1205130634617622530',1,'f3deb','2020年04月24日 11:10:37'),
('1227446732405420034','内蒙一号店2','1227424251418324993','内蒙古自治区','内蒙古自治区','乌海市','121121233',1,'12132','21212323','1229042814335930370',1,'f3deb','2020年05月19日 12:28:33'),
('1227486450832740353','fsafs','1227426950394228738','内蒙古自治区','内蒙古自治区','包头市','fasfaf',1,'fsaf','afaf',NULL,1,'f3deb','2020年02月12日 14:55:50'),
('1229024446757294081','大兴一号','1227424251418324993','北京市','北京市','东城区','大兴兴隆街99号',1,'李三','0208767676','1229029159443714049',1,'f3deb','2020年02月16日 20:47:17'),
('1229046210778451970','昌平一号店','1227426950394228738','北京市','北京市','西城区','昌平大一铺87号',1,'李起光','17873837394',NULL,1,'f3deb','2020年02月16日 22:13:46'),
('1252500961464729602','大兴三号','1227426950394228738','天津市','天津市','河东区','阿斯蒂芬',1,'阿道夫','3234234234',NULL,1,'f3deb','2020年04月21日 15:34:34'),
('1252801395224014850','大兴十号','1237215343973302273','北京市','北京市','东城区','阿道夫',1,'阿斯蒂芬','234-234324',NULL,1,'f3deb','2020年04月22日 11:28:23'),
('1252884252437000193','张庆','1237215423144984577','北京市','北京市','西城区','阿斯蒂芬',1,'啊稍等','234234234','1255431388027527170',1,'f3deb','2020年04月22日 16:57:38'),
('1253495517144494082','小程序北京第一门店','1253494599820849154','北京市','北京市','昌平区','北京市昌平区建材城西路金燕龙写字楼4层',1,'刘俊杰','18940843614','1205130634617622530',1,'f3deb','2020年04月24日 11:50:20'),
('1253523192663863298','测试','1253143752393936897','天津市','天津市','河西区','测试',1,'18810703325','18810703325',NULL,1,'f3deb','2020年04月24日 11:16:33'),
('1253526820371918849','测试1','1253526699982811137','北京市','北京市','西城区','测试地址',1,'zhagnsan','18810703325','1253526950990934017',0,'2j15tjny','2020年04月24日 11:30:58'),
('1254594105715036162','2222','1253143752393936897','天津市','天津市','河西区','2222',1,'22','2222',NULL,1,'f3deb','2020年04月27日 10:11:59'),
('1254962564256817153','建国门店','1254962205648019457','北京市','北京市','东城区','建国门店',1,'建国','13041139705',NULL,1,'f3deb','2020年04月28日 10:36:06'),
('1255432153239482370','产品栈小厨金燕龙店','1255431445563928578','北京市','北京市','昌平区','金燕龙写字楼地下停车场',1,'毕鹏','13301131116','1255433972422365185',0,'m1fhdqqt','2020年04月29日 17:42:05'),
('1255496202459381762','连线家门店','1255496092300181506','北京市','北京市','朝阳区','朝阳区五里桥二街2号院\n北京',1,'毕鹏','13301131116','1255496261922029569',0,'pifh8xt1','2020年04月29日 21:56:35'),
('1255513650571018241','test','1255513583621537794','天津市','天津市','河东区','test',1,'test','test','1255513726102044674',0,'naw94n44','2020年04月29日 23:05:55'),
('1261851998134771714','黑马店','1260152385711415298','北京市','北京市','东城区','顺义校区',1,'老黑','11111',NULL,1,'f3deb','2020年05月17日 10:52:15'),
('1261852329191186434','222','1260151547597201409','北京市','北京市','东城区','222',1,'222','2222',NULL,1,'f3deb','2020年05月17日 10:53:34'),
('1262188469836357633','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020年05月18日 09:09:16'),
('1262226099512844289','黑马店','','','','','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020年05月18日 11:38:48'),
('1262226593253728257','黑马店','','420000','420100','420116','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020年05月18日 11:40:46'),
('1262226912041803777','黑马店','1227424251418324993','420000','420100','420116','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020年05月18日 11:42:02'),
('1262251384010481665','黑马店','1227424251418324993','120000','120100','120101','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020年05月18日 13:19:16'),
('1262251582904377345','黑马店','1227424251418324993','150000','150100','150102','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020年05月18日 13:20:04'),
('1262253207278624770','web前端','1227426950394228738','420000','420100','420115','传智播客科创园',1,'小优老师','13297665566',NULL,1,'f3deb','2020年05月18日 13:26:31'),
('1262254477120937985','周黑鸭','1227426950394228738','320000','320100','320102','雨花台',1,'小鱼','11111111111',NULL,1,'f3deb','2020年05月18日 13:31:34'),
('1266978605711269890','123','招牌面馆','140000','140400','140423','北京 海淀 清华池11111111',1,'楼老师','18810703322',NULL,1,'f3deb','2020年05月31日 14:23:34'),
('1267616688450347009','keep','1227424251418324993','420000','420100','420116','传智播客科创园',1,'游游','13222222222',NULL,1,'f3deb','2020年06月02日 08:39:04'),
('1267622825220415489','111','1227424251418324993','140000','140400','140423','111',1,'1111','11111111111',NULL,1,'f3deb','2020年06月02日 09:03:27'),
('1269837373188907010','123','1227424251418324993','420000','420100','420116','黑马程序员',1,'123','123',NULL,1,'f3deb','2020年06月08日 11:43:17'),
('1269839226974806018','2233','1227424251418324993','340000','340300','340304','3333',1,'333','333',NULL,1,'f3deb','2020年06月08日 11:50:39'),
('1269856209732673538','qqq','1253143752393936897','220000','220400','220422','qqq',1,'qqq','qqq',NULL,1,'f3deb','2020年06月08日 12:58:08'),
('1269856718304616449','zzz','1253494599820849154','130000','130300','130304','zzzz',1,'zzz','zzz',NULL,1,'f3deb','2020年06月08日 13:59:44'),
('1269856970646528001','123','王牌','320000','320400','320412','ttt',1,'123','123',NULL,1,'f3deb','2020年06月08日 13:58:07'),
('1269872020891410433','666','1227424251418324993','320000','320400','320412','6666',1,'666','666',NULL,1,'f3deb','2020年06月08日 14:00:58'),
('1269872186805493762','66666','王牌','430000','430400','430408','6666777777',1,'666','666',NULL,1,'f3deb','2020年06月08日 14:02:22'),
('1269872937774653441','qqq','1227424251418324993','420000','420600','420625','qqq',1,'111','111',NULL,1,'f3deb','2020年06月08日 14:04:36'),
('1269874356221157378','1111','王牌','410000','410400','410404','1111',1,'1111','1111',NULL,1,'f3deb','2020年06月08日 14:10:35'),
('1269877693331054594','123','品牌一号','370000','370300','370304','123',1,'1111111','111111',NULL,1,'f3deb','2020年06月08日 14:28:54'),
('1269877902098341889','222','222','410000','410400','410411','22222222',1,'22','2222',NULL,1,'f3deb','2020年06月08日 14:25:33'),
('1269881285219753985','111','品牌一号','440000','440400','440404','111',1,'111','111',NULL,1,'f3deb','2020年06月08日 14:38:23'),
('1269882866422030338','1234','品牌一号','440000','440400','440404','1234',1,'1234','1234',NULL,1,'f3deb','2020年06月08日 14:44:20'),
('1269883758084923393','3333','招牌面馆','130000','130400','130406','33333',1,'333','333',NULL,1,'f3deb','2020年06月08日 14:48:34'),
('1269885877428985857','7777','肯德基','510000','510500','510521','7777',1,'老黑7','177',NULL,1,'f3deb','2020年06月08日 15:10:34'),
('1269889831483252737','11111','周黑鸭','安徽省','安徽省','马鞍山市','11111',1,'11111','11111',NULL,1,'f3deb','2020年06月08日 15:14:08'),
('1269891354179182594','111','王牌','440000','440400','440404','1111',1,'111','111',NULL,1,'f3deb','2020年06月08日 15:19:25'),
('1269893423409700866','222','王牌','410000','410400','410411','222',1,'222','222',NULL,1,'f3deb','2020年06月08日 15:26:13'),
('1269894979467124738','4444','招牌面馆','450000','450400','450421','4444',1,'44444','44444',NULL,1,'f3deb','2020年06月08日 15:32:39'),
('1269895392593485826','555556','肯德基','河北省','河北省','秦皇岛市','555556',1,'55556','55556',NULL,1,'f3deb','2020年06月08日 15:38:26'),
('1269897808156073986','1233','田老师红烧肉','420000','420600','420625','1233',1,'1233','1233',NULL,1,'f3deb','2020年06月08日 15:44:00'),
('1269902645304270850','1111','王牌','210000','210300','210304','1111',1,'1111','1111',NULL,1,'f3deb','2020年06月08日 16:03:30'),
('1269903168443031553','2222','王牌','130000','130300','130304','2222',1,'2222','2222',NULL,1,'f3deb','2020年06月08日 16:08:52'),
('1269904351366782978','小黑店','1227424251418324993','北京市','北京市','东城区','传智店',1,'郝老板','18675341529','1328258037012500482',0,'f3deb','2021年07月26日 15:09:55'),
('1269909836841132034','传智店','1227424251418324993','河北省','河北省','秦皇岛市','和平路店',1,'钱掌柜','18765478352','1229029159443714049',0,'f3deb','2021年07月26日 15:11:02'),
('1270896011819130881','小二店','1253143752393936897','340000','340400','340405','222',1,'222','222','1272007428219678721',1,'f3deb','2020年06月14日 10:44:14'),
('1270896079259344897','三哥店','1260150834901065729','510000','510500','510521','333',1,'333','333','1272007508729344001',1,'f3deb','2020年06月14日 10:44:34'),
('1270896149660737537','武湖店','1260152385711415298','420000','420100','420116','444',1,'444','444',NULL,1,'f3deb','2020年06月13日 16:02:23'),
('1270896212499800065','五哥店','1260151547597201409','370000','370400','370405','555',1,'555','555','1272007162728624129',1,'f3deb','2020年06月14日 10:44:56'),
('1271280322858790913','黑马店','1282344389773901825','湖北省','湖北省','武汉市','湖北省武湖',1,'游游','17565844589','1272007238788132866',0,'f3deb','2021年07月26日 15:12:32'),
('1282344676983062530','餐掌柜育新店','1282344389773901825','北京市','北京市','昌平区','建材城西路金燕龙写字楼',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020年12月13日 00:02:50'),
('1282570649326338050','222','1282344389773901825','北京市','北京市','东城区','2222',1,'22','2222',NULL,1,'f3deb','2020年07月13日 15:00:46'),
('1282570687423201282','2222','1282344389773901825','天津市','天津市','河东区','2222',1,'222','222',NULL,1,'f3deb','2020年07月13日 15:00:56'),
('1283672300246335489','22','1282569865368977409','北京市','北京市','东城区','22',0,'22','222',NULL,1,'f3deb','2020年07月16日 16:04:34'),
('1283681652315324418','23232','1282344389773901825','北京市','北京市','东城区','32323',1,'323','323',NULL,1,'f3deb','2020年07月16日 16:35:30'),
('1283681759043584001','545454','1260150834901065729','北京市','北京市','东城区','545454',1,'5454','4545',NULL,1,'f3deb','2020年07月16日 16:35:56'),
('1285147479128461313','餐掌柜顺义店','1282344389773901825','北京市','北京市','顺义区','京顺路99号黑马程序员(教学楼A栋)',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020年11月15日 22:04:03'),
('1285149346856226818','餐掌柜TBD店','1282344389773901825','北京市','北京市','昌平区','北七家镇七北路42号TBD云集中心2号楼3单元3层',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020年11月16日 13:11:56'),
('1285149840471281665','fsaf','1282344389773901825','天津市','天津市','河东区','fsafa',1,'fasf','fsafaf',NULL,1,'f3deb','2020年07月20日 17:50:09'),
('1287585303484194818','门店一号','1282344389773901825','天津市','天津市','河西区','鞍钢路店',0,'张三','15825664781','1205130634617622530',0,'f3deb','2021年07月26日 15:13:36'),
('1288653105829847042','1号店','1282344389773901825','北京市','北京市','东城区','测试',1,'测试','18200000000',NULL,1,'f3deb','2020年07月30日 09:50:35'),
('1288661996617670657','金燕龙门店','1288661282889736194','北京市','北京市','昌平区','金燕龙',1,'郝燕','13261698937','1288662663885299713',0,'yc2peo7n','2020年07月30日 10:37:03'),
('1288674459023122433','门店2','1288661282889736194','北京市','北京市','西城区','此项',1,'测试1','13261698938','1288674547468410882',0,'yc2peo7n','2020年07月30日 11:17:15'),
('1291570821364498434','一号门店','1282344389773901825','河北省','河北省','秦皇岛市','大望路店',0,'张三','18767636763','1205130634617622530',0,'f3deb','2021年07月26日 15:13:55'),
('1291570941103489026','二号','1282344389773901825','辽宁省','辽宁省','沈阳市','向阳路店',0,'蒙老师','12334235234',NULL,0,'f3deb','2021年07月26日 15:14:38'),
('1292739542921560065','门店1','1227424251418324993','北京市','北京市','东城区','北三环中路店',0,'杜店长','18800000000',NULL,0,'f3deb','2021年07月26日 15:16:08'),
('1292746078704156673','第一门店','1292745959145521153','北京市','北京市','东城区','东城区',1,'测试','13261698937','1292746344576892930',1,'f3deb','2020年08月10日 16:54:18'),
('1292746161008984065','第二门店','1292745959145521153','北京市','北京市','西城区','西城区',1,'测试','13261698937','1292746413610942465',1,'f3deb','2020年08月10日 16:54:38'),
('1327969813107052546','晓扬红肉','1292745959145521153','天津市','天津市','和平区','和平桥店',1,'杨险胜','16578904562',NULL,0,'f3deb','2021年07月26日 15:17:11'),
('1328188567321579521','小喜哦','1253143752393936897','天津市','天津市','南开区','89号路店',1,'张汤','14567894257','1328258037012500482',0,'f3deb','2021年07月26日 15:17:44'),
('1328194729760788482','123','1292745959145521153','河北省','河北省','秦皇岛市','23',1,'213','12323',NULL,1,'f3deb','2020年11月16日 16:45:46'),
('1328197290173665281','123','1292745959145521153','','北京市','市辖区','123213',1,'123','123',NULL,1,'f3deb','2020年11月16日 13:12:09'),
('1328885002153328642','tree flower1','1328884816614096897','北京市','北京市','东城区','东城区东郭家园店',1,'皮老板','18500000001','1328885283041673218',0,'f3deb','2021年07月26日 15:18:44');

/*Table structure for table `t_store_manager` */

DROP TABLE IF EXISTS `t_store_manager`;

CREATE TABLE `t_store_manager` (
 `store_manager_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
 `store_manager_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店管理员姓名',
 `store_manager_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店管理员电话',
 `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
 `status` int(1) DEFAULT '1',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '所属商户',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除 1是删除 0 未删除',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`store_manager_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门店管理员信息';

/*Data for the table `t_store_manager` */

insert into `t_store_manager`(`store_manager_id`,`store_manager_name`,`store_manager_phone`,`password`,`status`,`shop_id`,`is_deleted`,`last_update_time`) values 
('1205130634617622530','史文风','18810701234','1ドル$ZafRRcba$u/qwKjdTtlQJprMKxo/on0',1,'f3deb',0,'2021年07月26日 15:20:58'),
('1253526950990934017','力哥','18810703325','1ドル$gBmnjTi.$Xv/yJfXKcjR9UB0v1GVnp.',1,'2j15tjny',0,'2020年04月24日 11:31:29'),
('1255432233501683713','毕鹏','13301131116','1ドル$zUWy.fuX$kL1e305bZgZGwkd.YVOrg.',1,'m1fhdqqt',0,'2020年04月29日 17:42:24'),
('1255433972422365185','毕鹏','13301131116','1ドル$G0XcXakQ$RPYu9BmF5P8Lc2gL48nJ/.',1,'m1fhdqqt',0,'2020年04月29日 17:49:19'),
('1255496261922029569','毕鹏','13301131116','1ドル$UzlJgfJS$wL1BmCKRMqD2HO4dtQkhO.',1,'pifh8xt1',0,'2020年04月29日 21:56:49'),
('1255513726102044674','zhangsan2','18810703325','1ドル$pgKHtQXp$koR5eaJncyBEzc9Kkn5q1.',1,'naw94n44',0,'2020年04月29日 23:06:13'),
('1282344790564814849','播仔','13301131116','1ドル1ドルfVkPaAs$gZxTlpMid4RwBh2ueCBOS.',1,'f3deb',0,'2020年08月14日 17:48:13'),
('1282571312747790338','222222','2222','1ドル$lf/39sW0$WZz7NpH7NwhJcAWjJqa47.',1,'f3deb',1,'2020年07月13日 15:03:25'),
('1282571322306609153','222222','2222','1ドル1ドルHIBBJ5q$ezXBNGrWjSKTlBl6WgTS5/',1,'f3deb',1,'2020年07月13日 15:03:43'),
('1288370317062905857','222','2222','1ドル$z5hDXcRJ$OAWzhRQ9z0tXq8spUswV1/',1,'f3deb',1,'2020年07月29日 15:06:35'),
('1288370397245415425','22','22','1ドル$NQCddwi7$wwrOVztUkG1dkZyH1hzSC1',1,'f3deb',1,'2020年07月29日 15:06:54'),
('1288370408217714690','22','22','1ドル$s2j7Or5a$JQyprX/P5MUTHKjM9y04H0',1,'f3deb',1,'2020年07月29日 15:06:57'),
('1288662663885299713','郝燕','13261698937','1ドル$LHWZpwgo$uAcfWLloOGngzr.WJyJb6/',1,'yc2peo7n',0,'2020年07月30日 10:40:13'),
('1288662669950263297','郝燕','13261698937','1ドル$aTgYIsxP9ドルtkKu.TeXbQK9sjAh3nQi1',0,'yc2peo7n',1,'2020年07月30日 10:40:03'),
('1288662685674708993','郝燕','13261698937','1ドル$Xs9zn/Ok5ドルDNNoRMOuFC41HyC1QPhC0',0,'yc2peo7n',1,'2020年07月30日 10:28:21'),
('1288662709359943681','郝燕','13261698937','1ドル$Ap.h/bWQ$EE1txLGAzsDQFfUTXsjHK.',1,'yc2peo7n',1,'2020年07月30日 10:28:27'),
('1288662891862499330','郝燕','13261698937','1ドル1ドルO0UmJ6B$zHKi3IqPZ7vb58EFg2/Ye1',1,'yc2peo7n',1,'2020年07月30日 10:29:10'),
('1288663054236590081','毕鹏','13301131116','1ドル$RStNnSDp2ドルjv0xnwDzIeO4fKjhR61h0',1,'f3deb',1,'2020年07月30日 11:25:25'),
('1288674547468410882','测试2','13261698937','1ドル$PwX9lN8U$bRUCzqWuHhdaXx2BAEels1',1,'yc2peo7n',0,'2020年07月30日 11:15:29'),
('1288677143541260290','播仔','13301131116','1ドル1ドルfVkPaAs$gZxTlpMid4RwBh2ueCBOS.',1,'f3deb',1,'2020年08月14日 17:42:56'),
('1288680337617002497','小辉','1112222222','1ドル$cGR0Gjef$bJFTdQ3uPbUZPsrHA8ZNr.',0,'f3deb',1,'2020年07月30日 11:38:30'),
('1288680856527904769','小辉','1112223333','1ドル$yCzYfovS$ICQnXMRfkGdvrT5FALXaK1',1,'f3deb',1,'2020年07月30日 11:40:33'),
('1288681116474089473','小辉','111222333','1ドル$q3jp7W/B$HIE1o2VZSoVPvqrD/uxIQ.',0,'f3deb',1,'2020年07月30日 11:41:35'),
('1290109631463485442','张飒','18734534353','1ドル$IQLTvZzv$aPmNi1yIU1C/BDuI1PDRI1',1,'f3deb',1,'2020年08月03日 10:18:00'),
('1290109908652453890','李波','17834534534','1ドル5ドルHaJQTCk$dqrPSqObHVKx96wYvI/OR1',1,'f3deb',1,'2020年08月03日 10:19:06'),
('1290110542281764866','撒地方','18723878766','1ドル3ドルUtjr1BL$N0MsAOxJMC0hQePKA2Ptv.',1,'f3deb',1,'2020年08月03日 10:21:37'),
('1292746344576892930','杜长风','13261698937','1ドル$ItHYPwvK$iAgbDUKx/w7eH671zRbcT.',1,'f3deb',0,'2021年07月26日 15:19:29'),
('1292746413610942465','风笑天','13261698937','1ドル$CQPYkC5T$O/MPMJ8rhYwURIZXdxp7v1',1,'f3deb',0,'2021年07月26日 15:19:40'),
('1327986080480235521','123','123','1ドル$u4bdKLoq$sz.JqM8.ZFA4zzFn2FUV2/',1,'f3deb',1,'2020年11月15日 22:45:29'),
('1327986837287866370','xy','12345567890','1ドル$xEE8SvDb$ny/BP/u47s5GoUbBodZQW0',1,'f3deb',1,'2020年11月15日 23:23:11'),
('1328258037012500482','田子光','15678905673','1ドル6ドルkPcyB3u$XpFzcSPPl05e4962Rctvm1',0,'f3deb',0,'2021年07月26日 15:20:03'),
('1328885283041673218','皮静','18500000000','1ドル$Ske7MTnx$oviWYPS7vUG/Kmoa9Prm41',1,'f3deb',0,'2021年07月26日 15:20:25');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

一键复制编辑原始数据按行查看历史

王松岩提交于 2021年10月26日 11:38 +08:00 . first commit

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238

/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 8.0.18 : Database - restkeeper_shop
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`restkeeper_shop` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `restkeeper_shop`;

/*Table structure for table `t_brand` */

DROP TABLE IF EXISTS `t_brand`;

CREATE TABLE `t_brand` (
 `brand_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户id',
 `brand_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店名称',
 `logo` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '图片地址',
 `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '所属分类',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户号id',
 `contact` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '门店联系人',
 `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人电话',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`brand_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='品牌管理';

/*Data for the table `t_brand` */

insert into `t_brand`(`brand_id`,`brand_name`,`logo`,`category`,`shop_id`,`contact`,`contact_phone`,`is_deleted`,`last_update_time`) values 
('1227424251418324993','王牌','','甜点饮品','f3deb','张三','15116921201',0,'2020-02-12 10:48:41'),
('1227426950394228738','品牌一号','','甜点饮品','f3deb','张三','16127123243',0,'2020-02-12 10:59:24'),
('1237215343973302273','1','','小吃/快餐','f3deb','1','1',0,'2020-03-10 11:14:59'),
('1237215423144984577','2','','中餐','f3deb','2','23',0,'2020-03-10 11:15:18'),
('1253143752393936897','招牌面馆','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587607725379_head.jpg','甜点饮品','f3deb','李立群','18701012087',0,'2020-04-23 10:08:48'),
('1253494599820849154','小程序品牌','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587691364360_西餐.png','西餐','f3deb','刘俊杰','18940843614',0,'2020-04-24 09:22:56'),
('1253526699982811137','老诚一锅','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587699027228_企业微信截图_15876095228073.png','小吃/快餐','2j15tjny','张三','18810703325',0,'2020-04-24 11:30:29'),
('1254594679076392962','222','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1587953653987_5555.png','小吃/快餐','f3deb','22','222',0,'2020-04-27 10:14:15'),
('1254962205648019457','田老师红烧肉','','小吃/快餐','f3deb','田老师','13041139705',0,'2020-04-28 10:34:41'),
('1255431445563928578','产品栈','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588153132203_wechat_logo.png','中餐','m1fhdqqt','毕鹏','13301131116',0,'2020-04-29 17:39:16'),
('1255496092300181506','连线家','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588168567499_wechat_logo.png','甜点饮品','pifh8xt1','毕鹏','13301131116',0,'2020-04-29 21:56:09'),
('1255513583621537794','测试','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1588172737227_02.png','小吃/快餐','naw94n44','test','test',0,'2020-04-29 23:05:39'),
('1257933744001527810','11','','小吃/快餐','f3deb','111','22',0,'2020-05-06 15:22:31'),
('1260074056257937409','string','string','string','f3deb','string','string',0,'2020-05-12 13:07:21'),
('1260150834901065729','肯德基','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1589278340275_未标题-1 - 副本(1).jpg','西餐','f3deb','老黑','13297555524',0,'2020-05-12 18:12:26'),
('1282344389773901825','餐掌柜','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1594569699810_logo.434226c3.png','中餐','f3deb','播仔','13301131116',0,'2020-07-13 00:01:42'),
('1282569865368977409','2323','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1594623458681_22222.jpg','中餐','f3deb','32','23232',0,'2020-07-13 14:57:40'),
('1288661282889736194','九毛九','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1596075764895_test4.jpeg','美食广场(档口)','yc2peo7n','郝燕','13261698937',0,'2020-07-30 10:22:47'),
('1288673966251122689','品牌1','','甜点饮品','yc2peo7n','测试1','13261698937',0,'2020-07-30 11:13:11'),
('1288674332921372673','品牌2','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1596078876647_f6acc1a3d36a4c7fa25a96b9409da134.png','甜点饮品','yc2peo7n','测试2','13261698937',0,'2020-07-30 11:14:38'),
('1292745959145521153','测试品牌','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1597049628147_u=2988309327,3913417527&fm=111&gp=0.jpg','甜点饮品','f3deb','测试','13261698937',0,'2020-08-10 16:53:49'),
('1327578572028645378','12','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605354363265_二维码图片_10月28日18时25分19秒.png','串串香','f3deb','12','123',0,'2020-11-14 19:46:11'),
('1328884816614096897','tree flower','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605665799822_下载.png','自助餐','f3deb','peter','18500000000',0,'2020-11-18 10:16:44'),
('1329623959610617858','123','https://restkeeper-wzh.oss-cn-beijing.aliyuncs.com/1605842029561_二维码图片_10月28日18时25分19秒.png','甜点饮品','f3deb','山村','16578903452',0,'2020-11-20 11:13:50'),
('1336252429358870530','好吃点','','甜点饮品','f3deb','席靖宇','17683905468',0,'2020-12-08 18:13:00');

/*Table structure for table `t_store` */

DROP TABLE IF EXISTS `t_store`;

CREATE TABLE `t_store` (
 `store_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店主键id',
 `store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店名称',
 `brand_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '品牌id',
 `province` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(省)',
 `city` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(市)',
 `area` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(区)',
 `address` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '详细地址',
 `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态(营业中1,已停用0)',
 `contact` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '门店联系人',
 `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人电话',
 `store_manager_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管理员id',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户id',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`store_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门店信息账号';

/*Data for the table `t_store` */

insert into `t_store`(`store_id`,`store_name`,`brand_id`,`province`,`city`,`area`,`address`,`status`,`contact`,`contact_phone`,`store_manager_id`,`is_deleted`,`shop_id`,`last_update_time`) values 
('1205130634214969345','门店1','1205130625968967682','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,'1205130634617622530',1,'f3deb','2019-12-12 22:21:48'),
('1205130634395324417','收银端北京','1253143752393936897','天津市','天津市','河东区','北京 海淀 清华池',1,'楼老师','18810703325','1205130634617622530',0,'f3deb','2020-11-16 13:09:17'),
('1206211976528871425','门店1','1205130625968967682','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'null','2019-12-15 21:58:40'),
('1206216301732823041','门店1','1206216280392204290','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019-12-15 22:15:51'),
('1206476527887405057','门店1','1206476367023263745','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019-12-16 15:29:54'),
('1206476814614208513','门店1','1206476753285095425','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019-12-16 15:31:03'),
('1206477268886712321','门店1','1206477198929915905','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019-12-16 15:32:51'),
('1206479085242642434','门店1','1206479006180012033','北京','昌平区','金燕龙大厦','北京 昌平区 金燕龙大厦',1,NULL,NULL,NULL,0,'test','2019-12-16 15:40:04'),
('1227430144197341186','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020-02-12 11:12:06'),
('1227431391646265346','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020-02-12 11:17:03'),
('1227446499520884738','收银端','1227426950394228738','北京市','北京市','东城区','asdf',1,'asdf','asdf','1205130634617622530',1,'f3deb','2020-04-24 11:10:37'),
('1227446732405420034','内蒙一号店2','1227424251418324993','内蒙古自治区','内蒙古自治区','乌海市','121121233',1,'12132','21212323','1229042814335930370',1,'f3deb','2020-05-19 12:28:33'),
('1227486450832740353','fsafs','1227426950394228738','内蒙古自治区','内蒙古自治区','包头市','fasfaf',1,'fsaf','afaf',NULL,1,'f3deb','2020-02-12 14:55:50'),
('1229024446757294081','大兴一号','1227424251418324993','北京市','北京市','东城区','大兴兴隆街99号',1,'李三','0208767676','1229029159443714049',1,'f3deb','2020-02-16 20:47:17'),
('1229046210778451970','昌平一号店','1227426950394228738','北京市','北京市','西城区','昌平大一铺87号',1,'李起光','17873837394',NULL,1,'f3deb','2020-02-16 22:13:46'),
('1252500961464729602','大兴三号','1227426950394228738','天津市','天津市','河东区','阿斯蒂芬',1,'阿道夫','3234234234',NULL,1,'f3deb','2020-04-21 15:34:34'),
('1252801395224014850','大兴十号','1237215343973302273','北京市','北京市','东城区','阿道夫',1,'阿斯蒂芬','234-234324',NULL,1,'f3deb','2020-04-22 11:28:23'),
('1252884252437000193','张庆','1237215423144984577','北京市','北京市','西城区','阿斯蒂芬',1,'啊稍等','234234234','1255431388027527170',1,'f3deb','2020-04-22 16:57:38'),
('1253495517144494082','小程序北京第一门店','1253494599820849154','北京市','北京市','昌平区','北京市昌平区建材城西路金燕龙写字楼4层',1,'刘俊杰','18940843614','1205130634617622530',1,'f3deb','2020-04-24 11:50:20'),
('1253523192663863298','测试','1253143752393936897','天津市','天津市','河西区','测试',1,'18810703325','18810703325',NULL,1,'f3deb','2020-04-24 11:16:33'),
('1253526820371918849','测试1','1253526699982811137','北京市','北京市','西城区','测试地址',1,'zhagnsan','18810703325','1253526950990934017',0,'2j15tjny','2020-04-24 11:30:58'),
('1254594105715036162','2222','1253143752393936897','天津市','天津市','河西区','2222',1,'22','2222',NULL,1,'f3deb','2020-04-27 10:11:59'),
('1254962564256817153','建国门店','1254962205648019457','北京市','北京市','东城区','建国门店',1,'建国','13041139705',NULL,1,'f3deb','2020-04-28 10:36:06'),
('1255432153239482370','产品栈小厨金燕龙店','1255431445563928578','北京市','北京市','昌平区','金燕龙写字楼地下停车场',1,'毕鹏','13301131116','1255433972422365185',0,'m1fhdqqt','2020-04-29 17:42:05'),
('1255496202459381762','连线家门店','1255496092300181506','北京市','北京市','朝阳区','朝阳区五里桥二街2号院\n北京',1,'毕鹏','13301131116','1255496261922029569',0,'pifh8xt1','2020-04-29 21:56:35'),
('1255513650571018241','test','1255513583621537794','天津市','天津市','河东区','test',1,'test','test','1255513726102044674',0,'naw94n44','2020-04-29 23:05:55'),
('1261851998134771714','黑马店','1260152385711415298','北京市','北京市','东城区','顺义校区',1,'老黑','11111',NULL,1,'f3deb','2020-05-17 10:52:15'),
('1261852329191186434','222','1260151547597201409','北京市','北京市','东城区','222',1,'222','2222',NULL,1,'f3deb','2020-05-17 10:53:34'),
('1262188469836357633','string','string','string','string','string','string',1,'string','string',NULL,1,'f3deb','2020-05-18 09:09:16'),
('1262226099512844289','黑马店','','','','','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020-05-18 11:38:48'),
('1262226593253728257','黑马店','','420000','420100','420116','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020-05-18 11:40:46'),
('1262226912041803777','黑马店','1227424251418324993','420000','420100','420116','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020-05-18 11:42:02'),
('1262251384010481665','黑马店','1227424251418324993','120000','120100','120101','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020-05-18 13:19:16'),
('1262251582904377345','黑马店','1227424251418324993','150000','150100','150102','c传智播客科创园',1,'王老师','13297556666',NULL,1,'f3deb','2020-05-18 13:20:04'),
('1262253207278624770','web前端','1227426950394228738','420000','420100','420115','传智播客科创园',1,'小优老师','13297665566',NULL,1,'f3deb','2020-05-18 13:26:31'),
('1262254477120937985','周黑鸭','1227426950394228738','320000','320100','320102','雨花台',1,'小鱼','11111111111',NULL,1,'f3deb','2020-05-18 13:31:34'),
('1266978605711269890','123','招牌面馆','140000','140400','140423','北京 海淀 清华池11111111',1,'楼老师','18810703322',NULL,1,'f3deb','2020-05-31 14:23:34'),
('1267616688450347009','keep','1227424251418324993','420000','420100','420116','传智播客科创园',1,'游游','13222222222',NULL,1,'f3deb','2020-06-02 08:39:04'),
('1267622825220415489','111','1227424251418324993','140000','140400','140423','111',1,'1111','11111111111',NULL,1,'f3deb','2020-06-02 09:03:27'),
('1269837373188907010','123','1227424251418324993','420000','420100','420116','黑马程序员',1,'123','123',NULL,1,'f3deb','2020-06-08 11:43:17'),
('1269839226974806018','2233','1227424251418324993','340000','340300','340304','3333',1,'333','333',NULL,1,'f3deb','2020-06-08 11:50:39'),
('1269856209732673538','qqq','1253143752393936897','220000','220400','220422','qqq',1,'qqq','qqq',NULL,1,'f3deb','2020-06-08 12:58:08'),
('1269856718304616449','zzz','1253494599820849154','130000','130300','130304','zzzz',1,'zzz','zzz',NULL,1,'f3deb','2020-06-08 13:59:44'),
('1269856970646528001','123','王牌','320000','320400','320412','ttt',1,'123','123',NULL,1,'f3deb','2020-06-08 13:58:07'),
('1269872020891410433','666','1227424251418324993','320000','320400','320412','6666',1,'666','666',NULL,1,'f3deb','2020-06-08 14:00:58'),
('1269872186805493762','66666','王牌','430000','430400','430408','6666777777',1,'666','666',NULL,1,'f3deb','2020-06-08 14:02:22'),
('1269872937774653441','qqq','1227424251418324993','420000','420600','420625','qqq',1,'111','111',NULL,1,'f3deb','2020-06-08 14:04:36'),
('1269874356221157378','1111','王牌','410000','410400','410404','1111',1,'1111','1111',NULL,1,'f3deb','2020-06-08 14:10:35'),
('1269877693331054594','123','品牌一号','370000','370300','370304','123',1,'1111111','111111',NULL,1,'f3deb','2020-06-08 14:28:54'),
('1269877902098341889','222','222','410000','410400','410411','22222222',1,'22','2222',NULL,1,'f3deb','2020-06-08 14:25:33'),
('1269881285219753985','111','品牌一号','440000','440400','440404','111',1,'111','111',NULL,1,'f3deb','2020-06-08 14:38:23'),
('1269882866422030338','1234','品牌一号','440000','440400','440404','1234',1,'1234','1234',NULL,1,'f3deb','2020-06-08 14:44:20'),
('1269883758084923393','3333','招牌面馆','130000','130400','130406','33333',1,'333','333',NULL,1,'f3deb','2020-06-08 14:48:34'),
('1269885877428985857','7777','肯德基','510000','510500','510521','7777',1,'老黑7','177',NULL,1,'f3deb','2020-06-08 15:10:34'),
('1269889831483252737','11111','周黑鸭','安徽省','安徽省','马鞍山市','11111',1,'11111','11111',NULL,1,'f3deb','2020-06-08 15:14:08'),
('1269891354179182594','111','王牌','440000','440400','440404','1111',1,'111','111',NULL,1,'f3deb','2020-06-08 15:19:25'),
('1269893423409700866','222','王牌','410000','410400','410411','222',1,'222','222',NULL,1,'f3deb','2020-06-08 15:26:13'),
('1269894979467124738','4444','招牌面馆','450000','450400','450421','4444',1,'44444','44444',NULL,1,'f3deb','2020-06-08 15:32:39'),
('1269895392593485826','555556','肯德基','河北省','河北省','秦皇岛市','555556',1,'55556','55556',NULL,1,'f3deb','2020-06-08 15:38:26'),
('1269897808156073986','1233','田老师红烧肉','420000','420600','420625','1233',1,'1233','1233',NULL,1,'f3deb','2020-06-08 15:44:00'),
('1269902645304270850','1111','王牌','210000','210300','210304','1111',1,'1111','1111',NULL,1,'f3deb','2020-06-08 16:03:30'),
('1269903168443031553','2222','王牌','130000','130300','130304','2222',1,'2222','2222',NULL,1,'f3deb','2020-06-08 16:08:52'),
('1269904351366782978','小黑店','1227424251418324993','北京市','北京市','东城区','传智店',1,'郝老板','18675341529','1328258037012500482',0,'f3deb','2021-07-26 15:09:55'),
('1269909836841132034','传智店','1227424251418324993','河北省','河北省','秦皇岛市','和平路店',1,'钱掌柜','18765478352','1229029159443714049',0,'f3deb','2021-07-26 15:11:02'),
('1270896011819130881','小二店','1253143752393936897','340000','340400','340405','222',1,'222','222','1272007428219678721',1,'f3deb','2020-06-14 10:44:14'),
('1270896079259344897','三哥店','1260150834901065729','510000','510500','510521','333',1,'333','333','1272007508729344001',1,'f3deb','2020-06-14 10:44:34'),
('1270896149660737537','武湖店','1260152385711415298','420000','420100','420116','444',1,'444','444',NULL,1,'f3deb','2020-06-13 16:02:23'),
('1270896212499800065','五哥店','1260151547597201409','370000','370400','370405','555',1,'555','555','1272007162728624129',1,'f3deb','2020-06-14 10:44:56'),
('1271280322858790913','黑马店','1282344389773901825','湖北省','湖北省','武汉市','湖北省武湖',1,'游游','17565844589','1272007238788132866',0,'f3deb','2021-07-26 15:12:32'),
('1282344676983062530','餐掌柜育新店','1282344389773901825','北京市','北京市','昌平区','建材城西路金燕龙写字楼',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020-12-13 00:02:50'),
('1282570649326338050','222','1282344389773901825','北京市','北京市','东城区','2222',1,'22','2222',NULL,1,'f3deb','2020-07-13 15:00:46'),
('1282570687423201282','2222','1282344389773901825','天津市','天津市','河东区','2222',1,'222','222',NULL,1,'f3deb','2020-07-13 15:00:56'),
('1283672300246335489','22','1282569865368977409','北京市','北京市','东城区','22',0,'22','222',NULL,1,'f3deb','2020-07-16 16:04:34'),
('1283681652315324418','23232','1282344389773901825','北京市','北京市','东城区','32323',1,'323','323',NULL,1,'f3deb','2020-07-16 16:35:30'),
('1283681759043584001','545454','1260150834901065729','北京市','北京市','东城区','545454',1,'5454','4545',NULL,1,'f3deb','2020-07-16 16:35:56'),
('1285147479128461313','餐掌柜顺义店','1282344389773901825','北京市','北京市','顺义区','京顺路99号黑马程序员(教学楼A栋)',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020-11-15 22:04:03'),
('1285149346856226818','餐掌柜TBD店','1282344389773901825','北京市','北京市','昌平区','北七家镇七北路42号TBD云集中心2号楼3单元3层',1,'播仔','13301131116','1282344790564814849',0,'f3deb','2020-11-16 13:11:56'),
('1285149840471281665','fsaf','1282344389773901825','天津市','天津市','河东区','fsafa',1,'fasf','fsafaf',NULL,1,'f3deb','2020-07-20 17:50:09'),
('1287585303484194818','门店一号','1282344389773901825','天津市','天津市','河西区','鞍钢路店',0,'张三','15825664781','1205130634617622530',0,'f3deb','2021-07-26 15:13:36'),
('1288653105829847042','1号店','1282344389773901825','北京市','北京市','东城区','测试',1,'测试','18200000000',NULL,1,'f3deb','2020-07-30 09:50:35'),
('1288661996617670657','金燕龙门店','1288661282889736194','北京市','北京市','昌平区','金燕龙',1,'郝燕','13261698937','1288662663885299713',0,'yc2peo7n','2020-07-30 10:37:03'),
('1288674459023122433','门店2','1288661282889736194','北京市','北京市','西城区','此项',1,'测试1','13261698938','1288674547468410882',0,'yc2peo7n','2020-07-30 11:17:15'),
('1291570821364498434','一号门店','1282344389773901825','河北省','河北省','秦皇岛市','大望路店',0,'张三','18767636763','1205130634617622530',0,'f3deb','2021-07-26 15:13:55'),
('1291570941103489026','二号','1282344389773901825','辽宁省','辽宁省','沈阳市','向阳路店',0,'蒙老师','12334235234',NULL,0,'f3deb','2021-07-26 15:14:38'),
('1292739542921560065','门店1','1227424251418324993','北京市','北京市','东城区','北三环中路店',0,'杜店长','18800000000',NULL,0,'f3deb','2021-07-26 15:16:08'),
('1292746078704156673','第一门店','1292745959145521153','北京市','北京市','东城区','东城区',1,'测试','13261698937','1292746344576892930',1,'f3deb','2020-08-10 16:54:18'),
('1292746161008984065','第二门店','1292745959145521153','北京市','北京市','西城区','西城区',1,'测试','13261698937','1292746413610942465',1,'f3deb','2020-08-10 16:54:38'),
('1327969813107052546','晓扬红肉','1292745959145521153','天津市','天津市','和平区','和平桥店',1,'杨险胜','16578904562',NULL,0,'f3deb','2021-07-26 15:17:11'),
('1328188567321579521','小喜哦','1253143752393936897','天津市','天津市','南开区','89号路店',1,'张汤','14567894257','1328258037012500482',0,'f3deb','2021-07-26 15:17:44'),
('1328194729760788482','123','1292745959145521153','河北省','河北省','秦皇岛市','23',1,'213','12323',NULL,1,'f3deb','2020-11-16 16:45:46'),
('1328197290173665281','123','1292745959145521153','','北京市','市辖区','123213',1,'123','123',NULL,1,'f3deb','2020-11-16 13:12:09'),
('1328885002153328642','tree flower1','1328884816614096897','北京市','北京市','东城区','东城区东郭家园店',1,'皮老板','18500000001','1328885283041673218',0,'f3deb','2021-07-26 15:18:44');

/*Table structure for table `t_store_manager` */

DROP TABLE IF EXISTS `t_store_manager`;

CREATE TABLE `t_store_manager` (
 `store_manager_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
 `store_manager_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店管理员姓名',
 `store_manager_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '门店管理员电话',
 `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
 `status` int(1) DEFAULT '1',
 `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '所属商户',
 `is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除 1是删除 0 未删除',
 `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
 PRIMARY KEY (`store_manager_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='门店管理员信息';

/*Data for the table `t_store_manager` */

insert into `t_store_manager`(`store_manager_id`,`store_manager_name`,`store_manager_phone`,`password`,`status`,`shop_id`,`is_deleted`,`last_update_time`) values 
('1205130634617622530','史文风','18810701234','1ドル$ZafRRcba$u/qwKjdTtlQJprMKxo/on0',1,'f3deb',0,'2021-07-26 15:20:58'),
('1253526950990934017','力哥','18810703325','1ドル$gBmnjTi.$Xv/yJfXKcjR9UB0v1GVnp.',1,'2j15tjny',0,'2020-04-24 11:31:29'),
('1255432233501683713','毕鹏','13301131116','1ドル$zUWy.fuX$kL1e305bZgZGwkd.YVOrg.',1,'m1fhdqqt',0,'2020-04-29 17:42:24'),
('1255433972422365185','毕鹏','13301131116','1ドル$G0XcXakQ$RPYu9BmF5P8Lc2gL48nJ/.',1,'m1fhdqqt',0,'2020-04-29 17:49:19'),
('1255496261922029569','毕鹏','13301131116','1ドル$UzlJgfJS$wL1BmCKRMqD2HO4dtQkhO.',1,'pifh8xt1',0,'2020-04-29 21:56:49'),
('1255513726102044674','zhangsan2','18810703325','1ドル$pgKHtQXp$koR5eaJncyBEzc9Kkn5q1.',1,'naw94n44',0,'2020-04-29 23:06:13'),
('1282344790564814849','播仔','13301131116','1ドル1ドルfVkPaAs$gZxTlpMid4RwBh2ueCBOS.',1,'f3deb',0,'2020-08-14 17:48:13'),
('1282571312747790338','222222','2222','1ドル$lf/39sW0$WZz7NpH7NwhJcAWjJqa47.',1,'f3deb',1,'2020-07-13 15:03:25'),
('1282571322306609153','222222','2222','1ドル1ドルHIBBJ5q$ezXBNGrWjSKTlBl6WgTS5/',1,'f3deb',1,'2020-07-13 15:03:43'),
('1288370317062905857','222','2222','1ドル$z5hDXcRJ$OAWzhRQ9z0tXq8spUswV1/',1,'f3deb',1,'2020-07-29 15:06:35'),
('1288370397245415425','22','22','1ドル$NQCddwi7$wwrOVztUkG1dkZyH1hzSC1',1,'f3deb',1,'2020-07-29 15:06:54'),
('1288370408217714690','22','22','1ドル$s2j7Or5a$JQyprX/P5MUTHKjM9y04H0',1,'f3deb',1,'2020-07-29 15:06:57'),
('1288662663885299713','郝燕','13261698937','1ドル$LHWZpwgo$uAcfWLloOGngzr.WJyJb6/',1,'yc2peo7n',0,'2020-07-30 10:40:13'),
('1288662669950263297','郝燕','13261698937','1ドル$aTgYIsxP9ドルtkKu.TeXbQK9sjAh3nQi1',0,'yc2peo7n',1,'2020-07-30 10:40:03'),
('1288662685674708993','郝燕','13261698937','1ドル$Xs9zn/Ok5ドルDNNoRMOuFC41HyC1QPhC0',0,'yc2peo7n',1,'2020-07-30 10:28:21'),
('1288662709359943681','郝燕','13261698937','1ドル$Ap.h/bWQ$EE1txLGAzsDQFfUTXsjHK.',1,'yc2peo7n',1,'2020-07-30 10:28:27'),
('1288662891862499330','郝燕','13261698937','1ドル1ドルO0UmJ6B$zHKi3IqPZ7vb58EFg2/Ye1',1,'yc2peo7n',1,'2020-07-30 10:29:10'),
('1288663054236590081','毕鹏','13301131116','1ドル$RStNnSDp2ドルjv0xnwDzIeO4fKjhR61h0',1,'f3deb',1,'2020-07-30 11:25:25'),
('1288674547468410882','测试2','13261698937','1ドル$PwX9lN8U$bRUCzqWuHhdaXx2BAEels1',1,'yc2peo7n',0,'2020-07-30 11:15:29'),
('1288677143541260290','播仔','13301131116','1ドル1ドルfVkPaAs$gZxTlpMid4RwBh2ueCBOS.',1,'f3deb',1,'2020-08-14 17:42:56'),
('1288680337617002497','小辉','1112222222','1ドル$cGR0Gjef$bJFTdQ3uPbUZPsrHA8ZNr.',0,'f3deb',1,'2020-07-30 11:38:30'),
('1288680856527904769','小辉','1112223333','1ドル$yCzYfovS$ICQnXMRfkGdvrT5FALXaK1',1,'f3deb',1,'2020-07-30 11:40:33'),
('1288681116474089473','小辉','111222333','1ドル$q3jp7W/B$HIE1o2VZSoVPvqrD/uxIQ.',0,'f3deb',1,'2020-07-30 11:41:35'),
('1290109631463485442','张飒','18734534353','1ドル$IQLTvZzv$aPmNi1yIU1C/BDuI1PDRI1',1,'f3deb',1,'2020-08-03 10:18:00'),
('1290109908652453890','李波','17834534534','1ドル5ドルHaJQTCk$dqrPSqObHVKx96wYvI/OR1',1,'f3deb',1,'2020-08-03 10:19:06'),
('1290110542281764866','撒地方','18723878766','1ドル3ドルUtjr1BL$N0MsAOxJMC0hQePKA2Ptv.',1,'f3deb',1,'2020-08-03 10:21:37'),
('1292746344576892930','杜长风','13261698937','1ドル$ItHYPwvK$iAgbDUKx/w7eH671zRbcT.',1,'f3deb',0,'2021-07-26 15:19:29'),
('1292746413610942465','风笑天','13261698937','1ドル$CQPYkC5T$O/MPMJ8rhYwURIZXdxp7v1',1,'f3deb',0,'2021-07-26 15:19:40'),
('1327986080480235521','123','123','1ドル$u4bdKLoq$sz.JqM8.ZFA4zzFn2FUV2/',1,'f3deb',1,'2020-11-15 22:45:29'),
('1327986837287866370','xy','12345567890','1ドル$xEE8SvDb$ny/BP/u47s5GoUbBodZQW0',1,'f3deb',1,'2020-11-15 23:23:11'),
('1328258037012500482','田子光','15678905673','1ドル6ドルkPcyB3u$XpFzcSPPl05e4962Rctvm1',0,'f3deb',0,'2021-07-26 15:20:03'),
('1328885283041673218','皮静','18500000000','1ドル$Ske7MTnx$oviWYPS7vUG/Kmoa9Prm41',1,'f3deb',0,'2021-07-26 15:20:25');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;