-- http://www.phpmyadmin.net
--




--
-- Database: `demo`
--

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

--
-- Table structure for table `assign_subject`
--

CREATE TABLE `assign_subject` (
  `id` int(11) NOT NULL,
  `branch` int(11) NOT NULL,
  `semister` int(11) NOT NULL,
  `subject_name` int(11) NOT NULL,
  `faculty` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assign_subject`
--

INSERT INTO `assign_subject` (`id`, `branch`, `semister`, `subject_name`, `faculty`) VALUES
(1, 1, 1, 3, 1),
(2, 1, 1, 4, 2),
(3, 1, 1, 5, 3);

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '1',
  `author_id` int(11) NOT NULL,
  `project_name` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `short_description` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `client` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `consultant` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `main_contractor` int(11) NOT NULL,
  `project_goals` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `featured_image` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('completed','current','upcoming') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'completed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `branch`
--

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

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`id`, `branch_name`) VALUES
(1, 'Computer'),
(2, 'mechanical engineering');

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

--
-- Table structure for table `faculty`
--

CREATE TABLE `faculty` (
  `id` int(11) NOT NULL,
  `branch` int(11) NOT NULL,
  `faculty_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faculty`
--

INSERT INTO `faculty` (`id`, `branch`, `faculty_name`) VALUES
(1, 1, 'BJ'),
(2, 1, 'FS'),
(3, 1, 'PM');

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

--
-- Table structure for table `feedbacks`
--

CREATE TABLE `feedbacks` (
  `id` int(11) NOT NULL,
  `branch` int(11) NOT NULL,
  `student` int(11) NOT NULL,
  `rate` varchar(50) NOT NULL,
  `semister` int(11) NOT NULL,
  `faculty` int(11) NOT NULL,
  `question` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feedbacks`
--

INSERT INTO `feedbacks` (`id`, `branch`, `student`, `rate`, `semister`, `faculty`, `question`) VALUES
(1, 0, 3, '["5","4","2"]', 0, 0, 1),
(2, 0, 3, '["3","4","5"]', 0, 0, 2),
(3, 0, 3, '["1","3","4"]', 0, 0, 3);

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`) VALUES
(1, 'admin', 'Administrator'),
(2, 'manager', 'Manager'),
(3, 'engineer', 'engineer'),
(4, 'members', 'General User');

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `navigation`
--

CREATE TABLE `navigation` (
  `id` int(10) NOT NULL,
  `navSlug` varchar(50) NOT NULL,
  `navTitle` varchar(50) NOT NULL,
  `seriaNav` longtext NOT NULL,
  `convertedNav` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `navigation`
--

INSERT INTO `navigation` (`id`, `navSlug`, `navTitle`, `seriaNav`, `convertedNav`) VALUES
(9, 'header', 'Header', '\r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n                                \r\n   \r\n   \r\n      			\r\n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <li class="dd-item" data-href="http://localhost/electric_final/" data-title="Home" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">Home</div></li>                        <li class="dd-item" data-href="http://" data-title="Profile" data-type="1"><button data-action="collapse" type="button">Collapse</button><button data-action="expand" type="button" style="display: none;">Expand</button><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">Profile</div><ul class="dd-list"><li class="dd-item" data-href="http://" data-title="About Us" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">About Us</div></li></ul></li><li class="dd-item" data-href="http://" data-title="vision &amp; mission" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">vision &amp; mission</div></li>                        ', '<ul class="nav navbar-nav"><li><a href="http://localhost/electric_final/">Home</a></li><li class="sub"><a href="#" class="has-submenu" data-toggle="sub">Profile</a><ul class="sub-menu"><li><a href="http://">About Us</a></li></ul></li><li><a href="http://">vision & mission</a></li></ul>'),
(10, 'footer-widget2', 'Quick Links', '\r\n                        <li class="dd-item" data-href="#" data-title="Home" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">Home</div></li><li class="dd-item" data-href="#" data-title="Products" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">Products</div></li><li class="dd-item" data-href="#" data-title="Services" data-type="1"><a class="right" onclick="var li = this.parentNode; var ul = li.parentNode; ul.removeChild(li);"><i class="fa fa-times"></i></a><div class="dd-handle">Services</div></li>', '<ul class="nav navbar-nav"><li><a href="#">Home</a></li><li><a href="#">Products</a></li><li><a href="#">Services</a></li></ul>');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) NOT NULL,
  `pageTitle` varchar(65) NOT NULL,
  `navTitle` varchar(100) NOT NULL,
  `pageContent` longtext NOT NULL,
  `html` longtext NOT NULL,
  `url` varchar(100) DEFAULT NULL,
  `pageKeywords` varchar(200) NOT NULL,
  `pageDescription` varchar(170) NOT NULL,
  `template` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `pageTitle`, `navTitle`, `pageContent`, `html`, `url`, `pageKeywords`, `pageDescription`, `template`, `status`, `date_created`) VALUES
(1, 'Home', 'home', '', '', 'home', 'home', 'home', 'home', 1, NULL),
(3, 'About Us', 'about-us', '{"data":[{"type":"columns","data":{"columns":[{"width":6,"blocks":[{"type":"heading","data":{"text":"About Solar Energy"}},{"type":"text","data":{"text":"Cras molestie lacus et libero vehicula semper. Pellentesque ac leo quis enim ultrices mollis. Duis ornare in dolor non ultricies. Integer nec sem diam. In sed urna at mi fringilla malesuada.\\n"}},{"type":"text","data":{"text":"__\\n_**Aenean efficitur vitae ligula eget vulputate. Donec id ligula lorem. Nam ipsum odio, rutrum a nisl non, scelerisque iaculis ex**_\\n__\\n"}},{"type":"text","data":{"text":"\\nInteger mattis efficitur scelerisque. Phasellus malesuada metus vitae orci condimentum, non blandit lacus consectetur.\\n\\n"}}]},{"width":6,"blocks":[{"type":"image_extended","data":{"file":{"url":"http://localhost/alshamsia/assets/uploads/pages/about-us.png","filename":"about-us.png"},"caption":"","source":""}}]}],"preset":"columns-6-6"}}]}', '<div class=''row''><div class=''col-md-6''><h2>About Solar Energy</h2>\n<p>Cras molestie lacus et libero vehicula semper. Pellentesque ac leo quis enim ultrices mollis. Duis ornare in dolor non ultricies. Integer nec sem diam. In sed urna at mi fringilla malesuada.</p>\n<p>__\n<em><strong>Aenean efficitur vitae ligula eget vulputate. Donec id ligula lorem. Nam ipsum odio, rutrum a nisl non, scelerisque iaculis ex</strong></em>\n__</p>\n<p>Integer mattis efficitur scelerisque. Phasellus malesuada metus vitae orci condimentum, non blandit lacus consectetur.</p>\n</div><div class=''col-md-6''><img class="img-responsive" src="http://localhost/alshamsia/assets/uploads/pages/about-us.png" alt="" />\n</div></div>', 'about-us', 'about-us', 'about-us', 'about_us', 1, NULL),
(7, 'Our Teams', 'ourteams', '', '', 'ourteams', 'ourteams', 'ourteams', 'our_team', 1, NULL),
(8, 'Services', 'services', '', '', 'services', 'services', 'services', 'services', 1, NULL),
(14, 'Products', 'products', '', '', 'products', 'products', 'products', 'product', 1, NULL),
(15, 'Contact Us', 'contactus', '', '', 'contactus', 'contactus', 'contactus', 'contact', 1, NULL),
(16, 'Photo Gallery', 'photo-gallery', '', '', 'photo-gallery', 'photo-gallery', 'photo-gallery', 'photo', 1, NULL),
(17, 'Video Gallery', 'video-gallery', '', '', 'video-gallery', 'video-gallery', 'video-gallery', 'video', 1, NULL);

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(11) NOT NULL,
  `question` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `question`) VALUES
(1, '<p>\r\n	<span background-color:="" font-size:="" helvetica="" sans="" source="" style="color: rgb(51, 51, 51); font-family: ">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span><span style="color: rgb(51, 51, 51);">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span><span style="color: rgb(51, 51, 51);">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span></p>\r\n'),
(2, '<p>\r\n	<span style="color: rgb(51, 51, 51);">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span><span style="color: rgb(51, 51, 51);">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span></p>\r\n'),
(3, '<p>\r\n	<span background-color:="" font-size:="" helvetica="" sans="" source="" style="color: rgb(51, 51, 51); font-family: ">Bacon ipsum dolor sit amet salami venison chicken flank fatback doner.</span></p>\r\n');

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

--
-- Table structure for table `semister`
--

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

--
-- Dumping data for table `semister`
--

INSERT INTO `semister` (`id`, `semister`) VALUES
(1, 'semister 1'),
(2, 'semister 2'),
(3, 'semister 3'),
(4, 'semister 4'),
(5, 'semister 5'),
(6, 'semister 6'),
(7, 'semister 7'),
(8, 'semister 8');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `p_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `service_name`, `description`, `p_id`) VALUES
(7, 'Accusant dolor', '<p>Sed ut perspiciatis unde omnis iste natus error sit&nbsp; voluptatem accusantium doloremque laudantium,&nbsp;</p>\n', 5),
(8, 'Doluptatibus', '<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium</p>\n', 6),
(9, 'Accusant dolor', '<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium</p>\n', 7),
(10, 'Doluptatibus', '<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium</p>\n', 0),
(11, 'Voluptatibus', '<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium</p>\n', 0),
(12, 'Accusant dolor', '<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium</p>\n', 0);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(7, 'logo', '{"upload_data":{"file_name":"logo.jpg","file_type":"image/jpeg","file_path":"C:/xampp/htdocs/alshamsia/uploads/","full_path":"C:/xampp/htdocs/alshamsia/uploads/logo.jpg","raw_name":"logo","orig_name":"logo.jpg","client_name":"logo.jpg","file_ext":".jpg","file_size":7.47,"is_image":true,"image_width":234,"image_height":86,"image_type":"jpeg"}}'),
(38, 'complanyName', 'Malleeycom International'),
(39, 'complanySlogen', ''),
(40, 'adminEmail', 'info@alshamsia.com'),
(41, 'contactName', ''),
(42, 'contactPhone', '+971 55438 7096'),
(43, 'contactEmail', 'info@alshamsia.com'),
(44, 'facebook', '#'),
(45, 'twitter', '#'),
(46, 'google', '#'),
(47, 'footer-logo', '{"upload_data":{"file_name":"Untitled-11.png","file_type":"image/png","file_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/","full_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/Untitled-11.png","raw_name":"Untitled-11","orig_name":"Untitled-1.png","client_name":"Untitled-1.png","file_ext":".png","file_size":20.51,"is_image":true,"image_width":200,"image_height":100,"image_type":"png"}}'),
(48, 'footer-widget1', ''),
(49, 'footer-widget2', ''),
(50, 'footer-widget3', ''),
(51, 'footer-widget4', '      <h3>Get in touch</h3>\r\n      <div class="office">\r\n        <span><i class="fa fa-map-marker"></i> Sharjah, UAE</span> \r\n        <span><i class="fa fa-phone"></i> (06)  5345663</span>\r\n        <span><i class="fa fa-fax"></i> (06)  5355167</span>\r\n        <span><i class="fa fa-envelope-o"></i> <a href="mailto:info@fajeralbakker.com" title="">info@fajeralbakker.com</a> </span>\r\n      </div>  '),
(52, 'footer-copyright', 'Copyright© 2016. All Rights Reserved. '),
(53, 'about-us-text', '<p style="font-weight:bold">There are many reasons why over a million of our woods are in homes just like yours. Fajer Al Bakker, a wood interior company is an industry leader in high-quality, energy efficient residential and commercial interiors,   that offer superior durability and enduring beauty.<br><br> With <strong>Fajer Al Bakker</strong>, you can be assured that your new furniture has passed a rigorous quality inspection for both appearance and performance. Most of all, you can count on a warm welcome every time you step into your home.</p>'),
(54, 'why-fajer-text', '<p style="font-weight:bold">If you are looking for high-quality, interior solid wood doors and exterior front entry wood doors at reasonable prices, you have come to the right place. We believe that we are the biggest and the best solid wood interiormanufacturer in the country and that our pricing can’t be beat. The combination of our size, advanced technology, fully integrated manufacturing processes (no out-sourcing which would add additional profit centers and cost), experience, dedicated employees, environmental awareness, and true direct-from-the-factory pricing make us the premier choice when it comes to purchasing your interior  and exterior furniture.</p>'),
(56, 'stastics', '[""]'),
(57, 'header-background', '{"upload_data":{"file_name":"Untitled-16.png","file_type":"image/png","file_path":"/home/anchabcy/public_html/wajebco.com/uploads/","full_path":"/home/anchabcy/public_html/wajebco.com/uploads/Untitled-16.png","raw_name":"Untitled-16","orig_name":"Untitled-1.png","client_name":"Untitled-1.png","file_ext":".png","file_size":0.3,"is_image":true,"image_width":159,"image_height":110,"image_type":"png"}}'),
(58, 'footer-background', '{"upload_data":{"file_name":"Savin-NY-Website-Background-Web1.jpg","file_type":"image/jpeg","file_path":"C:/xampp/htdocs/wajebco/uploads/","full_path":"C:/xampp/htdocs/wajebco/uploads/Savin-NY-Website-Background-Web1.jpg","raw_name":"Savin-NY-Website-Background-Web1","orig_name":"Savin-NY-Website-Background-Web.jpg","client_name":"Savin-NY-Website-Background-Web.jpg","file_ext":".jpg","file_size":58.67,"is_image":true,"image_width":1200,"image_height":400,"image_type":"jpeg"}}'),
(59, 'field_name', 'Array'),
(60, 'broadcumbs-background', '{"upload_data":{"file_name":"wood_decking_187097.jpg","file_type":"image/jpeg","file_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/","full_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/wood_decking_187097.jpg","raw_name":"wood_decking_187097","orig_name":"wood_decking_187097.jpg","client_name":"wood_decking_187097.jpg","file_ext":".jpg","file_size":23.72,"is_image":true,"image_width":266,"image_height":200,"image_type":"jpeg"}}'),
(61, 'highlights-background', '{"upload_data":{"file_name":"567176-01-barbarian-group-clive-wilkinson-0514.jpg","file_type":"image/jpeg","file_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/","full_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/567176-01-barbarian-group-clive-wilkinson-0514.jpg","raw_name":"567176-01-barbarian-group-clive-wilkinson-0514","orig_name":"567176-01-barbarian-group-clive-wilkinson-0514.jpg","client_name":"567176-01-barbarian-group-clive-wilkinson-0514.jpg","file_ext":".jpg","file_size":111.16,"is_image":true,"image_width":1200,"image_height":746,"image_type":"jpeg"}}'),
(62, 'stastics-background', '{"upload_data":{"file_name":"paralex.jpg","file_type":"image/jpeg","file_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/","full_path":"/home/citizzle2/public_html/TEST5833/fajer/uploads/paralex.jpg","raw_name":"paralex","orig_name":"paralex.jpg","client_name":"paralex.jpg","file_ext":".jpg","file_size":35.53,"is_image":true,"image_width":851,"image_height":314,"image_type":"jpeg"}}'),
(63, 'sample', 'rgba(147, 57, 70, 0.96)'),
(64, 'ckeditor-full', ''),
(65, 'ckeditor-small', ''),
(66, 'color', 'rgb(32, 26, 200)'),
(67, 'skype', '#'),
(68, 'contactMap', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d57664.61448643022!2d55.49814289324875!3d25.40352500285549!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3e5f5764dd8fbe79%3A0xcda090de6445a819!2sAjman+-+United+Arab+Emirates!5e0!3m2!1sen!2sin!4v1514358527154" width="800" height="600" frameborder="0" style="border:0" allowfullscreen></iframe>'),
(69, 'contactAddress', ' Ajman,U.A.E.'),
(70, 'liveChat', ' '),
(71, 'statistic1text', 'Branches'),
(72, 'statistic1value', '2'),
(73, 'statistictext', 'Experts'),
(74, 'statistic2value', '55'),
(75, 'statistic3text', 'Clients'),
(76, 'statistic3value', '416'),
(77, 'statistic4text', 'Products'),
(78, 'statistic4value', '856'),
(79, 'statistics', 'a:2:{s:4:"text";a:1:{i:0;s:0:"";}s:5:"value";a:1:{i:0;s:0:"";}}'),
(80, 'contactHours', 'Mon - Fri 08AM-8PM'),
(81, 'banner-heading', 'WE ARE CONSTRUCTION'),
(82, 'banner-text', 'We are expert in construction and building by 1980. We provide<br /> the best financing solution  for your business.'),
(83, 'banner-background', '{"upload_data":{"file_name":"banner-image.jpg","file_type":"image/jpeg","file_path":"C:/xampp/htdocs/future/uploads/","full_path":"C:/xampp/htdocs/future/uploads/banner-image.jpg","raw_name":"banner-image","orig_name":"banner-image.jpg","client_name":"banner-image.jpg","file_ext":".jpg","file_size":474.54,"is_image":true,"image_width":1900,"image_height":744,"image_type":"jpeg"}}'),
(84, 'call-to-action', 'Get a free quote now or ask us a question, it is free, simple and fast. We will be happy to answer you.'),
(85, 'gplus', '#'),
(87, 'serviceHeading1', ''),
(88, 'servicetext1', 'text'),
(90, 'serviceHeading2', ''),
(91, 'servicetext2', 'text'),
(93, 'serviceHeading3', ''),
(94, 'servicetext3', 'text'),
(96, 'serviceHeading4', ''),
(97, 'servicetext4', 'text'),
(98, 'best-service-text', 'Welcome To CEP Education Center "MISSION FOR COMPUTER EDUCATION IN GUJARAT". We are Providing All Types of Computer Courses, Diploma Courses, Advance Diploma Courses and University Courses & Computer Education Franchises.We provide computer education Franchises in INDIA. Computer Educatipn Programme and Training Center is Registered under Gujarat Government. Cep Providing the Career Developement Courses, Personality Developement Courses And Many More Courses in Computer Application.'),
(99, 'footer-column1', 'Lorem ipsum dolor  amet natum latine copiosa at quo, suas labore saperet  has there any quote for write lorem sit latineu suas dummy sample'),
(100, 'footer-column2', ''),
(101, 'footer-column3', ''),
(102, 'serviceIcon1', '{"upload_data":{"file_name":"01-service-icon.png","file_type":"image/png","file_path":"C:/xampp/htdocs/wajebco/uploads/","full_path":"C:/xampp/htdocs/wajebco/uploads/01-service-icon.png","raw_name":"01-service-icon","orig_name":"01-service-icon.png","client_name":"01-service-icon.png","file_ext":".png","file_size":1.39,"is_image":true,"image_width":32,"image_height":28,"image_type":"png"}}'),
(103, 'serviceIcon2', '{"upload_data":{"file_name":"02-service-icon.png","file_type":"image/png","file_path":"C:/xampp/htdocs/wajebco/uploads/","full_path":"C:/xampp/htdocs/wajebco/uploads/02-service-icon.png","raw_name":"02-service-icon","orig_name":"02-service-icon.png","client_name":"02-service-icon.png","file_ext":".png","file_size":1.59,"is_image":true,"image_width":32,"image_height":32,"image_type":"png"}}'),
(104, 'serviceIcon3', '{"upload_data":{"file_name":"03-service-icon.png","file_type":"image/png","file_path":"C:/xampp/htdocs/wajebco/uploads/","full_path":"C:/xampp/htdocs/wajebco/uploads/03-service-icon.png","raw_name":"03-service-icon","orig_name":"03-service-icon.png","client_name":"03-service-icon.png","file_ext":".png","file_size":1.46,"is_image":true,"image_width":32,"image_height":32,"image_type":"png"}}'),
(105, 'serviceIcon4', '{"upload_data":{"file_name":"04-service-icon.png","file_type":"image/png","file_path":"C:/xampp/htdocs/wajebco/uploads/","full_path":"C:/xampp/htdocs/wajebco/uploads/04-service-icon.png","raw_name":"04-service-icon","orig_name":"04-service-icon.png","client_name":"04-service-icon.png","file_ext":".png","file_size":1.57,"is_image":true,"image_width":32,"image_height":22,"image_type":"png"}}'),
(106, 'brodcumb-background', '{"upload_data":{"file_name":"wallpaper-city-111.jpg","file_type":"image/jpeg","file_path":"/home/anchabcy/public_html/wajebco.com/uploads/","full_path":"/home/anchabcy/public_html/wajebco.com/uploads/wallpaper-city-111.jpg","raw_name":"wallpaper-city-111","orig_name":"wallpaper-city-11.jpg","client_name":"wallpaper-city-11.jpg","file_ext":".jpg","file_size":364.99,"is_image":true,"image_width":1366,"image_height":768,"image_type":"jpeg"}}'),
(107, 'contactPhone2', ' +971 5543 7096'),
(108, 'contactAddress2', 'SF-30,31 Vatsalya Status,<br>opp. Railway Station, Kadi. <br>Dist-Mehsana.'),
(109, 'contactMap2', '  <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3605.4800939375314!2d55.48005371554877!3d25.35522148382295!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3e5f589873a1b37b%3A0x77c4de81ac9e0bf7!2sAltitude+The+Box+(Crossfit)!5e0!3m2!1sen!2sin!4v1513080357151" width="600" height="450" frameborder="0" style="border:0" allowfullscreen></iframe>\r\n          '),
(110, 'contactEmail2', 'info@goldengate.com'),
(111, 'website-background', '{"upload_data":{"file_name":"con4.png","file_type":"image/png","file_path":"/home/anchabcy/public_html/wajebco.com/uploads/","full_path":"/home/anchabcy/public_html/wajebco.com/uploads/con4.png","raw_name":"con4","orig_name":"con4.png","client_name":"con4.png","file_ext":".png","file_size":20.36,"is_image":true,"image_width":466,"image_height":349,"image_type":"png"}}'),
(112, 'youtube', '#'),
(113, 'footer-column4', ''),
(114, 'homepage-about-us-text', 'Gulf Engineering Services L.L.C. holds true to its four core values: Honesty, Trust, Respect and Humility, for both customers and employees.\r\nWe don’t just hang that statement on the wall, but we strive to live by it every day. We work hard to demonstrate values of honesty, trust, respect and humility in every transaction we encounter with our customers and our employees.\r\nBecause of this attitude, we have built a strong base of quality, experienced staff that genuinely cares about doing great jobs for our customers. We have also earned a strong base of loyal customers who continuously rely on us for all of their HVAC, Electrical, Plumbing, Cleaning and Security issues, large and small. Satisfied customers will ensure the continued growth of our company and the growth of the people that make our company work.'),
(115, 'management-contact-map', ''),
(116, 'management-office-address', 'Bel Resheed Tower 1\r\n10th Floor, Office No. 1002<br>\r\nP.O. Box : 68712, Sharjah, U.A.E.'),
(117, 'management-office-email', 'gaurangp199@gmail.com'),
(118, 'management-office-phone', '+971 6 5754647'),
(119, 'management-office-fax', '+971 6 5754648'),
(120, 'management-office-pin', '68712'),
(121, 'operation-office-address', ''),
(122, 'operation-office-phone', ''),
(123, 'operation-office-fax', ''),
(124, 'operation-office-pin', ''),
(125, 'bodyBackground', '{"upload_data":{"file_name":"back.jpg","file_type":"image/jpeg","file_path":"C:/xampp/htdocs/gesnew/gesfinal/uploads/","full_path":"C:/xampp/htdocs/gesnew/gesfinal/uploads/back.jpg","raw_name":"back","orig_name":"back.jpg","client_name":"back.jpg","file_ext":".jpg","file_size":282.89,"is_image":true,"image_width":1600,"image_height":600,"image_type":"jpeg"}}'),
(126, 'about-us-image', '{"upload_data":{"file_name":"company.jpg","file_type":"image/jpeg","file_path":"C:/xampp/htdocs/gesnew/gesfinal/uploads/","full_path":"C:/xampp/htdocs/gesnew/gesfinal/uploads/company.jpg","raw_name":"company","orig_name":"company.jpg","client_name":"company.jpg","file_ext":".jpg","file_size":647.86,"is_image":true,"image_width":1300,"image_height":509,"image_type":"jpeg"}}'),
(127, 'companyName', ''),
(128, 'googleplus', '#'),
(129, 'followers', '500'),
(130, 'support', '100'),
(131, 'clients', '200'),
(132, 'awards', '700');

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

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `branch` int(11) NOT NULL,
  `semister` int(11) NOT NULL,
  `subject_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `branch`, `semister`, `subject_name`) VALUES
(3, 1, 1, 'C'),
(4, 1, 1, 'c++'),
(5, 1, 1, 'java');

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

--
-- Table structure for table `users_groups`
--

CREATE TABLE `users_groups` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group_id` mediumint(8) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_groups`
--

INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
(1, 1, 1);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `navigation`
--
ALTER TABLE `navigation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`navSlug`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url` (`url`);

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

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

--
-- Indexes for table `users_groups`
--
ALTER TABLE `users_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
  ADD KEY `fk_users_groups_users1_idx` (`user_id`),
  ADD KEY `fk_users_groups_groups1_idx` (`group_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assign_subject`
--
ALTER TABLE `assign_subject`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `faculty`
--
ALTER TABLE `faculty`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `feedbacks`
--
ALTER TABLE `feedbacks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `navigation`
--
ALTER TABLE `navigation`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `semister`
--
ALTER TABLE `semister`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;
--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `users_groups`
--
ALTER TABLE `users_groups`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `users_groups`
--
ALTER TABLE `users_groups`
  ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

