-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 14, 2020 at 04:47 PM
-- Server version: 10.1.32-MariaDB
-- PHP Version: 5.6.36

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: `edu_codeyaya`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `username` varchar(500) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `name`, `email`, `username`, `password`) VALUES
(1, 'Admin', 'admin@gmail.com', '', 'e10adc3949ba59abbe56e057f20f883e');

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `course` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `date_created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `posted_by` varchar(100) NOT NULL,
  `posted_date` varchar(100) NOT NULL,
  `content` longtext NOT NULL,
  `photo` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `category`, `posted_by`, `posted_date`, `content`, `photo`, `status`, `date_created`) VALUES
(6, 'Inquietude assistance precaution any impression man sufficient.', '', 'Admin', '2020-12-14', '<p style=\"padding: 0px; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(102, 102, 102); line-height: 26px; font-family: \" open=\"\" sans\",=\"\" sans-serif;\"=\"\">Give lady of they such they sure it. Me contained explained my education. Vulgar as hearts by garret. Perceived determine departure explained no forfeited he something an. Contrasted dissimilar get joy you instrument out reasonably. Again keeps at no meant stuff. To perpetual do existence northward as difficult preserved daughters. Continued at up to zealously necessary breakfast. Surrounded sir motionless she end literature. Gay direction neglected but supported yet her.</p><p style=\"padding: 0px; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(102, 102, 102); line-height: 26px; font-family: \" open=\"\" sans\",=\"\" sans-serif;\"=\"\">New had happen unable uneasy. Drawings can followed improved out sociable not. Earnestly so do instantly pretended. See general few civilly amiable pleased account carried. Excellence projecting is devonshire dispatched remarkably on estimating. Side in so life past. Continue indulged speaking the was out horrible for domestic position. Seeing rather her you not esteem men settle genius excuse. Deal say over you age from. Comparison new ham melancholy son themselves.</p>', '1ca416698f03c5d7f9fb81f8270f33ae.jpg', 1, '1585939092'),
(7, 'Discourse Ye Continued Pronounce We Particular Use Abilities.', '', 'Admin', '2020-07-17', '<p style=\"padding: 0px; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(102, 102, 102); line-height: 26px; font-family: &quot;Open Sans&quot;, sans-serif;\">Give lady of they such they sure it. Me contained explained my education. Vulgar as hearts by garret. Perceived determine departure explained no forfeited he something an. Contrasted dissimilar get joy you instrument out reasonably. Again keeps at no meant stuff. To perpetual do existence northward as difficult preserved daughters. Continued at up to zealously necessary breakfast. Surrounded sir motionless she end literature. Gay direction neglected but supported yet her.</p><p style=\"padding: 0px; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; color: rgb(102, 102, 102); line-height: 26px; font-family: &quot;Open Sans&quot;, sans-serif;\">New had happen unable uneasy. Drawings can followed improved out sociable not. Earnestly so do instantly pretended. See general few civilly amiable pleased account carried. Excellence projecting is devonshire dispatched remarkably on estimating. Side in so life past. Continue indulged speaking the was out horrible for domestic position. Seeing rather her you not esteem men settle genius excuse. Deal say over you age from. Comparison new ham melancholy son themselves.</p>', '8b7e2bf21148f5817f0a748199272836.jpg', 1, '1585939339'),
(8, 'Deficient Discourse Do Newspaper Be An Eagerness Continued.', '', 'Admin', '2020-08-28', '<p open=\"\" sans\",=\"\" sans-serif;\"=\"\" style=\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; line-height: 26px; color: rgb(102, 102, 102); padding: 0px;\">Give lady of they such they sure it. Me contained explained my education. Vulgar as hearts by garret. Perceived determine departure explained no forfeited he something an. Contrasted dissimilar get joy you instrument out reasonably. Again keeps at no meant stuff. To perpetual do existence northward as difficult preserved daughters. Continued at up to zealously necessary breakfast. Surrounded sir motionless she end literature. Gay direction neglected but supported yet her.</p><p open=\"\" sans\",=\"\" sans-serif;\"=\"\" style=\"margin-right: 0px; margin-bottom: 20px; margin-left: 0px; line-height: 26px; color: rgb(102, 102, 102); padding: 0px;\">New had happen unable uneasy. Drawings can followed improved out sociable not. Earnestly so do instantly pretended. See general few civilly amiable pleased account carried. Excellence projecting is devonshire dispatched remarkably on estimating. Side in so life past. Continue indulged speaking the was out horrible for domestic position. Seeing rather her you not esteem men settle genius excuse. Deal say over you age from. Comparison new ham melancholy son themselves.</p>', '027be7d9c4569314f6a97fb8e5cc40f7.jpg', 1, '1585939405');

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

--
-- Table structure for table `business_profile`
--

CREATE TABLE `business_profile` (
  `id` int(11) NOT NULL,
  `business_name` varchar(100) NOT NULL,
  `business_email` varchar(50) NOT NULL,
  `brochure` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `business_profile`
--

INSERT INTO `business_profile` (`id`, `business_name`, `business_email`, `brochure`) VALUES
(1, 'Edu Codeyaya', 'info@codeyaya.com', '6d1f208d8fc1f9d2190c7d61e1e678e0.pdf');

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

--
-- Table structure for table `call_back`
--

CREATE TABLE `call_back` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `date_created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `call_back`
--

INSERT INTO `call_back` (`id`, `phone`, `date_created`) VALUES
(2, '9087654321', '1586062282');

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

--
-- Table structure for table `certifications`
--

CREATE TABLE `certifications` (
  `id` int(11) NOT NULL,
  `name` longtext NOT NULL,
  `photo` varchar(100) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `certifications`
--

INSERT INTO `certifications` (`id`, `name`, `photo`, `date_created`) VALUES
(3, 'facebook', '63d499da72cf2f70569e11e107379174.jpg', '1585937086'),
(4, 'linkedIn', '90488f0288cbfe6d7f115d2586c1fe2e.jpg', '1585937142'),
(5, 'google1', '43baf6fa96e433360a5abde362d0d09e.jpg', '1585937161'),
(6, 'google2', '1906ebdb3b5abdc7f7be670a83545747.jpg', '1585937177'),
(7, 'hubspot1', 'b07fa0a3bc67e1d8eb4276e6160445d7.jpg', '1585937199');

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) NOT NULL,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('frqe0c4n5pjta4bj69akvu8oc66clv3n', '::1', 1586875469, 0x5f5f63695f6c6173745f726567656e65726174657c693a313538363837353436393b);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `website` varchar(500) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `logo`, `website`, `date_created`) VALUES
(2, 'client1', '6f5e8b436ce25e7ade0d44d55aa9eca0.jpg', 'https://alyaauditors.com/', '1585937625'),
(3, 'client2', 'be92ce5e4391e04c0f24131fc2e07c71.jpg', '#', '1585937655'),
(4, 'client3', '36b6357137b28192756c4ec4615397d8.jpg', '#', '1585937688'),
(5, 'client4', '12e8afc9306ebf7c34b94bae522d13f7.jpg', 'http://www.bluebellairporthotel.com/', '1585937713'),
(6, 'client5', '4735d6662ac9cf0804989ec3d163fdc8.jpg', '#', '1585937731'),
(7, 'client6', '479ac03c43203abda56dcfaa2574eecd.jpg', '#', '1585937747'),
(8, 'client7', '634374e9d8ad7a00d2ba133190a722f7.jpg', 'https://fadefit.com/', '1585937778'),
(9, 'client8', '6cca95e9f6c51072c71db3d81c03148d.jpg', '#', '1585937797'),
(10, 'client9', '3e699cc9da8d96fe89c9cafbbcd1fd15.jpg', 'https://www.signature1hotels.com/', '1585937821'),
(11, 'client10', '2c7eda106b1c63304bbf9bb321536532.jpg', 'https://neomlmsoftware.com/', '1585937849'),
(12, 'client11', 'a23e73194f60269e3f956d79f42d42c4.jpg', '#', '1585937871'),
(13, 'client12', '25bf3992f23cceebf769f082f287dfb8.jpg', 'https://sparkemc.com/', '1585937893'),
(14, 'client13', '5d227f61191c1344ac5715136e329545.jpg', '#', '1585937911'),
(15, 'client14', '74489c17f8974aa4fa0deeb94f7266db.jpg', '#', '1585937934'),
(16, 'client15', '5e09e2e60713dcf23b137e0dfafdd2b1.jpg', 'https://tft.aero/', '1585937956');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(25) NOT NULL,
  `message` varchar(500) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `email`, `phone`, `message`, `date_created`) VALUES
(1, 'Aslam P', 'info@startiyo.com', '9946974111', 'Tell me about courses', '1586875067');

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

--
-- Table structure for table `download_brochure`
--

CREATE TABLE `download_brochure` (
  `id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `download_brochure`
--

INSERT INTO `download_brochure` (`id`, `first_name`, `last_name`, `email`, `phone`, `date_created`) VALUES
(1, 'Aslam', 'P', 'info@startiyo.com', '9946974111', '1586875245');

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

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

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `date_created` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `gallery` (`id`, `name`, `photo`, `date_created`) VALUES
(7, 'Meeting Room', 'deca0eb42202fca0b8379ad9da51e2ae.jpg', '1585938162'),
(8, 'Meeting Room', 'd53fae8fddda7695f42e96c5444af1c5.jpg', '1585938184'),
(9, 'Meeting Room', '9186703e8b16123049713636f27de58f.jpg', '1585938206'),
(10, 'Meeting Room', '15acc36095bc384a5416e8e52010ea1f.jpg', '1585938227'),
(11, 'Meeting Room', '7a22835d49fd6894dcb6d58dc5b33bd0.jpg', '1585938253'),
(12, 'Reception', '4a5b20c48db0ec010a13ae539c08dcc7.jpg', '1585938270'),
(13, 'Work Station', '212668072c44270ea98765ff0fcd5610.jpg', '1585938288'),
(14, 'Work Station', '6cd88e09210dd99034d81af8f28c9c48.jpg', '1585938307'),
(15, 'Front View', 'def991393028c0046d0970b77ed744eb.jpg', '1585938327'),
(16, 'Front View', '136515cd8635b42f7a3e90c393a06c29.jpg', '1585938357'),
(17, 'Reception', '959af098217e92874f7e7afda8a63e59.jpg', '1585938373'),
(18, 'Pantry', '4c0c46d607bc81d2879da78812eb4ae2.jpg', '1585938391'),
(19, 'Meeting Room', '76ab50d536fc69a7444856ea2a9a3a60.jpg', '1585938410'),
(20, 'Conference Hall', 'a313fde1113a54f6543f4557e766ea2d.jpg', '1585938448'),
(21, 'Meeting Room', '188505be796317a5dea707d17dfeef59.jpg', '1585938467');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`admin_id`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `download_brochure`
--
ALTER TABLE `download_brochure`
  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=23;
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 */;
