sasasa
dfdfdf
rtrtrt
sdssdsdsd
', 'file-informasi/PDF.pdf', 1, '2025-02-03 00:16:52', '2025-02-03 00:16:52'); -- -------------------------------------------------------- -- -- Table structure for table `lowongans` -- CREATE TABLE `lowongans` ( `id` bigint(20) UNSIGNED NOT NULL, `gambar` varchar(255) NOT NULL, `judul` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `perusahaan` varchar(255) NOT NULL, `posisi` varchar(255) NOT NULL, `persyaratan` text NOT NULL, `batas_waktu` datetime NOT 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 for table `lowongans` -- INSERT INTO `lowongans` (`id`, `gambar`, `judul`, `slug`, `perusahaan`, `posisi`, `persyaratan`, `batas_waktu`, `user_id`, `created_at`, `updated_at`) VALUES (1, 'gambar-lowongan/WhatsApp-Image-2024-01-04-at-07.55.40-1536x1536.jpeg', 'LPK Alfabank Yogyakarta', 'lpk-alfabank-yogyakarta', 'LPK Alfabank Yogyakarta', 'Teknik Komputer', 'Info lowongan pekerjaan diatas tidak kolektif sekolah, silahkan yang berminat untuk alumni program keahlian TKJ bisa mengikuti. Prosedur pendaftaran di pusat informasi yg tertera di leaflet. Silahkan secepatnya manfaatkan kesempatan ini. SMK BISA-HEBAT!!!
', '2025-02-14 12:00:00', 1, '2025-02-03 00:16:08', '2025-02-04 00:28:59'), (2, 'gambar-lowongan/lowongan-pekerjaan-Kota-Kendari-CV-Maseba-Teknik-Perkasa.jpg', 'Lowongan Kerja Kendari CV Maseba Teknik Perkasa Buka Loker Admin Marketing dan Helper, Kualifikasi', 'lowongan-kerja-kendari-cv-maseba-teknik-perkasa-buka-loker-admin-marketing-dan-helper-kualifikasi', 'CV Maseba Teknik Perkasa', 'Admin Marketing', '1. Wanita
2. Pendidikan minimal S1 semua jurusan
3. Usia maksimal 35 tahun
4. Memiliki kemampuan dalam mengoperasikan Microsoft Office
5. Mampu bekerja dalam tim
6. Jujur, amanah, dan disiplin
Halo #sahabatmedicelle, saat ini kami sedang membuka lowongan pekerjaan untuk perawat dengan kualifikasi :
Segera daftarkan diri dan upload CV Anda melalui email seleksi.medika@gmail.com atau WhatsApp ke 0812-3322-5545
Woman Health Care Clinic
MedicElle Clinic
Jl. Raya Gubeng No. 11 Surabaya
031 30008008 / 08990118008
HATI-HATI TERHADAP PENIPUAN LOWONGAN PEKERJAAN ONLINE!
Salah satu indikasi PENIPUAN adalah jika pelamar diminta untuk melakukan TRANSFER via ATM atau dimintai uang dengan cara lain.
LANGSUNG DAFTAR DAN HUBUNGI SEGERA
', '2025-02-06 12:00:00', 1, '2025-02-04 00:31:28', '2025-02-04 00:31:28'), (5, 'gambar-lowongan/loker_digital_marketing_(2)1.jpg', 'Lowongan Kerja: Digital Marketing di PT. Berkah Energi Safety', 'lowongan-kerja-digital-marketing-di-pt-berkah-energi-safety', 'PT. Berkah Energi Safety', 'Digital Marketing', 'Lowongan Kerja: Digital Marketing di PT. Berkah Energi Safety
PT. Berkah Energi Safety membuka kesempatan bagi Anda yang bersemangat dan berpengalaman untuk bergabung sebagai Digital Marketing. Kami mencari individu yang kreatif, komunikatif, dan mampu bekerja dalam tim untuk mengelola media sosial dan website perusahaan.
Kualifikasi:
Fasilitas yang Ditawarkan:
Segera kirimkan lamaran dan CV Anda ke hrd.besty@gmail.com
Batas pengiriman: 14 November 2024
Jangan lewatkan kesempatan ini untuk bergabung dan tumbuh bersama tim kami!
', '2025-02-11 12:00:00', 1, '2025-02-04 00:33:51', '2025-02-04 00:33:51'); -- -------------------------------------------------------- -- -- Table structure for table `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 for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_100000_create_password_resets_table', 1), (2, '2019_08_19_000000_create_failed_jobs_table', 1), (3, '2019_12_14_000001_create_personal_access_tokens_table', 1), (4, '2023_03_03_232951_create_lowongans_table', 1), (5, '2023_03_03_233252_create_pendaftars_table', 1), (6, '2023_03_03_233535_create_users_table', 1), (7, '2023_03_06_232317_create_informasis_table', 1), (8, '2023_06_02_122334_create_roles_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pendaftars` -- CREATE TABLE `pendaftars` ( `id` bigint(20) UNSIGNED NOT NULL, `kode_pendaftaran` varchar(255) NOT NULL, `nama` varchar(255) NOT NULL, `jurusan` varchar(255) NOT NULL, `asal_sekolah` varchar(255) NOT NULL, `jenis_kelamin` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `lowongan_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 for table `pendaftars` -- INSERT INTO `pendaftars` (`id`, `kode_pendaftaran`, `nama`, `jurusan`, `asal_sekolah`, `jenis_kelamin`, `user_id`, `lowongan_id`, `created_at`, `updated_at`) VALUES (1, '0F1H7', 'kasep', 'SMA', 'SMA 1 Konoha', 'laki-laki', 3, 1, '2025-02-03 00:44:14', '2025-02-03 00:44:14'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `role` varchar(255) 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 for table `roles` -- INSERT INTO `roles` (`id`, `role`, `created_at`, `updated_at`) VALUES (1, 'admin', '2025-02-03 00:11:20', '2025-02-03 00:11:20'), (2, 'pendaftar', '2025-02-03 00:11:20', '2025-02-03 00:11:20'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `foto` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `foto`, `name`, `email`, `password`, `role_id`, `remember_token`, `email_verified_at`, `created_at`, `updated_at`) VALUES (1, 'foto/Foto 2.png', 'admin', 'admin@gmail.com', '$2y$10$7dN5zrYhA2OdWUHZHINWj.oi.2xMRYp7bCZyJaTzq1cb2xu47/H9q', 1, NULL, NULL, '2025-02-03 00:11:20', '2025-02-03 00:17:24'), (2, NULL, 'Mujiyono', 'mujiyono@gmail.com', '$2y$10$sS3o4T50bsqVp5M4Od0DzuJ1LD8A/Ypskt2bwDo9csWN9COvjHKh2', 2, NULL, NULL, '2025-02-03 00:11:20', '2025-02-03 00:11:20'), (3, 'foto/Foto 2.png', 'kasep', 'kasepcode@gmail.com', '$2y$10$M1rQFzkGJTObAaGVFqrA4OxOg0k0iT.muAE1QfgNr1Q9WIBALYhWG', 2, NULL, NULL, '2025-02-03 00:43:32', '2025-02-03 00:44:54'); -- -- Indexes for dumped tables -- -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `informasis` -- ALTER TABLE `informasis` ADD PRIMARY KEY (`id`); -- -- Indexes for table `lowongans` -- ALTER TABLE `lowongans` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `lowongans_slug_unique` (`slug`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `pendaftars` -- ALTER TABLE `pendaftars` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `informasis` -- ALTER TABLE `informasis` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `lowongans` -- ALTER TABLE `lowongans` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `pendaftars` -- ALTER TABLE `pendaftars` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;