관리-도구
편집 파일: schoolmanagement-1.sql
-- phpMyAdmin SQL Dump -- version 4.9.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Mar 03, 2020 at 05:28 PM -- Server version: 5.7.28 -- PHP Version: 5.6.40 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `schoolmanagement` -- -- -------------------------------------------------------- -- -- Table structure for table `about` -- DROP TABLE IF EXISTS `about`; CREATE TABLE IF NOT EXISTS `about` ( `about_id` int(11) NOT NULL AUTO_INCREMENT, `about_content` longtext COLLATE utf8_bin, `user_id` int(11) NOT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, `meta_keywords` text COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`about_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `about` -- INSERT INTO `about` (`about_id`, `about_content`, `user_id`, `meta_description`, `meta_keywords`, `meta_title`, `page_image`) VALUES (1, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. In rhoncus justo et pellentesque blandit. Suspendisse potenti. Mauris at sapien sapien. Phasellus ut risus vestibulum, laoreet tortor volutpat, auctor urna. Ut vitae fermentum purus, a efficitur ipsum. Praesent non bibendum ex. Curabitur ac augue magna. Quisque ac nunc nec lacus condimentum sagittis sed non lorem. Aliquam non nunc et quam pretium convallis. Vestibulum elit dui, dignissim sed cursus hendrerit, vulputate eu tellus. Praesent elementum venenatis augue, sit amet condimentum lorem malesuada sit amet. Aliquam erat volutpat. Fusce volutpat at sapien porta porta. Maecenas lacinia, augue at condimentum tincidunt, tellus nisi maximus velit, ac pulvinar nibh sem at orci. Mauris quis turpis et ex lobortis interdum. Phasellus ante lectus, scelerisque id sollicitudin a, hendrerit sit amet erat.</p>\r\n<p>Praesent blandit hendrerit orci. Sed maximus, est in bibendum commodo, urna nunc euismod enim, a ornare felis ante ut dui. Sed consectetur fringilla lacus nec fringilla. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Maecenas interdum lacus a justo porta facilisis. Nam vulputate quam non turpis venenatis sollicitudin. Duis ac purus molestie, suscipit erat in, tempus diam. Nullam vulputate, tortor ut eleifend congue, lectus nulla rhoncus purus, id condimentum justo nulla ut felis. Suspendisse potenti. Phasellus purus elit, feugiat luctus purus et, ullamcorper ultrices dolor. Vivamus imperdiet odio id nisi lobortis, in ultrices lectus venenatis. Phasellus nibh dui, ultrices in lobortis quis, condimentum in eros.</p>\r\n<p>Praesent eget nisi quis quam consequat volutpat et ac dui. Vivamus sagittis ligula non mauris scelerisque laoreet. Integer non nulla porta, porttitor nibh id, tincidunt velit. Etiam quis urna eu diam aliquet tempor. Proin vehicula massa id accumsan pellentesque. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed dapibus, libero eget laoreet gravida, ligula tortor elementum magna, in fermentum lorem velit a odio.</p>\r\n<p>In sem mauris, hendrerit et imperdiet eu, tincidunt in erat. Mauris sagittis aliquet egestas. Sed nulla ligula, pharetra cursus sem nec, pellentesque laoreet dolor. Integer gravida pharetra dolor, sit amet maximus ipsum consectetur sit amet. Pellentesque eget lectus quis mi elementum lacinia. Quisque viverra ligula velit, porttitor volutpat risus tincidunt non. Vestibulum quis porttitor nunc. In hac habitasse platea dictumst. Nam lorem augue, tristique eu risus ac, rhoncus consequat neque.</p>\r\n<p>Donec facilisis sagittis dui, pharetra tristique purus feugiat hendrerit. Cras auctor semper sem, ut eleifend dui tempor quis. Ut ac nulla in leo porta vehicula. Nulla dapibus, ligula non fringilla vestibulum, eros nisi tristique dui, in interdum mi mi egestas ipsum. Curabitur tellus purus, tempus in imperdiet vel, finibus tincidunt felis. Integer auctor ornare sagittis. Nulla ante velit, convallis sit amet tincidunt quis, lacinia quis quam.</p>', 1, 'about us', 'about us', 'about us', '5e595ade8d2507.27914186.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `admissions` -- DROP TABLE IF EXISTS `admissions`; CREATE TABLE IF NOT EXISTS `admissions` ( `admissions_id` int(255) NOT NULL AUTO_INCREMENT, `admissions_title` varchar(255) COLLATE utf8_bin NOT NULL, `admissions_content` longtext COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`admissions_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `admissions` -- INSERT INTO `admissions` (`admissions_id`, `admissions_title`, `admissions_content`, `page_image`, `meta_title`, `meta_description`, `meta_keywords`) VALUES (1, 'admissions', '<p><span style=\"font-size: 13px;\">admissionsadmissionsadmissionsadmissionsadmissionsadmissionsadmissionsadmissions</span><br></p>', '5e5a318125e861.82301523.jpg', 'admissions title', 'admissions desc', 'admissions key'); -- -------------------------------------------------------- -- -- Table structure for table `admission_form` -- DROP TABLE IF EXISTS `admission_form`; CREATE TABLE IF NOT EXISTS `admission_form` ( `admission_form_id` int(255) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) COLLATE utf8_bin NOT NULL, `last_name` varchar(255) COLLATE utf8_bin NOT NULL, `middle_name` varchar(255) COLLATE utf8_bin NOT NULL, `dateofbirth` varchar(255) COLLATE utf8_bin NOT NULL, `gender` varchar(255) COLLATE utf8_bin NOT NULL, `bloodgroup` varchar(255) COLLATE utf8_bin NOT NULL, `father_name` varchar(255) COLLATE utf8_bin NOT NULL, `father_qualification` varchar(255) COLLATE utf8_bin NOT NULL, `father_occupation` varchar(255) COLLATE utf8_bin NOT NULL, `residential_address` varchar(255) COLLATE utf8_bin NOT NULL, `permenant_address` varchar(255) COLLATE utf8_bin NOT NULL, `mother_name` varchar(255) COLLATE utf8_bin NOT NULL, `mother_qualification` varchar(255) COLLATE utf8_bin NOT NULL, `mother_occupation` varchar(255) COLLATE utf8_bin NOT NULL, `family_income` varchar(255) COLLATE utf8_bin NOT NULL, `contact1` varchar(255) COLLATE utf8_bin NOT NULL, `contact2` varchar(255) COLLATE utf8_bin NOT NULL, `email_id` varchar(255) COLLATE utf8_bin NOT NULL, `nationality` varchar(255) COLLATE utf8_bin NOT NULL, `mother_tounge` varchar(255) COLLATE utf8_bin NOT NULL, `religion` varchar(255) COLLATE utf8_bin NOT NULL, `caste` varchar(255) COLLATE utf8_bin NOT NULL, `aadhar_card_no` varchar(255) COLLATE utf8_bin NOT NULL, `student_photo` varchar(255) COLLATE utf8_bin DEFAULT NULL, `admission_in_class` varchar(255) COLLATE utf8_bin NOT NULL, `medium` varchar(255) COLLATE utf8_bin NOT NULL, `school_last_attended` varchar(255) COLLATE utf8_bin NOT NULL, `admission_till_class` varchar(255) COLLATE utf8_bin NOT NULL, `previous_class_average_grade` varchar(255) COLLATE utf8_bin NOT NULL, `admission_form_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `admission_form_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`admission_form_id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `admission_form` -- INSERT INTO `admission_form` (`admission_form_id`, `first_name`, `last_name`, `middle_name`, `dateofbirth`, `gender`, `bloodgroup`, `father_name`, `father_qualification`, `father_occupation`, `residential_address`, `permenant_address`, `mother_name`, `mother_qualification`, `mother_occupation`, `family_income`, `contact1`, `contact2`, `email_id`, `nationality`, `mother_tounge`, `religion`, `caste`, `aadhar_card_no`, `student_photo`, `admission_in_class`, `medium`, `school_last_attended`, `admission_till_class`, `previous_class_average_grade`, `admission_form_datetime`, `admission_form_datetime_stamp`) VALUES (3, 'First Nam', 'Last Name', 'Middle Name', '01-03-2020', 'Female', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b8248de8577.62290328.jpg', 'LKG', 'medium', 'School last attended', 'Class Xll', 'Previous Class Average Grade', '01-March-2020 03:07:12 pm', '1583055432'), (2, 'First Nam', 'Last Name', 'Middle Name', '01-03-2020', 'Female', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b8194a1a0c0.91104221.jpg', 'LKG', 'medium', 'School last attended', 'Class Xll', 'Previous Class Average Grade', '01-March-2020 03:04:12 pm', '1583055252'), (4, 'First Nam', 'Last Name', 'Middle Name', '01-03-2020', 'Female', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b825f61e414.57950140.jpg', 'LKG', 'medium', 'School last attended', 'Class Xll', 'Previous Class Average Grade', '01-March-2020 03:07:35 pm', '1583055455'), (5, 'First Nam', 'Last Name', 'Middle Name', '01-03-2020', 'Female', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b82961d2a56.77231919.jpg', 'LKG', 'medium', 'School last attended', 'Class Xll', 'Previous Class Average Grade', '01-March-2020 03:08:30 pm', '1583055510'), (6, 'First Name *', 'Last Name *', 'Middle Name *', '01-03-2020', 'Others', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b8da93c7757.91859621.jpg', 'Class Xll', 'medium', 'School last attended', 'Class Xl', 'Previous Class Average Grade', '01-March-2020 03:55:45 pm', '1583058345'), (7, 'First Name *', 'Last Name *', 'Middle Name *', '01-03-2020', 'Others', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b8dc0dd1911.75007629.jpg', 'Class Xll', 'medium', 'School last attended', 'Class Xl', 'Previous Class Average Grade', '01-March-2020 03:56:08 pm', '1583058368'), (8, 'First Name *', 'Last Name *', 'Middle Name *', '01-03-2020', 'Others', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b8ddaed34e6.94033179.jpg', 'Class Xll', 'medium', 'School last attended', 'Class Xl', 'Previous Class Average Grade', '01-March-2020 03:56:34 pm', '1583058394'), (9, 'First Nam', 'Last Name', 'Middle Name', '01-03-2020', 'Female', 'A', 'Father\'s Name', 'Father\'s Qualification', 'Father\'s Occupation', 'Residential Address', 'Permenant Address', 'Mother\'s Name', 'Mother\'s Qualification', 'Mother\'s Occupation', 'Family Income', 'Contact No 1', 'Contact No 2', 'email@example.com', 'Nationality', 'Mother Toungu', 'Religion', 'Caste', 'Aadhar Card No', '5e5b9070c1dda1.65170024.jpg', 'LKG', 'medium', 'School last attended', 'Class Xll', 'Previous Class Average Grade', '01-March-2020 04:07:36 pm', '1583059056'); -- -------------------------------------------------------- -- -- Table structure for table `application_form` -- DROP TABLE IF EXISTS `application_form`; CREATE TABLE IF NOT EXISTS `application_form` ( `id` int(255) NOT NULL AUTO_INCREMENT, `applied_post` varchar(255) COLLATE utf8_bin NOT NULL, `subject` varchar(255) COLLATE utf8_bin NOT NULL, `teaching_upto` varchar(255) COLLATE utf8_bin NOT NULL, `first_name` varchar(255) COLLATE utf8_bin NOT NULL, `last_name` varchar(255) COLLATE utf8_bin NOT NULL, `residential_address` varchar(255) COLLATE utf8_bin NOT NULL, `permanent_address` varchar(255) COLLATE utf8_bin NOT NULL, `father_husband_name` varchar(255) COLLATE utf8_bin NOT NULL, `family_income` varchar(255) COLLATE utf8_bin NOT NULL, `gender` varchar(255) COLLATE utf8_bin NOT NULL, `dateofbirth` varchar(255) COLLATE utf8_bin NOT NULL, `dateofbirth_stamp` varchar(255) COLLATE utf8_bin NOT NULL, `medium` varchar(255) COLLATE utf8_bin NOT NULL, `bloodgroup` varchar(255) COLLATE utf8_bin NOT NULL, `nationality` varchar(255) COLLATE utf8_bin NOT NULL, `mothertounge` varchar(255) COLLATE utf8_bin NOT NULL, `religion` varchar(255) COLLATE utf8_bin NOT NULL, `caste` varchar(255) COLLATE utf8_bin NOT NULL, `contactno1` varchar(255) COLLATE utf8_bin NOT NULL, `contactno2` varchar(255) COLLATE utf8_bin NOT NULL, `aadhar_no` varchar(255) COLLATE utf8_bin NOT NULL, `email_id` varchar(255) COLLATE utf8_bin NOT NULL, `previous_schoolname` varchar(255) COLLATE utf8_bin NOT NULL, `address` varchar(255) COLLATE utf8_bin NOT NULL, `teaching_experience` varchar(255) COLLATE utf8_bin NOT NULL, `intersted_teaching_subjects` varchar(255) COLLATE utf8_bin NOT NULL, `languages_known` varchar(255) COLLATE utf8_bin NOT NULL, `medium_of_teaching` varchar(255) COLLATE utf8_bin NOT NULL, `prev_profession` varchar(255) COLLATE utf8_bin NOT NULL, `qualification` varchar(255) COLLATE utf8_bin NOT NULL, `document_file` varchar(255) COLLATE utf8_bin NOT NULL, `datetime` varchar(255) COLLATE utf8_bin NOT NULL, `datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `careers` -- DROP TABLE IF EXISTS `careers`; CREATE TABLE IF NOT EXISTS `careers` ( `careers_id` int(255) NOT NULL AUTO_INCREMENT, `careers_title` varchar(255) COLLATE utf8_bin NOT NULL, `careers_content` longtext COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`careers_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `careers` -- INSERT INTO `careers` (`careers_id`, `careers_title`, `careers_content`, `page_image`, `meta_title`, `meta_description`, `meta_keywords`) VALUES (1, 'career titleddd', '<p>asdfasdfasdfasdfasdfdddddd</p>', '5e5a2ff0b05d16.76396766.jpg', 'career title dddd', 'asdfasdfsadtgertretertrewtwertwertwert dd', 'career ekyword ddd'); -- -------------------------------------------------------- -- -- Table structure for table `careers_form` -- DROP TABLE IF EXISTS `careers_form`; CREATE TABLE IF NOT EXISTS `careers_form` ( `careers_form_id` int(255) NOT NULL AUTO_INCREMENT, `position_applied` varchar(255) COLLATE utf8_bin NOT NULL, `interested_subjects` varchar(255) COLLATE utf8_bin NOT NULL, `teaching_upto` varchar(255) COLLATE utf8_bin NOT NULL, `first_name` varchar(255) COLLATE utf8_bin NOT NULL, `last_name` varchar(255) COLLATE utf8_bin NOT NULL, `residential_address` varchar(255) COLLATE utf8_bin NOT NULL, `permanent_address` varchar(255) COLLATE utf8_bin NOT NULL, `father_husband_name` varchar(255) COLLATE utf8_bin NOT NULL, `family_income` varchar(255) COLLATE utf8_bin NOT NULL, `gender` varchar(255) COLLATE utf8_bin NOT NULL, `dateofbirth` varchar(255) COLLATE utf8_bin NOT NULL, `medium` varchar(255) COLLATE utf8_bin NOT NULL, `bloodgroup` varchar(255) COLLATE utf8_bin NOT NULL, `nationality` varchar(255) COLLATE utf8_bin NOT NULL, `mothertounge` varchar(255) COLLATE utf8_bin NOT NULL, `religion` varchar(255) COLLATE utf8_bin NOT NULL, `caste` varchar(255) COLLATE utf8_bin NOT NULL, `contact1` varchar(255) COLLATE utf8_bin NOT NULL, `contact2` varchar(255) COLLATE utf8_bin NOT NULL, `aaddhar_card_no` varchar(255) COLLATE utf8_bin NOT NULL, `email_id` varchar(255) COLLATE utf8_bin NOT NULL, `previous_school_name` varchar(255) COLLATE utf8_bin NOT NULL, `previous_school_address` varchar(255) COLLATE utf8_bin NOT NULL, `teaching_experience` varchar(255) COLLATE utf8_bin NOT NULL, `interested_teaching_subject` varchar(255) COLLATE utf8_bin NOT NULL, `languages_known` varchar(255) COLLATE utf8_bin NOT NULL, `prev_medium_teaching` varchar(255) COLLATE utf8_bin NOT NULL, `prev_profession` varchar(255) COLLATE utf8_bin NOT NULL, `qualification` varchar(255) COLLATE utf8_bin NOT NULL, `document` varchar(255) COLLATE utf8_bin DEFAULT NULL, `careers_form_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `careers_form_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`careers_form_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `careers_form` -- INSERT INTO `careers_form` (`careers_form_id`, `position_applied`, `interested_subjects`, `teaching_upto`, `first_name`, `last_name`, `residential_address`, `permanent_address`, `father_husband_name`, `family_income`, `gender`, `dateofbirth`, `medium`, `bloodgroup`, `nationality`, `mothertounge`, `religion`, `caste`, `contact1`, `contact2`, `aaddhar_card_no`, `email_id`, `previous_school_name`, `previous_school_address`, `teaching_experience`, `interested_teaching_subject`, `languages_known`, `prev_medium_teaching`, `prev_profession`, `qualification`, `document`, `careers_form_datetime`, `careers_form_datetime_stamp`) VALUES (1, 'Position Applied', 'Interested Subjects', 'Class X', 'First Name', 'Last Name', 'Residential Address', 'Permanent Address', 'Father/Husband Name', 'Family Income', 'Female', '01-03-2020', 'Medium', 'AB', 'Nationality', 'Mother Toungue', 'Religion', 'Caste', 'Contact No 1', 'Contact No 2', 'Aaddhar Card No', 'example@example.com', 'Previous School Name', 'Previous Address', 'Teaching Experience', 'Interested Teaching Subject', 'Languages Known', 'Medium of Teaching', 'Prev Profession', 'Qualification *', '5e5bbf25cf3235.97120096.docx', '01-March-2020 07:26:53 pm', '1583071013'); -- -------------------------------------------------------- -- -- Table structure for table `contactus` -- DROP TABLE IF EXISTS `contactus`; CREATE TABLE IF NOT EXISTS `contactus` ( `contactus_id` int(255) NOT NULL AUTO_INCREMENT, `contactus_pagetitle` varchar(255) COLLATE utf8_bin NOT NULL, `contactus_content` longtext COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`contactus_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `contactus` -- INSERT INTO `contactus` (`contactus_id`, `contactus_pagetitle`, `contactus_content`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (1, 'Contact Us', '<h2>Feel Free To Contact Us</h2><h3>Demo High School </h3><h5>Demo@gmail.com</h5><h5>9999999999</h5>', 'ggh Update', 'yhuy Update', 'nbmnm Update'); -- -------------------------------------------------------- -- -- Table structure for table `contact_form` -- DROP TABLE IF EXISTS `contact_form`; CREATE TABLE IF NOT EXISTS `contact_form` ( `contact_form_id` int(255) NOT NULL AUTO_INCREMENT, `contact_form_name` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_occupation` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_contact` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_email` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_enquiry_for` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_address` text COLLATE utf8_bin NOT NULL, `contact_form_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `contact_form_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, `status` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'Pending' COMMENT 'Responded', `user_id` int(255) NOT NULL, `action_datetime` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`contact_form_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `contact_form` -- INSERT INTO `contact_form` (`contact_form_id`, `contact_form_name`, `contact_form_occupation`, `contact_form_contact`, `contact_form_email`, `contact_form_enquiry_for`, `contact_form_address`, `contact_form_datetime`, `contact_form_datetime_stamp`, `status`, `user_id`, `action_datetime`) VALUES (4, 'name12', 'name12', 'name12', 'name12@gmail.com', 'name12', 'name12', '27-February-2020 11:28:06 pm', '1582826286', 'Pending', 0, ''), (2, 'somename', 'occupation', 'contactnumber', 'emailaddress', 'enquiryfor', 'address', '27-February-2020 11:19:10 pm', '1582825750', 'Pending', 0, ''), (3, 'somename', 'occupation', 'contactnumber', 'emailaddress', 'enquiryfor', 'address', '27-February-2020 11:19:35 pm', '1582825775', 'Pending', 0, ''), (5, 'name13', 'name13', 'name13', 'name13@gmail.com', 'name13', 'name13', '27-February-2020 11:29:11 pm', '1582826351', 'Pending', 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `courses` -- DROP TABLE IF EXISTS `courses`; CREATE TABLE IF NOT EXISTS `courses` ( `courses_id` int(255) NOT NULL AUTO_INCREMENT, `courses_title` varchar(255) COLLATE utf8_bin NOT NULL, `courses_content` longtext COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`courses_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`courses_id`, `courses_title`, `courses_content`, `page_image`, `meta_title`, `meta_description`, `meta_keywords`) VALUES (1, 'We Teach', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. In rhoncus justo et pellentesque blandit. Suspendisse potenti. Mauris at sapien sapien. Phasellus ut risus vestibulum, laoreet tortor volutpat, auctor urna. Ut vitae fermentum purus, a efficitur ipsum. Praesent non bibendum ex. Curabitur ac augue magna. Quisque ac nunc nec lacus condimentum sagittis sed non lorem. Aliquam non nunc et quam pretium convallis. Vestibulum elit dui, dignissim sed cursus hendrerit, vulputate eu tellus. Praesent elementum venenatis augue, sit amet condimentum lorem malesuada sit amet. Aliquam erat volutpat. Fusce volutpat at sapien porta porta. Maecenas lacinia, augue at condimentum tincidunt, tellus nisi maximus velit, ac pulvinar nibh sem at orci. Mauris quis turpis et ex lobortis interdum. Phasellus ante lectus, scelerisque id sollicitudin a, hendrerit sit amet erat.</p>\r\n<p>Praesent blandit hendrerit orci. Sed maximus, est in bibendum commodo, urna nunc euismod enim, a ornare felis ante ut dui. Sed consectetur fringilla lacus nec fringilla. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Maecenas interdum lacus a justo porta facilisis. Nam vulputate quam non turpis venenatis sollicitudin. Duis ac purus molestie, suscipit erat in, tempus diam. Nullam vulputate, tortor ut eleifend congue, lectus nulla rhoncus purus, id condimentum justo nulla ut felis. Suspendisse potenti. Phasellus purus elit, feugiat luctus purus et, ullamcorper ultrices dolor. Vivamus imperdiet odio id nisi lobortis, in ultrices lectus venenatis. Phasellus nibh dui, ultrices in lobortis quis, condimentum in eros.</p>\r\n<p>Praesent eget nisi quis quam consequat volutpat et ac dui. Vivamus sagittis ligula non mauris scelerisque laoreet. Integer non nulla porta, porttitor nibh id, tincidunt velit. Etiam quis urna eu diam aliquet tempor. Proin vehicula massa id accumsan pellentesque. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed dapibus, libero eget laoreet gravida, ligula tortor elementum magna, in fermentum lorem velit a odio.</p>\r\n<p>In sem mauris, hendrerit et imperdiet eu, tincidunt in erat. Mauris sagittis aliquet egestas. Sed nulla ligula, pharetra cursus sem nec, pellentesque laoreet dolor. Integer gravida pharetra dolor, sit amet maximus ipsum consectetur sit amet. Pellentesque eget lectus quis mi elementum lacinia. Quisque viverra ligula velit, porttitor volutpat risus tincidunt non. Vestibulum quis porttitor nunc. In hac habitasse platea dictumst. Nam lorem augue, tristique eu risus ac, rhoncus consequat neque.</p>\r\n<p>Donec facilisis sagittis dui, pharetra tristique purus feugiat hendrerit. Cras auctor semper sem, ut eleifend dui tempor quis. Ut ac nulla in leo porta vehicula. Nulla dapibus, ligula non fringilla vestibulum, eros nisi tristique dui, in interdum mi mi egestas ipsum. Curabitur tellus purus, tempus in imperdiet vel, finibus tincidunt felis. Integer auctor ornare sagittis. Nulla ante velit, convallis sit amet tincidunt quis, lacinia quis quam.</p>', '5e595b00d771b3.09408777.jpg', 'courses', 'courses', 'courses'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; CREATE TABLE IF NOT EXISTS `events` ( `events_id` int(255) NOT NULL AUTO_INCREMENT, `events_title` varchar(255) COLLATE utf8_bin NOT NULL, `events_image` varchar(255) COLLATE utf8_bin NOT NULL, `events_content` text COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` text COLLATE utf8_bin NOT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, `events_start_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `events_start_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, `events_end_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `events_end_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, `events_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means enable, 0 means disabled', `events_displayorder` int(255) NOT NULL DEFAULT '0' COMMENT 'Higher the value First will come 100,99,98...,0 ', `events_is_deleted` int(11) NOT NULL DEFAULT '0' COMMENT '1 Means Deleted', PRIMARY KEY (`events_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `events` -- INSERT INTO `events` (`events_id`, `events_title`, `events_image`, `events_content`, `meta_title`, `meta_keywords`, `meta_description`, `events_start_datetime`, `events_start_datetime_stamp`, `events_end_datetime`, `events_end_datetime_stamp`, `events_status`, `events_displayorder`, `events_is_deleted`) VALUES (1, 'event 1 update update', '5e55537f950018.53508040.jpg', '<p>event 1 update update<br></p>', 'event 1 update update', 'event 1 update update', 'event 1 update update', '23-07-2020 00:00:00', '1595442600', '23-07-2020 23:59:59', '1595528999', 0, 19, 1), (2, 'ewrqwer', 'hello.jpg', '<p>qwerqwerqwer</p>', 'event 1 update update', 'event 1 update update', 'werwer', '29-02-2020 00:00:00', '1582914600', '29-02-2020 23:59:59', '1583000999', 1, 1, 0), (3, 'event2 update', '5e555c1a0447d4.32554065.jpg', '<p>sdfsdfdsfas</p>', 'event2 update', 'event2 update', 'event2 update', '15-05-2020 00:00:00', '1589481000', '15-05-2020 23:59:59', '1589567399', 1, 1, 0), (4, 'Event 1', '5e59367c12eca5.58955722.jpg', '<p><span style=\"color: rgb(34, 34, 34); font-family: Consolas, "Lucida Console", "Courier New", monospace; font-size: 12px; white-space: pre-wrap;\">The role is responsible for designing, coding and modifying websites, from layout to function and according to a client\'s specifications. Strive to create visually appealing sites that feature user-friendly design and clear navigation.</span><br></p>', 'Event 1', 'Event 1', 'Event 1', '28-02-2020 00:00:00', '1582828200', '28-02-2020 23:59:59', '1582914599', 1, 1, 0), (5, 'Event 2', '5e5936a7b80098.14507201.jpg', '<p><span style=\"color: rgb(34, 34, 34); font-family: Consolas, "Lucida Console", "Courier New", monospace; font-size: 12px; white-space: pre-wrap;\">The role is responsible for designing, coding and modifying websites, from layout to function and according to a client\'s specifications. Strive to create visually appealing sites that feature user-friendly design and clear navigation.</span><br></p>', 'Event 2', 'Event 2', 'Event 2', '28-03-2020 00:00:00', '1585333800', '28-03-2020 23:59:59', '1585420199', 1, 1, 0), (6, 'Event 5', '5e593e4868ceb9.52327316.jpg', '<p>Event 5<br></p>', 'Event 5', 'Event 5', 'Event 5', '23-04-2020 00:00:00', '1587580200', '23-04-2020 23:59:59', '1587666599', 1, 1, 0), (7, 'DEmo Event', '5e5dbab65ffdd3.02991665.jpg', '<p>Thisisdemoeventwhichgoeshere</p><p><br></p><p>asdfjladsjfkldjasf</p><p>ads\'</p><p>flads;lfkadolsfkjdasf</p><p>das[f\\</p><p>da[s</p><p>fdkasfkjdasfdafasf[</p><p>]awd[sf]</p><p>das[]</p><p>f[\'d;asfdasf</p>', 'demo event', 'demo event', 'demo eventdemo eventdemo eventdemo event', '13-03-2020 00:00:00', '1584037800', '13-03-2020 23:59:59', '1584124199', 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- DROP TABLE IF EXISTS `gallery`; CREATE TABLE IF NOT EXISTS `gallery` ( `gallery_id` int(255) NOT NULL AUTO_INCREMENT, `gallery_title` varchar(255) COLLATE utf8_bin NOT NULL, `gallery_image` varchar(255) COLLATE utf8_bin NOT NULL, `gallery_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means enable, 0 means disabled', `gallery_displayorder` int(11) NOT NULL DEFAULT '1' COMMENT 'Higher the value First will come 100,99,98...,0 ', PRIMARY KEY (`gallery_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`gallery_id`, `gallery_title`, `gallery_image`, `gallery_status`, `gallery_displayorder`) VALUES (2, 'ertertewrtwert', '5e5b94b3922226.12685062.jpg', 1, 1), (3, 'Gallery title', '5e5b94833ceaa4.20586321.jpg', 1, 3), (4, 'gallery title 2', '5e5b9499bc6c23.36959916.jpg', 1, 6), (5, 'Image snow', '5e5b94c2ddcf26.89263771.jpg', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `homepageslider` -- DROP TABLE IF EXISTS `homepageslider`; CREATE TABLE IF NOT EXISTS `homepageslider` ( `homepageslider_id` int(255) NOT NULL AUTO_INCREMENT, `homepageslider_image` varchar(255) COLLATE utf8_bin NOT NULL, `homepageslider_primarytext` text COLLATE utf8_bin NOT NULL, `homepageslider_secondarytext` text COLLATE utf8_bin NOT NULL, `homepageslider_displayorder` int(255) NOT NULL COMMENT 'Higher the value First will come 100,99,98...,0', `homepageslider_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means message is enable, 0 means message is disabled ', PRIMARY KEY (`homepageslider_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `homepageslider` -- INSERT INTO `homepageslider` (`homepageslider_id`, `homepageslider_image`, `homepageslider_primarytext`, `homepageslider_secondarytext`, `homepageslider_displayorder`, `homepageslider_status`) VALUES (1, '5e58af7c0fa860.69050248.jpg', 'Main Heading', 'Sub Heading', 1, 1), (2, '5e58af84594325.50018619.jpg', 'Main Heading', 'Sub Heading', 18, 1), (3, '5e58af8b2cb0f0.18900349.jpg', 'Main Heading', 'Sub Heading', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; CREATE TABLE IF NOT EXISTS `jobs` ( `jobs_id` int(255) NOT NULL AUTO_INCREMENT, `jobs_title` varchar(255) COLLATE utf8_bin NOT NULL, `jobs_content` text COLLATE utf8_bin NOT NULL, `jobs_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means enable, 0 means disabled', `jobs_displayorder` int(11) NOT NULL COMMENT ' Higher the value First will come 100,99,98...,0', PRIMARY KEY (`jobs_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `jobs` -- INSERT INTO `jobs` (`jobs_id`, `jobs_title`, `jobs_content`, `jobs_status`, `jobs_displayorder`) VALUES (1, 'job title update', '<p>job contnet update</p>', 0, 19); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; CREATE TABLE IF NOT EXISTS `messages` ( `messages_id` int(255) NOT NULL AUTO_INCREMENT, `messages_content` longtext COLLATE utf8_bin NOT NULL, `messages_title` varchar(255) COLLATE utf8_bin NOT NULL, `messages_displayorder` int(255) NOT NULL COMMENT 'Higher the value First will come 100,99,98...,0', `messages_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means message is enable, 0 means message is disabled', `message_added_by` int(11) DEFAULT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, `meta_keywords` text COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, `pagename` varchar(255) COLLATE utf8_bin NOT NULL, `pagetype` varchar(255) COLLATE utf8_bin NOT NULL, `pageurl` varchar(300) COLLATE utf8_bin NOT NULL, `special_entry` int(11) NOT NULL DEFAULT '0' COMMENT 'if 1 then this entry can''t be deleted, or else can be deleted', PRIMARY KEY (`messages_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`messages_id`, `messages_content`, `messages_title`, `messages_displayorder`, `messages_status`, `message_added_by`, `meta_description`, `meta_keywords`, `meta_title`, `page_image`, `pagename`, `pagetype`, `pageurl`, `special_entry`) VALUES (2, '<p>hello world @#$%^&<br></p>', 'hello world @#$%^&', 1, 1, 1, 'hello world @#$%^&', 'hello world @#$%^&', 'hello world @#$%^&', '', 'hello world 1 @#$%^&', 'blog', 'hello-world-1-1', 0), (3, '<p>hello world @#$%^&<br></p>', 'hello world @#$%^&', 1, 1, 1, 'hello world @#$%^&', 'hello world @#$%^&', 'hello world @#$%^&', '', 'hello world @#$%^&', 'academic', 'hello-world-1', 0), (4, '<p>Pages Messages<br></p>', 'Pages Messages', 1, 1, 1, 'Pages Messages', 'Pages Messages', 'Pages Messages', '5e5b9fc1ab5d15.84231024.jpg', 'Pages', 'messages', 'pages', 0), (1, '', '', 1, 0, 1, ' ', ' ', '', '', '', 'academic', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `mission` -- DROP TABLE IF EXISTS `mission`; CREATE TABLE IF NOT EXISTS `mission` ( `mission_id` int(255) NOT NULL AUTO_INCREMENT, `mission_content` longtext COLLATE utf8_bin NOT NULL, `mission_title` varchar(255) COLLATE utf8_bin NOT NULL, `page_image` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`mission_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `mission` -- INSERT INTO `mission` (`mission_id`, `mission_content`, `mission_title`, `page_image`) VALUES (1, '<p class=\"lead\">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.</p>\r\n<p class=\"lead mb-0\">Cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.</p>', 'Change the game through design.', '5e58a77d952079.55860910.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; CREATE TABLE IF NOT EXISTS `news` ( `news_id` int(255) NOT NULL AUTO_INCREMENT, `news_title` varchar(255) COLLATE utf8_bin NOT NULL, `news_content` longtext COLLATE utf8_bin NOT NULL, `news_image` varchar(255) COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` text COLLATE utf8_bin NOT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, `news_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `news_datetime_stamp` varchar(255) COLLATE utf8_bin NOT NULL, `news_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means enable, 0 means disabled', `news_displayorder` int(255) NOT NULL COMMENT 'Higher the value First will come 100,99,98...,0', PRIMARY KEY (`news_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `news` -- INSERT INTO `news` (`news_id`, `news_title`, `news_content`, `news_image`, `meta_title`, `meta_keywords`, `meta_description`, `news_datetime`, `news_datetime_stamp`, `news_status`, `news_displayorder`) VALUES (1, 'What CFR really is about', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.</p>', '5e58b5c1bca0b0.58844975.jpg', 'news title', 'news keyword', 'asdfasdf', '01-03-2020', '1583001000', 1, 1), (2, 'What CFR really is about', '<p><span style=\"color: rgb(34, 34, 34); font-family: Consolas, \"Lucida Console\", \"Courier New\", monospace; font-size: 12px; white-space: pre-wrap;\">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.</span><br></p>', '5e58b62d11c9b2.81975369.jpg', 'news2', 'news2', 'news2', '29-02-2020', '1582914600', 1, 1), (3, 'News 3', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.<br></p>', '5e5933ae6995f4.37388759.jpg', 'news meta', 'news meta', 'news descrito', '19-03-2020', '1584556200', 1, 1), (4, 'News 4', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.<br></p>', '5e5933c9f3b529.74576521.jpg', 'news meta', 'news meta', 'sdfdsafasf', '23-04-2020', '1587580200', 1, 1), (5, 'News 5', '<p>asfdsfadsfasdf</p>', '5e5933e3ead071.06950023.jpg', 'news meta', 'news meta', 'sdfdasfdasf', '20-05-2020', '1589913000', 1, 1), (6, 'News 6', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.<br></p>', '5e5933fd9727b7.53669987.jpg', 'news meta', 'news meta', 'asdfdsf', '28-02-2020', '1582828200', 1, 1), (7, 'News 7', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati.<br></p>', '5e59341eb5e785.58598182.jpg', 'news meta', 'news meta', 'dfsdfasdf', '20-03-2020', '1584642600', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `setting` -- DROP TABLE IF EXISTS `setting`; CREATE TABLE IF NOT EXISTS `setting` ( `setting_id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `telephone` varchar(255) COLLATE utf8_bin NOT NULL, `email` varchar(255) COLLATE utf8_bin NOT NULL, `address` varchar(255) COLLATE utf8_bin NOT NULL, `logo` varchar(255) COLLATE utf8_bin NOT NULL, `fevicon` varchar(255) COLLATE utf8_bin NOT NULL, `meta_title` varchar(255) COLLATE utf8_bin NOT NULL, `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL, `meta_description` text COLLATE utf8_bin NOT NULL, `facebook` varchar(255) COLLATE utf8_bin NOT NULL, `twitter` varchar(255) COLLATE utf8_bin NOT NULL, `instagram` varchar(255) COLLATE utf8_bin NOT NULL, `youtube` varchar(255) COLLATE utf8_bin NOT NULL, `google_map` text COLLATE utf8_bin NOT NULL, `visit_counter` int(255) NOT NULL DEFAULT '0', `notification` text COLLATE utf8_bin NOT NULL, `themeversion` int(11) NOT NULL DEFAULT '1' COMMENT 'For now count from 1 to 4, 1 is default', `protocol` varchar(255) COLLATE utf8_bin NOT NULL, `smtp_host` varchar(255) COLLATE utf8_bin NOT NULL, `smtp_port` varchar(255) COLLATE utf8_bin NOT NULL, `smtp_user` varchar(255) COLLATE utf8_bin NOT NULL, `smtp_pass` varchar(255) COLLATE utf8_bin NOT NULL, `count_teachers` int(255) NOT NULL DEFAULT '0', `count_students` int(255) NOT NULL DEFAULT '0', `footer_tag_line` varchar(255) COLLATE utf8_bin NOT NULL, `admissionhelpline` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`setting_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `setting` -- INSERT INTO `setting` (`setting_id`, `name`, `telephone`, `email`, `address`, `logo`, `fevicon`, `meta_title`, `meta_keywords`, `meta_description`, `facebook`, `twitter`, `instagram`, `youtube`, `google_map`, `visit_counter`, `notification`, `themeversion`, `protocol`, `smtp_host`, `smtp_port`, `smtp_user`, `smtp_pass`, `count_teachers`, `count_students`, `footer_tag_line`, `admissionhelpline`) VALUES (1, 'name', 'telephone34234kjk,qwe rqwer', 'email@example.com', 'addres<br />\r\nhell<br />\r\nwlrje<br />\r\nasdflj<br />\r\nasdf', '5e57fc14653774.51494409.png', '5e57fc1b3c1e01.03437532.png', 'metatitle', 'metakeyo', 'descf', 'https://www.facebook.com/', 'https://www.twitter.com/', 'https://www.instagram.com/', 'https://www.youtube.com/', 'https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d224084.91864951048!2d77.0336249!3d28.6499304!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x390cfd5b347eb62d%3A0x37205b715389640!2sDelhi!5e0!3m2!1sen!2sin!4v1582470845815!5m2!1sen!2sin', 675, '', 1, 'smtp', 'ssl://smtp.gmail.com', '465', '***********', '***********', 12, 123, 'One of the largest, most diverse universities in the India with over 8 students.', '1800-1800-2222'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) COLLATE utf8_bin NOT NULL, `password` varchar(255) COLLATE utf8_bin NOT NULL, `login_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `login_datetimestamp` varchar(255) COLLATE utf8_bin NOT NULL, `last_login_datetime` varchar(255) COLLATE utf8_bin NOT NULL, `last_login_datetimestamp` varchar(255) COLLATE utf8_bin NOT NULL, `role` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT 'admin', `image` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `users` -- INSERT INTO `users` (`user_id`, `username`, `password`, `login_datetime`, `login_datetimestamp`, `last_login_datetime`, `last_login_datetimestamp`, `role`, `image`) VALUES (1, 'admin', '1844156d4166d94387f1a4ad031ca5fa', '03-March-2020 11:29:38 am', '1583215178', '01-March-2020 10:04:59 pm', '1583080499', 'admin', ''); -- -------------------------------------------------------- -- -- Table structure for table `videos` -- DROP TABLE IF EXISTS `videos`; CREATE TABLE IF NOT EXISTS `videos` ( `videos_id` int(255) NOT NULL AUTO_INCREMENT, `videos_link` varchar(255) COLLATE utf8_bin NOT NULL, `videos_status` int(11) NOT NULL DEFAULT '1' COMMENT '1 means enable, 0 means disabled', `videos_displayorder` int(11) NOT NULL COMMENT 'Higher the value First will come 100,99,98...,0', `videos_title` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`videos_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `videos` -- INSERT INTO `videos` (`videos_id`, `videos_link`, `videos_status`, `videos_displayorder`, `videos_title`) VALUES (3, 'qVTAB8Z2VmA', 0, 1, ''), (2, 'XAowXcmQ-kA', 1, 2, ''), (4, 'tI8ijLpZaHk', 0, 1, ''); COMMIT; /*!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 */;