Da

✏️ Editing: nitessat_meet.sql

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

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

USE `nitessat_meet`;

--
-- Table structure for table `appointments`
--

DROP TABLE IF EXISTS `appointments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `appointments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_name` varchar(150) NOT NULL,
  `patient_tel` varchar(20) NOT NULL,
  `patient_user_id` int(11) DEFAULT NULL,
  `appointment_date` date NOT NULL,
  `appointment_time` time NOT NULL,
  `department` varchar(100) NOT NULL,
  `notes` text DEFAULT NULL,
  `status` enum('รออนุมัติ','อนุมัติ','ยกเลิก') NOT NULL DEFAULT 'รออนุมัติ',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `patient_user_id` (`patient_user_id`),
  CONSTRAINT `appointments_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_patient_user` FOREIGN KEY (`patient_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `appointments`
--

LOCK TABLES `appointments` WRITE;
/*!40000 ALTER TABLE `appointments` DISABLE KEYS */;
INSERT INTO `appointments` VALUES (1,'นายสมหวัง ตั้งใจ','0812345678',NULL,'2025-06-05','09:00:00','อายุรกรรม','ตรวจสุขภาพประจำปี','อนุมัติ',2,'2025-06-07 12:18:46'),(2,'นางสาวมานี มีนา','0823456789',NULL,'2025-06-02','10:30:00','ทันตกรรม','ขูดหินปูน','รออนุมัติ',3,'2025-06-07 12:18:46'),(3,'นายปิติ ชูใจ','0834567890',NULL,'2025-05-28','13:00:00','แผนกผิวหนัง','ปรึกษาเรื่องสิว','อนุมัติ',2,'2025-06-07 12:18:46'),(4,'นางสุดา ใจงาม','0845678901',NULL,'2025-05-23','11:00:00','กุมารเวชกรรม','ฉีดวัคซีนบุตร','ยกเลิก',4,'2025-06-07 12:18:46'),(5,'นายมานะ อดทน','0856789012',NULL,'2025-05-13','14:00:00','อายุรกรรม','ติดตามอาการเบาหวาน','อนุมัติ',5,'2025-06-07 12:18:46'),(6,'นายมานะ อดทน','0856789012',NULL,'2025-06-07','19:33:00','อายุรกรรม','---','อนุมัติ',1,'2025-06-07 12:33:26'),(7,'นางสุดา ใจงาม','0845678901',NULL,'2025-06-07','12:41:00','ทันตกรรม','---','รออนุมัติ',2,'2025-06-07 12:36:25'),(8,'คนไข้วันนี้','0998887766',NULL,'2025-06-07','10:00:00','อายุรกรรม','เคสทดสอบสำหรับวันนี้','อนุมัติ',1,'2025-06-07 12:49:53'),(9,'นายสมชาย  รักษาดี','0956029737',6,'2025-06-08','08:00:00','อายุรกรรม','----','อนุมัติ',1,'2025-06-07 13:22:33'),(10,'สมศักดิ์ รักษาดี','0956029737',6,'2025-06-09','13:00:00','ทันตกรรม','---','อนุมัติ',1,'2025-06-07 13:26:09');
/*!40000 ALTER TABLE `appointments` 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,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `role` enum('admin','staff','patient') NOT NULL DEFAULT 'staff',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 (1,'admin','$2y$10$QkTUWgx4M9TJtm0g8roUheeOs4rUiTtZY.5QyzFS8qhBCkfHF5X42','ผู้ดูแลระบบ','admin','2025-06-07 12:18:45'),(2,'wirat','$2y$10$0BbAvlRI4O.66yvePeQyf.y74I6dhliCZQjjETVpyJpmuB8iz2M5q','วิรัตน์ สวัสดี','staff','2025-06-07 12:18:45'),(3,'somsri','$2y$10$E9s0B9kC7hX5zJ4K9l.dduU6yB.9j7uY2eZ.F.p3q9Q6rR8bO4U.S','สมศรี มีใจ','staff','2025-06-07 12:18:45'),(4,'somchai','$2y$10$E9s0B9kC7hX5zJ4K9l.dduU6yB.9j7uY2eZ.F.p3q9Q6rR8bO4U.S','สมชาย ใจดี','staff','2025-06-07 12:18:45'),(5,'supansa','$2y$10$E9s0B9kC7hX5zJ4K9l.dduU6yB.9j7uY2eZ.F.p3q9Q6rR8bO4U.S','สุพรรษา ยิ้มแย้ม','staff','2025-06-07 12:18:45'),(6,'patient1','$2y$10$3olisWbmaAgRsWsFzXtezOvhFt4BdPhl2xumxElb/aTqt1UsZ.pUG','สมศักดิ์ รักษาดี','patient','2025-06-07 13:10:11');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visits`
--

DROP TABLE IF EXISTS `visits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visits` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `visit_date` date NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `visit_time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `date_ip` (`visit_date`,`ip_address`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visits`
--

LOCK TABLES `visits` WRITE;
/*!40000 ALTER TABLE `visits` DISABLE KEYS */;
INSERT INTO `visits` VALUES (1,'2025-06-07','::1','2025-06-07 12:21:22'),(2,'2025-06-07','127.0.0.1','2025-06-07 13:21:29'),(3,'2025-06-08','::1','2025-06-08 11:15:25');
/*!40000 ALTER TABLE `visits` 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:53:41

📁 Sid Gifari File Manager