-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 25 Jul 2023 pada 08.39
-- Versi server: 5.7.33
-- Versi PHP: 7.4.19

START TRANSACTION;



--
-- Database: `perp`
--

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

--
-- Struktur dari tabel `categories`
--

CREATE TABLE `categories` (
  `cat_id` bigint(11) UNSIGNED NOT NULL,
  `cat_code` varchar(255) NOT NULL,
  `cat_name` varchar(255) NOT NULL,
  `cat_status` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `customizations`
--

CREATE TABLE `customizations` (
  `custom_id` bigint(11) UNSIGNED NOT NULL,
  `front_title` varchar(255) DEFAULT NULL,
  `front_description` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `customizations`
--

INSERT INTO `customizations` (`custom_id`, `front_title`, `front_description`) VALUES
(1, '', 'Digital Library AnZFam (DILANZ) adalah Perpustakaan Digital dengan berbagai macam kategori Buku Elektronik (E-Book) yang selalu ter-update yang dapat memperluas pengetahuan dan wawasan anda. KUNJUNGI: app.anzfam.com');

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

--
-- Struktur dari tabel `e_categories`
--

CREATE TABLE `e_categories` (
  `ecat_id` varchar(255) NOT NULL,
  `ecat_name` varchar(255) NOT NULL,
  `ecat_status` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `e_collections`
--

CREATE TABLE `e_collections` (
  `ecol_id` varchar(255) NOT NULL,
  `ecol_u` varchar(255) NOT NULL,
  `ecat_id` varchar(255) NOT NULL,
  `esubcat_id` varchar(255) NOT NULL,
  `ecol_title` text NOT NULL,
  `ecol_slug` text NOT NULL,
  `ecol_desc` longtext,
  `ecol_author` varchar(255) DEFAULT NULL,
  `ecol_edition` varchar(255) DEFAULT NULL,
  `ecol_publishedin` varchar(255) DEFAULT NULL,
  `ecol_publishedat` varchar(255) DEFAULT NULL,
  `ecol_issbn` varchar(255) DEFAULT NULL,
  `ecol_publisher` varchar(255) DEFAULT NULL,
  `ecol_ebook` varchar(255) DEFAULT NULL,
  `ecol_cover` varchar(255) DEFAULT NULL,
  `ecol_coverin` int(2) DEFAULT NULL,
  `ecol_coveracc` varchar(255) DEFAULT NULL,
  `ecol_extension` varchar(255) DEFAULT NULL,
  `ecol_size` varchar(255) DEFAULT NULL,
  `ecol_storage` int(2) DEFAULT NULL,
  `ecol_acc` varchar(255) DEFAULT NULL,
  `ecol_status` int(3) NOT NULL,
  `ecol_topstatus` varchar(3) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `ecol_by` int(11) NOT NULL,
  `red_counter` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `e_comments`
--

CREATE TABLE `e_comments` (
  `comment_id` bigint(11) UNSIGNED NOT NULL,
  `commentator_name` varchar(255) NOT NULL,
  `commentator_pos` varchar(255) NOT NULL,
  `commentator_img` varchar(255) NOT NULL,
  `comments_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `e_comments`
--

INSERT INTO `e_comments` (`comment_id`, `commentator_name`, `commentator_pos`, `commentator_img`, `comments_text`) VALUES
(1, 'Saul Goodman', 'Kepala Sekolah', 'testimonials-2.jpg', ' Proin iaculis purus consequat sem cure digni ssim donec porttitora entum suscipit rhoncus. Accusantium quam, ultricies eget id, aliquam eget nibh et. Maecen aliquam, risus at semper.'),
(2, 'Sara Wilsson', 'Waka Kurikulum', 'testimonials-2.jpg', 'Export tempor illum tamen malis malis eram quae irure esse labore quem cillum quid cillum eram malis quorum velit fore eram velit sunt aliqua noster fugiat irure amet legam anim culpa.'),
(3, 'Jena Karlis', 'Waka Kesiswaan', 'testimonials-2.jpg', 'Enim nisi quem export duis labore cillum quae magna enim sint quorum nulla quem veniam duis minim tempor labore quem eram duis noster aute amet eram fore quis sint minim.');

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

--
-- Struktur dari tabel `e_subcategories`
--

CREATE TABLE `e_subcategories` (
  `esubcat_id` varchar(255) NOT NULL,
  `ecat_id` varchar(255) NOT NULL,
  `esubcat_name` varchar(255) NOT NULL,
  `esubcat_status` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `e_visitors`
--

CREATE TABLE `e_visitors` (
  `visitor_id` bigint(11) UNSIGNED NOT NULL,
  `visitor_ip` varchar(255) NOT NULL,
  `visit_at` date NOT NULL,
  `visit_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `e_visitors`
--

INSERT INTO `e_visitors` (`visitor_id`, `visitor_ip`, `visit_at`, `visit_time`) VALUES
(1, '::1', '2023-04-08', '14:34:51'),
(2, '::1', '2023-04-10', '11:34:25');

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

--
-- Struktur dari tabel `institution`
--

CREATE TABLE `institution` (
  `inst_id` int(11) UNSIGNED NOT NULL,
  `inst_name` varchar(200) NOT NULL,
  `inst_npsn` varchar(200) NOT NULL,
  `inst_nsm` varchar(200) DEFAULT NULL,
  `inst_headmaster` varchar(200) DEFAULT NULL,
  `inst_telp` varchar(200) DEFAULT NULL,
  `inst_address` varchar(255) DEFAULT NULL,
  `inst_village` varchar(255) DEFAULT NULL,
  `inst_district` varchar(255) DEFAULT NULL,
  `inst_regency` varchar(255) DEFAULT NULL,
  `inst_province` varchar(255) DEFAULT NULL,
  `inst_img` varchar(255) DEFAULT NULL,
  `inst_web` varchar(255) DEFAULT NULL,
  `inst_email` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `institution`
--

INSERT INTO `institution` (`inst_id`, `inst_name`, `inst_npsn`, `inst_nsm`, `inst_headmaster`, `inst_telp`, `inst_address`, `inst_village`, `inst_district`, `inst_regency`, `inst_province`, `inst_img`, `inst_web`, `inst_email`) VALUES
(1, 'PERPUSTAKAAN TAMAN BACAAN MASYARAKAT', '275', '', 'AnzFam, M.Pd.', '08766656255', 'Jl. Indah - Megah, kab. Pati', 'Lahar', 'Telagabiru', 'Pati', 'Jawa Tengah', '1680937939_f3f21b6151995b7034fb.png', 'www.anzfam.com', 'email@anzfam.com');

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

--
-- Struktur dari tabel `lib_authors`
--

CREATE TABLE `lib_authors` (
  `author_id` varchar(255) NOT NULL,
  `author_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `lib_places`
--

CREATE TABLE `lib_places` (
  `place_id` varchar(255) NOT NULL,
  `place_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `lib_publishers`
--

CREATE TABLE `lib_publishers` (
  `publisher_id` varchar(255) NOT NULL,
  `publisher_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `lib_rules`
--

CREATE TABLE `lib_rules` (
  `rule_id` bigint(11) UNSIGNED NOT NULL,
  `cover_size` varchar(255) NOT NULL,
  `cover_extension` varchar(255) NOT NULL,
  `e_size` varchar(255) NOT NULL,
  `e_extension` varchar(255) NOT NULL,
  `e_covergid` varchar(255) DEFAULT NULL,
  `e_ebookgid` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `lib_rules`
--

INSERT INTO `lib_rules` (`rule_id`, `cover_size`, `cover_extension`, `e_size`, `e_extension`, `e_covergid`, `e_ebookgid`) VALUES
(1, '102400', 'jpg,jpeg,png', '104857600', 'pdf', '1ALf6n7QsV9xVd8odlULqbnZQgXJ6LdoR', '11ixrdabp0I4RjIb4OBNNPYunlaSpR8pM');

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

--
-- Struktur dari tabel `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;

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2022-05-19-065227', 'App\\Database\\Migrations\\Admin', 'default', 'App', 1680937659, 1),
(2, '2022-05-19-070659', 'App\\Database\\Migrations\\Institution', 'default', 'App', 1680937659, 1),
(3, '2022-08-25-080716', 'App\\Database\\Migrations\\Kategori', 'default', 'App', 1680937659, 1),
(4, '2022-08-25-230133', 'App\\Database\\Migrations\\ECategories', 'default', 'App', 1680937659, 1),
(5, '2022-08-29-074100', 'App\\Database\\Migrations\\ESubcategories', 'default', 'App', 1680937659, 1),
(6, '2022-09-02-055502', 'App\\Database\\Migrations\\ECollections', 'default', 'App', 1680937659, 1),
(7, '2022-09-04-135641', 'App\\Database\\Migrations\\LibRules', 'default', 'App', 1680937659, 1),
(8, '2022-10-12-082414', 'App\\Database\\Migrations\\LibAuthors', 'default', 'App', 1680937659, 1),
(9, '2022-10-12-082505', 'App\\Database\\Migrations\\LibPlaces', 'default', 'App', 1680937659, 1),
(10, '2022-10-12-082525', 'App\\Database\\Migrations\\LibPublishers', 'default', 'App', 1680937659, 1),
(11, '2022-10-15-072200', 'App\\Database\\Migrations\\Visitors', 'default', 'App', 1680937659, 1),
(12, '2023-03-25-064628', 'App\\Database\\Migrations\\Customization', 'default', 'App', 1680937659, 1);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indeks untuk tabel `customizations`
--
ALTER TABLE `customizations`
  ADD PRIMARY KEY (`custom_id`);

--
-- Indeks untuk tabel `e_categories`
--
ALTER TABLE `e_categories`
  ADD PRIMARY KEY (`ecat_id`),
  ADD UNIQUE KEY `ecat_id` (`ecat_id`);

--
-- Indeks untuk tabel `e_collections`
--
ALTER TABLE `e_collections`
  ADD PRIMARY KEY (`ecol_id`),
  ADD UNIQUE KEY `ecol_id` (`ecol_id`),
  ADD UNIQUE KEY `ecol_u` (`ecol_u`);

--
-- Indeks untuk tabel `e_comments`
--
ALTER TABLE `e_comments`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indeks untuk tabel `e_subcategories`
--
ALTER TABLE `e_subcategories`
  ADD PRIMARY KEY (`esubcat_id`),
  ADD UNIQUE KEY `esubcat_id` (`esubcat_id`);

--
-- Indeks untuk tabel `e_visitors`
--
ALTER TABLE `e_visitors`
  ADD PRIMARY KEY (`visitor_id`);

--
-- Indeks untuk tabel `institution`
--
ALTER TABLE `institution`
  ADD PRIMARY KEY (`inst_id`);

--
-- Indeks untuk tabel `lib_authors`
--
ALTER TABLE `lib_authors`
  ADD PRIMARY KEY (`author_id`),
  ADD UNIQUE KEY `author_id` (`author_id`);

--
-- Indeks untuk tabel `lib_places`
--
ALTER TABLE `lib_places`
  ADD PRIMARY KEY (`place_id`),
  ADD UNIQUE KEY `place_id` (`place_id`);

--
-- Indeks untuk tabel `lib_publishers`
--
ALTER TABLE `lib_publishers`
  ADD PRIMARY KEY (`publisher_id`),
  ADD UNIQUE KEY `publisher_id` (`publisher_id`);

--
-- Indeks untuk tabel `lib_rules`
--
ALTER TABLE `lib_rules`
  ADD PRIMARY KEY (`rule_id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `categories`
--
ALTER TABLE `categories`
  MODIFY `cat_id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `customizations`
--
ALTER TABLE `customizations`
  MODIFY `custom_id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `e_comments`
--
ALTER TABLE `e_comments`
  MODIFY `comment_id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `e_visitors`
--
ALTER TABLE `e_visitors`
  MODIFY `visitor_id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `institution`
--
ALTER TABLE `institution`
  MODIFY `inst_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `lib_rules`
--
ALTER TABLE `lib_rules`
  MODIFY `rule_id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

