/*
|
Navicat MySQL Data Transfer
|
|
Source Server : lcoal
|
Source Server Version : 80033
|
Source Host : localhost:3306
|
Source Database : qianduan_sql
|
|
Target Server Type : MYSQL
|
Target Server Version : 80033
|
File Encoding : 65001
|
|
Date: 2023-07-11 11:47:08
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for shopname_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `shopname_data`;
|
CREATE TABLE `shopname_data` (
|
`fume_dev_id` varchar(30) CHARACTER SET utf8mb3 NOT NULL COMMENT '设备编号',
|
`shop_name` varchar(20) CHARACTER SET utf8mb3 NOT NULL COMMENT '餐饮店'
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- ----------------------------
|
-- Records of shopname_data
|
-- ----------------------------
|
INSERT INTO `shopname_data` VALUES ('GLHB00000000016004', '上海稔传餐饮管理有限公司（人生一串）');
|
INSERT INTO `shopname_data` VALUES ('fucheng310104200914', '缘家');
|
INSERT INTO `shopname_data` VALUES ('GLHB00000000016011', '丰茂烤串');
|
INSERT INTO `shopname_data` VALUES ('GLHB00000000010279', '上海泰煌餐饮管理有限公司（泰煌鸡）');
|
INSERT INTO `shopname_data` VALUES ('GLHB00000000010504', '徐汇区辰熙餐馆(小铁君串烧居酒屋)');
|
INSERT INTO `shopname_data` VALUES ('qinshi_31010320210010', '付小姐在成都');
|
INSERT INTO `shopname_data` VALUES ('qinshi_31010320200006', '吉刻联盟');
|
INSERT INTO `shopname_data` VALUES ('hengzhiyuan_64480047347215', '家在塔啦');
|
INSERT INTO `shopname_data` VALUES ('zhuoquan_31011020175012', '狼来了');
|
INSERT INTO `shopname_data` VALUES ('qinshi_31010320200007', '乐凯撒星游店');
|
INSERT INTO `shopname_data` VALUES ('hengzhiyuan_64480047078091', '馨远美食小镇（哈尼美食广场）');
|
INSERT INTO `shopname_data` VALUES ('qinshi_31010320190005', '棒约翰');
|
INSERT INTO `shopname_data` VALUES ('zhuoquan_31011020175008', '弄堂咪道');
|
INSERT INTO `shopname_data` VALUES ('zhuoquan_31011020175002', '杨记齐齐哈尔烤肉');
|
INSERT INTO `shopname_data` VALUES ('GLHB00000000016155', '泉盛餐饮（上海）有限公司（食其家）');
|
