-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `activity` text DEFAULT NULL,
  `activity_by` int(11) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `commented_by` int(11) DEFAULT NULL,
  `customer_message` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `architects`
--

CREATE TABLE `architects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `architect_id` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `primary_phone` varchar(255) NOT NULL,
  `secondary_phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `brand_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `gst_number` varchar(255) DEFAULT NULL,
  `established_year` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `architect_media`
--

CREATE TABLE `architect_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `thumbnail_path` varchar(255) DEFAULT NULL,
  `min_path` varchar(255) DEFAULT NULL,
  `media_type` enum('image','pdf') DEFAULT NULL,
  `architect_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL,
  `city_name` varchar(50) NOT NULL,
  `state_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `city_name`, `state_id`) VALUES
(1, 'North and Middle Andaman', 32),
(2, 'South Andaman', 32),
(3, 'Nicobar', 32),
(4, 'Adilabad', 1),
(5, 'Anantapur', 1),
(6, 'Chittoor', 1),
(7, 'East Godavari', 1),
(8, 'Guntur', 1),
(9, 'Hyderabad', 1),
(10, 'Kadapa', 1),
(11, 'Karimnagar', 1),
(12, 'Khammam', 1),
(13, 'Krishna', 1),
(14, 'Kurnool', 1),
(15, 'Mahbubnagar', 1),
(16, 'Medak', 1),
(17, 'Nalgonda', 1),
(18, 'Nellore', 1),
(19, 'Nizamabad', 1),
(20, 'Prakasam', 1),
(21, 'Rangareddi', 1),
(22, 'Srikakulam', 1),
(23, 'Vishakhapatnam', 1),
(24, 'Vizianagaram', 1),
(25, 'Warangal', 1),
(26, 'West Godavari', 1),
(27, 'Anjaw', 3),
(28, 'Changlang', 3),
(29, 'East Kameng', 3),
(30, 'Lohit', 3),
(31, 'Lower Subansiri', 3),
(32, 'Papum Pare', 3),
(33, 'Tirap', 3),
(34, 'Dibang Valley', 3),
(35, 'Upper Subansiri', 3),
(36, 'West Kameng', 3),
(37, 'Barpeta', 2),
(38, 'Bongaigaon', 2),
(39, 'Cachar', 2),
(40, 'Darrang', 2),
(41, 'Dhemaji', 2),
(42, 'Dhubri', 2),
(43, 'Dibrugarh', 2),
(44, 'Goalpara', 2),
(45, 'Golaghat', 2),
(46, 'Hailakandi', 2),
(47, 'Jorhat', 2),
(48, 'Karbi Anglong', 2),
(49, 'Karimganj', 2),
(50, 'Kokrajhar', 2),
(51, 'Lakhimpur', 2),
(52, 'Marigaon', 2),
(53, 'Nagaon', 2),
(54, 'Nalbari', 2),
(55, 'North Cachar Hills', 2),
(56, 'Sibsagar', 2),
(57, 'Sonitpur', 2),
(58, 'Tinsukia', 2),
(59, 'Araria', 4),
(60, 'Aurangabad', 4),
(61, 'Banka', 4),
(62, 'Begusarai', 4),
(63, 'Bhagalpur', 4),
(64, 'Bhojpur', 4),
(65, 'Buxar', 4),
(66, 'Darbhanga', 4),
(67, 'Purba Champaran', 4),
(68, 'Gaya', 4),
(69, 'Gopalganj', 4),
(70, 'Jamui', 4),
(71, 'Jehanabad', 4),
(72, 'Khagaria', 4),
(73, 'Kishanganj', 4),
(74, 'Kaimur', 4),
(75, 'Katihar', 4),
(76, 'Lakhisarai', 4),
(77, 'Madhubani', 4),
(78, 'Munger', 4),
(79, 'Madhepura', 4),
(80, 'Muzaffarpur', 4),
(81, 'Nalanda', 4),
(82, 'Nawada', 4),
(83, 'Patna', 4),
(84, 'Purnia', 4),
(85, 'Rohtas', 4),
(86, 'Saharsa', 4),
(87, 'Samastipur', 4),
(88, 'Sheohar', 4),
(89, 'Sheikhpura', 4),
(90, 'Saran', 4),
(91, 'Sitamarhi', 4),
(92, 'Supaul', 4),
(93, 'Siwan', 4),
(94, 'Vaishali', 4),
(95, 'Pashchim Champaran', 4),
(96, 'Bastar', 35),
(97, 'Bilaspur', 35),
(98, 'Dantewada', 35),
(99, 'Dhamtari', 35),
(100, 'Durg', 35),
(101, 'Jashpur', 35),
(102, 'Janjgir-Champa', 35),
(103, 'Korba', 35),
(104, 'Koriya', 35),
(105, 'Kanker', 35),
(106, 'Kawardha', 35),
(107, 'Mahasamund', 35),
(108, 'Raigarh', 35),
(109, 'Rajnandgaon', 35),
(110, 'Raipur', 35),
(111, 'Surguja', 35),
(112, 'Diu', 29),
(113, 'Daman', 29),
(114, 'Central Delhi', 25),
(115, 'East Delhi', 25),
(116, 'New Delhi', 25),
(117, 'North Delhi', 25),
(118, 'North East Delhi', 25),
(119, 'North West Delhi', 25),
(120, 'South Delhi', 25),
(121, 'South West Delhi', 25),
(122, 'West Delhi', 25),
(123, 'North Goa', 26),
(124, 'South Goa', 26),
(125, 'Ahmedabad', 5),
(126, 'Amreli District', 5),
(127, 'Anand', 5),
(128, 'Banaskantha', 5),
(129, 'Bharuch', 5),
(130, 'Bhavnagar', 5),
(131, 'Dahod', 5),
(132, 'The Dangs', 5),
(133, 'Gandhinagar', 5),
(134, 'Jamnagar', 5),
(135, 'Junagadh', 5),
(136, 'Kutch', 5),
(137, 'Kheda', 5),
(138, 'Mehsana', 5),
(139, 'Narmada', 5),
(140, 'Navsari', 5),
(141, 'Patan', 5),
(142, 'Panchmahal', 5),
(143, 'Porbandar', 5),
(144, 'Rajkot', 5),
(145, 'Sabarkantha', 5),
(146, 'Surendranagar', 5),
(147, 'Surat', 5),
(148, 'Vadodara', 5),
(149, 'Valsad', 5),
(150, 'Ambala', 6),
(151, 'Bhiwani', 6),
(152, 'Faridabad', 6),
(153, 'Fatehabad', 6),
(154, 'Gurgaon', 6),
(155, 'Hissar', 6),
(156, 'Jhajjar', 6),
(157, 'Jind', 6),
(158, 'Karnal', 6),
(159, 'Kaithal', 6),
(160, 'Kurukshetra', 6),
(161, 'Mahendragarh', 6),
(162, 'Mewat', 6),
(163, 'Panchkula', 6),
(164, 'Panipat', 6),
(165, 'Rewari', 6),
(166, 'Rohtak', 6),
(167, 'Sirsa', 6),
(168, 'Sonepat', 6),
(169, 'Yamuna Nagar', 6),
(170, 'Palwal', 6),
(171, 'Bilaspur', 7),
(172, 'Chamba', 7),
(173, 'Hamirpur', 7),
(174, 'Kangra', 7),
(175, 'Kinnaur', 7),
(176, 'Kulu', 7),
(177, 'Lahaul and Spiti', 7),
(178, 'Mandi', 7),
(179, 'Shimla', 7),
(180, 'Sirmaur', 7),
(181, 'Solan', 7),
(182, 'Una', 7),
(183, 'Anantnag', 8),
(184, 'Badgam', 8),
(185, 'Bandipore', 8),
(186, 'Baramula', 8),
(187, 'Doda', 8),
(188, 'Jammu', 8),
(189, 'Kargil', 8),
(190, 'Kathua', 8),
(191, 'Kupwara', 8),
(192, 'Leh', 8),
(193, 'Poonch', 8),
(194, 'Pulwama', 8),
(195, 'Rajauri', 8),
(196, 'Srinagar', 8),
(197, 'Samba', 8),
(198, 'Udhampur', 8),
(199, 'Bokaro', 34),
(200, 'Chatra', 34),
(201, 'Deoghar', 34),
(202, 'Dhanbad', 34),
(203, 'Dumka', 34),
(204, 'Purba Singhbhum', 34),
(205, 'Garhwa', 34),
(206, 'Giridih', 34),
(207, 'Godda', 34),
(208, 'Gumla', 34),
(209, 'Hazaribagh', 34),
(210, 'Koderma', 34),
(211, 'Lohardaga', 34),
(212, 'Pakur', 34),
(213, 'Palamu', 34),
(214, 'Ranchi', 34),
(215, 'Sahibganj', 34),
(216, 'Seraikela and Kharsawan', 34),
(217, 'Pashchim Singhbhum', 34),
(218, 'Ramgarh', 34),
(249, 'Alappuzha', 10),
(250, 'Ernakulam', 10),
(251, 'Idukki', 10),
(252, 'Kollam', 10),
(253, 'Kannur', 10),
(254, 'Kasaragod', 10),
(255, 'Kottayam', 10),
(256, 'Kozhikode', 10),
(257, 'Malappuram', 10),
(258, 'Palakkad', 10),
(259, 'Pathanamthitta', 10),
(260, 'Thrissur', 10),
(261, 'Thiruvananthapuram', 10),
(262, 'Wayanad', 10),
(263, 'Alirajpur', 11),
(264, 'Anuppur', 11),
(265, 'Ashok Nagar', 11),
(266, 'Balaghat', 11),
(267, 'Barwani', 11),
(268, 'Betul', 11),
(269, 'Bhind', 11),
(270, 'Bhopal', 11),
(271, 'Burhanpur', 11),
(272, 'Chhatarpur', 11),
(273, 'Chhindwara', 11),
(274, 'Damoh', 11),
(275, 'Datia', 11),
(276, 'Dewas', 11),
(277, 'Dhar', 11),
(278, 'Dindori', 11),
(279, 'Guna', 11),
(280, 'Gwalior', 11),
(281, 'Harda', 11),
(282, 'Hoshangabad', 11),
(283, 'Indore', 11),
(284, 'Jabalpur', 11),
(285, 'Jhabua', 11),
(286, 'Katni', 11),
(287, 'Khandwa', 11),
(288, 'Khargone', 11),
(289, 'Mandla', 11),
(290, 'Mandsaur', 11),
(291, 'Morena', 11),
(292, 'Narsinghpur', 11),
(293, 'Neemuch', 11),
(294, 'Panna', 11),
(295, 'Rewa', 11),
(296, 'Rajgarh', 11),
(297, 'Ratlam', 11),
(298, 'Raisen', 11),
(299, 'Sagar', 11),
(300, 'Satna', 11),
(301, 'Sehore', 11),
(302, 'Seoni', 11),
(303, 'Shahdol', 11),
(304, 'Shajapur', 11),
(305, 'Sheopur', 11),
(306, 'Shivpuri', 11),
(307, 'Sidhi', 11),
(308, 'Singrauli', 11),
(309, 'Tikamgarh', 11),
(310, 'Ujjain', 11),
(311, 'Umaria', 11),
(312, 'Vidisha', 11),
(313, 'Ahmednagar', 12),
(314, 'Akola', 12),
(315, 'Amrawati', 12),
(316, 'Aurangabad', 12),
(317, 'Bhandara', 12),
(318, 'Beed', 12),
(319, 'Buldhana', 12),
(320, 'Chandrapur', 12),
(321, 'Dhule', 12),
(322, 'Gadchiroli', 12),
(323, 'Gondiya', 12),
(324, 'Hingoli', 12),
(325, 'Jalgaon', 12),
(326, 'Jalna', 12),
(327, 'Kolhapur', 12),
(328, 'Latur', 12),
(329, 'Mumbai City', 12),
(330, 'Mumbai suburban', 12),
(331, 'Nandurbar', 12),
(332, 'Nanded', 12),
(333, 'Nagpur', 12),
(334, 'Nashik', 12),
(335, 'Osmanabad', 12),
(336, 'Parbhani', 12),
(337, 'Pune', 12),
(338, 'Raigad', 12),
(339, 'Ratnagiri', 12),
(340, 'Sindhudurg', 12),
(341, 'Sangli', 12),
(342, 'Solapur', 12),
(343, 'Satara', 12),
(344, 'Thane', 12),
(345, 'Wardha', 12),
(346, 'Washim', 12),
(347, 'Yavatmal', 12),
(348, 'Bishnupur', 13),
(349, 'Churachandpur', 13),
(350, 'Chandel', 13),
(351, 'Imphal East', 13),
(352, 'Senapati', 13),
(353, 'Tamenglong', 13),
(354, 'Thoubal', 13),
(355, 'Ukhrul', 13),
(356, 'Imphal West', 13),
(357, 'East Garo Hills', 14),
(358, 'East Khasi Hills', 14),
(359, 'Jaintia Hills', 14),
(360, 'Ri-Bhoi', 14),
(361, 'South Garo Hills', 14),
(362, 'West Garo Hills', 14),
(363, 'West Khasi Hills', 14),
(364, 'Aizawl', 15),
(365, 'Champhai', 15),
(366, 'Kolasib', 15),
(367, 'Lawngtlai', 15),
(368, 'Lunglei', 15),
(369, 'Mamit', 15),
(370, 'Saiha', 15),
(371, 'Serchhip', 15),
(372, 'Dimapur', 16),
(373, 'Kohima', 16),
(374, 'Mokokchung', 16),
(375, 'Mon', 16),
(376, 'Phek', 16),
(377, 'Tuensang', 16),
(378, 'Wokha', 16),
(379, 'Zunheboto', 16),
(380, 'Angul', 17),
(381, 'Boudh', 17),
(382, 'Bhadrak', 17),
(383, 'Bolangir', 17),
(384, 'Bargarh', 17),
(385, 'Baleswar', 17),
(386, 'Cuttack', 17),
(387, 'Debagarh', 17),
(388, 'Dhenkanal', 17),
(389, 'Ganjam', 17),
(390, 'Gajapati', 17),
(391, 'Jharsuguda', 17),
(392, 'Jajapur', 17),
(393, 'Jagatsinghpur', 17),
(394, 'Khordha', 17),
(395, 'Kendujhar', 17),
(396, 'Kalahandi', 17),
(397, 'Kandhamal', 17),
(398, 'Koraput', 17),
(399, 'Kendrapara', 17),
(400, 'Malkangiri', 17),
(401, 'Mayurbhanj', 17),
(402, 'Nabarangpur', 17),
(403, 'Nuapada', 17),
(404, 'Nayagarh', 17),
(405, 'Puri', 17),
(406, 'Rayagada', 17),
(407, 'Sambalpur', 17),
(408, 'Subarnapur', 17),
(409, 'Sundargarh', 17),
(410, 'Karaikal', 27),
(411, 'Mahe', 27),
(412, 'Puducherry', 27),
(413, 'Yanam', 27),
(414, 'Amritsar', 18),
(415, 'Bathinda', 18),
(416, 'Firozpur', 18),
(417, 'Faridkot', 18),
(418, 'Fatehgarh Sahib', 18),
(419, 'Gurdaspur', 18),
(420, 'Hoshiarpur', 18),
(421, 'Jalandhar', 18),
(422, 'Kapurthala', 18),
(423, 'Ludhiana', 18),
(424, 'Mansa', 18),
(425, 'Moga', 18),
(426, 'Mukatsar', 18),
(427, 'Nawan Shehar', 18),
(428, 'Patiala', 18),
(429, 'Rupnagar', 18),
(430, 'Sangrur', 18),
(431, 'Ajmer', 19),
(432, 'Alwar', 19),
(433, 'Bikaner', 19),
(434, 'Barmer', 19),
(435, 'Banswara', 19),
(436, 'Bharatpur', 19),
(437, 'Baran', 19),
(438, 'Bundi', 19),
(439, 'Bhilwara', 19),
(440, 'Churu', 19),
(441, 'Chittorgarh', 19),
(442, 'Dausa', 19),
(443, 'Dholpur', 19),
(444, 'Dungapur', 19),
(445, 'Ganganagar', 19),
(446, 'Hanumangarh', 19),
(447, 'Juhnjhunun', 19),
(448, 'Jalore', 19),
(449, 'Jodhpur', 19),
(450, 'Jaipur', 19),
(451, 'Jaisalmer', 19),
(452, 'Jhalawar', 19),
(453, 'Karauli', 19),
(454, 'Kota', 19),
(455, 'Nagaur', 19),
(456, 'Pali', 19),
(457, 'Pratapgarh', 19),
(458, 'Rajsamand', 19),
(459, 'Sikar', 19),
(460, 'Sawai Madhopur', 19),
(461, 'Sirohi', 19),
(462, 'Tonk', 19),
(463, 'Udaipur', 19),
(464, 'East Sikkim', 20),
(465, 'North Sikkim', 20),
(466, 'South Sikkim', 20),
(467, 'West Sikkim', 20),
(468, 'Ariyalur', 21),
(469, 'Chennai', 21),
(470, 'Coimbatore', 21),
(471, 'Cuddalore', 21),
(472, 'Dharmapuri', 21),
(473, 'Dindigul', 21),
(474, 'Erode', 21),
(475, 'Kanchipuram', 21),
(476, 'Kanyakumari', 21),
(477, 'Karur', 21),
(478, 'Madurai', 21),
(479, 'Nagapattinam', 21),
(480, 'The Nilgiris', 21),
(481, 'Namakkal', 21),
(482, 'Perambalur', 21),
(483, 'Pudukkottai', 21),
(484, 'Ramanathapuram', 21),
(485, 'Salem', 21),
(486, 'Sivagangai', 21),
(487, 'Tiruppur', 21),
(488, 'Tiruchirappalli', 21),
(489, 'Theni', 21),
(490, 'Tirunelveli', 21),
(491, 'Thanjavur', 21),
(492, 'Thoothukudi', 21),
(493, 'Thiruvallur', 21),
(494, 'Thiruvarur', 21),
(495, 'Tiruvannamalai', 21),
(496, 'Vellore', 21),
(497, 'Villupuram', 21),
(498, 'Dhalai', 22),
(499, 'North Tripura', 22),
(500, 'South Tripura', 22),
(501, 'West Tripura', 22),
(502, 'Almora', 33),
(503, 'Bageshwar', 33),
(504, 'Chamoli', 33),
(505, 'Champawat', 33),
(506, 'Dehradun', 33),
(507, 'Haridwar', 33),
(508, 'Nainital', 33),
(509, 'Pauri Garhwal', 33),
(510, 'Pithoragharh', 33),
(511, 'Rudraprayag', 33),
(512, 'Tehri Garhwal', 33),
(513, 'Udham Singh Nagar', 33),
(514, 'Uttarkashi', 33),
(515, 'Agra', 23),
(516, 'Allahabad', 23),
(517, 'Aligarh', 23),
(518, 'Ambedkar Nagar', 23),
(519, 'Auraiya', 23),
(520, 'Azamgarh', 23),
(521, 'Barabanki', 23),
(522, 'Badaun', 23),
(523, 'Bagpat', 23),
(524, 'Bahraich', 23),
(525, 'Bijnor', 23),
(526, 'Ballia', 23),
(527, 'Banda', 23),
(528, 'Balrampur', 23),
(529, 'Bareilly', 23),
(530, 'Basti', 23),
(531, 'Bulandshahr', 23),
(532, 'Chandauli', 23),
(533, 'Chitrakoot', 23),
(534, 'Deoria', 23),
(535, 'Etah', 23),
(536, 'Kanshiram Nagar', 23),
(537, 'Etawah', 23),
(538, 'Firozabad', 23),
(539, 'Farrukhabad', 23),
(540, 'Fatehpur', 23),
(541, 'Faizabad', 23),
(542, 'Gautam Buddha Nagar', 23),
(543, 'Gonda', 23),
(544, 'Ghazipur', 23),
(545, 'Gorkakhpur', 23),
(546, 'Ghaziabad', 23),
(547, 'Hamirpur', 23),
(548, 'Hardoi', 23),
(549, 'Mahamaya Nagar', 23),
(550, 'Jhansi', 23),
(551, 'Jalaun', 23),
(552, 'Jyotiba Phule Nagar', 23),
(553, 'Jaunpur District', 23),
(554, 'Kanpur Dehat', 23),
(555, 'Kannauj', 23),
(556, 'Kanpur Nagar', 23),
(557, 'Kaushambi', 23),
(558, 'Kushinagar', 23),
(559, 'Lalitpur', 23),
(560, 'Lakhimpur Kheri', 23),
(561, 'Lucknow', 23),
(562, 'Mau', 23),
(563, 'Meerut', 23),
(564, 'Maharajganj', 23),
(565, 'Mahoba', 23),
(566, 'Mirzapur', 23),
(567, 'Moradabad', 23),
(568, 'Mainpuri', 23),
(569, 'Mathura', 23),
(570, 'Muzaffarnagar', 23),
(571, 'Pilibhit', 23),
(572, 'Pratapgarh', 23),
(573, 'Rampur', 23),
(574, 'Rae Bareli', 23),
(575, 'Saharanpur', 23),
(576, 'Sitapur', 23),
(577, 'Shahjahanpur', 23),
(578, 'Sant Kabir Nagar', 23),
(579, 'Siddharthnagar', 23),
(580, 'Sonbhadra', 23),
(581, 'Sant Ravidas Nagar', 23),
(582, 'Sultanpur', 23),
(583, 'Shravasti', 23),
(584, 'Unnao', 23),
(585, 'Varanasi', 23),
(586, 'Birbhum', 24),
(587, 'Bankura', 24),
(588, 'Bardhaman', 24),
(589, 'Darjeeling', 24),
(590, 'Dakshin Dinajpur', 24),
(591, 'Hooghly', 24),
(592, 'Howrah', 24),
(593, 'Jalpaiguri', 24),
(594, 'Cooch Behar', 24),
(595, 'Kolkata', 24),
(596, 'Malda', 24),
(597, 'Midnapore', 24),
(598, 'Murshidabad', 24),
(599, 'Nadia', 24),
(600, 'North 24 Parganas', 24),
(601, 'South 24 Parganas', 24),
(602, 'Purulia', 24),
(603, 'Uttar Dinajpur', 24),
(604, 'Kavaratti', 28),
(605, 'Amini', 28),
(606, 'Daman', 30),
(607, 'Diu', 30),
(608, 'Ludhiana', 31),
(609, 'Patiala', 31),
(610, 'Raipur', 35),
(611, 'Korba', 35),
(612, 'Bengaluru', 9),
(613, 'Hubli-Dharwad', 9),
(614, 'Belagavi', 9),
(615, 'Mangaluru', 9),
(616, 'Davanagere', 9),
(617, 'Ballari', 9),
(618, 'Mysore', 9),
(619, 'Tumkur', 9),
(620, 'Shivamogga', 9),
(621, 'Raayachuru', 9),
(622, 'Robertson Pet', 9),
(623, 'Kolar', 9),
(624, 'Mandya', 9),
(625, 'Udupi', 9),
(626, 'Chikkamagaluru', 9),
(627, 'Karwar', 9),
(628, 'Ranebennuru', 9),
(629, 'Ranibennur', 9),
(630, 'Ramanagaram', 9),
(631, 'Gokak', 9),
(632, 'Yadgir', 9),
(633, 'Rabkavi Banhatti', 9),
(634, 'Shahabad', 9),
(635, 'Sirsi', 9),
(636, 'Sindhnur', 9),
(637, 'Tiptur', 9),
(638, 'Arsikere', 9),
(639, 'Nanjangud', 9),
(640, 'Sagara', 9),
(641, 'Sira', 9),
(642, 'Puttur', 9),
(643, 'Athni', 9),
(644, 'Mulbagal', 9),
(645, 'Surapura', 9),
(646, 'Siruguppa', 9),
(647, 'Mudhol', 9),
(648, 'Sidlaghatta', 9),
(649, 'Shahpur', 9),
(650, 'Saundatti-Yellamma', 9),
(651, 'Wadi', 9),
(652, 'Manvi', 9),
(653, 'Nelamangala', 9),
(654, 'Lakshmeshwar', 9),
(655, 'Ramdurg', 9),
(656, 'Nargund', 9),
(657, 'Tarikere', 9),
(658, 'Malavalli', 9),
(659, 'Savanur', 9),
(660, 'Lingsugur', 9),
(661, 'Vijayapura', 9),
(662, 'Sankeshwara', 9),
(663, 'Madikeri', 9),
(664, 'Talikota', 9),
(665, 'Sedam', 9),
(666, 'Shikaripur', 9),
(667, 'Mahalingapura', 9),
(668, 'Mudalagi', 9),
(669, 'Muddebihal', 9),
(670, 'Pavagada', 9),
(671, 'Malur', 9),
(672, 'Sindhagi', 9),
(673, 'Sanduru', 9),
(674, 'Afzalpur', 9),
(675, 'Maddur', 9),
(676, 'Madhugiri', 9),
(677, 'Tekkalakote', 9),
(678, 'Terdal', 9),
(679, 'Mudabidri', 9),
(680, 'Magadi', 9),
(681, 'Navalgund', 9),
(682, 'Shiggaon', 9),
(683, 'Shrirangapattana', 9),
(684, 'Sindagi', 9),
(685, 'Sakaleshapura', 9),
(686, 'Srinivaspur', 9),
(687, 'Ron', 9),
(688, 'Mundargi', 9),
(689, 'Sadalagi', 9),
(690, 'Piriyapatna', 9),
(691, 'Adyar', 9);

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `comment` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `commented_by` int(11) DEFAULT NULL,
  `comment_for` int(11) DEFAULT NULL,
  `commenter_role` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` int(11) NOT NULL,
  `complaint_id` varchar(50) NOT NULL,
  `customer_fullname` varchar(255) NOT NULL,
  `ticket_number` varchar(255) NOT NULL,
  `customer_mobile_number` varchar(255) NOT NULL,
  `sale_order_no` varchar(255) NOT NULL,
  `complaint_type` enum('Damage','Wrong Item Delivery','Batch Variation','Wrong Quantity','Delayed Delivery','Others') NOT NULL,
  `other_complaint_type` longtext DEFAULT NULL,
  `estimate_resolve_date` date NOT NULL,
  `comment_on_date_change` longtext DEFAULT NULL,
  `complaint_status` enum('Created','Inprogress','Resolved') NOT NULL DEFAULT 'Created',
  `comment` longtext DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `support_executive` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `complaint_activities`
--

CREATE TABLE `complaint_activities` (
  `id` int(10) UNSIGNED NOT NULL,
  `activity` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `complaint_id` int(11) NOT NULL,
  `activity_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `complaint_comments`
--

CREATE TABLE `complaint_comments` (
  `id` int(11) NOT NULL,
  `complaint_id` int(11) DEFAULT NULL,
  `comment` longtext NOT NULL,
  `commented_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `complaint_media`
--

CREATE TABLE `complaint_media` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `media_type` enum('Image','Video') DEFAULT 'Image',
  `path` varchar(255) NOT NULL,
  `min_path` varchar(255) DEFAULT NULL,
  `thumbnail_path` varchar(255) DEFAULT NULL,
  `complaint_id` int(11) DEFAULT NULL,
  `response_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `complaint_responses`
--

CREATE TABLE `complaint_responses` (
  `id` int(11) NOT NULL,
  `response_id` varchar(50) NOT NULL,
  `issue_from` enum('Mytyles','Vendor') NOT NULL DEFAULT 'Mytyles',
  `issue_vendor` varchar(255) DEFAULT NULL,
  `solution` enum('Replacement by Mytyles','Replacement by Vendor','Others') DEFAULT NULL,
  `other_solution` longtext DEFAULT NULL,
  `cost_to_mytyles` varchar(255) DEFAULT '0',
  `comment` varchar(255) DEFAULT NULL,
  `complaint_id` int(11) NOT NULL,
  `agent_assigned` int(11) DEFAULT NULL,
  `resolve_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `daily_worklogs`
--

CREATE TABLE `daily_worklogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `worklog_id` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` enum('present','absent') NOT NULL DEFAULT 'absent',
  `hours_worked` decimal(4,1) DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `working_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `daily_worklog_documents`
--

CREATE TABLE `daily_worklog_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `daily_worklog_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `daily_worklog_media`
--

CREATE TABLE `daily_worklog_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `min_path` varchar(255) DEFAULT NULL,
  `thumbnail_path` varchar(255) DEFAULT NULL,
  `media_type` enum('image','video') NOT NULL,
  `daily_worklog_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `delivery_modes`
--

CREATE TABLE `delivery_modes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `delivery_mode` enum('Local_Driver','OLA','Porter','Spoton','Others','Self','SVR','Jabbar','DTDC','Anmol','G_Shantilal','Manoj_Cargo') NOT NULL DEFAULT 'Others',
  `Driver_Name` varchar(255) DEFAULT NULL,
  `Driver_Contact` varchar(255) DEFAULT NULL,
  `Vehicle_Number` varchar(255) DEFAULT NULL,
  `Booking_Date` date NOT NULL DEFAULT '2024-01-24',
  `LR_No` varchar(255) DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `specific_delivery_mode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `order_type` enum('PO','SO') NOT NULL DEFAULT 'SO',
  `uploaded_by` int(11) DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_email` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `purpose` text DEFAULT NULL,
  `po_code` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `po_status` enum('ready','against_order') DEFAULT NULL,
  `schedule_date` date DEFAULT NULL,
  `delivery_mode` enum('Local_Driver','OLA','Porter','Spoton','Others','Self','SVR','Jabbar','DTDC','Anmol','G_Shantilal','Manoj_Cargo') DEFAULT NULL,
  `LR_No` varchar(255) DEFAULT NULL,
  `specific_delivery_mode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `document_proofs`
--

CREATE TABLE `document_proofs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `for_status` enum('order_creation','To_Be_Approved_From_Account','Pending_At_Dispatch_Manager','Po_Sent','Order_Processed','Loading','Dispatched','Reaching_Store','Ready_For_Pick_Up','Picked_Up','Delivered','Cancelled','Payment_Received','po_arranged','delivery_charge','delivery_charge_paid') NOT NULL DEFAULT 'To_Be_Approved_From_Account',
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `commented_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` bigint(20) NOT NULL,
  `lead_id` varchar(80) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `primary_phone` bigint(20) NOT NULL,
  `secondary_phone` bigint(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gst_number` varchar(15) DEFAULT NULL,
  `billing_address_id` int(11) DEFAULT NULL,
  `shipping_address_id` int(11) DEFAULT NULL,
  `lead_stage` enum('New Lead','Follow Up','Showroom Visit','Quotation','Order Placed','General Enquiry','Lost','Invalid') NOT NULL DEFAULT 'New Lead',
  `lead_source` enum('Website','Google Business','Interior/Architect Ref','Friend Referral','Instagram','Offline','Web Signups','Zopim Chat') NOT NULL DEFAULT 'Offline',
  `lead_type` enum('Call','Walkin','Website Signups') NOT NULL DEFAULT 'Walkin',
  `requirements` longtext NOT NULL,
  `notes` longtext DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `lead_owner_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_star_marked` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lead_activities`
--

CREATE TABLE `lead_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) NOT NULL,
  `activity_type` enum('Phone Call Positive','Phone Call Negative','WhatsApp Positive','WhatsApp Negative','Showroom Visit Positive','Showroom Visit Negative','Showroom Visited','Others','Order Placed') NOT NULL,
  `notes` longtext DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `other_activity_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lead_address`
--

CREATE TABLE `lead_address` (
  `id` int(11) NOT NULL,
  `lead_id` bigint(20) NOT NULL,
  `type` enum('Billing','Shipping') NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `pincode` bigint(20) DEFAULT NULL,
  `address_line_1` varchar(255) NOT NULL,
  `address_line_2` varchar(255) NOT NULL,
  `landmark` varchar(255) DEFAULT NULL,
  `gst_number` varchar(15) DEFAULT NULL,
  `site_in_charge_mobile_number` bigint(20) DEFAULT NULL,
  `as_default` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `lead_comments`
--

CREATE TABLE `lead_comments` (
  `id` int(11) NOT NULL,
  `lead_id` bigint(20) NOT NULL,
  `comment` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `lead_history`
--

CREATE TABLE `lead_history` (
  `id` int(11) NOT NULL,
  `lead_id` bigint(20) DEFAULT NULL,
  `field_name` varchar(255) DEFAULT NULL,
  `old_value` varchar(255) DEFAULT NULL,
  `new_value` varchar(255) DEFAULT NULL,
  `task` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `follow_up_date` date DEFAULT NULL,
  `follow_up_time` time DEFAULT NULL,
  `updated_by` int(11) NOT NULL,
  `change_date` date DEFAULT NULL,
  `change_time` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `lead_images`
--

CREATE TABLE `lead_images` (
  `id` int(11) NOT NULL,
  `lead_id` bigint(20) NOT NULL,
  `image_key` varchar(200) NOT NULL,
  `feature_image` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `lead_requirements`
--

CREATE TABLE `lead_requirements` (
  `id` int(11) NOT NULL,
  `lead_id` varchar(80) NOT NULL,
  `lead_requirement_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `URL` text NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `master_branch_name`
--

CREATE TABLE `master_branch_name` (
  `id` int(11) NOT NULL,
  `branch_name` varchar(512) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_branch_name`
--

INSERT INTO `master_branch_name` (`id`, `branch_name`) VALUES
(1, 'Mytyles'),
(2, 'Devstringx');

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

--
-- Table structure for table `master_brand`
--

CREATE TABLE `master_brand` (
  `id` int(11) NOT NULL,
  `brand_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_brand`
--

INSERT INTO `master_brand` (`id`, `brand_name`, `is_active`) VALUES
(1, 'kajaria', '1'),
(2, 'mytyles', '1');

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

--
-- Table structure for table `master_country_manufacture`
--

CREATE TABLE `master_country_manufacture` (
  `id` int(11) NOT NULL,
  `country_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_country_manufacture`
--

INSERT INTO `master_country_manufacture` (`id`, `country_name`, `is_active`) VALUES
(1, 'India', '1'),
(2, 'Italy', '1'),
(3, 'Germany', '1');

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

--
-- Table structure for table `master_details`
--

CREATE TABLE `master_details` (
  `id` int(11) NOT NULL,
  `detail_type` varchar(512) NOT NULL,
  `details` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_details`
--

INSERT INTO `master_details` (`id`, `detail_type`, `details`) VALUES
(1, 'bank_detail', 'Bank Name:- Kotak Mahindra Bank, IFSC:- KKBK001007, Branch:- Meera Bagh');

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

--
-- Table structure for table `master_material_type`
--

CREATE TABLE `master_material_type` (
  `id` int(11) NOT NULL,
  `material_type_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_material_type`
--

INSERT INTO `master_material_type` (`id`, `material_type_name`, `is_active`) VALUES
(1, 'ceramic', '1'),
(2, 'porcelain', '1');

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

--
-- Table structure for table `master_modules`
--

CREATE TABLE `master_modules` (
  `id` int(11) NOT NULL,
  `module_name` varchar(255) NOT NULL,
  `module_code` varchar(10) DEFAULT NULL,
  `permission` varchar(100) NOT NULL,
  `permission_type` enum('admin','user') NOT NULL DEFAULT 'user',
  `module_id` int(11) DEFAULT NULL,
  `is_not_display` enum('0','1') NOT NULL DEFAULT '0',
  `is_for_custom_role` tinyint(1) NOT NULL DEFAULT 0,
  `order_arrangement` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_modules`
--

INSERT INTO `master_modules` (`id`, `module_name`, `module_code`, `permission`, `permission_type`, `module_id`, `is_not_display`, `is_for_custom_role`, `order_arrangement`) VALUES
(1, 'Dashboard', 'DB', 'read', 'user', 0, '0', 1, 0),
(2, 'Manage Users', 'MU', 'read', 'user', 0, '0', 1, 1),
(3, 'Manage Inventory', 'MI', 'read', 'user', 0, '0', 1, 3),
(4, 'Manage Leads', 'ML', 'read', 'user', 0, '0', 1, 4),
(5, 'Manage Quotations', 'MQ', 'read', 'user', 0, '0', 1, 5),
(6, 'Stock Check Inquiries', 'SCE', 'read', 'user', 0, '0', 1, 6),
(7, 'roles and permissions', 'RP', 'read', 'user', 0, '0', 1, 2),
(9, 'View/Export Inventory', 'VEI', 'read', 'user', 3, '0', 1, 0),
(10, 'Add/Import/Edit/Active/Inactive Inventory', 'AIEAI', 'read', 'user', 3, '0', 1, 1),
(11, 'Delete Inventory', 'DI', 'read', 'user', 3, '0', 1, 2),
(12, 'Print Label Inventory', 'PLI', 'read', 'user', 3, '0', 1, 3),
(13, 'Add/Edit Users', 'AEU', 'read', 'user', 2, '0', 1, 2),
(14, 'View/Export  All Users as admin', 'VEAUAA', 'read', 'admin', 2, '0', 1, 0),
(15, 'Active/Inactive/Change Password/Resend password Users', 'AIUPRPU', 'read', 'user', 2, '0', 1, 3),
(16, 'Delete Users', 'DU', 'read', 'user', 2, '0', 1, 4),
(17, 'View/Export All Leads as admin', 'VELAA', 'read', 'admin', 4, '0', 1, 0),
(18, 'Add Lead', 'AL', 'read', 'user', 4, '0', 1, 2),
(19, 'Edit Lead', 'EL', 'read', 'user', 4, '0', 1, 3),
(21, 'View/Print/Download/Export All Quotes as admin', 'VPDEQA', 'read', 'admin', 5, '0', 1, 0),
(22, 'Add/Edit/Process for Dispatch Quotes', 'AEFPDQ', 'read', 'user', 5, '0', 1, 2),
(24, 'View/Export All Inquiries as admin', 'VEAIA', 'read', 'admin', 6, '0', 1, 0),
(25, 'Respond Inquiries', 'RI', 'read', 'user', 6, '0', 1, 2),
(26, 'View Role', 'VR', 'read', 'user', 7, '0', 1, 0),
(27, 'Add/Edit Role', 'AER', 'read', 'user', 7, '0', 1, 1),
(28, 'Delete Role', 'DR', 'read', 'user', 7, '0', 1, 2),
(29, 'Complete Analytics', 'CA', 'read', 'user', 1, '0', 1, 0),
(30, 'Quotation Analytics', 'QA', 'read', 'user', 1, '0', 1, 1),
(31, 'Lead Analytics', 'LA', 'read', 'user', 1, '0', 1, 2),
(32, 'Stock Check Inquiry Analytics', 'SCIA', 'read', 'user', 1, '0', 1, 3),
(33, 'Stock Check Inquiry Analytics as vendor', 'SCIAV', 'read', 'user', 32, '0', 1, 1),
(34, 'Stock Check Inquiry Analytics as admin', 'SCIAA', 'read', 'admin', 32, '0', 1, 0),
(35, 'Lead analytics as sales executive', 'LASE', 'read', 'user', 31, '0', 1, 0),
(36, 'Lead analytics as admin', 'LAAA', 'read', 'admin', 31, '0', 1, 0),
(37, 'Quotation analytics as Sales executive', 'QASE', 'read', 'user', 30, '0', 1, 1),
(38, 'Quotation analytics as admin', 'QAAA', 'read', 'admin', 30, '0', 1, 0),
(39, 'View/Export  Assign Leads as user', 'VEALAU', 'read', 'user', 4, '1', 1, 1),
(40, 'View/Export Assign Inquiries as user', 'VEAIU', 'read', 'user', 6, '1', 1, 1),
(41, 'View/Print/Download/Export Assign Quotes as user', 'VPDEAQAU', 'read', 'user', 5, '1', 1, 1),
(42, 'View/Export Vendor Users  as vendor admin', 'VEVUV', 'read', 'user', 2, '1', 1, 1),
(43, 'Delete Users as vendor admin', 'DUVA', 'read', 'user', 2, '0', 1, 3),
(45, 'Razorpay', 'RZP', 'read', 'user', 0, '0', 0, 10),
(46, 'View All Razorpay as Admin', 'VARZA', 'read', 'admin', 45, '0', 0, 0),
(47, 'View All Razorpay as User', 'VARZU', 'read', 'user', 45, '0', 0, 1),
(48, 'Add Razorpay', 'ARZ', 'read', 'user', 45, '0', 0, 2),
(49, 'Delete Razorpay', 'DRZ', 'read', 'user', 45, '0', 0, 3),
(50, 'Delivery Status', 'ODS', 'read', 'user', 0, '0', 0, 8),
(51, 'Complaint Management', 'CMS', 'read', 'user', 0, '0', 0, 9),
(52, 'Architect/Interior', 'AORI', 'read', 'user', 0, '0', 0, 11),
(53, 'Data Analytics', 'DAN', 'read', 'user', 0, '0', 0, 12),
(54, 'Transaction History', 'THI', 'read', 'user', 0, '0', 0, 13),
(55, 'Shipping Charge', 'SCH', 'read', 'admin', 0, '0', 0, 14),
(56, 'Daily Worklog', 'DWL', 'read', 'user', 0, '0', 0, 15),
(57, 'View Architect/Interior as a Admin', 'VAIA', 'read', 'admin', 52, '0', 0, 1),
(58, 'View Architect/Interior as a User', 'VAIU', 'read', 'user', 52, '0', 0, 2),
(59, 'Add/Edit Architect', 'AEA', 'read', 'admin', 52, '0', 0, 0),
(60, 'Delete Architect', 'DEA', 'read', 'admin', 52, '0', 0, 3),
(61, 'Task Reminder', 'TRE', 'read', 'user', 0, '0', 0, 16),
(62, 'View All Delivery Status as Admin', 'ODSA', 'read', 'admin', 50, '0', 0, 0),
(63, 'View All Delivery Status as User', 'ODSU', 'read', 'user', 50, '0', 0, 1),
(64, 'Edit Delivery Status', 'EODS', 'read', 'admin', 50, '0', 0, 2),
(65, 'Delete Delivery Status', 'DODS', 'read', 'admin', 50, '0', 0, 3),
(66, 'Cancel Delivery Status', 'CODS', 'read', 'admin', 50, '0', 0, 4),
(67, 'View All Complaint as Admin', 'CMSA', 'read', 'admin', 51, '0', 0, 0),
(68, 'View All Complaint as User', 'CMSU', 'read', 'user', 51, '0', 0, 1),
(69, 'Add Complaint', 'ACMS', 'read', 'admin', 51, '0', 0, 2),
(70, 'Edit Complaint', 'ECMS', 'read', 'admin', 51, '0', 0, 3),
(71, 'Delete Complaint', 'DCMS', 'read', 'admin', 51, '0', 0, 4),
(72, 'Order Analytics', 'OA', 'read', 'user', 1, '0', 0, 4),
(73, 'Order Analytics as Admin', 'OAA', 'read', 'admin', 72, '0', 0, 0),
(74, 'Order Analytics as User', 'OAU', 'read', 'user', 72, '0', 0, 1),
(75, 'Sale Graph', 'OASG', 'read', 'user', 72, '0', 0, 2),
(76, 'Order Graph', 'OAOG', 'read', 'user', 72, '0', 0, 3),
(77, 'Visit Graph', 'OAVG', 'read', 'user', 72, '0', 0, 4),
(78, 'Sale Amount Report', 'OASAR', 'read', 'user', 72, '0', 0, 5),
(79, 'Sale Analysis', 'OASA', 'read', 'user', 72, '0', 0, 6);

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

--
-- Table structure for table `master_product_category`
--

CREATE TABLE `master_product_category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_category`
--

INSERT INTO `master_product_category` (`id`, `category_name`, `is_active`) VALUES
(1, 'Granite Tile', '1'),
(2, 'Limestone Tile', '1');

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

--
-- Table structure for table `master_product_delivery_time`
--

CREATE TABLE `master_product_delivery_time` (
  `id` int(11) NOT NULL,
  `delivery_time` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_delivery_time`
--

INSERT INTO `master_product_delivery_time` (`id`, `delivery_time`, `is_active`) VALUES
(1, '0-1 day', '1'),
(2, '1-2 Days', '1'),
(3, '2-3 Days', '1'),
(4, '3-5 Days', '1'),
(5, '5-7 Days', '1'),
(6, '12-15 Days', '1'),
(7, '20-25 Days', '1'),
(8, '1 Month', '1'),
(9, '2 Month', '1'),
(10, 'Others', '1');

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

--
-- Table structure for table `master_product_finish`
--

CREATE TABLE `master_product_finish` (
  `id` int(11) NOT NULL,
  `product_finish_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_finish`
--

INSERT INTO `master_product_finish` (`id`, `product_finish_name`, `is_active`) VALUES
(1, 'Metallic', '1'),
(2, 'Non-metallic', '1');

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

--
-- Table structure for table `master_product_quality`
--

CREATE TABLE `master_product_quality` (
  `id` int(11) NOT NULL,
  `quality_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_quality`
--

INSERT INTO `master_product_quality` (`id`, `quality_name`, `is_active`) VALUES
(1, 'gold', '1'),
(2, 'metallic', '1');

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

--
-- Table structure for table `master_product_size`
--

CREATE TABLE `master_product_size` (
  `id` int(11) NOT NULL,
  `product_size` varchar(255) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_size`
--

INSERT INTO `master_product_size` (`id`, `product_size`, `is_active`) VALUES
(1, '300x300 mm', '1'),
(2, '600x600 mm', '1'),
(3, '450x450 mm', '1'),
(4, '800x800 mm', '1'),
(5, '150x150 mm', '1'),
(6, '1200x600 mm', '1');

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

--
-- Table structure for table `master_product_uses`
--

CREATE TABLE `master_product_uses` (
  `id` int(11) NOT NULL,
  `use_type_name` varchar(256) NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_product_uses`
--

INSERT INTO `master_product_uses` (`id`, `use_type_name`, `is_active`) VALUES
(1, 'Bathroom', '1'),
(2, 'Kitchen', '1');

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

--
-- Table structure for table `master_requirements`
--

CREATE TABLE `master_requirements` (
  `id` int(11) NOT NULL,
  `requirement` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_requirements`
--

INSERT INTO `master_requirements` (`id`, `requirement`) VALUES
(1, 'Wall Tile'),
(2, 'Floor Tile'),
(3, 'Poster Wall Tile'),
(4, 'Kitchen Sink'),
(5, 'Unknown Now');

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

--
-- Table structure for table `master_roles`
--

CREATE TABLE `master_roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(256) NOT NULL,
  `role_type` enum('system','custom') NOT NULL DEFAULT 'custom',
  `role_status` enum('0','1') NOT NULL DEFAULT '1',
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_roles`
--

INSERT INTO `master_roles` (`id`, `role_name`, `role_type`, `role_status`, `created_date`, `updated_date`) VALUES
(1, 'Admin', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(2, 'Support Executive', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(3, 'Vendor Admin', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(4, 'Vendor User', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(5, 'Inventory Manager', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(6, 'Sales Executive', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(7, 'System Admin', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(8, 'Dispatch Manager', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(9, 'Delivery Agent', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(10, 'Account Manager', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(11, 'Warehouse Incharge', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(12, 'HR', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18'),
(13, 'Employee', 'system', '1', '2024-06-07 06:15:18', '2024-06-07 06:15:18');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `thumbnail_path` varchar(255) DEFAULT NULL,
  `for_status` enum('order_creation','To_Be_Approved_From_Account','Pending_At_Dispatch_Manager','Po_Sent','Order_Processed','Loading','Dispatched','Reaching_Store','Ready_For_Pick_Up','Picked_Up','Delivered','Cancelled','Payment_Received','po_arranged','delivery_charge','delivery_charge_paid') NOT NULL DEFAULT 'To_Be_Approved_From_Account',
  `media_type` enum('image','video') DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `commented_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `min_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `sales_person` int(11) NOT NULL,
  `dispatch_manager` int(11) DEFAULT NULL,
  `delivery_agent` int(11) DEFAULT NULL,
  `architect` bigint(20) UNSIGNED DEFAULT NULL,
  `lead_id` bigint(20) DEFAULT NULL,
  `quotation_id` int(11) NOT NULL,
  `start_financial_year` year(4) NOT NULL,
  `sale_order_no` varchar(255) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_phone_number` varchar(255) DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `payment_verification` enum('accept','reject') NOT NULL DEFAULT 'accept',
  `quotation_url` varchar(100) DEFAULT NULL,
  `status` enum('To_Be_Approved_From_Account','Pending_At_Dispatch_Manager','Po_Sent','Order_Processed','Loading','Reaching_Store','Ready_For_Pick_Up','Dispatched','Delivered','Picked_Up','Cancelled') NOT NULL DEFAULT 'To_Be_Approved_From_Account',
  `pending_material` varchar(255) DEFAULT NULL,
  `delivery_type` enum('Pick Up','Home Delivery') NOT NULL DEFAULT 'Home Delivery',
  `customer_address` varchar(1000) DEFAULT NULL,
  `delivery_address` text DEFAULT NULL,
  `delivery_location_type` enum('Instation','Outstation') NOT NULL DEFAULT 'Instation',
  `order_type` enum('new_order','shortage_order') DEFAULT NULL,
  `quote_order_amount` decimal(20,2) NOT NULL,
  `delivery_date` date NOT NULL,
  `delivery_time` enum('first_half','second_half') NOT NULL DEFAULT 'second_half',
  `encrypted_sale_order_no` longtext DEFAULT NULL,
  `short_url_id` bigint(20) UNSIGNED DEFAULT NULL,
  `direct_ready_for_pickup` tinyint(1) NOT NULL DEFAULT 0,
  `delivery_instructions` text DEFAULT NULL,
  `comments` varchar(512) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `edited_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_deleted` datetime NOT NULL DEFAULT '1000-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `orders_info`
--

CREATE TABLE `orders_info` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sales_person` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `start_financial_year` varchar(15) NOT NULL,
  `sale_order_no` varchar(255) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_phone_number` varchar(255) DEFAULT NULL,
  `payment_verification` enum('pending','accept','reject') NOT NULL DEFAULT 'pending',
  `payment_receipt_url` varchar(100) NOT NULL,
  `status` enum('To_Be_Approved_From_Account','Pending_At_Dispatch_Manager','Po_Sent','Order_Processed','Loading','Reaching_Store','Ready_For_Pick_Up','Dispatched','Delivered','Picked_Up','Cancelled') NOT NULL DEFAULT 'To_Be_Approved_From_Account',
  `pending_material` varchar(255) DEFAULT NULL,
  `customer_address` varchar(1000) DEFAULT NULL,
  `delivery_address` text DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_deleted` enum('yes','no') NOT NULL DEFAULT 'no',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `order_type` enum('new_order','shortage_order') DEFAULT NULL,
  `quote_order_amount` decimal(20,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_reschedule_datas`
--

CREATE TABLE `order_reschedule_datas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `old_delivery_date` date DEFAULT NULL,
  `old_delivery_time` enum('first_half','second_half') NOT NULL DEFAULT 'second_half',
  `new_delivery_date` date NOT NULL DEFAULT '2024-01-24',
  `new_delivery_time` enum('first_half','second_half') NOT NULL DEFAULT 'second_half',
  `reason_for_reschedule` longtext DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `order_tasks`
--

CREATE TABLE `order_tasks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `po_name` varchar(255) DEFAULT NULL,
  `po_code` varchar(255) DEFAULT NULL,
  `task_status` enum('pending','arranged') NOT NULL DEFAULT 'pending',
  `document_id` bigint(20) UNSIGNED DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `assigned_by` int(11) DEFAULT NULL,
  `task_completed_date` date DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `delivery_date` date NOT NULL DEFAULT '2024-01-24',
  `delivery_time` enum('first_half','second_half') NOT NULL DEFAULT 'second_half',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_status` enum('paid','partially_paid','not_paid') NOT NULL DEFAULT 'not_paid',
  `order_amount` decimal(20,2) NOT NULL,
  `partial_amount` decimal(20,2) DEFAULT 0.00,
  `Ref_no` varchar(255) DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` int(11) NOT NULL,
  `payment_mode` enum('cash','bank_transfer','upi','cheque','dd','credit','card_swipe','razorpay','credit_notes','others') NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `product_id` varchar(80) DEFAULT NULL,
  `product_name` varchar(512) NOT NULL,
  `product_sku` varchar(256) NOT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `unit_of_measurement` enum('Sq.ft','Kg','Set','Piece') NOT NULL,
  `country_of_manufacture` int(11) DEFAULT NULL,
  `product_code` bigint(20) NOT NULL,
  `product_hsn_code` bigint(20) NOT NULL,
  `product_packing` varchar(256) NOT NULL,
  `product_size` int(11) NOT NULL,
  `product_finish` int(11) DEFAULT NULL,
  `product_material_type` int(11) DEFAULT NULL,
  `vendor_company_name` int(11) DEFAULT NULL,
  `product_weight` varchar(256) DEFAULT NULL,
  `product_quality` int(11) DEFAULT NULL,
  `web_url` varchar(256) DEFAULT NULL,
  `final_price` decimal(10,2) NOT NULL,
  `mrp` decimal(10,2) NOT NULL,
  `discount` decimal(10,3) DEFAULT NULL,
  `gst_rate` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL,
  `purchase_rate` decimal(10,2) DEFAULT NULL,
  `inventory` int(11) NOT NULL,
  `coverage` varchar(100) DEFAULT NULL,
  `delivery_time` int(11) DEFAULT NULL,
  `product_status` enum('added','active','inactive','deleted') NOT NULL DEFAULT 'added',
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `id` int(11) NOT NULL,
  `product_id` varchar(80) NOT NULL,
  `product_category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_multiple_images`
--

CREATE TABLE `product_multiple_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `file_name` varchar(256) NOT NULL,
  `product_image_key` varchar(256) NOT NULL,
  `product_image_500x500` varchar(256) NOT NULL,
  `product_image_100x100` varchar(256) NOT NULL,
  `feature_image` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `product_uses`
--

CREATE TABLE `product_uses` (
  `id` int(11) NOT NULL,
  `product_id` varchar(80) NOT NULL,
  `product_uses_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `quotation`
--

CREATE TABLE `quotation` (
  `id` int(11) NOT NULL,
  `customer_id` bigint(20) NOT NULL,
  `any_other_reference` varchar(512) DEFAULT NULL,
  `billing_address_line_1` varchar(2000) DEFAULT NULL,
  `billing_address_line_2` varchar(1000) DEFAULT NULL,
  `billing_city_name` varchar(100) DEFAULT NULL,
  `billing_address_pincode` varchar(20) DEFAULT NULL,
  `billing_gst_number` varchar(20) DEFAULT NULL,
  `billing_address_phone` varchar(50) DEFAULT NULL,
  `billing_state_name` varchar(50) DEFAULT NULL,
  `shipping_address_line_1` varchar(2000) NOT NULL,
  `shipping_address_line_2` varchar(500) DEFAULT NULL,
  `shipping_address_pincode` varchar(50) DEFAULT NULL,
  `shipping_gst_number` varchar(50) DEFAULT NULL,
  `shipping_address_phone` varchar(50) DEFAULT NULL,
  `shipping_state_name` varchar(50) DEFAULT NULL,
  `shipping_city_name` varchar(100) DEFAULT NULL,
  `quote_number` varchar(100) DEFAULT NULL,
  `po_number` varchar(100) DEFAULT NULL,
  `sales_executive_user` int(11) NOT NULL,
  `quote_date` date DEFAULT NULL,
  `quotation_status` enum('Open','Draft','Converted') NOT NULL DEFAULT 'Open',
  `order_status` enum('order placed','order dispatched','order completed') DEFAULT NULL,
  `quotation_type` enum('order','quotation') NOT NULL DEFAULT 'quotation',
  `stock_check_type` enum('Draft','Stock Check') NOT NULL DEFAULT 'Draft',
  `is_transportation` enum('0','1') NOT NULL DEFAULT '0',
  `transportation_charges` decimal(10,2) DEFAULT NULL,
  `transportation_charges_val` decimal(20,2) DEFAULT NULL,
  `is_unloading_charges` enum('0','1') NOT NULL DEFAULT '0',
  `unloading_charges` decimal(20,2) DEFAULT NULL,
  `unloading_charges_val` decimal(20,2) DEFAULT NULL,
  `total_taxable` decimal(20,2) DEFAULT NULL,
  `final_taxable` decimal(20,2) DEFAULT NULL,
  `is_discount_charges` enum('0','1') NOT NULL DEFAULT '0',
  `total_discount` decimal(20,3) DEFAULT NULL,
  `total_discount_val` decimal(20,2) DEFAULT NULL,
  `cgst` decimal(20,2) DEFAULT NULL,
  `sgst` decimal(20,2) DEFAULT NULL,
  `igst` decimal(20,2) DEFAULT NULL,
  `final_total` decimal(20,2) DEFAULT NULL,
  `terms_conditions` text DEFAULT NULL,
  `bank_details` varchar(2000) DEFAULT NULL,
  `payment_verified` enum('0','1') NOT NULL DEFAULT '0',
  `is_created_tally` enum('0','1') NOT NULL DEFAULT '0',
  `payment_receipt_url` varchar(200) DEFAULT NULL,
  `comment` varchar(2000) DEFAULT NULL,
  `indicator` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `quotation_products`
--

CREATE TABLE `quotation_products` (
  `id` bigint(20) NOT NULL,
  `quotation_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `enquiry_no` varchar(40) DEFAULT NULL,
  `hsn_code` bigint(20) NOT NULL,
  `unit_of_measurement` enum('Sq.ft','Kg','Set','Piece') NOT NULL,
  `quantity` bigint(20) NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `discount` decimal(20,4) DEFAULT NULL,
  `gst_rate` decimal(20,2) NOT NULL,
  `tax_amount` decimal(20,2) DEFAULT NULL,
  `vendor_id` int(11) NOT NULL,
  `description` longtext DEFAULT NULL,
  `total_amount` decimal(20,2) NOT NULL,
  `others_options` varchar(512) DEFAULT NULL,
  `stock_check_status` enum('Request Sent','Previously Available','Available','Not Available','Available Multiple Batches','Others','Not Responded') NOT NULL DEFAULT 'Request Sent',
  `not_available_quantity` int(11) DEFAULT NULL,
  `not_available_in_days` int(11) DEFAULT NULL,
  `order_product_status` enum('pending','order placed','order dispatched','order delivered','order completed') DEFAULT 'pending',
  `stock_check_type` enum('Stock Check','Draft') NOT NULL DEFAULT 'Draft',
  `enquiry_status` enum('New inquiry','Old inquiry') NOT NULL,
  `enquiry_date_time` datetime DEFAULT NULL,
  `is_ordered` enum('0','1') NOT NULL DEFAULT '0',
  `approved_by` int(11) DEFAULT NULL,
  `responded_in` datetime DEFAULT NULL,
  `responded_check` enum('0','1') NOT NULL DEFAULT '0',
  `is_deleted` enum('0','1') NOT NULL DEFAULT '0',
  `created_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `quotation_products_history`
--

CREATE TABLE `quotation_products_history` (
  `id` int(11) NOT NULL,
  `quotation_product_id` bigint(20) NOT NULL,
  `field_value` varchar(200) NOT NULL,
  `old_value` varchar(200) DEFAULT NULL,
  `new_value` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `razorpay_informations`
--

CREATE TABLE `razorpay_informations` (
  `id` int(11) NOT NULL,
  `payment_id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `sale_order_no` varchar(255) DEFAULT NULL,
  `order_amount` float NOT NULL,
  `payment_mode` enum('Cash','Bank Transfer','UPI','Cheque','DD','Credit','Card Swipe','Razorpay','Others') DEFAULT 'Razorpay',
  `generated_link` varchar(255) NOT NULL,
  `comment` text DEFAULT NULL,
  `payment` enum('True','False') NOT NULL DEFAULT 'False',
  `currency` varchar(255) DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `reminders`
--

CREATE TABLE `reminders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reminder_id` varchar(255) DEFAULT NULL,
  `sale_order_no` varchar(255) DEFAULT NULL,
  `comment` longtext NOT NULL,
  `status` enum('completed','not_completed') NOT NULL DEFAULT 'not_completed',
  `schedule_date` date NOT NULL,
  `schedule_time` time NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `reminder_timing` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `reminder_media`
--

CREATE TABLE `reminder_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `thumbnail_path` varchar(255) DEFAULT NULL,
  `min_path` varchar(255) DEFAULT NULL,
  `media_type` enum('image','pdf') DEFAULT NULL,
  `reminder_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles_permission`
--

CREATE TABLE `roles_permission` (
  `id` int(11) NOT NULL,
  `role_id` varchar(40) NOT NULL,
  `module_id` int(11) NOT NULL,
  `read_permission` enum('1','0') DEFAULT '0',
  `add_permission` enum('1','0') DEFAULT '0',
  `edit_permission` enum('1','0') DEFAULT '0',
  `delete_permission` enum('1','0') DEFAULT '0',
  `is_visible` enum('1','0') DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles_permission`
--

INSERT INTO `roles_permission` (`id`, `role_id`, `module_id`, `read_permission`, `add_permission`, `edit_permission`, `delete_permission`, `is_visible`) VALUES
(1, '1', 1, '1', '1', '1', '1', '1'),
(2, '1', 2, '1', '1', '1', '1', '1'),
(3, '1', 3, '1', '1', '1', '1', '1'),
(4, '1', 4, '1', '1', '1', '1', '1'),
(5, '1', 5, '1', '1', '1', '1', '1'),
(6, '1', 6, '1', '1', '1', '1', '1'),
(7, '1', 7, '1', '1', '1', '1', '1'),
(8, '1', 9, '1', '1', '1', '1', '1'),
(9, '1', 10, '1', '1', '1', '1', '1'),
(10, '1', 11, '1', '1', '1', '1', '1'),
(11, '1', 12, '1', '1', '1', '1', '1'),
(12, '1', 13, '1', '1', '1', '1', '1'),
(13, '1', 14, '1', '1', '1', '1', '1'),
(14, '1', 15, '1', '1', '1', '1', '1'),
(15, '1', 16, '1', '1', '1', '1', '1'),
(16, '1', 17, '1', '1', '1', '1', '1'),
(17, '1', 18, '1', '1', '1', '1', '1'),
(18, '1', 19, '1', '1', '1', '1', '1'),
(20, '1', 21, '1', '1', '1', '1', '1'),
(21, '1', 22, '1', '1', '1', '1', '1'),
(22, '1', 23, '1', '1', '1', '1', '1'),
(23, '1', 24, '1', '1', '1', '1', '1'),
(24, '1', 25, '1', '1', '1', '1', '1'),
(25, '1', 26, '1', '1', '1', '1', '1'),
(26, '1', 27, '1', '1', '1', '1', '1'),
(27, '1', 28, '1', '1', '1', '1', '1'),
(28, '1', 29, '1', '1', '1', '1', '1'),
(29, '1', 30, '1', '1', '1', '1', '1'),
(30, '1', 31, '1', '1', '1', '1', '1'),
(31, '1', 32, '1', '1', '1', '1', '1'),
(32, '1', 33, '1', '1', '1', '1', '1'),
(33, '1', 34, '1', '1', '1', '1', '1'),
(34, '1', 35, '1', '1', '1', '1', '1'),
(35, '1', 36, '1', '1', '1', '1', '1'),
(36, '1', 37, '1', '1', '1', '1', '1'),
(37, '1', 38, '1', '1', '1', '1', '1'),
(38, '1', 39, '1', '1', '1', '1', '1'),
(39, '1', 40, '1', '1', '1', '1', '1'),
(40, '1', 41, '1', '1', '1', '1', '1'),
(41, '1', 42, '1', '1', '1', '1', '1'),
(64, '2', 1, '1', '1', '1', '1', '1'),
(65, '2', 2, '1', '1', '1', '1', '1'),
(66, '2', 3, '1', '1', '1', '1', '1'),
(67, '2', 4, '1', '1', '1', '1', '1'),
(68, '2', 5, '1', '1', '1', '1', '1'),
(69, '2', 6, '1', '1', '1', '1', '1'),
(70, '2', 7, '0', '1', '1', '1', '1'),
(71, '2', 9, '1', '1', '1', '1', '1'),
(72, '2', 10, '1', '1', '1', '1', '1'),
(73, '2', 11, '0', '1', '1', '1', '1'),
(74, '2', 12, '1', '1', '1', '1', '1'),
(75, '2', 13, '1', '1', '1', '1', '1'),
(76, '2', 14, '1', '1', '1', '1', '1'),
(77, '2', 15, '1', '1', '1', '1', '1'),
(78, '2', 16, '0', '1', '1', '1', '1'),
(79, '2', 17, '1', '1', '1', '1', '1'),
(80, '2', 18, '1', '1', '1', '1', '1'),
(81, '2', 19, '1', '1', '1', '1', '1'),
(83, '2', 21, '1', '1', '1', '1', '1'),
(84, '2', 22, '1', '1', '1', '1', '1'),
(85, '2', 23, '0', '1', '1', '1', '1'),
(86, '2', 24, '1', '1', '1', '1', '1'),
(87, '2', 25, '1', '1', '1', '1', '1'),
(88, '2', 26, '0', '1', '1', '1', '1'),
(89, '2', 27, '0', '1', '1', '1', '1'),
(90, '2', 28, '0', '1', '1', '1', '1'),
(91, '2', 29, '1', '1', '1', '1', '1'),
(92, '2', 30, '1', '1', '1', '1', '1'),
(93, '2', 31, '1', '1', '1', '1', '1'),
(94, '2', 32, '1', '1', '1', '1', '1'),
(95, '2', 33, '0', '1', '1', '1', '1'),
(96, '2', 34, '1', '1', '1', '1', '1'),
(97, '2', 35, '0', '1', '1', '1', '1'),
(98, '2', 36, '1', '1', '1', '1', '1'),
(99, '2', 37, '0', '1', '1', '1', '1'),
(100, '2', 38, '1', '1', '1', '1', '1'),
(101, '2', 39, '0', '1', '1', '1', '1'),
(102, '2', 40, '0', '1', '1', '1', '1'),
(103, '2', 41, '0', '1', '1', '1', '1'),
(104, '2', 42, '0', '1', '1', '1', '1'),
(127, '3', 1, '1', '1', '1', '1', '1'),
(128, '3', 2, '1', '1', '1', '1', '1'),
(129, '3', 3, '0', '1', '1', '1', '1'),
(130, '3', 4, '0', '1', '1', '1', '1'),
(131, '3', 5, '0', '1', '1', '1', '1'),
(132, '3', 6, '1', '1', '1', '1', '1'),
(133, '3', 7, '0', '1', '1', '1', '1'),
(134, '3', 9, '0', '1', '1', '1', '1'),
(135, '3', 10, '0', '1', '1', '1', '1'),
(136, '3', 11, '0', '1', '1', '1', '1'),
(137, '3', 12, '0', '1', '1', '1', '1'),
(138, '3', 13, '1', '1', '1', '1', '1'),
(139, '3', 14, '0', '1', '1', '1', '1'),
(140, '3', 15, '1', '1', '1', '1', '1'),
(141, '3', 16, '0', '1', '1', '1', '1'),
(142, '3', 17, '0', '1', '1', '1', '1'),
(143, '3', 18, '0', '1', '1', '1', '1'),
(144, '3', 19, '0', '1', '1', '1', '1'),
(146, '3', 21, '0', '1', '1', '1', '1'),
(147, '3', 22, '0', '1', '1', '1', '1'),
(148, '3', 23, '0', '1', '1', '1', '1'),
(149, '3', 24, '0', '1', '1', '1', '1'),
(150, '3', 25, '1', '1', '1', '1', '1'),
(151, '3', 26, '0', '1', '1', '1', '1'),
(152, '3', 27, '0', '1', '1', '1', '1'),
(153, '3', 28, '0', '1', '1', '1', '1'),
(154, '3', 29, '0', '1', '1', '1', '1'),
(155, '3', 30, '0', '1', '1', '1', '1'),
(156, '3', 31, '0', '1', '1', '1', '1'),
(157, '3', 32, '1', '1', '1', '1', '1'),
(158, '3', 33, '1', '1', '1', '1', '1'),
(159, '3', 34, '0', '1', '1', '1', '1'),
(160, '3', 35, '0', '1', '1', '1', '1'),
(161, '3', 36, '0', '1', '1', '1', '1'),
(162, '3', 37, '0', '1', '1', '1', '1'),
(163, '3', 38, '0', '1', '1', '1', '1'),
(164, '3', 39, '0', '1', '1', '1', '1'),
(165, '3', 40, '1', '1', '1', '1', '1'),
(166, '3', 41, '0', '1', '1', '1', '1'),
(167, '3', 42, '1', '1', '1', '1', '1'),
(190, '4', 1, '1', '1', '1', '1', '1'),
(191, '4', 2, '0', '1', '1', '1', '1'),
(192, '4', 3, '0', '1', '1', '1', '1'),
(193, '4', 4, '0', '1', '1', '1', '1'),
(194, '4', 5, '0', '1', '1', '1', '1'),
(195, '4', 6, '1', '1', '1', '1', '1'),
(196, '4', 7, '0', '1', '1', '1', '1'),
(197, '4', 9, '0', '1', '1', '1', '1'),
(198, '4', 10, '0', '1', '1', '1', '1'),
(199, '4', 11, '0', '1', '1', '1', '1'),
(200, '4', 12, '0', '1', '1', '1', '1'),
(201, '4', 13, '0', '1', '1', '1', '1'),
(202, '4', 14, '0', '1', '1', '1', '1'),
(203, '4', 15, '0', '1', '1', '1', '1'),
(204, '4', 16, '0', '1', '1', '1', '1'),
(205, '4', 17, '0', '1', '1', '1', '1'),
(206, '4', 18, '0', '1', '1', '1', '1'),
(207, '4', 19, '0', '1', '1', '1', '1'),
(209, '4', 21, '0', '1', '1', '1', '1'),
(210, '4', 22, '0', '1', '1', '1', '1'),
(211, '4', 23, '0', '1', '1', '1', '1'),
(212, '4', 24, '0', '1', '1', '1', '1'),
(213, '4', 25, '1', '1', '1', '1', '1'),
(214, '4', 26, '0', '1', '1', '1', '1'),
(215, '4', 27, '0', '1', '1', '1', '1'),
(216, '4', 28, '0', '1', '1', '1', '1'),
(217, '4', 29, '0', '1', '1', '1', '1'),
(218, '4', 30, '0', '1', '1', '1', '1'),
(219, '4', 31, '0', '1', '1', '1', '1'),
(220, '4', 32, '1', '1', '1', '1', '1'),
(221, '4', 33, '1', '1', '1', '1', '1'),
(222, '4', 34, '0', '1', '1', '1', '1'),
(223, '4', 35, '0', '1', '1', '1', '1'),
(224, '4', 36, '0', '1', '1', '1', '1'),
(225, '4', 37, '0', '1', '1', '1', '1'),
(226, '4', 38, '0', '1', '1', '1', '1'),
(227, '4', 39, '0', '1', '1', '1', '1'),
(228, '4', 40, '1', '1', '1', '1', '1'),
(229, '4', 41, '0', '1', '1', '1', '1'),
(230, '4', 42, '0', '1', '1', '1', '1'),
(253, '5', 1, '0', '1', '1', '1', '1'),
(254, '5', 2, '0', '1', '1', '1', '1'),
(255, '5', 3, '1', '1', '1', '1', '1'),
(256, '5', 4, '0', '1', '1', '1', '1'),
(257, '5', 5, '0', '1', '1', '1', '1'),
(258, '5', 6, '0', '1', '1', '1', '1'),
(259, '5', 7, '0', '1', '1', '1', '1'),
(260, '5', 9, '1', '1', '1', '1', '1'),
(261, '5', 10, '1', '1', '1', '1', '1'),
(262, '5', 11, '0', '1', '1', '1', '1'),
(263, '5', 12, '1', '1', '1', '1', '1'),
(264, '5', 13, '0', '1', '1', '1', '1'),
(265, '5', 14, '0', '1', '1', '1', '1'),
(266, '5', 15, '0', '1', '1', '1', '1'),
(267, '5', 16, '0', '1', '1', '1', '1'),
(268, '5', 17, '0', '1', '1', '1', '1'),
(269, '5', 18, '0', '1', '1', '1', '1'),
(270, '5', 19, '0', '1', '1', '1', '1'),
(272, '5', 21, '0', '1', '1', '1', '1'),
(273, '5', 22, '0', '1', '1', '1', '1'),
(274, '5', 23, '0', '1', '1', '1', '1'),
(275, '5', 24, '0', '1', '1', '1', '1'),
(276, '5', 25, '0', '1', '1', '1', '1'),
(277, '5', 26, '0', '1', '1', '1', '1'),
(278, '5', 27, '0', '1', '1', '1', '1'),
(279, '5', 28, '0', '1', '1', '1', '1'),
(280, '5', 29, '0', '1', '1', '1', '1'),
(281, '5', 30, '0', '1', '1', '1', '1'),
(282, '5', 31, '0', '1', '1', '1', '1'),
(283, '5', 32, '0', '1', '1', '1', '1'),
(284, '5', 33, '0', '1', '1', '1', '1'),
(285, '5', 34, '0', '1', '1', '1', '1'),
(286, '5', 35, '0', '1', '1', '1', '1'),
(287, '5', 36, '0', '1', '1', '1', '1'),
(288, '5', 37, '0', '1', '1', '1', '1'),
(289, '5', 38, '0', '1', '1', '1', '1'),
(290, '5', 39, '0', '1', '1', '1', '1'),
(291, '5', 40, '0', '1', '1', '1', '1'),
(292, '5', 41, '0', '1', '1', '1', '1'),
(293, '5', 42, '0', '1', '1', '1', '1'),
(316, '6', 1, '1', '1', '1', '1', '1'),
(317, '6', 2, '0', '1', '1', '1', '1'),
(318, '6', 3, '0', '1', '1', '1', '1'),
(319, '6', 4, '1', '1', '1', '1', '1'),
(320, '6', 5, '1', '1', '1', '1', '1'),
(321, '6', 6, '0', '1', '1', '1', '1'),
(322, '6', 7, '0', '1', '1', '1', '1'),
(323, '6', 9, '0', '1', '1', '1', '1'),
(324, '6', 10, '0', '1', '1', '1', '1'),
(325, '6', 11, '0', '1', '1', '1', '1'),
(326, '6', 12, '0', '1', '1', '1', '1'),
(327, '6', 13, '0', '1', '1', '1', '1'),
(328, '6', 14, '0', '1', '1', '1', '1'),
(329, '6', 15, '0', '1', '1', '1', '1'),
(330, '6', 16, '0', '1', '1', '1', '1'),
(331, '6', 17, '0', '1', '1', '1', '1'),
(332, '6', 18, '1', '1', '1', '1', '1'),
(333, '6', 19, '1', '1', '1', '1', '1'),
(335, '6', 21, '0', '1', '1', '1', '1'),
(336, '6', 22, '1', '1', '1', '1', '1'),
(337, '6', 23, '0', '1', '1', '1', '1'),
(338, '6', 24, '0', '1', '1', '1', '1'),
(339, '6', 25, '0', '1', '1', '1', '1'),
(340, '6', 26, '0', '1', '1', '1', '1'),
(341, '6', 27, '0', '1', '1', '1', '1'),
(342, '6', 28, '0', '1', '1', '1', '1'),
(343, '6', 29, '0', '1', '1', '1', '1'),
(344, '6', 30, '1', '1', '1', '1', '1'),
(345, '6', 31, '1', '1', '1', '1', '1'),
(346, '6', 32, '0', '1', '1', '1', '1'),
(347, '6', 33, '0', '1', '1', '1', '1'),
(348, '6', 34, '0', '1', '1', '1', '1'),
(349, '6', 35, '1', '1', '1', '1', '1'),
(350, '6', 36, '0', '1', '1', '1', '1'),
(351, '6', 37, '1', '1', '1', '1', '1'),
(352, '6', 38, '0', '1', '1', '1', '1'),
(353, '6', 39, '1', '1', '1', '1', '1'),
(354, '6', 40, '0', '1', '1', '1', '1'),
(355, '6', 41, '1', '1', '1', '1', '1'),
(356, '6', 42, '0', '1', '1', '1', '1'),
(379, '49', 1, '0', '0', '0', '0', '0'),
(380, '49', 2, '0', '0', '0', '0', '0'),
(381, '49', 3, '0', '0', '0', '0', '0'),
(382, '49', 4, '1', '0', '0', '0', '0'),
(383, '49', 5, '1', '0', '0', '0', '0'),
(384, '49', 6, '0', '0', '0', '0', '0'),
(385, '49', 7, '0', '0', '0', '0', '0'),
(386, '49', 9, '0', '0', '0', '0', '0'),
(387, '49', 10, '0', '0', '0', '0', '0'),
(388, '49', 11, '0', '0', '0', '0', '0'),
(389, '49', 12, '0', '0', '0', '0', '0'),
(390, '49', 13, '1', '0', '0', '0', '0'),
(391, '49', 14, '1', '0', '0', '0', '0'),
(392, '49', 15, '1', '0', '0', '0', '0'),
(393, '49', 16, '1', '0', '0', '0', '0'),
(394, '49', 17, '1', '0', '0', '0', '0'),
(395, '49', 18, '1', '0', '0', '0', '0'),
(396, '49', 19, '0', '0', '0', '0', '0'),
(398, '49', 21, '1', '0', '0', '0', '0'),
(399, '49', 22, '1', '0', '0', '0', '0'),
(400, '49', 23, '1', '0', '0', '0', '0'),
(401, '49', 24, '1', '0', '0', '0', '0'),
(402, '49', 25, '1', '0', '0', '0', '0'),
(403, '49', 26, '0', '0', '0', '0', '0'),
(404, '49', 27, '0', '0', '0', '0', '0'),
(405, '49', 28, '0', '0', '0', '0', '0'),
(406, '49', 29, '0', '0', '0', '0', '0'),
(407, '49', 30, '0', '0', '0', '0', '0'),
(408, '49', 31, '0', '0', '0', '0', '0'),
(409, '49', 32, '0', '0', '0', '0', '0'),
(410, '49', 33, '0', '0', '0', '0', '0'),
(411, '49', 34, '0', '0', '0', '0', '0'),
(412, '49', 35, '0', '0', '0', '0', '0'),
(413, '49', 36, '0', '0', '0', '0', '0'),
(414, '49', 37, '0', '0', '0', '0', '0'),
(415, '49', 38, '0', '0', '0', '0', '0'),
(416, '49', 39, '0', '0', '0', '0', '0'),
(417, '49', 40, '1', '0', '0', '0', '0'),
(418, '49', 41, '1', '0', '0', '0', '0'),
(419, '49', 42, '1', '0', '0', '0', '0'),
(420, '50', 1, '0', '0', '0', '0', '0'),
(421, '50', 2, '0', '0', '0', '0', '0'),
(422, '50', 3, '0', '0', '0', '0', '0'),
(423, '50', 4, '0', '0', '0', '0', '0'),
(424, '50', 5, '0', '0', '0', '0', '0'),
(425, '50', 6, '0', '0', '0', '0', '0'),
(426, '50', 7, '0', '0', '0', '0', '0'),
(427, '50', 9, '0', '0', '0', '0', '0'),
(428, '50', 10, '0', '0', '0', '0', '0'),
(429, '50', 11, '0', '0', '0', '0', '0'),
(430, '50', 12, '0', '0', '0', '0', '0'),
(431, '50', 13, '0', '0', '0', '0', '0'),
(432, '50', 14, '0', '0', '0', '0', '0'),
(433, '50', 15, '0', '0', '0', '0', '0'),
(434, '50', 16, '0', '0', '0', '0', '0'),
(435, '50', 17, '0', '0', '0', '0', '0'),
(436, '50', 18, '0', '0', '0', '0', '0'),
(437, '50', 19, '0', '0', '0', '0', '0'),
(439, '50', 21, '0', '0', '0', '0', '0'),
(440, '50', 22, '0', '0', '0', '0', '0'),
(441, '50', 23, '0', '0', '0', '0', '0'),
(442, '50', 24, '0', '0', '0', '0', '0'),
(443, '50', 25, '0', '0', '0', '0', '0'),
(444, '50', 26, '0', '0', '0', '0', '0'),
(445, '50', 27, '0', '0', '0', '0', '0'),
(446, '50', 28, '0', '0', '0', '0', '0'),
(447, '50', 29, '0', '0', '0', '0', '0'),
(448, '50', 30, '0', '0', '0', '0', '0'),
(449, '50', 31, '0', '0', '0', '0', '0'),
(450, '50', 32, '0', '0', '0', '0', '0'),
(451, '50', 33, '0', '0', '0', '0', '0'),
(452, '50', 34, '0', '0', '0', '0', '0'),
(453, '50', 35, '0', '0', '0', '0', '0'),
(454, '50', 36, '0', '0', '0', '0', '0'),
(455, '50', 37, '0', '0', '0', '0', '0'),
(456, '50', 38, '0', '0', '0', '0', '0'),
(457, '50', 39, '0', '0', '0', '0', '0'),
(458, '50', 40, '0', '0', '0', '0', '0'),
(459, '50', 41, '0', '0', '0', '0', '0'),
(460, '50', 42, '0', '0', '0', '0', '0'),
(461, '7', 1, '0', '0', '0', '0', '0'),
(462, '7', 2, '0', '0', '0', '0', '0'),
(463, '7', 3, '0', '0', '0', '0', '0'),
(464, '7', 4, '0', '0', '0', '0', '0'),
(465, '7', 5, '0', '0', '0', '0', '0'),
(466, '7', 6, '0', '0', '0', '0', '0'),
(467, '7', 7, '0', '0', '0', '0', '0'),
(468, '7', 9, '0', '0', '0', '0', '0'),
(469, '7', 10, '0', '0', '0', '0', '0'),
(470, '7', 11, '0', '0', '0', '0', '0'),
(471, '7', 12, '0', '0', '0', '0', '0'),
(472, '7', 13, '0', '0', '0', '0', '0'),
(473, '7', 14, '0', '0', '0', '0', '0'),
(474, '7', 15, '0', '0', '0', '0', '0'),
(475, '7', 16, '0', '0', '0', '0', '0'),
(476, '7', 17, '0', '0', '0', '0', '0'),
(477, '7', 18, '0', '0', '0', '0', '0'),
(478, '7', 19, '0', '0', '0', '0', '0'),
(480, '7', 21, '0', '0', '0', '0', '0'),
(481, '7', 22, '0', '0', '0', '0', '0'),
(482, '7', 23, '0', '0', '0', '0', '0'),
(483, '7', 24, '0', '0', '0', '0', '0'),
(484, '7', 25, '0', '0', '0', '0', '0'),
(485, '7', 26, '0', '0', '0', '0', '0'),
(486, '7', 27, '0', '0', '0', '0', '0'),
(487, '7', 28, '0', '0', '0', '0', '0'),
(488, '7', 29, '0', '0', '0', '0', '0'),
(489, '7', 30, '0', '0', '0', '0', '0'),
(490, '7', 31, '0', '0', '0', '0', '0'),
(491, '7', 32, '0', '0', '0', '0', '0'),
(492, '7', 33, '0', '0', '0', '0', '0'),
(493, '7', 34, '0', '0', '0', '0', '0'),
(494, '7', 35, '0', '0', '0', '0', '0'),
(495, '7', 36, '0', '0', '0', '0', '0'),
(496, '7', 37, '0', '0', '0', '0', '0'),
(497, '7', 38, '0', '0', '0', '0', '0'),
(498, '7', 39, '0', '0', '0', '0', '0'),
(499, '7', 40, '0', '0', '0', '0', '0'),
(500, '7', 41, '0', '0', '0', '0', '0'),
(501, '7', 42, '0', '0', '0', '0', '0'),
(502, '8', 1, '0', '0', '0', '0', '0'),
(503, '8', 2, '0', '0', '0', '0', '0'),
(504, '8', 3, '0', '0', '0', '0', '0'),
(505, '8', 4, '0', '0', '0', '0', '0'),
(506, '8', 5, '0', '0', '0', '0', '0'),
(507, '8', 6, '0', '0', '0', '0', '0'),
(508, '8', 7, '0', '0', '0', '0', '0'),
(509, '8', 9, '0', '0', '0', '0', '0'),
(510, '8', 10, '0', '0', '0', '0', '0'),
(511, '8', 11, '0', '0', '0', '0', '0'),
(512, '8', 12, '0', '0', '0', '0', '0'),
(513, '8', 13, '0', '0', '0', '0', '0'),
(514, '8', 14, '0', '0', '0', '0', '0'),
(515, '8', 15, '0', '0', '0', '0', '0'),
(516, '8', 16, '0', '0', '0', '0', '0'),
(517, '8', 17, '0', '0', '0', '0', '0'),
(518, '8', 18, '0', '0', '0', '0', '0'),
(519, '8', 19, '0', '0', '0', '0', '0'),
(521, '8', 21, '0', '0', '0', '0', '0'),
(522, '8', 22, '0', '0', '0', '0', '0'),
(523, '8', 23, '0', '0', '0', '0', '0'),
(524, '8', 24, '0', '0', '0', '0', '0'),
(525, '8', 25, '0', '0', '0', '0', '0'),
(526, '8', 26, '1', '0', '0', '0', '0'),
(527, '8', 27, '0', '0', '0', '0', '0'),
(528, '8', 28, '0', '0', '0', '0', '0'),
(529, '8', 29, '0', '0', '0', '0', '0'),
(530, '8', 30, '0', '0', '0', '0', '0'),
(531, '8', 31, '0', '0', '0', '0', '0'),
(532, '8', 32, '0', '0', '0', '0', '0'),
(533, '8', 33, '0', '0', '0', '0', '0'),
(534, '8', 34, '0', '0', '0', '0', '0'),
(535, '8', 35, '0', '0', '0', '0', '0'),
(536, '8', 36, '0', '0', '0', '0', '0'),
(537, '8', 37, '0', '0', '0', '0', '0'),
(538, '8', 38, '0', '0', '0', '0', '0'),
(539, '8', 39, '0', '0', '0', '0', '0'),
(540, '8', 40, '0', '0', '0', '0', '0'),
(541, '8', 41, '0', '0', '0', '0', '0'),
(542, '8', 42, '0', '0', '0', '0', '0'),
(543, '9', 1, '0', '0', '0', '0', '0'),
(544, '9', 2, '0', '0', '0', '0', '0'),
(545, '9', 3, '0', '0', '0', '0', '0'),
(546, '9', 4, '0', '0', '0', '0', '0'),
(547, '9', 5, '0', '0', '0', '0', '0'),
(548, '9', 6, '0', '0', '0', '0', '0'),
(549, '9', 7, '0', '0', '0', '0', '0'),
(550, '9', 9, '0', '0', '0', '0', '0'),
(551, '9', 10, '0', '0', '0', '0', '0'),
(552, '9', 11, '0', '0', '0', '0', '0'),
(553, '9', 12, '0', '0', '0', '0', '0'),
(554, '9', 13, '0', '0', '0', '0', '0'),
(555, '9', 14, '0', '0', '0', '0', '0'),
(556, '9', 15, '0', '0', '0', '0', '0'),
(557, '9', 16, '0', '0', '0', '0', '0'),
(558, '9', 17, '0', '0', '0', '0', '0'),
(559, '9', 18, '0', '0', '0', '0', '0'),
(560, '9', 19, '0', '0', '0', '0', '0'),
(562, '9', 21, '0', '0', '0', '0', '0'),
(563, '9', 22, '0', '0', '0', '0', '0'),
(564, '9', 23, '0', '0', '0', '0', '0'),
(565, '9', 24, '0', '0', '0', '0', '0'),
(566, '9', 25, '0', '0', '0', '0', '0'),
(567, '9', 26, '0', '0', '0', '0', '0'),
(568, '9', 27, '0', '0', '0', '0', '0'),
(569, '9', 28, '0', '0', '0', '0', '0'),
(570, '9', 29, '0', '0', '0', '0', '0'),
(571, '9', 30, '0', '0', '0', '0', '0'),
(572, '9', 31, '0', '0', '0', '0', '0'),
(573, '9', 32, '0', '0', '0', '0', '0'),
(574, '9', 33, '0', '0', '0', '0', '0'),
(575, '9', 34, '0', '0', '0', '0', '0'),
(576, '9', 35, '0', '0', '0', '0', '0'),
(577, '9', 36, '0', '0', '0', '0', '0'),
(578, '9', 37, '0', '0', '0', '0', '0'),
(579, '9', 38, '0', '0', '0', '0', '0'),
(580, '9', 39, '0', '0', '0', '0', '0'),
(581, '9', 40, '0', '0', '0', '0', '0'),
(582, '9', 41, '0', '0', '0', '0', '0'),
(583, '9', 42, '0', '0', '0', '0', '0'),
(753, '14', 1, '0', '0', '0', '0', '0'),
(754, '14', 2, '1', '0', '0', '0', '0'),
(755, '14', 3, '0', '0', '0', '0', '0'),
(756, '14', 4, '0', '0', '0', '0', '0'),
(757, '14', 5, '0', '0', '0', '0', '0'),
(758, '14', 6, '0', '0', '0', '0', '0'),
(759, '14', 7, '0', '0', '0', '0', '0'),
(760, '14', 9, '0', '0', '0', '0', '0'),
(761, '14', 10, '0', '0', '0', '0', '0'),
(762, '14', 11, '0', '0', '0', '0', '0'),
(763, '14', 12, '0', '0', '0', '0', '0'),
(764, '14', 13, '0', '0', '0', '0', '0'),
(765, '14', 14, '0', '0', '0', '0', '0'),
(766, '14', 15, '0', '0', '0', '0', '0'),
(767, '14', 16, '0', '0', '0', '0', '0'),
(768, '14', 17, '0', '0', '0', '0', '0'),
(769, '14', 18, '0', '0', '0', '0', '0'),
(770, '14', 19, '0', '0', '0', '0', '0'),
(772, '14', 21, '0', '0', '0', '0', '0'),
(773, '14', 22, '0', '0', '0', '0', '0'),
(774, '14', 23, '0', '0', '0', '0', '0'),
(775, '14', 24, '0', '0', '0', '0', '0'),
(776, '14', 25, '0', '0', '0', '0', '0'),
(777, '14', 26, '0', '0', '0', '0', '0'),
(778, '14', 27, '0', '0', '0', '0', '0'),
(779, '14', 28, '0', '0', '0', '0', '0'),
(780, '14', 29, '0', '0', '0', '0', '0'),
(781, '14', 30, '0', '0', '0', '0', '0'),
(782, '14', 31, '0', '0', '0', '0', '0'),
(783, '14', 32, '0', '0', '0', '0', '0'),
(784, '14', 33, '0', '0', '0', '0', '0'),
(785, '14', 34, '0', '0', '0', '0', '0'),
(786, '14', 35, '0', '0', '0', '0', '0'),
(787, '14', 36, '0', '0', '0', '0', '0'),
(788, '14', 37, '0', '0', '0', '0', '0'),
(789, '14', 38, '0', '0', '0', '0', '0'),
(790, '14', 39, '0', '0', '0', '0', '0'),
(791, '14', 40, '0', '0', '0', '0', '0'),
(792, '14', 41, '0', '0', '0', '0', '0'),
(793, '14', 42, '0', '0', '0', '0', '0'),
(794, '14', 43, '0', '0', '0', '0', '0'),
(963, '14', 1, '0', '0', '0', '0', '0'),
(964, '14', 2, '0', '0', '0', '0', '0'),
(965, '14', 3, '0', '0', '0', '0', '0'),
(966, '14', 4, '0', '0', '0', '0', '0'),
(967, '14', 5, '0', '0', '0', '0', '0'),
(968, '14', 6, '0', '0', '0', '0', '0'),
(969, '14', 7, '0', '0', '0', '0', '0'),
(970, '14', 9, '0', '0', '0', '0', '0'),
(971, '14', 10, '0', '0', '0', '0', '0'),
(972, '14', 11, '0', '0', '0', '0', '0'),
(973, '14', 12, '0', '0', '0', '0', '0'),
(974, '14', 13, '0', '0', '0', '0', '0'),
(975, '14', 14, '0', '0', '0', '0', '0'),
(976, '14', 15, '0', '0', '0', '0', '0'),
(977, '14', 16, '0', '0', '0', '0', '0'),
(978, '14', 17, '0', '0', '0', '0', '0'),
(979, '14', 18, '0', '0', '0', '0', '0'),
(980, '14', 19, '0', '0', '0', '0', '0'),
(982, '14', 21, '0', '0', '0', '0', '0'),
(983, '14', 22, '0', '0', '0', '0', '0'),
(984, '14', 23, '0', '0', '0', '0', '0'),
(985, '14', 24, '0', '0', '0', '0', '0'),
(986, '14', 25, '0', '0', '0', '0', '0'),
(987, '14', 26, '0', '0', '0', '0', '0'),
(988, '14', 27, '0', '0', '0', '0', '0'),
(989, '14', 28, '0', '0', '0', '0', '0'),
(990, '14', 29, '0', '0', '0', '0', '0'),
(991, '14', 30, '0', '0', '0', '0', '0'),
(992, '14', 31, '0', '0', '0', '0', '0'),
(993, '14', 32, '0', '0', '0', '0', '0'),
(994, '14', 33, '0', '0', '0', '0', '0'),
(995, '14', 34, '0', '0', '0', '0', '0'),
(996, '14', 35, '0', '0', '0', '0', '0'),
(997, '14', 36, '0', '0', '0', '0', '0'),
(998, '14', 37, '0', '0', '0', '0', '0'),
(999, '14', 38, '0', '0', '0', '0', '0'),
(1000, '14', 39, '0', '0', '0', '0', '0'),
(1001, '14', 40, '0', '0', '0', '0', '0'),
(1002, '14', 41, '0', '0', '0', '0', '0'),
(1003, '14', 42, '0', '0', '0', '0', '0'),
(1004, '14', 43, '0', '0', '0', '0', '0'),
(1005, '15', 1, '0', '0', '0', '0', '0'),
(1006, '15', 2, '0', '0', '0', '0', '0'),
(1007, '15', 3, '1', '0', '0', '0', '0'),
(1008, '15', 4, '0', '0', '0', '0', '0'),
(1009, '15', 5, '0', '0', '0', '0', '0'),
(1010, '15', 6, '0', '0', '0', '0', '0'),
(1011, '15', 7, '0', '0', '0', '0', '0'),
(1012, '15', 9, '1', '0', '0', '0', '0'),
(1013, '15', 10, '1', '0', '0', '0', '0'),
(1014, '15', 11, '0', '0', '0', '0', '0'),
(1015, '15', 12, '1', '0', '0', '0', '0'),
(1016, '15', 13, '1', '0', '0', '0', '0'),
(1017, '15', 14, '0', '0', '0', '0', '0'),
(1018, '15', 15, '0', '0', '0', '0', '0'),
(1019, '15', 16, '0', '0', '0', '0', '0'),
(1020, '15', 17, '1', '0', '0', '0', '0'),
(1021, '15', 18, '1', '0', '0', '0', '0'),
(1022, '15', 19, '1', '0', '0', '0', '0'),
(1024, '15', 21, '0', '0', '0', '0', '0'),
(1025, '15', 22, '0', '0', '0', '0', '0'),
(1026, '15', 23, '0', '0', '0', '0', '0'),
(1027, '15', 24, '1', '0', '0', '0', '0'),
(1028, '15', 25, '0', '0', '0', '0', '0'),
(1029, '15', 26, '0', '0', '0', '0', '0'),
(1030, '15', 27, '0', '0', '0', '0', '0'),
(1031, '15', 28, '0', '0', '0', '0', '0'),
(1032, '15', 29, '1', '0', '0', '0', '0'),
(1033, '15', 30, '0', '0', '0', '0', '0'),
(1034, '15', 31, '1', '0', '0', '0', '0'),
(1035, '15', 32, '0', '0', '0', '0', '0'),
(1036, '15', 33, '0', '0', '0', '0', '0'),
(1037, '15', 34, '0', '0', '0', '0', '0'),
(1038, '15', 35, '0', '0', '0', '0', '0'),
(1039, '15', 36, '0', '0', '0', '0', '0'),
(1040, '15', 37, '0', '0', '0', '0', '0'),
(1041, '15', 38, '0', '0', '0', '0', '0'),
(1042, '15', 39, '0', '0', '0', '0', '0'),
(1043, '15', 40, '0', '0', '0', '0', '0'),
(1044, '15', 41, '0', '0', '0', '0', '0'),
(1045, '15', 42, '0', '0', '0', '0', '0'),
(1046, '15', 43, '1', '0', '0', '0', '0'),
(1047, '16', 1, '1', '0', '0', '0', '0'),
(1048, '16', 2, '0', '0', '0', '0', '0'),
(1049, '16', 3, '1', '0', '0', '0', '0'),
(1050, '16', 4, '1', '0', '0', '0', '0'),
(1051, '16', 5, '1', '0', '0', '0', '0'),
(1052, '16', 6, '1', '0', '0', '0', '0'),
(1053, '16', 7, '0', '0', '0', '0', '0'),
(1054, '16', 9, '1', '0', '0', '0', '0'),
(1055, '16', 10, '1', '0', '0', '0', '0'),
(1056, '16', 11, '1', '0', '0', '0', '0'),
(1057, '16', 12, '1', '0', '0', '0', '0'),
(1058, '16', 13, '1', '0', '0', '0', '0'),
(1059, '16', 14, '1', '0', '0', '0', '0'),
(1060, '16', 15, '1', '0', '0', '0', '0'),
(1061, '16', 16, '1', '0', '0', '0', '0'),
(1062, '16', 17, '1', '0', '0', '0', '0'),
(1063, '16', 18, '1', '0', '0', '0', '0'),
(1064, '16', 19, '1', '0', '0', '0', '0'),
(1066, '16', 21, '1', '0', '0', '0', '0'),
(1067, '16', 22, '1', '0', '0', '0', '0'),
(1068, '16', 23, '1', '0', '0', '0', '0'),
(1069, '16', 24, '1', '0', '0', '0', '0'),
(1070, '16', 25, '1', '0', '0', '0', '0'),
(1071, '16', 26, '1', '0', '0', '0', '0'),
(1072, '16', 27, '1', '0', '0', '0', '0'),
(1073, '16', 28, '1', '0', '0', '0', '0'),
(1074, '16', 29, '1', '0', '0', '0', '0'),
(1075, '16', 30, '1', '0', '0', '0', '0'),
(1076, '16', 31, '1', '0', '0', '0', '0'),
(1077, '16', 32, '1', '0', '0', '0', '0'),
(1078, '16', 33, '0', '0', '0', '0', '0'),
(1079, '16', 34, '1', '0', '0', '0', '0'),
(1080, '16', 35, '0', '0', '0', '0', '0'),
(1081, '16', 36, '1', '0', '0', '0', '0'),
(1082, '16', 37, '0', '0', '0', '0', '0'),
(1083, '16', 38, '1', '0', '0', '0', '0'),
(1084, '16', 39, '0', '0', '0', '0', '0'),
(1085, '16', 40, '0', '0', '0', '0', '0'),
(1086, '16', 41, '0', '0', '0', '0', '0'),
(1087, '16', 42, '0', '0', '0', '0', '0'),
(1088, '16', 43, '1', '0', '0', '0', '0'),
(1089, '1', 45, '1', '1', '1', '1', '1'),
(1090, '1', 46, '1', '1', '1', '1', '1'),
(1091, '1', 47, '1', '1', '1', '1', '1'),
(1092, '1', 48, '1', '1', '1', '1', '1'),
(1093, '1', 49, '1', '1', '1', '1', '1'),
(1096, '2', 45, '0', '1', '1', '1', '1'),
(1097, '2', 46, '0', '1', '1', '1', '1'),
(1098, '2', 47, '0', '1', '1', '1', '1'),
(1099, '2', 48, '0', '1', '1', '1', '1'),
(1100, '2', 49, '0', '1', '1', '1', '1'),
(1103, '3', 45, '0', '1', '1', '1', '1'),
(1104, '3', 46, '1', '1', '1', '1', '1'),
(1105, '3', 47, '1', '1', '1', '1', '1'),
(1106, '3', 48, '1', '1', '1', '1', '1'),
(1107, '3', 49, '1', '1', '1', '1', '1'),
(1110, '4', 45, '0', '1', '1', '1', '1'),
(1111, '4', 46, '0', '1', '1', '1', '1'),
(1112, '4', 47, '0', '1', '1', '1', '1'),
(1113, '4', 48, '0', '1', '1', '1', '1'),
(1114, '4', 49, '0', '1', '1', '1', '1'),
(1117, '5', 45, '0', '1', '1', '1', '1'),
(1118, '5', 46, '0', '1', '1', '1', '1'),
(1119, '5', 47, '0', '1', '1', '1', '1'),
(1120, '5', 48, '0', '1', '1', '1', '1'),
(1121, '5', 49, '0', '1', '1', '1', '1'),
(1124, '6', 45, '1', '1', '1', '1', '1'),
(1125, '6', 46, '0', '1', '1', '1', '1'),
(1126, '6', 47, '1', '1', '1', '1', '1'),
(1127, '6', 48, '1', '1', '1', '1', '1'),
(1128, '6', 49, '1', '1', '1', '1', '1'),
(1131, '7', 45, '1', '1', '1', '1', '1'),
(1132, '7', 46, '1', '1', '1', '1', '1'),
(1133, '7', 47, '1', '1', '1', '1', '1'),
(1134, '7', 48, '1', '1', '1', '1', '1'),
(1135, '7', 49, '1', '1', '1', '1', '1'),
(1138, '8', 45, '0', '1', '1', '1', '1'),
(1139, '8', 46, '0', '1', '1', '1', '1'),
(1140, '8', 47, '0', '1', '1', '1', '1'),
(1141, '8', 48, '0', '1', '1', '1', '1'),
(1142, '8', 49, '0', '1', '1', '1', '1'),
(1145, '9', 45, '0', '1', '1', '1', '1'),
(1146, '9', 46, '0', '1', '1', '1', '1'),
(1147, '9', 47, '0', '1', '1', '1', '1'),
(1148, '9', 48, '0', '1', '1', '1', '1'),
(1149, '9', 49, '0', '1', '1', '1', '1'),
(1159, '17', 1, '0', '0', '0', '0', '0'),
(1160, '17', 2, '1', '0', '0', '0', '0'),
(1161, '17', 3, '1', '0', '0', '0', '0'),
(1162, '17', 4, '1', '0', '0', '0', '0'),
(1163, '17', 5, '1', '0', '0', '0', '0'),
(1164, '17', 6, '1', '0', '0', '0', '0'),
(1165, '17', 7, '1', '0', '0', '0', '0'),
(1166, '17', 9, '0', '0', '0', '0', '0'),
(1167, '17', 10, '0', '0', '0', '0', '0'),
(1168, '17', 11, '0', '0', '0', '0', '0'),
(1169, '17', 12, '0', '0', '0', '0', '0'),
(1170, '17', 13, '1', '0', '0', '0', '0'),
(1171, '17', 14, '1', '0', '0', '0', '0'),
(1172, '17', 15, '1', '0', '0', '0', '0'),
(1173, '17', 16, '0', '0', '0', '0', '0'),
(1174, '17', 17, '0', '0', '0', '0', '0'),
(1175, '17', 18, '0', '0', '0', '0', '0'),
(1176, '17', 19, '0', '0', '0', '0', '0'),
(1177, '17', 21, '0', '0', '0', '0', '0'),
(1178, '17', 22, '0', '0', '0', '0', '0'),
(1179, '17', 23, '0', '0', '0', '0', '0'),
(1180, '17', 24, '0', '0', '0', '0', '0'),
(1181, '17', 25, '1', '0', '0', '0', '0'),
(1182, '17', 26, '0', '0', '0', '0', '0'),
(1183, '17', 27, '0', '0', '0', '0', '0'),
(1184, '17', 28, '0', '0', '0', '0', '0'),
(1185, '17', 29, '0', '0', '0', '0', '0'),
(1186, '17', 30, '0', '0', '0', '0', '0'),
(1187, '17', 31, '0', '0', '0', '0', '0'),
(1188, '17', 32, '0', '0', '0', '0', '0'),
(1189, '17', 33, '0', '0', '0', '0', '0'),
(1190, '17', 34, '0', '0', '0', '0', '0'),
(1191, '17', 35, '0', '0', '0', '0', '0'),
(1192, '17', 36, '0', '0', '0', '0', '0'),
(1193, '17', 37, '0', '0', '0', '0', '0'),
(1194, '17', 38, '0', '0', '0', '0', '0'),
(1195, '17', 39, '1', '0', '0', '0', '0'),
(1196, '17', 40, '1', '0', '0', '0', '0'),
(1197, '17', 41, '1', '0', '0', '0', '0'),
(1198, '17', 42, '1', '0', '0', '0', '0'),
(1199, '17', 43, '0', '0', '0', '0', '0'),
(1200, '17', 45, '1', '0', '0', '0', '0'),
(1201, '17', 46, '0', '0', '0', '0', '0'),
(1202, '17', 47, '0', '0', '0', '0', '0'),
(1203, '17', 48, '0', '0', '0', '0', '0'),
(1204, '17', 49, '0', '0', '0', '0', '0'),
(1205, '18', 1, '1', '0', '0', '0', '0'),
(1206, '18', 2, '0', '0', '0', '0', '0'),
(1207, '18', 3, '0', '0', '0', '0', '0'),
(1208, '18', 4, '1', '0', '0', '0', '0'),
(1209, '18', 5, '0', '0', '0', '0', '0'),
(1210, '18', 6, '0', '0', '0', '0', '0'),
(1211, '18', 7, '0', '0', '0', '0', '0'),
(1212, '18', 9, '0', '0', '0', '0', '0'),
(1213, '18', 10, '0', '0', '0', '0', '0'),
(1214, '18', 11, '0', '0', '0', '0', '0'),
(1215, '18', 12, '0', '0', '0', '0', '0'),
(1216, '18', 13, '0', '0', '0', '0', '0'),
(1217, '18', 14, '0', '0', '0', '0', '0'),
(1218, '18', 15, '0', '0', '0', '0', '0'),
(1219, '18', 16, '0', '0', '0', '0', '0'),
(1220, '18', 17, '0', '0', '0', '0', '0'),
(1221, '18', 18, '0', '0', '0', '0', '0'),
(1222, '18', 19, '0', '0', '0', '0', '0'),
(1223, '18', 21, '0', '0', '0', '0', '0'),
(1224, '18', 22, '0', '0', '0', '0', '0'),
(1225, '18', 23, '0', '0', '0', '0', '0'),
(1226, '18', 24, '0', '0', '0', '0', '0'),
(1227, '18', 25, '0', '0', '0', '0', '0'),
(1228, '18', 26, '0', '0', '0', '0', '0'),
(1229, '18', 27, '0', '0', '0', '0', '0'),
(1230, '18', 28, '0', '0', '0', '0', '0'),
(1231, '18', 29, '0', '0', '0', '0', '0'),
(1232, '18', 30, '0', '0', '0', '0', '0'),
(1233, '18', 31, '0', '0', '0', '0', '0'),
(1234, '18', 32, '0', '0', '0', '0', '0'),
(1235, '18', 33, '0', '0', '0', '0', '0'),
(1236, '18', 34, '0', '0', '0', '0', '0'),
(1237, '18', 35, '0', '0', '0', '0', '0'),
(1238, '18', 36, '0', '0', '0', '0', '0'),
(1239, '18', 37, '0', '0', '0', '0', '0'),
(1240, '18', 38, '0', '0', '0', '0', '0'),
(1241, '18', 39, '1', '0', '0', '0', '0'),
(1242, '18', 40, '0', '0', '0', '0', '0'),
(1243, '18', 41, '0', '0', '0', '0', '0'),
(1244, '18', 42, '0', '0', '0', '0', '0'),
(1245, '18', 43, '0', '0', '0', '0', '0'),
(1246, '18', 45, '0', '0', '0', '0', '0'),
(1247, '18', 46, '0', '0', '0', '0', '0'),
(1248, '18', 47, '0', '0', '0', '0', '0'),
(1249, '18', 48, '0', '0', '0', '0', '0'),
(1250, '18', 49, '0', '0', '0', '0', '0'),
(1251, '19', 1, '0', '0', '0', '0', '0'),
(1252, '19', 2, '0', '0', '0', '0', '0'),
(1253, '19', 3, '1', '0', '0', '0', '0'),
(1254, '19', 4, '0', '0', '0', '0', '0'),
(1255, '19', 5, '0', '0', '0', '0', '0'),
(1256, '19', 6, '0', '0', '0', '0', '0'),
(1257, '19', 7, '0', '0', '0', '0', '0'),
(1258, '19', 9, '1', '0', '0', '0', '0'),
(1259, '19', 10, '0', '0', '0', '0', '0'),
(1260, '19', 11, '0', '0', '0', '0', '0'),
(1261, '19', 12, '0', '0', '0', '0', '0'),
(1262, '19', 13, '0', '0', '0', '0', '0'),
(1263, '19', 14, '1', '0', '0', '0', '0'),
(1264, '19', 15, '0', '0', '0', '0', '0'),
(1265, '19', 16, '1', '0', '0', '0', '0'),
(1266, '19', 17, '0', '0', '0', '0', '0'),
(1267, '19', 18, '0', '0', '0', '0', '0'),
(1268, '19', 19, '0', '0', '0', '0', '0'),
(1269, '19', 21, '0', '0', '0', '0', '0'),
(1270, '19', 22, '0', '0', '0', '0', '0'),
(1271, '19', 23, '0', '0', '0', '0', '0'),
(1272, '19', 24, '0', '0', '0', '0', '0'),
(1273, '19', 25, '0', '0', '0', '0', '0'),
(1274, '19', 26, '0', '0', '0', '0', '0'),
(1275, '19', 27, '0', '0', '0', '0', '0'),
(1276, '19', 28, '0', '0', '0', '0', '0'),
(1277, '19', 29, '0', '0', '0', '0', '0'),
(1278, '19', 30, '0', '0', '0', '0', '0'),
(1279, '19', 31, '0', '0', '0', '0', '0'),
(1280, '19', 32, '0', '0', '0', '0', '0'),
(1281, '19', 33, '0', '0', '0', '0', '0'),
(1282, '19', 34, '0', '0', '0', '0', '0'),
(1283, '19', 35, '0', '0', '0', '0', '0'),
(1284, '19', 36, '0', '0', '0', '0', '0'),
(1285, '19', 37, '0', '0', '0', '0', '0'),
(1286, '19', 38, '0', '0', '0', '0', '0'),
(1287, '19', 39, '0', '0', '0', '0', '0'),
(1288, '19', 40, '0', '0', '0', '0', '0'),
(1289, '19', 41, '0', '0', '0', '0', '0'),
(1290, '19', 42, '0', '0', '0', '0', '0'),
(1291, '19', 43, '0', '0', '0', '0', '0'),
(1292, '19', 45, '0', '0', '0', '0', '0'),
(1293, '19', 46, '0', '0', '0', '0', '0'),
(1294, '19', 47, '0', '0', '0', '0', '0'),
(1295, '19', 48, '0', '0', '0', '0', '0'),
(1296, '19', 49, '0', '0', '0', '0', '0'),
(1297, '20', 1, '1', '0', '0', '0', '0'),
(1298, '20', 2, '1', '0', '0', '0', '0'),
(1299, '20', 3, '1', '0', '0', '0', '0'),
(1300, '20', 4, '1', '0', '0', '0', '0'),
(1301, '20', 5, '1', '0', '0', '0', '0'),
(1302, '20', 6, '1', '0', '0', '0', '0'),
(1303, '20', 7, '1', '0', '0', '0', '0'),
(1304, '20', 9, '1', '0', '0', '0', '0'),
(1305, '20', 10, '1', '0', '0', '0', '0'),
(1306, '20', 11, '0', '0', '0', '0', '0'),
(1307, '20', 12, '1', '0', '0', '0', '0'),
(1308, '20', 13, '0', '0', '0', '0', '0'),
(1309, '20', 14, '0', '0', '0', '0', '0'),
(1310, '20', 15, '1', '0', '0', '0', '0'),
(1311, '20', 16, '1', '0', '0', '0', '0'),
(1312, '20', 17, '1', '0', '0', '0', '0'),
(1313, '20', 18, '1', '0', '0', '0', '0'),
(1314, '20', 19, '1', '0', '0', '0', '0'),
(1315, '20', 21, '1', '0', '0', '0', '0'),
(1316, '20', 22, '1', '0', '0', '0', '0'),
(1317, '20', 23, '1', '0', '0', '0', '0'),
(1318, '20', 24, '1', '0', '0', '0', '0'),
(1319, '20', 25, '1', '0', '0', '0', '0'),
(1320, '20', 26, '1', '0', '0', '0', '0'),
(1321, '20', 27, '1', '0', '0', '0', '0'),
(1322, '20', 28, '1', '0', '0', '0', '0'),
(1323, '20', 29, '1', '0', '0', '0', '0'),
(1324, '20', 30, '1', '0', '0', '0', '0'),
(1325, '20', 31, '1', '0', '0', '0', '0'),
(1326, '20', 32, '1', '0', '0', '0', '0'),
(1327, '20', 33, '1', '0', '0', '0', '0'),
(1328, '20', 34, '1', '0', '0', '0', '0'),
(1329, '20', 35, '1', '0', '0', '0', '0'),
(1330, '20', 36, '1', '0', '0', '0', '0'),
(1331, '20', 37, '1', '0', '0', '0', '0'),
(1332, '20', 38, '1', '0', '0', '0', '0'),
(1333, '20', 39, '1', '0', '0', '0', '0'),
(1334, '20', 40, '0', '0', '0', '0', '0'),
(1335, '20', 41, '1', '0', '0', '0', '0'),
(1336, '20', 42, '1', '0', '0', '0', '0'),
(1337, '20', 43, '1', '0', '0', '0', '0'),
(1338, '20', 45, '1', '0', '0', '0', '0'),
(1339, '20', 46, '1', '0', '0', '0', '0'),
(1340, '20', 47, '1', '0', '0', '0', '0'),
(1341, '20', 48, '1', '0', '0', '0', '0'),
(1342, '20', 49, '1', '0', '0', '0', '0'),
(1343, '21', 1, '1', '0', '0', '0', '0'),
(1344, '21', 2, '1', '0', '0', '0', '0'),
(1345, '21', 3, '1', '0', '0', '0', '0'),
(1346, '21', 4, '1', '0', '0', '0', '0'),
(1347, '21', 5, '1', '0', '0', '0', '0'),
(1348, '21', 6, '1', '0', '0', '0', '0'),
(1349, '21', 7, '1', '0', '0', '0', '0'),
(1350, '21', 9, '1', '0', '0', '0', '0'),
(1351, '21', 10, '1', '0', '0', '0', '0'),
(1352, '21', 11, '1', '0', '0', '0', '0'),
(1353, '21', 12, '1', '0', '0', '0', '0'),
(1354, '21', 13, '1', '0', '0', '0', '0'),
(1355, '21', 14, '1', '0', '0', '0', '0'),
(1356, '21', 15, '1', '0', '0', '0', '0'),
(1357, '21', 16, '1', '0', '0', '0', '0'),
(1358, '21', 17, '1', '0', '0', '0', '0'),
(1359, '21', 18, '1', '0', '0', '0', '0'),
(1360, '21', 19, '1', '0', '0', '0', '0'),
(1361, '21', 21, '1', '0', '0', '0', '0'),
(1362, '21', 22, '1', '0', '0', '0', '0'),
(1363, '21', 23, '1', '0', '0', '0', '0'),
(1364, '21', 24, '1', '0', '0', '0', '0'),
(1365, '21', 25, '1', '0', '0', '0', '0'),
(1366, '21', 26, '1', '0', '0', '0', '0'),
(1367, '21', 27, '1', '0', '0', '0', '0'),
(1368, '21', 28, '1', '0', '0', '0', '0'),
(1369, '21', 29, '1', '0', '0', '0', '0'),
(1370, '21', 30, '1', '0', '0', '0', '0'),
(1371, '21', 31, '1', '0', '0', '0', '0'),
(1372, '21', 32, '1', '0', '0', '0', '0'),
(1373, '21', 33, '1', '0', '0', '0', '0'),
(1374, '21', 34, '1', '0', '0', '0', '0'),
(1375, '21', 35, '1', '0', '0', '0', '0'),
(1376, '21', 36, '1', '0', '0', '0', '0'),
(1377, '21', 37, '1', '0', '0', '0', '0'),
(1378, '21', 38, '1', '0', '0', '0', '0'),
(1379, '21', 39, '1', '0', '0', '0', '0'),
(1380, '21', 40, '0', '0', '0', '0', '0'),
(1381, '21', 41, '1', '0', '0', '0', '0'),
(1382, '21', 42, '1', '0', '0', '0', '0'),
(1383, '21', 43, '1', '0', '0', '0', '0'),
(1384, '21', 45, '0', '0', '0', '0', '0'),
(1385, '21', 46, '0', '0', '0', '0', '0'),
(1386, '21', 47, '0', '0', '0', '0', '0'),
(1387, '21', 48, '0', '0', '0', '0', '0'),
(1388, '21', 49, '0', '0', '0', '0', '0'),
(1389, '22', 1, '0', '0', '0', '0', '0'),
(1390, '22', 2, '0', '0', '0', '0', '0'),
(1391, '22', 3, '1', '0', '0', '0', '0'),
(1392, '22', 4, '0', '0', '0', '0', '0'),
(1393, '22', 5, '1', '0', '0', '0', '0'),
(1394, '22', 6, '0', '0', '0', '0', '0'),
(1395, '22', 7, '0', '0', '0', '0', '0'),
(1396, '22', 9, '0', '0', '0', '0', '0'),
(1397, '22', 10, '0', '0', '0', '0', '0'),
(1398, '22', 11, '0', '0', '0', '0', '0'),
(1399, '22', 12, '0', '0', '0', '0', '0'),
(1400, '22', 13, '1', '0', '0', '0', '0'),
(1401, '22', 14, '1', '0', '0', '0', '0'),
(1402, '22', 15, '1', '0', '0', '0', '0'),
(1403, '22', 16, '1', '0', '0', '0', '0'),
(1404, '22', 17, '1', '0', '0', '0', '0'),
(1405, '22', 18, '1', '0', '0', '0', '0'),
(1406, '22', 19, '1', '0', '0', '0', '0'),
(1407, '22', 21, '1', '0', '0', '0', '0'),
(1408, '22', 22, '1', '0', '0', '0', '0'),
(1409, '22', 23, '1', '0', '0', '0', '0'),
(1410, '22', 24, '1', '0', '0', '0', '0'),
(1411, '22', 25, '1', '0', '0', '0', '0'),
(1412, '22', 26, '1', '0', '0', '0', '0'),
(1413, '22', 27, '1', '0', '0', '0', '0'),
(1414, '22', 28, '1', '0', '0', '0', '0'),
(1415, '22', 29, '1', '0', '0', '0', '0'),
(1416, '22', 30, '1', '0', '0', '0', '0'),
(1417, '22', 31, '1', '0', '0', '0', '0'),
(1418, '22', 32, '1', '0', '0', '0', '0'),
(1419, '22', 33, '1', '0', '0', '0', '0'),
(1420, '22', 34, '1', '0', '0', '0', '0'),
(1421, '22', 35, '1', '0', '0', '0', '0'),
(1422, '22', 36, '1', '0', '0', '0', '0'),
(1423, '22', 37, '1', '0', '0', '0', '0'),
(1424, '22', 38, '1', '0', '0', '0', '0'),
(1425, '22', 39, '0', '0', '0', '0', '0'),
(1426, '22', 40, '0', '0', '0', '0', '0'),
(1427, '22', 41, '1', '0', '0', '0', '0'),
(1428, '22', 42, '0', '0', '0', '0', '0'),
(1429, '22', 43, '1', '0', '0', '0', '0'),
(1430, '22', 45, '0', '0', '0', '0', '0'),
(1431, '22', 46, '1', '0', '0', '0', '0'),
(1432, '22', 47, '1', '0', '0', '0', '0'),
(1433, '22', 48, '1', '0', '0', '0', '0'),
(1434, '22', 49, '1', '0', '0', '0', '0'),
(1435, '23', 1, '0', '0', '0', '0', '0'),
(1436, '23', 2, '1', '0', '0', '0', '0'),
(1437, '23', 3, '0', '0', '0', '0', '0'),
(1438, '23', 4, '1', '0', '0', '0', '0'),
(1439, '23', 5, '1', '0', '0', '0', '0'),
(1440, '23', 6, '1', '0', '0', '0', '0'),
(1441, '23', 7, '0', '0', '0', '0', '0'),
(1442, '23', 9, '0', '0', '0', '0', '0'),
(1443, '23', 10, '0', '0', '0', '0', '0'),
(1444, '23', 11, '0', '0', '0', '0', '0'),
(1445, '23', 12, '0', '0', '0', '0', '0'),
(1446, '23', 13, '0', '0', '0', '0', '0'),
(1447, '23', 14, '1', '0', '0', '0', '0'),
(1448, '23', 15, '0', '0', '0', '0', '0'),
(1449, '23', 16, '1', '0', '0', '0', '0'),
(1450, '23', 17, '1', '0', '0', '0', '0'),
(1451, '23', 18, '0', '0', '0', '0', '0'),
(1452, '23', 19, '0', '0', '0', '0', '0'),
(1453, '23', 21, '1', '0', '0', '0', '0'),
(1454, '23', 22, '0', '0', '0', '0', '0'),
(1455, '23', 23, '0', '0', '0', '0', '0'),
(1456, '23', 24, '1', '0', '0', '0', '0'),
(1457, '23', 25, '0', '0', '0', '0', '0'),
(1458, '23', 26, '0', '0', '0', '0', '0'),
(1459, '23', 27, '0', '0', '0', '0', '0'),
(1460, '23', 28, '0', '0', '0', '0', '0'),
(1461, '23', 29, '0', '0', '0', '0', '0'),
(1462, '23', 30, '1', '0', '0', '0', '0'),
(1463, '23', 31, '1', '0', '0', '0', '0'),
(1464, '23', 32, '1', '0', '0', '0', '0'),
(1465, '23', 33, '0', '0', '0', '0', '0'),
(1466, '23', 34, '1', '0', '0', '0', '0'),
(1467, '23', 35, '0', '0', '0', '0', '0'),
(1468, '23', 36, '1', '0', '0', '0', '0'),
(1469, '23', 37, '0', '0', '0', '0', '0'),
(1470, '23', 38, '1', '0', '0', '0', '0'),
(1471, '23', 39, '0', '0', '0', '0', '0'),
(1472, '23', 40, '0', '0', '0', '0', '0'),
(1473, '23', 41, '0', '0', '0', '0', '0'),
(1474, '23', 42, '1', '0', '0', '0', '0'),
(1475, '23', 43, '0', '0', '0', '0', '0'),
(1476, '23', 45, '0', '0', '0', '0', '0'),
(1477, '23', 46, '0', '0', '0', '0', '0'),
(1478, '23', 47, '0', '0', '0', '0', '0'),
(1479, '23', 48, '0', '0', '0', '0', '0'),
(1480, '23', 49, '0', '0', '0', '0', '0'),
(1481, '24', 1, '0', '0', '0', '0', '0'),
(1482, '24', 2, '0', '0', '0', '0', '0'),
(1483, '24', 3, '0', '0', '0', '0', '0'),
(1484, '24', 4, '0', '0', '0', '0', '0'),
(1485, '24', 5, '0', '0', '0', '0', '0'),
(1486, '24', 6, '0', '0', '0', '0', '0'),
(1487, '24', 7, '0', '0', '0', '0', '0'),
(1488, '24', 9, '0', '0', '0', '0', '0'),
(1489, '24', 10, '0', '0', '0', '0', '0'),
(1490, '24', 11, '0', '0', '0', '0', '0'),
(1491, '24', 12, '0', '0', '0', '0', '0'),
(1492, '24', 13, '0', '0', '0', '0', '0'),
(1493, '24', 14, '0', '0', '0', '0', '0'),
(1494, '24', 15, '0', '0', '0', '0', '0'),
(1495, '24', 16, '0', '0', '0', '0', '0'),
(1496, '24', 17, '0', '0', '0', '0', '0'),
(1497, '24', 18, '0', '0', '0', '0', '0'),
(1498, '24', 19, '0', '0', '0', '0', '0'),
(1499, '24', 21, '0', '0', '0', '0', '0'),
(1500, '24', 22, '1', '0', '0', '0', '0'),
(1501, '24', 23, '1', '0', '0', '0', '0'),
(1502, '24', 24, '0', '0', '0', '0', '0'),
(1503, '24', 25, '0', '0', '0', '0', '0'),
(1504, '24', 26, '0', '0', '0', '0', '0'),
(1505, '24', 27, '0', '0', '0', '0', '0'),
(1506, '24', 28, '0', '0', '0', '0', '0'),
(1507, '24', 29, '0', '0', '0', '0', '0'),
(1508, '24', 30, '0', '0', '0', '0', '0'),
(1509, '24', 31, '0', '0', '0', '0', '0'),
(1510, '24', 32, '0', '0', '0', '0', '0'),
(1511, '24', 33, '0', '0', '0', '0', '0'),
(1512, '24', 34, '0', '0', '0', '0', '0'),
(1513, '24', 35, '0', '0', '0', '0', '0'),
(1514, '24', 36, '0', '0', '0', '0', '0'),
(1515, '24', 37, '0', '0', '0', '0', '0'),
(1516, '24', 38, '0', '0', '0', '0', '0'),
(1517, '24', 39, '0', '0', '0', '0', '0'),
(1518, '24', 40, '0', '0', '0', '0', '0'),
(1519, '24', 41, '0', '0', '0', '0', '0'),
(1520, '24', 42, '0', '0', '0', '0', '0'),
(1521, '24', 43, '0', '0', '0', '0', '0'),
(1522, '24', 45, '0', '0', '0', '0', '0'),
(1523, '24', 46, '0', '0', '0', '0', '0'),
(1524, '24', 47, '0', '0', '0', '0', '0'),
(1525, '24', 48, '0', '0', '0', '0', '0'),
(1526, '24', 49, '0', '0', '0', '0', '0'),
(1527, '25', 1, '0', '0', '0', '0', '0'),
(1528, '25', 2, '0', '0', '0', '0', '0'),
(1529, '25', 3, '0', '0', '0', '0', '0'),
(1530, '25', 4, '0', '0', '0', '0', '0'),
(1531, '25', 5, '0', '0', '0', '0', '0'),
(1532, '25', 6, '0', '0', '0', '0', '0'),
(1533, '25', 7, '0', '0', '0', '0', '0'),
(1534, '25', 9, '0', '0', '0', '0', '0'),
(1535, '25', 10, '0', '0', '0', '0', '0'),
(1536, '25', 11, '0', '0', '0', '0', '0'),
(1537, '25', 12, '0', '0', '0', '0', '0'),
(1538, '25', 13, '0', '0', '0', '0', '0'),
(1539, '25', 14, '0', '0', '0', '0', '0'),
(1540, '25', 15, '0', '0', '0', '0', '0'),
(1541, '25', 16, '0', '0', '0', '0', '0'),
(1542, '25', 17, '0', '0', '0', '0', '0'),
(1543, '25', 18, '0', '0', '0', '0', '0'),
(1544, '25', 19, '0', '0', '0', '0', '0'),
(1545, '25', 21, '0', '0', '0', '0', '0'),
(1546, '25', 22, '0', '0', '0', '0', '0'),
(1547, '25', 23, '0', '0', '0', '0', '0'),
(1548, '25', 24, '0', '0', '0', '0', '0'),
(1549, '25', 25, '0', '0', '0', '0', '0'),
(1550, '25', 26, '0', '0', '0', '0', '0'),
(1551, '25', 27, '0', '0', '0', '0', '0'),
(1552, '25', 28, '0', '0', '0', '0', '0'),
(1553, '25', 29, '0', '0', '0', '0', '0'),
(1554, '25', 30, '0', '0', '0', '0', '0'),
(1555, '25', 31, '0', '0', '0', '0', '0'),
(1556, '25', 32, '0', '0', '0', '0', '0'),
(1557, '25', 33, '0', '0', '0', '0', '0'),
(1558, '25', 34, '0', '0', '0', '0', '0'),
(1559, '25', 35, '0', '0', '0', '0', '0'),
(1560, '25', 36, '0', '0', '0', '0', '0'),
(1561, '25', 37, '0', '0', '0', '0', '0'),
(1562, '25', 38, '0', '0', '0', '0', '0'),
(1563, '25', 39, '0', '0', '0', '0', '0'),
(1564, '25', 40, '0', '0', '0', '0', '0'),
(1565, '25', 41, '0', '0', '0', '0', '0'),
(1566, '25', 42, '0', '0', '0', '0', '0'),
(1567, '25', 43, '0', '0', '0', '0', '0'),
(1568, '25', 45, '0', '0', '0', '0', '0'),
(1569, '25', 46, '0', '0', '0', '0', '0'),
(1570, '25', 47, '0', '0', '0', '0', '0'),
(1571, '25', 48, '0', '0', '0', '0', '0'),
(1572, '25', 49, '0', '0', '0', '0', '0'),
(1573, '26', 1, '0', '0', '0', '0', '0'),
(1574, '26', 2, '0', '0', '0', '0', '0'),
(1575, '26', 3, '0', '0', '0', '0', '0'),
(1576, '26', 4, '0', '0', '0', '0', '0'),
(1577, '26', 5, '0', '0', '0', '0', '0'),
(1578, '26', 6, '0', '0', '0', '0', '0'),
(1579, '26', 7, '0', '0', '0', '0', '0'),
(1580, '26', 9, '0', '0', '0', '0', '0'),
(1581, '26', 10, '0', '0', '0', '0', '0'),
(1582, '26', 11, '0', '0', '0', '0', '0'),
(1583, '26', 12, '0', '0', '0', '0', '0'),
(1584, '26', 13, '0', '0', '0', '0', '0'),
(1585, '26', 14, '0', '0', '0', '0', '0'),
(1586, '26', 15, '0', '0', '0', '0', '0'),
(1587, '26', 16, '0', '0', '0', '0', '0'),
(1588, '26', 17, '0', '0', '0', '0', '0'),
(1589, '26', 18, '0', '0', '0', '0', '0'),
(1590, '26', 19, '0', '0', '0', '0', '0'),
(1591, '26', 21, '0', '0', '0', '0', '0'),
(1592, '26', 22, '0', '0', '0', '0', '0'),
(1593, '26', 23, '0', '0', '0', '0', '0'),
(1594, '26', 24, '0', '0', '0', '0', '0'),
(1595, '26', 25, '0', '0', '0', '0', '0'),
(1596, '26', 26, '0', '0', '0', '0', '0'),
(1597, '26', 27, '0', '0', '0', '0', '0'),
(1598, '26', 28, '0', '0', '0', '0', '0'),
(1599, '26', 29, '0', '0', '0', '0', '0'),
(1600, '26', 30, '0', '0', '0', '0', '0'),
(1601, '26', 31, '0', '0', '0', '0', '0'),
(1602, '26', 32, '0', '0', '0', '0', '0'),
(1603, '26', 33, '0', '0', '0', '0', '0'),
(1604, '26', 34, '0', '0', '0', '0', '0'),
(1605, '26', 35, '0', '0', '0', '0', '0'),
(1606, '26', 36, '0', '0', '0', '0', '0'),
(1607, '26', 37, '0', '0', '0', '0', '0'),
(1608, '26', 38, '0', '0', '0', '0', '0'),
(1609, '26', 39, '0', '0', '0', '0', '0'),
(1610, '26', 40, '0', '0', '0', '0', '0'),
(1611, '26', 41, '0', '0', '0', '0', '0'),
(1612, '26', 42, '0', '0', '0', '0', '0'),
(1613, '26', 43, '0', '0', '0', '0', '0'),
(1614, '26', 45, '0', '0', '0', '0', '0'),
(1615, '26', 46, '0', '0', '0', '0', '0'),
(1616, '26', 47, '0', '0', '0', '0', '0'),
(1617, '26', 48, '0', '0', '0', '0', '0'),
(1618, '26', 49, '0', '0', '0', '0', '0'),
(1619, '27', 1, '1', '0', '0', '0', '0'),
(1620, '27', 2, '0', '0', '0', '0', '0'),
(1621, '27', 3, '0', '0', '0', '0', '0'),
(1622, '27', 4, '0', '0', '0', '0', '0'),
(1623, '27', 5, '0', '0', '0', '0', '0'),
(1624, '27', 6, '0', '0', '0', '0', '0'),
(1625, '27', 7, '0', '0', '0', '0', '0'),
(1626, '27', 9, '0', '0', '0', '0', '0'),
(1627, '27', 10, '0', '0', '0', '0', '0'),
(1628, '27', 11, '0', '0', '0', '0', '0'),
(1629, '27', 12, '0', '0', '0', '0', '0'),
(1630, '27', 13, '0', '0', '0', '0', '0'),
(1631, '27', 14, '0', '0', '0', '0', '0'),
(1632, '27', 15, '0', '0', '0', '0', '0'),
(1633, '27', 16, '0', '0', '0', '0', '0'),
(1634, '27', 17, '0', '0', '0', '0', '0'),
(1635, '27', 18, '0', '0', '0', '0', '0'),
(1636, '27', 19, '0', '0', '0', '0', '0'),
(1637, '27', 21, '0', '0', '0', '0', '0'),
(1638, '27', 22, '0', '0', '0', '0', '0'),
(1639, '27', 23, '0', '0', '0', '0', '0'),
(1640, '27', 24, '0', '0', '0', '0', '0'),
(1641, '27', 25, '0', '0', '0', '0', '0'),
(1642, '27', 26, '0', '0', '0', '0', '0'),
(1643, '27', 27, '0', '0', '0', '0', '0'),
(1644, '27', 28, '0', '0', '0', '0', '0'),
(1645, '27', 29, '0', '0', '0', '0', '0'),
(1646, '27', 30, '0', '0', '0', '0', '0'),
(1647, '27', 31, '0', '0', '0', '0', '0'),
(1648, '27', 32, '0', '0', '0', '0', '0'),
(1649, '27', 33, '0', '0', '0', '0', '0'),
(1650, '27', 34, '0', '0', '0', '0', '0'),
(1651, '27', 35, '0', '0', '0', '0', '0'),
(1652, '27', 36, '0', '0', '0', '0', '0'),
(1653, '27', 37, '0', '0', '0', '0', '0'),
(1654, '27', 38, '0', '0', '0', '0', '0'),
(1655, '27', 39, '0', '0', '0', '0', '0'),
(1656, '27', 40, '0', '0', '0', '0', '0'),
(1657, '27', 41, '0', '0', '0', '0', '0'),
(1658, '27', 42, '0', '0', '0', '0', '0'),
(1659, '27', 43, '0', '0', '0', '0', '0'),
(1660, '27', 45, '0', '0', '0', '0', '0'),
(1661, '27', 46, '0', '0', '0', '0', '0'),
(1662, '27', 47, '0', '0', '0', '0', '0'),
(1663, '27', 48, '0', '0', '0', '0', '0'),
(1664, '27', 49, '0', '0', '0', '0', '0'),
(1665, '28', 1, '0', '0', '0', '0', '0'),
(1666, '28', 2, '0', '0', '0', '0', '0'),
(1667, '28', 3, '0', '0', '0', '0', '0'),
(1668, '28', 4, '0', '0', '0', '0', '0'),
(1669, '28', 5, '0', '0', '0', '0', '0'),
(1670, '28', 6, '0', '0', '0', '0', '0'),
(1671, '28', 7, '0', '0', '0', '0', '0'),
(1672, '28', 9, '0', '0', '0', '0', '0'),
(1673, '28', 10, '0', '0', '0', '0', '0'),
(1674, '28', 11, '0', '0', '0', '0', '0'),
(1675, '28', 12, '0', '0', '0', '0', '0'),
(1676, '28', 13, '0', '0', '0', '0', '0'),
(1677, '28', 14, '0', '0', '0', '0', '0'),
(1678, '28', 15, '0', '0', '0', '0', '0'),
(1679, '28', 16, '0', '0', '0', '0', '0'),
(1680, '28', 17, '0', '0', '0', '0', '0'),
(1681, '28', 18, '0', '0', '0', '0', '0'),
(1682, '28', 19, '0', '0', '0', '0', '0'),
(1683, '28', 21, '0', '0', '0', '0', '0'),
(1684, '28', 22, '0', '0', '0', '0', '0'),
(1685, '28', 23, '0', '0', '0', '0', '0'),
(1686, '28', 24, '0', '0', '0', '0', '0'),
(1687, '28', 25, '0', '0', '0', '0', '0'),
(1688, '28', 26, '0', '0', '0', '0', '0'),
(1689, '28', 27, '0', '0', '0', '0', '0'),
(1690, '28', 28, '0', '0', '0', '0', '0'),
(1691, '28', 29, '0', '0', '0', '0', '0'),
(1692, '28', 30, '0', '0', '0', '0', '0'),
(1693, '28', 31, '0', '0', '0', '0', '0'),
(1694, '28', 32, '0', '0', '0', '0', '0'),
(1695, '28', 33, '0', '0', '0', '0', '0'),
(1696, '28', 34, '0', '0', '0', '0', '0'),
(1697, '28', 35, '0', '0', '0', '0', '0'),
(1698, '28', 36, '0', '0', '0', '0', '0'),
(1699, '28', 37, '0', '0', '0', '0', '0'),
(1700, '28', 38, '0', '0', '0', '0', '0'),
(1701, '28', 39, '0', '0', '0', '0', '0'),
(1702, '28', 40, '0', '0', '0', '0', '0'),
(1703, '28', 41, '0', '0', '0', '0', '0'),
(1704, '28', 42, '0', '0', '0', '0', '0'),
(1705, '28', 43, '0', '0', '0', '0', '0'),
(1706, '28', 45, '0', '0', '0', '0', '0'),
(1707, '28', 46, '0', '0', '0', '0', '0'),
(1708, '28', 47, '0', '0', '0', '0', '0'),
(1709, '28', 48, '0', '0', '0', '0', '0'),
(1710, '28', 49, '0', '0', '0', '0', '0'),
(1963, '10', 1, '0', '1', '1', '1', '1'),
(1964, '10', 2, '0', '1', '1', '1', '1'),
(1965, '10', 3, '0', '1', '1', '1', '1'),
(1966, '10', 4, '0', '1', '1', '1', '1'),
(1967, '10', 5, '0', '1', '1', '1', '1'),
(1968, '10', 6, '0', '1', '1', '1', '1'),
(1969, '10', 7, '0', '1', '1', '1', '1'),
(1970, '10', 9, '0', '1', '1', '1', '1'),
(1971, '10', 10, '0', '1', '1', '1', '1'),
(1972, '10', 11, '0', '1', '1', '1', '1'),
(1973, '10', 12, '0', '1', '1', '1', '1'),
(1974, '10', 13, '0', '1', '1', '1', '1'),
(1975, '10', 14, '0', '1', '1', '1', '1'),
(1976, '10', 15, '0', '1', '1', '1', '1'),
(1977, '10', 16, '0', '1', '1', '1', '1'),
(1978, '10', 17, '0', '1', '1', '1', '1'),
(1979, '10', 18, '0', '1', '1', '1', '1'),
(1980, '10', 19, '0', '1', '1', '1', '1'),
(1981, '10', 21, '0', '1', '1', '1', '1'),
(1982, '10', 22, '0', '1', '1', '1', '1'),
(1983, '10', 23, '0', '1', '1', '1', '1'),
(1984, '10', 24, '0', '1', '1', '1', '1'),
(1985, '10', 25, '0', '1', '1', '1', '1'),
(1986, '10', 26, '0', '1', '1', '1', '1'),
(1987, '10', 27, '0', '1', '1', '1', '1'),
(1988, '10', 28, '0', '1', '1', '1', '1'),
(1989, '10', 29, '0', '1', '1', '1', '1'),
(1990, '10', 30, '0', '1', '1', '1', '1'),
(1991, '10', 31, '0', '1', '1', '1', '1'),
(1992, '10', 32, '0', '1', '1', '1', '1'),
(1993, '10', 33, '0', '1', '1', '1', '1'),
(1994, '10', 34, '0', '1', '1', '1', '1'),
(1995, '10', 35, '0', '1', '1', '1', '1'),
(1996, '10', 36, '0', '1', '1', '1', '1'),
(1997, '10', 37, '0', '1', '1', '1', '1'),
(1998, '10', 38, '0', '1', '1', '1', '1'),
(1999, '10', 39, '0', '1', '1', '1', '1'),
(2000, '10', 40, '0', '1', '1', '1', '1'),
(2001, '10', 41, '0', '1', '1', '1', '1'),
(2002, '10', 42, '0', '1', '1', '1', '1'),
(2003, '10', 43, '0', '1', '1', '1', '1'),
(2004, '10', 45, '0', '1', '1', '1', '1'),
(2005, '10', 46, '0', '1', '1', '1', '1'),
(2006, '10', 47, '0', '1', '1', '1', '1');
INSERT INTO `roles_permission` (`id`, `role_id`, `module_id`, `read_permission`, `add_permission`, `edit_permission`, `delete_permission`, `is_visible`) VALUES
(2007, '10', 48, '0', '1', '1', '1', '1'),
(2008, '10', 49, '0', '1', '1', '1', '1'),
(2026, '11', 1, '0', '1', '1', '1', '1'),
(2027, '11', 2, '0', '1', '1', '1', '1'),
(2028, '11', 3, '0', '1', '1', '1', '1'),
(2029, '11', 4, '0', '1', '1', '1', '1'),
(2030, '11', 5, '0', '1', '1', '1', '1'),
(2031, '11', 6, '0', '1', '1', '1', '1'),
(2032, '11', 7, '0', '1', '1', '1', '1'),
(2033, '11', 9, '0', '1', '1', '1', '1'),
(2034, '11', 10, '0', '1', '1', '1', '1'),
(2035, '11', 11, '0', '1', '1', '1', '1'),
(2036, '11', 12, '0', '1', '1', '1', '1'),
(2037, '11', 13, '0', '1', '1', '1', '1'),
(2038, '11', 14, '0', '1', '1', '1', '1'),
(2039, '11', 15, '0', '1', '1', '1', '1'),
(2040, '11', 16, '0', '1', '1', '1', '1'),
(2041, '11', 17, '0', '1', '1', '1', '1'),
(2042, '11', 18, '0', '1', '1', '1', '1'),
(2043, '11', 19, '0', '1', '1', '1', '1'),
(2044, '11', 21, '0', '1', '1', '1', '1'),
(2045, '11', 22, '0', '1', '1', '1', '1'),
(2046, '11', 23, '0', '1', '1', '1', '1'),
(2047, '11', 24, '0', '1', '1', '1', '1'),
(2048, '11', 25, '0', '1', '1', '1', '1'),
(2049, '11', 26, '0', '1', '1', '1', '1'),
(2050, '11', 27, '0', '1', '1', '1', '1'),
(2051, '11', 28, '0', '1', '1', '1', '1'),
(2052, '11', 29, '0', '1', '1', '1', '1'),
(2053, '11', 30, '0', '1', '1', '1', '1'),
(2054, '11', 31, '0', '1', '1', '1', '1'),
(2055, '11', 32, '0', '1', '1', '1', '1'),
(2056, '11', 33, '0', '1', '1', '1', '1'),
(2057, '11', 34, '0', '1', '1', '1', '1'),
(2058, '11', 35, '0', '1', '1', '1', '1'),
(2059, '11', 36, '0', '1', '1', '1', '1'),
(2060, '11', 37, '0', '1', '1', '1', '1'),
(2061, '11', 38, '0', '1', '1', '1', '1'),
(2062, '11', 39, '0', '1', '1', '1', '1'),
(2063, '11', 40, '0', '1', '1', '1', '1'),
(2064, '11', 41, '0', '1', '1', '1', '1'),
(2065, '11', 42, '0', '1', '1', '1', '1'),
(2066, '11', 43, '0', '1', '1', '1', '1'),
(2067, '11', 45, '0', '1', '1', '1', '1'),
(2068, '11', 46, '0', '1', '1', '1', '1'),
(2069, '11', 47, '0', '1', '1', '1', '1'),
(2070, '11', 48, '0', '1', '1', '1', '1'),
(2071, '11', 49, '0', '1', '1', '1', '1'),
(2089, '12', 1, '0', '1', '1', '1', '1'),
(2090, '12', 2, '0', '1', '1', '1', '1'),
(2091, '12', 3, '0', '1', '1', '1', '1'),
(2092, '12', 4, '0', '1', '1', '1', '1'),
(2093, '12', 5, '0', '1', '1', '1', '1'),
(2094, '12', 6, '0', '1', '1', '1', '1'),
(2095, '12', 7, '0', '1', '1', '1', '1'),
(2096, '12', 9, '0', '1', '1', '1', '1'),
(2097, '12', 10, '0', '1', '1', '1', '1'),
(2098, '12', 11, '0', '1', '1', '1', '1'),
(2099, '12', 12, '0', '1', '1', '1', '1'),
(2100, '12', 13, '0', '1', '1', '1', '1'),
(2101, '12', 14, '0', '1', '1', '1', '1'),
(2102, '12', 15, '0', '1', '1', '1', '1'),
(2103, '12', 16, '0', '1', '1', '1', '1'),
(2104, '12', 17, '0', '1', '1', '1', '1'),
(2105, '12', 18, '0', '1', '1', '1', '1'),
(2106, '12', 19, '0', '1', '1', '1', '1'),
(2107, '12', 21, '0', '1', '1', '1', '1'),
(2108, '12', 22, '0', '1', '1', '1', '1'),
(2109, '12', 23, '0', '1', '1', '1', '1'),
(2110, '12', 24, '0', '1', '1', '1', '1'),
(2111, '12', 25, '0', '1', '1', '1', '1'),
(2112, '12', 26, '0', '1', '1', '1', '1'),
(2113, '12', 27, '0', '1', '1', '1', '1'),
(2114, '12', 28, '0', '1', '1', '1', '1'),
(2115, '12', 29, '0', '1', '1', '1', '1'),
(2116, '12', 30, '0', '1', '1', '1', '1'),
(2117, '12', 31, '0', '1', '1', '1', '1'),
(2118, '12', 32, '0', '1', '1', '1', '1'),
(2119, '12', 33, '0', '1', '1', '1', '1'),
(2120, '12', 34, '0', '1', '1', '1', '1'),
(2121, '12', 35, '0', '1', '1', '1', '1'),
(2122, '12', 36, '0', '1', '1', '1', '1'),
(2123, '12', 37, '0', '1', '1', '1', '1'),
(2124, '12', 38, '0', '1', '1', '1', '1'),
(2125, '12', 39, '0', '1', '1', '1', '1'),
(2126, '12', 40, '0', '1', '1', '1', '1'),
(2127, '12', 41, '0', '1', '1', '1', '1'),
(2128, '12', 42, '0', '1', '1', '1', '1'),
(2129, '12', 43, '0', '1', '1', '1', '1'),
(2130, '12', 45, '0', '1', '1', '1', '1'),
(2131, '12', 46, '0', '1', '1', '1', '1'),
(2132, '12', 47, '0', '1', '1', '1', '1'),
(2133, '12', 48, '0', '1', '1', '1', '1'),
(2134, '12', 49, '0', '1', '1', '1', '1'),
(2152, '13', 1, '0', '1', '1', '1', '1'),
(2153, '13', 2, '0', '1', '1', '1', '1'),
(2154, '13', 3, '0', '1', '1', '1', '1'),
(2155, '13', 4, '0', '1', '1', '1', '1'),
(2156, '13', 5, '0', '1', '1', '1', '1'),
(2157, '13', 6, '0', '1', '1', '1', '1'),
(2158, '13', 7, '0', '1', '1', '1', '1'),
(2159, '13', 9, '0', '1', '1', '1', '1'),
(2160, '13', 10, '0', '1', '1', '1', '1'),
(2161, '13', 11, '0', '1', '1', '1', '1'),
(2162, '13', 12, '0', '1', '1', '1', '1'),
(2163, '13', 13, '0', '1', '1', '1', '1'),
(2164, '13', 14, '0', '1', '1', '1', '1'),
(2165, '13', 15, '0', '1', '1', '1', '1'),
(2166, '13', 16, '0', '1', '1', '1', '1'),
(2167, '13', 17, '0', '1', '1', '1', '1'),
(2168, '13', 18, '0', '1', '1', '1', '1'),
(2169, '13', 19, '0', '1', '1', '1', '1'),
(2170, '13', 21, '0', '1', '1', '1', '1'),
(2171, '13', 22, '0', '1', '1', '1', '1'),
(2172, '13', 23, '0', '1', '1', '1', '1'),
(2173, '13', 24, '0', '1', '1', '1', '1'),
(2174, '13', 25, '0', '1', '1', '1', '1'),
(2175, '13', 26, '0', '1', '1', '1', '1'),
(2176, '13', 27, '0', '1', '1', '1', '1'),
(2177, '13', 28, '0', '1', '1', '1', '1'),
(2178, '13', 29, '0', '1', '1', '1', '1'),
(2179, '13', 30, '0', '1', '1', '1', '1'),
(2180, '13', 31, '0', '1', '1', '1', '1'),
(2181, '13', 32, '0', '1', '1', '1', '1'),
(2182, '13', 33, '0', '1', '1', '1', '1'),
(2183, '13', 34, '0', '1', '1', '1', '1'),
(2184, '13', 35, '0', '1', '1', '1', '1'),
(2185, '13', 36, '0', '1', '1', '1', '1'),
(2186, '13', 37, '0', '1', '1', '1', '1'),
(2187, '13', 38, '0', '1', '1', '1', '1'),
(2188, '13', 39, '0', '1', '1', '1', '1'),
(2189, '13', 40, '0', '1', '1', '1', '1'),
(2190, '13', 41, '0', '1', '1', '1', '1'),
(2191, '13', 42, '0', '1', '1', '1', '1'),
(2192, '13', 43, '0', '1', '1', '1', '1'),
(2193, '13', 45, '0', '1', '1', '1', '1'),
(2194, '13', 46, '0', '1', '1', '1', '1'),
(2195, '13', 47, '0', '1', '1', '1', '1'),
(2196, '13', 48, '0', '1', '1', '1', '1'),
(2197, '13', 49, '0', '1', '1', '1', '1'),
(2215, '29', 1, '0', '0', '0', '0', '0'),
(2216, '29', 2, '0', '0', '0', '0', '0'),
(2217, '29', 3, '0', '0', '0', '0', '0'),
(2218, '29', 4, '0', '0', '0', '0', '0'),
(2219, '29', 5, '0', '0', '0', '0', '0'),
(2220, '29', 6, '0', '0', '0', '0', '0'),
(2221, '29', 7, '0', '0', '0', '0', '0'),
(2222, '29', 9, '0', '0', '0', '0', '0'),
(2223, '29', 10, '0', '0', '0', '0', '0'),
(2224, '29', 11, '0', '0', '0', '0', '0'),
(2225, '29', 12, '0', '0', '0', '0', '0'),
(2226, '29', 13, '0', '0', '0', '0', '0'),
(2227, '29', 14, '0', '0', '0', '0', '0'),
(2228, '29', 15, '0', '0', '0', '0', '0'),
(2229, '29', 16, '0', '0', '0', '0', '0'),
(2230, '29', 17, '0', '0', '0', '0', '0'),
(2231, '29', 18, '0', '0', '0', '0', '0'),
(2232, '29', 19, '0', '0', '0', '0', '0'),
(2233, '29', 21, '0', '0', '0', '0', '0'),
(2234, '29', 22, '0', '0', '0', '0', '0'),
(2235, '29', 23, '0', '0', '0', '0', '0'),
(2236, '29', 24, '0', '0', '0', '0', '0'),
(2237, '29', 25, '0', '0', '0', '0', '0'),
(2238, '29', 26, '0', '0', '0', '0', '0'),
(2239, '29', 27, '0', '0', '0', '0', '0'),
(2240, '29', 28, '0', '0', '0', '0', '0'),
(2241, '29', 29, '0', '0', '0', '0', '0'),
(2242, '29', 30, '0', '0', '0', '0', '0'),
(2243, '29', 31, '0', '0', '0', '0', '0'),
(2244, '29', 32, '0', '0', '0', '0', '0'),
(2245, '29', 33, '0', '0', '0', '0', '0'),
(2246, '29', 34, '0', '0', '0', '0', '0'),
(2247, '29', 35, '0', '0', '0', '0', '0'),
(2248, '29', 36, '0', '0', '0', '0', '0'),
(2249, '29', 37, '0', '0', '0', '0', '0'),
(2250, '29', 38, '0', '0', '0', '0', '0'),
(2251, '29', 39, '0', '0', '0', '0', '0'),
(2252, '29', 40, '0', '0', '0', '0', '0'),
(2253, '29', 41, '0', '0', '0', '0', '0'),
(2254, '29', 42, '0', '0', '0', '0', '0'),
(2255, '29', 43, '0', '0', '0', '0', '0'),
(2256, '29', 45, '0', '0', '0', '0', '0'),
(2257, '29', 46, '0', '0', '0', '0', '0'),
(2258, '29', 47, '0', '0', '0', '0', '0'),
(2259, '29', 48, '0', '0', '0', '0', '0'),
(2260, '29', 49, '0', '0', '0', '0', '0'),
(2261, '1', 43, '1', '1', '1', '1', '1'),
(2262, '1', 50, '1', '1', '1', '1', '1'),
(2263, '1', 51, '1', '1', '1', '1', '1'),
(2264, '1', 52, '1', '1', '1', '1', '1'),
(2265, '1', 53, '1', '1', '1', '1', '1'),
(2266, '1', 54, '1', '1', '1', '1', '1'),
(2267, '1', 55, '1', '1', '1', '1', '1'),
(2268, '1', 56, '1', '1', '1', '1', '1'),
(2269, '1', 57, '1', '1', '1', '1', '1'),
(2270, '1', 58, '1', '1', '1', '1', '1'),
(2271, '1', 59, '1', '1', '1', '1', '1'),
(2272, '1', 60, '1', '1', '1', '1', '1'),
(2273, '1', 61, '1', '1', '1', '1', '1'),
(2274, '6', 57, '1', '1', '1', '1', '1'),
(2275, '6', 58, '1', '1', '1', '1', '1'),
(2276, '6', 59, '1', '1', '1', '1', '1'),
(2277, '6', 60, '0', '1', '1', '1', '1'),
(2278, '6', 52, '1', '1', '1', '1', '1'),
(2279, '2', 43, '1', '1', '1', '1', '1'),
(2280, '2', 50, '0', '1', '1', '1', '1'),
(2281, '2', 51, '1', '1', '1', '1', '1'),
(2282, '2', 52, '0', '1', '1', '1', '1'),
(2283, '2', 53, '0', '1', '1', '1', '1'),
(2284, '2', 54, '0', '1', '1', '1', '1'),
(2285, '2', 55, '0', '1', '1', '1', '1'),
(2286, '2', 56, '1', '1', '1', '1', '1'),
(2287, '2', 57, '0', '1', '1', '1', '1'),
(2288, '2', 58, '0', '1', '1', '1', '1'),
(2289, '2', 59, '0', '1', '1', '1', '1'),
(2290, '2', 60, '0', '1', '1', '1', '1'),
(2291, '2', 61, '0', '1', '1', '1', '1'),
(2294, '6', 43, '1', '1', '1', '1', '1'),
(2295, '6', 50, '1', '1', '1', '1', '1'),
(2296, '6', 51, '1', '1', '1', '1', '1'),
(2297, '6', 53, '0', '1', '1', '1', '1'),
(2298, '6', 54, '0', '1', '1', '1', '1'),
(2299, '6', 55, '0', '1', '1', '1', '1'),
(2300, '6', 56, '1', '1', '1', '1', '1'),
(2301, '6', 61, '0', '1', '1', '1', '1'),
(2309, '8', 43, '1', '1', '1', '1', '1'),
(2310, '8', 50, '1', '1', '1', '1', '1'),
(2311, '8', 51, '0', '1', '1', '1', '1'),
(2312, '8', 52, '0', '1', '1', '1', '1'),
(2313, '8', 53, '0', '1', '1', '1', '1'),
(2314, '8', 54, '0', '1', '1', '1', '1'),
(2315, '8', 55, '1', '1', '1', '1', '1'),
(2316, '8', 56, '1', '1', '1', '1', '1'),
(2317, '8', 57, '0', '1', '1', '1', '1'),
(2318, '8', 58, '0', '1', '1', '1', '1'),
(2319, '8', 59, '0', '1', '1', '1', '1'),
(2320, '8', 60, '0', '1', '1', '1', '1'),
(2321, '8', 61, '1', '1', '1', '1', '1'),
(2324, '9', 43, '0', '1', '1', '1', '1'),
(2325, '9', 50, '1', '1', '1', '1', '1'),
(2326, '9', 51, '0', '1', '1', '1', '1'),
(2327, '9', 52, '0', '1', '1', '1', '1'),
(2328, '9', 53, '0', '1', '1', '1', '1'),
(2329, '9', 54, '0', '1', '1', '1', '1'),
(2330, '9', 55, '1', '1', '1', '1', '1'),
(2331, '9', 56, '1', '1', '1', '1', '1'),
(2332, '9', 57, '0', '1', '1', '1', '1'),
(2333, '9', 58, '0', '1', '1', '1', '1'),
(2334, '9', 59, '0', '1', '1', '1', '1'),
(2335, '9', 60, '0', '1', '1', '1', '1'),
(2336, '9', 61, '0', '1', '1', '1', '1'),
(2339, '10', 50, '1', '1', '1', '1', '1'),
(2340, '10', 51, '0', '1', '1', '1', '1'),
(2341, '10', 52, '0', '1', '1', '1', '1'),
(2342, '10', 53, '0', '1', '1', '1', '1'),
(2343, '10', 54, '1', '1', '1', '1', '1'),
(2344, '10', 55, '1', '1', '1', '1', '1'),
(2345, '10', 56, '1', '1', '1', '1', '1'),
(2346, '10', 57, '0', '1', '1', '1', '1'),
(2347, '10', 58, '0', '1', '1', '1', '1'),
(2348, '10', 59, '0', '1', '1', '1', '1'),
(2349, '10', 60, '0', '1', '1', '1', '1'),
(2350, '10', 61, '0', '1', '1', '1', '1'),
(2354, '11', 50, '1', '1', '1', '1', '1'),
(2355, '11', 51, '0', '1', '1', '1', '1'),
(2356, '11', 52, '0', '1', '1', '1', '1'),
(2357, '11', 53, '0', '1', '1', '1', '1'),
(2358, '11', 54, '0', '1', '1', '1', '1'),
(2359, '11', 55, '0', '1', '1', '1', '1'),
(2360, '11', 56, '1', '1', '1', '1', '1'),
(2361, '11', 57, '0', '1', '1', '1', '1'),
(2362, '11', 58, '0', '1', '1', '1', '1'),
(2363, '11', 59, '0', '1', '1', '1', '1'),
(2364, '11', 60, '0', '1', '1', '1', '1'),
(2365, '11', 61, '0', '1', '1', '1', '1'),
(2369, '12', 50, '0', '1', '1', '1', '1'),
(2370, '12', 51, '0', '1', '1', '1', '1'),
(2371, '12', 52, '0', '1', '1', '1', '1'),
(2372, '12', 53, '0', '1', '1', '1', '1'),
(2373, '12', 54, '0', '1', '1', '1', '1'),
(2374, '12', 55, '0', '1', '1', '1', '1'),
(2375, '12', 56, '1', '1', '1', '1', '1'),
(2376, '12', 57, '0', '1', '1', '1', '1'),
(2377, '12', 58, '0', '1', '1', '1', '1'),
(2378, '12', 59, '0', '1', '1', '1', '1'),
(2379, '12', 60, '0', '1', '1', '1', '1'),
(2380, '12', 61, '0', '1', '1', '1', '1'),
(2384, '13', 50, '0', '1', '1', '1', '1'),
(2385, '13', 51, '0', '1', '1', '1', '1'),
(2386, '13', 52, '0', '1', '1', '1', '1'),
(2387, '13', 53, '0', '1', '1', '1', '1'),
(2388, '13', 54, '0', '1', '1', '1', '1'),
(2389, '13', 55, '0', '1', '1', '1', '1'),
(2390, '13', 56, '1', '1', '1', '1', '1'),
(2391, '13', 57, '0', '1', '1', '1', '1'),
(2392, '13', 58, '0', '1', '1', '1', '1'),
(2393, '13', 59, '0', '1', '1', '1', '1'),
(2394, '13', 60, '0', '1', '1', '1', '1'),
(2395, '13', 61, '0', '1', '1', '1', '1'),
(2399, '30', 1, '0', '0', '0', '0', '0'),
(2400, '30', 2, '0', '0', '0', '0', '0'),
(2401, '30', 3, '0', '0', '0', '0', '0'),
(2402, '30', 4, '0', '0', '0', '0', '0'),
(2403, '30', 5, '0', '0', '0', '0', '0'),
(2404, '30', 6, '0', '0', '0', '0', '0'),
(2405, '30', 7, '0', '0', '0', '0', '0'),
(2406, '30', 9, '0', '0', '0', '0', '0'),
(2407, '30', 10, '0', '0', '0', '0', '0'),
(2408, '30', 11, '0', '0', '0', '0', '0'),
(2409, '30', 12, '0', '0', '0', '0', '0'),
(2410, '30', 13, '0', '0', '0', '0', '0'),
(2411, '30', 14, '0', '0', '0', '0', '0'),
(2412, '30', 15, '0', '0', '0', '0', '0'),
(2413, '30', 16, '0', '0', '0', '0', '0'),
(2414, '30', 17, '0', '0', '0', '0', '0'),
(2415, '30', 18, '0', '0', '0', '0', '0'),
(2416, '30', 19, '0', '0', '0', '0', '0'),
(2417, '30', 21, '0', '0', '0', '0', '0'),
(2418, '30', 22, '0', '0', '0', '0', '0'),
(2419, '30', 23, '0', '0', '0', '0', '0'),
(2420, '30', 24, '0', '0', '0', '0', '0'),
(2421, '30', 25, '0', '0', '0', '0', '0'),
(2422, '30', 26, '0', '0', '0', '0', '0'),
(2423, '30', 27, '0', '0', '0', '0', '0'),
(2424, '30', 28, '0', '0', '0', '0', '0'),
(2425, '30', 29, '0', '0', '0', '0', '0'),
(2426, '30', 30, '0', '0', '0', '0', '0'),
(2427, '30', 31, '0', '0', '0', '0', '0'),
(2428, '30', 32, '0', '0', '0', '0', '0'),
(2429, '30', 33, '0', '0', '0', '0', '0'),
(2430, '30', 34, '0', '0', '0', '0', '0'),
(2431, '30', 35, '0', '0', '0', '0', '0'),
(2432, '30', 36, '0', '0', '0', '0', '0'),
(2433, '30', 37, '0', '0', '0', '0', '0'),
(2434, '30', 38, '0', '0', '0', '0', '0'),
(2435, '30', 39, '0', '0', '0', '0', '0'),
(2436, '30', 40, '0', '0', '0', '0', '0'),
(2437, '30', 41, '0', '0', '0', '0', '0'),
(2438, '30', 42, '0', '0', '0', '0', '0'),
(2439, '30', 43, '0', '0', '0', '0', '0'),
(2440, '30', 45, '0', '0', '0', '0', '0'),
(2441, '30', 46, '0', '0', '0', '0', '0'),
(2442, '30', 47, '0', '0', '0', '0', '0'),
(2443, '30', 48, '0', '0', '0', '0', '0'),
(2444, '30', 49, '0', '0', '0', '0', '0'),
(2445, '30', 50, '0', '0', '0', '0', '0'),
(2446, '30', 51, '0', '0', '0', '0', '0'),
(2447, '30', 52, '0', '0', '0', '0', '0'),
(2448, '30', 53, '0', '0', '0', '0', '0'),
(2449, '30', 54, '0', '0', '0', '0', '0'),
(2450, '30', 55, '0', '0', '0', '0', '0'),
(2451, '30', 56, '0', '0', '0', '0', '0'),
(2452, '30', 57, '0', '0', '0', '0', '0'),
(2453, '30', 58, '0', '0', '0', '0', '0'),
(2454, '30', 59, '0', '0', '0', '0', '0'),
(2455, '30', 60, '0', '0', '0', '0', '0'),
(2456, '30', 61, '0', '0', '0', '0', '0'),
(2457, '31', 1, '0', '0', '0', '0', '0'),
(2458, '31', 2, '0', '0', '0', '0', '0'),
(2459, '31', 3, '0', '0', '0', '0', '0'),
(2460, '31', 4, '0', '0', '0', '0', '0'),
(2461, '31', 5, '0', '0', '0', '0', '0'),
(2462, '31', 6, '0', '0', '0', '0', '0'),
(2463, '31', 7, '0', '0', '0', '0', '0'),
(2464, '31', 9, '0', '0', '0', '0', '0'),
(2465, '31', 10, '0', '0', '0', '0', '0'),
(2466, '31', 11, '0', '0', '0', '0', '0'),
(2467, '31', 12, '0', '0', '0', '0', '0'),
(2468, '31', 13, '0', '0', '0', '0', '0'),
(2469, '31', 14, '0', '0', '0', '0', '0'),
(2470, '31', 15, '0', '0', '0', '0', '0'),
(2471, '31', 16, '0', '0', '0', '0', '0'),
(2472, '31', 17, '0', '0', '0', '0', '0'),
(2473, '31', 18, '0', '0', '0', '0', '0'),
(2474, '31', 19, '0', '0', '0', '0', '0'),
(2475, '31', 21, '0', '0', '0', '0', '0'),
(2476, '31', 22, '0', '0', '0', '0', '0'),
(2477, '31', 23, '0', '0', '0', '0', '0'),
(2478, '31', 24, '0', '0', '0', '0', '0'),
(2479, '31', 25, '0', '0', '0', '0', '0'),
(2480, '31', 26, '0', '0', '0', '0', '0'),
(2481, '31', 27, '0', '0', '0', '0', '0'),
(2482, '31', 28, '0', '0', '0', '0', '0'),
(2483, '31', 29, '0', '0', '0', '0', '0'),
(2484, '31', 30, '0', '0', '0', '0', '0'),
(2485, '31', 31, '0', '0', '0', '0', '0'),
(2486, '31', 32, '0', '0', '0', '0', '0'),
(2487, '31', 33, '0', '0', '0', '0', '0'),
(2488, '31', 34, '0', '0', '0', '0', '0'),
(2489, '31', 35, '0', '0', '0', '0', '0'),
(2490, '31', 36, '0', '0', '0', '0', '0'),
(2491, '31', 37, '0', '0', '0', '0', '0'),
(2492, '31', 38, '0', '0', '0', '0', '0'),
(2493, '31', 39, '0', '0', '0', '0', '0'),
(2494, '31', 40, '0', '0', '0', '0', '0'),
(2495, '31', 41, '0', '0', '0', '0', '0'),
(2496, '31', 42, '0', '0', '0', '0', '0'),
(2497, '31', 43, '0', '0', '0', '0', '0'),
(2498, '31', 45, '0', '0', '0', '0', '0'),
(2499, '31', 46, '0', '0', '0', '0', '0'),
(2500, '31', 47, '0', '0', '0', '0', '0'),
(2501, '31', 48, '0', '0', '0', '0', '0'),
(2502, '31', 49, '0', '0', '0', '0', '0'),
(2503, '31', 50, '0', '0', '0', '0', '0'),
(2504, '31', 51, '0', '0', '0', '0', '0'),
(2505, '31', 52, '0', '0', '0', '0', '0'),
(2506, '31', 53, '0', '0', '0', '0', '0'),
(2507, '31', 54, '0', '0', '0', '0', '0'),
(2508, '31', 55, '0', '0', '0', '0', '0'),
(2509, '31', 56, '0', '0', '0', '0', '0'),
(2510, '31', 57, '0', '0', '0', '0', '0'),
(2511, '31', 58, '0', '0', '0', '0', '0'),
(2512, '31', 59, '0', '0', '0', '0', '0'),
(2513, '31', 60, '0', '0', '0', '0', '0'),
(2514, '31', 61, '0', '0', '0', '0', '0'),
(2515, '1', 62, '1', '1', '1', '1', '1'),
(2516, '1', 63, '1', '1', '1', '1', '1'),
(2517, '1', 64, '1', '1', '1', '1', '1'),
(2518, '1', 65, '1', '1', '1', '1', '1'),
(2519, '1', 66, '1', '1', '1', '1', '1'),
(2520, '1', 67, '1', '1', '1', '1', '1'),
(2521, '1', 68, '1', '1', '1', '1', '1'),
(2522, '1', 69, '1', '1', '1', '1', '1'),
(2523, '1', 70, '1', '1', '1', '1', '1'),
(2524, '1', 71, '1', '1', '1', '1', '1'),
(2530, '2', 62, '0', '1', '1', '1', '1'),
(2531, '2', 63, '0', '1', '1', '1', '1'),
(2532, '2', 64, '0', '1', '1', '1', '1'),
(2533, '2', 65, '0', '1', '1', '1', '1'),
(2534, '2', 66, '0', '1', '1', '1', '1'),
(2535, '2', 67, '0', '1', '1', '1', '1'),
(2536, '2', 68, '1', '1', '1', '1', '1'),
(2537, '2', 69, '0', '1', '1', '1', '1'),
(2538, '2', 70, '1', '1', '1', '1', '1'),
(2539, '2', 71, '0', '1', '1', '1', '1'),
(2545, '6', 62, '0', '1', '1', '1', '1'),
(2546, '6', 63, '1', '1', '1', '1', '1'),
(2547, '6', 64, '0', '1', '1', '1', '1'),
(2548, '6', 65, '0', '1', '1', '1', '1'),
(2549, '6', 66, '0', '1', '1', '1', '1'),
(2550, '6', 67, '0', '1', '1', '1', '1'),
(2551, '6', 68, '1', '1', '1', '1', '1'),
(2552, '6', 69, '1', '1', '1', '1', '1'),
(2553, '6', 70, '0', '1', '1', '1', '1'),
(2554, '6', 71, '0', '1', '1', '1', '1'),
(2560, '8', 62, '0', '1', '1', '1', '1'),
(2561, '8', 63, '1', '1', '1', '1', '1'),
(2562, '8', 64, '1', '1', '1', '1', '1'),
(2563, '8', 65, '0', '1', '1', '1', '1'),
(2564, '8', 66, '1', '1', '1', '1', '1'),
(2565, '8', 67, '0', '1', '1', '1', '1'),
(2566, '8', 68, '0', '1', '1', '1', '1'),
(2567, '8', 69, '0', '1', '1', '1', '1'),
(2568, '8', 70, '0', '1', '1', '1', '1'),
(2569, '8', 71, '0', '1', '1', '1', '1'),
(2575, '9', 62, '0', '1', '1', '1', '1'),
(2576, '9', 63, '1', '1', '1', '1', '1'),
(2577, '9', 64, '0', '1', '1', '1', '1'),
(2578, '9', 65, '0', '1', '1', '1', '1'),
(2579, '9', 66, '0', '1', '1', '1', '1'),
(2580, '9', 67, '0', '1', '1', '1', '1'),
(2581, '9', 68, '0', '1', '1', '1', '1'),
(2582, '9', 69, '0', '1', '1', '1', '1'),
(2583, '9', 70, '0', '1', '1', '1', '1'),
(2584, '9', 71, '0', '1', '1', '1', '1'),
(2590, '10', 62, '1', '1', '1', '1', '1'),
(2591, '10', 63, '1', '1', '1', '1', '1'),
(2592, '10', 64, '0', '1', '1', '1', '1'),
(2593, '10', 65, '0', '1', '1', '1', '1'),
(2594, '10', 66, '0', '1', '1', '1', '1'),
(2595, '10', 67, '0', '1', '1', '1', '1'),
(2596, '10', 68, '0', '1', '1', '1', '1'),
(2597, '10', 69, '0', '1', '1', '1', '1'),
(2598, '10', 70, '0', '1', '1', '1', '1'),
(2599, '10', 71, '0', '1', '1', '1', '1'),
(2605, '11', 62, '0', '1', '1', '1', '1'),
(2606, '11', 63, '1', '1', '1', '1', '1'),
(2607, '11', 64, '0', '1', '1', '1', '1'),
(2608, '11', 65, '0', '1', '1', '1', '1'),
(2609, '11', 66, '0', '1', '1', '1', '1'),
(2610, '11', 67, '0', '1', '1', '1', '1'),
(2611, '11', 68, '0', '1', '1', '1', '1'),
(2612, '11', 69, '0', '1', '1', '1', '1'),
(2613, '11', 70, '0', '1', '1', '1', '1'),
(2614, '11', 71, '0', '1', '1', '1', '1'),
(2620, '12', 62, '0', '1', '1', '1', '1'),
(2621, '12', 63, '0', '1', '1', '1', '1'),
(2622, '12', 64, '0', '1', '1', '1', '1'),
(2623, '12', 65, '0', '1', '1', '1', '1'),
(2624, '12', 66, '0', '1', '1', '1', '1'),
(2625, '12', 67, '0', '1', '1', '1', '1'),
(2626, '12', 68, '0', '1', '1', '1', '1'),
(2627, '12', 69, '0', '1', '1', '1', '1'),
(2628, '12', 70, '0', '1', '1', '1', '1'),
(2629, '12', 71, '0', '1', '1', '1', '1'),
(2635, '13', 62, '0', '1', '1', '1', '1'),
(2636, '13', 63, '0', '1', '1', '1', '1'),
(2637, '13', 64, '0', '1', '1', '1', '1'),
(2638, '13', 65, '0', '1', '1', '1', '1'),
(2639, '13', 66, '0', '1', '1', '1', '1'),
(2640, '13', 67, '0', '1', '1', '1', '1'),
(2641, '13', 68, '0', '1', '1', '1', '1'),
(2642, '13', 69, '0', '1', '1', '1', '1'),
(2643, '13', 70, '0', '1', '1', '1', '1'),
(2644, '13', 71, '0', '1', '1', '1', '1'),
(2650, '1', 72, '1', '1', '1', '1', '1'),
(2651, '1', 73, '1', '1', '1', '1', '1'),
(2652, '1', 74, '1', '1', '1', '1', '1'),
(2653, '1', 75, '1', '1', '1', '1', '1'),
(2654, '1', 76, '1', '1', '1', '1', '1'),
(2655, '1', 77, '1', '1', '1', '1', '1'),
(2656, '1', 78, '1', '1', '1', '1', '1'),
(2657, '1', 79, '1', '1', '1', '1', '1');

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

--
-- Table structure for table `shipping_charges`
--

CREATE TABLE `shipping_charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `loading_points` varchar(255) DEFAULT NULL,
  `distance` varchar(255) DEFAULT NULL,
  `tds` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `amount_payable` varchar(255) DEFAULT NULL,
  `status` enum('request_sent','rejected','approved','paid','re_request') NOT NULL DEFAULT 'request_sent',
  `payment_mode` enum('cash','neft_imps','upi','other') NOT NULL,
  `payer` enum('mytyles','customer') NOT NULL,
  `agent_comment` text DEFAULT NULL,
  `accounts_comment` text DEFAULT NULL,
  `reason_for_rejection` text DEFAULT NULL,
  `media_ids` varchar(255) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `rejected_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `request_raised_time` timestamp NULL DEFAULT NULL,
  `rejected_time` timestamp NULL DEFAULT NULL,
  `re_request_time` timestamp NULL DEFAULT NULL,
  `paid_time` timestamp NULL DEFAULT NULL,
  `approved_time` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `short_urls`
--

CREATE TABLE `short_urls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(255) NOT NULL,
  `short_url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(11) NOT NULL,
  `state_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `state_name`) VALUES
(1, 'ANDHRA PRADESH'),
(2, 'ASSAM'),
(3, 'ARUNACHAL PRADESH'),
(4, 'BIHAR'),
(5, 'GUJRAT'),
(6, 'HARYANA'),
(7, 'HIMACHAL PRADESH'),
(8, 'JAMMU & KASHMIR'),
(9, 'KARNATAKA'),
(10, 'KERALA'),
(11, 'MADHYA PRADESH'),
(12, 'MAHARASHTRA'),
(13, 'MANIPUR'),
(14, 'MEGHALAYA'),
(15, 'MIZORAM'),
(16, 'NAGALAND'),
(17, 'ORISSA'),
(18, 'PUNJAB'),
(19, 'RAJASTHAN'),
(20, 'SIKKIM'),
(21, 'TAMIL NADU'),
(22, 'TRIPURA'),
(23, 'UTTAR PRADESH'),
(24, 'WEST BENGAL'),
(25, 'DELHI'),
(26, 'GOA'),
(27, 'PONDICHERY'),
(28, 'LAKSHDWEEP'),
(29, 'DAMAN & DIU'),
(30, 'DADRA & NAGAR'),
(31, 'CHANDIGARH'),
(32, 'ANDAMAN & NICOBAR'),
(33, 'UTTARANCHAL'),
(34, 'JHARKHAND'),
(35, 'CHATTISGARH');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint(20) NOT NULL,
  `lead_id` bigint(20) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `follow_up_date` date DEFAULT NULL,
  `follow_up_time` time DEFAULT NULL,
  `task_details` text DEFAULT NULL,
  `reminder` tinyint(1) DEFAULT 0,
  `notification_send` enum('0','1') NOT NULL DEFAULT '0',
  `status` enum('pending','completed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` bigint(20) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_order_id_foreign` (`order_id`),
  ADD KEY `activity_logs_activity_by_foreign` (`activity_by`),
  ADD KEY `activity_logs_commented_by_foreign` (`commented_by`),
  ADD KEY `activity_logs_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `architects`
--
ALTER TABLE `architects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `architects_created_by_foreign` (`created_by`),
  ADD KEY `architects_updated_by_foreign` (`updated_by`),
  ADD KEY `architects_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `architect_media`
--
ALTER TABLE `architect_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `architect_media_architect_id_foreign` (`architect_id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_order_id_foreign` (`order_id`),
  ADD KEY `comments_commented_by_foreign` (`commented_by`),
  ADD KEY `comments_comment_for_foreign` (`comment_for`),
  ADD KEY `comments_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
  ADD PRIMARY KEY (`id`),
  ADD KEY `complaints_support_executive_foreign` (`support_executive`),
  ADD KEY `complaints_created_by_foreign` (`created_by`),
  ADD KEY `complaints_updated_by_foreign` (`updated_by`),
  ADD KEY `complaints_deleted_by_foreign` (`deleted_by`),
  ADD KEY `complaints_order_id_foreign` (`order_id`) USING BTREE;

--
-- Indexes for table `complaint_activities`
--
ALTER TABLE `complaint_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `complaint_activities_complaint_id_foreign` (`complaint_id`),
  ADD KEY `complaint_activities_activity_by_foreign` (`activity_by`);

--
-- Indexes for table `complaint_comments`
--
ALTER TABLE `complaint_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `complaint_comments_complaint_id_foreign` (`complaint_id`),
  ADD KEY `complaint_comments_commented_by_foreign` (`commented_by`);

--
-- Indexes for table `complaint_media`
--
ALTER TABLE `complaint_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `complaint_media_complaint_id_foreign` (`complaint_id`),
  ADD KEY `complaint_media_response_id_foreign` (`response_id`),
  ADD KEY `complaint_media_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `complaint_responses`
--
ALTER TABLE `complaint_responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `complaint_responses_complaint_id_foreign` (`complaint_id`),
  ADD KEY `complaint_responses_agent_assigned_foreign` (`agent_assigned`),
  ADD KEY `complaint_responses_created_by_foreign` (`created_by`),
  ADD KEY `complaint_responses_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `daily_worklogs`
--
ALTER TABLE `daily_worklogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `daily_worklogs_user_id_foreign` (`user_id`),
  ADD KEY `daily_worklogs_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `daily_worklog_documents`
--
ALTER TABLE `daily_worklog_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `daily_worklog_documents_daily_worklog_id_foreign` (`daily_worklog_id`),
  ADD KEY `daily_worklog_documents_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `daily_worklog_media`
--
ALTER TABLE `daily_worklog_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `daily_worklog_media_daily_worklog_id_foreign` (`daily_worklog_id`),
  ADD KEY `daily_worklog_media_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `delivery_modes`
--
ALTER TABLE `delivery_modes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `delivery_modes_order_id_unique` (`order_id`),
  ADD KEY `delivery_modes_created_by_foreign` (`created_by`),
  ADD KEY `delivery_modes_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `documents_uploaded_by_foreign` (`uploaded_by`),
  ADD KEY `documents_order_id_foreign` (`order_id`),
  ADD KEY `documents_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `document_proofs`
--
ALTER TABLE `document_proofs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `document_proofs_order_id_foreign` (`order_id`),
  ADD KEY `document_proofs_created_by_foreign` (`created_by`),
  ADD KEY `document_proofs_commented_by_foreign` (`commented_by`),
  ADD KEY `document_proofs_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `leads_created_by_foreign` (`created_by`),
  ADD KEY `leads_owner_foreign` (`lead_owner_id`),
  ADD KEY `leads_updated_by_foreign` (`updated_by`),
  ADD KEY `leads_deleted_by_foreign` (`deleted_by`),
  ADD KEY `billing_address_fk` (`billing_address_id`),
  ADD KEY `shiping_address_fk` (`shipping_address_id`);

--
-- Indexes for table `lead_activities`
--
ALTER TABLE `lead_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_activities_lead_id_foreign` (`lead_id`),
  ADD KEY `lead_activities_created_by_foreign` (`created_by`);

--
-- Indexes for table `lead_address`
--
ALTER TABLE `lead_address`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_fk` (`state_id`),
  ADD KEY `city_fk` (`city_id`),
  ADD KEY `lead_fk` (`lead_id`);

--
-- Indexes for table `lead_comments`
--
ALTER TABLE `lead_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_id` (`lead_id`);

--
-- Indexes for table `lead_history`
--
ALTER TABLE `lead_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_history_ibfk_1` (`lead_id`),
  ADD KEY `lead_history_ibfk_3` (`updated_by`);

--
-- Indexes for table `lead_images`
--
ALTER TABLE `lead_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_id` (`lead_id`);

--
-- Indexes for table `lead_requirements`
--
ALTER TABLE `lead_requirements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `links`
--
ALTER TABLE `links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `links_order_id_foreign` (`order_id`),
  ADD KEY `links_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `master_branch_name`
--
ALTER TABLE `master_branch_name`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_brand`
--
ALTER TABLE `master_brand`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_country_manufacture`
--
ALTER TABLE `master_country_manufacture`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_details`
--
ALTER TABLE `master_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_material_type`
--
ALTER TABLE `master_material_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_modules`
--
ALTER TABLE `master_modules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_category`
--
ALTER TABLE `master_product_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_delivery_time`
--
ALTER TABLE `master_product_delivery_time`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_finish`
--
ALTER TABLE `master_product_finish`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_quality`
--
ALTER TABLE `master_product_quality`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_size`
--
ALTER TABLE `master_product_size`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_product_uses`
--
ALTER TABLE `master_product_uses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_requirements`
--
ALTER TABLE `master_requirements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_roles`
--
ALTER TABLE `master_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_order_id_foreign` (`order_id`),
  ADD KEY `media_created_by_foreign` (`created_by`),
  ADD KEY `media_commented_by_foreign` (`commented_by`),
  ADD KEY `media_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sale_order_no_and_start_finalcial_year_and_is_deleted_foreign` (`sale_order_no`,`start_financial_year`,`is_deleted`),
  ADD KEY `orders_sales_person_foreign` (`sales_person`),
  ADD KEY `orders_dispatch_manager_foreign` (`dispatch_manager`),
  ADD KEY `orders_created_by_foreign` (`created_by`),
  ADD KEY `orders_updated_by_foreign` (`updated_by`),
  ADD KEY `orders_deleted_by_foreign` (`deleted_by`),
  ADD KEY `orders_quotation_id_foreign` (`quotation_id`),
  ADD KEY `orders_lead_id_foreign` (`lead_id`) USING BTREE,
  ADD KEY `orders_delivery_agent_foreign` (`delivery_agent`),
  ADD KEY `orders_architect_foreign` (`architect`),
  ADD KEY `order_short_url_foreign` (`short_url_id`);

--
-- Indexes for table `orders_info`
--
ALTER TABLE `orders_info`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `start_financial_year` (`start_financial_year`,`sale_order_no`,`is_deleted`),
  ADD KEY `orders_sales_person_foreign` (`sales_person`),
  ADD KEY `orders_created_by_foreign` (`created_by`),
  ADD KEY `orders_updated_by_foreign` (`updated_by`),
  ADD KEY `orders_deleted_by_foreign` (`deleted_by`),
  ADD KEY `orders_lead_id_foreign` (`lead_id`);

--
-- Indexes for table `order_reschedule_datas`
--
ALTER TABLE `order_reschedule_datas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_reschedule_datas_order_id_foreign` (`order_id`),
  ADD KEY `order_reschedule_datas_updated_by_foreign` (`updated_by`),
  ADD KEY `order_reschedule_datas_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `order_tasks`
--
ALTER TABLE `order_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order__tasks_order_id_foreign` (`order_id`),
  ADD KEY `order__tasks_document_id_foreign` (`document_id`),
  ADD KEY `order__tasks_assigned_to_foreign` (`assigned_to`),
  ADD KEY `order__tasks_assigned_by_foreign` (`assigned_by`),
  ADD KEY `order__tasks_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_order_id_foreign` (`order_id`),
  ADD KEY `payments_created_by_foreign` (`created_by`),
  ADD KEY `payments_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_sku` (`product_sku`),
  ADD UNIQUE KEY `product_code` (`product_code`),
  ADD UNIQUE KEY `product_id` (`product_id`),
  ADD KEY `brand_id` (`brand_id`),
  ADD KEY `country_of_manufacture` (`country_of_manufacture`),
  ADD KEY `product_finish` (`product_finish`),
  ADD KEY `product_material_type` (`product_material_type`),
  ADD KEY `product_quality` (`product_quality`),
  ADD KEY `delivery_time` (`delivery_time`),
  ADD KEY `vendor_company_name` (`vendor_company_name`),
  ADD KEY `product_size` (`product_size`);

--
-- Indexes for table `product_category`
--
ALTER TABLE `product_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `product_category_ibfk_1` (`product_category_id`);

--
-- Indexes for table `product_multiple_images`
--
ALTER TABLE `product_multiple_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_uses`
--
ALTER TABLE `product_uses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `quotation`
--
ALTER TABLE `quotation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `quote_number` (`quote_number`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `sales_executive_user` (`sales_executive_user`);

--
-- Indexes for table `quotation_products`
--
ALTER TABLE `quotation_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_fk` (`product_id`),
  ADD KEY `quotaton_id` (`quotation_id`),
  ADD KEY `vendor_id` (`vendor_id`);

--
-- Indexes for table `quotation_products_history`
--
ALTER TABLE `quotation_products_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `razorpay_informations`
--
ALTER TABLE `razorpay_informations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `razorpay_informations_created_by_foreign` (`created_by`),
  ADD KEY `razorpay_informations_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `reminders`
--
ALTER TABLE `reminders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reminders_created_by_foreign` (`created_by`);

--
-- Indexes for table `reminder_media`
--
ALTER TABLE `reminder_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reminder_media_reminder_id_foreign` (`reminder_id`);

--
-- Indexes for table `roles_permission`
--
ALTER TABLE `roles_permission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `module_id` (`module_id`);

--
-- Indexes for table `shipping_charges`
--
ALTER TABLE `shipping_charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shipping__charges_order_id_foreign` (`order_id`),
  ADD KEY `shipping__charges_agent_id_foreign` (`agent_id`),
  ADD KEY `shipping__charges_rejected_by_foreign` (`rejected_by`),
  ADD KEY `shipping__charges_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `short_urls`
--
ALTER TABLE `short_urls`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `short_urls_short_url_unique` (`short_url`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_id` (`lead_id`);

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `architects`
--
ALTER TABLE `architects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `architect_media`
--
ALTER TABLE `architect_media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=692;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_activities`
--
ALTER TABLE `complaint_activities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_comments`
--
ALTER TABLE `complaint_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_media`
--
ALTER TABLE `complaint_media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `complaint_responses`
--
ALTER TABLE `complaint_responses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daily_worklogs`
--
ALTER TABLE `daily_worklogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daily_worklog_documents`
--
ALTER TABLE `daily_worklog_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `daily_worklog_media`
--
ALTER TABLE `daily_worklog_media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `delivery_modes`
--
ALTER TABLE `delivery_modes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `document_proofs`
--
ALTER TABLE `document_proofs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_activities`
--
ALTER TABLE `lead_activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_address`
--
ALTER TABLE `lead_address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_comments`
--
ALTER TABLE `lead_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_history`
--
ALTER TABLE `lead_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_images`
--
ALTER TABLE `lead_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lead_requirements`
--
ALTER TABLE `lead_requirements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `links`
--
ALTER TABLE `links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `master_modules`
--
ALTER TABLE `master_modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

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

--
-- AUTO_INCREMENT for table `master_product_delivery_time`
--
ALTER TABLE `master_product_delivery_time`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

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

--
-- AUTO_INCREMENT for table `master_product_size`
--
ALTER TABLE `master_product_size`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

--
-- AUTO_INCREMENT for table `master_roles`
--
ALTER TABLE `master_roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders_info`
--
ALTER TABLE `orders_info`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_reschedule_datas`
--
ALTER TABLE `order_reschedule_datas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_tasks`
--
ALTER TABLE `order_tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_multiple_images`
--
ALTER TABLE `product_multiple_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_uses`
--
ALTER TABLE `product_uses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation`
--
ALTER TABLE `quotation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation_products`
--
ALTER TABLE `quotation_products`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation_products_history`
--
ALTER TABLE `quotation_products_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `razorpay_informations`
--
ALTER TABLE `razorpay_informations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reminders`
--
ALTER TABLE `reminders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reminder_media`
--
ALTER TABLE `reminder_media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles_permission`
--
ALTER TABLE `roles_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3488;

--
-- AUTO_INCREMENT for table `shipping_charges`
--
ALTER TABLE `shipping_charges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `short_urls`
--
ALTER TABLE `short_urls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_activity_by_foreign` FOREIGN KEY (`activity_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `activity_logs_commented_by_foreign` FOREIGN KEY (`commented_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `activity_logs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `activity_logs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `architects`
--
ALTER TABLE `architects`
  ADD CONSTRAINT `architects_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `architects_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `architects_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `architect_media`
--
ALTER TABLE `architect_media`
  ADD CONSTRAINT `architect_media_architect_id_foreign` FOREIGN KEY (`architect_id`) REFERENCES `architects` (`id`);

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_comment_for_foreign` FOREIGN KEY (`comment_for`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `comments_commented_by_foreign` FOREIGN KEY (`commented_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `comments_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `comments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `complaints`
--
ALTER TABLE `complaints`
  ADD CONSTRAINT `complaints_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaints_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaints_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `complaints_support_executive_foreign` FOREIGN KEY (`support_executive`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaints_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `complaint_activities`
--
ALTER TABLE `complaint_activities`
  ADD CONSTRAINT `complaint_activities_activity_by_foreign` FOREIGN KEY (`activity_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaint_activities_complaint_id_foreign` FOREIGN KEY (`complaint_id`) REFERENCES `complaints` (`id`);

--
-- Constraints for table `complaint_comments`
--
ALTER TABLE `complaint_comments`
  ADD CONSTRAINT `complaint_comments_commented_by_foreign` FOREIGN KEY (`commented_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaint_comments_complaint_id_foreign` FOREIGN KEY (`complaint_id`) REFERENCES `complaints` (`id`);

--
-- Constraints for table `complaint_media`
--
ALTER TABLE `complaint_media`
  ADD CONSTRAINT `complaint_media_complaint_id_foreign` FOREIGN KEY (`complaint_id`) REFERENCES `complaints` (`id`),
  ADD CONSTRAINT `complaint_media_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaint_media_response_id_foreign` FOREIGN KEY (`response_id`) REFERENCES `complaint_responses` (`id`);

--
-- Constraints for table `complaint_responses`
--
ALTER TABLE `complaint_responses`
  ADD CONSTRAINT `complaint_responses_agent_assigned_foreign` FOREIGN KEY (`agent_assigned`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaint_responses_complaint_id_foreign` FOREIGN KEY (`complaint_id`) REFERENCES `complaints` (`id`),
  ADD CONSTRAINT `complaint_responses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `complaint_responses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `daily_worklogs`
--
ALTER TABLE `daily_worklogs`
  ADD CONSTRAINT `daily_worklogs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `daily_worklogs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `daily_worklog_documents`
--
ALTER TABLE `daily_worklog_documents`
  ADD CONSTRAINT `daily_worklog_documents_daily_worklog_id_foreign` FOREIGN KEY (`daily_worklog_id`) REFERENCES `daily_worklogs` (`id`),
  ADD CONSTRAINT `daily_worklog_documents_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `daily_worklog_media`
--
ALTER TABLE `daily_worklog_media`
  ADD CONSTRAINT `daily_worklog_media_daily_worklog_id_foreign` FOREIGN KEY (`daily_worklog_id`) REFERENCES `daily_worklogs` (`id`),
  ADD CONSTRAINT `daily_worklog_media_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `delivery_modes`
--
ALTER TABLE `delivery_modes`
  ADD CONSTRAINT `delivery_modes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `delivery_modes_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `delivery_modes_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `documents_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `documents_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `documents_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `document_proofs`
--
ALTER TABLE `document_proofs`
  ADD CONSTRAINT `document_proofs_commented_by_foreign` FOREIGN KEY (`commented_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `document_proofs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `document_proofs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `document_proofs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `lead_activities`
--
ALTER TABLE `lead_activities`
  ADD CONSTRAINT `lead_activities_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `lead_address`
--
ALTER TABLE `lead_address`
  ADD CONSTRAINT `city_fk` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `lead_fk` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `state_fk` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `lead_comments`
--
ALTER TABLE `lead_comments`
  ADD CONSTRAINT `lead_comments_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `lead_history`
--
ALTER TABLE `lead_history`
  ADD CONSTRAINT `lead_history_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `lead_images`
--
ALTER TABLE `lead_images`
  ADD CONSTRAINT `lead_images_ibfk_1` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `links`
--
ALTER TABLE `links`
  ADD CONSTRAINT `links_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `links_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_commented_by_foreign` FOREIGN KEY (`commented_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `media_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `media_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `media_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `order_short_url_foreign` FOREIGN KEY (`short_url_id`) REFERENCES `short_urls` (`id`),
  ADD CONSTRAINT `orders_architect_foreign` FOREIGN KEY (`architect`) REFERENCES `architects` (`id`),
  ADD CONSTRAINT `orders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_delivery_agent_foreign` FOREIGN KEY (`delivery_agent`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_dispatch_manager_foreign` FOREIGN KEY (`dispatch_manager`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`),
  ADD CONSTRAINT `orders_quotation_id_foreign` FOREIGN KEY (`quotation_id`) REFERENCES `quotation` (`id`),
  ADD CONSTRAINT `orders_sales_person_foreign` FOREIGN KEY (`sales_person`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `orders_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `order_reschedule_datas`
--
ALTER TABLE `order_reschedule_datas`
  ADD CONSTRAINT `order_reschedule_datas_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order_reschedule_datas_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_reschedule_datas_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `order_tasks`
--
ALTER TABLE `order_tasks`
  ADD CONSTRAINT `order__tasks_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order__tasks_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order__tasks_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `order__tasks_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),
  ADD CONSTRAINT `order__tasks_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `payments_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_2` FOREIGN KEY (`country_of_manufacture`) REFERENCES `master_country_manufacture` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_3` FOREIGN KEY (`product_finish`) REFERENCES `master_product_finish` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_4` FOREIGN KEY (`product_material_type`) REFERENCES `master_material_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_5` FOREIGN KEY (`product_quality`) REFERENCES `master_product_quality` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_6` FOREIGN KEY (`delivery_time`) REFERENCES `master_product_delivery_time` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_7` FOREIGN KEY (`vendor_company_name`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_8` FOREIGN KEY (`brand_id`) REFERENCES `master_brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `products_ibfk_9` FOREIGN KEY (`product_size`) REFERENCES `master_product_size` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_category`
--
ALTER TABLE `product_category`
  ADD CONSTRAINT `product_category_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `master_product_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_uses`
--
ALTER TABLE `product_uses`
  ADD CONSTRAINT `product_uses_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`);

--
-- Constraints for table `quotation`
--
ALTER TABLE `quotation`
  ADD CONSTRAINT `quotation_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `quotation_products`
--
ALTER TABLE `quotation_products`
  ADD CONSTRAINT `quotation_products_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `quotation_products_ibfk_2` FOREIGN KEY (`quotation_id`) REFERENCES `quotation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `razorpay_informations`
--
ALTER TABLE `razorpay_informations`
  ADD CONSTRAINT `razorpay_informations_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `razorpay_informations_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `reminders`
--
ALTER TABLE `reminders`
  ADD CONSTRAINT `created_by_foreign_key` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `reminder_media`
--
ALTER TABLE `reminder_media`
  ADD CONSTRAINT `reminder_foreign_key` FOREIGN KEY (`reminder_id`) REFERENCES `reminders` (`id`);

--
-- Constraints for table `shipping_charges`
--
ALTER TABLE `shipping_charges`
  ADD CONSTRAINT `shipping__charges_agent_id_foreign` FOREIGN KEY (`agent_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `shipping__charges_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `shipping__charges_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `shipping__charges_rejected_by_foreign` FOREIGN KEY (`rejected_by`) REFERENCES `users` (`id`);
COMMIT;

