-- MySQL dump 10.13  Distrib 5.1.47, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: room
-- ------------------------------------------------------
-- Server version	5.1.47

/*!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 utf8 */;
/*!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 */;

--
-- Table structure for table `tb_division`
--

DROP TABLE IF EXISTS `tb_division`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_division` (
  `id_division` int(1) NOT NULL AUTO_INCREMENT,
  `name_division` varchar(50) NOT NULL,
  PRIMARY KEY (`id_division`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_division`
--

LOCK TABLES `tb_division` WRITE;
/*!40000 ALTER TABLE `tb_division` DISABLE KEYS */;
INSERT INTO `tb_division` VALUES (1,'สำนักปลัด'),(2,'กองคลัง'),(3,'กองช่าง'),(4,'กองสาธารณสุขและสิ่งแวดล้อม'),(5,'กองการศึกษา ศาสนาและวัฒนธรรม');
/*!40000 ALTER TABLE `tb_division` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_equipment`
--

DROP TABLE IF EXISTS `tb_equipment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_equipment` (
  `id_equipment` int(2) NOT NULL AUTO_INCREMENT,
  `name_equipment` varchar(250) NOT NULL,
  PRIMARY KEY (`id_equipment`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_equipment`
--

LOCK TABLES `tb_equipment` WRITE;
/*!40000 ALTER TABLE `tb_equipment` DISABLE KEYS */;
INSERT INTO `tb_equipment` VALUES (1,'โน๊ตบุ๊ค'),(2,'ไมค์ลอย'),(3,'ไมค์คอนเฟอร์เรน'),(4,'โปรเจ๊คเตอร์'),(5,'อาหารว่าง'),(6,'อาหารเที่ยง'),(7,'ถ่ายรูป'),(8,'ถ่ายวิดีโอ');
/*!40000 ALTER TABLE `tb_equipment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_event`
--

DROP TABLE IF EXISTS `tb_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_member` int(3) NOT NULL,
  `status` int(1) NOT NULL,
  `rooms` int(3) NOT NULL,
  `title` varchar(100) NOT NULL,
  `start` varchar(30) NOT NULL,
  `end` varchar(30) NOT NULL,
  `color` varchar(30) NOT NULL,
  `division` varchar(50) NOT NULL,
  `people` int(3) NOT NULL,
  `style` varchar(50) NOT NULL,
  `equipment` varchar(250) NOT NULL,
  `member` varchar(200) NOT NULL,
  `etc` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='ทดสอบปฏิทิน';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_event`
--

LOCK TABLES `tb_event` WRITE;
/*!40000 ALTER TABLE `tb_event` DISABLE KEYS */;
INSERT INTO `tb_event` VALUES (23,1,0,1,'อบรม','2020-07-27T01:11:00','2020-07-28T01:11:00','#2f3fbc','1',10,'3','โน๊ตบุ๊ค,โปรเจ๊คเตอร์,ถ่ายรูป','แอดมิน ระบบ','กิจกรรมประชุมประจำเดือน'),(28,1,0,1,'วิชาการ','2021-01-01T16:11:00','2021-01-01T18:10:00','#2f3fbc','1',3,'1','ไมค์ลอย,อาหารว่าง','แอดมิน  ระบบ','');
/*!40000 ALTER TABLE `tb_event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_item`
--

DROP TABLE IF EXISTS `tb_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_item` (
  `id_item` int(3) NOT NULL,
  `type_item` varchar(20) NOT NULL,
  `name_item` varchar(250) NOT NULL,
  PRIMARY KEY (`id_item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_item`
--

LOCK TABLES `tb_item` WRITE;
/*!40000 ALTER TABLE `tb_item` DISABLE KEYS */;
INSERT INTO `tb_item` VALUES (12,'equipment','ไมค์ลอย'),(10,'equipment','โน๊ตบุ๊ค'),(11,'equipment','โปรเจคเตอร์'),(8,'style','ชั้นเรียน'),(9,'style','อื่นๆ'),(7,'style','ตัวยู เต็มห้อง'),(6,'style','ตัวยู ครึ่งห้อง'),(5,'division','กองการศึกษา ศาสนาและวัฒนธรรม'),(4,'division','กองสาธารณสุขและสิ่งแวดล้อม'),(3,'division','กองช่าง'),(2,'division','กองคลัง'),(1,'division','สำนักปลัด'),(13,'equipment','ไมค์คอนเฟอร์เรน'),(14,'equipment','ถ่ายรูป'),(15,'equipment','ถ่ายวีดีโอ'),(16,'equipment','อาหารว่าง'),(17,'equipment','อาหารเที่ยง');
/*!40000 ALTER TABLE `tb_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_member`
--

DROP TABLE IF EXISTS `tb_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_member` (
  `id_member` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `ntitle` varchar(10) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `status` varchar(5) NOT NULL,
  `position` varchar(200) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `active` int(1) NOT NULL,
  `login_date` datetime NOT NULL,
  `login_times` int(6) NOT NULL,
  `create_date` datetime NOT NULL,
  `FilesName` varchar(20) NOT NULL,
  PRIMARY KEY (`id_member`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_member`
--

LOCK TABLES `tb_member` WRITE;
/*!40000 ALTER TABLE `tb_member` DISABLE KEYS */;
INSERT INTO `tb_member` VALUES (1,'admin','123456','นาย','แอดมิน','ระบบ','admin@mail.com','admin','ผู้ดูแลระบบ','0999999999',1,'2021-02-22 10:02:35',21,'2020-07-01 00:00:00',''),(2,'member','123456','นาย','วรเวธน์','ศรีสุขา','999@hotmail.com','user','นักประชาสัมพันธ์','0999999999',1,'2020-08-12 16:03:46',2,'2020-07-05 00:00:00','woravets.jpg');
/*!40000 ALTER TABLE `tb_member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_rooms`
--

DROP TABLE IF EXISTS `tb_rooms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_rooms` (
  `id_rooms` int(3) NOT NULL AUTO_INCREMENT,
  `name_rooms` varchar(200) NOT NULL,
  `people_rooms` int(4) NOT NULL,
  `color_rooms` varchar(20) NOT NULL,
  `image_rooms` varchar(250) NOT NULL,
  `detail_rooms` text NOT NULL,
  PRIMARY KEY (`id_rooms`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_rooms`
--

LOCK TABLES `tb_rooms` WRITE;
/*!40000 ALTER TABLE `tb_rooms` DISABLE KEYS */;
INSERT INTO `tb_rooms` VALUES (1,'ประชุม 1',200,'#2f3fbc','DSC_9168.JPG','ชั้น 2 อาคารอเนกประสงค์');
/*!40000 ALTER TABLE `tb_rooms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_style`
--

DROP TABLE IF EXISTS `tb_style`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_style` (
  `id_style` int(10) NOT NULL AUTO_INCREMENT,
  `name_style` varchar(100) NOT NULL,
  PRIMARY KEY (`id_style`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_style`
--

LOCK TABLES `tb_style` WRITE;
/*!40000 ALTER TABLE `tb_style` DISABLE KEYS */;
INSERT INTO `tb_style` VALUES (1,'ประชุมทั่วไป'),(2,'ตัวยู เต็มห้อง'),(3,'ชั้นเรียน'),(4,'ประชุมสภา'),(5,'อื่นๆ');
/*!40000 ALTER TABLE `tb_style` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'room'
--
/*!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 2026-07-22  0:00:13