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

START TRANSACTION;



--
-- Database: `kids_school`
--

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `image_1` varchar(250) NOT NULL,
  `heading_1` varchar(250) NOT NULL,
  `address_1` varchar(250) NOT NULL,
  `address_2` varchar(250) NOT NULL,
  `image_2` varchar(250) NOT NULL,
  `heading_2` varchar(250) NOT NULL,
  `phone_1` varchar(250) NOT NULL,
  `phone_2` varchar(250) NOT NULL,
  `image_3` varchar(250) NOT NULL,
  `heading_3` varchar(250) NOT NULL,
  `email_1` varchar(250) NOT NULL,
  `email_2` varchar(250) NOT NULL,
  `image_4` varchar(250) NOT NULL,
  `heading_4` varchar(250) NOT NULL,
  `working_hours_1` varchar(250) NOT NULL,
  `working_hours_2` varchar(250) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `image_1`, `heading_1`, `address_1`, `address_2`, `image_2`, `heading_2`, `phone_1`, `phone_2`, `image_3`, `heading_3`, `email_1`, `email_2`, `image_4`, `heading_4`, `working_hours_1`, `working_hours_2`, `updated_at`, `status`) VALUES
(1, 'kids/i1.png', 'our location', 'Charlossteveille ', 'CA USA', 'kids/i2.png', 'phone no', '9999999999', '8888888888', 'kids/i3.png', 'Email id', 'kidschool@gmail.com', 'info@kidschool.com', 'kids/i4.png', 'kids school time', '8 am to 9 sat ', '1 pm to 4pm -sun', '13 Dec 2017 12:42 PM', 1);

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

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

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `image` varchar(300) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL,
  `content` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `title`, `image`, `created_at`, `updated_at`, `content`, `status`) VALUES
(1, '', 'kids/gallery1512994829.jpg', '11 Dec 2017 01:19 PM', '11 Dec 2017 01:20 PM', 'show', 1),
(2, '', 'kids/gallery1512996319.jpg', '11 Dec 2017 01:45 PM', '', 'show', 1),
(3, '', 'kids/gallery1512996423.jpg', '11 Dec 2017 01:47 PM', '', 'show', 1),
(4, '', 'kids/gallery1512996473.jpg', '11 Dec 2017 01:47 PM', '', 'show', 1);

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

--
-- Table structure for table `our_facilities`
--

CREATE TABLE `our_facilities` (
  `id` int(11) NOT NULL,
  `image` varchar(250) NOT NULL,
  `title` varchar(100) NOT NULL,
  `heading` varchar(100) NOT NULL,
  `description` varchar(500) NOT NULL,
  `created_at` varchar(200) NOT NULL,
  `updated_at` varchar(200) NOT NULL,
  `content` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `our_facilities`
--

INSERT INTO `our_facilities` (`id`, `image`, `title`, `heading`, `description`, `created_at`, `updated_at`, `content`, `status`) VALUES
(1, 'kids/facilities_1512992212.png', '', 'skating', 'our campuses are equipped with the best training facilities for our indoor pool..', '11 Dec 2017 11:53 AM', '11 Dec 2017 12:36 PM', 'show', 1),
(2, 'kids/facility_1512990867.png', '', 'swimming', 'the school is equipped with a skating rink that develops stability.', '11 Dec 2017 12:14 PM', '', 'show', 1),
(3, 'kids/facility_1512991348.png', '', 'science lab', 'experiementation at our laba are a regalar feateure of the school..', '11 Dec 2017 12:22 PM', '', 'show', 1);

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(10) NOT NULL,
  `site_title` varchar(50) NOT NULL,
  `contact_email` varchar(50) NOT NULL,
  `contact_number` varchar(50) NOT NULL,
  `facebook_link` varchar(50) NOT NULL,
  `twitter_link` varchar(50) NOT NULL,
  `footer_about_description` varchar(500) NOT NULL,
  `logo_image` varchar(50) NOT NULL,
  `favicon_image` varchar(50) NOT NULL,
  `meta_title` varchar(50) NOT NULL,
  `meta_description` varchar(100) NOT NULL,
  `meta_keywords` varchar(50) NOT NULL,
  `google_map_link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `site_title`, `contact_email`, `contact_number`, `facebook_link`, `twitter_link`, `footer_about_description`, `logo_image`, `favicon_image`, `meta_title`, `meta_description`, `meta_keywords`, `google_map_link`) VALUES
(1, 'kids school ', 'infokids@kids.com', '8522010702', 'facebook/kidsschool', 'twitter/kidsschool', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered maksu rez in some form, by injected humour, or randomised words which don\'t', 'kids/1512900227logo.png', '', '', '', '', '');

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

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` int(11) UNSIGNED NOT NULL,
  `image` varchar(200) DEFAULT NULL,
  `alt_text` varchar(25) DEFAULT NULL,
  `created_at` varchar(25) DEFAULT NULL,
  `updated_at` varchar(25) DEFAULT NULL,
  `image_value` varchar(50) NOT NULL,
  `status` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` (`id`, `image`, `alt_text`, `created_at`, `updated_at`, `image_value`, `status`) VALUES
(7, 'kids/slider_1512986087.jpg', 'slide2', '11 Dec 2017 10:54 AM', '11 Dec 2017 10:54 AM', 'show', 1),
(9, 'kids/slider_1513019165.jpg', 'slide1', '11 Dec 2017 08:06 PM', '11 Dec 2017 08:06 PM', 'show', 1);

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

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

CREATE TABLE `staff` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `description` varchar(500) NOT NULL,
  `created_at` varchar(150) NOT NULL,
  `updated_at` varchar(150) NOT NULL,
  `content` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `image`, `description`, `created_at`, `updated_at`, `content`, `status`) VALUES
(1, 'kids/staff_1513000188.jpg', 'principal', '11 Dec 2017 02:49 PM', '', 'show', 1),
(2, 'kids/staff_1513001044.jpg', 'vice principal', '11 Dec 2017 03:04 PM', '', 'show', 1),
(3, 'kids/staff_1513001115.jpg', 'teacher', '11 Dec 2017 03:05 PM', '', 'show', 1);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `our_facilities`
--
ALTER TABLE `our_facilities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `slides`
--
ALTER TABLE `slides`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;COMMIT;

