CREATE TABLE `board` ( `idx` int(11) NOT NULL auto_increment, `postedtime` datetime NOT NULL default '0000-00-00 00:00:00', `lasttime` datetime NOT NULL default '0000-00-00 00:00:00', `author` int(11) NOT NULL default '0', `replyto` int(11) NOT NULL default '0', `subject` varchar(255) NOT NULL default '', `message` text NOT NULL, `ip` varchar(15) NOT NULL default '', KEY `idx` (`idx`) ) TYPE=MyISAM ;
CREATE TABLE `users` ( `idx` int(11) NOT NULL auto_increment, `joined` datetime NOT NULL default '0000-00-00 00:00:00', `uname` varchar(31) NOT NULL default '', `pass` varchar(31) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `prevlogin` datetime NOT NULL default '0000-00-00 00:00:00', `logintoken` varchar(32) NOT NULL default '', KEY `idx` (`idx`) ) TYPE=MyISAM ;
that is, if you want to use the HCS Forum in its current state.
It's up by unknownfile at 11:46 AM EDT on August 18, 2005
HCSforums are up and running at http://unknown.halleyscometsoftware.com/forum.php
YAY HCS ;D
here's a thought... by hcs at 8:48 PM EDT on August 22, 2005
Maybe the last page function should show the last 20 posts, not merely literally the last page when paging through normally, which may only have one post on it.