Untitled

SUBMITTED BY: Guest

DATE: Feb. 4, 2014, 5:21 p.m.

FORMAT: Text only

SIZE: 48.2 kB

Raw Download

HITS: 792

Report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.4.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Feb 04, 2014 at 06:18 PM
  7. -- Server version: 5.5.32
  8. -- PHP Version: 5.4.16
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  19. --
  20. -- Database: `dbblog`
  21. --
  22. CREATE DATABASE IF NOT EXISTS `dbblog` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  23. USE `dbblog`;
  25. -- --------------------------------------------------------
  27. --
  28. -- Table structure for table `agenda`
  29. --
  31. CREATE TABLE IF NOT EXISTS `agenda` (
  32. `id_agenda` int(5) NOT NULL AUTO_INCREMENT,
  33. `tema` varchar(100) COLLATE latin1_general_ci NOT NULL,
  34. `tema_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  35. `isi_agenda` text COLLATE latin1_general_ci NOT NULL,
  36. `tempat` varchar(100) COLLATE latin1_general_ci NOT NULL,
  37. `pengirim` varchar(100) COLLATE latin1_general_ci NOT NULL,
  38. `tgl_mulai` date NOT NULL,
  39. `tgl_selesai` date NOT NULL,
  40. `tgl_posting` date NOT NULL,
  41. `jam` varchar(50) COLLATE latin1_general_ci NOT NULL,
  42. `username` varchar(50) COLLATE latin1_general_ci NOT NULL,
  43. PRIMARY KEY (`id_agenda`)
  44. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=40 ;
  46. -- --------------------------------------------------------
  48. --
  49. -- Table structure for table `album`
  50. --
  52. CREATE TABLE IF NOT EXISTS `album` (
  53. `id_album` int(5) NOT NULL AUTO_INCREMENT,
  54. `jdl_album` varchar(100) COLLATE latin1_general_ci NOT NULL,
  55. `album_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  56. `gbr_album` varchar(100) COLLATE latin1_general_ci NOT NULL,
  57. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  58. PRIMARY KEY (`id_album`)
  59. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=25 ;
  61. --
  62. -- Dumping data for table `album`
  63. --
  65. INSERT INTO `album` (`id_album`, `jdl_album`, `album_seo`, `gbr_album`, `aktif`) VALUES
  66. (21, 'Kartun', 'kartun', '476928sonic.jpg', 'Y'),
  67. (20, 'Pernikahan', 'pernikahan', '146667nikah.jpg', 'Y'),
  68. (18, 'Bayi', 'bayi', '246551silvestree.jpg', 'Y'),
  69. (12, 'Ilustrator', 'ilustrator', '987701family.jpg', 'Y'),
  70. (19, 'Binatang', 'binatang', '391479burung.jpg', 'Y'),
  71. (17, 'Arsitektur', 'arsitektur', '741638arche090.jpg', 'Y');
  73. -- --------------------------------------------------------
  75. --
  76. -- Table structure for table `banner`
  77. --
  79. CREATE TABLE IF NOT EXISTS `banner` (
  80. `id_banner` int(5) NOT NULL AUTO_INCREMENT,
  81. `judul` varchar(100) COLLATE latin1_general_ci NOT NULL,
  82. `url` varchar(100) COLLATE latin1_general_ci NOT NULL,
  83. `gambar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  84. `tgl_posting` date NOT NULL,
  85. PRIMARY KEY (`id_banner`)
  86. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
  88. --
  89. -- Dumping data for table `banner`
  90. --
  92. INSERT INTO `banner` (`id_banner`, `judul`, `url`, `gambar`, `tgl_posting`) VALUES
  93. (4, 'Fresh Book', 'http://freshbooks.com', 'freshbook.jpg', '2009-02-05'),
  94. (7, 'Cinema 21', 'http://21cineplex.com', 'cinema21.jpg', '2008-02-09');
  96. -- --------------------------------------------------------
  98. --
  99. -- Table structure for table `berita`
  100. --
  102. CREATE TABLE IF NOT EXISTS `berita` (
  103. `id_berita` int(5) NOT NULL AUTO_INCREMENT,
  104. `id_kategori` int(5) NOT NULL,
  105. `username` varchar(30) COLLATE latin1_general_ci NOT NULL,
  106. `judul` varchar(100) COLLATE latin1_general_ci NOT NULL,
  107. `judul_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  108. `headline` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  109. `isi_berita` text COLLATE latin1_general_ci NOT NULL,
  110. `hari` varchar(20) COLLATE latin1_general_ci NOT NULL,
  111. `tanggal` date NOT NULL,
  112. `jam` time NOT NULL,
  113. `gambar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  114. `dibaca` int(5) NOT NULL DEFAULT '1',
  115. `tag` varchar(100) COLLATE latin1_general_ci NOT NULL,
  116. `last_edit` date DEFAULT NULL COMMENT 'log edit berita',
  117. PRIMARY KEY (`id_berita`)
  118. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;
  120. --
  121. -- Dumping data for table `berita`
  122. --
  124. INSERT INTO `berita` (`id_berita`, `id_kategori`, `username`, `judul`, `judul_seo`, `headline`, `isi_berita`, `hari`, `tanggal`, `jam`, `gambar`, `dibaca`, `tag`, `last_edit`) VALUES
  125. (8, 77717, 'admin', 'Lagu Mars Saung Bekasi Utara', 'Lagu-Mars-Saung-Bekasi-Utara.html', 'Y', '<p><em>Lyric</em>&nbsp;MARS&nbsp;Saung&nbsp;Bekasi&nbsp;Utara</p>\n\n<p>Selamat&nbsp;datang&nbsp;di&nbsp;basecamp&nbsp;kami</p>\n\n<p>saung&nbsp;sederhana&nbsp;yang&nbsp;penting&nbsp;happy</p>\n\n<p>ngobrol-ngobrol&nbsp;kenalan&nbsp;sambil&nbsp;ngopi-ngopi</p>\n\n<p>main&nbsp;poker,&nbsp;main&nbsp;uno&nbsp;sampai&nbsp;pagi..</p>\n\n<p>kalo&nbsp;gak&nbsp;bisa&nbsp;main&nbsp;kartu&nbsp;jangan&nbsp;minder&nbsp;dulu,</p>\n\n<p>ada&nbsp;gitar,&nbsp;ada&nbsp;catur&nbsp;janganlah&nbsp;malu-malu</p>\n\n<p>kenalan&nbsp;donk..&nbsp;(situ&nbsp;siapa&nbsp;darimana)</p>\n\n<p>Ini&nbsp;lah&nbsp;dari&nbsp;mig33&nbsp;bekasi&nbsp;utara.</p>\n\n<p>room&nbsp;kami&nbsp;bebas&nbsp;gak&nbsp;ada&nbsp;moderator&nbsp;list</p>\n\n<p>mau&nbsp;ngflood&nbsp;mau&nbsp;ngkick&nbsp;bebas&nbsp;yang&nbsp;penting&nbsp;laris</p>\n\n<p>cowo&nbsp;nya&nbsp;asik-asik</p>\n\n<p>cewenya&nbsp;manis-manis</p>\n\n<p>kalo&nbsp;situ&nbsp;usik,&nbsp;kita&nbsp;bisa&nbsp;jadi&nbsp;sadis.</p>\n\n<p>sorry&nbsp;boss,&nbsp;kita&nbsp;emang&nbsp;ceplas&nbsp;ceplos</p>\n\n<p>biar&nbsp;gak&nbsp;selek&nbsp;yo&nbsp;marilah&nbsp;kita&nbsp;toss.</p>\n\n<p>kalo&nbsp;punya&nbsp;masalah&nbsp;di&nbsp;room&nbsp;mending&nbsp;jangan&nbsp;pada&nbsp;berisik</p>\n\n<p>mending&nbsp;damai&nbsp;sambil&nbsp;kopdar&nbsp;biar&nbsp;tambah&nbsp;asik</p>\n\n<p>&nbsp;</p>\n\n<p><em>reff:</em></p>\n\n<p>Saung&nbsp;mig33..</p>\n\n<p>Bekasi&nbsp;Utara..</p>\n\n<p>Disini&nbsp;kami..</p>\n\n<p>tempat&nbsp;berbagi&nbsp;rasa.</p>\n\n<p>&nbsp;</p>\n\n<p>Mau&nbsp;jadi&nbsp;moduser,&nbsp;flooder&nbsp;atau&nbsp;kicker</p>\n\n<p>terserah&nbsp;deh&nbsp;yang&nbsp;penting&nbsp;lo&nbsp;pake&nbsp;nick&nbsp;master</p>\n\n<p>udah&nbsp;ah&nbsp;cape&nbsp;ngetiknya&nbsp;:p</p>', 'Minggu', '2014-02-02', '17:45:40', 'saung.jpg', 1, '#philtyphil', NULL),
  126. (7, 77716, 'admin', 'Web Aplikasi KAS Saung Bekasi Utara', 'Web-Aplikasi-KAS-Saung-Bekasi-Utara.html', 'Y', '<p>Web&nbsp;aplikasi&nbsp;KAS&nbsp;saung&nbsp;bekasi&nbsp;utara&nbsp;ini,&nbsp;dibuat&nbsp;dengan&nbsp;tujuan&nbsp;menjaga&nbsp;transparasi&nbsp;keuangan&nbsp;saung&nbsp;bekasi&nbsp;utara.&nbsp;Sehingga&nbsp;semua&nbsp;aktifitas&nbsp;keuangan&nbsp;saung&nbsp;bekasi&nbsp;utara,&nbsp;dapat&nbsp;ter-<em>record</em>&nbsp;dan&nbsp;dapat&nbsp;dilihat&nbsp;oleh&nbsp;semua&nbsp;anggota&nbsp;secara&nbsp;<em>online</em>.</p>\n\n<p>Aplikasi&nbsp;ini&nbsp;dibuat&nbsp;dengan&nbsp;menggunakan&nbsp;Framework&nbsp;Codeigniter,&nbsp;Database&nbsp;MYSQL,&nbsp;jQUery&nbsp;1.10.1,&nbsp;dan&nbsp;plugin&nbsp;datatables.</p>\n\n<p>Download&nbsp;aplikasi&nbsp;-><a href="http://localhost/frontcms/download/choose/1">&nbsp;download</a></p>', 'Sabtu', '2014-02-01', '10:51:31', 'hblw.jpg', 1, '#philtyphil', NULL),
  127. (9, 77718, 'admin', 'Backpacker Semarang Jogja', 'Backpacker-Semarang-Jogja.html', 'Y', '<p>Backpacker&nbsp;kita&nbsp;kali&nbsp;ini&nbsp;seru&nbsp;banget.&nbsp;Kita&nbsp;memanfaatkan&nbsp;tanggalan&nbsp;kejepit&nbsp;di&nbsp;bulan&nbsp;november.&nbsp;Setelah&nbsp;semuanya&nbsp;di&nbsp;persiapkan&nbsp;selama&nbsp;sebulan&nbsp;lebih.&nbsp;Akhirnya&nbsp;kita&nbsp;berangkat&nbsp;juga.</p>\n\n<p>Sebelum&nbsp;berangkat,&nbsp;kita&nbsp;sepakat,&nbsp;untuk&nbsp;ngumpul&nbsp;dulu&nbsp;di&nbsp;stasiun&nbsp;bekasi.&nbsp;Karena&nbsp;kita&nbsp;harus&nbsp;ke&nbsp;stasiun&nbsp;senin&nbsp;dulu&nbsp;untuk&nbsp;keberangkatan&nbsp;keretanya.&nbsp;Dan&nbsp;inilah&nbsp;kami,&nbsp;ketika&nbsp;berada&nbsp;di&nbsp;stasiun&nbsp;bekasi&nbsp;sambil&nbsp;menunggu&nbsp;kerta&nbsp;commuterline&nbsp;kami&nbsp;datang.</p>\n <p><img alt="stasiun bekasi" src="http://imageshack.com/a/img194/7408/ximh.jpg" /></p>\n\n<p>Lalu,&nbsp;akhirnya&nbsp;tibalah&nbsp;kereta&nbsp;commuterline&nbsp;kami&nbsp;dan&nbsp;kamipun&nbsp;sudah&nbsp;ada&nbsp;di&nbsp;stasiun&nbsp;senen.</p>\n <p><img alt="stasiun senen" src="http://imageshack.com/a/img580/2522/8cit.jpg" /></p>\n\n<p>Dan&nbsp;ini&nbsp;ketika&nbsp;kami&nbsp;sudah&nbsp;dikereta.</p>\n <p><img alt="kereta gaya baru malam" src="http://imageshack.com/a/img545/576/rft7.jpg" /></p>\n <p><img alt="" src="http://imageshack.com/a/img837/6742/6ziq.jpg" /></p>\n <p><img alt="semarang" src="http://imageshack.com/a/img208/2633/ycrw.jpg" /></p>', 'Minggu', '2014-02-02', '18:24:07', 'CT_1_jpg.jpg', 1, '#backpacker,#semarang-jogja', NULL),
  128. (10, 1, 'admin', 'Resize And Crop Image with PHP', 'Resize-And-Crop-Image-with-PHP.html', 'Y', '<p>Masalah&nbsp;resize&nbsp;foto&nbsp;ini,&nbsp;saya&nbsp;alami&nbsp;ketika&nbsp;membuat&nbsp;website&nbsp;ini.&nbsp;Ini&nbsp;dikarenakan,&nbsp;saya&nbsp;harus&nbsp;mempertahan&nbsp;ke-<em>responsive</em>-an&nbsp;website&nbsp;ini,&nbsp;sehingga&nbsp;saya&nbsp;tidak&nbsp;bisa&nbsp;menuliskan&nbsp;image&nbsp;seperti&nbsp;ini.</p>\n\n<pre class="brush:xml;">\n<img&nbsp;src="img.jpg"&nbsp;width="400"&nbsp;height="300"/></pre>\n\n<p>Dengan&nbsp;memaksa&nbsp;ukuran&nbsp;photo&nbsp;seperti&nbsp;itu,&nbsp;membuat&nbsp;website&nbsp;ini&nbsp;jadi&nbsp;kurang&nbsp;responsive,&nbsp;oleh&nbsp;sebab&nbsp;itu&nbsp;saya&nbsp;harus&nbsp;automatis&nbsp;me-resize&nbsp;foto,&nbsp;ketika&nbsp;akan&nbsp;menambahan&nbsp;foto&nbsp;pada&nbsp;setiap&nbsp;berita.</p>\n\n<p>inilah&nbsp;source&nbsp;code&nbsp;yang&nbsp;saya&nbsp;gunakan.</p>\n\n<pre class="brush:php;ruler:true;wrap-lines:false;">\n$image&nbsp;=&nbsp;imagecreatefromjpeg($_GET['src']);\n$filename&nbsp;='images/cropped_whatever.jpg';\n\n$thumb_width&nbsp;=200;\n$thumb_height&nbsp;=150;\n\n$width&nbsp;=&nbsp;imagesx($image);\n$height&nbsp;=&nbsp;imagesy($image);\n\n$original_aspect&nbsp;=&nbsp;$width&nbsp;/&nbsp;$height;\n$thumb_aspect&nbsp;=&nbsp;$thumb_width&nbsp;/&nbsp;$thumb_height;if(&nbsp;$original_aspect&nbsp;>=&nbsp;$thumb_aspect&nbsp;){//&nbsp;If&nbsp;image&nbsp;is&nbsp;wider&nbsp;than&nbsp;thumbnail&nbsp;(in&nbsp;aspect&nbsp;ratio&nbsp;sense)\n&nbsp;&nbsp;&nbsp;$new_height&nbsp;=&nbsp;$thumb_height;\n&nbsp;&nbsp;&nbsp;$new_width&nbsp;=&nbsp;$width&nbsp;/($height&nbsp;/&nbsp;$thumb_height);}else{//&nbsp;If&nbsp;the&nbsp;thumbnail&nbsp;is&nbsp;wider&nbsp;than&nbsp;the&nbsp;image\n&nbsp;&nbsp;&nbsp;$new_width&nbsp;=&nbsp;$thumb_width;\n&nbsp;&nbsp;&nbsp;$new_height&nbsp;=&nbsp;$height&nbsp;/($width&nbsp;/&nbsp;$thumb_width);}\n\n$thumb&nbsp;=&nbsp;imagecreatetruecolor(&nbsp;$thumb_width,&nbsp;$thumb_height&nbsp;);//&nbsp;Resize&nbsp;and&nbsp;crop\nimagecopyresampled($thumb,\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$image,0-($new_width&nbsp;-&nbsp;$thumb_width)/2,//&nbsp;Center&nbsp;the&nbsp;image&nbsp;horizontally0-($new_height&nbsp;-&nbsp;$thumb_height)/2,//&nbsp;Center&nbsp;the&nbsp;image&nbsp;vertically0,0,\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$new_width,&nbsp;$new_height,\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$width,&nbsp;$height);\nimagejpeg($thumb,&nbsp;$filename,80);</pre>\n\n<p>Nah,&nbsp;selamat&nbsp;mencoba&nbsp;yah.</p>', 'Minggu', '2014-02-02', '18:41:14', 'PHP.jpg', 1, '#philtyphil,#resize_image,#php', NULL);
  130. -- --------------------------------------------------------
  132. --
  133. -- Table structure for table `download`
  134. --
  136. CREATE TABLE IF NOT EXISTS `download` (
  137. `id_download` int(5) NOT NULL AUTO_INCREMENT,
  138. `judul` varchar(100) COLLATE latin1_general_ci NOT NULL,
  139. `nama_pengupload` varchar(100) COLLATE latin1_general_ci NOT NULL,
  140. `tgl_posting` date NOT NULL,
  141. `hits` int(3) NOT NULL,
  142. `link` varchar(350) COLLATE latin1_general_ci DEFAULT NULL,
  143. PRIMARY KEY (`id_download`)
  144. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
  146. --
  147. -- Dumping data for table `download`
  148. --
  150. INSERT INTO `download` (`id_download`, `judul`, `nama_pengupload`, `tgl_posting`, `hits`, `link`) VALUES
  151. (1, 'Web Aplikasi KAS Saung Bekasi Utara [SOURCE CODE]]', 'admin', '2014-02-01', 0, 'http://adf.ly/cvSPi'),
  152. (2, 'Lagu Mars Bekasi Utara', 'admin', '2014-02-02', 0, 'http://adf.ly/csO3J');
  154. -- --------------------------------------------------------
  156. --
  157. -- Table structure for table `gallery`
  158. --
  160. CREATE TABLE IF NOT EXISTS `gallery` (
  161. `id_gallery` int(5) NOT NULL AUTO_INCREMENT,
  162. `id_album` int(5) NOT NULL,
  163. `jdl_gallery` varchar(100) COLLATE latin1_general_ci NOT NULL,
  164. `gallery_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  165. `keterangan` text COLLATE latin1_general_ci NOT NULL,
  166. `gbr_gallery` varchar(100) COLLATE latin1_general_ci NOT NULL,
  167. PRIMARY KEY (`id_gallery`)
  168. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=56 ;
  170. --
  171. -- Dumping data for table `gallery`
  172. --
  174. INSERT INTO `gallery` (`id_gallery`, `id_album`, `jdl_gallery`, `gallery_seo`, `keterangan`, `gbr_gallery`) VALUES
  175. (3, 12, 'Duduk di Sofa', 'duduk-di-sofa', 'Sekeluarga sedang duduk di sofa.', '27587family sofa.jpg'),
  176. (4, 12, 'Didepan Rumah', 'didepan-rumah', 'Sekeluarga sedang berada di ladang.', '258819family field.jpg'),
  177. (5, 12, 'Keluarga Bahagia', 'keluarga-bahagia', 'Si anak memperlihatkan lukisan.', '697448family.jpg'),
  178. (7, 19, 'Lebah', 'lebah', 'Lebah besar terbang.', '322906lebah.jpg'),
  179. (8, 17, 'Bangunan Jepang', 'bangunan-jepang', 'Bangunan khas jepang', '370422arche037.jpg'),
  180. (9, 17, 'Candi Merang', 'candi-merang', 'Bangunan candi khas kerajaan', '346527arche014.jpg'),
  181. (10, 18, 'Cukur Janggut', 'cukur-janggut', 'Bayi unik sedang cukur rambut', '892395macho4.jpg'),
  182. (11, 18, 'Push Up', 'push-up', 'Bayi unik sedang melakukan push-up', '991546macho1.jpg'),
  183. (12, 19, 'Kuda Nyengir', 'kuda-nyengir', 'Gini nih kalau kuda lagi nyengir.', '658447kuda.jpg'),
  184. (13, 21, 'Super Mario Bross', 'super-mario-bross', 'Game klasik 3D Mario Bross.', '601318mario bros.jpg'),
  185. (32, 21, 'Naruto', 'naruto', 'Kartun ninja jepang Naruto', '45440naruto.jpg'),
  186. (15, 21, 'Superman', 'superman', 'Superman kecil mau beraksi', '689147superman.jpg'),
  187. (27, 21, 'Sonic', 'sonic', 'Sonic and Friend', '152618sonic.jpg'),
  188. (31, 21, 'Kungfu Panda', 'kungfu-panda', 'Jack Black', '550598panda2.jpg'),
  189. (33, 21, 'Maskot Euro 2008', 'maskot-euro-2008', 'Trix dan Flix di Euro 2008', '816528mascot.jpg'),
  190. (14, 21, 'Harry Potter', 'harry-potter', 'Game Harry Potter', '735687potter.jpg'),
  191. (42, 21, 'Avatar', 'avatar', 'Eng si Gundul Avatar', '874877avatar.jpg'),
  192. (16, 21, 'Shrek', 'shrek', 'Film 3D Shrek 2', '527801shrek06_800.jpg'),
  193. (44, 21, 'Kenshin', 'kenshin', 'Kenshin Himura', '494110himura.jpg'),
  194. (45, 21, 'Sun Goku', 'sun-goku', 'Goku Cilik', '266845goku.JPG'),
  195. (46, 21, 'Virtual Girl', 'virtual-girl', 'Gadis Cantik 3D', '837921Girl.jpg');
  197. -- --------------------------------------------------------
  199. --
  200. -- Table structure for table `halamanstatis`
  201. --
  203. CREATE TABLE IF NOT EXISTS `halamanstatis` (
  204. `id_halaman` int(5) NOT NULL AUTO_INCREMENT,
  205. `judul` varchar(100) NOT NULL,
  206. `isi_halaman` text NOT NULL,
  207. `tgl_posting` date NOT NULL,
  208. `gambar` varchar(100) NOT NULL,
  209. `last_update` varchar(32) NOT NULL,
  210. `last_update_time` date DEFAULT NULL,
  211. PRIMARY KEY (`id_halaman`)
  212. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  214. --
  215. -- Dumping data for table `halamanstatis`
  216. --
  218. INSERT INTO `halamanstatis` (`id_halaman`, `judul`, `isi_halaman`, `tgl_posting`, `gambar`, `last_update`, `last_update_time`) VALUES
  219. (1, 'Profil', '<b><a title="Link: http://#" rel="nofollow" target="_blank" href="http://#">Saung Bekasi Utara</a></b> <b></b>adalah sebuah sarana bagi kami, untuk saling tukar pikiran (<i>sharing knowledge</i>) 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.<br>', '2014-01-19', 'gedungku.jpg', 'admin', NULL),
  220. (2, 'Visi dan Misi', '<p>\r\nVisi :\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p>\r\nMisi :\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n', '2010-05-31', '', '', NULL),
  221. (3, 'Struktur Organisasi', 'Isikan struktur organisasi di bagian ini\r\n', '2010-05-31', '', '', NULL);
  223. -- --------------------------------------------------------
  225. --
  226. -- Table structure for table `hubungi`
  227. --
  229. CREATE TABLE IF NOT EXISTS `hubungi` (
  230. `id_hubungi` int(5) NOT NULL AUTO_INCREMENT,
  231. `nama` varchar(50) COLLATE latin1_general_ci NOT NULL,
  232. `email` varchar(100) COLLATE latin1_general_ci NOT NULL,
  233. `subjek` varchar(100) COLLATE latin1_general_ci NOT NULL,
  234. `pesan` text COLLATE latin1_general_ci NOT NULL,
  235. `tanggal` date NOT NULL,
  236. PRIMARY KEY (`id_hubungi`)
  237. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;
  239. --
  240. -- Dumping data for table `hubungi`
  241. --
  243. INSERT INTO `hubungi` (`id_hubungi`, `nama`, `email`, `subjek`, `pesan`, `tanggal`) VALUES
  244. (1, 'Ariawan', 'ariawan@gmail.com', 'Mohon Informasi', 'Mohon informasi mengenai buku yang diterbitkan oleh Lokomedia.', '2008-02-10'),
  245. (4, 'lukman', 'lukman@hakim', 'Request Code', 'Tolong dunk ..', '2009-02-25'),
  246. (8, 'lukman', 'lukman@bukulokomedia.com', 'kontak kami', 'tes modul hubungi kami', '2010-05-16');
  248. -- --------------------------------------------------------
  250. --
  251. -- Table structure for table `identitas`
  252. --
  254. CREATE TABLE IF NOT EXISTS `identitas` (
  255. `id_identitas` int(5) NOT NULL AUTO_INCREMENT,
  256. `nama_website` varchar(100) NOT NULL,
  257. `alamat_website` varchar(100) NOT NULL,
  258. `meta_deskripsi` varchar(250) NOT NULL,
  259. `meta_keyword` varchar(250) NOT NULL,
  260. `favicon` varchar(50) NOT NULL,
  261. PRIMARY KEY (`id_identitas`)
  262. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  264. --
  265. -- Dumping data for table `identitas`
  266. --
  268. INSERT INTO `identitas` (`id_identitas`, `nama_website`, `alamat_website`, `meta_deskripsi`, `meta_keyword`, `favicon`) VALUES
  269. (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');
  271. -- --------------------------------------------------------
  273. --
  274. -- Table structure for table `katajelek`
  275. --
  277. CREATE TABLE IF NOT EXISTS `katajelek` (
  278. `id_jelek` int(11) NOT NULL AUTO_INCREMENT,
  279. `kata` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  280. `ganti` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  281. PRIMARY KEY (`id_jelek`)
  282. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
  284. --
  285. -- Dumping data for table `katajelek`
  286. --
  288. INSERT INTO `katajelek` (`id_jelek`, `kata`, `ganti`) VALUES
  289. (4, 'sex', 's**'),
  290. (2, 'bajingan', 'b*******'),
  291. (3, 'bangsat', 'b******');
  293. -- --------------------------------------------------------
  295. --
  296. -- Table structure for table `kategori`
  297. --
  299. CREATE TABLE IF NOT EXISTS `kategori` (
  300. `id_kategori` int(5) NOT NULL AUTO_INCREMENT,
  301. `nama_kategori` varchar(50) COLLATE latin1_general_ci NOT NULL,
  302. `kategori_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  303. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  304. PRIMARY KEY (`id_kategori`)
  305. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
  307. --
  308. -- Dumping data for table `kategori`
  309. --
  311. INSERT INTO `kategori` (`id_kategori`, `nama_kategori`, `kategori_seo`, `aktif`) VALUES
  312. (1, 'web programming', 'web-programming', 'Y');
  314. -- --------------------------------------------------------
  316. --
  317. -- Table structure for table `komentar`
  318. --
  320. CREATE TABLE IF NOT EXISTS `komentar` (
  321. `id_komentar` int(5) NOT NULL AUTO_INCREMENT,
  322. `id_berita` int(5) NOT NULL,
  323. `nama_komentar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  324. `url` varchar(100) COLLATE latin1_general_ci NOT NULL,
  325. `isi_komentar` text COLLATE latin1_general_ci NOT NULL,
  326. `tgl` date NOT NULL,
  327. `jam_komentar` time NOT NULL,
  328. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  329. PRIMARY KEY (`id_komentar`)
  330. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=102 ;
  332. -- --------------------------------------------------------
  334. --
  335. -- Table structure for table `mainmenu`
  336. --
  338. CREATE TABLE IF NOT EXISTS `mainmenu` (
  339. `id_main` int(5) NOT NULL AUTO_INCREMENT,
  340. `nama_menu` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  341. `icon` varchar(25) DEFAULT NULL,
  342. `link` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  343. `aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
  344. PRIMARY KEY (`id_main`)
  345. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
  347. --
  348. -- Dumping data for table `mainmenu`
  349. --
  351. INSERT INTO `mainmenu` (`id_main`, `nama_menu`, `icon`, `link`, `aktif`) VALUES
  352. (2, 'Home', 'icon-home', 'http://localhost/frontcms', 'Y'),
  353. (3, 'Profil', 'icon-group', 'http://localhost/frontcms/profil', 'Y'),
  354. (4, 'Agenda', 'icon-calendar', 'http://localhost/frontcms/schedule', 'Y'),
  355. (5, 'Blog', 'icon-pencil', 'http://localhost/frontcms/blog', 'Y'),
  356. (6, 'Download', 'icon-cloud-download', 'http://localhost/frontcms/download', 'Y'),
  357. (8, 'Contact Us', 'icon-bell', 'http://localhost/frontcms/contact', 'Y');
  359. -- --------------------------------------------------------
  361. --
  362. -- Table structure for table `menu_admin`
  363. --
  365. CREATE TABLE IF NOT EXISTS `menu_admin` (
  366. `id_main` int(5) NOT NULL AUTO_INCREMENT,
  367. `nama_menu` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  368. `class` varchar(25) DEFAULT NULL,
  369. `icon` varchar(25) DEFAULT NULL,
  370. `link` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  371. `aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
  372. PRIMARY KEY (`id_main`)
  373. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
  375. --
  376. -- Dumping data for table `menu_admin`
  377. --
  379. INSERT INTO `menu_admin` (`id_main`, `nama_menu`, `class`, `icon`, `link`, `aktif`) VALUES
  380. (2, 'Dashboard', 'dashaboard', 'icon-file', 'http://localhost/cms/dashboard', 'Y'),
  381. (3, 'Manage Menu', 'menu', 'icon-tasks', 'http://localhost/cms/menu', 'Y'),
  382. (4, 'Manage Agenda', NULL, 'icon-sort-by-alphabet-alt', 'http://localhost/cms/menu', 'Y'),
  383. (5, 'Manage Blog', 'berita', ' icon-pencil', 'http://localhost/cms/berita', 'Y'),
  384. (8, 'Manage User', 'user', 'icon-male', 'http://localhost/cms/user', 'Y'),
  385. (19, 'Manage Profil', 'profil', 'icon-android', 'http://localhost/cms/profil', 'Y'),
  386. (20, 'Manage Download', 'download', 'icon-trello', 'http://localhost/cms/download', 'Y'),
  387. (21, 'Manage Notification', 'notification', 'icon-archive', 'http://localhost/cms/notification', 'Y');
  389. -- --------------------------------------------------------
  391. --
  392. -- Table structure for table `menu_admin_group_access`
  393. --
  395. CREATE TABLE IF NOT EXISTS `menu_admin_group_access` (
  396. `id_group_access` int(5) NOT NULL AUTO_INCREMENT,
  397. `group` varchar(24) NOT NULL,
  398. PRIMARY KEY (`id_group_access`)
  399. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
  401. --
  402. -- Dumping data for table `menu_admin_group_access`
  403. --
  405. INSERT INTO `menu_admin_group_access` (`id_group_access`, `group`) VALUES
  406. (1, 'admin'),
  407. (2, 'user'),
  408. (3, 'guest'),
  409. (0, 'superadmin'),
  410. (6, 'other');
  412. -- --------------------------------------------------------
  414. --
  415. -- Table structure for table `menu_admin_role_access`
  416. --
  418. CREATE TABLE IF NOT EXISTS `menu_admin_role_access` (
  419. `id_menu_role_access` int(5) NOT NULL AUTO_INCREMENT,
  420. `id_main` int(5) NOT NULL,
  421. `id_menu` int(5) DEFAULT NULL,
  422. PRIMARY KEY (`id_menu_role_access`)
  423. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;
  425. --
  426. -- Dumping data for table `menu_admin_role_access`
  427. --
  429. INSERT INTO `menu_admin_role_access` (`id_menu_role_access`, `id_main`, `id_menu`) VALUES
  430. (55, 0, 8),
  431. (54, 0, 19),
  432. (53, 0, 3),
  433. (52, 0, 20),
  434. (51, 0, 5),
  435. (50, 0, 4),
  436. (49, 0, 2),
  437. (34, 1, 3),
  438. (33, 1, 5),
  439. (30, 6, 5),
  440. (22, 2, 3),
  441. (23, 2, 5),
  442. (32, 1, 2),
  443. (31, 6, 4),
  444. (35, 1, 19),
  445. (56, 0, 21);
  447. -- --------------------------------------------------------
  449. --
  450. -- Table structure for table `modul`
  451. --
  453. CREATE TABLE IF NOT EXISTS `modul` (
  454. `id_modul` int(5) NOT NULL AUTO_INCREMENT,
  455. `nama_modul` varchar(50) COLLATE latin1_general_ci NOT NULL,
  456. `link` varchar(100) COLLATE latin1_general_ci NOT NULL,
  457. `static_content` text COLLATE latin1_general_ci NOT NULL,
  458. `gambar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  459. `publish` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  460. `status` enum('user','admin') COLLATE latin1_general_ci NOT NULL,
  461. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  462. `urutan` int(5) NOT NULL,
  463. `link_seo` varchar(50) COLLATE latin1_general_ci NOT NULL,
  464. PRIMARY KEY (`id_modul`)
  465. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=62 ;
  467. --
  468. -- Dumping data for table `modul`
  469. --
  471. INSERT INTO `modul` (`id_modul`, `nama_modul`, `link`, `static_content`, `gambar`, `publish`, `status`, `aktif`, `urutan`, `link_seo`) VALUES
  472. (2, 'Manajemen User', '?module=user', '', '', 'N', 'user', 'Y', 1, ''),
  473. (18, 'Berita', '?module=berita', '', '', 'Y', 'user', 'Y', 6, 'semua-berita.html'),
  474. (19, 'Banner', '?module=banner', '', '', 'Y', 'admin', 'Y', 9, ''),
  475. (37, 'Profil', '?module=profil', '<b>Bukulokomedia.com</b> 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.<br><br>Produk unggulan dari penerbit Lokomedia adalah buku-buku serta aksesoris bertema PHP (<span style="font-weight: bold; font-style: italic;">PHP: Hypertext Preprocessor</span>) yang merupakan pemrograman Internet paling handal saat ini.\r\n', 'gedungku.jpg', 'N', 'admin', 'N', 3, 'profil-kami.html'),
  476. (10, 'Manajemen Modul', '?module=modul', '', '', 'N', 'admin', 'Y', 2, ''),
  477. (31, 'Kategori', '?module=kategori', '', '', 'Y', 'admin', 'Y', 5, ''),
  478. (33, 'Poling', '?module=poling', '', '', 'Y', 'admin', 'Y', 10, ''),
  479. (34, 'Tag (Label)', '?module=tag', '', '', 'N', 'admin', 'Y', 7, ''),
  480. (35, 'Komentar', '?module=komentar', '', '', 'Y', 'admin', 'Y', 8, ''),
  481. (36, 'Download', '?module=download', '', '', 'Y', 'admin', 'Y', 11, 'semua-download.html'),
  482. (40, 'Hubungi Kami', '?module=hubungi', '', '', 'Y', 'admin', 'Y', 12, 'hubungi-kami.html'),
  483. (41, 'Agenda', ' ?module=agenda', '', '', 'Y', 'user', 'Y', 31, 'semua-agenda.html'),
  484. (42, 'Shoutbox', '?module=shoutbox', '', '', 'Y', 'admin', 'Y', 13, ''),
  485. (43, 'Album', '?module=album', '', '', 'N', 'admin', 'Y', 14, ''),
  486. (44, 'Galeri Foto', '?module=galerifoto', '', '', 'Y', 'admin', 'Y', 15, ''),
  487. (45, 'Templates', '?module=templates', '', '', 'N', 'admin', 'Y', 16, ''),
  488. (46, 'Kata Jelek', '?module=katajelek', '', '', 'N', 'admin', 'Y', 17, ''),
  489. (47, 'RSS', '-', '', '', 'Y', 'admin', 'N', 18, ''),
  490. (48, 'YM', '-', '', '', 'Y', 'admin', 'N', 19, ''),
  491. (49, 'Indeks Berita', '-', '', '', 'Y', 'admin', 'N', 20, ''),
  492. (50, 'Kalender', '-', '', '', 'Y', 'admin', 'N', 21, ''),
  493. (51, 'Statistik User', '-', '', '', 'Y', 'admin', 'N', 22, ''),
  494. (52, 'Pencarian', '-', '', '', 'Y', 'admin', 'N', 23, ''),
  495. (53, 'Berita Teratas', '-', '', '', 'Y', 'admin', 'N', 24, ''),
  496. (54, 'Arsip Berita', '-', '', '', 'Y', 'admin', 'N', 25, ''),
  497. (55, 'Berita Sebelumnya', '-', '', '', 'Y', 'admin', 'N', 26, ''),
  498. (60, 'Sekilas Info', '?module=sekilasinfo', '', '', 'Y', 'admin', 'Y', 13, ''),
  499. (57, 'Menu Utama', '?module=menuutama', '', '', 'Y', 'admin', 'Y', 28, ''),
  500. (58, 'Sub Menu', '?module=submenu', '', '', 'Y', 'admin', 'Y', 29, ''),
  501. (59, 'Halaman Statis', '?module=halamanstatis', '', '', 'Y', 'admin', 'Y', 30, ''),
  502. (61, 'Identitas Website', '?module=identitas', '', '', 'N', 'admin', 'Y', 4, '');
  504. -- --------------------------------------------------------
  506. --
  507. -- Table structure for table `poling`
  508. --
  510. CREATE TABLE IF NOT EXISTS `poling` (
  511. `id_poling` int(5) NOT NULL AUTO_INCREMENT,
  512. `pilihan` varchar(100) COLLATE latin1_general_ci NOT NULL,
  513. `status` varchar(20) COLLATE latin1_general_ci NOT NULL,
  514. `rating` int(5) NOT NULL DEFAULT '0',
  515. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL,
  516. PRIMARY KEY (`id_poling`)
  517. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
  519. --
  520. -- Dumping data for table `poling`
  521. --
  523. INSERT INTO `poling` (`id_poling`, `pilihan`, `status`, `rating`, `aktif`) VALUES
  524. (1, 'Internet Explorer', 'Jawaban', 23, 'Y'),
  525. (2, 'Mozilla Firefox', 'Jawaban', 81, 'Y'),
  526. (3, 'Google Chrome', 'Jawaban', 21, 'Y'),
  527. (4, 'Opera', 'Jawaban', 22, 'Y'),
  528. (8, 'Apa Browser Favorit Anda?', 'Pertanyaan', 0, 'Y');
  530. -- --------------------------------------------------------
  532. --
  533. -- Table structure for table `sekilasinfo`
  534. --
  536. CREATE TABLE IF NOT EXISTS `sekilasinfo` (
  537. `id_sekilas` int(5) NOT NULL AUTO_INCREMENT,
  538. `info` varchar(100) COLLATE latin1_general_ci NOT NULL,
  539. `tgl_posting` date NOT NULL,
  540. `gambar` varchar(100) COLLATE latin1_general_ci NOT NULL,
  541. PRIMARY KEY (`id_sekilas`)
  542. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
  544. --
  545. -- Dumping data for table `sekilasinfo`
  546. --
  548. INSERT INTO `sekilasinfo` (`id_sekilas`, `info`, `tgl_posting`, `gambar`) VALUES
  549. (1, 'Jangan lupa kopdar nasional mig33 di senayan', '2014-01-29', '');
  551. -- --------------------------------------------------------
  553. --
  554. -- Table structure for table `shoutbox`
  555. --
  557. CREATE TABLE IF NOT EXISTS `shoutbox` (
  558. `id_shoutbox` int(5) NOT NULL AUTO_INCREMENT,
  559. `nama` varchar(100) COLLATE latin1_general_ci NOT NULL,
  560. `website` varchar(50) COLLATE latin1_general_ci NOT NULL,
  561. `pesan` text COLLATE latin1_general_ci NOT NULL,
  562. `tanggal` date NOT NULL,
  563. `jam` time NOT NULL,
  564. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
  565. PRIMARY KEY (`id_shoutbox`)
  566. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;
  568. --
  569. -- Dumping data for table `shoutbox`
  570. --
  572. INSERT INTO `shoutbox` (`id_shoutbox`, `nama`, `website`, `pesan`, `tanggal`, `jam`, `aktif`) VALUES
  573. (1, 'lukman', 'lukman.com', 'tes :-) aja ;-D ha ha ha <:D>', '2009-11-02', '00:00:00', 'Y'),
  574. (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'),
  575. (3, 'daryono', 'bukulokomedia.com', 'ku tes lagi<br>\r\ntes :-) aja ;-D ha ha ha <:D><br>\r\nkeren euy<br>\r\n:-(', '2009-11-02', '13:55:00', 'Y'),
  576. (5, 'iin', 'uin-suka.ac.id', 'tes aja euy ;-D boi', '2009-11-03', '11:36:06', 'Y');
  578. -- --------------------------------------------------------
  580. --
  581. -- Table structure for table `statistik`
  582. --
  584. CREATE TABLE IF NOT EXISTS `statistik` (
  585. `ip` varchar(20) NOT NULL DEFAULT '',
  586. `tanggal` date NOT NULL,
  587. `hits` int(10) NOT NULL DEFAULT '1',
  588. `online` varchar(255) NOT NULL
  589. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  591. --
  592. -- Dumping data for table `statistik`
  593. --
  595. INSERT INTO `statistik` (`ip`, `tanggal`, `hits`, `online`) VALUES
  596. ('127.0.0.2', '2009-09-11', 1, '1252681630'),
  597. ('127.0.0.1', '2009-09-11', 17, '1252734209'),
  598. ('127.0.0.3', '2009-09-12', 8, '1252817594'),
  599. ('127.0.0.1', '2009-10-24', 8, '1256381921'),
  600. ('127.0.0.1', '2009-10-26', 108, '1256620074'),
  601. ('127.0.0.1', '2009-10-27', 52, '1256686769'),
  602. ('127.0.0.1', '2009-10-28', 124, '1256792223'),
  603. ('127.0.0.1', '2009-10-29', 9, '1256828032'),
  604. ('127.0.0.1', '2009-10-31', 3, '1257047101'),
  605. ('127.0.0.1', '2009-11-01', 85, '1257113554'),
  606. ('127.0.0.1', '2009-11-02', 11, '1257207543'),
  607. ('127.0.0.1', '2009-11-03', 165, '1257292312'),
  608. ('127.0.0.1', '2009-11-04', 59, '1257403499'),
  609. ('127.0.0.1', '2009-11-05', 10, '1257433172'),
  610. ('127.0.0.1', '2009-11-11', 13, '1258006911'),
  611. ('127.0.0.1', '2009-11-12', 10, '1258048069'),
  612. ('127.0.0.1', '2009-11-14', 14, '1258222519'),
  613. ('127.0.0.1', '2009-11-17', 2, '1258473856'),
  614. ('127.0.0.1', '2009-11-19', 16, '1258635469'),
  615. ('127.0.0.1', '2009-11-21', 4, '1258863505'),
  616. ('127.0.0.1', '2009-11-25', 3, '1259216216'),
  617. ('127.0.0.1', '2009-11-26', 1, '1259222467'),
  618. ('127.0.0.1', '2009-11-30', 11, '1259651841'),
  619. ('127.0.0.1', '2009-12-02', 9, '1259746407'),
  620. ('127.0.0.1', '2009-12-03', 17, '1259906128'),
  621. ('127.0.0.1', '2009-12-10', 69, '1260423794'),
  622. ('127.0.0.1', '2009-12-12', 26, '1260560082'),
  623. ('127.0.0.1', '2009-12-11', 5, '1260508621'),
  624. ('127.0.0.1', '2009-12-13', 8, '1260716786'),
  625. ('127.0.0.1', '2009-12-14', 9, '1260772698'),
  626. ('127.0.0.1', '2009-12-15', 9, '1260837158'),
  627. ('127.0.0.1', '2009-12-16', 7, '1260905627'),
  628. ('127.0.0.1', '2009-12-17', 48, '1261026791'),
  629. ('127.0.0.1', '2009-12-18', 11, '1261088534'),
  630. ('127.0.0.1', '2009-12-22', 3, '1261477278'),
  631. ('127.0.0.1', '2009-12-25', 2, '1261686043'),
  632. ('127.0.0.1', '2009-12-26', 29, '1261835507'),
  633. ('127.0.0.1', '2009-12-27', 7, '1261920445'),
  634. ('127.0.0.1', '2009-12-28', 3, '1261965611'),
  635. ('127.0.0.1', '2009-12-29', 21, '1262024011'),
  636. ('127.0.0.1', '2009-12-30', 24, '1262146708'),
  637. ('127.0.0.1', '2010-01-01', 12, '1262286131'),
  638. ('127.0.0.1', '2010-01-03', 38, '1262529325'),
  639. ('127.0.0.1', '2010-01-12', 89, '1263264291'),
  640. ('127.0.0.1', '2010-01-14', 54, '1263482540'),
  641. ('127.0.0.1', '2010-01-15', 57, '1263506901'),
  642. ('127.0.0.1', '2010-02-11', 30, '1265831568'),
  643. ('127.0.0.1', '2010-02-13', 2, '1266032303'),
  644. ('127.0.0.1', '2010-02-14', 3, '1266115347'),
  645. ('127.0.0.1', '2010-02-15', 15, '1266195235'),
  646. ('127.0.0.1', '2010-02-18', 1, '1266499945'),
  647. ('127.0.0.1', '2010-02-22', 5, '1266856332'),
  648. ('127.0.0.1', '2010-02-25', 46, '1267103145'),
  649. ('127.0.0.1', '2010-05-12', 10, '1273654648'),
  650. ('127.0.0.1', '2010-05-16', 195, '1274026185'),
  651. ('127.0.0.1', '2010-05-17', 2, '1274029517'),
  652. ('127.0.0.1', '2010-05-19', 1, '1274279374'),
  653. ('127.0.0.1', '2010-05-27', 16, '1274967085'),
  654. ('127.0.0.1', '2010-05-30', 4, '1275192045'),
  655. ('127.0.0.1', '2010-05-31', 13, '1275271939'),
  656. ('127.0.0.1', '2010-06-05', 1, '1275676869'),
  657. ('127.0.0.1', '2010-06-06', 2, '1275842170'),
  658. ('127.0.0.1', '2010-06-15', 3, '1276572924'),
  659. ('127.0.0.1', '2010-06-22', 206, '1277221605'),
  660. ('127.0.0.1', '2010-08-02', 17, '1280754660'),
  661. ('127.0.0.1', '2010-08-20', 7, '1282285305'),
  662. ('127.0.0.1', '2010-08-30', 21, '1283185430'),
  663. ('127.0.0.1', '2010-08-31', 53, '1283207455'),
  664. ('127.0.0.1', '2010-09-02', 133, '1283402651'),
  665. ('127.0.0.1', '2010-09-05', 35, '1283702206'),
  666. ('127.0.0.1', '2010-09-13', 10, '1284370291'),
  667. ('127.0.0.1', '2010-09-17', 12, '1284662303'),
  668. ('127.0.0.1', '2010-09-22', 2, '1285091212'),
  669. ('127.0.0.1', '2010-09-23', 47, '1285254071'),
  670. ('127.0.0.1', '2010-09-26', 32, '1285512806'),
  671. ('127.0.0.1', '2010-09-27', 48, '1285529871'),
  672. ('127.0.0.1', '2011-01-19', 18, '1295395096'),
  673. ('127.0.0.1', '2011-01-21', 6, '1295580166'),
  674. ('127.0.0.1', '2011-01-22', 3, '1295639704'),
  675. ('127.0.0.1', '2011-01-25', 2, '1295895420'),
  676. ('127.0.0.1', '2011-01-27', 20, '1296145564'),
  677. ('127.0.0.1', '2011-01-28', 5, '1296150116'),
  678. ('127.0.0.1', '2011-02-01', 10, '1296555613'),
  679. ('127.0.0.1', '2011-02-02', 1, '1296657225'),
  680. ('127.0.0.1', '2011-02-05', 3, '1296875908'),
  681. ('127.0.0.1', '2011-02-07', 5, '1297090649'),
  682. ('127.0.0.1', '2011-02-09', 182, '1297254341'),
  683. ('127.0.0.1', '2011-02-10', 268, '1297355704'),
  684. ('127.0.0.1', '2011-02-16', 6, '1297824002'),
  685. ('127.0.0.1', '2011-02-17', 2, '1297945065'),
  686. ('127.0.0.1', '2011-12-28', 12, '1325081007'),
  687. ('127.0.0.1', '2011-12-29', 13, '1325167281'),
  688. ('127.0.0.1', '2011-12-31', 34, '1325296088'),
  689. ('127.0.0.1', '2012-01-02', 1, '1325449458'),
  690. ('127.0.0.1', '2012-01-03', 55, '1325601219'),
  691. ('127.0.0.1', '2012-01-04', 1, '1325630436'),
  692. ('127.0.0.1', '2012-02-08', 86, '1328720292'),
  693. ('127.0.0.1', '2012-02-09', 110, '1328798857'),
  694. ('127.0.0.1', '2012-02-10', 87, '1328871532'),
  695. ('127.0.0.1', '2012-02-11', 16, '1328899301'),
  696. ('127.0.0.1', '2012-03-31', 87, '1333186737'),
  697. ('127.0.0.1', '2012-04-01', 69, '1333248528'),
  698. ('127.0.0.1', '2012-04-02', 9, '1333338582'),
  699. ('127.0.0.1', '2012-04-03', 31, '1333456570'),
  700. ('127.0.0.1', '2012-04-04', 2, '1333498207'),
  701. ('127.0.0.1', '2012-04-05', 5, '1333628029'),
  702. ('127.0.0.1', '2012-04-08', 22, '1333871463'),
  703. ('127.0.0.1', '2012-04-09', 109, '1333972788'),
  704. ('127.0.0.1', '2012-04-10', 70, '1334024998'),
  705. ('127.0.0.1', '2012-05-01', 8, '1335889888'),
  706. ('127.0.0.1', '2012-05-02', 17, '1335935829'),
  707. ('127.0.0.1', '2012-05-27', 6, '1338133681'),
  708. ('127.0.0.1', '2012-05-29', 22, '1338304361'),
  709. ('127.0.0.1', '2012-05-30', 5, '1338389383'),
  710. ('127.0.0.1', '2012-05-31', 5, '1338408772'),
  711. ('127.0.0.1', '2012-06-01', 5, '1338567612'),
  712. ('127.0.0.1', '2012-07-01', 10, '1341152776');
  714. -- --------------------------------------------------------
  716. --
  717. -- Table structure for table `submenu`
  718. --
  720. CREATE TABLE IF NOT EXISTS `submenu` (
  721. `id_sub` int(5) NOT NULL AUTO_INCREMENT,
  722. `nama_sub` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  723. `link_sub` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  724. `id_main` int(5) NOT NULL,
  725. `aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
  726. PRIMARY KEY (`id_sub`)
  727. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
  729. -- --------------------------------------------------------
  731. --
  732. -- Table structure for table `submenu_admin`
  733. --
  735. CREATE TABLE IF NOT EXISTS `submenu_admin` (
  736. `id_sub` int(5) NOT NULL AUTO_INCREMENT,
  737. `nama_sub` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  738. `link_sub` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  739. `icon` varchar(32) DEFAULT NULL,
  740. `description` varchar(300) DEFAULT NULL,
  741. `id_main` int(5) NOT NULL,
  742. `aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
  743. PRIMARY KEY (`id_sub`)
  744. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
  746. --
  747. -- Dumping data for table `submenu_admin`
  748. --
  750. INSERT INTO `submenu_admin` (`id_sub`, `nama_sub`, `link_sub`, `icon`, `description`, `id_main`, `aktif`) VALUES
  751. (17, 'Musik', 'berita/widget/777', 'icon-music', 'Kami membuat lagu, kami mempunyai group band dan kami cukup sering tampil di atas panggung..', 5, 'Y'),
  752. (18, 'Travelling', 'berita/widget/777', ' icon-plane', 'Kami suka berpegian, entah hanya untuk sekedar melepas penat atau merayakan sesuatu di bekasi utara', 5, 'Y'),
  753. (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');
  755. -- --------------------------------------------------------
  757. --
  758. -- Table structure for table `tag`
  759. --
  761. CREATE TABLE IF NOT EXISTS `tag` (
  762. `id_tag` int(5) NOT NULL AUTO_INCREMENT,
  763. `nama_tag` varchar(100) COLLATE latin1_general_ci NOT NULL,
  764. `tag_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  765. `count` int(5) NOT NULL,
  766. PRIMARY KEY (`id_tag`)
  767. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=22 ;
  769. --
  770. -- Dumping data for table `tag`
  771. --
  773. INSERT INTO `tag` (`id_tag`, `nama_tag`, `tag_seo`, `count`) VALUES
  774. (1, 'Palestina', 'palestina', 7),
  775. (2, 'Gaza', 'gaza', 11),
  776. (9, 'Tenis', 'tenis', 5),
  777. (10, 'Sepakbola', 'sepakbola', 7),
  778. (8, 'Laskar Pelangi', 'laskar-pelangi', 2),
  779. (11, 'Amerika', 'amerika', 18),
  780. (12, 'George Bush', 'george-bush', 3),
  781. (13, 'Browser', 'browser', 9),
  782. (14, 'Google', 'google', 3),
  783. (15, 'Israel', 'israel', 5),
  784. (16, 'Komputer', 'komputer', 24),
  785. (17, 'Film', 'film', 9),
  786. (19, 'Mobil', 'mobil', 0),
  787. (21, 'Gayus', 'gayus', 2);
  789. -- --------------------------------------------------------
  791. --
  792. -- Table structure for table `templates`
  793. --
  795. CREATE TABLE IF NOT EXISTS `templates` (
  796. `id_templates` int(5) NOT NULL AUTO_INCREMENT,
  797. `judul` varchar(100) COLLATE latin1_general_ci NOT NULL,
  798. `pembuat` varchar(50) COLLATE latin1_general_ci NOT NULL,
  799. `folder` varchar(50) COLLATE latin1_general_ci NOT NULL,
  800. `aktif` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  801. PRIMARY KEY (`id_templates`)
  802. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
  804. --
  805. -- Dumping data for table `templates`
  806. --
  808. INSERT INTO `templates` (`id_templates`, `judul`, `pembuat`, `folder`, `aktif`) VALUES
  809. (1, 'Standar', 'Lukmanul Hakim', 'templates/standar', 'N'),
  810. (2, 'Building', 'Lukmanul Hakim', 'templates/building', 'N'),
  811. (3, 'eL jQuery', 'Lukmanul Hakim', 'templates/eljquery', 'N'),
  812. (4, 'eL jQuery versi 2', 'Lukmanul Hakim', 'templates/eljquery2', 'N'),
  813. (5, 'eL jQuery ala Yahoo', 'Lukmanul Hakim', 'templates/eljquery-yahoo', 'N'),
  814. (7, 'Sandbox', 'Ahmad Nugraha', 'templates/sandbox', 'Y'),
  815. (8, 'Just Simple Blue', 'Dian Pamungkas', 'templates/blue', 'N');
  817. -- --------------------------------------------------------
  819. --
  820. -- Table structure for table `users`
  821. --
  823. CREATE TABLE IF NOT EXISTS `users` (
  824. `username` varchar(50) COLLATE latin1_general_ci NOT NULL,
  825. `password` varchar(50) COLLATE latin1_general_ci NOT NULL,
  826. `nama_lengkap` varchar(100) COLLATE latin1_general_ci NOT NULL,
  827. `email` varchar(100) COLLATE latin1_general_ci NOT NULL,
  828. `no_telp` varchar(20) COLLATE latin1_general_ci NOT NULL,
  829. `level` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT 'user',
  830. `blokir` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  831. `role_id` int(2) NOT NULL COMMENT '0 = Super Admin\r\n',
  832. `id_session` varchar(100) COLLATE latin1_general_ci NOT NULL,
  833. `facebook` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  834. `twitter` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  835. `linkedin` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  836. `googleplus` varchar(110) COLLATE latin1_general_ci DEFAULT NULL,
  837. `gambar` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  838. `tgl_insert` date NOT NULL,
  839. PRIMARY KEY (`username`)
  840. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  842. --
  843. -- Dumping data for table `users`
  844. --
  846. INSERT INTO `users` (`username`, `password`, `nama_lengkap`, `email`, `no_telp`, `level`, `blokir`, `role_id`, `id_session`, `facebook`, `twitter`, `linkedin`, `googleplus`, `gambar`, `tgl_insert`) VALUES
  847. ('admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'admin@detik.com', '08238923848', 'admin', 'N', 0, '260580d287f6489d86c8f0bcc1680169', NULL, NULL, NULL, NULL, NULL, '0000-00-00'),
  848. ('akisaung', 'a01891e90e4133c30fb2f0467ae756a4', 'aki saung (Pak Kanta)', 'akisaung@gmail.com', '081237364924788', 'user', 'N', 2, '', '', '', '', '', 'WP_20131103_069.jpg', '2014-01-21'),
  849. ('puma', 'd9f32436125b47e03d11fbf1fa62424a', 'Putri Marlina', 'puma@gmail.com', '083875007774', 'admin', 'N', 1, '', NULL, NULL, NULL, NULL, NULL, '0000-00-00'),
  850. ('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'),
  851. ('philtyphils', 'd5cfbc9179a7f4e999a86d20bd0ef465', 'Sulistyo Nur Anggoro', 'philtyphil@ovi.com', '083750007779', 'user', 'N', 2, '', '', '', '', '', 'test1.jpg', '2014-01-21');
  853. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  854. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  855. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
comments powered by Disqus