ENxqxnUs

1CREATE TABLE IF NOT EXISTS `w_comment` (
2  `comment_id` mediumint(8) unsigned NOT NULL auto_increment,
3  `comment_name` varchar(50) NOT NULL default '',
4  `comment_content` varchar(255) NOT NULL default '',
5  `comment_reply` varchar(255) NOT NULL default '',
6  `comment_time` int(10) unsigned NOT NULL default '0',
7  `comment_ip` varchar(15) NOT NULL default '',
8  `comment_agent` varchar(255) NOT NULL default '',
9  `log_id` mediumint(8) unsigned NOT NULL default '0',
10  PRIMARY KEY  (`comment_id`)
11) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
12
13CREATE TABLE IF NOT EXISTS `w_log` (
14  `log_id` mediumint(8) unsigned NOT NULL auto_increment,
15  `log_content` text NOT NULL,
16  `log_ip` varchar(15) NOT NULL default '',
17  `log_agent` varchar(255) NOT NULL default '',
18  `log_comment_count` int(4) unsigned NOT NULL default '0',
19  `log_time` int(10) unsigned NOT NULL default '0',
20  `log_state` tinyint(1) unsigned NOT NULL default '0',
21  PRIMARY KEY  (`log_id`)
22) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
23
24
25CREATE TABLE IF NOT EXISTS `w_online` (
26  `onlinetime` int(10) unsigned NOT NULL default '0',
27  `onlineip` varchar(20) NOT NULL default '',
28  `onlineagent` varchar(50) NOT NULL default '',
29  KEY `onlinetime` (`onlinetime`)
30) ENGINE=MyISAM DEFAULT CHARSET=utf8;