Da

✏️ Editing: assinth_travel.sql

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

/*!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: `assinth_travel`
--

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

USE `assinth_travel`;

--
-- Table structure for table `pm_activity`
--

DROP TABLE IF EXISTS `pm_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `hotels` varchar(250) DEFAULT NULL,
  `users` text DEFAULT NULL,
  `max_children` int(11) DEFAULT 1,
  `max_adults` int(11) DEFAULT 1,
  `max_people` int(11) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `descr` longtext DEFAULT NULL,
  `duration` float DEFAULT 0,
  `duration_unit` varchar(50) DEFAULT NULL,
  `price` double DEFAULT 0,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `activity_lang_fkey` (`lang`),
  CONSTRAINT `activity_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_activity`
--

LOCK TABLES `pm_activity` WRITE;
/*!40000 ALTER TABLE `pm_activity` DISABLE KEYS */;
INSERT INTO `pm_activity` VALUES (1,2,'1,2','1',10,20,30,'Activity-1','Activity-1 Activity-1 Activity-1 Activity-1 Activity-1','act-1','',1,'hours',1000,18.3170581,99.3986862,1,1,1),(1,4,'1,2','1',10,20,30,'กิจกรรม1','กิจกรรม1 กิจกรรม1 กิจกรรม1 กิจกรรม1','activity-1','กิจกรรม1 กิจกรรม1 กิจกรรม1 กิจกรรม1',1,'hours',1000,18.3170581,99.3986862,1,1,1);
/*!40000 ALTER TABLE `pm_activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_activity_file`
--

DROP TABLE IF EXISTS `pm_activity_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_activity_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `activity_file_fkey` (`id_item`,`lang`),
  KEY `activity_file_lang_fkey` (`lang`),
  CONSTRAINT `activity_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_activity` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `activity_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_activity_file`
--

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

--
-- Table structure for table `pm_activity_session`
--

DROP TABLE IF EXISTS `pm_activity_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_activity_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_activity` int(11) NOT NULL,
  `days` varchar(20) DEFAULT NULL,
  `start_date` int(11) DEFAULT NULL,
  `end_date` int(11) DEFAULT NULL,
  `users` text DEFAULT NULL,
  `price` double DEFAULT 0,
  `price_child` double DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_type` varchar(10) DEFAULT NULL,
  `id_tax` int(11) DEFAULT NULL,
  `taxes` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_session_fkey` (`id_activity`),
  CONSTRAINT `activity_session_fkey` FOREIGN KEY (`id_activity`) REFERENCES `pm_activity` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_activity_session`
--

LOCK TABLES `pm_activity_session` WRITE;
/*!40000 ALTER TABLE `pm_activity_session` DISABLE KEYS */;
INSERT INTO `pm_activity_session` VALUES (1,1,'1,5,6',1669852800,1672444800,'1',1000,800,50,'fixed',NULL,''),(2,1,'5,6',1669852800,1672444800,'1',1000,800,50,'fixed',NULL,''),(3,1,'5,6',1669852800,1672444800,'1',1000,800,100,'fixed',1,''),(4,1,'5,6,7',1669852800,1672444800,'1',1000,500,0,'fixed',NULL,'');
/*!40000 ALTER TABLE `pm_activity_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_activity_session_hour`
--

DROP TABLE IF EXISTS `pm_activity_session_hour`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_activity_session_hour` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_activity_session` int(11) NOT NULL,
  `start_h` int(11) DEFAULT NULL,
  `start_m` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_session_hour_fkey` (`id_activity_session`),
  CONSTRAINT `activity_session_hour_fkey` FOREIGN KEY (`id_activity_session`) REFERENCES `pm_activity_session` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_activity_session_hour`
--

LOCK TABLES `pm_activity_session_hour` WRITE;
/*!40000 ALTER TABLE `pm_activity_session_hour` DISABLE KEYS */;
INSERT INTO `pm_activity_session_hour` VALUES (1,1,10,0),(2,1,11,0),(3,1,12,0),(4,3,10,0),(5,3,11,0),(6,4,10,0),(7,4,11,0);
/*!40000 ALTER TABLE `pm_activity_session_hour` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_article`
--

DROP TABLE IF EXISTS `pm_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `text` longtext DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `tags` varchar(250) DEFAULT NULL,
  `id_page` int(11) DEFAULT NULL,
  `users` text DEFAULT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `publish_date` int(11) DEFAULT NULL,
  `unpublish_date` int(11) DEFAULT NULL,
  `comment` int(11) DEFAULT 0,
  `rating` int(11) DEFAULT 0,
  `show_langs` text DEFAULT NULL,
  `hide_langs` text DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `article_lang_fkey` (`lang`),
  KEY `article_page_fkey` (`id_page`,`lang`),
  CONSTRAINT `article_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `article_page_fkey` FOREIGN KEY (`id_page`, `lang`) REFERENCES `pm_page` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_article`
--

LOCK TABLES `pm_article` WRITE;
/*!40000 ALTER TABLE `pm_article` DISABLE KEYS */;
INSERT INTO `pm_article` VALUES (1,1,'Plongez dans des eaux inconnues !','','plongee','','','',5,'1',1,1,1,1669899308,1669899308,NULL,NULL,1,0,NULL,NULL),(1,2,'Dive into unknown waters!','','scuba-diving','Lorem ipsum dolor sit amet consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.','','',5,'1',1,1,1,1669899308,1670139781,NULL,NULL,1,0,'4',''),(1,3,'Dive into unknown waters!','','scuba-diving','','','',5,'1',1,1,1,1669899308,1669899308,NULL,NULL,1,0,NULL,NULL),(1,4,'Dive into unknown waters!','','scuba-diving','Lorem ipsum dolor sit amet consectetur adipiscing elit. Nullam molestie, nunc eu consequat varius, nisi metus iaculis nulla, nec ornare odio leo quis eros. Donec gravida eget velit eget pulvinar. Phasellus eget est quis est faucibus condimentum. Morbi tellus turpis, posuere vel tincidunt non, varius ac ante. Suspendisse in sem neque. Donec et faucibus justo. Nulla vitae nisl lacus. Fusce tincidunt quam nec vestibulum vestibulum. Vivamus vulputate, nunc non ullamcorper mattis, nunc orci imperdiet nulla, at laoreet ipsum nisl non leo. Aenean dapibus aliquet sem, ut lacinia magna mattis in.Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur tempor arcu eu sapien ullamcorper sodales. Aenean eu massa in ante commodo scelerisque vitae sed sapien. Aenean eu dictum arcu. Mauris ultricies dolor eu molestie egestas. Proin feugiat, nunc at pellentesque fringilla, ex purus efficitur dolor, ac pretium odio lacus id leo. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Suspendisse eu ipsum viverra dolor tempus vehicula eu eu risus. Praesent rutrum dapibus odio, nec accumsan justo fermentum in. Ut quis neque a ante facilisis bibendum.','','',5,'1',1,1,1,1669899308,1670139781,NULL,NULL,1,0,'4',''),(4,1,'Première gallery','','premiere-gallery','','','',7,'1',0,1,4,1669899308,1669899308,NULL,NULL,0,0,NULL,NULL),(4,2,'First gallery','','first-gallery','','','',7,'1',0,1,4,1669899308,1669899308,NULL,NULL,0,0,NULL,NULL),(4,3,'First gallery','','first-gallery','','','',7,'1',0,1,4,1669899308,1669899308,NULL,NULL,0,0,NULL,NULL),(4,4,'First gallery','','first-gallery','','','',7,'1',0,1,4,1669899308,1669899308,NULL,NULL,0,0,NULL,NULL);
/*!40000 ALTER TABLE `pm_article` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_article_file`
--

DROP TABLE IF EXISTS `pm_article_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_article_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `article_file_fkey` (`id_item`,`lang`),
  KEY `article_file_lang_fkey` (`lang`),
  CONSTRAINT `article_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_article` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `article_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_article_file`
--

LOCK TABLES `pm_article_file` WRITE;
/*!40000 ALTER TABLE `pm_article_file` DISABLE KEYS */;
INSERT INTO `pm_article_file` VALUES (4,1,4,0,1,4,'sample4.jpg','','image'),(4,2,4,0,1,4,'sample4.jpg','','image'),(4,3,4,0,1,4,'sample4.jpg','','image'),(4,4,4,0,1,4,'sample4.jpg','','image'),(5,1,1,0,1,5,'diving.jpg','','image'),(5,2,1,0,1,5,'diving.jpg','','image'),(5,3,1,0,1,5,'diving.jpg','','image'),(5,4,1,0,1,5,'diving.jpg','','image');
/*!40000 ALTER TABLE `pm_article_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_booking`
--

DROP TABLE IF EXISTS `pm_booking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_hotel` int(11) DEFAULT NULL,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `from_date` int(11) DEFAULT NULL,
  `to_date` int(11) DEFAULT NULL,
  `nights` int(11) DEFAULT 0,
  `adults` int(11) DEFAULT 1,
  `children` int(11) DEFAULT 1,
  `amount` float DEFAULT NULL,
  `tourist_tax` float DEFAULT NULL,
  `discount` float DEFAULT NULL,
  `ex_tax` float DEFAULT NULL,
  `tax_amount` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `down_payment` float DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `balance` float DEFAULT NULL,
  `extra_services` text DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `company` varchar(50) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `postcode` varchar(10) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `country` varchar(100) NOT NULL,
  `comments` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `trans` varchar(50) DEFAULT NULL,
  `payment_date` int(11) DEFAULT NULL,
  `payment_option` varchar(250) DEFAULT NULL,
  `users` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking`
--

LOCK TABLES `pm_booking` WRITE;
/*!40000 ALTER TABLE `pm_booking` DISABLE KEYS */;
INSERT INTO `pm_booking` VALUES (1,1,1670142162,NULL,1670544000,1670630400,1,1,NULL,4100,NULL,0,3790.91,379.09,4170,NULL,NULL,NULL,NULL,1,'Theerachai','Chomtap','mrtan.dev@gmail.com','','123','10140','Bangkok','123','','Thailand','',1,NULL,NULL,'arrival','1'),(2,1,1670143906,NULL,1670544000,1670630400,1,1,NULL,4100,NULL,0,4677.27,372.73,5050,1515,NULL,NULL,NULL,1,'Theerachai','Chomtap','mrtan.dev@gmail.com','','123','10140','Bangkok','123','','Thailand','',1,NULL,NULL,'check','1'),(3,1,1670161779,NULL,1670112000,1670198400,1,1,NULL,4000,NULL,0,4586.36,363.64,4950,NULL,NULL,NULL,NULL,1,'Theerachai','Chomtap','mrtan.dev@gmail.com','','123','10140','Bangkok','123','','Thailand','',1,NULL,NULL,'arrival','1');
/*!40000 ALTER TABLE `pm_booking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_booking_activity`
--

DROP TABLE IF EXISTS `pm_booking_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(11) NOT NULL,
  `id_activity` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `children` int(11) DEFAULT 0,
  `adults` int(11) DEFAULT 0,
  `duration` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT 0,
  `ex_tax` double DEFAULT 0,
  `tax_rate` double DEFAULT 0,
  `date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_activity_fkey` (`id_booking`),
  CONSTRAINT `booking_activity_fkey` FOREIGN KEY (`id_booking`) REFERENCES `pm_booking` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking_activity`
--

LOCK TABLES `pm_booking_activity` WRITE;
/*!40000 ALTER TABLE `pm_booking_activity` DISABLE KEYS */;
INSERT INTO `pm_booking_activity` VALUES (1,2,1,'กิจกรรม1',0,1,'1 hours',950,950,NULL,1670583600),(2,3,1,'กิจกรรม1',0,1,'1 hours',950,950,NULL,1670666400);
/*!40000 ALTER TABLE `pm_booking_activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_booking_payment`
--

DROP TABLE IF EXISTS `pm_booking_payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(11) NOT NULL,
  `descr` varchar(100) DEFAULT NULL,
  `method` varchar(100) DEFAULT NULL,
  `amount` double DEFAULT 0,
  `trans` varchar(100) DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_payment_fkey` (`id_booking`),
  CONSTRAINT `booking_payment_fkey` FOREIGN KEY (`id_booking`) REFERENCES `pm_booking` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking_payment`
--

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

--
-- Table structure for table `pm_booking_room`
--

DROP TABLE IF EXISTS `pm_booking_room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(11) NOT NULL,
  `id_room` int(11) DEFAULT NULL,
  `id_hotel` int(11) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `num` varchar(10) DEFAULT NULL,
  `children` int(11) DEFAULT 0,
  `adults` int(11) DEFAULT 0,
  `amount` double DEFAULT 0,
  `ex_tax` double DEFAULT 0,
  `tax_rate` double DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `booking_room_fkey` (`id_booking`),
  CONSTRAINT `booking_room_fkey` FOREIGN KEY (`id_booking`) REFERENCES `pm_booking` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking_room`
--

LOCK TABLES `pm_booking_room` WRITE;
/*!40000 ALTER TABLE `pm_booking_room` DISABLE KEYS */;
INSERT INTO `pm_booking_room` VALUES (2,2,1,1,'Royal Hotel - Deluxe Double Bedroom',NULL,0,1,4100,3727.27,NULL),(3,3,1,1,'Royal Hotel - Deluxe Double Bedroom',NULL,0,1,4000,3636.36,NULL);
/*!40000 ALTER TABLE `pm_booking_room` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_booking_service`
--

DROP TABLE IF EXISTS `pm_booking_service`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(11) NOT NULL,
  `id_service` int(11) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `qty` int(11) DEFAULT 0,
  `amount` double DEFAULT 0,
  `ex_tax` double DEFAULT 0,
  `tax_rate` double DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `booking_service_fkey` (`id_booking`),
  CONSTRAINT `booking_service_fkey` FOREIGN KEY (`id_booking`) REFERENCES `pm_booking` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking_service`
--

LOCK TABLES `pm_booking_service` WRITE;
/*!40000 ALTER TABLE `pm_booking_service` DISABLE KEYS */;
INSERT INTO `pm_booking_service` VALUES (1,1,1,'Rent of towel (kit)',1,7,6.36,10),(2,1,2,'Housework',1,50,45.45,10),(3,1,3,'Heating',1,8,7.27,10),(4,1,4,'Pet',1,5,4.55,10);
/*!40000 ALTER TABLE `pm_booking_service` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_booking_tax`
--

DROP TABLE IF EXISTS `pm_booking_tax`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_booking_tax` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(11) NOT NULL,
  `id_tax` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `booking_tax_fkey` (`id_booking`),
  CONSTRAINT `booking_tax_fkey` FOREIGN KEY (`id_booking`) REFERENCES `pm_booking` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_booking_tax`
--

LOCK TABLES `pm_booking_tax` WRITE;
/*!40000 ALTER TABLE `pm_booking_tax` DISABLE KEYS */;
INSERT INTO `pm_booking_tax` VALUES (1,1,1,'VAT',379.09),(2,2,1,'VAT',372.73),(3,3,1,'ภาษีมูลค่าเพิ่ม',363.64);
/*!40000 ALTER TABLE `pm_booking_tax` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_comment`
--

DROP TABLE IF EXISTS `pm_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(30) DEFAULT NULL,
  `id_item` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `msg` longtext DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_comment`
--

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

--
-- Table structure for table `pm_country`
--

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

--
-- Dumping data for table `pm_country`
--

LOCK TABLES `pm_country` WRITE;
/*!40000 ALTER TABLE `pm_country` DISABLE KEYS */;
INSERT INTO `pm_country` VALUES (1,'Afghanistan','AF'),(2,'Åland','AX'),(3,'Albania','AL'),(4,'Algeria','DZ'),(5,'American Samoa','AS'),(6,'Andorra','AD'),(7,'Angola','AO'),(8,'Anguilla','AI'),(9,'Antarctica','AQ'),(10,'Antigua and Barbuda','AG'),(11,'Argentina','AR'),(12,'Armenia','AM'),(13,'Aruba','AW'),(14,'Australia','AU'),(15,'Austria','AT'),(16,'Azerbaijan','AZ'),(17,'Bahamas','BS'),(18,'Bahrain','BH'),(19,'Bangladesh','BD'),(20,'Barbados','BB'),(21,'Belarus','BY'),(22,'Belgium','BE'),(23,'Belize','BZ'),(24,'Benin','BJ'),(25,'Bermuda','BM'),(26,'Bhutan','BT'),(27,'Bolivia','BO'),(28,'Bonaire','BQ'),(29,'Bosnia and Herzegovina','BA'),(30,'Botswana','BW'),(31,'Bouvet Island','BV'),(32,'Brazil','BR'),(33,'British Indian Ocean Territory','IO'),(34,'British Virgin Islands','VG'),(35,'Brunei','BN'),(36,'Bulgaria','BG'),(37,'Burkina Faso','BF'),(38,'Burundi','BI'),(39,'Cambodia','KH'),(40,'Cameroon','CM'),(41,'Canada','CA'),(42,'Cape Verde','CV'),(43,'Cayman Islands','KY'),(44,'Central African Republic','CF'),(45,'Chad','TD'),(46,'Chile','CL'),(47,'China','CN'),(48,'Christmas Island','CX'),(49,'Cocos [Keeling] Islands','CC'),(50,'Colombia','CO'),(51,'Comoros','KM'),(52,'Cook Islands','CK'),(53,'Costa Rica','CR'),(54,'Croatia','HR'),(55,'Cuba','CU'),(56,'Curacao','CW'),(57,'Cyprus','CY'),(58,'Czech Republic','CZ'),(59,'Democratic Republic of the Congo','CD'),(60,'Denmark','DK'),(61,'Djibouti','DJ'),(62,'Dominica','DM'),(63,'Dominican Republic','DO'),(64,'East Timor','TL'),(65,'Ecuador','EC'),(66,'Egypt','EG'),(67,'El Salvador','SV'),(68,'Equatorial Guinea','GQ'),(69,'Eritrea','ER'),(70,'Estonia','EE'),(71,'Ethiopia','ET'),(72,'Falkland Islands','FK'),(73,'Faroe Islands','FO'),(74,'Fiji','FJ'),(75,'Finland','FI'),(76,'France','FR'),(77,'French Guiana','GF'),(78,'French Polynesia','PF'),(79,'French Southern Territories','TF'),(80,'Gabon','GA'),(81,'Gambia','GM'),(82,'Georgia','GE'),(83,'Germany','DE'),(84,'Ghana','GH'),(85,'Gibraltar','GI'),(86,'Greece','GR'),(87,'Greenland','GL'),(88,'Grenada','GD'),(89,'Guadeloupe','GP'),(90,'Guam','GU'),(91,'Guatemala','GT'),(92,'Guernsey','GG'),(93,'Guinea','GN'),(94,'Guinea-Bissau','GW'),(95,'Guyana','GY'),(96,'Haiti','HT'),(97,'Heard Island and McDonald Islands','HM'),(98,'Honduras','HN'),(99,'Hong Kong','HK'),(100,'Hungary','HU'),(101,'Iceland','IS'),(102,'India','IN'),(103,'Indonesia','ID'),(104,'Iran','IR'),(105,'Iraq','IQ'),(106,'Ireland','IE'),(107,'Isle of Man','IM'),(108,'Israel','IL'),(109,'Italy','IT'),(110,'Ivory Coast','CI'),(111,'Jamaica','JM'),(112,'Japan','JP'),(113,'Jersey','JE'),(114,'Jordan','JO'),(115,'Kazakhstan','KZ'),(116,'Kenya','KE'),(117,'Kiribati','KI'),(118,'Kosovo','XK'),(119,'Kuwait','KW'),(120,'Kyrgyzstan','KG'),(121,'Laos','LA'),(122,'Latvia','LV'),(123,'Lebanon','LB'),(124,'Lesotho','LS'),(125,'Liberia','LR'),(126,'Libya','LY'),(127,'Liechtenstein','LI'),(128,'Lithuania','LT'),(129,'Luxembourg','LU'),(130,'Macao','MO'),(131,'Macedonia','MK'),(132,'Madagascar','MG'),(133,'Malawi','MW'),(134,'Malaysia','MY'),(135,'Maldives','MV'),(136,'Mali','ML'),(137,'Malta','MT'),(138,'Marshall Islands','MH'),(139,'Martinique','MQ'),(140,'Mauritania','MR'),(141,'Mauritius','MU'),(142,'Mayotte','YT'),(143,'Mexico','MX'),(144,'Micronesia','FM'),(145,'Moldova','MD'),(146,'Monaco','MC'),(147,'Mongolia','MN'),(148,'Montenegro','ME'),(149,'Montserrat','MS'),(150,'Morocco','MA'),(151,'Mozambique','MZ'),(152,'Myanmar [Burma]','MM'),(153,'Namibia','NA'),(154,'Nauru','NR'),(155,'Nepal','NP'),(156,'Netherlands','NL'),(157,'New Caledonia','NC'),(158,'New Zealand','NZ'),(159,'Nicaragua','NI'),(160,'Niger','NE'),(161,'Nigeria','NG'),(162,'Niue','NU'),(163,'Norfolk Island','NF'),(164,'North Korea','KP'),(165,'Northern Mariana Islands','MP'),(166,'Norway','NO'),(167,'Oman','OM'),(168,'Pakistan','PK'),(169,'Palau','PW'),(170,'Palestine','PS'),(171,'Panama','PA'),(172,'Papua New Guinea','PG'),(173,'Paraguay','PY'),(174,'Peru','PE'),(175,'Philippines','PH'),(176,'Pitcairn Islands','PN'),(177,'Poland','PL'),(178,'Portugal','PT'),(179,'Puerto Rico','PR'),(180,'Qatar','QA'),(181,'Republic of the Congo','CG'),(182,'Réunion','RE'),(183,'Romania','RO'),(184,'Russia','RU'),(185,'Rwanda','RW'),(186,'Saint Barthélemy','BL'),(187,'Saint Helena','SH'),(188,'Saint Kitts and Nevis','KN'),(189,'Saint Lucia','LC'),(190,'Saint Martin','MF'),(191,'Saint Pierre and Miquelon','PM'),(192,'Saint Vincent and the Grenadines','VC'),(193,'Samoa','WS'),(194,'San Marino','SM'),(195,'São Tomé and Príncipe','ST'),(196,'Saudi Arabia','SA'),(197,'Senegal','SN'),(198,'Serbia','RS'),(199,'Seychelles','SC'),(200,'Sierra Leone','SL'),(201,'Singapore','SG'),(202,'Sint Maarten','SX'),(203,'Slovakia','SK'),(204,'Slovenia','SI'),(205,'Solomon Islands','SB'),(206,'Somalia','SO'),(207,'South Africa','ZA'),(208,'South Georgia and the South Sandwich Islands','GS'),(209,'South Korea','KR'),(210,'South Sudan','SS'),(211,'Spain','ES'),(212,'Sri Lanka','LK'),(213,'Sudan','SD'),(214,'Suriname','SR'),(215,'Svalbard and Jan Mayen','SJ'),(216,'Swaziland','SZ'),(217,'Sweden','SE'),(218,'Switzerland','CH'),(219,'Syria','SY'),(220,'Taiwan','TW'),(221,'Tajikistan','TJ'),(222,'Tanzania','TZ'),(223,'Thailand','TH'),(224,'Togo','TG'),(225,'Tokelau','TK'),(226,'Tonga','TO'),(227,'Trinidad and Tobago','TT'),(228,'Tunisia','TN'),(229,'Turkey','TR'),(230,'Turkmenistan','TM'),(231,'Turks and Caicos Islands','TC'),(232,'Tuvalu','TV'),(233,'U.S. Minor Outlying Islands','UM'),(234,'U.S. Virgin Islands','VI'),(235,'Uganda','UG'),(236,'Ukraine','UA'),(237,'United Arab Emirates','AE'),(238,'United Kingdom','GB'),(239,'United States','US'),(240,'Uruguay','UY'),(241,'Uzbekistan','UZ'),(242,'Vanuatu','VU'),(243,'Vatican City','VA'),(244,'Venezuela','VE'),(245,'Vietnam','VN'),(246,'Wallis and Futuna','WF'),(247,'Western Sahara','EH'),(248,'Yemen','YE'),(249,'Zambia','ZM'),(250,'Zimbabwe','ZW');
/*!40000 ALTER TABLE `pm_country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_coupon`
--

DROP TABLE IF EXISTS `pm_coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `discount` double DEFAULT 0,
  `discount_type` varchar(10) DEFAULT NULL,
  `rooms` text DEFAULT NULL,
  `once` int(11) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `publish_date` int(11) DEFAULT NULL,
  `unpublish_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_coupon`
--

LOCK TABLES `pm_coupon` WRITE;
/*!40000 ALTER TABLE `pm_coupon` DISABLE KEYS */;
INSERT INTO `pm_coupon` VALUES (1,'NewYear2023','NY2023001',500,'fixed','',1,1,1669891440,1672502400);
/*!40000 ALTER TABLE `pm_coupon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_coupon_user`
--

DROP TABLE IF EXISTS `pm_coupon_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_coupon_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_coupon` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `coupon_user_fkey` (`id_coupon`),
  CONSTRAINT `coupon_user_fkey` FOREIGN KEY (`id_coupon`) REFERENCES `pm_coupon` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_coupon_user`
--

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

--
-- Table structure for table `pm_currency`
--

DROP TABLE IF EXISTS `pm_currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `sign` varchar(5) DEFAULT NULL,
  `main` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_currency`
--

LOCK TABLES `pm_currency` WRITE;
/*!40000 ALTER TABLE `pm_currency` DISABLE KEYS */;
INSERT INTO `pm_currency` VALUES (1,'USD','$',0,1),(2,'EUR','€',0,2),(3,'GBP','£',0,3),(4,'INR','₹',0,4),(5,'AUD','A$',0,5),(6,'CAD','C$',0,6),(7,'CNY','¥',0,7),(8,'TRY','₺',0,8),(9,'THB','฿',1,9);
/*!40000 ALTER TABLE `pm_currency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_destination`
--

DROP TABLE IF EXISTS `pm_destination`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_destination` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `title_tag` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `descr` text DEFAULT NULL,
  `text` longtext DEFAULT NULL,
  `video` text DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_destination`
--

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

--
-- Table structure for table `pm_destination_file`
--

DROP TABLE IF EXISTS `pm_destination_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_destination_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `destination_file_fkey` (`id_item`,`lang`),
  KEY `destination_file_lang_fkey` (`lang`),
  CONSTRAINT `destination_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_destination` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `destination_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_destination_file`
--

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

--
-- Table structure for table `pm_email_content`
--

DROP TABLE IF EXISTS `pm_email_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_email_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `subject` varchar(250) DEFAULT NULL,
  `content` text DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `email_content_lang_fkey` (`lang`),
  CONSTRAINT `email_content_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_email_content`
--

LOCK TABLES `pm_email_content` WRITE;
/*!40000 ALTER TABLE `pm_email_content` DISABLE KEYS */;
INSERT INTO `pm_email_content` VALUES (1,1,'CONTACT','Contact','Nom: {name}Adresse: {address}Téléphone: {phone}E-mail: {email}Message:{msg}'),(1,2,'CONTACT','Contact','Name: {name} Address: {address} Phone: {phone} E-mail: {email} Message: {msg}'),(1,3,'CONTACT','Contact','Name: {name}Address: {address}Phone: {phone}E-mail: {email}Message:{msg}'),(1,4,'CONTACT','Contact','Name: {name} Address: {address} Phone: {phone} E-mail: {email} Message: {msg}'),(2,1,'BOOKING_REQUEST','Demande de réservation','Adresse de facturation \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nSociété : {company} \r\nTéléphone : {phone} \r\nMobile : {mobile} \r\nEmail : {email}\r\n\r\nDétails de la réservation \r\nArrivée : {Check_in} \r\nDépart : {Check_out} \r\n{num_nights} nuit(s) \r\n{num_guests} personne(s) - Adulte(s) : {num_adults} / Enfant(s) : {num_children}\r\n\r\nChambres\r\n\r\n{rooms}\r\n\r\nServices supplémentaires\r\n\r\n{extra_services}\r\n\r\nActivités\r\n\r\n{activities}\r\n\r\nCommentaires \r\n{comments}\r\n'),(2,2,'BOOKING_REQUEST','Booking request','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nComments \r\n{comments}\r\n'),(2,3,'BOOKING_REQUEST','Booking request','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nComments \r\n{comments}\r\n'),(2,4,'BOOKING_REQUEST','Booking request','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nComments \r\n{comments}\r\n'),(3,1,'BOOKING_CONFIRMATION','Confirmation de réservation','Adresse de facturation \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nSociété : {company} \r\nTéléphone : {phone} \r\nMobile : {mobile} \r\nEmail : {email}\r\n\r\nDétails de la réservation \r\nArrivée : {Check_in} \r\nDépart : {Check_out} \r\n{num_nights} nuit(s) \r\n{num_guests} personne(s) - Adulte(s) : {num_adults} / Enfant(s) : {num_children}\r\n\r\nChambres\r\n\r\n{rooms}\r\n\r\nServices supplémentaires\r\n\r\n{extra_services}\r\n\r\nActivités\r\n\r\n{activities}\r\n\r\nTaxe de séjour : {tourist_tax} \r\nRéduction: {discount} \r\n{taxes} \r\nTotal : {total} TTC\r\n\r\nAcompte : {down_payment} TTC\r\n\r\nCommentaires \r\n{comments}\r\n\r\n{payment_notice}\r\n'),(3,2,'BOOKING_CONFIRMATION','Booking confirmation','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nTourist tax: {tourist_tax} \r\nDiscount: {discount} \r\n{taxes} \r\nTotal: {total} incl. VAT\r\n\r\nDown payment: {down_payment} incl. VAT\r\n\r\nComments \r\n{comments}\r\n\r\n{payment_notice}\r\n'),(3,3,'BOOKING_CONFIRMATION','Booking confirmation','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nTourist tax: {tourist_tax} \r\nDiscount: {discount} \r\n{taxes} \r\nTotal: {total} incl. VAT\r\n\r\nDown payment: {down_payment} incl. VAT\r\n\r\nComments \r\n{comments}\r\n\r\n{payment_notice}\r\n'),(3,4,'BOOKING_CONFIRMATION','Booking confirmation','Billing address \r\n{firstname} {lastname} \r\n{address} \r\n{postcode} {city} \r\nCompany: {company} \r\nPhone: {phone} \r\nMobile: {mobile} \r\nEmail: {email}\r\n\r\nBooking details \r\nCheck in {Check_in} \r\nCheck out {Check_out} \r\n{num_nights} nights \r\n{num_guests} persons - Adults: {num_adults} / Children: {num_children}\r\n\r\nRooms\r\n\r\n{rooms}\r\n\r\nExtra services\r\n\r\n{extra_services}\r\n\r\nActivities\r\n\r\n{activities}\r\n\r\nTourist tax: {tourist_tax} \r\nDiscount: {discount} \r\n{taxes} \r\nTotal: {total} incl. VAT\r\n\r\nDown payment: {down_payment} incl. VAT\r\n\r\nComments \r\n{comments}\r\n\r\n{payment_notice}\r\n'),(4,1,'ACCOUNT_CONFIRMATION','Confirmation du compte','Bonjour, \r\nVous avez cr&eacute;&eacute; un nouveau compte. \r\nCliquez sur le lien ci-dessous pour valider votre compte: \r\n<a href=\"{link}\">Valider mon compte</a>\r\n'),(4,2,'ACCOUNT_CONFIRMATION','Validate your account','Hi, \r\nYou created a new account. \r\nClick on the link bellow to validate your account: \r\n<a href=\"{link}\">Validate my new account</a>\r\n'),(4,3,'ACCOUNT_CONFIRMATION','Validate your account','Hi, \r\nYou created a new account. \r\nClick on the link bellow to validate your account: \r\n<a href=\"{link}\">Validate my new account</a>\r\n'),(4,4,'ACCOUNT_CONFIRMATION','Validate your account','Hi, \r\nYou created a new account. \r\nClick on the link bellow to validate your account: \r\n<a href=\"{link}\">Validate my new account</a>\r\n');
/*!40000 ALTER TABLE `pm_email_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_facility`
--

DROP TABLE IF EXISTS `pm_facility`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_facility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `facility_lang_fkey` (`lang`),
  CONSTRAINT `facility_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_facility`
--

LOCK TABLES `pm_facility` WRITE;
/*!40000 ALTER TABLE `pm_facility` DISABLE KEYS */;
INSERT INTO `pm_facility` VALUES (1,1,'Climatisation',1),(1,2,'Air conditioning',1),(1,4,'Air conditioning',1),(2,1,'Lit bébé',2),(2,2,'Baby cot',2),(2,4,'Baby cot',2),(3,1,'Balcon',3),(3,2,'Balcony',3),(3,4,'Balcony',3),(4,1,'Barbecue',4),(4,2,'Barbecue',4),(4,4,'Barbecue',4),(5,1,'Salle de bain',5),(5,2,'Bathroom',5),(5,4,'Bathroom',5),(6,1,'Cafetière',6),(6,2,'Coffeemaker',6),(6,4,'Coffeemaker',6),(7,1,'Plaque de cuisson',7),(7,2,'Cooktop',7),(7,4,'Cooktop',7),(8,1,'Bureau',8),(8,2,'Desk',8),(8,4,'Desk',8),(9,1,'Lave vaisselle',9),(9,2,'Dishwasher',9),(9,4,'Dishwasher',9),(10,1,'Ventilateur',10),(10,2,'Fan',10),(10,4,'Fan',10),(11,1,'Parking gratuit',11),(11,2,'Free parking',11),(11,4,'Free parking',11),(12,1,'Réfrigérateur',12),(12,2,'Fridge',12),(12,4,'Fridge',12),(13,1,'Sèche-cheveux',13),(13,2,'Hairdryer',13),(13,4,'Hairdryer',13),(14,1,'Internet',14),(14,2,'Internet',14),(14,4,'Internet',14),(15,1,'Fer à repasser',15),(15,2,'Iron',15),(15,4,'Iron',15),(16,1,'Micro-ondes',16),(16,2,'Microwave',16),(16,4,'Microwave',16),(17,1,'Mini-bar',17),(17,2,'Mini-bar',17),(17,4,'Mini-bar',17),(18,1,'Non-fumeurs',18),(18,2,'Non-smoking',18),(18,4,'Non-smoking',18),(19,1,'Parking payant',19),(19,2,'Paid parking',19),(19,4,'Paid parking',19),(20,1,'Animaux acceptés',20),(20,2,'Pets allowed',20),(20,4,'Pets allowed',20),(21,1,'Animaux interdits',21),(21,2,'Pets not allowed',21),(21,4,'Pets not allowed',21),(22,1,'Radio',22),(22,2,'Radio',22),(22,4,'Radio',22),(23,1,'Coffre-fort',23),(23,2,'Safe',23),(23,4,'Safe',23),(24,1,'Chaines satellite',24),(24,2,'Satellite chanels',24),(24,4,'Satellite chanels',24),(25,1,'Salle d\'eau',25),(25,2,'Shower-room',25),(25,4,'Shower-room',25),(26,1,'Coin salon',26),(26,2,'Small lounge',26),(26,4,'Small lounge',26),(27,1,'Telephone',27),(27,2,'Telephone',27),(27,4,'Telephone',27),(28,1,'Téléviseur',28),(28,2,'Television',28),(28,4,'Television',28),(29,1,'Terrasse',29),(29,2,'Terrasse',29),(29,4,'Terrasse',29),(30,1,'Machine à laver',30),(30,2,'Washing machine',30),(30,4,'Washing machine',30),(31,1,'Accès handicapés',31),(31,2,'Wheelchair accessible',31),(31,4,'Wheelchair accessible',31),(32,1,'Wi-Fi',31),(32,2,'WiFi',31),(32,4,'WiFi',31),(33,1,'Chaine hifi',32),(33,2,'Hi-fi system',32),(33,4,'Hi-fi system',32),(34,1,'Lecteur DVD',33),(34,2,'DVD player',33),(34,4,'DVD player',33),(35,1,'Ascenceur',34),(35,2,'Elevator',34),(35,4,'Elevator',34),(36,1,'Coin salon',35),(36,2,'Lounge',35),(36,4,'Lounge',35),(37,1,'Restaurant',36),(37,2,'Restaurant',36),(37,4,'Restaurant',36),(38,1,'Service de chambre',37),(38,2,'Room service',37),(38,4,'Room service',37),(39,1,'Vestiaire',38),(39,2,'Cloakroom',38),(39,4,'Cloakroom',38);
/*!40000 ALTER TABLE `pm_facility` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_facility_file`
--

DROP TABLE IF EXISTS `pm_facility_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_facility_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `facility_file_fkey` (`id_item`,`lang`),
  KEY `facility_file_lang_fkey` (`lang`),
  CONSTRAINT `facility_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_facility` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `facility_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_facility_file`
--

LOCK TABLES `pm_facility_file` WRITE;
/*!40000 ALTER TABLE `pm_facility_file` DISABLE KEYS */;
INSERT INTO `pm_facility_file` VALUES (1,2,31,0,1,1,'wheelchair.png','','image'),(1,4,31,0,1,1,'wheelchair.png','','image'),(2,2,20,0,1,2,'pet-allowed.png','','image'),(2,4,20,0,1,2,'pet-allowed.png','','image'),(3,2,21,0,1,3,'pet-not-allowed.png','','image'),(3,4,21,0,1,3,'pet-not-allowed.png','','image'),(4,2,3,0,1,4,'balcony.png','','image'),(4,4,3,0,1,4,'balcony.png','','image'),(5,2,4,0,1,5,'barbecue.png','','image'),(5,4,4,0,1,5,'barbecue.png','','image'),(6,2,8,0,1,6,'desk.png','','image'),(6,4,8,0,1,6,'desk.png','','image'),(7,2,6,0,1,7,'coffee.png','','image'),(7,4,6,0,1,7,'coffee.png','','image'),(8,2,24,0,1,8,'satellite.png','','image'),(8,4,24,0,1,8,'satellite.png','','image'),(9,2,1,0,1,9,'air-conditioning.png','','image'),(9,4,1,0,1,9,'air-conditioning.png','','image'),(10,2,23,0,1,10,'safe.png','','image'),(10,4,23,0,1,10,'safe.png','','image'),(11,2,26,0,1,11,'lounge.png','','image'),(11,4,26,0,1,11,'lounge.png','','image'),(12,2,15,0,1,12,'iron.png','','image'),(12,4,15,0,1,12,'iron.png','','image'),(13,2,14,0,1,13,'adsl.png','','image'),(13,4,14,0,1,13,'adsl.png','','image'),(14,2,9,0,1,14,'dishwasher.png','','image'),(14,4,9,0,1,14,'dishwasher.png','','image'),(15,2,2,0,1,15,'baby-cot.png','','image'),(15,4,2,0,1,15,'baby-cot.png','','image'),(16,2,30,0,1,16,'washing-machine.png','','image'),(16,4,30,0,1,16,'washing-machine.png','','image'),(17,2,16,0,1,17,'microwaves.png','','image'),(17,4,16,0,1,17,'microwaves.png','','image'),(18,2,17,0,1,18,'mini-bar.png','','image'),(18,4,17,0,1,18,'mini-bar.png','','image'),(19,2,18,0,1,19,'non-smoking.png','','image'),(19,4,18,0,1,19,'non-smoking.png','','image'),(20,2,11,0,1,20,'free-parking.png','','image'),(20,4,11,0,1,20,'free-parking.png','','image'),(21,2,19,0,1,21,'paid-parking.png','','image'),(21,4,19,0,1,21,'paid-parking.png','','image'),(22,2,7,0,1,22,'cooktop.png','','image'),(22,4,7,0,1,22,'cooktop.png','','image'),(23,2,22,0,1,23,'radio.png','','image'),(23,4,22,0,1,23,'radio.png','','image'),(24,2,12,0,1,24,'fridge.png','','image'),(24,4,12,0,1,24,'fridge.png','','image'),(25,2,25,0,1,25,'shower.png','','image'),(25,4,25,0,1,25,'shower.png','','image'),(26,2,5,0,1,26,'bath.png','','image'),(26,4,5,0,1,26,'bath.png','','image'),(27,2,13,0,1,27,'hairdryer.png','','image'),(27,4,13,0,1,27,'hairdryer.png','','image'),(28,2,27,0,1,28,'phone.png','','image'),(28,4,27,0,1,28,'phone.png','','image'),(29,2,28,0,1,29,'tv.png','','image'),(29,4,28,0,1,29,'tv.png','','image'),(30,2,29,0,1,30,'terrasse.png','','image'),(30,4,29,0,1,30,'terrasse.png','','image'),(31,2,10,0,1,31,'fan.png','','image'),(31,4,10,0,1,31,'fan.png','','image'),(32,2,32,0,1,32,'wifi.png','','image'),(32,4,32,0,1,32,'wifi.png','','image'),(33,2,33,0,1,33,'hifi.png','','image'),(33,4,33,0,1,33,'hifi.png','','image'),(34,2,34,0,1,34,'dvd.png','','image'),(34,4,34,0,1,34,'dvd.png','','image'),(35,2,33,0,1,33,'elevator.png','','image'),(35,4,33,0,1,33,'elevator.png','','image'),(36,2,33,0,1,33,'lounge.png','','image'),(36,4,33,0,1,33,'lounge.png','','image'),(37,2,33,0,1,33,'restaurant.png','','image'),(37,4,33,0,1,33,'restaurant.png','','image'),(38,2,33,0,1,33,'room-service.png','','image'),(38,4,33,0,1,33,'room-service.png','','image'),(39,2,33,0,1,33,'cloakroom.png','','image'),(39,4,33,0,1,33,'cloakroom.png','','image');
/*!40000 ALTER TABLE `pm_facility_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_hotel`
--

DROP TABLE IF EXISTS `pm_hotel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_hotel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `users` text DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `class` int(11) DEFAULT 0,
  `address` varchar(250) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `web` varchar(250) DEFAULT NULL,
  `descr` longtext DEFAULT NULL,
  `facilities` varchar(250) DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `id_destination` int(11) DEFAULT NULL,
  `paypal_email` varchar(250) DEFAULT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `hotel_lang_fkey` (`lang`),
  CONSTRAINT `hotel_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_hotel`
--

LOCK TABLES `pm_hotel` WRITE;
/*!40000 ALTER TABLE `pm_hotel` DISABLE KEYS */;
INSERT INTO `pm_hotel` VALUES (1,1,'1','Royal Hotel','Hôtel luxueux avec vue sur la mer','royal-hotel',4,'',4.455734,73.718185,'contact@pandao.eu','+30 1 0xxx xxxx','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquet felis massa, sed condimentum ligula feugiat et. Etiam facilisis euismod dignissim. Vivamus facilisis lorem ut purus pellentesque, nec sollicitudin lorem suscipit. Fusce sed enim ultricies, venenatis nunc ut, pharetra nunc. Quisque sollicitudin egestas varius. Nulla aliquet magna sapien, id malesuada felis lobortis id. Vivamus vulputate sed enim sit amet eleifend. Vivamus sit amet felis id urna vulputate maximus. Nullam fringilla sed turpis non volutpat. Cras ultrices diam velit, ac volutpat odio semper at. Sed pulvinar turpis imperdiet sapien hendrerit pulvinar.\r\n','1,11,20,37,32',NULL,NULL,NULL,1,1,1),(1,2,'1','Royal Hotel','Luxury hotel overlooking the sea','royal-hotel',4,'1234',4.455734,73.718185,'contact@pandao.eu','+30 1 0xxx xxxx','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquet felis massa, sed condimentum ligula feugiat et. Etiam facilisis euismod dignissim. Vivamus facilisis lorem ut purus pellentesque, nec sollicitudin lorem suscipit. Fusce sed enim ultricies, venenatis nunc ut, pharetra nunc. Quisque sollicitudin egestas varius. Nulla aliquet magna sapien, id malesuada felis lobortis id. Vivamus vulputate sed enim sit amet eleifend. Vivamus sit amet felis id urna vulputate maximus. Nullam fringilla sed turpis non volutpat. Cras ultrices diam velit, ac volutpat odio semper at. Sed pulvinar turpis imperdiet sapien hendrerit pulvinar.','1,11,20,32,37','',NULL,'',1,1,1),(1,3,'1','Royal Hotel','فندق فخم يطل على البحر','royal-hotel',4,'',4.455734,73.718185,'contact@pandao.eu','+30 1 0xxx xxxx','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquet felis massa, sed condimentum ligula feugiat et. Etiam facilisis euismod dignissim. Vivamus facilisis lorem ut purus pellentesque, nec sollicitudin lorem suscipit. Fusce sed enim ultricies, venenatis nunc ut, pharetra nunc. Quisque sollicitudin egestas varius. Nulla aliquet magna sapien, id malesuada felis lobortis id. Vivamus vulputate sed enim sit amet eleifend. Vivamus sit amet felis id urna vulputate maximus. Nullam fringilla sed turpis non volutpat. Cras ultrices diam velit, ac volutpat odio semper at. Sed pulvinar turpis imperdiet sapien hendrerit pulvinar.\r\n','1,11,20,37,32',NULL,NULL,NULL,1,1,1),(1,4,'1','Royal Hotel','Luxury hotel overlooking the sea','royal-hotel',4,'1234',4.455734,73.718185,'contact@pandao.eu','+30 1 0xxx xxxx','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquet felis massa, sed condimentum ligula feugiat et. Etiam facilisis euismod dignissim. Vivamus facilisis lorem ut purus pellentesque, nec sollicitudin lorem suscipit. Fusce sed enim ultricies, venenatis nunc ut, pharetra nunc. Quisque sollicitudin egestas varius. Nulla aliquet magna sapien, id malesuada felis lobortis id. Vivamus vulputate sed enim sit amet eleifend. Vivamus sit amet felis id urna vulputate maximus. Nullam fringilla sed turpis non volutpat. Cras ultrices diam velit, ac volutpat odio semper at. Sed pulvinar turpis imperdiet sapien hendrerit pulvinar.','1,11,20,32,37','',NULL,'',1,1,1),(2,2,'1','','','',3,'66/7 Aroonpat 2 Village,',13.7412447,100.300958,'mrtan.dev@gmail.com','','','','1','',NULL,'',1,1,2),(2,4,'1','โรงแรม1','','hotel1',3,'66/7 Aroonpat 2 Village,',13.7412447,100.300958,'mrtan.dev@gmail.com','','','','1','',NULL,'',1,1,2);
/*!40000 ALTER TABLE `pm_hotel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_hotel_file`
--

DROP TABLE IF EXISTS `pm_hotel_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_hotel_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `hotel_file_fkey` (`id_item`,`lang`),
  KEY `hotel_file_lang_fkey` (`lang`),
  CONSTRAINT `hotel_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_hotel` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `hotel_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_hotel_file`
--

LOCK TABLES `pm_hotel_file` WRITE;
/*!40000 ALTER TABLE `pm_hotel_file` DISABLE KEYS */;
INSERT INTO `pm_hotel_file` VALUES (1,1,1,0,1,1,'5555048217-1389b680d6-o.jpg','','image'),(1,2,1,0,1,1,'5555048217-1389b680d6-o.jpg','','image'),(1,3,1,0,1,1,'5555048217-1389b680d6-o.jpg','','image'),(1,4,1,0,1,1,'5555048217-1389b680d6-o.jpg','','image');
/*!40000 ALTER TABLE `pm_hotel_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_ical_event`
--

DROP TABLE IF EXISTS `pm_ical_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_ical_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_room` int(11) NOT NULL,
  `title` varchar(150) DEFAULT NULL,
  `sync_date` int(11) DEFAULT NULL,
  `from_date` int(11) DEFAULT NULL,
  `to_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ical_event_fkey` (`id_room`),
  CONSTRAINT `ical_event_fkey` FOREIGN KEY (`id_room`) REFERENCES `pm_room` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_ical_event`
--

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

--
-- Table structure for table `pm_lang`
--

DROP TABLE IF EXISTS `pm_lang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) DEFAULT NULL,
  `locale` varchar(20) DEFAULT NULL,
  `main` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  `tag` varchar(20) DEFAULT NULL,
  `rtl` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_lang`
--

LOCK TABLES `pm_lang` WRITE;
/*!40000 ALTER TABLE `pm_lang` DISABLE KEYS */;
INSERT INTO `pm_lang` VALUES (1,'Français','fr_FR',0,3,2,'fr',0),(2,'English','en_GB',0,1,1,'en',0),(3,'عربي','ar_MA',0,3,3,'ar',1),(4,'Thai','th_TH',1,1,4,'th',0);
/*!40000 ALTER TABLE `pm_lang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_lang_file`
--

DROP TABLE IF EXISTS `pm_lang_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_lang_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lang_file_fkey` (`id_item`),
  CONSTRAINT `lang_file_fkey` FOREIGN KEY (`id_item`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_lang_file`
--

LOCK TABLES `pm_lang_file` WRITE;
/*!40000 ALTER TABLE `pm_lang_file` DISABLE KEYS */;
INSERT INTO `pm_lang_file` VALUES (1,1,0,1,2,'fr.png','','image'),(2,2,0,1,1,'gb.png','','image'),(3,3,0,1,3,'ar.png','','image'),(4,4,NULL,1,4,'thai.png','','image');
/*!40000 ALTER TABLE `pm_lang_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_location`
--

DROP TABLE IF EXISTS `pm_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `pages` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_location`
--

LOCK TABLES `pm_location` WRITE;
/*!40000 ALTER TABLE `pm_location` DISABLE KEYS */;
INSERT INTO `pm_location` VALUES (1,'Panda Multi Resorts','Maldives Mint, Neeloafaru Magu 20014, Maldives',4.174411,73.517851,1,'2');
/*!40000 ALTER TABLE `pm_location` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_media`
--

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

--
-- Dumping data for table `pm_media`
--

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

--
-- Table structure for table `pm_media_file`
--

DROP TABLE IF EXISTS `pm_media_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_media_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_file_fkey` (`id_item`),
  CONSTRAINT `media_file_fkey` FOREIGN KEY (`id_item`) REFERENCES `pm_media` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_media_file`
--

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

--
-- Table structure for table `pm_menu`
--

DROP TABLE IF EXISTS `pm_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `id_parent` int(11) DEFAULT NULL,
  `item_type` varchar(30) DEFAULT NULL,
  `id_item` int(11) DEFAULT NULL,
  `url` text DEFAULT NULL,
  `main` int(11) DEFAULT 1,
  `footer` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `menu_lang_fkey` (`lang`),
  CONSTRAINT `menu_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_menu`
--

LOCK TABLES `pm_menu` WRITE;
/*!40000 ALTER TABLE `pm_menu` DISABLE KEYS */;
INSERT INTO `pm_menu` VALUES (1,1,'Accueil','Lorem ipsum dolor sit amet',NULL,'page',1,NULL,1,0,1,1),(1,2,'Home','Panda Multi Resorts, Luxury Hotels',NULL,'page',16,'',1,0,1,1),(1,3,'ترحيب','هو سقطت الساحلية ذات, أن.',NULL,'page',1,NULL,1,0,1,1),(1,4,'หน้าแรก','Panda Multi Resorts, Luxury Hotels',NULL,'page',16,'',1,0,1,1),(2,1,'Contact','Contact',NULL,'page',2,NULL,1,1,1,8),(2,2,'Contact','Contact',NULL,'page',2,'',1,1,1,8),(2,3,'جهة الاتصال','جهة الاتصال',NULL,'page',2,NULL,1,1,1,8),(2,4,'ติดต่อ','ติดต่อ',NULL,'page',2,'',1,1,1,8),(3,1,'Mentions légales','Mentions légales',NULL,'page',3,NULL,0,1,1,9),(3,2,'Legal notices','Legal notices',NULL,'page',3,'',0,1,1,9),(3,3,'يذكر القانونية','يذكر القانونية',NULL,'page',3,NULL,0,1,1,9),(3,4,'ประกาศความเป็นส่วนตัว','Legal notices',NULL,'page',3,'',0,1,1,9),(4,1,'Plan du site','Plan du site',NULL,'page',4,NULL,0,1,1,10),(4,2,'Sitemap','Sitemap',NULL,'page',4,'',0,1,1,10),(4,3,'خريطة الموقع','خريطة الموقع',NULL,'page',4,NULL,0,1,1,10),(4,4,'แผนผังเว็บไซต์','Sitemap',NULL,'page',4,'',0,1,1,10),(5,1,'Qui sommes-nous ?','Qui sommes-nous ?',NULL,'page',5,NULL,1,0,1,2),(5,2,'About us','About us',NULL,'page',5,'',1,0,1,2),(5,3,'معلومات عنا','معلومات عنا',NULL,'page',5,NULL,1,0,1,2),(5,4,'เกี่ยวกับเรา','About us',NULL,'page',5,'',1,0,1,2),(6,1,'Galerie','Galerie',NULL,'page',7,NULL,1,0,1,4),(6,2,'Gallery','Gallery',NULL,'page',7,'',1,0,1,4),(6,3,'صور معرض','صور معرض',NULL,'page',7,NULL,1,0,1,4),(6,4,'รูปภาพ','Gallery',NULL,'page',7,'',1,0,1,4),(7,1,'Hôtels','Hôtels',NULL,'page',9,NULL,1,0,1,3),(7,2,'Hotels','Hotels',NULL,'page',9,'',1,0,1,3),(7,3,'الفنادق','الفنادق',NULL,'page',9,NULL,1,0,1,3),(7,4,'โรงแรม','Hotels',NULL,'page',9,'',1,0,1,3),(8,1,'Réserver','Réserver',NULL,'page',10,NULL,1,0,1,7),(8,2,'Booking','Booking',NULL,'page',10,'',1,0,1,7),(8,3,'الحجز','الحجز',NULL,'page',10,NULL,1,0,1,7),(8,4,'การจอง','Booking',NULL,'page',10,'',1,0,1,7),(9,1,'Activités','Activités',NULL,'page',16,NULL,1,0,1,5),(9,2,'Activities','Activities',NULL,'page',16,'',1,0,1,5),(9,3,'Activities','Activities',NULL,'page',16,NULL,1,0,1,5),(9,4,'กิจกรรม','Activities',NULL,'page',16,'',1,0,1,5),(10,1,'Destinations','',NULL,'page',18,'',1,0,1,6),(10,2,'Destinations','',NULL,'page',18,'',1,0,1,6),(10,3,'وجهات','',NULL,'page',18,'',1,0,1,6),(10,4,'จุดหมายปลายทาง','',NULL,'page',18,'',1,0,1,6);
/*!40000 ALTER TABLE `pm_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_message`
--

DROP TABLE IF EXISTS `pm_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `subject` varchar(250) DEFAULT NULL,
  `msg` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_message`
--

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

--
-- Table structure for table `pm_package`
--

DROP TABLE IF EXISTS `pm_package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users` text DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `days` text DEFAULT NULL,
  `min_nights` int(11) DEFAULT NULL,
  `max_nights` int(11) DEFAULT NULL,
  `day_start` int(11) DEFAULT NULL,
  `day_end` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_package`
--

LOCK TABLES `pm_package` WRITE;
/*!40000 ALTER TABLE `pm_package` DISABLE KEYS */;
INSERT INTO `pm_package` VALUES (1,'1','Week-end','5,6,7',0,0,NULL,NULL),(2,'1','Night','1,2,3,4,5,6,7',0,0,NULL,NULL),(3,'1','Mid-week','1,2,3,4,5',3,4,NULL,NULL),(4,'1','2 nights','1,2,3,4',2,2,NULL,NULL),(6,'1','Week','1,2,3,4,5,6,7',7,0,NULL,NULL);
/*!40000 ALTER TABLE `pm_package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_page`
--

DROP TABLE IF EXISTS `pm_page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `title_tag` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `descr` longtext DEFAULT NULL,
  `robots` varchar(20) DEFAULT NULL,
  `keywords` varchar(250) DEFAULT NULL,
  `intro` longtext DEFAULT NULL,
  `text` longtext DEFAULT NULL,
  `id_parent` int(11) DEFAULT NULL,
  `page_model` varchar(50) DEFAULT NULL,
  `article_model` varchar(50) DEFAULT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `comment` int(11) DEFAULT 0,
  `rating` int(11) DEFAULT 0,
  `system` int(11) DEFAULT 0,
  `show_langs` text DEFAULT NULL,
  `hide_langs` text DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `page_lang_fkey` (`lang`),
  CONSTRAINT `page_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_page`
--

LOCK TABLES `pm_page` WRITE;
/*!40000 ALTER TABLE `pm_page` DISABLE KEYS */;
INSERT INTO `pm_page` VALUES (1,1,'Accueil','Lorem ipsum dolor sit amet','Consectetur adipiscing elit','Accueil','','','index,follow','','','',NULL,'home','',0,1,1,1669899308,1669899308,0,0,0,NULL,NULL),(1,2,'Home','Panda Multi Resorts, Luxury Hotels','','Panda Multi Resorts, web software to create and manage multi hotels platforms','','','index,follow','','','<blockquote>A man travels the world over in search of what he needs and returns home to find it.</blockquote>- George A. Moore -',NULL,'home','',0,1,1,1669899308,1670133702,0,0,0,'',''),(1,3,'ترحيب','هو سقطت الساحلية ذات, أن.','غير بمعارضة وهولندا، الإقتصادية قد, فقد الفرنسي المعاهدات قد من.','ترحيب','','','index,follow','','','',NULL,'home','',0,1,1,1669899308,1669899308,0,0,0,NULL,NULL),(1,4,'หน้าแรก','Panda Multi Resorts, Luxury Hotels','','Panda Multi Resorts, web software to create and manage multi hotels platforms','','','index,follow','','','<blockquote>A man travels the world over in search of what he needs and returns home to find it.</blockquote>- George A. Moore -',NULL,'home','',0,1,1,1669899308,1670133702,0,0,0,'',''),(2,1,'Contact','Contact','','Contact','contact','','index,follow','','','',NULL,'contact','',0,1,11,1669899308,1669899308,0,0,0,NULL,NULL),(2,2,'Contact','Contact','','Contact','contact','','index,follow','','','',NULL,'contact','',0,1,11,1669899308,1670138247,0,0,0,'',''),(2,3,'جهة الاتصال','جهة الاتصال','','جهة الاتصال','contact','','index,follow','','','',NULL,'contact','',0,1,11,1669899308,1669899308,0,0,0,NULL,NULL),(2,4,'ติดต่อ','ติดต่อเรา','','Contact','contact','','index,follow','','','',NULL,'contact','',0,1,11,1669899308,1670138247,0,0,0,'',''),(3,1,'Mentions légales','Mentions légales','','Mentions légales','mentions-legales','','index,follow','','','',NULL,'page','',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(3,2,'Legal notices','Legal notices','','Legal notices','legal-notices','','index,follow','','','',NULL,'page','',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(3,3,'يذكر القانونية','يذكر القانونية','','يذكر القانونية','legal-notices','','index,follow','','','',NULL,'page','',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(3,4,'Legal notices','Legal notices','','Legal notices','legal-notices','','index,follow','','','',NULL,'page','',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(4,1,'Plan du site','Plan du site','','Plan du site','plan-site','','index,follow','','','',NULL,'sitemap','',0,1,13,1669899308,1669899308,0,0,0,NULL,NULL),(4,2,'Sitemap','Sitemap','','Sitemap','sitemap','','index,follow','','','',NULL,'sitemap','',0,1,13,1669899308,1669899308,0,0,0,NULL,NULL),(4,3,'خريطة الموقع','خريطة الموقع','','خريطة الموقع','sitemap','','index,follow','','','',NULL,'sitemap','',0,1,13,1669899308,1669899308,0,0,0,NULL,NULL),(4,4,'Sitemap','Sitemap','','Sitemap','sitemap','','index,follow','','','',NULL,'sitemap','',0,1,13,1669899308,1669899308,0,0,0,NULL,NULL),(5,1,'Qui sommes-nous ?','Qui sommes-nous ?','','Qui sommes-nous ?','qui-sommes-nous','','index,follow','','','',NULL,'page','article',0,1,2,1669899308,1669899308,0,0,0,NULL,NULL),(5,2,'About us','About us','','About us','about-us','','index,follow','','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque fringilla vel est at rhoncus. Cras porttitor ligula vel magna vehicula accumsan. Mauris eget elit et sem commodo interdum. Aenean dolor sem, tincidunt ac neque tempus, hendrerit blandit lacus. Vivamus placerat nulla in mi tristique, fringilla fermentum nisl vehicula. Nullam quis eros non magna tincidunt interdum ac eu eros. Morbi malesuada pulvinar ultrices. Etiam bibendum efficitur risus, sit amet venenatis urna ullamcorper non. Proin fermentum malesuada tortor, vitae mattis sem scelerisque in. Curabitur rutrum leo at mi efficitur suscipit. Vivamus tristique lorem eros, sit amet malesuada augue sodales sed.',NULL,'page','article',0,1,2,1669899308,1670137823,0,0,0,'',''),(5,3,'معلومات عنا','معلومات عنا','','معلومات عنا','about us','','index,follow','','','',NULL,'page','article',0,1,2,1669899308,1669899308,0,0,0,NULL,NULL),(5,4,'เกี่ยวกับเรา','เกี่ยวกับเรา','','About us','about-us','','index,follow','','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque fringilla vel est at rhoncus. Cras porttitor ligula vel magna vehicula accumsan. Mauris eget elit et sem commodo interdum. Aenean dolor sem, tincidunt ac neque tempus, hendrerit blandit lacus. Vivamus placerat nulla in mi tristique, fringilla fermentum nisl vehicula. Nullam quis eros non magna tincidunt interdum ac eu eros. Morbi malesuada pulvinar ultrices. Etiam bibendum efficitur risus, sit amet venenatis urna ullamcorper non. Proin fermentum malesuada tortor, vitae mattis sem scelerisque in. Curabitur rutrum leo at mi efficitur suscipit. Vivamus tristique lorem eros, sit amet malesuada augue sodales sed.',NULL,'page','article',0,1,2,1669899308,1670137823,0,0,0,'',''),(6,1,'Recherche','Recherche','','Recherche','search','','noindex,nofollow','','','',NULL,'search','',0,1,14,1669899308,1669899308,0,0,1,NULL,NULL),(6,2,'Search','Search','','Search','search','','noindex,nofollow','','','',NULL,'search','',0,1,14,1669899308,1669899308,0,0,1,NULL,NULL),(6,3,'بحث','بحث','','بحث','search','','noindex,nofollow','','','',NULL,'search','',0,1,14,1669899308,1669899308,0,0,1,NULL,NULL),(6,4,'Search','Search','','Search','search','','noindex,nofollow','','','',NULL,'search','',0,1,14,1669899308,1669899308,0,0,1,NULL,NULL),(7,1,'Galerie','Galerie','','Galerie','galerie','','index,follow','','','',NULL,'page','gallery',0,1,5,1669899308,1669899308,0,0,0,NULL,NULL),(7,2,'Gallery','Gallery','','Gallery','gallery','','index,follow','','','',NULL,'page','gallery',0,1,5,1669899308,1669899308,0,0,0,NULL,NULL),(7,3,'صور معرض','صور معرض','','صور معرض','gallery','','index,follow','','','',NULL,'page','gallery',0,1,5,1669899308,1669899308,0,0,0,NULL,NULL),(7,4,'Gallery','Gallery','','Gallery','gallery','','index,follow','','','',NULL,'page','gallery',0,1,5,1669899308,1669899308,0,0,0,NULL,NULL),(8,1,'404','Erreur 404 : Page introuvable !','','404 Page introuvable','404','','noindex,nofollow','','','L\'URL demandée n\'a pas été trouvée sur ce serveur. \r\nLa page que vous voulez afficher n\'existe pas, ou est temporairement indisponible.\r\n\r\nMerci d\'essayer les actions suivantes :\r\n\r\n<ul>\r\n <li>Assurez-vous que l\'URL dans la barre d\'adresse de votre navigateur est correctement orthographiée et formatée.</li>\r\n <li>Si vous avez atteint cette page en cliquant sur un lien ou si vous pensez que cela concerne une erreur du serveur, contactez l\'administrateur pour l\'alerter.</li>\r\n</ul>\r\n',NULL,'404','',0,1,15,1669899308,1669899308,0,0,1,NULL,NULL),(8,2,'404','404 Error: Page not found!','','404 Not Found','404','','noindex,nofollow','','','The wanted URL was not found on this server. \r\nThe page you wish to display does not exist, or is temporarily unavailable.\r\n\r\nThank you for trying the following actions :\r\n\r\n<ul>\r\n <li>Be sure the URL in the address bar of your browser is correctly spelt and formated.</li>\r\n <li>If you reached this page by clicking a link or if you think that it is about an error of the server, contact the administrator to alert him.</li>\r\n</ul>\r\n',NULL,'404','',0,1,15,1669899308,1669899308,0,0,1,NULL,NULL),(8,3,'404','404 Error: Page not found!','','404 Not Found','404','','noindex,nofollow','','','',NULL,'404','',0,1,15,1669899308,1669899308,0,0,1,NULL,NULL),(8,4,'404','404 Error: Page not found!','','404 Not Found','404','','noindex,nofollow','','','The wanted URL was not found on this server. \r\nThe page you wish to display does not exist, or is temporarily unavailable.\r\n\r\nThank you for trying the following actions :\r\n\r\n<ul>\r\n <li>Be sure the URL in the address bar of your browser is correctly spelt and formated.</li>\r\n <li>If you reached this page by clicking a link or if you think that it is about an error of the server, contact the administrator to alert him.</li>\r\n</ul>\r\n',NULL,'404','',0,1,15,1669899308,1669899308,0,0,1,NULL,NULL),(9,1,'Hôtels','Hôtels','','Hôtels','hotels','','index,follow','','','',NULL,'hotels','hotel',0,1,3,1669899308,1669899308,0,0,1,NULL,NULL),(9,2,'Hotels','Hotels','','Hotels','hotels','','index,follow','','','',NULL,'hotels','hotel',0,1,3,1669899308,1669899308,0,0,1,NULL,NULL),(9,3,'الفنادق','الفنادق','','الفنادق','hotels','','index,follow','','','',NULL,'hotels','hotel',0,1,3,1669899308,1669899308,0,0,1,NULL,NULL),(9,4,'Hotels','Hotels','','Hotels','hotels','','index,follow','','','',NULL,'hotels','hotel',0,1,3,1669899308,1669899308,0,0,1,NULL,NULL),(10,1,'Réserver','Réserver','','Réserver','reserver','','index,nofollow','','','',NULL,'booking','booking',0,1,6,1669899308,1669899308,0,0,1,NULL,NULL),(10,2,'Booking','Booking','','Booking','booking','','index,nofollow','','','',NULL,'booking','booking',0,1,6,1669899308,1670153140,0,0,1,'',''),(10,3,'الحجز','الحجز','','الحجز','booking','','index,nofollow','','','',NULL,'booking','booking',0,1,6,1669899308,1669899308,0,0,1,NULL,NULL),(10,4,'การจอง','การจอง','','Booking','booking','','index,nofollow','','','',NULL,'booking','booking',0,1,6,1669899308,1670153140,0,0,1,'',''),(11,1,'Coordonnées','Coordonnées','','Coordonnées','coordonnees','','noindex,nofollow','','','',10,'details','',0,1,8,1669899308,1669899308,0,0,1,NULL,NULL),(11,2,'Details','Booking details','','Booking details','booking-details','','noindex,nofollow','','','',10,'details','',0,1,8,1669899308,1670153205,0,0,1,'',''),(11,3,'تفاصيل الحجز','تفاصيل الحجز','','تفاصيل الحجز','booking-details','','noindex,nofollow','','','',10,'details','',0,1,8,1669899308,1669899308,0,0,1,NULL,NULL),(11,4,'รายละเอียด','รายละเอียดการจอง','','Booking details','booking-details','','noindex,nofollow','','','',10,'details','',0,1,8,1669899308,1670153205,0,0,1,'',''),(12,1,'Paiement','Paiement','','Paiement','paiement','','noindex,nofollow','','','',13,'payment','',0,1,10,1669899308,1669899308,0,0,1,NULL,NULL),(12,2,'Payment','Payment','','Payment','payment','','noindex,nofollow','','','',13,'payment','',0,1,10,1669899308,1670153233,0,0,1,'',''),(12,3,'دفع','دفع','','دفع','payment','','noindex,nofollow','','','',13,'payment','',0,1,10,1669899308,1669899308,0,0,1,NULL,NULL),(12,4,'การชำระเงิน','การชำระเงิน','','Payment','payment','','noindex,nofollow','','','',13,'payment','',0,1,10,1669899308,1670153233,0,0,1,'',''),(13,1,'Résumé de la réservation','Résumé de la réservation','','Résumé de la réservation','resume-reservation','','noindex,nofollow','','','',11,'summary','',0,1,9,1669899308,1669899308,0,0,1,NULL,NULL),(13,2,'Summary','Booking summary','','Booking summary','booking-summary','','noindex,nofollow','','','',11,'summary','',0,1,9,1669899308,1670153264,0,0,1,'',''),(13,3,'ملخص الحجز','ملخص الحجز','','ملخص الحجز','booking-summary','','noindex,nofollow','','','',11,'summary','',0,1,9,1669899308,1669899308,0,0,1,NULL,NULL),(13,4,'สรุปรายการ','สรุปรายการจอง','','Booking summary','booking-summary','','noindex,nofollow','','','',11,'summary','',0,1,9,1669899308,1670153264,0,0,1,'',''),(14,1,'Espace client','Espace client','','Espace client','espace-client','','noindex,nofollow','','','',NULL,'account','',0,1,16,1669899308,1669899308,0,0,1,NULL,NULL),(14,2,'Account','Account','','Account','account','','noindex,nofollow','','','',NULL,'account','',0,1,16,1669899308,1670153608,0,0,1,'',''),(14,3,'Account','Account','','Account','account','','noindex,nofollow','','','',NULL,'account','',0,1,16,1669899308,1669899308,0,0,1,NULL,NULL),(14,4,'บัญชี','บัญชี','','Account','account','','noindex,nofollow','','','',NULL,'account','',0,1,16,1669899308,1670153608,0,0,1,'',''),(15,1,'Activités','Activités','','Activités','reservation-activitees','','noindex,nofollow','','','',10,'booking-activities','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL),(15,2,'Activities','Activities','','Activities','booking-activities','','noindex,nofollow','','','',10,'booking-activities','',0,1,7,1669899308,1670153178,0,0,1,'',''),(15,3,'Activities','Activities','','Activities','booking-activities','','noindex,nofollow','','','',10,'booking-activities','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL),(15,4,'กิจกรรม','กิจกรรม','','Activities','booking-activities','','noindex,nofollow','','','',10,'booking-activities','',0,1,7,1669899308,1670153178,0,0,1,'',''),(16,1,'Activités','Activités','','Activités','activitees','','index,follow','','','',NULL,'activities','activity',1,1,4,1669899308,1669899308,0,0,1,NULL,NULL),(16,2,'Activities','Activities','','Activities','activities','','index,follow','','','',NULL,'home','activity',1,1,4,1669899308,1670133798,0,0,1,'',''),(16,3,'Activities','Activities','','Activities','activities','','index,follow','','','',NULL,'activities','activity',1,1,4,1669899308,1669899308,0,0,1,NULL,NULL),(16,4,'กิจกรรม','กิจกรรม','','Activities','activities','','index,follow','','','',NULL,'home','activity',1,1,4,1669899308,1670133798,0,0,1,'',''),(17,1,'Blog','Blog','','Blog','blog','','index,follow','','','',NULL,'blog','article-blog',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(17,2,'Blog','Blog','','Blog','blog','','index,follow','','','',NULL,'blog','article-blog',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(17,3,'مدونة','مدونة','','مدونة','blog','','index,follow','','','',NULL,'blog','article-blog',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(17,4,'Blog','Blog','','Blog','blog','','index,follow','','','',NULL,'blog','article-blog',0,1,12,1669899308,1669899308,0,0,0,NULL,NULL),(18,1,'Destinations','Destinations','','Destinations','destinations','','index,follow','','','',NULL,'destinations','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL),(18,2,'Destinations','Destinations','','Destinations','destinations','','index,follow','','','',NULL,'destinations','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL),(18,3,'وجهات','وجهات','','وجهات','destinations','','index,follow','','','',NULL,'destinations','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL),(18,4,'Destinations','Destinations','','Destinations','destinations','','index,follow','','','',NULL,'destinations','',0,1,7,1669899308,1669899308,0,0,1,NULL,NULL);
/*!40000 ALTER TABLE `pm_page` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_page_file`
--

DROP TABLE IF EXISTS `pm_page_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_page_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `page_file_fkey` (`id_item`,`lang`),
  KEY `page_file_lang_fkey` (`lang`),
  CONSTRAINT `page_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_page` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `page_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_page_file`
--

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

--
-- Table structure for table `pm_popup`
--

DROP TABLE IF EXISTS `pm_popup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_popup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `allpages` text DEFAULT NULL,
  `pages` text DEFAULT NULL,
  `background` varchar(20) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `publish_date` int(11) DEFAULT NULL,
  `unpublish_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `popup_lang_fkey` (`lang`),
  CONSTRAINT `popup_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_popup`
--

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

--
-- Table structure for table `pm_rate`
--

DROP TABLE IF EXISTS `pm_rate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_rate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_room` int(11) NOT NULL,
  `id_hotel` int(11) DEFAULT NULL,
  `id_package` int(11) NOT NULL,
  `users` text DEFAULT NULL,
  `start_date` int(11) DEFAULT NULL,
  `end_date` int(11) DEFAULT NULL,
  `price` double DEFAULT 0,
  `child_price` double DEFAULT 0,
  `discount` double DEFAULT 0,
  `discount_type` varchar(10) DEFAULT 'rate',
  `people` int(11) DEFAULT NULL,
  `price_sup` double DEFAULT NULL,
  `fixed_sup` double DEFAULT NULL,
  `id_tax` int(11) DEFAULT NULL,
  `taxes` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rate_room_fkey` (`id_room`),
  CONSTRAINT `rate_room_fkey` FOREIGN KEY (`id_room`) REFERENCES `pm_room` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_rate`
--

LOCK TABLES `pm_rate` WRITE;
/*!40000 ALTER TABLE `pm_rate` DISABLE KEYS */;
INSERT INTO `pm_rate` VALUES (1,1,1,2,'1',1669852800,1672444800,4000,500,0,'rate',2,1500,0,1,'1');
/*!40000 ALTER TABLE `pm_rate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_rate_child`
--

DROP TABLE IF EXISTS `pm_rate_child`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_rate_child` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_rate` int(11) NOT NULL,
  `min_age` int(11) DEFAULT NULL,
  `max_age` int(11) DEFAULT NULL,
  `price` double DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `rate_child_fkey` (`id_rate`),
  CONSTRAINT `rate_child_fkey` FOREIGN KEY (`id_rate`) REFERENCES `pm_rate` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_rate_child`
--

LOCK TABLES `pm_rate_child` WRITE;
/*!40000 ALTER TABLE `pm_rate_child` DISABLE KEYS */;
INSERT INTO `pm_rate_child` VALUES (1,1,10,15,500);
/*!40000 ALTER TABLE `pm_rate_child` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_room`
--

DROP TABLE IF EXISTS `pm_room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_hotel` int(11) NOT NULL,
  `users` text DEFAULT NULL,
  `max_children` int(11) DEFAULT 1,
  `max_adults` int(11) DEFAULT 1,
  `max_people` int(11) DEFAULT NULL,
  `min_people` int(11) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `descr` longtext DEFAULT NULL,
  `facilities` text DEFAULT NULL,
  `stock` int(11) DEFAULT 1,
  `price` double DEFAULT 0,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  `start_lock` int(11) DEFAULT NULL,
  `end_lock` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `room_lang_fkey` (`lang`),
  KEY `room_hotel_fkey` (`id_hotel`,`lang`),
  CONSTRAINT `room_hotel_fkey` FOREIGN KEY (`id_hotel`, `lang`) REFERENCES `pm_hotel` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `room_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_room`
--

LOCK TABLES `pm_room` WRITE;
/*!40000 ALTER TABLE `pm_room` DISABLE KEYS */;
INSERT INTO `pm_room` VALUES (1,1,1,'1',2,2,2,1,'Chambre Double Deluxe','Petit-déjeuner inclus','chambre-double-deluxe','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut eleifend diam. Etiam molestie quam at nunc tempus, ac porttitor ante rutrum. Donec ipsum orci, molestie sit amet nibh a, accumsan varius nisl. Suspendisse blandit efficitur interdum. Nulla auctor tortor eu volutpat imperdiet. Nam at tempus sapien, sit amet porttitor neque. Nam lacinia ex libero, vel egestas ante vehicula nec.\r\n\r\nSed sed dignissim est. Donec egestas nisl eu congue rhoncus. Nulla finibus malesuada mauris, et pellentesque diam scelerisque non. Duis auctor dapibus augue sed malesuada. Nam placerat at libero quis aliquam. Phasellus quam orci, dapibus sit amet finibus a, convallis volutpat arcu. Nullam condimentum quam id urna scelerisque varius. Duis a metus metus.\r\n','1,5,11,13,17,18,21,23,24,25,27,28,29,32',4,145,1,1,1,NULL,NULL),(1,2,1,'1',1,2,10,1,'Deluxe Double Bedroom','Breakfast included','deluxe-double-bedroom','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut eleifend diam. Etiam molestie quam at nunc tempus, ac porttitor ante rutrum. Donec ipsum orci, molestie sit amet nibh a, accumsan varius nisl. Suspendisse blandit efficitur interdum. Nulla auctor tortor eu volutpat imperdiet. Nam at tempus sapien, sit amet porttitor neque. Nam lacinia ex libero, vel egestas ante vehicula nec.Sed sed dignissim est. Donec egestas nisl eu congue rhoncus. Nulla finibus malesuada mauris, et pellentesque diam scelerisque non. Duis auctor dapibus augue sed malesuada. Nam placerat at libero quis aliquam. Phasellus quam orci, dapibus sit amet finibus a, convallis volutpat arcu. Nullam condimentum quam id urna scelerisque varius. Duis a metus metus.','1,5,11,13,17,18,21,23,24,25,27,28,29,32',4,5000,1,1,1,NULL,NULL),(1,3,1,'1',2,2,2,1,'Deluxe Double Bedroom','Breakfast included','deluxe-double-bedroom','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut eleifend diam. Etiam molestie quam at nunc tempus, ac porttitor ante rutrum. Donec ipsum orci, molestie sit amet nibh a, accumsan varius nisl. Suspendisse blandit efficitur interdum. Nulla auctor tortor eu volutpat imperdiet. Nam at tempus sapien, sit amet porttitor neque. Nam lacinia ex libero, vel egestas ante vehicula nec.\r\n\r\nSed sed dignissim est. Donec egestas nisl eu congue rhoncus. Nulla finibus malesuada mauris, et pellentesque diam scelerisque non. Duis auctor dapibus augue sed malesuada. Nam placerat at libero quis aliquam. Phasellus quam orci, dapibus sit amet finibus a, convallis volutpat arcu. Nullam condimentum quam id urna scelerisque varius. Duis a metus metus.\r\n','1,5,11,13,17,18,21,23,24,25,27,28,29,32',4,145,1,1,1,NULL,NULL),(1,4,1,'1',1,2,10,1,'Deluxe Double Bedroom','Breakfast included','deluxe-double-bedroom','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut eleifend diam. Etiam molestie quam at nunc tempus, ac porttitor ante rutrum. Donec ipsum orci, molestie sit amet nibh a, accumsan varius nisl. Suspendisse blandit efficitur interdum. Nulla auctor tortor eu volutpat imperdiet. Nam at tempus sapien, sit amet porttitor neque. Nam lacinia ex libero, vel egestas ante vehicula nec.Sed sed dignissim est. Donec egestas nisl eu congue rhoncus. Nulla finibus malesuada mauris, et pellentesque diam scelerisque non. Duis auctor dapibus augue sed malesuada. Nam placerat at libero quis aliquam. Phasellus quam orci, dapibus sit amet finibus a, convallis volutpat arcu. Nullam condimentum quam id urna scelerisque varius. Duis a metus metus.','1,5,11,13,17,18,21,23,24,25,27,28,29,32',4,5000,1,1,1,NULL,NULL);
/*!40000 ALTER TABLE `pm_room` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_room_calendar`
--

DROP TABLE IF EXISTS `pm_room_calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_room_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_room` int(11) NOT NULL,
  `title` varchar(150) DEFAULT NULL,
  `latest_sync` int(11) DEFAULT NULL,
  `url` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `room_calendar_fkey` (`id_room`),
  CONSTRAINT `room_calendar_fkey` FOREIGN KEY (`id_room`) REFERENCES `pm_room` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_room_calendar`
--

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

--
-- Table structure for table `pm_room_closing`
--

DROP TABLE IF EXISTS `pm_room_closing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_room_closing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_room` int(11) NOT NULL,
  `from_date` int(11) DEFAULT NULL,
  `to_date` int(11) DEFAULT NULL,
  `stock` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `room_closing_fkey` (`id_room`),
  CONSTRAINT `room_closing_fkey` FOREIGN KEY (`id_room`) REFERENCES `pm_room` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_room_closing`
--

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

--
-- Table structure for table `pm_room_file`
--

DROP TABLE IF EXISTS `pm_room_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_room_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `room_file_fkey` (`id_item`,`lang`),
  KEY `room_file_lang_fkey` (`lang`),
  CONSTRAINT `room_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_room` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `room_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_room_file`
--

LOCK TABLES `pm_room_file` WRITE;
/*!40000 ALTER TABLE `pm_room_file` DISABLE KEYS */;
INSERT INTO `pm_room_file` VALUES (1,1,1,0,1,1,'deluxe-double-room.jpg','','image'),(1,2,1,0,1,1,'deluxe-double-room.jpg','','image'),(1,3,1,0,1,1,'deluxe-double-room.jpg','','image'),(1,4,1,0,1,1,'deluxe-double-room.jpg','','image');
/*!40000 ALTER TABLE `pm_room_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_room_lock`
--

DROP TABLE IF EXISTS `pm_room_lock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_room_lock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_room` int(11) DEFAULT NULL,
  `from_date` int(11) DEFAULT NULL,
  `to_date` int(11) DEFAULT NULL,
  `add_date` int(11) DEFAULT NULL,
  `sessid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `room_lock_fkey` (`id_room`),
  CONSTRAINT `room_lock_fkey` FOREIGN KEY (`id_room`) REFERENCES `pm_room` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_room_lock`
--

LOCK TABLES `pm_room_lock` WRITE;
/*!40000 ALTER TABLE `pm_room_lock` DISABLE KEYS */;
INSERT INTO `pm_room_lock` VALUES (5,1,1670112000,1670198400,1670152846,'638c828eca3d5'),(6,1,1670112000,1670198400,1670153292,'638c844c034fc'),(7,1,1670112000,1670198400,1670153996,'638c870cb24d9');
/*!40000 ALTER TABLE `pm_room_lock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_service`
--

DROP TABLE IF EXISTS `pm_service`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `users` text DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `descr` text DEFAULT NULL,
  `long_descr` text DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `rooms` varchar(250) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `id_tax` int(11) DEFAULT NULL,
  `taxes` text DEFAULT NULL,
  `mandatory` int(11) DEFAULT 0,
  `start_date` int(11) DEFAULT NULL,
  `end_date` int(11) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `service_lang_fkey` (`lang`),
  CONSTRAINT `service_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_service`
--

LOCK TABLES `pm_service` WRITE;
/*!40000 ALTER TABLE `pm_service` DISABLE KEYS */;
INSERT INTO `pm_service` VALUES (1,1,'1','Set de toilette','1 serviette de toilette, 1 drap de douche, 1 tapis','','qty-night','4,1,3,2',7,1,'',0,NULL,NULL,1,1),(1,2,'1','Rent of towel (kit)','1 hand towel, 1 bath towel, 1 bath mat','','qty-night','1',7,1,'',0,NULL,NULL,1,1),(1,3,'1','Rent of towel (kit)','1 hand towel, 1 bath towel, 1 bath mat','','qty-night','4,1,3,2',7,1,'',0,NULL,NULL,1,1),(1,4,'1','เช่าผ้าขนหนู (ชุด)','ผ้าเช็ดมือ 1 ผืน, ผ้าขนหนูอาบน้ำ 1 ผืน, พรมเช็ดเท้า 1 ผืน','','qty-night','1',7,1,'',0,NULL,NULL,1,1),(2,1,'1','Ménage','','','package','1,3,2',50,1,'',0,NULL,NULL,1,2),(2,2,'1','Housework','','','package','1',50,1,'',0,NULL,NULL,1,2),(2,3,'1','Housework','','','package','1,3,2',50,1,'',0,NULL,NULL,1,2),(2,4,'1','งานบ้าน','','','package','1',50,1,'',0,NULL,NULL,1,2),(3,1,'1','Chauffage','','','night','1,3,2',8,1,'',0,NULL,NULL,1,3),(3,2,'1','Heating','','','night','1',8,1,'',0,NULL,NULL,1,3),(3,3,'1','Heating','','','night','1,3,2',8,1,'',0,NULL,NULL,1,3),(3,4,'1','เครื่องทำความร้อน','','','night','1',8,1,'',0,NULL,NULL,1,3),(4,1,'1','Animal domestique','Précisez la race ci-dessous','','qty-night','4,1,3,2',5,1,'',0,NULL,NULL,1,4),(4,2,'1','Pet','Specify the breed below','','qty-night','1',5,1,'',0,NULL,NULL,1,4),(4,3,'1','Pet','Specify the breed below','','qty-night','4,1,3,2',5,1,'',0,NULL,NULL,1,4),(4,4,'1','สัตว์เลี้ยง','ระบุสายพันธุ์ด้านล่าง','','qty-night','1',5,1,'',0,NULL,NULL,1,4);
/*!40000 ALTER TABLE `pm_service` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_slide`
--

DROP TABLE IF EXISTS `pm_slide`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `legend` text DEFAULT NULL,
  `url` varchar(250) DEFAULT NULL,
  `id_page` int(11) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `slide_lang_fkey` (`lang`),
  KEY `slide_page_fkey` (`id_page`,`lang`),
  CONSTRAINT `slide_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `slide_page_fkey` FOREIGN KEY (`id_page`, `lang`) REFERENCES `pm_page` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_slide`
--

LOCK TABLES `pm_slide` WRITE;
/*!40000 ALTER TABLE `pm_slide` DISABLE KEYS */;
INSERT INTO `pm_slide` VALUES (1,1,'','',1,1,2),(1,2,'<h1>Book your holydays with Panda Multi Resorts</h1>\r\n\r\n<h2>Fast, Easy and Powerfull</h2>\r\n','',1,1,2),(1,3,'','',1,1,2),(1,4,'<h1>Book your holydays with Panda Multi Resorts</h1>\r\n\r\n<h2>Fast, Easy and Powerfull</h2>\r\n','',1,1,2),(2,1,'','',1,1,3),(2,2,'<h1>A dream stay at the best price</h1>\r\n\r\n<h2>Best price guarantee</h2>\r\n','',1,1,3),(2,3,'','',1,1,3),(2,4,'<h1>A dream stay at the best price</h1>\r\n\r\n<h2>Best price guarantee</h2>\r\n','',1,1,3),(3,1,'','',1,1,1),(3,2,'<h1>Find Hotels, Activities and Tours</h1>\r\n\r\n<h2>Your whole vacation starts here</h2>\r\n','',1,1,1),(3,3,'','',1,1,1),(3,4,'<h1>Find Hotels, Activities and Tours</h1>\r\n\r\n<h2>Your whole vacation starts here</h2>\r\n','',1,1,1);
/*!40000 ALTER TABLE `pm_slide` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_slide_file`
--

DROP TABLE IF EXISTS `pm_slide_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_slide_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `id_item` int(11) NOT NULL,
  `home` int(11) DEFAULT 0,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  `file` varchar(250) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `slide_file_fkey` (`id_item`,`lang`),
  KEY `slide_file_lang_fkey` (`lang`),
  CONSTRAINT `slide_file_fkey` FOREIGN KEY (`id_item`, `lang`) REFERENCES `pm_slide` (`id`, `lang`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `slide_file_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_slide_file`
--

LOCK TABLES `pm_slide_file` WRITE;
/*!40000 ALTER TABLE `pm_slide_file` DISABLE KEYS */;
INSERT INTO `pm_slide_file` VALUES (3,1,1,0,1,2,'slide1.jpg','','image'),(3,2,1,0,1,2,'slide1.jpg','','image'),(3,3,1,0,1,2,'slide1.jpg','','image'),(3,4,1,0,1,2,'slide1.jpg','','image'),(4,1,2,0,1,3,'slide2.jpg','','image'),(4,2,2,0,1,3,'slide2.jpg','','image'),(4,3,2,0,1,3,'slide2.jpg','','image'),(4,4,2,0,1,3,'slide2.jpg','','image'),(6,1,3,0,1,4,'slide3.jpg','','image'),(6,2,3,0,1,4,'slide3.jpg','','image'),(6,3,3,0,1,4,'slide3.jpg','','image'),(6,4,3,0,1,4,'slide3.jpg','','image');
/*!40000 ALTER TABLE `pm_slide_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_social`
--

DROP TABLE IF EXISTS `pm_social`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL,
  `url` text DEFAULT NULL,
  `checked` int(11) DEFAULT 1,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_social`
--

LOCK TABLES `pm_social` WRITE;
/*!40000 ALTER TABLE `pm_social` DISABLE KEYS */;
INSERT INTO `pm_social` VALUES (1,'facebook','https://www.facebook.com/tchomtap',1,1),(2,'twitter','https://twitter.com/MrtanDev',1,2);
/*!40000 ALTER TABLE `pm_social` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_tag`
--

DROP TABLE IF EXISTS `pm_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `value` varchar(250) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `pages` varchar(250) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `tag_lang_fkey` (`lang`),
  CONSTRAINT `tag_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_tag`
--

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

--
-- Table structure for table `pm_tax`
--

DROP TABLE IF EXISTS `pm_tax`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_tax` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `value` double DEFAULT 0,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `tax_lang_fkey` (`lang`),
  CONSTRAINT `tax_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_tax`
--

LOCK TABLES `pm_tax` WRITE;
/*!40000 ALTER TABLE `pm_tax` DISABLE KEYS */;
INSERT INTO `pm_tax` VALUES (1,1,'TVA',10,1,1),(1,2,'VAT',7,1,1),(1,3,'VAT',10,1,1),(1,4,'ภาษีมูลค่าเพิ่ม',7,1,1);
/*!40000 ALTER TABLE `pm_tax` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_text`
--

DROP TABLE IF EXISTS `pm_text`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`,`lang`),
  KEY `text_lang_fkey` (`lang`),
  CONSTRAINT `text_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_text`
--

LOCK TABLES `pm_text` WRITE;
/*!40000 ALTER TABLE `pm_text` DISABLE KEYS */;
INSERT INTO `pm_text` VALUES (1,1,'CREATION','Création'),(1,2,'CREATION','Creation'),(1,3,'CREATION','إنشاء'),(1,4,'CREATION','การสร้าง'),(2,1,'MESSAGE','Message'),(2,2,'MESSAGE','Message'),(2,3,'MESSAGE','رسالة'),(2,4,'MESSAGE','ข้อความ'),(3,1,'EMAIL','E-mail'),(3,2,'EMAIL','E-mail'),(3,3,'EMAIL','بَرِيدٌ إلِكْترونيّ'),(3,4,'EMAIL','อีเมล'),(4,1,'PHONE','Tél.'),(4,2,'PHONE','Phone'),(4,3,'PHONE','رقم هاتف'),(4,4,'PHONE','โทรศัพท์'),(5,1,'FAX','Fax'),(5,2,'FAX','Fax'),(5,3,'FAX','فاكس'),(5,4,'FAX','แฟกซ์'),(6,1,'COMPANY','Société'),(6,2,'COMPANY','Company'),(6,3,'COMPANY','مشروع'),(6,4,'COMPANY','บริษัท'),(7,1,'COPY_CODE','Recopiez le code'),(7,2,'COPY_CODE','Copy the code'),(7,3,'COPY_CODE','رمز الأمان'),(7,4,'COPY_CODE','คัดลอกรหัส'),(8,1,'SUBJECT','Sujet'),(8,2,'SUBJECT','Subject'),(8,3,'SUBJECT','موضوع'),(8,4,'SUBJECT','เรื่อง'),(9,1,'REQUIRED_FIELD','Champ requis'),(9,2,'REQUIRED_FIELD','Required field'),(9,3,'REQUIRED_FIELD','الحقل المطلوب'),(9,4,'REQUIRED_FIELD','* ฟิลด์บังคับ'),(10,1,'INVALID_CAPTCHA_CODE','Le code de sécurité saisi est incorrect'),(10,2,'INVALID_CAPTCHA_CODE','Invalid security code'),(10,3,'INVALID_CAPTCHA_CODE','رمز الحماية أدخلته غير صحيح'),(10,4,'INVALID_CAPTCHA_CODE','รหัสความปลอดภัยไม่ถูกต้อง'),(11,1,'INVALID_EMAIL','Adresse e-mail invalide'),(11,2,'INVALID_EMAIL','Invalid email address'),(11,3,'INVALID_EMAIL','بريد إلكتروني خاطئ'),(11,4,'INVALID_EMAIL','ที่อยู่อีเมลที่ไม่ถูกต้อง'),(12,1,'FIRSTNAME','Prénom'),(12,2,'FIRSTNAME','Firstname'),(12,3,'FIRSTNAME','الاسم الأول'),(12,4,'FIRSTNAME','ชื่อจริง'),(13,1,'LASTNAME','Nom'),(13,2,'LASTNAME','Lastname'),(13,3,'LASTNAME','اسم العائلة'),(13,4,'LASTNAME','นามสกุล'),(14,1,'ADDRESS','Adresse'),(14,2,'ADDRESS','Address'),(14,3,'ADDRESS','عنوان الشارع'),(14,4,'ADDRESS','ที่อยู่'),(15,1,'POSTCODE','Code postal'),(15,2,'POSTCODE','Post code'),(15,3,'POSTCODE','الرمز البريدي'),(15,4,'POSTCODE','รหัสไปรษณีย์'),(16,1,'CITY','Ville'),(16,2,'CITY','City'),(16,3,'CITY','مدينة'),(16,4,'CITY','จังหวัด'),(17,1,'MOBILE','Portable'),(17,2,'MOBILE','Mobile'),(17,3,'MOBILE','هاتف'),(17,4,'MOBILE','มือถือ'),(18,1,'ADD','Ajouter'),(18,2,'ADD','Add'),(18,3,'ADD','إضافة على'),(18,4,'ADD','เพิ่ม'),(19,1,'EDIT','Modifier'),(19,2,'EDIT','Edit'),(19,3,'EDIT','تغيير'),(19,4,'EDIT','แก้ไข'),(20,1,'INVALID_INPUT','Saisie invalide'),(20,2,'INVALID_INPUT','Invalid input'),(20,3,'INVALID_INPUT','إدخال غير صالح'),(20,4,'INVALID_INPUT','อินพุตไม่ถูกต้อง'),(21,1,'MAIL_DELIVERY_FAILURE','Echec lors de l\'envoi du message.'),(21,2,'MAIL_DELIVERY_FAILURE','A failure occurred during the delivery of this message.'),(21,3,'MAIL_DELIVERY_FAILURE','حدث فشل أثناء تسليم هذه الرسالة.'),(21,4,'MAIL_DELIVERY_FAILURE','เกิดความล้มเหลวระหว่างการส่งข้อความนี้'),(22,1,'MAIL_DELIVERY_SUCCESS','Merci de votre intérêt, votre message a bien été envoyé.\nNous vous contacterons dans les plus brefs délais.'),(22,2,'MAIL_DELIVERY_SUCCESS','Thank you for your interest, your message has been sent.\nWe will contact you as soon as possible.'),(22,3,'MAIL_DELIVERY_SUCCESS','خزان لاهتمامك ، تم إرسال رسالتك . سوف نتصل بك في أقرب وقت ممكن .'),(22,4,'MAIL_DELIVERY_SUCCESS','ขอบคุณที่ให้ความสนใจ ข้อความของคุณถูกส่งไปแล้ว\nเราจะติดต่อคุณโดยเร็วที่สุด'),(23,1,'SEND','Envoyer'),(23,2,'SEND','Send'),(23,3,'SEND','ارسل انت'),(23,4,'SEND','ส่ง'),(24,1,'FORM_ERRORS','Le formulaire comporte des erreurs.'),(24,2,'FORM_ERRORS','The following form contains some errors.'),(24,3,'FORM_ERRORS','النموذج التالي يحتوي على بعض الأخطاء.'),(24,4,'FORM_ERRORS','แบบฟอร์มต่อไปนี้มีข้อผิดพลาดบางประการ'),(25,1,'FROM_DATE','Du'),(25,2,'FROM_DATE','From'),(25,3,'FROM_DATE','من'),(25,4,'FROM_DATE','จาก'),(26,1,'TO_DATE','au'),(26,2,'TO_DATE','till'),(26,3,'TO_DATE','حتى'),(26,4,'TO_DATE','จนถึง'),(27,1,'FROM','De'),(27,2,'FROM','From'),(27,3,'FROM','من'),(27,4,'FROM','จาก'),(28,1,'TO','à'),(28,2,'TO','to'),(28,3,'TO','إلى'),(28,4,'TO','ถึง'),(29,1,'BOOK','Réserver'),(29,2,'BOOK','Book'),(29,3,'BOOK','للحجز'),(29,4,'BOOK','จอง'),(30,1,'READMORE','Lire la suite'),(30,2,'READMORE','Read more'),(30,3,'READMORE','اقرأ المزيد'),(30,4,'READMORE','อ่านเพิ่มเติม'),(31,1,'BACK','Retour'),(31,2,'BACK','Back'),(31,3,'BACK','عودة'),(31,4,'BACK','กลับ'),(32,1,'DISCOVER','Découvrir'),(32,2,'DISCOVER','Discover'),(32,3,'DISCOVER','اكتشف'),(32,4,'DISCOVER','ค้นพบ'),(33,1,'ALL','Tous'),(33,2,'ALL','All'),(33,3,'ALL','كل'),(33,4,'ALL','ทั้งหมด'),(34,1,'ALL_RIGHTS_RESERVED','Tous droits réservés'),(34,2,'ALL_RIGHTS_RESERVED','All rights reserved'),(34,3,'ALL_RIGHTS_RESERVED','جميع الحقوق محفوظه'),(34,4,'ALL_RIGHTS_RESERVED','สงวนลิขสิทธิ์'),(35,1,'FORGOTTEN_PASSWORD','Mot de passe oublié ?'),(35,2,'FORGOTTEN_PASSWORD','Forgotten password?'),(35,3,'FORGOTTEN_PASSWORD','هل نسيت كلمة المرور؟'),(35,4,'FORGOTTEN_PASSWORD','ลืมรหัสผ่าน?'),(36,1,'LOG_IN','Connexion'),(36,2,'LOG_IN','Log in'),(36,3,'LOG_IN','تسجيل الدخول'),(36,4,'LOG_IN','เข้าสู่ระบบ'),(37,1,'SIGN_UP','Inscription'),(37,2,'SIGN_UP','Sign up'),(37,3,'SIGN_UP','تسجيل'),(37,4,'SIGN_UP','ลงชื่อ'),(38,1,'LOG_OUT','Déconnexion'),(38,2,'LOG_OUT','Log out'),(38,3,'LOG_OUT','تسجيل الخروج'),(38,4,'LOG_OUT','ออกจากระบบ'),(39,1,'SEARCH','Rechercher'),(39,2,'SEARCH','Search'),(39,3,'SEARCH','ابحث عن'),(39,4,'SEARCH','ค้นหา'),(40,1,'RESET_PASS_SUCCESS','Votre nouveau mot de passe vous a été envoyé sur votre adresse e-mail.'),(40,2,'RESET_PASS_SUCCESS','Your new password was sent to you on your e-mail.'),(40,3,'RESET_PASS_SUCCESS','تم إرسال كلمة المرور الجديدة إلى عنوان البريد الإلكتروني الخاص بك'),(40,4,'RESET_PASS_SUCCESS','รหัสผ่านใหม่ของคุณถูกส่งถึงคุณทางอีเมลของคุณ'),(41,1,'PASS_TOO_SHORT','Le mot de passe doit contenir 6 caractères au minimum'),(41,2,'PASS_TOO_SHORT','The password must contain 6 characters at least'),(41,3,'PASS_TOO_SHORT','يجب أن يحتوي على كلمة المرور ستة أحرف على الأقل'),(41,4,'PASS_TOO_SHORT','รหัสผ่านต้องมีอักขระอย่างน้อย 6 ตัว'),(42,1,'PASS_DONT_MATCH','Les mots de passe doivent correspondre'),(42,2,'PASS_DONT_MATCH','The passwords don\'t match'),(42,3,'PASS_DONT_MATCH','يجب أن تتطابق كلمات المرور'),(42,4,'PASS_DONT_MATCH','รหัสผ่านไม่ตรงกัน'),(43,1,'ACCOUNT_EXISTS','Un compte existe déjà avec cette adresse e-mail'),(43,2,'ACCOUNT_EXISTS','An account already exists with this e-mail'),(43,3,'ACCOUNT_EXISTS','حساب موجود بالفعل مع هذا عنوان البريد الإلكتروني'),(43,4,'ACCOUNT_EXISTS','มีบัญชีอยู่แล้วกับอีเมลนี้'),(44,1,'ACCOUNT_CREATED','Votre compte a bien été créé. Vous allez recevoir un email de confirmation. Cliquez sur le lien de cet e-mail pour confirmer votre compte avant de continuer.'),(44,2,'ACCOUNT_CREATED','Your account has been created. You will receive a confirmation email. Click on the link in this email to confirm your account before continuing.'),(44,3,'ACCOUNT_CREATED','Your account has been created. You will receive a confirmation email. Click on the link in this email to confirm your account before continuing.'),(44,4,'ACCOUNT_CREATED','บัญชีของคุณถูกสร้างขึ้นแล้ว คุณจะได้รับอีเมลยืนยัน คลิกลิงก์ในอีเมลนี้เพื่อยืนยันบัญชีของคุณก่อนดำเนินการต่อ'),(45,1,'INCORRECT_LOGIN','Les informations de connexion sont incorrectes.'),(45,2,'INCORRECT_LOGIN','Incorrect login information.'),(45,3,'INCORRECT_LOGIN','معلومات تسجيل الدخول غير صحيحة.'),(45,4,'INCORRECT_LOGIN','ข้อมูลเข้าสู่ระบบไม่ถูกต้อง'),(46,1,'I_SIGN_UP','Je m\'inscris'),(46,2,'I_SIGN_UP','I sign up'),(46,3,'I_SIGN_UP','يمكنني الاشتراك'),(46,4,'I_SIGN_UP','ฉันลงทะเบียน'),(47,1,'ALREADY_HAVE_ACCOUNT','J\'ai déjà un compte'),(47,2,'ALREADY_HAVE_ACCOUNT','I already have an account'),(47,3,'ALREADY_HAVE_ACCOUNT','لدي بالفعل حساب'),(47,4,'ALREADY_HAVE_ACCOUNT','ฉันมีบัญชีอยู่แล้ว'),(48,1,'MY_ACCOUNT','Mon compte'),(48,2,'MY_ACCOUNT','My account'),(48,3,'MY_ACCOUNT','حسابي'),(48,4,'MY_ACCOUNT','บัญชีของฉัน'),(49,1,'COMMENTS','Commentaires'),(49,2,'COMMENTS','Comments'),(49,3,'COMMENTS','تعليقات'),(49,4,'COMMENTS','ความคิดเห็น'),(50,1,'LET_US_KNOW','Faîtes-nous savoir ce que vous pensez'),(50,2,'LET_US_KNOW','Let us know what you think'),(50,3,'LET_US_KNOW','ماذا عن رايك؟'),(50,4,'LET_US_KNOW','แจ้งให้เราทราบ ในสิ่งที่คุณคิด'),(51,1,'COMMENT_SUCCESS','Merci de votre intérêt, votre commentaire va être soumis à validation.'),(51,2,'COMMENT_SUCCESS','Thank you for your interest, your comment will be checked.'),(51,3,'COMMENT_SUCCESS','شكرا ل اهتمامك، و سيتم التحقق من صحة للتعليق.'),(51,4,'COMMENT_SUCCESS','ขอขอบคุณที่ให้ความสนใจ ความคิดเห็นของคุณจะถูกตรวจสอบ'),(52,1,'NO_SEARCH_RESULT','Aucun résultat. Vérifiez l\'orthographe des termes de recherche (> 3 caractères) ou essayez d\'autres mots.'),(52,2,'NO_SEARCH_RESULT','No result. Check the spelling terms of search (> 3 characters) or try other words.'),(52,3,'NO_SEARCH_RESULT','لا نتيجة. التدقيق الإملائي للكلمات (أكثر من ثلاثة أحرف ) أو محاولة بعبارة أخرى .'),(52,4,'NO_SEARCH_RESULT','ไม่มีผลลัพธ์. ตรวจสอบการสะกดคำที่ต้องการค้นหา (> 3 ตัวอักษร) หรือลองใช้คำอื่น'),(53,1,'SEARCH_EXCEEDED','Nombre de recherches dépassé.'),(53,2,'SEARCH_EXCEEDED','Number of researches exceeded.'),(53,3,'SEARCH_EXCEEDED','عدد من الأبحاث السابقة .'),(53,4,'SEARCH_EXCEEDED','จำนวนงานวิจัยเกิน'),(54,1,'SECONDS','secondes'),(54,2,'SECONDS','seconds'),(54,3,'SECONDS','ثواني'),(54,4,'SECONDS','วินาที'),(55,1,'FOR_A_TOTAL_OF','sur un total de'),(55,2,'FOR_A_TOTAL_OF','for a total of'),(55,3,'FOR_A_TOTAL_OF','من الكل'),(55,4,'FOR_A_TOTAL_OF','รวมเป็น'),(56,1,'COMMENT','Commentaire'),(56,2,'COMMENT','Comment'),(56,3,'COMMENT','تعقيب'),(56,4,'COMMENT','ความคิดเห็น'),(57,1,'VIEW','Visionner'),(57,2,'VIEW','View'),(57,3,'VIEW','ل عرض'),(57,4,'VIEW','ดู'),(58,1,'RECENT_ARTICLES','Articles récents'),(58,2,'RECENT_ARTICLES','Recent articles'),(58,3,'RECENT_ARTICLES','المقالات الأخيرة'),(58,4,'RECENT_ARTICLES','บทความล่าสุด'),(59,1,'RSS_FEED','Flux RSS'),(59,2,'RSS_FEED','RSS feed'),(59,3,'RSS_FEED','تغذية RSS'),(59,4,'RSS_FEED','ฟีด RSS'),(60,1,'COUNTRY','Pays'),(60,2,'COUNTRY','Country'),(60,3,'COUNTRY','Country'),(60,4,'COUNTRY','ประเทศ'),(61,1,'ROOM','Chambre'),(61,2,'ROOM','Room'),(61,3,'ROOM','Room'),(61,4,'ROOM','ห้อง'),(62,1,'INCL_VAT','TTC'),(62,2,'INCL_VAT','incl. VAT'),(62,3,'INCL_VAT','incl. VAT'),(62,4,'INCL_VAT','รวม ภาษีมูลค่าเพิ่ม'),(63,1,'NIGHTS','nuits'),(63,2,'NIGHTS','nights'),(63,3,'NIGHTS','nights'),(63,4,'NIGHTS','คืน'),(64,1,'ADULTS','Adultes'),(64,2,'ADULTS','Adults'),(64,3,'ADULTS','Adults'),(64,4,'ADULTS','ผู้ใหญ่'),(65,1,'CHILDREN','Enfants'),(65,2,'CHILDREN','Children'),(65,3,'CHILDREN','Children'),(65,4,'CHILDREN','เด็ก'),(66,1,'PERSONS','personnes'),(66,2,'PERSONS','persons'),(66,3,'PERSONS','persons'),(66,4,'PERSONS','คน'),(67,1,'CONTACT_DETAILS','Coordonnées'),(67,2,'CONTACT_DETAILS','Contact details'),(67,3,'CONTACT_DETAILS','Contact details'),(67,4,'CONTACT_DETAILS','รายละเอียดการติดต่อ'),(68,1,'NO_AVAILABILITY','Aucune disponibilité'),(68,2,'NO_AVAILABILITY','No availability'),(68,3,'NO_AVAILABILITY','No availability'),(68,4,'NO_AVAILABILITY','ไม่มีความพร้อม'),(69,1,'AVAILABILITIES','Disponibilités'),(69,2,'AVAILABILITIES','Availabilities'),(69,3,'AVAILABILITIES','Availabilities'),(69,4,'AVAILABILITIES','ความพร้อมใช้งาน'),(70,1,'CHECK','Vérifier'),(70,2,'CHECK','Check'),(70,3,'CHECK','Check'),(70,4,'CHECK','ตรวจสอบ'),(71,1,'BOOKING_DETAILS','Détails de la réservation'),(71,2,'BOOKING_DETAILS','Booking details'),(71,3,'BOOKING_DETAILS','Booking details'),(71,4,'BOOKING_DETAILS','รายละเอียดการจอง'),(72,1,'SPECIAL_REQUESTS','Demandes spéciales'),(72,2,'SPECIAL_REQUESTS','Special requests'),(72,3,'SPECIAL_REQUESTS','Special requests'),(72,4,'SPECIAL_REQUESTS','คำขอพิเศษ'),(73,1,'PREVIOUS_STEP','Étape précédente'),(73,2,'PREVIOUS_STEP','Previous step'),(73,3,'PREVIOUS_STEP','Previous step'),(73,4,'PREVIOUS_STEP','ขั้นตอนก่อนหน้า'),(74,1,'CONFIRM_BOOKING','Confirmer la réservation'),(74,2,'CONFIRM_BOOKING','Confirm the booking'),(74,3,'CONFIRM_BOOKING','Confirm the booking'),(74,4,'CONFIRM_BOOKING','ยืนยันการจอง'),(75,1,'ALSO_DISCOVER','Découvrez aussi'),(75,2,'ALSO_DISCOVER','Also discover'),(75,3,'ALSO_DISCOVER','Also discover'),(75,4,'ALSO_DISCOVER','นอกจากนี้ยังค้นพบ'),(76,1,'CHECK_PEOPLE','Merci de vérifier le nombre de personnes pour l\'hébergement choisi.'),(76,2,'CHECK_PEOPLE','Please verify the number of people for the chosen accommodation'),(76,3,'CHECK_PEOPLE','Please verify the number of people for the chosen accommodation'),(76,4,'CHECK_PEOPLE','โปรดตรวจสอบจำนวนผู้เข้าพักสำหรับที่พักที่เลือก'),(77,1,'BOOKING','Réservation'),(77,2,'BOOKING','Booking'),(77,3,'BOOKING','Booking'),(77,4,'BOOKING','การจอง'),(78,1,'NIGHT','nuit'),(78,2,'NIGHT','night'),(78,3,'NIGHT','night'),(78,4,'NIGHT','คืน'),(79,1,'WEEK','semaine'),(79,2,'WEEK','week'),(79,3,'WEEK','week'),(79,4,'WEEK','สัปดาห์'),(80,1,'EXTRA_SERVICES','Services supplémentaires'),(80,2,'EXTRA_SERVICES','Extra services'),(80,3,'EXTRA_SERVICES','Extra services'),(80,4,'EXTRA_SERVICES','บริการเสริม'),(81,1,'BOOKING_TERMS',''),(81,2,'BOOKING_TERMS',''),(81,3,'BOOKING_TERMS',''),(81,4,'BOOKING_TERMS','เงื่อนไขการจอง'),(82,1,'NEXT_STEP','Étape suivante'),(82,2,'NEXT_STEP','Next step'),(82,3,'NEXT_STEP','Next step'),(82,4,'NEXT_STEP','ขั้นตอนต่อไป'),(83,1,'TOURIST_TAX','Taxe de séjour'),(83,2,'TOURIST_TAX','Tourist tax'),(83,3,'TOURIST_TAX','Tourist tax'),(83,4,'TOURIST_TAX','ภาษีนักท่องเที่ยว'),(84,1,'CHECK_IN','Arrivée'),(84,2,'CHECK_IN','Check in'),(84,3,'CHECK_IN','Check in'),(84,4,'CHECK_IN','เช็คอิน'),(85,1,'CHECK_OUT','Départ'),(85,2,'CHECK_OUT','Check out'),(85,3,'CHECK_OUT','Check out'),(85,4,'CHECK_OUT','เช็คเอาท์'),(86,1,'TOTAL','Total'),(86,2,'TOTAL','Total'),(86,3,'TOTAL','Total'),(86,4,'TOTAL','ทั้งหมด'),(87,1,'CAPACITY','Capacité'),(87,2,'CAPACITY','Capacity'),(87,3,'CAPACITY','Capacity'),(87,4,'CAPACITY','ความจุ'),(88,1,'FACILITIES','Équipements'),(88,2,'FACILITIES','Facilities'),(88,3,'FACILITIES','Facilities'),(88,4,'FACILITIES','สิ่งอำนวยความสะดวก'),(89,1,'PRICE','Prix'),(89,2,'PRICE','Price'),(89,3,'PRICE','Price'),(89,4,'PRICE','ราคา'),(90,1,'MORE_DETAILS','Plus d\'infos'),(90,2,'MORE_DETAILS','More details'),(90,3,'MORE_DETAILS','More details'),(90,4,'MORE_DETAILS','รายละเอียดเพิ่มเติม'),(91,1,'FROM_PRICE','À partir de'),(91,2,'FROM_PRICE','From'),(91,3,'FROM_PRICE','From'),(91,4,'FROM_PRICE','จาก'),(92,1,'AMOUNT','Montant'),(92,2,'AMOUNT','Amount'),(92,3,'AMOUNT','Amount'),(92,4,'AMOUNT','จำนวน'),(93,1,'PAY','Payer'),(93,2,'PAY','Check out'),(93,3,'PAY','Check out'),(93,4,'PAY','เช็คเอาท์'),(94,1,'PAYMENT_PAYPAL_NOTICE','Cliquez sur \"Payer\" ci-dessous, vous allez être redirigé vers le site sécurisé de PayPal'),(94,2,'PAYMENT_PAYPAL_NOTICE','Click on \"Check Out\" below, you will be redirected towards the secure site of PayPal'),(94,3,'PAYMENT_PAYPAL_NOTICE','Click on \"Check Out\" below, you will be redirected towards the secure site of PayPal'),(94,4,'PAYMENT_PAYPAL_NOTICE','คลิกที่ \"ชำระเงิน\" ด้านล่าง คุณจะถูกนำไปยังไซต์ที่ปลอดภัยของ PayPal'),(95,1,'PAYMENT_CANCEL_NOTICE','Le paiement a été annulé. Merci de votre visite et à bientôt.'),(95,2,'PAYMENT_CANCEL_NOTICE','The payment has been cancelled. Thank you for your visit and see you soon.'),(95,3,'PAYMENT_CANCEL_NOTICE','The payment has been cancelled. Thank you for your visit and see you soon.'),(95,4,'PAYMENT_CANCEL_NOTICE','การชำระเงินถูกยกเลิก ขอบคุณสำหรับการเยี่ยมชมของคุณ แล้วพบกันใหม่'),(96,1,'PAYMENT_SUCCESS_NOTICE','Le paiement a été réalisé avec succès. Merci de votre visite et à bientôt !'),(96,2,'PAYMENT_SUCCESS_NOTICE','Your payment has been successfully processed. Thank you for your visit and see you soon!'),(96,3,'PAYMENT_SUCCESS_NOTICE','Your payment has been successfully processed. Thank you for your visit and see you soon!'),(96,4,'PAYMENT_SUCCESS_NOTICE','การชำระเงินของคุณได้รับการดำเนินการเรียบร้อยแล้ว ขอขอบคุณสำหรับการเยี่ยมชมของคุณ แล้วพบกันใหม่เร็วๆ นี้!'),(97,1,'BILLING_ADDRESS','Adresse de facturation'),(97,2,'BILLING_ADDRESS','Billing address'),(97,3,'BILLING_ADDRESS','Billing address'),(97,4,'BILLING_ADDRESS','ที่อยู่เรียกเก็บเงิน'),(98,1,'DOWN_PAYMENT','Acompte'),(98,2,'DOWN_PAYMENT','Down payment'),(98,3,'DOWN_PAYMENT','Down payment'),(98,4,'DOWN_PAYMENT','เงินดาวน์'),(99,1,'PAYMENT_CHECK_NOTICE','Merci d\'envoyer un chèque à \"Panda Multi Resorts, Neeloafaru Magu, Maldives\" d\'un montant de {amount}. Votre réservation sera validée à réception du paiement. Merci de votre visite et à bientôt !'),(99,2,'PAYMENT_CHECK_NOTICE','Thank you for sending a check of {amount} to \"Panda Multi Resorts, Neeloafaru Magu, Maldives\". Your reservation will be confirmed upon receipt of the payment. Thank you for your visit and see you soon!'),(99,3,'PAYMENT_CHECK_NOTICE','Thank you for sending a check of {amount} to \"Panda Multi Resorts, Neeloafaru Magu, Maldives\". Your reservation will be confirmed upon receipt of the payment. Thank you for your visit and see you soon!'),(99,4,'PAYMENT_CHECK_NOTICE','ขอขอบคุณที่ส่งเช็คจำนวน {amount} ไปที่ \"RelifeTravel\" การจองของคุณจะได้รับการยืนยันเมื่อได้รับการชำระเงิน ขอขอบคุณสำหรับการเยี่ยมชมของคุณ แล้วพบกันใหม่'),(100,1,'PAYMENT_ARRIVAL_NOTICE','Veuillez régler le solde de votre réservation d\'un montant de {amount} à votre arrivée. Merci de votre visite et à bientôt !'),(100,2,'PAYMENT_ARRIVAL_NOTICE','Thank you for paying the balance of {amount} for your booking on your arrival. Thank you for your visit and see you soon!'),(100,3,'PAYMENT_ARRIVAL_NOTICE','Thank you for paying the balance of {amount} for your booking on your arrival. Thank you for your visit and see you soon!'),(100,4,'PAYMENT_ARRIVAL_NOTICE','ขอขอบคุณที่ชำระยอดคงเหลือจำนวน {amount} สำหรับการจองเมื่อเดินทางมาถึง ขอขอบคุณสำหรับการเยี่ยมชมของคุณ แล้วพบกันใหม่เร็วๆ นี้!'),(101,1,'MAX_PEOPLE','Pers. max'),(101,2,'MAX_PEOPLE','Max people'),(101,3,'MAX_PEOPLE','Max people'),(101,4,'MAX_PEOPLE','คนสูงสุด'),(102,1,'VAT_AMOUNT','Dont TVA'),(102,2,'VAT_AMOUNT','VAT amount'),(102,3,'VAT_AMOUNT','VAT amount'),(102,4,'VAT_AMOUNT','จำนวนภาษีมูลค่าเพิ่ม'),(103,1,'MIN_NIGHTS','Nuits min'),(103,2,'MIN_NIGHTS','Min nights'),(103,3,'MIN_NIGHTS','Min nights'),(103,4,'MIN_NIGHTS','คืนขั้นต่ำ'),(104,1,'ROOMS','Chambres'),(104,2,'ROOMS','Rooms'),(104,3,'ROOMS','Rooms'),(104,4,'ROOMS','ห้องพัก'),(105,1,'RATINGS','Note(s)'),(105,2,'RATINGS','Rating(s)'),(105,3,'RATINGS','Rating(s)'),(105,4,'RATINGS','คะแนน'),(106,1,'MIN_PEOPLE','Pers. min'),(106,2,'MIN_PEOPLE','Min people'),(106,3,'MIN_PEOPLE','Min people'),(106,4,'MIN_PEOPLE','คนขั้นต่ำ'),(107,1,'HOTEL','Hôtel'),(107,2,'HOTEL','Hotel'),(107,3,'HOTEL','Hotel'),(107,4,'HOTEL','โรงแรม'),(108,1,'MAKE_A_REQUEST','Faire une demande'),(108,2,'MAKE_A_REQUEST','Make a request'),(108,3,'MAKE_A_REQUEST','Make a request'),(108,4,'MAKE_A_REQUEST','ทำการร้องขอ'),(109,1,'FULLNAME','Nom complet'),(109,2,'FULLNAME','Full Name'),(109,3,'FULLNAME','Full Name'),(109,4,'FULLNAME','ชื่อเต็ม'),(110,1,'PASSWORD','Mot de passe'),(110,2,'PASSWORD','Password'),(110,3,'PASSWORD','Password'),(110,4,'PASSWORD','รหัสผ่าน'),(111,1,'LOG_IN_WITH_FACEBOOK','Enregistrez-vous avec Facebook'),(111,2,'LOG_IN_WITH_FACEBOOK','Log in with Facebook'),(111,3,'LOG_IN_WITH_FACEBOOK','Log in with Facebook'),(111,4,'LOG_IN_WITH_FACEBOOK','เข้าสู่ระบบด้วย Facebook'),(112,1,'OR','Ou'),(112,2,'OR','Or'),(112,3,'OR','Or'),(112,4,'OR','หรือ'),(113,1,'NEW_PASSWORD','Nouveau mot de passe'),(113,2,'NEW_PASSWORD','New password'),(113,3,'NEW_PASSWORD','New password'),(113,4,'NEW_PASSWORD','รหัสผ่านใหม่'),(114,1,'NEW_PASSWORD_NOTICE','Merci d\'entrer l\'adresse e-mail correspondant à votre compte. Un nouveau mot de passe vous sera envoyé par e-mail.'),(114,2,'NEW_PASSWORD_NOTICE','Please enter your e-mail address corresponding to your account. A new password will be sent to you by e-mail.'),(114,3,'NEW_PASSWORD_NOTICE','Please enter your e-mail address corresponding to your account. A new password will be sent to you by e-mail.'),(114,4,'NEW_PASSWORD_NOTICE','โปรดป้อนที่อยู่อีเมลของคุณที่ตรงกับบัญชีของคุณ รหัสผ่านใหม่จะถูกส่งถึงคุณทางอีเมล'),(115,1,'USERNAME','Utilisateur'),(115,2,'USERNAME','Username'),(115,3,'USERNAME','Username'),(115,4,'USERNAME','ชื่อผู้ใช้'),(116,1,'PASSWORD_CONFIRM','Confirmer mot de passe'),(116,2,'PASSWORD_CONFIRM','Confirm password'),(116,3,'PASSWORD_CONFIRM','Confirm password'),(116,4,'PASSWORD_CONFIRM','ยืนยันรหัสผ่าน'),(117,1,'USERNAME_EXISTS','Un compte existe déjà avec ce nom d\'utilisateur'),(117,2,'USERNAME_EXISTS','An account already exists with this username'),(117,3,'USERNAME_EXISTS','An account already exists with this username'),(117,4,'USERNAME_EXISTS','มีบัญชีที่ใช้ชื่อผู้ใช้นี้แล้ว'),(118,1,'ACCOUNT_EDIT_SUCCESS','Les informations de votre compte ont bien été modifiées.'),(118,2,'ACCOUNT_EDIT_SUCCESS','Your account information have been changed.'),(118,3,'ACCOUNT_EDIT_SUCCESS','Your account information have been changed.'),(118,4,'ACCOUNT_EDIT_SUCCESS','ข้อมูลบัญชีของคุณมีการเปลี่ยนแปลง'),(119,1,'ACCOUNT_EDIT_FAILURE','Echec de la modification des informations de compte.'),(119,2,'ACCOUNT_EDIT_FAILURE','An error occured during the modification of the account information.'),(119,3,'ACCOUNT_EDIT_FAILURE','An error occured during the modification of the account information.'),(119,4,'ACCOUNT_EDIT_FAILURE','เกิดข้อผิดพลาดระหว่างการแก้ไขข้อมูลบัญชี'),(120,1,'ACCOUNT_CREATE_FAILURE','Echec de la création du compte.'),(120,2,'ACCOUNT_CREATE_FAILURE','Failed to create account.'),(120,3,'ACCOUNT_CREATE_FAILURE','Failed to create account.'),(120,4,'ACCOUNT_CREATE_FAILURE','สร้างบัญชีไม่สำเร็จ'),(121,1,'PAYMENT_CHECK','Par chèque'),(121,2,'PAYMENT_CHECK','By check'),(121,3,'PAYMENT_CHECK','By check'),(121,4,'PAYMENT_CHECK','โดยเช็ค'),(122,1,'PAYMENT_ARRIVAL','A l\'arrivée'),(122,2,'PAYMENT_ARRIVAL','On arrival'),(122,3,'PAYMENT_ARRIVAL','On arrival'),(122,4,'PAYMENT_ARRIVAL','เมื่อมาถึง'),(123,1,'CHOOSE_PAYMENT','Choisissez un moyen de paiement'),(123,2,'CHOOSE_PAYMENT','Choose a method of payment'),(123,3,'CHOOSE_PAYMENT','Choose a method of payment'),(123,4,'CHOOSE_PAYMENT','เลือกวิธีการชำระเงิน'),(124,1,'PAYMENT_CREDIT_CARDS','Cartes de credit'),(124,2,'PAYMENT_CREDIT_CARDS','Credit cards'),(124,3,'PAYMENT_CREDIT_CARDS','Credit cards'),(124,4,'PAYMENT_CREDIT_CARDS','บัตรเครดิต'),(125,1,'MAX_ADULTS','Adultes max'),(125,2,'MAX_ADULTS','Max adults'),(125,3,'MAX_ADULTS','Max adults'),(125,4,'MAX_ADULTS','ผู้ใหญ่สูงสุด'),(126,1,'MAX_CHILDREN','Enfants max'),(126,2,'MAX_CHILDREN','Max children'),(126,3,'MAX_CHILDREN','Max children'),(126,4,'MAX_CHILDREN','เด็กสูงสุด'),(127,1,'PAYMENT_2CHECKOUT_NOTICE','Cliquez sur \"Payer\" ci-dessous, vous allez être redirigé vers le site sécurisé de 2Checkout.com'),(127,2,'PAYMENT_2CHECKOUT_NOTICE','Click on \"Check Out\" below, you will be redirected towards the secure site of 2Checkout.com'),(127,3,'PAYMENT_2CHECKOUT_NOTICE','Click on \"Check Out\" below, you will be redirected towards the secure site of 2Checkout.com'),(127,4,'PAYMENT_2CHECKOUT_NOTICE','คลิกที่ \"ชำระเงิน\" ด้านล่าง คุณจะถูกนำไปยังไซต์ที่ปลอดภัยของ 2Checkout.com'),(128,1,'COOKIES_NOTICE','Les cookies nous aident à fournir une meilleure expérience utilisateur. En utilisant notre site, vous acceptez l\'utilisation de cookies.'),(128,2,'COOKIES_NOTICE','Cookies help us provide better user experience. By using our website, you agree to the use of cookies.'),(128,3,'COOKIES_NOTICE','Cookies help us provide better user experience. By using our website, you agree to the use of cookies.'),(128,4,'COOKIES_NOTICE','คุกกี้ช่วยให้เรามอบประสบการณ์การใช้งานที่ดีขึ้น การใช้เว็บไซต์ของเราแสดงว่าคุณยอมรับการใช้คุกกี้'),(129,1,'DURATION','Durée'),(129,2,'DURATION','Duration'),(129,3,'DURATION','Duration'),(129,4,'DURATION','ระยะเวลา'),(130,1,'PERSON','Personne'),(130,2,'PERSON','Person'),(130,3,'PERSON','Person'),(130,4,'PERSON','บุคคล'),(131,1,'CHOOSE_A_DATE','Choisissez une date'),(131,2,'CHOOSE_A_DATE','Choose a date'),(131,3,'CHOOSE_A_DATE','Choose a date'),(131,4,'CHOOSE_A_DATE','เลือกวันที่'),(132,1,'TIMESLOT','Horaire'),(132,2,'TIMESLOT','Time slot'),(132,3,'TIMESLOT','Time slot'),(132,4,'TIMESLOT','ช่วงเวลา'),(133,1,'ACTIVITIES','Activités'),(133,2,'ACTIVITIES','Activities'),(133,3,'ACTIVITIES','Activities'),(133,4,'ACTIVITIES','กิจกรรม'),(134,1,'DESTINATION','Destination'),(134,2,'DESTINATION','Destination'),(134,3,'DESTINATION','Destination'),(134,4,'DESTINATION','ปลายทาง'),(135,1,'NO_HOTEL_FOUND','Aucun hotel trouvé'),(135,2,'NO_HOTEL_FOUND','No hotel found'),(135,3,'NO_HOTEL_FOUND','No hotel found'),(135,4,'NO_HOTEL_FOUND','ไม่พบโรงแรม'),(136,1,'FOR','pour'),(136,2,'FOR','for'),(136,3,'FOR','for'),(136,4,'FOR','สำหรับ'),(137,1,'FIND_ACTIVITIES_AND_TOURS','Découvrez nos activités et excursions'),(137,2,'FIND_ACTIVITIES_AND_TOURS','Find out our activities and tours'),(137,3,'FIND_ACTIVITIES_AND_TOURS','Find out our activities and tours'),(137,4,'FIND_ACTIVITIES_AND_TOURS','ค้นหากิจกรรมและทัวร์ของเรา'),(138,1,'MINUTES','minute(s)'),(138,2,'MINUTES','minute(s)'),(138,3,'MINUTES','minute(s)'),(138,4,'MINUTES','นาที'),(139,1,'HOURS','heure(s)'),(139,2,'HOURS','hour(s)'),(139,3,'HOURS','hour(s)'),(139,4,'HOURS','ชั่วโมง'),(140,1,'DAYS','jour(s)'),(140,2,'DAYS','day(s)'),(140,3,'DAYS','day(s)'),(140,4,'DAYS','วัน'),(141,1,'WEEKS','semaine(s)'),(141,2,'WEEKS','week(s)'),(141,3,'WEEKS','week(s)'),(141,4,'WEEKS','สัปดาห์'),(142,1,'RESULTS','Résultats'),(142,2,'RESULTS','Results'),(142,3,'RESULTS','Results'),(142,4,'RESULTS','ผลลัพธ์'),(143,1,'BOOKING_HISTORY','Historique des réservations'),(143,2,'BOOKING_HISTORY','Booking history'),(143,3,'BOOKING_HISTORY','Booking history'),(143,4,'BOOKING_HISTORY','ประวัติการจอง'),(144,1,'BOOKING_SUMMARY','Résumé de la réservation'),(144,2,'BOOKING_SUMMARY','Booking summary'),(144,3,'BOOKING_SUMMARY','Booking summary'),(144,4,'BOOKING_SUMMARY','สรุปการจอง'),(145,1,'BOOKING_DATE','Date de la réservations'),(145,2,'BOOKING_DATE','Booking date'),(145,3,'BOOKING_DATE','Booking date'),(145,4,'BOOKING_DATE','วันที่จอง'),(146,1,'NO_BOOKING_YET','Pas encore de réservation...'),(146,2,'NO_BOOKING_YET','No booking yet...'),(146,3,'NO_BOOKING_YET','No booking yet...'),(146,4,'NO_BOOKING_YET','ยังไม่มีการจอง...'),(147,1,'PAYMENT','Paiement'),(147,2,'PAYMENT','Payment'),(147,3,'PAYMENT','Payment'),(147,4,'PAYMENT','การชำระเงิน'),(148,1,'PAYMENT_DATE','Date du paiement'),(148,2,'PAYMENT_DATE','Payment date'),(148,3,'PAYMENT_DATE','Payment date'),(148,4,'PAYMENT_DATE','วันจ่าย'),(149,1,'PAYMENT_METHOD','Méthode de paiement'),(149,2,'PAYMENT_METHOD','Payment method'),(149,3,'PAYMENT_METHOD','Payment method'),(149,4,'PAYMENT_METHOD','วิธีการชำระเงิน'),(150,1,'NUM_TRANSACTION','N°transaction'),(150,2,'NUM_TRANSACTION','Num. transaction'),(150,3,'NUM_TRANSACTION','Num. transaction'),(150,4,'NUM_TRANSACTION','จำนวน ธุรกรรม'),(151,1,'STATUS','Statut'),(151,2,'STATUS','Status'),(151,3,'STATUS','Status'),(151,4,'STATUS','สถานะ'),(152,1,'AWAITING','En attente'),(152,2,'AWAITING','Awaiting'),(152,3,'AWAITING','Awaiting'),(152,4,'AWAITING','กำลังรอ'),(153,1,'CANCELLED','Annulé'),(153,2,'CANCELLED','Cancelled'),(153,3,'CANCELLED','Cancelled'),(153,4,'CANCELLED','ยกเลิก'),(154,1,'REJECTED_PAYMENT','Paiement rejeté'),(154,2,'REJECTED_PAYMENT','Rejected payment'),(154,3,'REJECTED_PAYMENT','Rejected payment'),(154,4,'REJECTED_PAYMENT','การชำระเงินที่ถูกปฏิเสธ'),(155,1,'PAYED','Payé'),(155,2,'PAYED','Payed'),(155,3,'PAYED','Payed'),(155,4,'PAYED','จ่ายแล้ว'),(156,1,'INCL_TAX','TTC'),(156,2,'INCL_TAX','incl. tax'),(156,3,'INCL_TAX','incl. tax'),(156,4,'INCL_TAX','รวมภาษี'),(157,1,'TAGS','Tags'),(157,2,'TAGS','Tags'),(157,3,'TAGS','Tags'),(157,4,'TAGS','แท็ก'),(158,1,'ARCHIVES','Archives'),(158,2,'ARCHIVES','Archives'),(158,3,'ARCHIVES','Archives'),(158,4,'ARCHIVES','Archives'),(159,1,'STARS','Étoiles'),(159,2,'STARS','Stars'),(159,3,'STARS','Stars'),(159,4,'STARS','ดาว'),(160,1,'HOTEL_CLASS','Catégorie d\'Hôtel'),(160,2,'HOTEL_CLASS','Hotel Class'),(160,3,'HOTEL_CLASS','Hotel Class'),(160,4,'HOTEL_CLASS','ระดับโรงแรม'),(161,1,'YOUR_BUDGET','Votre Budget'),(161,2,'YOUR_BUDGET','Your Budget'),(161,3,'YOUR_BUDGET','Your Budget'),(161,4,'YOUR_BUDGET','งบประมาณของคุณ'),(162,1,'LOAD_MORE','Voir plus'),(162,2,'LOAD_MORE','Load more'),(162,3,'LOAD_MORE','Load more'),(162,4,'LOAD_MORE','โหลดเพิ่มเติม'),(163,1,'DO_YOU_HAVE_A_COUPON','Avez-vous un code promo ?'),(163,2,'DO_YOU_HAVE_A_COUPON','Do you have a coupon?'),(163,3,'DO_YOU_HAVE_A_COUPON','Do you have a coupon?'),(163,4,'DO_YOU_HAVE_A_COUPON','คุณมีคูปองหรือไม่?'),(164,1,'DISCOUNT','Réduction'),(164,2,'DISCOUNT','Discount'),(164,3,'DISCOUNT','Discount'),(164,4,'DISCOUNT','การลดราคา'),(165,1,'COUPON_CODE_SUCCESS','Félicitations ! Le code promo a été ajouté avec succès.'),(165,2,'COUPON_CODE_SUCCESS','Congratulations! The coupon code has been successfully added.'),(165,3,'COUPON_CODE_SUCCESS','Congratulations! The coupon code has been successfully added.'),(165,4,'COUPON_CODE_SUCCESS','ยินดีด้วย! เพิ่มรหัสคูปองสำเร็จแล้ว'),(166,1,'ROOMS','chambres'),(166,2,'ROOMS','rooms'),(166,3,'ROOMS','rooms'),(166,4,'ROOMS','ห้องพัก'),(167,1,'ADULT','adulte'),(167,2,'ADULT','adult'),(167,3,'ADULT','adult'),(167,4,'ADULT','ผู้ใหญ่'),(168,1,'CHILD','enfant'),(168,2,'CHILD','child'),(168,3,'CHILD','child'),(168,4,'CHILD','เด็ก'),(169,1,'ACTIVITY','Activité'),(169,2,'ACTIVITY','Activity'),(169,3,'ACTIVITY','Activity'),(169,4,'ACTIVITY','กิจกรรม'),(170,1,'DATE','Date'),(170,2,'DATE','Date'),(170,3,'DATE','Date'),(170,4,'DATE','วันที่'),(171,1,'QUANTITY','Quantité'),(171,2,'QUANTITY','Quantity'),(171,3,'QUANTITY','Quantity'),(171,4,'QUANTITY','ปริมาณ'),(172,1,'SERVICE','Service'),(172,2,'SERVICE','Service'),(172,3,'SERVICE','Service'),(172,4,'SERVICE','บริการ'),(173,1,'BOOKING_NOTICE','<h2>Réservez sur notre site</h2>Dépêchez-vous ! Sélectionnez vos chambres, complétez votre réservation et profitez de nos packages et offres spéciales ! Meilleur prix garanti !'),(173,2,'BOOKING_NOTICE','<h2>Book on our website</h2>Hurry up! Select the your rooms, complete your booking and take advantage of our special offers and packages! Best price guarantee!'),(173,3,'BOOKING_NOTICE','<h2>Book on our website</h2>Hurry up! Select the your rooms, complete your booking and take advantage of our special offers and packages! Best price guarantee!'),(173,4,'BOOKING_NOTICE','<h2>จองบนเว็บไซต์ของเรา</h2>เร็วเข้า! เลือกห้องของคุณ ดำเนินการจองให้เสร็จสิ้น และใช้ประโยชน์จากข้อเสนอและแพ็คเกจพิเศษของเรา! รับประกันราคาดีที่สุด!'),(174,1,'NUM_ROOMS','Nb chambres'),(174,2,'NUM_ROOMS','Num rooms'),(174,3,'NUM_ROOMS','Num rooms'),(174,4,'NUM_ROOMS','จำนวนห้อง'),(175,1,'TOP_DESTINATIONS','Top Destinations'),(175,2,'TOP_DESTINATIONS','Top Destinations'),(175,3,'TOP_DESTINATIONS','Top Destinations'),(175,4,'TOP_DESTINATIONS','จุดหมายปลายทางยอดนิยม'),(176,1,'BEST_RATES_SUBTITLE','Meilleurs tarifs à partir de seulement {min_price}'),(176,2,'BEST_RATES_SUBTITLE','Best rates starting at just {min_price}'),(176,3,'BEST_RATES_SUBTITLE','Best rates starting at just {min_price}'),(176,4,'BEST_RATES_SUBTITLE','ราคาที่ดีที่สุดเริ่มต้นเพียง {min_price}'),(177,1,'CONTINUE_AS_GUEST','Continuer sans m\'enregistrer'),(177,2,'CONTINUE_AS_GUEST','Continue as guest'),(177,3,'CONTINUE_AS_GUEST','Continue as guest'),(177,4,'CONTINUE_AS_GUEST','ยังคงเป็นแขกรับเชิญ'),(178,1,'PRIVACY_POLICY_AGREEMENT','J\'accepte que les informations recueillies par ce formulaire soient stockées dans un fichier informatisé afin de traiter ma demande. Conformément au \"Réglement Général sur la Protection des Données\", vous pouvez exercer votre droit d\'accès aux données vous concernant et les faire rectifier via le formulaire de contact.'),(178,2,'PRIVACY_POLICY_AGREEMENT','I agree that the information collected by this form will be stored in a database in order to process my request. In accordance with the \"General Data Protection Regulation\", you can exercise your right to access to your data and make them rectified via the contact form.'),(178,3,'PRIVACY_POLICY_AGREEMENT','I agree that the information collected by this form will be stored in a database in order to process my request. In accordance with the \"General Data Protection Regulation\", you can exercise your right to access to your data and make them rectified via the contact form.'),(178,4,'PRIVACY_POLICY_AGREEMENT','ฉันยอมรับว่าข้อมูลที่รวบรวมโดยแบบฟอร์มนี้จะถูกจัดเก็บไว้ในฐานข้อมูลเพื่อดำเนินการตามคำขอของฉัน ตาม \"ระเบียบการคุ้มครองข้อมูลทั่วไป\" คุณสามารถใช้สิทธิ์ในการเข้าถึงข้อมูลของคุณและ ดำเนินการแก้ไขผ่านแบบฟอร์มการติดต่อ'),(179,1,'COMPLETE_YOUR_BOOKING','Terminez votre réservation !'),(179,2,'COMPLETE_YOUR_BOOKING','Complete your booking!'),(179,3,'COMPLETE_YOUR_BOOKING','Complete your booking!'),(179,4,'COMPLETE_YOUR_BOOKING','เสร็จสิ้นการจองของคุณ!'),(180,1,'CHILDREN_AGE','Age des enfants'),(180,2,'CHILDREN_AGE','Age of children'),(180,3,'CHILDREN_AGE','Age of children'),(180,4,'CHILDREN_AGE','อายุของเด็ก'),(181,1,'I_AM_HOTEL_OWNER','Je suis propriétaire'),(181,2,'I_AM_HOTEL_OWNER','I am a hotel owner'),(181,3,'I_AM_HOTEL_OWNER','I am a hotel owner'),(181,4,'I_AM_HOTEL_OWNER','ฉันเป็นเจ้าของโรงแรม'),(182,1,'I_AM_TRAVELER','Je suis vacancier'),(182,2,'I_AM_TRAVELER','I am a traveler'),(182,3,'I_AM_TRAVELER','I am a traveler'),(182,4,'I_AM_TRAVELER','ฉันเป็นนักเดินทาง'),(183,1,'BOOK_NOW','Réserver maintenant'),(183,2,'BOOK_NOW','Book now'),(183,3,'BOOK_NOW','Book now'),(183,4,'BOOK_NOW','จองตอนนี้'),(184,1,'LOCATION','Emplacement'),(184,2,'LOCATION','Location'),(184,3,'LOCATION','Location'),(184,4,'LOCATION','ที่ตั้ง'),(185,1,'DISCOVER_ALSO','Découvrez aussi'),(185,2,'DISCOVER_ALSO','Discover also'),(185,3,'DISCOVER_ALSO','Discover also'),(185,4,'DISCOVER_ALSO','ค้นพบด้วย'),(186,1,'PAYMENT_BRAINTREE_NOTICE','Remplissez le formulaire ci-dessous avec les informations de votre carte de crédit, puis cliquez sur \"Payer\".'),(186,2,'PAYMENT_BRAINTREE_NOTICE','Fill in the form bellow with your credit card information, then click on \"Check Out\".'),(186,3,'PAYMENT_BRAINTREE_NOTICE','Fill in the form bellow with your credit card information, then click on \"Check Out\".'),(186,4,'PAYMENT_BRAINTREE_NOTICE','กรอกแบบฟอร์มด้านล่างด้วยข้อมูลบัตรเครดิตของคุณ จากนั้นคลิก \"ชำระเงิน\"'),(187,1,'COUPON_CODE_FAILURE','Erreur : ce code est invalide ou a déjà été utilisé'),(187,2,'COUPON_CODE_FAILURE','Error: this code is invalid or already used'),(187,3,'COUPON_CODE_FAILURE','Error: this code is invalid or already used'),(187,4,'COUPON_CODE_FAILURE','ข้อผิดพลาด: รหัสนี้ไม่ถูกต้องหรือใช้ไปแล้ว'),(188,1,'PAYMENT_RAZORPAY_NOTICE','Cliquez sur \"Payer\", puis remplissez le formulaire avec les informations de votre carte de crédit.'),(188,2,'PAYMENT_RAZORPAY_NOTICE','Click on \"Check Out\", then fill in the form with your credit card information.'),(188,3,'PAYMENT_RAZORPAY_NOTICE','Click on \"Check Out\", then fill in the form with your credit card information.'),(188,4,'PAYMENT_RAZORPAY_NOTICE','คลิกที่ \"ชำระเงิน\" จากนั้นกรอกแบบฟอร์มด้วยข้อมูลบัตรเครดิตของคุณ'),(189,1,'YO','y.o.'),(189,2,'YO','ans'),(189,3,'YO','y.o.'),(189,4,'YO','ตอบ');
/*!40000 ALTER TABLE `pm_text` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_user`
--

DROP TABLE IF EXISTS `pm_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `login` varchar(50) DEFAULT NULL,
  `pass` varchar(100) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `add_date` int(11) DEFAULT NULL,
  `edit_date` int(11) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `fb_id` varchar(50) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `postcode` varchar(10) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `token` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_user`
--

LOCK TABLES `pm_user` WRITE;
/*!40000 ALTER TABLE `pm_user` DISABLE KEYS */;
INSERT INTO `pm_user` VALUES (1,'Theerachai','Chomtap','mrtan.dev@gmail.com','admin','e921082f0616c71269fb1c87b336c930','administrator',1669899308,1670161738,1,'','123','10140','Bangkok','','Thailand','','123','');
/*!40000 ALTER TABLE `pm_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pm_widget`
--

DROP TABLE IF EXISTS `pm_widget`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_widget` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `showtitle` int(11) DEFAULT NULL,
  `pos` varchar(20) DEFAULT NULL,
  `allpages` int(11) DEFAULT NULL,
  `pages` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `class` varchar(200) DEFAULT NULL,
  `checked` int(11) DEFAULT 0,
  `rank` int(11) DEFAULT 0,
  PRIMARY KEY (`id`,`lang`),
  KEY `widget_lang_fkey` (`lang`),
  CONSTRAINT `widget_lang_fkey` FOREIGN KEY (`lang`) REFERENCES `pm_lang` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pm_widget`
--

LOCK TABLES `pm_widget` WRITE;
/*!40000 ALTER TABLE `pm_widget` DISABLE KEYS */;
INSERT INTO `pm_widget` VALUES (1,1,'Qui sommes-nous ?',1,'footer_col_1',1,'','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.\r\n',NULL,1,1),(1,2,'About us',1,'footer_col_1',1,'','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.\r\n',NULL,1,1),(1,3,'عنا',1,'footer_col_1',1,'','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.\r\n',NULL,1,1),(1,4,'About us',1,'footer_col_1',1,'','','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum eget auctor ipsum. Mauris pharetra neque a mauris commodo, at aliquam leo malesuada. Maecenas eget elit eu ligula rhoncus dapibus at non erat. In sed velit eget eros gravida consectetur varius imperdiet lectus.\r\n',NULL,1,1),(3,1,'Derniers articles',1,'footer_col_2',1,'','latest_articles','','',1,2),(3,2,'Latest articles',1,'footer_col_2',1,'','latest_articles','','',1,2),(3,3,'المقالات الأخيرة',1,'footer_col_2',1,'','latest_articles','','',1,2),(3,4,'Latest articles',1,'footer_col_2',1,'','latest_articles','','',1,2),(4,1,'Contactez-nous',0,'footer_col_3',1,'','contact_informations','','',1,3),(4,2,'Contact us',0,'footer_col_3',1,'','contact_informations','','',1,3),(4,3,'اتصل بنا',0,'footer_col_3',1,'','contact_informations','','',1,3),(4,4,'Contact us',0,'footer_col_3',1,'','contact_informations','','',1,3),(5,1,'Footer form',0,'footer_col_3',1,'','footer_form','','footer-form mt10',0,4),(5,2,'Footer form',0,'footer_col_3',1,'','footer_form','','footer-form mt10',0,4),(5,3,'Footer form',0,'footer_col_3',1,'','footer_form','','footer-form mt10',0,4),(5,4,'Footer form',0,'footer_col_3',1,'','footer_form','','footer-form mt10',0,4),(6,1,'Blog side',0,'right',0,'17','blog_side','','',1,5),(6,2,'Blog side',0,'right',0,'17','blog_side','','',1,5),(6,3,'Blog side',0,'right',0,'17','blog_side','','',1,5),(6,4,'Blog side',0,'right',0,'17','blog_side','','',1,5);
/*!40000 ALTER TABLE `pm_widget` 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-26 21:32:39

📁 Sid Gifari File Manager