-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

-- Dumping structure for table fluttercomic.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table fluttercomic.categories: ~4 rows (approximately)
DELETE FROM `categories`;
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`) VALUES
	(2, 'Romance', 'Focuses on relationship developments and love stories.', '2026-06-13 04:05:37'),
	(5, 'Slice of Life', 'Depicts everyday life experiences and realistic situations.', '2026-06-13 04:05:37'),
	(6, 'Horror', 'Scary and thrilling comics that evoke fear and suspense.', '2026-06-13 04:05:37'),
	(7, 'Cerita Rakyat Pasemah', 'Cerita Rakyat Pasemah meruapakan legenda yang beredar di kalangan masyarakat wilayah Pasemah', '2026-06-16 07:53:10');

-- Dumping structure for table fluttercomic.chapters
CREATE TABLE IF NOT EXISTS `chapters` (
  `id` int NOT NULL AUTO_INCREMENT,
  `comic_id` int NOT NULL,
  `chapter_number` double NOT NULL,
  `chapter_title` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `comic_id` (`comic_id`),
  CONSTRAINT `chapters_ibfk_1` FOREIGN KEY (`comic_id`) REFERENCES `comics` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table fluttercomic.chapters: ~15 rows (approximately)
DELETE FROM `chapters`;
INSERT INTO `chapters` (`id`, `comic_id`, `chapter_number`, `chapter_title`, `created_at`) VALUES
	(9, 5, 1, 'Jejak di Tangge Manik', '2026-07-10 02:55:00'),
	(10, 5, 2, 'Bidadari yang Tertinggal', '2026-07-10 02:57:00'),
	(11, 5, 3, 'Nasib Sang Bidadari', '2026-07-10 02:58:51'),
	(12, 6, 1, 'Hidup Dalam Kesederhanaan', '2026-07-10 03:04:46'),
	(13, 6, 2, 'Sebakul Dedak', '2026-07-10 03:06:18'),
	(14, 6, 3, 'Keajaiban dari Sebakul Dedak', '2026-07-10 03:08:16'),
	(15, 9, 1, 'Raja Kecil di Hulu Sungai', '2026-07-10 03:53:47'),
	(16, 9, 2, 'Kejutan di Sungai Besar', '2026-07-10 03:54:03'),
	(17, 9, 3, 'Damai di Ulu Tulung', '2026-07-10 03:54:21'),
	(18, 7, 1, 'Warisan yang Dirampas', '2026-07-10 06:01:17'),
	(19, 7, 2, 'Keluarga yang Terpisah', '2026-07-10 06:01:59'),
	(20, 7, 3, 'Takdir yang Kembali', '2026-07-10 08:34:03'),
	(21, 8, 1, 'Doa yang Dikabulkan', '2026-07-10 13:16:15'),
	(22, 8, 2, 'Tiga Putri yang Berbeda', '2026-07-10 13:16:42'),
	(23, 8, 3, 'Janji yang Ditepati', '2026-07-10 17:22:01');

-- Dumping structure for table fluttercomic.chapter_pages
CREATE TABLE IF NOT EXISTS `chapter_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chapter_id` int NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `page_order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `chapter_id` (`chapter_id`),
  CONSTRAINT `chapter_pages_ibfk_1` FOREIGN KEY (`chapter_id`) REFERENCES `chapters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table fluttercomic.chapter_pages: ~19 rows (approximately)
DELETE FROM `chapter_pages`;
INSERT INTO `chapter_pages` (`id`, `chapter_id`, `image_path`, `page_order`, `created_at`) VALUES
	(40, 15, 'uploads/pages/698644299e4f10e965e7e76ad84aa8c0.png', 1, '2026-07-15 20:25:59'),
	(41, 16, 'uploads/pages/40a5d16de8e72c0d8b701d441acdfdab.png', 1, '2026-07-15 20:26:22'),
	(42, 17, 'uploads/pages/2f0ef62017c71d5f1a38cdf882f9c570.png', 1, '2026-07-15 20:26:41'),
	(46, 9, 'uploads/pages/99b478e086d0e7391f14d2c8881a5084.png', 1, '2026-07-15 20:30:29'),
	(47, 10, 'uploads/pages/6f03b8da669a657b0be897b26a189b38.png', 1, '2026-07-15 20:30:47'),
	(48, 11, 'uploads/pages/38a8e5f4ac4a2d756902fbc44cf05f48.png', 1, '2026-07-15 20:31:04'),
	(50, 19, 'uploads/pages/7f4d720538e7053e1f4f29041a23c267.png', 1, '2026-07-15 20:32:17'),
	(51, 20, 'uploads/pages/825d198b2c303166682ae99498cc8eaa.png', 1, '2026-07-15 20:32:41'),
	(53, 21, 'uploads/pages/2da7936aaecbcc90db92ea881a5c81ee.png', 2, '2026-07-15 20:34:08'),
	(54, 22, 'uploads/pages/ab555d238c3f5edf8b4b8aaede3278ea.png', 1, '2026-07-15 20:34:27'),
	(56, 23, 'uploads/pages/9e253f4630a41d41f3479695af500ef7.png', 1, '2026-07-15 20:45:40'),
	(57, 12, 'uploads/pages/12cc427f7814ef2e899ad4fce6b69c4f.png', 1, '2026-07-16 00:03:34'),
	(58, 12, 'uploads/pages/d7f7546e6f1689124924450eba5fd94c.png', 2, '2026-07-16 00:03:53'),
	(60, 13, 'uploads/pages/874fb0497e0c5df7daa57d1ddff11feb.png', 1, '2026-07-16 00:05:07'),
	(62, 13, 'uploads/pages/97b79582772a16016d5def31982b6125.png', 2, '2026-07-16 00:06:06'),
	(65, 14, 'uploads/pages/f549202327022f9684ef3ef55d1b2a64.png', 1, '2026-07-16 00:19:40'),
	(66, 14, 'uploads/pages/deaf83e021dcf806d5bd87f05a573f62.png', 2, '2026-07-16 00:20:02'),
	(67, 18, 'uploads/pages/90cbabdd868492fce17689b0309a2ff2.png', 1, '2026-07-16 00:21:41'),
	(68, 18, 'uploads/pages/f0269195c7d2c6df123e3c2a2989e51f.png', 2, '2026-07-16 00:21:51');

-- Dumping structure for table fluttercomic.comics
CREATE TABLE IF NOT EXISTS `comics` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `category_id` int NOT NULL,
  `title` varchar(100) NOT NULL,
  `synopsis` text NOT NULL,
  `cover_image` varchar(255) NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `comics_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `comics_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table fluttercomic.comics: ~5 rows (approximately)
DELETE FROM `comics`;
INSERT INTO `comics` (`id`, `user_id`, `category_id`, `title`, `synopsis`, `cover_image`, `status`, `created_at`, `updated_at`) VALUES
	(5, 5, 7, 'Serunting dan Bidadari Bungsu', 'Serunting dan Bidadari Bungsu merupakan cerita rakyat Pasemah yang mengisahkan pertemuan seorang pemuda bernama Barudin dengan seorang bidadari dari kayangan. Pertemuan tersebut membawa mereka pada sebuah kisah tentang cinta, takdir, dan pengorbanan yang menjadi legenda di Tanah Besemah.', 'uploads/covers/86706a56f7e16fb8182324209aae0c58.png', 'approved', '2026-07-10 02:53:43', '2026-07-15 20:35:45'),
	(6, 5, 7, 'Anak Belai Minta Padi', 'Anak Belai Minta Padi merupakan cerita rakyat Pasemah yang mengajarkan tentang kesabaran, ketulusan, dan pentingnya tetap berbuat baik dalam menghadapi kesulitan. Kisah ini mengingatkan bahwa setiap kebaikan akan membawa berkah, serta mengajarkan agar tidak merendahkan orang lain karena nasib seseorang dapat berubah sewaktu-waktu.', 'uploads/covers/3fdd2b163ebaf1324a8bf1b2cfa51a53.png', 'approved', '2026-07-10 03:02:15', '2026-07-15 20:35:43'),
	(7, 5, 7, 'Seringguk Malai', 'Seringguk Malai merupakan cerita rakyat Pasemah yang mengisahkan perjalanan Putri Bungsu, seorang putri yang berhati baik dan harus menerima pengkhianatan dari keenam kakaknya yang iri terhadap dirinya. Setelah berbagai cobaan memisahkan keluarganya, Putri Bungsu dan putrinya, Seringguk Malai, tetap tabah menjalani kehidupan. Kisah ini menggambarkan bahwa kebaikan, kesabaran, dan kasih sayang keluarga mampu mengalahkan kejahatan, hingga pada akhirnya keadilan kembali ditegakkan.', 'uploads/covers/eaad7070d683da2d035e1cf83f19f8da.png', 'approved', '2026-07-10 03:37:38', '2026-07-15 20:35:41'),
	(8, 5, 7, 'Ranggak Ringgik dan Rangge Gudung', 'Mengisahkan tiga saudara perempuan yang memiliki sifat berbeda. Perbedaan sikap mereka terhadap sang ibu membawa mereka pada sebuah peristiwa yang mengajarkan arti kasih sayang, bakti kepada orang tua, dan akibat dari kesombongan.', 'uploads/covers/54237e32b073fb08f2b33e254de47ed8.png', 'approved', '2026-07-10 03:45:04', '2026-07-15 20:35:39'),
	(9, 5, 7, 'Ikan Pungkut di Ulu Tulung', 'Cerita rakyat Pasemah ini mengisahkan Ikan Pungkut, seekor ikan yang merasa paling kuat dan berkuasa di Ulu Tulung. Pengalaman yang dialaminya mengajarkan bahwa kesombongan hanya membawa kesulitan, sedangkan sikap rendah hati, saling memaafkan, dan hidup rukun merupakan kunci terciptanya kedamaian bersama.', 'uploads/covers/ce431534a0a62efdd42876aefb8e4149.png', 'approved', '2026-07-10 03:53:06', '2026-07-16 02:57:13');

-- Dumping structure for table fluttercomic.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('admin','user') DEFAULT 'user',
  `avatar` varchar(255) 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`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table fluttercomic.users: ~6 rows (approximately)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `username`, `email`, `password`, `role`, `avatar`, `created_at`, `updated_at`) VALUES
	(1, 'Admin Comic', 'admin@gmail.com', '$2y$12$zqMABi5dpOLIa2YsK4/aze44fGsbTMPfnX6RwC8xK1FvsPtkBo.1e', 'admin', NULL, '2026-06-13 04:05:37', '2026-07-16 02:39:22'),
	(5, 'walu.hnm', 'sitiwaluhm@gmail.com', '$2y$10$aU6at8dXf8.GwnFfUbjKLO3.VKcNKrJ9FmDaNzIHPkoP58gffV8T2', 'user', NULL, '2026-06-16 08:05:39', '2026-07-15 09:09:55'),
	(6, 'delia', 'deliaamarta63@gmail.com', '$2y$10$86KcoNoqNQRQx7KcDSxBF.NLJwqw10U/hKw/HQUORUpEovGTHWqQK', 'user', NULL, '2026-07-05 04:56:44', '2026-07-05 04:56:44'),
	(8, 'hani', 'hani@gmail.com', '$2y$10$1gHUo3oy2rB5KhTN1Jd.FOgXXzxgvQ6GSeNi2OuiiKSDY5cNy1eoq', 'user', NULL, '2026-07-15 12:50:26', '2026-07-15 12:50:26'),
	(9, 'delia', 'delia@gmail.com', '$2y$10$SVzrcuNdSNFKrdLrRWusR.M1GJERMczfuNHR7X7aBhPAkiebjeYay', 'user', NULL, '2026-07-15 12:50:37', '2026-07-15 12:50:37'),
	(10, 'sudendev', 'fahruladib9@gmail.com', '$2y$10$icJ0CwUqprlLiYjQj1hf9O6K/oR/b3HpiE3CDy9ks9eTvA8Q4qf1O', 'user', NULL, '2026-07-16 02:40:05', '2026-07-16 02:40:05');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;