Da

✏️ Editing: btsbtlco_fccreport.sql

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

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `btsbtlco_fccreport`
--

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

USE `btsbtlco_fccreport`;

--
-- Table structure for table `auditlog`
--

DROP TABLE IF EXISTS `auditlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auditlog` (
  `audit_id` int(11) NOT NULL AUTO_INCREMENT,
  `audit_employee` varchar(255) NOT NULL,
  `audit_projectid` int(11) NOT NULL,
  `audit_dataid` int(11) NOT NULL,
  `audit_oldtext` text NOT NULL,
  `audit_newtext` text NOT NULL,
  `audit_datetime` datetime NOT NULL,
  PRIMARY KEY (`audit_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auditlog`
--

LOCK TABLES `auditlog` WRITE;
/*!40000 ALTER TABLE `auditlog` DISABLE KEYS */;
INSERT INTO `auditlog` VALUES (1,'Administrator BT',1,1,'636578','636578xxx','2020-03-24 11:58:20'),(2,'Administrator BT',1,1,'','ผลการติดต่อ สำเร็จ','2020-03-24 11:58:21'),(3,'Administrator BT',1,1,'','ผลการ Confirm (Yes/No) Yes','2020-03-24 11:58:21'),(4,'Administrator BT',1,1,'','Confirm Booking (Yes/No) Yes','2020-03-24 11:58:22'),(5,'Administrator BT',1,1,'','ผลการติดต่อ สำเร็จ','2020-03-24 11:58:23'),(6,'Administrator BT',1,1,'Toyota Camry','Hyundai H1','2020-03-24 12:42:08');
/*!40000 ALTER TABLE `auditlog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data`
--

DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `data_projectid` int(11) NOT NULL,
  `Grouping` varchar(20) NOT NULL,
  `No` int(11) DEFAULT NULL,
  `Case_Number` varchar(20) DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `Case_Date` varchar(20) DEFAULT NULL,
  `Reservation_Date` varchar(20) DEFAULT NULL,
  `Reservation_Time` varchar(20) DEFAULT NULL,
  `Flight` varchar(20) DEFAULT NULL,
  `Flight_Time` varchar(20) DEFAULT NULL,
  `Flight_Date` varchar(20) DEFAULT NULL,
  `Account_Name` varchar(255) DEFAULT NULL,
  `Guest_Name` varchar(255) DEFAULT NULL,
  `Customer_Mobile` varchar(255) DEFAULT NULL,
  `Guest_Mobile` varchar(255) DEFAULT NULL,
  `Project_Line_Item_Choice_Name` varchar(255) DEFAULT NULL,
  `Car_Type` varchar(255) DEFAULT NULL,
  `Fast_track_service` varchar(255) DEFAULT NULL,
  `Buggy_service` varchar(255) DEFAULT NULL,
  `Pick_Up_Location` varchar(255) DEFAULT NULL,
  `Pick_Up_Subdistrict` varchar(255) DEFAULT NULL,
  `Pick_Up_District` varchar(255) DEFAULT NULL,
  `Pick_Up_Province` varchar(255) DEFAULT NULL,
  `Pick_Up_Zipcode` varchar(255) DEFAULT NULL,
  `Drop_Off_Location` varchar(255) DEFAULT NULL,
  `Drop_Off_Subdistrict` varchar(255) DEFAULT NULL,
  `Drop_Off_District` varchar(255) DEFAULT NULL,
  `Drop_Off_Province` varchar(255) DEFAULT NULL,
  `Drop_Off_Zipcode` varchar(255) DEFAULT NULL,
  `Status_FT_BG_Confirmed_Check_by` varchar(255) DEFAULT NULL,
  `Confirm_Booking_Date` varchar(255) DEFAULT NULL,
  `Confirm_Booking_1` varchar(20) DEFAULT NULL,
  `Confirm_Booking_time_1` varchar(20) DEFAULT NULL,
  `Confirm_Booking_2` varchar(20) DEFAULT NULL,
  `Confirm_Booking_time_2` varchar(20) DEFAULT NULL,
  `Confirm_Booking_3` varchar(20) DEFAULT NULL,
  `Confirm_Booking_time_3` varchar(20) DEFAULT NULL,
  `Confirm_Booking_Pass` varchar(255) DEFAULT NULL,
  `Confirm_Booking_NoPass` varchar(10) DEFAULT NULL,
  `Confirm_Booking_Car` varchar(30) DEFAULT NULL,
  `Confirm_Booking_YN` varchar(255) DEFAULT NULL,
  `Confirm_Booking_Edit` varchar(255) DEFAULT NULL,
  `Driver_Fullname` varchar(255) DEFAULT NULL,
  `Driver_Telephone` varchar(255) DEFAULT NULL,
  `Driver_Type_Car` varchar(255) DEFAULT NULL,
  `Confirm_Booking_Status` varchar(255) DEFAULT NULL,
  `Driver_Edit_If_Confirm_No` varchar(255) DEFAULT NULL,
  `Confirm_Driver_Date` varchar(20) DEFAULT NULL,
  `Confirm_Driver_1` varchar(20) DEFAULT NULL,
  `Confirm_Driver_time_1` varchar(20) DEFAULT NULL,
  `Confirm_Driver_2` varchar(20) DEFAULT NULL,
  `Confirm_Driver_time_2` varchar(20) DEFAULT NULL,
  `Confirm_Driver_3` varchar(20) DEFAULT NULL,
  `Confirm_Driver_time_3` varchar(20) DEFAULT NULL,
  `Confirm_Driver_Tel_reason` varchar(255) DEFAULT NULL,
  `Confirm_FTT_Date` varchar(255) DEFAULT NULL,
  `Confirm_FTT_1` varchar(255) DEFAULT NULL,
  `Confirm_FTT_time_1` varchar(255) DEFAULT NULL,
  `Confirm_FTT_2` varchar(255) DEFAULT NULL,
  `Confirm_FTT_time_2` varchar(255) DEFAULT NULL,
  `Confirm_FTT_tel_reason` varchar(255) DEFAULT NULL,
  `Call_Result_Date` varchar(255) DEFAULT NULL,
  `Call_Result_1` varchar(255) DEFAULT NULL,
  `Call_Result_time_1` varchar(255) DEFAULT NULL,
  `Call_Result_2` varchar(255) DEFAULT NULL,
  `Call_Result_time_2` varchar(255) DEFAULT NULL,
  `Confirm_FTT_3` varchar(20) DEFAULT NULL,
  `Confirm_FTT_time_3` varchar(20) DEFAULT NULL,
  `Call_Result_3` varchar(255) DEFAULT NULL,
  `Call_Result_time_3` varchar(255) DEFAULT NULL,
  `Call_Result_Pass` varchar(255) DEFAULT NULL,
  `Call_Result_NotPass` varchar(255) DEFAULT NULL,
  `Call_Result_Comment` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `data_employee` varchar(255) DEFAULT NULL,
  `data_fcc_employee` varchar(50) DEFAULT NULL,
  `data_status` varchar(20) NOT NULL DEFAULT 'New',
  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 `data`
--

LOCK TABLES `data` WRITE;
/*!40000 ALTER TABLE `data` DISABLE KEYS */;
INSERT INTO `data` VALUES (1,1,'20200320153623',1,'636578xxx','New','2020-03-15','2020-03-22','18:22','TG242','18:22','2020-03-22','NONTIWAT YANATAL','NONTIWAT YANATAL','832087028','832087028','Toyota Camry (ขาเข้า) สุวรรณภูมิ','Toyota Camry','-','-','BKK/TG242/11:40 สมุทรปราการ','-','-','สมุทรปราการ','-','InterContinental Bangkok, 973 Phloen Chit Rd ลุมพินี เขตปทุมวัน กรุงเทพฯ','ลุมพินี','เขตปทุมวัน','กรุงเทพฯ','10330','','','','','','','','','ผลการติดต่อ สำเร็จ','','Hyundai H1','Confirm Booking (Yes/No) Yes','','','','Hyundai H1','ผลการ Confirm (Yes/No) Yes','','','','','','','','','','','','','','','','','','','','','','','','','ผลการติดต่อ สำเร็จ','','','2020-03-20 15:36:23','นางสาวนวกมล  สังข์สุวรรณ','Administrator BT',' Edited'),(2,1,'20200320153623',2,'636651','New','2020-03-16','2020-03-22','21:12','TG475','00:32','2020-03-22','Daranee Vorasurayakarnt','DARANEE VORASURAYAKARNT','813455081','813455081','Toyota Camry','Toyota Camry','-','-','33/73 ถ.ทรัพย์ สี่พระยา เขตบางรัก กรุงเทพฯ','สี่พระยา','เขตบางรัก','กรุงเทพฯ','10500','BKK/TG475/17:50 สมุทรปราการ','-','-','สมุทรปราการ','-','','','','','','','','','','',NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2020-03-20 15:36:23','นางสาวนวกมล  สังข์สุวรรณ','','New');
/*!40000 ALTER TABLE `data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_log`
--

DROP TABLE IF EXISTS `data_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_employee_id` int(11) NOT NULL,
  `log_datetime` datetime NOT NULL,
  `log_record` int(11) NOT NULL,
  PRIMARY KEY (`log_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 `data_log`
--

LOCK TABLES `data_log` WRITE;
/*!40000 ALTER TABLE `data_log` DISABLE KEYS */;
INSERT INTO `data_log` VALUES (1,48,'2020-03-20 15:36:23',2);
/*!40000 ALTER TABLE `data_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project` (
  `project_id` int(11) NOT NULL AUTO_INCREMENT,
  `project_name` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `project_icon` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`project_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 `project`
--

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
INSERT INTO `project` VALUES (1,'CITI bank ROP','citi.jpg'),(2,'CITI Gold','citi.jpg'),(3,'KBANK','kbank.jpg'),(4,'UOB Infinite','uob.jpg');
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-31 13:19:14

📁 Sid Gifari File Manager