-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 03, 2023 at 12:53 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.1.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `clearmov_clearmoves`
--

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `cid` int(11) NOT NULL,
  `ccode` varchar(200) NOT NULL,
  `categorytype` varchar(255) NOT NULL,
  `categorydes` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cid`, `ccode`, `categorytype`, `categorydes`) VALUES
(1, '1122', 'FOOD ITEMS', ''),
(2, '1123', 'AAA', ''),
(3, '1SAS', 'PENASAS', '');

-- --------------------------------------------------------

--
-- Table structure for table `employee_info`
--

CREATE TABLE `employee_info` (
  `empcode` varchar(200) NOT NULL,
  `emppass` varchar(200) NOT NULL,
  `designationcode` varchar(200) NOT NULL,
  `designation` varchar(200) NOT NULL,
  `empname` varchar(500) NOT NULL,
  `department` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employee_info`
--

INSERT INTO `employee_info` (`empcode`, `emppass`, `designationcode`, `designation`, `empname`, `department`) VALUES
('23623', '1122', 'CEO01', 'CEO/Directors', '', ''),
('23624', '1122', 'MG02', 'Manager', 'Abubakar', ''),
('23625', '1122', 'SF03', 'Staff', 'Rana Marwat Hussain', ''),
('23626', '1122', 'SP04', 'SpecialStaff', 'Manan Butt', '');

-- --------------------------------------------------------

--
-- Table structure for table `itemactivityreport`
--

CREATE TABLE `itemactivityreport` (
  `aid` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL,
  `icat` varchar(255) DEFAULT NULL,
  `ccode` varchar(255) DEFAULT NULL,
  `vcode` varchar(255) DEFAULT NULL,
  `vname` varchar(255) DEFAULT NULL,
  `lcode` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `recorddescription` varchar(255) DEFAULT NULL,
  `reqdate` datetime(6) DEFAULT NULL,
  `rq` varchar(255) DEFAULT NULL,
  `iq` varchar(255) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `itemactivityreport`
--

INSERT INTO `itemactivityreport` (`aid`, `icode`, `iname`, `icat`, `ccode`, `vcode`, `vname`, `lcode`, `lname`, `recorddescription`, `reqdate`, `rq`, `iq`, `balance`) VALUES
(1, 'FO2034', 'TEA', '1122-FOOD ITEMS', '1', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', 'Added Against MRN#1', '2023-03-01 13:31:34.000000', '4000', '-', '4000'),
(2, 'FO2034', 'TEA', '1122-FOOD ITEMS', '1', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', 'Issued Against RN#1', '2023-03-01 13:32:44.000000', '-', '1000', '3000'),
(3, 'FO2034', 'TEA', '1122-FOOD ITEMS', '1', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', 'Returned From Finance Dep Against RN#1', '2023-03-01 13:33:16.000000', '500', '-', '3500'),
(4, 'FO2034', 'TEA', '1122-FOOD ITEMS', '1', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', 'Discarded Items by Inventory Department Against RN#1', '2023-03-01 13:33:46.000000', '-', '500', '3000'),
(5, 'FO2034', 'TEA', '1122-FOOD ITEMS', '1', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', 'Added Against MRN#2', '2023-03-02 13:06:53.000000', '21', '-', '3021'),
(6, '', '', '', '', '', '', '', '', 'Issued Against RN#2', '2023-03-03 12:12:03.000000', '-', '2000', '-2000');

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `iid` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`iid`, `icode`, `iname`) VALUES
(1, 'FO2034', 'TEA'),
(2, 'ASASASA', 'ASASAS');

-- --------------------------------------------------------

--
-- Table structure for table `item_discard`
--

CREATE TABLE `item_discard` (
  `did` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL,
  `lid` varchar(200) NOT NULL,
  `irequired` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `irequestdate` datetime(6) NOT NULL,
  `irequestdepartment` varchar(255) DEFAULT NULL,
  `empname` varchar(255) DEFAULT NULL,
  `irequeststatus` varchar(255) DEFAULT NULL,
  `approveddate` varchar(255) DEFAULT NULL,
  `postrequest` varchar(200) NOT NULL,
  `approvedstatus` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_discard`
--

INSERT INTO `item_discard` (`did`, `icode`, `iname`, `lid`, `irequired`, `reason`, `irequestdate`, `irequestdepartment`, `empname`, `irequeststatus`, `approveddate`, `postrequest`, `approvedstatus`) VALUES
(1, 'FO2034', 'TEA', '1', '500', ' ALL ITEM WERE DAMAGES', '2023-03-01 13:33:43.000000', 'Inventory Department', '23624-Abubakar', 'Approved', '2023-03-01 13:33:46', '1', '1');

-- --------------------------------------------------------

--
-- Table structure for table `item_instock`
--

CREATE TABLE `item_instock` (
  `iid` int(10) NOT NULL,
  `icode` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `iname` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `ides` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `icat` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `cid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `fromvendor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `vid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `tolocation` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `lid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `totalstockbalance` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `item_instock`
--

INSERT INTO `item_instock` (`iid`, `icode`, `iname`, `ides`, `icat`, `cid`, `fromvendor`, `vid`, `tolocation`, `lid`, `totalstockbalance`) VALUES
(1, 'FO2034', 'TEA', 'N/A', '1122-FOOD ITEMS', '1', '1123-TEXTILE3', '1', '1122-GULSHAN E RAVI', '1', '3021');

-- --------------------------------------------------------

--
-- Table structure for table `item_purchaserequest`
--

CREATE TABLE `item_purchaserequest` (
  `prid` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL,
  `lid` varchar(200) NOT NULL,
  `irequired` varchar(255) DEFAULT NULL,
  `irequestdate` datetime(6) NOT NULL,
  `irequestdepartment` varchar(255) DEFAULT NULL,
  `empname` varchar(255) DEFAULT NULL,
  `irequeststatus` varchar(255) DEFAULT NULL,
  `purchaseorder` varchar(200) NOT NULL,
  `purchaseorderdate` varchar(200) NOT NULL,
  `unitprice` varchar(200) NOT NULL,
  `totalcost` varchar(200) NOT NULL,
  `purchaseorderstatus` varchar(200) NOT NULL,
  `approveddate` varchar(255) DEFAULT NULL,
  `postrequest` varchar(200) NOT NULL,
  `approvedstatus` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_purchaserequest`
--

INSERT INTO `item_purchaserequest` (`prid`, `icode`, `iname`, `lid`, `irequired`, `irequestdate`, `irequestdepartment`, `empname`, `irequeststatus`, `purchaseorder`, `purchaseorderdate`, `unitprice`, `totalcost`, `purchaseorderstatus`, `approveddate`, `postrequest`, `approvedstatus`) VALUES
(2, 'FO2034', 'TEA', '3', '6000', '2023-03-03 14:19:03.000000', 'Inventory Department', '23624-Abubakar', 'Approved', '000002', '2023-03-03 15:11:16', '100', '600000', '1', '03-03-23 11:38:51', '1', '1'),
(3, 'FO2034', 'TEA', '1', '100', '2023-03-03 15:39:21.000000', 'Inventory Department', '23624-Abubakar', 'Approved', '000001', '2023-03-03 15:42:56', '10', '1000', '1', '0', '1', '0'),
(4, 'FO2034', 'TEA', '1', '100', '2023-03-03 16:26:55.000000', 'Inventory Department', '23624-Abubakar', 'Approved', '000003', '2023-03-03 16:48:07', '10', '1000', '1', '0', '1', '0');

-- --------------------------------------------------------

--
-- Table structure for table `item_records`
--

CREATE TABLE `item_records` (
  `iid` int(10) NOT NULL,
  `icode` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `iname` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `ides` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `icat` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `cid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `uploaded_on` datetime NOT NULL,
  `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `fromvendor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `vid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `vntn` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `vcontact` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `vstatus` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `tolocation` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `lid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `iquantity` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `iunitprice` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `totalcost` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `paymentstatus` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `idefect` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `iactualquantity` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `mrnstatus` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `minstatus` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `mrncreatedby` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `mincreatedby` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `paymentapprovedby` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `itemcredits` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `idefectremarks` varchar(500) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `item_records`
--

INSERT INTO `item_records` (`iid`, `icode`, `iname`, `ides`, `icat`, `cid`, `file_name`, `uploaded_on`, `status`, `fromvendor`, `vid`, `vntn`, `vcontact`, `vstatus`, `tolocation`, `lid`, `iquantity`, `iunitprice`, `totalcost`, `paymentstatus`, `idefect`, `iactualquantity`, `mrnstatus`, `minstatus`, `mrncreatedby`, `mincreatedby`, `paymentapprovedby`, `itemcredits`, `idefectremarks`) VALUES
(1, 'FO2034', 'TEA', 'N/A', '1122-FOOD ITEMS', '1', '', '2023-03-01 13:30:53', '1', '1123-TEXTILE3', '1', '3520288830643', '03204821306', 'ACTIVE', '1122-GULSHAN E RAVI', '1', '5000', '100', ' 400000', '1', '1000', '4000', '1', '1', '23624-Abubakar', '23624-Abubakar', '23624-Abubakar', 'Item In-Stocked', 'NOT OK'),
(2, 'FO2034', 'TEA', 'N/A', '1122-FOOD ITEMS', '1', 'e16eaab5-2623-418c-9085-03d923f50e47.jpg', '2023-03-02 13:05:47', '1', '1123-TEXTILE3', '1', '3520288830643', '03204821306', 'ACTIVE', '1122-GULSHAN E RAVI', '1', '121', '10', ' 210', '1', '100', '21', '1', '1', '23624-Abubakar', '23624-Abubakar', '23624-Abubakar', 'Item In-Stocked', '21 ARE DEFECTED');

-- --------------------------------------------------------

--
-- Table structure for table `item_requests`
--

CREATE TABLE `item_requests` (
  `rid` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL,
  `lid` varchar(200) NOT NULL,
  `irequired` varchar(255) DEFAULT NULL,
  `iapproved` varchar(255) DEFAULT NULL,
  `irequestdate` datetime(6) NOT NULL,
  `irequestdepartment` varchar(255) DEFAULT NULL,
  `empname` varchar(255) DEFAULT NULL,
  `irequeststatus` varchar(255) DEFAULT NULL,
  `approveddate` varchar(255) DEFAULT NULL,
  `postrequest` varchar(200) NOT NULL,
  `approvedstatus` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_requests`
--

INSERT INTO `item_requests` (`rid`, `icode`, `iname`, `lid`, `irequired`, `iapproved`, `irequestdate`, `irequestdepartment`, `empname`, `irequeststatus`, `approveddate`, `postrequest`, `approvedstatus`) VALUES
(1, 'FO2034', 'TEA', '1', '1000', '1000', '2023-03-01 13:32:30.000000', 'Finance Department', '23624-Abubakar', 'Approved', '2023-03-01 13:32:44', '1', '1'),
(2, 'FO2034', 'TEA', '3', '2000', '2000', '2023-03-03 12:09:58.000000', 'Finance Department', '23624-Abubakar', 'Approved', '2023-03-03 12:12:03', '1', '1'),
(3, 'ASASASA', 'TEA', '3', '3000', '100', '2023-03-03 12:16:25.000000', 'Finance Department', '23624-Abubakar', 'Pending', '0', '1', '0');

-- --------------------------------------------------------

--
-- Table structure for table `item_returnrequests`
--

CREATE TABLE `item_returnrequests` (
  `rrid` int(11) NOT NULL,
  `icode` varchar(255) NOT NULL,
  `iname` varchar(255) DEFAULT NULL,
  `lid` varchar(200) NOT NULL,
  `iused` varchar(255) DEFAULT NULL,
  `iapproved` varchar(255) DEFAULT NULL,
  `ireturn` varchar(200) NOT NULL,
  `irrequestdate` datetime(6) NOT NULL,
  `irrequestdepartment` varchar(255) DEFAULT NULL,
  `empname` varchar(255) DEFAULT NULL,
  `irrequeststatus` varchar(255) DEFAULT NULL,
  `rapproveddate` varchar(255) DEFAULT NULL,
  `rpostrequest` varchar(200) NOT NULL,
  `rapprovedstatus` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_returnrequests`
--

INSERT INTO `item_returnrequests` (`rrid`, `icode`, `iname`, `lid`, `iused`, `iapproved`, `ireturn`, `irrequestdate`, `irrequestdepartment`, `empname`, `irrequeststatus`, `rapproveddate`, `rpostrequest`, `rapprovedstatus`) VALUES
(1, 'FO2034', 'TEA', '1', '500', '1000', '500', '2023-03-01 13:33:05.000000', 'Finance Department', '23624-Abubakar', 'Approved', '2023-03-01 13:33:16', '1', '1');

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `lid` int(11) NOT NULL,
  `lcode` varchar(255) NOT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `ltype` varchar(255) DEFAULT NULL,
  `ldes` varchar(255) DEFAULT NULL,
  `llocation` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`lid`, `lcode`, `lname`, `ltype`, `ldes`, `llocation`) VALUES
(1, '1122', 'GULSHAN E RAVI', '', '', 'first'),
(3, '1233333', 'GULBURG', '', '', 'first'),
(4, 'ASASA11', 'ASASASAS', '', '', 'first');

-- --------------------------------------------------------

--
-- Table structure for table `vendors_info`
--

CREATE TABLE `vendors_info` (
  `vid` int(11) NOT NULL,
  `vcode` varchar(100) NOT NULL,
  `vname` varchar(200) NOT NULL,
  `vemail` varchar(200) NOT NULL,
  `vcontact` varchar(200) NOT NULL,
  `vaddress` varchar(200) NOT NULL,
  `vntn` varchar(200) DEFAULT NULL,
  `vaccountnumber` varchar(200) DEFAULT NULL,
  `vstatus` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vendors_info`
--

INSERT INTO `vendors_info` (`vid`, `vcode`, `vname`, `vemail`, `vcontact`, `vaddress`, `vntn`, `vaccountnumber`, `vstatus`) VALUES
(1, '1123', 'TEXTILE3', 'RANA@GMAIL.COM', '03204821306', 'LHR', '3520288830643', 'PK124579996', 'ACTIVE'),
(2, '2232', 'RANA MARWAT HUSSAIN', '', '12121212121', '', '', '', 'ACTIVE'),
(3, 'UMTSHE1', 'RANA MARWAT HUSSAIN', '', '222222', '', '', '', 'ACTIVE'),
(4, '1124', 'RANA', '', '4545', '', '', '', 'ACTIVE');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `itemactivityreport`
--
ALTER TABLE `itemactivityreport`
  ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`iid`);

--
-- Indexes for table `item_discard`
--
ALTER TABLE `item_discard`
  ADD PRIMARY KEY (`did`);

--
-- Indexes for table `item_purchaserequest`
--
ALTER TABLE `item_purchaserequest`
  ADD PRIMARY KEY (`prid`);

--
-- Indexes for table `item_records`
--
ALTER TABLE `item_records`
  ADD PRIMARY KEY (`iid`);

--
-- Indexes for table `item_requests`
--
ALTER TABLE `item_requests`
  ADD PRIMARY KEY (`rid`);

--
-- Indexes for table `item_returnrequests`
--
ALTER TABLE `item_returnrequests`
  ADD PRIMARY KEY (`rrid`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`lid`);

--
-- Indexes for table `vendors_info`
--
ALTER TABLE `vendors_info`
  ADD PRIMARY KEY (`vid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `itemactivityreport`
--
ALTER TABLE `itemactivityreport`
  MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `iid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `item_discard`
--
ALTER TABLE `item_discard`
  MODIFY `did` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `item_purchaserequest`
--
ALTER TABLE `item_purchaserequest`
  MODIFY `prid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `item_records`
--
ALTER TABLE `item_records`
  MODIFY `iid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `item_requests`
--
ALTER TABLE `item_requests`
  MODIFY `rid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `item_returnrequests`
--
ALTER TABLE `item_returnrequests`
  MODIFY `rrid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `lid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `vendors_info`
--
ALTER TABLE `vendors_info`
  MODIFY `vid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;
