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

START TRANSACTION;



--
-- Database: `idex_new_12`
--

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

--
-- Table structure for table `aic_districts`
--

CREATE TABLE `aic_districts` (
  `id` int(11) NOT NULL,
  `stateid` varchar(200) NOT NULL,
  `name` varchar(255) NOT NULL,
  `distic_status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aic_districts`
--

INSERT INTO `aic_districts` (`id`, `stateid`, `name`, `distic_status`) VALUES
(1, '1', 'Anantnag', 0),
(2, '1', 'Bandipora', 0),
(3, '1', 'Baramulla', 0),
(4, '1', 'Budgam', 0),
(5, '1', 'Doda', 0),
(6, '1', 'Ganderbal', 0),
(7, '1', 'Jammu', 0),
(8, '1', 'Kargil', 0),
(9, '1', 'Kathua', 0),
(10, '1', 'Kishtwar', 0),
(11, '1', 'Kulgam', 0),
(12, '1', 'Kupwara', 0),
(13, '1', 'Leh', 0),
(14, '1', 'Poonch', 0),
(15, '1', 'Pulwama', 0),
(16, '1', 'Rajouri', 0),
(17, '1', 'Ramban', 0),
(18, '1', 'Reasi', 0),
(19, '1', 'Samba', 0),
(20, '1', 'Shopian', 0),
(21, '1', 'Srinagar', 0),
(22, '1', 'Udhampur', 0),
(23, '2', 'Bilaspur', 0),
(24, '2', 'Chamba', 0),
(25, '2', 'Hamirpur', 0),
(26, '2', 'Kangra', 0),
(27, '2', 'Kinnaur', 0),
(28, '2', 'Kullu', 0),
(29, '2', 'Lahaul and Spiti', 0),
(30, '2', 'Mandi', 0),
(31, '2', 'Shimla', 0),
(32, '2', 'Sirmaur', 0),
(33, '2', 'Solan', 0),
(34, '2', 'Una', 0),
(35, '3', 'Amritsar', 0),
(36, '3', 'Barnala', 0),
(37, '3', 'Bathinda', 0),
(38, '3', 'Faridkot', 0),
(39, '3', 'Fatehgarh Sahib', 0),
(40, '3', 'Fazilka', 0),
(41, '3', 'Ferozepur', 0),
(42, '3', 'Gurdaspur', 0),
(43, '3', 'Hoshiarpur', 0),
(44, '3', 'Jalandhar', 0),
(45, '3', 'Kapurthala', 0),
(46, '3', 'Ludhiana', 0),
(47, '3', 'Mansa', 0),
(48, '3', 'Moga', 0),
(49, '3', 'Mohali', 0),
(50, '3', 'Muktsar', 0),
(51, '3', 'Pathankot', 0),
(52, '3', 'Patiala', 0),
(53, '3', 'Rupnagar', 0),
(54, '3', 'Sangrur', 0),
(55, '3', 'Shahid Bhagat Singh Nagar', 0),
(56, '3', 'Tarn Taran', 0),
(57, '4', 'Almora', 0),
(58, '4', 'Bageshwar', 0),
(59, '4', 'Chamoli', 0),
(60, '4', 'Champawat', 0),
(61, '4', 'Dehradun', 0),
(62, '4', 'Haridwar', 0),
(63, '4', 'Nainital', 0),
(64, '4', 'Pauri Garhwal', 0),
(65, '4', 'Pithoragarh', 0),
(66, '4', 'Rudraprayag', 0),
(67, '4', 'Tehri Garhwal', 0),
(68, '4', 'Udham Singh Nagar', 0),
(69, '4', 'Uttarkashi', 0),
(70, '5', 'Agra', 0),
(71, '5', 'Aligarh', 0),
(72, '5', 'Allahabad', 0),
(73, '5', 'Ambedkar Nagar', 0),
(74, '5', 'Amethi', 0),
(75, '5', 'Amroha', 0),
(76, '5', 'Auraiya', 0),
(77, '5', 'Azamgarh', 0),
(78, '5', 'Baghpat', 0),
(79, '5', 'Bahraich', 0),
(80, '5', 'Ballia', 0),
(81, '5', 'Balrampur', 0),
(82, '5', 'Banda', 0),
(83, '5', 'Barabanki', 0),
(84, '5', 'Bareilly', 0),
(85, '5', 'Basti', 0),
(86, '5', 'Bijnor', 0),
(87, '5', 'Budaun', 0),
(88, '5', 'Bulandshahr', 0),
(89, '5', 'Chandauli', 0),
(90, '5', 'Chitrakoot', 0),
(91, '5', 'Deoria', 0),
(92, '5', 'Etah', 0),
(93, '5', 'Etawah', 0),
(94, '5', 'Faizabad', 0),
(95, '5', 'Farrukhabad', 0),
(96, '5', 'Fatehpur', 0),
(97, '5', 'Firozabad', 0),
(98, '5', 'Gautam Buddha Nagar', 0),
(99, '5', 'Ghaziabad', 0),
(100, '5', 'Ghazipur', 0),
(101, '5', 'Gonda', 0),
(102, '5', 'Gorakhpur', 0),
(103, '5', 'Hamirpur', 0),
(104, '5', 'Hapur', 0),
(105, '5', 'Hardoi', 0),
(106, '5', 'Hathras', 0),
(107, '5', 'Jalaun', 0),
(108, '5', 'Jaunpur', 0),
(109, '5', 'Jhansi', 0),
(110, '5', 'Kannauj', 0),
(111, '5', 'Kanpur Dehat', 0),
(112, '5', 'Kanpur Nagar', 0),
(113, '5', 'Kanshiram Nagar', 0),
(114, '5', 'Kaushambi', 0),
(115, '5', 'Kheri', 0),
(116, '5', 'Kushinagar', 0),
(117, '5', 'Lalitpur', 0),
(118, '5', 'Lucknow', 0),
(119, '5', 'Maharajganj', 0),
(120, '5', 'Mahoba', 0),
(121, '5', 'Mainpuri', 0),
(122, '5', 'Mathura', 0),
(123, '5', 'Mau', 0),
(124, '5', 'Meerut', 0),
(125, '5', 'Mirzapur', 0),
(126, '5', 'Moradabad', 0),
(127, '5', 'Muzaffarnagar', 0),
(128, '5', 'Pilibhit', 0),
(129, '5', 'Pratapgarh', 0),
(130, '5', 'Raebareli', 0),
(131, '5', 'Rampur', 0),
(132, '5', 'Saharanpur', 0),
(133, '5', 'Sambhal', 0),
(134, '5', 'Sant Kabir Nagar', 0),
(135, '5', 'Sant Ravidas Nagar', 0),
(136, '5', 'Shahjahanpur', 0),
(137, '5', 'Shamli', 0),
(138, '5', 'Shravasti', 0),
(139, '5', 'Siddharthnagar', 0),
(140, '5', 'Sitapur', 0),
(141, '5', 'Sonbhadra', 0),
(142, '5', 'Sultanpur', 0),
(143, '5', 'Unnao', 0),
(144, '5', 'Varanasi', 0),
(145, '6', 'Ambala', 0),
(146, '6', 'Bhiwani', 0),
(147, '6', 'Charkhi Dadri', 0),
(148, '6', 'Faridabad', 0),
(149, '6', 'Fatehabad', 0),
(150, '6', 'Gurgaon', 0),
(151, '6', 'Hisar', 0),
(152, '6', 'Jhajjar', 0),
(153, '6', 'Jind', 0),
(154, '6', 'Kaithal', 0),
(155, '6', 'Karnal', 0),
(156, '6', 'Kurukshetra', 0),
(157, '6', 'Mahendragarh', 0),
(158, '6', 'Mewat', 0),
(159, '6', 'Palwal', 0),
(160, '6', 'Panchkula', 0),
(161, '6', 'Panipat', 0),
(162, '6', 'Rewari', 0),
(163, '6', 'Rohtak', 0),
(164, '6', 'Sirsa', 0),
(165, '6', 'Sonipat', 0),
(166, '6', 'Yamunanagar', 0),
(167, '7', 'Central Delhi', 0),
(168, '7', 'East Delhi', 0),
(169, '7', 'New Delhi', 0),
(170, '7', 'North Delhi', 0),
(171, '7', 'North East Delhi', 0),
(172, '7', 'North West Delhi', 0),
(173, '7', 'Shahdara', 0),
(174, '7', 'South Delhi', 0),
(175, '7', 'South East Delhi', 0),
(176, '7', 'South West Delhi', 0),
(177, '7', 'West Delhi', 0),
(178, '8', 'Chandigarh', 0),
(179, '9', 'Araria', 0),
(180, '9', 'Arwal', 0),
(181, '9', 'Aurangabad', 0),
(182, '9', 'Banka', 0),
(183, '9', 'Begusarai', 0),
(184, '9', 'Bhabhua', 0),
(185, '9', 'Bhagalpur', 0),
(186, '9', 'Bhojpur', 0),
(187, '9', 'Buxar', 0),
(188, '9', 'Darbhanga', 0),
(189, '9', 'East Champaran', 0),
(190, '9', 'Gaya', 0),
(191, '9', 'Gopalganj', 0),
(192, '9', 'Jamui', 0),
(193, '9', 'Jehanabad', 0),
(194, '9', 'Katihar', 0),
(195, '9', 'Khagaria', 0),
(196, '9', 'Kishanganj', 0),
(197, '9', 'Lakhisarai', 0),
(198, '9', 'Madhepura', 0),
(199, '9', 'Madhubani', 0),
(200, '9', 'Munger', 0),
(201, '9', 'Muzaffarpur', 0),
(202, '9', 'Nalanda', 0),
(203, '9', 'Nawada', 0),
(204, '9', 'Patna', 0),
(205, '9', 'Purnea', 0),
(206, '9', 'Rohtas', 0),
(207, '9', 'Saharsa', 0),
(208, '9', 'Samastipur', 0),
(209, '9', 'Saran', 0),
(210, '9', 'Sheikhpura', 0),
(211, '9', 'Sheohar', 0),
(212, '9', 'Sitamarhi', 0),
(213, '9', 'Siwan', 0),
(214, '9', 'Supaul', 0),
(215, '9', 'Vaishali', 0),
(216, '9', 'West Champaran', 0),
(217, '10', 'Angul', 0),
(218, '10', 'Balangir', 0),
(219, '10', 'Balasore', 0),
(220, '10', 'Bargarh', 0),
(221, '10', 'Bhadrak', 0),
(222, '10', 'Boudh', 0),
(223, '10', 'Cuttack', 0),
(224, '10', 'Debagarh', 0),
(225, '10', 'Dhenkanal', 0),
(226, '10', 'Gajapati', 0),
(227, '10', 'Ganjam', 0),
(228, '10', 'Jagatsinghpur', 0),
(229, '10', 'Jajpur', 0),
(230, '10', 'Jharsuguda', 0),
(231, '10', 'Kalahandi', 0),
(232, '10', 'Kandhamal', 0),
(233, '10', 'Kendrapara', 0),
(234, '10', 'Kendujhar', 0),
(235, '10', 'Khordha', 0),
(236, '10', 'Koraput', 0),
(237, '10', 'Malkangiri', 0),
(238, '10', 'Mayurbhanj', 0),
(239, '10', 'Nabarangapur', 0),
(240, '10', 'Nayagarh', 0),
(241, '10', 'Nuapada', 0),
(242, '10', 'Puri', 0),
(243, '10', 'Rayagada', 0),
(244, '10', 'Sambalpur', 0),
(245, '10', 'Subarnapur', 0),
(246, '10', 'Sundargarh', 0),
(247, '11', 'Bokaro', 0),
(248, '11', 'Balangir', 0),
(249, '11', 'Deoghar', 0),
(250, '11', 'Dhanbad', 0),
(251, '11', 'Dumka', 0),
(252, '11', 'East Singhbhum', 0),
(253, '11', 'Garhwa', 0),
(254, '11', 'Giridih', 0),
(255, '11', 'Godda', 0),
(256, '11', 'Gumla', 0),
(257, '11', 'Hazaribagh', 0),
(258, '11', 'Jamtara', 0),
(259, '11', 'Khunti', 0),
(260, '11', 'Koderma', 0),
(261, '11', 'Latehar', 0),
(262, '11', 'Lohardaga', 0),
(263, '11', 'Pakur', 0),
(264, '11', 'Palamu', 0),
(265, '11', 'Ramgarh', 0),
(266, '11', 'Ranchi', 0),
(267, '11', 'Sahibganj', 0),
(268, '11', 'Saraikela Kharsawan', 0),
(269, '11', 'Simdega', 0),
(270, '11', 'West Singhbhum', 0),
(271, '12', 'Alipurduar', 0),
(272, '12', 'Bankura', 0),
(273, '12', 'Birbhum', 0),
(274, '12', 'Bardhaman/Burdwan', 0),
(275, '12', 'Birbhum', 0),
(276, '12', 'Cooch Behar', 0),
(277, '12', 'Dakshin Dinajpur', 0),
(278, '12', 'Darjeeling', 0),
(279, '12', 'Hooghly', 0),
(280, '12', 'Howrah', 0),
(281, '12', 'Jalpaiguri', 0),
(282, '12', 'Kolkata', 0),
(283, '12', 'Malda', 0),
(284, '12', 'Murshidabad', 0),
(285, '12', 'Nadia', 0),
(286, '12', 'North 24 Parganas', 0),
(287, '12', 'Paschim Medinipur', 0),
(288, '12', 'Purba Medinipur', 0),
(289, '12', 'Purulia', 0),
(290, '12', 'South 24 Parganas', 0),
(291, '12', 'Uttar Dinajpur', 0),
(292, '13', 'Ajmer', 0),
(293, '13', 'Alwar', 0),
(294, '13', 'Banswara', 0),
(295, '13', 'Baran', 0),
(296, '13', 'Barmer', 0),
(297, '13', 'Bharatpur', 0),
(298, '13', 'Bhilwara', 0),
(299, '13', 'Bikaner', 0),
(300, '13', 'Bundi', 0),
(301, '13', 'Chittorgarh', 0),
(302, '13', 'Churu', 0),
(303, '13', 'Dausa', 0),
(304, '13', 'Dholpur', 0),
(305, '13', 'Dungarpur', 0),
(306, '13', 'Ganganagar', 0),
(307, '13', 'Hanumangarh', 0),
(308, '13', 'Jaipur', 0),
(309, '13', 'Jaisalmer', 0),
(310, '13', 'Jalore', 0),
(311, '13', 'Jhalawar', 0),
(312, '13', 'Jhunjhunu', 0),
(313, '13', 'Jodhpur', 0),
(314, '13', 'Karauli', 0),
(315, '13', 'Kota', 0),
(316, '13', 'Nagaur', 0),
(317, '13', 'Pali', 0),
(318, '13', 'Pratapgarh', 0),
(319, '13', 'Rajsamand', 0),
(320, '13', 'Sawai Madhopur', 0),
(321, '13', 'Sikar', 0),
(322, '13', 'Sirohi', 0),
(323, '13', 'Tonk', 0),
(324, '13', 'Udaipur', 0),
(325, '14', 'Ahmedabad', 0),
(326, '14', 'Amreli', 0),
(327, '14', 'Anand', 0),
(328, '14', 'Aravalli', 0),
(329, '14', 'Banaskantha', 0),
(330, '14', 'Bharuch', 0),
(331, '14', 'Bhavnagar', 0),
(332, '14', 'Botad', 0),
(333, '14', 'Chhota Udepur', 0),
(334, '14', 'Dahod', 0),
(335, '14', 'Dang', 0),
(336, '14', 'Devbhoomi Dwarka', 0),
(337, '14', 'Gandhinagar', 0),
(338, '14', 'Gir Somnath', 0),
(339, '14', 'Jamnagar', 0),
(340, '14', 'Junagadh', 0),
(341, '14', 'Kheda', 0),
(342, '14', 'Kutch', 0),
(343, '14', 'Mahisagar', 0),
(344, '14', 'Mehsana', 0),
(345, '14', 'Morbi', 0),
(346, '14', 'Narmada', 0),
(347, '14', 'Navsari', 0),
(348, '14', 'Panchmahal', 0),
(349, '14', 'Patan', 0),
(350, '14', 'Porbandar', 0),
(351, '14', 'Rajkot', 0),
(352, '14', 'Sabarkantha', 0),
(353, '14', 'Surat', 0),
(354, '14', 'Surendranagar', 0),
(355, '14', 'Tapi', 0),
(356, '14', 'Vadodara', 0),
(357, '14', 'Valsad', 0),
(358, '15', 'North Goa', 0),
(359, '15', 'South Goa', 0),
(360, '16', 'Ahmednagar', 0),
(361, '16', 'Akola', 0),
(362, '16', 'Amravati', 0),
(363, '16', 'Aurangabad', 0),
(364, '16', 'Beed', 0),
(365, '16', 'Bhandara', 0),
(366, '16', 'Buldhana', 0),
(367, '16', 'Chandrapur', 0),
(368, '16', 'Dhule', 0),
(369, '16', 'Gadchiroli', 0),
(370, '16', 'Gondia', 0),
(371, '16', 'Hingoli', 0),
(372, '16', 'Jalgaon', 0),
(373, '16', 'Jalna', 0),
(374, '16', 'Kolhapur', 0),
(375, '16', 'Latur', 0),
(376, '16', 'Mumbai City', 0),
(377, '16', 'Mumbai Suburban', 0),
(378, '16', 'Nagpur', 0),
(379, '16', 'Nanded', 0),
(380, '16', 'Nandurbar', 0),
(381, '16', 'Nashik', 0),
(382, '16', 'Osmanabad', 0),
(383, '16', 'Palghar', 0),
(384, '16', 'Parbhani', 0),
(385, '16', 'Pune', 0),
(386, '16', 'Raigad', 0),
(387, '16', 'Ratnagiri', 0),
(388, '16', 'Sangli', 0),
(389, '16', 'Satara', 0),
(390, '16', 'Sindhudurg', 0),
(391, '16', 'Solapur', 0),
(392, '16', 'Thane', 0),
(393, '16', 'Wardha', 0),
(394, '16', 'Washim', 0),
(395, '16', 'Yavatmal', 0),
(396, '17', 'Dadra & Nagar Haveli', 0),
(397, '18', 'Daman', 0),
(398, '18', 'Diu', 0),
(399, '19', 'Anantapur', 0),
(400, '19', 'Chittoor', 0),
(401, '19', 'East Godavari', 0),
(402, '19', 'Guntur', 0),
(403, '19', 'Kadapa', 0),
(404, '19', 'Krishna', 0),
(405, '19', 'Kurnool', 0),
(406, '19', 'Nellore', 0),
(407, '19', 'Prakasam', 0),
(408, '19', 'Srikakulam', 0),
(409, '19', 'Visakhapatnam', 0),
(410, '19', 'Vizianagaram', 0),
(411, '19', 'West Godavari', 0),
(412, '20', 'Bagalkot', 0),
(413, '20', 'Bangalore', 0),
(414, '20', 'Bangalore Rural', 0),
(415, '20', 'Belgaum', 0),
(416, '20', 'Bellary', 0),
(417, '20', 'Bidar', 0),
(418, '20', 'Bijapur', 0),
(419, '20', 'Chamarajanagar', 0),
(420, '20', 'Chickmagalur', 0),
(421, '20', 'Chikkaballapur', 0),
(422, '20', 'Chitradurga', 0),
(423, '20', 'Dakshina Kannada', 0),
(424, '20', 'Davangere', 0),
(425, '20', 'Dharwad', 0),
(426, '20', 'Gadag', 0),
(427, '20', 'Gulbarga', 0),
(428, '20', 'Hassan', 0),
(429, '20', 'Haveri', 0),
(430, '20', 'Kodagu', 0),
(431, '20', 'Kolar', 0),
(432, '20', 'Koppal', 0),
(433, '20', 'Mandya', 0),
(434, '20', 'Mysore', 0),
(435, '20', 'Raichur', 0),
(436, '20', 'Ramanagara', 0),
(437, '20', 'Shimoga', 0),
(438, '20', 'Tumkur', 0),
(439, '20', 'Udupi', 0),
(440, '20', 'Uttara Kannada', 0),
(441, '20', 'Yadgir', 0),
(442, '21', 'Alappuzha', 0),
(443, '21', 'Ernakulam', 0),
(444, '21', 'Idukki', 0),
(445, '21', 'Kannur', 0),
(446, '21', 'Kasaragod', 0),
(447, '21', 'Kollam', 0),
(448, '21', 'Kottayam', 0),
(449, '21', 'Kozhikode', 0),
(450, '21', 'Malappuram', 0),
(451, '21', 'Palakkad', 0),
(452, '21', 'Pathanamthitta', 0),
(453, '21', 'Thiruvananthapuram', 0),
(454, '21', 'Thrissur', 0),
(455, '21', 'Wayanad', 0),
(456, '22', 'Ariyalur', 0),
(457, '22', 'Chennai', 0),
(458, '22', 'Coimbatore', 0),
(459, '22', 'Cuddalore', 0),
(460, '22', 'Dharmapuri', 0),
(461, '22', 'Dindigul', 0),
(462, '22', 'Erode', 0),
(463, '22', 'Kanchipuram', 0),
(464, '22', 'Kanyakumari', 0),
(465, '22', 'Karur', 0),
(466, '22', 'Krishnagiri', 0),
(467, '22', 'Madurai', 0),
(468, '22', 'Nagapattinam', 0),
(469, '22', 'Namakkal', 0),
(470, '22', 'Nilgiris', 0),
(471, '22', 'Perambalur', 0),
(472, '22', 'Pudukkottai', 0),
(473, '22', 'Ramanathapuram', 0),
(474, '22', 'Salem', 0),
(475, '22', 'Sivaganga', 0),
(476, '22', 'Thanjavur', 0),
(477, '22', 'Theni', 0),
(478, '22', 'Thiruvallur', 0),
(479, '22', 'Thiruvarur', 0),
(480, '22', 'Thoothukudi', 0),
(481, '22', 'Tiruchirappalli', 0),
(482, '22', 'Tirunelveli', 0),
(483, '22', 'Tirupur', 0),
(484, '22', 'Tiruvannamalai', 0),
(485, '22', 'Vellore', 0),
(486, '22', 'Viluppuram', 0),
(487, '22', 'Virudhunagar', 0),
(488, '23', 'Adilabad', 0),
(489, '23', 'Bhadradri Kothagudem', 0),
(490, '23', 'Hyderabad', 0),
(491, '23', 'Jagtial', 0),
(492, '23', 'Jangaon', 0),
(493, '23', 'Jayashankar Bhupalapally', 0),
(494, '23', 'Jogulamba Gadwal', 0),
(495, '23', 'Kamareddy', 0),
(496, '23', 'Karimnagar', 0),
(497, '23', 'Khammam', 0),
(498, '23', 'Kumarambheem Asifabad', 0),
(499, '23', 'Mahabubabad', 0),
(500, '23', 'Mahabubnagar', 0),
(501, '23', 'Mancherial', 0),
(502, '23', 'Medak', 0),
(503, '23', 'Medchal?Malkajgiri', 0),
(504, '23', 'Nagarkurnool', 0),
(505, '23', 'Nalgonda', 0),
(506, '23', 'Nirmal', 0),
(507, '23', 'Nizamabad', 0),
(508, '23', 'Peddapalli', 0),
(509, '23', 'Rajanna Sircilla', 0),
(510, '23', 'Ranga Reddy', 0),
(511, '23', 'Sangareddy', 0),
(512, '23', 'Siddipet', 0),
(513, '23', 'Suryapet', 0),
(514, '23', 'Vikarabad', 0),
(515, '23', 'Wanaparthy', 0),
(516, '23', 'Warangal', 0),
(517, '23', 'Warangal Rural', 0),
(518, '23', 'Yadadri Bhuvanagiri', 0),
(519, '24', 'Nicobar', 0),
(520, '24', 'North and Middle Andaman', 0),
(521, '24', 'South Andaman', 0),
(522, '25', 'Lakshadweep', 0),
(523, '26', 'Karaikal', 0),
(524, '26', 'Mahe', 0),
(525, '26', 'Pondicherry', 0),
(526, '26', 'Yanam', 0),
(527, '27', 'Agar Malwa', 0),
(528, '27', 'Alirajpur', 0),
(529, '27', 'Anuppur', 0),
(530, '27', 'Ashoknagar', 0),
(531, '27', 'Balaghat', 0),
(532, '27', 'Barwani', 0),
(533, '27', 'Betul', 0),
(534, '27', 'Bhind', 0),
(535, '27', 'Bhopal', 0),
(536, '27', 'Burhanpur', 0),
(537, '27', 'Chhatarpur', 0),
(538, '27', 'Chhindwara', 0),
(539, '27', 'Damoh', 0),
(540, '27', 'Datia', 0),
(541, '27', 'Dewas', 0),
(542, '27', 'Dhar', 0),
(543, '27', 'Dindori', 0),
(544, '27', 'Guna', 0),
(545, '27', 'Gwalior', 0),
(546, '27', 'Harda', 0),
(547, '27', 'Hoshangabad', 0),
(548, '27', 'Indore', 0),
(549, '27', 'Jabalpur', 0),
(550, '27', 'Jhabua', 0),
(551, '27', 'Katni', 0),
(552, '27', 'Khandwa', 0),
(553, '27', 'Khargone', 0),
(554, '27', 'Mandla', 0),
(555, '27', 'Mandsaur', 0),
(556, '27', 'Morena', 0),
(557, '27', 'Narsinghpur', 0),
(558, '27', 'Neemuch', 0),
(559, '27', 'Panna', 0),
(560, '27', 'Raisen', 0),
(561, '27', 'Rajgarh', 0),
(562, '27', 'Ratlam', 0),
(563, '27', 'Rewa', 0),
(564, '27', 'Sagar', 0),
(565, '27', 'Satna', 0),
(566, '27', 'Sehore', 0),
(567, '27', 'Seoni', 0),
(568, '27', 'Shahdol', 0),
(569, '27', 'Shajapur', 0),
(570, '27', 'Sheopur', 0),
(571, '27', 'Shivpuri', 0),
(572, '27', 'Sidhi', 0),
(573, '27', 'Singrauli', 0),
(574, '27', 'Tikamgarh', 0),
(575, '27', 'Ujjain', 0),
(576, '27', 'Umaria', 0),
(577, '27', 'Vidisha', 0),
(578, '28', 'Balod', 0),
(579, '28', 'Baloda Bazar', 0),
(580, '28', 'Balrampur', 0),
(581, '28', 'Bemetara', 0),
(582, '28', 'Bijapur', 0),
(583, '28', 'Bilaspur', 0),
(584, '28', 'Dantewada', 0),
(585, '28', 'Dhamtari', 0),
(586, '28', 'Durg', 0),
(587, '28', 'Gariaband', 0),
(588, '28', 'Jagdalpur?(Madhya Bastar)', 0),
(589, '28', 'Janjgir-Champa', 0),
(590, '28', 'Jashpur', 0),
(591, '28', 'Kabirdham', 0),
(592, '28', 'Kanker', 0),
(593, '28', 'Kondagaon', 0),
(594, '28', 'Korba', 0),
(595, '28', 'Koriya', 0),
(596, '28', 'Mahasamund', 0),
(597, '28', 'Mungeli', 0),
(598, '28', 'Narayanpur', 0),
(599, '28', 'Raigarh', 0),
(600, '28', 'Raipur', 0),
(601, '28', 'Rajnandgaon', 0),
(602, '28', 'Sukma', 0),
(603, '28', 'Surajpur', 0),
(604, '28', 'Surguja', 0),
(605, '29', 'Baksa', 0),
(606, '29', 'Barpeta', 0),
(607, '29', 'Biswanath', 0),
(608, '29', 'Bongaigaon', 0),
(609, '29', 'Cachar', 0),
(610, '29', 'Charaideo', 0),
(611, '29', 'Chirang', 0),
(612, '29', 'Darrang', 0),
(613, '29', 'Dhemaji', 0),
(614, '29', 'Dhubri', 0),
(615, '29', 'Dibrugarh', 0),
(616, '29', 'Dima Hasao', 0),
(617, '29', 'Goalpara', 0),
(618, '29', 'Golaghat', 0),
(619, '29', 'Hailakandi', 0),
(620, '29', 'Hojai', 0),
(621, '29', 'Jorhat', 0),
(622, '29', 'Kamrup', 0),
(623, '29', 'Kamrup Metropolitan', 0),
(624, '29', 'Karbi Anglong', 0),
(625, '29', 'Karimganj', 0),
(626, '29', 'Kokrajhar', 0),
(627, '29', 'Lakhimpur', 0),
(628, '29', 'Majuli', 0),
(629, '29', 'Morigaon', 0),
(630, '29', 'Nagaon', 0),
(631, '29', 'Nalbari', 0),
(632, '29', 'Sivasagar', 0),
(633, '29', 'Sonitpur', 0),
(634, '29', 'South Salamara-Mankachar', 0),
(635, '29', 'Tinsukia', 0),
(636, '29', 'Udalguri', 0),
(637, '29', 'West Karbi Anglong', 0),
(638, '30', 'East Sikkim', 0),
(639, '30', 'North Sikkim', 0),
(640, '30', 'South Sikkim', 0),
(641, '30', 'West Sikkim', 0),
(642, '31', 'Dimapur', 0),
(643, '31', 'Kiphire', 0),
(644, '31', 'Kohima', 0),
(645, '31', 'Longleng', 0),
(646, '31', 'Mokokchung', 0),
(647, '31', 'Mon', 0),
(648, '31', 'Peren', 0),
(649, '31', 'Phek', 0),
(650, '31', 'Tuensang', 0),
(651, '31', 'Wokha', 0),
(652, '31', 'Zunheboto', 0),
(653, '32', 'East Garo Hills', 0),
(654, '32', 'East Jaintia Hills', 0),
(655, '32', 'East Khasi Hills', 0),
(656, '32', 'North Garo Hills', 0),
(657, '32', 'Ri Bhoi', 0),
(658, '32', 'South Garo Hills', 0),
(659, '32', 'South West Garo Hills', 0),
(660, '32', 'South West Khasi Hills', 0),
(661, '32', 'West Garo Hills', 0),
(662, '32', 'West Jaintia Hills', 0),
(663, '32', 'West Khasi Hills', 0),
(664, '33', 'Bishnupur', 0),
(665, '33', 'Chandel', 0),
(666, '33', 'Churachandpur', 0),
(667, '33', 'Imphal East', 0),
(668, '33', 'Imphal West', 0),
(669, '33', 'Jiribam', 0),
(670, '33', 'Kakching', 0),
(671, '33', 'Kamjong', 0),
(672, '33', 'Kangpokpi', 0),
(673, '33', 'Noney', 0),
(674, '33', 'Pherzawl', 0),
(675, '33', 'Senapati', 0),
(676, '33', 'Tamenglong', 0),
(677, '33', 'Tengnoupal', 0),
(678, '33', 'Thoubal', 0),
(679, '33', 'Ukhrul', 0),
(680, '34', 'Aizawl', 0),
(681, '34', 'Champhai', 0),
(682, '34', 'Kolasib', 0),
(683, '34', 'Lawngtlai', 0),
(684, '34', 'Lunglei', 0),
(685, '34', 'Mamit', 0),
(686, '34', 'Saiha', 0),
(687, '34', 'Serchhip', 0),
(688, '35', 'Dhalai', 0),
(689, '35', 'Gomati', 0),
(690, '35', 'Khowai', 0),
(691, '35', 'North Tripura', 0),
(692, '35', 'Sipahijala', 0),
(693, '35', 'South Tripura', 0),
(694, '35', 'Unakoti', 0),
(695, '35', 'West Tripura', 0),
(696, '36', 'Anjaw', 0),
(697, '36', 'Changlang', 0),
(698, '36', 'Dibang Valley', 0),
(699, '36', 'East Kameng', 0),
(700, '36', 'East Siang', 0),
(701, '36', 'Kra Daadi', 0),
(702, '36', 'Kurung Kumey', 0),
(703, '36', 'Lohit', 0),
(704, '36', 'Londing', 0),
(705, '36', 'Lower Dibang Valley', 0),
(706, '36', 'Lower Siang', 0),
(707, '36', 'Lower Subansiri', 0),
(708, '36', 'Namsai', 0),
(709, '36', 'Papum Pare', 0),
(710, '36', 'Siang', 0),
(711, '36', 'Tawang', 0),
(712, '36', 'Tirap', 0),
(713, '36', 'Upper Siang', 0),
(714, '36', 'Upper Subansiri', 0),
(715, '36', 'West Kameng', 0),
(716, '36', 'West Siang', 0);

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

--
-- Table structure for table `aic_states`
--

CREATE TABLE `aic_states` (
  `id` int(11) NOT NULL,
  `state_name` varchar(255) NOT NULL,
  `state_status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aic_states`
--

INSERT INTO `aic_states` (`id`, `state_name`, `state_status`) VALUES
(1, 'Jammu and Kashmir', 0),
(2, 'Himachal Pradesh', 0),
(3, 'Punjab', 0),
(4, 'Uttarakhand', 0),
(5, 'Uttar Pradesh', 0),
(6, 'Haryana', 0),
(7, 'Delhi-NCR', 0),
(8, 'Chandigarh', 0),
(9, 'Bihar', 0),
(10, 'Odisha', 0),
(11, 'Jharkhand', 0),
(12, 'West Bengal', 0),
(13, 'Rajasthan', 0),
(14, 'Gujarat', 0),
(15, 'Goa', 0),
(16, 'Maharashtra', 0),
(17, 'Dadra and Nagar Haveli', 0),
(18, 'Daman and Diu', 0),
(19, 'Andhra Pradesh', 0),
(20, 'Karnataka', 0),
(21, 'Kerala', 0),
(22, 'Tamil Nadu', 0),
(23, 'Telengana', 0),
(24, 'Andaman and Nicobar Islands', 0),
(25, 'Lakshadweep', 0),
(26, 'Puducherry', 0),
(27, 'Madhya Pradesh', 0),
(28, 'Chhattisgarh', 0),
(29, 'Assam', 0),
(30, 'Sikkim', 0),
(31, 'Nagaland', 0),
(32, 'Meghalaya', 0),
(33, 'Manipur', 0),
(34, 'Mizoram', 0),
(35, 'Tripura', 0),
(36, 'Arunachal Pradesh', 0);

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_awards_incubator`
--

CREATE TABLE `goals_awards_incubator` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_awards_startup`
--

CREATE TABLE `goals_awards_startup` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_events`
--

CREATE TABLE `goals_events` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `speakers` varchar(255) NOT NULL,
  `attendees` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_funding`
--

CREATE TABLE `goals_funding` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `investor` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `comments` varchar(255) NOT NULL,
  `sdate` date NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_ipgenerated`
--

CREATE TABLE `goals_ipgenerated` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `publish_date` date NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_labs`
--

CREATE TABLE `goals_labs` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goals_labs`
--

INSERT INTO `goals_labs` (`id`, `refid`, `name`, `description`, `area`, `file_name`, `dated`) VALUES
(1, 1, 'Test Lab 1', 'test desc', '200', '1559817500_ir.png', '2019-06-04');

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

--
-- Table structure for table `goals_media`
--

CREATE TABLE `goals_media` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `dated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `file_name` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_mentors`
--

CREATE TABLE `goals_mentors` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `profile` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `expert` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goals_mentors`
--

INSERT INTO `goals_mentors` (`id`, `refid`, `name`, `email`, `mobile`, `profile`, `linkedin`, `expert`, `file_name`, `dated`) VALUES
(1, 1, 'Dhruv Sharma', 'dhruvsharma1904@gmail.com', '9650066026', 'senior web developer', 'asdasd\'a\'sd\'as\'dasd', 'asdasd\'as\'d\'as', '1559818473_ir.png', '2019-06-04');

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

--
-- Table structure for table `goals_nextround`
--

CREATE TABLE `goals_nextround` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `revenue` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `employees` varchar(255) NOT NULL,
  `funding_date` date NOT NULL,
  `funding` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_partners`
--

CREATE TABLE `goals_partners` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `goals_partners`
--

INSERT INTO `goals_partners` (`id`, `refid`, `name`, `type`, `description`, `website`, `dated`) VALUES
(1, 1, 'rajat', 'women_and_child_development', 'asda\'sd\'as\';as\'d;\'asd;\'a;sd\';asd\';a;d\'as;d\'sd', 'asdasdasd', '2019-06-02');

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

--
-- Table structure for table `goals_partnersacad`
--

CREATE TABLE `goals_partnersacad` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `dated` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_seedfunding`
--

CREATE TABLE `goals_seedfunding` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `proof` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `employees` varchar(255) NOT NULL,
  `budget` text NOT NULL,
  `proof_details` text NOT NULL,
  `funding_date` date NOT NULL,
  `funding` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_startups`
--

CREATE TABLE `goals_startups` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `founders` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `jobs_created` varchar(255) NOT NULL,
  `womenled` varchar(255) NOT NULL,
  `women_emp` varchar(255) NOT NULL,
  `patents_detail` varchar(255) NOT NULL,
  `aimgrant` varchar(255) NOT NULL,
  `othgrant` varchar(255) NOT NULL,
  `reg_date` date NOT NULL,
  `inc_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `goals_training`
--

CREATE TABLE `goals_training` (
  `id` bigint(20) NOT NULL,
  `refid` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `speakers` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `attendees` varchar(255) NOT NULL,
  `file_name` text NOT NULL,
  `sdate` date NOT NULL,
  `edate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ictee_data`
--

CREATE TABLE `ictee_data` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `logos` varchar(250) DEFAULT NULL,
  `startup` varchar(255) DEFAULT NULL,
  `locationic` varchar(255) DEFAULT NULL,
  `addressic` varchar(255) DEFAULT NULL,
  `pinic` varchar(6) DEFAULT NULL,
  `customers` text,
  `support_type` varchar(255) DEFAULT NULL,
  `name` text,
  `designation` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `email_id` text,
  `mobileno` text,
  `jobscount` varchar(255) DEFAULT NULL,
  `startupdesc` text,
  `raisefund` varchar(255) DEFAULT NULL,
  `eng_model` text,
  `sector_focus` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `links` varchar(255) DEFAULT NULL,
  `govscheme` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dated` date DEFAULT NULL,
  `legalname` varchar(250) DEFAULT NULL,
  `registration_no` varchar(250) DEFAULT NULL,
  `womenlead` varchar(100) DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ictee_data`
--

INSERT INTO `ictee_data` (`id`, `refid`, `logos`, `startup`, `locationic`, `addressic`, `pinic`, `customers`, `support_type`, `name`, `designation`, `email_id`, `mobileno`, `jobscount`, `startupdesc`, `raisefund`, `eng_model`, `sector_focus`, `links`, `govscheme`, `dated`, `legalname`, `registration_no`, `womenlead`, `status`) VALUES
(1, 1, NULL, 'Dhruv Sharma', NULL, NULL, NULL, NULL, 'physical', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Agriculture and Allied Fields', NULL, NULL, NULL, NULL, NULL, '1', NULL);

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

--
-- Table structure for table `ictor_data`
--

CREATE TABLE `ictor_data` (
  `id` int(11) NOT NULL,
  `eic` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_no` varchar(155) DEFAULT NULL,
  `logos` varchar(250) DEFAULT NULL,
  `ceoname` varchar(255) DEFAULT NULL,
  `locationic` varchar(255) DEFAULT NULL,
  `addressic` varchar(255) DEFAULT NULL,
  `pinic` varchar(6) DEFAULT NULL,
  `areaic` varchar(255) DEFAULT NULL,
  `usedareaic` varchar(255) DEFAULT NULL,
  `name` text,
  `designation` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `email_id` text,
  `mobileno` text,
  `emptype` text,
  `boardmember` text,
  `existmember` text,
  `aimspoc` text,
  `sanctionamt` decimal(10,0) DEFAULT NULL,
  `dispersedamt` decimal(10,0) DEFAULT NULL,
  `agncname` text,
  `grantamt` text,
  `grantpurp` varchar(255) DEFAULT NULL,
  `grantrcdt` text,
  `grantlstdt` text,
  `sector_focus` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `links` varchar(255) DEFAULT NULL,
  `other` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `unique_id` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tagline` varchar(250) DEFAULT NULL,
  `name_eic` varchar(250) DEFAULT NULL,
  `registration_no` varchar(250) DEFAULT NULL,
  `type_of_entity` varchar(100) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `ceoprofile` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ictor_data`
--

INSERT INTO `ictor_data` (`id`, `eic`, `phone_no`, `logos`, `ceoname`, `locationic`, `addressic`, `pinic`, `areaic`, `usedareaic`, `name`, `designation`, `email_id`, `mobileno`, `emptype`, `boardmember`, `existmember`, `aimspoc`, `sanctionamt`, `dispersedamt`, `agncname`, `grantamt`, `grantpurp`, `grantrcdt`, `grantlstdt`, `sector_focus`, `links`, `other`, `unique_id`, `date`, `tagline`, `name_eic`, `registration_no`, `type_of_entity`, `created`, `modified`, `status`, `ceoprofile`) VALUES
(1, 'Ramneek\'s Incubation centre', '9650066026', '1559817434_lockheed.jpg', '', '7,177', 'New Multan Nagar, Paschim Vihar', '110056', '500', '70', 'a:2:{i:0;s:12:\"Dhruv Sharma\";i:1;s:11:\"Rajat Kumar\";}', 'a:2:{i:0;s:3:\"CEO\";i:1;s:13:\"Web Developer\";}', 'a:2:{i:0;s:25:\"dhruvsharma1904@gmail.com\";i:1;s:17:\"rajat@avianwe.com\";}', 'a:2:{i:0;s:10:\"9650066026\";i:1;s:10:\"9650066026\";}', 'a:2:{i:0;s:0:\"\";i:1;s:9:\"Full Time\";}', 'a:2:{i:0;s:16:\"www.linkedin.com\";i:1;s:0:\"\";}', 'a:2:{i:0;s:7:\"twt.com\";i:1;s:3:\"Yes\";}', 'a:2:{i:0;s:0:\"\";i:1;s:3:\"Yes\";}', '100000', NULL, 'a:1:{i:0;s:8:\"Avian We\";}', 'a:1:{i:0;s:5:\"10000\";}', 'a:1:{i:0;s:7:\"startup\";}', 'a:1:{i:0;s:10:\"2019-05-02\";}', 'a:1:{i:0;s:10:\"2019-05-03\";}', 'a:4:{i:0;s:29:\"Agriculture and Allied Fields\";i:1;s:14:\"Bio Technology\";i:2;s:42:\"Building Materials/Construction Technology\";i:3;s:70:\"Electricity, New and Renewable Energy and Environmental sustainability\";}', 'a:3:{i:0;s:8:\"expd.pro\";i:1;s:17:\"http://www.fb.com\";i:2;s:17:\"http://www.fb.com\";}', '                ', '', '2019-05-01', 'This is a test account', 'RIC', '28hsn73c8', 'Partnership', '2019-06-06 00:00:00', '2019-06-06 00:00:00', '1', '1559817434_incubator_target_achieved_fundedstartup.csv');

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

--
-- Table structure for table `ictor_exp`
--

CREATE TABLE `ictor_exp` (
  `id` int(11) NOT NULL,
  `sr` int(11) NOT NULL,
  `refid` int(11) NOT NULL,
  `othrfund` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ictor_expen`
--

CREATE TABLE `ictor_expen` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `sr` varchar(255) DEFAULT NULL,
  `expen_val` text,
  `dated` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ictor_tranche`
--

CREATE TABLE `ictor_tranche` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `sr` varchar(255) DEFAULT NULL,
  `tranche_detail` text,
  `tranche_val` text,
  `other_sources` text,
  `other_sources_val` text,
  `dated` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ictor_tranche_other`
--

CREATE TABLE `ictor_tranche_other` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `other_sources` text,
  `other_sources_val` text,
  `dated` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ic_fac_infra`
--

CREATE TABLE `ic_fac_infra` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `office_facilities` text,
  `rooms_count` text,
  `rooms_capacity` text,
  `equipments_list` text,
  `created` varchar(100) DEFAULT NULL,
  `modified` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_fac_infra`
--

INSERT INTO `ic_fac_infra` (`id`, `refid`, `office_facilities`, `rooms_count`, `rooms_capacity`, `equipments_list`, `created`, `modified`) VALUES
(1, 0, 'a:4:{i:0;s:18:\"Video conferencing\";i:1;s:13:\"Seminar Halls\";i:2;s:13:\"Meeting Rooms\";i:3;s:20:\"Sector Specific Labs\";}', 'a:4:{i:0;s:2:\"10\";i:1;s:2:\"12\";i:2;s:2:\"43\";i:3;s:1:\"6\";}', 'a:4:{i:0;s:1:\"3\";i:1;s:1:\"5\";i:2;s:1:\"5\";i:3;s:1:\"4\";}', 'a:4:{i:0;s:1:\"3\";i:1;s:1:\"6\";i:2;s:2:\"15\";i:3;s:2:\"20\";}', '2019-06-06', '2019-06-06'),
(2, 1, 'a:4:{i:0;s:18:\"Video conferencing\";i:1;s:13:\"Seminar Halls\";i:2;s:13:\"Meeting Rooms\";i:3;s:20:\"Sector Specific Labs\";}', 'a:4:{i:0;s:1:\"6\";i:1;s:2:\"23\";i:2;s:2:\"10\";i:3;s:1:\"5\";}', 'a:4:{i:0;s:1:\"5\";i:1;s:1:\"6\";i:2;s:1:\"7\";i:3;s:2:\"32\";}', 'a:4:{i:0;s:1:\"4\";i:1;s:1:\"5\";i:2;s:1:\"6\";i:3;s:1:\"6\";}', '2019-06-06', '2019-06-06');

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

--
-- Table structure for table `income_table`
--

CREATE TABLE `income_table` (
  `incm_id` int(11) NOT NULL,
  `incm_refid` int(55) NOT NULL,
  `incm_year` varchar(155) NOT NULL,
  `incm_quater` varchar(155) NOT NULL,
  `rent_amout1` int(55) NOT NULL DEFAULT '0',
  `rent_amout2` int(55) NOT NULL DEFAULT '0',
  `rent_amout3` int(55) NOT NULL DEFAULT '0',
  `rent_total` int(55) NOT NULL DEFAULT '0',
  `return_amout1` int(55) NOT NULL DEFAULT '0',
  `return_amout2` int(55) NOT NULL DEFAULT '0',
  `return_amout3` int(55) NOT NULL DEFAULT '0',
  `return_total` int(55) NOT NULL DEFAULT '0',
  `consult_amount1` int(55) NOT NULL DEFAULT '0',
  `consult_amount2` int(55) NOT NULL DEFAULT '0',
  `consult_amount3` int(55) NOT NULL DEFAULT '0',
  `consult_total` int(55) NOT NULL DEFAULT '0',
  `train_amount1` int(55) NOT NULL DEFAULT '0',
  `train_amount2` int(55) NOT NULL DEFAULT '0',
  `train_amount3` int(55) NOT NULL DEFAULT '0',
  `train_total` int(55) NOT NULL DEFAULT '0',
  `incext_amount1` int(55) NOT NULL DEFAULT '0',
  `incext_amount2` int(55) NOT NULL DEFAULT '0',
  `incext_amount3` int(55) NOT NULL DEFAULT '0',
  `incext_total` int(55) NOT NULL DEFAULT '0',
  `csrfund_amount1` int(55) NOT NULL DEFAULT '0',
  `csrfund_amount2` int(55) NOT NULL DEFAULT '0',
  `csrfund_amount3` int(55) NOT NULL DEFAULT '0',
  `csrfund_total` int(55) NOT NULL DEFAULT '0',
  `incm_amount1` int(55) NOT NULL DEFAULT '0',
  `incm_amount2` int(55) NOT NULL DEFAULT '0',
  `incm_amount3` int(55) NOT NULL DEFAULT '0',
  `incm_amount` text NOT NULL,
  `incm_total` int(55) NOT NULL DEFAULT '0',
  `govt_amount1` int(55) NOT NULL DEFAULT '0',
  `govt_amount2` int(55) NOT NULL DEFAULT '0',
  `govt_amount3` int(55) NOT NULL DEFAULT '0',
  `govt_amount` text NOT NULL,
  `govt_total` int(55) NOT NULL DEFAULT '0',
  `total1` int(55) NOT NULL DEFAULT '0',
  `total2` int(55) NOT NULL DEFAULT '0',
  `total3` int(55) NOT NULL DEFAULT '0',
  `total` int(55) NOT NULL DEFAULT '0',
  `buss_inc1` int(55) NOT NULL,
  `buss_inc2` int(11) NOT NULL,
  `buss_inc3` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `incubatee_founder_details`
--

CREATE TABLE `incubatee_founder_details` (
  `id` int(11) NOT NULL,
  `incubatee_founder_id` int(11) NOT NULL,
  `incubatee_founder__full_name` varchar(250) NOT NULL,
  `incubatee_founder__full_desc` text NOT NULL,
  `incubatee_founder__part_name` varchar(250) NOT NULL,
  `incubatee_founder__part_desc` text NOT NULL,
  `incubatee_founder__no_name` varchar(250) NOT NULL,
  `incubatee_founder__no_desc` text NOT NULL,
  `incubatee_founder__prior` varchar(250) NOT NULL,
  `incubatee_founder__prior_desc` text NOT NULL,
  `incubatee_founder__income` varchar(250) NOT NULL,
  `incubatee_founder__income_desc` text NOT NULL,
  `incubatee_founder__service` varchar(250) NOT NULL,
  `incubatee_founder__service_desc` text NOT NULL,
  `incubatee_founder__revenue` varchar(250) NOT NULL,
  `incubatee_founder__revenue_desc` text NOT NULL,
  `incubatee_founder__revenue_rs` varchar(250) DEFAULT NULL,
  `incubatee_founder__revenue_des_rs` text,
  `created` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubatee_information`
--

CREATE TABLE `incubatee_information` (
  `id` int(11) NOT NULL,
  `incubatee_d_id` int(11) NOT NULL,
  `incubatee_d_name` varchar(250) DEFAULT NULL,
  `incubatee_d_program` varchar(250) NOT NULL,
  `logos` varchar(250) DEFAULT NULL,
  `incubatee_sector` varchar(100) DEFAULT NULL,
  `incubatee_d_date` varchar(100) NOT NULL,
  `incubatee_d_status_at_the_time_of_affiliation` varchar(100) NOT NULL,
  `incubatee_d_legal_form` varchar(100) NOT NULL,
  `incubatee_d_line_description_of_the_incubatee` varchar(100) NOT NULL,
  `incubatee_d_funded` varchar(100) NOT NULL,
  `incubatee_d_seed_funded` varchar(100) NOT NULL,
  `incubatee_d_series_a` varchar(100) NOT NULL,
  `incubatee_d_series_b` varchar(100) NOT NULL,
  `incubatee_d_series_c` varchar(100) NOT NULL,
  `incubatee_d_series_d` varchar(100) NOT NULL,
  `incubatee_d_debt` varchar(100) NOT NULL,
  `incubatee_d_equity` varchar(100) NOT NULL,
  `incubatee_d_grant_philanthropy` varchar(100) NOT NULL,
  `incubatee_d_bank` varchar(100) NOT NULL,
  `incubatee_d_bank_amount` varchar(100) NOT NULL,
  `incubatee_d_angel` varchar(100) NOT NULL,
  `incubatee_d_angel_amount` varchar(100) NOT NULL,
  `incubatee_d_vc` varchar(100) NOT NULL,
  `incubatee_d_vc_amount` varchar(100) NOT NULL,
  `incubatee_d_gol` varchar(100) NOT NULL,
  `incubatee_d_gol_amount` varchar(100) NOT NULL,
  `incubatee_d_accelerator` varchar(100) NOT NULL,
  `incubatee_d_accelerator_amount` varchar(100) NOT NULL,
  `incubatee_d_crowd_fund` varchar(100) NOT NULL,
  `incubatee_d_crowd_amount` varchar(100) NOT NULL,
  `incubatee_d_family` varchar(100) NOT NULL,
  `incubatee_d_family_amount` varchar(100) NOT NULL,
  `incubatee_d_employees` varchar(100) NOT NULL,
  `incubatee_d_employees_amount` varchar(100) NOT NULL,
  `incubatee_d_type_of_kind` varchar(100) NOT NULL,
  `incubatee_d_value` varchar(100) NOT NULL,
  `incubatee_d_type_of_support` varchar(100) NOT NULL,
  `incubatee_d_enagement_model_with_incubator` varchar(100) NOT NULL,
  `incubatee_d_operate_model` varchar(100) DEFAULT NULL,
  `incubatee_d_target_market` varchar(100) NOT NULL,
  `incubatee_d_incubate_ass` varchar(100) DEFAULT NULL,
  `incubatee_d_incubatee_dependent` varchar(100) NOT NULL,
  `incubatee_d_social_environment` varchar(100) NOT NULL,
  `incubatee_d_explain_the_impact` varchar(100) NOT NULL,
  `incubatee_d_beneficiaries` varchar(100) NOT NULL,
  `incubatee_d_number_of_Mentor` varchar(100) NOT NULL,
  `created` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubatee_ip`
--

CREATE TABLE `incubatee_ip` (
  `id` int(11) NOT NULL,
  `incubatee_ip_id` int(11) DEFAULT NULL,
  `incubatee_ip_reg_no` varchar(250) NOT NULL,
  `incubatee_ip_type` varchar(250) NOT NULL,
  `incubatee_ip_status` varchar(250) NOT NULL,
  `created` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubator_financial_chart`
--

CREATE TABLE `incubator_financial_chart` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `capital_amout1` int(11) DEFAULT NULL,
  `capital_amout2` int(11) DEFAULT NULL,
  `capital_amout3` int(11) DEFAULT NULL,
  `capital_total` int(11) DEFAULT NULL,
  `c_percent` float DEFAULT NULL,
  `expan_amout1` int(11) DEFAULT NULL,
  `expan_amout2` int(11) DEFAULT NULL,
  `expan_amout3` int(11) DEFAULT NULL,
  `expan_total` int(11) DEFAULT NULL,
  `e_percent` float DEFAULT NULL,
  `renovat_amount1` int(11) DEFAULT NULL,
  `renovat_amount2` int(11) DEFAULT NULL,
  `renovat_amount3` int(11) DEFAULT NULL,
  `renovat_total` int(11) DEFAULT NULL,
  `r_percent` float DEFAULT NULL,
  `tech_amount1` int(11) DEFAULT NULL,
  `tech_amount2` int(11) DEFAULT NULL,
  `tech_amount3` int(11) DEFAULT NULL,
  `tech_total` int(11) DEFAULT NULL,
  `t_percent` float DEFAULT NULL,
  `incub_amount1` int(11) DEFAULT NULL,
  `incub_amount2` int(11) DEFAULT NULL,
  `incub_amount3` int(11) DEFAULT NULL,
  `Incub_total` int(11) DEFAULT NULL,
  `i_percent` float DEFAULT NULL,
  `person_amount1` int(11) DEFAULT NULL,
  `person_amount2` int(11) DEFAULT NULL,
  `person_amount3` int(11) DEFAULT NULL,
  `person_total` int(11) DEFAULT NULL,
  `p_percent` float DEFAULT NULL,
  `seed_amount1` int(11) DEFAULT NULL,
  `seed_amount2` int(11) DEFAULT NULL,
  `seed_amount3` int(11) DEFAULT NULL,
  `seed_total` int(11) DEFAULT NULL,
  `s_percent` float DEFAULT NULL,
  `total_a` int(11) DEFAULT NULL,
  `manpower_and_staff_1` int(11) DEFAULT NULL,
  `manpower_and_staff_2` int(11) DEFAULT NULL,
  `manpower_and_staff_3` int(11) DEFAULT NULL,
  `manpower_and_staff_4` int(11) DEFAULT NULL,
  `manpower_and_staff_5` int(11) DEFAULT NULL,
  `utility_and_maint_1` int(11) DEFAULT NULL,
  `utility_and_maint_2` int(11) DEFAULT NULL,
  `utility_and_maint_3` int(11) DEFAULT NULL,
  `utility_and_maint_4` int(11) DEFAULT NULL,
  `utility_and_maint_5` int(11) DEFAULT NULL,
  `work_seminars_1` int(11) DEFAULT NULL,
  `work_seminars_2` int(11) DEFAULT NULL,
  `work_seminars_3` int(11) DEFAULT NULL,
  `work_seminars_4` int(11) DEFAULT NULL,
  `work_seminars_5` int(11) DEFAULT NULL,
  `consul_train_1` int(11) DEFAULT NULL,
  `consul_train_2` int(11) DEFAULT NULL,
  `consul_train_3` int(11) DEFAULT NULL,
  `consul_train_4` int(11) DEFAULT NULL,
  `consul_train_5` int(11) DEFAULT NULL,
  `lincensing_1` int(11) DEFAULT NULL,
  `lincensing_2` int(11) DEFAULT NULL,
  `lincensing_3` int(11) DEFAULT NULL,
  `lincensing_4` int(11) DEFAULT NULL,
  `lincensing_5` int(11) DEFAULT NULL,
  `miscell_expens_1` int(11) DEFAULT NULL,
  `miscell_expens_2` int(11) DEFAULT NULL,
  `miscell_expens_3` int(11) DEFAULT NULL,
  `miscell_expens_4` int(11) DEFAULT NULL,
  `miscell_expens_5` int(11) DEFAULT NULL,
  `total_b` int(11) DEFAULT NULL,
  `total_cost` int(11) DEFAULT NULL,
  `seed_supprt` int(11) DEFAULT NULL,
  `grant_aim` int(11) DEFAULT NULL,
  `state_gov` int(11) DEFAULT NULL,
  `donors_cont` int(11) DEFAULT NULL,
  `other_income` int(11) DEFAULT NULL,
  `bank_interest` int(11) DEFAULT NULL,
  `total_income_c` int(11) DEFAULT NULL,
  `total_sanction` int(11) NOT NULL,
  `amount_dispersed` int(11) NOT NULL,
  `generated_fees` text,
  `generated_programs` text,
  `capital_amount` int(11) DEFAULT NULL,
  `capital_percent` float DEFAULT NULL,
  `incubator_amount` int(11) DEFAULT NULL,
  `incubator_percent` float DEFAULT NULL,
  `personnel_amount` int(11) DEFAULT NULL,
  `personnel_percent` float DEFAULT NULL,
  `seed_amount` int(11) DEFAULT NULL,
  `seed_percent` float DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubator_information`
--

CREATE TABLE `incubator_information` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `info_year` varchar(11) DEFAULT NULL,
  `info_quarter` varchar(11) DEFAULT NULL,
  `values_no_pre_incubatees` varchar(100) DEFAULT NULL,
  `values_no_virtually` varchar(100) DEFAULT NULL,
  `values_no_physically` varchar(100) DEFAULT NULL,
  `values_no_incubatee_funded` varchar(100) DEFAULT NULL,
  `values_no_incubatee_acquired` varchar(100) DEFAULT NULL,
  `values_no_graduated` varchar(100) DEFAULT NULL,
  `values_no_incubatee_operation` varchar(100) DEFAULT NULL,
  `values_no_incubatee_models` varchar(100) DEFAULT NULL,
  `no_seats_available` varchar(100) DEFAULT NULL,
  `fund_rais_portfolio` varchar(100) DEFAULT NULL,
  `no_tech_patent` varchar(100) DEFAULT NULL,
  `no_job_created` varchar(100) DEFAULT NULL,
  `full_time_tech` varchar(100) DEFAULT NULL,
  `no_supported_incubate` varchar(100) DEFAULT NULL,
  `no_award_received` varchar(100) DEFAULT NULL,
  `no_award_received_incubate` varchar(100) DEFAULT NULL,
  `lab_facilities` varchar(100) DEFAULT NULL,
  `collaborator_no_mentor` varchar(100) DEFAULT NULL,
  `collaborator_no_academic` varchar(100) DEFAULT NULL,
  `collaborator_no_corporate` varchar(100) DEFAULT NULL,
  `collaborator_no_invstors` varchar(100) DEFAULT NULL,
  `event_no_accelertor` varchar(100) DEFAULT NULL,
  `event_no_outreach` varchar(100) DEFAULT NULL,
  `event_no_training` varchar(100) DEFAULT NULL,
  `name_of_event` varchar(100) DEFAULT NULL,
  `date_of_event` varchar(100) DEFAULT NULL,
  `audience_figures` varchar(100) DEFAULT NULL,
  `description_of_the_event` varchar(100) DEFAULT NULL,
  `place_of_the_event` varchar(100) DEFAULT NULL,
  `no_ip_filed` varchar(100) DEFAULT NULL,
  `no_ip_granted` varchar(100) DEFAULT NULL,
  `articles_publish` varchar(100) DEFAULT NULL,
  `papers_publish` varchar(100) DEFAULT NULL,
  `ip_details` varchar(100) DEFAULT NULL,
  `name_of_ip` varchar(100) DEFAULT NULL,
  `registration_number` varchar(100) DEFAULT NULL,
  `ip_date_of_registration` varchar(100) DEFAULT NULL,
  `brief_description` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `awards_recevied` varchar(100) DEFAULT NULL,
  `name_of_award` varchar(100) DEFAULT NULL,
  `date_of_award` varchar(100) DEFAULT NULL,
  `description_of_award` varchar(100) DEFAULT NULL,
  `created` varchar(250) DEFAULT NULL,
  `modified` varchar(250) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubator_seed_fund`
--

CREATE TABLE `incubator_seed_fund` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `dst_amount` int(11) DEFAULT NULL,
  `dst_sanctioned` int(11) DEFAULT NULL,
  `dst_disbursed` int(11) DEFAULT NULL,
  `aim_amount1` int(11) DEFAULT NULL,
  `aim_amount2` int(11) DEFAULT NULL,
  `aim_sanctioned` int(11) DEFAULT NULL,
  `aim_disbursed` int(11) DEFAULT NULL,
  `dbt_amount` int(11) DEFAULT NULL,
  `dbt_sanctioned` int(11) DEFAULT NULL,
  `dbt_disbursed` int(11) DEFAULT NULL,
  `any_amount` int(11) DEFAULT NULL,
  `any_sanctioned` int(11) DEFAULT NULL,
  `any_disbursed` int(11) DEFAULT NULL,
  `total_seed` int(11) DEFAULT NULL,
  `total_seed_fund` int(11) DEFAULT NULL,
  `no_of_incu_app` int(11) DEFAULT NULL,
  `no_of_app_pres` int(11) DEFAULT NULL,
  `no_of_incu_fund` int(11) DEFAULT NULL,
  `no_of_incu_disbur` int(11) DEFAULT NULL,
  `seed_name` text,
  `seed_education` text,
  `seed_board_member` text,
  `created` varchar(100) DEFAULT NULL,
  `modified` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubator_target`
--

CREATE TABLE `incubator_target` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `ryear` varchar(20) DEFAULT NULL,
  `quarter` varchar(20) DEFAULT NULL,
  `seats` varchar(111) DEFAULT NULL,
  `labs` varchar(11) DEFAULT NULL,
  `team` varchar(255) DEFAULT NULL,
  `mentors` varchar(255) DEFAULT NULL,
  `partners` varchar(255) NOT NULL,
  `msme` int(255) NOT NULL DEFAULT '0',
  `startupphy` varchar(255) DEFAULT NULL,
  `startupvir` varchar(255) DEFAULT NULL,
  `womenlead` varchar(255) DEFAULT NULL,
  `events` varchar(255) DEFAULT NULL,
  `training` varchar(255) DEFAULT NULL,
  `accprgm` int(255) NOT NULL DEFAULT '0',
  `startup` int(255) NOT NULL DEFAULT '0',
  `fundedstartup` varchar(255) DEFAULT NULL,
  `seedfunded` varchar(255) DEFAULT NULL,
  `jobs` varchar(255) DEFAULT NULL,
  `startup_wemp` varchar(255) DEFAULT NULL,
  `ip_generated` varchar(255) DEFAULT NULL,
  `created` varchar(11) DEFAULT NULL,
  `modified` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `incubator_target_achieved`
--

CREATE TABLE `incubator_target_achieved` (
  `id` int(11) NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `ryear` varchar(20) DEFAULT NULL,
  `quarter` varchar(20) DEFAULT NULL,
  `rmonth` varchar(22) NOT NULL,
  `seats` int(11) DEFAULT NULL,
  `labs` varchar(11) DEFAULT NULL,
  `team` float DEFAULT NULL,
  `mentors` int(11) DEFAULT NULL,
  `partners` int(11) NOT NULL,
  `startupphy` int(11) DEFAULT NULL,
  `msme` int(255) NOT NULL DEFAULT '0',
  `startupvir` int(11) DEFAULT NULL,
  `womenlead` int(11) NOT NULL,
  `events` int(11) DEFAULT NULL,
  `training` int(11) DEFAULT NULL,
  `startup` int(255) NOT NULL DEFAULT '0',
  `accprgm` int(255) NOT NULL DEFAULT '0',
  `fundedstartup` int(11) DEFAULT NULL,
  `seedfunded` int(11) DEFAULT NULL,
  `jobs` int(11) DEFAULT NULL,
  `startup_wemp` int(11) DEFAULT NULL,
  `taxes` float DEFAULT NULL,
  `award_tor` int(11) DEFAULT NULL,
  `award_tee` int(11) DEFAULT NULL,
  `ip_generated` int(11) DEFAULT NULL,
  `created` varchar(11) DEFAULT NULL,
  `modified` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `incubator_target_achieved`
--

INSERT INTO `incubator_target_achieved` (`id`, `refid`, `ryear`, `quarter`, `rmonth`, `seats`, `labs`, `team`, `mentors`, `partners`, `startupphy`, `msme`, `startupvir`, `womenlead`, `events`, `training`, `startup`, `accprgm`, `fundedstartup`, `seedfunded`, `jobs`, `startup_wemp`, `taxes`, `award_tor`, `award_tee`, `ip_generated`, `created`, `modified`) VALUES
(1, 1, '2019', 't2', 'Apr', 0, '0', NULL, 0, 0, 1, 0, NULL, 0, 0, 0, 0, 0, 4, 0, 10, 0, 0, 0, 0, 4, NULL, NULL),
(2, 1, '2019', 't2', 'May', 0, '0', NULL, 0, 0, 1, 0, NULL, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, NULL, NULL),
(3, 1, '2019', 't2', 'Jun', 0, '0', NULL, 0, 0, 1, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, NULL, NULL);

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

--
-- Table structure for table `incubator_team_details`
--

CREATE TABLE `incubator_team_details` (
  `id` int(11) NOT NULL,
  `team_u_id` int(11) DEFAULT NULL,
  `team_member_name` varchar(250) DEFAULT NULL,
  `team_designation` varchar(250) DEFAULT NULL,
  `team_role` varchar(250) DEFAULT NULL,
  `team_email` varchar(250) DEFAULT NULL,
  `team_mob` varchar(250) DEFAULT NULL,
  `team_education` varchar(250) DEFAULT NULL,
  `type_of_employee` varchar(250) DEFAULT NULL,
  `team_gender` varchar(250) DEFAULT NULL,
  `team_board_member` varchar(250) DEFAULT NULL,
  `team_existing_member` varchar(250) DEFAULT NULL,
  `created` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incubtee_team_details`
--

CREATE TABLE `incubtee_team_details` (
  `id` int(11) NOT NULL,
  `incubatee_id` int(11) DEFAULT NULL,
  `incubatee_team_member_name` varchar(250) DEFAULT NULL,
  `incubatee_team_role` varchar(250) DEFAULT NULL,
  `incubatee_team_email` varchar(250) DEFAULT NULL,
  `incubatee_team_Cont` varchar(250) DEFAULT NULL,
  `incubatee_team_high_qualification` varchar(250) DEFAULT NULL,
  `incubatee_type_of_employee` varchar(250) DEFAULT NULL,
  `incubatee_team_gender` varchar(250) DEFAULT NULL,
  `incubatee_team_board_member` varchar(250) DEFAULT NULL,
  `incubatee_team_age` varchar(250) DEFAULT NULL,
  `created` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incu_event`
--

CREATE TABLE `incu_event` (
  `id` int(11) NOT NULL,
  `refid` int(11) NOT NULL,
  `event_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `event_date` date NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `event_links` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `brochure` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `income_table`
--
ALTER TABLE `income_table`
  ADD PRIMARY KEY (`incm_id`);

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `goals_labs`
--
ALTER TABLE `goals_labs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `goals_mentors`
--
ALTER TABLE `goals_mentors`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `goals_partners`
--
ALTER TABLE `goals_partners`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `income_table`
--
ALTER TABLE `income_table`
  MODIFY `incm_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

