PDA

View Full Version : How do I rebuild the [forum] post table?


stwilson
Sat 23rd Jun '07, 12:52am
I was multitasking and erroneously delted my post table when I was trying to empty it. I have a custom template applied to my forum so I do not want to reinstall and blow out all my settings.

Can someone point me in the right direction to just rebuild the post table? Is there a script I can run to just create this table? I appreciate any directiom you can offer.

Kerry-Anne
Sat 23rd Jun '07, 9:09am
CREATE TABLE `PREFIX_post` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`parentid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext,
`allowsmilie` smallint(6) NOT NULL default '0',
`showsignature` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`infraction` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
FULLTEXT KEY `title` (`title`,`pagetext`)
) ENGINE=MyISAMReplace PREFIX_ with your table prefix if you use one.