-- PHP MySQL Dump
--
-- Generated: Wed, 27 Nov 2019 09:31:06 +0100


--
-- Database: `tekwsills`
--

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

--
-- Table structure for table `aboutus`
--

CREATE TABLE `aboutus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `main_description` text NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aboutus`
--

INSERT INTO `aboutus` (`id`, `title`, `image`, `description`, `main_description`, `created_at`, `updated_at`, `status`) VALUES
('1', 'Welcome toTekWills', '1574772756_welcome.png', '<p style=\"text-align:justify\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat Duis.<br />\r\n<br />\r\nVoluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.</p>\r\n\r\n<p style=\"text-align:justify\">Voluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.</p>\r\n', '<p style=\"text-align:justify\">Voluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.Voluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.Voluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.Voluptate velit esse cillum dolore eu fugiat nulla pariatur. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation.</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2016-11-26', '2019-11-26', '1');

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

--
-- Table structure for table `contact_us_enquiries`
--

CREATE TABLE `contact_us_enquiries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_us_enquiries`
--

INSERT INTO `contact_us_enquiries` (`id`, `name`, `email`, `mobile`, `service_name`, `message`, `created_at`, `updated_at`, `status`) VALUES
('1', '', '', '', '', ' Dear Admin, you have new Quick enquiry \r\n  Name : \r\n Email : \r\n Phone : \r\n  subject : \r\n  message : ', '2019-11-27', '', '1');

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

--
-- Table structure for table `header_image`
--

CREATE TABLE `header_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `meta_keywords` text NOT NULL,
  `meta_description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `header_image`
--

INSERT INTO `header_image` (`id`, `title`, `meta_keywords`, `meta_description`, `image`, `created_at`, `updated_at`, `status`) VALUES
('1', 'about', 'about', 'about', '1574838533_banner1.png', '2019-01-05', '', '1'),
('2', 'services', 'services', 'services', '1574838591_banner1.png', '2019-01-05', '', '1'),
('3', 'gallery', 'gallery', 'gallery', '1574838576_banner1.png', '2019-01-05', '', '1'),
('4', 'contact', 'contact', 'contact', '1574838602_banner1.png', '2019-01-05', '', '1');

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

--
-- Table structure for table `photo_gallery`
--

CREATE TABLE `photo_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photo_gallery`
--

INSERT INTO `photo_gallery` (`id`, `image`, `created_at`, `updated_at`, `status`) VALUES
('3', '1574768365_banner1.png', '2019-11-26', '2019-11-26', '1'),
('4', '1574768188_img2.jpg', '2019-11-26', '2019-11-26', '1'),
('5', '1574767766_img1.png', '2019-11-26', '2019-11-26', '1'),
('6', '1574768188_img2.jpg', '2019-11-26', '2019-11-26', '1'),
('7', '1574767766_img1.png', '2019-11-26', '2019-11-26', '1'),
('8', '1574768188_img2.jpg', '2019-11-26', '2019-11-26', '1'),
('9', '1574767766_img1.png', '2019-11-26', '2019-11-26', '1'),
('10', '1574768188_img2.jpg', '2019-11-26', '2019-11-26', '1'),
('11', '1574768386_img4.png', '2019-11-26', '2019-11-26', '1'),
('12', '1574830958_service1.png', '2019-11-27', '', '1'),
('13', '1574767766_img1.png', '2019-11-26', '2019-11-26', '1'),
('14', '1574768188_img2.jpg', '2019-11-26', '2019-11-26', '1'),
('15', '1574768386_img4.png', '2019-11-26', '2019-11-26', '1'),
('16', '1574830958_service1.png', '2019-11-27', '', '1');

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

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

CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

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

INSERT INTO `services` (`id`, `title`, `image`, `description`, `created_at`, `updated_at`, `status`) VALUES
('3', 'title comes here', 'icon-settings', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1'),
('4', 'title comes here', 'icon-settings', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1'),
('5', 'title comes here', 'icon-settings', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1'),
('6', 'title comes here', 'icon-settings', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1'),
('7', 'title comes here', 'icon-settings', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1'),
('8', 'title comes here', 'icon-users', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '', '1'),
('9', 'title comes here', 'icon-users', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '', '1'),
('10', 'title comes here', 'icon-users', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '', '1'),
('11', 'new one', 'icon-users', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Officia assumenda reiciendis nam id inventore.</p>\r\n', '2019-11-26', '2019-11-26', '1');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `image`, `created_at`, `updated_at`, `status`) VALUES
('1', 'fdfvsd', '1574768532_banner1.png', '2019-11-26', '2019-11-26', '1'),
('2', 'fdfvsd', '1574768544_banner2.png', '2019-11-26', '2019-11-26', '1'),
('3', 'fdfvsd', '1574768683_banner3.png', '2019-11-26', '2019-11-26', '1');

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

--
-- Table structure for table `social_media_links`
--

CREATE TABLE `social_media_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facebook` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `google` varchar(255) NOT NULL,
  `viber` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `created_at` varchar(20) DEFAULT NULL,
  `updated_at` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `social_media_links`
--

INSERT INTO `social_media_links` (`id`, `facebook`, `twitter`, `google`, `viber`, `instagram`, `youtube`, `created_at`, `updated_at`, `status`) VALUES
('1', 'http://www.facebook.com', 'http://www.twitter.com', 'https://www.google.com', 'https://www.viber.com', 'https://www.instagram.com', 'https://www.youtube.com', '2019-01-05', '2019-11-26', '1');
