-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 04, 2014 at 06:18 PM
-- Server version: 5.5.32
-- PHP Version: 5.4.16
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `dbblog`
--
CREATE DATABASE IF NOT EXISTS `dbblog` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `dbblog`;
-- --------------------------------------------------------
--
-- Table structure for table `agenda`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=40 ;
-- --------------------------------------------------------
--
-- Table structure for table `album`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=25 ;
--
-- Dumping data for table `album`
--
INSERT INTO `album` (`id_album`, `jdl_album`, `album_seo`, `gbr_album`, `aktif`) VALUES
(21, 'Kartun', 'kartun', '476928sonic.jpg', 'Y'),
(20, 'Pernikahan', 'pernikahan', '146667nikah.jpg', 'Y'),
(18, 'Bayi', 'bayi', '246551silvestree.jpg', 'Y'),
(12, 'Ilustrator', 'ilustrator', '987701family.jpg', 'Y'),
(19, 'Binatang', 'binatang', '391479burung.jpg', 'Y'),
(17, 'Arsitektur', 'arsitektur', '741638arche090.jpg', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `banner`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
--
-- Dumping data for table `banner`
--
INSERT INTO `banner` (`id_banner`, `judul`, `url`, `gambar`, `tgl_posting`) VALUES
(4, 'Fresh Book', 'http://freshbooks.com', 'freshbook.jpg', '2009-02-05'),
(7, 'Cinema 21', 'http://21cineplex.com', 'cinema21.jpg', '2008-02-09');
-- --------------------------------------------------------
--
-- Table structure for table `berita`
--
CREATE TABLE IF NOT EXISTS `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,
`last_edit` date DEFAULT NULL COMMENT 'log edit berita',
PRIMARY KEY (`id_berita`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;
--
-- Dumping data for table `berita`
--
INSERT INTO `berita` (`id_berita`, `id_kategori`, `username`, `judul`, `judul_seo`, `headline`, `isi_berita`, `hari`, `tanggal`, `jam`, `gambar`, `dibaca`, `tag`, `last_edit`) VALUES
(8, 77717, 'admin', 'Lagu Mars Saung Bekasi Utara', 'Lagu-Mars-Saung-Bekasi-Utara.html', 'Y', 'Lyric MARS Saung Bekasi Utara
\n\nSelamat datang di basecamp kami
\n\nsaung sederhana yang penting happy
\n\nngobrol-ngobrol kenalan sambil ngopi-ngopi
\n\nmain poker, main uno sampai pagi..
\n\nkalo gak bisa main kartu jangan minder dulu,
\n\nada gitar, ada catur janganlah malu-malu
\n\nkenalan donk.. (situ siapa darimana)
\n\nIni lah dari mig33 bekasi utara.
\n\nroom kami bebas gak ada moderator list
\n\nmau ngflood mau ngkick bebas yang penting laris
\n\ncowo nya asik-asik
\n\ncewenya manis-manis
\n\nkalo situ usik, kita bisa jadi sadis.
\n\nsorry boss, kita emang ceplas ceplos
\n\nbiar gak selek yo marilah kita toss.
\n\nkalo punya masalah di room mending jangan pada berisik
\n\nmending damai sambil kopdar biar tambah asik
\n\n
\n\nreff:
\n\nSaung mig33..
\n\nBekasi Utara..
\n\nDisini kami..
\n\ntempat berbagi rasa.
\n\n
\n\nMau jadi moduser, flooder atau kicker
\n\nterserah deh yang penting lo pake nick master
\n\nudah ah cape ngetiknya :p
', 'Minggu', '2014-02-02', '17:45:40', 'saung.jpg', 1, '#philtyphil', NULL),
(7, 77716, 'admin', 'Web Aplikasi KAS Saung Bekasi Utara', 'Web-Aplikasi-KAS-Saung-Bekasi-Utara.html', 'Y', 'Web aplikasi KAS saung bekasi utara ini, dibuat dengan tujuan menjaga transparasi keuangan saung bekasi utara. Sehingga semua aktifitas keuangan saung bekasi utara, dapat ter-record dan dapat dilihat oleh semua anggota secara online.
\n\nAplikasi ini dibuat dengan menggunakan Framework Codeigniter, Database MYSQL, jQUery 1.10.1, dan plugin datatables.
\n\nDownload aplikasi -> download
', 'Sabtu', '2014-02-01', '10:51:31', 'hblw.jpg', 1, '#philtyphil', NULL),
(9, 77718, 'admin', 'Backpacker Semarang Jogja', 'Backpacker-Semarang-Jogja.html', 'Y', 'Backpacker kita kali ini seru banget. Kita memanfaatkan tanggalan kejepit di bulan november. Setelah semuanya di persiapkan selama sebulan lebih. Akhirnya kita berangkat juga.
\n\nSebelum berangkat, kita sepakat, untuk ngumpul dulu di stasiun bekasi. Karena kita harus ke stasiun senin dulu untuk keberangkatan keretanya. Dan inilah kami, ketika berada di stasiun bekasi sambil menunggu kerta commuterline kami datang.
\n 
\n\nLalu, akhirnya tibalah kereta commuterline kami dan kamipun sudah ada di stasiun senen.
\n 
\n\nDan ini ketika kami sudah dikereta.
\n 
\n 
\n 
', 'Minggu', '2014-02-02', '18:24:07', 'CT_1_jpg.jpg', 1, '#backpacker,#semarang-jogja', NULL),
(10, 1, 'admin', 'Resize And Crop Image with PHP', 'Resize-And-Crop-Image-with-PHP.html', 'Y', 'Masalah resize foto ini, saya alami ketika membuat website ini. Ini dikarenakan, saya harus mempertahan ke-responsive-an website ini, sehingga saya tidak bisa menuliskan image seperti ini.
\n\n\n
\n\nDengan memaksa ukuran photo seperti itu, membuat website ini jadi kurang responsive, oleh sebab itu saya harus automatis me-resize foto, ketika akan menambahan foto pada setiap berita.
\n\ninilah source code yang saya gunakan.
\n\n\n$image = imagecreatefromjpeg($_GET['src']);\n$filename ='images/cropped_whatever.jpg';\n\n$thumb_width =200;\n$thumb_height =150;\n\n$width = imagesx($image);\n$height = imagesy($image);\n\n$original_aspect = $width / $height;\n$thumb_aspect = $thumb_width / $thumb_height;if( $original_aspect >= $thumb_aspect ){// If image is wider than thumbnail (in aspect ratio sense)\n $new_height = $thumb_height;\n $new_width = $width /($height / $thumb_height);}else{// If the thumbnail is wider than the image\n $new_width = $thumb_width;\n $new_height = $height /($width / $thumb_width);}\n\n$thumb = imagecreatetruecolor( $thumb_width, $thumb_height );// Resize and crop\nimagecopyresampled($thumb,\n $image,0-($new_width - $thumb_width)/2,// Center the image horizontally0-($new_height - $thumb_height)/2,// Center the image vertically0,0,\n $new_width, $new_height,\n $width, $height);\nimagejpeg($thumb, $filename,80);\n\nNah, selamat mencoba yah.
', 'Minggu', '2014-02-02', '18:41:14', 'PHP.jpg', 1, '#philtyphil,#resize_image,#php', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `download`
--
CREATE TABLE IF NOT EXISTS `download` (
`id_download` int(5) NOT NULL AUTO_INCREMENT,
`judul` varchar(100) COLLATE latin1_general_ci NOT NULL,
`nama_pengupload` varchar(100) COLLATE latin1_general_ci NOT NULL,
`tgl_posting` date NOT NULL,
`hits` int(3) NOT NULL,
`link` varchar(350) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`id_download`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `download`
--
INSERT INTO `download` (`id_download`, `judul`, `nama_pengupload`, `tgl_posting`, `hits`, `link`) VALUES
(1, 'Web Aplikasi KAS Saung Bekasi Utara [SOURCE CODE]]', 'admin', '2014-02-01', 0, 'http://adf.ly/cvSPi'),
(2, 'Lagu Mars Bekasi Utara', 'admin', '2014-02-02', 0, 'http://adf.ly/csO3J');
-- --------------------------------------------------------
--
-- Table structure for table `gallery`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=56 ;
--
-- Dumping data for table `gallery`
--
INSERT INTO `gallery` (`id_gallery`, `id_album`, `jdl_gallery`, `gallery_seo`, `keterangan`, `gbr_gallery`) VALUES
(3, 12, 'Duduk di Sofa', 'duduk-di-sofa', 'Sekeluarga sedang duduk di sofa.', '27587family sofa.jpg'),
(4, 12, 'Didepan Rumah', 'didepan-rumah', 'Sekeluarga sedang berada di ladang.', '258819family field.jpg'),
(5, 12, 'Keluarga Bahagia', 'keluarga-bahagia', 'Si anak memperlihatkan lukisan.', '697448family.jpg'),
(7, 19, 'Lebah', 'lebah', 'Lebah besar terbang.', '322906lebah.jpg'),
(8, 17, 'Bangunan Jepang', 'bangunan-jepang', 'Bangunan khas jepang', '370422arche037.jpg'),
(9, 17, 'Candi Merang', 'candi-merang', 'Bangunan candi khas kerajaan', '346527arche014.jpg'),
(10, 18, 'Cukur Janggut', 'cukur-janggut', 'Bayi unik sedang cukur rambut', '892395macho4.jpg'),
(11, 18, 'Push Up', 'push-up', 'Bayi unik sedang melakukan push-up', '991546macho1.jpg'),
(12, 19, 'Kuda Nyengir', 'kuda-nyengir', 'Gini nih kalau kuda lagi nyengir.', '658447kuda.jpg'),
(13, 21, 'Super Mario Bross', 'super-mario-bross', 'Game klasik 3D Mario Bross.', '601318mario bros.jpg'),
(32, 21, 'Naruto', 'naruto', 'Kartun ninja jepang Naruto', '45440naruto.jpg'),
(15, 21, 'Superman', 'superman', 'Superman kecil mau beraksi', '689147superman.jpg'),
(27, 21, 'Sonic', 'sonic', 'Sonic and Friend', '152618sonic.jpg'),
(31, 21, 'Kungfu Panda', 'kungfu-panda', 'Jack Black', '550598panda2.jpg'),
(33, 21, 'Maskot Euro 2008', 'maskot-euro-2008', 'Trix dan Flix di Euro 2008', '816528mascot.jpg'),
(14, 21, 'Harry Potter', 'harry-potter', 'Game Harry Potter', '735687potter.jpg'),
(42, 21, 'Avatar', 'avatar', 'Eng si Gundul Avatar', '874877avatar.jpg'),
(16, 21, 'Shrek', 'shrek', 'Film 3D Shrek 2', '527801shrek06_800.jpg'),
(44, 21, 'Kenshin', 'kenshin', 'Kenshin Himura', '494110himura.jpg'),
(45, 21, 'Sun Goku', 'sun-goku', 'Goku Cilik', '266845goku.JPG'),
(46, 21, 'Virtual Girl', 'virtual-girl', 'Gadis Cantik 3D', '837921Girl.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `halamanstatis`
--
CREATE TABLE IF NOT EXISTS `halamanstatis` (
`id_halaman` int(5) NOT NULL AUTO_INCREMENT,
`judul` varchar(100) NOT NULL,
`isi_halaman` text NOT NULL,
`tgl_posting` date NOT NULL,
`gambar` varchar(100) NOT NULL,
`last_update` varchar(32) NOT NULL,
`last_update_time` date DEFAULT NULL,
PRIMARY KEY (`id_halaman`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `halamanstatis`
--
INSERT INTO `halamanstatis` (`id_halaman`, `judul`, `isi_halaman`, `tgl_posting`, `gambar`, `last_update`, `last_update_time`) VALUES
(1, 'Profil', 'Saung Bekasi Utara adalah sebuah sarana bagi kami, untuk saling tukar pikiran (sharing knowledge) dan sebagai salah satu wadah kami dalam berkreatifitas, untuk menjadi pemuda yang lebih produktif. Sehingga diharapkan kami dapat menghasilkan produk-produk yang dibutuhkan dan diterima oleh masyarakat khususnya anggota Saung Bekasi Utara.
', '2014-01-19', 'gedungku.jpg', 'admin', NULL),
(2, 'Visi dan Misi', '\r\nVisi :\r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\nMisi :\r\n
\r\n\r\n \r\n
\r\n', '2010-05-31', '', '', NULL),
(3, 'Struktur Organisasi', 'Isikan struktur organisasi di bagian ini\r\n', '2010-05-31', '', '', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `hubungi`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;
--
-- Dumping data for table `hubungi`
--
INSERT INTO `hubungi` (`id_hubungi`, `nama`, `email`, `subjek`, `pesan`, `tanggal`) VALUES
(1, 'Ariawan', 'ariawan@gmail.com', 'Mohon Informasi', 'Mohon informasi mengenai buku yang diterbitkan oleh Lokomedia.', '2008-02-10'),
(4, 'lukman', 'lukman@hakim', 'Request Code', 'Tolong dunk ..', '2009-02-25'),
(8, 'lukman', 'lukman@bukulokomedia.com', 'kontak kami', 'tes modul hubungi kami', '2010-05-16');
-- --------------------------------------------------------
--
-- Table structure for table `identitas`
--
CREATE TABLE IF NOT EXISTS `identitas` (
`id_identitas` int(5) NOT NULL AUTO_INCREMENT,
`nama_website` varchar(100) NOT NULL,
`alamat_website` varchar(100) NOT NULL,
`meta_deskripsi` varchar(250) NOT NULL,
`meta_keyword` varchar(250) NOT NULL,
`favicon` varchar(50) NOT NULL,
PRIMARY KEY (`id_identitas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `identitas`
--
INSERT INTO `identitas` (`id_identitas`, `nama_website`, `alamat_website`, `meta_deskripsi`, `meta_keyword`, `favicon`) VALUES
(1, 'bukulokomedia.com - penerbit lokomedia yogyakartas', 'http://localhost/lokomedia', 'lokomedia adalah penerbit buku-buku komputer khususnya di bidang pemrograman web dan internet.', 'lokomedia, bukulokomedia, toko online, buku komputer, trik, tutorial, konsultasi, distro kaos, php', 'favicon.ico');
-- --------------------------------------------------------
--
-- Table structure for table `katajelek`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `katajelek`
--
INSERT INTO `katajelek` (`id_jelek`, `kata`, `ganti`) VALUES
(4, 'sex', 's**'),
(2, 'bajingan', 'b*******'),
(3, 'bangsat', 'b******');
-- --------------------------------------------------------
--
-- Table structure for table `kategori`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `kategori`
--
INSERT INTO `kategori` (`id_kategori`, `nama_kategori`, `kategori_seo`, `aktif`) VALUES
(1, 'web programming', 'web-programming', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `komentar`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=102 ;
-- --------------------------------------------------------
--
-- Table structure for table `mainmenu`
--
CREATE TABLE IF NOT EXISTS `mainmenu` (
`id_main` int(5) NOT NULL AUTO_INCREMENT,
`nama_menu` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`icon` varchar(25) DEFAULT NULL,
`link` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id_main`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `mainmenu`
--
INSERT INTO `mainmenu` (`id_main`, `nama_menu`, `icon`, `link`, `aktif`) VALUES
(2, 'Home', 'icon-home', 'http://localhost/frontcms', 'Y'),
(3, 'Profil', 'icon-group', 'http://localhost/frontcms/profil', 'Y'),
(4, 'Agenda', 'icon-calendar', 'http://localhost/frontcms/schedule', 'Y'),
(5, 'Blog', 'icon-pencil', 'http://localhost/frontcms/blog', 'Y'),
(6, 'Download', 'icon-cloud-download', 'http://localhost/frontcms/download', 'Y'),
(8, 'Contact Us', 'icon-bell', 'http://localhost/frontcms/contact', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `menu_admin`
--
CREATE TABLE IF NOT EXISTS `menu_admin` (
`id_main` int(5) NOT NULL AUTO_INCREMENT,
`nama_menu` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`class` varchar(25) DEFAULT NULL,
`icon` varchar(25) DEFAULT NULL,
`link` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
`aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id_main`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `menu_admin`
--
INSERT INTO `menu_admin` (`id_main`, `nama_menu`, `class`, `icon`, `link`, `aktif`) VALUES
(2, 'Dashboard', 'dashaboard', 'icon-file', 'http://localhost/cms/dashboard', 'Y'),
(3, 'Manage Menu', 'menu', 'icon-tasks', 'http://localhost/cms/menu', 'Y'),
(4, 'Manage Agenda', NULL, 'icon-sort-by-alphabet-alt', 'http://localhost/cms/menu', 'Y'),
(5, 'Manage Blog', 'berita', ' icon-pencil', 'http://localhost/cms/berita', 'Y'),
(8, 'Manage User', 'user', 'icon-male', 'http://localhost/cms/user', 'Y'),
(19, 'Manage Profil', 'profil', 'icon-android', 'http://localhost/cms/profil', 'Y'),
(20, 'Manage Download', 'download', 'icon-trello', 'http://localhost/cms/download', 'Y'),
(21, 'Manage Notification', 'notification', 'icon-archive', 'http://localhost/cms/notification', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `menu_admin_group_access`
--
CREATE TABLE IF NOT EXISTS `menu_admin_group_access` (
`id_group_access` int(5) NOT NULL AUTO_INCREMENT,
`group` varchar(24) NOT NULL,
PRIMARY KEY (`id_group_access`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `menu_admin_group_access`
--
INSERT INTO `menu_admin_group_access` (`id_group_access`, `group`) VALUES
(1, 'admin'),
(2, 'user'),
(3, 'guest'),
(0, 'superadmin'),
(6, 'other');
-- --------------------------------------------------------
--
-- Table structure for table `menu_admin_role_access`
--
CREATE TABLE IF NOT EXISTS `menu_admin_role_access` (
`id_menu_role_access` int(5) NOT NULL AUTO_INCREMENT,
`id_main` int(5) NOT NULL,
`id_menu` int(5) DEFAULT NULL,
PRIMARY KEY (`id_menu_role_access`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;
--
-- Dumping data for table `menu_admin_role_access`
--
INSERT INTO `menu_admin_role_access` (`id_menu_role_access`, `id_main`, `id_menu`) VALUES
(55, 0, 8),
(54, 0, 19),
(53, 0, 3),
(52, 0, 20),
(51, 0, 5),
(50, 0, 4),
(49, 0, 2),
(34, 1, 3),
(33, 1, 5),
(30, 6, 5),
(22, 2, 3),
(23, 2, 5),
(32, 1, 2),
(31, 6, 4),
(35, 1, 19),
(56, 0, 21);
-- --------------------------------------------------------
--
-- Table structure for table `modul`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=62 ;
--
-- Dumping data for table `modul`
--
INSERT INTO `modul` (`id_modul`, `nama_modul`, `link`, `static_content`, `gambar`, `publish`, `status`, `aktif`, `urutan`, `link_seo`) VALUES
(2, 'Manajemen User', '?module=user', '', '', 'N', 'user', 'Y', 1, ''),
(18, 'Berita', '?module=berita', '', '', 'Y', 'user', 'Y', 6, 'semua-berita.html'),
(19, 'Banner', '?module=banner', '', '', 'Y', 'admin', 'Y', 9, ''),
(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'),
(10, 'Manajemen Modul', '?module=modul', '', '', 'N', 'admin', 'Y', 2, ''),
(31, 'Kategori', '?module=kategori', '', '', 'Y', 'admin', 'Y', 5, ''),
(33, 'Poling', '?module=poling', '', '', 'Y', 'admin', 'Y', 10, ''),
(34, 'Tag (Label)', '?module=tag', '', '', 'N', 'admin', 'Y', 7, ''),
(35, 'Komentar', '?module=komentar', '', '', 'Y', 'admin', 'Y', 8, ''),
(36, 'Download', '?module=download', '', '', 'Y', 'admin', 'Y', 11, 'semua-download.html'),
(40, 'Hubungi Kami', '?module=hubungi', '', '', 'Y', 'admin', 'Y', 12, 'hubungi-kami.html'),
(41, 'Agenda', ' ?module=agenda', '', '', 'Y', 'user', 'Y', 31, 'semua-agenda.html'),
(42, 'Shoutbox', '?module=shoutbox', '', '', 'Y', 'admin', 'Y', 13, ''),
(43, 'Album', '?module=album', '', '', 'N', 'admin', 'Y', 14, ''),
(44, 'Galeri Foto', '?module=galerifoto', '', '', 'Y', 'admin', 'Y', 15, ''),
(45, 'Templates', '?module=templates', '', '', 'N', 'admin', 'Y', 16, ''),
(46, 'Kata Jelek', '?module=katajelek', '', '', 'N', 'admin', 'Y', 17, ''),
(47, 'RSS', '-', '', '', 'Y', 'admin', 'N', 18, ''),
(48, 'YM', '-', '', '', 'Y', 'admin', 'N', 19, ''),
(49, 'Indeks Berita', '-', '', '', 'Y', 'admin', 'N', 20, ''),
(50, 'Kalender', '-', '', '', 'Y', 'admin', 'N', 21, ''),
(51, 'Statistik User', '-', '', '', 'Y', 'admin', 'N', 22, ''),
(52, 'Pencarian', '-', '', '', 'Y', 'admin', 'N', 23, ''),
(53, 'Berita Teratas', '-', '', '', 'Y', 'admin', 'N', 24, ''),
(54, 'Arsip Berita', '-', '', '', 'Y', 'admin', 'N', 25, ''),
(55, 'Berita Sebelumnya', '-', '', '', 'Y', 'admin', 'N', 26, ''),
(60, 'Sekilas Info', '?module=sekilasinfo', '', '', 'Y', 'admin', 'Y', 13, ''),
(57, 'Menu Utama', '?module=menuutama', '', '', 'Y', 'admin', 'Y', 28, ''),
(58, 'Sub Menu', '?module=submenu', '', '', 'Y', 'admin', 'Y', 29, ''),
(59, 'Halaman Statis', '?module=halamanstatis', '', '', 'Y', 'admin', 'Y', 30, ''),
(61, 'Identitas Website', '?module=identitas', '', '', 'N', 'admin', 'Y', 4, '');
-- --------------------------------------------------------
--
-- Table structure for table `poling`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
--
-- Dumping data for table `poling`
--
INSERT INTO `poling` (`id_poling`, `pilihan`, `status`, `rating`, `aktif`) VALUES
(1, 'Internet Explorer', 'Jawaban', 23, 'Y'),
(2, 'Mozilla Firefox', 'Jawaban', 81, 'Y'),
(3, 'Google Chrome', 'Jawaban', 21, 'Y'),
(4, 'Opera', 'Jawaban', 22, 'Y'),
(8, 'Apa Browser Favorit Anda?', 'Pertanyaan', 0, 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `sekilasinfo`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `sekilasinfo`
--
INSERT INTO `sekilasinfo` (`id_sekilas`, `info`, `tgl_posting`, `gambar`) VALUES
(1, 'Jangan lupa kopdar nasional mig33 di senayan', '2014-01-29', '');
-- --------------------------------------------------------
--
-- Table structure for table `shoutbox`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
--
-- Dumping data for table `shoutbox`
--
INSERT INTO `shoutbox` (`id_shoutbox`, `nama`, `website`, `pesan`, `tanggal`, `jam`, `aktif`) VALUES
(1, 'lukman', 'lukman.com', 'tes :-) aja ;-D ha ha ha <:D>', '2009-11-02', '00:00:00', 'Y'),
(2, 'hakim', 'hakim.com', 'tes :-) aja ;-D ha ha ha <:D>\r\ndfa\r\nfdas\r\nfdsa\r\nfdasf\r\n:-(', '2009-11-02', '00:00:00', 'Y'),
(3, 'daryono', 'bukulokomedia.com', 'ku tes lagi
\r\ntes :-) aja ;-D ha ha ha <:D>
\r\nkeren euy
\r\n:-(', '2009-11-02', '13:55:00', 'Y'),
(5, 'iin', 'uin-suka.ac.id', 'tes aja euy ;-D boi', '2009-11-03', '11:36:06', 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `statistik`
--
CREATE TABLE IF NOT EXISTS `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;
--
-- Dumping data for table `statistik`
--
INSERT INTO `statistik` (`ip`, `tanggal`, `hits`, `online`) VALUES
('127.0.0.2', '2009-09-11', 1, '1252681630'),
('127.0.0.1', '2009-09-11', 17, '1252734209'),
('127.0.0.3', '2009-09-12', 8, '1252817594'),
('127.0.0.1', '2009-10-24', 8, '1256381921'),
('127.0.0.1', '2009-10-26', 108, '1256620074'),
('127.0.0.1', '2009-10-27', 52, '1256686769'),
('127.0.0.1', '2009-10-28', 124, '1256792223'),
('127.0.0.1', '2009-10-29', 9, '1256828032'),
('127.0.0.1', '2009-10-31', 3, '1257047101'),
('127.0.0.1', '2009-11-01', 85, '1257113554'),
('127.0.0.1', '2009-11-02', 11, '1257207543'),
('127.0.0.1', '2009-11-03', 165, '1257292312'),
('127.0.0.1', '2009-11-04', 59, '1257403499'),
('127.0.0.1', '2009-11-05', 10, '1257433172'),
('127.0.0.1', '2009-11-11', 13, '1258006911'),
('127.0.0.1', '2009-11-12', 10, '1258048069'),
('127.0.0.1', '2009-11-14', 14, '1258222519'),
('127.0.0.1', '2009-11-17', 2, '1258473856'),
('127.0.0.1', '2009-11-19', 16, '1258635469'),
('127.0.0.1', '2009-11-21', 4, '1258863505'),
('127.0.0.1', '2009-11-25', 3, '1259216216'),
('127.0.0.1', '2009-11-26', 1, '1259222467'),
('127.0.0.1', '2009-11-30', 11, '1259651841'),
('127.0.0.1', '2009-12-02', 9, '1259746407'),
('127.0.0.1', '2009-12-03', 17, '1259906128'),
('127.0.0.1', '2009-12-10', 69, '1260423794'),
('127.0.0.1', '2009-12-12', 26, '1260560082'),
('127.0.0.1', '2009-12-11', 5, '1260508621'),
('127.0.0.1', '2009-12-13', 8, '1260716786'),
('127.0.0.1', '2009-12-14', 9, '1260772698'),
('127.0.0.1', '2009-12-15', 9, '1260837158'),
('127.0.0.1', '2009-12-16', 7, '1260905627'),
('127.0.0.1', '2009-12-17', 48, '1261026791'),
('127.0.0.1', '2009-12-18', 11, '1261088534'),
('127.0.0.1', '2009-12-22', 3, '1261477278'),
('127.0.0.1', '2009-12-25', 2, '1261686043'),
('127.0.0.1', '2009-12-26', 29, '1261835507'),
('127.0.0.1', '2009-12-27', 7, '1261920445'),
('127.0.0.1', '2009-12-28', 3, '1261965611'),
('127.0.0.1', '2009-12-29', 21, '1262024011'),
('127.0.0.1', '2009-12-30', 24, '1262146708'),
('127.0.0.1', '2010-01-01', 12, '1262286131'),
('127.0.0.1', '2010-01-03', 38, '1262529325'),
('127.0.0.1', '2010-01-12', 89, '1263264291'),
('127.0.0.1', '2010-01-14', 54, '1263482540'),
('127.0.0.1', '2010-01-15', 57, '1263506901'),
('127.0.0.1', '2010-02-11', 30, '1265831568'),
('127.0.0.1', '2010-02-13', 2, '1266032303'),
('127.0.0.1', '2010-02-14', 3, '1266115347'),
('127.0.0.1', '2010-02-15', 15, '1266195235'),
('127.0.0.1', '2010-02-18', 1, '1266499945'),
('127.0.0.1', '2010-02-22', 5, '1266856332'),
('127.0.0.1', '2010-02-25', 46, '1267103145'),
('127.0.0.1', '2010-05-12', 10, '1273654648'),
('127.0.0.1', '2010-05-16', 195, '1274026185'),
('127.0.0.1', '2010-05-17', 2, '1274029517'),
('127.0.0.1', '2010-05-19', 1, '1274279374'),
('127.0.0.1', '2010-05-27', 16, '1274967085'),
('127.0.0.1', '2010-05-30', 4, '1275192045'),
('127.0.0.1', '2010-05-31', 13, '1275271939'),
('127.0.0.1', '2010-06-05', 1, '1275676869'),
('127.0.0.1', '2010-06-06', 2, '1275842170'),
('127.0.0.1', '2010-06-15', 3, '1276572924'),
('127.0.0.1', '2010-06-22', 206, '1277221605'),
('127.0.0.1', '2010-08-02', 17, '1280754660'),
('127.0.0.1', '2010-08-20', 7, '1282285305'),
('127.0.0.1', '2010-08-30', 21, '1283185430'),
('127.0.0.1', '2010-08-31', 53, '1283207455'),
('127.0.0.1', '2010-09-02', 133, '1283402651'),
('127.0.0.1', '2010-09-05', 35, '1283702206'),
('127.0.0.1', '2010-09-13', 10, '1284370291'),
('127.0.0.1', '2010-09-17', 12, '1284662303'),
('127.0.0.1', '2010-09-22', 2, '1285091212'),
('127.0.0.1', '2010-09-23', 47, '1285254071'),
('127.0.0.1', '2010-09-26', 32, '1285512806'),
('127.0.0.1', '2010-09-27', 48, '1285529871'),
('127.0.0.1', '2011-01-19', 18, '1295395096'),
('127.0.0.1', '2011-01-21', 6, '1295580166'),
('127.0.0.1', '2011-01-22', 3, '1295639704'),
('127.0.0.1', '2011-01-25', 2, '1295895420'),
('127.0.0.1', '2011-01-27', 20, '1296145564'),
('127.0.0.1', '2011-01-28', 5, '1296150116'),
('127.0.0.1', '2011-02-01', 10, '1296555613'),
('127.0.0.1', '2011-02-02', 1, '1296657225'),
('127.0.0.1', '2011-02-05', 3, '1296875908'),
('127.0.0.1', '2011-02-07', 5, '1297090649'),
('127.0.0.1', '2011-02-09', 182, '1297254341'),
('127.0.0.1', '2011-02-10', 268, '1297355704'),
('127.0.0.1', '2011-02-16', 6, '1297824002'),
('127.0.0.1', '2011-02-17', 2, '1297945065'),
('127.0.0.1', '2011-12-28', 12, '1325081007'),
('127.0.0.1', '2011-12-29', 13, '1325167281'),
('127.0.0.1', '2011-12-31', 34, '1325296088'),
('127.0.0.1', '2012-01-02', 1, '1325449458'),
('127.0.0.1', '2012-01-03', 55, '1325601219'),
('127.0.0.1', '2012-01-04', 1, '1325630436'),
('127.0.0.1', '2012-02-08', 86, '1328720292'),
('127.0.0.1', '2012-02-09', 110, '1328798857'),
('127.0.0.1', '2012-02-10', 87, '1328871532'),
('127.0.0.1', '2012-02-11', 16, '1328899301'),
('127.0.0.1', '2012-03-31', 87, '1333186737'),
('127.0.0.1', '2012-04-01', 69, '1333248528'),
('127.0.0.1', '2012-04-02', 9, '1333338582'),
('127.0.0.1', '2012-04-03', 31, '1333456570'),
('127.0.0.1', '2012-04-04', 2, '1333498207'),
('127.0.0.1', '2012-04-05', 5, '1333628029'),
('127.0.0.1', '2012-04-08', 22, '1333871463'),
('127.0.0.1', '2012-04-09', 109, '1333972788'),
('127.0.0.1', '2012-04-10', 70, '1334024998'),
('127.0.0.1', '2012-05-01', 8, '1335889888'),
('127.0.0.1', '2012-05-02', 17, '1335935829'),
('127.0.0.1', '2012-05-27', 6, '1338133681'),
('127.0.0.1', '2012-05-29', 22, '1338304361'),
('127.0.0.1', '2012-05-30', 5, '1338389383'),
('127.0.0.1', '2012-05-31', 5, '1338408772'),
('127.0.0.1', '2012-06-01', 5, '1338567612'),
('127.0.0.1', '2012-07-01', 10, '1341152776');
-- --------------------------------------------------------
--
-- Table structure for table `submenu`
--
CREATE TABLE IF NOT EXISTS `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,
`id_main` int(5) NOT NULL,
`aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id_sub`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Table structure for table `submenu_admin`
--
CREATE TABLE IF NOT EXISTS `submenu_admin` (
`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,
`icon` varchar(32) DEFAULT NULL,
`description` varchar(300) DEFAULT NULL,
`id_main` int(5) NOT NULL,
`aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id_sub`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `submenu_admin`
--
INSERT INTO `submenu_admin` (`id_sub`, `nama_sub`, `link_sub`, `icon`, `description`, `id_main`, `aktif`) VALUES
(17, 'Musik', 'berita/widget/777', 'icon-music', 'Kami membuat lagu, kami mempunyai group band dan kami cukup sering tampil di atas panggung..', 5, 'Y'),
(18, 'Travelling', 'berita/widget/777', ' icon-plane', 'Kami suka berpegian, entah hanya untuk sekedar melepas penat atau merayakan sesuatu di bekasi utara', 5, 'Y'),
(16, 'Build Website Application', 'berita/widget/777', 'icon-desktop', 'We can build website applicatoin like e-commerce, e-learning, blog or website profil.', 5, 'Y');
-- --------------------------------------------------------
--
-- Table structure for table `tag`
--
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=22 ;
--
-- Dumping data for table `tag`
--
INSERT INTO `tag` (`id_tag`, `nama_tag`, `tag_seo`, `count`) VALUES
(1, 'Palestina', 'palestina', 7),
(2, 'Gaza', 'gaza', 11),
(9, 'Tenis', 'tenis', 5),
(10, 'Sepakbola', 'sepakbola', 7),
(8, 'Laskar Pelangi', 'laskar-pelangi', 2),
(11, 'Amerika', 'amerika', 18),
(12, 'George Bush', 'george-bush', 3),
(13, 'Browser', 'browser', 9),
(14, 'Google', 'google', 3),
(15, 'Israel', 'israel', 5),
(16, 'Komputer', 'komputer', 24),
(17, 'Film', 'film', 9),
(19, 'Mobil', 'mobil', 0),
(21, 'Gayus', 'gayus', 2);
-- --------------------------------------------------------
--
-- Table structure for table `templates`
--
CREATE TABLE IF NOT EXISTS `templates` (
`id_templates` 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_templates`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
--
-- Dumping data for table `templates`
--
INSERT INTO `templates` (`id_templates`, `judul`, `pembuat`, `folder`, `aktif`) VALUES
(1, 'Standar', 'Lukmanul Hakim', 'templates/standar', 'N'),
(2, 'Building', 'Lukmanul Hakim', 'templates/building', 'N'),
(3, 'eL jQuery', 'Lukmanul Hakim', 'templates/eljquery', 'N'),
(4, 'eL jQuery versi 2', 'Lukmanul Hakim', 'templates/eljquery2', 'N'),
(5, 'eL jQuery ala Yahoo', 'Lukmanul Hakim', 'templates/eljquery-yahoo', 'N'),
(7, 'Sandbox', 'Ahmad Nugraha', 'templates/sandbox', 'Y'),
(8, 'Just Simple Blue', 'Dian Pamungkas', 'templates/blue', 'N');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `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',
`role_id` int(2) NOT NULL COMMENT '0 = Super Admin\r\n',
`id_session` varchar(100) COLLATE latin1_general_ci NOT NULL,
`facebook` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
`twitter` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
`linkedin` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
`googleplus` varchar(110) COLLATE latin1_general_ci DEFAULT NULL,
`gambar` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
`tgl_insert` date NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`username`, `password`, `nama_lengkap`, `email`, `no_telp`, `level`, `blokir`, `role_id`, `id_session`, `facebook`, `twitter`, `linkedin`, `googleplus`, `gambar`, `tgl_insert`) VALUES
('admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'admin@detik.com', '08238923848', 'admin', 'N', 0, '260580d287f6489d86c8f0bcc1680169', NULL, NULL, NULL, NULL, NULL, '0000-00-00'),
('akisaung', 'a01891e90e4133c30fb2f0467ae756a4', 'aki saung (Pak Kanta)', 'akisaung@gmail.com', '081237364924788', 'user', 'N', 2, '', '', '', '', '', 'WP_20131103_069.jpg', '2014-01-21'),
('puma', 'd9f32436125b47e03d11fbf1fa62424a', 'Putri Marlina', 'puma@gmail.com', '083875007774', 'admin', 'N', 1, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00'),
('philtyphil', 'fafcc6a08fe77228b32f3d56f92856bb', 'Sulistyo Nur Anggoro. Skom', 'philtyphils@gmail.com', '083875007779', 'guest', 'N', 3, '', 'https://www.facebook.com/philtygrin', NULL, NULL, NULL, NULL, '0000-00-00'),
('philtyphils', 'd5cfbc9179a7f4e999a86d20bd0ef465', 'Sulistyo Nur Anggoro', 'philtyphil@ovi.com', '083750007779', 'user', 'N', 2, '', '', '', '', '', 'test1.jpg', '2014-01-21');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;