bringing back my comments-table

[sventillack]

i dont know why but i just deleted the comments-table while writing down a wrong sql-statement into the entry-field of my phpmysql. awesome.

when i try to re-build a table by copy and paste the
"CREATE TABLE pixelpost_comment" from the create_tables.php (from the 1.7.1 install)

http://img526.imageshack.us/img526/4554/bild4od1.th.png (http://img526.imageshack.us/my.php?image=bild4od1.png)

it gives me "Unknown column 'publish' in 'where clause'" when i try to run my pixelpost at www.sventillack.de

i tried to update to 1.7.1 just some days ago and it seems that it worked (maybe that information helps you). and no, i do not have a backup.

,(

[Dkozikowski]

CREATE TABLE `pixelpost_comments` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(20) NOT NULL default '',
`message` text NOT NULL,
`name` varchar(30) default NULL,
`url` varchar(70) default NULL,
`email` varchar(100) default NULL,
`publish` varchar(3) NOT NULL default 'yes',
`spaminess` float default NULL,
`signature` varchar(55) default NULL,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
)

[sventillack]

that worked! great. many thanks!