-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 09 Feb 2026 pada 04.16
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.2.12

START TRANSACTION;



--
-- Database: `tpk`
--

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

--
-- Struktur dari tabel `announcements`
--

CREATE TABLE `announcements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 0,
  `published_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `announcements`
--

INSERT INTO `announcements` (`id`, `title`, `slug`, `content`, `attachment`, `is_published`, `published_at`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Pendaftaran Mahasiswa Baru Semester Genap 2024/2025', 'pendaftaran-mahasiswa-baru-semester-genap-2024-2025', '<p>Pendaftaran mahasiswa baru Program Studi TPPK untuk semester genap tahun akademik 2024/2025 telah dibuka.</p>\r\n\r\n            <p><strong>Persyaratan:</strong></p>\r\n            <ul>\r\n                <li>Ijazah SMA/SMK sederajat</li>\r\n                <li>Raport semester 1-5</li>\r\n                <li>Foto 3x4 (2 lembar)</li>\r\n                <li>Foto full body</li>\r\n                <li>Surat keterangan sehat</li>\r\n            </ul>\r\n\r\n            <p><strong>Jadwal Pendaftaran:</strong><br>\r\n            1 Januari - 31 Maret 2025</p>\r\n\r\n            <p>Informasi lebih lanjut dapat diperoleh di bagian akademik atau website resmi kampus.</p>', NULL, 1, '2026-01-21 23:27:00', 1, '2026-01-22 23:27:26', '2026-01-23 00:57:34'),
(2, 'Pengumuman Hasil Seleksi Beasiswa Semester Genap', 'pengumuman-hasil-seleksi-beasiswa-semester-genap', '<p>Hasil seleksi beasiswa untuk semester genap tahun akademik 2024/2025 telah diumumkan.</p>\n\n            <p>Daftar nama penerima beasiswa dapat dilihat pada lampiran atau di papan pengumuman program studi.</p>\n\n            <p>Selamat kepada mahasiswa yang lolos seleksi. Tetap semangat dan jaga prestasi akademik!</p>\n\n            <p><strong>Catatan:</strong> Beasiswa dapat dicabut jika terjadi pelanggaran tata tertib kampus.</p>', NULL, 1, '2026-01-17 23:27:26', 1, '2026-01-22 23:27:26', '2026-01-22 23:27:26');

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

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_01_23_061904_add_role_to_users_table', 1),
(5, '2026_01_23_061913_create_news_table', 1),
(6, '2026_01_23_061918_create_announcements_table', 1),
(7, '2026_01_23_061924_create_profiles_table', 1),
(8, '2026_01_26_040225_create_sliders_table', 2);

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

--
-- Struktur dari tabel `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 0,
  `published_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `news`
--

INSERT INTO `news` (`id`, `title`, `slug`, `content`, `image`, `is_published`, `published_at`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Selamat Datang di Website Program Studi TPK', 'selamat-datang-website-program-studi-tppk', '<p>Selamat datang di website resmi Program Studi Teknologi Pengolahan Kulit (TPK). Website ini merupakan sumber informasi utama mengenai program studi kami.</p>\r\n\r\n            <h3>Apa yang bisa Anda temukan di sini?</h3>\r\n            <ul>\r\n                <li>Informasi lengkap tentang program studi</li>\r\n                <li>Berita terkini seputar kegiatan akademik</li>\r\n                <li>Pengumuman penting untuk mahasiswa</li>\r\n                <li>Profil dosen dan tenaga pengajar</li>\r\n                <li>Informasi akademik dan kurikulum</li>\r\n            </ul>\r\n\r\n            <p>Kami berkomitmen untuk memberikan pengalaman belajar yang berkualitas dan mempersiapkan lulusan yang siap bersaing di dunia kerja.</p>', 'news/FAy5FX5vfCAlHdcv8NXyb8blXEV9QzPF7YWAxtG5.jpg', 1, '2026-01-22 23:27:00', 1, '2026-01-22 23:27:26', '2026-02-04 20:26:10'),
(2, 'Workshop Teknologi Kulit Modern', 'workshop-teknologi-kulit-modern', '<p>Program Studi TPK mengadakan workshop teknologi kulit modern yang menghadirkan para ahli dari industri kulit nasional.</p>\r\n\r\n            <p>Workshop ini bertujuan untuk memberikan wawasan terkini tentang perkembangan teknologi pengolahan kulit serta praktik-praktik terbaik di industri.</p>\r\n\r\n            <h3>Materi Workshop:</h3>\r\n            <ul>\r\n                <li>Teknologi tanning modern</li>\r\n                <li>Inovasi dalam finishing kulit</li>\r\n                <li>Kualitas dan standar produk kulit</li>\r\n                <li>Tren pasar kulit global</li>\r\n            </ul>', 'news/dbAcCPYMPo9B3j2OF6EgbdvfHNuDzP8H10eRrFaB.jpg', 1, '2026-01-19 23:27:00', 1, '2026-01-22 23:27:26', '2026-02-04 20:27:33'),
(4, 'Lorem Ipsum', 'lorem-ipsum', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'news/puXXeULV8BD3Mg5XBfN7opJ5SZWQ4LA5rB3bcPro.jpg', 1, '2026-01-28 03:37:00', 1, '2026-01-27 20:37:31', '2026-02-03 21:06:59'),
(5, 'Tes Berita', 'tes-berita', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'news/LMY4APtpUTPtnxCHQdG5yRopwejD9oki7NzJpKoC.jpg', 1, '2026-01-28 03:41:00', 1, '2026-01-27 20:41:18', '2026-02-03 21:06:33');

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

--
-- Struktur dari tabel `profiles`
--

CREATE TABLE `profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `profiles`
--

INSERT INTO `profiles` (`id`, `section`, `title`, `content`, `image`, `order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'visi_misi', 'Visi Program Studi TPPK', '<h3>Visi</h3>\n            <p>Menjadi program studi unggul dalam bidang teknologi pengolahan produk kulit yang berdaya saing global dan berkontribusi pada pembangunan industri kulit nasional.</p>\n\n            <h3>Misi</h3>\n            <ol>\n                <li>Menyelenggarakan pendidikan tinggi yang bermutu dalam bidang teknologi pengolahan produk kulit</li>\n                <li>Mengembangkan penelitian yang inovatif dan aplikatif di bidang teknologi kulit</li>\n                <li>Melaksanakan pengabdian kepada masyarakat melalui transfer teknologi dan konsultasi</li>\n                <li>Menjalin kemitraan dengan industri kulit untuk pengembangan kurikulum dan praktikum</li>\n                <li>Mencetak lulusan yang kompeten, profesional, dan berakhlak mulia</li>\n            </ol>', NULL, 1, 1, '2026-01-22 23:27:26', '2026-01-22 23:27:26'),
(2, 'sejarah', 'Sejarah Program Studi TPPK', '<p>Program Studi Teknologi Pengolahan Produk Kulit (TPPK) didirikan pada tahun 2010 sebagai respon terhadap kebutuhan industri kulit nasional akan tenaga ahli yang kompeten.</p>\n\n            <p>Sejak awal berdiri, program studi ini telah berkomitmen untuk menghasilkan lulusan yang tidak hanya memiliki kompetensi teknis yang tinggi, tetapi juga memiliki etika kerja yang profesional.</p>\n\n            <p>Dalam perjalanannya, TPPK telah mengalami berbagai perkembangan, mulai dari sarana prasarana laboratorium, kurikulum yang selalu diperbaharui sesuai perkembangan teknologi, hingga kemitraan dengan berbagai perusahaan kulit terkemuka.</p>', NULL, 1, 1, '2026-01-22 23:27:26', '2026-01-22 23:27:26'),
(3, 'dosen', 'Dosen Tetap Program Studi TPPK', '<h3>Ketua Program Studi</h3>\n            <p><strong>Dr. Ir. Ahmad Suryanto, M.Sc.</strong><br>\n            Ahli di bidang teknologi kulit dan pengawetan kulit</p>\n\n            <h3>Dosen Tetap</h3>\n            <ul>\n                <li>Prof. Dr. Siti Nurhaliza, M.T. - Teknologi Finishing Kulit</li>\n                <li>Dr. Budi Santoso, M.Sc. - Kimia Kulit dan Bahan Tambahan</li>\n                <li>Ir. Rina Sari, M.T. - Teknologi Pengolahan Kulit</li>\n                <li>Dra. Maya Indah, M.Sc. - Analisis dan Pengendalian Kualitas</li>\n                <li>Ir. Hendro Wibowo, M.T. - Teknologi Lingkungan Industri Kulit</li>\n            </ul>\n\n            <h3>Dosen Luar Biasa</h3>\n            <ul>\n                <li>Ir. Bambang Pramono - Praktisi Industri Kulit PT. XYZ</li>\n                <li>Dra. Sari Dewi - Quality Control Manager PT. ABC Leather</li>\n            </ul>', NULL, 1, 1, '2026-01-22 23:27:26', '2026-01-22 23:27:26'),
(5, 'visi_misi', 'Lorem Ipsum', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', NULL, 1, 1, '2026-01-27 20:14:20', '2026-01-27 20:14:20');

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

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('eHnTNWYkFdKYzQSlFQykzmS5ngTSOEGhtHeL2ABK', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWh6OW1QSXFMU2ZFRGRQcjJHZTZxWVcxTHZ0VjlFNHd2c0c2QWtNcyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1770604166),
('r0lHpdGF2VcCiG9PU4ElB5F3PbEUjJf1atal8fN6', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMGxhS0ljcGRpVWhScHhWcnhnbUVoaGJJY0Z5VVBYZlZaRmRWVnh4ZiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1770606705),
('txkm70mtTJ3fz8H0HopiqbvxjshpT1naNAasFSZm', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWxSa2NUajlmWm9XWXA5WXF3R0QxV2RPWnM2OE1FOGxoVzZIUlRxYiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9sb2dpbiI7czo1OiJyb3V0ZSI7czoxMToiYWRtaW4ubG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1770601700);

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

--
-- Struktur dari tabel `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `description`, `image`, `button_text`, `button_link`, `is_active`, `order`, `created_at`, `updated_at`) VALUES
(5, 'Teknologi Pengolahan Kulit', 'Program Studi Teknologi Pengolahan Kulit berfokus pada pengembangan teknologi pengolahan kulit menjadi produk berkualitas tinggi. Kami mencetak lulusan yang terampil, inovatif, dan siap bersaing di dunia industri.', 'sliders/TvITeqm9jgi8Gr4gGVw99MMs1dCy7TIhyls8ebAx.jpg', NULL, NULL, 1, 1, '2026-01-27 20:20:27', '2026-02-05 23:27:46'),
(6, 'Pembukaan Mahasiswa Baru Politeknik ATK', 'Pembukaan Mahasiswa Baru Politeknik ATK telah di buka mulai Januari', 'sliders/KLMIaxjls5ALp8RoHXDpko2SbSKLIpJKXFMvJWw9.jpg', NULL, NULL, 1, 2, '2026-01-27 20:22:04', '2026-02-08 19:50:12');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `announcements_slug_unique` (`slug`),
  ADD KEY `announcements_user_id_foreign` (`user_id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indeks untuk tabel `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `news_slug_unique` (`slug`),
  ADD KEY `news_user_id_foreign` (`user_id`);

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

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `profiles`
--
ALTER TABLE `profiles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `announcements`
--
ALTER TABLE `announcements`
  ADD CONSTRAINT `announcements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

