Da

✏️ Editing: nahaewwi_waste_bank.sql

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

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

USE `nahaewwi_waste_bank`;

--
-- Table structure for table `activity_logs`
--

DROP TABLE IF EXISTS `activity_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activity_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `action` varchar(20) DEFAULT NULL,
  `table_name` varchar(50) DEFAULT NULL,
  `record_id` int(11) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`log_id`),
  KEY `user_id` (`user_id`),
  KEY `created_at` (`created_at`),
  CONSTRAINT `activity_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activity_logs`
--

LOCK TABLES `activity_logs` WRITE;
/*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */;
INSERT INTO `activity_logs` VALUES (3,1,'cancel','withdrawals',3,'ยกเลิกรายการถอนเงิน','2025-04-07 01:54:02'),(4,1,'cancel','withdrawals',4,'ยกเลิกรายการถอนเงิน','2025-04-07 01:54:54'),(5,1,'cancel','withdrawals',5,'ยกเลิกรายการถอนเงิน','2025-04-07 01:54:58'),(6,1,'insert','transactions',17,'เพิ่มรายการขยะ: วัสดุ ID 17 น้ำหนัก 1 กก.','2025-04-07 11:52:06'),(7,1,'insert','transactions',18,'เพิ่มรายการขยะ: วัสดุ ID 23 น้ำหนัก 0.03 กก.','2025-04-07 11:52:06'),(8,1,'cancel','withdrawals',9,'ยกเลิกรายการถอนเงิน','2025-04-07 12:13:17'),(9,1,'insert','withdrawals',10,'ขอถอนเงินจำนวน 208 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 12:14:52'),(10,1,'cancel','withdrawals',10,'ยกเลิกรายการถอนเงิน','2025-04-07 12:39:28'),(11,1,'insert','withdrawals',11,'ขอถอนเงินจำนวน 55 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 12:52:36'),(12,1,'confirm','withdrawals',11,'อนุมัติคำขอถอนเงินของ ชัยพัฒน์ นนทจันทร์ จำนวน 55.00 บาท','2025-04-07 12:56:47'),(13,1,'insert','withdrawals',12,'ขอถอนเงินจำนวน 8 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 13:00:56'),(14,1,'insert','withdrawals',13,'ขอถอนเงินจำนวน 100 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 13:01:28'),(15,1,'cancel','withdrawals',13,'ยกเลิกรายการถอนเงิน','2025-04-07 13:04:57'),(16,1,'login','users',1,'Login success','2025-04-07 14:00:20'),(17,1,'login','users',1,'Login success','2025-04-07 14:00:54'),(18,1,'login','users',1,'Login success','2025-04-07 14:05:52'),(19,1,'login','users',1,'Login success','2025-04-07 14:08:38'),(20,1,'login','users',1,'Login success','2025-04-07 14:09:18'),(21,1,'login','users',1,'Login success','2025-04-07 14:09:53'),(22,1,'login','users',1,'Login success','2025-04-07 14:11:30'),(23,1,'login','users',1,'Login success','2025-04-07 14:11:30'),(24,1,'login','users',1,'Login success','2025-04-07 14:11:31'),(25,1,'login','users',1,'Login success','2025-04-07 14:11:32'),(26,1,'login','users',1,'Login success','2025-04-07 14:11:33'),(27,1,'login','users',1,'Login success','2025-04-07 14:14:44'),(28,1,'login','users',1,'Login success','2025-04-07 14:16:04'),(29,1,'login','users',1,'Login success','2025-04-07 14:19:03'),(30,1,'login','users',1,'Login success','2025-04-07 14:19:24'),(31,1,'login','users',1,'Login success','2025-04-07 14:19:52'),(32,1,'login','users',1,'Login success','2025-04-07 14:25:37'),(33,1,'login','users',1,'Login success','2025-04-07 14:30:00'),(34,1,'login','users',1,'Login success','2025-04-07 14:30:15'),(35,1,'login','users',1,'Login success','2025-04-07 14:47:06'),(36,1,'login','users',1,'Login success','2025-04-07 14:47:08'),(37,1,'login','users',1,'Login success','2025-04-07 14:47:10'),(38,1,'login','users',1,'Login success','2025-04-07 14:47:11'),(39,1,'login','users',1,'Login success','2025-04-07 14:47:13'),(40,1,'login','users',1,'Login success','2025-04-07 15:42:24'),(41,1,'login','users',1,'Login success','2025-04-07 16:16:25'),(42,1,'login','users',1,'Login success','2025-04-07 16:20:29'),(43,1,'login','users',1,'Login success','2025-04-07 16:27:57'),(44,1,'login','users',1,'Login success','2025-04-07 16:46:28'),(45,1,'login','users',1,'Login success','2025-04-07 16:56:49'),(46,1,'login','users',1,'Login success','2025-04-07 17:13:55'),(47,1,'delete','members',30,'ลบสมาชิก (soft-delete)','2025-04-07 17:24:24'),(48,1,'delete','members',31,'ลบสมาชิก (soft-delete)','2025-04-07 17:24:28'),(49,1,'delete','members',32,'ลบสมาชิก (soft-delete)','2025-04-07 17:26:40'),(50,1,'delete','members',30,'ลบสมาชิก (soft-delete)','2025-04-07 17:35:34'),(51,1,'delete','members',31,'ลบสมาชิก (soft-delete)','2025-04-07 17:37:13'),(52,1,'restore','members',30,'กู้คืนสมาชิกที่ถูกลบ','2025-04-07 17:37:35'),(53,1,'restore','members',31,'กู้คืนสมาชิกที่ถูกลบ','2025-04-07 17:37:44'),(54,1,'insert','transactions',19,'เพิ่มรายการขยะ: วัสดุ ID 33 น้ำหนัก 5 กก.','2025-04-07 17:40:18'),(55,1,'insert','withdrawals',14,'ขอถอนเงินจำนวน 95 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 17:54:19'),(56,1,'cancel','withdrawals',14,'ยกเลิกรายการถอนเงิน','2025-04-07 17:56:20'),(57,1,'insert','withdrawals',15,'ขอถอนเงินจำนวน 95 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 17:56:31'),(58,1,'confirm','withdrawals',15,'อนุมัติคำขอถอนเงินของ ชัยพัฒน์ นนทจันทร์ จำนวน 95.00 บาท','2025-04-07 18:01:32'),(59,1,'edit','waste_types',32,'ปิดใช้งาน วัสดุ: test99','2025-04-07 18:22:33'),(60,1,'edit','waste_types',32,'เปิดใช้งาน วัสดุ: test99','2025-04-07 18:22:34'),(61,1,'edit','waste_types',32,'ปิดใช้งาน วัสดุ: test99','2025-04-07 18:22:35'),(62,1,'edit','waste_types',33,'ปิดใช้งาน วัสดุ: test999','2025-04-07 18:22:36'),(63,1,'edit','waste_types',32,'แก้ไขวัสดุขยะ:  (ID: 32)','2025-04-07 18:22:46'),(64,1,'edit','waste_types',32,'แก้ไขวัสดุขยะ:  (ID: 32)','2025-04-07 18:22:48'),(65,1,'add','waste_types',34,'เพิ่มวัสดุขยะ: test88','2025-04-07 18:24:21'),(66,1,'edit','waste_types',34,'ปิดใช้งาน วัสดุ: test88','2025-04-07 18:24:23'),(67,1,'edit','waste_types',32,'แก้ไขวัสดุ: test99 (ID: 32)','2025-04-07 18:27:31'),(68,1,'edit','waste_types',32,'แก้ไขวัสดุ: test77 (ID: 32)','2025-04-07 18:27:50'),(69,1,'add','waste_types',35,'เพิ่มวัสดุใหม่: หมวด test99, ชื่อ test66, ราคา 66, แต้ม 0','2025-04-07 18:32:18'),(70,1,'edit','waste_types',34,'เปิดใช้งาน วัสดุ: test88','2025-04-07 18:32:25'),(71,1,'edit','waste_types',33,'เปิดใช้งาน วัสดุ: test999','2025-04-07 18:32:26'),(72,1,'login','users',1,'Login success','2025-04-07 20:07:35'),(73,1,'login','users',1,'Login success','2025-04-07 20:08:04'),(74,1,'login','users',1,'Login success','2025-04-07 20:19:55'),(75,1,'login','users',1,'Login success','2025-04-07 20:57:28'),(76,1,'login','users',1,'Login success','2025-04-07 21:20:56'),(77,1,'insert','withdrawals',16,'ขอถอนเงินจำนวน 100 บาท | หมายเหตุ:  | ผู้ส่งคำขอ: admin_chaiphat','2025-04-07 21:21:11'),(78,1,'login','users',1,'Login success','2025-04-07 22:02:47'),(79,1,'cancel','withdrawals',16,'ยกเลิกรายการถอนเงิน','2025-04-07 22:11:14'),(80,1,'delete','transactions',19,'ลบ transaction_id 19 และย้ายไป archive','2025-04-07 22:46:29'),(81,1,'login','users',1,'Login success','2025-04-07 22:59:35'),(82,1,'login','users',1,'Login success','2025-04-07 23:01:54'),(83,1,'login','users',1,'Login success','2025-04-07 23:07:51'),(84,1,'delete','transactions',17,'ลบ transaction_id 17 และย้ายไป archive','2025-04-07 23:13:30'),(85,1,'login','users',1,'Login success','2025-04-08 00:24:35'),(86,1,'login','users',1,'Login success','2025-04-08 07:53:36'),(87,1,'login','users',1,'Login success','2025-04-08 09:24:28'),(88,1,'login','users',1,'Login success','2025-04-08 09:24:33'),(89,1,'login','users',1,'Login success','2025-04-08 09:24:37'),(90,1,'login','users',1,'Login success','2025-04-08 09:36:23'),(91,1,'login','users',1,'Login success','2025-04-10 19:31:10'),(92,1,'login','users',1,'Login success','2025-04-20 14:25:26'),(93,1,'login','users',1,'Login success','2025-05-14 12:48:10'),(94,1,'login','users',1,'Login success','2025-05-15 00:43:00'),(95,1,'insert','transactions',20,'เพิ่มรายการขยะ: วัสดุ ID 7 น้ำหนัก 0.1 กก.','2025-05-15 00:43:20'),(96,1,'login','users',1,'Login success','2025-05-18 23:01:28'),(97,1,'login','users',1,'Login success','2025-05-20 11:10:59'),(98,1,'login','users',1,'Login success','2025-05-21 12:19:44'),(99,1,'login','users',1,'Login success','2025-05-29 14:26:29'),(100,1,'login','users',1,'Login success','2025-06-04 14:11:38'),(101,1,'login','users',1,'Login success','2025-06-06 11:10:25'),(102,1,'insert','transactions',21,'เพิ่มรายการขยะ: วัสดุ ID 22 น้ำหนัก 10000 กก.','2025-06-06 11:13:40'),(103,1,'insert','withdrawals',17,'ขอถอนเงินจำนวน 195000 บาท | หมายเหตุ: เทส | ผู้ส่งคำขอ: admin_chaiphat','2025-06-06 11:14:35'),(104,1,'confirm','withdrawals',17,'อนุมัติคำขอถอนเงินของ ณัฐวุฒิ นาพันผล จำนวน 195000.00 บาท','2025-06-06 11:15:10'),(105,1,'delete','members',46,'ลบสมาชิก (soft-delete)','2025-06-06 11:28:38'),(106,1,'login','users',1,'Login success','2025-06-07 23:45:31'),(107,1,'login','users',1,'Login success','2025-06-12 16:40:15'),(108,1,'login','users',1,'Login success','2025-07-01 13:19:17'),(109,2,'login','users',2,'Login success','2025-07-01 13:37:33'),(110,2,'login','users',2,'Login success','2025-07-01 14:31:07'),(111,2,'login','users',2,'Login success','2025-07-01 15:38:40'),(112,2,'login','users',2,'Login success','2025-07-23 11:22:41'),(113,1,'login','users',1,'Login success','2025-08-18 16:56:29'),(114,1,'login','users',1,'Login success','2025-09-08 15:13:04');
/*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `class_rooms`
--

DROP TABLE IF EXISTS `class_rooms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class_rooms` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `teacher_name` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `class_rooms`
--

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

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `members` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `class_room` varchar(20) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `total_weight` decimal(10,2) DEFAULT 0.00,
  `total_point` int(11) DEFAULT 0,
  `total_money` decimal(10,2) DEFAULT 0.00,
  `created_at` datetime DEFAULT current_timestamp(),
  `class_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1=ใช้งาน, 0=ลบแล้ว',
  PRIMARY KEY (`member_id`),
  UNIQUE KEY `student_id` (`student_id`),
  KEY `fk_members_class` (`class_id`),
  CONSTRAINT `fk_members_class` FOREIGN KEY (`class_id`) REFERENCES `class_rooms` (`class_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `members`
--

LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;
INSERT INTO `members` VALUES (1,'111111','รักสะอาด ณ นาแห้ว','1/3','0812345677',0.00,0,0.00,'2025-04-03 18:32:00',NULL,1),(2,'111112','ทดสอบ ระบบ2','1/3','0812345677',0.00,0,0.00,'2025-04-03 19:15:23',NULL,1),(3,'111113','ชัยพัฒน์ นนทจันทร์','ครู','0822299661',0.00,0,0.00,'2025-04-04 00:08:06',NULL,1),(24,'111115','อนันต์ คำดี','4/1','812345670',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(25,'111116','เบญจวรรณ ศรีสุข','4/2','823456781',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(26,'111117','ชานินทร์ ยอดดี','4/3','834567892',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(27,'111118','ดวงใจ แก้วกล้า','4/1','845678903',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(28,'111119','เอกชาติ น้อยศรี','4/2','856789014',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(29,'111120','ฝนทิพย์ ใจแสน','4/3','867890125',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(30,'111121','กวิน รัตนา','4/1','0878901236',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(31,'111122','หทัยชนก จันทร์ดี','4/2','889012347',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(32,'111123','อิสรา กองดี','4/3','890123458',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(33,'111124','จินตนา สุขสวัสดิ์','4/1','801234569',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(34,'111125','กิตติศักดิ์ มณี','4/2','812345671',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(35,'111126','ลัดดาวัลย์ พรหมดี','4/3','823456782',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(36,'111127','มนัส บุญเยือน','4/1','834567893',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(37,'111128','นภสร ยิ้มย่าย','4/2','845678904',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(38,'111129','อรอนันต์ ใจเย็น','4/3','856789015',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(39,'111130','ภาคิน สุภาวัฒน์','4/1','867890126',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(40,'111131','รัชนก โสภา','4/2','878901237',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(41,'111132','สราวุธ มีชัย','4/3','889012348',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(42,'111133','ธิดารัตน์ อินทอง','4/1','890123459',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(43,'111134','วัชระ บัวเพชร','4/2','801234570',0.00,0,0.00,'2025-04-04 00:24:26',NULL,1),(44,'1000001','test','1/4','1111111111',0.00,0,0.00,'2025-04-07 01:01:26',NULL,1),(45,'151651','ทดสอบ 626 ฟหก','5/5','6529529529',0.00,0,0.00,'2025-04-07 17:38:51',NULL,1),(46,'04242','ณัฐวุฒิ นาพันผล','6/1','0640454005',0.00,0,0.00,'2025-06-06 11:12:51',NULL,0);
/*!40000 ALTER TABLE `members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
  `permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `menu_slug` varchar(100) NOT NULL,
  `can_view` tinyint(1) NOT NULL,
  `can_add` tinyint(1) NOT NULL,
  `can_edit` tinyint(1) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (11,1,'dashboard',1,1,1,1),(12,1,'members',1,1,1,1),(13,1,'add_transaction',1,1,1,1),(14,1,'transactions_list',1,1,1,1),(15,1,'add_withdrawal',1,1,1,1),(16,1,'withdrawals_list',1,1,1,1),(17,1,'report_overview',1,1,1,1),(18,1,'manage_waste_prices',1,1,1,1),(19,1,'role_manage',1,1,1,1),(20,1,'backup',1,1,1,1),(21,2,'dashboard',1,0,0,0),(22,2,'members',1,1,1,0),(23,2,'add_transaction',1,1,0,0),(24,2,'transactions_list',1,0,0,0),(25,2,'add_withdrawal',1,1,0,0),(26,2,'withdrawals_list',1,0,0,0),(27,2,'report_overview',1,0,0,0),(28,2,'manage_waste_prices',1,1,0,0),(29,2,'role_manage',0,0,0,0),(30,2,'backup',1,0,0,0),(31,3,'dashboard',1,0,0,0),(32,3,'members',0,0,0,0),(33,3,'add_transaction',0,0,0,0),(34,3,'transactions_list',1,0,0,0),(35,3,'add_withdrawal',0,0,0,0),(36,3,'withdrawals_list',1,0,0,0),(37,3,'report_overview',1,0,0,0),(38,3,'manage_waste_prices',0,0,0,0),(39,3,'role_manage',0,0,0,0),(40,3,'backup',0,0,0,0),(41,4,'dashboard',1,0,0,0),(42,4,'members',1,1,1,0),(43,4,'add_transaction',1,0,0,0),(44,4,'transactions_list',1,1,0,0),(45,4,'add_withdrawal',1,1,1,0),(46,4,'withdrawals_list',1,1,1,0),(47,4,'report_overview',1,1,0,0),(48,4,'manage_waste_prices',1,0,0,0),(49,4,'role_manage',1,0,0,0),(50,4,'backup',1,0,0,0),(51,1,'transactions_archive',1,1,1,1);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'admin','ผู้ดูแลระบบ'),(2,'staff','เจ้าหน้าที่ทั่วไป'),(3,'viewer','สมาชิก'),(4,'staffbank','เจ้าหน้าที่บัญชี');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `waste_type_id` int(11) DEFAULT NULL,
  `weight` decimal(10,2) DEFAULT NULL,
  `price_per_kg` decimal(10,2) DEFAULT NULL,
  `total_price` decimal(10,2) DEFAULT NULL,
  `point_earned` int(11) DEFAULT 0,
  `transaction_date` datetime DEFAULT current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `archived_reason` text DEFAULT NULL,
  `archived_by` int(11) DEFAULT NULL,
  `archived_at` datetime DEFAULT NULL,
  PRIMARY KEY (`transaction_id`),
  KEY `waste_type_id` (`waste_type_id`),
  KEY `created_by` (`created_by`),
  KEY `member_id` (`member_id`),
  KEY `transaction_date` (`transaction_date`),
  KEY `idx_transaction_member_date` (`member_id`,`transaction_date`),
  CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`member_id`),
  CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`waste_type_id`) REFERENCES `waste_types` (`waste_type_id`),
  CONSTRAINT `transactions_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES (1,1,12,1.00,50.00,50.00,0,'2025-04-03 19:14:47',1,NULL,NULL,NULL),(2,1,1,1.00,314.00,314.00,0,'2025-04-03 19:20:24',1,NULL,NULL,NULL),(3,2,13,5.00,8.50,42.00,0,'2025-04-03 19:24:42',1,NULL,NULL,NULL),(4,2,23,1.00,18.00,18.00,0,'2025-04-03 19:24:42',1,NULL,NULL,NULL),(5,2,17,1.00,3.70,3.00,0,'2025-04-03 19:32:06',1,NULL,NULL,NULL),(6,2,21,1.00,1.20,1.00,0,'2025-04-03 19:32:06',1,NULL,NULL,NULL),(7,1,1,0.01,314.00,3.00,0,'2025-04-03 23:48:02',1,NULL,NULL,NULL),(8,1,21,55.00,1.20,66.00,0,'2025-04-03 23:48:02',1,NULL,NULL,NULL),(9,1,1,0.01,314.00,3.00,0,'2025-04-03 23:53:33',1,NULL,NULL,NULL),(10,1,21,55.00,1.20,66.00,0,'2025-04-03 23:53:33',1,NULL,NULL,NULL),(11,1,22,0.20,19.50,3.00,0,'2025-04-04 00:00:41',1,NULL,NULL,NULL),(12,3,24,11.00,5.00,55.00,0,'2025-04-04 00:08:42',1,NULL,NULL,NULL),(13,35,9,3.00,66.00,198.00,0,'2025-04-04 01:25:01',1,NULL,NULL,NULL),(14,35,18,120.00,6.30,756.00,0,'2025-04-04 01:25:01',1,NULL,NULL,NULL),(15,35,22,20.00,19.50,390.00,0,'2025-04-04 01:25:01',1,NULL,NULL,NULL),(16,1,22,0.03,19.50,0.00,0,'2025-04-05 21:54:59',1,NULL,NULL,NULL),(18,1,23,0.03,18.00,0.00,0,'2025-04-07 11:52:06',1,NULL,NULL,NULL),(20,35,7,0.10,72.00,7.00,0,'2025-05-15 00:43:20',1,NULL,NULL,NULL),(21,46,22,10000.00,19.50,195000.00,0,'2025-06-06 11:13:40',1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions_archive`
--

DROP TABLE IF EXISTS `transactions_archive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions_archive` (
  `archive_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `waste_type_id` int(11) DEFAULT NULL,
  `weight` decimal(10,2) DEFAULT NULL,
  `price_per_kg` decimal(10,2) DEFAULT NULL,
  `total_price` decimal(10,2) DEFAULT NULL,
  `point_earned` int(11) DEFAULT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `reason` text DEFAULT NULL,
  PRIMARY KEY (`archive_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions_archive`
--

LOCK TABLES `transactions_archive` WRITE;
/*!40000 ALTER TABLE `transactions_archive` DISABLE KEYS */;
INSERT INTO `transactions_archive` VALUES (1,19,3,33,5.00,99.00,495.00,0,'2025-04-07 17:40:18',1,NULL,NULL,NULL),(2,17,1,17,1.00,3.70,3.00,0,'2025-04-07 11:52:06',1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `transactions_archive` 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` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','staff') DEFAULT 'staff',
  `created_at` datetime DEFAULT current_timestamp(),
  `last_login` datetime DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`),
  KEY `fk_users_role` (`role_id`),
  CONSTRAINT `fk_users_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 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 (1,'admin_chaiphat','$2y$10$o0SWebs7.u4gK1DAttdXC.eD.ZMSzG6EDH8DGgvCV0qHX0EMDKhwS','admin','2025-04-03 18:20:00','2025-09-08 15:13:04',1),(2,'admin_rutrod','$2y$10$W6ZJ2SL7MCIlosrwLJsxs.k.Fkxf6QpAmtaJaGtnSjogpN7MOsfJO','admin','2025-04-03 18:20:00','2025-07-23 11:22:41',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `vw_member_summary`
--

DROP TABLE IF EXISTS `vw_member_summary`;
/*!50001 DROP VIEW IF EXISTS `vw_member_summary`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vw_member_summary` AS SELECT
 1 AS `member_id`,
  1 AS `name`,
  1 AS `class_room`,
  1 AS `total_weight`,
  1 AS `total_money`,
  1 AS `total_point`,
  1 AS `transaction_count` */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `waste_types`
--

DROP TABLE IF EXISTS `waste_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `waste_types` (
  `waste_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `name` varchar(100) NOT NULL,
  `price_per_kg` decimal(10,2) NOT NULL,
  `sell_price_per_kg` decimal(10,2) NOT NULL,
  `point_per_kg` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  `created_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`waste_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `waste_types`
--

LOCK TABLES `waste_types` WRITE;
/*!40000 ALTER TABLE `waste_types` DISABLE KEYS */;
INSERT INTO `waste_types` VALUES (1,'โลหะมีค่า','ทองแดงปอกสวย',314.00,0.00,0,1,'2025-04-03 19:04:05'),(2,'โลหะมีค่า','ทองแดงซ๊อตดำ',304.00,0.00,0,1,'2025-04-03 19:04:05'),(3,'โลหะมีค่า','ทองแดงใหญ่/ท่อเก่า',294.00,0.00,0,1,'2025-04-03 19:04:05'),(4,'โลหะมีค่า','ทองแดงเส้นเล็ก (ชุบขาว)',290.00,0.00,0,1,'2025-04-03 19:04:05'),(5,'โลหะมีค่า','ทองเหลืองหนา',197.00,0.00,0,1,'2025-04-03 19:04:05'),(6,'โลหะมีค่า','หม้อน้ำทองเหลือง',179.00,0.00,0,1,'2025-04-03 19:04:05'),(7,'โลหะมีค่า','อลูมิเนียมฉากรวม',72.00,0.00,0,1,'2025-04-03 19:04:05'),(8,'โลหะมีค่า','อลูมิเนียมเพลท',66.00,0.00,0,1,'2025-04-03 19:04:05'),(9,'โลหะมีค่า','อลูมิเนียมกระป๋อง',66.00,0.00,0,1,'2025-04-03 19:04:05'),(10,'โลหะมีค่า','อลูมิเนียมหนา',64.00,0.00,0,1,'2025-04-03 19:04:05'),(11,'โลหะมีค่า','สแตนเลสแท้ 304',45.00,0.00,0,1,'2025-04-03 19:04:05'),(12,'โลหะมีค่า','ตะกั่วอ่อน',50.00,0.00,0,1,'2025-04-03 19:04:05'),(13,'เศษเหล็ก','เหล็กหล่อ',8.50,0.00,0,1,'2025-04-03 19:04:05'),(14,'เศษเหล็ก','เหล็กหนาสั้น + เครื่อง',9.50,0.00,0,1,'2025-04-03 19:04:05'),(15,'เศษเหล็ก','เหล็กหนายาว',8.50,0.00,0,1,'2025-04-03 19:04:05'),(16,'เศษเหล็ก','เหล็กย่อย (คละ)',7.80,0.00,0,1,'2025-04-03 19:04:05'),(17,'กระดาษ','กระดาษลังน้ำตาล',3.70,0.00,0,1,'2025-04-03 19:04:05'),(18,'กระดาษ','กระดาษขาวดำ',6.30,0.00,0,1,'2025-04-03 19:04:05'),(19,'กระดาษ','กระดาษเล่ม/ย่อย',3.10,0.00,0,1,'2025-04-03 19:04:05'),(20,'กระดาษ','หนังสือพิมพ์',6.00,0.00,0,1,'2025-04-03 19:04:05'),(21,'ขวดแก้ว','ขวดแก้วรวมสี',1.20,0.00,0,1,'2025-04-03 19:04:05'),(22,'พลาสติก','ขวด PET ใส (แกะฉลาก)',19.50,0.00,0,1,'2025-04-03 19:04:05'),(23,'พลาสติก','ขวด PET ใส (ไม่แกะฉลาก)',18.00,0.00,0,1,'2025-04-03 19:04:05'),(24,'พลาสติก','พลาสติกรวมสี',5.00,0.00,0,1,'2025-04-03 19:04:05'),(25,'พลาสติก','ถุงพลาสติก',5.00,0.00,0,1,'2025-04-03 19:04:05'),(26,'เครื่องใช้ไฟฟ้า','จอคอมพิวเตอร์ (LED)',1.00,0.00,0,1,'2025-04-03 19:04:05'),(27,'เครื่องใช้ไฟฟ้า','เคสคอมพิวเตอร์',2.50,0.00,0,1,'2025-04-03 19:04:05'),(28,'เครื่องใช้ไฟฟ้า','เครื่องแฟกซ์',1.50,0.00,0,1,'2025-04-03 19:04:05'),(29,'เครื่องใช้ไฟฟ้า','พัดลมตั้งโต๊ะ, เพดาน',3.00,0.00,0,1,'2025-04-03 19:04:05'),(30,'เครื่องใช้ไฟฟ้า','เครื่องซักผ้า',2.00,0.00,0,1,'2025-04-03 19:04:05'),(31,'เครื่องใช้ไฟฟ้า','เครื่องสำรองไฟ (UPS)',5.00,0.00,0,1,'2025-04-03 19:04:05'),(32,'test99','test77',9.00,10.00,0,1,'2025-04-07 00:27:59'),(33,'test99','test999',99.00,999.00,0,1,'2025-04-07 00:49:34'),(34,'test99','test88',88.00,0.00,0,1,'2025-04-07 18:24:21'),(35,'test99','test66',66.00,0.00,0,1,'2025-04-07 18:32:18');
/*!40000 ALTER TABLE `waste_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdrawals`
--

DROP TABLE IF EXISTS `withdrawals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdrawals` (
  `withdrawal_id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(64) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `withdrawal_date` datetime DEFAULT current_timestamp(),
  `note` text DEFAULT NULL,
  `status` enum('pending','confirmed','cancelled') DEFAULT 'pending',
  `confirmed_at` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  PRIMARY KEY (`withdrawal_id`),
  UNIQUE KEY `token` (`token`),
  KEY `user_id` (`user_id`),
  KEY `member_id` (`member_id`),
  KEY `withdrawal_date` (`withdrawal_date`),
  KEY `idx_withdrawal_member_date` (`member_id`,`withdrawal_date`),
  CONSTRAINT `withdrawals_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`member_id`),
  CONSTRAINT `withdrawals_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdrawals`
--

LOCK TABLES `withdrawals` WRITE;
/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
INSERT INTO `withdrawals` VALUES (3,'2fe8a26870acf56de46961f7a83b424f27eabeeaa572678060be443b8fa70339',3,5.00,'2025-04-04 02:29:32','| ผู้ส่งคำขอ: admin_chaiphat | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,NULL),(4,'353f42c843fd9349081d46dbf9c14cbd79b8313f0b2909f7c160fbb5ed69d07b',3,5.00,'2025-04-04 02:31:34','| ผู้ส่งคำขอ: admin_chaiphat | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,NULL),(5,'14ec9302b3828af51679f6e038edaf24d5aaeabce846eded87db699052fb2a65',3,5.00,'2025-04-04 02:32:09','| ผู้ส่งคำขอ: admin_chaiphat | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,NULL),(9,'ec26aaeaa65a7e3c8700cdbf9d3ac28b550f7e68dcec391f4bf63aab00c05876',1,100.00,'2025-04-07 01:51:40',' | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,NULL),(10,'1e84dcf722f2b81e6df91126acc46c43aa5f21b2932c1e822e27a797ea3709a2',1,208.00,'2025-04-07 12:14:52',' | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,NULL),(11,'f9d5030cd3cad6b9e946468de2c7bf990f5a860b23e809c84e253d28b4602e4f',3,55.00,'2025-04-07 12:52:36',' | ผู้ส่งคำขอ: admin_chaiphat','confirmed','2025-04-07 12:58:44',1,NULL),(12,'b80143368d5cbaa95120ed705b00284330009be40d30048ae29f0d9529f8c3b1',1,8.00,'2025-04-07 13:00:56',' | ผู้ส่งคำขอ: admin_chaiphat','confirmed','2025-04-07 13:01:00',1,NULL),(13,'e3641718c8530c953e0ff45e56516e9f4478628f6932cd2b47126211b10f795a',1,100.00,'2025-04-07 13:01:28',' | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,'2025-04-07 13:04:57'),(14,'4d0ba951e6c46ace7dd76573e50262077aa060d5546aed3857cc9cc6c83ab876',3,95.00,'2025-04-07 17:54:19',' | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,'2025-04-07 17:56:20'),(15,'6338f682f2b0752e38968cfa2f465972f9a94e357f8f59c014b3081df5a5ade7',3,95.00,'2025-04-07 17:56:31',' | ผู้ส่งคำขอ: admin_chaiphat','confirmed','2025-04-07 18:01:32',1,NULL),(16,'c3070be292a9d793be03080533582e34a8abe6604242cda89913e53af72cec58',3,100.00,'2025-04-07 21:21:11',' | ผู้ส่งคำขอ: admin_chaiphat','cancelled',NULL,1,'2025-04-07 22:11:14'),(17,'bc145d9d1864ffa27a4187d603a22c9ffe45b26c6f4be6bdf186927fae17c3fc',46,195000.00,'2025-06-06 11:14:35','เทส | ผู้ส่งคำขอ: admin_chaiphat','confirmed','2025-06-06 11:15:10',1,NULL);
/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdrawals_archive`
--

DROP TABLE IF EXISTS `withdrawals_archive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdrawals_archive` (
  `withdrawal_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `withdrawal_date` datetime DEFAULT current_timestamp(),
  `note` text DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status_before` enum('pending','confirmed','cancelled') DEFAULT NULL,
  `archived_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`withdrawal_id`),
  KEY `user_id` (`user_id`),
  KEY `member_id` (`member_id`),
  KEY `withdrawal_date` (`withdrawal_date`),
  KEY `idx_withdrawal_member_date` (`member_id`,`withdrawal_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdrawals_archive`
--

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

--
-- Current Database: `nahaewwi_waste_bank`
--

USE `nahaewwi_waste_bank`;

--
-- Final view structure for view `vw_member_summary`
--

/*!50001 DROP VIEW IF EXISTS `vw_member_summary`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nahaewwi_waste_bank`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vw_member_summary` AS select `m`.`member_id` AS `member_id`,`m`.`name` AS `name`,`m`.`class_room` AS `class_room`,sum(`t`.`weight`) AS `total_weight`,sum(`t`.`total_price`) AS `total_money`,sum(`t`.`point_earned`) AS `total_point`,count(`t`.`transaction_id`) AS `transaction_count` from (`members` `m` left join `transactions` `t` on(`m`.`member_id` = `t`.`member_id`)) group by `m`.`member_id` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!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:22:24

📁 Sid Gifari File Manager