-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Nov 29, 2020 at 03:35 AM -- Server version: 10.4.6-MariaDB -- PHP Version: 7.3.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `minipos_sunshine` -- -- -------------------------------------------------------- -- -- Table structure for table `category_master` -- CREATE TABLE `category_master` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Active` enum('0','1') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `customer_group` -- CREATE TABLE `customer_group` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Group_Name` varchar(50) NOT NULL, `Remark` varchar(255) NOT NULL, `Active` enum('1','0') NOT NULL, `Cust_Num` int(50) NOT NULL DEFAULT 0, `Cust_List` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]', `Default_Item` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `customer_group` -- INSERT INTO `customer_group` (`Col_Num`, `ID`, `Group_Name`, `Remark`, `Active`, `Cust_Num`, `Cust_List`, `Default_Item`) VALUES (1, 'CG000001', '傳統舞蹈', 'for test only', '1', 0, '[\"3\",\"2\"]', '1'), (2, 'cg000002', 'Hip Hop', '', '1', 0, '[\"2\",\"3\"]', '3'), (3, 'cg000003', '芭蕾', '', '1', 0, '[]', '2'); -- -------------------------------------------------------- -- -- Table structure for table `customer_info` -- CREATE TABLE `customer_info` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Phone` varchar(50) DEFAULT NULL, `Birthday` date DEFAULT NULL, `Joined_Date` date DEFAULT NULL, `Full_Data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL ) ; -- -- Dumping data for table `customer_info` -- INSERT INTO `customer_info` (`Col_Num`, `ID`, `Name`, `Phone`, `Birthday`, `Joined_Date`, `Full_Data`, `Active`, `Emergency_Phone`, `Username`, `Password`, `In_Group`) VALUES (2, 'cust000001', '小三', '', '0000-00-00', '0000-00-00', '[{\"IC\":\"\",\"Address\":\"\",\"Email\":\"\"}]', '1', '', 'cust1', 'cust1', '[\"1\",\"2\"]'), (3, 'cust000003', '隔壁老王', '', '0000-00-00', '0000-00-00', '[{\"IC\":\"\",\"Address\":\"\",\"Email\":\"\"}]', '1', '', 'cust2', 'cust2', '[\"1\",\"2\"]'); -- -------------------------------------------------------- -- -- Table structure for table `item_master` -- CREATE TABLE `item_master` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Type` enum('s','i') NOT NULL, `Stock_Count` enum('1','0') NOT NULL, `Default_Selling_Price` decimal(50,2) NOT NULL, `Default_UOM` varchar(50) NOT NULL DEFAULT '''unit''', `Multi_UOM` enum('1','0') NOT NULL, `Selling_UOM_Price_Json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `Active` enum('1','0') NOT NULL, `Pricing_Type` enum('s','m','o') NOT NULL, `Category_Group` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ) ; -- -- Dumping data for table `item_master` -- INSERT INTO `item_master` (`Col_Num`, `ID`, `Name`, `Type`, `Stock_Count`, `Default_Selling_Price`, `Default_UOM`, `Multi_UOM`, `Selling_UOM_Price_Json`, `Active`, `Pricing_Type`, `Category_Group`) VALUES (1, 'itm-000001', '傳統舞蹈學費', 's', '0', '100.00', 'unit', '0', '100.00', '1', 's', NULL), (2, 'itm-000002', '芭蕾舞學費', 's', '0', '150.00', 'unit', '0', '150', '1', 's', NULL), (3, 'itm-000003', 'Hip Hop 學費', 's', '0', '100.00', 'unit', '0', '100.00', '1', 's', NULL), (4, 'itm-000004', '3 個月 學費', 's', '0', '0.00', 'unit', '0', NULL, '1', 'o', NULL); -- -------------------------------------------------------- -- -- Table structure for table `menu_group` -- CREATE TABLE `menu_group` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Remark` varchar(50) DEFAULT NULL, `Active` enum('1','0') NOT NULL, `Menu_Item` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `menu_group` -- INSERT INTO `menu_group` (`Col_Num`, `ID`, `Name`, `Remark`, `Active`, `Menu_Item`) VALUES (1, 'MG000001', 'Menu 1', 'for menu 1', '1', '[\"4\",\"3\",\"2\",\"1\"]'); -- -------------------------------------------------------- -- -- Table structure for table `resit_setting` -- CREATE TABLE `resit_setting` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Header1` varchar(50) NOT NULL, `Header2` varchar(50) NOT NULL, `Header3` varchar(50) NOT NULL, `Header4` varchar(50) NOT NULL, `Footer1` varchar(50) NOT NULL, `Footer2` varchar(50) NOT NULL, `Active` enum('0','1') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `resit_setting` -- INSERT INTO `resit_setting` (`Col_Num`, `ID`, `Name`, `Header1`, `Header2`, `Header3`, `Header4`, `Footer1`, `Footer2`, `Active`) VALUES (1, 'resit1', '默認', 'Sunshine ', 'address1', 'address2', 'address3', 'footer1', 'footer2', '1'); -- -------------------------------------------------------- -- -- Table structure for table `sales_dtl` -- CREATE TABLE `sales_dtl` ( `Col_Num` bigint(20) NOT NULL, `Doc_Num` varchar(50) NOT NULL, `Hdr_ID` varchar(50) NOT NULL, `Item_ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Price` decimal(50,2) NOT NULL, `Date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `sales_dtl` -- INSERT INTO `sales_dtl` (`Col_Num`, `Doc_Num`, `Hdr_ID`, `Item_ID`, `Name`, `Price`, `Date`) VALUES (1, 'ter1-201121-0008', 'mdtl2011217HVG', '2', 'item 2', '2.00', '2020-11-21 12:56:06'), (2, 'ter1-201121-0009', 'mdtl201121SQ45', '2', 'item 2', '2.00', '2020-11-21 16:34:53'), (3, 'ter1-201121-0010', 'mdtl201121YSG3', '2', 'item 2', '2.00', '2020-11-21 16:46:23'), (4, 'ter1-201121-0001', 'mdtl2011211E2M', '2', 'item 2', '2.00', '2020-11-21 11:23:19'), (5, 'ter1-201121-0002', 'mdtl20112127DX', '2', 'item 2', '2.00', '2020-11-21 11:24:47'), (6, 'ter1-201121-0003', 'mdtl201121G608', '2', 'item 2', '2.00', '2020-11-21 11:28:12'), (7, 'ter1-201121-0004', 'mdtl201121MZU2', '2', 'item 2', '2.00', '2020-11-21 11:29:02'), (8, 'ter1-201121-0005', 'mdtl20112164S1', '2', 'item 2', '2.00', '2020-11-21 11:30:09'), (9, 'ter1-201121-0006', 'mdtl201121KWZL', '2', 'item 2', '2.00', '2020-11-21 11:31:23'), (10, 'ter1-201121-0007', 'mdtl201121F1LK', '2', 'item 2', '2.00', '2020-11-21 11:34:43'), (11, 'ter1-201125-0001', 'mdtl201125K1V7', '1', '傳統舞蹈學費', '100.00', '2020-11-25 21:26:35'), (12, 'ter1-201125-0001', 'mdtl201125K1V7', '2', '芭蕾舞學費', '150.00', '2020-11-25 21:26:35'), (13, 'ter1-201126-0001', 'mdtl201126N15W', '1', '傳統舞蹈學費', '100.00', '2020-11-26 21:28:47'), (14, 'ter1-201126-0001', 'mdtl201126N15W', '2', '芭蕾舞學費', '150.00', '2020-11-26 21:28:47'); -- -------------------------------------------------------- -- -- Table structure for table `sales_hdr` -- CREATE TABLE `sales_hdr` ( `Col_Num` bigint(20) NOT NULL, `Doc_Num` varchar(50) NOT NULL, `Hdr_ID` varchar(50) NOT NULL, `Cust_ID` varchar(50) NOT NULL, `Payment_Method` varchar(50) NOT NULL DEFAULT 'cash', `Ref_No` varchar(50) DEFAULT NULL, `Final_Amt` decimal(50,2) NOT NULL, `Ex_Round` decimal(50,2) NOT NULL, `Total_Round` decimal(50,2) NOT NULL, `Dtl_Json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL ) ; -- -- Dumping data for table `sales_hdr` -- INSERT INTO `sales_hdr` (`Col_Num`, `Doc_Num`, `Hdr_ID`, `Cust_ID`, `Payment_Method`, `Ref_No`, `Final_Amt`, `Ex_Round`, `Total_Round`, `Dtl_Json`, `Sales_Date`, `Sales_Person`, `Void`, `Void_Data`, `Terminal_ID`, `Remark`) VALUES (4, 'ter1-201121-0008', 'mdtl2011217HVG', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl2011217HVG\",\"Doc_Num\":\"ter1-201121-0008\",\"Sales_Date\":\"2020-11-21 12:56:06\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 12:56:06\"}]', '2020-11-21 12:56:06', '2', '1', '[{\"Reason\":\"test\",\"Void_By\":\"3\",\"Void_Date\":\"2020-11-23\"}]', '1', NULL), (5, 'ter1-201121-0009', 'mdtl201121SQ45', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121SQ45\",\"Doc_Num\":\"ter1-201121-0009\",\"Sales_Date\":\"2020-11-21 16:34:53\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 16:34:53\"}]', '2020-11-21 16:34:53', '2', '0', NULL, '1', NULL), (6, 'ter1-201121-0010', 'mdtl201121YSG3', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121YSG3\",\"Doc_Num\":\"ter1-201121-0010\",\"Sales_Date\":\"2020-11-21 16:46:23\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 16:46:23\"}]', '2020-11-21 16:46:23', '2', '0', NULL, '1', NULL), (7, 'ter1-201121-0001', 'mdtl2011211E2M', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl2011211E2M\",\"Doc_Num\":\"ter1-201121-0001\",\"Sales_Date\":\"2020-11-21 11:23:19\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:23:19\"}]', '2020-11-21 11:23:19', '2', '0', NULL, '1', NULL), (8, 'ter1-201121-0002', 'mdtl20112127DX', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl20112127DX\",\"Doc_Num\":\"ter1-201121-0002\",\"Sales_Date\":\"2020-11-21 11:24:47\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:24:47\"}]', '2020-11-21 11:24:47', '2', '0', NULL, '1', NULL), (9, 'ter1-201121-0003', 'mdtl201121G608', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121G608\",\"Doc_Num\":\"ter1-201121-0003\",\"Sales_Date\":\"2020-11-21 11:28:12\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:28:12\"}]', '2020-11-21 11:28:12', '2', '0', NULL, '1', NULL), (10, 'ter1-201121-0004', 'mdtl201121MZU2', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121MZU2\",\"Doc_Num\":\"ter1-201121-0004\",\"Sales_Date\":\"2020-11-21 11:29:02\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:29:02\"}]', '2020-11-21 11:29:02', '2', '0', NULL, '1', NULL), (11, 'ter1-201121-0005', 'mdtl20112164S1', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl20112164S1\",\"Doc_Num\":\"ter1-201121-0005\",\"Sales_Date\":\"2020-11-21 11:30:09\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:30:09\"}]', '2020-11-21 11:30:09', '2', '0', NULL, '1', NULL), (12, 'ter1-201121-0006', 'mdtl201121KWZL', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121KWZL\",\"Doc_Num\":\"ter1-201121-0006\",\"Sales_Date\":\"2020-11-21 11:31:23\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:31:23\"}]', '2020-11-21 11:31:23', '2', '0', NULL, '1', NULL), (13, 'ter1-201121-0007', 'mdtl201121F1LK', '2', '1', '', '2.00', '2.00', '0.00', '[{\"ID\":\"mdtl201121F1LK\",\"Doc_Num\":\"ter1-201121-0007\",\"Sales_Date\":\"2020-11-21 11:34:43\",\"Product\":\"2\",\"Name\":\"item 2\",\"Price\":2,\"Date\":\"2020-11-21 11:34:43\"}]', '2020-11-21 11:34:43', '2', '0', NULL, '1', NULL), (14, 'ter1-201125-0001', 'mdtl201125K1V7', '2', '1', '', '250.00', '250.00', '0.00', '[{\"ID\":\"mdtl201125K1V7\",\"Doc_Num\":\"ter1-201125-0001\",\"Sales_Date\":\"2020-11-25 21:26:35\",\"Product\":\"1\",\"Name\":\"傳統舞蹈學費\",\"Price\":100,\"Date\":\"2020-11-25 21:26:35\"},{\"ID\":\"mdtl201125K1V7\",\"Doc_Num\":\"ter1-201125-0001\",\"Sales_Date\":\"2020-11-25 21:26:35\",\"Product\":\"2\",\"Name\":\"芭蕾舞學費\",\"Price\":150,\"Date\":\"2020-11-25 21:26:35\"}]', '2020-11-25 21:26:35', '2', '0', '[]', '1', '2020 11'), (15, 'ter1-201126-0001', 'mdtl201126N15W', '2', '1', '', '250.00', '250.00', '0.00', '[{\"ID\":\"mdtl201126N15W\",\"Doc_Num\":\"ter1-201126-0001\",\"Sales_Date\":\"2020-11-26 21:28:47\",\"Product\":\"1\",\"Name\":\"傳統舞蹈學費\",\"Price\":100,\"Date\":\"2020-11-26 21:28:47\"},{\"ID\":\"mdtl201126N15W\",\"Doc_Num\":\"ter1-201126-0001\",\"Sales_Date\":\"2020-11-26 21:28:47\",\"Product\":\"2\",\"Name\":\"芭蕾舞學費\",\"Price\":150,\"Date\":\"2020-11-26 21:28:47\"}]', '2020-11-26 21:28:47', '2', '0', '[]', '1', '2020 11'); -- -------------------------------------------------------- -- -- Table structure for table `shop_info` -- CREATE TABLE `shop_info` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Business_Code` varchar(50) NOT NULL, `Address` varchar(50) NOT NULL, `Phone` varchar(50) NOT NULL, `Resit_Setting` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL ) ; -- -- Dumping data for table `shop_info` -- INSERT INTO `shop_info` (`Col_Num`, `ID`, `Name`, `Business_Code`, `Address`, `Phone`, `Resit_Setting`, `Finance_Date`, `HQ`, `Active`) VALUES (1, '', 'Sunshine', '', '', '', '1', '2020-11-22', '1', '1'); -- -------------------------------------------------------- -- -- Table structure for table `staff_info` -- CREATE TABLE `staff_info` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Username` varchar(50) NOT NULL, `Password` varchar(50) NOT NULL, `Active` enum('1','0') NOT NULL, `Full_Data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `System_Admin` enum('0','1') NOT NULL DEFAULT '0', `Pos_Pass` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `staff_info` -- INSERT INTO `staff_info` (`Col_Num`, `ID`, `Name`, `Username`, `Password`, `Active`, `Full_Data`, `System_Admin`, `Pos_Pass`) VALUES (1, 'system', 'System', 'system', 'system', '1', NULL, '1', '0001'), (2, 's000001', 'Jensen', 'jensen', '1234', '1', '[{\"IC\":\"\",\"Passport\":\"\",\"Foreigner_Worker\":0,\"Permit_Expired\":\"\",\"Email\":\"\"}]', '0', '1234'), (3, 's000002', 'Admin', 'admin', 'admin', '1', '[{\"IC\":\"\",\"Passport\":\"\",\"Foreigner_Worker\":0,\"Permit_Expired\":\"\",\"Email\":\"\"}]', '0', '0000'); -- -------------------------------------------------------- -- -- Table structure for table `terminal_info` -- CREATE TABLE `terminal_info` ( `Col_Num` bigint(20) NOT NULL, `ID` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Shop` varchar(50) NOT NULL, `Passcode` varchar(50) NOT NULL, `Menu` varchar(50) NOT NULL, `Active` enum('1','0') NOT NULL, `Resit_Setting` varchar(50) NOT NULL, `Resit_Prefix` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `terminal_info` -- INSERT INTO `terminal_info` (`Col_Num`, `ID`, `Name`, `Shop`, `Passcode`, `Menu`, `Active`, `Resit_Setting`, `Resit_Prefix`) VALUES (1, 'terminal1', 'Terminal 1', '1', 'abc123', '1', '1', '', 'ter1-'); -- -- Indexes for dumped tables -- -- -- Indexes for table `category_master` -- ALTER TABLE `category_master` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `customer_group` -- ALTER TABLE `customer_group` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `menu_group` -- ALTER TABLE `menu_group` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `resit_setting` -- ALTER TABLE `resit_setting` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `sales_dtl` -- ALTER TABLE `sales_dtl` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `staff_info` -- ALTER TABLE `staff_info` ADD PRIMARY KEY (`Col_Num`); -- -- Indexes for table `terminal_info` -- ALTER TABLE `terminal_info` ADD PRIMARY KEY (`Col_Num`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `category_master` -- ALTER TABLE `category_master` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customer_group` -- ALTER TABLE `customer_group` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `customer_info` -- ALTER TABLE `customer_info` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `item_master` -- ALTER TABLE `item_master` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `menu_group` -- ALTER TABLE `menu_group` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `resit_setting` -- ALTER TABLE `resit_setting` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sales_dtl` -- ALTER TABLE `sales_dtl` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sales_hdr` -- ALTER TABLE `sales_hdr` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shop_info` -- ALTER TABLE `shop_info` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `staff_info` -- ALTER TABLE `staff_info` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `terminal_info` -- ALTER TABLE `terminal_info` MODIFY `Col_Num` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;