-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `perpus`
--

-- --------------------------------------------------------

--
-- Table structure for table `auth_groups_users`
--

CREATE TABLE `auth_groups_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `auth_groups_users`
--

INSERT INTO `auth_groups_users` (`id`, `user_id`, `group`, `created_at`) VALUES
(1, 1, 'superadmin', '2024-08-25 12:57:28');

-- --------------------------------------------------------

--
-- Table structure for table `auth_identities`
--

CREATE TABLE `auth_identities` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `secret` varchar(255) NOT NULL,
  `secret2` varchar(255) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  `extra` text DEFAULT NULL,
  `force_reset` tinyint(1) NOT NULL DEFAULT 0,
  `last_used_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `auth_identities`
--

INSERT INTO `auth_identities` (`id`, `user_id`, `type`, `name`, `secret`, `secret2`, `expires`, `extra`, `force_reset`, `last_used_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'email_password', NULL, 'superadmin@admin.com', '$2y$12$ZGvHnW1Dx9Q9OYX1IsGBCuplehuQc.dFkp0d.YeJ.4v6ZImI8Bz8m', NULL, NULL, 0, '2024-08-25 13:11:23', '2024-08-25 12:57:28', '2024-08-25 13:11:23');

-- --------------------------------------------------------

--
-- Table structure for table `auth_logins`
--

CREATE TABLE `auth_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `auth_logins`
--

INSERT INTO `auth_logins` (`id`, `ip_address`, `user_agent`, `id_type`, `identifier`, `user_id`, `date`, `success`) VALUES
(1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'superadmin@gmail.com', NULL, '2024-08-25 12:58:50', 0),
(2, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'superadmin@admin.com', 1, '2024-08-25 12:59:00', 1),
(3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'nugraha29@najmudin.web.id', NULL, '2024-08-25 13:09:07', 0),
(4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'superadmin@admin.com', 1, '2024-08-25 13:11:23', 1);

-- --------------------------------------------------------

--
-- Table structure for table `auth_permissions_users`
--

CREATE TABLE `auth_permissions_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `permission` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `auth_remember_tokens`
--

CREATE TABLE `auth_remember_tokens` (
  `id` int(11) UNSIGNED NOT NULL,
  `selector` varchar(255) NOT NULL,
  `hashedValidator` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `expires` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `auth_token_logins`
--

CREATE TABLE `auth_token_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(127) NOT NULL,
  `author` varchar(64) NOT NULL,
  `publisher` varchar(64) NOT NULL,
  `isbn` varchar(13) NOT NULL,
  `year` year(4) NOT NULL,
  `rack_id` int(11) UNSIGNED NOT NULL,
  `category_id` int(11) UNSIGNED NOT NULL,
  `book_cover` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `slug`, `title`, `author`, `publisher`, `isbn`, `year`, `rack_id`, `category_id`, `book_cover`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'autem-molestias-magnam11669', 'Autem molestias magnam.', 'Eluh Maulana', 'Yayasan Tarihoran', '9781120321190', 1980, 1, 2, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, 'voluptates-inventore-asperiores19493', 'Voluptates inventore asperiores.', 'Cici Uyainah S.H.', 'PD Andriani', '9786825819966', 2005, 5, 1, 'book-1.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(3, 'in-aliquid-quam19730', 'In aliquid quam.', 'Cawisono Anggriawan', 'Perum Rahayu Tbk', '9795619945927', 1984, 9, 4, 'book-5.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(4, 'recusandae-corporis-commodi-omnis-non27052', 'Recusandae corporis commodi omnis non.', 'Pardi Irawan', 'PD Hardiansyah Pangestu (Persero) Tbk', '9780912663609', 2021, 9, 3, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(5, 'quidem-ut-nulla19972', 'Quidem ut nulla.', 'Ganep Winarno', 'UD Nasyiah Halimah Tbk', '9785061525105', 1994, 3, 2, 'book-10.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(6, 'maiores-ut-quod95564', 'Maiores ut quod.', 'Balamantri Jamal Ardianto S.IP', 'PT Widodo', '9790127024041', 2019, 9, 4, 'book-8.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(7, 'voluptatem-qui-fugiat29018', 'Voluptatem qui fugiat.', 'Kamila Rahimah S.E.I', 'UD Safitri Widodo Tbk', '9786405845422', 2004, 3, 4, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(8, 'inventore-sunt48602', 'Inventore sunt.', 'Ganda Hakim', 'CV Fujiati Setiawan', '9786236593813', 1997, 5, 5, 'book-4.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(9, 'cumque-adipisci-facere32213', 'Cumque adipisci facere.', 'Ulva Yolanda', 'PT Narpati (Persero) Tbk', '9794455792481', 1975, 5, 3, 'book-3.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(10, 'eveniet-quo-rem-praesentium-minus69325', 'Eveniet quo rem praesentium minus.', 'Harimurti Indra Putra', 'Fa Rajasa', '9784237620712', 1999, 4, 2, 'book-7.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(11, 'veritatis-sapiente-totam-ut-doloribus-magnam20196', 'Veritatis sapiente totam ut doloribus magnam.', 'Dalima Salwa Mandasari', 'Fa Astuti', '9797815408848', 2001, 9, 3, 'book-6.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(12, 'quasi-blanditiis-nihil79165', 'Quasi blanditiis nihil.', 'Mala Lidya Puspasari', 'Perum Kusumo Wulandari', '9782739480049', 1971, 7, 3, 'book-8.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(13, 'quod-unde-ut-eaque27606', 'Quod unde ut eaque.', 'Carla Padmasari', 'PJ Mansur Gunawan (Persero) Tbk', '9798358981911', 2013, 6, 3, 'book-8.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(14, 'quia-eum-ut18565', 'Quia eum ut.', 'Catur Prabawa Pangestu S.Gz', 'Perum Halimah Usada', '9785233310362', 1997, 7, 2, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(15, 'et-fuga-est-aut-delectus22039', 'Et fuga est aut delectus.', 'Salwa Astuti S.Psi', 'PT Wahyuni', '9782827480333', 2013, 9, 1, 'book-3.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(16, 'labore-est-quod50806', 'Labore est quod.', 'Kayla Zulaika', 'CV Nasyiah Oktaviani Tbk', '9780114896034', 1972, 6, 5, 'book-3.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(17, 'perferendis-voluptatem-aperiam-suscipit53200', 'Perferendis voluptatem aperiam suscipit.', 'Mahfud Manullang', 'Yayasan Halim Tbk', '9796181656891', 1978, 2, 5, 'book-7.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(18, 'quia-ut-quisquam-quos-suscipit22345', 'Quia ut quisquam quos suscipit.', 'Ganep Damar Pangestu S.Psi', 'Fa Siregar (Persero) Tbk', '9789503328248', 2014, 9, 5, 'book-9.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(19, 'quam-quae-accusantium-culpa-voluptatem87252', 'Quam quae accusantium culpa voluptatem.', 'Karsa Januar', 'PJ Ardianto Tbk', '9798673183083', 1983, 7, 3, 'book-8.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(20, 'esse-sint35765', 'Esse sint.', 'Ihsan Prayoga', 'Yayasan Utami Januar', '9797783186830', 2011, 3, 1, 'book-10.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(21, 'dicta-repellendus-provident-numquam-ullam-magni29707', 'Dicta repellendus provident numquam ullam magni.', 'Uchita Paramita Rahayu S.E.', 'PJ Sinaga Simanjuntak', '9785980722074', 2022, 8, 1, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(22, 'quod-totam65099', 'Quod totam.', 'Nova Aryani', 'Perum Yolanda Situmorang', '9787120927707', 1978, 2, 3, 'book-8.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(23, 'et-et-libero61601', 'Et et libero.', 'Amelia Purnawati', 'Fa Winarno', '9787927583915', 1985, 1, 4, 'book-3.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(24, 'praesentium-et16382', 'Praesentium et.', 'Rika Titin Mayasari S.H.', 'PT Saragih Hasanah (Persero) Tbk', '9799590801685', 1994, 3, 5, 'book-1.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(25, 'velit-quas-et-aut-nostrum66423', 'Velit quas et aut nostrum.', 'Gina Hariyah', 'Yayasan Palastri', '9797818515444', 2010, 1, 5, 'book-2.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(26, 'ab-excepturi-similique79629', 'Ab excepturi similique.', 'Septi Prastuti', 'Perum Susanti Sihombing', '9791472035287', 2021, 8, 5, 'book-6.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(27, 'et-est-soluta-non92265', 'Et est soluta non.', 'Ophelia Yolanda', 'CV Mandala Anggriawan (Persero) Tbk', '9790433031696', 1986, 2, 4, 'book-4.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(28, 'numquam-hic-sunt10908', 'Numquam hic sunt.', 'Emin Warta Waskita', 'Perum Zulaika Hutapea (Persero) Tbk', '9797238916807', 2013, 6, 3, 'book-5.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(29, 'est-velit-magni-ratione-doloremque71063', 'Est velit magni ratione doloremque.', 'Wakiman Sihombing', 'UD Kuswandari Hutapea', '9781766118376', 1972, 5, 4, 'book-4.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(30, 'aut-omnis-necessitatibus21191', 'Aut omnis necessitatibus.', 'Jumari Siregar', 'Yayasan Namaga (Persero) Tbk', '9786214000319', 2018, 5, 2, 'book-10.jpg', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(31, 'ratione-est-fugit69192', 'Ratione est fugit.', 'Kasiyah Novitasari', 'PD Saragih Tbk', '9781406197433', 1978, 7, 1, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(32, 'aperiam-eum-dolorem67379', 'Aperiam eum dolorem.', 'Icha Aryani M.Farm', 'Perum Riyanti Tbk', '9798505595251', 1992, 7, 2, 'book-5.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(33, 'culpa-reiciendis-voluptas-adipisci-optio-officia76230', 'Culpa reiciendis voluptas adipisci optio officia.', 'Cahyo Putra S.Pd', 'Perum Narpati Kusmawati', '9790563585489', 2011, 1, 1, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(34, 'eum-sed-aut-et-esse55797', 'Eum sed aut et esse.', 'Ratih Wastuti', 'PT Oktaviani Rajata Tbk', '9783309402942', 1970, 2, 2, 'book-4.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(35, 'molestias-ut37142', 'Molestias ut.', 'Yulia Eli Riyanti', 'Yayasan Rajata Sitorus', '9789496911496', 1971, 5, 1, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(36, 'ut-odit-cupiditate-sapiente89865', 'Ut odit cupiditate sapiente.', 'Jarwi Cahyo Sihombing S.IP', 'PJ Nuraini Widiastuti Tbk', '9789525696233', 2015, 8, 5, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(37, 'necessitatibus-qui-non58262', 'Necessitatibus qui non.', 'Candra Gamani Pangestu S.Pt', 'PJ Hastuti (Persero) Tbk', '9798195636203', 2021, 5, 1, 'book-7.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(38, 'et-dicta-quis-sit-perferendis96617', 'Et dicta quis sit perferendis.', 'Ibrahim Januar S.I.Kom', 'Perum Ramadan Riyanti Tbk', '9798237774856', 1978, 2, 5, 'book-2.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(39, 'perferendis-perspiciatis-iusto-tempora77194', 'Perferendis perspiciatis iusto tempora.', 'Lasmono Prayoga', 'PJ Megantara (Persero) Tbk', '9780340917992', 1998, 3, 3, 'book-9.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(40, 'sint-reprehenderit96435', 'Sint reprehenderit.', 'Silvia Fujiati', 'PJ Najmudin Handayani', '9783861305378', 2021, 6, 3, 'book-4.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(41, 'voluptas-et-aut-ullam-id17296', 'Voluptas et aut ullam id.', 'Najwa Dinda Oktaviani M.Farm', 'UD Dabukke', '9798814480224', 2009, 8, 3, 'book-9.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(42, 'nemo-impedit-illo45489', 'Nemo impedit illo.', 'Jaiman Najmudin', 'Fa Oktaviani', '9783938184189', 1980, 7, 3, 'book-7.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(43, 'asperiores-eaque-est-vel42822', 'Asperiores eaque est vel.', 'Carla Hartati', 'PJ Hassanah', '9784365092658', 2011, 9, 1, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(44, 'quas-vel-et10520', 'Quas vel et.', 'Puput Mala Agustina', 'CV Natsir', '9794144389169', 1979, 3, 1, 'book-1.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(45, 'est-dignissimos68820', 'Est dignissimos.', 'Warta Sihombing M.Ak', 'PD Ardianto Tarihoran Tbk', '9789914928228', 2009, 5, 3, 'book-3.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(46, 'rerum-voluptatem-consequatur-at45207', 'Rerum voluptatem consequatur at.', 'Teguh Damanik S.E.', 'PJ Nugroho', '9793732617844', 2013, 5, 5, 'book-2.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(47, 'harum-consequatur-ratione-voluptatem-dicta46187', 'Harum consequatur ratione voluptatem dicta.', 'Darmanto Waskita', 'PJ Narpati', '9783425800714', 1980, 6, 1, 'book-7.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(48, 'in-rerum-vitae69701', 'In rerum vitae.', 'Candrakanta Suryono', 'CV Rahmawati Maryadi', '9795540018714', 2001, 4, 4, 'book-3.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(49, 'voluptatem-voluptas-nostrum45941', 'Voluptatem voluptas nostrum.', 'Shakila Mayasari', 'Yayasan Uyainah Tbk', '9792137378114', 2000, 7, 3, 'book-6.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(50, 'dolores-esse-tempore-beatae82307', 'Dolores esse tempore beatae.', 'Ira Ella Laksmiwati S.IP', 'PD Firgantoro Maheswara', '9790652827315', 2005, 9, 4, 'book-5.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(51, 'ullam-ut-consequatur70919', 'Ullam ut consequatur.', 'Unjani Hariyah', 'PJ Lailasari', '9796022452156', 1984, 4, 1, 'book-5.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(52, 'rerum-quae-aperiam-in81145', 'Rerum quae aperiam in.', 'Suci Wahyuni', 'CV Namaga', '9786065557895', 2008, 3, 1, 'book-4.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(53, 'cumque-incidunt-et-suscipit72519', 'Cumque incidunt et suscipit.', 'Nalar Heryanto Halim', 'UD Rahmawati Hassanah', '9792231645587', 1974, 8, 2, 'book-6.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(54, 'eligendi-voluptatem-sed-esse78389', 'Eligendi voluptatem sed esse.', 'Zulaikha Jessica Winarsih', 'Fa Wulandari (Persero) Tbk', '9797914691851', 2009, 1, 3, 'book-3.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(55, 'modi-totam-pariatur-dolorem24829', 'Modi totam pariatur dolorem.', 'Lidya Iriana Namaga S.E.I', 'UD Anggraini Pratiwi Tbk', '9783862939633', 2004, 9, 2, 'book-8.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(56, 'aliquid-dolores-quae-iure-facere64175', 'Aliquid dolores quae iure facere.', 'Lasmanto Rajata', 'Fa Suwarno Wijayanti', '9783519051053', 2021, 7, 3, 'book-1.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(57, 'beatae-quod-vel78484', 'Beatae quod vel.', 'Gabriella Prastuti', 'Yayasan Puspasari', '9799692074789', 2011, 8, 2, 'book-6.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(58, 'minus-et-eaque53078', 'Minus et eaque.', 'Ayu Tina Melani S.Psi', 'CV Suryatmi (Persero) Tbk', '9796015399987', 1992, 9, 5, 'book-6.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(59, 'quo-iste-facilis-sequi66375', 'Quo iste facilis sequi.', 'Jasmin Hassanah', 'PJ Yuliarti Dabukke (Persero) Tbk', '9785702345826', 1983, 2, 3, 'book-3.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(60, 'nulla-suscipit-delectus-libero-velit27677', 'Nulla suscipit delectus libero velit.', 'Elvina Lestari S.Pd', 'PD Wijayanti', '9797925661973', 2024, 10, 3, 'book-5.jpg', '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `book_stock`
--

CREATE TABLE `book_stock` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `book_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `book_stock`
--

INSERT INTO `book_stock` (`id`, `book_id`, `quantity`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 35, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, 2, 64, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(3, 3, 73, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(4, 4, 70, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(5, 5, 55, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(6, 6, 54, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(7, 7, 29, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(8, 8, 58, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(9, 9, 18, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(10, 10, 35, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(11, 11, 46, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(12, 12, 40, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(13, 13, 86, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(14, 14, 43, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(15, 15, 47, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(16, 16, 58, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(17, 17, 7, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(18, 18, 49, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(19, 19, 35, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(20, 20, 86, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(21, 21, 62, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(22, 22, 63, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(23, 23, 68, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(24, 24, 59, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(25, 25, 99, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(26, 26, 78, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(27, 27, 58, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(28, 28, 53, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(29, 29, 85, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(30, 30, 8, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(31, 1, 64, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(32, 2, 21, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(33, 3, 70, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(34, 4, 44, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(35, 5, 76, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(36, 6, 17, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(37, 7, 88, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(38, 8, 69, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(39, 9, 99, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(40, 10, 14, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(41, 11, 30, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(42, 12, 11, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(43, 13, 27, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(44, 14, 99, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(45, 15, 7, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(46, 16, 37, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(47, 17, 41, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(48, 18, 49, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(49, 19, 12, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(50, 20, 29, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(51, 21, 84, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(52, 22, 20, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(53, 23, 22, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(54, 24, 12, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(55, 25, 22, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(56, 26, 22, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(57, 27, 67, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(58, 28, 14, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(59, 29, 70, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(60, 30, 85, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(61, 31, 86, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(62, 32, 60, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(63, 33, 83, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(64, 34, 14, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(65, 35, 79, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(66, 36, 49, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(67, 37, 76, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(68, 38, 20, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(69, 39, 50, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(70, 40, 71, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(71, 41, 58, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(72, 42, 73, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(73, 43, 49, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(74, 44, 25, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(75, 45, 93, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(76, 46, 81, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(77, 47, 67, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(78, 48, 22, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(79, 49, 88, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(80, 50, 11, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(81, 51, 86, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(82, 52, 27, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(83, 53, 56, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(84, 54, 11, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(85, 55, 10, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(86, 56, 60, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(87, 57, 41, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(88, 58, 14, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(89, 59, 53, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL),
(90, 60, 32, '2024-08-25 05:57:45', '2024-08-25 05:57:45', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(64) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Fiksi', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, 'Non-Fiksi', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(3, 'Sejarah', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(4, 'Komik', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(5, 'Teknologi', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(6, 'Fiksi', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(7, 'Non-Fiksi', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(8, 'Sejarah', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(9, 'Komik', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(10, 'Teknologi', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fines`
--

CREATE TABLE `fines` (
  `id` int(11) UNSIGNED NOT NULL,
  `loan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount_paid` int(11) UNSIGNED DEFAULT NULL,
  `fine_amount` int(11) UNSIGNED NOT NULL,
  `paid_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `fines`
--

INSERT INTO `fines` (`id`, `loan_id`, `amount_paid`, `fine_amount`, `paid_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 3, NULL, 20000, NULL, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, 4, 15000, 15000, '2024-09-14 17:02:39', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fines_per_day`
--

CREATE TABLE `fines_per_day` (
  `id` int(11) UNSIGNED NOT NULL,
  `amount` int(11) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `fines_per_day`
--

INSERT INTO `fines_per_day` (`id`, `amount`, `created_at`, `updated_at`) VALUES
(1, 1000, '2024-08-25 05:57:23', '2024-08-25 05:57:23');

-- --------------------------------------------------------

--
-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` varchar(255) NOT NULL,
  `book_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) UNSIGNED NOT NULL DEFAULT 1,
  `member_id` int(11) UNSIGNED NOT NULL,
  `loan_date` datetime NOT NULL,
  `due_date` date NOT NULL,
  `return_date` datetime DEFAULT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` (`id`, `uid`, `book_id`, `quantity`, `member_id`, `loan_date`, `due_date`, `return_date`, `qr_code`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '356a192b7913b04c54574d18c28d46e6395428ab', 1, 1, 1, '2024-07-18 11:13:39', '2024-08-07', '2024-08-07 10:05:39', NULL, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, 'da4b9237bacccdf19c0760cab7aec4a8359010b0', 4, 1, 2, '2024-07-24 10:03:39', '2024-09-06', NULL, 'nardi-sinaga_rec_2f53b_1724565965.png', '2024-08-25 05:57:39', '2024-08-25 06:06:05', NULL),
(3, '77de68daecd823babbb58edb1c8e14d7106e83bb', 2, 5, 3, '2024-07-21 10:53:39', '2024-08-15', '2024-09-07 14:33:39', 'sakura-nurai_vol_e04fc_1724565847.png', '2024-08-25 05:57:39', '2024-08-25 06:04:07', NULL),
(4, '1b6453892473a467d07372d45eb05abc2031647a', 1, 1, 4, '2024-07-23 10:38:39', '2024-07-30', '2024-08-26 17:02:39', NULL, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL);

-- --------------------------------------------------------

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

CREATE TABLE `members` (
  `id` int(11) UNSIGNED NOT NULL,
  `uid` varchar(255) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` text DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `gender` enum('Male','Female') NOT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `members` (`id`, `uid`, `first_name`, `last_name`, `email`, `phone`, `address`, `date_of_birth`, `gender`, `qr_code`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'e2d53e686b4e359f03f08c970cb217fee50dcf26', 'Farhunnisa', 'Hasanah', 'nugraha29@najmudin.web.id', '(+62) 476 8459 3465', 'Kpg. Kartini No. 289, Pangkal Pinang 44698, Kalbar', '1980-12-24', 'Female', 'farhunnisa-hasan_02347_1724566057.png', '2024-08-25 05:57:39', '2024-08-25 06:07:37', NULL),
(2, '557d1c4293eb5f4144e50c56f5e9103210394de9', 'Nardi', 'Sinaga', 'queen.sitompul@yahoo.co.id', '(+62) 891 8294 4079', 'Ds. Gremet No. 853, Surabaya 16479, Maluku', '1976-11-15', 'Male', 'nardi-sinaga_3fe8d_1724566062.png', '2024-08-25 05:57:39', '2024-08-25 06:07:42', NULL),
(3, 'f4205565b80b375f9865713f3466c17ec94a03c3', 'Sakura', 'Nuraini', 'mangunsong.lili@gmail.com', '(+62) 344 5149 1899', 'Gg. Sadang Serang No. 893, Tangerang 97764, Jambi', '1994-03-07', 'Female', 'sakura-nuraini_a8d8c_1724566070.png', '2024-08-25 05:57:39', '2024-08-25 06:07:51', NULL),
(4, 'b6fb0d35fc89c860f0f6e28c5ef75b5aa8207891', 'Sakura', 'Wastuti', 'jzulaika@yahoo.com', '0476 8337 9655', 'Jr. Ujung No. 289, Palangka Raya 19101, Sulteng', '1980-05-11', 'Female', 'sakura-wastuti_0068a_1724566066.png', '2024-08-25 05:57:39', '2024-08-25 06:07:46', NULL),
(5, 'd19c84f4055f58a7a86ba6613c7e6276cbeadbf0', 'Banawa', 'Hidayanto', 'ciaobella22@nasyidah.biz', '(+62) 523 7055 3485', 'Gg. Babakan No. 531, Pariaman 78357, Kalbar', '1970-01-21', 'Male', NULL, '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(6, 'fc3f3c8981aac796e9f47c8f21a6feba4cd1bb37', 'Kardi', 'Pradana', 'nnababan@gmail.co.id', '(+62) 229 7556 293', 'Psr. B.Agam Dlm No. 919, Mataram 79731, NTB', '2003-01-04', 'Male', NULL, '2024-08-25 05:57:49', '2024-08-25 05:57:49', NULL),
(7, '8473c6a8acf62428ebfd141935c2f99d476c0c73', 'Rahmi', 'Yuniar', 'opung94@yahoo.co.id', '0887 3267 588', 'Ki. Eka No. 133, Pangkal Pinang 91120, Kaltara', '2010-09-13', 'Female', NULL, '2024-08-25 05:57:49', '2024-08-25 05:57:49', NULL),
(8, 'fe737004119b414a5d0e58f2185c5a045b340093', 'Banawa', 'Nababan', 'amalia70@gmail.co.id', '0381 2939 2373', 'Gg. Gardujati No. 859, Bitung 53506, Sulteng', '2004-01-31', 'Male', NULL, '2024-08-25 05:57:49', '2024-08-25 05:57:49', NULL),
(9, 'c059938ac65ce838b77a1df7dadcf41cdb96225c', 'Nasrullah', 'Sihombing', 'halimah.maida@yahoo.com', '0302 1745 985', 'Psr. Jamika No. 961, Kediri 41975, Sumsel', '1974-05-07', 'Male', NULL, '2024-08-25 05:57:49', '2024-08-25 05:57:49', NULL),
(10, 'd655b0fa7e8d5c0afa38e884d8b753dfb931e160', 'Gangsar', 'Sinaga', 'harimurti.pratiwi@gmail.co.id', '0692 0580 697', 'Jln. Bak Mandi No. 600, Padangsidempuan 65584, Malut', '2020-03-07', 'Male', NULL, '2024-08-25 05:57:49', '2024-08-25 05:57:49', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2020-12-28-223112', 'CodeIgniter\\Shield\\Database\\Migrations\\CreateAuthTables', 'default', 'CodeIgniter\\Shield', 1724565443, 1),
(2, '2021-07-04-041948', 'CodeIgniter\\Settings\\Database\\Migrations\\CreateSettingsTable', 'default', 'CodeIgniter\\Settings', 1724565443, 1),
(3, '2021-11-14-143905', 'CodeIgniter\\Settings\\Database\\Migrations\\AddContextColumn', 'default', 'CodeIgniter\\Settings', 1724565443, 1),
(4, '2023-08-12-000001', 'App\\Database\\Migrations\\CreateRacksTable', 'default', 'App', 1724565443, 1),
(5, '2023-08-12-000002', 'App\\Database\\Migrations\\CreateCategoriesTable', 'default', 'App', 1724565443, 1),
(6, '2023-08-12-000003', 'App\\Database\\Migrations\\CreateBooksTable', 'default', 'App', 1724565443, 1),
(7, '2023-08-12-000004', 'App\\Database\\Migrations\\CreateBookStockTable', 'default', 'App', 1724565443, 1),
(8, '2023-08-12-000005', 'App\\Database\\Migrations\\CreateMembersTable', 'default', 'App', 1724565443, 1),
(9, '2023-08-12-000006', 'App\\Database\\Migrations\\CreateLoansTable', 'default', 'App', 1724565443, 1),
(10, '2023-08-12-000007', 'App\\Database\\Migrations\\CreateFinesTable', 'default', 'App', 1724565443, 1),
(11, '2024-07-08-045735', 'App\\Database\\Migrations\\CreateFinesPerDayTable', 'default', 'App', 1724565443, 1);

-- --------------------------------------------------------

--
-- Table structure for table `racks`
--

CREATE TABLE `racks` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(8) NOT NULL,
  `floor` varchar(16) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `racks`
--

INSERT INTO `racks` (`id`, `name`, `floor`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '1A', '1', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(2, '1B', '1', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(3, '1C', '1', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(4, '2A', '2', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(5, '2B', '2', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(6, '2C', '2', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(7, '3A', '3', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(8, '3B', '3', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(9, '3C', '3', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(10, '3D', '3', '2024-08-25 05:57:39', '2024-08-25 05:57:39', NULL),
(11, '1A', '1', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(12, '1B', '1', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(13, '1C', '1', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(14, '2A', '2', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(15, '2B', '2', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(16, '2C', '2', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(17, '3A', '3', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(18, '3B', '3', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(19, '3C', '3', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL),
(20, '3D', '3', '2024-08-25 05:57:44', '2024-08-25 05:57:44', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(9) NOT NULL,
  `class` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `type` varchar(31) NOT NULL DEFAULT 'string',
  `context` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(30) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `status_message` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `last_active` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `status`, `status_message`, `active`, `last_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'superadmin', NULL, NULL, 1, '2024-08-25 13:47:46', '2024-08-25 12:57:28', '2024-08-25 12:57:28', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_groups_users_user_id_foreign` (`user_id`);

--
-- Indexes for table `auth_identities`
--
ALTER TABLE `auth_identities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `type_secret` (`type`,`secret`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `auth_logins`
--
ALTER TABLE `auth_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_permissions_users_user_id_foreign` (`user_id`);

--
-- Indexes for table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `selector` (`selector`),
  ADD KEY `auth_remember_tokens_user_id_foreign` (`user_id`);

--
-- Indexes for table `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `books_rack_id_foreign` (`rack_id`),
  ADD KEY `books_category_id_foreign` (`category_id`);

--
-- Indexes for table `book_stock`
--
ALTER TABLE `book_stock`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_stock_book_id_foreign` (`book_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fines`
--
ALTER TABLE `fines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fines_loan_id_foreign` (`loan_id`);

--
-- Indexes for table `fines_per_day`
--
ALTER TABLE `fines_per_day`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `loans`
--
ALTER TABLE `loans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uid` (`uid`),
  ADD KEY `loans_book_id_foreign` (`book_id`),
  ADD KEY `loans_member_id_foreign` (`member_id`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uid` (`uid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `racks`
--
ALTER TABLE `racks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `auth_identities`
--
ALTER TABLE `auth_identities`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `auth_logins`
--
ALTER TABLE `auth_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `book_stock`
--
ALTER TABLE `book_stock`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `fines`
--
ALTER TABLE `fines`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `fines_per_day`
--
ALTER TABLE `fines_per_day`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `loans`
--
ALTER TABLE `loans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `racks`
--
ALTER TABLE `racks`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(9) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD CONSTRAINT `auth_groups_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auth_identities`
--
ALTER TABLE `auth_identities`
  ADD CONSTRAINT `auth_identities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD CONSTRAINT `auth_permissions_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD CONSTRAINT `auth_remember_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `books`
--
ALTER TABLE `books`
  ADD CONSTRAINT `books_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `books_rack_id_foreign` FOREIGN KEY (`rack_id`) REFERENCES `racks` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Constraints for table `book_stock`
--
ALTER TABLE `book_stock`
  ADD CONSTRAINT `book_stock_book_id_foreign` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `fines`
--
ALTER TABLE `fines`
  ADD CONSTRAINT `fines_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `loans` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `loans`
--
ALTER TABLE `loans`
  ADD CONSTRAINT `loans_book_id_foreign` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `loans_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE;
COMMIT;

