--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `alumni`
--

CREATE TABLE `alumni` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `link` varchar(50) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `nisn` varchar(15) NOT NULL,
  `nis` varchar(100) NOT NULL,
  `jurusan` text NOT NULL,
  `tempat_lahir` varchar(50) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `kelamin_jenis` enum('L','P') NOT NULL DEFAULT 'L',
  `alamat` text NOT NULL,
  `kota` varchar(30) NOT NULL,
  `telepon` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `angkatan` varchar(5) NOT NULL,
  `tahun_lulus` year(4) NOT NULL,
  `jenjang` varchar(16) NOT NULL,
  `sekolah_lanjutan` varchar(50) NOT NULL,
  `program_studi` varchar(100) NOT NULL,
  `pekerjaan` varchar(100) NOT NULL,
  `bekerja_diperusahaan` varchar(100) NOT NULL,
  `profil` text NOT NULL,
  `gambar` varchar(190) NOT NULL,
  `tgl` date NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=165952 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_module` int(11) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `url` varchar(200) NOT NULL,
  `target` enum('_parent','_blank') NOT NULL DEFAULT '_parent',
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=374115 DEFAULT CHARSET=latin1;




INSERT INTO `banner` VALUES (28795,'smkhidayatulinsaniabadi.sch.id',183236,'Banner ','Banner','','_blank','ban1.jpg','2021-03-19 11:00:19','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `berita`
--

CREATE TABLE `berita` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `isi` longtext NOT NULL,
  `kata_kunci` text NOT NULL,
  `kategori` varchar(100) NOT NULL,
  `penulis` varchar(100) NOT NULL,
  `id_berita_kategori` int(11) NOT NULL,
  `tampilkan_judul` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_tanggal` enum('1','0') NOT NULL,
  `tampilkan_isi` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_gambar` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_komentar` enum('0','1') NOT NULL,
  `tampilkan_formulir` enum('0','1') NOT NULL,
  `tampilkan_pembaca` enum('1','0') NOT NULL,
  `tampilkan_katakunci` enum('1','0') NOT NULL,
  `tampilkan_berbagi` enum('1','0') NOT NULL,
  `jumlah_pembaca` int(11) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=996176 DEFAULT CHARSET=latin1;




INSERT INTO `berita` VALUES (152996,'smkhidayatulinsaniabadi.sch.id',' Sekolah SMK Hidayatul Insani Abadi membuka kembali pendaftaran siswa/i baru tahun 2021/2022','-sekolah-smk-hidayatul-insani-abadi-membuka-kembali-pendaftaran-siswai-baru-tahun-20212022','&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;b&gt;&lt;span style=&quot;font-family:&amp;quot;Arial Black&amp;quot;,&amp;quot;sans-serif&amp;quot;&quot;&gt;SMK HIA MEMBUKA\r\nKEMBALI PENDAFTARAN SISWA BARU TAHUN 2021/2022&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Sekolah Menengah Kejuruan Hidayatul Insani Abadi\r\natau lebih mudah di kenal dengan SMK HIA, kembali membuka pendaftaran\r\npenerimaan siswa/siswi baru untuk tahun ajaran 2021/2022. pada tahun ini\r\npendaftaran dibuka mulai bulai Maret sampai dengan bulan Mei 2021. Di\r\ntahun-tahun sebelumnya SMK HIA hanya memiliki 2 jurusan utama yaitu TKR\r\n(Tekhnik Kendaraan Ringan) dan TB (Tata Busana), namun tahun ini SMK HIA\r\nmenambah 1 jurusan baru yaitu jurusan Multimedia.&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Kepala sekolah SMK HIA Ibu Turi Hudayani Abadi\r\nmengatakan &lsquo;&rsquo;Kami siap membimbing dan membentuk siswa/siswi untuk menjadi\r\npribadi yang bertakwa, unggul dalam prestasi dan mandiri sesuai dengan visi\r\nsekolah kami&rsquo;&rsquo;. Selain itu Ibu Turi juga menjelaskan bahwa keluarga besar SMK\r\nHIA siap membantu calon siswa/siswi baru untuk mengasah keahlian didalam\r\npembelajaran baik secara teori maupun praktek.&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;SMK HIA merupakan sekolah yang memiliki guru\r\n(Tenaga pengajar) yang berkompeten di bidangnya. Guru disekolah ini juga dapat\r\nmerangkul dan mendampingi siswa/siswi dengan menggunkan sistem pembelajaran\r\nyang menarik dan mudah dimengerti oleh siswa/siswi seperti misalnya system\r\npembelajaran 70% Praktek dan 30% Teori sehingga siswa/siswi tertarik untuk\r\nbelajar dan dapat menguasai pelajaran sesuai dengan keahlian serta kompetensi\r\nmasing-masing.&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Lokasi SMK HIA berada dikawasan lingkungan yang\r\nsangat bagus dan cocok untuk mendukung proses belajar mengajar, dimana kondisi\r\nyang sangat asri dan sejuk serta banyak pepohonan dan jauh dari bisingnya\r\nkeramaian namun tetap dapat dijangakau karena tidak jauh dari kota sangat\r\nmendukung untuk konsentrasi belajar. Selain itu kegiatan ekstrakurikuler\r\nsiswa/siswi di sekolah ini juga beragam, hal ini berguna untuk menambah wawasan\r\nsiswa/siswi agar menjadi aktif dan kreatif.&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Syarat pendaftaran disekolah ini sama seperti\r\nsyarat sekolah SMK/SMA pada umumnya. Yang membedakannya ialah\r\nkemudahan-kemudahan yang dapat diperoleh oleh calon siswa/siswi baru yaitu bagi\r\nsiswa/siswi yang dapat menghafal Al-Qur&rsquo;an minimal 1 Juz tidak akan dibebani\r\nbiaya pembangunan dan bagi siswa/siswi yatim, piatu dan yatim piatu akan\r\ndiberikan keringanan membayar SPP hanya setengah. Bagaimana? Apakah anda\r\ntertarik untuk masuk belajar dan menjadi bagian dari keluarga besar SMK HIA?\r\nAyo kunjungi sekolah kami yang beralamatkan Jln.Blang Jorong-Pondok Baru,\r\nLr.M.Ali, Desa Jadi Sepakat, Kecamatan Bandar, Kabupaten Bener Meriah. Tamat\r\ndari SMK HIA Siap Bekerja, Siap Berwirausaha, Dan Siap Melanjutkan. SMK Bisa!&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;text-indent:36.0pt&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/p&gt;','Pendaftaran Sekolah SMK Hidayatul Insani Abadi','','',36294,'1','1','1','1','1','1','1','0','1',1094,'43391967pendaftaran.jpg','2021-05-19 11:03:12','1'),(421112,'smkhidayatulinsaniabadi.sch.id','DAFTARKAN DIRI KE SEKOLAH SMK HIDAYATUL INSANI ABADI','daftarkan-diri-ke-sekolah-smk-hidayatul-insani-abadi','&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-weight: 700;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Arial Black&amp;quot;, &amp;quot;sans-serif&amp;quot;;&quot;&gt;SMK HIA MEMBUKA KEMBALI PENDAFTARAN SISWA BARU TAHUN 2022/2023&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Sekolah Menengah Kejuruan Hidayatul Insani Abadi atau lebih mudah di kenal dengan SMK HIA, kembali membuka pendaftaran penerimaan siswa/siswi baru untuk tahun ajaran 2022/2023. pada tahun ini pendaftaran dibuka mulai bulai Maret sampai dengan bulan Mei 2022. Di tahun-tahun sebelumnya SMK HIA hanya memiliki 2 jurusan utama yaitu TKR (Tekhnik Kendaraan Ringan) dan TB (Tata Busana), namun tahun ini SMK HIA menambah 1 jurusan baru yaitu jurusan Multimedia.&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Kepala sekolah SMK HIA Ibu Turi Hudayani Abadi mengatakan &lsquo;&rsquo;Kami siap membimbing dan membentuk siswa/siswi untuk menjadi pribadi yang bertakwa, unggul dalam prestasi dan mandiri sesuai dengan visi sekolah kami&rsquo;&rsquo;. Selain itu Ibu Turi juga menjelaskan bahwa keluarga besar SMK HIA siap membantu calon siswa/siswi baru untuk mengasah keahlian didalam pembelajaran baik secara teori maupun praktek.&amp;nbsp;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;SMK HIA merupakan sekolah yang memiliki guru (Tenaga pengajar) yang berkompeten di bidangnya. Guru disekolah ini juga dapat merangkul dan mendampingi siswa/siswi dengan menggunkan sistem pembelajaran yang menarik dan mudah dimengerti oleh siswa/siswi seperti misalnya system pembelajaran 70% Praktek dan 30% Teori sehingga siswa/siswi tertarik untuk belajar dan dapat menguasai pelajaran sesuai dengan keahlian serta kompetensi masing-masing.&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Lokasi SMK HIA berada dikawasan lingkungan yang sangat bagus dan cocok untuk mendukung proses belajar mengajar, dimana kondisi yang sangat asri dan sejuk serta banyak pepohonan dan jauh dari bisingnya keramaian namun tetap dapat dijangakau karena tidak jauh dari kota sangat mendukung untuk konsentrasi belajar. Selain itu kegiatan ekstrakurikuler siswa/siswi di sekolah ini juga beragam, hal ini berguna untuk menambah wawasan siswa/siswi agar menjadi aktif dan kreatif.&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;text-indent: 36pt;&quot;&gt;Syarat pendaftaran disekolah ini sama seperti syarat sekolah SMK/SMA pada umumnya. Yang membedakannya ialah kemudahan-kemudahan yang dapat diperoleh oleh calon siswa/siswi baru yaitu bagi siswa/siswi yang dapat menghafal Al-Qur&rsquo;an minimal 1 Juz tidak akan dibebani biaya pembangunan dan bagi siswa/siswi yatim, piatu dan yatim piatu akan diberikan keringanan membayar SPP hanya setengah. Bagaimana? Apakah anda tertarik untuk masuk belajar dan menjadi bagian dari keluarga besar SMK HIA? Ayo kunjungi sekolah kami yang beralamatkan Jln.Blang Jorong-Pondok Baru, Lr.M.Ali, Desa Jadi Sepakat, Kecamatan Bandar, Kabupaten Bener Meriah. Tamat dari SMK HIA Siap Bekerja, Siap Berwirausaha, Dan Siap Melanjutkan. SMK Bisa!&lt;/span&gt;&lt;/p&gt;','PPDB SMK HIA','','',36294,'1','1','1','1','1','1','1','0','1',366,'61087422PPDBdewi.jpg','2022-01-28 13:23:23','1'),(420504,'smkhidayatulinsaniabadi.sch.id','Lowongan kerja SMK HIDAYATUL INSANI ABADI','lowongan-kerja-smk-hidayatul-insani-abadi','&lt;b&gt;Dibutuhkan&lt;/b&gt; tenaga kerja guru Teknik Kendaraan Ringan Otomotif (TKRO), bagi yang sedang mencari pekerjaan bisa langsung datang ke alamat Jl. Blang Jorong-Pondok Baru, Lr.M.Ali, Desa.Jadi Sepakat, Kec. Bandar, Kab. Bener Meriah Aceh. Bagi yang berminat bisa melengkapi beberapa persyaratan yaitu :&lt;div&gt;&lt;br&gt;&lt;div&gt;1. Minimal Lulusan D-3.&lt;/div&gt;&lt;div&gt;2. Memahami Dunia Otomotif.&lt;/div&gt;&lt;div&gt;3. Fotokopi Ijazah Terakhir dan Ijazah SMA/SMK.&lt;/div&gt;&lt;div&gt;4. CV.&lt;/div&gt;&lt;div&gt;5. Fotokopi Kartu Keluarga (KK) dan Kartu Tanda Pengenal ( KTP ).&lt;/div&gt;&lt;div&gt;6. Sertifikat Pendukung.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;','lowongan pekerjaan','','',36294,'1','1','1','1','1','1','1','0','1',455,'','2022-01-06 10:55:42','1'),(153001,'smkhidayatulinsaniabadi.sch.id','Mari bergabung dengan SMK HIA','mari-bergabung-dengan-smk-hia','&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Sekolah Menengah Kejuruan\r\nHidayatul Insani Abadi atau lebih mudah di kenal dengan SMK HIA, kembali membuka\r\npendaftaran penerimaan siswa/siswi baru untuk tahun ajaran 2021/2022. pada\r\ntahun ini pendaftaran dibuka mulai bulai Maret sampai dengan bulan Mei 2021. Di\r\ntahun-tahun sebelumnya SMK HIA hanya memiliki 2 jurusan utama yaitu TKR\r\n(Tekhnik Kendaraan Ringan) dan TB (Tata Busana), namun tahun ini SMK HIA\r\nmenambah 1 jurusan baru yaitu jurusan Multimedia.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Kepala sekolah SMK HIA Ibu Turi\r\nHudayani Abadi mengatakan &lsquo;&rsquo;Kami siap membimbing dan membentuk siswa/siswi\r\nuntuk menjadi pribadi yang bertakwa, unggul dalam prestasi dan mandiri sesuai\r\ndengan visi sekolah kami&rsquo;&rsquo;. Selain itu Ibu Turi juga menjelaskan bahwa keluarga\r\nbesar SMK HIA siap membantu calon siswa/siswi baru untuk mengasah keahlian\r\ndidalam pembelajaran baik secara teori maupun praktek.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;SMK HIA merupakan sekolah yang\r\nmemiliki guru (Tenaga pengajar) yang berkompeten di bidangnya. Guru disekolah\r\nini juga dapat merangkul dan mendampingi siswa/siswi dengan menggunkan sistem\r\npembelajaran yang menarik dan mudah dimengerti oleh siswa/siswi seperti\r\nmisalnya system pembelajaran 70% Praktek dan 30% Teori sehingga siswa/siswi tertarik\r\nuntuk belajar dan dapat menguasai pelajaran sesuai dengan keahlian serta\r\nkompetensi masing-masing. &lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Lokasi SMK HIA berada dikawasan\r\nlingkungan yang sangat bagus dan cocok untuk mendukung proses belajar mengajar,\r\ndimana kondisi yang sangat asri dan sejuk serta banyak pepohonan dan jauh dari\r\nbisingnya keramaian namun tetap dapat dijangakau karena tidak jauh dari kota\r\nsangat mendukung untuk konsentrasi belajar. Selain itu kegiatan ekstrakurikuler\r\nsiswa/siswi di sekolah ini juga beragam, hal ini berguna untuk menambah wawasan\r\nsiswa/siswi agar menjadi aktif dan kreatif.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Syarat pendaftaran disekolah ini\r\nsama seperti syarat sekolah SMK/SMA pada umumnya. Yang membedakannya ialah\r\nkemudahan-kemudahan yang dapat diperoleh oleh calon siswa/siswi baru yaitu bagi\r\nsiswa/siswi yang dapat menghafal Al-Qur&rsquo;an minimal 1 Juz tidak akan dibebani\r\nbiaya pembangunan dan bagi siswa/siswi yatim, piatu dan yatim piatu akan\r\ndiberikan keringanan membayar SPP hanya setengah. Bagaimana? Apakah anda\r\ntertarik untuk masuk belajar dan menjadi bagian dari keluarga besar SMK HIA?\r\nAyo kunjungi sekolah kami yang beralamatkan Jln.Blang Jorong-Pondok Baru,\r\nLr.M.Ali, Desa Jadi Sepakat, Kecamatan Bandar, Kabupaten Bener Meriah. Tamat\r\ndari SMK HIA Siap Bekerja, Siap Berwirausaha, Dan Siap Melanjutkan. SMK Bisa!&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/p&gt;','Artikel SMK HIA ','','',36294,'1','1','1','1','1','1','1','0','1',657,'38368866smkhia.jpg','2021-05-19 11:45:39','1'),(428367,'smkhidayatulinsaniabadi.sch.id','MEMBUKA PENDAFTARAN TAHUN AJARAN 2022/2023','membuka-pendaftaran-tahun-ajaran-20222023','Silahkan isi link berikut untuk mendaftarkan diri kamu secara oline&lt;div&gt;https://forms.gle/jfMJpzdjLEVipRiD6&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;','daftar di smk hia','','',36294,'1','1','1','1','1','1','1','0','1',241,'3229539joinourscholl_page-0001.jpg','2022-11-24 12:03:56','1'),(150941,'smkhidayatulinsaniabadi.sch.id','Menerapkan Disiplin di Sekolah','menerapkan-disiplin-di-sekolah','Disiplin merupakan suatu kegiatan yang dilakukan agar tidak melanggar peraturan yang berlaku demi terciptanya suatu tujuan. Disiplin tidak hanya dilakukan di rumah tapi disiplin juga bisa dilakukan di sekolah. Dengan adanya disiplin di sekolah murid-murid akan melakukan segala sesuatu dengan tertib dan teratur sehingga tercapainya impian dan tujuan dalam hidup.&lt;br&gt;&lt;br&gt;\r\n							Kegiatan sekolah merupakan salah satu bentuk dari disiplin seperti guru maupun murid berperilaku sopan santun, bahasa yang baik dan benar. Dan murid menerima teguran atau hukuman yang adil. Serta guru dan murid bekerjasama dalam membangun, memelihara dan memperbaiki aturan-aturan dan norma-norma.','demo, artikel',',36295,','',36295,'1','0','1','1','0','0','0','0','0',690,'42247723kkkkkk.jpeg','2021-03-19 11:00:19','1'),(421102,'smkhidayatulinsaniabadi.sch.id','PPBD SMK Hidayatul Insani Abadi','ppbd-smk-hidayatul-insani-abadi','&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Salam sekolah para juara&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Menjelang tahun ajaran baru,\r\npemerintah selalu mengeluarkan &amp;nbsp;kebijakan terkait penerimaan peserta didik\r\nbaru (PPDB). Pada tahun 2022/2023 ini, penerimaan peserta didik baru akan\r\nsegera dilaksanakan.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Menjadi tanya untuk warga\r\nbagaimana penerimaan peserta didik baru (PPDB) di SMK Hidayatul Insani Abadi?&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Saat ditanya bagaimana\r\npelaksanaan penerimaan peserta didik baru di SMK Hidayatul Insani Abadi kami\r\nmenjelaskan bahwa &ldquo; PPDB di SMK Hidayatul Insani Abadi ini &amp;nbsp;di lakukan\r\nsecara tatap muka dan menggunakan media sosial (WA) untuk pendaftaran sedangkan\r\nuntuk mengumpulkan persyaratan pendaftaran, siswa harus datang ke sekolah &rdquo;&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNoSpacing&quot; style=&quot;text-align:justify&quot;&gt;Bagi kamu yang memiliki bakat\r\ndibidang seni, olahraga atau akademik, kamu bakal diasah kemampuannya melalui\r\nberbagai macam ekstrakulikuler yang ada disekolah kita.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Berdiri sejak tahun 2016 SMK\r\nHidayatul Insani Abadi punya beberapa jurusan antara lain MULTIMEDIA, TATA\r\nBUSANA, dan TKRO. Kamu bisa pilih jurusan mana yang kamu sukai.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;\r\n\r\n&lt;p class=&quot;MsoNormal&quot; style=&quot;text-align:justify&quot;&gt;Yuk ajak teman, tetangga, kerabat\r\ndan keluarga bergabung bersama SMK Hidayatul Insani Abadi.&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;','PPDB','','',36294,'1','1','1','1','1','1','1','0','1',479,'96250276PPDBZhara.jpg','2022-01-28 10:03:31','1'),(154361,'smkhidayatulinsaniabadi.sch.id','SMK Hidayatul Insani ','smk-hidayatul-insani-','&lt;p class=&quot;MsoNormal&quot; align=&quot;center&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;\r\ntext-align:center;line-height:150%;mso-layout-grid-align:none;text-autospace:\r\nnone&quot;&gt;&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi;color:#3C2415&quot;&gt;PELAJAR SMK&amp;nbsp;\r\nHIDAYATUL INSANI ABADI&amp;nbsp; BERINOVASI&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi;color:#3C2415&quot;&gt;Siapa bilang siswa perempuan &lt;b&gt;GAGAP &lt;/b&gt;teknologi? &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi;color:#3C2415&quot;&gt;Kata siapa siswa perempuan &lt;b&gt;TIDAK BISA &lt;/b&gt;berinovasi?&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;Dua&amp;nbsp; belas pelajar&amp;nbsp; tata&amp;nbsp;\r\nbusana SMK&amp;nbsp; Hidayatul&amp;nbsp; Insani&amp;nbsp;\r\nAbadi&amp;nbsp; yang terbagi menjadi tiga\r\ntim berhasil membuktikan bahwa perempuan juga bisa berinovasi dengan\r\nmengembangkan tiga Proyek Inovasi Berbasis&amp;nbsp;\r\n&lt;i&gt;Internet of Things.&amp;nbsp; &lt;o:p&gt;&lt;/o:p&gt;&lt;/i&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;Inovasi tersebut diantaranya &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;&amp;nbsp;&lt;b&gt;&lt;i&gt;&ldquo;sistem cerdas\r\npendeteksi&amp;nbsp; Gerak Jarum&amp;nbsp; Mesin Jahit menggunakan&amp;nbsp; perangkat&amp;nbsp;\r\nhalocode&lt;/i&gt;&lt;/b&gt;&rdquo;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;&ldquo;&lt;b&gt;&lt;i&gt;pemilihan warna kain yang akan dijahit&amp;nbsp; menggunakan halocode&amp;nbsp; dengan&amp;nbsp;\r\nanimasi&amp;nbsp; simulasi&lt;/i&gt;&lt;/b&gt;&rdquo;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;&ldquo;Teknologi&amp;nbsp; sistem\r\npintar&amp;nbsp; gerbang sekolah&amp;nbsp; menggunakan&amp;nbsp;\r\nhalocode&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;\r\nfont-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;mso-ascii-theme-font:major-bidi;\r\nmso-hansi-theme-font:major-bidi;mso-bidi-theme-font:major-bidi&quot;&gt;&rdquo;&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;Inovasi tersebut tercipta karena&amp;nbsp;\r\nadanya&amp;nbsp; kegiatan &lt;b&gt;Pekan\r\nPerempuan Vokasi Tangkas Inovasi&lt;/b&gt; (&lt;i&gt;Women Innovation Camp 2021).&lt;/i&gt;Kegiatan\r\nini merupakan&amp;nbsp; proyek Kerja Sama\r\nIndonesia- Jerman untuk Penguatan Sistem Pendidikan dan Pelatihan Vokasi (&lt;i&gt;TVET\r\nSystem&lt;/i&gt; &lt;i&gt;Reform&lt;/i&gt;) serta Proyek Global Olah Raga untuk Pembangunan (&lt;i&gt;Sport\r\nfor&lt;/i&gt; &lt;i&gt;Development&lt;/i&gt;) bekerja sama dengan Axioo Class Program dan\r\nMakeblock Makers Academy yang bertujuan untuk memperkenalkan konsep &lt;i&gt;design&lt;/i&gt;&lt;b&gt;\r\n&lt;/b&gt;&lt;i&gt;thinking &lt;/i&gt;dan inovasi dengan&amp;nbsp;\r\npemanfaatan&amp;nbsp; Halocode sebagai&amp;nbsp; system pengendalinya kepada para siswa\r\nperempuan di beberapa lembaga vokasi&lt;b&gt;&amp;nbsp; &lt;/b&gt;SMK\r\ndi Provinsi Aceh.&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:\r\n12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;mso-ascii-theme-font:\r\nmajor-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:major-bidi&quot;&gt;&ldquo;Alhamdulilah,&amp;nbsp; di &amp;nbsp;masa sulit pandemi, anak didik&amp;nbsp; kami berhasil menembus&amp;nbsp; tiga proyek sekaligus&amp;nbsp; dalam kegiatan &lt;b&gt;Pekan Perempuan Vokasi\r\nTangkas Inovasi&lt;/b&gt; ini,&rdquo;&amp;nbsp; kata Kepala\r\nSekolah SMK Hidayatul Insani Abadi, Turi Hudayani&amp;nbsp; Abadi, selasa (22/06/2021).&lt;/span&gt;&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; align=&quot;center&quot; style=&quot;text-align: justify; margin-bottom: 0.0001pt; line-height: 150%;&quot;&gt;\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n&lt;/p&gt;&lt;p class=&quot;MsoNormal&quot; style=&quot;margin-bottom:0cm;margin-bottom:.0001pt;text-align:\r\njustify;line-height:150%;mso-layout-grid-align:none;text-autospace:none&quot;&gt;&lt;span style=&quot;font-size:12.0pt;line-height:150%;font-family:&amp;quot;Times New Roman&amp;quot;,&amp;quot;serif&amp;quot;;\r\nmso-ascii-theme-font:major-bidi;mso-hansi-theme-font:major-bidi;mso-bidi-theme-font:\r\nmajor-bidi&quot;&gt;Turi Hudayani Abadi&amp;nbsp; menilai,\r\nprestasi&amp;nbsp; ini&amp;nbsp; merupakan inovasi dengan&amp;nbsp; perjuangan berat. Karena&amp;nbsp; dimasa pandemi ini&amp;nbsp; harus&amp;nbsp;\r\nketat menerapkan protokol kesehatan. Meskipun begitu dengan adanya\r\ninovasi ini dapat meningkatkan kesadaran baik pada siswa maupun manajemen SMK\r\nakan pentingnya partisipasi perempuan pada inovasi.&amp;nbsp; Selain&amp;nbsp;\r\nitu juga dapat meningkatkan &amp;nbsp;&lt;i&gt;soft\r\nskill &lt;/i&gt;(kepemimpinan dan kerja sama) siswa dan guru.&amp;nbsp;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;','sekolah SMK Hidayatul Insani Abadi','','',36295,'1','1','1','1','1','1','1','0','1',741,'82293866kegiatan.jpg','2021-06-28 12:01:28','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `berita_kategori`
--

CREATE TABLE `berita_kategori` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`),
  KEY `judul` (`judul`),
  KEY `link` (`link`)
) ENGINE=MyISAM AUTO_INCREMENT=38506 DEFAULT CHARSET=latin1;




INSERT INTO `berita_kategori` VALUES (36294,'smkhidayatulinsaniabadi.sch.id','Berita','berita','2021-03-19 10:46:47','1'),(36295,'smkhidayatulinsaniabadi.sch.id','Artikel','artikel','2021-03-19 10:46:47','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `buku_tamu`
--

CREATE TABLE `buku_tamu` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `jenis_kelamin` enum('L','P') NOT NULL DEFAULT 'L',
  `telepon` varchar(100) NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `komentar` text NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=1676 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `iduser` varchar(50) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `status` enum('open','closed','answered','reply') NOT NULL DEFAULT 'open',
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1868 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `contact_isi`
--

CREATE TABLE `contact_isi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_contact` varchar(50) NOT NULL,
  `iduser` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=4703 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `exc_profil_sekolah`
--

CREATE TABLE `exc_profil_sekolah` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nama_sekolah` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `jenis_sekolah` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nss` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `npsn` int(11) NOT NULL,
  `tanggal_berdiri` date NOT NULL,
  `akreditasi` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `program_jurusan` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `izin_operasional` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `luas_tanah` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `kurikulum` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `jam_aktif` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `jumlah_guru_staff` int(11) NOT NULL,
  `jumlah_siswa` int(11) NOT NULL,
  `jumlah_rombel` int(11) NOT NULL,
  `jumlah_prestasi` int(11) NOT NULL,
  `slogan_sekolah` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `video_profil` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci NOT NULL,
  `kepsek` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `nip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `masa_kerja` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `izin_memimpin` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status_kepegawaian` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `pendidikan_terakhir` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `tgl` date NOT NULL,
  `publish` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=328 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;




INSERT INTO `exc_profil_sekolah` VALUES (78,'smkhidayatulinsaniabadi.sch.id','smk-hidayatul-insani-abadi','SMK HIDAYATUL INSANI ABADI','SEKOLAH KEJURUAN / VOKASI','',69966704,'0000-00-00','C','Teknik Kendaraan Ringan dan Tata Busana','421.5/DPMPTSP/3055/2022','14.210','Kurikulum Merdeka IKM Merdeka Berbagi','07.30-16.00',18,85,6,30,'SMK HIA BISA HEBAT !!!','','SMK Hidayatul Insani Abadi merupakan sekolah kejuaruan yang memiliki visi membentuk peserta didik yang bertaqwa, unggul dalam prestasi dan mandiri.','Turi Hudayani Abadi','2147483647','14 tahun','22 Juni 2016','PNS','S-1','2023-04-24','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `file`
--

CREATE TABLE `file` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `deskripsi` text NOT NULL,
  `lokasi` enum('in','out') NOT NULL DEFAULT 'in',
  `file` varchar(200) NOT NULL,
  `url` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=11241 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `galeri`
--

CREATE TABLE `galeri` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `id_galeri_kategori` int(11) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=230608 DEFAULT CHARSET=latin1;




INSERT INTO `galeri` VALUES (111899,'smkhidayatulinsaniabadi.sch.id','','',13654,'991956052..jpg','2021-04-11 10:57:12','1'),(111900,'smkhidayatulinsaniabadi.sch.id','desain pola baju','desain-pola-baju',13654,'295783073..jpg','2021-04-11 10:59:54','1'),(120847,'smkhidayatulinsaniabadi.sch.id','hari guru','hari-guru',15600,'','2021-11-23 16:34:07','1'),(111961,'smkhidayatulinsaniabadi.sch.id','kepala sekolah &  siswi tata busana','kepala-sekolah---siswi-tata-busana',0,'41688810IMG-20210410-WA0004.jpg','2021-04-12 08:04:11','1'),(111960,'smkhidayatulinsaniabadi.sch.id','kepala sekolah yang friendly','kepala-sekolah-yang-friendly',13865,'340149432...jpg','2021-04-12 08:01:57','1'),(111959,'smkhidayatulinsaniabadi.sch.id','perlombaan kelas','perlombaan-kelas',13865,'92120073IMG-20210410-WA0017.jpg','2021-04-12 07:59:41','1'),(110758,'smkhidayatulinsaniabadi.sch.id','Perpustakaan','perpustakaan',0,'f1.jpg','2021-03-19 11:00:20','1'),(110817,'smkhidayatulinsaniabadi.sch.id','Praktikum tata busana','praktikum-tata-busana',13654,'93557979praktatabusana.jpg','2021-03-22 09:02:53','1'),(111898,'smkhidayatulinsaniabadi.sch.id','ujian praktik tata busana','ujian-praktik-tata-busana',13654,'49802068(1).jpg','2021-04-11 10:54:04','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `galeri_kategori`
--

CREATE TABLE `galeri_kategori` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=20028 DEFAULT CHARSET=latin1;




INSERT INTO `galeri_kategori` VALUES (15600,'smkhidayatulinsaniabadi.sch.id','HARI GURU','hari-guru','2021-11-23 16:31:07','1'),(13865,'smkhidayatulinsaniabadi.sch.id','JUARA','juara','2021-04-11 10:58:02','1'),(13654,'smkhidayatulinsaniabadi.sch.id','TATA BUSANA','tata-busana','2021-03-22 08:36:15','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `guru`
--

CREATE TABLE `guru` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `link` varchar(50) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `nip` varchar(20) NOT NULL,
  `nuptk` varchar(50) NOT NULL,
  `nrg` varchar(50) NOT NULL,
  `tahun_sertifikasi` year(4) NOT NULL,
  `status` varchar(20) NOT NULL,
  `pendidikan` varchar(75) NOT NULL,
  `pangkat_golongan` varchar(50) NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `mata_pelajaran` varchar(25) NOT NULL,
  `kelamin_jenis` enum('L','P') NOT NULL DEFAULT 'L',
  `agama` varchar(20) NOT NULL,
  `tempat_lahir` varchar(30) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` text NOT NULL,
  `kota` varchar(50) NOT NULL,
  `kodepos` varchar(10) NOT NULL,
  `telepon` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL,
  `whatsapp` varchar(100) NOT NULL,
  `gambar` varchar(50) NOT NULL,
  `tugas_tambahan` varchar(100) NOT NULL,
  `nik` varchar(100) NOT NULL,
  `rt` varchar(50) NOT NULL,
  `rw` varchar(50) NOT NULL,
  `dusun` varchar(100) NOT NULL,
  `desa` varchar(100) NOT NULL,
  `kecamatan` varchar(100) NOT NULL,
  `hp` varchar(50) NOT NULL,
  `jenis_ptk` varchar(100) NOT NULL,
  `umur` varchar(20) NOT NULL,
  `keterangan` varchar(191) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=80977 DEFAULT CHARSET=latin1;




INSERT INTO `guru` VALUES (62890,'smkhidayatulinsaniabadi.sch.id','masitah-spd','Masitah, S.Pd','-','-','-',0000,'Guru','S1','','Guru Mapel','Matematika','P','Islam','Pondok Baru','1998-05-15','Mutiara','Bener Meriah','24582','085358109797','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62889,'smkhidayatulinsaniabadi.sch.id','amelia-andini','Amelia Andini','','','',0000,'Guru','SMK','','Guru Mapel','Kejuruan Tata Busana','P','Islam','pondok sayur','0000-00-00','Selamat Rejo','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62888,'smkhidayatulinsaniabadi.sch.id','kumala-sari','Kumala Sari','','','',0000,'Guru','S1','','Guru Mapel','Kejuruan Tata Busana','P','Islam','Belang Pulo','0000-00-00','Belang Kucak','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62887,'smkhidayatulinsaniabadi.sch.id','maulinda-sari-sn','Maulinda Sari, S.Sn','','','',0000,'Guru','S1','','Guru Mapel','Seni Budaya','P','Islam','Simpanng balik','0000-00-00','','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62886,'smkhidayatulinsaniabadi.sch.id','yusrijal-spd','Yusrijal, S.Pd','','','',0000,'Guru','S1','','Guru Mapel','Sejarah','L','Islam','Takengon','0000-00-00','Purwosari','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62885,'smkhidayatulinsaniabadi.sch.id','yanti-sri-wahyuni-spd','Yanti Sri Wahyuni, S.Pd','','','',0000,'Guru','S1','','Kesiswaan','Bimbingan Konseling','P','Islam','Aceh Tengah','0000-00-00','Mutiara','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62883,'smkhidayatulinsaniabadi.sch.id','susilawati-spd','Susilawati, S.Pd','','','',0000,'Guru','S1','','Wali Kelas','Matematika','P','Islam','Kelupak Mata','0000-00-00','Pondok Baru','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62882,'smkhidayatulinsaniabadi.sch.id','suhartik-spd','Suhartik, S.Pd','','','',0000,'Guru','S1','','Wali Kelas','Bahasa Inggris','P','Islam','Blang Paku','0000-00-00','Selisih Mara','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62881,'smkhidayatulinsaniabadi.sch.id','solehati-spd','Solehati, S.Pd','','','',0000,'Guru','S1','','Wali Kelas','Olahraga','P','Islam','Selamat Rejo','0000-00-00','Purwosari','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62880,'smkhidayatulinsaniabadi.sch.id','nuti-asrianti-spdi','Nuti Asrianti, S.Pd.I','','','',0000,'Guru','S1','','Wali Kelas','Agama','P','Islam','Lampahan','0000-00-00','Mupakat Jadi','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62877,'smkhidayatulinsaniabadi.sch.id','irmansyah-s-mat','Irmansyah, S. Mat','','','',0000,'Guru','S1','','Wali Kelas','Matematika','L','Islam','Kung','0000-00-00','Kung','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62876,'smkhidayatulinsaniabadi.sch.id','hamdani-st','Hamdani, ST','','','',0000,'Guru','S1','','Guru Mapel','Simulasi Digital','L','Islam','Janarata','0000-00-00','','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62875,'smkhidayatulinsaniabadi.sch.id','hafizd-st','Hafizd, ST','-','-','-',0000,'Guru','S1','','Ketua Jurusan TKRO','Kejuruan TKRO','L','Islam','Pangkalan Kerinci','1996-11-19','Simpang Teritit','Bener Meriah','24582','082161926893','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62874,'smkhidayatulinsaniabadi.sch.id','esi-holinda-sari-skom','Esi Holinda Sari, S.Kom','','','',0000,'Guru','S1','','Waka Humas','Informatika','P','Islam','Selisih Mara','1998-03-10','Selisih Mara','Bener Meriah','24582','082295298713','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62873,'smkhidayatulinsaniabadi.sch.id','dila-yulia-spd','Dila Yulia, S.Pd','','1044763663300013','',2019,'Guru','S1','','Waka Kurikulum','Bahasa Indonesia','P','Islam','Matur','0000-00-00','Bale Atu','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62872,'smkhidayatulinsaniabadi.sch.id','beti-nanda-sarisi','Beti Nanda Sari,S.Si','','','',0000,'Guru','S1','','Guru Mapel','Kimia','P','Islam','Cemparam Jaya','0000-00-00','Purwosari','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62871,'smkhidayatulinsaniabadi.sch.id','amilia-pitri-sh','Amilia Pitri, SH','','','',0000,'Guru','S1','','Wali Kelas','PKN','P','Islam','Pondok Baru','1996-11-06','Gunung Teritit','Bener Meriah','24582','','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1'),(62870,'smkhidayatulinsaniabadi.sch.id','turi-hudayni-abadisi','Turi Hudayni Abadi,S.Si','19810618 200904 2 00','2950759661220002','',0000,'Guru','S1','PENATA IIIc','Kepala','','P','Islam','Takengon','0000-00-00','Tingkem','Bener Meriah','24582','082296126349','','','','','','','','','','','','','','','','','2021-06-09 09:46:43','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `halaman`
--

CREATE TABLE `halaman` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `tipe` varchar(100) NOT NULL,
  `idtipe` int(11) NOT NULL,
  `isi` longtext NOT NULL,
  `kata_kunci` text NOT NULL,
  `tampilkan_judul` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_isi` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_gambar` enum('1','0') NOT NULL DEFAULT '1',
  `tampilkan_tanggal` enum('1','0') NOT NULL,
  `tampilkan_komentar` enum('1','0') NOT NULL,
  `tampilkan_formulir` enum('1','0') NOT NULL,
  `tampilkan_pembaca` enum('1','0') NOT NULL,
  `tampilkan_katakunci` enum('1','0') NOT NULL,
  `tampilkan_berbagi` enum('1','0') NOT NULL,
  `jumlah_pembaca` int(11) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `urutan` int(11) NOT NULL,
  `uphalaman` int(11) NOT NULL,
  `subhalaman` enum('0','1') NOT NULL,
  `checked` tinyint(1) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=871056 DEFAULT CHARSET=latin1;




INSERT INTO `halaman` VALUES (326871,'smkhidayatulinsaniabadi.sch.id','Artikel Sekolah SMK Hidayatul Insani Abadi','artikel-sekolah-smk-hidayatul-insani-abadi','berita_kategori',36295,'','','1','1','1','0','0','0','0','0','0',0,'',10,324039,'0',0,'2021-06-11 11:05:10','1'),(324049,'smkhidayatulinsaniabadi.sch.id','Ekstrakurikuler','ekstrakurikuler','tulis',0,'<p>Kegiatan ekstrakurikuler merupakan salah satu alat pengenalan siswa pada hubungan sosial. Di dalamnya terdapat pendidikan pengenalan diri dan pengembangan kemampuan selain pemahaman materi pelajaran.</p>\r\n							<p>Selain OSIS sebagai induk kegiatan ektrakurikuler di sekolah, kegiatan ektrakurikuler lainnya adalah:</p>\r\n							<ul>\r\n								<li>Pramuka</li>\r\n								<li>Paskibra</li>\r\n								<li>Palang Merah Remaja (PMR)</li>\r\n								<li>Patroli Keamanan Sekolah (PKS)</li>\r\n								<li>Pecinta Alam (PA)</li>\r\n							</ul>',' ekstrakurikuler','1','1','1','0','0','0','0','0','0',43,'19004053WhatsAppImage2021-04-10at19.02.48.jpeg',2,324040,'0',0,'2021-04-11 10:46:33','1'),(325438,'smkhidayatulinsaniabadi.sch.id','FOTO','foto','galeri',0,'','','1','1','1','0','0','0','0','0','0',0,'',10,0,'0',0,'2021-04-11 10:45:00','1'),(324048,'smkhidayatulinsaniabadi.sch.id','Osis','osis','tulis',0,'-',' struktur osis','1','1','1','0','0','0','0','0','0',43,'',1,324040,'0',0,'2021-03-23 11:18:44','1'),(324050,'smkhidayatulinsaniabadi.sch.id','Pendaftaran','pendaftaran','tulis',0,'<br>',' pendaftaran siswa baru SMK hia','1','1','1','0','0','0','0','0','0',47,'59396905PENERIMAANSISWABARU.JPG',1,324041,'0',0,'2021-04-11 10:34:19','1'),(324039,'smkhidayatulinsaniabadi.sch.id','Profil','profil','tulis',0,'Nama Sekolah : SMK HIDAYATUL INSANI ABADI<div>NPSN : 69966704</div><div>Kurikulum yang diampu : Kurikulum Merdeka</div><div>Alamat Sekolah : JL. Blang Jorong-Pondok Baru, Desa Jadi Sepakat, Kec. Bandar, Kab. Bener Meriah</div><div>Kode Pos : 24582</div><div>Email : SMKhidayatulinsaniabadi@gmail.com</div><div>Instagram: SMK Hidayatul Insani Abadi</div><div>Tahun Berdiri : 2016</div><div>Kepala Sekolah :</div><div>a. Nama : Turi Hudayani Abadi, S.Si</div><div>b. Nip : 19810618 200904 2 007</div><div>c. Pangkat : Penata, III/c</div><div>d. TMT Kasek : 22/06/2016</div><div>e. Berdasarkan Surat : YAYASAN HIDAYATUL INSANI ABADI</div><div>f. Nomor Surat pengangkatan Kasek : 02/SK/YHIA/BM/2016</div><div>g. Tanggal Surat Pengangkatan Kasek : 22 Juni 2016</div><div>Jumlah Guru : 16 Orang</div><div>Jumlah Laboran : 2 Orang</div><div>Jumlah Tata Usaha : 6 Orang</div><div>Jumlah Penjaga Sekolah : 1 Orang</div><div>pendaftaran online:&nbsp;</div><div>https://forms.gle/uq8Qn1zqk5j3Ve457</div>','profil, SMK HIA, Profil SMK HIA','1','1','1','0','0','0','0','0','0',449,'47727125PAMPLETYHIA(2).JPG',2,0,'1',0,'2022-11-10 14:32:09','1'),(324046,'smkhidayatulinsaniabadi.sch.id','Sejarah','sejarah','tulis',0,'<h6><font face=\"times new roman\" size=\"4\">SMK Hidayatul insani Abdi berdiri sejak tanggal 24 Februari tahun 2016. <span style=\"text-align: center;\">Jl. Blang Jorong – Pondok Baru, Kec. Bandar, Kab. Bener\r\nMeriah Desa Jadi Sepakat.</span>&nbsp;Status kepemilikan sekolah ini adalah Yayasan.&nbsp;</font></h6>',' sejarah SMK HIA','1','1','1','0','0','0','0','0','0',364,'19306584logosmk.jpg',1,324039,'0',0,'2021-03-22 16:27:01','1'),(396628,'smkhidayatulinsaniabadi.sch.id','VOKASI SMK HIDAYATUL INSANI ABADI','vokasi-smk-hidayatul-insani-abadi','link',0,'','','1','1','1','0','0','0','0','0','0',0,'',10,0,'0',0,'2022-01-18 09:00:49','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `halamantipe`
--

CREATE TABLE `halamantipe` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `tipe` varchar(50) NOT NULL,
  `kategori` varchar(50) NOT NULL,
  `folder` varchar(100) NOT NULL,
  `deskripsi` text NOT NULL,
  `subdomain` varchar(50) NOT NULL,
  `paket` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  `active` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `judul` (`judul`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `html`
--

CREATE TABLE `html` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_module` int(11) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `kode_html` text NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=6182 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `kalender`
--

CREATE TABLE `kalender` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `isi` text NOT NULL,
  `tempat_kegiatan` varchar(100) NOT NULL,
  `tanggal_mulai` date NOT NULL,
  `tanggal_selesai` date NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=6022 DEFAULT CHARSET=latin1;




INSERT INTO `kalender` VALUES (4342,'smkhidayatulinsaniabadi.sch.id','Kalender Pendidikan','Kalender-Pendidikan','Tahun ajaran 2021/2022','Sekolah','2021-07-15','2022-07-18','2021-05-19 11:53:14','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `kelas`
--

CREATE TABLE `kelas` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `jurusan` varchar(50) NOT NULL,
  `wali_kelas` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=14677 DEFAULT CHARSET=latin1;




INSERT INTO `kelas` VALUES (12364,'smkhidayatulinsaniabadi.sch.id','X TB 2022/2023','x-tb-20222023','Tata Busana','Yusrijal,S.pd','2022-11-03 12:39:15','1'),(12368,'smkhidayatulinsaniabadi.sch.id','XI TB','xi-tb','Tata Busana ','Yanti Sri Wahyuni,S.Pd','2022-11-03 12:44:39','1'),(12363,'smkhidayatulinsaniabadi.sch.id','XI TKR','xi-tkr','Teknik Kendaraan Ringan','SOLEHATI, S. Pd','2022-11-03 12:38:55','1'),(12366,'smkhidayatulinsaniabadi.sch.id','XII TB 2022/2023','xii-tb-20222023','Tata Busana','Rahmat Hidayat, S.Pd','2022-11-03 12:41:15','1'),(12365,'smkhidayatulinsaniabadi.sch.id','XII TKR 2022/2023','xii-tkr-20222023','TKR','SUHARTIK','2022-11-03 12:39:41','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `kode_tambahan`
--

CREATE TABLE `kode_tambahan` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `kode_html` text NOT NULL,
  `shared` enum('0','1') NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=1991 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `komentar`
--

CREATE TABLE `komentar` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_halaman` int(11) NOT NULL,
  `id_berita` int(11) NOT NULL,
  `no_komentar` int(11) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `komentar` text NOT NULL,
  `admin` text NOT NULL,
  `balas` enum('0','1') NOT NULL,
  `tgl` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=130708 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `konsultasi`
--

CREATE TABLE `konsultasi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_konsultasipengasuh` int(11) NOT NULL,
  `penanya` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `pertanyaan` text NOT NULL,
  `jawaban` text NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=195 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `konsultasipengasuh`
--

CREATE TABLE `konsultasipengasuh` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `instansi` varchar(200) NOT NULL,
  `topik` varchar(50) NOT NULL,
  `gambar` varchar(255) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=160 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_module` int(11) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `url` varchar(200) NOT NULL,
  `target` enum('_parent','_blank') NOT NULL DEFAULT '_parent',
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=16454 DEFAULT CHARSET=latin1;




INSERT INTO `link` VALUES (8823,'smkhidayatulinsaniabadi.sch.id',183234,'instagram','instagram','https://instagram.com/smk_hia_official?gshid=1guxjzsxy6stt','_blank','2021-04-11 11:25:05','1'),(14430,'smkhidayatulinsaniabadi.sch.id',183236,'DAFTARKAN DIRI KE SEKOLAH SMK HIDAYATUL INSANI ABADI','daftarkan-diri-ke-sekolah-smk-hidayatul-insani-abadi','https://forms.gle/jfMJpzdjLEVipRiD6','_blank','2022-11-24 12:05:40','1'),(14429,'smkhidayatulinsaniabadi.sch.id',183236,'DAFTARKAN DIRI KE SEKOLAH SMK HIDAYATUL INSANI ABADI','daftarkan-diri-ke-sekolah-smk-hidayatul-insani-abadi','https://forms.gle/jfMJpzdjLEVipRiD6','_blank','2022-11-24 12:05:09','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `mading`
--

CREATE TABLE `mading` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `id_mading_kategori` int(11) NOT NULL,
  `gambar` varchar(255) NOT NULL,
  `author` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=1703 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `mading_kategori`
--

CREATE TABLE `mading_kategori` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=810 DEFAULT CHARSET=latin1;




INSERT INTO `mading_kategori` VALUES (306,'smkhidayatulinsaniabadi.sch.id','Mading SMK Hidayatul Insani','mading-smk-hidayatul-insani','2021-07-28 09:05:12','1'),(307,'smkhidayatulinsaniabadi.sch.id','Kegiatan IoT Vokasi Perempuan','kegiatan-iot-vokasi-perempuan','2021-07-28 09:05:59','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `matapelajaran`
--

CREATE TABLE `matapelajaran` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=17170 DEFAULT CHARSET=latin1;




INSERT INTO `matapelajaran` VALUES (15808,'smkhidayatulinsaniabadi.sch.id','BAHASA INDONESIA ','bahasa-indonesia-','2022-11-03 12:44:52','1'),(15809,'smkhidayatulinsaniabadi.sch.id','BAHASA INGGRIS','bahasa-inggris','2022-11-03 12:45:05','1'),(15812,'smkhidayatulinsaniabadi.sch.id','IPAS','ipas','2022-11-03 12:47:08','1'),(15805,'smkhidayatulinsaniabadi.sch.id','MATEMATIKA X','matematika-x','2022-11-03 12:32:48','1'),(15806,'smkhidayatulinsaniabadi.sch.id','MATEMATIKA XI','matematika-xi','2022-11-03 12:44:05','1'),(15807,'smkhidayatulinsaniabadi.sch.id','MATEMATIKA XII','matematika-xii','2022-11-03 12:44:23','1'),(15810,'smkhidayatulinsaniabadi.sch.id','PENDIDIKAN AGAMA ISLAM','pendidikan-agama-islam','2022-11-03 12:45:29','1'),(15811,'smkhidayatulinsaniabadi.sch.id','SEJARAH','sejarah','2022-11-03 12:45:59','1'),(11036,'smkhidayatulinsaniabadi.sch.id','TEKNIK MESIN','teknik-mesin','2021-03-20 15:26:43','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `materi`
--

CREATE TABLE `materi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `link` varchar(100) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `no_matapelajaran` int(11) NOT NULL,
  `semester` int(11) NOT NULL,
  `kelas` varchar(50) NOT NULL,
  `tahun_ajaran` varchar(50) NOT NULL,
  `file` varchar(200) NOT NULL,
  `download` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=3993 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `posisi` varchar(50) NOT NULL,
  `tipe` varchar(50) NOT NULL,
  `idtipe` int(11) NOT NULL,
  `tampilan_tipe` varchar(100) NOT NULL,
  `tampilkan_judul` enum('1','0') NOT NULL DEFAULT '1',
  `hal` enum('semua','home') NOT NULL DEFAULT 'semua',
  `style` text NOT NULL,
  `urutan` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=633935 DEFAULT CHARSET=latin1;




INSERT INTO `module` VALUES (183232,'smkhidayatulinsaniabadi.sch.id','Artikel','artikel','main','berita_terbaru_kategori',36295,'','1','home','',4,'2021-03-19 11:00:19','1'),(183236,'smkhidayatulinsaniabadi.sch.id','Banner','banner','side','banner',0,'','1','semua','',4,'2021-03-19 11:00:19','1'),(183231,'smkhidayatulinsaniabadi.sch.id','Berita','berita','main','berita_terbaru_kategori',36294,'','1','home','',3,'2021-03-19 11:00:19','1'),(183235,'smkhidayatulinsaniabadi.sch.id','Berita Terbaru','berita-terbaru','side','berita_terbaru',0,'','1','semua','',3,'2021-03-19 11:00:19','1'),(183233,'smkhidayatulinsaniabadi.sch.id','Galeri','galeri','main','galeri',0,'','','home','',5,'2021-03-19 11:00:19','1'),(183234,'smkhidayatulinsaniabadi.sch.id','Kontak','kontak','side','kontak',0,'','1','semua','',1,'2021-03-19 11:00:19','1'),(183229,'smkhidayatulinsaniabadi.sch.id','Konten','konten','main','konten',0,'','1','semua','',1,'2021-03-19 11:00:19','1'),(183230,'smkhidayatulinsaniabadi.sch.id','Sambutan Kepala Sekolah','sambutan','main','sambutan',0,'','1','home','',2,'2021-03-19 11:00:19','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `moduletipe`
--

CREATE TABLE `moduletipe` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `id_modulekategori` int(11) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `tipe` varchar(50) NOT NULL,
  `kategori` enum('basic','addon','paket') NOT NULL DEFAULT 'basic',
  `subdomain` varchar(50) NOT NULL,
  `paket` varchar(200) NOT NULL,
  `deskripsi` text NOT NULL,
  `posisi` varchar(50) NOT NULL,
  `folder` varchar(100) NOT NULL,
  `tampilan_tipe` varchar(100) NOT NULL,
  `relasi_tabel` varchar(50) NOT NULL,
  `relasi` enum('2','1','0') NOT NULL,
  `kolom` varchar(50) NOT NULL,
  `jenis_file` varchar(50) NOT NULL,
  `lanjut` enum('1','0') NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `id_modulekategori` (`id_modulekategori`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `polling`
--

CREATE TABLE `polling` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `jawaban_1` varchar(50) NOT NULL,
  `hasil_1` int(11) NOT NULL,
  `jawaban_2` varchar(50) NOT NULL,
  `hasil_2` int(11) NOT NULL,
  `jawaban_3` varchar(50) NOT NULL,
  `hasil_3` int(11) NOT NULL,
  `jawaban_4` varchar(50) NOT NULL,
  `hasil_4` int(11) NOT NULL,
  `jawaban_5` varchar(50) NOT NULL,
  `hasil_5` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=6149 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `profil_sekolah`
--

CREATE TABLE `profil_sekolah` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nama_sekolah` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `jenis_sekolah` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nss` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `npsn` int(11) NOT NULL,
  `tanggal_berdiri` date NOT NULL,
  `akreditasi` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `program_jurusan` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `izin_operasional` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `luas_tanah` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `kurikulum` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `jam_aktif` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `jumlah_guru_staff` int(11) NOT NULL,
  `jumlah_siswa` int(11) NOT NULL,
  `jumlah_rombel` int(11) NOT NULL,
  `jumlah_prestasi` int(11) NOT NULL,
  `deskripsi` text COLLATE utf8_unicode_ci NOT NULL,
  `kepsek` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `nip` int(11) NOT NULL,
  `masa_kerja` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `izin_memimpin` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status_kepegawaian` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `pendidikan_terakhir` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `tgl` date NOT NULL,
  `publish` enum('1','0') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=384 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;




INSERT INTO `profil_sekolah` VALUES (168,'smkhidayatulinsaniabadi.sch.id','smk-hidayatul-insani-abadi','SMK HIDAYATUL INSANI ABADI','Swasta','-',69966704,'0000-00-00','C','Tata Busana dan Teknik Kendaraan Ringan Otomotif','421.5/DPMPTSP/2186/2017','14.210 m2','Kurikulum Merdeka','07.30-15.45',20,80,6,20,'','Turi Hudayani Abadi',19810618,'13 Tahun','Izin pengangkatan kepala sekolah dari pihak yayasan','PNS','S1','2022-09-08','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_banner`
--

CREATE TABLE `psb_banner` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `isi` longtext NOT NULL,
  `url` varchar(100) NOT NULL,
  `gambar` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1388 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_contact`
--

CREATE TABLE `psb_contact` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `iduser` varchar(50) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `status` enum('open','closed','answered','reply') NOT NULL DEFAULT 'open',
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=9072 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_contact_isi`
--

CREATE TABLE `psb_contact_isi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_contact` int(11) NOT NULL,
  `iduser` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `gambar` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=11102 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_dokumen`
--

CREATE TABLE `psb_dokumen` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `nisn` varchar(20) NOT NULL,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `nisn` (`nisn`)
) ENGINE=MyISAM AUTO_INCREMENT=182371 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_download`
--

CREATE TABLE `psb_download` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `isi` text NOT NULL,
  `no_psb_member` int(11) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=2282 DEFAULT CHARSET=latin1;




INSERT INTO `psb_download` VALUES (1695,'smkhidayatulinsaniabadi.sch.id','Mari bergabung dengan SMK HIA','mari-bergabung-dengan-smk-hia','',0,'35606862PENERIMAANSISWABARU.JPG','2021-06-09 09:53:59','1'),(1993,'smkhidayatulinsaniabadi.sch.id','mari bergabung ke sekolah kami sekarang juga','mari-bergabung-ke-sekolah-kami-sekarang-juga','',0,'61650390joinourscholl_page-0001.jpg','2022-11-24 12:16:23','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_file`
--

CREATE TABLE `psb_file` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `isi` text NOT NULL,
  `file` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1408 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_halaman`
--

CREATE TABLE `psb_halaman` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `isi` text NOT NULL,
  `kata_kunci` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=3420 DEFAULT CHARSET=latin1;




INSERT INTO `psb_halaman` VALUES (2871,'smkhidayatulinsaniabadi.sch.id','langkah prosedur pendaftaran','panduan','Datang ke sekolah bersama wali murid sesuai protokol kesehatan. Sesampainya di sekolah temui panitia pendaftaran.<div>&nbsp;=&gt;mengisi formulir</div><div>=&gt; selanjutnya tes</div><div>=&gt; wali di wawancarai oleh kepala sekolah</div>','','','2021-06-09 11:47:56','1'),(2902,'smkhidayatulinsaniabadi.sch.id','PPDB ONLINE SMK HIDAYATUL INSANI ABADI','alur','https://forms.gle/jfMJpzdjLEVipRiD6<br>','','','2021-06-14 12:48:44','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_jadwal`
--

CREATE TABLE `psb_jadwal` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `tempat` varchar(100) NOT NULL,
  `tanggal` varchar(100) NOT NULL,
  `tanggal_akhir` varchar(100) NOT NULL,
  `deskripsi` text NOT NULL,
  `urutan` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=3407 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_jadwal_kartu`
--

CREATE TABLE `psb_jadwal_kartu` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `hari` varchar(100) NOT NULL,
  `tanggal` date NOT NULL,
  `waktu` varchar(100) NOT NULL,
  `tempat` varchar(100) NOT NULL,
  `acara` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=744 DEFAULT CHARSET=latin1;




INSERT INTO `psb_jadwal_kartu` VALUES (368,'smkhidayatulinsaniabadi.sch.id','SENIN','2021-06-21','10.00','SEKOLAH SMK HIDAYATUL INSANI ABADI','PENDAFTARAN MURID BARU','2021-06-14 12:55:21','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_member_kartu`
--

CREATE TABLE `psb_member_kartu` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `jalur_ppdb` enum('0','1') NOT NULL,
  `gelombang_pendaftaran` enum('0','1') NOT NULL,
  `nama` enum('0','1') NOT NULL,
  `nama_panggilan` enum('0','1') NOT NULL,
  `kewarganegaraan` enum('0','1') NOT NULL,
  `bahasa` enum('0','1') NOT NULL,
  `email` enum('0','1') NOT NULL,
  `nik` enum('0','1') NOT NULL,
  `nomor_kk` enum('0','1') NOT NULL,
  `kelas` enum('0','1') NOT NULL,
  `pilihan_kelas` enum('0','1') NOT NULL,
  `jurusan` enum('0','1') NOT NULL,
  `jurusan_dua` enum('0','1') NOT NULL,
  `jurusan_tiga` enum('0','1') NOT NULL,
  `alasan` enum('0','1') NOT NULL,
  `tempat_lahir` enum('0','1') NOT NULL,
  `tanggal_lahir` enum('0','1') NOT NULL,
  `kelamin_jenis` enum('0','1') NOT NULL,
  `agama` enum('0','1') NOT NULL,
  `status_anak` enum('0','1') NOT NULL,
  `anak_ke` enum('0','1') NOT NULL,
  `jumlah_saudara` enum('0','1') NOT NULL,
  `jumlah_saudara_kandung` enum('0','1') NOT NULL,
  `jumlah_saudara_tiri` enum('0','1') NOT NULL,
  `jumlah_saudara_angkat` enum('0','1') NOT NULL,
  `tinggi_badan` enum('0','1') NOT NULL,
  `berat_badan` enum('0','1') NOT NULL,
  `cacat_badan` enum('0','1') NOT NULL,
  `golongan_darah` enum('0','1') NOT NULL,
  `penyakit_bawaan` enum('0','1') NOT NULL,
  `pernah_sakit` enum('0','1') NOT NULL,
  `nama_penyakit` enum('0','1') NOT NULL,
  `tanggal_sakit` enum('0','1') NOT NULL,
  `lama_sakit` enum('0','1') NOT NULL,
  `cita_cita` enum('0','1') NOT NULL,
  `hobi` enum('0','1') NOT NULL,
  `alamat` enum('0','1') NOT NULL,
  `dusun` enum('0','1') NOT NULL,
  `rt` enum('0','1') NOT NULL,
  `rw` enum('0','1') NOT NULL,
  `kelurahan` enum('0','1') NOT NULL,
  `kecamatan` enum('0','1') NOT NULL,
  `kota` enum('0','1') NOT NULL,
  `provinsi` enum('0','1') NOT NULL,
  `kodepos` enum('0','1') NOT NULL,
  `sekolah` enum('0','1') NOT NULL,
  `jarak_kesekolah` enum('0','1') NOT NULL,
  `transportasi_kesekolah` enum('0','1') NOT NULL,
  `waktu_kesekolah` enum('0','1') NOT NULL,
  `jenis_tinggal` enum('0','1') NOT NULL,
  `telepon` enum('0','1') NOT NULL,
  `handphone` enum('0','1') NOT NULL,
  `penerima_pkh` enum('0','1') NOT NULL,
  `nomor_kps` enum('0','1') NOT NULL,
  `jenis_ktm` enum('0','1') NOT NULL,
  `nomor_sktm` enum('0','1') NOT NULL,
  `nomor_kks` enum('0','1') NOT NULL,
  `nomor_pkh` enum('0','1') NOT NULL,
  `layak_pip` enum('0','1') NOT NULL,
  `alasan_pip` enum('0','1') NOT NULL,
  `nama_kip` enum('0','1') NOT NULL,
  `nomor_kip` enum('0','1') NOT NULL,
  `alasan_tolak_kip` enum('0','1') NOT NULL,
  `penerima_kip` enum('0','1') NOT NULL,
  `terima_fisik_kip` enum('0','1') NOT NULL,
  `nomor_kis` enum('0','1') NOT NULL,
  `bujur` enum('0','1') NOT NULL,
  `lintang` enum('0','1') NOT NULL,
  `lingkar_kepala` enum('0','1') NOT NULL,
  `asal_sekolah` enum('0','1') NOT NULL,
  `rangking` enum('0','1') NOT NULL,
  `peringkat_semester_1` enum('0','1') NOT NULL,
  `peringkat_semester_2` enum('0','1') NOT NULL,
  `peringkat_semester_3` enum('0','1') NOT NULL,
  `peringkat_semester_4` enum('0','1') NOT NULL,
  `peringkat_semester_5` enum('0','1') NOT NULL,
  `peringkat_semester_6` enum('0','1') NOT NULL,
  `alamat_sekolah_asal` enum('0','1') NOT NULL,
  `npsn` enum('0','1') NOT NULL,
  `tahunlulus` enum('0','1') NOT NULL,
  `email_ortu` enum('0','1') NOT NULL,
  `telp_ortu` enum('0','1') NOT NULL,
  `nis` enum('0','1') NOT NULL,
  `nama_ayah` enum('0','1') NOT NULL,
  `nik_ayah` enum('0','1') NOT NULL,
  `alamat_ayah` enum('0','1') NOT NULL,
  `tempat_lahir_ayah` enum('0','1') NOT NULL,
  `tanggal_lahir_ayah` enum('0','1') NOT NULL,
  `usia_ayah` enum('0','1') NOT NULL,
  `agama_ayah` enum('0','1') NOT NULL,
  `pendidikan_ayah` enum('0','1') NOT NULL,
  `pekerjaan_ayah` enum('0','1') NOT NULL,
  `penghasilan_ayah` enum('0','1') NOT NULL,
  `cacat_badan_ayah` enum('0','1') NOT NULL,
  `telepon_ayah` enum('0','1') NOT NULL,
  `nama_ibu` enum('0','1') NOT NULL,
  `nik_ibu` enum('0','1') NOT NULL,
  `alamat_ibu` enum('0','1') NOT NULL,
  `tempat_lahir_ibu` enum('0','1') NOT NULL,
  `tanggal_lahir_ibu` enum('0','1') NOT NULL,
  `usia_ibu` enum('0','1') NOT NULL,
  `tahun_lahir_ayah` enum('0','1') NOT NULL,
  `tahun_lahir_ibu` enum('0','1') NOT NULL,
  `tahun_lahir_wali` enum('0','1') NOT NULL,
  `agama_ibu` enum('0','1') NOT NULL,
  `pendidikan_ibu` enum('0','1') NOT NULL,
  `pekerjaan_ibu` enum('0','1') NOT NULL,
  `penghasilan_ibu` enum('0','1') NOT NULL,
  `cacat_badan_ibu` enum('0','1') NOT NULL,
  `telepon_ibu` enum('0','1') NOT NULL,
  `nama_wali` enum('0','1') NOT NULL,
  `nik_wali` enum('0','1') NOT NULL,
  `alamat_wali` enum('0','1') NOT NULL,
  `tempat_lahir_wali` enum('0','1') NOT NULL,
  `tanggal_lahir_wali` enum('0','1') NOT NULL,
  `usia_wali` enum('0','1') NOT NULL,
  `agama_wali` enum('0','1') NOT NULL,
  `pendidikan_wali` enum('0','1') NOT NULL,
  `pekerjaan_wali` enum('0','1') NOT NULL,
  `penghasilan_wali` enum('0','1') NOT NULL,
  `cacat_badan_wali` enum('0','1') NOT NULL,
  `telepon_wali` enum('0','1') NOT NULL,
  `prestasi` enum('0','1') NOT NULL,
  `prestasi_dua` enum('0','1') NOT NULL,
  `beasiswa` enum('0','1') NOT NULL,
  `nilai_un3` enum('0','1') NOT NULL,
  `nilai_un` enum('0','1') NOT NULL,
  `nilai_us` enum('0','1') NOT NULL,
  `nilai_un_b_indo` enum('0','1') NOT NULL,
  `nilai_un_matematika` enum('0','1') NOT NULL,
  `nilai_un_b_ing` enum('0','1') NOT NULL,
  `nilai_un_ipa` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_1` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_2` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_3` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_4` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_5` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_6` enum('0','1') NOT NULL,
  `agama_rapor_semester_1` enum('0','1') NOT NULL,
  `agama_rapor_semester_2` enum('0','1') NOT NULL,
  `agama_rapor_semester_3` enum('0','1') NOT NULL,
  `agama_rapor_semester_4` enum('0','1') NOT NULL,
  `agama_rapor_semester_5` enum('0','1') NOT NULL,
  `agama_rapor_semester_6` enum('0','1') NOT NULL,
  `ips_rapor_semester_1` enum('0','1') NOT NULL,
  `ips_rapor_semester_2` enum('0','1') NOT NULL,
  `ips_rapor_semester_3` enum('0','1') NOT NULL,
  `ips_rapor_semester_4` enum('0','1') NOT NULL,
  `ips_rapor_semester_5` enum('0','1') NOT NULL,
  `ips_rapor_semester_6` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_1` enum('0','1') NOT NULL,
  `matematika_rapor_semester_1` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_1` enum('0','1') NOT NULL,
  `ipa_rapor_semester_1` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_2` enum('0','1') NOT NULL,
  `matematika_rapor_semester_2` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_2` enum('0','1') NOT NULL,
  `ipa_rapor_semester_2` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_3` enum('0','1') NOT NULL,
  `matematika_rapor_semester_3` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_3` enum('0','1') NOT NULL,
  `ipa_rapor_semester_3` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_4` enum('0','1') NOT NULL,
  `matematika_rapor_semester_4` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_4` enum('0','1') NOT NULL,
  `ipa_rapor_semester_4` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_5` enum('0','1') NOT NULL,
  `matematika_rapor_semester_5` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_5` enum('0','1') NOT NULL,
  `ipa_rapor_semester_5` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_6` enum('0','1') NOT NULL,
  `matematika_rapor_semester_6` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_6` enum('0','1') NOT NULL,
  `ipa_rapor_semester_6` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_7` enum('0','1') NOT NULL,
  `matematika_rapor_semester_7` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_7` enum('0','1') NOT NULL,
  `ipa_rapor_semester_7` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_8` enum('0','1') NOT NULL,
  `matematika_rapor_semester_8` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_8` enum('0','1') NOT NULL,
  `ipa_rapor_semester_8` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_9` enum('0','1') NOT NULL,
  `matematika_rapor_semester_9` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_9` enum('0','1') NOT NULL,
  `ipa_rapor_semester_9` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_10` enum('0','1') NOT NULL,
  `matematika_rapor_semester_10` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_10` enum('0','1') NOT NULL,
  `ipa_rapor_semester_10` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_11` enum('0','1') NOT NULL,
  `matematika_rapor_semester_11` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_11` enum('0','1') NOT NULL,
  `ipa_rapor_semester_11` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_12` enum('0','1') NOT NULL,
  `matematika_rapor_semester_12` enum('0','1') NOT NULL,
  `ipa_rapor_semester_12` enum('0','1') NOT NULL,
  `pkn_rapor_semester_5` enum('0','1') NOT NULL,
  `rata_rata_us` enum('0','1') NOT NULL,
  `jmlh_nilai_un` enum('0','1') NOT NULL,
  `rata_rata_un` enum('0','1') NOT NULL,
  `nomor_ijazah` enum('0','1') NOT NULL,
  `nomor_skhu` enum('0','1') NOT NULL,
  `nomor_peserta_un` enum('0','1') NOT NULL,
  `nomor_akta_lahir` enum('0','1') NOT NULL,
  `domisili` enum('0','1') NOT NULL,
  `jenjang` enum('0','1') NOT NULL,
  `pembayaran` enum('0','1') NOT NULL,
  `tanggal_daftar` enum('0','1') NOT NULL,
  `data_periodik` enum('0','1') NOT NULL,
  `tanggal_isi_form` enum('0','1') NOT NULL,
  `pernah_paud` enum('0','1') NOT NULL,
  `pernah_tk` enum('0','1') NOT NULL,
  `referensi` enum('0','1') NOT NULL,
  `status_rumah_ayah` enum('0','1') NOT NULL,
  `status_rumah_ibu` enum('0','1') NOT NULL,
  `alamat_kerja_ayah` enum('0','1') NOT NULL,
  `alamat_kerja_ibu` enum('0','1') NOT NULL,
  `jarak_kekantor_ayah` enum('0','1') NOT NULL,
  `jarak_kekantor_ibu` enum('0','1') NOT NULL,
  `transportasi_ayah` enum('0','1') NOT NULL,
  `transportasi_ibu` enum('0','1') NOT NULL,
  `suku_ayah` enum('0','1') NOT NULL,
  `suku_ibu` enum('0','1') NOT NULL,
  `bahasa_ayah` enum('0','1') NOT NULL,
  `bahasa_ibu` enum('0','1') NOT NULL,
  `pendidikan_agama_ayah` enum('0','1') NOT NULL,
  `pendidikan_agama_ibu` enum('0','1') NOT NULL,
  `bacaan_quran_ayah` enum('0','1') NOT NULL,
  `bacaan_quran_ibu` enum('0','1') NOT NULL,
  `status_ayah` enum('0','1') NOT NULL,
  `status_ibu` enum('0','1') NOT NULL,
  `organisasi_islam_ayah` enum('0','1') NOT NULL,
  `organisasi_islam_ibu` enum('0','1') NOT NULL,
  `bacaan_ayah` enum('0','1') NOT NULL,
  `bacaan_ibu` enum('0','1') NOT NULL,
  `penghasilan` enum('0','1') NOT NULL,
  `nsm` enum('0','1') NOT NULL,
  `keterangan_beasiswa` enum('0','1') NOT NULL,
  `tahun_mulai_beasiswa` enum('0','1') NOT NULL,
  `tahun_selesai_beasiswa` enum('0','1') NOT NULL,
  `jenis_kesejahteraan` enum('0','1') NOT NULL,
  `nomor_bpjs` enum('0','1') NOT NULL,
  `panjang_lengan` enum('0','1') NOT NULL,
  `panjang_tungkai` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_1` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_2` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_3` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_4` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_5` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_6` enum('0','1') NOT NULL,
  `ukuran_pakaian` enum('0','1') NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=784 DEFAULT CHARSET=latin1;




INSERT INTO `psb_member_kartu` VALUES (472,'smkhidayatulinsaniabadi.sch.id','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0000-00-00 00:00:00');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_member_template`
--

CREATE TABLE `psb_member_template` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `jalur_ppdb` enum('0','1') NOT NULL,
  `nomor_pendaftaran` enum('0','1') NOT NULL,
  `gelombang_pendaftaran` enum('0','1') NOT NULL,
  `nama` enum('0','1') NOT NULL,
  `nama_panggilan` enum('0','1') NOT NULL,
  `kewarganegaraan` enum('0','1') NOT NULL,
  `bahasa` enum('0','1') NOT NULL,
  `email` enum('0','1') NOT NULL,
  `nik` enum('0','1') NOT NULL,
  `nomor_kk` enum('0','1') NOT NULL,
  `kelas` enum('0','1') NOT NULL,
  `pilihan_kelas` enum('0','1') NOT NULL,
  `jurusan` enum('0','1') NOT NULL,
  `jurusan_dua` enum('0','1') NOT NULL,
  `jurusan_tiga` enum('0','1') NOT NULL,
  `alasan` enum('0','1') NOT NULL,
  `tempat_lahir` enum('0','1') NOT NULL,
  `tanggal_lahir` enum('0','1') NOT NULL,
  `kelamin_jenis` enum('0','1') NOT NULL,
  `agama` enum('0','1') NOT NULL,
  `status_anak` enum('0','1') NOT NULL,
  `anak_ke` enum('0','1') NOT NULL,
  `jumlah_saudara` enum('0','1') NOT NULL,
  `jumlah_saudara_kandung` enum('0','1') NOT NULL,
  `jumlah_saudara_tiri` enum('0','1') NOT NULL,
  `jumlah_saudara_angkat` enum('0','1') NOT NULL,
  `tinggi_badan` enum('0','1') NOT NULL,
  `berat_badan` enum('0','1') NOT NULL,
  `cacat_badan` enum('0','1') NOT NULL,
  `golongan_darah` enum('0','1') NOT NULL,
  `penyakit_bawaan` enum('0','1') NOT NULL,
  `pernah_sakit` enum('0','1') NOT NULL,
  `nama_penyakit` enum('0','1') NOT NULL,
  `tanggal_sakit` enum('0','1') NOT NULL,
  `lama_sakit` enum('0','1') NOT NULL,
  `cita_cita` enum('0','1') NOT NULL,
  `hobi` enum('0','1') NOT NULL,
  `alamat` enum('0','1') NOT NULL,
  `dusun` enum('0','1') NOT NULL,
  `rt` enum('0','1') NOT NULL,
  `rw` enum('0','1') NOT NULL,
  `kelurahan` enum('0','1') NOT NULL,
  `kecamatan` enum('0','1') NOT NULL,
  `kota` enum('0','1') NOT NULL,
  `provinsi` enum('0','1') NOT NULL,
  `kodepos` enum('0','1') NOT NULL,
  `sekolah` enum('0','1') NOT NULL,
  `jarak_kesekolah` enum('0','1') NOT NULL,
  `transportasi_kesekolah` enum('0','1') NOT NULL,
  `waktu_kesekolah` enum('0','1') NOT NULL,
  `jenis_tinggal` enum('0','1') NOT NULL,
  `telepon` enum('0','1') NOT NULL,
  `handphone` enum('0','1') NOT NULL,
  `penerima_pkh` enum('0','1') NOT NULL,
  `nomor_kps` enum('0','1') NOT NULL,
  `jenis_ktm` enum('0','1') NOT NULL,
  `nomor_sktm` enum('0','1') NOT NULL,
  `nomor_kks` enum('0','1') NOT NULL,
  `nomor_pkh` enum('0','1') NOT NULL,
  `layak_pip` enum('0','1') NOT NULL,
  `alasan_pip` enum('0','1') NOT NULL,
  `nama_kip` enum('0','1') NOT NULL,
  `nomor_kip` enum('0','1') NOT NULL,
  `alasan_tolak_kip` enum('0','1') NOT NULL,
  `penerima_kip` enum('0','1') NOT NULL,
  `terima_fisik_kip` enum('0','1') NOT NULL,
  `nomor_kis` enum('0','1') NOT NULL,
  `bujur` enum('0','1') NOT NULL,
  `lintang` enum('0','1') NOT NULL,
  `lingkar_kepala` enum('0','1') NOT NULL,
  `asal_sekolah` enum('0','1') NOT NULL,
  `rangking` enum('0','1') NOT NULL,
  `peringkat_semester_1` enum('0','1') NOT NULL,
  `peringkat_semester_2` enum('0','1') NOT NULL,
  `peringkat_semester_3` enum('0','1') NOT NULL,
  `peringkat_semester_4` enum('0','1') NOT NULL,
  `peringkat_semester_5` enum('0','1') NOT NULL,
  `peringkat_semester_6` enum('0','1') NOT NULL,
  `alamat_sekolah_asal` enum('0','1') NOT NULL,
  `npsn` enum('0','1') NOT NULL,
  `tahunlulus` enum('0','1') NOT NULL,
  `nisn` enum('0','1') NOT NULL,
  `email_ortu` enum('0','1') NOT NULL,
  `telp_ortu` enum('0','1') NOT NULL,
  `nis` enum('0','1') NOT NULL,
  `nama_ayah` enum('0','1') NOT NULL,
  `nik_ayah` enum('0','1') NOT NULL,
  `alamat_ayah` enum('0','1') NOT NULL,
  `tempat_lahir_ayah` enum('0','1') NOT NULL,
  `tanggal_lahir_ayah` enum('0','1') NOT NULL,
  `usia_ayah` enum('0','1') NOT NULL,
  `agama_ayah` enum('0','1') NOT NULL,
  `pendidikan_ayah` enum('0','1') NOT NULL,
  `pekerjaan_ayah` enum('0','1') NOT NULL,
  `penghasilan_ayah` enum('0','1') NOT NULL,
  `cacat_badan_ayah` enum('0','1') NOT NULL,
  `telepon_ayah` enum('0','1') NOT NULL,
  `nama_ibu` enum('0','1') NOT NULL,
  `nik_ibu` enum('0','1') NOT NULL,
  `alamat_ibu` enum('0','1') NOT NULL,
  `tempat_lahir_ibu` enum('0','1') NOT NULL,
  `tanggal_lahir_ibu` enum('0','1') NOT NULL,
  `usia_ibu` enum('0','1') NOT NULL,
  `tahun_lahir_ayah` enum('0','1') NOT NULL,
  `tahun_lahir_ibu` enum('0','1') NOT NULL,
  `tahun_lahir_wali` enum('0','1') NOT NULL,
  `agama_ibu` enum('0','1') NOT NULL,
  `pendidikan_ibu` enum('0','1') NOT NULL,
  `pekerjaan_ibu` enum('0','1') NOT NULL,
  `penghasilan_ibu` enum('0','1') NOT NULL,
  `cacat_badan_ibu` enum('0','1') NOT NULL,
  `telepon_ibu` enum('0','1') NOT NULL,
  `nama_wali` enum('0','1') NOT NULL,
  `nik_wali` enum('0','1') NOT NULL,
  `alamat_wali` enum('0','1') NOT NULL,
  `tempat_lahir_wali` enum('0','1') NOT NULL,
  `tanggal_lahir_wali` enum('0','1') NOT NULL,
  `usia_wali` enum('0','1') NOT NULL,
  `agama_wali` enum('0','1') NOT NULL,
  `pendidikan_wali` enum('0','1') NOT NULL,
  `pekerjaan_wali` enum('0','1') NOT NULL,
  `penghasilan_wali` enum('0','1') NOT NULL,
  `cacat_badan_wali` enum('0','1') NOT NULL,
  `telepon_wali` enum('0','1') NOT NULL,
  `prestasi` enum('0','1') NOT NULL,
  `prestasi_dua` enum('0','1') NOT NULL,
  `beasiswa` enum('0','1') NOT NULL,
  `nilai_un3` enum('0','1') NOT NULL,
  `nilai_un` enum('0','1') NOT NULL,
  `nilai_us` enum('0','1') NOT NULL,
  `nilai_un_b_indo` enum('0','1') NOT NULL,
  `nilai_un_matematika` enum('0','1') NOT NULL,
  `nilai_un_b_ing` enum('0','1') NOT NULL,
  `nilai_un_ipa` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_1` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_2` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_3` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_4` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_5` enum('0','1') NOT NULL,
  `rata_rata_rapor_semester_6` enum('0','1') NOT NULL,
  `agama_rapor_semester_1` enum('0','1') NOT NULL,
  `agama_rapor_semester_2` enum('0','1') NOT NULL,
  `agama_rapor_semester_3` enum('0','1') NOT NULL,
  `agama_rapor_semester_4` enum('0','1') NOT NULL,
  `agama_rapor_semester_5` enum('0','1') NOT NULL,
  `agama_rapor_semester_6` enum('0','1') NOT NULL,
  `ips_rapor_semester_1` enum('0','1') NOT NULL,
  `ips_rapor_semester_2` enum('0','1') NOT NULL,
  `ips_rapor_semester_3` enum('0','1') NOT NULL,
  `ips_rapor_semester_4` enum('0','1') NOT NULL,
  `ips_rapor_semester_5` enum('0','1') NOT NULL,
  `ips_rapor_semester_6` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_1` enum('0','1') NOT NULL,
  `matematika_rapor_semester_1` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_1` enum('0','1') NOT NULL,
  `ipa_rapor_semester_1` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_2` enum('0','1') NOT NULL,
  `matematika_rapor_semester_2` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_2` enum('0','1') NOT NULL,
  `ipa_rapor_semester_2` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_3` enum('0','1') NOT NULL,
  `matematika_rapor_semester_3` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_3` enum('0','1') NOT NULL,
  `ipa_rapor_semester_3` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_4` enum('0','1') NOT NULL,
  `matematika_rapor_semester_4` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_4` enum('0','1') NOT NULL,
  `ipa_rapor_semester_4` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_5` enum('0','1') NOT NULL,
  `matematika_rapor_semester_5` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_5` enum('0','1') NOT NULL,
  `ipa_rapor_semester_5` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_6` enum('0','1') NOT NULL,
  `matematika_rapor_semester_6` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_6` enum('0','1') NOT NULL,
  `ipa_rapor_semester_6` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_7` enum('0','1') NOT NULL,
  `matematika_rapor_semester_7` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_7` enum('0','1') NOT NULL,
  `ipa_rapor_semester_7` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_8` enum('0','1') NOT NULL,
  `matematika_rapor_semester_8` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_8` enum('0','1') NOT NULL,
  `ipa_rapor_semester_8` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_9` enum('0','1') NOT NULL,
  `matematika_rapor_semester_9` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_9` enum('0','1') NOT NULL,
  `ipa_rapor_semester_9` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_10` enum('0','1') NOT NULL,
  `matematika_rapor_semester_10` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_10` enum('0','1') NOT NULL,
  `ipa_rapor_semester_10` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_11` enum('0','1') NOT NULL,
  `matematika_rapor_semester_11` enum('0','1') NOT NULL,
  `b_ing_rapor_semester_11` enum('0','1') NOT NULL,
  `ipa_rapor_semester_11` enum('0','1') NOT NULL,
  `b_indo_rapor_semester_12` enum('0','1') NOT NULL,
  `matematika_rapor_semester_12` enum('0','1') NOT NULL,
  `ipa_rapor_semester_12` enum('0','1') NOT NULL,
  `pkn_rapor_semester_5` enum('0','1') NOT NULL,
  `rata_rata_us` enum('0','1') NOT NULL,
  `jmlh_nilai_un` enum('0','1') NOT NULL,
  `rata_rata_un` enum('0','1') NOT NULL,
  `nomor_ijazah` enum('0','1') NOT NULL,
  `nomor_skhu` enum('0','1') NOT NULL,
  `nomor_peserta_un` enum('0','1') NOT NULL,
  `nomor_akta_lahir` enum('0','1') NOT NULL,
  `domisili` enum('0','1') NOT NULL,
  `jenjang` enum('0','1') NOT NULL,
  `pembayaran` enum('0','1') NOT NULL,
  `tanggal_daftar` enum('0','1') NOT NULL,
  `data_periodik` enum('0','1') NOT NULL,
  `tanggal_isi_form` enum('0','1') NOT NULL,
  `pernah_paud` enum('0','1') NOT NULL,
  `pernah_tk` enum('0','1') NOT NULL,
  `referensi` enum('0','1') NOT NULL,
  `status_rumah_ayah` enum('0','1') NOT NULL,
  `status_rumah_ibu` enum('0','1') NOT NULL,
  `alamat_kerja_ayah` enum('0','1') NOT NULL,
  `alamat_kerja_ibu` enum('0','1') NOT NULL,
  `jarak_kekantor_ayah` enum('0','1') NOT NULL,
  `jarak_kekantor_ibu` enum('0','1') NOT NULL,
  `transportasi_ayah` enum('0','1') NOT NULL,
  `transportasi_ibu` enum('0','1') NOT NULL,
  `suku_ayah` enum('0','1') NOT NULL,
  `suku_ibu` enum('0','1') NOT NULL,
  `bahasa_ayah` enum('0','1') NOT NULL,
  `bahasa_ibu` enum('0','1') NOT NULL,
  `pendidikan_agama_ayah` enum('0','1') NOT NULL,
  `pendidikan_agama_ibu` enum('0','1') NOT NULL,
  `bacaan_quran_ayah` enum('0','1') NOT NULL,
  `bacaan_quran_ibu` enum('0','1') NOT NULL,
  `status_ayah` enum('0','1') NOT NULL,
  `status_ibu` enum('0','1') NOT NULL,
  `organisasi_islam_ayah` enum('0','1') NOT NULL,
  `organisasi_islam_ibu` enum('0','1') NOT NULL,
  `bacaan_ayah` enum('0','1') NOT NULL,
  `bacaan_ibu` enum('0','1') NOT NULL,
  `tgl` enum('0','1') NOT NULL,
  `penghasilan` enum('0','1') NOT NULL,
  `nsm` enum('0','1') NOT NULL,
  `keterangan_beasiswa` enum('0','1') NOT NULL,
  `tahun_mulai_beasiswa` enum('0','1') NOT NULL,
  `tahun_selesai_beasiswa` enum('0','1') NOT NULL,
  `jenis_kesejahteraan` enum('0','1') NOT NULL,
  `nomor_bpjs` enum('0','1') NOT NULL,
  `panjang_lengan` enum('0','1') NOT NULL,
  `panjang_tungkai` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_1` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_2` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_3` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_4` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_5` enum('0','1') NOT NULL,
  `jumlah_rapor_semester_6` enum('0','1') NOT NULL,
  `ukuran_pakaian` enum('0','1') NOT NULL,
  `foto` enum('0','1') NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1267 DEFAULT CHARSET=latin1;




INSERT INTO `psb_member_template` VALUES (945,'smkhidayatulinsaniabadi.sch.id','1','1','0','1','1','1','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','1','1','1','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2022-05-10 12:46:58');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_pengumuman`
--

CREATE TABLE `psb_pengumuman` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `isi` text NOT NULL,
  `kata_kunci` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1839 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_setting`
--

CREATE TABLE `psb_setting` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `head1` varchar(100) NOT NULL,
  `head2` varchar(100) NOT NULL,
  `head3` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `prolog` text NOT NULL,
  `penutup` text NOT NULL,
  `logo` varchar(200) NOT NULL,
  `logo2` varchar(200) NOT NULL,
  `stempel` varchar(200) NOT NULL,
  `ttd_kepsek` varchar(200) NOT NULL,
  `nama_kepsek` varchar(200) NOT NULL,
  `gelar` varchar(50) NOT NULL,
  `nip_kepsek` varchar(20) NOT NULL,
  `tempat_keputusan` varchar(200) NOT NULL,
  `tanggal_keputusan` date NOT NULL,
  `jam_keputusan` time NOT NULL,
  `tahun_ajaran` varchar(10) NOT NULL,
  `tanggal_tutup` date NOT NULL,
  `jam_tutup` time NOT NULL,
  `nilai_minimal` decimal(4,2) NOT NULL,
  `kuota` int(11) NOT NULL,
  `jurusan` longtext NOT NULL,
  `jalur_ppdb` text NOT NULL,
  `syarat_login` text NOT NULL,
  `copyright` varchar(100) NOT NULL,
  `penomoran_otomatis` enum('0','1') NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1500 DEFAULT CHARSET=latin1;




INSERT INTO `psb_setting` VALUES (1215,'smkhidayatulinsaniabadi.sch.id','','','','','','','','','','','','','','','','','0000-00-00','00:00:00','','0000-00-00','00:00:00',0.00,0,'','','','','0','0000-00-00 00:00:00','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_setting_kartu`
--

CREATE TABLE `psb_setting_kartu` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `kartu_1` enum('0','1') NOT NULL,
  `kartu_2` enum('0','1') NOT NULL,
  `kartu_3` enum('0','1') NOT NULL,
  `kartu_4` enum('0','1') NOT NULL,
  `jadwal_ppdb` enum('0','1') NOT NULL,
  `foto_1` enum('0','1') NOT NULL,
  `foto_2` enum('0','1') NOT NULL,
  `tampilkan_foto` enum('0','1') NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=739 DEFAULT CHARSET=latin1;




INSERT INTO `psb_setting_kartu` VALUES (445,'smkhidayatulinsaniabadi.sch.id','1','0','0','1','1','0','1','1','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_setting_pembayaran`
--

CREATE TABLE `psb_setting_pembayaran` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `isi` longtext NOT NULL,
  `pembayaran` enum('0','1') NOT NULL,
  `tanggal` date NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_setting_template`
--

CREATE TABLE `psb_setting_template` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` enum('1','0') NOT NULL,
  `link` varchar(100) NOT NULL,
  `head1` enum('1','0') NOT NULL,
  `head2` enum('1','0') NOT NULL,
  `head3` enum('1','0') NOT NULL,
  `alamat` enum('1','0') NOT NULL,
  `logo` enum('1','0') NOT NULL,
  `logo2` enum('1','0') NOT NULL,
  `prolog` enum('1','0') NOT NULL,
  `penutup` enum('1','0') NOT NULL,
  `nisn` enum('1','0') NOT NULL,
  `nama` enum('1','0') NOT NULL,
  `ttd_kepsek` enum('1','0') NOT NULL,
  `nama_kepsek` enum('1','0') NOT NULL,
  `stempel` enum('1','0') NOT NULL,
  `nip_kepsek` enum('1','0') NOT NULL,
  `kelas` enum('1','0') NOT NULL,
  `pilihan_kelas` enum('1','0') NOT NULL,
  `jurusan` enum('1','0') NOT NULL,
  `jurusan_dua` enum('1','0') NOT NULL,
  `jurusan_tiga` enum('1','0') NOT NULL,
  `kelamin_jenis` enum('1','0') NOT NULL,
  `isi` enum('1','0') NOT NULL,
  `tanggal_keputusan` enum('1','0') NOT NULL,
  `tempat_keputusan` enum('1','0') NOT NULL,
  `tahun_ajaran` enum('1','0') NOT NULL,
  `keputusan` enum('1','0') NOT NULL,
  `jurusan_diterima` enum('0','1') NOT NULL,
  `tanggal_tutup` date NOT NULL,
  `jam_tutup` time NOT NULL,
  `nilai_minimal` decimal(4,2) NOT NULL,
  `kuota` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1197 DEFAULT CHARSET=latin1;




INSERT INTO `psb_setting_template` VALUES (917,'smkhidayatulinsaniabadi.sch.id','1','1','0','0','0','1','1','1','1','1','1','1','1','1','1','1','0','1','1','1','1','1','1','1','1','1','1','1','0000-00-00','00:00:00',0.00,0,'2022-05-11 09:49:00','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `psb_ubah_label`
--

CREATE TABLE `psb_ubah_label` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(100) NOT NULL,
  `jalur_ppdb` varchar(100) NOT NULL,
  `gelombang_pendaftaran` varchar(100) NOT NULL,
  `nomor_pendaftaran` varchar(100) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nama_panggilan` varchar(100) NOT NULL,
  `kewarganegaraan` varchar(100) NOT NULL,
  `bahasa` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `nik` varchar(100) NOT NULL,
  `nomor_kk` varchar(100) NOT NULL,
  `kelas` varchar(100) NOT NULL,
  `pilihan_kelas` varchar(100) NOT NULL,
  `jurusan` varchar(100) NOT NULL,
  `jurusan_dua` varchar(100) NOT NULL,
  `jurusan_tiga` varchar(100) NOT NULL,
  `alasan` varchar(100) NOT NULL,
  `tempat_lahir` varchar(100) NOT NULL,
  `tanggal_lahir` varchar(100) NOT NULL,
  `kelamin_jenis` varchar(100) NOT NULL,
  `agama` varchar(100) NOT NULL,
  `status_anak` varchar(100) NOT NULL,
  `anak_ke` varchar(100) NOT NULL,
  `jumlah_saudara` varchar(100) NOT NULL,
  `jumlah_saudara_kandung` varchar(100) NOT NULL,
  `jumlah_saudara_tiri` varchar(100) NOT NULL,
  `jumlah_saudara_angkat` varchar(100) NOT NULL,
  `tinggi_badan` varchar(100) NOT NULL,
  `berat_badan` varchar(100) NOT NULL,
  `cacat_badan` varchar(100) NOT NULL,
  `golongan_darah` varchar(100) NOT NULL,
  `penyakit_bawaan` varchar(100) NOT NULL,
  `pernah_sakit` varchar(100) NOT NULL,
  `nama_penyakit` varchar(100) NOT NULL,
  `tanggal_sakit` varchar(100) NOT NULL,
  `lama_sakit` varchar(100) NOT NULL,
  `cita_cita` varchar(100) NOT NULL,
  `hobi` varchar(100) NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `dusun` varchar(100) NOT NULL,
  `rt` varchar(100) NOT NULL,
  `rw` varchar(100) NOT NULL,
  `kelurahan` varchar(100) NOT NULL,
  `kecamatan` varchar(100) NOT NULL,
  `kota` varchar(100) NOT NULL,
  `provinsi` varchar(100) NOT NULL,
  `kodepos` varchar(100) NOT NULL,
  `sekolah` varchar(100) NOT NULL,
  `jarak_kesekolah` varchar(100) NOT NULL,
  `transportasi_kesekolah` varchar(100) NOT NULL,
  `waktu_kesekolah` varchar(100) NOT NULL,
  `jenis_tinggal` varchar(100) NOT NULL,
  `telepon` varchar(100) NOT NULL,
  `handphone` varchar(100) NOT NULL,
  `penerima_pkh` varchar(100) NOT NULL,
  `nomor_kps` varchar(100) NOT NULL,
  `jenis_ktm` varchar(100) NOT NULL,
  `nomor_sktm` varchar(100) NOT NULL,
  `nomor_kks` varchar(100) NOT NULL,
  `nomor_pkh` varchar(100) NOT NULL,
  `layak_pip` varchar(100) NOT NULL,
  `alasan_pip` varchar(100) NOT NULL,
  `nama_kip` varchar(100) NOT NULL,
  `nomor_kip` varchar(100) NOT NULL,
  `alasan_tolak_kip` varchar(100) NOT NULL,
  `penerima_kip` varchar(100) NOT NULL,
  `terima_fisik_kip` varchar(100) NOT NULL,
  `nomor_kis` varchar(100) NOT NULL,
  `bujur` varchar(100) NOT NULL,
  `lintang` varchar(100) NOT NULL,
  `lingkar_kepala` varchar(100) NOT NULL,
  `asal_sekolah` varchar(100) NOT NULL,
  `rangking` varchar(100) NOT NULL,
  `peringkat_semester_1` varchar(100) NOT NULL,
  `peringkat_semester_2` varchar(100) NOT NULL,
  `peringkat_semester_3` varchar(100) NOT NULL,
  `peringkat_semester_4` varchar(100) NOT NULL,
  `peringkat_semester_5` varchar(100) NOT NULL,
  `peringkat_semester_6` varchar(100) NOT NULL,
  `alamat_sekolah_asal` varchar(100) NOT NULL,
  `npsn` varchar(100) NOT NULL,
  `tahunlulus` varchar(100) NOT NULL,
  `nisn` varchar(100) NOT NULL,
  `email_ortu` varchar(100) NOT NULL,
  `telp_ortu` varchar(100) NOT NULL,
  `nis` varchar(100) NOT NULL,
  `nama_ayah` varchar(100) NOT NULL,
  `nik_ayah` varchar(100) NOT NULL,
  `alamat_ayah` varchar(100) NOT NULL,
  `tempat_lahir_ayah` varchar(100) NOT NULL,
  `tanggal_lahir_ayah` varchar(100) NOT NULL,
  `usia_ayah` varchar(100) NOT NULL,
  `agama_ayah` varchar(100) NOT NULL,
  `pendidikan_ayah` varchar(100) NOT NULL,
  `pekerjaan_ayah` varchar(100) NOT NULL,
  `penghasilan_ayah` varchar(100) NOT NULL,
  `cacat_badan_ayah` varchar(100) NOT NULL,
  `telepon_ayah` varchar(100) NOT NULL,
  `nama_ibu` varchar(100) NOT NULL,
  `nik_ibu` varchar(100) NOT NULL,
  `alamat_ibu` varchar(100) NOT NULL,
  `tempat_lahir_ibu` varchar(100) NOT NULL,
  `tanggal_lahir_ibu` varchar(100) NOT NULL,
  `usia_ibu` varchar(100) NOT NULL,
  `tahun_lahir_ayah` varchar(100) NOT NULL,
  `tahun_lahir_ibu` varchar(100) NOT NULL,
  `tahun_lahir_wali` varchar(100) NOT NULL,
  `agama_ibu` varchar(100) NOT NULL,
  `pendidikan_ibu` varchar(100) NOT NULL,
  `pekerjaan_ibu` varchar(100) NOT NULL,
  `penghasilan_ibu` varchar(100) NOT NULL,
  `cacat_badan_ibu` varchar(100) NOT NULL,
  `telepon_ibu` varchar(100) NOT NULL,
  `nama_wali` varchar(100) NOT NULL,
  `nik_wali` varchar(100) NOT NULL,
  `alamat_wali` varchar(100) NOT NULL,
  `tempat_lahir_wali` varchar(100) NOT NULL,
  `tanggal_lahir_wali` varchar(100) NOT NULL,
  `usia_wali` varchar(100) NOT NULL,
  `agama_wali` varchar(100) NOT NULL,
  `pendidikan_wali` varchar(100) NOT NULL,
  `pekerjaan_wali` varchar(100) NOT NULL,
  `penghasilan_wali` varchar(100) NOT NULL,
  `cacat_badan_wali` varchar(100) NOT NULL,
  `telepon_wali` varchar(100) NOT NULL,
  `prestasi` varchar(100) NOT NULL,
  `prestasi_dua` varchar(100) NOT NULL,
  `beasiswa` varchar(100) NOT NULL,
  `nilai_un3` varchar(100) NOT NULL,
  `nilai_un` varchar(100) NOT NULL,
  `nilai_us` varchar(100) NOT NULL,
  `nilai_un_b_indo` varchar(100) NOT NULL,
  `nilai_un_matematika` varchar(100) NOT NULL,
  `nilai_un_b_ing` varchar(100) NOT NULL,
  `nilai_un_ipa` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_1` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_2` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_3` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_4` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_5` varchar(100) NOT NULL,
  `rata_rata_rapor_semester_6` varchar(100) NOT NULL,
  `agama_rapor_semester_1` varchar(100) NOT NULL,
  `agama_rapor_semester_2` varchar(100) NOT NULL,
  `agama_rapor_semester_3` varchar(100) NOT NULL,
  `agama_rapor_semester_4` varchar(100) NOT NULL,
  `agama_rapor_semester_5` varchar(100) NOT NULL,
  `agama_rapor_semester_6` varchar(100) NOT NULL,
  `ips_rapor_semester_1` varchar(100) NOT NULL,
  `ips_rapor_semester_2` varchar(100) NOT NULL,
  `ips_rapor_semester_3` varchar(100) NOT NULL,
  `ips_rapor_semester_4` varchar(100) NOT NULL,
  `ips_rapor_semester_5` varchar(100) NOT NULL,
  `ips_rapor_semester_6` varchar(100) NOT NULL,
  `b_indo_rapor_semester_1` varchar(100) NOT NULL,
  `matematika_rapor_semester_1` varchar(100) NOT NULL,
  `b_ing_rapor_semester_1` varchar(100) NOT NULL,
  `ipa_rapor_semester_1` varchar(100) NOT NULL,
  `b_indo_rapor_semester_2` varchar(100) NOT NULL,
  `matematika_rapor_semester_2` varchar(100) NOT NULL,
  `b_ing_rapor_semester_2` varchar(100) NOT NULL,
  `ipa_rapor_semester_2` varchar(100) NOT NULL,
  `b_indo_rapor_semester_3` varchar(100) NOT NULL,
  `matematika_rapor_semester_3` varchar(100) NOT NULL,
  `b_ing_rapor_semester_3` varchar(100) NOT NULL,
  `ipa_rapor_semester_3` varchar(100) NOT NULL,
  `b_indo_rapor_semester_4` varchar(100) NOT NULL,
  `matematika_rapor_semester_4` varchar(100) NOT NULL,
  `b_ing_rapor_semester_4` varchar(100) NOT NULL,
  `ipa_rapor_semester_4` varchar(100) NOT NULL,
  `b_indo_rapor_semester_5` varchar(100) NOT NULL,
  `matematika_rapor_semester_5` varchar(100) NOT NULL,
  `b_ing_rapor_semester_5` varchar(100) NOT NULL,
  `ipa_rapor_semester_5` varchar(100) NOT NULL,
  `b_indo_rapor_semester_6` varchar(100) NOT NULL,
  `matematika_rapor_semester_6` varchar(100) NOT NULL,
  `b_ing_rapor_semester_6` varchar(100) NOT NULL,
  `ipa_rapor_semester_6` varchar(100) NOT NULL,
  `b_indo_rapor_semester_7` varchar(100) NOT NULL,
  `matematika_rapor_semester_7` varchar(100) NOT NULL,
  `b_ing_rapor_semester_7` varchar(100) NOT NULL,
  `ipa_rapor_semester_7` varchar(100) NOT NULL,
  `b_indo_rapor_semester_8` varchar(100) NOT NULL,
  `matematika_rapor_semester_8` varchar(100) NOT NULL,
  `b_ing_rapor_semester_8` varchar(100) NOT NULL,
  `ipa_rapor_semester_8` varchar(100) NOT NULL,
  `b_indo_rapor_semester_9` varchar(100) NOT NULL,
  `matematika_rapor_semester_9` varchar(100) NOT NULL,
  `b_ing_rapor_semester_9` varchar(100) NOT NULL,
  `ipa_rapor_semester_9` varchar(100) NOT NULL,
  `b_indo_rapor_semester_10` varchar(100) NOT NULL,
  `matematika_rapor_semester_10` varchar(100) NOT NULL,
  `b_ing_rapor_semester_10` varchar(100) NOT NULL,
  `ipa_rapor_semester_10` varchar(100) NOT NULL,
  `b_indo_rapor_semester_11` varchar(100) NOT NULL,
  `matematika_rapor_semester_11` varchar(100) NOT NULL,
  `b_ing_rapor_semester_11` varchar(100) NOT NULL,
  `ipa_rapor_semester_11` varchar(100) NOT NULL,
  `b_indo_rapor_semester_12` varchar(100) NOT NULL,
  `matematika_rapor_semester_12` varchar(100) NOT NULL,
  `ipa_rapor_semester_12` varchar(100) NOT NULL,
  `pkn_rapor_semester_5` varchar(100) NOT NULL,
  `rata_rata_us` varchar(100) NOT NULL,
  `jmlh_nilai_un` varchar(100) NOT NULL,
  `rata_rata_un` varchar(100) NOT NULL,
  `nomor_ijazah` varchar(100) NOT NULL,
  `nomor_skhu` varchar(100) NOT NULL,
  `nomor_peserta_un` varchar(100) NOT NULL,
  `nomor_akta_lahir` varchar(100) NOT NULL,
  `domisili` varchar(100) NOT NULL,
  `jenjang` varchar(100) NOT NULL,
  `pembayaran` varchar(100) NOT NULL,
  `tanggal_daftar` varchar(100) NOT NULL,
  `data_periodik` varchar(100) NOT NULL,
  `tanggal_isi_form` varchar(100) NOT NULL,
  `pernah_paud` varchar(100) NOT NULL,
  `pernah_tk` varchar(100) NOT NULL,
  `referensi` varchar(100) NOT NULL,
  `status_rumah_ayah` varchar(100) NOT NULL,
  `status_rumah_ibu` varchar(100) NOT NULL,
  `alamat_kerja_ayah` varchar(100) NOT NULL,
  `alamat_kerja_ibu` varchar(100) NOT NULL,
  `jarak_kekantor_ayah` varchar(100) NOT NULL,
  `jarak_kekantor_ibu` varchar(100) NOT NULL,
  `transportasi_ayah` varchar(100) NOT NULL,
  `transportasi_ibu` varchar(100) NOT NULL,
  `suku_ayah` varchar(100) NOT NULL,
  `suku_ibu` varchar(100) NOT NULL,
  `bahasa_ayah` varchar(100) NOT NULL,
  `bahasa_ibu` varchar(100) NOT NULL,
  `pendidikan_agama_ayah` varchar(100) NOT NULL,
  `pendidikan_agama_ibu` varchar(100) NOT NULL,
  `bacaan_quran_ayah` varchar(100) NOT NULL,
  `bacaan_quran_ibu` varchar(100) NOT NULL,
  `status_ayah` varchar(100) NOT NULL,
  `status_ibu` varchar(100) NOT NULL,
  `organisasi_islam_ayah` varchar(100) NOT NULL,
  `organisasi_islam_ibu` varchar(100) NOT NULL,
  `bacaan_ayah` varchar(100) NOT NULL,
  `bacaan_ibu` varchar(100) NOT NULL,
  `tgl` varchar(100) NOT NULL,
  `penghasilan` varchar(100) NOT NULL,
  `nsm` varchar(100) NOT NULL,
  `keterangan_beasiswa` varchar(100) NOT NULL,
  `tahun_mulai_beasiswa` varchar(100) NOT NULL,
  `tahun_selesai_beasiswa` varchar(100) NOT NULL,
  `jenis_kesejahteraan` varchar(100) NOT NULL,
  `nomor_bpjs` varchar(100) NOT NULL,
  `panjang_lengan` varchar(100) NOT NULL,
  `panjang_tungkai` varchar(100) NOT NULL,
  `jumlah_rapor_semester_1` varchar(100) NOT NULL,
  `jumlah_rapor_semester_2` varchar(100) NOT NULL,
  `jumlah_rapor_semester_3` varchar(100) NOT NULL,
  `jumlah_rapor_semester_4` varchar(100) NOT NULL,
  `jumlah_rapor_semester_5` varchar(100) NOT NULL,
  `jumlah_rapor_semester_6` varchar(100) NOT NULL,
  `ukuran_pakaian` varchar(100) NOT NULL,
  `foto` varchar(100) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=457 DEFAULT CHARSET=latin1;




INSERT INTO `psb_ubah_label` VALUES (375,'smkhidayatulinsaniabadi.sch.id','Jalur Ppdb','','Nomor Pendaftaran','Nama','Nama Panggilan','Kewarganegaraan','Bahasa','Email','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Nilai Un','','Nilai Un B Indo','Nilai Un Matematika','Nilai Un B Ing','','Rata Rata Rapor Semester 1','Rata Rata Rapor Semester 2','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2022-05-10 12:46:02');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `sambutan`
--

CREATE TABLE `sambutan` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=62671 DEFAULT CHARSET=latin1;




INSERT INTO `sambutan` VALUES (20544,'smkhidayatulinsaniabadi.sch.id','Sambutan Kepala Sekolah','sambutan-kepala-sekolah','Sebagai lembaga pendidikan, SMK Hidayatul Insani Abadi tanggap dengan perkembangan mutu belajar murid. Dengan dukungan para guru sebagai pengajar yang di miliki sekolah ini, kami mempersiapkan para murid supaya siap untuk berkompetisi dengan sekolah lain dalam keunggulan belajar. Teknologi Informasi Web khususnya, menjadi sarana bagi SMK&amp;nbsp;hidayatul Insani Abadi untuk memberi pelayanan informasi secara cepat, jelas, dan akuntable. Dari layanan ini pula, sekolah siap menerima saran dari semua pihak yang akhirnya dapat memberikan jawaban kepada para orang tua untuk memilihkan sekolah yang cocok dengan minat anak. ','77424768WhatsAppImage2021-03-18at07.26.03.jpeg','2021-03-19 11:00:20','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `agama_sekolah` varchar(50) NOT NULL,
  `idsponsor` varchar(50) NOT NULL,
  `paket` enum('basic','profesional','exclusive','custom') NOT NULL,
  `aplikasi` enum('tidakpakai','ppdb','simpen','semua') NOT NULL,
  `pid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `whmcs` enum('0','1') NOT NULL,
  `email_ke` enum('1','2','3','4','5') NOT NULL DEFAULT '1',
  `version_web` int(11) NOT NULL,
  `version_admin` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `tingkat` enum('sd','smp','sma','smk') NOT NULL,
  `judul` varchar(200) NOT NULL,
  `subjudul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `deskripsi` text NOT NULL,
  `kata_kunci` text NOT NULL,
  `tipe_header` enum('logo','banner') NOT NULL DEFAULT 'logo',
  `tipe_slideshow` varchar(50) NOT NULL,
  `top_left` text NOT NULL,
  `top_right` text NOT NULL,
  `header` varchar(200) NOT NULL,
  `header2` varchar(200) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `logo_landscape` varchar(191) NOT NULL,
  `logo_text` varchar(100) NOT NULL,
  `logo_text2` varchar(100) NOT NULL,
  `breadcumb` varchar(191) NOT NULL,
  `header_kanan` text NOT NULL,
  `header_bawah` text NOT NULL,
  `banner` varchar(200) NOT NULL,
  `footer` varchar(200) NOT NULL,
  `footer_title` varchar(100) NOT NULL,
  `footer_text` text NOT NULL,
  `theme` varchar(50) NOT NULL,
  `theme_new` varchar(32) NOT NULL,
  `kolom` int(11) NOT NULL,
  `favicon` varchar(200) NOT NULL,
  `alamat` varchar(200) NOT NULL,
  `kota` varchar(50) NOT NULL,
  `provinsi` varchar(50) NOT NULL,
  `maps` text NOT NULL,
  `kodepos` varchar(5) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `telepon2` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `website` varchar(50) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `google_plus` varchar(200) NOT NULL,
  `google_map` varchar(100) NOT NULL,
  `google_verification` text NOT NULL,
  `followup` text NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `youtube` varchar(100) NOT NULL,
  `whatsapp` varchar(100) NOT NULL,
  `tiktok` varchar(191) NOT NULL,
  `tgl` datetime NOT NULL,
  `tgl_upgrade` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  `migrated` tinyint(1) NOT NULL,
  `migrated_lama` tinyint(1) NOT NULL,
  `migrate_order` int(11) NOT NULL,
  `migrate_category` enum('A','B','C') NOT NULL,
  `status` enum('active','renewal','upgrade','lms','callback','confirm') NOT NULL DEFAULT 'active',
  `note` text NOT NULL,
  `aktif` enum('0','1') NOT NULL,
  `sdhcek` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=73575 DEFAULT CHARSET=latin1;




INSERT INTO `setting` VALUES (21248,'smkhidayatulinsaniabadi.sch.id','','','admin','profesional','semua',10,6243,'0','4',0,0,'smkhidayatulinsaniabadi@gmail.com','sd','SMK Hidayatul Insani Abadi','Bandar\r Kabupaten Bener Meriah\r','smkhidayatulinsaniabadihia','Website SMK Hidayatul Insani Abadi','SMK Hidayatul Insani Abadi','logo','','','','72814079LOGO.jpeg','','39202536WhatsAppImage2021-03-18at07.26.03.jpeg','','SMK HIDAYATUL INSANI ABADI','VOCATIONAL HIGH SCHOOL','','','','','Copyright - 2019-SMK Hidayatul Insani Abadi','','','evo','movers',3,'','Jadi Sepakat, Kec. Bandar, Kab, Bener Meriah. Aceh, Indonesia','Kabupaten Bener Meriah','Aceh','PWWM+93H, Jadi Sepakat, Kec. Bandar, Kab. Bener Meriah, Aceh 24582','24582','082296126349','082295298713','','smkhidayatulinsaniabadi@gmail.com','smkhidayatulinsaniabadi.sch.id','SMK Hidayatul Insani Abadi','','','','','','https://www.instagram.com/smk_hia_official/','smk hidayatul insani abadi','082296126349','','2021-03-19 11:00:14','2021-03-20 10:05:32','1',1,0,0,'A','active','','1','0');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `setting_backup`
--

CREATE TABLE `setting_backup` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `agama_sekolah` varchar(50) NOT NULL,
  `idsponsor` varchar(50) NOT NULL,
  `paket` enum('basic','profesional','exclusive','custom') NOT NULL,
  `aplikasi` enum('tidakpakai','ppdb','simpen','semua') NOT NULL,
  `pid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `whmcs` enum('0','1') NOT NULL,
  `email_ke` enum('1','2','3','4','5') NOT NULL DEFAULT '1',
  `version_web` int(11) NOT NULL,
  `version_admin` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `tingkat` enum('sd','smp','sma','smk') NOT NULL,
  `judul` varchar(200) NOT NULL,
  `subjudul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `deskripsi` text NOT NULL,
  `kata_kunci` text NOT NULL,
  `tipe_header` enum('logo','banner') NOT NULL DEFAULT 'logo',
  `tipe_slideshow` varchar(50) NOT NULL,
  `top_left` text NOT NULL,
  `top_right` text NOT NULL,
  `header` varchar(200) NOT NULL,
  `header2` varchar(200) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `logo_landscape` varchar(191) NOT NULL,
  `logo_text` varchar(100) NOT NULL,
  `logo_text2` varchar(100) NOT NULL,
  `breadcumb` varchar(191) NOT NULL,
  `header_kanan` text NOT NULL,
  `header_bawah` text NOT NULL,
  `banner` varchar(200) NOT NULL,
  `footer` varchar(200) NOT NULL,
  `footer_title` varchar(100) NOT NULL,
  `footer_text` text NOT NULL,
  `theme` varchar(50) NOT NULL,
  `theme_new` varchar(32) NOT NULL,
  `kolom` int(11) NOT NULL,
  `favicon` varchar(200) NOT NULL,
  `alamat` varchar(200) NOT NULL,
  `kota` varchar(50) NOT NULL,
  `provinsi` varchar(50) NOT NULL,
  `maps` text NOT NULL,
  `kodepos` varchar(5) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `telepon2` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `website` varchar(50) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `google_plus` varchar(200) NOT NULL,
  `google_map` varchar(100) NOT NULL,
  `google_verification` text NOT NULL,
  `followup` text NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `youtube` varchar(100) NOT NULL,
  `whatsapp` varchar(100) NOT NULL,
  `tiktok` varchar(191) NOT NULL,
  `tgl` datetime NOT NULL,
  `tgl_upgrade` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  `migrated` tinyint(1) NOT NULL,
  `migrated_lama` tinyint(1) NOT NULL,
  `migrate_order` int(11) NOT NULL,
  `migrate_category` enum('A','B','C') NOT NULL,
  `status` enum('active','renewal','upgrade','lms','callback','confirm') NOT NULL DEFAULT 'active',
  `note` text NOT NULL,
  `aktif` enum('0','1') NOT NULL,
  `sdhcek` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=73575 DEFAULT CHARSET=latin1;




INSERT INTO `setting_backup` VALUES (21248,'smkhidayatulinsaniabadi.sch.id','','','admin','profesional','semua',10,6243,'0','4',0,0,'smkhidayatulinsaniabadi@gmail.com','sd','SMK Hidayatul Insani Abadi','Bandar\r Kabupaten Bener Meriah\r','smkhidayatulinsaniabadihia','Website SMK Hidayatul Insani Abadi','SMK Hidayatul Insani Abadi','logo','','','','72814079LOGO.jpeg','','39202536WhatsAppImage2021-03-18at07.26.03.jpeg','','SMK HIDAYATUL INSANI ABADI','VOCATIONAL HIGH SCHOOL','','','','','Copyright - 2019-SMK Hidayatul Insani Abadi','','','evo','movers',3,'','Jadi Sepakat, Kec. Bandar, Kab, Bener Meriah. Aceh, Indonesia','Kabupaten Bener Meriah','Aceh','PWWM+93H, Jadi Sepakat, Kec. Bandar, Kab. Bener Meriah, Aceh 24582','24582','082296126349','082295298713','','smkhidayatulinsaniabadi@gmail.com','smkhidayatulinsaniabadi.sch.id','SMK Hidayatul Insani Abadi','','','','','','https://www.instagram.com/smk_hia_official/','smk hidayatul insani abadi','082296126349','','2021-03-19 11:00:14','2021-03-20 10:05:32','1',1,0,0,'A','active','','1','0');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `silabus`
--

CREATE TABLE `silabus` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `semester` int(11) NOT NULL,
  `kelas` varchar(50) NOT NULL,
  `tahun_ajaran` varchar(50) NOT NULL,
  `file` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1948 DEFAULT CHARSET=latin1;




INSERT INTO `silabus` VALUES (1910,'smkhidayatulinsaniabadi.sch.id','ATP MATEMATIKA X','atp-matematika-x',0,'X FASE E','2022/2023','35852526ALURDANTUJUANPEMBELAJARANFix.docx','2022-11-03 12:34:27','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_halaman`
--

CREATE TABLE `simpen_halaman` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `isi` longtext NOT NULL,
  `kata_kunci` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=2591 DEFAULT CHARSET=latin1;




INSERT INTO `simpen_halaman` VALUES (1474,'smkhidayatulinsaniabadi.sch.id','','panduan','','','','2021-04-11 10:38:34','1'),(1473,'smkhidayatulinsaniabadi.sch.id','','tentang','','','','2021-04-11 10:38:31','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_sambutan`
--

CREATE TABLE `simpen_sambutan` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=6105 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_setting`
--

CREATE TABLE `simpen_setting` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `head1` text NOT NULL,
  `head2` varchar(100) NOT NULL,
  `head3` varchar(100) NOT NULL,
  `head4` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `tingkat` enum('sd','smp','sma','smk','ma','mak') NOT NULL DEFAULT 'sd',
  `tahun_ajaran` varchar(50) NOT NULL,
  `tanggal_buka` date NOT NULL,
  `jam_buka` time NOT NULL,
  `tempat_keputusan` varchar(100) NOT NULL,
  `tanggal_keputusan` varchar(100) NOT NULL,
  `nama_kepsek` varchar(100) NOT NULL,
  `nip_kepsek` varchar(100) NOT NULL,
  `ttd_kepsek` varchar(200) NOT NULL,
  `stempel` varchar(200) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `logo2` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  `surat_prolog` text NOT NULL,
  `surat_isi` text NOT NULL,
  `surat_penutup` text NOT NULL,
  `nomor_surat` varchar(100) NOT NULL,
  `simpen_template` int(11) NOT NULL,
  `kategori_simpen` enum('N','Y') NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=988 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_siswa`
--

CREATE TABLE `simpen_siswa` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `nis` varchar(50) NOT NULL,
  `nisn` varchar(50) NOT NULL,
  `nik` varchar(50) NOT NULL,
  `npsn` varchar(20) NOT NULL,
  `nomor_ujian` varchar(50) NOT NULL,
  `nomor_peserta` varchar(50) NOT NULL,
  `ttl` varchar(100) NOT NULL,
  `tempat_lahir` varchar(100) NOT NULL,
  `tgl_lahir` varchar(100) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `nama_orang_tua` varchar(50) NOT NULL,
  `jenis_kelamin` varchar(50) NOT NULL,
  `kelas` varchar(50) NOT NULL,
  `jurusan` varchar(50) NOT NULL,
  `gambar` varchar(150) NOT NULL,
  `rata_rata_us` decimal(5,2) NOT NULL,
  `rata_rata_un` decimal(5,2) NOT NULL,
  `mapel_pilihan_rapor` decimal(5,2) NOT NULL,
  `mapel_pilihan_ns` decimal(5,2) NOT NULL,
  `mapel_pilihan_un` decimal(5,2) NOT NULL,
  `mapel_pilihan_akhir` decimal(5,2) NOT NULL,
  `mapel_pilihan_rapor_dua` decimal(5,2) NOT NULL,
  `mapel_pilihan_ns_dua` decimal(5,2) NOT NULL,
  `ind_ns` decimal(5,2) NOT NULL,
  `ind_un` decimal(5,2) NOT NULL,
  `ind_rapor` decimal(5,2) NOT NULL,
  `ind_us_praktik` decimal(5,2) NOT NULL,
  `ind_us_tulis` decimal(5,2) NOT NULL,
  `ind_akhir` decimal(5,2) NOT NULL,
  `antro_un` decimal(5,2) NOT NULL,
  `arab_un` decimal(5,2) NOT NULL,
  `arab_rapor` decimal(5,2) NOT NULL,
  `arab_us` decimal(5,2) NOT NULL,
  `prakarya_rapor` decimal(5,2) NOT NULL,
  `prakarya_ns` decimal(5,2) NOT NULL,
  `prakarya_us` decimal(5,2) NOT NULL,
  `arab_ns` decimal(5,2) NOT NULL,
  `akhlak_un` decimal(5,2) NOT NULL,
  `akidah_un` decimal(5,2) NOT NULL,
  `sastra_un` decimal(5,2) NOT NULL,
  `tafsir_un` decimal(5,2) NOT NULL,
  `tafsir_ns` decimal(5,2) NOT NULL,
  `hadis_rapor` decimal(5,2) NOT NULL,
  `ski_un` decimal(5,2) NOT NULL,
  `fikih_un` decimal(5,2) NOT NULL,
  `kalam_un` decimal(5,2) NOT NULL,
  `ing_ns` decimal(5,2) NOT NULL,
  `ing_un` decimal(5,2) NOT NULL,
  `ing_rapor` decimal(5,2) NOT NULL,
  `ing_us_tulis` decimal(5,2) NOT NULL,
  `ing_us_praktik` decimal(5,2) NOT NULL,
  `ing_akhir` decimal(5,2) NOT NULL,
  `mat_ns` decimal(5,2) NOT NULL,
  `mat_un` decimal(5,2) NOT NULL,
  `mat_rapor` decimal(5,2) NOT NULL,
  `mat_us_praktik` decimal(5,2) NOT NULL,
  `mat_us_tulis` decimal(5,2) NOT NULL,
  `mat_akhir` decimal(5,2) NOT NULL,
  `ipa_ns` decimal(5,2) NOT NULL,
  `ipa_un` decimal(5,2) NOT NULL,
  `ipa_rapor` decimal(5,2) NOT NULL,
  `ipa_us_praktik` decimal(5,2) NOT NULL,
  `ipa_us_tulis` decimal(5,2) NOT NULL,
  `fis_rapor` decimal(5,2) NOT NULL,
  `ipa_akhir` decimal(5,2) NOT NULL,
  `fis_ns` decimal(5,2) NOT NULL,
  `fis_un` decimal(5,2) NOT NULL,
  `fis_akhir` decimal(5,2) NOT NULL,
  `kim_rapor` decimal(5,2) NOT NULL,
  `kim_ns` decimal(5,2) NOT NULL,
  `kim_un` decimal(5,2) NOT NULL,
  `kim_akhir` decimal(5,2) NOT NULL,
  `bio_rapor` decimal(5,2) NOT NULL,
  `bio_ns` decimal(5,2) NOT NULL,
  `bio_un` decimal(5,2) NOT NULL,
  `bio_akhir` decimal(5,2) NOT NULL,
  `eko_rapor` decimal(5,2) NOT NULL,
  `eko_ns` decimal(5,2) NOT NULL,
  `eko_un` decimal(5,2) NOT NULL,
  `eko_akhir` decimal(5,2) NOT NULL,
  `sos_rapor` decimal(5,2) NOT NULL,
  `sos_ns` decimal(5,2) NOT NULL,
  `sos_un` decimal(5,2) NOT NULL,
  `sos_akhir` decimal(5,2) NOT NULL,
  `geo_rapor` decimal(5,2) NOT NULL,
  `geo_ns` decimal(5,2) NOT NULL,
  `geo_un` decimal(5,2) NOT NULL,
  `geo_akhir` decimal(5,2) NOT NULL,
  `agama_rapor` decimal(5,2) NOT NULL,
  `agama_us_tulis` decimal(5,2) NOT NULL,
  `agama_us_praktik` decimal(5,2) NOT NULL,
  `agama_ns` decimal(5,2) NOT NULL,
  `pkn_rapor` decimal(5,2) NOT NULL,
  `pkn_us_tulis` decimal(5,2) NOT NULL,
  `pkn_us_praktik` decimal(5,2) NOT NULL,
  `pkn_ns` decimal(5,2) NOT NULL,
  `ips_rapor` decimal(5,2) NOT NULL,
  `ips_un` decimal(5,2) NOT NULL,
  `ips_us_tulis` decimal(5,2) NOT NULL,
  `ips_us_praktik` decimal(5,2) NOT NULL,
  `ips_ns` decimal(5,2) NOT NULL,
  `sbk_rapor` decimal(5,2) NOT NULL,
  `sbk_us_tulis` decimal(5,2) NOT NULL,
  `sbk_us_praktik` decimal(5,2) NOT NULL,
  `sbk_ns` decimal(5,2) NOT NULL,
  `penjas_rapor` decimal(5,2) NOT NULL,
  `penjas_us_tulis` decimal(5,2) NOT NULL,
  `penjas_us_praktik` decimal(5,2) NOT NULL,
  `penjas_ns` decimal(5,2) NOT NULL,
  `budpek_rapor` decimal(5,2) NOT NULL,
  `budpek_us_tulis` decimal(5,2) NOT NULL,
  `budpek_us_praktik` decimal(5,2) NOT NULL,
  `budpek_ns` decimal(5,2) NOT NULL,
  `sejarah_ns` decimal(5,2) NOT NULL,
  `sejarah_rapor` decimal(5,2) NOT NULL,
  `sejarah_tulis` decimal(5,2) NOT NULL,
  `sejarah_praktek` decimal(5,2) NOT NULL,
  `pjok_ns` decimal(5,2) NOT NULL,
  `tik_rapor` decimal(5,2) NOT NULL,
  `tik_ns` decimal(5,2) NOT NULL,
  `keterampilan_ns` decimal(5,2) NOT NULL,
  `keterampilan_rapor` decimal(4,2) NOT NULL,
  `pariwisata_ns` decimal(5,2) NOT NULL,
  `utk_ns` decimal(5,2) NOT NULL,
  `utk_un` decimal(5,2) NOT NULL,
  `kompetensi_ns` decimal(5,2) NOT NULL,
  `kompetensi_akhir` decimal(5,2) NOT NULL,
  `kompetensi_keahlian` decimal(5,2) NOT NULL,
  `antropologi_ns` decimal(5,2) NOT NULL,
  `antropologi_akhir` decimal(5,2) NOT NULL,
  `sastra_ns` decimal(5,2) NOT NULL,
  `sastra_akhir` decimal(5,2) NOT NULL,
  `sastra_rapor` decimal(5,2) NOT NULL,
  `bhs_jerman_ns` decimal(5,2) NOT NULL,
  `bhs_jerman_akhir` decimal(5,2) NOT NULL,
  `hadis_uambnbk` decimal(5,2) NOT NULL,
  `hadis_ns` decimal(5,2) NOT NULL,
  `akidah_uambnbk` decimal(5,2) NOT NULL,
  `fikih_uambnbk` decimal(5,2) NOT NULL,
  `fikih_ns` decimal(5,2) NOT NULL,
  `ski_uambnbk` decimal(5,2) NOT NULL,
  `arab_uambnbk` decimal(5,2) NOT NULL,
  `akhlak_uambnbk` decimal(5,2) NOT NULL,
  `kalam_uambnbk` decimal(5,2) NOT NULL,
  `utk_akhir` decimal(5,2) NOT NULL,
  `total` decimal(5,2) NOT NULL,
  `rata_rata` decimal(5,2) NOT NULL,
  `nilai` decimal(5,2) NOT NULL,
  `asal_sekolah` varchar(100) NOT NULL,
  `agama_akhir` decimal(5,2) NOT NULL,
  `hadits_akhir` decimal(5,2) NOT NULL,
  `akhlak_akhir` decimal(5,2) NOT NULL,
  `akhlak_ns` decimal(5,2) NOT NULL,
  `fikih_akhir` decimal(5,2) NOT NULL,
  `sejarah_islam_akhir` decimal(5,2) NOT NULL,
  `sejarah_islam_ns` decimal(5,2) NOT NULL,
  `pkn_akhir` decimal(5,2) NOT NULL,
  `arab_akhir` decimal(5,2) NOT NULL,
  `ips_akhir` decimal(5,2) NOT NULL,
  `seni_budaya_akhir` decimal(5,2) NOT NULL,
  `penjas_akhir` decimal(5,2) NOT NULL,
  `keterampilan_akhir` decimal(5,2) NOT NULL,
  `tik_akhir` decimal(5,2) NOT NULL,
  `muatan_lokal_ns` decimal(5,2) NOT NULL,
  `muatan_lokal_rapor` decimal(5,2) NOT NULL,
  `km_rapor` decimal(5,2) NOT NULL,
  `km_ns` decimal(5,2) NOT NULL,
  `pai_rpt2` decimal(5,2) NOT NULL,
  `pkn_rpt2` decimal(5,2) NOT NULL,
  `indo_rpt2` decimal(5,2) NOT NULL,
  `ingg_rpt2` decimal(5,2) NOT NULL,
  `mat_rpt2` decimal(5,2) NOT NULL,
  `ipa_rpt2` decimal(5,2) NOT NULL,
  `ips_rpt2` decimal(5,2) NOT NULL,
  `sb_rpt2` decimal(5,2) NOT NULL,
  `penjas_rpt2` decimal(5,2) NOT NULL,
  `prakarya_rpt2` decimal(5,2) NOT NULL,
  `jawa_rpt2` decimal(5,2) NOT NULL,
  `agama_us` decimal(5,2) NOT NULL,
  `pkn_us` decimal(5,2) NOT NULL,
  `ind_us` decimal(5,2) NOT NULL,
  `ing_us` decimal(5,2) NOT NULL,
  `mat_us` decimal(5,2) NOT NULL,
  `ipa_us` decimal(5,2) NOT NULL,
  `ips_us` decimal(5,2) NOT NULL,
  `sbk_us` decimal(5,2) NOT NULL,
  `penjas_us` decimal(5,2) NOT NULL,
  `prakarya_nus` decimal(5,2) NOT NULL,
  `jawa_us` decimal(5,2) NOT NULL,
  `kwu_rapor` decimal(5,2) NOT NULL,
  `kwu_ns` decimal(5,2) NOT NULL,
  `b_asing_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_1_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_2_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_3_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_4_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_5_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_6_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_7_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_8_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_9_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_10_ns` decimal(5,2) NOT NULL,
  `mapel_tambahan_1_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_2_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_3_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_4_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_5_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_6_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_7_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_8_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_9_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_10_us` decimal(5,2) NOT NULL,
  `mapel_tambahan_1_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_2_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_3_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_4_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_5_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_6_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_7_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_8_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_9_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_10_rapor` decimal(5,2) NOT NULL,
  `mapel_tambahan_1_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_2_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_3_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_4_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_5_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_6_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_7_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_8_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_9_akhir` decimal(5,2) NOT NULL,
  `mapel_tambahan_10_akhir` decimal(5,2) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `keputusan` varchar(32) NOT NULL DEFAULT 'LULUS',
  `kurikulum` varchar(100) NOT NULL,
  `pemrograman` decimal(5,2) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=376039 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_ubah_label`
--

CREATE TABLE `simpen_ubah_label` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `nip_kepsek` varchar(50) NOT NULL,
  `link` varchar(100) NOT NULL,
  `nomor_ujian` varchar(50) NOT NULL,
  `nomor_peserta` varchar(50) NOT NULL,
  `nama_orang_tua` varchar(50) NOT NULL,
  `jurusan` varchar(50) NOT NULL,
  `nama_siswa` varchar(50) NOT NULL,
  `mapel_pilihan` varchar(50) NOT NULL,
  `ind` varchar(50) NOT NULL,
  `antro` varchar(50) NOT NULL,
  `arab` varchar(50) NOT NULL,
  `prakarya` varchar(50) NOT NULL,
  `akhlak` varchar(50) NOT NULL,
  `akidah` varchar(50) NOT NULL,
  `sastra` varchar(50) NOT NULL,
  `tafsir` varchar(50) NOT NULL,
  `hadis` varchar(50) NOT NULL,
  `ski` varchar(50) NOT NULL,
  `fikih` varchar(50) NOT NULL,
  `kalam` varchar(50) NOT NULL,
  `ing` varchar(50) NOT NULL,
  `mat` varchar(50) NOT NULL,
  `ipa` varchar(50) NOT NULL,
  `fis` varchar(50) NOT NULL,
  `kim` varchar(50) NOT NULL,
  `bio` varchar(50) NOT NULL,
  `eko` varchar(50) NOT NULL,
  `sos` varchar(50) NOT NULL,
  `geo` varchar(50) NOT NULL,
  `agama` varchar(50) NOT NULL,
  `pkn` varchar(50) NOT NULL,
  `ips` varchar(50) NOT NULL,
  `sbk` varchar(50) NOT NULL,
  `penjas` varchar(50) NOT NULL,
  `budpek` varchar(50) NOT NULL,
  `sejarah` varchar(50) NOT NULL,
  `tik` varchar(50) NOT NULL,
  `keterampilan` varchar(50) NOT NULL,
  `pariwisata` varchar(50) NOT NULL,
  `utk` varchar(50) NOT NULL,
  `bhs_jerman` varchar(50) NOT NULL,
  `hadits` varchar(50) NOT NULL,
  `muatan_lokal` varchar(50) NOT NULL,
  `km` varchar(50) NOT NULL,
  `kwu` varchar(50) NOT NULL,
  `b_asing` varchar(50) NOT NULL,
  `mapel_tambahan_1` varchar(50) NOT NULL,
  `mapel_tambahan_2` varchar(50) NOT NULL,
  `mapel_tambahan_3` varchar(50) NOT NULL,
  `mapel_tambahan_4` varchar(50) NOT NULL,
  `mapel_tambahan_5` varchar(50) NOT NULL,
  `mapel_tambahan_6` varchar(50) NOT NULL,
  `mapel_tambahan_7` varchar(50) NOT NULL,
  `mapel_tambahan_8` varchar(50) NOT NULL,
  `mapel_tambahan_9` varchar(50) NOT NULL,
  `mapel_tambahan_10` varchar(50) NOT NULL,
  `jawa` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `simpen_ubah_urutan`
--

CREATE TABLE `simpen_ubah_urutan` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `link` varchar(100) NOT NULL,
  `mapel_pilihan` varchar(50) NOT NULL,
  `ind` varchar(50) NOT NULL,
  `antro` varchar(50) NOT NULL,
  `arab` varchar(50) NOT NULL,
  `prakarya` varchar(50) NOT NULL,
  `akhlak` varchar(50) NOT NULL,
  `akidah` varchar(50) NOT NULL,
  `sastra` varchar(50) NOT NULL,
  `tafsir` varchar(50) NOT NULL,
  `hadis` varchar(50) NOT NULL,
  `ski` varchar(50) NOT NULL,
  `fikih` varchar(50) NOT NULL,
  `kalam` varchar(50) NOT NULL,
  `ing` varchar(50) NOT NULL,
  `mat` varchar(50) NOT NULL,
  `ipa` varchar(50) NOT NULL,
  `fis` varchar(50) NOT NULL,
  `kim` varchar(50) NOT NULL,
  `bio` varchar(50) NOT NULL,
  `eko` varchar(50) NOT NULL,
  `sos` varchar(50) NOT NULL,
  `geo` varchar(50) NOT NULL,
  `agama` varchar(50) NOT NULL,
  `pkn` varchar(50) NOT NULL,
  `ips` varchar(50) NOT NULL,
  `sbk` varchar(50) NOT NULL,
  `penjas` varchar(50) NOT NULL,
  `budpek` varchar(50) NOT NULL,
  `sejarah` varchar(50) NOT NULL,
  `tik` varchar(50) NOT NULL,
  `keterampilan` varchar(50) NOT NULL,
  `pariwisata` varchar(50) NOT NULL,
  `utk` varchar(50) NOT NULL,
  `bhs_jerman` varchar(50) NOT NULL,
  `hadits` varchar(50) NOT NULL,
  `muatan_lokal` varchar(50) NOT NULL,
  `km` varchar(50) NOT NULL,
  `kwu` varchar(50) NOT NULL,
  `b_asing` varchar(50) NOT NULL,
  `seni_budaya` varchar(50) NOT NULL,
  `mapel_tambahan_1` varchar(50) NOT NULL,
  `mapel_tambahan_2` varchar(50) NOT NULL,
  `mapel_tambahan_3` varchar(50) NOT NULL,
  `mapel_tambahan_4` varchar(50) NOT NULL,
  `mapel_tambahan_5` varchar(50) NOT NULL,
  `mapel_tambahan_6` varchar(50) NOT NULL,
  `mapel_tambahan_7` varchar(50) NOT NULL,
  `mapel_tambahan_8` varchar(50) NOT NULL,
  `mapel_tambahan_9` varchar(50) NOT NULL,
  `mapel_tambahan_10` varchar(50) NOT NULL,
  `jawa` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `siswa`
--

CREATE TABLE `siswa` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `nis` varchar(100) NOT NULL,
  `subdomain` varchar(75) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nama_panggilan` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `sekolah_asal` varchar(100) NOT NULL,
  `tempat_lahir` varchar(50) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `kelamin_jenis` varchar(50) NOT NULL,
  `nisn` varchar(15) NOT NULL,
  `kota` varchar(100) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `kodepos` varchar(10) NOT NULL,
  `no_kelas` int(11) NOT NULL,
  `rombel` varchar(50) NOT NULL,
  `no_kelompok` varchar(50) NOT NULL,
  `nama_ayah` varchar(100) NOT NULL,
  `nama_ibu` varchar(100) NOT NULL,
  `pekerjaan_ayah` varchar(100) NOT NULL,
  `pekerjaan_ibu` varchar(100) NOT NULL,
  `agama` varchar(50) NOT NULL,
  `golongan_darah` varchar(100) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  `kelas` varchar(50) NOT NULL,
  `jurusan` varchar(50) NOT NULL,
  `no_induk` varchar(50) NOT NULL,
  `rt` varchar(50) NOT NULL,
  `rw` varchar(50) NOT NULL,
  `dusun` varchar(50) NOT NULL,
  `kelurahan` varchar(50) NOT NULL,
  `kecamatan` varchar(50) NOT NULL,
  `nipd` varchar(50) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=170741 DEFAULT CHARSET=latin1;




INSERT INTO `siswa` VALUES (121807,'0030211831','smkhidayatulinsaniabadi.sch.id','Abdul  Mutalib','','abdul--mutalib','Blang Jorong,Desa Petukel Blang Jorong,Kec.Bandar','','Blang Jorong','0000-00-00','L','111705150203000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121806,'0011447930','smkhidayatulinsaniabadi.sch.id','Anugrah Ramadhan','','anugrah-ramadhan','Blang Jorong,Desa Petukel Blang Jorong,Bandar','','Medan','0000-00-00','L','111705091102000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKR','','','','','','',''),(121805,'0020561463','smkhidayatulinsaniabadi.sch.id','Mirza Rappasa Rinaldi','','mirza-rappasa-rinaldi','Blang Jorong,Bandar','','Takengon','0000-00-00','L','111705041102000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKR','','','','','','',''),(121804,'1060507040','smkhidayatulinsaniabadi.sch.id','Rio Alfitra','','rio-alfitra','Batin Baru, Musara Pakat kec. Bandar','','Arul Badak','2037-05-02','L','111705100601000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121803,'0010318233','smkhidayatulinsaniabadi.sch.id','Irsan Safawi','','irsan-safawi','Hakim Wih Ilang, Bandar','','Hakim Wih Ilang','2037-10-01','L','111705290701000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121802,'0010755474','smkhidayatulinsaniabadi.sch.id','Wani Ramadhan','','wani-ramadhan','Pondok Baru,Bandar','','Banda Aceh','0000-00-00','L','110609430202000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121800,'0018895918','smkhidayatulinsaniabadi.sch.id','Maulana Satriyadi','','maulana-satriyadi','Dusun Benara, Pondok Baru, Bandar','','Pekan Baru','0000-00-00','L','111705120301000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121801,'0016477986','smkhidayatulinsaniabadi.sch.id','Muhriza','','muhriza','Hakim Wih Ilang, Bandar','','Hakim Wihn Ilang','0000-00-00','L','111705251201000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121799,'0016337295','smkhidayatulinsaniabadi.sch.id','selamat  Tuah  Bahgie','','selamat--tuah--bahgie','Dusun Benara, Pondok Baru, Bandar','','Pondok Baru','0000-00-00','L','111705211001000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121798,'0030194942','smkhidayatulinsaniabadi.sch.id','zufri Yanto','','zufri-yanto','Tingkem Asli Kec Bukit','','Tingkem','0000-00-00','L','111703070103000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121797,'0030194480','smkhidayatulinsaniabadi.sch.id','Kasman dargo','','kasman-dargo','Dsn.Mesara Ate Pondok ulung Kac.Bandar','','Pondok Ulung','0000-00-00','L','111705010400000','Bener Meriah','','24582',0,'','','','','','','Islam','','2021-06-15 13:12:49','1','Kelas Otomotif 3','TKR','','','','','','',''),(121796,'0022579119','smkhidayatulinsaniabadi.sch.id','Maudi Riogi','','maudi-riogi','Muyang Kute Mangku. Dsn. Sinar Mangku desa Mangku Kec Bandar','','Medan','0000-00-00','L','111705210702000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121795,'0028666513','smkhidayatulinsaniabadi.sch.id','Juwanda','','juwanda','Batin Baru, Musara Pakat kec. Bandar','','Langsa','0000-00-00','L','111705050702000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121794,'0022578479','smkhidayatulinsaniabadi.sch.id','Sopyan Razali','','sopyan-razali','Bahgie Bertona Telege Mumata kec.Bandar ','','Bahgie Bertona','0000-00-00','L','111705040902000','Bener Meriah','','24582',9435,'','','','','','','Islam','','2021-06-15 13:12:49','1','','TKRO','','','','','','',''),(121793,'','smkhidayatulinsaniabadi.sch.id','Adi Sumantri','','adi-sumantri','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:10:58','1','','TKRO','','','','','','',''),(121792,'','smkhidayatulinsaniabadi.sch.id','Agus Tiandi','','agus-tiandi','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:09:59','1','','TKRO','','','','','','',''),(121791,'','smkhidayatulinsaniabadi.sch.id','Daldi Trianda','','daldi-trianda','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:09:24','1','','TKRO','','','','','','',''),(121790,'','smkhidayatulinsaniabadi.sch.id','RIDHO TRIRAMANDA','','ridho-triramanda','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:08:35','1','','TKRO','','','','','','',''),(121789,'','smkhidayatulinsaniabadi.sch.id','Ihwan Qalbi','','ihwan-qalbi','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:07:58','1','','TKRO','','','','','','',''),(121788,'','smkhidayatulinsaniabadi.sch.id','Jainuddin','','jainuddin','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:07:08','1','','TKRO','','','','','','',''),(121787,'','smkhidayatulinsaniabadi.sch.id','Karim Amarullah','','karim-amarullah','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:06:05','1','','TKRO','','','','','','',''),(121786,'','smkhidayatulinsaniabadi.sch.id','KHALIFAH MUSTAQIM','','khalifah-mustaqim','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:04:39','1','','TKRO','','','','','','',''),(121785,'','smkhidayatulinsaniabadi.sch.id','Mirwansyah','','mirwansyah','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:03:31','1','','TKRO','','','','','','',''),(121784,'','smkhidayatulinsaniabadi.sch.id','MUHAMMAD BADALI','','muhammad-badali','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:02:34','1','','TKRO','','','','','','',''),(121783,'','smkhidayatulinsaniabadi.sch.id','RAHMAT RANDIKA','','rahmat-randika','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 13:01:39','1','','TKRO','','','','','','',''),(121782,'','smkhidayatulinsaniabadi.sch.id','RYAN ALYANI','','ryan-alyani','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 12:58:57','1','','TKRO','','','','','','',''),(121781,'','smkhidayatulinsaniabadi.sch.id','Suhardi','','suhardi','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 12:57:28','1','','TKRO','','','','','','',''),(121780,'','smkhidayatulinsaniabadi.sch.id','THAURA ARRIDHA','','thaura-arridha','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','','','2021-06-15 12:55:44','1','','TKRO','','','','','','',''),(121779,'','smkhidayatulinsaniabadi.sch.id','Yarham Agung Laksono','','yarham-agung-laksono','','','','0000-00-00','L','','Bener Meriah','','24582',9436,'','','','','','','Islam','','2021-06-15 12:54:35','1','','TKRO','','','','','','',''),(121778,'','smkhidayatulinsaniabadi.sch.id','AULIA AMANDA PUTRI','','aulia-amanda-putri','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','Islam','','2021-06-15 12:52:39','1','','Tata Busana','','','','','','',''),(121777,'','smkhidayatulinsaniabadi.sch.id','HIJRAH ALMUNAWAR','','hijrah-almunawar','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','Islam','','2021-06-15 12:50:13','1','','Tata Busana','','','','','','',''),(121776,'','smkhidayatulinsaniabadi.sch.id','LUTHFIA SABILLAH','','luthfia-sabillah','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','Islam','','2021-06-15 12:49:26','1','','Tata Busana','','','','','','',''),(121775,'','smkhidayatulinsaniabadi.sch.id','MELIA UTARI','','melia-utari','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','Islam','','2021-06-15 12:47:25','1','','Tata Busana','','','','','','',''),(121774,'','smkhidayatulinsaniabadi.sch.id','Nurhaliza','','nurhaliza','','','','0000-00-00','P','','Bener Meriah','','24582',0,'','','','','','','Islam','','2021-06-15 12:45:16','1','','','','','','','','',''),(121773,'','smkhidayatulinsaniabadi.sch.id','RINI SAHARA FITRI','','rini-sahara-fitri','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','','','2021-06-15 12:44:00','1','','Tata Busana','','','','','','',''),(121772,'','smkhidayatulinsaniabadi.sch.id','UMI ABNI ARESTY','','umi-abni-aresty','','','','0000-00-00','P','','Bener Meriah','','24582',9437,'','','','','','','','','2021-06-15 12:41:58','1','','Tata Busana','','','','','','',''),(121771,'','smkhidayatulinsaniabadi.sch.id','IRSADI','','irsadi','','','','0000-00-00','P','0043492735','Bener Meriah','','24582',9438,'','','','','','','Islam','','2021-06-15 12:39:07','1','','Tata Busana','','','','','','',''),(121770,'','smkhidayatulinsaniabadi.sch.id','Anisa Fitria','','anisa-fitria','','','','0000-00-00','P','','Bener Meriah','','24582',9438,'','','','','','','Islam','','2021-06-15 12:37:54','1','','Tata Busana','','','','','','',''),(121769,'','smkhidayatulinsaniabadi.sch.id','Raodah','','raodah','','','','0000-00-00','P','0048639983','Bener Meriah','','24582',9438,'','','','','','','Islam','','2021-06-15 12:33:12','1','','Tata Busana','','','','','','',''),(121768,'','smkhidayatulinsaniabadi.sch.id','RENI SULISDIANI','','reni-sulisdiani','','','','0000-00-00','P','0043379862','Bener Meriah','','24582',9438,'','','','','','','Islam','','2021-06-15 12:30:21','1','','Tata Busana','','','','','','',''),(121767,'','smkhidayatulinsaniabadi.sch.id','LILIS ANDRIANI','','lilis-andriani','','','','0000-00-00','P','0048639983','Bener Meriah','','24582',9438,'','','','','','','','','2021-06-15 12:28:38','1','','Tata Busana','','','','','','',''),(121766,'','smkhidayatulinsaniabadi.sch.id','GUSTINAWATI','','gustinawati','','','','0000-00-00','P','0032379316','Bener Meriah','','24582',9438,'','','','','','','','','2021-06-15 12:25:09','1','','Tata Busana','','','','','','',''),(121765,'','smkhidayatulinsaniabadi.sch.id','DEVI AFRILIA','','devi-afrilia','','','','0000-00-00','P','0043492850','Bener Meriah','','24582',9438,'','','','','','','','','2021-06-15 12:21:37','1','','Tata Busana','','','','','','',''),(121764,'','smkhidayatulinsaniabadi.sch.id','ANNISA NOVIANTI','','annisa-novianti','','','','0000-00-00','P','0043492852','Bener Meriah','','24582',9438,'','','','','','','','','2021-06-15 12:17:23','1','','Tata Busana','','','','','','',''),(121763,'','smkhidayatulinsaniabadi.sch.id','ANGGUN DENIS BERLIANA','','anggun-denis-berliana','Selisih Mara','','','0000-00-00','P','0035391005','Bener Meriah','','24582',9438,'','','','','','','','','2021-06-15 12:14:32','1','','Tata Busana','','','','','','',''),(121762,'','smkhidayatulinsaniabadi.sch.id','WAHYU KHAIRUL PRATAMA','','wahyu-khairul-pratama','','','','0000-00-00','L','','Bener Meriah','','24582',9434,'','','','','','','','','2021-06-15 12:03:23','1','','TKRO','','','','','','',''),(121760,'','smkhidayatulinsaniabadi.sch.id','Sutondo Widdyanto','','sutondo-widdyanto','','','','0000-00-00','L','','','','',9434,'','','','','','','','','2021-06-15 11:59:07','1','','TKRO','','','','','','',''),(121761,'','smkhidayatulinsaniabadi.sch.id','WAHAB AIDIL','','wahab-aidil','','','','0000-00-00','L','0022752581','Bener Meriah','','24582',9434,'','','','','','','','','2021-06-15 12:01:41','1','','TKRO','','','','','','',''),(121759,'','smkhidayatulinsaniabadi.sch.id','SULTAN YUDI PRATAMA','','sultan-yudi-pratama',' Puja Mulia','',' Pondok Baru','2004-02-08','L','0043492844','Bener Meriah','','24582',9434,'','','','','','','Islam','','2021-06-15 11:57:58','1','','TKRO','','','','','','',''),(121757,'','smkhidayatulinsaniabadi.sch.id','RIDUANSYAH','','riduansyah','Mantam\r\n','','Mantam','2004-03-13','L','','','','',9434,'','','','','','','Islam','','2021-06-15 10:22:22','1','','TKRO','','','','','','',''),(121758,'','smkhidayatulinsaniabadi.sch.id','Rudi M. Ramdan','','rudi-m-ramdan','Mutiara','','','2003-11-28','L','0039035526','Bener Meriah','','24582',9434,'','','','','','','Islam','','2021-06-15 11:48:11','1','','TKRO','','','','','','',''),(121756,'','smkhidayatulinsaniabadi.sch.id','REZEKI ANGGA ANTONI','','rezeki-angga-antoni','Sidodadi','','Sidodadi','2004-04-09','L','0043104190','Bener Meriah','','24582',9434,'','','','','','','Islam','','2021-06-15 10:11:07','1','','TKRO','','','','','','',''),(121755,'','smkhidayatulinsaniabadi.sch.id','RAHMAT MAULANA','','rahmat-maulana','Uyem Lime Tansaran Bidin\r\n','','Tansaran Bidin','2004-01-02','L','0047217333','Bener Meriah','','24582',9434,'','','','','','','Islam','','2021-06-15 10:04:43','1','','TKRO','','','','','','','');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `slideshow`
--

CREATE TABLE `slideshow` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `deskripsi` varchar(100) NOT NULL,
  `url` varchar(200) NOT NULL,
  `url_text` varchar(50) NOT NULL,
  `target` enum('_parent','_blank') NOT NULL DEFAULT '_parent',
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=157822 DEFAULT CHARSET=latin1;




INSERT INTO `slideshow` VALUES (63231,'smkhidayatulinsaniabadi.sch.id','Desain dan Produksi Busana','desain-dan-produksi-busana','Siap membentuk peserta didik yang kompeten di bidang desain busana dan mampu memproduksi busana ','','','_parent','71034847WhatsAppImage2023-04-24at20.56.35.jpeg','2021-03-19 11:00:19','1'),(63232,'smkhidayatulinsaniabadi.sch.id','Selamat Datang di SMK HIA','selamat-datang-di-smk-hia','','https://forms.gle/uq8Qn1zqk5j3Ve457','','_parent','9827777WhatsAppImage2023-04-24at20.40.28.jpeg','2021-03-19 11:00:19','1'),(64788,'smkhidayatulinsaniabadi.sch.id','Teknik Kendaraan Ringan Otomotif','teknik-kendaraan-ringan-otomotif','Siap membentuk peserta didik yang kompeten di indutri otomotif','','','_parent','86484493IMG-20220204-WA0063.jpg','2021-06-28 10:15:54','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `link` varchar(100) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nip` varchar(50) NOT NULL,
  `nuptk` varchar(30) NOT NULL,
  `status` varchar(50) NOT NULL,
  `pendidikan` varchar(50) NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `kelamin_jenis` varchar(50) NOT NULL,
  `agama` varchar(50) NOT NULL,
  `tempat_lahir` varchar(50) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` text NOT NULL,
  `kota` varchar(50) NOT NULL,
  `kodepos` varchar(10) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `gambar` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  `instansi` varchar(100) NOT NULL,
  `umur` varchar(50) NOT NULL,
  `keterangan` varchar(100) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=10947 DEFAULT CHARSET=latin1;




INSERT INTO `staff` VALUES (9642,'smkhidayatulinsaniabadi.sch.id','azhar-mahendra-skom','Azhar Mahendra. S.Kom','','','','S-1 Sistem Komputer','Bendahara BOS','L','Islam','','0000-00-00','Selisih Mara, Dusun Sara Rasa','Bener Meriah','24582','','','2022-11-03 12:42:20','1','SMK Hidayatul Insani Abadi','','','','',''),(7792,'smkhidayatulinsaniabadi.sch.id','irma-haryani-se','Irma Haryani, S.E','-','9861770671230182','Tenaga Kependidikan','S1','Ka. tenaga Administrasi Sekolah ','P','Islam','Cemparam','1992-05-29','Cemparam Lama\r\n','Bener Meriah','24582','082267972882','','2021-06-14 12:40:45','1','Yayasan ','29','','','',''),(7791,'smkhidayatulinsaniabadi.sch.id','leni-septiani-spi','Leni Septiani, S.Pi','','','Operator','S1','Operator Dapodik','P','Islam','Takengon','1993-09-03','Selish Mara','Bener Meriah','24582','082276072766','','2021-06-14 12:32:05','1','Yayasan ','28','Operator Dapodik dan Operator sekolah SMK hia','','',''),(7790,'smkhidayatulinsaniabadi.sch.id','turi-hudayani-abadi','Turi Hudayani Abadi','19810618 200904 2 007','2950759661220002','Kepala Sekolah','S1','Kepala Sekolah','P','Islam','Takengon','1981-06-18','Tingkem','Bener Meriah','24582','082296126349','','2021-06-14 12:17:08','1','Yayasan ','40','Menjabat Sebagai Kepala Sekoah','','',''),(7793,'smkhidayatulinsaniabadi.sch.id','wahyu-diana-sip','Wahyu Diana, S.IP','','','Tendik','S1','Kepala perpustakaan','P','Islam','Belang Panas','1994-12-04','Pondok Baru\r\n','Bener Meriah','24582','','','2021-06-15 09:27:09','1','Yayasan ','27','Menjabat Sebagai Kepala perpustakaan SMK Hidayatul Insani Abadi','','','');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `struktur_organisasi`
--

CREATE TABLE `struktur_organisasi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(100) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `jabatan` enum('Kepala Sekolah','Bendahara','TU','Waka') DEFAULT NULL,
  `telepon` varchar(50) DEFAULT NULL,
  `keterangan` varchar(50) DEFAULT NULL,
  `tgl` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `publish` enum('1','0') NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `teks`
--

CREATE TABLE `teks` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_module` int(11) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `isi` longtext NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1938 DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `template_simpen`
--

CREATE TABLE `template_simpen` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `head1` enum('N','Y') NOT NULL,
  `head2` enum('N','Y') NOT NULL,
  `head3` enum('N','Y') NOT NULL,
  `head4` enum('N','Y') NOT NULL,
  `alamat` enum('N','Y') NOT NULL,
  `logo` enum('N','Y') NOT NULL,
  `logo2` enum('N','Y') NOT NULL,
  `kopsurat` enum('N','Y') NOT NULL,
  `judulsurat` enum('N','Y') NOT NULL,
  `nomor_surat` enum('N','Y') NOT NULL,
  `surat_prolog` enum('N','Y') NOT NULL,
  `surat_isi` enum('N','Y') NOT NULL,
  `surat_penutup` enum('N','Y') NOT NULL,
  `tahun_ajaran` enum('N','Y') NOT NULL,
  `tempat_keputusan` enum('N','Y') NOT NULL,
  `tanggal_keputusan` enum('N','Y') NOT NULL,
  `ttd_kepsek` enum('N','Y') NOT NULL,
  `nama_kepsek` enum('N','Y') NOT NULL,
  `nip_kepsek` enum('N','Y') NOT NULL,
  `stempel` enum('N','Y') NOT NULL,
  `link` varchar(100) NOT NULL,
  `nis` enum('N','Y') NOT NULL,
  `nisn` enum('N','Y') NOT NULL,
  `nik` enum('N','Y') NOT NULL,
  `npsn` enum('N','Y') NOT NULL,
  `nomor_ujian` enum('N','Y') NOT NULL,
  `nomor_peserta` enum('N','Y') NOT NULL,
  `ttl` enum('N','Y') NOT NULL,
  `tempat_lahir` enum('N','Y') NOT NULL,
  `tgl_lahir` enum('N','Y') NOT NULL,
  `tanggal_lahir` enum('N','Y') NOT NULL,
  `nama_orang_tua` enum('N','Y') NOT NULL,
  `jenis_kelamin` enum('N','Y') NOT NULL,
  `kelas` enum('N','Y') NOT NULL,
  `jurusan` enum('N','Y') NOT NULL,
  `nama_siswa` varchar(200) NOT NULL,
  `rata_rata_us` enum('N','Y') NOT NULL,
  `rata_rata_un` enum('N','Y') NOT NULL,
  `mapel_pilihan_rapor` enum('N','Y') NOT NULL,
  `mapel_pilihan_ns` enum('N','Y') NOT NULL,
  `mapel_pilihan_un` enum('N','Y') NOT NULL,
  `mapel_pilihan_akhir` enum('N','Y') NOT NULL,
  `mapel_pilihan_rapor_dua` enum('N','Y') NOT NULL,
  `mapel_pilihan_ns_dua` enum('N','Y') NOT NULL,
  `ind_ns` enum('N','Y') NOT NULL,
  `ind_un` enum('N','Y') NOT NULL,
  `ind_rapor` enum('N','Y') NOT NULL,
  `ind_us_praktik` enum('N','Y') NOT NULL,
  `ind_us_tulis` enum('N','Y') NOT NULL,
  `ind_akhir` enum('N','Y') NOT NULL,
  `antro_un` enum('N','Y') NOT NULL,
  `arab_un` enum('N','Y') NOT NULL,
  `arab_rapor` enum('N','Y') NOT NULL,
  `arab_us` enum('N','Y') NOT NULL,
  `prakarya_rapor` enum('N','Y') NOT NULL,
  `prakarya_ns` enum('N','Y') NOT NULL,
  `prakarya_us` enum('N','Y') NOT NULL,
  `arab_ns` enum('N','Y') NOT NULL,
  `akhlak_un` enum('N','Y') NOT NULL,
  `akidah_un` enum('N','Y') NOT NULL,
  `sastra_un` enum('N','Y') NOT NULL,
  `tafsir_un` enum('N','Y') NOT NULL,
  `tafsir_ns` enum('N','Y') NOT NULL,
  `hadis_rapor` enum('N','Y') NOT NULL,
  `ski_un` enum('N','Y') NOT NULL,
  `fikih_un` enum('N','Y') NOT NULL,
  `kalam_un` enum('N','Y') NOT NULL,
  `ing_ns` enum('N','Y') NOT NULL,
  `ing_un` enum('N','Y') NOT NULL,
  `ing_rapor` enum('N','Y') NOT NULL,
  `ing_us_tulis` enum('N','Y') NOT NULL,
  `ing_us_praktik` enum('N','Y') NOT NULL,
  `ing_akhir` enum('N','Y') NOT NULL,
  `mat_ns` enum('N','Y') NOT NULL,
  `mat_un` enum('N','Y') NOT NULL,
  `mat_rapor` enum('N','Y') NOT NULL,
  `mat_us_praktik` enum('N','Y') NOT NULL,
  `mat_us_tulis` enum('N','Y') NOT NULL,
  `mat_akhir` enum('N','Y') NOT NULL,
  `ipa_ns` enum('N','Y') NOT NULL,
  `ipa_un` enum('N','Y') NOT NULL,
  `ipa_rapor` enum('N','Y') NOT NULL,
  `ipa_us_praktik` enum('N','Y') NOT NULL,
  `ipa_us_tulis` enum('N','Y') NOT NULL,
  `fis_rapor` enum('N','Y') NOT NULL,
  `ipa_akhir` enum('N','Y') NOT NULL,
  `fis_ns` enum('N','Y') NOT NULL,
  `fis_un` enum('N','Y') NOT NULL,
  `fis_akhir` enum('N','Y') NOT NULL,
  `kim_rapor` enum('N','Y') NOT NULL,
  `kim_ns` enum('N','Y') NOT NULL,
  `kim_un` enum('N','Y') NOT NULL,
  `kim_akhir` enum('N','Y') NOT NULL,
  `bio_rapor` enum('N','Y') NOT NULL,
  `bio_ns` enum('N','Y') NOT NULL,
  `bio_un` enum('N','Y') NOT NULL,
  `bio_akhir` enum('N','Y') NOT NULL,
  `eko_rapor` enum('N','Y') NOT NULL,
  `eko_ns` enum('N','Y') NOT NULL,
  `eko_un` enum('N','Y') NOT NULL,
  `eko_akhir` enum('N','Y') NOT NULL,
  `sos_rapor` enum('N','Y') NOT NULL,
  `sos_ns` enum('N','Y') NOT NULL,
  `sos_un` enum('N','Y') NOT NULL,
  `sos_akhir` enum('N','Y') NOT NULL,
  `geo_rapor` enum('N','Y') NOT NULL,
  `geo_ns` enum('N','Y') NOT NULL,
  `geo_un` enum('N','Y') NOT NULL,
  `geo_akhir` enum('N','Y') NOT NULL,
  `agama_rapor` enum('N','Y') NOT NULL,
  `agama_us_tulis` enum('N','Y') NOT NULL,
  `agama_us_praktik` enum('N','Y') NOT NULL,
  `agama_ns` enum('N','Y') NOT NULL,
  `pkn_rapor` enum('N','Y') NOT NULL,
  `pkn_us_tulis` enum('N','Y') NOT NULL,
  `pkn_us_praktik` enum('N','Y') NOT NULL,
  `pkn_ns` enum('N','Y') NOT NULL,
  `ips_rapor` enum('N','Y') NOT NULL,
  `ips_us_tulis` enum('N','Y') NOT NULL,
  `ips_un` enum('N','Y') NOT NULL,
  `ips_us_praktik` enum('N','Y') NOT NULL,
  `ips_ns` enum('N','Y') NOT NULL,
  `sbk_rapor` enum('N','Y') NOT NULL,
  `sbk_us_tulis` enum('N','Y') NOT NULL,
  `sbk_us_praktik` enum('N','Y') NOT NULL,
  `sbk_ns` enum('N','Y') NOT NULL,
  `penjas_rapor` enum('N','Y') NOT NULL,
  `penjas_us_tulis` enum('N','Y') NOT NULL,
  `penjas_us_praktik` enum('N','Y') NOT NULL,
  `penjas_ns` enum('N','Y') NOT NULL,
  `budpek_rapor` enum('N','Y') NOT NULL,
  `budpek_us_tulis` enum('N','Y') NOT NULL,
  `budpek_us_praktik` enum('N','Y') NOT NULL,
  `budpek_ns` enum('N','Y') NOT NULL,
  `sejarah_ns` enum('N','Y') NOT NULL,
  `sejarah_rapor` enum('N','Y') NOT NULL,
  `sejarah_tulis` enum('N','Y') NOT NULL,
  `sejarah_praktek` enum('N','Y') NOT NULL,
  `pjok_ns` enum('N','Y') NOT NULL,
  `tik_rapor` enum('N','Y') NOT NULL,
  `tik_ns` enum('N','Y') NOT NULL,
  `keterampilan_ns` enum('N','Y') NOT NULL,
  `keterampilan_rapor` enum('N','Y') NOT NULL,
  `pariwisata_ns` enum('N','Y') NOT NULL,
  `utk_ns` enum('N','Y') NOT NULL,
  `utk_un` enum('N','Y') NOT NULL,
  `kompetensi_ns` enum('N','Y') NOT NULL,
  `kompetensi_akhir` enum('N','Y') NOT NULL,
  `kompetensi_keahlian` enum('N','Y') NOT NULL,
  `antropologi_ns` enum('N','Y') NOT NULL,
  `antropologi_akhir` enum('N','Y') NOT NULL,
  `sastra_ns` enum('N','Y') NOT NULL,
  `sastra_akhir` enum('N','Y') NOT NULL,
  `sastra_rapor` enum('N','Y') NOT NULL,
  `bhs_jerman_ns` enum('N','Y') NOT NULL,
  `bhs_jerman_akhir` enum('N','Y') NOT NULL,
  `hadis_uambnbk` enum('N','Y') NOT NULL,
  `hadis_ns` enum('N','Y') NOT NULL,
  `akidah_uambnbk` enum('N','Y') NOT NULL,
  `fikih_uambnbk` enum('N','Y') NOT NULL,
  `fikih_ns` enum('N','Y') NOT NULL,
  `ski_uambnbk` enum('N','Y') NOT NULL,
  `arab_uambnbk` enum('N','Y') NOT NULL,
  `akhlak_uambnbk` enum('N','Y') NOT NULL,
  `kalam_uambnbk` enum('N','Y') NOT NULL,
  `utk_akhir` enum('N','Y') NOT NULL,
  `total` enum('N','Y') NOT NULL,
  `rata_rata` decimal(5,2) NOT NULL,
  `nilai` enum('N','Y') NOT NULL,
  `asal_sekolah` varchar(100) NOT NULL,
  `agama_akhir` enum('N','Y') NOT NULL,
  `hadits_akhir` enum('N','Y') NOT NULL,
  `akhlak_akhir` enum('N','Y') NOT NULL,
  `akhlak_ns` enum('N','Y') NOT NULL,
  `fikih_akhir` enum('N','Y') NOT NULL,
  `sejarah_islam_akhir` enum('N','Y') NOT NULL,
  `sejarah_islam_ns` enum('N','Y') NOT NULL,
  `pkn_akhir` enum('N','Y') NOT NULL,
  `arab_akhir` enum('N','Y') NOT NULL,
  `ips_akhir` enum('N','Y') NOT NULL,
  `seni_budaya_akhir` enum('N','Y') NOT NULL,
  `penjas_akhir` enum('N','Y') NOT NULL,
  `keterampilan_akhir` enum('N','Y') NOT NULL,
  `tik_akhir` enum('N','Y') NOT NULL,
  `muatan_lokal_ns` enum('N','Y') NOT NULL,
  `muatan_lokal_rapor` enum('N','Y') NOT NULL,
  `km_rapor` enum('N','Y') NOT NULL,
  `km_ns` enum('N','Y') NOT NULL,
  `pai_rpt2` enum('N','Y') NOT NULL,
  `pkn_rpt2` enum('N','Y') NOT NULL,
  `indo_rpt2` enum('N','Y') NOT NULL,
  `ingg_rpt2` enum('N','Y') NOT NULL,
  `mat_rpt2` enum('N','Y') NOT NULL,
  `ipa_rpt2` enum('N','Y') NOT NULL,
  `ips_rpt2` enum('N','Y') NOT NULL,
  `sb_rpt2` enum('N','Y') NOT NULL,
  `penjas_rpt2` enum('N','Y') NOT NULL,
  `prakarya_rpt2` enum('N','Y') NOT NULL,
  `jawa_rpt2` enum('N','Y') NOT NULL,
  `agama_us` enum('N','Y') NOT NULL,
  `pkn_us` enum('N','Y') NOT NULL,
  `ind_us` enum('N','Y') NOT NULL,
  `ing_us` enum('N','Y') NOT NULL,
  `mat_us` enum('N','Y') NOT NULL,
  `ipa_us` enum('N','Y') NOT NULL,
  `ips_us` enum('N','Y') NOT NULL,
  `sbk_us` enum('N','Y') NOT NULL,
  `penjas_us` enum('N','Y') NOT NULL,
  `prakarya_nus` enum('N','Y') NOT NULL,
  `jawa_us` enum('N','Y') NOT NULL,
  `kwu_rapor` enum('N','Y') NOT NULL,
  `kwu_ns` enum('N','Y') NOT NULL,
  `b_asing_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_1_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_2_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_3_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_4_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_5_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_6_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_7_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_8_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_9_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_10_ns` enum('N','Y') NOT NULL,
  `mapel_tambahan_1_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_2_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_3_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_4_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_5_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_6_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_7_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_8_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_9_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_10_us` enum('N','Y') NOT NULL,
  `mapel_tambahan_1_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_2_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_3_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_4_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_5_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_6_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_7_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_8_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_9_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_10_rapor` enum('N','Y') NOT NULL,
  `mapel_tambahan_1_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_2_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_3_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_4_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_5_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_6_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_7_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_8_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_9_akhir` enum('N','Y') NOT NULL,
  `mapel_tambahan_10_akhir` enum('N','Y') NOT NULL,
  `tampilkan_keputusan` enum('N','Y') NOT NULL,
  `tampilkan_nilai` enum('N','Y') NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `keputusan` varchar(32) NOT NULL DEFAULT 'LULUS',
  `kurikulum` varchar(100) NOT NULL,
  `pemrograman` decimal(5,2) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`),
  KEY `subdomain` (`subdomain`)
) ENGINE=MyISAM AUTO_INCREMENT=1265 DEFAULT CHARSET=latin1;




INSERT INTO `template_simpen` VALUES (709,'smkhidayatulinsaniabadi.sch.id','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','Y','N','Y','N','N','Y','N','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',0.00,'N','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','LULUS','',0.00,'2021-04-11 10:37:55','1');


--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `tmp_kartu`
--

CREATE TABLE `tmp_kartu` (
  `subdomain` varchar(75) NOT NULL,
  `psb_member_id` int(11) NOT NULL,
  `kartu_id` int(11) NOT NULL,
  `tgl` datetime NOT NULL,
  PRIMARY KEY (`psb_member_id`),
  KEY `kartu_id` (`kartu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------






--
-- Host: localhost    Database: websitesekolahmy_cmsdb
-- ------------------------------------------------------


--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(75) NOT NULL,
  `id_module` int(11) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `url` varchar(200) NOT NULL,
  `tgl` datetime NOT NULL,
  `publish` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=32896 DEFAULT CHARSET=latin1;




INSERT INTO `video` VALUES (28613,'smkhidayatulinsaniabadi.sch.id',0,'IOT Teknologi Sistem Pintar Gerbang Sekolah','iot-teknologi-sistem-pintar-gerbang-sekolah','https://www.youtube.com/watch?v=Er3eWUhcP30','2021-08-23 08:35:09','1'),(30524,'smkhidayatulinsaniabadi.sch.id',0,'Pamplet','pamplet','https://vt.tiktok.com/ZSRPECkJK/','2022-09-08 12:14:44','1'),(30794,'smkhidayatulinsaniabadi.sch.id',0,'Manusia kuat- Tulus (Cover by SMK HIA)','manusia-kuat--tulus-cover-by-smk-hia','https://youtu.be/vIbsOiz8v84','2022-11-24 12:27:59','1'),(28730,'smkhidayatulinsaniabadi.sch.id',0,'smk hidayatul insani abadi berbagi takjil','smk-hidayatul-insani-abadi-berbagi-takjil','https://www.youtube.com/watch?v=WZIGQnIaK1k','2021-09-09 10:09:40','1'),(28729,'smkhidayatulinsaniabadi.sch.id',0,'profil sekolah','profil-sekolah','https://youtu.be/02X1YAciAJw','2021-09-09 08:49:37','1');


