uFQWPTcf

1--
2-- Create database `berita`
3--
4 
5CREATE DATABASE `berita`;
6 
7use `berita`;
8 
9--
10-- Table structure for table `news`
11--
12 
13CREATE TABLE IF NOT EXISTS `berita` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `title` varchar(128) NOT NULL,
16  `slug` varchar(128) NOT NULL,
17  `text` text NOT NULL,
18  PRIMARY KEY (`id`),
19  KEY `slug` (`slug`)
20) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
21 
22--
23-- Dumping data for table `berita`
24--
25 
26INSERT INTO `berita` (`id`, `title`, `slug`, `text`) VALUES
27(1, 'Test', 'test', 'Hello World !!'),
28(2, 'What is Lorem Ipsum?', 'what-is-lorem-ipsum', 'Lorem Ipsum is simply dummy text.');