Da

✏️ Editing: schedart_doc_db.sql

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

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

USE `schedart_doc_db`;

--
-- Table structure for table `tbl_department`
--

DROP TABLE IF EXISTS `tbl_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_department` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_name` varchar(100) NOT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_department`
--

LOCK TABLES `tbl_department` WRITE;
/*!40000 ALTER TABLE `tbl_department` DISABLE KEYS */;
INSERT INTO `tbl_department` VALUES (1,'IT Support'),(2,'Account'),(3,'Logistics'),(4,'Human Resources'),(5,'Purchase'),(6,'Manager');
/*!40000 ALTER TABLE `tbl_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_doc_file`
--

DROP TABLE IF EXISTS `tbl_doc_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_doc_file` (
  `f_id` int(11) NOT NULL AUTO_INCREMENT,
  `fileID` varchar(100) NOT NULL,
  `filename` varchar(200) NOT NULL COMMENT 'ชื่อเอกสาร',
  `t_id` int(11) NOT NULL COMMENT 'ประเภทเอกสาร',
  `doc_file` varchar(200) NOT NULL COMMENT 'ไฟล์เอกสาร',
  `date_get` date NOT NULL COMMENT 'วันที่พิมพ์',
  `date_up` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'วันที่อัพเอกสาร',
  `m_username` varchar(20) NOT NULL COMMENT 'ส่งให้ผู้ใช้',
  `d_id` int(11) NOT NULL COMMENT 'ส่งให้แผนก',
  `qty` int(11) NOT NULL COMMENT 'จำนวนการโหลด',
  `status` int(11) NOT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_doc_file`
--

LOCK TABLES `tbl_doc_file` WRITE;
/*!40000 ALTER TABLE `tbl_doc_file` DISABLE KEYS */;
INSERT INTO `tbl_doc_file` VALUES (1,'กข001','เอกสารการอบรม',5,'28940735320250513_031925.pdf','2022-06-26','2022-06-25 18:32:51','member',1,4712,0),(2,'อส.01','เอกสารฝึกงาน',3,'89716169120220625_230325.pdf','2022-06-26','2022-06-25 18:33:46','member',2,25013,1),(3,'อส.02','เอกสารสำคัญ',5,'53222416320220625_230332.pdf','2022-06-25','2022-06-25 18:34:23','boss',4,2507,0),(4,'อส.03','เอกสารคำสั่ง',4,'108574586120220625_230344.pdf','2022-06-26','2022-06-25 18:34:41','member',3,7004,1),(5,'อส.04','เอกสารการอบรม2',2,'94157958420250514_035359.pdf','2022-06-24','2022-06-25 18:47:42','member',1,3503,0),(7,'xx','yy',1,'44830173920250513_032144.pdf','2025-05-13','2025-05-13 03:21:10','boss',1,12,0),(8,'xxxx','yyxxx',4,'179779706020250516_150458.pdf','2025-05-14','2025-05-16 15:04:58','one',1,8,0);
/*!40000 ALTER TABLE `tbl_doc_file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_member`
--

DROP TABLE IF EXISTS `tbl_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_member` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'PK',
  `m_username` varchar(100) NOT NULL COMMENT 'ไอดีผู้ใช้',
  `m_password` varchar(100) NOT NULL COMMENT 'รหัสผ่าน',
  `m_name` varchar(100) NOT NULL COMMENT 'ชื่อ-นามสกุล',
  `d_id` varchar(100) NOT NULL COMMENT 'FK tbl_department',
  `m_level` varchar(100) NOT NULL COMMENT 'สถานะ',
  `m_img` varchar(250) NOT NULL COMMENT 'รูปภาพ',
  PRIMARY KEY (`m_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_member`
--

LOCK TABLES `tbl_member` WRITE;
/*!40000 ALTER TABLE `tbl_member` DISABLE KEYS */;
INSERT INTO `tbl_member` VALUES (1,'admin','admin','admin','1','admin','176138106920250531_061528.png'),(2,'skd','skd','Document SKD','6','admin','56545308920220626_042233.png'),(3,'one','one','Kanokwan','2','member','178072269320220626_042239.png'),(4,'boss','boss','boss_boss','2','boss','165557995920220626_042246.png');
/*!40000 ALTER TABLE `tbl_member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_type`
--

DROP TABLE IF EXISTS `tbl_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_type` (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `t_name` varchar(100) NOT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_type`
--

LOCK TABLES `tbl_type` WRITE;
/*!40000 ALTER TABLE `tbl_type` DISABLE KEYS */;
INSERT INTO `tbl_type` VALUES (1,'หนังสือภายใน'),(2,'หนังสือภายนอก'),(3,'หนังสือประทับตา'),(4,'หนังสือสั่งการ'),(5,'หนังสือหลักฐานทางราชการ');
/*!40000 ALTER TABLE `tbl_type` 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:24:06

📁 Sid Gifari File Manager