Da

✏️ Editing: gstengin_db1.sql

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

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

USE `gstengin_db1`;

--
-- Table structure for table `service`
--

DROP TABLE IF EXISTS `service`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service` (
  `id_ser` int(11) NOT NULL AUTO_INCREMENT,
  `name_ser` text NOT NULL,
  `detail_ser` text NOT NULL,
  `date_ser` date NOT NULL,
  `status_ser` int(11) NOT NULL,
  PRIMARY KEY (`id_ser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service`
--

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

--
-- Table structure for table `tb_about`
--

DROP TABLE IF EXISTS `tb_about`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_about` (
  `id_abo` int(11) NOT NULL AUTO_INCREMENT,
  `title_abo` text NOT NULL,
  `detial_abo` text NOT NULL,
  `image_abo` text NOT NULL,
  PRIMARY KEY (`id_abo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_about`
--

LOCK TABLES `tb_about` WRITE;
/*!40000 ALTER TABLE `tb_about` DISABLE KEYS */;
INSERT INTO `tb_about` VALUES (1,'GST Engineering','à¹€à¸›à¹‡à¸™à¸œà¸¹à¹‰à¸¡à¸µà¸„à¸§à¸²à¸¡à¸£à¸¹à¹‰à¹à¸¥à¸°à¹€à¸Šà¸µà¹ˆà¸¢à¸§à¸Šà¸²à¸à¸”à¹‰à¸²à¸™à¸–à¸±à¸‡à¸ªà¹à¸•à¸™à¹€à¸¥à¸ª à¸–à¸±à¸‡à¸à¸£à¸à¸‡à¸„à¸§à¸²à¸¡à¸”à¸±à¸™ à¸žà¸£à¹‰à¸à¸¡à¸”à¹‰à¸§à¸¢à¸šà¸¸à¸„à¸¥à¸²à¸à¸£à¸—à¸µà¹ˆà¸¡à¸µà¸„à¸§à¸²à¸¡à¸£à¸¹à¹‰à¸„à¸§à¸²à¸¡à¸ªà¸²à¸¡à¸²à¸£à¸– à¸—à¸µà¹ˆà¸žà¸£à¹‰à¸à¸¡à¹ƒà¸«à¹‰à¸šà¸£à¸´à¸à¸²à¸£à¸¥à¸¹à¸à¸„à¹‰à¸²à¹à¸šà¸šà¸„à¸£à¸šà¸§à¸‡à¸ˆà¸£à¸•à¸±à¹‰à¸‡à¹à¸•à¹ˆà¹€à¸£à¸´à¹ˆà¸¡à¸•à¹‰à¸™à¸ˆà¸™à¸–à¸¶à¸‡à¸šà¸£à¸´à¸à¸²à¸£à¸«à¸¥à¸±à¸‡à¸à¸²à¸£à¸‚à¸²à¸¢','About_20240129_044344.jpg');
/*!40000 ALTER TABLE `tb_about` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_contact`
--

DROP TABLE IF EXISTS `tb_contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_contact` (
  `id_con` int(11) NOT NULL AUTO_INCREMENT,
  `add_con` text NOT NULL,
  `phone_con` text NOT NULL,
  `email_con` text NOT NULL,
  `fb_con` text NOT NULL,
  `youtube_con` text NOT NULL,
  `ig_con` text NOT NULL,
  PRIMARY KEY (`id_con`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_contact`
--

LOCK TABLES `tb_contact` WRITE;
/*!40000 ALTER TABLE `tb_contact` DISABLE KEYS */;
INSERT INTO `tb_contact` VALUES (1,'42 à¸‹à¸à¸¢à¸£à¸²à¸¡à¸à¸´à¸™à¸—à¸£à¸² 14 à¹à¸¢à¸ 9 à¸–à¸™à¸™à¸£à¸²à¸¡à¸à¸´à¸™à¸—à¸£à¸² à¹à¸‚à¸§à¸‡à¸—à¹ˆà¸²à¹à¸£à¹‰à¸‡ à¹€à¸‚à¸•à¸šà¸²à¸‡à¹€à¸‚à¸™ à¸à¸£à¸¸à¸‡à¹€à¸—à¸žà¸¡à¸«à¸²à¸™à¸„à¸£','0971532141','gstech026@gmail.com','https://www.facebook.com/profile.php?id=61553185719202&mibextid=ZbWKwL','','');
/*!40000 ALTER TABLE `tb_contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_faqs`
--

DROP TABLE IF EXISTS `tb_faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_faqs` (
  `id_faqs` int(11) NOT NULL AUTO_INCREMENT,
  `q_faqs` text NOT NULL,
  `a_faqs` text NOT NULL,
  `status_faqs` int(11) NOT NULL,
  PRIMARY KEY (`id_faqs`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_faqs`
--

LOCK TABLES `tb_faqs` WRITE;
/*!40000 ALTER TABLE `tb_faqs` DISABLE KEYS */;
INSERT INTO `tb_faqs` VALUES (1,'à¸œà¸¥à¸´à¸•à¸ à¸±à¸“à¸‘à¹Œ à¸¡à¸µà¸à¸°à¹„à¸£à¸šà¹‰à¸²à¸‡ ','Filter   tank  and  pressure vessel ',2),(2,'à¸‡à¸²à¸™à¸šà¸£à¸´à¸à¸²à¸£à¸—à¸³à¸à¸°à¹„à¸£à¸šà¹‰à¸²à¸‡','Repair tank  ,  PT   test    Repair agitator  and Modify',2),(5,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ 3','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 3 ',2),(6,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ 4','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 4',2),(7,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ  5','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 5',2),(8,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ 6','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 6',2),(9,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ  7','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 7',2),(10,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ 8','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 8',2),(11,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ  9','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 9',2),(12,'à¸„à¸³à¸–à¸²à¸¡à¸‚à¹‰à¸à¸—à¸µà¹ˆ 10','à¸„à¸³à¸•à¸à¸šà¸‚à¹‰à¸à¸—à¸µà¹ˆ 10',2);
/*!40000 ALTER TABLE `tb_faqs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_fluid`
--

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

--
-- Dumping data for table `tb_fluid`
--

LOCK TABLES `tb_fluid` WRITE;
/*!40000 ALTER TABLE `tb_fluid` DISABLE KEYS */;
INSERT INTO `tb_fluid` VALUES (1,'ให้บริการ ผลิต ติดตั้ง และซ่อมบำรุง ถังสแตนเลส ไซโล และ ฮอปเปอร์ และ Agitator','file.png');
/*!40000 ALTER TABLE `tb_fluid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_head`
--

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

--
-- Dumping data for table `tb_head`
--

LOCK TABLES `tb_head` WRITE;
/*!40000 ALTER TABLE `tb_head` DISABLE KEYS */;
INSERT INTO `tb_head` VALUES (1,'G.S.T. à¹€à¸›à¹‡à¸™à¸œà¸¹à¹‰à¸œà¸¥à¸´à¸• à¸•à¸´à¸”à¸•à¸±à¹‰à¸‡ à¸ˆà¸³à¸«à¸™à¹ˆà¸²à¸¢ à¹à¸¥à¸°à¸šà¸£à¸´à¸à¸²à¸£à¸‹à¹ˆà¸à¸¡à¸šà¸³à¸£à¸¸à¸‡ à¸œà¸¥à¸´à¸•à¸ à¸±à¸“à¸‘à¹Œà¸–à¸±à¸‡à¸ªà¹à¸•à¸™à¹€à¸¥à¸ª à¸–à¸±à¸‡à¸œà¸ªà¸¡ à¸–à¸±à¸‡à¸à¸£à¸à¸‡à¸„à¸§à¸²à¸¡à¸”à¸±à¸™ à¹ƒà¸šà¸à¸§à¸™ à¹à¸¥à¸°à¸œà¸¥à¸´à¸•à¸ à¸±à¸“à¸‘à¹Œà¸—à¸µà¹ˆà¹ƒà¸Šà¹‰à¸ªà¸³à¸«à¸£à¸±à¸š à¸à¸²à¸£à¹à¸›à¸£à¸¹à¸›à¸‚à¸à¸‡à¹€à¸«à¸¥à¸§à¸•à¹ˆà¸²à¸‡à¹† à¹€à¸Šà¹ˆà¸™ à¸›à¸´à¹‚à¸•à¸£à¹€à¸„à¸¡à¸µ à¹€à¸„à¸£à¸·à¹ˆà¸à¸‡à¸”à¸·à¹ˆà¸¡ à¹à¸¥à¸°à¹€à¸§à¸Šà¸ à¸±à¸“à¸‘à¹Œ à¸”à¹‰à¸§à¸¢à¸›à¸£à¸°à¸ªà¸šà¸à¸²à¸£à¸“à¹Œà¹à¸¥à¸°à¹€à¸—à¸„à¸™à¸´à¸„à¸à¸²à¸£à¸—à¸³à¸‡à¸²à¸™à¸—à¸²à¸‡à¸”à¹‰à¸²à¸™à¸™à¸µà¹‰à¹‚à¸”à¸¢à¹€à¸‰à¸žà¸²à¸° à¸—à¸³à¹ƒà¸«à¹‰à¸œà¸¥à¸´à¸•à¸ à¸±à¸“à¸‘à¹Œà¸‚à¸à¸‡à¹€à¸£à¸²à¸¡à¸µà¸„à¸¸à¸“à¸ à¸²à¸žà¹à¸¥à¸°à¸›à¸¥à¸à¸”à¸ à¸±à¸¢à¸•à¸²à¸¡à¸¡à¸²à¸•à¸£à¸à¸²à¸™à¸ªà¸²à¸à¸¥    G.S.T. Could Supply stainless and Cabon steel tank Pressure Vessel and Equipment  for  liquid ; beverage ','Header_20240206_110344.png');
/*!40000 ALTER TABLE `tb_head` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_mem`
--

DROP TABLE IF EXISTS `tb_mem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_mem` (
  `id_mem` int(11) NOT NULL AUTO_INCREMENT,
  `fname_mem` text NOT NULL,
  `lname_mem` text NOT NULL,
  `position_mem` text NOT NULL,
  `tel_mem` text NOT NULL,
  `email_mem` text NOT NULL,
  `status_mem` int(11) NOT NULL,
  `img_mem` text NOT NULL,
  PRIMARY KEY (`id_mem`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_mem`
--

LOCK TABLES `tb_mem` WRITE;
/*!40000 ALTER TABLE `tb_mem` DISABLE KEYS */;
INSERT INTO `tb_mem` VALUES (1,'à¸„à¸²à¸£à¸Šà¸±à¸¢','à¹à¸ªà¸‡à¸£à¸±à¸•à¸™à¹Œ','à¸œà¸¹à¹‰à¸ˆà¸±à¸”à¸à¸²à¸£à¸ªà¹ˆà¸§à¸™à¸šà¸£à¸´à¸à¸²à¸£','0847346997','gstech026@gmail.com',2,'à¸„à¸²à¸£à¸Šà¸±à¸¢_à¹à¸ªà¸‡à¸£à¸±à¸•à¸™à¹Œ_122929012024.jpg');
/*!40000 ALTER TABLE `tb_mem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_mete`
--

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

--
-- Dumping data for table `tb_mete`
--

--
-- Table structure for table `tb_ser`
--

DROP TABLE IF EXISTS `tb_ser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_ser` (
  `id_ser` int(11) NOT NULL AUTO_INCREMENT,
  `type_ser` int(11) NOT NULL,
  `title_ser` text NOT NULL,
  `date_ser` date NOT NULL,
  `loca_ser` text NOT NULL,
  `detail_ser` text NOT NULL,
  `cover_ser` text NOT NULL,
  `count_ser` int(11) NOT NULL,
  `img_ser` text NOT NULL,
  `status_ser` int(11) NOT NULL,
  PRIMARY KEY (`id_ser`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_ser`
--

LOCK TABLES `tb_ser` WRITE;
/*!40000 ALTER TABLE `tb_ser` DISABLE KEYS */;
INSERT INTO `tb_ser` VALUES (10,1,'G.S.T. Engineering','2023-12-12','-','  ','1_1_20231212_060317_cover.png',2,'1_1_20231212_060317_2.jpg/1_1_20231212_060317_1.jpg/1_1_20231212_060317_0.jpg/',2),(11,2,'G.S.T. Engineering','2023-12-01','-','  ','2_1_20230112_060703_cover.png',2,'2_1_20230112_060703_2.jpg/2_1_20230112_060703_1.jpg/2_1_20230112_060703_0.jpg/',2),(28,3,'Repair Jacket tank ','2023-12-26','à¸¥à¸²à¸”à¸à¸£à¸°à¸šà¸±à¸‡','','3_1_20231226_125731_cover.jpg',0,'3_1_20231226_125731_0./',1),(29,3,'Repair Jacket tank ','2023-12-25','à¸¥à¸²à¸”à¸à¸£à¸°à¸šà¸±à¸‡',' Repair Jacket tank','3_1_20231225_010240_cover.jpg',1,'3_1_20231225_010240_1.jpg/3_1_20231225_010240_0.jpg/',2),(30,3,'Repair Agitator ','2024-02-07','à¸Šà¸¥à¸šà¸¸à¸£à¸µ',' Agitator   ','3_1_20240207_010832_cover.jpg',0,'3_1_20240207_010832_0.jpg/',2);
/*!40000 ALTER TABLE `tb_ser` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `name_user` text NOT NULL,
  `user_user` text NOT NULL,
  `pass_user` text NOT NULL,
  `level_user` int(11) NOT NULL,
  `status_user` int(11) NOT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'ทศพล','admin','123456',1,1);
/*!40000 ALTER TABLE `user` 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:20:55

📁 Sid Gifari File Manager