-- Table structure for table `receipt_number_total`
--

CREATE TABLE IF NOT EXISTS `receipt_number_total` (
  `rnt_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rnt_number` varchar(45) NOT NULL,
  `rnt_total` varchar(45) NOT NULL,
  `rnt_chq_number` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) NOT NULL,
  `particulars` varchar(45) NOT NULL,
  PRIMARY KEY (`rnt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_sub_head`
--

CREATE TABLE IF NOT EXISTS `receipt_sub_head` (
  `receipt_sub_head_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_head` varchar(45) DEFAULT NULL,
  `receipt_sub_head` varchar(45) DEFAULT NULL,
  `sub_head_amount` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `sub_head_no` varchar(45) DEFAULT NULL,
  `receipt_head_total` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_sub_head_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_title`
--

CREATE TABLE IF NOT EXISTS `receipt_title` (
  `receipt_title_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_title` varchar(100) NOT NULL,
  `receipt_head_name` varchar(200) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `receipt_title_total` varchar(45) DEFAULT NULL,
  `counter_name` varchar(100) DEFAULT NULL,
  `academic_year` varchar(100) DEFAULT NULL,
  `sequence_no_of_head` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `receipt_title_head`
--

CREATE TABLE IF NOT EXISTS `receipt_title_head` (
  `receipt_title_head_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_title` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_title_head_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_type`
--

CREATE TABLE IF NOT EXISTS `receipt_type` (
  `receipt_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `receipt_type_name` varchar(100) NOT NULL,
  `budget_percent` varchar(10) DEFAULT NULL,
  `particular_exp` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`receipt_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_type`
--

INSERT INTO `receipt_type` (`receipt_type_id`, `receipt_type_name`, `budget_percent`, `particular_exp`) VALUES
 (1,'Fee Receipt','0',NULL),
 (2,'Tution Fee',NULL,NULL),
 (3,'Developement Fee',NULL,NULL),
 (4,'Internet & E-mail Charges',NULL,NULL),
 (5,'Gymkhana Fees',NULL,NULL),
 (6,'Gathering & Cluteral Fee',NULL,NULL),
 (7,'Library Fee',NULL,NULL),
 (8,'interim Fee',NULL,NULL),
 (9,'Admission Form Fee',NULL,NULL),
 (10,'Admission Form',NULL,NULL),
 (11,'Eligibility Form Fee',NULL,NULL),
 (12,'Eligibility Fee',NULL,NULL),
 (13,'University Exam Form',NULL,NULL),
 (14,'University Exam Fee',NULL,NULL),
 (15,'St. Of Marks Fee',NULL,NULL),
 (16,'C.A.P. Fee',NULL,NULL),
 (17,'Bonafied Certificate Fee',NULL,NULL),
 (18,'T.C. Fee',NULL,NULL),
 (19,'Project Fee',NULL,NULL),
 (20,'Passing Certificate Fee',NULL,NULL),
 (21,'Internal Marks Fee',NULL,NULL),
 (22,'Late Fee',NULL,NULL),
 (23,'Supper Late Fee',NULL,NULL),
 (24,'Student Welfare Fee',NULL,NULL),
 (25,'Student Insurance Fee',NULL,NULL),
 (26,'Accident Fee',NULL,NULL),
 (27,'Ashwamedh Fee',NULL,NULL),
 (28,'Coppers Fund',NULL,NULL),
 (29,'Uni. Addmission Fee',NULL,NULL),
 (30,'Computer Fee',NULL,NULL),
 (31,'Uni. Development Fee',NULL,NULL),
 (32,'Refund Fee',NULL,NULL),
 (33,'Library Fine',NULL,NULL),
 (34,'Registration Fee',NULL,NULL),
 (35,'Admission Form & Prospectous',NULL,NULL),
 (36,'Revaluation Form fee',NULL,NULL),
 (37,'Other ',NULL,NULL),
 (38,'Uni Revaluation And Photo Copy Form Fee',NULL,NULL),
 (39,'Uni Revaluation And Photo Copy Fee',NULL,NULL);

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

--
-- Table structure for table `religion`
--

CREATE TABLE IF NOT EXISTS `religion` (
  `religion_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `religion_name` varchar(45) NOT NULL,
  PRIMARY KEY (`religion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `religion`
--

INSERT INTO `religion` (`religion_id`, `religion_name`) VALUES
(5, 'HINDU'),
(6, 'MUSLIM'),
(7, 'Sikh'),
(8, 'CHRISTIAN'),
(9, 'jain'),
(11, 'buddhist');

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

--
-- Table structure for table `resolution`
--

CREATE TABLE IF NOT EXISTS `resolution` (
  `resolution_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_no` int(11) DEFAULT NULL,
  `resolution_no` varchar(100) DEFAULT NULL,
  `resolution_discussion` varchar(5000) DEFAULT NULL,
  `sr_no_of_meeting` int(11) DEFAULT NULL,
  PRIMARY KEY (`resolution_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `role_info`
--

CREATE TABLE IF NOT EXISTS `role_info` (
  `role_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) NOT NULL,
  `student` varchar(3) DEFAULT NULL,
  `faculty` varchar(3) DEFAULT NULL,
  `accounts` varchar(3) DEFAULT NULL,
  `reports` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`role_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `route_details`
--

CREATE TABLE IF NOT EXISTS `route_details` (
  `route_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_name` varchar(100) DEFAULT NULL,
  `distance` varchar(10) DEFAULT NULL,
  `bus_no` int(11) DEFAULT NULL,
  `bus_driver` varchar(20) DEFAULT NULL,
  `bus_attendant` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`route_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `route_details`
--


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

--
-- Table structure for table `scanned_docs`
--

CREATE TABLE IF NOT EXISTS `scanned_docs` (
  `scanned_docs_id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_name` varchar(100) DEFAULT NULL,
  `doc_desc` varchar(500) DEFAULT NULL,
  `doc` longblob,
  PRIMARY KEY (`scanned_docs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `section_info`
--

CREATE TABLE IF NOT EXISTS `section_info` (
  `section_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `section_name` varchar(45) NOT NULL,
  `section_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`section_info_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `section_info`
--

INSERT INTO `section_info` (`section_info_id`, `section_name`, `section_no`) VALUES
(7, 'MCA', NULL);

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

--
-- Table structure for table `skipped_receipt_info`
--

CREATE TABLE IF NOT EXISTS `skipped_receipt_info` (
  `skipped_receipt_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) NOT NULL,
  `receipt_date` varchar(45) DEFAULT NULL,
  `receipt_type` varchar(100) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `paid_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `fee_info_id` int(10) UNSIGNED DEFAULT NULL,
  `bank` varchar(300) DEFAULT NULL,
  `chq_dd_no` varchar(15) DEFAULT NULL,
  `ptotal` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `bus_stop_name` varchar(45) DEFAULT NULL,
  `stop_from` varchar(45) DEFAULT NULL,
  `stop_to` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`skipped_receipt_info_id`),
  KEY `FK_receipt_info_1` (`s_personal_info_id`),
  KEY `FK_receipt_info_2` (`fee_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `society_bus_fee`
--

CREATE TABLE IF NOT EXISTS `society_bus_fee` (
  `bus_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(25) DEFAULT NULL,
  `route_id` int(11) DEFAULT NULL,
  `bus_stop_id` int(11) DEFAULT NULL,
  `total_fee` float DEFAULT NULL,
  `paid_fee` float DEFAULT NULL,
  `pending_fee` float DEFAULT NULL,
  `term` int(11) DEFAULT NULL,
  `oldpending` float DEFAULT NULL,
  `is_concession` varchar(10) DEFAULT NULL,
  `concession_amount` float DEFAULT NULL,
  `s_bus_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`bus_fees_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_bus_fee_receipt`
--

CREATE TABLE IF NOT EXISTS `society_bus_fee_receipt` (
  `society_bus_fee_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) DEFAULT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `middel_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `stop` varchar(255) DEFAULT NULL,
  `term1_fee` varchar(45) DEFAULT NULL,
  `term2_fee` varchar(45) DEFAULT NULL,
  `pyment_type` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`society_bus_fee_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_bus_receipt_info`
--

CREATE TABLE IF NOT EXISTS `society_bus_receipt_info` (
  `receipt_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) NOT NULL,
  `receipt_date` varchar(45) DEFAULT NULL,
  `receipt_type` varchar(100) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `paid_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `fee_info_id` int(10) UNSIGNED DEFAULT NULL,
  `bank` varchar(300) DEFAULT NULL,
  `chq_dd_no` varchar(15) DEFAULT NULL,
  `ptotal` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `bus_stop_name` varchar(45) DEFAULT NULL,
  `stop_from` varchar(45) DEFAULT NULL,
  `stop_to` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `cash_amount` varchar(45) DEFAULT NULL,
  `trf_no` varchar(45) DEFAULT NULL,
  `trf_narration` varchar(45) DEFAULT NULL,
  `rtgs_no` varchar(45) DEFAULT NULL,
  `rtgs_narration` varchar(45) DEFAULT NULL,
  `refund_description` varchar(350) DEFAULT NULL,
  `is_canceled` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_info_id`),
  KEY `FK_receipt_info_1` (`s_personal_info_id`),
  KEY `FK_receipt_info_2` (`fee_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_fee_receipt`
--

CREATE TABLE IF NOT EXISTS `society_fee_receipt` (
  `society_fee_receipt_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `middel_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `standard` varchar(45) DEFAULT NULL,
  `branch` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  `admission_type` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `fee_head` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `total` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`society_fee_receipt_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_voucher`
--

CREATE TABLE IF NOT EXISTS `society_voucher` (
  `sv_number` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sv_name` varchar(100) NOT NULL,
  `sv_date` varchar(20) DEFAULT NULL,
  `sv_paid_to` varchar(100) DEFAULT NULL,
  `sv_amount` varchar(10) DEFAULT NULL,
  `sv_towards` varchar(200) DEFAULT NULL,
  `sv_is_cash_or_cheque` varchar(50) DEFAULT NULL,
  `sv_cheque_number` varchar(50) DEFAULT NULL,
  `sv_cash_amount` varchar(10) DEFAULT NULL,
  `sv_total` varchar(10) DEFAULT NULL,
  `sv_received_by` varchar(100) DEFAULT NULL,
  `is_paid_received` varchar(45) DEFAULT NULL,
  `sv_particulars` varchar(45) DEFAULT NULL,
  `sv_bankname` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`sv_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `society_voucher`
--

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

--
-- Table structure for table `society_voucher_head`
--

CREATE TABLE IF NOT EXISTS `society_voucher_head` (
  `svh_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `svh_name` varchar(45) NOT NULL,
  PRIMARY KEY (`svh_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_voucher_type`
--

CREATE TABLE IF NOT EXISTS `society_voucher_type` (
  `society_voucher_type_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `society_voucher_type_name` varchar(100) NOT NULL,
  PRIMARY KEY (`society_voucher_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `society_voucher_type`
--



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

--
-- Table structure for table `standard_info`
--

CREATE TABLE IF NOT EXISTS `standard_info` (
  `standard_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `standard_name` varchar(100) DEFAULT NULL,
  `section_name` varchar(45) DEFAULT NULL,
  `standard_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`standard_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard_info`
--

INSERT INTO `standard_info` (`standard_info_id`, `standard_name`, `section_name`, `standard_no`) VALUES
(1, 'FIRST', 'MCA', NULL),
(2, 'SECOND', 'MCA', NULL),
(3, 'THIRD', 'MCA', NULL);
-- --------------------------------------------------------

--
-- Table structure for table `standard_report`
--

CREATE TABLE IF NOT EXISTS `standard_report` (
  `standard_report_id` int(11) NOT NULL AUTO_INCREMENT,
  `standard_report_name` varchar(400) DEFAULT NULL,
  `table_names` varchar(50) DEFAULT NULL,
  `column_names` varchar(500) DEFAULT NULL,
  `conditions` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`standard_report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `stationary_receipt_head`
--

CREATE TABLE IF NOT EXISTS `stationary_receipt_head` (
  `stationary_receipt_head_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `head_name` varchar(100) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL,
  `quantity` varchar(20) NOT NULL,
  `tax_amount` varchar(20) NOT NULL,
  `head_total` varchar(20) NOT NULL,
  PRIMARY KEY (`stationary_receipt_head_id`),
  KEY `FK_stationary_receipt_head_1` (`stationary_receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `stationary_receipt_title`
--

CREATE TABLE IF NOT EXISTS `stationary_receipt_title` (
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `total_amount` varchar(20) NOT NULL,
  `section_name` varchar(50) NOT NULL,
  `standard_name` varchar(50) NOT NULL,
  `academic_year` varchar(50) NOT NULL,
  PRIMARY KEY (`stationary_receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_issue`
--

CREATE TABLE IF NOT EXISTS `store_issue` (
  `store_issue_id` int(11) NOT NULL AUTO_INCREMENT,
  `issue_date` date DEFAULT NULL,
  `issue_item_name` varchar(45) DEFAULT NULL,
  `issue_item_qty` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_requirement`
--

CREATE TABLE IF NOT EXISTS `store_requirement` (
  `store_req_id` int(11) NOT NULL AUTO_INCREMENT,
  `req_number` varchar(45) NOT NULL,
  `req_by` varchar(45) DEFAULT NULL,
  `req_by_designation` varchar(45) DEFAULT NULL,
  `req_item_name` varchar(45) NOT NULL,
  `req_qty` varchar(45) NOT NULL,
  `req_date` datetime DEFAULT NULL,
  `req_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_req_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_stock`
--

CREATE TABLE IF NOT EXISTS `store_stock` (
  `store_stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(45) DEFAULT NULL,
  `item_qty` varchar(45) DEFAULT NULL,
  `item_desc` varchar(45) DEFAULT NULL,
  `store_date` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_bonafide`
--

CREATE TABLE IF NOT EXISTS `student_bonafide` (
  `bonafide_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) NOT NULL,
  `generated_date` date DEFAULT NULL,
  `place` varchar(100) DEFAULT NULL,
  `bdateinwords` varchar(100) DEFAULT NULL,
  `bonafied_number` varchar(25) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`bonafide_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_notice`
--

CREATE TABLE IF NOT EXISTS `student_notice` (
  `student_notice_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_id` varchar(45) DEFAULT NULL,
  `student_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`student_notice_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40489 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_photo`
--

CREATE TABLE IF NOT EXISTS `student_photo` (
  `student_photo_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `image` longblob,
  PRIMARY KEY (`student_photo_id`),
  KEY `FK_student_photo_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `student_stationary`
--

CREATE TABLE IF NOT EXISTS `student_stationary` (
  `student_stationary_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` varchar(50) DEFAULT NULL,
  `subcategory` varchar(50) DEFAULT NULL,
  `product` varchar(100) NOT NULL,
  `price` varchar(20) NOT NULL,
  `tax_percent` varchar(5) NOT NULL,
  PRIMARY KEY (`student_stationary_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_user`
--

CREATE TABLE IF NOT EXISTS `student_user` (
  `student_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `is_info_added` varchar(1) NOT NULL,
  PRIMARY KEY (`student_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `student_user` (`student_user_id`,`username`,`password`,`is_info_added`) VALUES 
 (2,'14151101','d7HrWWcEwS','N'),
 (4,'14151102','oYj6swFN9n','N'),
 (5,'14151103','xyAn1D4MmF','N'),
 (6,'14151104','U8gWW9lDOY','N'),
 (7,'14151105','PcYUvF6p4U','N'),
 (8,'14151106','mT5hkpZm0u','N'),
 (9,'14151107','xMK6Lx1OQ8','N'),
 (10,'14151108','BxBSh61RW8','N'),
 (11,'14151109','KCvTsYkGfK','N'),
 (12,'14151110','8jdbjROmsz','N'),
 (13,'14151111','cJ9LWKLw4r','N'),
 (14,'14151112','Nz5NyAYLMU','N'),
 (15,'14151113','uaEm8Cq9D4','N'),
 (16,'14151114','4OT9BJWJ9y','N'),
 (17,'14151115','yTnPodaXw5','N'),
 (19,'14151117','vP88nlloNN','N'),
 (20,'14151118','sTWU5LPuEt','N'),
 (21,'14151119','KEXeyaI5Z2','N'),
 (22,'14151120','Oe6fq0BPyl','N'),
 (23,'14151121','sz01RCyebk','N'),
 (24,'14151122','N1WXvha7hN','N'),
 (25,'14151116','8s4u3GBluy','N'),
 (27,'14151123','t0z8H5ffjs','N'),
 (28,'14151124','hKlGrpYyqb','N'),
 (29,'14151125','HvwgiBhuCp','N'),
 (30,'14151126','QNE9qVnx4u','N'),
 (31,'14151127','w0USsuTaaZ','N'),
 (32,'14151128','17Q9Zjtt0S','N'),
 (33,'14151129','F4GoXj2eKF','N'),
 (34,'1415130','fMtto1gg5K','N'),
 (35,'1415131','HUfwQQT4FS','N'),
 (36,'1415132','BQzbFgEp4B','N'),
 (37,'1415133','5Dj8uUohYt','N'),
 (38,'14151134','n1y9UiYFhP','N'),
 (39,'14151135','um6xZub18M','N'),
 (40,'14151136','3rFhJF0Mow','N'),
 (41,'1415137','H1SVOKmwId','N'),
 (42,'1415138','Qpp486xXbq','N'),
 (43,'14151139','gbwMkFYyAe','N'),
 (44,'1415140','Ssrz4v4dI5','N'),
 (45,'1415141','thYo7Y36bC','N'),
 (46,'1415142','s9gmMdehnt','N'),
 (47,'1415143','JW5CGPpYFF','N'),
 (48,'14151144','KfHuMLBXO5','N'),
 (49,'14151146','0NTl33iFBK','N'),
 (50,'14151147','KAkmAWUkjj','N'),
 (51,'14151148','Xy9rfm0NfS','N'),
 (52,'14151149','miBGZrr9OH','N'),
 (53,'14151150','e61tdx2jbc','N'),
 (54,'14151151','HZB15Xc52C','N'),
 (55,'14151152','je82I6rClz','N'),
 (56,'14151153','hMG4hCDhI2','N'),
 (57,'14151154','Ior3rUCBB5','N'),
 (58,'14151155','Oq79umQ4b8','N'),
 (59,'14151156','eYVkhKt2gZ','N'),
 (60,'14151157','rBJol5a6Pd','N'),
 (61,'14151158','GQ1Fe9F8OT','N'),
 (62,'14151159','72oXfcvlny','N'),
 (63,'14151160','XuyfpW6YX3','N'),
 (64,'14151161','VhKVoD0FeO','N'),
 (65,'14151162','16UmNetrSP','N'),
 (66,'141511653','jtdDKa0r8a','N'),
 (67,'14151164','efw33WxTBe','N'),
 (68,'14151165','7ECP29m26W','N'),
 (69,'14151201','AtCdik1yHY','N'),
 (70,'14151002','extdBIDX6u','N'),
 (71,'14151073','rpbC2vqiVM','N'),
 (72,'14151037','y5RMOeTEoc','N'),
 (73,'14151038','9gWYXr31ud','N'),
 (74,'14151074','HPcwU43MTK','N'),
 (75,'14151075','sWLOAsKHZh','N'),
 (76,'14151076','J79yvwtBy6','N'),
 (77,'14151077','j4A0fBL2Ik','N'),
 (78,'14151078','ETNObuU4u3','N'),
 (79,'14151080','VlGfdNuhcQ','N'),
 (80,'14151082','TvI5FZQGOT','N'),
 (81,'14151083','qsK8KKpYnj','N'),
 (82,'14151068','ateM5l42P4','N'),
 (83,'14151064','b0NfEZHJd3','N'),
 (84,'14151065','30869Sh6cn','N'),
 (85,'14151070','RhGdE2Ezaa','N'),
 (86,'14151039','JrkJzEiyIB','N'),
 (87,'14151072','xt8AKRM5ae','N'),
 (88,'14151040','7KJPDtp2jP','N'),
 (89,'14151036','jKTpigmyNJ','N'),
 (90,'14151067','ApeBdKC5E4','N'),
 (91,'14151066','Rbza6PY5EW','N'),
 (92,'14151047','Ja4E8QHmYs','N'),
 (93,'14151048','zmwHWIDNAW','N'),
 (94,'14151052','QHi7nsCxCM','N'),
 (95,'14151060','GNuvfFJbsK','N'),
 (96,'14151054','z8YaxnkMrU','N'),
 (97,'14151071','0iKHw1r29O','N'),
 (98,'14151069','eUPIK9V12L','N'),
 (99,'14151061','UKXtytCdWc','N'),
 (100,'14151055','Ze2i09LIvb','N'),
 (101,'14151063','KmSEi3bpyU','N'),
 (102,'14151001','lh9i5QbVbQ','N'),
 (103,'141510101','U5VhJW9PZc','N'),
 (104,'14151050','eEOeu8lxvR','N'),
 (105,'14151051','JLhlpxyaG0','N'),
 (106,'14151062','k8CDs5mIvY','N'),
 (107,'14151079','r78n6MKEI8','N'),
 (108,'14151003','q6a9rDbVVM','N'),
 (109,'14151087','c2WMYoqgKs','N'),
 (110,'14151097','TcAnjYwqF3','N'),
 (111,'14151098','90m7ah84J8','N'),
 (112,'14151099','98CLS6QZzd','N'),
 (113,'14151100','bjTaEDE1v3','N'),
 (114,'141511','iXRcjM9zSt','N'),
 (115,'141511110','YXFkGPjdbv','N'),
 (116,'14151202','N5dnp44c2X','N'),
 (117,'14151253','RnREB37Ym1','N'),
 (118,'14151081','JbbwixCnok','N'),
 (119,'141510117','2R4x7dTzBm','N'),
 (120,'141511122','ycMAHPon7S','N'),
 (121,'141512110','p4JpMtlc3q','N'),
 (122,'14151315','wefDiOEQUG','N'),
 (123,'14151555','WcECiMVMPv','N'),
 (124,'141515585','n0AqI2FZ9E','N'),
 (125,'141515559','pTq7GPhgUC','N'),
 (126,'141514584','j0Nhfni9cx','N'),
 (127,'1415145864','0WQXCZ60Lh','N'),
 (128,'14151459841','kgvHkOX7Hu','N'),
 (130,'161715001','xEsL0gDSyS','N'),
 (131,'16171157','AeaZVUujOQ','N'),
 (132,'16171491','bRHLKQ7a9D','N'),
 (133,'16171489','PF0FwlZqhQ','N'),
 (134,'16171487','Dg4RQOmhSf','N'),
 (135,'16171484','JpQXAnIubr','N'),
 (136,'16171515','XZzuNG9zVN','N'),
 (137,'16171480','0coasMv6kd','N'),
 (138,'16171477','0JHbXq1KjE','N'),
 (139,'16171178','pv82umd30K','N'),
 (140,'16171173','VbHTdMhNPU','N'),
 (141,'16171220','FkvDz8QkHF','N'),
 (142,'16171169','pZRNt3aCVm','N'),
 (143,'16171187','ndt0Gjn7Rd','N'),
 (144,'16171167','my3Fhx5m3q','N'),
 (145,'16171221','T3Wku4wsxR','N'),
 (146,'16171226','JuFO7AgVu8','N'),
 (147,'16171186','5vacmGNkjt','N'),
 (148,'1617115','Jj0gBZfmnO','N'),
 (149,'1617130','9PawifqyP3','N'),
 (150,'1617131','vWivN2O0nu','N'),
 (151,'17181415','x7RZU5ddUQ','N'),
 (152,'17181416','GbzBR3cdtX','N'),
 (153,'17181417','1a7jHqiAgD','N'),
 (154,'17181418','kCscmgOlua','N'),
 (155,'17181419','GTsdxAi3pc','N'),
 (156,'17181420','88zS0duwJm','N'),
 (157,'17181421','giSY739kKI','N'),
 (158,'171810421','O9ZlLEvVVK','N'),
 (159,'17181422','TfGA4A1KUN','N'),
 (160,'171810422','1ZrNfjuNVO','N'),
 (161,'17181423','cVLAE0OMnj','N'),
 (162,'17181424','hKWP8uFITj','N'),
 (163,'17181425','TvlEPqHyqK','N'),
 (164,'17181426','BCHFDoQSdS','N'),
 (165,'17181427','jEx2kuGvlC','N'),
 (166,'17181428','ygnX6DdUPE','N'),
 (167,'17181429','CXMxZVPsf6','N'),
 (168,'17181430','3iJLa8vHWY','N'),
 (169,'17181431','N40Scy50os','N'),
 (170,'17181432','5Mo3OI23wn','N'),
 (171,'17181433','HpsF53HW8Y','N'),
 (172,'17181434','wyjYO3EXUm','N'),
 (173,'17181435','hBIMrkpirx','N'),
 (174,'17181436','a0w8z8KzG4','N'),
 (175,'17181437','gnG9zW16JJ','N'),
 (176,'17181438','jiNyU08SI1','N'),
 (177,'17181439','jx3R94vBbb','N'),
 (178,'17181440','a7LDpuFZ58','N'),
 (179,'17181441','1ZqCZHHGQk','N'),
 (180,'17181442','jvAPzUIoqC','N'),
 (181,'17181451','ABYFwPuPub','N'),
 (182,'17181011','0RXptUKIe2','N'),
 (183,'171810111','TDz9V4wk9z','N'),
 (184,'18191201801','Y7005haC5K','N'),
 (185,'18191201802','eY3h8RsYSj','N'),
 (186,'18191201803','fTxJau4a6m','N'),
 (187,'18191201804','qYy7Uz5beP','N'),
 (188,'18191201805','RtIY6DmSh1','N'),
 (189,'18191201806','x0XqDxyQww','N'),
 (190,'18191201807','k3HrsCzb1W','N'),
 (191,'18191201808','LGU2xzSBiJ','N'),
 (192,'18191201809','DOSVug3OmJ','N'),
 (193,'18191201810','xkEj5XnB08','N'),
 (194,'18191201811','YmwIlo8Pu2','N'),
 (195,'18191201812','d7KMrBL35N','N'),
 (196,'18191201816','dGhLNuOOmR','N'),
 (197,'181912181817','LxocMGmmM7','N'),
 (198,'18191201818','S7X6ywINEX','N'),
 (199,'18191201819','MjebeR3adU','N'),
 (200,'18191201820','TzRTlYPa8w','N'),
 (201,'18191201821','wYjHdDnvDt','N'),
 (202,'18191201822','tcDgrHpgAe','N'),
 (203,'18191201823','GSo1jQPovk','N'),
 (204,'18191201824','doGtOxDVik','N'),
 (205,'18191201825','tXG6Vl9xeG','N'),
 (206,'18191201826','LXHpu1PnpG','N'),
 (207,'18191201827','ebxIrQ8iuJ','N'),
 (208,'18191201828','P04sJHmLir','N'),
 (209,'18191201829','3BN8UwyEdC','N'),
 (210,'18191201830','7qOa65ROPX','N'),
 (211,'18191201831','mSu20xxOTQ','N'),
 (212,'18191201832','nDfq4Lh0hN','N'),
 (213,'18191201833','Yxj2tf5SKh','N'),
 (214,'18191201834','HsNe8lzaEy','N'),
 (215,'18191201835','v8fzfHMTij','N'),
 (216,'18191201836','gacmayuWTi','N'),
 (217,'18191201837','vZNkcnnUa0','N'),
 (218,'18191201838','SkACzUjaIn','N'),
 (219,'1819120140','4wJt1BikxW','N'),
 (220,'181910007','vbELyDsagG','N'),
 (221,'1819100001','alCMecTkB9','N'),
 (222,'1819161702525','r2WhmzauSD','N'),
 (223,'181912018','MNl7XdCd2X','N'),
 (224,'1819105','csiwXQRjG3','N');
-- --------------------------------------------------------

--
-- Table structure for table `subject_info`
--

CREATE TABLE IF NOT EXISTS `subject_info` (
  `subject_code` varchar(10) NOT NULL,
  `subject_name` varchar(50) DEFAULT NULL,
  `course_no` varchar(50) DEFAULT NULL,
  `theory_marks` varchar(5) DEFAULT NULL,
  `tw_marks` varchar(5) DEFAULT NULL,
  `practical_viva_marks` varchar(5) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `standard` varchar(15) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`subject_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `sudent_notice_old`
--

CREATE TABLE IF NOT EXISTS `sudent_notice_old` (
  `sudent_notice_old_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_id` varchar(45) DEFAULT NULL,
  `student_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`sudent_notice_old_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36483 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_academic_info`
--

CREATE TABLE IF NOT EXISTS `s_academic_info` (
  `s_academic_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_is_repeat_year` varchar(3) DEFAULT NULL,
  `s_previous_school_attended` varchar(100) DEFAULT NULL,
  `s_last_class_attended` varchar(45) DEFAULT NULL,
  `s_last_exam_percentage` varchar(45) DEFAULT NULL,
  `s_last_exam_grade` varchar(45) DEFAULT NULL,
  `s_school_name` varchar(200) DEFAULT NULL,
  `s_ssc_seatno` varchar(200) DEFAULT NULL,
  `s_ssc_month` varchar(200) DEFAULT NULL,
  `s_ssc_year` varchar(200) DEFAULT NULL,
  `s_ssc_center` varchar(200) DEFAULT NULL,
  `s_marks1` varchar(4) DEFAULT NULL,
  `s_marks1_total` varchar(4) DEFAULT NULL,
  `s_percentage1` varchar(5) DEFAULT NULL,
  `s_jrcollege_name` varchar(200) DEFAULT NULL,
  `s_marks2` varchar(4) DEFAULT NULL,
  `s_marks2_total` varchar(4) DEFAULT NULL,
  `s_percentage2` varchar(5) DEFAULT NULL,
  `s_achievements` varchar(100) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `s_is_gap` varchar(20) DEFAULT NULL,
  `no_gap_years` varchar(20) DEFAULT NULL,
  `gap_reason` varchar(100) DEFAULT NULL,
  `s_repeat_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_academic_info_id`),
  KEY `FK_s_academic_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `s_academic_info`
--

INSERT INTO `s_academic_info` (`s_academic_info_id`, `s_personal_info_id`, `s_is_repeat_year`, `s_previous_school_attended`, `s_last_class_attended`, `s_last_exam_percentage`, `s_last_exam_grade`,
 `s_school_name`, `s_ssc_seatno`, `s_ssc_month`, `s_ssc_year`, `s_ssc_center`, `s_marks1`, `s_marks1_total`,`s_jrcollege_name`) VALUES
 (2,'14151101',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (4,'14151102',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (5,'14151103',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (6,'14151104',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (7,'14151105',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (8,'14151106',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (9,'14151107',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (10,'14151108',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (11,'14151109',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (12,'14151110',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (13,'14151111',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (14,'14151112',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (15,'14151113',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (16,'14151114',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (17,'14151115',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (19,'14151117',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (20,'14151118',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (21,'14151119',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (22,'14151120',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (23,'14151121',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (24,'14151122',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (25,'14151116',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (27,'14151123',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (28,'14151124',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (29,'14151125',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (30,'14151126',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (31,'14151127',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (32,'14151128',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (33,'14151129',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (34,'1415130',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (35,'1415131',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (36,'1415132',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (37,'1415133',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (38,'14151134',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (39,'14151135',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (40,'14151136',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (41,'1415137',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (42,'1415138',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (43,'14151139',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (44,'1415140',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (45,'1415141',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (46,'1415142',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (47,'1415143',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (48,'14151144',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (49,'14151146',NULL,'Direct',NULL,NULL,'',NULL,NULL,NULL,'',NULL,NULL,NULL,'Management'),
 (50,'14151147',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (51,'14151148',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (52,'14151149',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (53,'14151150',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (54,'14151151',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (55,'14151152',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (56,'14151153',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (57,'14151154',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (58,'14151155',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (59,'14151156',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (60,'14151157',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (61,'14151158',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (62,'14151159',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (63,'14151160',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (64,'14151161',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (65,'14151162',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (66,'141511653',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (67,'14151164',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (68,'14151165',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (69,'14151201',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (70,'14151002',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (71,'14151073',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (72,'14151037',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (73,'14151038',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (74,'14151074',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (75,'14151075',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (76,'14151076',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (77,'14151077',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (78,'14151078',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (79,'14151080',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (80,'14151082',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (81,'14151083',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (82,'14151068',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (83,'14151064',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (84,'14151065',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (85,'14151070',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (86,'14151039',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (87,'14151072',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (88,'14151040',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (89,'14151036',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (90,'14151067',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (91,'14151066',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (92,'14151047',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (93,'14151048',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (94,'14151052',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (95,'14151060',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (96,'14151054',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (97,'14151071',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (98,'14151069',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (99,'14151061',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (100,'14151055',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (101,'14151063',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (102,'14151001',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (103,'141510101',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (104,'14151050',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (105,'14151051',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (106,'14151062',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (107,'14151079',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (108,'14151003',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (109,'14151087',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (110,'14151097',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (111,'14151098',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (112,'14151099',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (113,'14151100',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (114,'141511',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (115,'141511110',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (116,'14151202',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (117,'14151253',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (118,'14151081',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (119,'141510117',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Provisional'),
 (120,'141511122',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (121,'141512110',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (122,'14151315',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (123,'14151555',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (124,'141515585',NULL,'Direct',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (125,'141515559',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (126,'141514584',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (127,'1415145864',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (128,'14151459841',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (130,'161715001',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (131,'16171157',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (132,'16171491',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (133,'16171489',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (134,'16171487',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (135,'16171484',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (136,'16171515',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (137,'16171480',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (138,'16171477',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (139,'16171178',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (140,'16171173',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (141,'16171220',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (142,'16171169',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (143,'16171187',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (144,'16171167',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (145,'16171221',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (146,'16171226',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (147,'16171186',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (148,'1617115',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (149,'1617130',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (150,'1617131',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (151,'17181415',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (152,'17181416',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (153,'17181417',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (154,'17181418',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (155,'17181419',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (156,'17181420',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (157,'17181421',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (158,'171810421',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (159,'17181422',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (160,'171810422',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (161,'17181423',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (162,'17181424',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (163,'17181425',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (164,'17181426',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (165,'17181427',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (166,'17181428',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (167,'17181429',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (168,'17181430',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (169,'17181431',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (170,'17181432',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (171,'17181433',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (172,'17181434',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (173,'17181435',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (174,'17181436',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (175,'17181437',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (176,'17181438',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (177,'17181439',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (178,'17181440',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (179,'17181441',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (180,'17181442',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (181,'17181451',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (182,'17181011',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (183,'171810111',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (184,'18191201801',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (185,'18191201802',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (186,'18191201803',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (187,'18191201804',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (188,'18191201805',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (189,'18191201806',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (190,'18191201807',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (191,'18191201808',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (192,'18191201809',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (193,'18191201810',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (194,'18191201811',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (195,'18191201812',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (196,'18191201816',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (197,'181912181817',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (198,'18191201818',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (199,'18191201819',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (200,'18191201820',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (201,'18191201821',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (202,'18191201822',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (203,'18191201823',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (204,'18191201824',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (205,'18191201825',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (206,'18191201826',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (207,'18191201827',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (208,'18191201828',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (209,'18191201829',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (210,'18191201830',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (211,'18191201831',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (212,'18191201832',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (213,'18191201833',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (214,'18191201834',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (215,'18191201835',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (216,'18191201836',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (217,'18191201837',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (218,'18191201838',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (219,'1819120140',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (220,'181910007',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (221,'1819100001',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (222,'1819161702525',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (223,'181912018',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (224,'1819105',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round');

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

--
-- Table structure for table `s_attendance`
--

CREATE TABLE IF NOT EXISTS `s_attendance` (
  `s_attendance_id` int(10) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `attendance_date` date DEFAULT NULL,
  `is_present` varchar(20) DEFAULT NULL,
  `teacher_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_attendance_id`)
) ENGINE=MyISAM AUTO_INCREMENT=224918 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_division`
--

CREATE TABLE IF NOT EXISTS `s_division` (
  `s_division_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `division_info_id` varchar(50) NOT NULL,
  PRIMARY KEY (`s_division_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `s_division`
--

INSERT INTO `s_division` (`s_division_id`, `s_personal_info_id`, `division_info_id`) VALUES

 (2,'14151101','THIRDMCA'),
 (4,'14151102','THIRDMCA'),
 (5,'14151103','THIRDMCA'),
 (6,'14151104','THIRDMCA'),
 (7,'14151105','THIRDMCA'),
 (8,'14151106','THIRDMCA'),
 (9,'14151107','THIRDMCA'),
 (10,'14151108','THIRDMCA'),
 (11,'14151109','THIRDMCA'),
 (12,'14151110','THIRDMCA'),
 (13,'14151111','THIRDMCA'),
 (14,'14151112','THIRDMCA'),
 (15,'14151113','THIRDMCA'),
 (16,'14151114','THIRDMCA'),
 (17,'14151115','THIRDMCA'),
 (19,'14151117','THIRDMCA'),
 (20,'14151118','THIRDMCA'),
 (21,'14151119','THIRDMCA'),
 (22,'14151120','THIRDMCA'),
 (23,'14151121','THIRDMCA'),
 (24,'14151122','THIRDMCA'),
 (25,'14151116','THIRDMCA'),
 (27,'14151123','THIRDMCA'),
 (28,'14151124','THIRDMCA'),
 (29,'14151125','THIRDMCA'),
 (30,'14151126','THIRDMCA'),
 (31,'14151127','THIRDMCA'),
 (32,'14151128','THIRDMCA'),
 (33,'14151129','THIRDMCA'),
 (34,'1415130','THIRDMCA'),
 (35,'1415131','THIRDMCA'),
 (36,'1415132','THIRDMCA'),
 (37,'1415133','THIRDMCA'),
 (38,'14151134','THIRDMCA'),
 (39,'14151135','THIRDMCA'),
 (40,'14151136','THIRDMCA'),
 (41,'1415137','THIRDMCA'),
 (42,'1415138','THIRDMCA'),
 (43,'14151139','THIRDMCA'),
 (44,'1415140','THIRDMCA'),
 (45,'1415141','THIRDMCA'),
 (46,'1415142','THIRDMCA'),
 (47,'1415143','THIRDMCA'),
 (48,'14151144','THIRDMCA'),
 (49,'14151146','THIRDMCA'),
 (50,'14151147','THIRDMCA'),
 (51,'14151148','THIRDMCA'),
 (52,'14151149','THIRDMCA'),
 (53,'14151150','THIRDMCA'),
 (54,'14151151','THIRDMCA'),
 (55,'14151152','THIRDMCA'),
 (56,'14151153','THIRDMCA'),
 (57,'14151154','THIRDMCA'),
 (58,'14151155','THIRDMCA'),
 (59,'14151156','THIRDMCA'),
 (60,'14151157','THIRDMCA'),
 (61,'14151158','THIRDMCA'),
 (62,'14151159','THIRDMCA'),
 (63,'14151160','SECONDMCA'),
 (64,'14151161','THIRDMCA'),
 (65,'14151162','THIRDMCA'),
 (66,'141511653','THIRDMCA'),
 (67,'14151164','THIRDMCA'),
 (68,'14151165','THIRDMCA'),
 (69,'14151201','SECONDMCA'),
 (70,'14151002','SECONDMCA'),
 (71,'14151073','SECONDMCA'),
 (72,'14151037','SECONDMCA'),
 (73,'14151038','FIRSTMCA'),
 (74,'14151074','SECONDMCA'),
 (75,'14151075','SECONDMCA'),
 (76,'14151076','SECONDMCA'),
 (77,'14151077','SECONDMCA'),
 (78,'14151078','SECONDMCA'),
 (79,'14151080','THIRDMCA2015-16'),
 (80,'14151082','SECONDMCA'),
 (81,'14151083','SECONDMCA'),
 (82,'14151068','SECONDMCA'),
 (83,'14151064','SECONDMCA'),
 (84,'14151065','SECONDMCA'),
 (85,'14151070','SECONDMCA'),
 (86,'14151039','SECONDMCA'),
 (87,'14151072','SECONDMCA'),
 (88,'14151040','SECONDMCA'),
 (89,'14151036','SECONDMCA'),
 (90,'14151067','SECONDMCA'),
 (91,'14151066','SECONDMCA'),
 (92,'14151047','SECONDMCA'),
 (93,'14151048','SECONDMCA'),
 (94,'14151052','SECONDMCA'),
 (95,'14151060','SECONDMCA'),
 (96,'14151054','SECONDMCA'),
 (97,'14151071','SECONDMCA'),
 (98,'14151069','SECONDMCA'),
 (99,'14151061','SECONDMCA'),
 (100,'14151055','SECONDMCA'),
 (101,'14151063','SECONDMCA'),
 (102,'14151001','SECONDMCA'),
 (103,'141510101','SECONDMCA'),
 (104,'14151050','SECONDMCA'),
 (105,'14151051','SECONDMCA'),
 (106,'14151062','SECONDMCA'),
 (107,'14151079','SECONDMCA'),
 (108,'14151003','SECONDMCA'),
 (109,'14151087','SECONDMCA'),
 (110,'14151097','SECONDMCA'),
 (111,'14151098','SECONDMCA'),
 (112,'14151099','SECONDMCA'),
 (113,'14151100','SECONDMCA'),
 (114,'141511','FIRSTMCA'),
 (115,'141511110','SECONDMCA'),
 (116,'14151202','SECONDMCA'),
 (117,'14151253','SECONDMCA'),
 (118,'14151081','SECONDMCA'),
 (119,'141510117','SECONDMCA'),
 (120,'141511122','THIRDMCA'),
 (121,'141512110','THIRDMCA'),
 (122,'14151315','SECONDMCA'),
 (123,'14151555','SECONDMCA'),
 (124,'141515585','SECONDMCA'),
 (125,'141515559','Not Selected'),
 (126,'141514584','SECONDMCA'),
 (127,'1415145864','THIRDMCA'),
 (128,'14151459841','SECONDMCA'),
 (130,'161715001','FIRSTMCA'),
 (131,'16171157','THIRDMCA'),
 (132,'16171491','THIRDMCA'),
 (133,'16171489','THIRDMCA2017-18'),
 (134,'16171487','SECONDMCA'),
 (135,'16171484','THIRDMCA2017-18'),
 (136,'16171515','THIRDMCA2017-18'),
 (137,'16171480','THIRDMCA2017-18'),
 (138,'16171477','THIRDMCA2017-18'),
 (139,'16171178','THIRDMCA2018-19'),
 (140,'16171173','THIRDMCA2018-19'),
 (141,'16171220','THIRDMCA2018-19'),
 (142,'16171169','THIRDMCA2018-19'),
 (143,'16171187','FIRSTMCA'),
 (144,'16171167','THIRDMCA2018-19'),
 (145,'16171221','THIRDMCA2018-19'),
 (146,'16171226','FIRSTMCA'),
 (147,'16171186','FIRSTMCA'),
 (148,'1617115','SECONDMCA2017-18'),
 (149,'1617130','THIRDMCA2017-18'),
 (150,'1617131','THIRDMCA'),
 (151,'17181415','SECONDMCA2018-19'),
 (152,'17181416','SECONDMCA2018-19'),
 (153,'17181417','SECONDMCA2018-19'),
 (154,'17181418','SECONDMCA2018-19'),
 (155,'17181419','FIRSTMCA'),
 (156,'17181420','FIRSTMCA'),
 (157,'17181421','FIRSTMCA'),
 (158,'171810421','SECONDMCA2018-19'),
 (159,'17181422','SECONDMCA2018-19'),
 (160,'171810422','SECONDMCA2018-19'),
 (161,'17181423','SECONDMCA2018-19'),
 (162,'17181424','SECONDMCA2018-19'),
 (163,'17181425','SECONDMCA2018-19'),
 (164,'17181426','SECONDMCA2018-19'),
 (165,'17181427','SECONDMCA2018-19'),
 (166,'17181428','FIRSTMCA'),
 (167,'17181429','SECONDMCA2018-19'),
 (168,'17181430','FIRSTMCA'),
 (169,'17181431','SECONDMCA2018-19'),
 (170,'17181432','FIRSTMCA'),
 (171,'17181433','SECONDMCA2018-19'),
 (172,'17181434','SECONDMCA2018-19'),
 (173,'17181435','SECONDMCA2018-19'),
 (174,'17181436','SECONDMCA2018-19'),
 (175,'17181437','FIRSTMCA'),
 (176,'17181438','SECONDMCA2018-19'),
 (177,'17181439','FIRSTMCA'),
 (178,'17181440','SECONDMCA2018-19'),
 (179,'17181441','SECONDMCA2018-19'),
 (180,'17181442','SECONDMCA2018-19'),
 (181,'17181451','FIRSTMCA'),
 (182,'17181011','SECONDMCA'),
 (183,'171810111','THIRDMCA'),
 (184,'18191201801','FIRSTMCA'),
 (185,'18191201802','FIRSTMCA'),
 (186,'18191201803','FIRSTMCA'),
 (187,'18191201804','FIRSTMCA'),
 (188,'18191201805','FIRSTMCA'),
 (189,'18191201806','FIRSTMCA'),
 (190,'18191201807','FIRSTMCA'),
 (191,'18191201808','FIRSTMCA'),
 (192,'18191201809','FIRSTMCA'),
 (193,'18191201810','FIRSTMCA'),
 (194,'18191201811','FIRSTMCA'),
 (195,'18191201812','FIRSTMCA'),
 (196,'18191201816','FIRSTMCA'),
 (197,'181912181817','FIRSTMCA'),
 (198,'18191201818','FIRSTMCA'),
 (199,'18191201819','FIRSTMCA'),
 (200,'18191201820','FIRSTMCA'),
 (201,'18191201821','FIRSTMCA'),
 (202,'18191201822','FIRSTMCA'),
 (203,'18191201823','FIRSTMCA'),
 (204,'18191201824','FIRSTMCA'),
 (205,'18191201825','FIRSTMCA'),
 (206,'18191201826','FIRSTMCA'),
 (207,'18191201827','FIRSTMCA'),
 (208,'18191201828','FIRSTMCA'),
 (209,'18191201829','FIRSTMCA'),
 (210,'18191201830','FIRSTMCA'),
 (211,'18191201831','FIRSTMCA'),
 (212,'18191201832','FIRSTMCA'),
 (213,'18191201833','FIRSTMCA'),
 (214,'18191201834','FIRSTMCA'),
 (215,'18191201835','FIRSTMCA'),
 (216,'18191201836','FIRSTMCA'),
 (217,'18191201837','FIRSTMCA'),
 (218,'18191201838','FIRSTMCA'),
 (219,'1819120140','FIRSTMCA'),
 (220,'181910007','FIRSTMCA'),
 (221,'1819100001','THIRDMCA'),
 (222,'1819161702525','THIRDMCA'),
 (223,'181912018','SECONDMCA'),
 (224,'1819105','THIRDMCA');


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

--
-- Table structure for table `s_fee_history`
--

CREATE TABLE IF NOT EXISTS `s_fee_history` (
  `s_fee_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `division_info_id` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `s_admission_type` varchar(45) DEFAULT NULL,
  `is_rte_student` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_fee_info_id`),
  KEY `FK_s_fee_info_id_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


INSERT INTO `s_fee_history` (`s_fee_info_id`,`s_personal_info_id`,`s_total_fee`,`s_paid_fee`,`s_pending_fee`,`s_payment_date`,`s_section`,`s_concession`,`s_academic_year`,`division_info_id`,`scholarship`,`s_standard`,`scholarship_pending`,`s_admission_type`) VALUES 
 (1,'16171477',76680,0,76680,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (2,'16171484',76680,34583,42097,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (3,'1617130',76680,34855,41825,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (4,'16171480',6971,0,6971,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (5,'1617115',6455,0,6455,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (6,'16171515',76680,34853,41827,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (7,'16171489',76680,35000,41680,NULL,'SECOND','0.0','2016-17','SECONDMCA','0','0','0','0'),
 (8,'16171220',6455,0,6455,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (9,'16171221',71000,0,71000,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (10,'16171173',71000,32273,38727,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (12,'16171167',71000,0,71000,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (13,'16171169',71000,32273,38727,NULL,'FIRST','0.0','2016-17','FIRSTMCA','0','0','0','0'),
 (14,'16171173',71000,38727,71000,NULL,'Second','0.0','2017-18','SECONDMCA2017-18','0','0','0','0'),
 (15,'171810422',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (17,'17181427',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (18,'17181416',25000,7450,17550,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (19,'17181417',25000,23255,1745,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (20,'17181431',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (21,'17181438',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (22,'17181418',25000,21000,4000,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (23,'17181429',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (24,'17181424',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (25,'17181425',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (26,'17181426',13637,13636,1,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (27,'17181415',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (28,'16171220',6455,4710,8200,NULL,'Second','0.0','2017-18','SECONDMCA2017-18','0','0','0','0'),
 (29,'17181442',25000,20500,4500,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (30,'171810421',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (32,'16171169',71000,38727,71000,NULL,'Second','0.0','2017-18','SECONDMCA2017-18','0','0','0','0'),
 (33,'17181423',13637,13636,1,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (34,'17181434',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (36,'16171221',71000,71000,71000,NULL,'Second','0.0','2017-18','SECONDMCA2017-18','0','0','0','0'),
 (38,'17181440',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (39,'17181441',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (40,'16171167',71000,71000,71000,NULL,'Second','0.0','2017-18','SECONDMCA2017-18','0','0','0','0'),
 (41,'17181436',25000,25000,0,NULL,'FIRST','0.0','2017-18','FIRSTMCA','0','0','0','0'),
 (42,'14151080',67200,36615,30585,NULL,'SECOND','0.0','2014-15','SECONDMCA','0','0','0','0');
-- --------------------------------------------------------

--
-- Table structure for table `s_fee_history_old`
--

CREATE TABLE IF NOT EXISTS `s_fee_history_old` (
  `s_fee_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `division_info_id` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `s_admission_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_fee_info_id`),
  KEY `FK_s_fee_info_id_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `s_lc`
--

CREATE TABLE IF NOT EXISTS `s_lc` (
  `id_s_LC` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `reg_no` varchar(45) DEFAULT NULL,
  `lc_no` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `last_school_att` varchar(100) DEFAULT NULL,
  `last_jrcollege_att` varchar(100) DEFAULT NULL,
  `progress` varchar(100) DEFAULT NULL,
  `conduct` varchar(45) DEFAULT NULL,
  `s_dol` date DEFAULT NULL,
  `s_class_and_year` varchar(60) DEFAULT NULL,
  `lc_reason` varchar(100) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lc_remarks` varchar(100) DEFAULT NULL,
  `date_of_lc` varchar(45) DEFAULT NULL,
  `is_all_dues_clear` varchar(45) DEFAULT NULL,
  `head_mistress_remarks` varchar(100) DEFAULT NULL,
  `date_of_application` varchar(45) DEFAULT NULL,
  `bdateinwords` varchar(200) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `mothertongue` varchar(45) DEFAULT NULL,
  `exam_attended` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_s_LC`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_medical_info`
--

CREATE TABLE IF NOT EXISTS `s_medical_info` (
  `s_medical_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_height` varchar(3) DEFAULT NULL,
  `s_weight` varchar(3) DEFAULT NULL,
  `s_blood_group` varchar(50) DEFAULT NULL,
  `s_allergies` varchar(200) DEFAULT NULL,
  `s_vaccination_taken` varchar(500) DEFAULT NULL,
  `s_medical_history` varchar(500) DEFAULT NULL,
  `s_family_doctor` varchar(500) DEFAULT NULL,
  `s_family_doc_phno` varchar(500) DEFAULT NULL,
  `s_identification_marks` varchar(500) DEFAULT NULL,
  `s_regular_medication` varchar(500) DEFAULT NULL,
  `s_reason_for_medication` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`s_medical_info_id`),
  KEY `FK_s_medical_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `s_medical_info`
--

INSERT INTO `s_medical_info` (`s_medical_info_id`, `s_personal_info_id`, `s_height`, `s_weight`, `s_blood_group`, `s_allergies`, `s_medical_history`) VALUES
 (2,'14151101',NULL,NULL,NULL,NULL,NULL),
 (4,'14151102',NULL,NULL,NULL,NULL,NULL),
 (5,'14151103',NULL,NULL,NULL,NULL,NULL),
 (6,'14151104',NULL,NULL,NULL,NULL,NULL),
 (7,'14151105',NULL,NULL,NULL,NULL,NULL),
 (8,'14151106',NULL,NULL,NULL,NULL,NULL),
 (9,'14151107',NULL,NULL,NULL,NULL,NULL),
 (10,'14151108',NULL,NULL,NULL,NULL,NULL),
 (11,'14151109',NULL,NULL,NULL,NULL,NULL),
 (12,'14151110',NULL,NULL,NULL,NULL,NULL),
 (13,'14151111',NULL,NULL,NULL,NULL,NULL),
 (14,'14151112',NULL,NULL,NULL,NULL,NULL),
 (15,'14151113',NULL,NULL,NULL,NULL,NULL),
 (16,'14151114',NULL,NULL,NULL,NULL,NULL),
 (17,'14151115',NULL,NULL,NULL,NULL,NULL),
 (19,'14151117',NULL,NULL,NULL,NULL,NULL),
 (20,'14151118',NULL,NULL,NULL,NULL,NULL),
 (21,'14151119',NULL,NULL,NULL,NULL,NULL),
 (22,'14151120',NULL,NULL,NULL,NULL,NULL),
 (23,'14151121',NULL,NULL,NULL,NULL,NULL),
 (24,'14151122',NULL,NULL,NULL,NULL,NULL),
 (25,'14151116',NULL,NULL,NULL,NULL,NULL),
 (27,'14151123',NULL,NULL,NULL,NULL,NULL),
 (28,'14151124',NULL,NULL,NULL,NULL,NULL),
 (29,'14151125',NULL,NULL,NULL,NULL,NULL),
 (30,'14151126',NULL,NULL,NULL,NULL,NULL),
 (31,'14151127',NULL,NULL,NULL,NULL,NULL),
 (32,'14151128',NULL,NULL,NULL,NULL,NULL),
 (33,'14151129',NULL,NULL,NULL,NULL,NULL),
 (34,'1415130',NULL,NULL,NULL,NULL,NULL),
 (35,'1415131',NULL,NULL,NULL,NULL,NULL),
 (36,'1415132',NULL,NULL,NULL,NULL,NULL),
 (37,'1415133',NULL,NULL,NULL,NULL,NULL),
 (38,'14151134',NULL,NULL,NULL,NULL,NULL),
 (39,'14151135',NULL,NULL,NULL,NULL,NULL),
 (40,'14151136',NULL,NULL,NULL,NULL,NULL),
 (41,'1415137',NULL,NULL,NULL,NULL,NULL),
 (42,'1415138',NULL,NULL,NULL,NULL,NULL),
 (43,'14151139',NULL,NULL,NULL,NULL,NULL),
 (44,'1415140',NULL,NULL,NULL,NULL,NULL),
 (45,'1415141',NULL,NULL,NULL,NULL,NULL),
 (46,'1415142',NULL,NULL,NULL,NULL,NULL),
 (47,'1415143',NULL,NULL,NULL,NULL,NULL),
 (48,'14151144',NULL,NULL,NULL,NULL,NULL),
 (49,'14151146',NULL,NULL,NULL,NULL,NULL),
 (50,'14151147',NULL,NULL,NULL,NULL,NULL),
 (51,'14151148',NULL,NULL,NULL,NULL,NULL),
 (52,'14151149',NULL,NULL,NULL,NULL,NULL),
 (53,'14151150',NULL,NULL,NULL,NULL,NULL),
 (54,'14151151',NULL,NULL,NULL,NULL,NULL),
 (55,'14151152',NULL,NULL,NULL,NULL,NULL),
 (56,'14151153',NULL,NULL,NULL,NULL,NULL),
 (57,'14151154',NULL,NULL,NULL,NULL,NULL),
 (58,'14151155',NULL,NULL,NULL,NULL,NULL),
 (59,'14151156',NULL,NULL,NULL,NULL,NULL),
 (60,'14151157',NULL,NULL,NULL,NULL,NULL),
 (61,'14151158',NULL,NULL,NULL,NULL,NULL),
 (62,'14151159',NULL,NULL,NULL,NULL,NULL),
 (63,'14151160',NULL,NULL,NULL,NULL,NULL),
 (64,'14151161',NULL,NULL,NULL,NULL,NULL),
 (65,'14151162',NULL,NULL,NULL,NULL,NULL),
 (66,'141511653',NULL,NULL,NULL,NULL,NULL),
 (67,'14151164',NULL,NULL,NULL,NULL,NULL),
 (68,'14151165',NULL,NULL,NULL,NULL,NULL),
 (69,'14151201',NULL,NULL,NULL,NULL,NULL),
 (70,'14151002',NULL,NULL,NULL,NULL,NULL),
 (71,'14151073',NULL,NULL,NULL,NULL,NULL),
 (72,'14151037',NULL,NULL,NULL,NULL,NULL),
 (73,'14151038',NULL,NULL,NULL,NULL,NULL),
 (74,'14151074',NULL,NULL,NULL,NULL,NULL),
 (75,'14151075',NULL,NULL,NULL,NULL,NULL),
 (76,'14151076',NULL,NULL,NULL,NULL,NULL),
 (77,'14151077',NULL,NULL,NULL,NULL,NULL),
 (78,'14151078',NULL,NULL,NULL,NULL,NULL),
 (79,'14151080',NULL,NULL,NULL,NULL,NULL),
 (80,'14151082',NULL,NULL,NULL,NULL,NULL),
 (81,'14151083',NULL,NULL,NULL,NULL,NULL),
 (82,'14151068',NULL,NULL,NULL,NULL,NULL),
 (83,'14151064',NULL,NULL,NULL,NULL,NULL),
 (84,'14151065',NULL,NULL,NULL,NULL,NULL),
 (85,'14151070',NULL,NULL,NULL,NULL,NULL),
 (86,'14151039',NULL,NULL,NULL,NULL,NULL),
 (87,'14151072',NULL,NULL,NULL,NULL,NULL),
 (88,'14151040',NULL,NULL,NULL,NULL,NULL),
 (89,'14151036',NULL,NULL,NULL,NULL,NULL),
 (90,'14151067',NULL,NULL,NULL,NULL,NULL),
 (91,'14151066',NULL,NULL,NULL,NULL,NULL),
 (92,'14151047',NULL,NULL,NULL,NULL,NULL),
 (93,'14151048',NULL,NULL,NULL,NULL,NULL),
 (94,'14151052',NULL,NULL,NULL,NULL,NULL),
 (95,'14151060',NULL,NULL,NULL,NULL,NULL),
 (96,'14151054',NULL,NULL,NULL,NULL,NULL),
 (97,'14151071',NULL,NULL,NULL,NULL,NULL),
 (98,'14151069',NULL,NULL,NULL,NULL,NULL),
 (99,'14151061',NULL,NULL,NULL,NULL,NULL),
 (100,'14151055',NULL,NULL,NULL,NULL,NULL),
 (101,'14151063',NULL,NULL,NULL,NULL,NULL),
 (102,'14151001',NULL,NULL,NULL,NULL,NULL),
 (103,'141510101',NULL,NULL,NULL,NULL,NULL),
 (104,'14151050',NULL,NULL,NULL,NULL,NULL),
 (105,'14151051',NULL,NULL,NULL,NULL,NULL),
 (106,'14151062',NULL,NULL,NULL,NULL,NULL),
 (107,'14151079',NULL,NULL,NULL,NULL,NULL),
 (108,'14151003',NULL,NULL,NULL,NULL,NULL),
 (109,'14151087',NULL,NULL,NULL,NULL,NULL),
 (110,'14151097',NULL,NULL,NULL,NULL,NULL),
 (111,'14151098',NULL,NULL,NULL,NULL,NULL),
 (112,'14151099',NULL,NULL,NULL,NULL,NULL),
 (113,'14151100',NULL,NULL,NULL,NULL,NULL),
 (114,'141511',NULL,NULL,NULL,NULL,NULL),
 (115,'141511110',NULL,NULL,NULL,NULL,NULL),
 (116,'14151202',NULL,NULL,NULL,NULL,NULL),
 (117,'14151253',NULL,NULL,NULL,NULL,NULL),
 (118,'14151081',NULL,NULL,NULL,NULL,NULL),
 (119,'141510117',NULL,NULL,NULL,NULL,NULL),
 (120,'141511122',NULL,NULL,NULL,NULL,NULL),
 (121,'141512110',NULL,NULL,NULL,NULL,NULL),
 (122,'14151315',NULL,NULL,NULL,NULL,NULL),
 (123,'14151555',NULL,NULL,NULL,NULL,NULL),
 (124,'141515585',NULL,NULL,NULL,NULL,NULL),
 (125,'141515559',NULL,NULL,NULL,NULL,NULL),
 (126,'141514584',NULL,NULL,NULL,NULL,NULL),
 (127,'1415145864',NULL,NULL,NULL,NULL,NULL),
 (128,'14151459841',NULL,NULL,NULL,NULL,NULL),
 (130,'161715001',NULL,NULL,NULL,NULL,NULL),
 (131,'16171157',NULL,NULL,NULL,NULL,NULL),
 (132,'16171491',NULL,NULL,NULL,NULL,NULL),
 (133,'16171489',NULL,NULL,NULL,NULL,NULL),
 (134,'16171487',NULL,NULL,NULL,NULL,NULL),
 (135,'16171484',NULL,NULL,NULL,NULL,NULL),
 (136,'16171515',NULL,NULL,NULL,NULL,NULL),
 (137,'16171480',NULL,NULL,NULL,NULL,NULL),
 (138,'16171477',NULL,NULL,NULL,NULL,NULL),
 (139,'16171178',NULL,NULL,NULL,NULL,NULL),
 (140,'16171173',NULL,NULL,NULL,NULL,NULL),
 (141,'16171220',NULL,NULL,NULL,NULL,NULL),
 (142,'16171169',NULL,NULL,NULL,NULL,NULL),
 (143,'16171187',NULL,NULL,NULL,NULL,NULL),
 (144,'16171167',NULL,NULL,NULL,NULL,NULL),
 (145,'16171221',NULL,NULL,NULL,NULL,NULL),
 (146,'16171226',NULL,NULL,NULL,NULL,NULL),
 (147,'16171186',NULL,NULL,NULL,NULL,NULL),
 (148,'1617115',NULL,NULL,NULL,NULL,NULL),
 (149,'1617130',NULL,NULL,NULL,NULL,NULL),
 (150,'1617131',NULL,NULL,NULL,NULL,NULL),
 (151,'17181415',NULL,NULL,NULL,NULL,NULL),
 (152,'17181416',NULL,NULL,NULL,NULL,NULL),
 (153,'17181417',NULL,NULL,NULL,NULL,NULL),
 (154,'17181418',NULL,NULL,NULL,NULL,NULL),
 (155,'17181419',NULL,NULL,NULL,NULL,NULL),
 (156,'17181420',NULL,NULL,NULL,NULL,NULL),
 (157,'17181421',NULL,NULL,NULL,NULL,NULL),
 (158,'171810421',NULL,NULL,NULL,NULL,NULL),
 (159,'17181422',NULL,NULL,NULL,NULL,NULL),
 (160,'171810422',NULL,NULL,NULL,NULL,NULL),
 (161,'17181423',NULL,NULL,NULL,NULL,NULL),
 (162,'17181424',NULL,NULL,NULL,NULL,NULL),
 (163,'17181425',NULL,NULL,NULL,NULL,NULL),
 (164,'17181426',NULL,NULL,NULL,NULL,NULL),
 (165,'17181427',NULL,NULL,NULL,NULL,NULL),
 (166,'17181428',NULL,NULL,NULL,NULL,NULL),
 (167,'17181429',NULL,NULL,NULL,NULL,NULL),
 (168,'17181430',NULL,NULL,NULL,NULL,NULL),
 (169,'17181431',NULL,NULL,NULL,NULL,NULL),
 (170,'17181432',NULL,NULL,NULL,NULL,NULL),
 (171,'17181433',NULL,NULL,NULL,NULL,NULL),
 (172,'17181434',NULL,NULL,NULL,NULL,NULL),
 (173,'17181435',NULL,NULL,NULL,NULL,NULL),
 (174,'17181436',NULL,NULL,NULL,NULL,NULL),
 (175,'17181437',NULL,NULL,NULL,NULL,NULL),
 (176,'17181438',NULL,NULL,NULL,NULL,NULL),
 (177,'17181439',NULL,NULL,NULL,NULL,NULL),
 (178,'17181440',NULL,NULL,NULL,NULL,NULL),
 (179,'17181441',NULL,NULL,NULL,NULL,NULL),
 (180,'17181442',NULL,NULL,NULL,NULL,NULL),
 (181,'17181451',NULL,NULL,NULL,NULL,NULL),
 (182,'17181011',NULL,NULL,NULL,NULL,NULL),
 (183,'171810111',NULL,NULL,NULL,NULL,NULL),
 (184,'18191201801',NULL,NULL,NULL,NULL,NULL),
 (185,'18191201802',NULL,NULL,NULL,NULL,NULL),
 (186,'18191201803',NULL,NULL,NULL,NULL,NULL),
 (187,'18191201804',NULL,NULL,NULL,NULL,NULL),
 (188,'18191201805',NULL,NULL,NULL,NULL,NULL),
 (189,'18191201806',NULL,NULL,NULL,NULL,NULL),
 (190,'18191201807',NULL,NULL,NULL,NULL,NULL),
 (191,'18191201808',NULL,NULL,NULL,NULL,NULL),
 (192,'18191201809',NULL,NULL,NULL,NULL,NULL),
 (193,'18191201810',NULL,NULL,NULL,NULL,NULL),
 (194,'18191201811',NULL,NULL,NULL,NULL,NULL),
 (195,'18191201812',NULL,NULL,NULL,NULL,NULL),
 (196,'18191201816',NULL,NULL,NULL,NULL,NULL),
 (197,'181912181817',NULL,NULL,NULL,NULL,NULL),
 (198,'18191201818',NULL,NULL,NULL,NULL,NULL),
 (199,'18191201819',NULL,NULL,NULL,NULL,NULL),
 (200,'18191201820',NULL,NULL,NULL,NULL,NULL),
 (201,'18191201821',NULL,NULL,NULL,NULL,NULL),
 (202,'18191201822',NULL,NULL,NULL,NULL,NULL),
 (203,'18191201823',NULL,NULL,NULL,NULL,NULL),
 (204,'18191201824',NULL,NULL,NULL,NULL,NULL),
 (205,'18191201825',NULL,NULL,NULL,NULL,NULL),
 (206,'18191201826',NULL,NULL,NULL,NULL,NULL),
 (207,'18191201827',NULL,NULL,NULL,NULL,NULL),
 (208,'18191201828',NULL,NULL,NULL,NULL,NULL),
 (209,'18191201829',NULL,NULL,NULL,NULL,NULL),
 (210,'18191201830',NULL,NULL,NULL,NULL,NULL),
 (211,'18191201831',NULL,NULL,NULL,NULL,NULL),
 (212,'18191201832',NULL,NULL,NULL,NULL,NULL),
 (213,'18191201833',NULL,NULL,NULL,NULL,NULL),
 (214,'18191201834',NULL,NULL,NULL,NULL,NULL),
 (215,'18191201835',NULL,NULL,NULL,NULL,NULL),
 (216,'18191201836',NULL,NULL,NULL,NULL,NULL),
 (217,'18191201837',NULL,NULL,NULL,NULL,NULL),
 (218,'18191201838',NULL,NULL,NULL,NULL,NULL),
 (219,'1819120140',NULL,NULL,NULL,NULL,NULL),
 (220,'181910007',NULL,NULL,NULL,NULL,NULL),
 (221,'1819100001',NULL,NULL,NULL,NULL,NULL),
 (222,'1819161702525',NULL,NULL,NULL,NULL,NULL),
 (223,'181912018',NULL,NULL,NULL,NULL,NULL),
 (224,'1819105',NULL,NULL,NULL,NULL,NULL);

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

--
-- Table structure for table `s_office_info`
--

CREATE TABLE IF NOT EXISTS `s_office_info` (
  `s_office_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `admission_status` varchar(45) DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `admission_type` varchar(45) DEFAULT NULL,
  `transfer_narration` varchar(500) DEFAULT NULL,
  `paid_fee_per` varchar(45) DEFAULT NULL,
  `is_rte_student` varchar(45) DEFAULT NULL,
  `caste_wise_fee` varchar(45) DEFAULT NULL,
  `caste_fee_details_id` int(10) DEFAULT NULL,
  `is_scholarship` varchar(45) DEFAULT NULL,
  `scholarship_amount` varchar(45) DEFAULT NULL,
  `scholarship_student_amount` varchar(45) DEFAULT NULL,
  `scholarship_pending_student_amount` varchar(45) DEFAULT NULL,
  `goverment_pending_amount` varchar(45) DEFAULT NULL,
  `scholarship_paid_student_amount` varchar(45) DEFAULT NULL,
  `goverment_paid_amount` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_office_info_id`),
  KEY `FK_s_office_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `s_office_info`
--

INSERT INTO `s_office_info` (`s_office_info_id`, `s_personal_info_id`, `s_total_fee`, `s_paid_fee`, `s_pending_fee`, `s_payment_date`, `s_standard`, `s_concession`, `give_concession`, `concession_reason`,
 `goverment_pending_amount`, `admission_date`, `scholarship`, `scholarship_pending`, `admission_status`, `admission_type`,`scholarship_amount`, `goverment_paid_amount`,`scholarship_pending_student_amount`,`scholarship_student_amount`) VALUES

 (2,'14151101',3807,5365,-1558,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (4,'14151102',3807,5922,-2115,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (5,'14151103',3807,0,3807,NULL,'THIRD','0.0',NULL,NULL,'54393.0','2014-06-15','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (6,'14151104',31004,17485,13519,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'Regular','First Shift','0','0','0','0'),
 (7,'14151105',31004,4665,26339,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (8,'14151106',31004,3615,27389,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (9,'14151107',58200,58200,0,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (10,'14151108',58200,20615,37585,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (11,'14151109',58200,2115,56085,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (12,'14151110',58200,3115,55085,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (13,'14151111',58200,11865,46335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (14,'14151112',58200,6865,51335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (15,'14151113',58200,27365,30835,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (16,'14151114',58200,2865,55335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (17,'14151115',58200,7365,50835,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (19,'14151117',58200,7615,50585,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (20,'14151118',58200,60315,-2115,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (21,'14151119',58200,60315,-2115,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (22,'14151120',58200,11865,46335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (23,'14151121',58200,2615,55585,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (24,'14151122',58200,3730,54470,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (25,'14151116',58200,12865,45335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-13','EBC','Not Selected',NULL,'First Shift','0','0','0','0'),
 (27,'14151123',7000,4615,2385,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (28,'14151124',7000,2365,4635,NULL,'THIRD','0.0',NULL,NULL,'60200.0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (29,'14151125',7000,7985,-985,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (30,'14151126',7000,2365,4635,NULL,'THIRD','0.0',NULL,NULL,'60200.0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (31,'14151127',37100,7865,29235,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (32,'14151128',37100,6365,30735,NULL,'THIRD','0.0',NULL,NULL,'30100.0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (33,'14151129',37100,3615,33485,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (34,'1415130',67200,11865,55335,NULL,'THIRD','0.0',NULL,NULL,NULL,'2014-02-11',NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (35,'1415131',67200,22365,44835,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (36,'1415132',67200,1865,65335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (37,'1415133',67200,4115,63085,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (38,'14151134',67200,16615,50585,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (39,'14151135',67200,7365,59835,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (40,'14151136',67200,4165,63035,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (41,'1415137',67200,2565,64635,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (42,'1415138',67200,11865,55335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (43,'14151139',67200,8000,59200,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (44,'1415140',67200,11615,55585,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (45,'1415141',7000,6735,265,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (46,'1415142',67200,22365,44835,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (47,'1415143',67200,12365,54835,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (48,'14151144',67200,1865,65335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (49,'14151146',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','2013-08-05','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (50,'14151147',67200,2065,65135,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (51,'14151148',67200,2615,64585,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (52,'14151149',67200,4730,62470,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (53,'14151150',67200,17115,50085,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (54,'14151151',67200,15000,52200,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (55,'14151152',67200,12235,54965,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (56,'14151153',67200,21865,45335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (57,'14151154',67200,3700,63500,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (58,'14151155',67200,2865,64335,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (59,'14151156',67200,12115,55085,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (60,'14151157',67200,6865,60335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (61,'14151158',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (62,'14151159',67200,5000,62200,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (63,'14151160',67200,26865,40335,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (64,'14151161',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (65,'14151162',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (66,'141511653',67200,32235,34965,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-16','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (67,'14151164',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','2014-06-23','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (68,'14151165',67200,5615,61585,NULL,'THIRD','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (69,'14151201',67200,36615,30585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (70,'14151002',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','2014-07-02','EBC','Not Applicable',NULL,'First Shift','0','0','0','0'),
 (71,'14151073',7000,8615,-1615,NULL,'SECOND','0','No','',NULL,NULL,'Not Applicable','Not Applicable',NULL,'First Shift','0','0','0','0'),
 (72,'14151037',7000,3615,3385,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (73,'14151038',31004,15615,15389,NULL,'FIRST','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (74,'14151074',7000,8615,-1615,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (75,'14151075',37100,21615,15485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (76,'14151076',67200,31615,35585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (77,'14151077',37100,6615,30485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (78,'14151078',37100,11615,25485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (79,'14151080',67200,0,97785,NULL,'Third','0','No',NULL,'0',NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (80,'14151082',7000,2615,4385,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (81,'14151083',7000,1000,6000,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (82,'14151068',67200,11615,55585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (83,'14151064',67200,6615,60585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (84,'14151065',67200,3615,63585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (85,'14151070',7000,4615,2385,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (86,'14151039',37100,17000,20100,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (87,'14151072',67200,16615,50585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (88,'14151040',67200,31615,35585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (89,'14151036',7000,8615,-1615,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (90,'14151067',67200,6615,60585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (91,'14151066',67200,6615,60585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (92,'14151047',37100,15615,21485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (93,'14151048',7000,1615,5385,NULL,'SECOND','0.0',NULL,NULL,'54393.0','2014-07-31','Scholorship','Not Applicable',NULL,'First Shift','0','0','0','0'),
 (94,'14151052',67200,41615,25585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (95,'14151060',67200,1705,65495,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'Regular','First Shift','0','0','0','0'),
 (96,'14151054',67200,26615,40585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (97,'14151071',37100,6615,30485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (98,'14151069',37100,6615,30485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (99,'14151061',67200,11615,55585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (100,'14151055',37100,16615,20485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (101,'14151063',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','2014-07-31','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (102,'14151001',67200,12980,54220,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (103,'141510101',37100,6615,30485,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (104,'14151050',67200,11615,55585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (105,'14151051',67200,10615,56585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (106,'14151062',67200,7615,59585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (107,'14151079',67200,11615,55585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (108,'14151003',67200,0,67200,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (109,'14151087',67200,20615,46585,NULL,'SECOND','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (110,'14151097',37100,4000,33100,NULL,'SECOND','0.0',NULL,NULL,'27196.5','19-06-2014','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (111,'14151098',67200,5000,62200,NULL,'SECOND','0.0',NULL,NULL,'0','19-06-2014','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (112,'14151099',67200,21615,45585,NULL,'SECOND','0.0',NULL,NULL,'0','24-09-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (113,'14151100',67200,9000,58200,NULL,'SECOND','0.0',NULL,NULL,'0','01-07-2014','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (114,'141511',58200,530,57670,NULL,'THIRD','0.0',NULL,NULL,'0','15-07-2010','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (115,'141511110',7000,2165,4835,NULL,'SECOND','0.0',NULL,NULL,'54393.0','25-10-2014','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (116,'14151202',67200,0,67200,NULL,'THIRD','0.0',NULL,NULL,'0','13-08-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (117,'14151253',67200,780,66420,NULL,'THIRD','0.0',NULL,NULL,'0','13-08-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (118,'14151081',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','07-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (119,'141510117',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','07-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (120,'141511122',58200,530,57670,NULL,'FIRST','0.0',NULL,NULL,'0','03-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (121,'141512110',58200,0,58200,NULL,'THIRD','0.0',NULL,NULL,'0','05-10-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (122,'14151315',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','05-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (123,'14151555',67200,1615,65585,NULL,'SECOND','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (124,'141515585',67200,1780,65420,NULL,'SECOND','0.0',NULL,NULL,'0','08-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (125,'141515559',31004,1030,29974,NULL,'FIRST','0.0',NULL,NULL,'27196.5','07-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (126,'141514584',31004,530,30474,NULL,'SECOND','0.0',NULL,NULL,'27196.5','16-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (127,'1415145864',58200,780,57420,NULL,'THIRD','0.0',NULL,NULL,'0','11-10-2014','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (128,'14151459841',58200,0,58200,NULL,'SECOND','0.0',NULL,NULL,'0','17-10-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (130,'161715001',71000,0,71000,NULL,'FIRST','0.0',NULL,NULL,'0','23-11-2016','Scholorship','Not Applicable',NULL,NULL,'0','0','0','0'),
 (131,'16171157',41826,2893,38933,NULL,'THIRD','0.0',NULL,NULL,'35500.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (132,'16171491',41826,10000,31826,NULL,'THIRD','0.0',NULL,NULL,'35500.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (133,'16171489',76680,60000,58360,NULL,'Third','0','No',NULL,'0','28-09-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (134,'16171487',76680,0,76680,NULL,'SECOND','0.0',NULL,NULL,'0','09-08-2016','Not Selected','Not Applicable',NULL,NULL,'0','0','0','0'),
 (135,'16171484',76680,76680,42097,NULL,'Third','0','No',NULL,'0','28-09-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (136,'16171515',76680,76680,41827,NULL,'Third','0','No',NULL,'0','28-09-2016','EBC','Apply','New','First Shift','0','0','0','0'),
 (137,'16171480',6971,6971,6971,NULL,'Third','0','No',NULL,'0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (138,'16171477',76680,40000,113360,NULL,'Third','0','No',NULL,'0','14-10-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (139,'16171178',71000,16136,54864,NULL,'Third','0','No',NULL,'0','02-08-2016','EBC','Apply','New','First Shift','0','0','0','0'),
 (140,'16171173',71000,71000,71000,NULL,'Third','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (141,'16171220',6455,6455,8200,NULL,'Third','0','No',NULL,'0','22-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (142,'16171169',71000,71000,71000,NULL,'Third','0','No',NULL,'0','15-07-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (143,'16171187',38728,10000,28728,NULL,'FIRST','0.0',NULL,NULL,'35500.0','05-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (144,'16171167',71000,47272,94728,NULL,'Third','0','No',NULL,'0','15-07-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (145,'16171221',71000,50000,92000,NULL,'Third','0','No',NULL,'0','22-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (146,'16171226',6455,0,6455,NULL,'FIRST','0.0',NULL,NULL,'71000.0','27-09-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (147,'16171186',71000,10000,61000,NULL,'FIRST','0.0',NULL,NULL,'0','05-07-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (148,'1617115',6455,6455,6455,NULL,'Second','0','No',NULL,'0','24-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (149,'1617130',76680,34855,83650,NULL,'Third','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (150,'1617131',6971,6971,0,NULL,'THIRD','0.0',NULL,NULL,'71000.0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (151,'17181415',25000,25000,0,NULL,'Second','0','No',NULL,'0','02-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (152,'17181416',25000,25000,17550,NULL,'Second','0','No',NULL,'0','02-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (153,'17181417',25000,25000,1745,NULL,'Second','0','No',NULL,'0','02-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (154,'17181418',25000,24999,4001,NULL,'Second','0','No',NULL,'0','02-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (155,'17181419',2273,2273,0,NULL,'FIRST','0.0',NULL,NULL,'25000.0','03-08-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (156,'17181420',2273,2273,0,NULL,'FIRST','0.0',NULL,NULL,'25000.0','03-08-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (157,'17181421',25000,16864,8136,NULL,'FIRST','0.0',NULL,NULL,'0','03-08-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (158,'171810421',25000,5000,20000,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (159,'17181422',25000,5681,19319,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (160,'171810422',25000,25000,0,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (161,'17181423',13637,13636,2,NULL,'Second','0','No',NULL,'0','04-08-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (162,'17181424',25000,24999,1,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (163,'17181425',25000,25000,0,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (164,'17181426',13637,6000,7638,NULL,'Second','0','No',NULL,'0','04-08-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (165,'17181427',25000,20000,5000,NULL,'Second','0','No',NULL,'0','04-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (166,'17181428',2273,0,2273,NULL,'FIRST','0.0',NULL,NULL,'25000.0','04-08-2017','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (167,'17181429',25000,25000,0,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (168,'17181430',2273,2273,0,NULL,'FIRST','0.0',NULL,NULL,'25000.0','05-08-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (169,'17181431',25000,25000,0,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (170,'17181432',2273,0,2273,NULL,'FIRST','0.0',NULL,NULL,'25000.0','05-08-2017','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (171,'17181433',25000,5682,19318,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (172,'17181434',25000,25000,0,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (173,'17181435',25000,5681,19319,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (174,'17181436',25000,18363,6637,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (175,'17181437',2273,0,2273,NULL,'FIRST','0.0',NULL,NULL,'25000.0','05-08-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (176,'17181438',25000,25000,0,NULL,'Second','0','No',NULL,'0','05-08-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (177,'17181439',25000,0,25000,NULL,'FIRST','0.0',NULL,NULL,'0','14-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (178,'17181440',25000,20200,4800,NULL,'Second','0','No',NULL,'0','14-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (179,'17181441',25000,25000,0,NULL,'Second','0','No',NULL,'0','16-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (180,'17181442',25000,10000,19500,NULL,'Second','0','No',NULL,'0','16-08-2017','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (181,'17181451',6971,-945,7916,NULL,'THIRD','0.0',NULL,NULL,'69709','11-09-2017','Scholorship','Apply','New','First Shift','69709','0','69709','76680.0'),
 (182,'17181011',6455,0,6455,NULL,'SECOND','0.0',NULL,NULL,'64545','29-11-2017','Scholorship','Apply',NULL,NULL,'64545','0','64545','71000.0'),
 (183,'171810111',6971,6971,0,NULL,'THIRD','0.0',NULL,NULL,'69709','30-11-2017','Scholorship','Apply','New','First Shift','69709','0','69709','76680.0'),
 (184,'18191201801',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','28-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (185,'18191201802',42500,41725,775,NULL,'FIRST','0.0',NULL,NULL,'39063','28/07/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (186,'18191201803',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','28-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (187,'18191201804',42500,32735,9765,NULL,'FIRST','0.0',NULL,NULL,'39063','27/07/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (188,'18191201805',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'0.0','27/07/2018','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (189,'18191201806',42500,0,42500,NULL,'FIRST','0.0',NULL,NULL,'39063','27-07-2018','EBC','Apply',NULL,NULL,'19531','0','19531','42500'),
 (190,'18191201807',3437,3437,0,NULL,'FIRST','0.0',NULL,NULL,'39063','30/07/2018','Scholorship','Apply','New','First Shift','39063','0','39063','42500.0'),
 (191,'18191201808',22969,22969,0,NULL,'FIRST','0.0',NULL,NULL,'39063','27-07-2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (192,'18191201809',22969,22969,0,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (193,'18191201810',42500,22969,19531,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (194,'18191201811',42500,22969,19531,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (195,'18191201812',22969,22950,19,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (196,'18191201816',22969,8450,14519,NULL,'FIRST','0.0',NULL,NULL,'39063','31/07/2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (197,'181912181817',42500,37254,5246,NULL,'FIRST','0.0',NULL,NULL,'39063','31/07/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (198,'18191201818',42500,37981,4519,NULL,'FIRST','0.0',NULL,NULL,'39063','31/07/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (199,'18191201819',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','31/07/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (200,'18191201820',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (201,'18191201821',42500,0,42500,NULL,'FIRST','0.0',NULL,NULL,'39063','01/08/2018','EBC','Apply',NULL,NULL,'19531','0','19531','42500'),
 (202,'18191201822',42500,30982,11518,NULL,'FIRST','0.0',NULL,NULL,'39063','01/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (203,'18191201823',42500,13450,29050,NULL,'FIRST','0.0',NULL,NULL,'0','01/08/2018','Scholorship','Apply','New','First Shift',NULL,'0',NULL,'0.0'),
 (204,'18191201824',42500,32734,9766,NULL,'FIRST','0.0',NULL,NULL,'39063','01/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (205,'18191201825',42500,17450,25050,NULL,'FIRST','0.0',NULL,NULL,'39063','01/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (206,'18191201826',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','03/08/2018','EBC','Apply','Regular','First Shift','19531','0','19531','42500'),
 (207,'18191201827',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','02/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (208,'18191201828',42500,42500,0,NULL,'FIRST','0.0',NULL,NULL,'39063','07/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (209,'18191201829',42500,32735,9765,NULL,'FIRST','0.0',NULL,NULL,'39063','08/08/2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (210,'18191201830',22969,22969,0,NULL,'FIRST','0.0',NULL,NULL,'39063','08-08-2018','Scholorship','Apply','New','First Shift','19531','17969','0','22969.0'),
 (211,'18191201831',42500,32735,9765,NULL,'FIRST','0.0',NULL,NULL,'39063','10-08-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (212,'18191201832',22969,22969,0,NULL,'FIRST','0.0',NULL,NULL,'39063','10-08-2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (213,'18191201833',42500,36959,5541,NULL,'FIRST','0.0',NULL,NULL,'39063','10-08-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (214,'18191201834',22969,15000,7969,NULL,'FIRST','0.0',NULL,NULL,'19531.0','10-08-2018','Scholorship','Not Applicable','New','First Shift','0','0','0','0'),
 (215,'18191201835',22969,22969,0,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','Scholorship','Apply','New','First Shift','19531','0','19531','22969.0'),
 (216,'18191201836',42500,5000,37500,NULL,'FIRST','0.0',NULL,NULL,'39063','30-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (217,'18191201837',42500,0,42500,NULL,'FIRST','0.0',NULL,NULL,'39063','31-07-2018','EBC','Apply','New','First Shift','19531','0','19531','42500'),
 (218,'18191201838',42500,10000,32500,NULL,'FIRST','0.0',NULL,NULL,'0.0','31-08-2018','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (219,'1819120140',42500,42000,500,NULL,'FIRST','0.0',NULL,NULL,'0.0','16-07-2018','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (220,'181910007',42500,19531,22969,NULL,'FIRST','0.0',NULL,NULL,'39063','16-10-2018','EBC','Apply','Regular','First Shift','19531','0','19531','42500'),
 (221,'1819100001',71000,32272,38728,NULL,'THIRD','0.0',NULL,NULL,'64545','21-08-2018','EBC','Apply','New','First Shift','32272','0','32272','71000'),
 (222,'1819161702525',71000,2855,68145,NULL,'THIRD','0.0',NULL,NULL,'64545','16-07-2018','EBC','Apply','Regular','First Shift','32272','0','32272','71000'),
 (223,'181912018',25000,5682,19318,NULL,'SECOND','0.0',NULL,NULL,'22727','26-09-2018','EBC','Apply','Regular','First Shift','11363','0','11363','25000'),
 (224,'1819105',71000,32272,38728,NULL,'THIRD','0.0',NULL,NULL,'64545','16-07-2018','EBC','Apply','New','First Shift','32272','0','32272','71000');
-- --------------------------------------------------------

--
-- Table structure for table `s_other_fee`
--

CREATE TABLE IF NOT EXISTS `s_other_fee` (
  `s_other_fee_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_other_fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_other_fee_history`
--

CREATE TABLE IF NOT EXISTS `s_other_fee_history` (
  `s_other_fee_history_id` int(10) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_other_fee_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_personal_info`
--

CREATE TABLE IF NOT EXISTS `s_personal_info` (
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_academic_year` varchar(10) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_branch_type` varchar(45) DEFAULT NULL,
  `s_form_number` int(10) UNSIGNED DEFAULT NULL,
  `s_first_name` varchar(100) DEFAULT NULL,
  `s_middle_name` varchar(100) DEFAULT NULL,
  `s_last_name` varchar(100) DEFAULT NULL,
  `s_mother_name` varchar(100) DEFAULT NULL,
  `s_mother_tongue` varchar(100) DEFAULT NULL,
  `s_dob` date DEFAULT NULL,
  `s_age` int(10) UNSIGNED DEFAULT NULL,
  `s_gender` varchar(15) DEFAULT NULL,
  `s_nationality` varchar(15) DEFAULT NULL,
  `s_religion` varchar(45) DEFAULT NULL,
  `s_caste` varchar(45) DEFAULT NULL,
  `s_subcaste` varchar(45) DEFAULT NULL,
  `s_laddr_line1` varchar(100) DEFAULT NULL,
  `s_laddr_line2` varchar(100) DEFAULT NULL,
  `s_laddr_line3` varchar(100) DEFAULT NULL,
  `s_laddr_city` varchar(100) DEFAULT NULL,
  `s_laddr_state` varchar(100) DEFAULT NULL,
  `s_laddr_zipcode` varchar(15) DEFAULT NULL,
  `s_paddr_line1` varchar(100) DEFAULT NULL,
  `s_paddr_line2` varchar(100) DEFAULT NULL,
  `s_paddr_line3` varchar(100) DEFAULT NULL,
  `s_paddr_city` varchar(100) DEFAULT NULL,
  `s_paddr_state` varchar(100) DEFAULT NULL,
  `s_paddr_zipcode` varchar(15) DEFAULT NULL,
  `s_local_landline` varchar(15) DEFAULT NULL,
  `s_permanent_landline` varchar(15) DEFAULT NULL,
  `s_mobile1` varchar(15) DEFAULT NULL,
  `s_father_mobile` varchar(15) DEFAULT NULL,
  `s_mother_mobile` varchar(15) DEFAULT NULL,
  `s_guardian_name` varchar(100) DEFAULT NULL,
  `s_guardian_mobile` varchar(15) DEFAULT NULL,
  `s_residence_type` varchar(45) DEFAULT NULL,
  `s_transport_type` varchar(45) DEFAULT NULL,
  `s_email` varchar(100) DEFAULT NULL,
  `is_rural_urban` varchar(100) DEFAULT NULL,
  `s_no_of_siblings` varchar(2) DEFAULT NULL,
  `s_father_occupation` varchar(100) DEFAULT NULL,
  `s_mother_occupation` varchar(100) DEFAULT NULL,
  `s_gross_annual_family_income` varchar(100) DEFAULT NULL,
  `s_gr_number` varchar(45) DEFAULT NULL,
  `s_birth_place` varchar(100) DEFAULT NULL,
  `eligibility_no` varchar(100) DEFAULT NULL,
  `pattern_name` varchar(100) DEFAULT NULL,
  `roll_no` varchar(45) DEFAULT NULL,
  `s_mobile_no` varchar(20) DEFAULT NULL,
  `s_uid_no` varchar(45) DEFAULT NULL,
  `s_taluka` varchar(45) DEFAULT NULL,
  `s_district` varchar(45) DEFAULT NULL,
  `u_idno` varchar(45) DEFAULT NULL,
  `s_password` varchar(255) DEFAULT NULL,
  `app_token` varchar(255) DEFAULT NULL,
  `s_status` varchar(45) DEFAULT NULL,
  `is_society_bus_applied` varchar(45) DEFAULT NULL,
  `is_subscribed` varchar(45) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `s_personal_info`
--

INSERT INTO `s_personal_info` (`s_personal_info_id`,`s_academic_year`,`s_section`,`s_form_number`,`s_first_name`,`s_middle_name`,`s_last_name`,`s_mother_name`,`s_dob`,`s_age`,`s_gender`,`s_religion`,`s_caste`,`s_laddr_line1`,`s_laddr_line2`,`s_laddr_line3`,`s_laddr_city`,`s_laddr_state`,`s_laddr_zipcode`,`s_paddr_line1`,`s_paddr_line2`,`s_paddr_line3`,`s_paddr_city`,`s_paddr_state`,`s_paddr_zipcode`,`s_local_landline`,`s_permanent_landline`,`s_mobile1`,`s_father_mobile`,`s_mother_mobile`,`s_guardian_name`,`s_guardian_mobile`,`s_residence_type`,`s_transport_type`,`s_email`,`s_no_of_siblings`,`s_father_occupation`,`s_birth_place`,`s_subcaste`,`s_nationality`) VALUES 
 ('14151101','2014-15','MCA',101,'Vasant','Tulshi','Katake',NULL,NULL,NULL,'Male',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale',NULL),
 ('14151102','2014-15','MCA',102,' Pooja ','Umakant','Tannu',NULL,NULL,NULL,'Female',NULL,'SBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Ahir koly',NULL),
 ('14151103','2014-15','MCA',103,'Rohit',' Limbraj','Kshirsagar ',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aarava Mala',NULL),
 ('14151104','2014-15','MCA',104,' Dayanada ','Narayan','Pawar',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale',NULL),
 ('14151105','2014-15','MCA',105,' Anup ','Dadaram','Sapkal',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale',NULL),
 ('14151106','2014-15','MCA',106,' Umesh ','Shivaj','Thakare',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale',NULL),
 ('14151107','2014-15','MCA',107,' Milson ','','Banjare',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'chambar',NULL),
 ('14151108','2014-15','MCA',108,' Kishor  ','Vilas','Kolhe',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'chambar',NULL),
 ('14151109','2014-15','MCA',109,' Renuka ','Subhash','Patil',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151110','2014-15','MCA',110,' Girija ','SHAHAJI','Dhumal',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151111','2014-15','MCA',111,' Sudarshan ','Sandipan','Wadwale',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151112','2014-15','MCA',112,' Sagar ','Maruti','Nalawade',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151113','2014-15','MCA',113,' Priyanka ','Dilip','Jagatap',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151114','2014-15','MCA',114,'Nikhil ','Rajendra','Gund ',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151115','2014-15','MCA',115,' Prasad ','Sambhaji','Dhabale',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151116','2014-15','MCA',116,'Suraj','Dattatray','Patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151117','2014-15','MCA',117,' Nachiket ','Suresh','Nangare',NULL,'1992-01-03',22,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'','bramin',NULL),
 ('14151118','2014-15','MCA',118,' Bhairu ','Apparam','Mule',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151119','2014-15','MCA',119,'Anil ','Anadrao','Narawade ',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151120','2014-15','MCA',120,' Nikhil ','','Karande',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151121','2014-15','MCA',121,' Aniket','','Shitole',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151122','2014-15','MCA',122,'Asmita','','Kindre ',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151123','2014-15','MCA',123,' ABHIJIT ','RAMCHANDRA','BHOI',NULL,NULL,NULL,'Male',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale',NULL),
 ('14151124','2014-15','MCA',124,' SANJAY ','HARICHANDRA','PAWAR ',NULL,NULL,NULL,'Male',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale',NULL),
 ('14151125','2014-15','MCA',125,' SAYALI','ASHOK','NIMJE',NULL,NULL,NULL,'Female',NULL,'SBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Ahir koly',NULL),
 ('14151126','2014-15','MCA',126,' CHAITALI ','SHIVAJI','MANDULE',NULL,NULL,NULL,'Female',NULL,'SBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Ahir koly',NULL),
 ('14151127','2014-15','MCA',127,' VINODINEE ','POPAT','KORE',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
 ('14151128','2014-15','MCA',128,'PARFULLA ','GULABRAO','SARODE ',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale',NULL),
 ('14151129','2014-15','MCA',129,'PRAJAKTA ','ASHOK','BHAMBURE ',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale',NULL),
 ('1415130','2014-15','MCA',30,'SHIVANI','RAJENDRA','KALWAGE',NULL,'1996-04-04',0,'Female','test','OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',''),
 ('1415131','2014-15','MCA',31,'ULKA','LAXMAN','TARALE',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415132','2014-15','MCA',32,'EKNATH','UDHAN','TAKE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415133','2014-15','MCA',33,' ADITYA ','VIJAY','DHAGE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151134','2014-15','MCA',134,'THRUPTI','MADUKAR','BHURUK',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151135','2014-15','MCA',135,'MAHESH','SHASHIKANT','GHOGARE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151136','2014-15','MCA',136,'AMIT','SANJAY','MORE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415137','2014-15','MCA',37,'GAJANAN','BABURAO','KUTE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415138','2014-15','MCA',38,'OMKAR','KASHINATH','UTTEKAR',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151139','2014-15','MCA',139,'ROHIT','MOHAN','THOPTE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415140','2014-15','MCA',40,'AMIT','ANKUSH','AMARALE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415141','2014-15','MCA',41,'AJINKYA','PRADIP','RATHOD',NULL,NULL,NULL,'Male',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale',NULL),
 ('1415142','2014-15','MCA',42,'HIMANSHU','KISHOR','JOSHI',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('1415143','2014-15','MCA',43,'JAYSHREE','PANDURANG','KIRDAT',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151144','2014-15','MCA',144,'SURAJ','UMASHANKAR','MISHRA',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151146','2014-15','MCA',146,'NIRMAL','KUNDANLAL','SAINI','','1992-11-21',23,'Male','','OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'',' Fulmali',NULL),
 ('14151147','2014-15','MCA',147,'MAYURI','SURESH','SHIRKE',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
 ('14151148','2014-15','MCA',148,'YOGESH','NITIN','GAIKWAD',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
 ('14151149','2014-15','MCA',149,'DARSHANKUMAR','','SONWANE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151150','2014-15','MCA',150,'NITIN','RAJENDRA','BARI',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151151','2014-15','MCA',151,'PRASHANT','BHIVAJI','LONDHE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151152','2014-15','MCA',152,'ROSHAN','ARJU','ROHARA',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151153','2014-15','MCA',153,'ASHWINI','ARVIND','KALE',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151154','2014-15','MCA',154,' SANDEEP ','NITIN','LOKHANDE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151155','2014-15','MCA',155,'I NIKHIL ','SURESH','TRIVED',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151156','2014-15','MCA',156,' MAYURI ','NAGNATH','GODSE',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151157','2014-15','MCA',157,'KAJOL','SHANKAR','THORAT',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151158','2014-15','MCA',158,'SAGAR','RAMCHANDRA','UPHALE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151159','2014-15','MCA',159,'AKSHAY','C','GIRGUNE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151160','2014-15','MCA',160,'SONALI','POPAT','KONDE','','1991-06-01',23,'Female','','OPEN','','','','','','','','','','','','','','','','','','','',NULL,NULL,'','','','','bramin',NULL),
 ('14151161','2014-15','MCA',161,'ABASAHEB','','CHATALE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151162','2014-15','MCA',162,'SWAPNIL','','SONVANE',NULL,NULL,0,'Male','Indian','OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',''),
 ('141511653','2013-14','MCA',1653,'SHANKAR ','LAXMAN','SHIROLE',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151164','2014-15','MCA',164,'YOGESH','SUBHASH','VEDPHATAK',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151165','2014-15','MCA',165,'SUDAM','APPASAHEB','JADHAV',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin',NULL),
 ('14151201','2014-15','MCA',201,'ROHIT','PRADIP','SHELAR',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha',NULL),
 ('14151002','2014-15','MCA',2,'Fayaj','Jafarmiyan','Maniyar',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fayaj.Fm786@gmail.com',NULL,NULL,NULL,'Islam-Muslim',NULL),
 ('14151073','2014-15','MCA',73,'Gaurav','Vijay','Sapar',NULL,NULL,NULL,'Male',NULL,'SBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gaurav-sapar@yahoo.com',NULL,NULL,NULL,'Swakul Saly','Indian'),
 ('14151037','2014-15','MCA',37,'Nilesh','Bhima','Katke',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'Indian'),
 ('14151038','2014-15','MCA',38,'Pravin','Balkrushna','Datir',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale','Indian'),
 ('14151074','2014-15','MCA',74,'Vrushali','Hiralal','Raut',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Eaur.Vrushali@gmail.com',NULL,NULL,NULL,'Mahar','Indian'),
 ('14151075','2014-15','MCA',75,'Venkatesh','Hanaslal','Rane',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'venkateshrane1@gmail.com',NULL,NULL,NULL,'Powar or pawar','Indian'),
 ('14151076','2014-15','MCA',76,'Spruha','Shamkant','Ukidave',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'spruha123@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151077','2014-15','MCA',77,'Raza Khan','Nazir','Khan','','1993-08-03',21,'Male','','OBC','','','','','','','','','','','','','','','','','','','',NULL,NULL,'razakhan808@gmail.com','','','','Musleem Bhand',NULL),
 ('14151078','2014-15','MCA',78,'Ravindra','Machhindra','Kokate',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ravikumarkokate@gmail.com',NULL,NULL,NULL,'Mahil','Indian'),
 ('14151080','2015-16','MCA',80,'Madhura','Anil','Deodhar',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','Indian'),
 ('14151082','2014-15','MCA',82,'Rohit','Dharma','Shinde',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Rohitshinde638@gmail.com',NULL,NULL,NULL,'Mang','Indian'),
 ('14151083','2014-15','MCA',83,'Arati','Babu','Mhaske',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'aratimhaske@yahoo.com',NULL,NULL,NULL,'NEW BUDDHA','Indian'),
 ('14151068','2014-15','MCA',68,'Vaibhav','Prakash','Kulkarni',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vaibhavkulkarni12@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151064','2014-15','MCA',64,'Rahul','Amit','Sharma',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rAHULAMITSHARMA@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('14151065','2014-15','MCA',65,'Aniruddha','Chandrakant','Patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ani66.patil@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151070','2014-15','MCA',70,'Akshay','Arvind','Lokhande',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Akshaylokhande143@gmail.com',NULL,NULL,NULL,'Mahar','Indian'),
 ('14151039','2014-15','MCA',39,'Harshada','Sheshrao ','Gaikwad',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pavybhosale@gmail.com',NULL,NULL,NULL,'Malee','Indian'),
 ('14151072','2014-15','MCA',72,'Dhiraj','Maruti','Gogwale',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','Indian'),
 ('14151040','2014-15','MCA',40,'Tejas','Vinod','Kulkarni',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tvk.tejas@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151036','2014-15','MCA',36,'Sonal ','Rajendra','Gaikwad',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sonalgaikwad68@gmail.com',NULL,NULL,NULL,'Aarava Mala','Indian'),
 ('14151067','2014-15','MCA',67,'Shital','Hanumant','Gaikwad',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shitalgaikwad021@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151066','2014-15','MCA',66,'Raviraj','Bhagwan','Tate',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tateraviraj@yahoo.com',NULL,NULL,NULL,'maratha','Indian'),
 ('14151047','2014-15','MCA',47,'Mayuri','Vishnu','Phalle',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mayuri.phalke@gmail.com',NULL,NULL,NULL,'Telee','Indian'),
 ('14151048','2014-15','MCA',48,'Gauri','Bhimrao','Kamble',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gaurid.pawar@gmail.com',NULL,NULL,NULL,'chamar','Indian'),
 ('14151052','2014-15','MCA',52,'Sikandar','Afsar','Shekh',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sikandarshaikh191@gmail.com',NULL,NULL,NULL,'Islam-Muslim','Indian'),
 ('14151060','2014-15','MCA',60,'Azhar','Rafiq','Majkure','','1993-08-17',21,'Male','','OPEN','','','','','','','','','','','','','','','','','','','',NULL,NULL,'Azarmalkuew@gmail.com','','','','Islam-Muslim',NULL),
 ('14151054','2014-15','MCA',54,'Vaibhav','Kishor','Agrawal',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'agrawal.vaibhav24@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151071','2014-15','MCA',71,'Yogesh','Ganesh','Khollam',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yogesh7860@gmail.com',NULL,NULL,NULL,'Sonar','Indian'),
 ('14151069','2014-15','MCA',69,'Yogesh','Anant','Baikar',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'YOGESHBAIKAR11@Gmail.com',NULL,NULL,NULL,'Kunabee','Indian'),
 ('14151061','2014-15','MCA',61,'Vaibhav','Kailas','Salunke',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salunkevk10@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('14151055','2014-15','MCA',55,'Hemant','Dilip','Bhadane',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hemant_9604@yahoo.com',NULL,NULL,NULL,'Kunabee','Indian'),
 ('14151063','2014-15','MCA',63,'Amol','Attam','Mane',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'amol.mane91@gamil.com',NULL,NULL,NULL,'maratha','Indian'),
 ('14151001','2014-15','MCA',1,'Chetan','Vikas','Mangade',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mangadeehetan123@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('141510101','2014-15','MCA',101,'Pratibha','','Suryawanshi',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0','Indian'),
 ('14151050','2014-15','MCA',50,'Shailesh','Devedas','Bari',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nbarishailesh@gamil.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151051','2014-15','MCA',51,'Deepali','Dinkar','Phadtare',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'phadtaredeepali@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151062','2014-15','MCA',62,'Shweta','Suresh','Hadke',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hadkeshweta3@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151079','2014-15','MCA',79,'Sourabh','Ramesh','Dubale',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sourabh11dubale09@gmail.com',NULL,NULL,NULL,'Aarava Mala','Indian'),
 ('14151003','2014-15','MCA',3,'Ashwini','Anand','Devare',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ashwinidevare2893@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151087','2014-15','MCA',87,'Swati','Shankar','Vairagkar',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin','Indian'),
 ('14151097','2014-15','MCA',97,'Ashish','Ashok','Prajapati',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ashishprajapati110@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('14151098','2014-15','MCA',98,'Pournima','Ravindra','Shinde',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kondhalkarpournima@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151099','2014-15','MCA',99,'Manoj','Suresh','Rathod',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'manojrathod786@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151100','2014-15','MCA',100,'Niraj','Harendrasinh','Desai',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'niraj004@yahoo.com',NULL,NULL,NULL,'bramin','Indian'),
 ('141511','2014-15','MCA',1,'Anjani Kumar','','Pandey',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'anjani.pandey4@gmail.com',NULL,NULL,NULL,'0','Indian'),
 ('141511110','2014-15','MCA',1110,'Vijaya','','Shinde',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0','Indian'),
 ('14151202','2014-15','MCA',202,'Prasad','Mahadeo','Sonawane',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin','Indian'),
 ('14151253','2014-15','MCA',253,'Prasad','Mahadeo','Sonawane',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'Indian'),
 ('14151081','2014-15','MCA',81,'Supriya','Hujjur','Inamdar',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sofiyainamdar4@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('141510117','2014-15','MCA',117,'Swati','Shankar','Shelke',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sshelke560@gmail.com',NULL,NULL,NULL,'0','Indian'),
 ('141511122','2014-15','MCA',1122,'Abhijeet','Ankush','Konde',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kondeabhijeet2009@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('141512110','2014-15','MCA',2110,'Asmita','Dashrath','Kindre',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'asmitakindre1@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151315','2014-15','MCA',315,'Prithviraj','Pandurang','Bhosale',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'prithvirajbhosale0@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('14151555','2014-15','MCA',555,'Mrunal','Ramesh','Shinde',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shinde.mrunal9@gmail.com',NULL,NULL,NULL,'bramin','Indian'),
 ('141515585','2014-15','MCA',5585,'Tushar','Sukhdev','Salunke',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tsalunke2@gmail.com',NULL,NULL,NULL,'0','Indian'),
 ('141515559','2014-15','MCA',5559,'Amarsinha','Prakash','Sutar',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'asutar2012@gmail.com',NULL,NULL,NULL,'Aagale','Indian'),
 ('141514584','2014-15','MCA',4584,'Sagar','Jawahar','Hiremath',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sagar7.bac@gmail.com',NULL,NULL,NULL,'Aagale','Indian'),
 ('1415145864','2014-15','MCA',45864,'Pawan','','Trivedi',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pawan.trivedimca@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('14151459841','2014-15','MCA',459841,'Nilesh','Shahaji','Patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nileshpatil.me333@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('161715001','2016-17','MCA',5001,'Shivaji','m','patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shivaji@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171157','2016-17','MCA',157,'Pravin','Balkrusna','Datir',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale','INDIAN'),
 ('16171491','2016-17','MCA',491,'Yogesh','Anant','Baikar',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aagale','INDIAN'),
 ('16171489','2017-18','MCA',489,'Tejas','Vijay','Konde',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171487','2016-17','MCA',487,'Gagan','Narapati','Munda',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171484','2017-18','MCA',484,'Shubham','Ramdas','Jambhale',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171515','2017-18','MCA',515,'Swapnil','Sadashiv','Karke',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171480','2017-18','MCA',480,'Vicky','Balasaheb','Vanshiv',NULL,NULL,0,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aarava Mala','INDIAN'),
 ('16171477','2017-18','MCA',477,'Kunal','Sanjay','Chavan',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin','INDIAN'),
 ('16171178','2018-19','MCA',178,'Mayuri','Pandurang','Gaikwad',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171173','2018-19','MCA',173,'Shubham','Satish','Shah',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Marawadi','INDIAN'),
 ('16171220','2018-19','MCA',220,'Rajashree','Manohar','Rokade',NULL,NULL,0,'Not Selected',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'INDIAN'),
 ('16171169','2018-19','MCA',169,'Suraj','Shivaji','Dhanawale',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171187','2016-17','MCA',187,'RAm','Dnyandev','Zagade',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Malee','INDIAN'),
 ('16171167','2018-19','MCA',167,'Shubham','Sanjay','Soni',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Marawadi','INDIAN'),
 ('16171221','2018-19','MCA',221,'Aishwarya','Suresh','Salunke',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('16171226','2016-17','MCA',226,'Yogita','Gorakh','Budhawant',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'chambhar','INDIAN'),
 ('16171186','2016-17','MCA',186,'Amol','Kailas','Dhoble',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','INDIAN'),
 ('1617115','2017-18','MCA',15,'Bhagwan','','Tapase',NULL,NULL,0,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aarava Mala','INDIAN'),
 ('1617130','2017-18','MCA',30,'Sonali','Somnath','sigh',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin','INDIAN'),
 ('1617131','2016-17','MCA',31,'savita','Baburao','kumavat',NULL,NULL,NULL,'Female',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale','INDIAN'),
 ('17181415','2018-19','MCA',415,'Vrushali','Surendrasing','Pawar',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vrushalir30@gmail.com',NULL,NULL,NULL,'MARAHA','INDIAN'),
 ('17181416','2018-19','MCA',416,'Mayur','Bhanudas','Khopade',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mayur.khopade20@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181417','2018-19','MCA',417,'Shubham','Suhas','Rokde',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shubhamrokade7670@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181418','2018-19','MCA',418,'Sachin','Suresh','Patil',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sachin.patil7557@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181419','2017-18','MCA',419,'Sagar','Ashok','Sonawane',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sagarthewildkire@gmail.com',NULL,NULL,NULL,'Mahar','INDIAN'),
 ('17181420','2017-18','MCA',420,'Ujjwal','Popat','Ghone',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ujjwalg123@gmail.com',NULL,NULL,NULL,'Khatik','Indian'),
 ('17181421','2017-18','MCA',421,'Amol','krushna','Bhilare',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Amol07bhilare@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('171810421','2018-19','MCA',421,'Akshay','Dattatray','Sawant',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'akshaysawant211@gmail.com',NULL,NULL,NULL,'MARAHA','INDIAN'),
 ('17181422','2018-19','MCA',422,'Nilam','Dattatraya','Bhogawale',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'nilam.bhogawale@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('171810422','2018-19','MCA',422,'Akshay','Rajesh','Utekar',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'akshayutekar99@gmail.com',NULL,NULL,NULL,'MARAHA','INDIAN'),
 ('17181423','2018-19','MCA',423,'Sangram','Sahebrao','Adsul',NULL,NULL,0,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sangramadsul07@gmail.com',NULL,NULL,NULL,'Malee','INDIAN'),
 ('17181424','2018-19','MCA',424,'Prathamesh','Jitendra','Gurav',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pgprathamesh@gmail.com',NULL,NULL,NULL,'bramin','INDIAN'),
 ('17181425','2018-19','MCA',425,'Ankita','Ajit','Thombare',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ankitathombare007@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181426','2018-19','MCA',426,'Shubham','Prakash','Kajulkar',NULL,NULL,0,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'skajulkar@gmail.com',NULL,NULL,NULL,'Kumbara','INDIAN'),
 ('17181427','2018-19','MCA',427,'Snehal','Sunil','Choudhari',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'snehalchoudhari197@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181428','2017-18','MCA',428,'Sagar','Pandurang','Masal',NULL,NULL,NULL,'Male',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sagarmasal2018@gmail.com',NULL,NULL,NULL,'Dhanagar','INDIAN'),
 ('17181429','2018-19','MCA',429,'Aditya','Sunil','Dharmawat',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'adityadharmawat@gmail.com',NULL,NULL,NULL,'Marawadi','INDIAN'),
 ('17181430','2017-18','MCA',430,'Swanil ','Mahendra','Gaikwad',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'swapnil89gaikwad@gmail.com',NULL,NULL,NULL,'Burud','INDIAN'),
 ('17181431','2018-19','MCA',431,'Akshay','Kishor','Mohol',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'aksmohol@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181432','2017-18','MCA',432,'Chaitanya','Devidas','Lokhande',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'lokhandelcd1996@gmail.com',NULL,NULL,NULL,'Mang','INDIAN'),
 ('17181433','2018-19','MCA',433,'Akshay','Tatoba','Jagtap',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'akshayjagtap646@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181434','2018-19','MCA',434,'Swati','Ganpati','Kumbhar',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kumbhar.swati24@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181435','2018-19','MCA',435,'Rahul','Rajendra','Patil',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rahulpatil221996@gmail.com',NULL,NULL,NULL,'LINGAYAT','INDIAN'),
 ('17181436','2018-19','MCA',436,'Shivani','Rajendra','Sonawani',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'s.shivani4995@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181437','2017-18','MCA',437,'Vaibhav','Ramesh','Hande',NULL,NULL,NULL,'Male',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vaibhavhande001@gmail.com',NULL,NULL,NULL,'Mahar','INDIAN'),
 ('17181438','2018-19','MCA',438,'Anusha','Manohar','Thakur',NULL,NULL,0,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'agusttwenty123@gmail.com',NULL,NULL,NULL,'maratha','INDIAN'),
 ('17181439','2017-18','MCA',439,'Manoj','Kumar','Kulkarni',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'manikul2009@gmail.com',NULL,NULL,NULL,'bramin','INDIAN'),
 ('17181440','2018-19','MCA',440,'Ujjwal','','Kumar',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ujjwalkumar752@gmail.com',NULL,NULL,NULL,'bramin','INDIAN'),
 ('17181441','2018-19','MCA',441,'Mahesh','Gajanan','Gaikwad',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mahesh001.mg@gmail.com',NULL,NULL,NULL,'MARAHA','INDIAN'),
 ('17181442','2018-19','MCA',442,'Rahul','Kamalaprasad','Varma',NULL,NULL,0,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'varmaRahul.Ru98@gmail.com',NULL,NULL,NULL,'bramin','INDIAN'),
 ('17181451','2017-18','MCA',451,'Sonal','Sunil','Chavan',NULL,NULL,NULL,'Female',NULL,'NT-A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sonalschavan33@gmail.com',NULL,NULL,NULL,'Ramoshee','INDIAN'),
 ('17181011','2017-18','MCA',11,'savita','','kumawat',NULL,NULL,NULL,'Female',NULL,'SC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aarava Mala','INDIAN'),
 ('171810111','2017-18','MCA',111,'savita','','kumawat',NULL,NULL,NULL,'Female',NULL,'NT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Aswalwale','INDIAN'),
 ('18191201801','2018-19','MCA',201801,'Ankit','Ajit','Patel',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ankitpatel1434ever@gmail.com',NULL,NULL,NULL,'Marawadi','Indian'),
 ('18191201802','2018-19','MCA',201802,'Bhoomish','Dilip','Atha',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'boomishatha@gmail.com',NULL,NULL,NULL,'Marawadi','Indian'),
 ('18191201803','2018-19','MCA',201803,'Rohini','Suryakant','Jadhav',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rohini7218@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201804','2018-19','MCA',201804,'Suvarna','Kisan','Phalke',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'suvarnaphalake1517@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201805','2018-19','MCA',201805,'Lucky','Dileshwar','Jena',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'luckyjena341998@gmail.com',NULL,NULL,NULL,'Marawadi','Indian'),
 ('18191201806','2018-19','MCA',201806,'Akshay','Dattatray','Shinde',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shindeakshay9762@gmail',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201807','2018-19','MCA',201807,'Prasad','Ramchandra','Tatale',NULL,NULL,NULL,'Male',NULL,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'prasadtatale987@gmail.com',NULL,NULL,NULL,'Munurwad','Indian'),
 ('18191201808','2018-19','MCA',201808,'Prashant','Suresh','Mandge',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'prashantsm8991@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201809','2018-19','MCA',201809,'Shubham','Arun','bari',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bari.shubham919@gmail.com',NULL,NULL,NULL,'Baree','Indian'),
 ('18191201810','2018-19','MCA',201810,'Suraj','Gajanan','Nikam',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'surajnikam2123@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201811','2018-19','MCA',201811,'Hitesh','Fakirchand','Bhattad',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bhattadnitesh@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201812','2018-19','MCA',201812,'swapna','Satish','Raut',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'swapnaraut27@gmail.com',NULL,NULL,NULL,'Navi','Indian'),
 ('18191201816','2018-19','MCA',201816,'Yogesh','Pradip','Patil',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yogeshpatill426@gmail.com',NULL,NULL,NULL,'Reva gujar','Indian'),
 ('181912181817','2018-19','MCA',2181817,'Vaishnavi','Shashikant','Bhagat',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vaishnavi1319@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201818','2018-19','MCA',201818,'Vishal','Ashok','Patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vishalpatil2805@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201819','2018-19','MCA',201819,'Appukutan','Mohan Das','Nair',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'knairr.appu@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201820','2018-19','MCA',201820,'She Mubin','She Sadik','Attar',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sk.mubinattar@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201821','2018-19','MCA',201821,'Omkar','Vijay','Nair',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'omkarNaik99927@gmail.com',NULL,NULL,NULL,'0','Indian'),
 ('18191201822','2018-19','MCA',201822,'Omkar','Vijay','Naik',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'omkarNaik99927@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201823','2018-19','MCA',201823,'Shriniwas','Prakash','turekar',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shriturekar22@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201824','2018-19','MCA',201824,'Tejas','Arvind','Gadkar',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tejasgadkar143@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201825','2018-19','MCA',201825,'Afrin','Karimsha','Patel',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'afrinpatel2130@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201826','2018-19','MCA',201826,'Uttareshwar','Shrimant','Solunke',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'uttarehwarsolunke@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201827','2018-19','MCA',201827,'Rahulsingh','Rajpalsingh','Baisthakur',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rahulth50@gmail.com',NULL,NULL,NULL,'maharaj','Indian'),
 ('18191201828','2018-19','MCA',201828,'Aarti ','Nandaram','Kale',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'aarti25695@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201829','2018-19','MCA',201829,'Priyanka','Tanaji','Jadhav',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jadhavp2400@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201830','2018-19','MCA',201830,'Rupesh','Kedarnath','Waghmare',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'waghmare.rupesh@yahoo.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201831','2018-19','MCA',201831,'Prakash','Maheshbhai','Sapra',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sapra1139@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201832','2018-19','MCA',201832,'Swapnil','Rajendra ','Durgade',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'swapnildurgade3@gmail.com',NULL,NULL,NULL,'Malee','Indian'),
 ('18191201833','2018-19','MCA',201833,'Akshay ','Dattatray','Shinde',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shindeakshay9762@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201834','2018-19','MCA',201834,'Umesh','Raju','Sonar',NULL,NULL,NULL,'Male',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'umeshsonar2013@gmail.com',NULL,NULL,NULL,'Malee','Indian'),
 ('18191201835','2018-19','MCA',201835,'Shivani','Vijay ','Kankal',NULL,NULL,NULL,'Female',NULL,'OBC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shivani4296@gmail.com',NULL,NULL,NULL,'Bavarchee','Indian'),
 ('18191201836','2018-19','MCA',201836,'Deepak','Satish','Madhabhaye',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'deepakmadhabhaya@gmail.com',NULL,NULL,NULL,'maratha','Indian'),
 ('18191201837','2018-19','MCA',201837,'Akshay','Dattatray','Shinde',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shindeakshay9762@gmail.com',NULL,NULL,NULL,NULL,'Indian'),
 ('18191201838','2018-19','MCA',201838,'Zakir','Hussain','Ganie',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Zakirhusssain8259@gmail.com',NULL,NULL,NULL,'Islam-Muslim','Indian'),
 ('1819120140','2018-19','MCA',20140,'Vishal','Raj','Sahu',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'vishalraj62@gmail.com',NULL,NULL,NULL,'Marawadi','Indian'),
 ('181910007','2018-19','MCA',7,'Swapna ','Satish ','Raut',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'Indian'),
 ('1819100001','2018-19','MCA',1,'Shubham','Satish','Shah',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'Marawadi','Indian'),
 ('1819161702525','2018-19','MCA',61702525,'Madhura','Anil','Deodhar',NULL,NULL,NULL,'Female',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'bramin','Indian'),
 ('181912018','2018-19','MCA',2018,'Rahul ','Rajendra','Patil',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'Indian'),
 ('1819105','2018-19','MCA',5,'Suraj','Shivaji','Dhanawale',NULL,NULL,NULL,'Male',NULL,'OPEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'maratha','Indian');

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

--
-- Table structure for table `s_promoted`
--

CREATE TABLE IF NOT EXISTS `s_promoted` (
  `s_promoted_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_current_standard` varchar(15) DEFAULT NULL,
  `s_next_standard` varchar(15) DEFAULT NULL,
  `is_promoted` varchar(15) DEFAULT NULL,
  `academic_year` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`s_promoted_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `s_promoted` (`s_promoted_id`,`s_personal_info_id`,`s_current_standard`,`s_next_standard`,`is_promoted`,`academic_year`,`s_section`) VALUES 
 (1,'16171477','SECOND','Third','Promoted','2016-17','passed 2nd year'),
 (2,'16171484','SECOND','Third','Promoted','2016-17','passed 2nd year'),
 (3,'1617130','SECOND','Third','Promoted','2016-17','passed 2nd year'),
 (4,'16171480','SECOND','Third','Promoted','2016-17','2nd passed'),
 (5,'1617115','FIRST','Second','Promoted','2016-17','1st year passed'),
 (6,'16171515','SECOND','Third','Promoted','2016-17','2nd Year passed'),
 (7,'16171489','SECOND','Third','Promoted','2016-17','passed 2nd year'),
 (8,'16171220','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (9,'16171221','FIRST','Second','Promoted','2016-17','1st year passed'),
 (10,'16171173','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (11,'16171178','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (12,'16171167','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (13,'16171169','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (14,'16171173','Second','Third','Promoted','2017-18','IIyear passed'),
 (15,'171810422','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (16,'17181433','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (17,'17181427','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (18,'17181416','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (19,'17181417','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (20,'17181431','FIRST','Second','Promoted','2017-18','IIyear passed'),
 (21,'17181438','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (22,'17181418','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (23,'17181429','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (24,'17181424','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (25,'17181425','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (26,'17181426','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (27,'17181415','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (28,'16171220','Second','Third','Promoted','2017-18','IIyear passed'),
 (29,'17181442','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (30,'171810421','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (31,'17181435','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (32,'16171169','Second','Third','Promoted','2017-18','IIyear passed'),
 (33,'17181423','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (34,'17181434','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (35,'17181422','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (36,'16171221','Second','Third','Promoted','2017-18','IIyear passed'),
 (37,'16171178','Second','Third','Promoted','2017-18','IIyear passed'),
 (38,'17181440','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (39,'17181441','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (40,'16171167','Second','Third','Promoted','2017-18','IIyear passed'),
 (41,'17181436','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (42,'14151080','SECOND','Third','Promoted','2014-15','Iyear passed');
-- --------------------------------------------------------

--
-- Table structure for table `s_results`
--

CREATE TABLE IF NOT EXISTS `s_results` (
  `s_results_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_on` datetime DEFAULT NULL,
  PRIMARY KEY (`s_results_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_result_info`
--

CREATE TABLE IF NOT EXISTS `s_result_info` (
  `s_result_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_results_id` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_division` varchar(45) DEFAULT NULL,
  `s_branch_type` varchar(45) DEFAULT NULL,
  `exam_name` varchar(100) DEFAULT NULL,
  `exam_date` varchar(45) DEFAULT NULL,
  `subject_name` varchar(100) DEFAULT NULL,
  `internal_marks_out_of` varchar(45) DEFAULT NULL,
  `external_marks_out_of` varchar(45) DEFAULT NULL,
  `s_internal_marks` varchar(45) DEFAULT NULL,
  `s_external_marks` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_result_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_stationary_receipt`
--

CREATE TABLE IF NOT EXISTS `s_stationary_receipt` (
  `s_stationary_receipt_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL,
  `s_personal_info_id` varchar(45) NOT NULL,
  `s_date` varchar(45) NOT NULL,
  `receipt_number` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_stationary_receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `forgotten_password_code` varchar(45) DEFAULT NULL,
  `created_on` int(11) DEFAULT NULL,
  `active` tinyint(1) UNSIGNED DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `phonenumber` varchar(45) DEFAULT NULL,
  `user_role` varchar(45) DEFAULT NULL,
  `user_code` varchar(45) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `standard` varchar(45) DEFAULT NULL,
  `division` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=146 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `username`, `password`, `email`, `forgotten_password_code`, `created_on`, `active`, `firstname`, `lastname`, `phonenumber`, `user_role`, `user_code`, `section`, `standard`, `division`) VALUES
(145, 'admin', '$2y$10$9h73j56DCaogZiedMzktdumLttR9SOwlSiIp02Xw8A5m5w5kI4J76', 'abhinavedu.data@gmail.com', NULL, 1497275822, 1, 'AbhinavDCS', 'Admin', '7722002190', 'Superadmin', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE IF NOT EXISTS `user_groups` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group_id` int(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_user_groups_1_idx` (`user_id`),
  KEY `index3` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_info`
--

CREATE TABLE IF NOT EXISTS `user_info` (
  `user_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `role_info_id` int(10) UNSIGNED NOT NULL,
  `e_personal_info_id` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`user_info_id`),
  KEY `FK_user_info_1` (`role_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucher`
--

CREATE TABLE IF NOT EXISTS `voucher` (
  `voucher_number` varchar(20) NOT NULL,
  `voucher_type_name` varchar(100) NOT NULL,
  `voucher_date` date DEFAULT NULL,
  `paid_to` varchar(100) DEFAULT NULL,
  `amount` varchar(10) DEFAULT NULL,
  `towards` varchar(200) DEFAULT NULL,
  `is_cash_or_cheque` varchar(50) DEFAULT NULL,
  `cheque_number` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `cash_amount` varchar(10) DEFAULT NULL,
  `total` varchar(10) DEFAULT NULL,
  `received_by` varchar(100) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `is_paid_received` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`voucher_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher`
--



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

--
-- Table structure for table `voucher_type`
--

CREATE TABLE IF NOT EXISTS `voucher_type` (
  `voucher_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `voucher_type_name` varchar(100) DEFAULT NULL,
  `budget_percent` varchar(10) DEFAULT NULL,
  `particular_exp` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`voucher_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher_type`
--

INSERT INTO `voucher_type` (`voucher_type_id`, `voucher_type_name`, `budget_percent`, `particular_exp`) VALUES
(1, 'Advance Cash', NULL, NULL);

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

--
-- Table structure for table `working_days`
--

CREATE TABLE IF NOT EXISTS `working_days` (
  `working_days_id` int(10) NOT NULL AUTO_INCREMENT,
  `is_monday_open` varchar(20) DEFAULT NULL,
  `is_tuesday_open` varchar(20) DEFAULT NULL,
  `is_wednesday_open` varchar(20) DEFAULT NULL,
  `is_thursday_open` varchar(20) DEFAULT NULL,
  `is_friday_open` varchar(20) DEFAULT NULL,
  `is_saturday_open` varchar(20) DEFAULT NULL,
  `is_sunday_open` varchar(20) DEFAULT NULL,
  `is_first_third_open` varchar(20) DEFAULT NULL,
  `is_sec_third_open` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`working_days_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `daily_incoming_cash_info`
--
ALTER TABLE `daily_incoming_cash_info`
  ADD CONSTRAINT `FK_daily_cash_id` FOREIGN KEY (`daily_cash_id`) REFERENCES `daily_cash` (`daily_cash_id`);

--
-- Constraints for table `exam_timetable`
--
ALTER TABLE `exam_timetable`
  ADD CONSTRAINT `m_subject_info_id` FOREIGN KEY (`m_subject_info_id`) REFERENCES `m_subject` (`m_subject_info_id`);

--
-- Constraints for table `stationary_receipt_head`
--
ALTER TABLE `stationary_receipt_head`
  ADD CONSTRAINT `FK_stationary_receipt_head_1` FOREIGN KEY (`stationary_receipt_title_id`) REFERENCES `stationary_receipt_title` (`stationary_receipt_title_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `user_info`
--
ALTER TABLE `user_info`
  ADD CONSTRAINT `FK_user_info_1` FOREIGN KEY (`role_info_id`) REFERENCES `role_info` (`role_info_id`);
COMMIT;

