D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
www
/
html
/
epaji.com
/
public_html
/
hindiusa
/
Filename :
db.sql
back
Copy
-- phpMyAdmin SQL Dump -- version 4.9.5deb2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 01, 2021 at 08:55 PM -- Server version: 8.0.27-0ubuntu0.20.04.1 -- PHP Version: 7.4.3 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: `hindi_usa` -- -- -------------------------------------------------------- -- -- Table structure for table `about_schools` -- CREATE TABLE `about_schools` ( `id` int NOT NULL, `school_id` int NOT NULL, `description` text NOT NULL, `thumb_image` varchar(300) DEFAULT NULL, `our_vision` text, `our_mission` text, `vision_image` varchar(300) DEFAULT NULL, `mission_image` varchar(300) DEFAULT NULL, `meta_title` varchar(200) DEFAULT NULL, `meta_desc` varchar(500) DEFAULT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `about_schools` -- INSERT INTO `about_schools` VALUES(1, 2, '<p>Hindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<p>USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<ul>\r\n <li>USA School descriptionHindi USA School descriptionHindi USA </li>\r\n <li>USA School descriptionHindi USA School descriptionHindi USA </li>\r\n <li>USA School description USA School descriptionUSA School </li>\r\n</ul>\r\n', 'uploads/schools/2/2116475346-features-img1.jpg', '<p>Hindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<p>USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<ul>\r\n <li>Hindi USA School descriptionHindi</li>\r\n <li>Hindi USA School descriptionHindi</li>\r\n <li>Hindi USA School descriptionHindi</li>\r\n</ul>\r\n', '<p>Hindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<p>USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi USA School descriptionHindi</p>\r\n\r\n<ul>\r\n <li>Hindi USA School descriptionHindi</li>\r\n <li>Hindi USA School descriptionHindi </li>\r\n <li>Hindi USA School descriptionHindi</li>\r\n <li>Hindi USA School descriptionHindi</li>\r\n</ul>\r\n', 'uploads/schools/2/1691168038-features-img1.jpg', 'uploads/schools/2/1660856102-features-img1.jpg', 'meta title about us', 'meta description\r\ndfsafa fdnfn', 1); INSERT INTO `about_schools` VALUES(3, 3, 'Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school Hello delhi public school ', 'uploads/schools/3/1095594074-slider-1.jpeg', 'our vision', '<p>our mission</p>\r\n', 'uploads/schools/3/727119682-wheat.jpeg', 'uploads/schools/3/267447295-soya-beans-700.jpg', 'meta title about us', 'desc', 1); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int NOT NULL, `school_id` int NOT NULL, `user_id` int NOT NULL, `blog_category_id` int NOT NULL, `title` varchar(300) NOT NULL, `description` text NOT NULL, `thumb_image` varchar(300) NOT NULL, `meta_title` varchar(300) DEFAULT NULL, `meta_description` varchar(500) DEFAULT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `blogs` -- INSERT INTO `blogs` VALUES(1, 2, 7, 1, 'Blog title for Hindi USA', '<p>blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description blog description </p>\r\n', 'uploads/schools/2/29209035-blog-img1.jpg', 'meta title ', 'meta description', 1, '2021-10-23 03:26:53'); INSERT INTO `blogs` VALUES(2, 3, 8, 2, 'Technology blog', '<p>Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi</p>\r\n\r\n<p> </p>\r\n\r\n<p><strong>public school describe Delhi public school describe </strong>Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe </p>\r\n\r\n<p> </p>\r\n\r\n<p>Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe Delhi public school describe </p>\r\n\r\n<p> </p>\r\n', 'uploads/schools/3/695357668-blog-course-4.jpg', 'meta title Delhi public school', 'meta description Delhi public schoolmeta description Delhi public schoolmeta title Delhi public schoolmeta title Delhi public school', 1, '2021-10-25 10:54:30'); -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` int NOT NULL, `school_id` int NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `blog_categories` -- INSERT INTO `blog_categories` VALUES(1, 2, 'news'); INSERT INTO `blog_categories` VALUES(2, 3, 'Technology'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int NOT NULL, `school_id` int NOT NULL, `event_type_id` int NOT NULL, `title` varchar(200) NOT NULL, `thumb_image` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `summary` varchar(500) NOT NULL, `description` text NOT NULL, `start_date` date NOT NULL, `start_time` varchar(10) NOT NULL, `end_date` date NOT NULL, `end_time` varchar(10) NOT NULL, `seat` int DEFAULT NULL, `venue` varchar(200) NOT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` VALUES(1, 2, 1, 'diwali event', 'uploads/schools/2/654793501-events-img2.jpg', 'Diwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwal', 'Diwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwalDiwali eventDiwal', '2021-10-25', '1AM', '2021-10-30', '2PM', 100, 'Noida', 1, '2021-10-27 15:52:56'); INSERT INTO `events` VALUES(2, 3, 2, 'event title', 'uploads/schools/3/1227427502-events-lg-img2.jpg', ' summery summery summery summery summery summery summery summery summery ', 'description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description description ', '2021-11-25', '11Am', '2021-11-25', '12AM', 23, 'Hindi USA School', 1, '2021-11-01 03:16:49'); -- -------------------------------------------------------- -- -- Table structure for table `event_types` -- CREATE TABLE `event_types` ( `id` int NOT NULL, `school_id` int NOT NULL, `name` varchar(100) NOT NULL, `description` varchar(500) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `event_types` -- INSERT INTO `event_types` VALUES(1, 2, 'Diwali Event', 'description'); INSERT INTO `event_types` VALUES(2, 3, 'Holi Event', ''); -- -------------------------------------------------------- -- -- Table structure for table `extra_pages` -- CREATE TABLE `extra_pages` ( `id` int NOT NULL, `school_id` int NOT NULL, `title` varchar(30) NOT NULL, `description` text NOT NULL, `meta_title` varchar(100) DEFAULT NULL, `meta_desc` varchar(300) DEFAULT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `extra_pages` -- INSERT INTO `extra_pages` VALUES(1, 2, 'extra page 1', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<ul>\r\n <li>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</li>\r\n</ul>\r\n\r\n<p><strong>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, loo</strong>ked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</p>\r\n', 'meta title', 'meta description', 1); INSERT INTO `extra_pages` VALUES(2, 2, 'extra page 2', '<p>Hindi usa 2 Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</p>\r\n', 'meta title', 'meta description', 1); INSERT INTO `extra_pages` VALUES(3, 3, 'extra page 3', '<p><strong>Delhi public</strong>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</p>\r\n\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary.</p>\r\n', 'meta title', 'meta description', 1); -- -------------------------------------------------------- -- -- Table structure for table `gallery_categories` -- CREATE TABLE `gallery_categories` ( `id` int NOT NULL, `school_id` int NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `gallery_categories` -- INSERT INTO `gallery_categories` VALUES(1, 2, 'New Year'); INSERT INTO `gallery_categories` VALUES(3, 2, 'Diwali'); INSERT INTO `gallery_categories` VALUES(4, 2, 'Holi'); INSERT INTO `gallery_categories` VALUES(5, 2, 'Annual function'); INSERT INTO `gallery_categories` VALUES(6, 3, 'Republic Day'); -- -------------------------------------------------------- -- -- Table structure for table `home_sliders` -- CREATE TABLE `home_sliders` ( `id` int NOT NULL, `school_id` int NOT NULL, `title` varchar(100) NOT NULL, `image` varchar(300) NOT NULL, `hover_text1` varchar(50) DEFAULT NULL, `hover_text2` varchar(100) DEFAULT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `home_sliders` -- INSERT INTO `home_sliders` VALUES(1, 3, 'slider-1', 'uploads/schools/3/477990461-img-4.jpg', 'Delhi Public school slider one', 'Delhi public ecommerce features are included with KIDZ, Build your site.', 1); INSERT INTO `home_sliders` VALUES(2, 2, 'slider-1', 'uploads/schools/2/587973344-img-1.jpg', 'Impress your client heading one', 'Kidz is a perfect theme for kindergarten school, very easy to use.', 1); INSERT INTO `home_sliders` VALUES(3, 2, 'slider-2', 'uploads/schools/2/1598275387-img-2.jpg', 'Kindergarten Website', 'All ecommerce features are included with KIDZ, Build your site.', 1); INSERT INTO `home_sliders` VALUES(4, 3, 'dslider-2', 'uploads/schools/3/560033479-img-3.jpg', 'Delhi Impress your client', 'Delhi Kidz is a perfect theme for kindergarten school, very easy to use.', 1); -- -------------------------------------------------------- -- -- Table structure for table `image_galleries` -- CREATE TABLE `image_galleries` ( `id` int NOT NULL, `school_id` int NOT NULL, `gallery_category_id` int NOT NULL, `title` varchar(100) NOT NULL, `description` varchar(200) DEFAULT NULL, `image` varchar(300) NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `image_galleries` -- INSERT INTO `image_galleries` VALUES(3, 2, 1, 'new year', 'new year image', 'uploads/schools/2/1233331126-gallery-lg-img8.jpg', 1); INSERT INTO `image_galleries` VALUES(4, 2, 3, 'diwal', 'bshf', 'uploads/schools/2/242657787-gallery-lg-img4.jpg', 1); INSERT INTO `image_galleries` VALUES(5, 2, 1, 'dhwvhj', 'bhjb', 'uploads/schools/2/679526188-gallery-lg-img3.jpg', 1); INSERT INTO `image_galleries` VALUES(6, 2, 3, 'fbjdwh', 'bjhjh', 'uploads/schools/2/2112878339-gallery-img8.jpg', 1); INSERT INTO `image_galleries` VALUES(7, 2, 4, 'fwbjwfbjb', 'jhgjhg', 'uploads/schools/2/886984677-gallery-img1.jpg', 1); INSERT INTO `image_galleries` VALUES(8, 2, 4, 'vhvgh', 'ghjgh', 'uploads/schools/2/2054075076-gallery-img2.jpg', 1); INSERT INTO `image_galleries` VALUES(9, 2, 5, 'vhvgh', 'vhv', 'uploads/schools/2/1782031984-gallery-lg-img5.jpg', 1); INSERT INTO `image_galleries` VALUES(10, 2, 5, 'bhjvj', 'hgjhg', 'uploads/schools/2/1154299489-gallery-img6.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `id` int NOT NULL, `school_id` int NOT NULL, `news_category_id` int NOT NULL, `title` varchar(500) NOT NULL, `description` text NOT NULL, `thumb_image` varchar(300) NOT NULL, `reference_url` varchar(500) DEFAULT NULL, `meta_title` varchar(300) DEFAULT NULL, `meta_description` varchar(500) DEFAULT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `news` -- INSERT INTO `news` VALUES(1, 2, 1, 'The Standard Chunk Of Lorem. Jone Doe', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<ul>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n</ul>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n', 'uploads/schools/2/741454166-blog-course-2.jpg', 'hyttp://news.com', 'meta title', 'meta description', 1, '2021-11-01 12:32:55'); INSERT INTO `news` VALUES(2, 3, 2, 'The Standard Chunk Of Lorem. Jone Doe wbgb', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n\r\n<ul>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n <li>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</li>\r\n</ul>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n', 'uploads/schools/3/1143984449-blog-img2.jpg', 'hyttp://news.com', 'meta title', 'meta description', 1, '2021-11-01 12:33:43'); -- -------------------------------------------------------- -- -- Table structure for table `news_categories` -- CREATE TABLE `news_categories` ( `id` int NOT NULL, `school_id` int NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `news_categories` -- INSERT INTO `news_categories` VALUES(1, 1, 'Hindi USA school News'); INSERT INTO `news_categories` VALUES(2, 3, 'Delhi school news'); -- -------------------------------------------------------- -- -- Table structure for table `notices` -- CREATE TABLE `notices` ( `id` int NOT NULL, `school_id` int NOT NULL, `title` varchar(200) NOT NULL, `description` text NOT NULL, `end_date` date DEFAULT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `notices` -- INSERT INTO `notices` VALUES(1, 2, 'test noticee', 'w fjqbrjqejk', '2021-11-23', 1, '2021-11-01 03:13:48'); INSERT INTO `notices` VALUES(2, 2, 'test notice2', 'bf hfihwg jwrhjaerljeh akjgh lerh ghek hgkjejg ', '2021-11-20', 1, '2021-11-01 03:15:08'); INSERT INTO `notices` VALUES(3, 3, 'qje hfj ew hewh', 'h lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjhh lrehelkeh erl kjh', '2021-11-27', 1, '2021-11-01 03:15:29'); -- -------------------------------------------------------- -- -- Table structure for table `schools` -- CREATE TABLE `schools` ( `id` int NOT NULL, `user_id` int NOT NULL, `url` varchar(20) NOT NULL, `name` varchar(100) NOT NULL, `logo` varchar(200) DEFAULT NULL, `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `address_line1` varchar(100) DEFAULT NULL, `address_line2` varchar(100) DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `country` varchar(50) DEFAULT NULL, `zip` varchar(20) DEFAULT NULL, `contact_email` varchar(30) DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `copy_right` varchar(50) DEFAULT NULL, `facebook` varchar(300) DEFAULT NULL, `twitter` varchar(300) DEFAULT NULL, `linkedIn` varchar(300) DEFAULT NULL, `instagram` varchar(300) DEFAULT NULL, `youtube` varchar(300) DEFAULT NULL, `term_condition` text, `privacy_policy` text, `sponser_link` varchar(300) DEFAULT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `schools` -- INSERT INTO `schools` VALUES(1, 6, 'bhappi', 'Happy Public School', 'uploads/schools/338759494-schoolinformation-logo.png', 'school descriptions', 'H 187', 'Work Wings', 'Noida', 'UP', 'India', '201301', 'akhalesk.kumar@coworkingnext.c', '08700741487', '', '', '', '', '', '', '', '', '', 1, '2021-10-02 07:49:36'); INSERT INTO `schools` VALUES(2, 7, '/', 'Hindi USA', 'uploads/schools/611972428-loho.jpeg', 'description', 'Boston street', '', 'Boston', 'Massachusetts', 'United States', '02125', 'akki.gautam2204@gmail.com', '6175556985', '', '', '', '', '', '', '', '', '', 1, '2021-10-02 09:01:38'); INSERT INTO `schools` VALUES(3, 8, 'dpsnewdelhi', 'Delhi Public School', 'uploads/schools/102444542-schoolinformation-logo.png', 'description', 'Boston street', '', 'Boston', 'Massachusetts', 'United States', '02125', 'akki.gautam2204@gmail.com', '6175556985', '@delhi public school', '', '', '', '', '', '', '', '', 1, '2021-10-03 03:43:10'); -- -------------------------------------------------------- -- -- Table structure for table `teachers` -- CREATE TABLE `teachers` ( `id` int NOT NULL, `school_id` int NOT NULL, `name` varchar(100) NOT NULL, `designation` varchar(300) NOT NULL, `description` text NOT NULL, `photo_image` varchar(300) NOT NULL, `facebook` varchar(300) DEFAULT NULL, `twitter` varchar(300) DEFAULT NULL, `linkdin` varchar(300) DEFAULT NULL, `youtube` varchar(300) DEFAULT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `teachers` -- INSERT INTO `teachers` VALUES(1, 2, 'Akhilesh Gautam', 'Match Teacher', 'Math teacher', 'uploads/schools/2/10060276-avator-img1.jpg', 'https://facebook.com', 'https://facebook.com', 'https://linkdin.com', 'https://youtube.com', 1); -- -------------------------------------------------------- -- -- Table structure for table `testimonials` -- CREATE TABLE `testimonials` ( `id` int NOT NULL, `school_id` int NOT NULL, `title` varchar(200) NOT NULL, `description` text NOT NULL, `photo_image` varchar(300) NOT NULL, `name` varchar(200) NOT NULL, `designation` varchar(100) DEFAULT NULL, `organization` varchar(100) DEFAULT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `testimonials` -- INSERT INTO `testimonials` VALUES(1, 2, 'testimonal 1', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.', 'uploads/schools/2/1765744528-5.jpg', 'Akhilesh', 'CEO', 'E infotech solutions', 1); INSERT INTO `testimonials` VALUES(2, 3, 'testimonial for Delhi public schools', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.\r\n\r\n', 'uploads/schools/3/323424084-1.jpg', 'Venu Gopal', 'Director', 'NRI WINGS', 1); INSERT INTO `testimonials` VALUES(3, 2, 'testimonial for Hindi USA', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.', 'uploads/schools/2/688154875-3.jpg', 'Bhappi Singh', 'Director', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(300) NOT NULL, `firstname` varchar(50) NOT NULL, `lastname` varchar(50) DEFAULT NULL, `role` int NOT NULL, `school_id` int DEFAULT NULL, `authKey` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `secret` varchar(300) DEFAULT NULL, `status` int NOT NULL, `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES(1, 'akki.gautam2204@gmail.com', '$2y$13$XWnzUWlwdRnSdnjDQxHWiuZWJWhgHlVh91f6O4b7n6QFrLdKQnATa', 'Akhalesh', 'Gautam', 1, NULL, '', '', 1, '2021-08-27 17:03:14'); INSERT INTO `users` VALUES(6, 'devonly2204@gmail.com', '$2y$13$4CLahBzIbVYHsgVSuQKDHOaX7QY/ft359kg5uAMEuDFZz0FdhiEbS', 'Bhappi', 'Singh', 2, NULL, 'hhHC6TftVAg0Sla5SCWG9SHWtfCBAsbX', NULL, 1, '2021-09-30 05:25:10'); INSERT INTO `users` VALUES(7, 'akki.gautam60286@gmail.com', '$2y$13$IM7e/NNW1N2dKNYs8ba/JeMINHA0gR/8Vn8c5WhgCoU3YQJsO4ttm', 'Venu', 'Gopal', 2, NULL, 'B25jCPQPKhA_iZbpxFz1nib6JRK4NM4w', NULL, 1, '2021-09-30 05:25:35'); INSERT INTO `users` VALUES(8, 'devonly2204+4@gmail.com', '$2y$13$PTiE13aOeDF9sQMTnAYpAuA9iBdJhkQxOecJoC7Fw7vUnTxSQ7tn6', 'akki', 'gautam', 2, NULL, 'GMIaIK5C9pzeG5QHnHsSo0u82puIVE-O', NULL, 1, '2021-10-03 03:39:03'); -- -------------------------------------------------------- -- -- Table structure for table `video_galleries` -- CREATE TABLE `video_galleries` ( `id` int NOT NULL, `school_id` int NOT NULL, `gallery_category_id` int NOT NULL, `title` varchar(100) NOT NULL, `description` varchar(200) DEFAULT NULL, `source_name` varchar(50) NOT NULL, `link` varchar(300) NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `video_galleries` -- INSERT INTO `video_galleries` VALUES(1, 2, 1, 'new year video', 'desc', 'Youtube', 'https://www.youtube.com/embed/v64KOxKVLVg', 1); INSERT INTO `video_galleries` VALUES(2, 2, 3, 'diwali video', 'bhjasvj', 'Youtube', 'https://www.youtube.com/embed/bi5PhlIQpwU', 1); INSERT INTO `video_galleries` VALUES(3, 2, 4, 'Holi video', 'vdadfj', 'Vimeo', 'https://player.vimeo.com/video/137857207', 1); INSERT INTO `video_galleries` VALUES(4, 3, 6, 'rehsfh', 'gjhgjh', 'Vimeo', 'https://player.vimeo.com/video/137857207', 1); INSERT INTO `video_galleries` VALUES(5, 2, 5, 'huhh', 'ghjhgh', 'Vimeo', 'https://player.vimeo.com/video/137857207', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `about_schools` -- ALTER TABLE `about_schools` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`), ADD KEY `blog_category_id` (`blog_category_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`), ADD KEY `event_type_id` (`event_type_id`); -- -- Indexes for table `event_types` -- ALTER TABLE `event_types` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `extra_pages` -- ALTER TABLE `extra_pages` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `gallery_categories` -- ALTER TABLE `gallery_categories` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `home_sliders` -- ALTER TABLE `home_sliders` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `image_galleries` -- ALTER TABLE `image_galleries` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`), ADD KEY `gallery_category_id` (`gallery_category_id`); -- -- Indexes for table `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`), ADD KEY `news_category_id` (`news_category_id`); -- -- Indexes for table `news_categories` -- ALTER TABLE `news_categories` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `notices` -- ALTER TABLE `notices` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `schools` -- ALTER TABLE `schools` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `url` (`url`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `teachers` -- ALTER TABLE `teachers` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `school_id` (`school_id`); -- -- Indexes for table `video_galleries` -- ALTER TABLE `video_galleries` ADD PRIMARY KEY (`id`), ADD KEY `school_id` (`school_id`), ADD KEY `gallery_category_id` (`gallery_category_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `about_schools` -- ALTER TABLE `about_schools` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `event_types` -- ALTER TABLE `event_types` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `extra_pages` -- ALTER TABLE `extra_pages` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `gallery_categories` -- ALTER TABLE `gallery_categories` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `home_sliders` -- ALTER TABLE `home_sliders` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `image_galleries` -- ALTER TABLE `image_galleries` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `news` -- ALTER TABLE `news` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `news_categories` -- ALTER TABLE `news_categories` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notices` -- ALTER TABLE `notices` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `schools` -- ALTER TABLE `schools` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `teachers` -- ALTER TABLE `teachers` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `video_galleries` -- ALTER TABLE `video_galleries` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `about_schools` -- ALTER TABLE `about_schools` ADD CONSTRAINT `about_schools_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `blogs` -- ALTER TABLE `blogs` ADD CONSTRAINT `blogs_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `blogs_ibfk_2` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `blogs_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `blog_categories` -- ALTER TABLE `blog_categories` ADD CONSTRAINT `blog_categories_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `events` -- ALTER TABLE `events` ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `events_ibfk_2` FOREIGN KEY (`event_type_id`) REFERENCES `event_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `event_types` -- ALTER TABLE `event_types` ADD CONSTRAINT `event_types_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `extra_pages` -- ALTER TABLE `extra_pages` ADD CONSTRAINT `extra_pages_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `gallery_categories` -- ALTER TABLE `gallery_categories` ADD CONSTRAINT `gallery_categories_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `home_sliders` -- ALTER TABLE `home_sliders` ADD CONSTRAINT `home_sliders_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `image_galleries` -- ALTER TABLE `image_galleries` ADD CONSTRAINT `image_galleries_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `image_galleries_ibfk_2` FOREIGN KEY (`gallery_category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `news` -- ALTER TABLE `news` ADD CONSTRAINT `news_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `news_ibfk_2` FOREIGN KEY (`news_category_id`) REFERENCES `news_categories` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `news_categories` -- ALTER TABLE `news_categories` ADD CONSTRAINT `news_categories_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `notices` -- ALTER TABLE `notices` ADD CONSTRAINT `notices_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `schools` -- ALTER TABLE `schools` ADD CONSTRAINT `schools_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `teachers` -- ALTER TABLE `teachers` ADD CONSTRAINT `teachers_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `testimonials` -- ALTER TABLE `testimonials` ADD CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `video_galleries` -- ALTER TABLE `video_galleries` ADD CONSTRAINT `video_galleries_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `video_galleries_ibfk_2` FOREIGN KEY (`gallery_category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; 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 */;