001.# Dump of table Product_A
002.#
003.
004.DROP TABLE IF EXISTS `Product_A`;
005.
006.CREATE TABLE `Product_A` (
007. `DATE` date DEFAULT NULL,
008. `Emp_ID` varchar(255) DEFAULT NULL,
009. `Revenue` int(11) DEFAULT NULL,
010. `Unit` varchar(255) DEFAULT NULL
011.) ENGINE=InnoDB DEFAULT CHARSET=utf8;
012.
013.LOCK TABLES `Product_A` WRITE;
014./*!40000 ALTER TABLE `Product_A` DISABLE KEYS */;
015.
016.INSERT INTO `Product_A` (`DATE`, `Emp_ID`, `Revenue`, `Unit`)
017.VALUES
018. ('2021-05-04','B',2500,'2\r'),
019. ('2021-05-04','C',1200,'1\r'),
020. ('2021-05-04','A',6000,'5\r'),
021. ('2021-05-04','E',7500,'8\r'),
022. ('2021-05-04','A',9250,'10\r'),
023. ('2021-05-04','F',11230,'1\r'),
024. ('2021-05-04','C',13210,'6\r'),
025. ('2021-05-05','D',15190,'8\r'),
026. ('2021-05-05','B',17170,'6\r'),
027. ('2021-05-05','C',19150,'12\r'),
028. ('2021-05-05','A',21130,'2\r'),
029. ('2021-05-05','E',23110,'8\r'),
030. ('2021-05-05','A',25090,'5\r'),
031. ('2021-05-05','F',27070,'8\r'),
032. ('2021-05-06','C',29050,'10\r'),
033. ('2021-05-06','D',31030,'1\r'),
034. ('2021-05-06','B',33010,'6\r'),
035. ('2021-05-06','C',34990,'8\r'),
036. ('2021-05-06','A',36970,'10');
037.
038./*!40000 ALTER TABLE `Product_A` ENABLE KEYS */;
039.UNLOCK TABLES;
040.
041.
042.# Dump of table Product_B
043.#
044.
045.DROP TABLE IF EXISTS `Product_B`;
046.
047.CREATE TABLE `Product_B` (
048. `DATE` date DEFAULT NULL,
049. `Emp_ID` varchar(255) DEFAULT NULL,
050. `Revenue` int(11) DEFAULT NULL,
051. `Unit` varchar(255) DEFAULT NULL
052.) ENGINE=InnoDB DEFAULT CHARSET=utf8;
053.
054.LOCK TABLES `Product_B` WRITE;
055./*!40000 ALTER TABLE `Product_B` DISABLE KEYS */;
056.
057.INSERT INTO `Product_B` (`DATE`, `Emp_ID`, `Revenue`, `Unit`)
058.VALUES
059. ('2021-05-04','B',2500,'2\r'),
060. ('2021-05-04','C',1200,'1\r'),
061. ('2021-05-04','A',6000,'5\r'),
062. ('2021-05-04','E',7500,'8\r'),
063. ('2021-05-04','A',9250,'10\r'),
064. ('2021-05-04','F',11230,'1\r'),
065. ('2021-05-04','C',13210,'6\r'),
066. ('2021-05-05','B',15190,'8\r'),
067. ('2021-05-05','B',17170,'6\r'),
068. ('2021-05-05','C',19150,'12\r'),
069. ('2021-05-05','A',21130,'2\r'),
070. ('2021-05-05','E',23110,'8\r'),
071. ('2021-05-05','A',25090,'5\r'),
072. ('2021-05-05','F',27070,'8\r'),
073. ('2021-05-06','C',29050,'10\r'),
074. ('2021-05-06','B',31030,'1\r'),
075. ('2021-05-06','B',33010,'6\r'),
076. ('2021-05-06','C',34990,'8\r'),
077. ('2021-05-06','A',36970,'10');
078.
079./*!40000 ALTER TABLE `Product_B` ENABLE KEYS */;
080.UNLOCK TABLES;
081.
082.
083.# Dump of table Product_C
084.#
085.
086.DROP TABLE IF EXISTS `Product_C`;
087.
088.CREATE TABLE `Product_C` (
089. `DATE` date DEFAULT NULL,
090. `Emp_ID` varchar(255) DEFAULT NULL,
091. `Revenue` int(11) DEFAULT NULL,
092. `Unit` varchar(255) DEFAULT NULL
093.) ENGINE=InnoDB DEFAULT CHARSET=utf8;
094.
095.LOCK TABLES `Product_C` WRITE;
096./*!40000 ALTER TABLE `Product_C` DISABLE KEYS */;
097.
098.INSERT INTO `Product_C` (`DATE`, `Emp_ID`, `Revenue`, `Unit`)
099.VALUES
100. ('2021-05-04','B',2500,'2\r'),
101. ('2021-05-04','C',1200,'1\r'),
102. ('2021-05-04','A',6000,'5\r'),
103. ('2021-05-04','E',7500,'8\r'),
104. ('2021-05-04','A',9250,'10\r'),
105. ('2021-05-04','D',11230,'1\r'),
106. ('2021-05-04','C',13210,'6\r'),
107. ('2021-05-05','B',15190,'8\r'),
108. ('2021-05-05','B',17170,'6\r'),
109. ('2021-05-05','C',19150,'12\r'),
110. ('2021-05-05','A',21130,'2\r'),
111. ('2021-05-05','E',23110,'8\r'),
112. ('2021-05-05','A',25090,'5\r'),
113. ('2021-05-05','D',27070,'8\r'),
114. ('2021-05-06','C',29050,'10\r'),
115. ('2021-05-06','B',31030,'1\r'),
116. ('2021-05-06','B',33010,'6\r'),
117. ('2021-05-06','C',34990,'8\r'),
118. ('2021-05-06','A',36970,'10');
119.
120./*!40000 ALTER TABLE `Product_C` ENABLE KEYS */;
121.UNLOCK TABLES;
122.
123.
124.# Dump of table StaffInfo
125.#
126.
127.DROP TABLE IF EXISTS `StaffInfo`;
128.
129.CREATE TABLE `StaffInfo` (
130. `Emp_ID` varchar(255) DEFAULT NULL,
131. `Emp_Name` varchar(255) DEFAULT NULL,
132. `Emp_Type` varchar(255) DEFAULT NULL,
133. `Shop_code` varchar(255) DEFAULT NULL
134.) ENGINE=InnoDB DEFAULT CHARSET=utf8;
135.
136.LOCK TABLES `StaffInfo` WRITE;
137./*!40000 ALTER TABLE `StaffInfo` DISABLE KEYS */;
138.
139.INSERT INTO `StaffInfo` (`Emp_ID`, `Emp_Name`, `Emp_Type`, `Shop_code`)
140.VALUES
141. ('A','เอกราช','Sales_A','301\r'),
142. ('B','อภิวิชย์','Sales_A','401\r'),
143. ('C','อนุศร','Sales_C','201\r'),
144. ('D','นุเทพ','Sales_B','101\r'),
145. ('E','ธนากร','Sales_A','101\r'),
146. ('F','บรรพต','Sales_B','201');
147.
148./*!40000 ALTER TABLE `StaffInfo` ENABLE KEYS */;
149.UNLOCK TABLES;
