-- 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 */;
