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.php?s=&action=newreply&threadid=2255

[g-force2k2]

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 (http://www.vbulletin.com/members/vbulletin.org.php) 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.