help: need to fix word.MYD

[sung]

in a very freak of nature-ish way, my my "word" table got deleted and i need to restore it... is it possible for somebody to give me the query information for the table so i can add it back thru mySQLadmin?

thank you.

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('test')
mysql error: Unknown column 'wordid' in 'field list'

mysql error number: 1054

Date: Friday 05th of July 2002 07:44:57 PM
Script: http://www.drsnyltd.com/sung/sung/newreply.php
Referer: http://drsnyltd.com/sung/newreply.ph...&threadid=2255

[g-force2k2]

PHP Code:

CREATE TABLE word (
   wordid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   title char(50) NOT NULL,
   PRIMARY KEY (wordid)
)

ALTER TABLE word ADD UNIQUE (title) 


You have to run these to quiries hope that helps

g-force2k2

[Steve Machol]

sung, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.