Notices Table Doesn't Exist?

[Chelf12]

Is there an SQL Query or something to restore it? I get this when trying to add a notice.

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM notice ORDER BY displayorder, title;

MySQL Error : Table 'zackwil_bull2.notice' doesn't exist
Error Number : 1146
Request Date : Saturday, May 2nd 2009 @ 12:35:05 PM
Error Date : Saturday, May 2nd 2009 @ 12:35:05 PM
Script : http://******/forum/admincp/notice.php?do=modify
Referrer : http://******/forum/admincp/index.php?do=nav
IP Address : *******
Username : Darkstar
Classname : vB_Database
MySQL Version : 4.1.22-community-nt-log

[Steve Machol]

Here is the query to create that table:

CREATE TABLE notice (
noticeid INT UNSIGNED NOT NULL auto_increment,
title VARCHAR(250) NOT NULL DEFAULT '',
displayorder INT UNSIGNED NOT NULL DEFAULT '0',
persistent SMALLINT UNSIGNED NOT NULL default '0',
active SMALLINT UNSIGNED NOT NULL DEFAULT '0',
dismissible SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (noticeid),
KEY active (active)
);

[Chelf12]

Thanks Steve. A lifesaver as always.

Should I execute this in phpMyAdmin, or can I do it from the ACP?

I'm a little slow today. Just got over being sick with the flu. ._.

[Nick]

Thanks Steve. A lifesaver as always.

Should I execute this in phpMyAdmin, or can I do it from the ACP?

I'm a little slow today. Just got over being sick with the flu. ._.

I don't think it would matter. Personally, I'd prefer to do it via phpMyAdmin. But that's just me.