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

START TRANSACTION;



--
-- Database: `sisems_mobile_school`
--

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

--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `assignment_description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `create_date` date NOT NULL,
  `update_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `attendance_details`
--

CREATE TABLE `attendance_details` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `attendance_id` int(11) NOT NULL,
  `mark` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `attendence`
--

CREATE TABLE `attendence` (
  `id` int(25) NOT NULL,
  `date` varchar(80) NOT NULL,
  `class_id` int(25) DEFAULT NULL,
  `class_year` varchar(20) NOT NULL,
  `division` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `bank_id` int(10) UNSIGNED NOT NULL,
  `bank` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bonafied`
--

CREATE TABLE `bonafied` (
  `srno` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `date` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `buses`
--

CREATE TABLE `buses` (
  `id` int(11) NOT NULL,
  `bus_no` varchar(25) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `caste`
--

CREATE TABLE `caste` (
  `caste_id` int(25) UNSIGNED NOT NULL,
  `caste_name` varchar(25) DEFAULT NULL,
  `religion` varchar(25) DEFAULT NULL,
  `category` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `caste`
--

INSERT INTO `caste` (`caste_id`, `caste_name`, `religion`, `category`) VALUES
(85, 'Hindu - Vadari', NULL, 'SC'),
(84, 'Hindu - Mahar ( S.C. )', NULL, NULL),
(121, 'Hindu - Bhamta Rajput', NULL, NULL),
(83, 'Mali', NULL, NULL),
(18, 'Hindu - Maratha', NULL, 'OPEN'),
(17, 'Hindu - Vanjari', NULL, NULL),
(19, 'Hindu - Vadar', NULL, NULL),
(20, 'Rajput', NULL, NULL),
(21, 'Hindu - Gupta', NULL, NULL),
(22, 'Hindu - Kaikadi', NULL, NULL),
(23, 'Nav Boudha (Mahar)', NULL, NULL),
(24, 'S.C.Moliya', NULL, NULL),
(25, 'Hindu - Brahman', NULL, NULL),
(26, 'Hindu - Maratha (Kumbhar)', NULL, NULL),
(27, 'Hindu - Sonar', NULL, NULL),
(28, 'Hindu - Lingayat', NULL, NULL),
(29, 'Hindu - Jain', NULL, NULL),
(30, '-', NULL, NULL),
(31, 'Hindu - Bedajangam', NULL, NULL),
(32, 'Hindu -  Agri', NULL, NULL),
(33, 'Hindu - Teli', NULL, NULL),
(34, 'Hindu - Mang', NULL, NULL),
(35, 'Hindu - Brahmin', NULL, NULL),
(36, 'Hindu - Dhangar', NULL, NULL),
(37, 'Muslim', NULL, NULL),
(38, 'Hindu-Kunabi', NULL, NULL),
(39, 'Hindu', NULL, NULL),
(40, 'Hindu- Chambhar', NULL, NULL),
(41, 'Hindu - Mali', NULL, NULL),
(42, 'Hindu - Mahar', NULL, NULL),
(43, 'Hindu - Nair', NULL, NULL),
(44, 'Kunbi', NULL, NULL),
(45, 'Hindu - Sindhi', NULL, NULL),
(46, 'Hindu - Kumbhar', NULL, NULL),
(47, 'Nav - Boudha', NULL, NULL),
(48, 'Hindu - Wani', NULL, NULL),
(49, 'Maratha', NULL, NULL),
(50, 'Hindu - Joshi', NULL, NULL),
(51, 'Hindu - Sutar', NULL, NULL),
(52, 'Panjabi', NULL, NULL),
(53, 'Hindu  - Gadilohar', NULL, NULL),
(54, ' Hindu - Beldar', NULL, NULL),
(55, 'Hindu - Mahadev Koli', NULL, NULL),
(56, 'Hindu - Gurav', NULL, NULL),
(57, 'Hindu - Patel  ( Kunbi )', NULL, NULL),
(58, 'Hindu -Ti - Kunbi', NULL, NULL),
(59, 'Hindu - Parit', NULL, NULL),
(60, 'Hindu - C.K.P.', NULL, NULL),
(61, 'Hindu - Navhi', NULL, NULL),
(62, 'Hindu - Phulmali', NULL, NULL),
(63, 'Buddhist', NULL, NULL),
(64, 'Hindu - Shimpi (OBC )', NULL, NULL),
(65, 'Hindu - Koshti', NULL, NULL),
(66, 'Hindu - Rajasthani', NULL, NULL),
(67, 'Hindu - Kanoji Brahman', NULL, NULL),
(68, 'Hindu - Shimpi ', NULL, NULL),
(69, 'Hindu -  Matang', NULL, NULL),
(70, 'Hindu -  Marwadi', NULL, NULL),
(71, 'Hindu - Bhoi', NULL, NULL),
(72, 'Hindu - Gangi Teli', NULL, NULL),
(73, 'Hindu - Koli ( Mahadeo )', NULL, NULL),
(74, 'Hindu - Mali ( O.B.C. )', NULL, NULL),
(75, 'Hindu -  Kasar', NULL, NULL),
(76, 'Hindu - Ramoshi', NULL, NULL),
(77, 'Deshstha - Brahman', NULL, NULL),
(78, 'Hindu - Namdev Shimpi', NULL, NULL),
(79, 'Hindu - Kachmali', NULL, NULL),
(80, 'Hindu - Mang ( S.C. )', NULL, NULL),
(81, 'Muslim - Beldar (N.T)', NULL, NULL),
(82, 'Hindu - Parit', NULL, NULL),
(86, 'Hindu - Beda Jangam', NULL, NULL),
(87, 'Hindu - Gondhali', NULL, NULL),
(88, 'Roman - Cathalic', NULL, NULL),
(89, 'Hindu - Sali', NULL, NULL),
(90, 'Hindu - Lingayat Wani', NULL, NULL),
(91, 'Hindu - Laman', NULL, NULL),
(92, 'Hindu - Lad Sharviya Wani', NULL, NULL),
(93, 'Hindu - Sangar', NULL, NULL),
(94, 'Hindu - Gujar', NULL, NULL),
(95, 'Hindu - Dongri Dhangar', NULL, NULL),
(96, 'Hindu - Wadar', NULL, NULL),
(97, 'Hindu - Ti - Kunbi', NULL, NULL),
(98, 'Halba', NULL, NULL),
(99, 'Hindu - Kadva Patel', NULL, NULL),
(100, 'Khutekar', NULL, NULL),
(101, 'Komati', NULL, NULL),
(102, 'Hindu - Tillori Kunbi', NULL, NULL),
(103, 'Hindu - Kokani', NULL, NULL),
(104, 'Hindu - Lamani', NULL, NULL),
(105, 'Lingayat - Wani', NULL, NULL),
(106, 'Hindu - Dhor', NULL, NULL),
(107, 'Kokani Maratha', NULL, NULL),
(108, 'Hindu - Shiravi', NULL, NULL),
(109, 'Hindu - Bhangi', NULL, NULL),
(110, 'Hindu - Nav Buddha', NULL, NULL),
(111, 'Musalman', NULL, NULL),
(112, 'Hindu - Kunbi', NULL, NULL),
(113, 'Hindu - Padmasali', NULL, NULL),
(114, 'Hindu - Khatik', NULL, NULL),
(115, 'Hindu - Vaishnav ( Indian', NULL, NULL),
(116, 'Gosavi', NULL, NULL),
(117, 'Hindu- Arya Vaishya Komt', NULL, NULL),
(118, 'Hindu - Namdeo Shimpi', NULL, NULL),
(119, 'Nav - Boudd', NULL, NULL),
(120, 'Hindu -Tweshtakasar(Tamba', NULL, NULL),
(122, 'Hindu - Erakal', NULL, NULL),
(123, 'Nabhik', NULL, NULL),
(124, 'Dhangar', NULL, NULL),
(125, 'Boudha', NULL, NULL),
(126, 'Hindu - Vedajangam', NULL, NULL),
(127, 'Hindu - Tokre Koli', NULL, NULL),
(128, 'Hindu - Bhavsar Kshatriya', NULL, NULL),
(129, 'Matang', NULL, NULL),
(130, 'Jain - Chaturth', NULL, NULL),
(131, 'Hindu - Fulmali', NULL, NULL),
(132, 'Hindu - Lonari', NULL, NULL),
(133, 'Kadiya', NULL, NULL),
(134, 'Hindu - Biilava', NULL, NULL),
(135, 'Hindu-Kshatriya Gadi-Loha', NULL, NULL),
(136, 'Hindu - Bhil', NULL, NULL),
(137, 'Hindu-Manner-Varlu ( ST)', NULL, NULL),
(138, 'Hindu - Leva Patil', NULL, NULL),
(139, 'Hindu - Kunbi ( OBC )', NULL, NULL),
(140, 'Hindu - Nhavi', NULL, NULL),
(141, 'Nav - Boudh', NULL, NULL),
(142, 'Hindu - Lad', NULL, NULL),
(143, 'Muslim - Fakir', NULL, NULL),
(144, 'H. Dhangar', NULL, NULL),
(145, 'Hindu - Vai. Vani', NULL, NULL),
(146, 'Hindu - Koli', NULL, NULL),
(147, 'Hindu-Thakur', NULL, NULL),
(148, 'Hindu - Gopal', NULL, NULL),
(149, 'Hindu - Devang Koshti', NULL, NULL),
(150, 'Jain - Bhartiya', NULL, NULL),
(151, 'Mahar', NULL, NULL),
(152, 'Hindu - Brahman Kanadi', NULL, NULL),
(153, 'Hindu - Dhobi', NULL, NULL),
(154, 'Hindu - Non B.C.', NULL, NULL),
(155, 'Hindu - Gosavi', NULL, NULL),
(156, 'Hindu - Wadari', NULL, NULL),
(157, 'Bigar Magas Shimpi', NULL, NULL),
(158, 'Hindu - Loniya', NULL, NULL),
(159, 'Hindu - Komti', NULL, NULL),
(160, 'Hindu-Dodegujar', NULL, NULL),
(161, 'Lingayat', NULL, NULL),
(162, 'Hindu - Lingayat Jangam', NULL, NULL),
(163, 'Hindu - Leva Patidar  O. ', NULL, NULL),
(164, 'Hindu - Holar', NULL, NULL),
(165, 'Hindu - Teli', NULL, NULL),
(166, 'Hindu - Vai-Vaniya', NULL, NULL),
(167, 'Hindu - Teli, Tilwan Teli', NULL, NULL),
(168, 'Hindu - Twasta Kasar', NULL, NULL),
(169, 'Hindu - Rabari', NULL, NULL),
(170, 'Hindu - Gavali', NULL, NULL),
(171, 'Jain', NULL, NULL),
(172, 'Mang', NULL, NULL),
(173, 'Hindu - Aadigaud Brahmin', NULL, NULL),
(174, 'Hindu - Swakul Sali', NULL, NULL),
(175, 'Hindu - Mahadev Koli (S.T', NULL, NULL),
(176, 'Hindu - Kolhati', NULL, NULL),
(177, 'hindu - kakaiya', NULL, NULL),
(178, 'hindu-kakaiya', NULL, NULL),
(211, 'Christian Roman Cathilic', NULL, NULL),
(203, 'Hindu - Vaishy Wani', NULL, NULL),
(181, 'Beldar', NULL, NULL),
(182, 'Muslim - Shimpi', NULL, NULL),
(183, 'Hindu - Pardhi', NULL, NULL),
(185, 'Hindu-Lamani', NULL, NULL),
(202, 'Hindu - Bhavsar', NULL, NULL),
(210, 'Brahman', NULL, NULL),
(188, 'Hindu Chitode Wani', NULL, NULL),
(189, 'Hindu - Yallam', NULL, NULL),
(190, 'Hindu - Leva Patidar (OBC', NULL, NULL),
(191, 'Jain Swetambar', NULL, NULL),
(192, 'Hindu - Rajput', NULL, NULL),
(193, 'Pardhi', NULL, NULL),
(194, 'Laman', NULL, NULL),
(195, 'Chaparband', NULL, NULL),
(196, 'Hindu - Ahir ( SC )', NULL, NULL),
(197, 'Hindu - Ahir', NULL, NULL),
(198, 'Hindu - Rangari', NULL, NULL),
(199, 'Hindu - Golla', NULL, NULL),
(200, 'Rajput Bhamta', NULL, NULL),
(201, 'Hindu - Kunbi Patil', NULL, NULL),
(204, 'Hindu - Banjari Laman', NULL, NULL),
(205, 'Kadava Patidar', NULL, NULL),
(206, 'Hindu - Saroj', NULL, NULL),
(207, 'Hindu - Gujarathi', NULL, NULL),
(208, 'Hindu - Kadva Patidar', NULL, NULL),
(209, 'Hindu - Sonar', NULL, NULL),
(212, 'Hindu - Marwadi Brahman', NULL, NULL),
(213, 'Ramoshi', NULL, NULL),
(214, 'Hindu - Kurmi', NULL, NULL),
(215, 'Hindu Kunbi Patil OBC', NULL, NULL),
(216, 'Islam Mulsim', NULL, NULL),
(217, 'Christian R. C.', NULL, NULL),
(218, 'Gavali', NULL, NULL),
(219, 'Hindu - Arya Vaishya Komt', NULL, NULL),
(220, 'Hindu - Dhangar  NT-29', NULL, NULL),
(221, 'Hindu  - Mahar ( Holer )', NULL, NULL),
(222, 'Kokni - Brahmin', NULL, NULL),
(223, 'Hindu - Dashanema Gujar', NULL, NULL),
(224, 'Hindu Brahmin Non B. C.', NULL, NULL),
(225, 'Nav - Bouddha', NULL, NULL),
(226, 'Bauddha', NULL, NULL),
(227, 'Hindu - Agri', NULL, NULL),
(228, 'Jain Marwadi', NULL, NULL),
(229, 'Muslim - Momin', NULL, NULL),
(230, 'Bhavsar', NULL, NULL),
(231, 'Hindu - Levapatidar', NULL, NULL),
(232, 'Hindu - Lohar', NULL, NULL),
(233, 'Hindu - Bhavsar Shimpi', NULL, NULL),
(234, 'Hindu - Murav', NULL, NULL),
(235, 'Hindu - Bhillav', NULL, NULL),
(236, 'S. C.', NULL, NULL),
(237, 'Hindu - Lingayat Vani', NULL, NULL),
(238, 'Hindu - Madar', NULL, NULL),
(239, 'Hindu - Badai ( Sutar )', NULL, NULL),
(240, 'H.  Daivdny Brahmin(Sonar', NULL, NULL),
(241, 'Hindu - Marwari', NULL, NULL),
(242, 'Hindu - Bhamta', NULL, NULL),
(243, 'Hindu - Boudh', NULL, NULL),
(244, 'Vanjari', NULL, NULL),
(245, 'Hindu  - Tilori Kunbi', NULL, NULL),
(246, 'Hindu - Shegar', NULL, NULL),
(247, 'Hindu - Shimpi Namdeo', NULL, NULL),
(248, 'Hindu - Burud', NULL, NULL),
(249, 'Navbaudha', NULL, NULL),
(250, 'Hindu - Thakar', NULL, NULL),
(251, 'Hindu - Bava Gosavi', NULL, NULL),
(252, 'Hindu-Bhope', NULL, NULL),
(253, 'Hindu - Maheshwari', NULL, NULL),
(258, 't', NULL, 'OBC'),
(262, 'tests', NULL, 'OBC'),
(260, 'a', NULL, 'SC');

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

--
-- Table structure for table `circular`
--

CREATE TABLE `circular` (
  `id` int(11) NOT NULL,
  `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `circulars_tmp`
--

CREATE TABLE `circulars_tmp` (
  `id` int(11) NOT NULL,
  `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `circular_schoolclass`
--

CREATE TABLE `circular_schoolclass` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `circular_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `class`
--

CREATE TABLE `class` (
  `class_id` int(25) UNSIGNED NOT NULL,
  `class_name` varchar(50) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  `Division` varchar(4) NOT NULL,
  `class_year` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `class_circulars`
--

CREATE TABLE `class_circulars` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `circular_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `class_year`
--

CREATE TABLE `class_year` (
  `class_year_id` int(10) UNSIGNED NOT NULL,
  `class_year_name` varchar(50) DEFAULT NULL,
  `class_year_desc` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `class_year`
--

INSERT INTO `class_year` (`class_year_id`, `class_year_name`, `class_year_desc`) VALUES
(1, 'PG', 'Play Gruop'),
(2, 'KG', ' Kindergarten'),
(3, 'LKG', 'Lower Kindergarten'),
(4, 'UKG', 'Upper Kindergarten'),
(5, 'I', 'First standard'),
(6, 'II', 'Second standard'),
(7, 'III', 'Third standard'),
(8, 'IV', 'Fourth standard'),
(9, 'V', 'Fifth standard'),
(10, 'VI', 'Six  standard');

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

--
-- Table structure for table `college_info`
--

CREATE TABLE `college_info` (
  `college_id` int(25) UNSIGNED NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `address` varchar(150) DEFAULT NULL,
  `reg_no` varchar(50) DEFAULT NULL,
  `logo` longblob,
  `extensionOflogo` varchar(10) DEFAULT NULL,
  `contact_no` varchar(50) DEFAULT NULL,
  `web_site` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `college_info`
--

INSERT INTO `college_info` (`college_id`, `name`, `address`, `reg_no`, `logo`, `extensionOflogo`, `contact_no`, `web_site`) VALUES
(1, 'DR. SB PREPRIMARY SCHOOL,BHOSARI', 'S.No. 68/3/1, Behind Kothrud P.M.T. Bus Depot, Paud Road, Pune-38.', '', 0x[BLOB], 'png', '020 - 25362055, 25361968 Fax: 25361967', '');

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

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

CREATE TABLE `documents` (
  `doc_id` int(25) UNSIGNED NOT NULL,
  `doc_name` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` (`doc_id`, `doc_name`) VALUES
(16, 'Cast Certificate'),
(3, 'Domicile'),
(11, 'TRAIN PASS'),
(12, 'nationality'),
(13, 'birth_certi');

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

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `student_first_name` varchar(150) NOT NULL,
  `student_last_name` varchar(150) NOT NULL,
  `student_dob` text NOT NULL,
  `seeking_admission_to` varchar(150) NOT NULL,
  `country` int(11) NOT NULL,
  `parent_first_name` varchar(150) NOT NULL,
  `parent_last_name` varchar(150) NOT NULL,
  `telephone_home` int(11) NOT NULL,
  `mobile_no` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `enquiry_comment` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL,
  `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `event_schoolclass`
--

CREATE TABLE `event_schoolclass` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `exam`
--

CREATE TABLE `exam` (
  `id` int(25) NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `exam_schoolclass`
--

CREATE TABLE `exam_schoolclass` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `expected_fee`
--

CREATE TABLE `expected_fee` (
  `id` int(11) NOT NULL,
  `standard` varchar(25) DEFAULT NULL,
  `academic_year` varchar(25) DEFAULT NULL,
  `fee_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `safty` varchar(150) NOT NULL,
  `good_progress` varchar(150) NOT NULL,
  `good_approach` varchar(150) NOT NULL,
  `good_management` varchar(150) NOT NULL,
  `extra_activity` varchar(150) NOT NULL,
  `good_facility` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fee_master`
--

CREATE TABLE `fee_master` (
  `fee_id` int(10) UNSIGNED NOT NULL,
  `fee_name` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fee_master`
--

INSERT INTO `fee_master` (`fee_id`, `fee_name`) VALUES
(1, 'Development Fees'),
(2, 'Other Fee'),
(3, 'Tution Fee'),
(6, 'Excess Fee'),
(7, 'Caution Money Deposit'),
(8, 'Contigency');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `event` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gps_track`
--

CREATE TABLE `gps_track` (
  `gps_id` int(11) NOT NULL,
  `latitude` varchar(250) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `longitude` varchar(250) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `vehicle_id` int(10) NOT NULL,
  `gps_time` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `homework`
--

CREATE TABLE `homework` (
  `id` int(11) NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `homework_schoolclass`
--

CREATE TABLE `homework_schoolclass` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `homework_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `leaving_certificate`
--

CREATE TABLE `leaving_certificate` (
  `lc_id` int(10) UNSIGNED NOT NULL,
  `student_id` int(11) DEFAULT NULL,
  `serial_no` int(11) DEFAULT NULL,
  `leaving_date` varchar(25) DEFAULT NULL,
  `progress` text,
  `conduct` text,
  `reason` text,
  `remark` text,
  `study_year` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(25) NOT NULL,
  `student_id` int(25) NOT NULL,
  `class_id` int(11) NOT NULL,
  `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `title`, `created_at`, `updated_at`) VALUES
(1, 'Cash', '2022-05-13 08:18:04', NULL),
(2, 'Cheque', '2022-05-13 08:18:04', NULL),
(3, 'Card', '2022-05-13 08:18:24', NULL),
(4, 'Gpay', '2022-05-13 08:18:24', NULL);

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

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL,
  `full_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `qualification`
--

CREATE TABLE `qualification` (
  `qualification_code` varchar(5) NOT NULL,
  `qualification` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `qualification`
--

INSERT INTO `qualification` (`qualification_code`, `qualification`) VALUES
('OTH', 'Other'),
('ITI', 'ITI'),
('MCVC', 'MCVC'),
('HSC', 'HSC'),
('SSC', 'SSC');

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

--
-- Table structure for table `receipt`
--

CREATE TABLE `receipt` (
  `receipt_id` int(11) NOT NULL,
  `receipt_no` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `payment_method` varchar(25) DEFAULT NULL,
  `cheque_no` varchar(25) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `date` varchar(40) DEFAULT NULL,
  `receipt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pm_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_details`
--

CREATE TABLE `receipt_details` (
  `id` int(11) NOT NULL,
  `receipt_id` int(11) NOT NULL,
  `fee_id` int(11) NOT NULL,
  `paid_amount` double NOT NULL,
  `description` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report`
--

CREATE TABLE `report` (
  `report_id` int(25) UNSIGNED NOT NULL,
  `year` varchar(25) DEFAULT NULL,
  `report_name` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_details`
--

CREATE TABLE `report_details` (
  `year_id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `f1` varchar(50) NOT NULL,
  `f2` varchar(50) NOT NULL,
  `f3` varchar(50) NOT NULL,
  `f4` varchar(50) NOT NULL,
  `f5` varchar(50) NOT NULL,
  `f6` varchar(50) NOT NULL,
  `f7` varchar(50) NOT NULL,
  `f8` varchar(50) NOT NULL,
  `f9` varchar(50) NOT NULL,
  `f10` varchar(50) NOT NULL,
  `f11` varchar(50) NOT NULL,
  `f12` varchar(50) NOT NULL,
  `f13` varchar(50) NOT NULL,
  `f14` varchar(50) NOT NULL,
  `f15` varchar(50) NOT NULL,
  `f16` varchar(50) NOT NULL,
  `f17` varchar(50) NOT NULL,
  `f18` varchar(50) NOT NULL,
  `f19` varchar(50) NOT NULL,
  `f20` varchar(50) NOT NULL,
  `f21` varchar(100) NOT NULL,
  `f22` varchar(50) NOT NULL,
  `f23` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL,
  `can_admin` smallint(6) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id`, `name`, `create_time`, `update_time`, `can_admin`) VALUES
(1, 'Admin', '2015-11-05 04:57:35', NULL, 1),
(2, 'User', '2015-11-05 04:57:35', NULL, 0);

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

--
-- Table structure for table `scholarship_fees`
--

CREATE TABLE `scholarship_fees` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `cheque_no` int(11) NOT NULL,
  `fee_id` int(11) NOT NULL,
  `date` varchar(30) NOT NULL,
  `adjusted` tinyint(4) NOT NULL,
  `scholarship_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `scholarship_inward`
--

CREATE TABLE `scholarship_inward` (
  `inward_id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `date` varchar(30) NOT NULL,
  `bank_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `scholarship_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `scholarship_receipt`
--

CREATE TABLE `scholarship_receipt` (
  `sr_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `date` varchar(15) NOT NULL,
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `scholarship_type`
--

CREATE TABLE `scholarship_type` (
  `scholarship_id` int(11) NOT NULL,
  `scholarship_name` varchar(40) NOT NULL,
  `description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `schoolclass`
--

CREATE TABLE `schoolclass` (
  `id` int(11) NOT NULL,
  `standard` varchar(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `division` varchar(1) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `staff_id` int(25) UNSIGNED NOT NULL,
  `name` varchar(25) DEFAULT NULL,
  `date_of_birth` varchar(25) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `photo` longblob,
  `extensionOfphoto` varchar(10) DEFAULT NULL,
  `date_of_join` varchar(25) DEFAULT NULL,
  `designation` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `students_expected_fees`
--

CREATE TABLE `students_expected_fees` (
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `fee_id` int(11) NOT NULL,
  `amount` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_class`
--

CREATE TABLE `student_class` (
  `student_id` int(11) NOT NULL,
  `roll_no` int(11) DEFAULT NULL,
  `class_id` int(11) NOT NULL,
  `result` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_document`
--

CREATE TABLE `student_document` (
  `student_id` int(11) NOT NULL,
  `doc_id` int(11) NOT NULL,
  `submitted` tinyint(1) NOT NULL,
  `returned` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_fee`
--

CREATE TABLE `student_fee` (
  `fee_id` int(11) NOT NULL,
  `student_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `cheque_no` varchar(25) DEFAULT NULL,
  `payment_method` varchar(25) DEFAULT NULL,
  `date` varchar(25) DEFAULT NULL,
  `paid_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `paid_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `paid_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `scholarship_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `scholarship_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `scholarship_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `balance_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `balance_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `balance_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `paid_schol_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `paid_schol_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `paid_schol_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `expected_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `expected_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0',
  `expected_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_qualification`
--

CREATE TABLE `student_qualification` (
  `student_id` int(11) NOT NULL,
  `qualification_code` varchar(10) NOT NULL,
  `board` varchar(100) NOT NULL,
  `year_of_passing` varchar(10) NOT NULL,
  `total_marks` int(11) NOT NULL,
  `percentage` float NOT NULL,
  `remark` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_scholarship`
--

CREATE TABLE `student_scholarship` (
  `student_scholarship_id` int(11) NOT NULL,
  `scholarship_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `approved_scholorship` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL,
  `requested_scholorship` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_scholarship_expenses`
--

CREATE TABLE `student_scholarship_expenses` (
  `expense_id` int(11) NOT NULL,
  `student_scholarship_id` int(11) NOT NULL,
  `given_to_student` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `bank_id` int(11) NOT NULL,
  `adjusted_tution` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL,
  `adjusted_development` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL,
  `adjusted_other` varchar(100) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL,
  `receipt_no` int(100) NOT NULL,
  `date` varchar(20) NOT NULL,
  `class_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subject`
--

CREATE TABLE `subject` (
  `id` int(11) NOT NULL,
  `subject_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `subject_name`) VALUES
(1, 'Geography'),
(2, 'English'),
(3, 'Science'),
(4, 'Marathi'),
(5, 'Hindi'),
(6, 'Math-I'),
(7, 'Marathi'),
(9, 'History'),
(10, 'English'),
(11, 'Mathematics - II');

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

--
-- Table structure for table `subject_ols`
--

CREATE TABLE `subject_ols` (
  `subject_id` int(25) UNSIGNED NOT NULL,
  `subject_name` varchar(25) DEFAULT NULL,
  `sub_type` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subject_schoolclass`
--

CREATE TABLE `subject_schoolclass` (
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timetable`
--

CREATE TABLE `timetable` (
  `id` int(25) NOT NULL,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

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

--
-- Table structure for table `timetable_schoolclass`
--

CREATE TABLE `timetable_schoolclass` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `timetable_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_log`
--

CREATE TABLE `users_log` (
  `id` int(10) NOT NULL,
  `user_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `severity` int(5) NOT NULL,
  `user_ip` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `date_time` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `user_auth`
--

CREATE TABLE `user_auth` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `provider` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `provider_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `provider_attributes` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `user_key`
--

CREATE TABLE `user_key` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` smallint(6) NOT NULL,
  `key_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `consume_time` timestamp NULL DEFAULT NULL,
  `expire_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_key`
--

INSERT INTO `user_key` (`id`, `user_id`, `type`, `key_value`, `create_time`, `consume_time`, `expire_time`) VALUES
(1, 2, 1, 'spLip1d9vv-Ef1-mMdC7swZ_lHvfQuuM', '2015-11-05 23:17:52', NULL, NULL),
(2, 3, 1, 'Vyhkav17TDxqVKKoBD7kByxHYRDI0Boe', '2015-11-06 00:39:56', NULL, NULL);

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

--
-- Table structure for table `year`
--

CREATE TABLE `year` (
  `year_id` int(11) NOT NULL,
  `year_name` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `year`
--

INSERT INTO `year` (`year_id`, `year_name`) VALUES
(1, 'First Year'),
(2, 'Second Year'),
(3, 'Third Year');


--
-- Table structure for table `timetable_new`
--

CREATE TABLE `timetable_new` (
  `id` int(11) NOT NULL,
  `time` varchar(20) DEFAULT NULL,
  `Monday` int(11) DEFAULT NULL,
  `Tuesday` int(11) DEFAULT NULL,
  `Wednesday` int(11) DEFAULT NULL,
  `Thursday` int(11) DEFAULT NULL,
  `Friday` int(11) DEFAULT NULL,
  `Saturday` int(11) NOT NULL,
  `Sunday` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `bank`
--
ALTER TABLE `bank`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `bonafied`
--
ALTER TABLE `bonafied`
  ADD PRIMARY KEY (`srno`);

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

--
-- Indexes for table `caste`
--
ALTER TABLE `caste`
  ADD PRIMARY KEY (`caste_id`);

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

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

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

--
-- Indexes for table `class`
--
ALTER TABLE `class`
  ADD PRIMARY KEY (`class_id`);

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

--
-- Indexes for table `class_year`
--
ALTER TABLE `class_year`
  ADD PRIMARY KEY (`class_year_id`);

--
-- Indexes for table `college_info`
--
ALTER TABLE `college_info`
  ADD PRIMARY KEY (`college_id`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`doc_id`),
  ADD UNIQUE KEY `doc_id_index` (`doc_id`);

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

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

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

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

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

--
-- Indexes for table `expected_fee`
--
ALTER TABLE `expected_fee`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fee_id` (`fee_id`);

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

--
-- Indexes for table `fee_master`
--
ALTER TABLE `fee_master`
  ADD PRIMARY KEY (`fee_id`);

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

--
-- Indexes for table `gps_track`
--
ALTER TABLE `gps_track`
  ADD PRIMARY KEY (`gps_id`);

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

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

--
-- Indexes for table `leaving_certificate`
--
ALTER TABLE `leaving_certificate`
  ADD PRIMARY KEY (`lc_id`),
  ADD KEY `student_id` (`student_id`);

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

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

--
-- Indexes for table `profile`
--
ALTER TABLE `profile`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profile_user_id` (`user_id`);

--
-- Indexes for table `qualification`
--
ALTER TABLE `qualification`
  ADD PRIMARY KEY (`qualification_code`);

--
-- Indexes for table `receipt`
--
ALTER TABLE `receipt`
  ADD PRIMARY KEY (`receipt_id`);

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

--
-- Indexes for table `report`
--
ALTER TABLE `report`
  ADD PRIMARY KEY (`report_id`);

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

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

--
-- Indexes for table `scholarship_inward`
--
ALTER TABLE `scholarship_inward`
  ADD PRIMARY KEY (`inward_id`);

--
-- Indexes for table `scholarship_receipt`
--
ALTER TABLE `scholarship_receipt`
  ADD PRIMARY KEY (`sr_id`);

--
-- Indexes for table `scholarship_type`
--
ALTER TABLE `scholarship_type`
  ADD PRIMARY KEY (`scholarship_id`);

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

--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
  ADD PRIMARY KEY (`staff_id`),
  ADD UNIQUE KEY `staff_id_index` (`staff_id`);

--
-- Indexes for table `student_class`
--
ALTER TABLE `student_class`
  ADD PRIMARY KEY (`student_id`,`class_id`);

--
-- Indexes for table `student_fee`
--
ALTER TABLE `student_fee`
  ADD PRIMARY KEY (`fee_id`);

--
-- Indexes for table `student_qualification`
--
ALTER TABLE `student_qualification`
  ADD PRIMARY KEY (`student_id`,`qualification_code`);

--
-- Indexes for table `student_scholarship`
--
ALTER TABLE `student_scholarship`
  ADD PRIMARY KEY (`student_scholarship_id`),
  ADD KEY `scholarship_id` (`scholarship_id`),
  ADD KEY `student_id` (`student_id`),
  ADD KEY `class_id` (`class_id`);

--
-- Indexes for table `student_scholarship_expenses`
--
ALTER TABLE `student_scholarship_expenses`
  ADD PRIMARY KEY (`expense_id`),
  ADD KEY `student_scholarship_id` (`student_scholarship_id`);

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

--
-- Indexes for table `subject_ols`
--
ALTER TABLE `subject_ols`
  ADD PRIMARY KEY (`subject_id`);

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

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

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

--
-- Indexes for table `user_auth`
--
ALTER TABLE `user_auth`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_auth_provider_id` (`provider_id`),
  ADD KEY `user_auth_user_id` (`user_id`);

--
-- Indexes for table `user_key`
--
ALTER TABLE `user_key`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_key_key` (`key_value`),
  ADD KEY `user_key_user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `attendence`
--
ALTER TABLE `attendence`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `bonafied`
--
ALTER TABLE `bonafied`
  MODIFY `srno` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `caste`
--
ALTER TABLE `caste`
  MODIFY `caste_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=263;

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

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

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

--
-- AUTO_INCREMENT for table `class`
--
ALTER TABLE `class`
  MODIFY `class_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `class_year`
--
ALTER TABLE `class_year`
  MODIFY `class_year_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `college_info`
--
ALTER TABLE `college_info`
  MODIFY `college_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `doc_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

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

--
-- AUTO_INCREMENT for table `exam`
--
ALTER TABLE `exam`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `fee_master`
--
ALTER TABLE `fee_master`
  MODIFY `fee_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

--
-- AUTO_INCREMENT for table `gps_track`
--
ALTER TABLE `gps_track`
  MODIFY `gps_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `receipt`
--
ALTER TABLE `receipt`
  MODIFY `receipt_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `report`
--
ALTER TABLE `report`
  MODIFY `report_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `scholarship_inward`
--
ALTER TABLE `scholarship_inward`
  MODIFY `inward_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `scholarship_receipt`
--
ALTER TABLE `scholarship_receipt`
  MODIFY `sr_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `scholarship_type`
--
ALTER TABLE `scholarship_type`
  MODIFY `scholarship_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `staff_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_fee`
--
ALTER TABLE `student_fee`
  MODIFY `fee_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_scholarship`
--
ALTER TABLE `student_scholarship`
  MODIFY `student_scholarship_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_scholarship_expenses`
--
ALTER TABLE `student_scholarship_expenses`
  MODIFY `expense_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `subject_ols`
--
ALTER TABLE `subject_ols`
  MODIFY `subject_id` int(25) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timetable`
--
ALTER TABLE `timetable`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `profile`
--
ALTER TABLE `profile`
  ADD CONSTRAINT `profile_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Constraints for table `student_scholarship_expenses`
--
ALTER TABLE `student_scholarship_expenses`
  ADD CONSTRAINT `student_scholarship_expenses_ibfk_1` FOREIGN KEY (`student_scholarship_id`) REFERENCES `student_scholarship` (`student_scholarship_id`);

--
-- Constraints for table `user_auth`
--
ALTER TABLE `user_auth`
  ADD CONSTRAINT `user_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Constraints for table `user_key`
--
ALTER TABLE `user_key`
  ADD CONSTRAINT `user_key_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
  
  
  --
-- Indexes for table `timetable_new`
--
ALTER TABLE `timetable_new`
  ADD PRIMARY KEY (`id`);
  
--
-- AUTO_INCREMENT for table `timetable_new`
--
ALTER TABLE `timetable_new`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
COMMIT;

