-- MySQL dump 10.13  Distrib 8.0.46, for Linux (x86_64)
--
-- Host: localhost    Database: ysh533247t
-- ------------------------------------------------------
-- Server version	8.0.46

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

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

DROP TABLE IF EXISTS `members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `members` (
  `memberID` int NOT NULL AUTO_INCREMENT,
  `userLevel` tinyint(1) DEFAULT '0',
  `joinDateTime` datetime NOT NULL,
  `endUseDateTime` date DEFAULT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `activeToken` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `resetToken` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `resetComplete` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`memberID`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3;
/*!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,1,'2022-03-07 00:49:11','2022-03-07','admin','$2y$10$RM7D4UWpVi9u.0nfVe6vLOHSId4fvuuEDANrlk39j4DI3Q8DaGPD6','admin@admin.com',1,'13d7f47e186a301afa14d8b6001842556076ad5001cc3ece24bcaf742ac191fabebdd9b45959dd64edfa404ca6e4c83e2edc239cd7724c06659b7f819405eb72',NULL,0),(2,1,'2022-03-07 00:51:46','2022-03-07','ysh533247t','$2y$10$xbqSo/SS1pMtXfswibWL0Op7kZmKydEWke6oe9AycKVrATKDl7acW','ysh533247t@admin.com',1,'7126bdc77880336f46ac9971111254f5e01e7671e0c56a12214ef63100f76f822ceccdadadeedae6019a5c22e0f082652836b57a3d582c27aedba00a9377bf54',NULL,0),(7,0,'2022-03-07 13:18:01','2025-03-31','86d9-b564-a512-e10f-1d20-3f5a-0028-ae72','$2y$10$XpDVSfje.aWN9Yg6UkJ.U.8bodpAx35wg.ChXh8oVXG9xQZcaug4K','파주(노트북1)',1,NULL,NULL,0),(9,0,'2022-03-09 08:25:38','2025-03-30','aa86-8971-3dad-19ce-4b6b-91b1-c534-2559','$2y$10$KN1wy4WOqkHgFza5MezMUeUUHhF/T7Kxx4C/vvUOPQSA561geEd..','서울노트',1,NULL,NULL,0),(25,0,'2025-07-02 01:29:49',NULL,'f8e2-0b4b-85a0-a877-e4eb-66f5-fcfb-d4ce','$2y$10$e8ZICmXS0mRUWTng.CMTdu00Fvs9Yz/ppwizOLkRzgj3ypnckhrOO','태스',1,NULL,NULL,0),(14,0,'2022-03-21 12:04:44','2025-03-30','ee9e-3298-262f-d1fd-9057-214d-ddff-36f0','$2y$10$Pkh/nzXBC3aTfbae1dldquLezoYclSrBOlcOR2JB67UmLG6frrCp2','박한기노트',1,NULL,NULL,0),(16,0,'2022-03-22 10:51:36','2025-03-30','ee38-a3a6-5f28-da55-c481-e31e-fb2d-a448','$2y$10$BE.8XJauOqxKvKFfMX/WDOyxalrK5vhlEQGpI2lxz1CnZGd35GC9m','송중창',1,NULL,NULL,0);
/*!40000 ALTER TABLE `members` 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 2026-08-26  3:18:19