-- phpMyAdmin SQL Dump -- version 4.2.11 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Apr 04, 2020 at 04:27 PM -- Server version: 5.6.21 -- PHP Version: 5.6.3 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `gb_solution` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_admin` -- CREATE TABLE IF NOT EXISTS `tbl_admin` ( `fld_id` int(11) NOT NULL, `fld_name` varchar(50) NOT NULL, `fld_address` text NOT NULL, `fld_mobile` varchar(13) NOT NULL, `fld_email` varchar(255) NOT NULL, `fld_password` varchar(100) NOT NULL, `fld_photo` varchar(255) NOT NULL, `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_admin` -- INSERT INTO `tbl_admin` (`fld_id`, `fld_name`, `fld_address`, `fld_mobile`, `fld_email`, `fld_password`, `fld_photo`, `created_date`, `modified_date`, `fld_delete`) VALUES (1, 'Admin', 'Pune', '9764002514', 'admin@gmail.com', 'admin', '740068.png', '2020-03-23 14:31:14', '2020-03-23 15:29:03', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_city` -- CREATE TABLE IF NOT EXISTS `tbl_city` ( `fld_city_id` int(11) NOT NULL, `fld_state_id` int(11) NOT NULL, `fld_city_name` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_city_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_city` -- INSERT INTO `tbl_city` (`fld_city_id`, `fld_state_id`, `fld_city_name`, `fld_created_date`, `fld_modified_date`, `fld_city_delete`) VALUES (1, 1, 'Nashik', '2020-04-04 17:12:26', '2020-04-04 17:12:26', 0), (2, 2, 'Panaji', '2020-04-04 17:13:10', '2020-04-04 17:13:10', 0), (3, 2, 'Nagpur', '2020-04-04 17:13:31', '2020-04-04 17:13:31', 0), (4, 3, 'Surat', '2020-04-04 17:13:58', '2020-04-04 17:13:58', 0), (5, 1, 'Nagpur', '2020-04-04 17:14:30', '2020-04-04 17:15:23', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_course` -- CREATE TABLE IF NOT EXISTS `tbl_course` ( `fld_course_id` int(11) NOT NULL, `fld_course_name` varchar(200) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_course_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_course` -- INSERT INTO `tbl_course` (`fld_course_id`, `fld_course_name`, `fld_created_date`, `fld_modified_date`, `fld_course_delete`) VALUES (1, 'Php', '2020-04-04 17:29:52', '2020-04-04 17:29:52', 0), (2, 'Android', '2020-04-04 17:30:24', '2020-04-04 17:30:24', 0), (3, 'Python', '2020-04-04 17:30:39', '2020-04-04 17:30:39', 0), (4, '.Net', '2020-04-04 17:31:08', '2020-04-04 17:31:08', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_course_details` -- CREATE TABLE IF NOT EXISTS `tbl_course_details` ( `fld_course_details_id` int(11) NOT NULL, `fld_course_id` int(11) NOT NULL, `fld_batch_time_from` varchar(200) NOT NULL, `fld_batch_time_to` varchar(100) NOT NULL, `fld_session_date` varchar(255) NOT NULL, `fld_fee_of_course` varchar(200) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_course_details_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_course_details` -- INSERT INTO `tbl_course_details` (`fld_course_details_id`, `fld_course_id`, `fld_batch_time_from`, `fld_batch_time_to`, `fld_session_date`, `fld_fee_of_course`, `fld_created_date`, `fld_modified_date`, `fld_course_details_delete`) VALUES (1, 1, '9:00 am', '12:00 am', '2020-01-01', '20000', '2020-04-04 17:32:48', '2020-04-04 17:35:05', 1), (2, 2, '7:00 am', '11:00 am', '2020-02-03', '25000', '2020-04-04 17:33:52', '2020-04-04 17:33:52', 0), (3, 1, '9:00 am', '12:00 pm', '2020-01-01', '20000', '2020-04-04 17:34:43', '2020-04-04 17:34:43', 0), (4, 3, '8:00 am', '1:00 pm', '2020-03-02', '35000', '2020-04-04 17:36:52', '2020-04-04 17:36:52', 0), (5, 4, '5:00 pm', '7:00 pm', '2020-04-01', '15000', '2020-04-04 17:37:40', '2020-04-04 17:37:40', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_dynamic_header_footer` -- CREATE TABLE IF NOT EXISTS `tbl_dynamic_header_footer` ( `fld_id` int(11) NOT NULL, `fld_company_name` varchar(200) NOT NULL, `fld_company_address` text NOT NULL, `fld_mobile` varchar(15) NOT NULL, `fld_phone` varchar(20) NOT NULL, `fld_email` varchar(255) NOT NULL, `fld_website` varchar(255) NOT NULL, `fld_logo` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_header_footer_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_dynamic_header_footer` -- INSERT INTO `tbl_dynamic_header_footer` (`fld_id`, `fld_company_name`, `fld_company_address`, `fld_mobile`, `fld_phone`, `fld_email`, `fld_website`, `fld_logo`, `fld_created_date`, `fld_modified_date`, `fld_header_footer_delete`) VALUES (1, 'GB Solution', 'Govind Nagar, Nashik', '9898989898', '0253225698', 'gbsolution@gmail.com', 'www.gbsolution.com', '564980.png', '2020-03-28 16:54:40', '2020-04-03 18:29:04', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_employee_qualification` -- CREATE TABLE IF NOT EXISTS `tbl_employee_qualification` ( `fld_emp_id` int(11) NOT NULL, `fld_emp_qualification` varchar(100) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_emp_qualification_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_employee_qualification` -- INSERT INTO `tbl_employee_qualification` (`fld_emp_id`, `fld_emp_qualification`, `fld_created_date`, `fld_modified_date`, `fld_emp_qualification_delete`) VALUES (1, 'B Tech', '2020-04-04 18:07:09', '2020-04-04 18:07:09', 0), (2, 'M Tech', '2020-04-04 18:07:28', '2020-04-04 18:07:28', 0), (3, 'Bcs', '2020-04-04 18:07:38', '2020-04-04 18:07:38', 0), (4, 'Mcs', '2020-04-04 18:07:56', '2020-04-04 18:07:56', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_empolyee_details` -- CREATE TABLE IF NOT EXISTS `tbl_empolyee_details` ( `fld_emp_details_id` int(11) NOT NULL, `fld_employee_id` varchar(50) NOT NULL, `fld_emp_fname` varchar(100) NOT NULL, `fld_emp_mname` varchar(100) NOT NULL, `fld_emp_lname` varchar(100) NOT NULL, `fld_emp_dob` varchar(100) NOT NULL, `fld_emp_email` varchar(255) NOT NULL, `fld_emp_mobile` varchar(13) NOT NULL, `fld_state_id` varchar(50) NOT NULL, `fld_city_id` varchar(50) NOT NULL, `fld_taluka_id` varchar(50) NOT NULL, `fld_emp_aadhar_no` varchar(50) NOT NULL, `fld_emp_id` varchar(50) NOT NULL, `fld_emp_course` varchar(100) NOT NULL, `fld_emp_date_of_joining` varchar(100) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_emp_details_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_empolyee_details` -- INSERT INTO `tbl_empolyee_details` (`fld_emp_details_id`, `fld_employee_id`, `fld_emp_fname`, `fld_emp_mname`, `fld_emp_lname`, `fld_emp_dob`, `fld_emp_email`, `fld_emp_mobile`, `fld_state_id`, `fld_city_id`, `fld_taluka_id`, `fld_emp_aadhar_no`, `fld_emp_id`, `fld_emp_course`, `fld_emp_date_of_joining`, `fld_created_date`, `fld_modified_date`, `fld_emp_details_delete`) VALUES (1, 'GBE1', 'abcd', 'abcd', 'abcd', '2020-04-04', 'a@gmail.com', '9894561484', '3', '4', '1', '232265674877', '2', 'demo', '2020-04-30', '2020-04-04 19:21:05', '2020-04-04 19:21:24', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_gst` -- CREATE TABLE IF NOT EXISTS `tbl_gst` ( `fld_gst_id` int(11) NOT NULL, `fld_gst` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_gst_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_gst` -- INSERT INTO `tbl_gst` (`fld_gst_id`, `fld_gst`, `fld_created_date`, `fld_modified_date`, `fld_gst_delete`) VALUES (1, '10', '2020-04-04 19:03:49', '2020-04-04 19:03:49', 0), (2, '12', '2020-04-04 19:03:57', '2020-04-04 19:03:57', 0), (3, '15', '2020-04-04 19:04:04', '2020-04-04 19:04:04', 0), (4, '18', '2020-04-04 19:04:14', '2020-04-04 19:04:14', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_guest_lecture` -- CREATE TABLE IF NOT EXISTS `tbl_guest_lecture` ( `fld_lecture_id` int(11) NOT NULL, `fld_name_of_college` varchar(150) NOT NULL, `fld_topic_of_lecture` varchar(150) NOT NULL, `fld_lecture_date` varchar(100) NOT NULL, `fld_lecture_time` varchar(100) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_lecture_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_guest_lecture` -- INSERT INTO `tbl_guest_lecture` (`fld_lecture_id`, `fld_name_of_college`, `fld_topic_of_lecture`, `fld_lecture_date`, `fld_lecture_time`, `fld_created_date`, `fld_modified_date`, `fld_lecture_delete`) VALUES (1, 'Sandip Foundation Nashik', 'PHP', '2020-03-09', '10:00 am', '2020-03-28 15:51:51', '2020-03-28 15:51:51', 0), (2, 'Amurtvahini College of engg.', 'Andorid', '2020-02-19', '11:00 am', '2020-03-28 15:53:33', '2020-03-28 15:54:08', 1), (3, 'Sandip Foundation Nashik', 'PHP', '2020-03-09', '3:54 pm', '2020-03-28 15:54:54', '2020-03-28 16:40:21', 1), (4, 'Sandip Foundation Nashik', 'PHP', '2020-03-09', '3:54 pm', '2020-03-28 15:55:40', '2020-03-28 16:19:49', 1), (5, 'Sapkal college of engg ', 'Laravel', '2020-01-22', '12:00 pm', '2020-03-28 15:58:11', '2020-03-28 16:41:52', 0), (6, 'K.K Wagh college of engg', 'Python', '2020-02-10', '11:00 am', '2020-03-28 15:59:35', '2020-03-28 16:40:10', 1), (7, 'K.K Wagh college of engg', 'Python', '2020-02-10', '11:00 am', '2020-03-28 16:04:31', '2020-03-28 16:18:36', 0), (8, 'Amurtvahini College of engg.', '.Net', '2020-03-02', '9:00 am', '2020-03-28 16:39:58', '2020-04-04 17:06:38', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_invoice` -- CREATE TABLE IF NOT EXISTS `tbl_invoice` ( `fld_invoice_id` int(11) NOT NULL, `fld_invoice_no` varchar(50) NOT NULL, `fld_reg_no` varchar(50) NOT NULL, `fld_final_fees` varchar(200) NOT NULL, `fld_pending_amount` varchar(200) NOT NULL, `fld_paid_amount` varchar(200) NOT NULL, `fld_balance_amount` varchar(200) NOT NULL, `fld_invoice_current_date` varchar(200) NOT NULL, `fld_invoice_status` varchar(200) NOT NULL DEFAULT 'Not_final', `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_invoice` -- INSERT INTO `tbl_invoice` (`fld_invoice_id`, `fld_invoice_no`, `fld_reg_no`, `fld_final_fees`, `fld_pending_amount`, `fld_paid_amount`, `fld_balance_amount`, `fld_invoice_current_date`, `fld_invoice_status`, `fld_created_date`, `fld_modified_date`, `fld_delete`) VALUES (1, 'GBI1', 'GBS1', '19000', '19000', '10000', '9000', '2020-04-04', 'Not_final', '2020-04-04 19:13:46', '2020-04-04 19:13:46', 0), (2, 'GBI2', 'GBS1', '19000', '9000', '9000', '0', '2020-04-04', 'Final', '2020-04-04 19:14:12', '2020-04-04 19:14:16', 0), (3, 'GBI3', 'GBS2', '31500', '31500', '31500', '0', '2020-04-04', 'Final', '2020-04-04 19:16:27', '2020-04-04 19:17:04', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_media` -- CREATE TABLE IF NOT EXISTS `tbl_media` ( `fld_media_id` int(11) NOT NULL, `fld_media_name` varchar(255) NOT NULL, `fld_media_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_media_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_media` -- INSERT INTO `tbl_media` (`fld_media_id`, `fld_media_name`, `fld_media_created_date`, `fld_modified_date`, `fld_media_delete`) VALUES (1, 'Website', '2020-04-04 17:20:12', '2020-04-04 17:20:12', 0), (2, 'Newspaper', '2020-04-04 17:28:57', '2020-04-04 17:28:57', 0), (3, 'Friend', '2020-04-04 17:29:08', '2020-04-04 17:29:08', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_message` -- CREATE TABLE IF NOT EXISTS `tbl_message` ( `fld_message_id` int(11) NOT NULL, `fld_message` text NOT NULL, `fld_student_count` varchar(200) NOT NULL, `fld_message_code` varchar(100) NOT NULL, `fld_course_id` int(11) NOT NULL, `fld_batch_time_from` varchar(200) NOT NULL, `fld_batch_time_to` varchar(200) NOT NULL, `fld_message_category` varchar(100) NOT NULL, `fld_message_type` varchar(255) NOT NULL COMMENT 'mail,sms', `fld_message_send_by` int(11) NOT NULL, `fld_message_send_type` varchar(255) NOT NULL COMMENT 'admin,po_office,emrs_school', `fld_message_status` varchar(200) NOT NULL DEFAULT 'no_message', `fld_message_delete` int(11) NOT NULL, `fld_message_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_message_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_message` -- INSERT INTO `tbl_message` (`fld_message_id`, `fld_message`, `fld_student_count`, `fld_message_code`, `fld_course_id`, `fld_batch_time_from`, `fld_batch_time_to`, `fld_message_category`, `fld_message_type`, `fld_message_send_by`, `fld_message_send_type`, `fld_message_status`, `fld_message_delete`, `fld_message_created_date`, `fld_message_modified_date`) VALUES (1, 'Welcome to GB Soultion', '3', 'GBSOLU', 0, '', '', '', '', 0, '', 'All', 0, '2020-04-01 14:53:05', '2020-04-01 14:53:05'), (2, 'Welcome to GB Soultion', '3', 'GBSOLU', 0, '', '', '', '', 0, '', 'All', 0, '2020-04-01 14:53:54', '2020-04-01 14:53:54'), (3, 'Please Paid Your Balance Fees.', '1', 'GBSOLU', 0, '', '', '', '', 0, '', 'Fee Balance', 0, '2020-04-01 15:12:15', '2020-04-01 15:12:15'), (4, 'Your Course is PHP.', '', 'GBSOLU', 1, '', '', '', '', 0, '', 'Course', 0, '2020-04-01 16:10:09', '2020-04-01 16:10:09'), (6, 'Your batch time for PHP course is as 10:47 am to 1:47 pm', '', 'GBSOLU', 1, '10:47 am', '1:47 pm', '', '', 0, '', 'Batch Time', 0, '2020-04-01 17:17:40', '2020-04-01 17:17:40'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_payee` -- CREATE TABLE IF NOT EXISTS `tbl_payee` ( `fld_payee_id` int(11) NOT NULL, `fld_payee_name` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_payee_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_payee` -- INSERT INTO `tbl_payee` (`fld_payee_id`, `fld_payee_name`, `fld_created_date`, `fld_modified_date`, `fld_payee_delete`) VALUES (1, 'Abc', '2020-04-04 18:14:32', '2020-04-04 18:14:32', 0), (2, 'Xyz', '2020-04-04 18:15:03', '2020-04-04 18:15:03', 0), (3, 'Yogita', '2020-04-04 18:15:14', '2020-04-04 18:15:14', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_payment_mode` -- CREATE TABLE IF NOT EXISTS `tbl_payment_mode` ( `fld_payment_mode_id` int(11) NOT NULL, `fld_payment_mode` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_payment_mode_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_payment_mode` -- INSERT INTO `tbl_payment_mode` (`fld_payment_mode_id`, `fld_payment_mode`, `fld_created_date`, `fld_modified_date`, `fld_payment_mode_delete`) VALUES (1, 'Online Payment', '2020-04-04 19:10:19', '2020-04-04 19:10:19', 0), (2, 'Cash Payment', '2020-04-04 19:10:49', '2020-04-04 19:10:49', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_state` -- CREATE TABLE IF NOT EXISTS `tbl_state` ( `fld_state_id` int(11) NOT NULL, `fld_state_name` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_state_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_state` -- INSERT INTO `tbl_state` (`fld_state_id`, `fld_state_name`, `fld_created_date`, `fld_modified_date`, `fld_state_delete`) VALUES (1, 'Maharashtra', '2020-04-04 17:08:49', '2020-04-04 17:08:49', 0), (2, 'Goa', '2020-04-04 17:09:12', '2020-04-04 17:09:12', 0), (3, 'Gujrat', '2020-04-04 17:09:28', '2020-04-04 17:09:28', 0), (4, 'Asd', '2020-04-04 17:10:46', '2020-04-04 17:11:31', 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl_student_occupation` -- CREATE TABLE IF NOT EXISTS `tbl_student_occupation` ( `fld_occ_id` int(11) NOT NULL, `fld_occupation` varchar(100) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_occupation_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_student_occupation` -- INSERT INTO `tbl_student_occupation` (`fld_occ_id`, `fld_occupation`, `fld_created_date`, `fld_modified_date`, `fld_occupation_delete`) VALUES (1, 'Teacher', '2020-04-04 18:06:07', '2020-04-04 18:06:07', 0), (2, 'Student', '2020-04-04 18:06:15', '2020-04-04 18:06:15', 0), (3, 'Goverment Employee', '2020-04-04 18:06:34', '2020-04-04 18:06:34', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_student_qualification` -- CREATE TABLE IF NOT EXISTS `tbl_student_qualification` ( `fld_stud_id` int(11) NOT NULL, `fld_stud_qualification` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_stud_qualification_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_student_qualification` -- INSERT INTO `tbl_student_qualification` (`fld_stud_id`, `fld_stud_qualification`, `fld_created_date`, `fld_modified_date`, `fld_stud_qualification_delete`) VALUES (1, 'Ssc', '2020-04-04 17:38:05', '2020-04-04 17:38:05', 0), (2, 'Hsc', '2020-04-04 17:38:25', '2020-04-04 17:38:25', 0), (3, 'Phd', '2020-04-04 17:39:40', '2020-04-04 17:39:40', 0), (4, 'B Tech', '2020-04-04 17:40:42', '2020-04-04 17:40:42', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_student_reg` -- CREATE TABLE IF NOT EXISTS `tbl_student_reg` ( `fld_stud_reg_id` int(11) NOT NULL, `fld_reg_no` varchar(100) NOT NULL, `fld_first_name` varchar(100) NOT NULL, `fld_middle_name` varchar(100) NOT NULL, `fld_last_name` varchar(100) NOT NULL, `fld_dob` varchar(100) NOT NULL, `fld_email` varchar(255) NOT NULL, `fld_mobile` varchar(13) NOT NULL, `fld_state_id` varchar(50) NOT NULL, `fld_city_id` varchar(50) NOT NULL, `fld_taluka_id` varchar(50) NOT NULL, `fld_aadhar_no` varchar(50) NOT NULL, `fld_stud_id` varchar(50) NOT NULL, `fld_occ_id` varchar(50) NOT NULL, `fld_course_id` varchar(50) NOT NULL, `fld_batch_time_from` varchar(50) NOT NULL, `fld_batch_time_to` varchar(50) NOT NULL, `fld_session_date` varchar(100) NOT NULL, `fld_fee_of_course` varchar(100) NOT NULL, `fld_discount` varchar(100) NOT NULL, `fld_final_fees` varchar(100) NOT NULL, `fld_media_id` varchar(50) NOT NULL, `fld_reg_date` varchar(100) NOT NULL, `fld_status` varchar(200) NOT NULL DEFAULT 'Balance', `fld_invoice_current_date` varchar(200) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_stud_reg_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_student_reg` -- INSERT INTO `tbl_student_reg` (`fld_stud_reg_id`, `fld_reg_no`, `fld_first_name`, `fld_middle_name`, `fld_last_name`, `fld_dob`, `fld_email`, `fld_mobile`, `fld_state_id`, `fld_city_id`, `fld_taluka_id`, `fld_aadhar_no`, `fld_stud_id`, `fld_occ_id`, `fld_course_id`, `fld_batch_time_from`, `fld_batch_time_to`, `fld_session_date`, `fld_fee_of_course`, `fld_discount`, `fld_final_fees`, `fld_media_id`, `fld_reg_date`, `fld_status`, `fld_invoice_current_date`, `fld_created_date`, `fld_modified_date`, `fld_stud_reg_delete`) VALUES (1, 'GBS1', 'demo', 'demo', 'demo', '1992-01-03', 'a@gmail.com', '9998989898', '1', '1', '5', '787874845412', '4', '3', '1', '9:00 am', '12:00 pm', '2020-01-01', '20000', '5', '19000', '1', '2020-04-04', 'Paid', '2020-04-04', '2020-04-04 19:12:48', '2020-04-04 19:14:11', 0), (2, 'GBS2', 'abc', 'abc', 'abc', '2020-02-29', 'b@gmail.com', '9894561484', '2', '2', '3', '232265674877', '2', '2', '3', '8:00 am', '1:00 pm', '2020-03-02', '35000', '10', '31500', '3', '2020-04-04', 'Paid', '2020-04-04', '2020-04-04 19:16:01', '2020-04-04 19:16:55', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_taluka` -- CREATE TABLE IF NOT EXISTS `tbl_taluka` ( `fld_taluka_id` int(11) NOT NULL, `fld_state_id` int(11) NOT NULL, `fld_city_id` int(11) NOT NULL, `fld_taluka_name` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_taluka_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_taluka` -- INSERT INTO `tbl_taluka` (`fld_taluka_id`, `fld_state_id`, `fld_city_id`, `fld_taluka_name`, `fld_created_date`, `fld_modified_date`, `fld_taluka_delete`) VALUES (1, 3, 4, 'Surat', '2020-04-04 17:16:31', '2020-04-04 17:16:31', 0), (2, 1, 5, 'Surat', '2020-04-04 17:16:49', '2020-04-04 17:16:49', 0), (3, 2, 2, 'Panaji', '2020-04-04 17:17:26', '2020-04-04 17:17:26', 0), (4, 1, 1, 'Sinner', '2020-04-04 17:17:55', '2020-04-04 17:17:55', 0), (5, 1, 1, 'Malegaon', '2020-04-04 17:18:18', '2020-04-04 17:18:18', 0), (6, 1, 1, 'Ozar', '2020-04-04 17:19:04', '2020-04-04 17:19:04', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_voucher_category` -- CREATE TABLE IF NOT EXISTS `tbl_voucher_category` ( `fld_voucher_category_id` int(11) NOT NULL, `fld_voucher_category` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_voucher_category_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_voucher_category` -- INSERT INTO `tbl_voucher_category` (`fld_voucher_category_id`, `fld_voucher_category`, `fld_created_date`, `fld_modified_date`, `fld_voucher_category_delete`) VALUES (1, 'Cash Vouchers', '2020-04-04 18:24:10', '2020-04-04 18:58:33', 0), (2, 'Sales Voucher', '2020-04-04 18:24:36', '2020-04-04 18:55:14', 0), (3, 'Purchase Voucher', '2020-04-04 18:24:53', '2020-04-04 18:24:53', 0), (4, 'Receipt Voucher', '2020-04-04 18:25:12', '2020-04-04 18:59:19', 0), (5, 'Payment Voucher', '2020-04-04 18:25:38', '2020-04-04 19:02:51', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_voucher_details` -- CREATE TABLE IF NOT EXISTS `tbl_voucher_details` ( `fld_voucher_details_id` int(11) NOT NULL, `fld_voucher_id` varchar(50) NOT NULL, `fld_payee_id` int(11) NOT NULL, `fld_voucher_type_id` int(11) NOT NULL, `fld_voucher_category_id` int(11) NOT NULL, `fld_description` text NOT NULL, `fld_amount` varchar(100) NOT NULL, `fld_gst` varchar(50) NOT NULL, `fld_final_amount` varchar(150) NOT NULL, `fld_payment_mode_id` int(11) NOT NULL, `fld_voucher_date` varchar(100) NOT NULL, `fld_voucher_status` varchar(150) NOT NULL DEFAULT 'Not_final', `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_voucher_details_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_voucher_details` -- INSERT INTO `tbl_voucher_details` (`fld_voucher_details_id`, `fld_voucher_id`, `fld_payee_id`, `fld_voucher_type_id`, `fld_voucher_category_id`, `fld_description`, `fld_amount`, `fld_gst`, `fld_final_amount`, `fld_payment_mode_id`, `fld_voucher_date`, `fld_voucher_status`, `fld_created_date`, `fld_modified_date`, `fld_voucher_details_delete`) VALUES (1, 'GBV1', 2, 2, 5, 'asdas', '5000', '10', '5500', 2, '2020-04-17', 'Final', '2020-04-04 19:22:24', '2020-04-04 19:36:06', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_voucher_type` -- CREATE TABLE IF NOT EXISTS `tbl_voucher_type` ( `fld_voucher_type_id` int(11) NOT NULL, `fld_voucher_type` varchar(255) NOT NULL, `fld_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `fld_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `fld_voucher_type_delete` int(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_voucher_type` -- INSERT INTO `tbl_voucher_type` (`fld_voucher_type_id`, `fld_voucher_type`, `fld_created_date`, `fld_modified_date`, `fld_voucher_type_delete`) VALUES (1, 'Supporting Vouchers', '2020-04-04 18:20:18', '2020-04-04 18:20:18', 0), (2, 'Accounting Vouchers', '2020-04-04 18:20:51', '2020-04-04 18:20:51', 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_admin` -- ALTER TABLE `tbl_admin` ADD PRIMARY KEY (`fld_id`), ADD UNIQUE KEY `fld_email` (`fld_email`); -- -- Indexes for table `tbl_city` -- ALTER TABLE `tbl_city` ADD PRIMARY KEY (`fld_city_id`); -- -- Indexes for table `tbl_course` -- ALTER TABLE `tbl_course` ADD PRIMARY KEY (`fld_course_id`); -- -- Indexes for table `tbl_course_details` -- ALTER TABLE `tbl_course_details` ADD PRIMARY KEY (`fld_course_details_id`); -- -- Indexes for table `tbl_dynamic_header_footer` -- ALTER TABLE `tbl_dynamic_header_footer` ADD PRIMARY KEY (`fld_id`); -- -- Indexes for table `tbl_employee_qualification` -- ALTER TABLE `tbl_employee_qualification` ADD PRIMARY KEY (`fld_emp_id`); -- -- Indexes for table `tbl_empolyee_details` -- ALTER TABLE `tbl_empolyee_details` ADD PRIMARY KEY (`fld_emp_details_id`), ADD UNIQUE KEY `fld_employee_id` (`fld_employee_id`,`fld_emp_email`); -- -- Indexes for table `tbl_gst` -- ALTER TABLE `tbl_gst` ADD PRIMARY KEY (`fld_gst_id`); -- -- Indexes for table `tbl_guest_lecture` -- ALTER TABLE `tbl_guest_lecture` ADD PRIMARY KEY (`fld_lecture_id`); -- -- Indexes for table `tbl_invoice` -- ALTER TABLE `tbl_invoice` ADD PRIMARY KEY (`fld_invoice_id`); -- -- Indexes for table `tbl_media` -- ALTER TABLE `tbl_media` ADD PRIMARY KEY (`fld_media_id`); -- -- Indexes for table `tbl_message` -- ALTER TABLE `tbl_message` ADD PRIMARY KEY (`fld_message_id`); -- -- Indexes for table `tbl_payee` -- ALTER TABLE `tbl_payee` ADD PRIMARY KEY (`fld_payee_id`); -- -- Indexes for table `tbl_payment_mode` -- ALTER TABLE `tbl_payment_mode` ADD PRIMARY KEY (`fld_payment_mode_id`); -- -- Indexes for table `tbl_state` -- ALTER TABLE `tbl_state` ADD PRIMARY KEY (`fld_state_id`); -- -- Indexes for table `tbl_student_occupation` -- ALTER TABLE `tbl_student_occupation` ADD PRIMARY KEY (`fld_occ_id`); -- -- Indexes for table `tbl_student_qualification` -- ALTER TABLE `tbl_student_qualification` ADD PRIMARY KEY (`fld_stud_id`); -- -- Indexes for table `tbl_student_reg` -- ALTER TABLE `tbl_student_reg` ADD PRIMARY KEY (`fld_stud_reg_id`), ADD UNIQUE KEY `fld_email` (`fld_email`); -- -- Indexes for table `tbl_taluka` -- ALTER TABLE `tbl_taluka` ADD PRIMARY KEY (`fld_taluka_id`); -- -- Indexes for table `tbl_voucher_category` -- ALTER TABLE `tbl_voucher_category` ADD PRIMARY KEY (`fld_voucher_category_id`); -- -- Indexes for table `tbl_voucher_details` -- ALTER TABLE `tbl_voucher_details` ADD PRIMARY KEY (`fld_voucher_details_id`); -- -- Indexes for table `tbl_voucher_type` -- ALTER TABLE `tbl_voucher_type` ADD PRIMARY KEY (`fld_voucher_type_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_admin` -- ALTER TABLE `tbl_admin` MODIFY `fld_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_city` -- ALTER TABLE `tbl_city` MODIFY `fld_city_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tbl_course` -- ALTER TABLE `tbl_course` MODIFY `fld_course_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_course_details` -- ALTER TABLE `tbl_course_details` MODIFY `fld_course_details_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tbl_dynamic_header_footer` -- ALTER TABLE `tbl_dynamic_header_footer` MODIFY `fld_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_employee_qualification` -- ALTER TABLE `tbl_employee_qualification` MODIFY `fld_emp_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_empolyee_details` -- ALTER TABLE `tbl_empolyee_details` MODIFY `fld_emp_details_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_gst` -- ALTER TABLE `tbl_gst` MODIFY `fld_gst_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_guest_lecture` -- ALTER TABLE `tbl_guest_lecture` MODIFY `fld_lecture_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `tbl_invoice` -- ALTER TABLE `tbl_invoice` MODIFY `fld_invoice_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tbl_media` -- ALTER TABLE `tbl_media` MODIFY `fld_media_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tbl_message` -- ALTER TABLE `tbl_message` MODIFY `fld_message_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_payee` -- ALTER TABLE `tbl_payee` MODIFY `fld_payee_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tbl_payment_mode` -- ALTER TABLE `tbl_payment_mode` MODIFY `fld_payment_mode_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_state` -- ALTER TABLE `tbl_state` MODIFY `fld_state_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_student_occupation` -- ALTER TABLE `tbl_student_occupation` MODIFY `fld_occ_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tbl_student_qualification` -- ALTER TABLE `tbl_student_qualification` MODIFY `fld_stud_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_student_reg` -- ALTER TABLE `tbl_student_reg` MODIFY `fld_stud_reg_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_taluka` -- ALTER TABLE `tbl_taluka` MODIFY `fld_taluka_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_voucher_category` -- ALTER TABLE `tbl_voucher_category` MODIFY `fld_voucher_category_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tbl_voucher_details` -- ALTER TABLE `tbl_voucher_details` MODIFY `fld_voucher_details_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_voucher_type` -- ALTER TABLE `tbl_voucher_type` MODIFY `fld_voucher_type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;