Da

✏️ Editing: welcomepholtel.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: welcomepholtel
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `welcomepholtel`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `welcomepholtel` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `welcomepholtel`;

--
-- Table structure for table `about`
--

DROP TABLE IF EXISTS `about`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `about` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `about_header` varchar(100) NOT NULL,
  `about_column1` text NOT NULL,
  `about_column2` text NOT NULL,
  `about_column3` text NOT NULL,
  `img_about` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `about`
--

LOCK TABLES `about` WRITE;
/*!40000 ALTER TABLE `about` DISABLE KEYS */;
INSERT INTO `about` VALUES (1,'Welcome Plaza Hotel Pattaya','																																																																																																																																								                         Welcome Plaza Hotel Pattaya have 230 room which located ideally in the city center within walking distance to Pattaya’s major sights. it features a large outdoor pool. free wifi is available in all the rooms. Every paid guest will receive complimentary breakfast buffet between 6:00am till 10:00am..																																																																																																																				','																																																																																											                        \n  Simply furnished and decorated in warm earth tones, the rooms all have satellite tv, a refrigerator and their own individually controlled air conditioning. it also features a private balcony with views of the city or pool. the private bathroom all have a hot shower, towels and free toiletries. at welcome plaza Pattaya, guests will find a helpful 24-hour front desk that can give information with car rentals, sightseeing tours, bus station and more. Private parking space is available at the hotel for our guest.\n\nthe property is only a 9-minute walk(700 m) from the lively walking street Pattaya. Pattaya beach is 300m away from hotel. For shopping and more dining options, guests can head over to royal garden, the avenue Pattaya and central festival Pattaya beach which are both located within 0.9 mi. other beachfront bars, restaurants, convenience stores and pharmacies can all be found within a short walk.									\n							\n								\n										\n										\n													\n													\n						','','about1685947089.jpg');
/*!40000 ALTER TABLE `about` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attractions`
--

DROP TABLE IF EXISTS `attractions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attractions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `header` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attractions`
--

LOCK TABLES `attractions` WRITE;
/*!40000 ALTER TABLE `attractions` DISABLE KEYS */;
INSERT INTO `attractions` VALUES (1,'Attractions','Explore Top Attractions','Attractions'),(2,'Amenity','','Amenity');
/*!40000 ALTER TABLE `attractions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attractions_img`
--

DROP TABLE IF EXISTS `attractions_img`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attractions_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(110) NOT NULL,
  `attra_img` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attractions_img`
--

LOCK TABLES `attractions_img` WRITE;
/*!40000 ALTER TABLE `attractions_img` DISABLE KEYS */;
INSERT INTO `attractions_img` VALUES (15,'Pattaya beach','attra1686295382.jpg',1),(16,'Walking street','attra1686295405.jpg',1),(17,'Royal garden','attra1686295455.jpg',1),(18,'Major cineplex Avenue Pattaya','attra1686295483.jpg',1),(19,'CentralPattay','attra1686295510.jpg',1),(20,'Wat Yansangwararam','attra1686295544.jpg',1);
/*!40000 ALTER TABLE `attractions_img` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_us`
--

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact_us` (
  `cont_id` int(11) NOT NULL AUTO_INCREMENT,
  `cont_address` varchar(110) NOT NULL,
  `cont_phone` varchar(100) NOT NULL,
  `cont_email` varchar(110) NOT NULL,
  `cont_phones` varchar(100) NOT NULL,
  `cont_map` varchar(100) NOT NULL,
  PRIMARY KEY (`cont_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_us`
--

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
INSERT INTO `contact_us` VALUES (1,'213 pattaya 2nd road moo 10 banglamung Chonburi, Thailand  20150','083-536-6955','welcomeplazapattaya@gmail.com','083-536-6955, 082-595-2956, 038-424766 ','');
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `home_room_img`
--

DROP TABLE IF EXISTS `home_room_img`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `home_room_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `img_name` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home_room_img`
--

LOCK TABLES `home_room_img` WRITE;
/*!40000 ALTER TABLE `home_room_img` DISABLE KEYS */;
/*!40000 ALTER TABLE `home_room_img` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `home_row_1`
--

DROP TABLE IF EXISTS `home_row_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `home_row_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `header` varchar(100) NOT NULL,
  `column1` text NOT NULL,
  `img_home` varchar(100) NOT NULL,
  `desc` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home_row_1`
--

LOCK TABLES `home_row_1` WRITE;
/*!40000 ALTER TABLE `home_row_1` DISABLE KEYS */;
INSERT INTO `home_row_1` VALUES (1,'row1','Welcome Plaza Hotel','																																																																																										Welcome Plaza Hotel Pattaya have 230 room which located ideally in the city center within walking distance to Pattaya’s major sights. it features a large outdoor pool. free wifi is available in all the rooms. Every paid guest will receive complimentary breakfast buffet between 6:00am till 10:00am.																																																																																	','about_home1685947430.jpg','\" welcome plaza hotel Pattaya have 230 room which located ideally in the city center \"');
/*!40000 ALTER TABLE `home_row_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images_gallary`
--

DROP TABLE IF EXISTS `images_gallary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_gallary` (
  `img_gallary_id` int(11) NOT NULL AUTO_INCREMENT,
  `img_gallary_name` varchar(100) NOT NULL,
  `img_gallary_type` varchar(100) NOT NULL,
  `img_gallary_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`img_gallary_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images_gallary`
--

LOCK TABLES `images_gallary` WRITE;
/*!40000 ALTER TABLE `images_gallary` DISABLE KEYS */;
INSERT INTO `images_gallary` VALUES (3,'room1685695144.jpg','room',1),(4,'pool1685696782.jpg','pool',1),(5,'rastaurant1685696966.jpg','rastaurant',1),(6,'room1685699418.jpg','room',1),(7,'room1685699425.jpg','room',1),(8,'room1685699431.jpg','room',1),(9,'room1685699437.jpg','room',1),(10,'room1685699442.jpg','room',1),(11,'room1685699448.jpg','room',1),(12,'room1685699454.jpg','room',1),(13,'pool1685700013.jpg','pool',1),(14,'room1686023819.jpg','room',1),(15,'room1686023829.jpg','room',1),(16,'room1686023848.jpg','room',1),(17,'room1686023855.jpg','room',1),(18,'room1686023862.jpg','room',1),(19,'room1686023881.jpg','room',1),(20,'room1686023888.jpg','room',1),(21,'room1686023893.jpg','room',1),(22,'room1686024054.jpg','room',1),(23,'room1686024060.jpg','room',1),(24,'room1686024067.jpg','room',0),(25,'room1686024117.jpg','room',1),(26,'room1686024125.jpg','room',1),(27,'pool1686024167.jpg','pool',1),(28,'pool1686024173.jpg','pool',1),(29,'pool1686024193.jpg','pool',1),(31,'pool1686024236.jpg','pool',1),(32,'pool1686024248.jpg','pool',1),(33,'pool1686024257.jpg','pool',1),(34,'pool1686024273.jpg','pool',1),(35,'pool1686024324.jpg','pool',1),(36,'pool1686024331.jpg','pool',1),(37,'pool1686024342.jpg','pool',1),(38,'pool1686024351.jpg','pool',1),(39,'rastaurant1686024436.jpg','rastaurant',0),(40,'rastaurant1686024443.jpg','rastaurant',1),(41,'rastaurant1686024451.jpg','rastaurant',1),(42,'rastaurant1686024486.jpg','rastaurant',1),(43,'rastaurant1686024498.jpg','rastaurant',1),(44,'rastaurant1686024517.jpg','rastaurant',0),(45,'rastaurant1686024527.jpg','rastaurant',1),(46,'rastaurant1686024548.jpg','rastaurant',1);
/*!40000 ALTER TABLE `images_gallary` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images_room`
--

DROP TABLE IF EXISTS `images_room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_room` (
  `img_room_id` int(11) NOT NULL AUTO_INCREMENT,
  `img_room_name` varchar(110) NOT NULL,
  `img_room_type` varchar(100) NOT NULL,
  `img_room_status` int(11) DEFAULT 0,
  PRIMARY KEY (`img_room_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images_room`
--

LOCK TABLES `images_room` WRITE;
/*!40000 ALTER TABLE `images_room` DISABLE KEYS */;
INSERT INTO `images_room` VALUES (15,'kingbed1685679523.jpg','kingbed',1),(16,'kingbed1685679551.jpg','kingbed',1),(17,'kingbed1685679558.jpg','kingbed',1),(18,'kingbed1685679564.jpg','kingbed',1),(19,'kingbed1685679581.jpg','kingbed',1),(20,'kingbed1685679588.jpg','kingbed',1),(21,'kingbed1685679600.jpg','kingbed',1),(22,'kingbed1685679609.jpg','kingbed',1),(23,'twinbed1685680337.jpg','twinbed',1),(24,'twinbed1685680478.jpg','twinbed',1),(25,'twinbed1685684562.jpg','twinbed',1),(26,'twinbed1685684575.jpg','twinbed',1),(27,'twinbed1685684585.jpg','twinbed',1),(28,'twinbed1685684601.jpg','twinbed',1),(33,'triplebed_A1685684946.jpg','triplebed_A',1),(34,'triplebed_A1685684956.jpg','triplebed_A',1),(35,'triplebed_A1685684996.jpg','triplebed_A',1),(36,'triplebed_A1685685005.jpg','triplebed_A',1),(37,'triplebed_B1685686331.jpg','triplebed_B',1),(38,'triplebed_B1685686356.jpg','triplebed_B',1),(39,'twinbed1685687000.jpg','twinbed',0),(45,'room1685694416.jpg','room',0);
/*!40000 ALTER TABLE `images_room` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images_slide_home`
--

DROP TABLE IF EXISTS `images_slide_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images_slide_home` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `uploaded_on` datetime NOT NULL DEFAULT current_timestamp(),
  `upload_by` varchar(100) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images_slide_home`
--

LOCK TABLES `images_slide_home` WRITE;
/*!40000 ALTER TABLE `images_slide_home` DISABLE KEYS */;
INSERT INTO `images_slide_home` VALUES (35,'slides_1682494015.jpg',NULL,'2023-04-26 14:26:55','','1'),(36,'slides_1682494377.jpg',NULL,'2023-04-26 14:32:57','','1'),(37,'slides_1682497618.jpg',NULL,'2023-04-26 15:26:58','','1'),(41,'slides_1682497942.jpg',NULL,'2023-04-26 15:32:22','','1'),(43,'slides_1682497998.jpg',NULL,'2023-04-26 15:33:18','','1'),(53,'slides_1682499613.jpg',NULL,'2023-04-26 16:00:14','','1'),(55,'slides_1682502640.jpg',NULL,'2023-04-26 16:50:40','','1'),(56,'slides_1682569701.jpg',NULL,'2023-04-27 11:28:21','','1'),(90,'slides_1685951930.jpg',NULL,'2023-06-05 14:58:50','','1');
/*!40000 ALTER TABLE `images_slide_home` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_home`
--

DROP TABLE IF EXISTS `room_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room_home` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img_name` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room_home`
--

LOCK TABLES `room_home` WRITE;
/*!40000 ALTER TABLE `room_home` DISABLE KEYS */;
INSERT INTO `room_home` VALUES (1,'welcome Plaza Hotel_2.jpg',1),(2,'Welcome Plaza Hotel_9.jpg',1),(3,'Welcome Plaza Hotel_19.jpg',1),(4,'Welcome Plaza Hotel_25.jpg',1),(5,'slides_1683006123.jpg',1),(6,'slides_1683006200.jpg',1);
/*!40000 ALTER TABLE `room_home` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_uploads`
--

DROP TABLE IF EXISTS `tbl_uploads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_uploads` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `img_name` varchar(100) NOT NULL,
  `img_file` varchar(100) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_uploads`
--

LOCK TABLES `tbl_uploads` WRITE;
/*!40000 ALTER TABLE `tbl_uploads` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_uploads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_admin`
--

DROP TABLE IF EXISTS `user_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  `timelogin` datetime DEFAULT NULL,
  `numerphone` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_admin`
--

LOCK TABLES `user_admin` WRITE;
/*!40000 ALTER TABLE `user_admin` DISABLE KEYS */;
INSERT INTO `user_admin` VALUES (15,'habibi','jackson','หวัง','3384b1322fbcb842e0f86b56884548d8','tiwtanmoo@gmail.com',1,'2023-06-19 10:55:54',NULL),(16,'admin','welcome','Plaza','92d1b790972c909fe4ffc696bc540169','welcomeplazapattaya@gmail.com',2,'2023-06-12 15:25:31',NULL),(20,'jackson','jackson','wang','8d93d6bad1571f4baac53ac813a7fb57','tiwtanmoo@gmail.com',3,'2023-06-08 12:42:51',NULL);
/*!40000 ALTER TABLE `user_admin` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-31 13:30:23

📁 Sid Gifari File Manager