/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19-11.4.13-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: ycplucnjgt_palacemail
-- ------------------------------------------------------
-- Server version	11.4.13-MariaDB-cll-lve

/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--
-- Table structure for table `bulk_mail_queue_jobs`
--

DROP TABLE IF EXISTS `bulk_mail_queue_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bulk_mail_queue_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `template_id` int(11) DEFAULT NULL,
  `subject` varchar(500) NOT NULL,
  `body` mediumtext NOT NULL,
  `is_html` tinyint(1) NOT NULL DEFAULT 1,
  `status` enum('pending','processing','completed','cancelled','failed','paused') NOT NULL DEFAULT 'pending',
  `total_recipients` int(11) NOT NULL DEFAULT 0,
  `processed_count` int(11) NOT NULL DEFAULT 0,
  `success_count` int(11) NOT NULL DEFAULT 0,
  `failed_count` int(11) NOT NULL DEFAULT 0,
  `last_error` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `idx_user` (`user_id`),
  KEY `idx_created` (`created_at`),
  KEY `bulk_mail_queue_jobs_ibfk_template` (`template_id`),
  CONSTRAINT `bulk_mail_queue_jobs_ibfk_template` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `bulk_mail_queue_jobs_ibfk_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bulk_mail_queue_jobs`
--

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

--
-- Table structure for table `bulk_mail_queue_recipients`
--

DROP TABLE IF EXISTS `bulk_mail_queue_recipients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bulk_mail_queue_recipients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `sender_account_id` int(11) NOT NULL,
  `status` enum('pending','sent','failed','cancelled') NOT NULL DEFAULT 'pending',
  `mail_log_id` int(11) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `attempts` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_job_status` (`job_id`,`status`),
  KEY `idx_job_id` (`job_id`,`id`),
  KEY `bulk_mail_queue_recipients_ibfk_sender` (`sender_account_id`),
  KEY `bulk_mail_queue_recipients_ibfk_mail_log` (`mail_log_id`),
  CONSTRAINT `bulk_mail_queue_recipients_ibfk_job` FOREIGN KEY (`job_id`) REFERENCES `bulk_mail_queue_jobs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bulk_mail_queue_recipients_ibfk_mail_log` FOREIGN KEY (`mail_log_id`) REFERENCES `mail_logs` (`id`) ON DELETE SET NULL,
  CONSTRAINT `bulk_mail_queue_recipients_ibfk_sender` FOREIGN KEY (`sender_account_id`) REFERENCES `sender_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bulk_mail_queue_recipients`
--

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

--
-- Table structure for table `credit_transactions`
--

DROP TABLE IF EXISTS `credit_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `credit_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `credits_amount` int(11) NOT NULL,
  `transaction_type` enum('deduct','add') NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `mail_log_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_type` (`transaction_type`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_mail_log` (`mail_log_id`),
  CONSTRAINT `credit_transactions_ibfk_1` FOREIGN KEY (`mail_log_id`) REFERENCES `mail_logs` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credit_transactions`
--

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

--
-- Table structure for table `credits`
--

DROP TABLE IF EXISTS `credits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `credits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `total_credits` int(11) NOT NULL DEFAULT 300000,
  `used_credits` int(11) NOT NULL DEFAULT 0,
  `remaining_credits` int(11) NOT NULL DEFAULT 300000,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credits`
--

LOCK TABLES `credits` WRITE;
/*!40000 ALTER TABLE `credits` DISABLE KEYS */;
INSERT INTO `credits` VALUES
(1,1000000,0,1000000,'2026-10-17 09:54:10');
/*!40000 ALTER TABLE `credits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mail_logs`
--

DROP TABLE IF EXISTS `mail_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `recipient_email` varchar(255) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `mail_type` enum('bulk','single') NOT NULL,
  `template_id` int(11) DEFAULT NULL,
  `status` enum('sent','failed','pending') DEFAULT 'pending',
  `transaction_id` varchar(255) DEFAULT NULL,
  `credits_used` int(11) DEFAULT 1,
  `error_message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `template_id` (`template_id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_status` (`status`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_transaction_id` (`transaction_id`),
  CONSTRAINT `mail_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `mail_logs_ibfk_2` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_logs`
--

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

--
-- Table structure for table `mail_pool`
--

DROP TABLE IF EXISTS `mail_pool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_pool` (
  `id` int(11) NOT NULL DEFAULT 1,
  `status` enum('stopped','running') NOT NULL DEFAULT 'stopped',
  `user_id` int(11) DEFAULT NULL,
  `cursor_recipient_id` int(11) NOT NULL DEFAULT 0,
  `next_template_index` int(11) NOT NULL DEFAULT 0,
  `total_sent` bigint(20) NOT NULL DEFAULT 0,
  `total_failed` bigint(20) NOT NULL DEFAULT 0,
  `cycle_count` int(11) NOT NULL DEFAULT 0,
  `sent_today` int(11) NOT NULL DEFAULT 0,
  `sent_today_date` date DEFAULT NULL,
  `last_error` text DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `stopped_at` timestamp NULL DEFAULT NULL,
  `last_run_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `mail_pool_ibfk_user` (`user_id`),
  CONSTRAINT `mail_pool_ibfk_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_pool`
--

LOCK TABLES `mail_pool` WRITE;
/*!40000 ALTER TABLE `mail_pool` DISABLE KEYS */;
INSERT INTO `mail_pool` VALUES
(1,'stopped',NULL,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,'2026-08-18 15:37:02','2026-08-18 15:37:02');
/*!40000 ALTER TABLE `mail_pool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mail_pool_recipients`
--

DROP TABLE IF EXISTS `mail_pool_recipients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_pool_recipients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_email` (`email`),
  KEY `idx_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_pool_recipients`
--

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

--
-- Table structure for table `mail_pool_templates`
--

DROP TABLE IF EXISTS `mail_pool_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_pool_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `body` mediumtext NOT NULL,
  `is_html` tinyint(1) NOT NULL DEFAULT 1,
  `source_template_id` int(11) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_active_sort` (`is_active`,`sort_order`,`id`),
  KEY `mail_pool_templates_ibfk_template` (`source_template_id`),
  CONSTRAINT `mail_pool_templates_ibfk_template` FOREIGN KEY (`source_template_id`) REFERENCES `templates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_pool_templates`
--

LOCK TABLES `mail_pool_templates` WRITE;
/*!40000 ALTER TABLE `mail_pool_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `mail_pool_templates` 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 = utf8mb4 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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','Sistem yöneticisi - Tüm yetkilere sahip','2026-02-05 08:00:20','2026-02-05 08:00:20'),
(2,'personel','Personel - Sadece şablon kullanarak mail gönderebilir','2026-02-05 08:00:20','2026-02-05 08:00:20');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sender_accounts`
--

DROP TABLE IF EXISTS `sender_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sender_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_email` (`email`),
  KEY `idx_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sender_accounts`
--

LOCK TABLES `sender_accounts` WRITE;
/*!40000 ALTER TABLE `sender_accounts` DISABLE KEYS */;
INSERT INTO `sender_accounts` VALUES
(13,'adnanbezer@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(14,'ayferreyhan94@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(15,'ayhannoykara@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(16,'bahriunatir@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(17,'cemaylax@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(18,'davutkenderecek@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(19,'ecrinbutac@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(20,'ersinkarasan0@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(21,'esmaoldef@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(22,'kaldekadanak@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(23,'kamilsedeayhan@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(24,'kasimbeylere@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(25,'kerimanolsey@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(26,'mahiralibakan@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(27,'mercanbedese471@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(28,'nejlakonaz@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(29,'remstaygold3658syt@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(30,'samiizelds@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(31,'sezginkozmsxs@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(32,'sezginsalaman@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(33,'veldeolrspt@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(34,'zahittaktsk@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(35,'zehraakcay174@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(36,'zehrakondese@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47'),
(37,'zehrakonmazal@gmail.com','LordPalace',1,NULL,'2026-08-20 03:22:47','2026-08-20 03:22:47');
/*!40000 ALTER TABLE `sender_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `templates`
--

DROP TABLE IF EXISTS `templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `body` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `allowed_roles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`allowed_roles`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_active` (`is_active`),
  KEY `idx_created_by` (`created_by`),
  CONSTRAINT `templates_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `templates`
--

LOCK TABLES `templates` WRITE;
/*!40000 ALTER TABLE `templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `templates` 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 = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role_id` int(11) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `last_login` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_email` (`email`),
  KEY `idx_role` (`role_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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','admin@admin.com','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',1,1,'2026-08-25 13:05:50','2026-02-05 08:00:20','2026-08-25 13:05:50'),
(2,'user','admin@admin2.com','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',1,1,'2026-08-05 15:17:45','2026-02-05 09:39:19','2026-08-07 00:04:39'),
(5,'admin2','palace@admin.com','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi',1,1,'2026-08-24 21:19:36','2026-02-05 08:00:20','2026-08-24 21:19:36');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'ycplucnjgt_palacemail'
--
/*!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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-10-18 21:54:49