kY3V1ecx

1--
2-- menghapus tabel backup_log dan content
3--
4DROP TABLE `backup_log`, `content`;
5--
6-- membuat ulang tabel backup_log
7--
8CREATE TABLE IF NOT EXISTS `backup_log` (
9  `backup_log_id` int(11) NOT NULL auto_increment,
10  `user_id` int(11) NOT NULL default '0',
11  `backup_time` datetime NOT NULL default '0000-00-00 00:00:00',
12  `backup_file` varchar(100) collate utf8_unicode_ci default NULL,
13  PRIMARY KEY  (`backup_log_id`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
15--
16-- membuat ulang tabel content
17--
18CREATE TABLE IF NOT EXISTS `content` (
19  `content_id` int(11) NOT NULL auto_increment,
20  `content_title` varchar(255) collate utf8_unicode_ci NOT NULL,
21  `content_desc` text collate utf8_unicode_ci NOT NULL,
22  `content_path` varchar(20) collate utf8_unicode_ci NOT NULL,
23  `is_news` smallint(1) NULL DEFAULT NULL,
24  `input_date` datetime NOT NULL,
25  `last_update` datetime NOT NULL,
26  `content_ownpage` enum('1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
27  PRIMARY KEY  (`content_id`),
28  UNIQUE KEY `content_path` (`content_path`),
29  FULLTEXT KEY `content_title` (`content_title`),
30  FULLTEXT KEY `content_desc` (`content_desc`)
31) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
32--
33--