Da

✏️ Editing: ggraceco_dit.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: ggraceco_dit
-- ------------------------------------------------------
-- 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: `ggraceco_dit`
--

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

USE `ggraceco_dit`;

--
-- Table structure for table `CBD_LED`
--

DROP TABLE IF EXISTS `CBD_LED`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CBD_LED` (
  `LED_ID` int(5) NOT NULL AUTO_INCREMENT,
  `LED_Code` varchar(10) DEFAULT NULL,
  `Region` varchar(30) DEFAULT NULL,
  `Photo_LED` varchar(50) DEFAULT NULL,
  `ProvinceTH` varchar(20) DEFAULT NULL,
  `LocationTH` varchar(50) DEFAULT NULL,
  `ProvinceEN` varchar(20) DEFAULT NULL,
  `LocationEN` varchar(50) DEFAULT NULL,
  `Propotion` varchar(10) DEFAULT NULL,
  `Resolution` varchar(20) DEFAULT NULL,
  `Latitude` varchar(30) DEFAULT NULL,
  `Longtitude` varchar(30) DEFAULT NULL,
  `Status` varchar(10) NOT NULL DEFAULT 'open',
  PRIMARY KEY (`LED_ID`),
  UNIQUE KEY `LED_CODE_UNIQUE` (`LED_Code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CBD_LED`
--

LOCK TABLES `CBD_LED` WRITE;
/*!40000 ALTER TABLE `CBD_LED` DISABLE KEYS */;
INSERT INTO `CBD_LED` VALUES (1,'CRI01','เหนือ',NULL,'เชียงราย','ห้าแยกพ่อขุนเม็งราย','Chiangrai','King Mengrai Junction','16:9','1280 x 720','19.910887','99.840373','open'),(2,'CMI01','เหนือ',NULL,'เชียงใหม่','สี่แยกข่วงสิงห์','Chiangmai','Khuang Sing Intersection','4:3','624 x 464','18.812198','98.984096','open'),(3,'CMI04','เหนือ',NULL,'เชียงใหม่','สี่แยกสะพานนวรัฐ','Chiangmai','Nawarat Bridge Intersection ','4:3','512 x 384','18.787762','99.005359','open'),(4,'PLK01','เหนือ',NULL,'พิษณุโลก','สี่แยกบ้านคลอง','Phitsanulok','Baan Klong Intersection','16:9','768 x 432','16.831287','100.248753','open'),(5,'UTT01','เหนือ',NULL,'อุตรดิตถ์','วงเวียนหอนาฬิกา','Uttaradit','Clock Tower','16:9','432 x 256','17.61868','100.09755','open'),(6,'PRE01','เหนือ',NULL,'แพร่','แยกโรงพยาบาลแพร่ ถนนช่อแฮ','Phrae','Phrae Hospital Junction','16:9','432 x 256','18.134783','100.153795','open'),(7,'NAN01','เหนือ',NULL,'น่าน','แยกถนนสุมนเทวราช','Nan','Sumontewaratch Intersection','16:9','496 x 288','18.779188','100.775912','open'),(8,'KKN01','ตะวันออกเฉียงเหนือ',NULL,'ขอนแก่น','สี่แยกเซ็นทรัลพลาซ่าขอนแก่น','Khon Kaen','Central Plaza Khon Kaen Intersection','16:9','-','16.4318622','102.8238243','open'),(9,'KKN02','ตะวันออกเฉียงเหนือ',NULL,'ขอนแก่น','สามแยกถนนหน้าเมือง-เหล่านาดี','Khon Kaen','Na Muang - Lao Na Dee Junction','16:9','496 x 288','16.41331','102.832277','open');
/*!40000 ALTER TABLE `CBD_LED` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Spot_location_data`
--

DROP TABLE IF EXISTS `Spot_location_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Spot_location_data` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `JobNo` varchar(20) NOT NULL,
  `LocationName` varchar(40) NOT NULL,
  `SpotName` varchar(50) NOT NULL,
  `AddDate` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Spot_location_data`
--

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

--
-- Table structure for table `cbd_led_data`
--

DROP TABLE IF EXISTS `cbd_led_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cbd_led_data` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `LocName` varchar(40) NOT NULL,
  `LocDetail` varchar(150) NOT NULL,
  `STATUS` varchar(3) NOT NULL DEFAULT 'On',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cbd_led_data`
--

LOCK TABLES `cbd_led_data` WRITE;
/*!40000 ALTER TABLE `cbd_led_data` DISABLE KEYS */;
INSERT INTO `cbd_led_data` VALUES (1,'สวัสดี','ที่อยู่','On'),(2,'สวัสดี','ที่อยู่','On'),(3,'สวัสดี','ที่อยู่','On'),(4,'สวัสดี','ที่อยู่','On'),(5,'à¸ªà¸§à¸±à¸ªà¸”à¸µ','à¸—à¸µà¹ˆà¸à¸¢à¸¹à¹ˆ','On'),(6,'à¸”à¸”à¸”à¸”','à¸”à¸”à¸”à¸à¸«à¸³à¸³à¸žà¸žà¸³à¸Ÿ','On'),(7,'à¸à¸²à¸£à¸¥à¸°à¸„à¸£à¸±à¹‰à¸‡à¸«à¸™à¸¶à','à¸à¸²à¸£à¸¥à¸°à¸„à¸£à¸±à¹‰à¸‡à¸«à¸™à¸¶à¹ˆà¸‡123','On'),(8,'à¸«à¸Ÿà¸«','à¹†à¹†à¹†','On'),(9,'à¸™à¸£à¸¢à¸£à¸™à¸¢','à¸™à¸¢à¸£à¸¢à¸™à¸£à¸™à¸™','On'),(10,'ddd','wwww','On'),(11,'à¸à¸à¸à¸à¸','à¸«à¸«à¸«à¸«à¸«','On');
/*!40000 ALTER TABLE `cbd_led_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` VALUES (63,'test1','test1test1test1',NULL,NULL),(64,'test122','test1test1test122',NULL,NULL),(65,'dfsd','dfsd',NULL,NULL),(66,'eee','eeee',NULL,NULL),(67,'sss','qqqq',NULL,NULL),(68,'d','d',NULL,NULL),(69,'d','d',NULL,NULL);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `spot_data`
--

DROP TABLE IF EXISTS `spot_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `spot_data` (
  `ID` int(6) NOT NULL AUTO_INCREMENT,
  `BRAND` varchar(50) NOT NULL COMMENT 'ชื่อสินค้า',
  `SpotName` varchar(50) NOT NULL COMMENT 'ชื่อ Spot ที่ใช้',
  `JobNo` varchar(20) NOT NULL,
  `AE` varchar(20) NOT NULL COMMENT 'ชือ Sale ที่ดูแล',
  `MEDIA` varchar(10) NOT NULL COMMENT 'CBD หรือ Aroy',
  `LOCATION` int(3) NOT NULL COMMENT 'สถานที่ตั้งจอ',
  `ClientName` varchar(50) NOT NULL COMMENT 'ชื่อลูกค้า',
  `StartDate` date NOT NULL COMMENT 'วันที่ on',
  `COMMENT` tinytext NOT NULL,
  `AddDate` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `spot_data`
--

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `image` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=125 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (18,'Joseph','Harman','1.jpg'),(21,'Yolanda','Green','5.jpg'),(22,'Cara','Gariepy','7.jpg'),(23,'Christine','Johnson','11.jpg'),(24,'Alana','Decruze','12.jpg'),(121,'img1','1','924113380.jpg'),(70,'Cindy','Canady','18211.jpg'),(73,'Daphne','Frost','1577223405.jpg'),(122,'img2','2','2005385576.jpg'),(71,'Christina','Wilke','9248.jpg'),(68,'Roy','Newton','27282.jpg'),(75,'ddd','ddd','1866395331.jpg'),(123,'img3','3','1511168484.jpg'),(124,'img4','4','1019073565.jpg');
/*!40000 ALTER TABLE `users` 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-22 16:50:46

📁 Sid Gifari File Manager