From 24c1e8c7e81d889b8d5a81993ab066fd5b0f4bbb Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期二, 11 七月 2023 11:48:55 +0800
Subject: [PATCH] Spring+MySql表结构

---
 MySql/fm_web_analysis_data.sql |   45 +++++++
 MySql/shopname_data.sql        |   44 +++++++
 MySql/ed_data.sql              |   39 ++++++
 MySql/exceeding_st_data.sql    |   41 ++++++
 MySql/ea_t_device_info.sql     |   41 ++++++
 MySql/abnormal_data.sql        |   31 +++++
 MySql/fd_t_minutevalue.sql     |   41 ++++++
 MySql/analysis_data.sql        |   45 +++++++
 8 files changed, 327 insertions(+), 0 deletions(-)

diff --git a/MySql/abnormal_data.sql b/MySql/abnormal_data.sql
new file mode 100644
index 0000000..b3cf297
--- /dev/null
+++ b/MySql/abnormal_data.sql
@@ -0,0 +1,31 @@
+/*
+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:41:53
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for abnormal_data
+-- ----------------------------
+DROP TABLE IF EXISTS `abnormal_data`;
+CREATE TABLE `abnormal_data` (
+  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '搴忓彿',
+  `dev_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '璁惧缂栧彿',
+  `exception` varchar(20) NOT NULL,
+  `exception_type` varchar(20) NOT NULL COMMENT '寮傚父绫诲瀷',
+  `region` varchar(20) DEFAULT NULL COMMENT '鍦板尯',
+  `begin_time` datetime NOT NULL COMMENT '寮�濮嬫椂闂�',
+  `end_time` datetime NOT NULL COMMENT '缁撴潫',
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=625 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
diff --git a/MySql/analysis_data.sql b/MySql/analysis_data.sql
new file mode 100644
index 0000000..64efd82
--- /dev/null
+++ b/MySql/analysis_data.sql
@@ -0,0 +1,45 @@
+/*
+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:45:21
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for analysis_data
+-- ----------------------------
+DROP TABLE IF EXISTS `analysis_data`;
+CREATE TABLE `analysis_data` (
+  `fume_dev_id` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '璁惧缂栧彿',
+  `fume_date` date DEFAULT NULL,
+  `fume_day_min` double(8,2) DEFAULT NULL COMMENT '鎺掔儫娴撳害锛屽崟浣峬g/m^3',
+  `fume_day_max` double(8,2) DEFAULT NULL COMMENT '鎺掔儫娴撳害锛屽崟浣峬g/m^3',
+  `fume_day_average` double(23,2) DEFAULT NULL,
+  `purifier_open_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `fume_minute_exceeding_num` decimal(23,0) DEFAULT NULL,
+  `fume_over_standard_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `fume_data_efficiency` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `daily_online_rate` varchar(29) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_opening_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_exceeding_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
diff --git a/MySql/ea_t_device_info.sql b/MySql/ea_t_device_info.sql
new file mode 100644
index 0000000..e998eeb
--- /dev/null
+++ b/MySql/ea_t_device_info.sql
@@ -0,0 +1,41 @@
+/*
+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:42:16
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for ea_t_device_info
+-- ----------------------------
+DROP TABLE IF EXISTS `ea_t_device_info`;
+CREATE TABLE `ea_t_device_info` (
+  `DI_GUID` varchar(16) NOT NULL,
+  `DI_Code` varchar(50) DEFAULT NULL,
+  `DI_Name` varchar(255) DEFAULT NULL COMMENT '璁惧鍚嶇О',
+  `DI_Device_Type_Id` int DEFAULT NULL,
+  `DI_Device_Type` varchar(50) DEFAULT NULL,
+  `DI_Scene_Type_Id` int DEFAULT NULL,
+  `DI_Scene_Type` varchar(50) DEFAULT NULL,
+  `DI_Province_Code` varchar(50) DEFAULT NULL,
+  `DI_Province_Name` varchar(50) DEFAULT NULL,
+  `DI_City_Code` varchar(50) DEFAULT NULL,
+  `DI_City_Name` varchar(50) DEFAULT NULL,
+  `DI_District_Code` varchar(50) DEFAULT NULL,
+  `DI_District_Name` varchar(50) DEFAULT NULL,
+  `DI_Town_Code` varchar(50) DEFAULT NULL,
+  `DI_Town_Name` varchar(50) DEFAULT NULL,
+  `DI_Supplier` varchar(255) DEFAULT NULL COMMENT '渚涘簲鍟�',
+  `DI_Online` bit(1) DEFAULT NULL COMMENT '鏄惁鍦ㄧ嚎',
+  PRIMARY KEY (`DI_GUID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
diff --git a/MySql/ed_data.sql b/MySql/ed_data.sql
new file mode 100644
index 0000000..77a6c3d
--- /dev/null
+++ b/MySql/ed_data.sql
@@ -0,0 +1,39 @@
+/*
+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:45:29
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for ed_data
+-- ----------------------------
+DROP TABLE IF EXISTS `ed_data`;
+CREATE TABLE `ed_data` (
+  `id` int NOT NULL AUTO_INCREMENT COMMENT '搴忓彿',
+  `provider` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '渚涘簲鍟�',
+  `shop_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '椁愰ギ搴�',
+  `equipment_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '璁惧缂栧彿',
+  `equipment_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '璁惧鍚嶇О',
+  `smoke_push_density` double(8,0) DEFAULT NULL COMMENT '绂佺儫娴撳害锛屽崟浣峬g/m^3',
+  `smoke_pop_density` double(8,2) DEFAULT NULL COMMENT '鎺掔儫娴撳害锛屽崟浣峬g/m^3',
+  `wind_turbine` double(8,2) DEFAULT NULL COMMENT '椋庢満鐢�,鍗曚綅A',
+  `purifier` double(8,2) DEFAULT NULL COMMENT '鍑�鍖栧櫒锛屽崟浣岮',
+  `level` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '绾у埆',
+  `alarm_required` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '闇�鎶ヨ',
+  `alarm_triggered` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '宸叉姤璀�',
+  `attribution_time` datetime DEFAULT NULL COMMENT '褰掑睘鏃堕棿锛屾瘡10鍒嗛挓涓�娈�',
+  `reporting_time` datetime DEFAULT NULL COMMENT '涓婃姤鏃堕棿',
+  `data_time` datetime DEFAULT NULL COMMENT '鏁版嵁鏃堕棿',
+  PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB AUTO_INCREMENT=36751 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
diff --git a/MySql/exceeding_st_data.sql b/MySql/exceeding_st_data.sql
new file mode 100644
index 0000000..4b55c67
--- /dev/null
+++ b/MySql/exceeding_st_data.sql
@@ -0,0 +1,41 @@
+/*
+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:42:40
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for exceeding_st_data
+-- ----------------------------
+DROP TABLE IF EXISTS `exceeding_st_data`;
+CREATE TABLE `exceeding_st_data` (
+  `MV_ID` int NOT NULL AUTO_INCREMENT,
+  `MV_Stat_Code` varchar(50) DEFAULT NULL COMMENT '璁惧缂栧彿',
+  `MV_Create_Time` datetime DEFAULT NULL COMMENT '涓婃姤鏃堕棿',
+  `MV_Data_Time` datetime DEFAULT NULL COMMENT '褰掑睘鏃堕棿',
+  `MV_Power_On_Time` datetime DEFAULT NULL COMMENT '寮�鏈烘椂闂�',
+  `MV_Recent_Down_Time` datetime DEFAULT NULL COMMENT '鏈�杩戝叧鏈烘椂闂�',
+  `MV_signal` double(6,0) DEFAULT NULL,
+  `MV_Fan_Status` bit(1) DEFAULT NULL COMMENT '椋庢満寮�鍏崇姸鎬�',
+  `MV_Purifier_Status` bit(1) DEFAULT NULL COMMENT '鍑�鍖栧櫒寮�鍏崇姸鎬�',
+  `MV_Fan_Electricity` double(8,2) DEFAULT NULL COMMENT '椋庢満鐢垫祦',
+  `MV_Purifier_Electricity` double(8,2) DEFAULT NULL COMMENT '鍑�鍖栧櫒鐢垫祦',
+  `MV_Fume_Concentration` double(8,2) DEFAULT NULL COMMENT '杩涙补鐑熸祿搴﹀��',
+  `MV_Fume_Concentration2` double(8,2) DEFAULT NULL COMMENT '鎺掓补鐑熸祿搴﹀�硷紙鍚庯級',
+  `MV_PM` double(8,2) DEFAULT NULL COMMENT '棰楃矑鐗╋紙姘旀憾鑳讹級',
+  `MV_NMHC` double(8,2) DEFAULT NULL COMMENT '闈炵敳鐑锋�荤儍',
+  `MV_Upload` bit(1) DEFAULT NULL COMMENT '鏄惁涓婁紶',
+  PRIMARY KEY (`MV_ID`),
+  KEY `MV_Stat_Code` (`MV_Stat_Code`)
+) ENGINE=InnoDB AUTO_INCREMENT=1052 DEFAULT CHARSET=utf8mb3;
diff --git a/MySql/fd_t_minutevalue.sql b/MySql/fd_t_minutevalue.sql
new file mode 100644
index 0000000..60b93fb
--- /dev/null
+++ b/MySql/fd_t_minutevalue.sql
@@ -0,0 +1,41 @@
+/*
+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:42:52
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for fd_t_minutevalue
+-- ----------------------------
+DROP TABLE IF EXISTS `fd_t_minutevalue`;
+CREATE TABLE `fd_t_minutevalue` (
+  `MV_ID` int NOT NULL AUTO_INCREMENT,
+  `MV_Stat_Code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '璁惧缂栧彿',
+  `MV_Create_Time` datetime DEFAULT NULL COMMENT '涓婃姤鏃堕棿',
+  `MV_Data_Time` datetime DEFAULT NULL COMMENT '褰掑睘鏃堕棿',
+  `MV_Power_On_Time` datetime DEFAULT NULL COMMENT '寮�鏈烘椂闂�',
+  `MV_Recent_Down_Time` datetime DEFAULT NULL COMMENT '鏈�杩戝叧鏈烘椂闂�',
+  `MV_signal` double(6,0) DEFAULT NULL,
+  `MV_Fan_Status` bit(1) DEFAULT NULL COMMENT '椋庢満寮�鍏崇姸鎬�',
+  `MV_Purifier_Status` bit(1) DEFAULT NULL COMMENT '鍑�鍖栧櫒寮�鍏崇姸鎬�',
+  `MV_Fan_Electricity` double(8,2) DEFAULT NULL COMMENT '椋庢満鐢垫祦',
+  `MV_Purifier_Electricity` double(8,2) DEFAULT NULL COMMENT '鍑�鍖栧櫒鐢垫祦',
+  `MV_Fume_Concentration` double(8,2) DEFAULT NULL COMMENT '杩涙补鐑熸祿搴﹀��',
+  `MV_Fume_Concentration2` double(8,2) DEFAULT NULL COMMENT '鎺掓补鐑熸祿搴﹀�硷紙鍚庯級',
+  `MV_PM` double(8,2) DEFAULT NULL COMMENT '棰楃矑鐗╋紙姘旀憾鑳讹級',
+  `MV_NMHC` double(8,2) DEFAULT NULL COMMENT '闈炵敳鐑锋�荤儍',
+  `MV_Upload` bit(1) DEFAULT NULL COMMENT '鏄惁涓婁紶',
+  PRIMARY KEY (`MV_ID`),
+  KEY `MV_Stat_Code` (`MV_Stat_Code`)
+) ENGINE=InnoDB AUTO_INCREMENT=27529 DEFAULT CHARSET=utf8mb3;
diff --git a/MySql/fm_web_analysis_data.sql b/MySql/fm_web_analysis_data.sql
new file mode 100644
index 0000000..6401e75
--- /dev/null
+++ b/MySql/fm_web_analysis_data.sql
@@ -0,0 +1,45 @@
+/*
+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:45:51
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for fm_web_analysis_data
+-- ----------------------------
+DROP TABLE IF EXISTS `fm_web_analysis_data`;
+CREATE TABLE `fm_web_analysis_data` (
+  `fume_dev_id` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '璁惧缂栧彿',
+  `fume_date` date DEFAULT NULL,
+  `fume_day_min` double(8,2) DEFAULT NULL COMMENT '鎺掔儫娴撳害锛屽崟浣峬g/m^3',
+  `fume_day_max` double(8,2) DEFAULT NULL COMMENT '鎺掔儫娴撳害锛屽崟浣峬g/m^3',
+  `fume_day_average` double(23,2) DEFAULT NULL,
+  `purifier_open_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `fume_minute_exceeding_num` decimal(23,0) DEFAULT NULL,
+  `fume_over_standard_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `fume_data_efficiency` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `daily_online_rate` varchar(29) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_online_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night__valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_valid_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_opening_count` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_opening_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `noon_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `night_exceeding_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
+  `key_exceeding_rate` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
diff --git a/MySql/shopname_data.sql b/MySql/shopname_data.sql
new file mode 100644
index 0000000..629ee04
--- /dev/null
+++ b/MySql/shopname_data.sql
@@ -0,0 +1,44 @@
+/*
+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', '娉夌洓椁愰ギ锛堜笂娴凤級鏈夐檺鍏徃锛堥鍏跺锛�');

--
Gitblit v1.9.3