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

START TRANSACTION;



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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `brand_id` int(255) NOT NULL,
  `brand_name` varchar(255) NOT NULL,
  `brand_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_image`) VALUES
(3, 'Brand2', 'images-4.jpeg'),
(4, 'Brand3', 'images-13.jpeg'),
(5, 'Brand7', 'images-15.jpeg'),
(8, 'NECTECH', 'images-6.jpeg'),
(9, 'GLO1', 'images-7.jpeg'),
(10, 'MTN', 'images-10.jpeg');

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

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `comment_id` int(255) NOT NULL,
  `comment_name` varchar(255) NOT NULL,
  `comment_email` varchar(255) NOT NULL,
  `comment_message` mediumtext NOT NULL,
  `comment_date` datetime(6) NOT NULL,
  `post_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`comment_id`, `comment_name`, `comment_email`, `comment_message`, `comment_date`, `post_id`) VALUES
(8, 'king', 'reter@gmail.com', 'Always do good', '2025-01-24 02:58:13.000000', 8),
(9, 'blessing', 'reter@gmail.com', 'Thank you', '2025-02-04 04:04:16.000000', 8);

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `contact_id` int(255) NOT NULL,
  `contact_name` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_number` varchar(255) NOT NULL,
  `contact_handle` varchar(255) NOT NULL,
  `contact_skills` varchar(255) NOT NULL,
  `contact_info` varchar(255) NOT NULL,
  `contact_agree` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`contact_id`, `contact_name`, `contact_email`, `contact_number`, `contact_handle`, `contact_skills`, `contact_info`, `contact_agree`) VALUES
(1, 'king', 'ioioutrt@gmail.com', 'oioo', 'mn m', 'knk', 'Radio', ''),
(2, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'Radio', ''),
(3, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'through_a_friend', ''),
(4, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'social_media', ''),
(5, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'Radio', ''),
(6, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'through_a_friend', ''),
(7, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'through_a_friend', ''),
(8, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'social_media', ''),
(9, 'kingsley wadikie', 'kingsleywadike123@gmail.com', '09023992201', 'whatsApp', 'tech skills', 'Radio', ''),
(10, 'gy', 'uytrt6r@gmail.com', 'gg', 'gg', 'y', 'Radio', ''),
(11, 'kingsley', 'uytrt6r@gmail.com', '7765445', 'gg', 'y', 'social_media', '');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_id` int(255) NOT NULL,
  `news_name` varchar(255) NOT NULL,
  `news_email` varchar(255) NOT NULL,
  `news_contact` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `news_name`, `news_email`, `news_contact`) VALUES
(1, 'er', 'r', 'ere'),
(2, 'kingsley wadkine', 'kldookkd', 'ere'),
(3, 'kingsley wadkine', 'r', 'ere');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `portfolio_id` int(255) NOT NULL,
  `portfolio_title` varchar(255) NOT NULL,
  `portfolio_service` varchar(255) NOT NULL,
  `portfolio_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`portfolio_id`, `portfolio_title`, `portfolio_service`, `portfolio_image`) VALUES
(59, 'SUPPLY OF BUILDING METERIALS', '7', 'images-18.jpeg'),
(60, 'BUILDING MAINTENANCE', '10', 'IMG-20210629-WA0088.jpg'),
(62, 'BUILDING MAINTENANCE', '10', 'IMG-20210629-WA0029.jpg'),
(64, 'INDUSTRIAL CLEANING', '12', 'images-29.jpeg'),
(65, 'INDUSTRIAL CLEANING', '12', 'images-25.jpeg'),
(66, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0019.jpg'),
(67, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0003.jpg'),
(68, 'BUILDING MAINTENANCE', '10', 'IMG-20210629-WA0074.jpg'),
(69, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0041.jpg'),
(70, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0006.jpg'),
(71, 'INDUSTRIAL CLEANING', '12', 'images-30.jpeg'),
(72, 'SUPPLY OF BUILDING METERIALS', '7', 'images-15.jpeg'),
(73, 'BUILDING MAINTENANCE', '10', 'IMG-20210630-WA0004.jpg'),
(74, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0075.jpg'),
(75, 'FURNITURE MANUFACTURING', '11', 'IMG-20210629-WA0010.jpg');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` int(255) NOT NULL,
  `post_title` varchar(255) NOT NULL,
  `post_author` varchar(255) NOT NULL,
  `post_body` longtext NOT NULL,
  `post_date` datetime(6) NOT NULL,
  `post_category` varchar(255) NOT NULL,
  `post_image` varchar(255) NOT NULL,
  `admin_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `post_title`, `post_author`, `post_body`, `post_date`, `post_category`, `post_image`, `admin_id`) VALUES
(1, 'Lonny Estate Luxury Duplex ', 'king lords', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Calabar Landed Properties', 'post-1.jpg', 1),
(2, 'Benson Estate Standard Duplex ', 'sunny prince', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Lagos Landed Properties ', 'post-2.jpg', 1),
(3, 'Losey Queen Estate', 'king lords', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Calabar Landed Properties', 'images-13.jpeg', 1),
(4, 'Airico Estate Duplex', 'sunny prince', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Lagos Landed Properties ', 'images-9.jpeg', 1),
(5, 'Fortune Estate ', 'divine john ', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Abuja Landed Proprieties  ', 'images-8.jpeg', 1),
(6, 'Okaywalie Estate Mansion ', 'praise milky ', 'Architectural phenomenology is a movement within architecture that began in the 1950s, reaching a wide audience in the late 1970s and 1980s, and continuing until today. Architectural phenomenology focuses on human experience, background, intention and historical reflection, interpretation as well as poetic and ethical considerations with authors such as Gaston Bachelard.[21]\r\n\r\nIslamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.', '2025-01-03 00:00:00.000000', 'Port Harcourt Landed Properties ', 'computer tutor.jpg', 1),
(7, 'Kingsley', 'King ', 'A well situated property located in the heart of a vibrant city.', '2025-01-24 00:00:00.000000', 'Calabar Landed Properties', 'images-3.jpeg', 1),
(8, 'school fees', 'Godwin', 'Islamic architecture began in the 7th century CE, incorporating architectural forms from the ancient Middle East and Byzantium, but also developing features to suit the religious and social needs of the society. Examples can be found throughout the Middle East, North Africa, Spain and the Indian Sub-continent.\r\n\r\nAliquam eget tellus sed dolor accumsan imperdiet.\r\n Nunc interdum arcu vel massa faucibus imperdiet.\r\n Vestibulum sollicitudin odio nec faucibus venenatis.\r\n Etiam iaculis nunc et iaculis sodales.', '2025-01-24 00:00:00.000000', 'Port Harcourt Landed Properties ', '2-4.jpg', 1);

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

--
-- Table structure for table `post_catatogory`
--

CREATE TABLE `post_catatogory` (
  `category_id` int(255) NOT NULL,
  `category_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post_catatogory`
--

INSERT INTO `post_catatogory` (`category_id`, `category_title`) VALUES
(3, 'Abuja Landed Proprieties  '),
(4, 'Port Harcourt Landed Properties '),
(5, 'Lagos Landed Properties '),
(6, 'Calabar Landed Properties');

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

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `question_id` int(255) NOT NULL,
  `question_title` varchar(255) NOT NULL,
  `question_email` varchar(255) NOT NULL,
  `question_number` varchar(255) NOT NULL,
  `question_subject` varchar(255) NOT NULL,
  `question_message` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `request_id` int(255) NOT NULL,
  `request_name` varchar(255) NOT NULL,
  `request_number` varchar(255) NOT NULL,
  `request_options` varchar(255) NOT NULL,
  `request_message` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quote`
--

INSERT INTO `quote` (`request_id`, `request_name`, `request_number`, `request_options`, `request_message`) VALUES
(1, 'Henry Peterside', '07034445228', 'FURNITURE MANUFACTURING', 'Request for any kind of service here via this form and our dedicated staff will get it done for u.');

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

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

CREATE TABLE `services` (
  `service_id` int(255) NOT NULL,
  `service_title` varchar(255) NOT NULL,
  `service_details` longtext NOT NULL,
  `service_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `services` (`service_id`, `service_title`, `service_details`, `service_image`) VALUES
(7, 'Supply Of Building Meterials', 'Building material, are material used for construction. Many naturally occurring substances, such as clay, rocks, sand and wood, even twigs and leaves, have been used to construct buildings. Apart from naturally occurring materials, many man-made products are in use, some more and some less synthetic. The manufacturing of building materials is an established industry in many countries and the use of these materials is typically segmented into specific specialty trades, such as carpentry, insulation, plumbing, and roofing work. They provide the make-up of habitats and structures including homes.\r\n\r\nIn history there are trends in building materials from being natural to becoming more man-made and composite; biodegradable to imperishable; indigenous (local) to being transported globally; repairable to disposable; chosen for increased levels of fire-safety, and improved seismic resistance.. These trends tend to increase the initial and long term economic, ecological, energy, and social costs of building materials.\r\n\r\nECONOMIC COST \r\nInitial economic cost of building materials is the purchase price. This is often what governs decision making about what materials to use. Sometimes people take into consideration the energy savings or durability of the materials and see the value of paying a higher initial cost in return for a lower lifetime cost. For example, an asphalt shingle roof costs less than a metal roof to install, but the metal roof will last longer so the lifetime cost is less per year. Some materials may require more care than others, maintaining costs specific to some materials may also influence the final decision. Risks when considering lifetime cost of a material is if the building is damaged such as by fire or wind, or if the material is not as durable as advertised. The cost of materials should be taken into consideration to bear the risk to buy combustive materials to enlarge the lifetime. It is said that, \"if it must be done, it must be done well\r\n\r\n\r\nECOLOGICAL COST\r\nPollution costs can be macro and micro. The macro, environmental pollution of extraction industries building materials rely on such as mining, petroleum, and logging produce environmental damage at their source and in transportation of the raw materials, manufacturing, transportation of the products, retailing, and installation. An example of the micro aspect of pollution is the off-gassing of the building materials in the building or indoor air pollution. Red List building materials are materials found to be harmful. Also the carbon footprint, the total set of greenhouse gas emissions produced in the life of the material. A life-cycle analysis also includes the reuse, recycling, or disposal of construction waste. Two concepts in building which account for the ecological economics of building materials are green building and sustainable development\r\n\r\nENERGY COST\r\nthe Initial energy costs include the amount of energy consumed to produce, deliver and install the material. The long term energy cost is the economic, ecological, and social costs of continuing to produce and deliver energy to the building for its use, maintenance, and eventual removal. The initial embodied energy of a structure is the energy consumed to extract, manufacture, deliver, install, the materials. The lifetime embodied energy continues to grow with the use, maintenance, and reuse/recycling/disposal of the building materials themselves and how the materials and design help minimize the life-time energy consumption of the structure\"\"\"\"\"', 'images-17.jpeg'),
(9, 'Road Rehabilitation ', ' In industrialized countries, everyone is talking about the dire need to invest and modernize the existing infrastructure. This mainly involves road rehabilitation, but also extending and upgrading the existing road network. Roads are exposed to tremendous loads that will sooner or later leave their marks on them. A time will come when every road will be in need of a general overhaul. But no two damage patterns are alike. Which rehabilitation methods offer a cure for distressed roads? What are the differences between them? Which are suitable to be carried out as mobile roadworks\"\"\"', 'images-56.jpeg'),
(10, 'Building Maintenance', 'Building owners consider the planned maintenance as a matter of serious apprehension, and yet building owner cannot afford to tolerate their buildings to perish over a period of time. As it is undoubtedly unfeasible, and even detrimental to restore all the older buildings, everybody apprehensive with those buildings, whether as the owners, builders or the end users, ought to take a serious attention in this infinite dilemma of building. Now and then, they have a certain amount of budget to handle or cover this problem and only waiting for the liable person .\r\nBuilding maintenance progression was on reservation and restoration commotion for the building of structural and components. Building maintenance envelops every part of buildings, for example, rooms, toilet windows, wall and their furniture. Building maintenance is a worldwide problem and extremely measured for the untimely route of construction that the superiority of the building can be guaranteed . Maintenance also can be referred as an operation that being done on a continuous basis to maintain the building in a safe and the best form for the everyday use. Maintenance activities cover all the building like from the top to the bottom of particular building. This commotion will identify all part of it in order to ensure that it could be used either on the structural, components and the materials holistically .\r\n\r\nTYPES OF MAINTENANCE:\r\nAs been presented earlier, maintenance can be categorized into two groups: unplanned and planned maintenance. For planned maintenance that work that have a scheduled and carried out, i.e. daily cleaning of floor, weekly for cleaning the window and a year to check the painting of the building . Whereas for the unplanned maintenance where the work is carried out on emergency basis or when having problem in that building, for example, when lift is having problems, so maintenance needs at that particular time. There are three types of maintenance which are; corrective maintenance, preventive maintenance, and condition-based maintenance. The types of maintenance include the service maintenance that maintenance items demanded by the renter or the occupant. It also includes some emergency items. Next is what we called as a routine maintenance that includes broad or general types of maintenance to the common areas. These particular aspects are not requested by the tenant, but it is necessary in order to keep the building in excellent state.\r\n\r\nCORRECTIVE MAINTENANCE :\r\nCorrective Maintenance Corrective maintenance is the maintenance carried out subsequent to the breakdown that has occurred and projected to reinstate an item to a state in which it can execute its necessitated purpose. Whereas, preventive maintenance is maintenance that carried at prearranged period of time and anticipated to diminish the possibility of malfunction or the performance dilapidation of any particular item. Condition-based maintenance is defined as preventive maintenance commenced as a result of knowledge of the condition of an item from the schedule or incessant monitoring . It should be pointed out that corrective maintenance is the simplest types of maintenance approach, where building components are utilized until its breakdown. It covers all actions, which include repair of an element that has failed to a point at which it cannot execute its essential purpose. Hence, corrective maintenance can be tremendously costly because the breakdown or failure of a particular item can cause a great amount of significant damage to other elements in the building. For examples, failure of the roof might cause harm to the ceiling and the interior part of the building and the failure of an item can take place at a time which is not convenient to equally the user and the maintenance personnel. This could formulate manpower and spare parts planning exceptionally complicated.\r\n\r\nPREVENTIVE MAINTENANCE:\r\nOn the other hand, the preventive maintenance is established to surmount the disadvantages of corrective maintenance, by reducing the likelihood of the incidence of malfunction and avoiding unexpected failure. Preventive maintenance task is done in agreement with a prearranged plan at regular, fixed intervals, which may be based for example on an operating time. There are some advantages of preventive maintenance in excess of corrective maintenance such as the maintenance could be intended in advance and executed when it is expedient to the building’s user, the cost could be diminished by avoiding the cost of significant damage, the point in time that a component of the building or the entire building is out of service, can be diminished, the health and safety of the user can be improve and the planned maintenance task are frequently very challenging in terms of spare parts and the labour cost.\r\n.', 'images-4.jpeg'),
(11, 'Furniture Manufacturing', 'Furniture refers to movable objects intended to support various human activities such as seating (e.g., chairs, stools, and sofas), eating (tables), and sleeping (e.g., beds). Furniture is also used to hold objects at a convenient height for work (as horizontal surfaces above the ground, such as tables and desks), or to store things (e.g., cupboards and shelves). Furniture can be a product of design and is considered a form of decorative art. In addition to furniture\'s functional role, it can serve a symbolic or religious purpose. It can be made from many materials, including metal, plastic, and wood. Furniture can be made using a variety of woodworking joints which often reflect the local culture.\r\n\r\nPeople have been using natural objects, such as tree stumps, rocks and moss, as furniture since the beginning of human civilization. Archaeological research shows that from around 30,000 years ago, people started to construct and carve their own furniture, using wood, stone, and animal bones. Early furniture from this period is known from artwork such as a Venus figurine found in Russia, depicting the goddess on a throne. The first surviving extant furniture is in the homes of Skara Brae in Scotland, and includes cupboards, dressers and beds all constructed from stone. Complex construction techniques such as joinery began in the early dynastic period of ancient Egypt. This era saw constructed wooden pieces, including stools and tables, sometimes decorated with valuable metals.\r\n\r\nThe evolution of furniture design continued in ancient Greece and ancient Rome, with thrones being commonplace as well as the klinai, multipurpose couches used for relaxing, eating, and sleeping. The furniture of the Middle Ages was usually heavy, oak, and ornamented. Furniture design expanded during the Italian Renaissance of the fourteenth and fifteenth century. The seventeenth century, in both Southern and Northern Europe, was characterized by opulent, often gilded Baroque designs. The nineteenth century is usually defined by revival styles. The first three-quarters of the twentieth century are often seen as the march towards Modernism. One unique outgrowth of post-modern furniture design is a return to natural shapes and textures.\r\n\r\nThe practice of using natural objects as rudimentary pieces of furniture likely dates to the beginning of human civilization. Early humans are likely to have used tree stumps as seats, rocks as rudimentary tables, and mossy areas for sleeping. During the late palaeolithic or early neolithic period, from around 30,000 years ago, people began constructing and carving their own furniture, using wood, stone and animal bones. The earliest evidence for the existence of constructed furniture is a Venus figurine found at the Gagarino site in Russia, which depicts the goddess in a sitting position, on a throne. A similar statue of a seated woman was found in Catal Huyuk in Turkey, dating to between 6000 and 5500 BCE.The inclusion of such a seat in the figurines implies that these were already common artefacts of that age.\r\n\r\nA range of unique stone furniture has been excavated in Skara Brae, a Neolithic village in Orkney, Scotland The site dates from 3100 to 2500 BCE and due to a shortage of wood in Orkney, the people of Skara Brae were forced to build with stone, a readily available material that could be worked easily and turned into items for use within the household. Each house shows a high degree of sophistication and was equipped with an extensive assortment of stone furniture, ranging from cupboards, dressers, and beds to shelves, stone seats, and limpet tanks. The stone dresser was regarded as the most important as it symbolically faces the entrance in each house and is therefore the first item seen when entering, perhaps displaying symbolic objects, including decorative artwork such as several Neolithic carved stone balls also found at the site.\r\n', 'images-13.jpeg'),
(12, 'House / Industrial Cleaning ', 'Simply stated, industrial cleaning is the act of cleaning hazardous areas in industrial facilities such as factories, warehouses, power plants and other types of industrial facilities. There is no simpler way to describe the job of cleaning factories, generating plants, or other industrial job sites, as there is such a variety in the different facilities that a building service contractor may come across. The industrial cleaning contractor may be contracted to clean large facilities, like factories, plants, warehouses, and various other industrial settings. A position like this requires that you get on the job training, and learn all about safety knowledge. There might be special equipment for an industrial cleaner to ware, or specific chemicals to use in doing their jobs.\r\n\r\nThe job of an industrial cleaner is dirty work. Maintaining the offices of industrial sites is very demanding as well, for there is dirt being constantly tracked in from the outside areas of the factory floors. Then you have the challenges of working around the heavy machinery and the safety risks that are involved, such as paints, lubricants, metal shavings, and fiberglass. There is also some machinery that is sensitive to things like dust and dirt, and cleaning them will be essential. Another big concern when cleaning industrial sites is the staffing areas. For instance, employees that do the industries cleaning will need to be in good health and in condition to perform the duties required. Industrial cleaners also need to be concerned with effective communication.', 'images-27.jpeg');

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

--
-- Table structure for table `signup`
--

CREATE TABLE `signup` (
  `signup_id` int(255) NOT NULL,
  `signup_name` varchar(255) NOT NULL,
  `signup_email` varchar(255) NOT NULL,
  `signup_contact` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `signup`
--

INSERT INTO `signup` (`signup_id`, `signup_name`, `signup_email`, `signup_contact`) VALUES
(1, 'Dum-Igoni Kingsley', 'qwerty', 's'),
(2, 'Dum-Igoni Kingsley', 'qwerty', 's'),
(3, 'Dum-Igoni Kingsley', 'qwerty', 's');

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

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `team_id` int(255) NOT NULL,
  `team_name` varchar(255) NOT NULL,
  `team_position` varchar(255) NOT NULL,
  `team_details` longtext NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`team_id`, `team_name`, `team_position`, `team_details`, `image`) VALUES
(2, 'PATIENCE JOSEPH', 'SECRETARY', 'hard working secretary', 'images-1.jpeg'),
(3, 'LENEBARI MORRISON', 'ARCHITECT', 'a very creative architect \"', 'boss.jpg'),
(4, ' NWIDOH D ROWLAND', 'MANAGER', '\"', 'IMG-20210713-WA0001.jpg'),
(6, 'NWI-UE P GODAE', 'PROJECT MANAGER', '\"', 'IMG-20210713-WA0003.jpg'),
(7, 'BOMA EMMAUEL J', 'CIVIL ENGINEER / ARCHITECT', '', 'images-74.jpeg'),
(8, 'KARALOLO GODWIN', 'SITE ENGINEER', '', 'images-76.jpeg');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `testimonial_id` int(255) NOT NULL,
  `testimonial_name` varchar(255) NOT NULL,
  `testimonial_location` varchar(255) NOT NULL,
  `testimonial_details` longtext NOT NULL,
  `testimonial_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`testimonial_id`, `testimonial_name`, `testimonial_location`, `testimonial_details`, `testimonial_image`) VALUES
(16, 'JOY  Mark', 'ABUJA', 'They where never a dull moment with  Royal-Tech Planning & Enviromental Konsult, they came early in the morning and worked straight through until its night. Clean up was excellent you would never know they had been here. They are certainly highly recommended for all.\r\n', 'images-80.jpeg'),
(17, 'PETER OKOYE', 'ABUJA', 'Company very professional, when we met and got the offer them, it wasn’t the cheapest but they were the most professional.', 'images-78.jpeg'),
(18, 'REGINA GEORGE', 'LAGOS', 'Royal-Tech Planning &Enviromental Konsult was referred to me by a good friend of mine. I am glad I went with them - the team was professional and courteous throughout the process. They did an amazing job.', 'download-7.jpeg'),
(19, 'BENSON JOHN', 'PORT-HARCOURT', 'Very quick with great team response, easy estimation time, Stands behind works Royal-Tech Planning &Enviromental Konsult are simply the best among', 'images-76.jpeg'),
(20, 'JOSEPH CELESSTINE', 'ABUJA', ' Royal-Tech Planning &Enviromental Konsult did an amazing job. Very fast and efficient! Answered all of our questions and there was never any hassle. Built a new roof that was better than the old and we have had no more leaks at all and we have had a lot of storms. Very professional!! I would recommend them to anyone!!\r\n', 'images-74.jpeg'),
(21, 'NONSO CHIKA', 'LAGOS', 'Great service during pre and post sale process.. Royal-Tech Planning &Enviromental Konsult did an excellent job of replacing my roof and gutters. Job was done fast and with excellent quality. Royal-Tech Planning &Enviromental Konsult took care of the working area after everything was completed. I definitely will use their service again', 'images-66.jpeg');

--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
  ADD PRIMARY KEY (`brand_id`);

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`contact_id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`news_id`);

--
-- Indexes for table `portfolio`
--
ALTER TABLE `portfolio`
  ADD PRIMARY KEY (`portfolio_id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

--
-- Indexes for table `post_catatogory`
--
ALTER TABLE `post_catatogory`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `question`
--
ALTER TABLE `question`
  ADD PRIMARY KEY (`question_id`);

--
-- Indexes for table `quote`
--
ALTER TABLE `quote`
  ADD PRIMARY KEY (`request_id`);

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

--
-- Indexes for table `signup`
--
ALTER TABLE `signup`
  ADD PRIMARY KEY (`signup_id`);

--
-- Indexes for table `team`
--
ALTER TABLE `team`
  ADD PRIMARY KEY (`team_id`);

--
-- Indexes for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD PRIMARY KEY (`testimonial_id`);

--
-- AUTO_INCREMENT for table `brand`
--
ALTER TABLE `brand`
  MODIFY `brand_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `comment_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `contact_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `news_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `portfolio_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `post_catatogory`
--
ALTER TABLE `post_catatogory`
  MODIFY `category_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `service_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `signup`
--
ALTER TABLE `signup`
  MODIFY `signup_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `team`
--
ALTER TABLE `team`
  MODIFY `team_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

