/*
Navicat MySQL Data Transfer
Source Server : 192.168.1.2
Source Server Version : 50051
Source Host : 192.168.1.2:3306
Source Database : alirsyad
Target Server Type : MYSQL
Target Server Version : 50051
File Encoding : 65001
Date: 2014-09-13 00:56:42
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `agenda`
-- ----------------------------
DROP TABLE IF EXISTS `agenda`;
CREATE TABLE `agenda` (
`id_agenda` int(5) NOT NULL auto_increment,
`tema` varchar(100) collate latin1_general_ci NOT NULL,
`tema_seo` varchar(100) collate latin1_general_ci NOT NULL,
`isi_agenda` text collate latin1_general_ci NOT NULL,
`tempat` varchar(100) collate latin1_general_ci NOT NULL,
`pengirim` varchar(100) collate latin1_general_ci NOT NULL,
`tgl_mulai` date NOT NULL,
`tgl_selesai` date NOT NULL,
`tgl_posting` date NOT NULL,
`jam` varchar(50) collate latin1_general_ci NOT NULL,
`username` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_agenda`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of agenda
-- ----------------------------
INSERT INTO `agenda` VALUES ('41', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Latiahn Ujian Nasional MKKS ( tryout tahap VII)\r\n', 'SMP Al Irsyad', 'Admin', '2012-03-05', '2012-03-14', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('42', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Ujian Praktek\r\n', 'SMP Al Irsyad', 'Admin', '2012-03-14', '2012-03-23', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('43', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Ujian Yayasan\r\n', 'SMP Al Irsyad', 'Admin', '2012-03-25', '2012-03-26', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('44', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Ujian Sekolah\r\n', 'SMP Al Irsyad', 'Admin', '2012-03-28', '2012-04-02', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('45', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Tryout tahap VIII\r\n', 'SMP Al Irsyad', 'Admin', '2012-04-04', '2012-04-07', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('46', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'Persiapan Ujian Nasional\r\n', 'SMP Al Irsyad', 'Admin', '2012-04-04', '2012-04-23', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('47', 'Kegiatan Semester Genap kelas 9', 'kegiatan-semester-genap-kelas-9', 'UJIAN NASIONAL\r\n', 'SMP Al Irsyad', 'Admin', '2012-04-25', '2012-04-28', '2012-02-29', '07.00-selesai', 'admin');
INSERT INTO `agenda` VALUES ('48', 'Kegiatan Semester Genap', 'kegiatan-semester-genap', 'AKHIRUSSANNAH\r\n', 'SMP Al Irsyad', 'Admin', '2012-04-18', '2012-04-18', '2012-02-29', '07.00-selesai', 'admin');
-- ----------------------------
-- Table structure for `album`
-- ----------------------------
DROP TABLE IF EXISTS `album`;
CREATE TABLE `album` (
`id_album` int(5) NOT NULL auto_increment,
`jdl_album` varchar(100) collate latin1_general_ci NOT NULL,
`album_seo` varchar(100) collate latin1_general_ci NOT NULL,
`gbr_album` varchar(100) collate latin1_general_ci NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`id_album`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of album
-- ----------------------------
INSERT INTO `album` VALUES ('21', 'Pramuka', 'pramuka', '341308ambalan (Copy).jpg', 'Y');
INSERT INTO `album` VALUES ('20', 'PMR', 'pmr', '686676pmr.jpg', 'Y');
INSERT INTO `album` VALUES ('18', 'Bayi', 'bayi', '246551silvestree.jpg', 'N');
INSERT INTO `album` VALUES ('12', 'Ilustrator', 'ilustrator', '987701family.jpg', 'N');
INSERT INTO `album` VALUES ('19', 'Binatang', 'binatang', '391479burung.jpg', 'N');
INSERT INTO `album` VALUES ('17', 'Kegiatan', 'kegiatan', '326660badge2.jpg', 'Y');
INSERT INTO `album` VALUES ('22', 'Theo', 'theo', '775329CANDRA.jpg', 'N');
-- ----------------------------
-- Table structure for `banner`
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`id_banner` int(5) NOT NULL auto_increment,
`judul` varchar(100) collate latin1_general_ci NOT NULL,
`url` varchar(100) collate latin1_general_ci NOT NULL,
`gambar` varchar(100) collate latin1_general_ci NOT NULL,
`tgl_posting` date NOT NULL,
PRIMARY KEY (`id_banner`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of banner
-- ----------------------------
-- ----------------------------
-- Table structure for `berita`
-- ----------------------------
DROP TABLE IF EXISTS `berita`;
CREATE TABLE `berita` (
`id_berita` int(5) NOT NULL auto_increment,
`id_kategori` int(5) NOT NULL,
`username` varchar(30) collate latin1_general_ci NOT NULL,
`judul` varchar(100) collate latin1_general_ci NOT NULL,
`judul_seo` varchar(100) collate latin1_general_ci NOT NULL,
`headline` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
`isi_berita` text collate latin1_general_ci NOT NULL,
`hari` varchar(20) collate latin1_general_ci NOT NULL,
`tanggal` date NOT NULL,
`jam` time NOT NULL,
`gambar` varchar(100) collate latin1_general_ci NOT NULL,
`dibaca` int(5) NOT NULL default '1',
`tag` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_berita`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of berita
-- ----------------------------
INSERT INTO `berita` VALUES ('102', '25', 'admin', 'Kegiatan Latiahan Ujian NAsional', 'kegiatan-latiahan-ujian-nasional', 'Y', 'hari ini merupakan hari Pertama Melakukan Latiahn ujain Nasional Di SMP kita tercinta, para peserta yang utama adalah 9. Menurut wawancara yang kami lakukan para siswa mengaku berdebar-debar, ya mungkin dikarenakan gugup \r\n', 'Sabtu', '2010-04-10', '22:28:32', '51messi.jpg', '13', 'sepakbola');
INSERT INTO `berita` VALUES ('103', '25', 'admin', 'Percaya Diri', 'percaya-diri', 'Y', '\r\n\r\n\r\n\r\n * 10 Tips\r\nAgar Kita Bisa Tampil Percaya Diri*\r\n
\r\n\r\n
\r\n\r\nKita Harus Jujur Menilai Diri Kita\r\nSendiri.\r\n
\r\n\r\n \r\n
\r\n\r\nCoba ingat-ingat lagi\r\npotensi diri, maupun keahlian yang menjadi kelebihan diri kita. Cari dan\r\nkembangkan potensi yang masih terpendam. Tanyakan pada orang-orang terdekat\r\natau mendatangi psikiater untuk menggali potensi diri.\r\n
\r\n\r\n \r\n
\r\n\r\nKita Harus Menetapkan Tujuan Yang\r\nRealistis.\r\n\r\n
\r\n\r\nDengan menetapkan tujuan-tujuan\r\ntersebut, kita akan mudah dalam mencapainya. Percaya diri dalam melangkah,\r\nbertindak dan memutuskan segalanya, sekaligus memperkecil resiko yang mungkin\r\nditimbulkan.\r\n
\r\n\r\nKita Harus Memberi Penghargaan\r\nSekecil Apapun Pada Diri Kita.\r\n\r\n
\r\n\r\nJangan sekali-kali kita meremehkan\r\nkemajuan yang kita peroleh sekecil apapun. Apalagi justru terus mengingat\r\nkesalahan yang telah kita lakukan, yang hanya membuat kita merasa tidak\r\nberguna.\r\n
\r\n\r\nKita Harus Mengikuti Saran Positif\r\nDan Menolak Saran Negative. \r\n
\r\n\r\nKita harus berhati-hati. Tidak\r\nselamanya saran orang lain harus kita ikuti. Tidak setiap orang memberikan\r\nsupport dan bersikap positif. Jangan sampai hal itu melunturkan rasa percaya\r\ndiri kita.\r\n
\r\n\r\nJadilah Orang Yang Positif\r\nThinking. \r\n
\r\n\r\nCobalah untuk senantiasa berpikir\r\nlogis dan rasional, terhadap diri kita, orang lain, lingkungan dan setiap\r\nsituasi yang kita hadapi. Camkan bahwa tidak ada manusia yang sempurna dan\r\nsangat rentan untuk melakukan kesalahan.\r\n
\r\n\r\nGunakan Self-Affirmation.\r\n\r\n
\r\n\r\nJika kita masih sering menyatakan,\r\n“saya tidak bisa”, maka ubahlah menjadi, “saya pasti bisa!”. Ini penting untuk\r\nterus mengasah percaya diri kita.\r\n
\r\n\r\nBerani Mengambil Resiko.\r\n\r\n
\r\n\r\nCobalah untuk berusaha dan berbuat\r\nsecara nyata. Tanamkan pada diri kita bahwa kita tidak akan mendapatkan sesuatu\r\ntanpa resiko. Apapun yang kita lakukan pasti ada dampaknya.\r\n
\r\n\r\nBerani Menerima Tanggung Jawab.\r\n\r\n
\r\n\r\nTanggung jawab mampu mendorong kita\r\nuntuk melakukan yang terbaik. Kita akan terbiasa menyelesaikan tugas besar yang\r\ndibebankan dengan ringan.\r\n
\r\n\r\nMencari Lingkungan Yang Kondusif.\r\n\r\n
\r\n\r\nPerbanyaklah bergaul dengan\r\norang-orang yang memiliki rasa percaya diri tinggi. Sebab, rasa percaya diri\r\nitu pun bisa menular.\r\n
\r\n\r\nBanyak Bersyukur Dan Berdoa.\r\n\r\n
\r\nPerbanyaklah rasa syukur dan berdoa atas segala\r\nhal yang kita jalani dalam hidup. Nikmati hidup kita, dan lihatlah hal-hal baik\r\nyang telah kita dapatkan\r\n', 'Sabtu', '2010-04-10', '22:32:19', '6643pede.jpg', '8', '');
INSERT INTO `berita` VALUES ('104', '23', 'admin', 'Jalan Sehat', 'jalan-sehat', 'Y', '\r\n Dihari yang cerah nan menyejukan, warga SMP Al Irsyad mengadakan gerak jalan yang diikuti semua anggotanya, mulai dari siswa-siswi, bapak ibu guru dan karyawan. Acara dilakukan pada hari kamis yang menyenangkan dengan penuh semangat 45,,(hihihi,,kayak prajurit mau kemedan perang aja)... mereka berjalan menyusuri jalan Kapten mulyadi memutar ke daerah sangkrah hingga kembali ke gedung Al Irsyad. \r\n
\r\n\r\n Walaupun capek, letih, lesu, lemas, tapi semua itu tak dirasa dan sudah dibayar lunas dengan senangnya hati dan keringat yang sangggat buuanyak ( ya walau pun agak bau dikit,,heheheh). Begitulah kegiatan akhir pekan yang menyenangkan hingga badan terasa enakan.by Pw\r\n
\r\n', 'Sabtu', '2010-04-10', '22:46:50', '8615jln.jpg', '20', 'browser');
INSERT INTO `berita` VALUES ('108', '25', 'admin', 'PENDAFTARAN SISWA BARU 2012/2013', 'pendaftaran-siswa-baru-20122013', 'Y', '\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\nTelah \r\nDibuka Pendaftaran Siswa-Siswa Baru Tahun 2012/2013\r\n
\r\n\r\n Syarat Pendaftaran:\r\n
\r\n\r\n - Mengisi formulir pendaftaran
\r\n - Foto copy kartu keluarga
\r\n - Foto 3 x 4 hitam putih (4 lembar)
\r\n - Foto copy raport kelas IV, V dan VI (semester gasal)
\r\n - Mengikuti tes seleksi (wawancara dan BTA)
\r\n - Foto copy ijasah SD/MI yang dilegalisir (bisa menyusul)
\r\n - Foto copy SKHUN SD/MI yang dilegalisir (bisa menyusul)
\r\n
\r\n\r\n \r\nRincian Biaya:\r\n
\r\n\r\n \r\n \r\n | 1. Seragan | \r\n Rp. 450.000,-\r\n | \r\n
\r\n \r\n | 2. Pengembangan Pendidikan | \r\n Rp. 600.000,-\r\n | \r\n
\r\n \r\n 3. SPP Bulan Juli
\r\n | \r\n Rp. 135.000,- | \r\n
\r\n \r\n | 4. MOS | \r\n Rp. 50.000,- | \r\n
\r\n \r\n 5. OSIS (1 tahun)
\r\n | \r\n Rp. 50.000,- | \r\n
\r\n \r\n | 6. Pendaftaran | \r\n Rp. 50.000,- | \r\n
\r\n \r\n 7. Kegiatan Ekstra / Semester
\r\n | \r\n Rp. 60.000,- | \r\n
\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n\r\n
\r\n', 'Sabtu', '2012-03-03', '13:48:19', '16PDB.jpg', '17', '');
-- ----------------------------
-- Table structure for `bobot`
-- ----------------------------
DROP TABLE IF EXISTS `bobot`;
CREATE TABLE `bobot` (
`id` int(11) NOT NULL auto_increment,
`skhun` int(11) default NULL,
`raport` int(11) default NULL,
`bta` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of bobot
-- ----------------------------
INSERT INTO `bobot` VALUES ('1', '40', '35', '25');
-- ----------------------------
-- Table structure for `download`
-- ----------------------------
DROP TABLE IF EXISTS `download`;
CREATE TABLE `download` (
`id_download` int(5) NOT NULL auto_increment,
`judul` varchar(100) collate latin1_general_ci NOT NULL,
`nama_file` varchar(100) collate latin1_general_ci NOT NULL,
`tgl_posting` date NOT NULL,
`hits` int(3) NOT NULL,
PRIMARY KEY (`id_download`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of download
-- ----------------------------
INSERT INTO `download` VALUES ('10', 'RPP TIK KELAS 7', 'pp-tik-7.pdf', '2012-03-02', '0');
INSERT INTO `download` VALUES ('11', 'RPP TIK KELAS 8', 'pp-tik-8.pdf', '2012-03-02', '0');
INSERT INTO `download` VALUES ('12', 'RPP BHS INGGRIS KELAS 9 2011-2012', 'PP Bahasa Inggris kelas 9 2011-2012.pdf', '2012-03-02', '0');
-- ----------------------------
-- Table structure for `gallery`
-- ----------------------------
DROP TABLE IF EXISTS `gallery`;
CREATE TABLE `gallery` (
`id_gallery` int(5) NOT NULL auto_increment,
`id_album` int(5) NOT NULL,
`jdl_gallery` varchar(100) collate latin1_general_ci NOT NULL,
`gallery_seo` varchar(100) collate latin1_general_ci NOT NULL,
`keterangan` text collate latin1_general_ci NOT NULL,
`gbr_gallery` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_gallery`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of gallery
-- ----------------------------
INSERT INTO `gallery` VALUES ('65', '17', 'ekstra masak', 'ekstra-masak', '', '255371IMG_7860 (Copy).JPG');
INSERT INTO `gallery` VALUES ('66', '17', 'ekstra masak', 'ekstra-masak', '', '462188IMG_7862 (Copy).JPG');
INSERT INTO `gallery` VALUES ('64', '17', 'kegiatan olah raga', 'kegiatan-olah-raga', '', '218353DSCF2915 (Copy).JPG');
INSERT INTO `gallery` VALUES ('59', '0', 'PMR', 'pmr', '', '727447IMG_7933.JPG');
INSERT INTO `gallery` VALUES ('60', '20', 'PMR', 'pmr', '', '340393IMG_7934 (Copy).JPG');
INSERT INTO `gallery` VALUES ('61', '20', 'PMR', 'pmr', '', '448333IMG_7933 (Copy).JPG');
INSERT INTO `gallery` VALUES ('62', '20', 'PMR', 'pmr', '', '573242Foto0037 (Copy).jpg');
INSERT INTO `gallery` VALUES ('55', '20', 'PMR', 'pmr', '', '780303Foto0021 (Copy).jpg');
INSERT INTO `gallery` VALUES ('56', '20', 'PMR', 'pmr', '', '539245Foto0022 (Copy).jpg');
INSERT INTO `gallery` VALUES ('57', '20', 'PMR', 'pmr', '', '810760Foto0027 (Copy).jpg');
INSERT INTO `gallery` VALUES ('58', '0', 'PMR', 'pmr', '', '15258Foto0026 (Copy).jpg');
INSERT INTO `gallery` VALUES ('48', '21', 'Pasuka pa', 'pasuka-pa', '', '732696DSCF2292 (Copy).JPG');
INSERT INTO `gallery` VALUES ('49', '21', 'Pengibaran bendera ', 'pengibaran-bendera-', 'Saat Persami\r\n', '876892DSCF2296 (Copy).JPG');
INSERT INTO `gallery` VALUES ('51', '21', 'Pemenang Lomba ', 'pemenang-lomba-', 'Dalam Rangka Persami\r\n', '843139DSCF2498 (Copy).JPG');
INSERT INTO `gallery` VALUES ('52', '21', 'Semapore', 'semapore', '', '763122IMG_7869 (Copy).JPG');
INSERT INTO `gallery` VALUES ('53', '21', 'Lomba Masak', 'lomba-masak', 'Dalam Rangka Persami\r\n', '588348DSCF2356 (Copy).JPG');
INSERT INTO `gallery` VALUES ('54', '21', 'Api unggun', 'api-unggun', 'Dalam Rangka Persami\r\n', '91461SAM_4051 (Copy).JPG');
INSERT INTO `gallery` VALUES ('67', '17', 'berjualan', 'berjualan', '', '739685IMG_0245 (Copy).JPG');
INSERT INTO `gallery` VALUES ('68', '17', 'berjualan', 'berjualan', '', '33660IMG_0248 (Copy).JPG');
INSERT INTO `gallery` VALUES ('69', '17', 'hadrah', 'hadrah', '', '186401IMG_0220 (Copy).JPG');
INSERT INTO `gallery` VALUES ('70', '17', 'hadrah', 'hadrah', '', '756988IMG_0222 (Copy).JPG');
INSERT INTO `gallery` VALUES ('71', '17', 'hadrah', 'hadrah', '', '435363IMG_0225 (Copy).JPG');
INSERT INTO `gallery` VALUES ('63', '17', 'kegiatan olah raga', 'kegiatan-olah-raga', '', '487365DSCF2914 (Copy).JPG');
INSERT INTO `gallery` VALUES ('72', '17', 'bela diri', 'bela-diri', '', '175140IMG_0134 (Copy).JPG');
INSERT INTO `gallery` VALUES ('73', '17', 'bela diri', 'bela-diri', '', '670166IMG_0136 (Copy).JPG');
INSERT INTO `gallery` VALUES ('74', '17', 'bela diri', 'bela-diri', '', '299835IMG_0137 (Copy).JPG');
-- ----------------------------
-- Table structure for `gruppertanyaan`
-- ----------------------------
DROP TABLE IF EXISTS `gruppertanyaan`;
CREATE TABLE `gruppertanyaan` (
`id` int(11) NOT NULL auto_increment,
`grouppertanyaan` varchar(40) NOT NULL default '',
`Keterangan` varchar(60) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of gruppertanyaan
-- ----------------------------
INSERT INTO `gruppertanyaan` VALUES ('1', 'Perkuliahan', 'Group pertanyaan tentang perkuliahaan');
-- ----------------------------
-- Table structure for `halamanstatis`
-- ----------------------------
DROP TABLE IF EXISTS `halamanstatis`;
CREATE TABLE `halamanstatis` (
`id_halaman` int(5) NOT NULL auto_increment,
`judul` varchar(100) NOT NULL,
`judul_seo` varchar(100) NOT NULL,
`isi_halaman` text NOT NULL,
`tgl_posting` date NOT NULL,
`gambar` varchar(100) NOT NULL,
PRIMARY KEY (`id_halaman`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of halamanstatis
-- ----------------------------
INSERT INTO `halamanstatis` VALUES ('1', 'Profil', 'profil', '\r\n\r\n\r\n\r\nAG \r\n\r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\nSELAMAT DATANG DI
\r\n
\r\n\r\n \r\n\r\n
\r\n\r\nSMP AL IRSYAD AL ISLAMIYYAH SURAKARTA\r\n\r\n
\r\n', '2010-05-31', 'MG_0213 (Copy) (Copy).jpg');
INSERT INTO `halamanstatis` VALUES ('2', 'Visi dan Misi', 'visi-dan-misi', '\r\n\r\n\r\n\r\nVISI, MISI DAN TUJUAN SEKOLAH\r\n
\r\n\r\n \r\n
\r\n\r\nVisi Sekolah : \r\n
\r\n\r\nBersih hati,\r\ncerdas pikiran dan survive dalam kehidupan\r\n
\r\n\r\n \r\n
\r\n\r\nMisi : \r\n
\r\n\r\n - Menyelenggarakan pendidikan yang menunjang\r\n kecerdasan spiritual dan akal
\r\n - Menyelenggarakan proses pembelajaran terpadu\r\n berbasis sains dan agama (Islam)
\r\n - Menyelenggarakan pendidikan life skill
\r\n - Menciptakan lingkungan pendidikan yang mendukung\r\n pembentukan syakhsyiyah islamiyah siswa
\r\n - Menjalin kerjasama dengan mitra kerja pendidikan\r\n dan Stakeholder Sekolah
\r\n
\r\n\r\n \r\n
\r\n\r\nTujuan Sekolah\r\n
\r\n\r\nPada akhir tahun pelajaran 2011/2012 sekolah dapat :\r\n
\r\n\r\n1. \r\nMengembangkan kurikulum berdiversifikasi dengan\r\nmemberikan pelayanan kepada siswa sesuai dengan tingkat kemampuan belajarnya\r\n
\r\n\r\n2. \r\nMengoptimalkan proses pembelajaran dengan menggunakan\r\nmedia pembelajaran\r\n
\r\n\r\n3. \r\nTingkat kelulusan berdasar nilai Ujian Nasional 70 %\r\n
\r\n\r\n4. \r\nMemperoleh nilai rata rata ujian nasional untuk mata pelajaran\r\n
\r\n\r\nBhs.Indonesia\r\n= 6.25\r\n
\r\n\r\nBhs.\r\nInggris = 5.25\r\n
\r\n\r\nMatematika\r\n= 5.25\r\n
\r\n\r\nIPA = 5.5 \r\n
\r\n\r\n5. \r\nMeraih kejuaraan di bidang kaligrafi dan seni baca al\r\nqur’an di tingkat kota\r\n
\r\n\r\n6. \r\nMembekali siswa dengan hafalan juz amma dan hadits\r\narbain\r\n
\r\n\r\n7. \r\nMembekali 80 % siswa untuk mengembangkan minat dan\r\nbakat melalui kegiatan ekstrakurikuler\r\n
\r\n\r\n8. \r\nMembekali siswa untuk mampu mengakses berbagai\r\ninformasi yang positif melalui internet\r\n
\r\n\r\n9. \r\nMembekali siswa agar dapat mengimplementasikan ajaran agamanya\r\nmelalui shalat berjamaah\r\n
\r\n', '2010-05-31', 'DSCN1455.jpg');
INSERT INTO `halamanstatis` VALUES ('3', 'Struktur Organisasi', 'struktur-organisasi', '', '2010-05-31', 'struktur (Copy).jpg');
INSERT INTO `halamanstatis` VALUES ('4', 'Test', 'test', 'Test disini saja\r\n', '2012-02-17', '');
INSERT INTO `halamanstatis` VALUES ('7', 'Biodata Pengajar', 'biodata-pengajar', '', '2012-03-05', '');
-- ----------------------------
-- Table structure for `hubungi`
-- ----------------------------
DROP TABLE IF EXISTS `hubungi`;
CREATE TABLE `hubungi` (
`id_hubungi` int(5) NOT NULL auto_increment,
`nama` varchar(50) collate latin1_general_ci NOT NULL,
`email` varchar(100) collate latin1_general_ci NOT NULL,
`subjek` varchar(100) collate latin1_general_ci NOT NULL,
`pesan` text collate latin1_general_ci NOT NULL,
`tanggal` date NOT NULL,
PRIMARY KEY (`id_hubungi`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of hubungi
-- ----------------------------
INSERT INTO `hubungi` VALUES ('9', 'Theo Pilus Candra', 'theoweb.dev@gmail.com', 'Test', 'Testing 123', '2012-02-17');
-- ----------------------------
-- Table structure for `jawaban`
-- ----------------------------
DROP TABLE IF EXISTS `jawaban`;
CREATE TABLE `jawaban` (
`id` int(11) NOT NULL auto_increment,
`idpendaftar` int(11) default NULL,
`idpertanyaan` int(10) NOT NULL default '0',
`jawaban` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=592 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of jawaban
-- ----------------------------
-- ----------------------------
-- Table structure for `katajelek`
-- ----------------------------
DROP TABLE IF EXISTS `katajelek`;
CREATE TABLE `katajelek` (
`id_jelek` int(11) NOT NULL auto_increment,
`kata` varchar(60) collate latin1_general_ci default NULL,
`ganti` varchar(60) collate latin1_general_ci default NULL,
PRIMARY KEY (`id_jelek`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of katajelek
-- ----------------------------
INSERT INTO `katajelek` VALUES ('4', 'sex', 's**');
INSERT INTO `katajelek` VALUES ('2', 'bajingan', 'b*******');
INSERT INTO `katajelek` VALUES ('3', 'bangsat', 'b******');
INSERT INTO `katajelek` VALUES ('5', 'asu', 'as**');
INSERT INTO `katajelek` VALUES ('6', 'brengsek', 'bre**');
-- ----------------------------
-- Table structure for `kategori`
-- ----------------------------
DROP TABLE IF EXISTS `kategori`;
CREATE TABLE `kategori` (
`id_kategori` int(5) NOT NULL auto_increment,
`nama_kategori` varchar(50) collate latin1_general_ci NOT NULL,
`kategori_seo` varchar(100) collate latin1_general_ci NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`id_kategori`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of kategori
-- ----------------------------
INSERT INTO `kategori` VALUES ('19', 'Teknologi', 'teknologi', 'Y');
INSERT INTO `kategori` VALUES ('2', 'Olahraga', 'olahraga', 'Y');
INSERT INTO `kategori` VALUES ('21', 'Ekonomi', 'ekonomi', 'Y');
INSERT INTO `kategori` VALUES ('22', 'Politik', 'politik', 'Y');
INSERT INTO `kategori` VALUES ('23', 'Hiburan', 'hiburan', 'Y');
INSERT INTO `kategori` VALUES ('24', 'Dunia Islam', 'dunia-islam', 'Y');
INSERT INTO `kategori` VALUES ('25', 'Pendidikan', 'pendidikan', 'Y');
-- ----------------------------
-- Table structure for `komentar`
-- ----------------------------
DROP TABLE IF EXISTS `komentar`;
CREATE TABLE `komentar` (
`id_komentar` int(5) NOT NULL auto_increment,
`id_berita` int(5) NOT NULL,
`nama_komentar` varchar(100) collate latin1_general_ci NOT NULL,
`url` varchar(100) collate latin1_general_ci NOT NULL,
`isi_komentar` text collate latin1_general_ci NOT NULL,
`tgl` date NOT NULL,
`jam_komentar` time NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`id_komentar`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of komentar
-- ----------------------------
-- ----------------------------
-- Table structure for `kriteriappdb`
-- ----------------------------
DROP TABLE IF EXISTS `kriteriappdb`;
CREATE TABLE `kriteriappdb` (
`id` int(11) NOT NULL auto_increment,
`kriteria` varchar(50) default NULL,
`alias` varchar(100) default NULL,
`bobot` int(11) default NULL,
`tbl_c` varchar(20) default NULL,
`simbol` char(2) default NULL,
`form` enum('Y','N') default 'Y',
`aktif` enum('Y','N') default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of kriteriappdb
-- ----------------------------
INSERT INTO `kriteriappdb` VALUES ('1', 'skhun', 'SKHUN', '40', 'tbl_c1', 'c1', 'Y', 'Y');
INSERT INTO `kriteriappdb` VALUES ('2', 'raport', 'Rata-rata Raport', '35', 'tbl_c2', 'c2', 'Y', 'Y');
INSERT INTO `kriteriappdb` VALUES ('3', 'bta', 'BTA', '25', 'tbl_c3', 'c3', 'N', 'Y');
-- ----------------------------
-- Table structure for `mainmenu`
-- ----------------------------
DROP TABLE IF EXISTS `mainmenu`;
CREATE TABLE `mainmenu` (
`id_main` int(5) NOT NULL auto_increment,
`nama_menu` varchar(50) character set latin1 collate latin1_general_ci default NULL,
`link` varchar(100) character set latin1 collate latin1_general_ci default NULL,
`urutan` int(11) NOT NULL default '0',
`aktif` enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (`id_main`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of mainmenu
-- ----------------------------
INSERT INTO `mainmenu` VALUES ('1', 'Beranda', 'index.php', '-15', 'Y');
INSERT INTO `mainmenu` VALUES ('2', 'Profil', 'statis-1-profil.html', '-14', 'Y');
INSERT INTO `mainmenu` VALUES ('3', 'Agenda', 'semua-agenda.html', '-13', 'Y');
INSERT INTO `mainmenu` VALUES ('4', 'Berita', 'semua-berita.html', '-12', 'Y');
INSERT INTO `mainmenu` VALUES ('5', 'Download', 'semua-download.html', '-11', 'Y');
INSERT INTO `mainmenu` VALUES ('6', 'Galeri Foto', 'semua-album.html', '-10', 'Y');
INSERT INTO `mainmenu` VALUES ('7', 'Hubungi Kami', 'hubungi-kami.html', '-9', 'Y');
INSERT INTO `mainmenu` VALUES ('9', 'Pendaftaran', 'pendaftaran.html', '-11', 'N');
INSERT INTO `mainmenu` VALUES ('10', 'PPDB', 'ppdb.html', '-11', 'Y');
-- ----------------------------
-- Table structure for `modul`
-- ----------------------------
DROP TABLE IF EXISTS `modul`;
CREATE TABLE `modul` (
`id_modul` int(5) NOT NULL auto_increment,
`nama_modul` varchar(50) collate latin1_general_ci NOT NULL,
`link` varchar(100) collate latin1_general_ci NOT NULL,
`static_content` text collate latin1_general_ci NOT NULL,
`gambar` varchar(100) collate latin1_general_ci NOT NULL,
`publish` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
`status` enum('user','admin') collate latin1_general_ci NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
`urutan` int(5) NOT NULL,
`link_seo` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_modul`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of modul
-- ----------------------------
INSERT INTO `modul` VALUES ('2', 'Manajemen User', '?module=user', '', '', 'N', 'user', 'Y', '1', '');
INSERT INTO `modul` VALUES ('18', 'Berita', '?module=berita', '', '', 'Y', 'user', 'Y', '6', 'semua-berita.html');
INSERT INTO `modul` VALUES ('19', 'Banner', '?module=banner', '', '', 'Y', 'admin', 'Y', '9', '');
INSERT INTO `modul` VALUES ('37', 'Profil', '?module=profil', 'Bukulokomedia.com merupakan website resmi dari penerbit Lokomedia yang bermarkas di Jl. Arwana No.24 Minomartani Yogyakarta 55581. Dirintis pertama kali oleh Lukmanul Hakim pada tanggal 14 Maret 2008.
Produk unggulan dari penerbit Lokomedia adalah buku-buku serta aksesoris bertema PHP (PHP: Hypertext Preprocessor) yang merupakan pemrograman Internet paling handal saat ini.\r\n', 'gedungku.jpg', 'N', 'admin', 'N', '3', 'profil-kami.html');
INSERT INTO `modul` VALUES ('10', 'Manajemen Modul', '?module=modul', '', '', 'N', 'admin', 'Y', '2', '');
INSERT INTO `modul` VALUES ('31', 'Kategori', '?module=kategori', '', '', 'Y', 'admin', 'Y', '5', '');
INSERT INTO `modul` VALUES ('33', 'Poling', '?module=poling', '', '', 'Y', 'admin', 'Y', '10', '');
INSERT INTO `modul` VALUES ('34', 'Tag (Label)', '?module=tag', '', '', 'N', 'admin', 'Y', '7', '');
INSERT INTO `modul` VALUES ('35', 'Komentar', '?module=komentar', '', '', 'Y', 'admin', 'Y', '8', '');
INSERT INTO `modul` VALUES ('36', 'Download', '?module=download', '', '', 'Y', 'admin', 'Y', '11', 'semua-download.html');
INSERT INTO `modul` VALUES ('40', 'Hubungi Kami', '?module=hubungi', '', '', 'Y', 'admin', 'Y', '12', 'hubungi-kami.html');
INSERT INTO `modul` VALUES ('41', 'Agenda', ' ?module=agenda', '', '', 'Y', 'user', 'Y', '4', 'semua-agenda.html');
INSERT INTO `modul` VALUES ('42', 'Shoutbox', '?module=shoutbox', '', '', 'Y', 'admin', 'Y', '13', '');
INSERT INTO `modul` VALUES ('43', 'Album', '?module=album', '', '', 'N', 'admin', 'Y', '14', '');
INSERT INTO `modul` VALUES ('44', 'Galeri Foto', '?module=galerifoto', '', '', 'Y', 'admin', 'Y', '15', '');
INSERT INTO `modul` VALUES ('45', 'Themes', '?module=themes', '', '', 'N', 'admin', 'Y', '16', '');
INSERT INTO `modul` VALUES ('46', 'Kata Jelek', '?module=katajelek', '', '', 'N', 'admin', 'Y', '17', '');
INSERT INTO `modul` VALUES ('47', 'RSS', '-', '', '', 'Y', 'admin', 'N', '18', '');
INSERT INTO `modul` VALUES ('48', 'YM', '-', '', '', 'Y', 'admin', 'N', '19', '');
INSERT INTO `modul` VALUES ('49', 'Indeks Berita', '-', '', '', 'Y', 'admin', 'N', '20', '');
INSERT INTO `modul` VALUES ('50', 'Kalender', '-', '', '', 'Y', 'admin', 'N', '21', '');
INSERT INTO `modul` VALUES ('51', 'Statistik User', '-', '', '', 'Y', 'admin', 'Y', '22', '');
INSERT INTO `modul` VALUES ('52', 'Pencarian', '-', '', '', 'Y', 'admin', 'N', '23', '');
INSERT INTO `modul` VALUES ('53', 'Berita Teratas', '-', '', '', 'Y', 'admin', 'N', '24', '');
INSERT INTO `modul` VALUES ('54', 'Arsip Berita', '-', '', '', 'Y', 'admin', 'N', '25', '');
INSERT INTO `modul` VALUES ('55', 'Berita Sebelumnya', '-', '', '', 'Y', 'admin', 'N', '26', '');
INSERT INTO `modul` VALUES ('60', 'Sekilas Info', '?module=sekilasinfo', '', '', 'Y', 'user', 'Y', '13', '');
INSERT INTO `modul` VALUES ('57', 'Menu Utama', '?module=menuutama', '', '', 'Y', 'admin', 'Y', '28', '');
INSERT INTO `modul` VALUES ('58', 'Sub Menu', '?module=submenu', '', '', 'Y', 'admin', 'Y', '29', '');
INSERT INTO `modul` VALUES ('59', 'Halaman Statis', '?module=halamanstatis', '', '', 'Y', 'admin', 'Y', '30', '');
INSERT INTO `modul` VALUES ('61', 'Pendaftaran', '?module=pendaftaran&req=bta', ' ', ' ', 'Y', 'user', 'N', '31', ' ');
INSERT INTO `modul` VALUES ('66', 'Sistem PPDB', '?module=sistemppdb', ' ', ' ', 'Y', 'admin', 'Y', '33', ' ');
INSERT INTO `modul` VALUES ('67', 'Data Pendaftar', '?module=pendaftar', ' ', ' ', 'Y', 'user', 'Y', '34', ' ');
INSERT INTO `modul` VALUES ('68', 'Perangkingan PPDB', '?module=perangkinganppdb', ' ', ' ', 'Y', 'admin', 'Y', '35', ' ');
INSERT INTO `modul` VALUES ('69', 'Test Online', '?module=testonline', '', '', 'Y', 'admin', 'Y', '32', ' ');
-- ----------------------------
-- Table structure for `pendaftar`
-- ----------------------------
DROP TABLE IF EXISTS `pendaftar`;
CREATE TABLE `pendaftar` (
`id` int(11) NOT NULL auto_increment,
`nodaf` varchar(30) default NULL,
`nisn` varchar(30) default NULL,
`nama` varchar(30) default NULL,
`tempatlahir` varchar(60) default NULL,
`tgllahir` date default NULL,
`jeniskelamin` enum('Laki-laki','Perempuan') default 'Laki-laki',
`idagama` int(11) default NULL,
`alamat` varchar(100) default NULL,
`asalsekolah` varchar(60) default NULL,
`kecamatan` varchar(60) default NULL,
`kabupaten` varchar(60) default NULL,
`propinsi` varchar(60) default NULL,
`namaortu` varchar(30) default NULL,
`alamatortu` varchar(100) default NULL,
`telepon` varchar(20) default NULL,
`pekerjaan` varchar(40) default NULL,
`tanggal` datetime default NULL,
`email` varchar(60) default NULL,
`password` varchar(32) default NULL,
`skhun` int(11) default NULL,
`raport` int(11) default NULL,
`bta` int(11) default NULL,
`c1` int(11) default NULL,
`c2` int(11) default NULL,
`c3` int(11) default NULL,
`nilaiakhir` double(16,2) default NULL,
`skhun_ekst` varchar(10) default NULL,
`raport_ekst` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pendaftar
-- ----------------------------
INSERT INTO `pendaftar` VALUES ('1', '2014001', null, 'Bayu', 'solo', '1990-01-01', 'Laki-laki', '1', 'sukoharjo', 'sd negeri 1', 'kec', 'kab', 'prov', 'bapak', 'jajar', '092381223', 'pek', '2014-08-15 11:25:15', 'aa@yahoo.com', 'a8e52217c48d055fb98e2732c587d056', '22', '9', '230', '35', '35', '25', '0.95', null, null);
INSERT INTO `pendaftar` VALUES ('2', '2014002', null, 'Dia', 'sragen', '1990-01-01', 'Laki-laki', '1', 'srgen', 'sd negeri 1', 'kec', 'kab', 'prov', 'ibu', 'solo', '0928242482321', 'swasta', '2014-08-15 11:33:36', 'bb@yahoo.com', 'pass', '21', '7', '60', '30', '25', '15', '0.70', null, null);
INSERT INTO `pendaftar` VALUES ('3', '2014003', null, 'Intan', 'klaten', '2014-01-01', 'Laki-laki', '1', '', '', '', '', '', '', '', '', '', '2014-08-18 18:05:25', '', '', '19', '5', '202', '20', '15', '25', '0.60', null, null);
INSERT INTO `pendaftar` VALUES ('4', '2014004', null, 'Budi', 'solo', '2014-01-01', 'Laki-laki', '1', 'solo', '', '', '', '', '', '', '', '', '2014-08-18 18:10:16', '', '', '20', '6', '60', '25', '20', '15', '0.60', null, null);
INSERT INTO `pendaftar` VALUES ('5', '2014005', null, 'Arum', 'solo', '2014-01-01', 'Laki-laki', '1', '', '', '', '', '', '', '', '', '', '2014-08-18 18:20:22', '', '', '23', '8', '100', '40', '30', '25', '0.95', null, null);
INSERT INTO `pendaftar` VALUES ('32', '2014007', null, 'sfsd', 'fdsf', '2014-08-23', 'Laki-laki', '1', 'fsdf', 'sfsd', 'sfdsf', 'fsdf', 'fsdf', 'fdsf', 'fsd', 'fdssdf', 'fsdf', '2014-08-23 16:08:34', 'gg@yahoo.com', 'p', '23', '7', '100', '40', '25', '25', '0.90', null, null);
INSERT INTO `pendaftar` VALUES ('6', '2014006', null, 'hhh', 'cscsd', '2014-08-11', 'Laki-laki', '1', 'csdv', 'dcsdv', 'csdv', 'sdsd', 'dvdsv', 'dvsdv', 'dvsdv', 'dssd', 'dvsdvdsv', '2014-08-22 23:42:15', 'yy@yahoo.com', 'p', '20', '7', '40', '25', '25', '10', '5.46', null, null);
INSERT INTO `pendaftar` VALUES ('41', '2014008', '', 'WWW', 'solo', '2014-08-27', 'Laki-laki', '1', 'SOLO', 'SD NEGERI 1', 'SOLO', 'SOLO', 'SOLO', 'BAPAK', 'SOLO', '081743', 'SWASTA', '2014-08-27 18:25:52', 'zz@yahoo.com', 'p', '20', '8', '70', '25', '30', '20', '0.75', 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('42', '2014009', '', 'AUW', 'SOLO', '2014-08-27', 'Laki-laki', '1', 'SOLO', 'SD NEGERI 1', 'SOLO', 'SOLO', 'SOLO', 'BAPAK', 'SOLO', '081743', 'SWASTA', '2014-08-27 19:20:34', 'mm@yahoo.com', 'p', '21', '6', null, '30', '20', null, null, 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('43', '2014010', '123', 'AUW', 'SOLO', '2014-08-27', 'Laki-laki', '1', 'SOLO', 'SD NEGERI 1', 'SOLO', 'SOLO', 'SOLO', 'BAPAK', 'SOLO', '081743', 'SWASTA', '2014-08-27 19:26:04', 'll@yahoo.com', 'p', '21', '6', null, '30', '20', null, null, 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('46', '2014011', '', 'SADASD', 'SDASD', '2027-08-05', 'Laki-laki', '1', 'SDASD', 'SDAS', 'SDASD', 'SDASD', 'SADASD', 'SDASD', 'SDSAD', 'dsasd', 'DASDAS', '2014-08-27 23:36:27', 'ff@yahoo.com', 'f0a4058fd33489695d53df156b77c724', '21', '7', null, '30', '25', null, null, 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('48', '2014012', '', 'GDFG', 'GDFGDFG', '2014-08-28', 'Laki-laki', '1', 'GFDFG', 'GD', 'FGFD', 'GFDG', 'GDG', 'GFG', 'GFG', 'fgg', 'GFG', '2014-08-28 00:46:14', 'gh@yahoo.com', '514f1b439f404f86f77090fa9edc96ce', '21', '6', null, '30', '20', null, null, 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('49', '2014013', '', 'GDFH', 'HFGHFG', '2014-08-28', 'Laki-laki', '1', 'HFGH', 'HFF', 'HFGH', 'HFGHFH', 'FGHFGHFG', 'HFGHFGH', 'FGHFHFH', 'hfgh', 'HHHH', '2014-08-28 00:50:15', 'uu@yahoo.com', '83878c91171338902e0fe0fb97a8c47a', '17', '7', null, '20', '25', null, null, 'png', 'jpeg');
INSERT INTO `pendaftar` VALUES ('50', '2014014', '', 'FDGDF', 'HGHFFDH', '2014-08-28', 'Laki-laki', '1', 'FDHHFGHF', 'HFDHH', 'FHFDH', 'GHFGH', 'HGGHFGH', 'HFGHH', 'HFGHFGH', 'fghfghfgh', 'HFGHFG', '2014-08-28 01:16:03', 'rt@yahoo.com', 'c4ca4238a0b923820dcc509a6f75849b', '21', '8', null, '30', '30', null, null, 'jpeg', 'jpeg');
INSERT INTO `pendaftar` VALUES ('51', '2014015', '', 'GDFG', 'GDFGDFG', '2014-08-28', 'Laki-laki', '1', 'FGDFG', 'FDGDF', 'GGDDFG', 'GFDFGDF', 'GDF', 'FDGDF', 'GFDGDFG', 'fdg', 'FDGDFG', '2014-08-28 01:18:41', 'eer@yahoo.com', 'c4ca4238a0b923820dcc509a6f75849b', '22', '8', null, '35', '30', null, null, 'jpeg', 'png');
-- ----------------------------
-- Table structure for `pertanyaan`
-- ----------------------------
DROP TABLE IF EXISTS `pertanyaan`;
CREATE TABLE `pertanyaan` (
`id` int(11) NOT NULL auto_increment,
`idgroup` int(10) NOT NULL default '0',
`pertanyaan` varchar(200) NOT NULL default '',
`pilihan1` varchar(100) default NULL,
`pilihan2` varchar(100) default NULL,
`pilihan3` varchar(100) default NULL,
`pilihan4` varchar(100) default NULL,
`pilihan5` varchar(100) default NULL,
`jawaban` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pertanyaan
-- ----------------------------
INSERT INTO `pertanyaan` VALUES ('1', '1', 'Apakah Silabi dan rancangan pembelajaran mata kuliah ini jelas', 'Tidak Jelas (Tidak pernah dijelaskan rencananya)', 'Kurang Jelas (Diterangkan secara lisan)', 'Jelas (Diterangkan, ditulis dipapan atau transparansi)', 'Sangat Jelas (Diterangkan, dicetak dan dilampirkan di daftar presensi mahasiswa)', null, '1');
INSERT INTO `pertanyaan` VALUES ('2', '1', 'Apakah perkuliahan yang terlaksana sesuai dengan silabi dan rancangan pembelajaran yang telah disepa', 'Sangat sedikit yang terlaksana dengan baik ( <25 % )', 'Sedikit yang terlaksana dengan baik ( >25 % - 50 % )', 'Banyak yang terlaksana dengan baik ( >50% - 75 % )', 'Hampir semua terlaksana dengan baik ( >75 % )', null, '2');
INSERT INTO `pertanyaan` VALUES ('3', '1', 'Pada setiap tata muka berapa rata-rata lama diskusi/taya jawab/presentasi, berlangsung', 'Sangat sedikit (Kurang dari 10%)', 'Sedikit (10% - 20%)', 'Banyak (Lebih dari 20% - 40 %)', 'Sangat banyak (Lebih dari 40%)', null, '3');
INSERT INTO `pertanyaan` VALUES ('4', '1', 'Berapa banyak materi yang dapat anda serap dengan jelas', 'Sangat sedikit (Kurang dari 20%)', 'Sedikit (Kurang lebih 20% - 40%)', 'Banyak (> 40 % sampai 60%)', 'Hampir Seluruhnya (Diatas 60%)', null, '4');
INSERT INTO `pertanyaan` VALUES ('5', '1', 'Berapa banyak manfaat dari tugas yang diberikan dosen?', 'Tidak banyak bermanfaat / menambah beban saja', 'sedikit menambah kemampuan', 'banyak menambah kemampuan', 'sangat banyak menambah kemampuan', null, '1');
INSERT INTO `pertanyaan` VALUES ('6', '1', 'Apakah tugas / test / UTS atau UAS mendapat evaluasi dan koreksi mewadai ?', 'Tidak pernah dibahas dan tidak pernah dikembalikan', 'dibahas secara umum, berkas tidak dikembaliakan', 'dibahas secara rinci, berkas tidak dikembalikan', 'dibahas secara rinci, berkas dikoreksi dan dibagikan', null, '2');
INSERT INTO `pertanyaan` VALUES ('7', '1', 'Berapa banyak anda mendapat materi yang up to date ? (Jurnal, infromasi baru, Internet, Konteks nyata saat ini )', 'Kurang sekali', 'Kurang', 'banyak', 'sangat banyak', null, '3');
INSERT INTO `pertanyaan` VALUES ('8', '1', 'Seberapa sering perkuliahan ini berlangsung tepat waktu baik awal maupun akhir ?', 'Tidak penah tepat waktu', 'Jarang tepat waktu', 'Sering tepat waktu', 'Selalu tepat waktu', null, '4');
INSERT INTO `pertanyaan` VALUES ('11', '1', 'Bentuk pembelajaran yang terlaksana seberapa besar dapat meningkatkan minat dan semangat belajar saudara ?', 'Menjadi sangat tidak berminat', 'kurang berminat', 'berminat dan semangat', 'sangat bergairah dan bersemangat', null, '1');
INSERT INTO `pertanyaan` VALUES ('10', '1', 'Apakah proses evaluasi/penilaian belajar jelas dan sesuai dengan peraturan akademis?', 'tidak jelas/tidak akademis', 'kurang jelas/kurang akademis', 'sebagian jelas dan akademis', 'hampir semua jelas dan akademis', null, '2');
-- ----------------------------
-- Table structure for `poling`
-- ----------------------------
DROP TABLE IF EXISTS `poling`;
CREATE TABLE `poling` (
`id_poling` int(5) NOT NULL auto_increment,
`pilihan` varchar(100) collate latin1_general_ci NOT NULL,
`status` varchar(20) collate latin1_general_ci NOT NULL,
`rating` int(5) NOT NULL default '0',
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_poling`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of poling
-- ----------------------------
INSERT INTO `poling` VALUES ('1', 'Juwadi', 'Jawaban', '25', 'Y');
INSERT INTO `poling` VALUES ('2', 'Asep', 'Jawaban', '80', 'Y');
INSERT INTO `poling` VALUES ('3', 'Erwin', 'Jawaban', '21', 'Y');
INSERT INTO `poling` VALUES ('4', 'Lintar Sapto', 'Jawaban', '22', 'Y');
INSERT INTO `poling` VALUES ('8', 'Guru favoritmu?', 'Pertanyaan', '0', 'Y');
-- ----------------------------
-- Table structure for `sekilasinfo`
-- ----------------------------
DROP TABLE IF EXISTS `sekilasinfo`;
CREATE TABLE `sekilasinfo` (
`id_sekilas` int(5) NOT NULL auto_increment,
`info` varchar(100) collate latin1_general_ci NOT NULL,
`tgl_posting` date NOT NULL,
`gambar` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_sekilas`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of sekilasinfo
-- ----------------------------
INSERT INTO `sekilasinfo` VALUES ('1', 'Anak yang mengalami gangguan tidur, cenderung memakai obat2an dan alkohol berlebih saat dewasa.', '2010-04-11', 'news5.jpg');
INSERT INTO `sekilasinfo` VALUES ('2', 'WHO merilis, 30 persen anak-anak di dunia kecanduan menonton televisi dan bermain komputer.', '2010-04-11', 'news4.jpg');
INSERT INTO `sekilasinfo` VALUES ('3', 'Menurut peneliti di Detroit, orang yang selalu tersenyum lebar cenderung hidup lebih lama.', '2010-04-11', 'news3.jpg');
INSERT INTO `sekilasinfo` VALUES ('4', 'Menurut United Stated Trade Representatives, 25% obat yang beredar di Indonesia adalah palsu.', '2010-04-11', 'news2.jpg');
INSERT INTO `sekilasinfo` VALUES ('5', 'Presiden AS Barack Obama memesan Nasi Goreng di restoran Bali langsung dari Amerika', '2010-04-11', 'news1.jpg');
-- ----------------------------
-- Table structure for `shoutbox`
-- ----------------------------
DROP TABLE IF EXISTS `shoutbox`;
CREATE TABLE `shoutbox` (
`id_shoutbox` int(5) NOT NULL auto_increment,
`nama` varchar(100) collate latin1_general_ci NOT NULL,
`website` varchar(50) collate latin1_general_ci NOT NULL,
`pesan` text collate latin1_general_ci NOT NULL,
`tanggal` date NOT NULL,
`jam` time NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`id_shoutbox`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of shoutbox
-- ----------------------------
-- ----------------------------
-- Table structure for `statistik`
-- ----------------------------
DROP TABLE IF EXISTS `statistik`;
CREATE TABLE `statistik` (
`ip` varchar(20) NOT NULL default '',
`tanggal` date NOT NULL,
`hits` int(10) NOT NULL default '1',
`online` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of statistik
-- ----------------------------
INSERT INTO `statistik` VALUES ('127.0.0.2', '2009-09-11', '1', '1252681630');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-09-11', '17', '1252734209');
INSERT INTO `statistik` VALUES ('127.0.0.3', '2009-09-12', '8', '1252817594');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-24', '8', '1256381921');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-26', '108', '1256620074');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-27', '52', '1256686769');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-28', '124', '1256792223');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-29', '9', '1256828032');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-10-31', '3', '1257047101');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-01', '85', '1257113554');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-02', '11', '1257207543');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-03', '165', '1257292312');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-04', '59', '1257403499');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-05', '10', '1257433172');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-11', '13', '1258006911');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-12', '10', '1258048069');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-14', '14', '1258222519');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-17', '2', '1258473856');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-19', '16', '1258635469');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-21', '4', '1258863505');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-25', '3', '1259216216');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-26', '1', '1259222467');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-11-30', '11', '1259651841');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-02', '9', '1259746407');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-03', '17', '1259906128');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-10', '69', '1260423794');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-12', '26', '1260560082');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-11', '5', '1260508621');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-13', '8', '1260716786');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-14', '9', '1260772698');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-15', '9', '1260837158');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-16', '7', '1260905627');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-17', '48', '1261026791');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-18', '11', '1261088534');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-22', '3', '1261477278');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-25', '2', '1261686043');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-26', '29', '1261835507');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-27', '7', '1261920445');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-28', '3', '1261965611');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-29', '21', '1262024011');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2009-12-30', '24', '1262146708');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-01-01', '12', '1262286131');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-01-03', '38', '1262529325');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-01-12', '89', '1263264291');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-01-14', '54', '1263482540');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-01-15', '57', '1263506901');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-11', '30', '1265831568');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-13', '2', '1266032303');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-14', '3', '1266115347');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-15', '15', '1266195235');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-18', '1', '1266499945');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-22', '5', '1266856332');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-02-25', '46', '1267103145');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-12', '10', '1273654648');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-16', '195', '1274026185');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-17', '2', '1274029517');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-19', '1', '1274279374');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-27', '16', '1274967085');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-30', '4', '1275192045');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-05-31', '13', '1275271939');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-06-05', '1', '1275676869');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-06-06', '2', '1275842170');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-06-15', '3', '1276572924');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-06-22', '206', '1277221605');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-08-02', '17', '1280754660');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-08-20', '7', '1282285305');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-08-30', '21', '1283185430');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-08-31', '53', '1283207455');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-02', '133', '1283402651');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-05', '35', '1283702206');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-13', '10', '1284370291');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-17', '12', '1284662303');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-22', '2', '1285091212');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-23', '47', '1285254071');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-26', '32', '1285512806');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2010-09-27', '48', '1285529871');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-18', '3', '1324190996');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-22', '2', '1324573078');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-23', '91', '1324659534');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-24', '41', '1324662198');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-25', '75', '1324780963');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-27', '80', '1324966078');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2011-12-31', '18', '1325295958');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-01-04', '1', '1325621462');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-01-05', '10', '1325733853');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-01-21', '1', '1327115448');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-01-24', '1', '1327375985');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-01', '3', '1328036204');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-04', '1', '1328332058');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-07', '25', '1328633989');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-08', '40', '1328649429');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-09', '6', '1328802541');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-10', '3', '1328888718');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-14', '50', '1329200650');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-15', '27', '1329281145');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-16', '4', '1329341881');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-17', '35', '1329496523');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2012-02-22', '1', '1329882046');
INSERT INTO `statistik` VALUES ('::1', '2012-02-27', '66', '1330315321');
INSERT INTO `statistik` VALUES ('::1', '2012-02-28', '11', '1330414726');
INSERT INTO `statistik` VALUES ('::1', '2012-02-29', '123', '1330486113');
INSERT INTO `statistik` VALUES ('::1', '2012-03-01', '7', '1330577892');
INSERT INTO `statistik` VALUES ('::1', '2012-03-02', '45', '1330667468');
INSERT INTO `statistik` VALUES ('::1', '2012-03-03', '72', '1330759673');
INSERT INTO `statistik` VALUES ('::1', '2012-03-05', '43', '1330919580');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2005-04-12', '1', '1113249138');
INSERT INTO `statistik` VALUES ('127.0.0.1', '2005-01-01', '1', '1104512633');
-- ----------------------------
-- Table structure for `submenu`
-- ----------------------------
DROP TABLE IF EXISTS `submenu`;
CREATE TABLE `submenu` (
`id_sub` int(5) NOT NULL auto_increment,
`nama_sub` varchar(50) character set latin1 collate latin1_general_ci default NULL,
`link_sub` varchar(100) character set latin1 collate latin1_general_ci default NULL,
`urutan_sub` int(11) NOT NULL default '0',
`id_main` int(5) NOT NULL,
PRIMARY KEY (`id_sub`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of submenu
-- ----------------------------
INSERT INTO `submenu` VALUES ('2', 'Visi dan Misi', 'statis-2-visidanmisi.html', '-1', '2');
INSERT INTO `submenu` VALUES ('3', 'Struktur Organisasi', 'statis-3-strukturorganisasi.html', '0', '2');
INSERT INTO `submenu` VALUES ('4', 'Ekonomi', 'kategori-21-ekonomi.html', '0', '4');
INSERT INTO `submenu` VALUES ('5', 'Hiburan', 'kategori-23-hiburan.html', '0', '4');
INSERT INTO `submenu` VALUES ('6', 'Olahraga', 'kategori-2-olahraga.html', '0', '4');
INSERT INTO `submenu` VALUES ('7', 'Politik', 'kategori-22-politik.html', '0', '4');
INSERT INTO `submenu` VALUES ('8', 'Teknologi', 'kategori-19-teknologi.html', '0', '4');
INSERT INTO `submenu` VALUES ('10', 'Pendidikan', 'kategori-25-pendidikan.html', '-1', '4');
INSERT INTO `submenu` VALUES ('11', 'Biodata Pengajar', 'statis-7-biodata-pengajar.html', '1', '2');
INSERT INTO `submenu` VALUES ('12', 'Pendaftaran Online', 'pendaftaranppdb.html', '0', '10');
INSERT INTO `submenu` VALUES ('13', 'Pengumuman', 'pengumumanppdb.html', '1', '10');
-- ----------------------------
-- Table structure for `tag`
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag` (
`id_tag` int(5) NOT NULL auto_increment,
`nama_tag` varchar(100) collate latin1_general_ci NOT NULL,
`tag_seo` varchar(100) collate latin1_general_ci NOT NULL,
`count` int(5) NOT NULL,
PRIMARY KEY (`id_tag`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of tag
-- ----------------------------
INSERT INTO `tag` VALUES ('1', 'Palestina', 'palestina', '5');
INSERT INTO `tag` VALUES ('2', 'Gaza', 'gaza', '6');
INSERT INTO `tag` VALUES ('9', 'Tenis', 'tenis', '5');
INSERT INTO `tag` VALUES ('10', 'Sepakbola', 'sepakbola', '4');
INSERT INTO `tag` VALUES ('8', 'Laskar Pelangi', 'laskar-pelangi', '2');
INSERT INTO `tag` VALUES ('11', 'Amerika', 'amerika', '10');
INSERT INTO `tag` VALUES ('12', 'George Bush', 'george-bush', '3');
INSERT INTO `tag` VALUES ('13', 'Browser', 'browser', '5');
INSERT INTO `tag` VALUES ('14', 'Google', 'google', '2');
INSERT INTO `tag` VALUES ('15', 'Israel', 'israel', '5');
INSERT INTO `tag` VALUES ('16', 'Komputer', 'komputer', '7');
INSERT INTO `tag` VALUES ('17', 'Film', 'film', '3');
INSERT INTO `tag` VALUES ('19', 'Mobil', 'mobil', '0');
-- ----------------------------
-- Table structure for `tbl_c1`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_c1`;
CREATE TABLE `tbl_c1` (
`id` int(11) NOT NULL auto_increment,
`n_awal` int(11) default NULL,
`n_akhir` int(11) default NULL,
`c` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_c1
-- ----------------------------
INSERT INTO `tbl_c1` VALUES ('1', '1', '19', '20');
INSERT INTO `tbl_c1` VALUES ('2', '20', '20', '25');
INSERT INTO `tbl_c1` VALUES ('3', '21', '21', '30');
INSERT INTO `tbl_c1` VALUES ('4', '22', '22', '35');
INSERT INTO `tbl_c1` VALUES ('5', '23', '0', '40');
-- ----------------------------
-- Table structure for `tbl_c2`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_c2`;
CREATE TABLE `tbl_c2` (
`id` int(11) NOT NULL auto_increment,
`n_awal` int(11) default NULL,
`n_akhir` int(11) default NULL,
`c` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_c2
-- ----------------------------
INSERT INTO `tbl_c2` VALUES ('1', '1', '5', '15');
INSERT INTO `tbl_c2` VALUES ('2', '6', '6', '20');
INSERT INTO `tbl_c2` VALUES ('3', '7', '7', '25');
INSERT INTO `tbl_c2` VALUES ('4', '8', '8', '30');
INSERT INTO `tbl_c2` VALUES ('5', '9', '0', '35');
-- ----------------------------
-- Table structure for `tbl_c3`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_c3`;
CREATE TABLE `tbl_c3` (
`id` int(11) NOT NULL auto_increment,
`n_awal` int(11) default NULL,
`n_akhir` int(11) default NULL,
`c` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_c3
-- ----------------------------
INSERT INTO `tbl_c3` VALUES ('1', '1', '20', '5');
INSERT INTO `tbl_c3` VALUES ('2', '21', '40', '10');
INSERT INTO `tbl_c3` VALUES ('3', '41', '60', '15');
INSERT INTO `tbl_c3` VALUES ('4', '61', '80', '20');
INSERT INTO `tbl_c3` VALUES ('7', '81', '0', '25');
-- ----------------------------
-- Table structure for `tbl_max`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_max`;
CREATE TABLE `tbl_max` (
`c1` int(11) default '0',
`c2` int(11) default '0',
`c3` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_max
-- ----------------------------
INSERT INTO `tbl_max` VALUES ('40', '35', '25');
-- ----------------------------
-- Table structure for `tbl_nilai`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_nilai`;
CREATE TABLE `tbl_nilai` (
`nodaf` varchar(7) NOT NULL,
`skhun` int(11) default NULL,
`raport` int(11) default NULL,
`bta` int(11) default NULL,
PRIMARY KEY (`nodaf`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_nilai
-- ----------------------------
INSERT INTO `tbl_nilai` VALUES ('2014001', '22', '9', '20');
INSERT INTO `tbl_nilai` VALUES ('2014002', '21', '7', '75');
INSERT INTO `tbl_nilai` VALUES ('2014003', '19', '5', '40');
INSERT INTO `tbl_nilai` VALUES ('2014004', '20', '6', '100');
INSERT INTO `tbl_nilai` VALUES ('2014005', '23', '8', '80');
INSERT INTO `tbl_nilai` VALUES ('2014006', '23', '7', '100');
INSERT INTO `tbl_nilai` VALUES ('2014007', '23', '8', null);
INSERT INTO `tbl_nilai` VALUES ('2014008', '21', '8', '20');
INSERT INTO `tbl_nilai` VALUES ('2014009', '24', '10', null);
INSERT INTO `tbl_nilai` VALUES ('2014010', '21', '8', '100');
INSERT INTO `tbl_nilai` VALUES ('2014011', '20', '8', null);
INSERT INTO `tbl_nilai` VALUES ('2014012', '23', '9', null);
-- ----------------------------
-- Table structure for `tbl_nilai_c`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_nilai_c`;
CREATE TABLE `tbl_nilai_c` (
`nodaf` varchar(7) NOT NULL,
`c1` int(11) default NULL,
`c2` int(11) default NULL,
`c3` int(11) default NULL,
PRIMARY KEY (`nodaf`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_nilai_c
-- ----------------------------
INSERT INTO `tbl_nilai_c` VALUES ('2014001', '35', '35', '5');
INSERT INTO `tbl_nilai_c` VALUES ('2014002', '30', '25', '15');
INSERT INTO `tbl_nilai_c` VALUES ('2014003', '20', '15', '10');
INSERT INTO `tbl_nilai_c` VALUES ('2014004', '25', '20', '25');
INSERT INTO `tbl_nilai_c` VALUES ('2014005', '40', '30', '20');
INSERT INTO `tbl_nilai_c` VALUES ('2014006', '40', '25', '0');
INSERT INTO `tbl_nilai_c` VALUES ('2014007', '40', '30', '0');
INSERT INTO `tbl_nilai_c` VALUES ('2014008', '30', '30', '5');
INSERT INTO `tbl_nilai_c` VALUES ('2014009', '40', '35', null);
INSERT INTO `tbl_nilai_c` VALUES ('2014010', '30', '30', '25');
INSERT INTO `tbl_nilai_c` VALUES ('2014011', '25', '30', null);
INSERT INTO `tbl_nilai_c` VALUES ('2014012', '40', '35', null);
-- ----------------------------
-- Table structure for `tbl_pendaftar`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_pendaftar`;
CREATE TABLE `tbl_pendaftar` (
`nodaf` varchar(10) NOT NULL,
`nisn` varchar(20) default NULL,
`namasiswa` varchar(30) default NULL,
`tempatlahir` varchar(255) default NULL,
`tgllahir` date default NULL,
`jk` enum('LAKI-LAKI','PEREMPUAN') default NULL,
`agama` varchar(15) default NULL,
`alamatsiswa` varchar(50) default NULL,
`asalsekolah` varchar(50) default NULL,
`kec` varchar(20) default NULL,
`kab` varchar(20) default NULL,
`prov` varchar(20) default NULL,
`namaortu` varchar(30) default NULL,
`alamatortu` varchar(50) default NULL,
`telp` varchar(15) default NULL,
`pekerjaan` varchar(20) default NULL,
`tgldaftar` datetime default NULL,
`email` varchar(50) default NULL,
`password` varchar(32) default NULL,
`verifikasi` enum('Y','N') default 'N',
`nilaisaw` double(5,2) default NULL,
PRIMARY KEY (`nodaf`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_pendaftar
-- ----------------------------
INSERT INTO `tbl_pendaftar` VALUES ('2014001', null, 'BAYU', 'SOLO', '2014-09-04', 'PEREMPUAN', 'ISLAM', 'SOLO KLATEN JAWA TENGAH SEMARANG', 'SD N SOLO', 'SOLO', 'SOLO', 'SOLO', 'BAPAK', 'SOLO', '085666777888', 'SWASTA', '2014-09-02 01:48:08', 'a@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'Y', '0.75');
INSERT INTO `tbl_pendaftar` VALUES ('2014002', null, 'DIA', 'KLATEN', '2014-09-01', 'LAKI-LAKI', 'ISLAM', 'KLATEN', 'SD N KLATEN', 'KLATEN', 'KLATEN', 'KLATEN', 'KLATEN', 'KLATEN', '081999888777', 'SWASTA', '2014-09-04 02:33:17', 'b@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'Y', '0.70');
INSERT INTO `tbl_pendaftar` VALUES ('2014003', null, 'INTAN', 'SRAGEN', '2014-09-12', null, null, 'SRAGEN KOTA', 'SD SRAGEN', null, null, null, null, null, null, null, '2014-09-07 23:14:48', null, '0cc175b9c0f1b6a831c399e269772661', 'Y', '0.45');
INSERT INTO `tbl_pendaftar` VALUES ('2014004', null, 'BUDI', 'BOYOLALI', '2014-09-12', null, null, 'BOYOLALI PINGGIR KALI', 'SD BOYOLALI', null, null, null, null, null, null, null, '2014-09-07 23:14:53', null, '0cc175b9c0f1b6a831c399e269772661', 'Y', '0.70');
INSERT INTO `tbl_pendaftar` VALUES ('2014005', null, 'ARUM', 'SEMARANG', null, null, null, 'JURANG SEMARANG ', 'SD SEMARANG', null, null, null, null, null, null, null, '2014-09-07 23:14:56', null, '0cc175b9c0f1b6a831c399e269772661', 'Y', '0.90');
INSERT INTO `tbl_pendaftar` VALUES ('2014006', 'N001', 'ENDRO', 'SOLO', '2014-09-05', 'LAKI-LAKI', 'ISLAM', 'SOLO', 'SD N 1 SOLO', 'SOLO', 'SOLO', 'SOLO', 'BAPAK', 'SOLO', '081999888000', '', '2014-09-05 16:48:06', 'a@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014007', '2014', 'COBA', 'SRAGEN', '2014-09-08', 'LAKI-LAKI', 'ISLAM', 'SRAGEN', 'SRAGEN', 'SRAGEN', 'SRAGEN', 'SRAGEN', 'BAPAK', 'SRAGEN', '081999888777', '', '2014-09-08 18:36:07', 'f@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014008', '', 'DION', 'GONDANG', '2014-09-10', 'LAKI-LAKI', 'ISLAM', 'GONDANG', 'SMA KEDUNG JERUK', 'MOJOGEDANG', 'KARANGANYAR', 'SEMARANG', 'BAPAK', 'GONDANG', '081777666555', '', '2014-09-10 22:33:33', 'd@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014009', '', 'AKU', 'WONOGIRI', '2014-09-11', 'LAKI-LAKI', 'ISLAM', 'WONOGIRI', 'SD WONOGIRI', 'WONOGIRI', 'WONOGIRI', 'WONOGIRI', 'BAPAK', 'WONOGIRI', '081777666555', 'SWASTA', '2014-09-11 05:23:21', 'a@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014010', '', 'MAS', 'WONOGIRI', '2014-09-11', 'LAKI-LAKI', 'ISLAM', 'WONOGIRI', 'SD N 1 SRAGEN', 'WONOGIRI', 'WONOGIRI', 'WONOGIRI', 'BAPAK', 'WONOGIRI', '', '', '2014-09-11 05:32:49', 'z@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014011', '', 'DENI', 'KLATEN', '2014-09-11', 'PEREMPUAN', 'ISLAM', 'KLATEN', 'SD N 1 KLATEN', 'KLATEN', 'KLATEN', 'KLATEN', 'BAPAK', 'KLATEN', '', '', '2014-09-11 22:50:31', 'r@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
INSERT INTO `tbl_pendaftar` VALUES ('2014012', '', 'TUKUL', 'JKT', '2014-09-11', 'LAKI-LAKI', 'ISLAM', 'JKT', 'JKT', 'JKT', 'JKT', 'JKT', 'BAPAK', 'JKT', '', '', '2014-09-12 00:00:53', 'w@yahoo.com', '0cc175b9c0f1b6a831c399e269772661', 'N', null);
-- ----------------------------
-- Table structure for `tbl_soal`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_soal`;
CREATE TABLE `tbl_soal` (
`id` int(11) NOT NULL auto_increment,
`pertanyaan` varchar(255) default NULL,
`a` varchar(255) default NULL,
`b` varchar(255) default NULL,
`c` varchar(255) default NULL,
`d` varchar(255) default NULL,
`jawaban` enum('a','b','c','d') default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_soal
-- ----------------------------
INSERT INTO `tbl_soal` VALUES ('9', 'Menyembelih hewan ternak pada hari Tasrik 11, 12, 13 Dzulhijjah dengan tujuan mendekatkan diri kepda ALLAH dinamakan...\r\n', 'Aqiqah', 'Kifarat', ' Qurban', 'Ukiyah', 'c');
INSERT INTO `tbl_soal` VALUES ('7', 'Bukit Tursina adalah tempat Nabi Musa AS menerima kitab dari ALLAH S\r\n', 'Nasrani', 'Mayusi', 'Yahudi', 'Qurais', 'c');
INSERT INTO `tbl_soal` VALUES ('8', 'Batas antara alam dunia dengan alam akhirat disebut:\r\n', 'Alam barzah', 'Yaumul hisab', 'Yaumul baas', 'Yaumul mahsyar', 'a');
INSERT INTO `tbl_soal` VALUES ('10', 'Sikap rela menerima dan merasa cukup atas hasil yang diusahakan serta menjauhkan diri dari rasa tidak puas disebut sikap…\r\n', 'Tawakal', 'Tasamuh', 'Tawaduk', 'Qanaah', 'd');
INSERT INTO `tbl_soal` VALUES ('11', '\r\nاللهم بارك لنا فيما رزقتنا و', 'Doa mau makan', 'Doa mau mandi', 'Doa mau pergi', 'Doa mau pulang', 'a');
-- ----------------------------
-- Table structure for `themes`
-- ----------------------------
DROP TABLE IF EXISTS `themes`;
CREATE TABLE `themes` (
`id_themes` int(5) NOT NULL auto_increment,
`judul` varchar(100) collate latin1_general_ci NOT NULL,
`pembuat` varchar(50) collate latin1_general_ci NOT NULL,
`folder` varchar(50) collate latin1_general_ci NOT NULL,
`aktif` enum('Y','N') collate latin1_general_ci NOT NULL default 'N',
PRIMARY KEY (`id_themes`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of themes
-- ----------------------------
INSERT INTO `themes` VALUES ('7', 'theo', 'Theo Pilus C', 'themes/theo', 'Y');
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`username` varchar(50) collate latin1_general_ci NOT NULL,
`password` varchar(50) collate latin1_general_ci NOT NULL,
`nama_lengkap` varchar(100) collate latin1_general_ci NOT NULL,
`email` varchar(100) collate latin1_general_ci NOT NULL,
`no_telp` varchar(20) collate latin1_general_ci NOT NULL,
`level` varchar(20) collate latin1_general_ci NOT NULL default 'user',
`blokir` enum('Y','N') collate latin1_general_ci NOT NULL default 'N',
`id_session` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('admin', 'a8e52217c48d055fb98e2732c587d056', 'Administrator', 'admin@detik.com', '08238923848', 'admin', 'N', 'gg9lctais26o7r463ktn3s9j55');
INSERT INTO `users` VALUES ('sinto ', 'dc855efb0dc7476760afaa1b281665f1', 'Asep', '', '', 'user', 'N', '958f62f9f8b7f348d08943189fda3b15');
INSERT INTO `users` VALUES ('joko', '9ba0009aa81e794e628a04b51eaf7d7f', 'Joko Subando', '', '', 'user', 'N', '4e5ad0dc4d478726661c8c2b3ea31777');
INSERT INTO `users` VALUES ('wiro', '7577bfe4fecd40c43e6140344d90ce0e', 'Wiro Sableng', 'wiro@detik.com', '038039403948', 'user', 'N', '3a4d7257c044c52007c75c370958a533');
INSERT INTO `users` VALUES ('wiros', 'dcdd932ea3418387ef2f06644303389e', 'wiryo', 'wiryo@sableng', '98797', 'user', 'N', '25005d71e4f9a670ebf111888a0916b2');
INSERT INTO `users` VALUES ('theo', '7938414aed691e4bf32edcad0d7df0c6', 'theo', 'theo', '0821', 'user', 'N', 'a3vmq43h1964nppchh6e8cjgq7');
INSERT INTO `users` VALUES ('w', 'f1290186a5d0b1ceab27f4e77c0c5d68', 'www', 'w@yahoo.com', '081', 'user', 'N', 'msls5ga6b17rbus4rg3s7h8g94');