USE `ucyr7474_univcokro`;

CREATE TABLE IF NOT EXISTS `catatan_pendaftaran` (
  `uuid` char(50) DEFAULT NULL,
  `name` text,
  `email` varchar(200) NOT NULL DEFAULT '',
  `notelp` varchar(200) DEFAULT NULL,
  `prodi` varchar(200) DEFAULT NULL,
  `pesan` text,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB;

INSERT INTO `catatan_pendaftaran` (`uuid`, `name`, `email`, `notelp`, `prodi`, `pesan`, `created_at`) VALUES
	('4f565795-a0c4-4a5f-ad95-3e96228d296e', 'Muhammad Ichsan', 'ichsanfadhil67@gmail.com', '081325184866', 'Pendidikan Matematika', 'Halo Ichsan', '2024-07-18 09:30:00');

CREATE TABLE IF NOT EXISTS `gambar` (
  `uuid` char(50) DEFAULT NULL,
  `image_id` char(50) DEFAULT NULL,
  `url` char(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `gambar` (`uuid`, `image_id`, `url`, `created_at`) VALUES
	('a155defa-1388-4d13-b749-dcd0d5ce62af', '66698c4737b244ef54a17059', 'https://ik.imagekit.io/uvma3bkbp/desaku/logo_header%20(2)_xXPbuDCGq.png', '2024-06-12 11:53:43'),
	('1da33526-ad7e-430f-ad71-44aed311c296', '66698ce737b244ef54a359c8', 'https://ik.imagekit.io/uvma3bkbp/desaku/fikri-rasyid-IBb_Y65z5ZU-unsplash%20(2)_FjElb7X0B.jpg', '2024-06-12 11:56:23'),
	('14067f9f-6b20-41d5-8588-2a8f3225e37b', '66698e6237b244ef54ad586f', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '2024-06-12 12:02:42'),
	('f4726aec-8018-441b-9b0d-8cd7d5b29ea8', '66698ecd37b244ef54b11be2', 'https://ik.imagekit.io/uvma3bkbp/desaku/ivan-hermawan-ju3cS0vqlhY-unsplash_o-ajAPFdC.jpg', '2024-06-12 12:04:29'),
	('7f0023da-3a4c-4029-9eea-153b6e4b4a2a', '66698f1837b244ef54b33572', 'https://ik.imagekit.io/uvma3bkbp/desaku/ds_d6onoSg2m.jpg', '2024-06-12 12:05:44'),
	('a61671e6-5aa6-4c83-b977-745138e055fe', '66698f3837b244ef54b41218', 'https://ik.imagekit.io/uvma3bkbp/desaku/fikri-rasyid-IBb_Y65z5ZU-unsplash%20(2)_Fu-Kr4Xer.jpg', '2024-06-12 12:06:16'),
	('de65d351-bc9d-4f80-8037-678f287542f2', '66698fd537b244ef54b96f2d', 'https://ik.imagekit.io/uvma3bkbp/desaku/tikus_fS58RoOxf.jpg', '2024-06-12 12:08:53'),
	('9e48f515-27b5-4685-9af2-9c5d9abbdd19', '6669908c37b244ef54c07baa', 'https://ik.imagekit.io/uvma3bkbp/desaku/ikn-proyek_q_j4uDa_q.jpg', '2024-06-12 12:11:56'),
	('17aa3592-9948-4f73-bfe5-0a65f51e5614', '666990ea37b244ef54c17cfc', 'https://ik.imagekit.io/uvma3bkbp/desaku/karangmiri_Oia7NfWtx.jpg', '2024-06-12 12:13:30'),
	('797b27b4-5f41-418b-8ab0-8cfff57cb131', '666991a837b244ef54c3a7f5', 'https://ik.imagekit.io/uvma3bkbp/desaku/6666f90a7969f-aksi-penolakan-tapera-yang-dilakukan-oleh-organisasi-mahasiswa-cipayung-plus-di-halaman-kantor-dprd-diy-senin-1062024_1265_711_7b1MFKMWB.jpg', '2024-06-12 12:16:40'),
	('2382f1c7-80b2-4c19-8533-76cfdaa53cce', '666991fa37b244ef54c47c2c', 'https://ik.imagekit.io/uvma3bkbp/desaku/bintekk-3730704934_otpwqLySP.webp', '2024-06-12 12:18:02'),
	('c35bf6a4-ce55-46ac-b389-78d0a7e8b456', '666992d937b244ef54c93852', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '2024-06-12 12:21:45'),
	('0913ebf3-f492-48c3-8bb0-6126e75045c7', '66987cb0e375273f6026cff4', 'https://ik.imagekit.io/uvma3bkbp/desaku/dummy-photo_KZqy2wW80.png', '2024-07-18 02:23:46'),
	('5b000d7c-b169-4b7d-bff3-ef2981425da6', '669a0ac3e375273f60b2875a', 'https://ik.imagekit.io/uvma3bkbp/desaku/dummy-photo_6b-JscRYq.png', '2024-07-19 06:42:13'),
	('ad40ecca-602f-4a3e-adc2-28721a1682b0', '66a7028be375273f6016f4ab', 'https://ik.imagekit.io/uvma3bkbp/desaku/Group%201_fIfXgweSv.png', '2024-07-29 02:46:36');

CREATE TABLE IF NOT EXISTS `informasi_kampus` (
  `uuid` char(50) DEFAULT NULL,
  `title` text,
  `slug` varchar(200) DEFAULT NULL,
  `description` text,
  `thumbnail` varchar(200) DEFAULT NULL,
  `content` text,
  `user_id` char(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `informasi_kampus` (`uuid`, `title`, `slug`, `description`, `thumbnail`, `content`, `user_id`, `created_at`, `updated_at`) VALUES
	('b05ea29e-25ac-4d2d-8c48-2b8f6b07f7ee', 'Jadwal Pemilihan Ulang Mitra Kerjasama Pemanfaatan (KSP) Mal', 'jadwal-pemilihan-ulang-mitra-kerjasama-pemanfaatan-ksp-mal', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p class="ql-align-justify">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus. Nullam in orci quis eros porttitor ultrices. In vel arcu a massa molestie tincidunt at posuere nisi. Nulla facilisi. Aenean ut semper diam. Maecenas sodales, massa in consectetur fermentum, felis ex lobortis nunc, sed molestie ligula metus eget massa. Aliquam hendrerit dolor sed sem pretium ultricies sit amet at nulla. Integer nec diam non leo sodales feugiat vitae a velit. Fusce ut orci ex.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Vestibulum viverra nulla vel consectetur egestas. Nulla sagittis magna ut ipsum vestibulum, eu rutrum odio aliquam. Pellentesque cursus vel risus a vehicula. Vestibulum lectus ipsum, fringilla dignissim ipsum non, cursus vestibulum nisl. Fusce eget hendrerit mi. Aliquam condimentum ac tortor non egestas. Nunc a magna nec diam mattis accumsan. Aliquam dolor tellus, euismod non porttitor eu, posuere id magna. Suspendisse sit amet blandit nulla. Ut metus nisl, ullamcorper quis venenatis at, interdum a arcu. Ut non eros elit. Aenean quis nibh at turpis tempor faucibus nec sit amet velit. Morbi volutpat vitae orci et rhoncus. Quisque sed vestibulum nulla, id cursus urna.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Fusce semper ornare porta. Fusce vehicula elit nisl, vitae varius nisi convallis tempus. Integer mollis purus et tellus laoreet congue. Maecenas a pretium est. Donec rhoncus mi eu nunc euismod, a dignissim nibh lacinia. Sed venenatis, risus sed vehicula posuere, ipsum turpis vestibulum tellus, eget convallis neque sem vel est. Integer lectus dolor, faucibus eu laoreet id, molestie id lorem. Mauris aliquet augue nec egestas condimentum. Nam nec nunc nec eros pharetra pulvinar. Quisque quam dui, auctor quis malesuada eget, tincidunt id elit. Ut mattis, urna non dignissim molestie, massa dui imperdiet libero, quis egestas orci orci vitae est.</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-06-12 12:26:19', '2024-06-12 12:26:19'),
	('b4ebc9d7-5fa9-4871-b9e0-5b4496a51d01', 'Pengidap Diabetes Masih Boleh Kok Makan Nasi', 'pengumuman-pengadaan-pegawai-pemerintah-dengan-perjanjian-kerja-pppk-tenaga-teknis-di-lingkungan1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p class="ql-align-justify">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus. Nullam in orci quis eros porttitor ultrices. In vel arcu a massa molestie tincidunt at posuere nisi. Nulla facilisi. Aenean ut semper diam. Maecenas sodales, massa in consectetur fermentum, felis ex lobortis nunc, sed molestie ligula metus eget massa. Aliquam hendrerit dolor sed sem pretium ultricies sit amet at nulla. Integer nec diam non leo sodales feugiat vitae a velit. Fusce ut orci ex.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Vestibulum viverra nulla vel consectetur egestas. Nulla sagittis magna ut ipsum vestibulum, eu rutrum odio aliquam. Pellentesque cursus vel risus a vehicula. Vestibulum lectus ipsum, fringilla dignissim ipsum non, cursus vestibulum nisl. Fusce eget hendrerit mi. Aliquam condimentum ac tortor non egestas. Nunc a magna nec diam mattis accumsan. Aliquam dolor tellus, euismod non porttitor eu, posuere id magna. Suspendisse sit amet blandit nulla. Ut metus nisl, ullamcorper quis venenatis at, interdum a arcu. Ut non eros elit. Aenean quis nibh at turpis tempor faucibus nec sit amet velit. Morbi volutpat vitae orci et rhoncus. Quisque sed vestibulum nulla, id cursus urna.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Fusce semper ornare porta. Fusce vehicula elit nisl, vitae varius nisi convallis tempus. Integer mollis purus et tellus laoreet congue. Maecenas a pretium est. Donec rhoncus mi eu nunc euismod, a dignissim nibh lacinia. Sed venenatis, risus sed vehicula posuere, ipsum turpis vestibulum tellus, eget convallis neque sem vel est. Integer lectus dolor, faucibus eu laoreet id, molestie id lorem. Mauris aliquet augue nec egestas condimentum. Nam nec nunc nec eros pharetra pulvinar. Quisque quam dui, auctor quis malesuada eget, tincidunt id elit. Ut mattis, urna non dignissim molestie, massa dui imperdiet libero, quis egestas orci orci vitae est.</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-06-12 12:27:16', '2024-06-12 12:27:16'),
	('650c9598-7835-4ca0-9416-8d3266a0d2ed', 'Penemuan Fosil Tritylodont Jurassic yang Mengejutkan di Danau Powell', 'pengumuman-pengadaan-pegawai-pemerintah2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p>Halo hai</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 11:55:14', '2024-07-18 03:13:52'),
	('b12bbc3e-0d75-48b7-bb49-637e8eb477a1', 'Turbulensi Pesawat Ekstrem Sebenarnya Jarang Terjadi', 'pengumuman-pengadaan-pegawai-pemerintah-dengan-perjanjian3', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-18 03:13:31'),
	('4debfcf9-84fe-4d71-b2ee-67b8ef30d83a', 'Vaksinasi Bisa Kurangi Risiko DBD yang Parah', 'universitas-cokroaminoto-yogyakarta-atau-disingkat-4', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p>Halo hai  Haja</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:10:01', '2024-07-18 03:12:44'),
	('7b089237-ff2b-4763-93d0-6fb8bf390814', 'Will Our Cars Fly In The Near Future?', 'will-our-cars-fly-in-the-near-future', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>halo</p>', '9650aeb3-c956-48ae-9556-88d7b30a44f6', '2024-07-26 02:33:12', '2024-07-29 01:58:20'),
	('1f90caa3-6e85-4912-986b-d722929e1f88', 'Word Of The Day: Gutted', 'word-of-the-day-gutted', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '<p>n a historic move to combat climate change and address the growing global energy crisis, an international consortium of renewable energy companies has launched the largest solar power project ever undertaken in the Sahara De</p><p><br></p><p>n a historic move to combat climate change and address the growing global energy crisis, an international consortium of renewable energy companies has launched the largest solar power project ever undertaken in the Sahara De</p><p><br></p><p><em>asasasas</em></p><p><em><u>asasasas</u></em></p><p><strong><em>asasasasas</em></strong></p><p><br></p><p class="ql-align-center"><strong><em><span class="ql-cursor"></span></em></strong><img src="https://ik.imagekit.io/uvma3bkbp/desaku/Group%201_fIfXgweSv.png"></p>', 'd71ccbda-e9eb-496d-83f4-d9b891de3392', '2024-07-26 02:34:19', '2024-07-29 02:47:06');

CREATE TABLE IF NOT EXISTS `informasi_mahasiswa` (
  `uuid` char(50) DEFAULT NULL,
  `title` text,
  `slug` varchar(200) DEFAULT NULL,
  `description` text,
  `thumbnail` varchar(200) DEFAULT NULL,
  `content` text,
  `user_id` char(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB;

INSERT INTO `informasi_mahasiswa` (`uuid`, `title`, `slug`, `description`, `thumbnail`, `content`, `user_id`, `created_at`, `updated_at`) VALUES
	('b4ebc9d7-5fa9-4871-b9e0-5b4496a51d01', 'When will a robot be able to do my laundry?', 'pengumuman-pengadaan-pegawai-pemerintah-dengan-perjanjian-kerja-pppk-tenaga-teknis-di-lingkungan-pemerintah', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p class="ql-align-justify">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus. Nullam in orci quis eros porttitor ultrices. In vel arcu a massa molestie tincidunt at posuere nisi. Nulla facilisi. Aenean ut semper diam. Maecenas sodales, massa in consectetur fermentum, felis ex lobortis nunc, sed molestie ligula metus eget massa. Aliquam hendrerit dolor sed sem pretium ultricies sit amet at nulla. Integer nec diam non leo sodales feugiat vitae a velit. Fusce ut orci ex.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Vestibulum viverra nulla vel consectetur egestas. Nulla sagittis magna ut ipsum vestibulum, eu rutrum odio aliquam. Pellentesque cursus vel risus a vehicula. Vestibulum lectus ipsum, fringilla dignissim ipsum non, cursus vestibulum nisl. Fusce eget hendrerit mi. Aliquam condimentum ac tortor non egestas. Nunc a magna nec diam mattis accumsan. Aliquam dolor tellus, euismod non porttitor eu, posuere id magna. Suspendisse sit amet blandit nulla. Ut metus nisl, ullamcorper quis venenatis at, interdum a arcu. Ut non eros elit. Aenean quis nibh at turpis tempor faucibus nec sit amet velit. Morbi volutpat vitae orci et rhoncus. Quisque sed vestibulum nulla, id cursus urna.</p><p class="ql-align-justify"><br></p><p class="ql-align-justify">Fusce semper ornare porta. Fusce vehicula elit nisl, vitae varius nisi convallis tempus. Integer mollis purus et tellus laoreet congue. Maecenas a pretium est. Donec rhoncus mi eu nunc euismod, a dignissim nibh lacinia. Sed venenatis, risus sed vehicula posuere, ipsum turpis vestibulum tellus, eget convallis neque sem vel est. Integer lectus dolor, faucibus eu laoreet id, molestie id lorem. Mauris aliquet augue nec egestas condimentum. Nam nec nunc nec eros pharetra pulvinar. Quisque quam dui, auctor quis malesuada eget, tincidunt id elit. Ut mattis, urna non dignissim molestie, massa dui imperdiet libero, quis egestas orci orci vitae est.</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-06-12 12:27:16', '2024-06-12 12:27:16'),
	('650c9598-7835-4ca0-9416-8d3266a0d2ed', 'Venezuelans vote in election challenging Maduro\'s grip on power', 'halo-bang-haji', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Halo hai</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 11:55:14', '2024-07-16 11:55:14'),
	('b12bbc3e-0d75-48b7-bb49-637e8eb477a1', 'Putin vows ‘mirror measures’ if US puts missiles in Germany in 2026', 'hola', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('4debfcf9-84fe-4d71-b2ee-87b8kj30d83a', 'From Believers to Bitcoin: 24 Hours in Trump’s Code-Switching', 'halo-bang-haji-jaka', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Halo hai jaokaoksoas</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:10:01', '2024-07-16 12:12:47'),
	('4debfcf9-84fe-4d71-b2ee-87b8lj30d83a', 'Ryan Reynolds on Stunning ‘Deadpool & Wolverine’', 'halo-bang-haji-jaka2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Halo hai jaokaoksoas</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:10:01', '2024-07-16 12:12:47'),
	('7a33e56b-72e2-4236-a34e-22d622899e0a', 'Blood test has a 90 percent accuracy rate in determining whether', 'halo-bang-haji1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Apapun itu kapanpun</p>', '9650aeb3-c956-48ae-9556-88d7b30a44f6', '2024-07-18 02:47:05', '2024-07-18 02:47:05'),
	('70db0949-90c6-426b-8670-ab4aea3e68d4', 'National Hurricane Center tracking tropical', 'haloi', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '<p>Apapun itu kapanpun</p>', '9650aeb3-c956-48ae-9556-88d7b30a44f6', '2024-07-18 02:47:05', '2024-07-18 02:47:05');

CREATE TABLE IF NOT EXISTS `jurnal` (
  `uuid` char(50) DEFAULT NULL,
  `title` text,
  `description` text,
  `url` varchar(200) DEFAULT NULL,
  `user_id` char(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `jurnal` (`uuid`, `title`, `description`, `url`, `user_id`, `created_at`, `updated_at`) VALUES
	('b05ea29e-25ac-4d2d-8c48-2b8f6b07f7ee', 'Role of Artificial Intelligence in Modern Healthcare', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-06-12 12:26:19', '2024-07-29 02:41:04'),
	('b4ebc9d7-5fa9-4871-b9e0-5b4496a51d01', 'Socioeconomic Impacts of Climate Change: A Global Perspective\n', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-06-12 12:27:16', '2024-06-12 12:27:16'),
	('650c9598-7835-4ca0-9416-8d3266a0d2ed', 'Exploring the Ethical Implications of Genetic Engineering\n', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 11:55:14', '2024-07-18 03:13:52'),
	('b12bbc3e-0d75-48b7-bb49-637e8eb477a1', 'Innovations in Urban Planning for Sustainable Cities\n', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-18 03:13:31'),
	('4debfcf9-84fe-4d71-b2ee-67b8ef30d83a', 'The Future of Work: Automation and Human Labor\n', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:10:01', '2024-07-18 03:12:44'),
	('7b089237-ff2b-4763-93d0-6fb8bf390814', 'Cybersecurity Strategies in the Age of Digital Transformation\n', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/Most_Outstanding_Women_20241JPG-2448972759_ZtskFWXLd.webp', '9650aeb3-c956-48ae-9556-88d7b30a44f6', '2024-07-26 02:33:12', '2024-07-29 01:58:20'),
	('1f90caa3-6e85-4912-986b-d722929e1f88', 'Psychological Effects of Social Media on Adolescents', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', 'https://ik.imagekit.io/uvma3bkbp/desaku/helene-nguyen-UG87YRaLpL8-unsplash_D3XvnJtbl.jpg', 'd71ccbda-e9eb-496d-83f4-d9b891de3392', '2024-07-26 02:34:19', '2024-07-29 02:34:15');

CREATE TABLE IF NOT EXISTS `pengumuman` (
  `uuid` char(50) DEFAULT NULL,
  `title` text,
  `slug` varchar(200) DEFAULT NULL,
  `description` text,
  `content` text,
  `user_id` char(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `pengumuman` (`uuid`, `title`, `slug`, `description`, `content`, `user_id`, `created_at`, `updated_at`) VALUES
	('b12bbc3e-0d75-48b7-bb49-637e8eb477a1', 'Breaking Barriers: Innovations Shaping the Future\n', 'hola9', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('4debfcf9-84fe-4d71-b2ee-67b8ef30d83a', 'Global Economies on the Brink: A Deep Dive into Market Trends\n', 'universitas-cokroaminoto-yogyakarta-atau-disingkat-ucy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo hai jaokaoksoas</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:10:01', '2024-07-18 03:12:19'),
	('b12bbc3e-0d75-48b7-bb49-637e8eu477a1', 'Tech Giants Clash: The Battle for Digital Dominance\n', 'hola5', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('b12bbc3e-0d75-48b7-bb49-637e8eu478a1', 'Climate Crisis: Urgent Actions and Global Responses\n', 'hola4', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('b12bbc3e-0d75-48b7-bb49-637e8eu978a1', 'Healthcare Revolution: New Advances and Challenges\n', 'hola2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('b12bbc3e-0d75-48b7-bb49-637e8eu678a1', 'Cultural Renaissance: The Rebirth of Arts in the Digital Age\n', 'hola1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('b12bbc3e-0d75-48u7-bb49-637e8eu678a1', 'Political Shifts: Analyzing the Impact of Recent Elections\n', 'ada-ular', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04'),
	('b12bbc3e-0d75-48u7-bb49-639e8eu678a1', 'Cybersecurity Threats: How Safe is Your Data?\n', 'holal', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel tortor lorem. Morbi venenatis porta nisi, porttitor elementum sem placerat quis. Nunc tincidunt quis ligula ornare pellentesque. Quisque neque felis, consequat sit amet dignissim pellentesque, tincidunt quis purus.', '<p>Halo bang</p>', '376738e4-d859-42a5-b50c-728fab99dd49', '2024-07-16 12:01:04', '2024-07-16 12:01:04');

CREATE TABLE IF NOT EXISTS `reset_password` (
  `uuid` char(50) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `token` char(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `expired_at` datetime DEFAULT NULL
) ENGINE=InnoDB;


CREATE TABLE IF NOT EXISTS `setting` (
  `uuid` char(50) DEFAULT NULL,
  `banner` tinytext
) ENGINE=InnoDB;

INSERT INTO `setting` (`uuid`, `banner`) VALUES
	('1', '1');

CREATE TABLE IF NOT EXISTS `tracer_study` (
  `uuid` char(50) DEFAULT NULL,
  `nik` char(50) DEFAULT NULL,
  `npwp` char(50) DEFAULT NULL,
  `name` text,
  `email` varchar(200) NOT NULL DEFAULT '',
  `graduate` varchar(200) DEFAULT NULL,
  `prodi` varchar(200) DEFAULT NULL,
  `nim` varchar(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

INSERT INTO `tracer_study` (`uuid`, `nik`, `npwp`, `name`, `email`, `graduate`, `prodi`, `nim`, `created_at`) VALUES
	('48c0fde1-05ef-4933-89a3-9ba8c2529950', '871271', '7632732', 'asas', 'ichsan@gma.com', '2012', 'manajem', '8717212', '2024-07-16 02:24:14');

CREATE TABLE IF NOT EXISTS `user` (
  `uuid` char(50) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `name` char(50) DEFAULT NULL,
  `password` char(50) DEFAULT NULL,
  `is_admin` tinyint DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB;

INSERT INTO `user` (`uuid`, `email`, `name`, `password`, `is_admin`, `created_at`) VALUES
	('376738e4-d859-42a5-b50c-728fab99dd49', 'admin@cokroaminoto.com', 'Admin Cokroaminoto', '123', 1, '2024-05-31 13:19:43'),
	('d71ccbda-e9eb-496d-83f4-d9b891de3392', 'fai@ucy.ac.id', 'Admin Fakultas Agama Islam', '123', 0, '2024-05-31 13:19:46'),
	('78e3feaa-4b7e-467f-8131-381f49d1ffd6', 'fkip@ucy.ac.id', 'Admin Fakultas Keguruan Ilmu Pendidikan', '123', 0, '2024-05-31 13:19:46'),
	('9650aeb3-c956-48ae-9556-88d7b30a44f6', 'fh@ucy.ac.id', 'Admin Fakultas Hukum', '123', 0, '2024-05-31 13:19:46'),
	('054a9a78-4251-4195-a746-78dfbc37b6c0', 'ft@ucy.ac.id', 'Admin Fakultas Teknik', '123', 0, '2024-05-31 13:19:46'),
	('d632f3d2-46cd-4c54-b7a1-e58dbe181dd7', 'fe@ucy.ac.id', 'Admin Fakultas Ekonomi', '123', 0, '2024-05-31 13:19:46');