เรื่่องเกี่ยวกับการทำกระทู้ การอับเดทกระทู้ การกำหนดสถานะกระทู้

CREATE TABLE `user` (
  `user_id` int(3) unsigned zerofill NOT NULL auto_increment,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `department` varchar(20) NOT NULL,
  `phone` text NOT NULL,
  `status` enum('ADMIN','SUPERUSER','USER') NOT NULL default 'USER',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

CREATE TABLE `reply` (
  `reply_id` int(10) unsigned NOT NULL auto_increment,
  `topic_id` int(10) unsigned default NULL,
  `message` text,
  `username` varchar(100) default NULL,
  `date_reply` datetime default NULL,
  `bgcolor` varchar(30) default NULL,
  `ip` varchar(15) default NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY  (`reply_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

CREATE TABLE `topic` (
  `topic_id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(200) default NULL,
  `details` text,
  `username` varchar(100) default NULL,
  `date_post` datetime default NULL,
  `num_reply` smallint(5) unsigned default NULL,
  `ip` varchar(15) default NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY  (`topic_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;