AutoShell

jkghkghkghkghkghkghkghkkghghkkghkgh hgghkghkghghkghhgkhgkghghkkghkhghkgkghkghkgh hjlhlhjhjlhjlhjlhjlhjlhjlhjhjl AutoShell

?? Editing: trymywebsites_rsanjanaconstructiondb.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Sep 30, 2024 at 11:00 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `trymywebsites_rsanjanaconstructiondb`
--

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

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

CREATE TABLE `admin` (
  `id` int(10) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', 'admin@123');

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

--
-- Table structure for table `areacategory`
--

CREATE TABLE `areacategory` (
  `id` int(50) NOT NULL,
  `categoryname` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `areacategory`
--

INSERT INTO `areacategory` (`id`, `categoryname`) VALUES
(1, 'Coimbatore');

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

--
-- Table structure for table `areaproject`
--

CREATE TABLE `areaproject` (
  `id` int(50) NOT NULL,
  `productcategory` varchar(500) NOT NULL,
  `productname` varchar(500) NOT NULL,
  `productimage` varchar(50) NOT NULL,
  `description` longtext NOT NULL,
  `description2` longtext NOT NULL,
  `image2` varchar(500) NOT NULL,
  `image3` varchar(500) NOT NULL,
  `image4` varchar(500) NOT NULL,
  `image5` varchar(500) NOT NULL,
  `projectname` varchar(500) NOT NULL,
  `location` varchar(500) NOT NULL,
  `type` varchar(500) NOT NULL,
  `size` varchar(500) NOT NULL,
  `cost` varchar(500) NOT NULL,
  `duration` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `areaproject`
--

INSERT INTO `areaproject` (`id`, `productcategory`, `productname`, `productimage`, `description`, `description2`, `image2`, `image3`, `image4`, `image5`, `projectname`, `location`, `type`, `size`, `cost`, `duration`) VALUES
(1, 'Coimbatore', 'Urbanite Developments', 'product/portfolio-01.jpg', 'Riverside Retreat is a prestigious residential development nestled along the banks of the picturesque river in Dubai. This exclusive project offers a serene and luxurious living experience, combining breathtaking natural surroundings with meticulous design and top-of-the-line amenities. Designed for those seeking a harmonious blend of comfort, style, and nature, Riverside Retreat boasts a collection of beautifully crafted residences. Each home is thoughtfully designed to maximize the stunning river views and create a seamless connection between indoor and outdoor living spaces. Residents of Riverside Retreat will enjoy a host of resort-style amenities, including a riverside pool with a sundeck, a fully equipped fitness center, private gardens, and a stylish clubhouse.', 'Environmental Considerations Being situated along the river, environmental regulations and potential impact on the surrounding ecosystem need to be carefully addressed during construction to ensure sustainable development. \r\n\r\n\r\nPermitting and Regulatory Compliance Navigating the necessary permits and approvals from local authorities and regulatory bodies can pose challenges and require coordination to ensure compliance with all relevant regulations. \r\n										\r\nWeather and Seasonal Constraints Adverse weather conditions, such as heavy rains or extreme temperatures, can affect construction progress and require careful scheduling and contingency plans to mitigate delays. \r\n\r\nRiverbank Stabilization Given the proximity to the river, ensuring proper riverbank stabilization measures and flood mitigation strategies may be necessary to protect the project and ensure long-term durability.\r\n																																	', 'product/portfolio-single-02.jpg', 'product/portfolio-single-03.jpg', 'product/portfolio-single-04.jpg', 'product/portfolio-single-05.jpg', ' Uptown Residences', ' Thailand', ' Commercial', ' 160,000 sq. ft.', ' $715 Million', ' 21 Months');

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

--
-- Table structure for table `areavideo`
--

CREATE TABLE `areavideo` (
  `id` int(50) NOT NULL,
  `video_url` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `areavideo`
--

INSERT INTO `areavideo` (`id`, `video_url`) VALUES
(4, 'video-66fa43f04e3d16.23341395.mp4');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(20) NOT NULL,
  `productcategory` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `productcategory`) VALUES
(1, 'cold room'),
(2, 'cold storage'),
(4, 'air conditioner');

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

--
-- Table structure for table `coldroom`
--

CREATE TABLE `coldroom` (
  `id` int(50) NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coldroom`
--

INSERT INTO `coldroom` (`id`, `image`) VALUES
(1, 'product/why_choose_us_3.jpg'),
(2, 'product/why_choose_us_4.jpg'),
(3, 'product/why_choose_us_1.jpg'),
(4, 'product/why_choose_us_2.jpg'),
(5, 'product/service_single1.jpg'),
(6, 'product/service_single2.jpg'),
(7, 'product/why_choose_us_7.jpg'),
(8, 'product/why_choose_us_8.jpg'),
(10, 'product/why_choose_us_4.jpg'),
(11, 'product/why_choose_us_1.jpg'),
(12, 'product/why_choose_us_7.jpg'),
(13, 'product/page_gallery_16.jpg'),
(14, 'product/multi.jpg'),
(15, 'product/sketch.jpg'),
(16, 'product/swing.jpg'),
(17, 'product/ciling.jpg'),
(18, 'product/wall.jpg'),
(19, 'product/evoprator.jpg'),
(20, 'product/coldroom2.jpg');

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

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

CREATE TABLE `gallery` (
  `id` int(50) NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `gallery` (`id`, `image`) VALUES
(24, 'product/1.jpg'),
(25, 'product/gallery2.jpg'),
(26, 'product/2.jpg'),
(27, 'product/about.jpg'),
(29, 'product/gallery1.jpg'),
(30, 'product/gallery3.jpg'),
(31, 'product/gallery9.jpg'),
(34, 'product/gallery3.jpg');

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

--
-- Table structure for table `productdetails`
--

CREATE TABLE `productdetails` (
  `id` int(10) NOT NULL,
  `productcategory` varchar(500) NOT NULL,
  `productname` longtext NOT NULL,
  `productimage` varchar(50) NOT NULL,
  `description` longtext NOT NULL,
  `description2` longtext NOT NULL,
  `description3` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `productdetails`
--

INSERT INTO `productdetails` (`id`, `productcategory`, `productname`, `productimage`, `description`, `description2`, `description3`) VALUES
(1, 'cold room', 'Ultra Cool Engineers is a leading manufacturer and supplier of highly efficient Cold Room and Storage that is easy to operate and better in performance. This tailor-made product range is built with premium quality range of material in standard size and customized specification to fulfil our customer needs. These Cold Rooms are well insulated, highly efficient and precisely designed to cater to wide temperature range from +15oC to -400 C.', 'product/AU.jpg', '◈ High cooling with low power consumption \r\n◈ Designed for high ambient condition up to 550 C \r\n◈ Condensing coil with inner grooved copper tubes & aluminum fins \r\n ◈ Efficient fans with external motors for single phase and three phase \r\n◈ High- & low-pressure cut-out including mounting brackets, wired to terminal strip \r\n◈ Large size filter drier, moisture indicator, solenoid valve, oil separator and accumulator \r\n◈ Shell & tube type condenser with high cooling capacity for high ambient conditions\r\n\r\n \r\n\r\n◈ It has advanced power saving system compared to normal refrigeration system \r\n\r\n \r\n◈ Rack system will work as per product load variation', '◈ Fan – High reliability, low-temperature resistance and low noise external rotor fans ◈ Coil – High efficiency heat exchange with in-line tube system for minimum loss of air flow between fans and large surface area for better cooling ◈ Defrost – Electrically heating stainless steel pipe is used for long life and is also leak proof ◈ Unit Body – Aluminum, PU type Powder Coated, Corrosion resistant and nice appearance body.◈ High efficiency heat exchanger with in-line tube system for minimum loss of air flow between fins and with large surface area for long cooling time. ◈ Fan Motor and Heater wires are connected in terminal box mounted inside the unit ◈ Fan Motors are of leading brand. Insulation Class F, thermally protected against overload and can be used on 230V/50 Hz supplies ◈ Provision given for installing tray heater later ◈ Stainless steel mounting rail ◈ Compact, adjustable & easily openable side panels for easy installation ◈ Heater rods are arranged for better heat distribution in coil. Electric heater rods are inserted into special aluminum sleeve tubes to avoid steam formation ◈ Drainage Connection', 'Our portable dehumidifier provides low humidity conditions necessary to maintain a dry environment. It’s a simple solution to an old problem. Our Dehumidifier works by forcing condensation on cold surfaces. Humid air is drawn over cooled fins that makes moisture condense on the large cool surface. The condensate is allowed to drain from the fins into a collection tank or is piped to a suitable drainage. Cooled dry air passes through condenser coil and again heated to desired temperature to maintain low relative humidity. Large cool surface.◈ Temperature Controls ◈ Phase Preventing ◈ HP-LP Protection ◈ Delay timer'),
(3, 'Cold Storage', 'eeeeeeeeee', 'product/about1.jpg', 'Cold storage refers to the preservation of perishable goods in a temperature-controlled environment. It is crucial in various industries such as agriculture, food processing, pharmaceuticals, and logistics. The primary goal of cold storage is to extend the shelf life of products and maintain their quality by slowing down the deterioration process caused by bacteria and enzymatic activity.', 'Specific Products That Require Cold Storage', '◈ Foods like fresh produce, meat and seafood, dairy, processed foods, and frozen foods \r\n◈ Nutritional supplements like perishable nutrient products \r\n\r\n◈ Botanicals such as flowers and plants ◈ Bio-pharmaceuticals like medicines, vaccines, blood samples, IVs, and certain dental materials \r\n\r\n◈ Books and artwork like historical documents, paintings, and film canisters \r\n◈ Craft goods like candles (as they can lose their shape or color or melt if kept in high heat) \r\n◈ Cosmetics such as lipstick and cologne \r\n◈ Chemicals like reagents and disinfectants (these require cold storage to slow down their chemical reactions) \r\n ◈ Organic textiles including fur, wool, and hides ◈ Specialized products like aircraft components'),
(4, 'Air Conditioner', 'eeeeeeeeee', 'product/ff.jpg', 'An air conditioner is a device that helps regulate the temperature, humidity, and quality of air in a space such as your home. It cools down hot indoor air by removing heat and transferring it outside while sending excess moisture down the drain. Air conditioners come in central or split-system, window unit, or ductless varieties. ', 'A central air conditioner usually has two components: an outdoor condenser/compressor unit and an indoor evaporator coil. The indoor and outdoor units work together to cool and dehumidify the air in your home to keep you comfortable. While a central ducted split-system cools your entire home, ductless-mini splits are smaller and do not have ductwork throughout the home. They are designed to cool just one room or one area of your home. Window units are single pieces of equipment that fit in a window or wall opening and are perfect for cooling one room.\r\n\r\n\r\nAir conditioners provide many benefits including improved indoor air quality and better sleep in hot summer months. They help reduce allergens like dust particles, pet hair/dander, mold spores and other airborne contaminants that can aggravate asthma or trigger allergies. Plus they remove excess moisture which helps prevent humidity-related problems such as mold growth or musty odors.', '◈ Individual rooms \r\n◈ Offices \r\n◈ Shops \r\n◈ Cafés \r\n◈ Server rooms\r\n\r\n \r\nAir conditioners provide many benefits including improved indoor air quality and better sleep in hot summer months. They help reduce allergens like dust particles, pet hair/dander, mold spores and other airborne contaminants that can aggravate asthma or trigger allergies. Plus they remove excess moisture which helps prevent humidity-related problems such as mold growth or musty odors.');

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

--
-- Table structure for table `projectimage`
--

CREATE TABLE `projectimage` (
  `id` int(50) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projectimage`
--

INSERT INTO `projectimage` (`id`, `image`) VALUES
(44, 'product/service1.jpg'),
(45, 'product/service2.jpg'),
(46, 'product/service3.jpg'),
(47, 'product/service4.jpg'),
(48, 'product/service5.jpg'),
(49, 'product/service6.jpg'),
(50, 'product/service7.jpg'),
(51, 'product/service8.jpg'),
(52, 'product/service9.jpg'),
(53, 'product/service10.jpg'),
(54, 'product/service11.jpg'),
(55, 'product/service12.jpg'),
(56, 'product/service13.jpg'),
(57, 'product/service13.jpg'),
(58, 'product/service15.jpg'),
(59, 'product/service16.jpg'),
(60, 'product/service17.jpg'),
(61, 'product/service18.jpg'),
(62, 'product/service19.jpg'),
(63, 'product/service20.jpg'),
(64, 'product/service21.jpg'),
(65, 'product/service22.jpg'),
(66, 'product/service23.jpg'),
(67, 'product/service24.jpg'),
(68, 'product/service25.jpg'),
(69, 'product/service26.jpg'),
(70, 'product/service27.jpg'),
(71, 'product/service28.jpg'),
(72, 'product/service29.jpg'),
(73, 'product/service30.jpg'),
(74, 'product/service31.jpg'),
(75, 'product/service32.jpg'),
(76, 'product/service33.jpg'),
(77, 'product/service34.jpg'),
(78, 'product/service35.jpg'),
(79, 'product/service36.jpg');

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int(50) NOT NULL,
  `video_url` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`id`, `video_url`) VALUES
(6, 'video-66faa2882c7d46.36365859.mp4');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `areaproject`
--
ALTER TABLE `areaproject`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

--
-- AUTO_INCREMENT for table `coldroom`
--
ALTER TABLE `coldroom`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

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

--
-- AUTO_INCREMENT for table `projectimage`
--
ALTER TABLE `projectimage`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Path:

home / dhw4kgxay284 / public_html / rsanjanavaluehomes.com / database /

?? Editing: trymywebsites_rsanjanaconstructiondb.sql

Path:

?? Upload