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

START TRANSACTION;



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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `cust_id` varchar(20) NOT NULL,
  `cust_name` varchar(100) DEFAULT NULL,
  `cust_email` varchar(120) DEFAULT NULL,
  `cust_phone` varchar(50) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `PostingDate` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requests_material`
--

CREATE TABLE `requests_material` (
  `id` int(30) NOT NULL,
  `varietyName` varchar(200) NOT NULL,
  `p_name` varchar(100) NOT NULL,
  `quantity` int(250) NOT NULL,
  `bags` int(50) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `supplier` varchar(200) NOT NULL,
  `specs` text NOT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'Waiting For Approval',
  `charges` float NOT NULL,
  `reason` varchar(200) NOT NULL,
  `DueDate` datetime NOT NULL,
  `inventoryStatus` varchar(20) NOT NULL DEFAULT 'Pending',
  `Duration` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `payStatus` varchar(20) NOT NULL DEFAULT 'Pending',
  `Ref` varchar(200) NOT NULL,
  `servedBy` varchar(200) NOT NULL,
  `prodstats` varchar(100) NOT NULL DEFAULT 'In Progress'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `requests_material`
--

INSERT INTO `requests_material` (`id`, `varietyName`, `p_name`, `quantity`, `bags`, `weight`, `supplier`, `specs`, `status`, `charges`, `reason`, `DueDate`, `inventoryStatus`, `Duration`, `date_created`, `payStatus`, `Ref`, `servedBy`, `prodstats`) VALUES
(75, 'Exfoliants', '', 5, 0, '', 'Omondi Titus', 'White ', 'Released', 0, '', '0000-00-00 00:00:00', 'Pending', '', '2025-11-24 11:34:07', 'Pending', '', '', 'In Progress'),
(76, 'Face masks', '', 5, 0, '', 'Omondi Titus', 'White and rough ', 'Released', 0, '', '0000-00-00 00:00:00', 'Pending', '', '2025-11-24 11:43:38', 'Pending', '', '', 'In Progress'),
(77, 'Cleansers', '', 5, 0, '', '', 'Rough cleansers', 'Released', 0, '', '0000-00-00 00:00:00', 'Pending', '', '2025-11-24 15:23:12', 'Pending', '', '', 'In Progress');

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

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `id` int(11) NOT NULL,
  `pid` int(200) NOT NULL,
  `varietyName` varchar(200) NOT NULL,
  `price` int(10) NOT NULL,
  `qty` int(200) NOT NULL,
  `status` varchar(20) NOT NULL,
  `imge` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`id`, `pid`, `varietyName`, `price`, `qty`, `status`, `imge`) VALUES
(13, 0, 'Scrabber', 400, 470, '1', ''),
(14, 0, 'Cleansers', 700, 165, '', ''),
(15, 0, 'Exfoliants', 550, 45, '', ''),
(16, 0, 'Face masks', 600, 745, '', ''),
(17, 0, 'Moisturizers', 1500, 105, '', '');

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

--
-- Table structure for table `tbl_bookings`
--

CREATE TABLE `tbl_bookings` (
  `id` int(10) NOT NULL,
  `stu_id` int(10) NOT NULL,
  `full_name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `address` varchar(100) NOT NULL,
  `service` varchar(50) NOT NULL,
  `feedback` varchar(200) NOT NULL,
  `charges` varchar(50) NOT NULL,
  `fee` float NOT NULL,
  `transactioncode` varchar(100) NOT NULL,
  `eventdate` date NOT NULL DEFAULT current_timestamp(),
  `location` varchar(200) NOT NULL,
  `county` varchar(100) NOT NULL,
  `supervisor` varchar(100) NOT NULL DEFAULT 'Not Assigned',
  `technician` varchar(50) NOT NULL DEFAULT 'Not Assigned',
  `recommandation` varchar(1000) NOT NULL,
  `engineer_recommandation` varchar(1000) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `payment_status` varchar(20) NOT NULL DEFAULT 'Pending',
  `qty` int(11) NOT NULL,
  `photographer_status` varchar(30) NOT NULL DEFAULT 'Pending',
  `date` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `cust_remark` varchar(200) NOT NULL,
  `amount` float NOT NULL,
  `product_details` varchar(500) NOT NULL,
  `driver` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `completion_status` varchar(100) NOT NULL DEFAULT 'Pending',
  `materialcost` float NOT NULL,
  `labourcost` float NOT NULL,
  `repstats` varchar(50) NOT NULL DEFAULT 'Pending',
  `total` float NOT NULL,
  `method` varchar(500) NOT NULL,
  `duration` varchar(500) NOT NULL,
  `l_name` varchar(100) NOT NULL,
  `servicetype` varchar(200) NOT NULL,
  `category` varchar(100) NOT NULL,
  `note` varchar(500) NOT NULL,
  `frm_t` varchar(100) NOT NULL,
  `to_t` varchar(100) NOT NULL,
  `medication` varchar(100) NOT NULL DEFAULT 'Waiting'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_bookings`
--

INSERT INTO `tbl_bookings` (`id`, `stu_id`, `full_name`, `email`, `phone`, `address`, `service`, `feedback`, `charges`, `fee`, `transactioncode`, `eventdate`, `location`, `county`, `supervisor`, `technician`, `recommandation`, `engineer_recommandation`, `status`, `payment_status`, `qty`, `photographer_status`, `date`, `cust_remark`, `amount`, `product_details`, `driver`, `description`, `completion_status`, `materialcost`, `labourcost`, `repstats`, `total`, `method`, `duration`, `l_name`, `servicetype`, `category`, `note`, `frm_t`, `to_t`, `medication`) VALUES
(185, 70, 'Joseph ', 'kamau@gmail.com', '0700566565', '', 'Slimming Skincare', '', '3500', 0, 'GJ137HRNFM', '2025-11-30', '', '', 'Not Assigned', 'Omondi Titus', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 10:57:37', '', 0, '', '', '', 'Completed', 0, 0, 'Pending', 0, '', 'Xyz', 'kamau', '', '', 'Happy ', '06:00', '08:00', 'Waiting'),
(186, 70, 'Joseph ', 'kamau@gmail.com', '0700566565', '', 'Nutrition Management', '', '4500', 0, 'BI677BFKFM', '2025-11-25', '', '', 'Not Assigned', 'Alice Boyani', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 08:12:59', '', 0, '', '', '', 'Pending', 0, 0, 'Pending', 0, '', 'Vdnmfm', 'kamau', '', '', '', '11:00', '01:00', 'Waiting'),
(187, 67, 'J', 'jk@gmail.com', '0753121619', '', 'Slimming Skincare', '', '3500', 0, 'GR274GDNND', '2025-11-30', '', '', 'Not Assigned', 'Omondi Titus', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 11:37:39', '', 0, '', '', '', 'Completed', 0, 0, 'Pending', 0, '', 'Full slimming ', 'K', '', '', 'Good ', '02:00', '03:00', 'Waiting'),
(188, 67, 'J', 'jk@gmail.com', '0753121619', '', 'Full facial treatment', '', '3500', 0, 'FH2466HJVN', '2025-11-30', '', '', 'Not Assigned', 'Omondi Titus', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 11:45:44', '', 0, '', '', '', 'Completed', 0, 0, 'Pending', 0, '', 'Full scrabbing ', 'K', '', '', 'Joy', '06:00', '07:00', 'Waiting'),
(189, 69, 'Black', 'black@gmail.com', '0756265995', '', 'Nutrition Management', '', '4500', 0, 'HFJR364846', '2025-11-27', '', '', 'Not Assigned', 'Alice Boyani', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 12:48:46', '', 0, '', '', '', 'Completed', 0, 0, 'Pending', 0, '', 'A weekly breakdown ', 'Pen', '', '', 'Served', '06:00', '07:00', 'Waiting'),
(190, 72, 'John', 'john@gmail.com', '0743151659', '', 'Massage Services', '', '4500', 0, 'GJ63848HFJ', '2025-11-30', '', '', 'Not Assigned', 'Joy Mbuki', '', '', 'Approved', 'Approved', 0, 'Pending', '2025-11-24 15:27:59', 'Well served', 0, '', '', '', 'Completed', 0, 0, 'Pending', 0, '', 'Full body massage ', 'kamaa', '', '', 'Well served ', '06:00', '08:00', 'Waiting');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(100) NOT NULL DEFAULT '',
  `cost` float NOT NULL,
  `servicecost` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`country_id`, `country_name`, `cost`, `servicecost`) VALUES
(1, 'Mombasa', 200, 700),
(2, 'Kwale', 0, 680),
(3, 'Kilifi', 0, 650),
(4, 'Tana River', 0, 600),
(5, 'Lamu', 0, 630),
(6, 'Taita-Taveta', 0, 600),
(7, 'Garissa', 0, 600),
(8, 'Wajir', 0, 600),
(9, 'Mandera', 0, 600),
(10, 'Marsabit', 0, 700),
(11, 'Isiolo', 0, 400),
(12, 'Meru', 0, 300),
(13, 'Tharaka-Nithi', 0, 300),
(14, 'Embu', 0, 300),
(15, 'Kitui', 0, 300),
(16, 'Machakos', 0, 300),
(17, 'Makueni', 0, 300),
(18, 'Nyandarua', 0, 300),
(19, 'Nyeri', 0, 300),
(20, 'Kirinyaga', 0, 300),
(21, 'Muranga', 0, 300),
(22, 'Kiambu', 0, 250),
(23, 'Turkana', 0, 700),
(24, 'West Pokot', 0, 600),
(25, 'Samburu', 0, 600),
(26, 'Trans Nzoia', 0, 350),
(27, 'Uasin Ngishu', 0, 350),
(28, 'Elgeiyo Marakwet', 0, 350),
(29, 'Nandi', 0, 400),
(30, 'Baringo', 0, 350),
(31, 'Laikipia', 0, 300),
(32, 'Nakuru', 0, 250),
(33, 'Narok', 0, 250),
(34, 'Kajiado', 0, 250),
(35, 'Kericho', 0, 250),
(36, 'Bomet', 0, 250),
(37, 'Kakamega', 0, 400),
(38, 'Vihiga', 0, 400),
(39, 'Bungoma', 0, 400),
(40, 'Busia', 0, 350),
(41, 'Siaya', 0, 400),
(42, 'Kisumu', 0, 300),
(43, 'Homa Bay', 0, 300),
(44, 'Migori', 0, 400),
(45, 'Kisii', 0, 300),
(46, 'Nyamira', 0, 400),
(47, 'Nairobi', 0, 100),
(246, 'I will Pick', 0, 0);

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

--
-- Table structure for table `tbl_faq`
--

CREATE TABLE `tbl_faq` (
  `faq_id` int(11) NOT NULL,
  `faq_title` varchar(255) NOT NULL,
  `faq_content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_faq`
--

INSERT INTO `tbl_faq` (`faq_id`, `faq_title`, `faq_content`) VALUES
(1, 'How to book for a service', '<h3 class=\"checkout-complete-box font-bold txt16\" style=\"box-sizing: inherit; text-rendering: optimizeLegibility; margin: 0.2rem 0px 0.5rem; padding: 0px; line-height: 1.4; background-color: rgb(250, 250, 250);\"><font color=\"#222222\" face=\"opensans, Helvetica Neue, Helvetica, Helvetica, Arial, sans-serif\"><span style=\"font-size: 15.7143px;\">We have a wide range of services you can decide to choose.</span></font></h3><h3 class=\"checkout-complete-box font-bold txt16\" style=\"box-sizing: inherit; text-rendering: optimizeLegibility; margin: 0.2rem 0px 0.5rem; padding: 0px; line-height: 1.4; background-color: rgb(250, 250, 250);\"><span style=\"font-size: 15.7143px; color: rgb(34, 34, 34); font-family: opensans, \" helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;\"=\"\">1:Use the search bar to access services.</span></h3><h3 class=\"checkout-complete-box font-bold txt16\" style=\"box-sizing: inherit; text-rendering: optimizeLegibility; margin: 0.2rem 0px 0.5rem; padding: 0px; line-height: 1.4; background-color: rgb(250, 250, 250);\"><font color=\"#222222\" face=\"opensans, Helvetica Neue, Helvetica, Helvetica, Arial, sans-serif\"><span style=\"font-size: 15.7143px;\">2: Navigate through the services and choose the service you want.</span></font><br></h3>\r\n'),
(6, 'How to Register your Account', '<p>To Register your Account , follow these steps;</p><p>1.Click on SignUp button on top of this site and two buttons will pop</p><p>2.Click on Client/ Customer and a Login page will open</p><p>3.At the Bottom of the Page click Create Account and a Sign Up page will open</p><p>4.Finally, Fill your details and click Register.</p><p><br></p>'),
(7, 'How To Login into Your Account', '<p><br></p><p>To Login into your Account follow the following steps;</p><p><br></p><p>1..Click on SignUp button on top of the site and two buttons will pop</p><p><br></p><p>2..Click on Customer and a Login page will open</p><p><br></p><p>3.Enter Your Email and Password and Click Sign In</p>'),
(8, 'How to Request For a Service', '<p>To request for a service follow the following steps;</p><p>1. On the menu bar clik on \'Our Services\'</p><p>2.A page will open with a button for \"Request Now\', click on the button</p><p>3.Fill in the information what service you would like to be done for you</p><p>4.Click submit your request will be sent.</p><p>5. On top of the site click on \'My DASHBOARD\'</p><p>6.Navigate to Special Order</p><p>7.Pay for the requested service here</p><p>8.Submit the transaction code and wait for approval</p>'),
(9, 'How to Contact Company Staff', '<p>To send your message to any of the company staff;</p><p>1. On top of the site click on MY DASHBOARD</p><p>2.Navigate to Feedback and click the button</p><p>3.On top of the Messages page click on \'New\'</p><p>4.Select Recepient and type your message</p><p>5. Click send and your message will be sent to the person selected</p>');

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

--
-- Table structure for table `tbl_page`
--

CREATE TABLE `tbl_page` (
  `id` int(11) NOT NULL,
  `about_title` varchar(255) NOT NULL,
  `about_content` text NOT NULL,
  `about_banner` varchar(255) NOT NULL,
  `about_meta_title` varchar(255) NOT NULL,
  `about_meta_keyword` text NOT NULL,
  `about_meta_description` text NOT NULL,
  `faq_title` varchar(255) NOT NULL,
  `faq_banner` varchar(255) NOT NULL,
  `faq_meta_title` varchar(255) NOT NULL,
  `faq_meta_keyword` text NOT NULL,
  `faq_meta_description` text NOT NULL,
  `blog_title` varchar(255) NOT NULL,
  `blog_banner` varchar(255) NOT NULL,
  `blog_meta_title` varchar(255) NOT NULL,
  `blog_meta_keyword` text NOT NULL,
  `blog_meta_description` text NOT NULL,
  `contact_title` varchar(255) NOT NULL,
  `contact_banner` varchar(255) NOT NULL,
  `contact_meta_title` varchar(255) NOT NULL,
  `contact_meta_keyword` text NOT NULL,
  `contact_meta_description` text NOT NULL,
  `pgallery_title` varchar(255) NOT NULL,
  `pgallery_banner` varchar(255) NOT NULL,
  `pgallery_meta_title` varchar(255) NOT NULL,
  `pgallery_meta_keyword` text NOT NULL,
  `pgallery_meta_description` text NOT NULL,
  `vgallery_title` varchar(255) NOT NULL,
  `vgallery_banner` varchar(255) NOT NULL,
  `vgallery_meta_title` varchar(255) NOT NULL,
  `vgallery_meta_keyword` text NOT NULL,
  `vgallery_meta_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_page`
--

INSERT INTO `tbl_page` (`id`, `about_title`, `about_content`, `about_banner`, `about_meta_title`, `about_meta_keyword`, `about_meta_description`, `faq_title`, `faq_banner`, `faq_meta_title`, `faq_meta_keyword`, `faq_meta_description`, `blog_title`, `blog_banner`, `blog_meta_title`, `blog_meta_keyword`, `blog_meta_description`, `contact_title`, `contact_banner`, `contact_meta_title`, `contact_meta_keyword`, `contact_meta_description`, `pgallery_title`, `pgallery_banner`, `pgallery_meta_title`, `pgallery_meta_keyword`, `pgallery_meta_description`, `vgallery_title`, `vgallery_banner`, `vgallery_meta_title`, `vgallery_meta_keyword`, `vgallery_meta_description`) VALUES
(1, 'About Us', '<p>Unique slim point spaSpa, based in Nairobi, Kenya, specializes in weight loss and healthy living. </p><p>They provide various services aimed at improving overall body health and wellness, including Burn Fat Solutions using EMS (Electronic Muscle Stimulation) through an electrotherapy machine, Nutrition Management, Muscle Toning, Slimming Skincare, and Body Care.</p><p> Their wellness offerings also include professional body massage, full facial treatment, body waxing, body scrubs, sauna wraps, and reflexology.</p><p>', 'about-banner.png', 'ecoways is', 'about, about us, about our products, about ', 'Our goal has always been to get the best for you .', 'FAQ', 'faq-banner.jpg', 'Fashionys.com - FAQ', '', '', 'Blog', 'blog-banner.jpg', 'Ecommerce - Blog', '', '', 'Contact Us', 'contact-banner.jpg', 'Basket Kenya', '', '', 'Photo Gallery', 'pgallery-banner.jpg', 'Ecommerce - Photo Gallery', '', '', 'Video Gallery', 'vgallery-banner.jpg', 'Ecommerce - Video Gallery', '', '');

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

--
-- Table structure for table `tbl_request`
--

CREATE TABLE `tbl_request` (
  `id` int(10) NOT NULL,
  `cust_id` int(10) NOT NULL,
  `cust_name` varchar(100) NOT NULL,
  `cust_phone` varchar(15) NOT NULL,
  `cust_email` varchar(50) NOT NULL,
  `cust_address` varchar(100) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `quantity` int(10) NOT NULL,
  `charges` int(10) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `designer` varchar(50) NOT NULL DEFAULT 'Not Assigned',
  `weaver` varchar(50) NOT NULL DEFAULT 'Not Assigned',
  `status` varchar(20) NOT NULL DEFAULT 'Pending',
  `completion_status` varchar(50) NOT NULL DEFAULT 'Pending',
  `remark` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_request_material`
--

CREATE TABLE `tbl_request_material` (
  `id` int(10) NOT NULL,
  `full_name` varchar(50) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `quantity` int(10) NOT NULL,
  `price` int(10) NOT NULL,
  `amount_paid` int(10) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `phone` varchar(15) NOT NULL,
  `transactioncode` varchar(20) NOT NULL,
  `description` varchar(500) NOT NULL,
  `supplier` varchar(20) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `payment_status` varchar(20) NOT NULL DEFAULT 'Pending',
  `comment` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_services`
--

CREATE TABLE `tbl_services` (
  `serviceid` int(11) NOT NULL,
  `servicename` varchar(100) NOT NULL,
  `pricing` int(10) NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `servicetype` varchar(500) DEFAULT 'Construction of Meter Box',
  `status` varchar(20) DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `p_featured_photo` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_services`
--

INSERT INTO `tbl_services` (`serviceid`, `servicename`, `pricing`, `description`, `servicetype`, `status`, `date`, `p_featured_photo`) VALUES
(45, 'Nutrition Management', 4500, 'We offer nutrition management services to enhance your well-being. We focus on balanced meal planning, building healthy eating habits, and mindful nutrition practices. ', 'Streess management', 'Active', '2025-11-12 10:29:42', ''),
(46, 'Slimming Skincare', 3500, 'We offer slimming skincare services to enhance your well-being. We focus on effective body contouring, building a consistent skincare routine, and mindful beauty practices. ', 'Depression management', 'Active', '2025-11-20 12:25:53', ''),
(48, 'Full facial treatment', 3500, 'We offer professional facial treatment services to relieve and rejuvenate your skin.', 'Relationship problems', 'Active', '2025-11-20 12:27:54', ''),
(51, 'Massage Services', 4500, 'We offer professional massage services to relieve stress and muscle tension.', 'Massage', 'Active', '2025-11-20 11:53:03', '');

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

--
-- Table structure for table `tbl_slider`
--

CREATE TABLE `tbl_slider` (
  `id` int(11) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `heading` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `button_text` varchar(255) NOT NULL,
  `button_url` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` (`id`, `photo`, `heading`, `content`, `button_text`, `button_url`, `position`) VALUES
(1, 'slider-1.png', 'Welcome to Ecommerce PHP', 'Shop Online for Latest Women Accessories', 'View Women Accessories', 'product-category.php?id=4&type=mid-category', 'Center'),
(2, 'slider-2.jpg', '50% Discount on All Products', 'Lorem ipsum dolor sit amet, an labores explicari qui, eu nostrum copiosae argumentum has.', 'Read More', '#', 'Center'),
(3, 'slider-3.png', '24 Hours Customer Support', 'Lorem ipsum dolor sit amet, an labores explicari qui, eu nostrum copiosae argumentum has.', 'Read More', '#', 'Right');

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

--
-- Table structure for table `tbmessages`
--

CREATE TABLE `tbmessages` (
  `id` int(11) NOT NULL,
  `user_id` int(10) NOT NULL,
  `message` varchar(500) NOT NULL,
  `sender` varchar(50) NOT NULL,
  `recepient` varchar(50) NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(11) DEFAULT NULL,
  `user` varchar(50) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

--
-- Indexes for table `tbl_country`
--
ALTER TABLE `tbl_country`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  ADD PRIMARY KEY (`faq_id`);

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

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

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

--
-- Indexes for table `tbl_services`
--
ALTER TABLE `tbl_services`
  ADD PRIMARY KEY (`serviceid`);

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

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

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

--
-- AUTO_INCREMENT for table `requests_material`
--
ALTER TABLE `requests_material`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

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

--
-- AUTO_INCREMENT for table `tbl_bookings`
--
ALTER TABLE `tbl_bookings`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=191;

--
-- AUTO_INCREMENT for table `tbl_country`
--
ALTER TABLE `tbl_country`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT for table `tbl_faq`
--
ALTER TABLE `tbl_faq`
  MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

--
-- AUTO_INCREMENT for table `tbl_request_material`
--
ALTER TABLE `tbl_request_material`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `tbl_services`
--
ALTER TABLE `tbl_services`
  MODIFY `serviceid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

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

--
-- AUTO_INCREMENT for table `tbmessages`
--
ALTER TABLE `tbmessages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;
COMMIT;

