-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ppdb2`
--

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

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `bank`
--

INSERT INTO `bank` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'BRI', '2020-08-20 14:43:44', '2020-08-20 14:50:15'),
(2, 'BCA', '2020-08-20 14:53:53', '2020-08-20 14:53:53');

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

--
-- Table structure for table `biodata`
--

CREATE TABLE `biodata` (
  `id` int(10) UNSIGNED NOT NULL,
  `users` bigint(20) UNSIGNED NOT NULL,
  `jalur_ppdb` int(10) UNSIGNED DEFAULT NULL,
  `no_hp` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` datetime NOT NULL,
  `agama_anak` int(10) UNSIGNED NOT NULL,
  `ijazah` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ktp` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nisn` int(15) DEFAULT NULL,
  `jk` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ayah` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik_ayah` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `agama_ayah` int(10) UNSIGNED NOT NULL,
  `pendidikan_ayah` int(10) UNSIGNED DEFAULT NULL,
  `pekerjaan_ayah` int(10) UNSIGNED DEFAULT NULL,
  `nama_ibu` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik_ibu` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `agama_ibu` int(10) UNSIGNED NOT NULL,
  `pendidikan_ibu` int(10) UNSIGNED DEFAULT NULL,
  `pekerjaan_ibu` int(10) UNSIGNED DEFAULT NULL,
  `asal_sekolah` int(10) UNSIGNED DEFAULT NULL,
  `status_sklh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_sklh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_un` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_kk` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_sklh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa_sklh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kec_sklh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kab_sklh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi_sklh` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos_sklh` varchar(100) COLLATE utf8mb4_unicode_ci 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 `biodata`
--

INSERT INTO `biodata` (`id`, `users`, `jalur_ppdb`, `no_hp`, `alamat`, `tempat_lahir`, `tanggal_lahir`, `agama_anak`, `ijazah`, `ktp`, `nik`, `nisn`, `jk`, `nama_ayah`, `nik_ayah`, `agama_ayah`, `pendidikan_ayah`, `pekerjaan_ayah`, `nama_ibu`, `nik_ibu`, `agama_ibu`, `pendidikan_ibu`, `pekerjaan_ibu`, `asal_sekolah`, `status_sklh`, `nama_sklh`, `no_un`, `no_kk`, `alamat_sklh`, `desa_sklh`, `kec_sklh`, `kab_sklh`, `provinsi_sklh`, `kode_pos_sklh`, `created_at`, `updated_at`) VALUES
(16, 98, 1, '424', 'fwfwf', 'sdcsdc', '2020-08-05 00:00:00', 1, NULL, NULL, '4424', NULL, 'Laki-laki', 'fwef', '442424', 1, 2, 3, 'wefwe', '42423', 1, 3, 3, 2, 'Swasta', 'fwefew', NULL, '424230', 'sfsf', 'rwerw', 'sfsd', 'fsf', 'sdfds', '324324', '2020-08-06 17:19:53', '2020-08-06 17:19:53');

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

--
-- Table structure for table `info`
--

CREATE TABLE `info` (
  `id` int(12) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL,
  `prosedur_id` int(10) UNSIGNED NOT NULL,
  `waktu` date NOT NULL,
  `judul` varchar(115) NOT NULL,
  `deskripsi` text NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `info`
--

INSERT INTO `info` (`id`, `profile_id`, `prosedur_id`, `waktu`, `judul`, `deskripsi`, `photo`, `created_at`, `updated_at`) VALUES
(24, 1, 1, '2020-08-19', 'Pendaftaran telah dibuka', '<p>Sebelum mengisi formulir pendaftaran siswa/pendaftar diharuskan untuk mendaftarkan akun terlebih dahulu di <a href=\"/ppdb\" target=\"_blank\">link ini</a>. Terima kasih.</p><p>Lorem Ipsum adalah contoh teks atau dummy dalam industri percetakan dan penataan huruf atau typesetting. Lorem Ipsum telah menjadi standar contoh teks sejak tahun 1500an, saat seorang tukang cetak yang tidak dikenal mengambil sebuah kumpulan teks dan mengacaknya untuk menjadi sebuah buku contoh huruf.<br></p>', 'uploads/862930964-PPDB.png', '2020-08-02 07:25:18', '2020-08-10 13:18:18'),
(26, 1, 1, '2020-08-26', 'Jadwal pengumuman kelulusan PPDB Online', '<p>Pengumuman PPDB Online akan dilaksakan pada tanggal 27 Agustus 2020 pada jam 09.00, diharapkan siswa dapat melihat pada link <a href=\"https://ppdb.verval.id.\" target=\"_blank\">https://ppdb.verval.id.</a> terima kasih</p>', 'uploads/761704819-PPDB.png', '2020-08-10 12:58:28', '2020-08-10 13:15:36');

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

--
-- Table structure for table `konfbayars`
--

CREATE TABLE `konfbayars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_siswa` varchar(255) NOT NULL,
  `id_reg` varchar(255) NOT NULL,
  `tgl_kirim` date NOT NULL,
  `nm_pengirim` varchar(255) NOT NULL,
  `bank_id` int(10) UNSIGNED NOT NULL,
  `nominal` varchar(100) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `konfbayars`
--

INSERT INTO `konfbayars` (`id`, `nama_siswa`, `id_reg`, `tgl_kirim`, `nm_pengirim`, `bank_id`, `nominal`, `image`, `created_at`, `updated_at`) VALUES
(13, 'Hadziq', 'REG-20200210210404', '2020-08-24', 'Hadziq', 2, 'Rp. 100.000', '1221635988.png', '2020-08-20 15:04:55', '2020-08-20 15:33:40');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_02_05_034224_alter_users', 2),
(4, '2020_02_05_034724_add_photo', 3),
(5, '2020_02_05_172122_add_id_registrasi', 4),
(6, '2020_02_08_224238_create_biodata', 5),
(7, '2020_02_12_232246_alter_users_verifikasi', 6),
(8, '2020_02_17_230350_add_file', 7),
(9, '2020_02_18_223345_add_role_users', 8),
(10, '2020_02_19_221921_table_profile_sekolah', 9),
(11, '2020_02_22_055318_create_table_pesan', 10),
(12, '2020_02_22_061845_alter_pesan', 11),
(13, '2020_02_23_104352_add_islulus', 12),
(14, '2020_07_18_151636_alter_profile_id', 13),
(15, '2020_07_18_152301_alter_profile_id', 14),
(16, '2020_07_18_212216_create_table_pekerjaan', 15),
(17, '2020_07_18_213133_alter_pekerjaan', 16),
(18, '2020_07_18_214506_create_table_pendidikan', 17),
(19, '2020_07_18_214552_alter_pendidikan', 17),
(20, '2020_07_19_062101_create_table_jalurppdb', 18),
(21, '2020_07_19_062252_alter_jalur_ppdb', 19),
(22, '2020_07_19_191439_create_asal_sekolah', 20),
(23, '2020_07_19_191743_alter_asal_sekolah', 20),
(24, '2020_07_21_220842_alter_identitas_sekolah', 21),
(25, '2020_08_01_144238_create_crud_table', 22),
(26, '2020_08_02_140432_alter_prosedur_id', 23),
(27, '2020_08_06_210748_create_agama_table', 24),
(28, '2020_08_06_214208_alter_agama_ibu_biodata', 25),
(29, '2020_08_20_211508_create_bank_table', 26),
(30, '2020_08_20_211845_alter_bank_id_table', 27);

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

--
-- Table structure for table `m_agama`
--

CREATE TABLE `m_agama` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `m_agama`
--

INSERT INTO `m_agama` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'Islam', '2020-08-06 14:23:25', '2020-08-06 14:26:22'),
(2, 'Kristen', '2020-08-06 14:27:17', '2020-08-06 14:27:17'),
(3, 'Katolik', '2020-08-06 14:27:37', '2020-08-06 14:27:37'),
(4, 'Budha', '2020-08-06 23:08:23', '2020-08-06 23:08:23'),
(5, 'Hindu', '2020-08-06 23:08:34', '2020-08-06 23:08:34'),
(6, 'Kong Hu Chu', '2020-08-06 23:08:47', '2020-08-06 23:08:47');

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

--
-- Table structure for table `m_asal_sekolah`
--

CREATE TABLE `m_asal_sekolah` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `m_asal_sekolah`
--

INSERT INTO `m_asal_sekolah` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'SD/MI (Sederajat)', NULL, NULL),
(2, 'SMP/MTs (Sederajat)', NULL, NULL),
(3, 'SMA/MA (Sederajat)', '2020-07-19 13:06:35', '2020-07-19 13:13:40');

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

--
-- Table structure for table `m_jalur_ppdb`
--

CREATE TABLE `m_jalur_ppdb` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `m_jalur_ppdb`
--

INSERT INTO `m_jalur_ppdb` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'Baru', NULL, NULL),
(2, 'Pindahan', NULL, NULL);

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

--
-- Table structure for table `m_pekerjaan`
--

CREATE TABLE `m_pekerjaan` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `m_pekerjaan`
--

INSERT INTO `m_pekerjaan` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'Petani', NULL, NULL),
(2, 'Buruh harian lepas', NULL, NULL),
(3, 'Karyawan Swasta', '2020-07-18 16:09:00', '2020-07-21 08:45:07'),
(5, 'Guru/Dosen', '2020-07-18 17:04:31', '2020-07-18 17:04:54'),
(6, 'Wiraswasta', '2020-07-18 17:05:32', '2020-07-18 17:05:32'),
(7, 'Ibu rumah tangga', '2020-07-18 17:05:50', '2020-07-18 17:05:50');

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

--
-- Table structure for table `m_pendidikan`
--

CREATE TABLE `m_pendidikan` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(115) COLLATE utf8mb4_unicode_ci 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 `m_pendidikan`
--

INSERT INTO `m_pendidikan` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'SD/MI (Sederajat)', NULL, '2020-07-18 20:22:05'),
(2, 'SMP/MTs (Sederajat)', NULL, '2020-07-18 20:22:23'),
(3, 'SMA/MA (Sederajat)', '2020-07-18 20:18:39', '2020-07-18 20:21:46'),
(4, 'D1', '2020-07-18 23:15:09', '2020-07-18 23:15:09'),
(5, 'D2', '2020-07-18 23:15:17', '2020-07-18 23:15:17'),
(6, 'D3', '2020-07-18 23:15:25', '2020-07-18 23:15:25'),
(7, 'D4', '2020-07-18 23:15:36', '2020-07-18 23:15:36'),
(8, 'S1', '2020-07-18 23:15:44', '2020-07-18 23:15:44'),
(9, 'S2', '2020-07-18 23:15:53', '2020-07-18 23:15:53'),
(10, 'S3', '2020-07-18 23:16:02', '2020-07-18 23:16:02');

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

--
-- Table structure for table `pesan`
--

CREATE TABLE `pesan` (
  `id` int(10) UNSIGNED NOT NULL,
  `users` bigint(20) UNSIGNED NOT NULL,
  `judul` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) 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 `pesan`
--

INSERT INTO `pesan` (`id`, `users`, `judul`, `keterangan`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 'Test pesan', '<p>keterangan pesan<br></p>', 1, '2020-02-21 23:24:41', '2020-07-26 14:57:13'),
(2, 3, 'asdasd', '<p>sadasdas<br></p>', 1, '2020-02-22 14:43:10', '2020-05-02 04:30:13'),
(4, 5, 'Informasi PPDB', '<p style=\"color: rgb(51, 51, 51);\">Hello John,</p><p style=\"color: rgb(51, 51, 51);\">Keffiyeh blog actually fashion axe vegan, irony biodiesel. Cold-pressed hoodie chillwave put a bird on it aesthetic, bitters brunch meggings vegan iPhone. Dreamcatcher vegan scenester mlkshk. Ethical master cleanse Bushwick, occupy Thundercats banjo cliche ennui farm-to-table mlkshk fanny pack gluten-free. Marfa butcher vegan quinoa, bicycle rights disrupt tofu scenester chillwave 3 wolf moon asymmetrical taxidermy pour-over. Quinoa tote bag fashion axe, Godard disrupt migas church-key tofu blog locavore. Thundercats cronut polaroid Neutra tousled, meh food truck selfies narwhal American Apparel.</p>', 1, '2020-07-20 14:10:18', '2020-07-26 14:56:13'),
(5, 99, 'egew', '<p>gweger</p>', 1, '2020-07-22 08:25:20', '2020-08-04 07:12:15');

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

--
-- Table structure for table `profile_sekolah`
--

CREATE TABLE `profile_sekolah` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `desa` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kec` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kab` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pos` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_telp` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tapel` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` text COLLATE utf8mb4_unicode_ci 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 `profile_sekolah`
--

INSERT INTO `profile_sekolah` (`id`, `nama`, `alamat`, `desa`, `kec`, `kab`, `kode_pos`, `email`, `no_telp`, `tapel`, `logo`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'MI Ya BAKII Kuripan Kidul', 'Jl. Diponegoro No. 52', 'Kuripan Kidul', 'Kesugihan', 'Cilacap', '53274', 'miyabakii_kurkid@yahoo.com', '6282337724632', '2020/2021', 'sekolah_images/Logo Ya BAKII.png', 'sekolah_images/Kop MI.png', '2020-08-03 13:22:30', '2020-08-03 13:22:30');

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

--
-- Table structure for table `prosedur_ppdb`
--

CREATE TABLE `prosedur_ppdb` (
  `id` int(10) UNSIGNED NOT NULL,
  `judul` varchar(115) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` text COLLATE utf8mb4_unicode_ci 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 `prosedur_ppdb`
--

INSERT INTO `prosedur_ppdb` (`id`, `judul`, `deskripsi`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Prosedur Pendaftaran Peserta Didik Baru', '<table class=\"table table-bordered\"><tbody><tr><td style=\"text-align: center;\"><b>No</b></td><td style=\"text-align: center;\"><b>Keterangan</b></td></tr><tr><td style=\"text-align: center;\">1</td><td><span style=\"color: rgb(51, 51, 51);\">Siswa mendaftar akun baru di&nbsp;</span><a href=\"/ppdb\" style=\"background-color: rgb(255, 255, 255);\">Daftar Akun.</a><br></td></tr><tr><td style=\"text-align: center;\">2</td><td><span style=\"color: rgb(51, 51, 51);\">Setelah berhasil membuat akun baru, siswa&nbsp;</span><a href=\"/login\" style=\"background-color: rgb(255, 255, 255);\">login/masuk</a><span style=\"color: rgb(51, 51, 51);\">&nbsp;menggunakan email yang barusan digunakan untuk daftar dan password/kata sandi yang diberikan pada notifikasi berwarna hijau saat berhasil membuat akun baru.</span><br></td></tr><tr><td style=\"text-align: center;\">3</td><td><span style=\"color: rgb(51, 51, 51);\">Setelah berhasil login, siswa harus melengkapi&nbsp;</span><a href=\"/biodata\" style=\"background-color: rgb(255, 255, 255);\">biodata</a><span style=\"color: rgb(51, 51, 51);\">&nbsp;secara keseluruhan menggunakan data yang valid, dan menambahkan atau meng-upload foto (wajib) dan file Ijazah (jika ada)</span><br></td></tr><tr><td style=\"text-align: center;\">4</td><td><span style=\"color: rgb(51, 51, 51);\">Setelah biodata berhasil dilengkapi, siswa dapat mengunduh atau&nbsp;</span><span style=\"background-color: rgb(255, 255, 255);\">download formulir</span><span style=\"color: rgb(51, 51, 51);\">&nbsp;dan kartu peserta PPDB, kemudian di cetak/print kemudian dibawa ke sekolah kami dan diserahkan ke panitia PPDB pada saat sebelum pendaftaran ditutup.</span><br></td></tr></tbody></table><p><br></p>', 'assets/1280326479-post_ppdb.png', '2020-08-01 07:56:10', '2020-08-02 06:45:27');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bank`
--
ALTER TABLE `bank`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `biodata`
--
ALTER TABLE `biodata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `biodata_users_foreign` (`users`),
  ADD KEY `biodata_pekerjaan_ayah_foreign` (`pekerjaan_ayah`),
  ADD KEY `biodata_pekerjaan_ibu_foreign` (`pekerjaan_ibu`),
  ADD KEY `biodata_pendidikan_ayah_foreign` (`pendidikan_ayah`),
  ADD KEY `biodata_pendidikan_ibu_foreign` (`pendidikan_ibu`),
  ADD KEY `biodata_jalur_ppdb_foreign` (`jalur_ppdb`),
  ADD KEY `biodata_asal_sekolah_foreign` (`asal_sekolah`),
  ADD KEY `biodata_agama_anak_foreign` (`agama_anak`),
  ADD KEY `biodata_agama_ayah_foreign` (`agama_ayah`),
  ADD KEY `biodata_agama_ibu_foreign` (`agama_ibu`);

--
-- Indexes for table `info`
--
ALTER TABLE `info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `info_profile_id_foreign` (`profile_id`),
  ADD KEY `info_prosedur_id_foreign` (`prosedur_id`);

--
-- Indexes for table `konfbayars`
--
ALTER TABLE `konfbayars`
  ADD PRIMARY KEY (`id`),
  ADD KEY `konfbayars_bank_id_foreign` (`bank_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_agama`
--
ALTER TABLE `m_agama`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_asal_sekolah`
--
ALTER TABLE `m_asal_sekolah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_jalur_ppdb`
--
ALTER TABLE `m_jalur_ppdb`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_pekerjaan`
--
ALTER TABLE `m_pekerjaan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_pendidikan`
--
ALTER TABLE `m_pendidikan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pesan`
--
ALTER TABLE `pesan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesan_users_foreign` (`users`);

--
-- Indexes for table `profile_sekolah`
--
ALTER TABLE `profile_sekolah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `prosedur_ppdb`
--
ALTER TABLE `prosedur_ppdb`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bank`
--
ALTER TABLE `bank`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `biodata`
--
ALTER TABLE `biodata`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `info`
--
ALTER TABLE `info`
  MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `konfbayars`
--
ALTER TABLE `konfbayars`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `m_agama`
--
ALTER TABLE `m_agama`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `m_asal_sekolah`
--
ALTER TABLE `m_asal_sekolah`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `m_jalur_ppdb`
--
ALTER TABLE `m_jalur_ppdb`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `m_pekerjaan`
--
ALTER TABLE `m_pekerjaan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `m_pendidikan`
--
ALTER TABLE `m_pendidikan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `pesan`
--
ALTER TABLE `pesan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `profile_sekolah`
--
ALTER TABLE `profile_sekolah`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `prosedur_ppdb`
--
ALTER TABLE `prosedur_ppdb`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `biodata`
--
ALTER TABLE `biodata`
  ADD CONSTRAINT `biodata_agama_anak_foreign` FOREIGN KEY (`agama_anak`) REFERENCES `m_agama` (`id`),
  ADD CONSTRAINT `biodata_agama_ayah_foreign` FOREIGN KEY (`agama_ayah`) REFERENCES `m_agama` (`id`),
  ADD CONSTRAINT `biodata_agama_ibu_foreign` FOREIGN KEY (`agama_ibu`) REFERENCES `m_agama` (`id`),
  ADD CONSTRAINT `biodata_asal_sekolah_foreign` FOREIGN KEY (`asal_sekolah`) REFERENCES `m_asal_sekolah` (`id`),
  ADD CONSTRAINT `biodata_jalur_ppdb_foreign` FOREIGN KEY (`jalur_ppdb`) REFERENCES `m_jalur_ppdb` (`id`),
  ADD CONSTRAINT `biodata_pekerjaan_ayah_foreign` FOREIGN KEY (`pekerjaan_ayah`) REFERENCES `m_pekerjaan` (`id`),
  ADD CONSTRAINT `biodata_pekerjaan_ibu_foreign` FOREIGN KEY (`pekerjaan_ibu`) REFERENCES `m_pekerjaan` (`id`),
  ADD CONSTRAINT `biodata_pendidikan_ayah_foreign` FOREIGN KEY (`pendidikan_ayah`) REFERENCES `m_pendidikan` (`id`),
  ADD CONSTRAINT `biodata_pendidikan_ibu_foreign` FOREIGN KEY (`pendidikan_ibu`) REFERENCES `m_pendidikan` (`id`),
  ADD CONSTRAINT `biodata_users_foreign` FOREIGN KEY (`users`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `info`
--
ALTER TABLE `info`
  ADD CONSTRAINT `info_profile_id_foreign` FOREIGN KEY (`profile_id`) REFERENCES `profile_sekolah` (`id`),
  ADD CONSTRAINT `info_prosedur_id_foreign` FOREIGN KEY (`prosedur_id`) REFERENCES `prosedur_ppdb` (`id`);

--
-- Constraints for table `konfbayars`
--
ALTER TABLE `konfbayars`
  ADD CONSTRAINT `konfbayars_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `bank` (`id`);

--
-- Constraints for table `pesan`
--
ALTER TABLE `pesan`
  ADD CONSTRAINT `pesan_users_foreign` FOREIGN KEY (`users`) REFERENCES `users` (`id`);
COMMIT;

