-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 11, 2026 at 09:37 AM -- Server version: 10.11.16-MariaDB-ubu2404 -- PHP Version: 8.4.19 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `edunesiaserver_ISTA-ALKAMAL` -- -- -------------------------------------------------------- -- -- Table structure for table `beranda` -- CREATE TABLE `beranda` ( `beranda_id` int(11) NOT NULL, `page_id` int(11) NOT NULL, `urut` int(11) NOT NULL, `tipe` varchar(15) NOT NULL, `active` enum('1','0') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `beranda` -- INSERT INTO `beranda` (`beranda_id`, `page_id`, `urut`, `tipe`, `active`) VALUES (3, 16, 1, 'slide', '1'), (4, 15, 1, 'posisi1', '1'), (8, 27, 2, 'posisi2', '1'), (9, 28, 3, 'posisi2', '1'); -- -------------------------------------------------------- -- -- Table structure for table `berita` -- CREATE TABLE `berita` ( `id_berita` int(11) NOT NULL, `judul` varchar(200) NOT NULL, `slug` varchar(200) NOT NULL, `ringkasan` varchar(200) NOT NULL, `content` longtext NOT NULL, `tanggal_berita` date NOT NULL, `file_foto` varchar(200) NOT NULL, `path` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `berita` -- INSERT INTO `berita` (`id_berita`, `judul`, `slug`, `ringkasan`, `content`, `tanggal_berita`, `file_foto`, `path`) VALUES (13, 'tstt', 'tstt', 'tsttt', '

tdt

', '2026-04-10', 'V2LAprXvU0Doo2Yo9ac3w8couyOt3ty1HisEIFnx.webp', ''); -- -------------------------------------------------------- -- -- Table structure for table `biaya` -- CREATE TABLE `biaya` ( `biaya_id` int(11) NOT NULL, `kategori` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jurusan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `biaya_awal` int(11) NOT NULL, `biaya_spp` int(11) NOT NULL, `deskripsi` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `biaya` -- INSERT INTO `biaya` (`biaya_id`, `kategori`, `jurusan`, `biaya_awal`, `biaya_spp`, `deskripsi`) VALUES (152, 'Reguler Pagi', 'S1 Teknik Industri', 850000, 500000, '

Biaya Formulir Rp 200.000

\r\n\r\n

Biaya Awal *Sesuai Tabel ( Angs 1 UKT + Jas Almamater + PKKMB)

\r\n\r\n

Biaya Kuliah Dapat Diangsur Flat Sampai Lulus

'), (153, 'Reguler Pagi', 'S1 Teknik Mesin', 850000, 500000, NULL), (154, 'Reguler Pagi', 'S1 Teknik Sipil', 850000, 500000, NULL), (155, 'Reguler Pagi', 'S1 Teknik Informatika', 850000, 500000, NULL), (156, 'Reguler Pagi', 'S1 Sistem Informasi', 850000, 500000, NULL), (157, 'Reguler Pagi', 'S1 Design Komunikasi Visual', 850000, 500000, NULL), (158, 'Reguler Pagi', 'S1 Teknik Kimia', 850000, 740000, NULL), (159, 'Reguler Pagi', 'S1 Farmasi', 1300000, 890000, NULL), (160, 'Reguler Plus', 'S1 Teknik Industri', 850000, 620000, '

Biaya Formulir Rp 200.000

\r\n\r\n

Biaya Awal *Sesuai Tabel ( Angs 1 UKT + Jas Almamater + PKKMB)

\r\n\r\n

Biaya Kuliah Dapat Diangsur Flat Sampai Lulus

'), (161, 'Reguler Plus', 'S1 Teknik Mesin', 850000, 620000, NULL), (162, 'Reguler Plus', 'S1 Teknik Sipil', 850000, 620000, NULL), (163, 'Reguler Plus', 'S1 Teknik Informatika', 850000, 620000, NULL), (164, 'Reguler Plus', 'S1 Sistem Informasi', 850000, 620000, NULL), (165, 'Reguler Plus', 'S1 Design Komunikasi Visual', 850000, 620000, NULL), (166, 'Reguler Plus', 'S1 Teknik Kimia', 850000, 800000, NULL), (167, 'Reguler Plus', 'S1 Farmasi', 1300000, 1250000, NULL); -- -------------------------------------------------------- -- -- Table structure for table `brosur` -- CREATE TABLE `brosur` ( `brosur_id` int(11) NOT NULL, `kategori` varchar(200) NOT NULL, `file` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `daftar` -- CREATE TABLE `daftar` ( `daftar_id` int(11) NOT NULL, `kelas` varchar(30) NOT NULL, `nama_leng` varchar(150) DEFAULT NULL, `kampus` varchar(100) NOT NULL, `al_ktp` varchar(250) DEFAULT NULL, `al_dom` varchar(250) DEFAULT NULL, `j_kel` varchar(1) DEFAULT NULL, `tmpt_lahir` varchar(100) DEFAULT NULL, `tgl_lahir` date DEFAULT NULL, `no_ktp` varchar(50) DEFAULT NULL, `jurusan` varchar(255) DEFAULT NULL, `no_hp` varchar(20) DEFAULT NULL, `no_wa` varchar(20) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `agama` varchar(30) DEFAULT NULL, `ibu` varchar(50) DEFAULT NULL, `ayah` varchar(50) DEFAULT NULL, `jaket` char(5) DEFAULT NULL, `lulusan` varchar(60) DEFAULT NULL, `sekolah` varchar(100) NOT NULL, `biaya` varchar(15) DEFAULT NULL, `info` varchar(50) DEFAULT NULL, `pekerjaan` varchar(255) DEFAULT NULL, `jabatan` varchar(100) DEFAULT NULL, `al_kerja` varchar(250) DEFAULT NULL, `no_kantor` varchar(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT (current_timestamp() + interval 7 hour) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `daftar` -- INSERT INTO `daftar` (`daftar_id`, `kelas`, `nama_leng`, `kampus`, `al_ktp`, `al_dom`, `j_kel`, `tmpt_lahir`, `tgl_lahir`, `no_ktp`, `jurusan`, `no_hp`, `no_wa`, `email`, `agama`, `ibu`, `ayah`, `jaket`, `lulusan`, `sekolah`, `biaya`, `info`, `pekerjaan`, `jabatan`, `al_kerja`, `no_kantor`, `created_at`) VALUES (250002, 'Reguler Plus', 'testerakbarsyawal', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'dasdasdasdas', 'tes', 'L', 'BEKASI', '2025-12-30', '1234567890123457', 'S1 Farmasi', '081412106812', '081412106812', 'ads.kuliahkaryawan.id@gmail.com', 'Islam', 'a', 'b', 'XL', 'SMA/MA/SMK/Sederajat', 'c', 'Bulanan', 'Brosur', NULL, NULL, NULL, NULL, '2025-12-30 06:54:00'), (260002, 'Reguler Plus', 'tes', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'sdfsdfsd', 'adadasd', 'L', 'tes', '2026-01-20', '1234567890123458', 'S1 Teknik Industri', '321321312312', '085717731737', 'ads.kuliahkaryawan.id@gmail.com', 'Islam', 'a', 'b', 'XL', 'SMA/MA/SMK/Sederajat', 'c', 'Bulanan', 'Google', NULL, NULL, NULL, NULL, '2026-01-09 13:52:34'), (260003, 'Reguler Plus', 'Audy Chynthya Andriana', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Villa Tangerang Indah Blok Ac 3 No.16', 'Villa Tangerang Indah Blok Ac 3 No.16', 'P', 'Pacitan', '2003-09-14', '3671085409030004', 'S1 Farmasi', '081297435651', '081398665584', 'audyach8@gmail.com', 'Islam', 'Suratin', 'Alm. Salmon Andrian', 'XL', 'SMA/MA/SMK/Sederajat', 'SMKN 9 Tangerang', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-01-10 15:53:16'), (260004, 'Reguler Plus', 'tes', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'sdfsdfsd', 'adadasd', 'L', 'tes', '2026-01-10', '1234123412341234', 'S1 Teknik Informatika', '085717731737', '085717731737', 'ads.kuliahkaryawan.id@gmail.com', 'Islam', 'a', 'b', 'L', 'SMA/MA/SMK/Sederajat', 'c', 'Bulanan', 'Google', NULL, NULL, NULL, NULL, '2026-01-10 17:33:36'), (260005, 'Reguler Plus', 'Rahma nazila', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Kp. Sangiang rt 01/01 kel. Periuk jaya kec. Periuk', 'Kota tangerang', 'P', 'Tangerang', '2003-05-29', '3671086905030001', 'S1 Farmasi', '089653519577', '089684855129', 'rahmanazila139@gmail.com', 'Islam', 'Eni daryanti', 'Saprudin', 'M', 'SMA/MA/SMK/Sederajat', 'Smkn 9 kota tangerang', 'Bulanan', 'Teman/Keluarga', 'Total logam jaya', NULL, 'Jl. Daan mogot km 21', NULL, '2026-01-12 21:28:21'), (260006, 'Reguler Plus', 'Intan shabina maharani', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Poris gaga baru', 'Poris gaga baru', 'P', 'Tangerang', '2003-04-25', '3671036504030002', 'S1 Farmasi', '081298918979', '089524674853', 'intanshabinamaharani123@gmail.com', 'Islam', 'Dewi satriani', 'Rohman', 'M', 'SMA/MA/SMK/Sederajat', 'SMK NEGRI 9 TANGERANG', 'Bulanan', 'Teman/Keluarga', 'PT. bright mobile telecommunication', NULL, 'Jalan Kawasan Industri Jl. Raya Bayur, Periuk Jaya, Kec. Periuk, Kota Tangerang, Banten 15131', NULL, '2026-01-16 13:10:07'), (260007, 'Reguler Plus', 'Raihand putra alkafi', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jln pondok pakulonan block n3 no18', 'Jln pondok pakulonan block n3 no18', 'L', 'Jakarta', '1999-12-18', '3674021812990002', 'S1 Teknik Industri', '08817568332', '08817568332', 'rehanputra1807@gmail.com', 'Islam', 'Elvi dona', 'Saiful karim', 'M', 'SMA/MA/SMK/Sederajat', 'Smkn 2 tangerang selatan', 'Bulanan', 'Teman/Keluarga', 'Hang tuah', NULL, 'Pecenongan', NULL, '2026-02-07 18:42:12'), (260008, 'Reguler Plus', 'Muhammad Arya alfaris', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jalan.Kp.Rawa Lumpang , Desa. Salembaran Jati , Kec.Kosambi ,Kab.Tangerang, Banten', 'Jalan.Kp.Rawa Lumpang , Desa. Salembaran Jati , Kec.Kosambi ,Kab.Tangerang, Banten', 'L', 'Tangerang', '2004-02-25', '3603142502040003', 'S1 Teknik Sipil', '081385185851', '083894414881', 'alfarisarya355@gmail.com', 'Islam', 'Dahlia', 'Muhaji', 'XL', 'SMA/MA/SMK/Sederajat', 'SMAN 5', 'Bulanan', 'Teman/Keluarga', NULL, NULL, NULL, NULL, '2026-02-09 13:12:19'), (260009, 'Reguler Plus', 'Dewi Sriyanti Eko', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Oemofa', 'Oemofa', 'P', 'Oemofa', '2006-01-26', '5303136601060001', 'S1 Farmasi', '081342006408', '082138890983', 'dewisriyantieko@gmail.com', 'Katolik', 'Modesta Abi', 'Karlus Eko', 'M', 'SMA/MA/SMK/Sederajat', 'SMK St Agustinus Kefamenanu', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-02-10 15:41:30'), (260010, 'Reguler Plus', 'Muhamad Nur Ichsan', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl.blok kelapa,no 26,Buaran indah,Tangerang, Kota Tangerang', 'Jl.PrabuSiliwangi No.6,sangiang Jaya,priuk,Tangerang', 'L', 'Ciamis', '1997-05-12', '3671011205970003', 'S1 Farmasi', '088211076785', '088211076785', 'muhamadnurichsan222@gmail.com', 'Islam', 'Nur Khotimah', 'Saim wahyudi', 'XL', 'SMA/MA/SMK/Sederajat', 'Institut kesehatan Indonesia', 'Semesteran', 'Instagram', 'Rs Bunda Sejati', NULL, 'Jl.PrabuSiliwangiNo.11, jatiuwung,Tangerang', NULL, '2026-02-13 21:05:19'), (260011, 'Reguler Plus', 'Ahmad iqbal', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl. Palmerah Barat 1', 'Jl. Palmerah Barat 1', 'L', 'Pemalang', '1996-09-20', '3327012009960004', 'S1 Teknik Informatika', '0882003120754', '083861718300', 'ahmadiqbal01220@gmail.com', 'Islam', 'Mashanah', 'Muhtamim', 'L', 'SMA/MA/SMK/Sederajat', 'SMK Al Falah', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-02-16 15:51:06'), (260012, 'Reguler Plus', 'MUTIARA NUR RAFIFAH', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'JL. KAMPUNG BARU 2', 'RT 001/ RW 002, ULUJAMI, PESANGGRAHAN', 'P', 'JAKARTA', '2007-07-25', '3174106507070003', 'S1 Farmasi', '085772120098', '087874103114', 'mutiaranurrafifah25@gmail.com', 'Islam', 'Hartini', 'Suherman', 'M', 'SMA/MA/SMK/Sederajat', 'SMA KARTIKA X-1', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-02-24 15:25:00'), (260013, 'Reguler Plus', 'Revansyah putra jamil', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl Pemancingan, Srengseng, Kembangan Jakarta Barat', 'Perum. Taman Adiyasa, Cikuya, Solear, kab. Tangerang', 'L', 'Jakarta', '2001-10-16', '3173081610010008', 'S1 Teknik Sipil', '00000000000', '08994554725', 'rputrajamil@gmail.com', 'Islam', 'Niken Wulandari', 'Awaludin Jamil', 'XXL', 'SMA/MA/SMK/Sederajat', 'SMK Tri Arga 2 Jakarta', 'Bulanan', 'Instagram', 'Pt Dana Purna Investama', NULL, 'Jl. Tanah Abang 1 No.27a, Jakarta Pusat 10160', NULL, '2026-02-27 15:51:58'), (260014, 'Reguler Plus', 'Heriyanti', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Kp. Cerewet RT 007/016 Duren Jaya Bekasi', 'Alamanda Regency Bekasi', 'P', 'Jakarta', '1985-10-21', '1305026110850001', 'S1 Farmasi', '089506843406', '089506843406', 'heriyantiheriyanti48@gmail.com', 'Islam', 'Nuripah', 'Heri Koto', 'XL', 'SMA/MA/SMK/Sederajat', 'SMK Analis Kimia Prgram 4Tahun', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-02-28 13:35:05'), (260015, 'Reguler Plus', 'enyfauziah', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'tanggerang', 'taman raya rajeg', 'P', 'tanggerang', '2008-03-06', '3603114603080003', 'S1 Farmasi', '0895405859710', '085715330925', 'enyfauziah4@gmail.com', 'Islam', 'erny', 'edy', 'M', 'SMA/MA/SMK/Sederajat', 'smas daarul muttaqien 2', 'Semesteran', 'Google', NULL, NULL, NULL, NULL, '2026-03-05 09:27:37'), (260016, 'Reguler Plus', 'Aditya Sofari', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Graha Pesona', 'Koja Jakarta Utara', 'L', 'Cilacap', '1999-04-06', '3603190406990003', 'S1 Design Komunikasi Visual', '098630688395', '0895414730909', 'sofaree4@gmail.com', 'Islam', 'Suyatni', 'Tasman', 'L', 'D3/Sederajat', 'STPI Curug', 'Bulanan', 'Facebook', 'PT Tunas Laser Metalindo', NULL, 'Jl Plumpang Semper No 16', NULL, '2026-03-06 17:45:38'), (260017, 'Reguler Plus', 'Moh', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'SENTRA TIMUR RESIDENCE TOWER H0825 D', 'Pulo Gebang Cakung', 'L', 'Makkah', '2001-06-09', '3175062706011007', 'S1 Farmasi', '087875356258', '082113550952', 'mohammaddedesyamsudin@gmail.com', 'Islam', 'Nurain Mohammad', 'Dede Syamsudin', 'L', 'SMA/MA/SMK/Sederajat', 'Al-Anjal Internasional School Makkah', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-03-09 10:45:22'), (260018, 'Reguler Plus', 'Jelita allicia', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl.prepedan dalam RT.09rw.09 no.103 kel.kamal kec.kalideres jakarta barat', 'Jl.Prepedan dalam RT.09/09 no.103 kel.kamal.kec.kalideres 11810', 'P', 'Jakarta', '2008-07-01', '3173064107081008', 'S1 Farmasi', '089688044118', '08131858337', 'kusmoment@gmail.com', 'Islam', 'Kusaroh', 'Alm.Jove daniari Sembiring', 'XL', 'SMA/MA/SMK/Sederajat', 'SMK BINA HUSADA MANDIRI', 'Bulanan', 'Facebook', NULL, NULL, NULL, NULL, '2026-03-11 13:20:47'), (260019, 'Reguler Plus', 'Lovelyna khelsea', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Kambang', 'Kebun jeruk,gang lada,kelapa dua,Jakarta barat,rt 004,rw08 kode pos 11550', 'P', 'Kambang', '2008-03-24', '1301106303080001', 'S1 Farmasi', '081112005386', '081275171110', 'lovelynakhelsea714@gmail.com', 'Islam', 'Cici efrimayeni', 'Apri hendrik nasril', 'S', 'SMA/MA/SMK/Sederajat', 'Sma negeri 1 sutra', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-03-11 22:34:31'), (260020, 'Reguler Plus', 'Syafara Aulia azwa', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl almagfiroh no 06 rt06 RW04 Balekambang Kramat jati Jakarta Timur', 'Jakarta timur', 'P', 'Prabumulih', '2006-06-12', '1674035206060001', 'S1 Teknik Informatika', '085369983595', '089665607400', 'syafaraauliaazwa@gmail.com', 'Islam', 'Uswatun Hasanah', 'Karman edi', 'M', 'SMA/MA/SMK/Sederajat', 'Pondok pesantren sholbul qurban', 'Semesteran', 'Instagram', NULL, NULL, NULL, NULL, '2026-03-12 11:34:53'), (260021, 'Reguler Plus', 'SelLa kaifa salasaTin', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Cimone jl suebandi rt 04 Rw 05 gg jenan 2 kp mumungang', 'Tangerang , cimone', 'P', 'Tangerang', '2007-11-29', '3671076911070002', 'S1 Farmasi', '085770356836', '085718269318', 'billiabdika@gmail.com', 'Islam', 'Dewi murniati', 'Muhamad adnan', 'L', 'SMA/MA/SMK/Sederajat', 'Smkn 9 kota Tangerang', 'Bulanan', 'Google', NULL, NULL, NULL, NULL, '2026-03-17 10:58:07'), (260022, 'Reguler Plus', 'M. Andi Irfansyah', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'JL. BRIGJEND H. HASAN BASERY, RT 01 RW 01, DESA/KELURAHAN KALIRING, KECAMATAN PADANG BATUNG, KABUPATEN HULU SUNGAI SELATAN, PROVINSI KALIMANTAN SELATAN, KODE POS 71281', 'JL. BRIGJEND H. HASAN BASERY, RT 01 RW 01, DESA/KELURAHAN KALIRING, KECAMATAN PADANG BATUNG, KABUPATEN HULU SUNGAI SELATAN, PROVINSI KALIMANTAN SELATAN, KODE POS 71281', 'L', 'KANDANGAN', '1993-09-11', '6205051109930002', 'S1 Teknik Sipil', '082156399953', '082156399952', 'andysatur34@gmail.com', 'Islam', 'BASRIAH', 'ARIFIN', 'L', 'D3/Sederajat', 'POLITEKNIK ISLAM SYEKH SALMAN AL-FARISI RANTAU', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-03-28 12:52:24'), (260023, 'Reguler Plus', 'tes', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'tes', 'tes', 'L', 'rts', '2026-04-02', '1234123112341234', 'S1 Farmasi', '1231231231231', '123123123123', 'ads.kuliahkaryawan.id@gmail.com', 'Islam', 'a', 'b', 'M', 'SMA/MA/SMK/Sederajat', 'c', 'Bulanan', 'Facebook', NULL, NULL, NULL, NULL, '2026-04-02 14:47:57'), (260024, 'Reguler Plus', 'Pius Hiluka', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Trim', 'Indonesia', 'L', 'Nanggo', '2006-07-03', '1924320307060001', 'S1 Teknik Mesin', '087823794922', '085264268917', 'piushiluka852@gmail.com', 'Kristen', 'Yonota Giban', 'Yago hiluka', 'XL', 'SMA/MA/SMK/Sederajat', 'SMK pelayaran jakarta raya', 'Semesteran', 'Instagram', 'PT.metrologi', NULL, 'Jln kelpak Gading Jakarta Utara', NULL, '2026-04-04 11:49:31'), (260025, 'Reguler Plus', 'Muhammad Rizki Akbar', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jorong Bukit Barisan, Desa Tigo Jangko, Kec. Lintau Buo, Kab. Tanah Datar, Prov. Sumatera Barat', 'Jorong Bukit Barisan, Desa Tigo Jangko, Kec. Lintau Buo, Kab. Tanah Datar, Prov. Sumatera Barat', 'L', 'Taluk', '2007-06-28', '1304062806070001', 'S1 Teknik Mesin', '082385839045', '082283878630', 'Mhdakbarpku111@gmail.com', 'Islam', 'Rahmawita', 'Syahrial', 'L', 'SMA/MA/SMK/Sederajat', 'SMK N 1 Lintau Buo', 'Bulanan', 'Facebook', NULL, NULL, NULL, NULL, '2026-04-04 14:20:55'), (260026, 'Reguler Plus', 'BELLA SETIAWAN', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Sumbermulyo, Sumberejo, Tanggamus, Lampung', 'Cicau,Cikarang Pusat, Bekasi', 'L', 'Sumbermulyo', '2002-09-06', '1806131609020004', 'S1 Teknik Sipil', '087838070224', '088291648913', 'bellasetiawan045@icloud.com', 'Islam', 'Yulikah', 'Dedi Agus Riyanto', 'S', 'SMA/MA/SMK/Sederajat', 'SMA NEGERI 1 SUMBEREJO', 'Bulanan', 'Instagram', 'PT. TUNASDAYA MUSTIKA', NULL, 'Jln. Radin Inten II No. 52 - Duren Sawit Jakarta Timur - 13440', NULL, '2026-04-06 16:05:06'), (260027, 'Reguler Plus', 'Ahmad Jaki Mubarok', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl.Kh.Abdul Hamid,Kp.Cibunian,Rt03/Rw11,Des.Cibunian,Kec.Pamijahan,Kab.Bogor', 'Jl.Kh.Abdul Hamid,Kp.Cibunian,Rt03/Rw11,Des.Cibunian,Kec.Pamijahan,Kab.Bogor', 'L', 'Bogor', '2007-04-09', '3201170905070002', 'S1 Sistem Informasi', '085716628378', '085720820639', 'dzakidorbetahmad@gmail.com', 'Islam', 'Aar', 'Maman', 'L', 'SMA/MA/SMK/Sederajat', 'MAS AL-HIKMAH', 'Bulanan', 'Tiktok', NULL, NULL, NULL, NULL, '2026-04-07 23:42:52'), (260028, 'Reguler Plus', 'Hanessa yudhistia', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl. Sago', 'Payakumbuh', 'P', 'Payakumbuh', '2004-07-26', '1307046607040001', 'S1 Farmasi', '081378134886', '083161277646', 'yudhistiahanessa@gmail.com', 'Islam', 'Lidia Sari', 'Yudhi Alfitri', 'L', 'SMA/MA/SMK/Sederajat', 'Universitas muhammadiyah bandung', 'Bulanan', 'Instagram', NULL, NULL, NULL, NULL, '2026-04-10 10:26:44'), (260030, 'Reguler Pagi', 'Siti Yuli yani', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'jl pedongkelan RT 10 RW 16 kelurahan kapuk kecamatan Cengkareng Jakarta barat', 'JL.PEDONGKELAN RT 10 RW 16 kelurahan kapuk kecamatan Cengkareng Jakarta Barat', 'P', 'jakarta', '1999-10-23', '3173016310990002', 'S1 Farmasi', '089652563036', '089606826631', 'yn130816@gmail.com', 'Islam', 'nasro', NULL, 'XL', 'Paket C', 'himata', 'Bulanan', 'Teman/Keluarga', 'SPG / kasir', NULL, NULL, NULL, '2026-04-11 08:06:35'), (260031, 'Reguler Pagi', 'adskuliah karyawanid', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', 'Jl Ir H Juanda No71 Pisangan Kec Ciputat', 'Jl Ir H Juanda No71 Pisangan Kec Ciputat', 'L', 'tst', '2026-04-10', '1234567890987564', 'S1 Teknik Kimia', '087804681458', '085880291684', 'farhanyuswaa@gmail.com', 'Islam', 'test', NULL, 'XL', 'SMA/MA/SMK/Sederajat', 'test', 'Bulanan', 'RAP (Recruit Affiliate Program)', 'tstt', NULL, NULL, NULL, '2026-04-11 15:20:54'); -- -------------------------------------------------------- -- -- Table structure for table `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; -- -------------------------------------------------------- -- -- Table structure for table `images` -- CREATE TABLE `images` ( `image_id` int(11) NOT NULL, `kategori` varchar(200) NOT NULL, `file` varchar(100) NOT NULL, `path` varchar(100) DEFAULT NULL, `active` enum('1','0') DEFAULT '1', `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `images` -- INSERT INTO `images` (`image_id`, `kategori`, `file`, `path`, `active`, `created_at`) VALUES (57, 'Fasilitas Kampus', 'ANtC2FRPB9s1Hvm9a24aqeG3sKDNN5EUdUlFnCfn.webp', NULL, '1', '2026-01-09 07:53:02'), (58, 'Fasilitas Kampus', 'ptWVAJCQqtG5Ydgbr6u2hRJRY4bZKZT2o3n4N9jq.webp', NULL, '1', '2026-01-09 07:53:26'), (59, 'Fasilitas Kampus', 'arthOkOM7UXTMTELp7askCmyT1bYfBtI5tgVRDhP.webp', NULL, '1', '2026-01-22 07:17:22'), (61, 'Kegiatan Mahasiswa', 'cUFDvmbaUiQIAYvXu2SjKqMROZ0J3q0UXnfuHTBX.jpg', NULL, '1', '2026-01-22 07:42:41'), (64, 'Fasilitas Kampus', 'PizSveoMDHgO2Lftae1pFXaPcfEZrYSyWrcYyQmQ.webp', NULL, '1', '2026-01-22 07:44:55'), (65, 'Fasilitas Kampus', 'EXgOXsAMK6egD9k9Ko1P9ZQS1WkvA8nXMAXcqll0.webp', NULL, '1', '2026-01-22 07:45:56'), (67, 'Fasilitas Kampus', 'FL7gxVu711xwmGFGIYP5hZ1bW1IOnGj6T9levZND.jpg', NULL, '1', '2026-01-22 07:48:23'), (68, 'Event Kampus', 'V9M3UbjUpTLv2hzYnzttrnzM9UL458MMIlUAPOlT.jpg', NULL, '1', '2026-01-22 07:50:10'); -- -------------------------------------------------------- -- -- Table structure for table `kontak` -- CREATE TABLE `kontak` ( `kontak_id` int(11) NOT NULL, `nama` varchar(100) NOT NULL, `no_telp` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `alamat` text NOT NULL, `pesan` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `kontak` -- INSERT INTO `kontak` (`kontak_id`, `nama`, `no_telp`, `email`, `alamat`, `pesan`, `created_at`, `updated_at`) VALUES (1, 'Movie Clip test', '083183262301', 'admin@gmail.com', 'Jl. Kenanga 3 no.74 RT 03 RW 05 Kel.Depok Jaya Kec. pancoran mas', 'sad', '2024-11-26 00:34:41', '2024-11-26 00:34:41'), (2, 'Muhamad Ilham Mubarrok', '081389963530', 'kagamayta721@gmail.com', 'JL. KP. SAWAH DALAM NO.31', 'asdasdasd', '2024-12-24 02:57:27', '2024-12-24 02:57:27'), (3, 'Muhamad Ilham Mubarrok', '081389963530', 'kagamayta721@gmail.com', 'JL. KP. SAWAH DALAM NO.31', 'asdasdasd', '2024-12-24 02:57:37', '2024-12-24 02:57:37'); -- -------------------------------------------------------- -- -- Table structure for table `kurikulum` -- CREATE TABLE `kurikulum` ( `id_kurikulum` int(11) NOT NULL, `jurusan` varchar(200) NOT NULL, `file` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `menu` -- CREATE TABLE `menu` ( `menu_id` int(11) NOT NULL, `submenu_id` int(11) NOT NULL DEFAULT 0, `menu` varchar(30) DEFAULT NULL, `url` varchar(500) DEFAULT NULL, `urutan` tinyint(4) NOT NULL, `active` enum('1','0') NOT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `menu` -- INSERT INTO `menu` (`menu_id`, `submenu_id`, `menu`, `url`, `urutan`, `active`, `updated_at`) VALUES (2, 0, 'Biaya Kuliah', '#', 5, '1', NULL), (4, 0, 'Daftar Online', 'pendaftaran', 4, '1', NULL), (7, 0, 'Akademik', '#', 3, '1', NULL), (8, 0, 'Home', './', 1, '1', NULL), (10, 0, 'Galeri', 'index.php?m=galeri', 6, '1', NULL), (26, 0, 'Tentang', '#', 2, '1', NULL), (28, 26, 'Sejarah Singkat', 'sejarah-singkat', 2, '1', NULL), (30, 26, 'Visi & Misi', 'visi-misi', 4, '1', NULL), (37, 10, 'Event Kampus', 'event-kampus', 1, '1', NULL), (38, 10, 'Fasilitas Kampus', 'fasilitas-kampus', 2, '1', NULL), (39, 10, 'Kegiatan Mahasiswa', 'kegiatan-mahasiswa', 3, '1', NULL), (54, 2, 'Biaya Kuliah', 'Biaya-kuliah', 1, '1', NULL), (67, 7, 'Fasilitas Kampus ', '13', 0, '1', NULL), (68, 2, 'Brosur', 'brosur', 2, '1', NULL), (71, 7, 'Sistem Perkuliahan', '23', 0, '1', NULL), (80, 26, 'Struktur Organisasi', 'struktur-organisasi', 0, '1', '2024-11-13 00:14:16'), (81, 7, 'Kurikulum', 'kurikulum', 3, '1', NULL), (82, 0, 'Tracer Study', 'tracer-study', 7, '1', NULL); -- -------------------------------------------------------- -- -- 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 (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2024_11_04_063620_create_daftar_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE `page` ( `page_id` int(11) NOT NULL, `judul` varchar(100) NOT NULL, `slug` varchar(200) NOT NULL, `short` varchar(250) NOT NULL, `isi` text NOT NULL, `image` varchar(100) NOT NULL, `link` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `page` -- INSERT INTO `page` (`page_id`, `judul`, `slug`, `short`, `isi`, `image`, `link`, `created_at`) VALUES (13, 'Fasilitas', '', 'Fasilitas Kampus', '

Kampus INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL memiliki fasilitas lengkap dan terkini sehingga memudahkan proses belajar mengajar sebagai berikut :

\r\n\r\n
    \r\n
  1. Kuliah melalui tatap muka serta komunikasi melalui internet.
    2. \r\n
  2. Laboratorium yang lengkap dan memadai.
    3. \r\n
  3. Ruang Kuliah dilengkapi LCD Proyektor dan Multi media lainnya.
    4. \r\n
  4. Perpustakaan menggunakan (Air Conditioner) atau Penyejuk Udara dan menggunakan alat pemantau (cctv).
    5. \r\n
  5. Tempat ibadah/Musholah yang bersih untuk kesempurnaan ibadah.
    6. \r\n
  6. Lokasi kampus strategis, mudah dijangkau dan tersedia tempat parkir.                                                                                             
    7. \r\n
\r\n\r\n

 

\r\n\r\n

 

\r\n\r\n

Terima Kasih
\r\nSekretariat Pendaftaran INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL

', '', '', '2025-12-30 06:39:12'), (23, 'Sistem Perkuliahan Kelas Karyawan', '', 'Dengan jam kuliah yang fleksibel tersedia kelas sabtu minggu dan kelas shift sangat membantu teman teman yang ingin kuliah namun terkendala jam pekerjaan', '

Sistem Perkuliahan

\r\n\r\n

Dengan jam kuliah yang sangat fleksibel, menyediakan program kelas .

\r\n\r\n

Dengan jadwal kuliah :
\r\nReguler Pagi
\r\nReguler Plus
\r\n
\r\n
\r\nJika teman teman memiliki kendala dalam waktu kuliah karena sistem kerja yang shift ataupun kerjaan dengan waktu yang sulit untuk berkuliah, INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL memilki waktu kuliah yang fleksibel, silahkan dapat menghubungi admin kami untuk konsultasi lebih lanjut.                                                        

\r\n\r\n

Terima Kasih
\r\nSekretariat Penerimaan INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL

\r\n\r\n\r\n \r\n \r\n
', '', '', '2025-12-30 06:38:31'); -- -------------------------------------------------------- -- -- 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 `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, `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 `setting` -- CREATE TABLE `setting` ( `id_setting` int(11) NOT NULL, `jenis_set` varchar(20) NOT NULL, `nama_set` varchar(200) NOT NULL, `nilai_set` varchar(255) NOT NULL, `active` enum('1','0') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `setting` -- INSERT INTO `setting` (`id_setting`, `jenis_set`, `nama_set`, `nilai_set`, `active`) VALUES (2, 'kontak', 'Telepon', '0878-9019-8284', '1'), (3, 'kontak', 'Whatsapp', '6287818000395', '1'), (4, 'fb', 'Facebook1', 'https://www.facebook.com/profile.php?id=61585787822436', '1'), (6, 'rekening', 'an Khavid Hasbulloh, PT BRI, Tbk', '0924-01-007596-507', '1'), (7, 'rekening', 'Khavid Hasbulloh, PT Bank BCA, Tbk', '6610-8654-35', '1'), (8, 'rekening', 'Khavid Hasbulloh, PT Bank Mandiri Syariah, Tbk', '711-2299-666', '1'), (9, 'ig', 'Instagram1', 'https://www.instagram.com/k2.istajakarta_/', '1'), (10, 'kampus', 'nama kampus', 'INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL', '1'), (11, 'biaya formulir', 's1', 'Rp 200.000', '1'), (13, 'kampus', 'alamat kampus', 'Jl. Raya Al Kamal No.2 Kedoya Selatan Kebon Jeruk, Jakarta Barat DKI Jakarta 11520', '1'), (19, 'kampus', 'maps', 'https://www.google.com/maps/embed?pb=!3m2!1sen!2sid!4v1767068049866!5m2!1sen!2sid!6m8!1m7!1shpGzva9GiQKMHQ_GIBgGWQ!2m2!1d-6.187591708454787!2d106.7617620379846!3f297.80156332770486!4f-1.0211765077730774!5f0.7820865974627469', '1'), (25, 'kampus', 'link1', 'https://maps.app.goo.gl/wY2M7pWy1ArxAntK8', '1'); -- -------------------------------------------------------- -- -- Table structure for table `tracer_study` -- CREATE TABLE `tracer_study` ( `tracer_id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) NOT NULL, `jenis_kelamin` enum('L','P') NOT NULL, `tempat_lahir` varchar(255) NOT NULL, `tanggal_lahir` date NOT NULL, `alamat_domisili` text NOT NULL, `jurusan` varchar(255) NOT NULL, `no_hp` varchar(15) NOT NULL, `email_pribadi` varchar(255) NOT NULL, `tanggal_kelulusan` date NOT NULL, `memiliki_sertifikat` enum('Ya','Tidak') NOT NULL, `status_lulus` enum('Bekerja','Melanjutkan Kuliah','Belum Bekerja/Kuliah','Sambil Bekerja dan Kuliah') NOT NULL, `nama_instansi` varchar(255) DEFAULT NULL, `mulai_bekerja` date DEFAULT NULL, `waktu_menunggu` varchar(100) DEFAULT NULL, `alamat_perusahaan` text DEFAULT NULL, `kampus_lanjutan` varchar(255) DEFAULT NULL, `alamat_kampus_lanjutan` text DEFAULT NULL, `sosial_media` text DEFAULT NULL, `kesan` text DEFAULT NULL, `saran` text 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 `useradmin` -- CREATE TABLE `useradmin` ( `user_id` int(11) NOT NULL, `username` char(32) DEFAULT NULL, `password` varchar(150) DEFAULT NULL, `nama` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `tipe` char(30) DEFAULT NULL, `status` char(10) DEFAULT NULL, `lastlogin` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `useradmin` -- INSERT INTO `useradmin` (`user_id`, `username`, `password`, `nama`, `email`, `remember_token`, `tipe`, `status`, `lastlogin`) VALUES (232, 'admin', '10beaac415ef63830210737bd6d7edb8', 'Admin Institut Az Zuhra', '', NULL, 'admin', '1', NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `kampus` varchar(255) DEFAULT NULL, `gambar` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) 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`, `name`, `kampus`, `gambar`, `logo`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (12, 'admin INSTITUT SAIN DAN TEKNOLOGI AL-KAMAL', 'INSTITUT SAIN DAN TEKNOLOGI AL-KAMAL', 'bCOHpcCPkJvN3DIkoPW0HUaMdek0SMeDOGxW9gTA.png', 'xMr4WNzc5G3O6pBcdVvy1v5JDYA2JU1YXhxQ1SVz.png', 'admin@gmail.com', NULL, '$2y$10$vSv4bryjdaAKKyZwRST1WOv.oDPJYCxbKQnxtHS/OnaLJvWmGFtZO', NULL, '2025-04-15 21:18:07', '2025-12-30 09:13:55'); -- -- Indexes for dumped tables -- -- -- Indexes for table `beranda` -- ALTER TABLE `beranda` ADD PRIMARY KEY (`beranda_id`); -- -- Indexes for table `berita` -- ALTER TABLE `berita` ADD PRIMARY KEY (`id_berita`); -- -- Indexes for table `biaya` -- ALTER TABLE `biaya` ADD PRIMARY KEY (`biaya_id`); -- -- Indexes for table `brosur` -- ALTER TABLE `brosur` ADD PRIMARY KEY (`brosur_id`); -- -- Indexes for table `daftar` -- ALTER TABLE `daftar` ADD PRIMARY KEY (`daftar_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `images` -- ALTER TABLE `images` ADD PRIMARY KEY (`image_id`); -- -- Indexes for table `kontak` -- ALTER TABLE `kontak` ADD PRIMARY KEY (`kontak_id`); -- -- Indexes for table `kurikulum` -- ALTER TABLE `kurikulum` ADD PRIMARY KEY (`id_kurikulum`); -- -- Indexes for table `menu` -- ALTER TABLE `menu` ADD PRIMARY KEY (`menu_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `page` -- ALTER TABLE `page` ADD PRIMARY KEY (`page_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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 `setting` -- ALTER TABLE `setting` ADD PRIMARY KEY (`id_setting`); -- -- Indexes for table `tracer_study` -- ALTER TABLE `tracer_study` ADD PRIMARY KEY (`tracer_id`); -- -- Indexes for table `useradmin` -- ALTER TABLE `useradmin` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `beranda` -- ALTER TABLE `beranda` MODIFY `beranda_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `berita` -- ALTER TABLE `berita` MODIFY `id_berita` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `biaya` -- ALTER TABLE `biaya` MODIFY `biaya_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168; -- -- AUTO_INCREMENT for table `brosur` -- ALTER TABLE `brosur` MODIFY `brosur_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `images` -- ALTER TABLE `images` MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69; -- -- AUTO_INCREMENT for table `kontak` -- ALTER TABLE `kontak` MODIFY `kontak_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `kurikulum` -- ALTER TABLE `kurikulum` MODIFY `id_kurikulum` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `menu` -- ALTER TABLE `menu` MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `page` -- ALTER TABLE `page` MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- 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 `setting` -- ALTER TABLE `setting` MODIFY `id_setting` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `tracer_study` -- ALTER TABLE `tracer_study` MODIFY `tracer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `useradmin` -- ALTER TABLE `useradmin` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; 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 */;