--
-- 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 (22592,'smktkmecirebon.sch.id',147640,'Banner ','Banner','','_blank','ban1.jpg','2019-06-27 15:51:14','1'),(22593,'smktkmecirebon.sch.id',147648,'Banner ','Banner','','_blank','ban1.jpg','2020-01-08 11:43:46','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 (122670,'smktkmecirebon.sch.id','Pendaftaran Online','pendaftaran-online','Untuk Pendaftaran PPDB Online 2024, Silahkan Klik link d bawah ini&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href=&quot;https://docs.google.com/forms/d/1OCzc6_uaVN2nH2tpMs6u2ohGBGGFOcGN6phVyyiEfJ4/edit?usp=sharing&quot; title=&quot;Pendaftaran Online&quot; target=&quot;_blank&quot;&gt;(ONLINE)&lt;/a&gt;&lt;br&gt;&lt;/div&gt;','Pendaftaran Online SMK TKME CIREBON',',31614,','',31614,'1','0','1','1','1','1','1','1','1',1002,'23138807BROSURPPDBprint_001.jpg','2024-05-11 11:37:24','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 (31613,'smktkmecirebon.sch.id','Artikel','artikel','2019-06-27 15:51:14','1'),(31612,'smktkmecirebon.sch.id','Berita','berita','2019-06-27 15:51:14','1'),(31711,'smktkmecirebon.sch.id','cek','cek','2020-01-18 09:04:39','1'),(31614,'smktkmecirebon.sch.id','Pendaftaran Online','pendaftaran-online','2020-01-11 12:25:13','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 (248,'smktkmecirebon.sch.id','smk-taman-karya-madya-ekonomi-tkme-cirebon','SMK TAMAN KARYA MADYA EKONOMI (TKME) CIREBON','SMK SWASTA','32442630316',20222169,'0000-00-00','B (2023)','BISNIS MANAJEMEN - AKUNTANSI','72/i02.1/Kep/OT/2001','1774 m2','MERDEKA BERBAGI','07.00 -16.00',16,87,4,0,'','','SMK Taman Karya Madya Ekonomi (TKME) Cirebon merupakan sekolah SMK swasta dibawah naungan Yayasan Persatuan Perguruan Tamansiswa Cabang Cirebon yang berpusat di tamansiswa Yogyakarta.\r\nKompetensi Keahlian Akuntansi dan Lembaga Keuangan','Aris Sunandar,SP.','','','','','','2024-09-30','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 (225847,'smktkmecirebon.sch.id','Memperingati Hari Guru 2024','memperingati-hari-guru-2024',9346,'40057047WhatsAppImage2024-12-19at09.02.02.jpeg','2024-12-19 09:09:59','1'),(225848,'smktkmecirebon.sch.id','Seminar Penguatan Kapasitas dan Tata Kelola Satuan Pendidikan dalam Implementasi kurikulum Nasional','seminar-penguatan-kapasitas-dan-tata-kelola-satuan-pendidikan-dalam-implementasi-kurikulum-nasional',9345,'4109475WhatsAppImage2024-12-19at09.55.47.jpeg','2024-12-19 09:15:10','1'),(225846,'smktkmecirebon.sch.id','Memperingati Hari Guru 2024','memperingati-hari-guru-2024',9346,'32829153WhatsAppImage2024-12-19at09.02.02(1).jpeg','2024-12-19 09:09:44','1'),(225844,'smktkmecirebon.sch.id','Perkemahan Perjusami','perkemahan-perjusami',9346,'2370294WhatsAppImage2024-12-19at09.02.33.jpeg','2024-12-19 09:06:21','1'),(225845,'smktkmecirebon.sch.id','Perkemahan Perjusami','perkemahan-perjusami',9346,'14812054WhatsAppImage2024-12-19at09.02.34.jpeg','2024-12-19 09:09:01','1'),(225849,'smktkmecirebon.sch.id','Seminar Penguatan Kapasitas dan Tata Kelola Satuan Pendidikan dalam Implementasi kurikulum Nasional','seminar-penguatan-kapasitas-dan-tata-kelola-satuan-pendidikan-dalam-implementasi-kurikulum-nasional',9345,'75107181WhatsAppImage2024-12-19at09.55.46.jpeg','2024-12-19 09:15:30','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 (9345,'smktkmecirebon.sch.id','Kegiatan Guru','kegiatan-guru','2020-01-11 11:37:13','1'),(9346,'smktkmecirebon.sch.id','Kegiatan Siswa','kegiatan-siswa','2024-05-11 11:37:24','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 (30236,'smktkmecirebon.sch.id','aris-sunandarsp','Aris Sunandar,S.P.','','','',2011,'Menikah','Sarjana (S1)','','Kepala Sekolah','Informatika','L','ISLAM','Cirebon','0000-00-00','','Cirebon','','','','','','','110937795ki-aris-sunandars.p.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30239,'smktkmecirebon.sch.id','drs-sugiarto','Drs Sugiarto','','','',0000,'Menikah','Sarjana (S1)','','','PKKN','L','Islam','Bondowoso','1959-10-01','','Cirebon','','','','','','','2022598804ki-drs.sugiarto.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30241,'smktkmecirebon.sch.id','dra-hasih-nurlaeli','Dra Hasih Nurlaeli','','','',0000,'','','','','Bimbingan Konseling','P','','','0000-00-00','','','','','','','','','1439344754nyi-dra-hasih-nurlaeli.jpg','','','','','','','','','','','','2020-01-11 09:21:06','1'),(30242,'smktkmecirebon.sch.id','iwan-intan-buanas.pd','Iwan Intan Buana,S.Pd','','','',0000,'','','','','','','','','0000-00-00','','','','','','','','','368744888ki-iwan-intan-buanas.pd.jpg','','','','','','','','','','','','2020-01-11 09:26:41','1'),(30243,'smktkmecirebon.sch.id','ayu-marliantispd','Ayu Marlianti,S.Pd','','','',0000,'Menikah','Sarjana (S1)','','Kaprodi Akuntansi','Produktif Akuntansi','P','Islam','Cirebon','0000-00-00','','','','','','','','','821380404ayu-marlianti.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30244,'smktkmecirebon.sch.id','sayfurrakhmanspd','Sayfurrakhman,S.Pd','','','',2020,'Menikah','Sarjana (S1)','','Pembina OSIS','Produktif Akuntansi','L','Islam','Cirebon','0000-00-00','','','','','','','','','1827739132dscf44506.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(77289,'smktkmecirebon.sch.id','satrio-saputro-spd','Satrio Saputro, S.Pd','','','',0000,'Belum Menikah','Sarjana (S1)','','','Bahasa Inggris','L','Islam','Cirebon','2001-05-22','','','','','','','','','5976459IMG-20241001-WA0000.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30247,'smktkmecirebon.sch.id','yuliana-spd','Yuliana S.Pd','','','',0000,'Menikah','Sarjana (S1)','','','Produktif Akuntansi','P','Islam','Cirebon','0000-00-00','','','','','','','','','1118191589yuli.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30248,'smktkmecirebon.sch.id','iis-kristiyanaspd','Iis Kristiyana,S.Pd','','','',0000,'Menikah','Sarjana (S1)','','','Bahasa Indonesia','L','Islam','Cirebon','0000-00-00','','','','','','','','','960997828b-iis.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(77288,'smktkmecirebon.sch.id','deti-irmawati-spd','Deti Irmawati, S.Pd','','','',0000,'Belum Menikah','Sarjana (S1)','','','Matematika','P','Islam','Cirebon','2004-08-08','','','','','','','','','997308FotoDetiIrmawati-1.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(30252,'smktkmecirebon.sch.id','ahmad-hariss.ag','Ahmad haris,S.Ag','','','',0000,'','','','','','','','','0000-00-00','','','','','','','','','736430331ki-ahmad-hariss.pdi.jpg','','','','','','','','','','','','2020-01-11 10:15:07','1'),(30255,'smktkmecirebon.sch.id','muslimspd','Muslim,S.Pd','','','',0000,'Belum Menikah','Sarjana (S1)','','','Pendidikan Agama Islam','L','Islam','','0000-00-00','','','','','','','','','1805260702muslimjpg.jpg','','','','','','','','','','','','0000-00-00 00:00:00','1'),(77287,'smktkmecirebon.sch.id','sri-astuti-se','Sri Astuti, SE','','','',0000,'Belum Menikah','Sarjana (S1)','','Guru Mapel','PKKW, PKKN','P','Islam','Cirebon','0000-00-00','','','','','','','','','49006568214418820sri-astuti.jpg','','','','','','','','','','','','0000-00-00 00:00:00','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 (264750,'smktkmecirebon.sch.id','Struktur Organisasi','struktur-organisasi','tulis',0,'<img alt=struktur src=https://mysch.id/cms/picture/str1.jpg width=100%>','struktur organisasi','1','1','1','0','0','0','0','0','0',56,'',4,501490,'0',0,'2020-01-08 11:43:46','1'),(264759,'smktkmecirebon.sch.id','Pendaftaran PPDB Online 2024','pendaftaran-ppdb-online-2024','berita_kategori',31614,'','','1','1','1','0','0','0','0','0','0',0,'',5,264736,'0',1,'2024-09-30 14:16:37','1'),(264760,'smktkmecirebon.sch.id','Foto Kegiatan Siswa','foto-kegiatan-siswa','galeri_kategori',9346,'','','1','1','1','0','0','0','0','0','0',0,'',1,264747,'0',1,'2020-01-11 11:37:48','1'),(264761,'smktkmecirebon.sch.id','Foto Kegiatan Guru','foto-kegiatan-guru','galeri_kategori',9345,'','','1','1','1','0','0','0','0','0','0',0,'',2,264747,'0',1,'2020-01-11 11:39:25','1'),(264762,'smktkmecirebon.sch.id','Data Kepegawaian','data-kepegawaian','guru',0,'','','1','1','1','0','0','0','0','0','0',0,'',8,0,'1',1,'2020-01-11 11:22:48','1'),(264763,'smktkmecirebon.sch.id','Kontak','kontak','kontak',0,'','','1','1','1','0','0','0','0','0','0',0,'',10,0,'0',1,'2020-01-11 11:34:11','1'),(264758,'smktkmecirebon.sch.id','Staff','staff','staff',0,'','','1','1','1','0','0','0','0','0','0',0,'',2,264762,'0',1,'2020-01-11 11:21:47','1'),(264747,'smktkmecirebon.sch.id','Galeri','galeri','galeri',0,'Galeri','galeri','1','1','1','0','0','0','0','0','0',0,'',7,0,'1',1,'2020-01-08 11:43:46','1'),(264727,'smktkmecirebon.sch.id','Beranda','','home',0,'','','1','1','1','0','0','0','0','0','0',0,'',1,0,'0',0,'2020-01-11 09:05:46','1'),(264728,'smktkmecirebon.sch.id','Profil Sekolah','profil-sekolah','tulis',0,'<div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Nama Sekolah</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"nama_sekolah\" id=\"nama_sekolah\" class=\"form-control\" value=\"SMK TAMAN KARYA MADYA EKONOMI (TKME) CIREBON\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Jenis Sekolah</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"jenis_sekolah\" id=\"jenis_sekolah\" class=\"form-control\" value=\"SMK SWASTA\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">NSS</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"nss\" id=\"nss\" class=\"form-control\" value=\"32442630316\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">NPSN</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"npsn\" id=\"npsn\" class=\"form-control\" value=\"20222169\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Tanggal Berdiri</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"tanggal_berdiri\" id=\"tanggal_berdiri\" class=\"form-control\" value=\"0000-00-00\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Akreditasi</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"akreditasi\" id=\"akreditasi\" class=\"form-control\" value=\"B (2023)\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Program Jurusan</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"program_jurusan\" id=\"program_jurusan\" class=\"form-control\" value=\"BISNIS MANAJEMEN - AKUNTANSI\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Izin Operasional</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"izin_operasional\" id=\"izin_operasional\" class=\"form-control\" value=\"72/i02.1/Kep/OT/2001\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Luas Tanah</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"luas_tanah\" id=\"luas_tanah\" class=\"form-control\" value=\"1774 m2\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Kurikulum</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"kurikulum\" id=\"kurikulum\" class=\"form-control\" value=\"MERDEKA BERBAGI\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Jam Aktif</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"jam_aktif\" id=\"jam_aktif\" class=\"form-control\" value=\"07.00 -16.00\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Jumlah Guru dan Staff</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"jumlah_guru_staff\" id=\"jumlah_guru_staff\" class=\"form-control\" value=\"16\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Jumlah Siswa</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"jumlah_siswa\" id=\"jumlah_siswa\" class=\"form-control\" value=\"87\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_label\" style=\"width: 186.828px;\">Jumlah Rombel</div><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><input type=\"text\" name=\"jumlah_rombel\" id=\"jumlah_rombel\" class=\"form-control\" value=\"4\" style=\"line-height: 1.42857; width: 830.391px;\"></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_content\" style=\"width: 830.391px;\"><span style=\"text-transform: capitalize;\">Deskripsi</span><br></div></div><div id=\"view\" style=\"width: 1038px;\"><div class=\"view_dot\" style=\"width: 20.75px;\">:</div><div class=\"view_content\" style=\"width: 830.391px;\"><textarea name=\"deskripsi\" id=\"deskripsi\" class=\"form-control\" style=\"line-height: 1.42857; width: 830.391px; height: 80px;\"></textarea></div></div>','profil sekolah','1','1','1','0','0','0','0','0','0',749,'',2,0,'0',1,'2024-09-30 13:56:15','1'),(264731,'smktkmecirebon.sch.id','Berita','berita','berita_kategori',58819,'','berita','1','1','1','0','0','0','0','0','0',0,'',5,0,'0',0,'2020-01-08 11:43:46','1'),(264755,'smktkmecirebon.sch.id',' Pamong ;Guru','-pamong-guru','guru',0,'','','1','1','1','0','0','0','0','0','0',0,'',1,264762,'0',1,'2024-10-01 06:42:36','1'),(264735,'smktkmecirebon.sch.id','Kesiswaan','kesiswaan','tulis',0,'','kesiswaan','1','1','1','0','0','0','0','0','0',525,'',3,0,'0',1,'2019-06-27 15:51:14','1'),(264736,'smktkmecirebon.sch.id','Informasi','informasi','tulis',0,'<br>','informasi','1','1','1','0','0','0','0','0','0',469,'',6,0,'1',1,'2020-01-11 11:06:50','1'),(864780,'smktkmecirebon.sch.id','VISI MISI TUJUAN SMK TKME CIREBON','visi-misi-tujuan-smk-tkme-cirebon','tulis',0,'<p class=\"MsoTitle\" style=\"margin-left:21.3pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"IN\" style=\"font-size:12.0pt;line-height:150%\">A.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span style=\"font-size:12.0pt;line-height:150%;mso-ansi-language:EN-US\">Visi SMK\r\nTaman Karya Madya Ekonomi (TKME)</span><span lang=\"IN\" style=\"font-size:12.0pt;\r\nline-height:150%\"><o:p></o:p></span></p><p class=\"MsoTitle\" style=\"margin-left:21.3pt;text-align:justify;text-indent:\r\n21.25pt;line-height:150%\"><span style=\"font-size: 12pt; line-height: 150%;\">Terwujudnya\r\nlulusan yang beriman dan bertakwa kepada Tuhan Yang Maha Esa, berakhlak mulia,\r\nunggul, kompeten, kreatif, berwawasan profil pelajar Pancasila, serta menguasai\r\nteknologi, informasi dan komunikasi sampai dengan tahun 2027.</span><span lang=\"IN\" style=\"font-size:12.0pt;line-height:150%\"><o:p></o:p></span></p><p class=\"MsoTitle\" style=\"margin-left:21.3pt;text-align:justify;line-height:\r\n150%\"><span lang=\"IN\" style=\"font-size: 12pt; line-height: 150%;\">&nbsp;</span></p><p class=\"MsoTitle\" style=\"margin-left:21.3pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"IN\" style=\"font-size:12.0pt;line-height:150%\">B.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"IN\" style=\"font-size:12.0pt;line-height:150%\">M</span><span style=\"font-size:12.0pt;line-height:150%;mso-ansi-language:EN-US\">isi SMK Taman\r\nKarya Madya Ekonomi (TKME)</span><span lang=\"IN\" style=\"font-size:12.0pt;\r\nline-height:150%\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-top:12.0pt;margin-right:0cm;margin-bottom:\r\n0cm;margin-left:42.55pt;margin-bottom:.0001pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><!--[if !supportLists]--><span lang=\"IN\">a.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]--><span lang=\"IT-CH\">Meningkatkan kompetensi pendidik dan\r\ntenaga kependidikan yang profesional</span><span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><!--[if !supportLists]--><span lang=\"IN\">b.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]-->Mengembangkan\r\nkurikulum yang berpihak kepada siswa dan sesuai dengan kebutuhan dunia kerja<span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><!--[if !supportLists]--><span lang=\"IN\">c.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]-->Meningkatkan\r\nkarakter siswa yang sesuai dengan Profil Pelajar Pancasila<span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><!--[if !supportLists]--><span lang=\"IN\">d.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]-->Menanamkan\r\njiwa wirausaha dan melatih wirausaha berbasis <i>technosociopereneur</i><span lang=\"IN\"><o:p></o:p></span></p><p>\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</p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><!--[if !supportLists]--><span lang=\"IN\">e.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: \" times=\"\" new=\"\" roman\";\"=\"\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><!--[endif]-->Menjalin\r\nkemitraan dengan pemangku kepentingan, dunia kerja dan industri</p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><span lang=\"IN\"><o:p><br></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:21.3pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l1 level1 lfo1\"><b><span lang=\"IN\">C.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;\r\n</span></span></b><!--[endif]--><b><span lang=\"IN\">T</span>ujuan SMK Taman Karya Madya\r\nEkonomi (TKME)</b><b><span lang=\"IN\"><o:p></o:p></span></b></p><p class=\"MsoNormal\" style=\"margin-top:12.0pt;margin-right:0cm;margin-bottom:\r\n0cm;margin-left:42.55pt;margin-bottom:.0001pt;text-align:justify;text-indent:\r\n-21.25pt;line-height:150%;mso-list:l0 level1 lfo2\"><!--[if !supportLists]--><span lang=\"IN\">1.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]--><span lang=\"IN\">Me</span>ningkatkan\r\nkompetensi pendidik dan tenaga kependidikan sesuai dengan perkembangan\r\nteknologi dan berintegritas tinggi<span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-21.25pt;line-height:150%;mso-list:l0 level1 lfo2\"><!--[if !supportLists]--><span lang=\"IN\">2.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]-->Mengembangkan kurikulum operasional sekolah\r\nberbasis <i>project based learnin,</i>tersinkronisasi\r\ndengan dunia kerja dan industry<span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-21.25pt;line-height:150%;mso-list:l0 level1 lfo2\"><!--[if !supportLists]--><span lang=\"IN\">3.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]-->Menghasilkan siswa yang berkarakter sesuai\r\nProfil Pelajar Pancasila<span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-21.25pt;line-height:150%;mso-list:l0 level1 lfo2\"><!--[if !supportLists]--><span lang=\"IN\">4.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]-->Menumbuhkan jiwa wirausaha peserta didik yang\r\nberbasis <i>technosociopereneur</i><span lang=\"IN\"><o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-18.0pt;line-height:150%;mso-list:l0 level2 lfo1\"><span lang=\"IN\">\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n</span></p><p class=\"MsoNormal\" style=\"margin-left:42.55pt;text-align:justify;text-indent:\r\n-21.25pt;line-height:150%;mso-list:l0 level1 lfo2\"><!--[if !supportLists]--><span lang=\"IN\">5.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n</span></span><!--[endif]-->Mengembangkan kerja sama yang luas dan bermakna\r\ndengan pemangku kepentingan, dunia kerja dan industry nasional dan\r\ninternasional<span lang=\"IN\"><o:p></o:p></span></p>',' Visi Misi Tujuan','1','1','1','0','0','0','0','0','1',66,'',2,0,'0',0,'2024-09-30 14:25:12','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 (5719,'smktkmecirebon.sch.id','KALENDER AKADEMIK','KALENDER-AKADEMIK','Kalender Akademik Pendidikan SMK TKME Tahun Pelajaran 2024/2025','SMK TKME CIREBON','2024-07-07','2025-07-06','2024-10-01 08:26:07','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 (13995,'smktkmecirebon.sch.id','KELAS X AK','kelas-x-ak','Akuntansi','Deti Irmawati, S.Pd','2024-12-19 08:48:56','1'),(13996,'smktkmecirebon.sch.id','KELAS XI AK','kelas-xi-ak','Akuntansi','Yulyana, S.Pd','2024-12-19 08:50:18','1'),(13997,'smktkmecirebon.sch.id','KELAS XII AK','kelas-xii-ak','Akuntansi','Iis Kritiyana, S.Pd','2024-12-19 08:50:59','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 (4007,'smktkmecirebon.sch.id',0,'Pendaftaran Online','pendaftaran-online','https://docs.google.com/forms/d/1OCzc6_uaVN2nH2tpMs6u2ohGBGGFOcGN6phVyyiEfJ4/edit?usp=sharing','_parent','2020-01-11 12:31:57','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;






--
-- 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 (4511,'smktkmecirebon.sch.id','Pendidikan Agama Islam','pendidikan-agama-islam','2020-01-11 08:53:41','1'),(4512,'smktkmecirebon.sch.id','Pendidikan Kewarganegaraan','pendidikan-kewarganegaraan','2020-01-11 08:53:59','1'),(16823,'smktkmecirebon.sch.id','Pendidikan Agama Islam','pendidikan_agama_islam','2024-10-01 08:31:45','1'),(16824,'smktkmecirebon.sch.id','PKKN','pkn','2024-10-01 08:31:45','1'),(16825,'smktkmecirebon.sch.id','Bahasa Indonesia','bahasa_indonesia','2024-10-01 08:31:45','1'),(16826,'smktkmecirebon.sch.id','Matematika','matematika','2024-10-01 08:31:45','1'),(16827,'smktkmecirebon.sch.id','Bahasa Inggris','bahasa_ingris','2024-10-01 08:31:45','1'),(16828,'smktkmecirebon.sch.id','Seni Budaya','seni_budaya','2024-10-01 08:31:45','1'),(16829,'smktkmecirebon.sch.id','PenjasOrkes','penjasorkes','2024-10-01 08:31:45','1'),(16830,'smktkmecirebon.sch.id','Informatika','informatika','2024-10-01 08:31:45','1'),(16831,'smktkmecirebon.sch.id','Kejuruan','kejuruan','2024-10-01 08:31:45','1'),(16832,'smktkmecirebon.sch.id','Sejarah Indonesia','sejarah_indonesia','2024-10-01 08:31:45','1'),(16833,'smktkmecirebon.sch.id','PKKW','pkw','2024-10-01 08:31:45','1'),(16834,'smktkmecirebon.sch.id','Project IPAS','project_ipas','2024-10-01 08:31:45','1'),(16835,'smktkmecirebon.sch.id','Ketamansiswaan','ketamansiswan','2024-10-01 08:31:45','1'),(16836,'smktkmecirebon.sch.id','Bimbingan Konseling','bimbingan_konseling','2024-10-01 08:31:45','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 (147644,'smktkmecirebon.sch.id','Artikel','artikel','main','berita_terbaru_kategori',58818,'kombinasi2','1','home','',4,'2020-01-08 11:43:46','0'),(147640,'smktkmecirebon.sch.id','Banner','banner','side','banner',0,'','1','semua','',4,'2019-06-27 15:51:14','1'),(147639,'smktkmecirebon.sch.id','Berita Terbaru','berita-terbaru','side','berita_terbaru',0,'','1','semua','',3,'2019-06-27 15:51:14','1'),(147645,'smktkmecirebon.sch.id','Galeri','galeri','main','galeri',0,'','','home','',5,'2020-01-08 11:43:46','0'),(147646,'smktkmecirebon.sch.id','Kontak','kontak','side','kontak',0,'','1','semua','',1,'2020-01-08 11:43:46','1'),(147641,'smktkmecirebon.sch.id','Konten','konten','main','konten',0,'','1','semua','',1,'2020-01-08 11:43:46','1'),(147642,'smktkmecirebon.sch.id','Sambutan Kepala Sekolah','sambutan','main','sambutan',0,'','1','home','',2,'2020-01-08 11:43:46','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;






--
-- 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;




INSERT INTO `psb_banner` VALUES (1375,'smktkmecirebon.sch.id','PENERIMAAN PESERTA DIDIK BARU 2024/2025','','<p><img src=data:image/jpeg;base64,[BLOB]','','34787718BROSURPPDBprint_001.jpg','2024-09-30 14:09:01','1');


--
-- 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 (2195,'smktkmecirebon.sch.id','BROSUR PENERIMAAN PESERTA DIDIK BARU 2024/2025','brosur-penerimaan-peserta-didik-baru-20242025','',0,'57796192BROSURPPDBprint_001.jpg','2024-09-30 14:11:29','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;






--
-- 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;






--
-- 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;






--
-- 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;






--
-- 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 (1486,'smktkmecirebon.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;






--
-- 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 (1184,'smktkmecirebon.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','0','0000-00-00','00:00:00',0.00,0,'0000-00-00 00:00: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;






--
-- 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 (17632,'smktkmecirebon.sch.id','Sambutan Kepala Sekolah','sambutan-kepsek','<p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px;\">Bismillahirohmannirrohim</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Assalamualaikum Warahmatullah Wabarakatuh</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Alhamdulillahi robbil alamin kami panjatkan kehadirat Allah SWT, bahwasannya dengan rahmat dan karunia-Nya lah akhirnya Website sekolah ini dengan alamat&nbsp;<a href=\"https://www.smktkmecirebon.sch.id/\">www.smktkmecirebon.sch.id</a>&nbsp;dapat kami perbaharui. Kami mengucapkan selamat datang di Website kami Sekolah Menengah Kejuruan Negeri SMK TAMAN KARYA MADYA EKONOMI (TKME) Kota Cirebon yang saya tujukan untuk seluruh unsur pimpinan, guru, karyawan dan siswa serta khalayak umum guna dapat mengakses seluruh informasi tentang segala profil, aktifitas/kegiatan serta fasilitas sekolah kami.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Kami selaku pimpinan sekolah mengucapkan terima kasih kepada tim pembuat Website ini yang telah berusaha untuk dapat lebih memperkenalkan segala perihal yang dimiliki oleh sekolah. Dan tentunya Website sekolah kami masih terdapat banyak kekurangan, oleh karena itu kepada seluruh civitas akademika dan masyarakat umum dapat memberikan saran dan kritik yang membangun demi kemajuan Website ini lebih lanjut.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Saya berharap Website ini dapat dijadikan wahana interaksi yang positif baik antar civitas akademika maupun masyarakat pada umumnya sehingga dapat menjalin silaturahmi yang erat disegala unsur. Mari kita bekerja dan berkarya dengan mengharap ridho sang Kuasa dan keikhlasan yang tulus dijiwa demi anak bangsa.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Terima kasih semoga Allah ‘Azza Wa Jalla menyertai doa kita semua……amin.</p>','70583662fotokepalasekolah.jpeg','2019-06-27 15:51:14','1'),(17633,'smktkmecirebon.sch.id','Sambutan Kepala Sekolah','sambutan-kepsek','<p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px;\">Bismillahirohmannirrohim</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Assalamualaikum Warahmatullah Wabarakatuh</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Alhamdulillahi robbil alamin kami panjatkan kehadirat Allah SWT, bahwasannya dengan rahmat dan karunia-Nya lah akhirnya Website sekolah ini dengan alamat&nbsp;<a href=\"https://www.smktkmecirebon.sch.id/\">www.smktkmecirebon.sch.id</a>&nbsp;dapat kami perbaharui. Kami mengucapkan selamat datang di Website kami Sekolah Menengah Kejuruan Negeri SMK TAMAN KARYA MADYA EKONOMI (TKME) Kota Cirebon yang saya tujukan untuk seluruh unsur pimpinan, guru, karyawan dan siswa serta khalayak umum guna dapat mengakses seluruh informasi tentang segala profil, aktifitas/kegiatan serta fasilitas sekolah kami.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Kami selaku pimpinan sekolah mengucapkan terima kasih kepada tim pembuat Website ini yang telah berusaha untuk dapat lebih memperkenalkan segala perihal yang dimiliki oleh sekolah. Dan tentunya Website sekolah kami masih terdapat banyak kekurangan, oleh karena itu kepada seluruh civitas akademika dan masyarakat umum dapat memberikan saran dan kritik yang membangun demi kemajuan Website ini lebih lanjut.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Saya berharap Website ini dapat dijadikan wahana interaksi yang positif baik antar civitas akademika maupun masyarakat pada umumnya sehingga dapat menjalin silaturahmi yang erat disegala unsur. Mari kita bekerja dan berkarya dengan mengharap ridho sang Kuasa dan keikhlasan yang tulus dijiwa demi anak bangsa.</p><p style=\"padding: 0px; margin-bottom: 20px; outline: none; list-style: none; border: 0px none; box-sizing: border-box; font-family: &quot;Open Sans&quot;; font-size: 13px; text-align: justify;\">Terima kasih semoga Allah ‘Azza Wa Jalla menyertai doa kita semua……amin.</p>','70583662fotokepalasekolah.jpeg','2020-01-08 11:43:47','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 (18295,'smktkmecirebon.sch.id','','','admin','profesional','semua',10,3663,'0','4',0,0,'tkmesmk0@gmail.com','sd','SMK TAMAN KARYA MADYA EKONOMI (TKME) CIREBON','KOMPETENSI KEAHLIAN AKUNTANSI DAN KEUANGAN LEMBAGA','smk-taman-karya-madya-ekonomi-tkme-cirebon','Website SMK TAMAN KARYA MADYA EKONOMI (TKME) KOTA CIREBON','SMK TKME CIREBON','logo','smooth','','','7349531whatsappimage2019-09-14at8.25.58am.jpeg','','2646738241258709tkme.jpg','','SMK TKME CIREBON','AKUNTANSI DAN KEUANGAN LEMBAGA','','SMK TKME JUARA !!!','','','SMK TAMAN KARYA MADYA EKONOMI KOTA (TKME) CIREBON','','','circle','agency2',1,'','Jl. Perjuangan BInawan V ','Kota Cirebon','Jawa Barat','','45134','081321839383','','','tkmesmk0@gmail.com','www.smktkmecirebon.sch.id','https://www.facebook.com/BkkSMKTKME','','','','','','','','','','2020-01-08 11:43:46','0000-00-00 00:00:00','1',0,1,2,'A','active','','1','0'),(18294,'smktkmecirebon.sch.id','','','admin','profesional','semua',0,3663,'0','4',0,0,'tkmesmk0@gmail.com','sd','SMK TKME CIREBON','Kesambi Kota Cirebon','smktkmecirebon','Website SMK TKME CIREBON','SMK TKME CIREBON','logo','smooth','','','7349531whatsappimage2019-09-14at8.25.58am.jpeg','','41258709tkme.jpg','','SMK TKME CIREBON','Kesambi Kota Cirebon','','SMK TKME JUARA !!!','','','SMK TAMAN KARYA MADYA EKONOMI KOTA CIREBON','','','circle','agency2',1,'','Jl. Perjuangan BInawan V ','Kota Cirebon','Jawa Barat','','45134','081321839383','','','tkmesmk0@gmail.com','www.smktkmecirebon.sch.id','https://www.facebook.com/BkkSMKTKME','','','','','','','','','','2019-06-27 15:51:14','0000-00-00 00:00:00','1',0,1,2,'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 (18295,'smktkmecirebon.sch.id','','','admin','profesional','semua',10,3663,'0','4',0,0,'tkmesmk0@gmail.com','sd','SMK TAMAN KARYA MADYA EKONOMI (TKME) CIREBON','KOMPETENSI KEAHLIAN AKUNTANSI DAN KEUANGAN LEMBAGA','smk-taman-karya-madya-ekonomi-tkme-cirebon','Website SMK TAMAN KARYA MADYA EKONOMI (TKME) KOTA CIREBON','SMK TKME CIREBON','logo','smooth','','','7349531whatsappimage2019-09-14at8.25.58am.jpeg','','2646738241258709tkme.jpg','','SMK TKME CIREBON','AKUNTANSI DAN KEUANGAN LEMBAGA','','SMK TKME JUARA !!!','','','SMK TAMAN KARYA MADYA EKONOMI KOTA (TKME) CIREBON','','','circle','agency2',1,'','Jl. Perjuangan BInawan V ','Kota Cirebon','Jawa Barat','','45134','081321839383','','','tkmesmk0@gmail.com','www.smktkmecirebon.sch.id','https://www.facebook.com/BkkSMKTKME','','','','','','','','','','2020-01-08 11:43:46','0000-00-00 00:00:00','1',0,1,2,'A','active','','1','0'),(18294,'smktkmecirebon.sch.id','','','admin','profesional','semua',0,3663,'0','4',0,0,'tkmesmk0@gmail.com','sd','SMK TKME CIREBON','Kesambi Kota Cirebon','smktkmecirebon','Website SMK TKME CIREBON','SMK TKME CIREBON','logo','smooth','','','7349531whatsappimage2019-09-14at8.25.58am.jpeg','','41258709tkme.jpg','','SMK TKME CIREBON','Kesambi Kota Cirebon','','SMK TKME JUARA !!!','','','SMK TAMAN KARYA MADYA EKONOMI KOTA CIREBON','','','circle','agency2',1,'','Jl. Perjuangan BInawan V ','Kota Cirebon','Jawa Barat','','45134','081321839383','','','tkmesmk0@gmail.com','www.smktkmecirebon.sch.id','https://www.facebook.com/BkkSMKTKME','','','','','','','','','','2019-06-27 15:51:14','0000-00-00 00:00:00','1',0,1,2,'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;






--
-- 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 (2559,'smktkmecirebon.sch.id','','panduan','','','','2024-09-30 13:00:32','1'),(2560,'smktkmecirebon.sch.id','','tentang','','','','2024-09-30 13:00:47','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 (56404,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56405,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56406,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56407,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56408,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56409,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56410,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56411,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56412,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56413,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56414,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56415,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56416,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56417,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56418,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56419,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56420,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56421,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56422,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56423,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56424,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56425,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56426,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56427,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56428,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56429,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56430,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56431,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56432,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','',''),(56434,'','smktkmecirebon.sch.id','','','','','','','0000-00-00','','','','','',0,'','','','','','','','','2020-01-13 09:43:32','1','','','','','','','','','');


--
-- 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 (49138,'smktkmecirebon.sch.id',' SMK TKME CIREBON','-smk-tkme-cirebon','','','','_parent','960956204771924tamantkme.jpg','2020-01-08 11:43:46','1'),(49136,'smktkmecirebon.sch.id','Kunjungan Industri','kunjungan-industri','','','','_parent','24376642dsc0094.jpg','2019-06-27 15:51:14','1'),(49142,'smktkmecirebon.sch.id','Pelantikan Bantara','pelantikan-bantara','','','','_parent','521404088bantara.jpg','2020-01-11 08:58:07','1'),(49137,'smktkmecirebon.sch.id','Pelantikan OSIS SMK TKME','pelantikan-osis-smk-tkme','','','','_parent','2565603468434757pelantikanosis.jpg','2019-06-27 15:51:14','1'),(49139,'smktkmecirebon.sch.id','Tim Futsal SMK TKME','tim-futsal-smk-tkme','','','','_parent','7728837073351933fernandes157.jpg','2020-01-08 11:43:46','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 (3414,'smktkmecirebon.sch.id','dhea-andini','Dhea Andini','','','','','','','','','0000-00-00','','','','','1919526431ni-dhea-andini.jpg','2020-01-11 09:32:10','1','','','','','',''),(3417,'smktkmecirebon.sch.id','riyanto','Riyanto','','','','SMK','Operator','L','Islam','Cirebon','0000-00-00','','','','','1555413620riyantojpg.jpg','0000-00-00 00:00:00','1','','','','','',''),(3415,'smktkmecirebon.sch.id','rosyana','Rosyana','','','','','','','','','0000-00-00','','','','','2127607398rosiyana.jpg','2020-01-11 09:44:13','1','','','','','',''),(3418,'smktkmecirebon.sch.id','sri-astutise','Sri Astuti,S.E','','','Belum Menikah','Sarjana (S1)','Kepala TU','P','Islam','Cirebon','0000-00-00','','','','','214418820sri-astuti.jpg','0000-00-00 00:00:00','1','SMK TKME','','','','','');


--
-- 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 (1252,'smktkmecirebon.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','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','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,'0000-00-00 00:00:00','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;






