SQLize Online / PHPize Online  /  SQLtest Online

-- -------------------------------------------------------- -- Host: localhost -- Server version: 10.4.32-MariaDB - mariadb.org binary distribution -- Server OS: Win64 -- HeidiSQL Version: 12.6.0.6765 -- -------------------------------------------------------- /*!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 database structure for ebook CREATE DATABASE IF NOT EXISTS `ebook` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */; USE `ebook`; -- Dumping structure for table ebook.books CREATE TABLE IF NOT EXISTS `books` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `image` varchar(225) DEFAULT NULL, `author` varchar(224) DEFAULT '', `Des` mediumtext DEFAULT NULL, `user_id` bigint(20) unsigned NOT NULL, `price` int(11) DEFAULT 10, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_books_users` (`user_id`), CONSTRAINT `FK_books_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ebook.books: ~0 rows (approximately) INSERT INTO `books` (`id`, `name`, `image`, `author`, `Des`, `user_id`, `price`, `created_at`, `updated_at`) VALUES (21, 'sach1', 'photos/urPnZaYKmOubysiQAzgpKMl6KRoZPadLobzbegS3.png', '4', 'sdsdssdsdssdsdssdsdssdsdssdsds', 4, 223, '2024-07-22 18:03:29', '2024-07-22 18:03:29'); -- Dumping structure for table ebook.book_contents CREATE TABLE IF NOT EXISTS `book_contents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Content` varchar(255) NOT NULL, `page` int(11) NOT NULL, `Book_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_book_contents_books` (`Book_id`), CONSTRAINT `FK_book_contents_books` FOREIGN KEY (`Book_id`) REFERENCES `books` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ebook.book_contents: ~1 rows (approximately) INSERT INTO `book_contents` (`id`, `Content`, `page`, `Book_id`, `created_at`, `updated_at`) VALUES (1, 'asdasdasds', 0, 21, NULL, NULL); -- Dumping structure for table ebook.migrations CREATE TABLE IF NOT EXISTS `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ebook.migrations: ~7 rows (approximately) INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2024_06_24_095822_create_comment_at', 1), (2, '2024_06_24_101731_create_sessions_table', 1), (3, '2024_07_07_013232_create_posts_table', 1), (4, '2024_07_15_035640_create_cache_table', 1), (5, '2024_07_19_022503_create_likes_table', 1), (6, '2024_07_22_060340_create_users_table', 2), (7, '2024_07_22_061619_create_books_table', 3), (8, '2024_07_23_010921_create_book_contents_table', 4); -- Dumping structure for table ebook.sessions CREATE TABLE IF NOT EXISTS `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ebook.sessions: ~1 rows (approximately) INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('c5vJLs1SrcXrdiZ7uGXuPfclHMH4rymH3if9Te74', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSlN1WDROUkE3Qk94NmxKcXBQeTRXNUM3SnJKdjRKQXpaSWFsZkJBUSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAwIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9SZWFkQm9vay8yMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7fQ==', 1721697789); -- Dumping structure for table ebook.users CREATE TABLE IF NOT EXISTS `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `note` varchar(225) NOT NULL DEFAULT 'images/avatar/', `avatar_url` varchar(225) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table ebook.users: ~3 rows (approximately) INSERT INTO `users` (`id`, `name`, `email`, `password`, `note`, `avatar_url`, `created_at`, `updated_at`) VALUES (4, 'Sparkle', 'Sparkle@gmail.com', '$2y$12$gbm1wGkTK2TkikCc0.T4iuxNAAxkcbWOgFBfh3HTJIMF.CYvFtdZ6', '123', 'Default-User-Image.png', '2024-07-22 00:39:48', '2024-07-22 00:39:48'), (5, '123', '1@gmail.com', '$2y$12$jA4Oz3U/lcHwvNl6TsMSyecKhLyiVLmDHfxv00Myix7Ld.dtXnsE.', '123', 'Default-User-Image.png', '2024-07-22 00:42:09', '2024-07-22 00:42:09'), (6, '34334', '2@gmail.com', '$2y$12$gyzy.GiwzW8nC52GVeFuieE/1xMwsYMdE8E/L3BN3PYyZiU8H7d/e', '123', 'Default-User-Image.png', '2024-07-22 00:47:18', '2024-07-22 00:47:18'); /*!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) */;