Forum Understanding Schema....help?
 

OK...I've got a few MISSING items in my database. Caused by a hard drive crash and a backup that is not as good as I thought it was.

I need to do some fixing......

Take the "contenttype" as an example. When I look down my list of tables in phpmyadmin it is not there. But when I look on my server it's there.

So...inside of schema I see this:

Quote:
$schema['CREATE']['query']['contenttype'] = "
CREATE TABLE " . TABLE_PREFIX . "contenttype (
contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
class VARBINARY(50) NOT NULL,
packageid INT UNSIGNED NOT NULL,
canplace ENUM('0','1') NOT NULL DEFAULT '0',
cansearch ENUM('0','1') NOT NULL DEFAULT '0',
cantag ENUM('0','1') DEFAULT '0',
canattach ENUM('0','1') DEFAULT '0',
isaggregator ENUM('0', '1') NOT NULL DEFAULT '0',
PRIMARY KEY (contenttypeid),
UNIQUE KEY packageclass (packageid, class)
) ENGINE = $hightrafficengine
";
$schema['CREATE']['explain']['contenttype'] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "contenttype");

How do I take that info...and convert it into a QUERY that I can run in PHPMYADMIN and re-make this table?

I realize that this is totally an easy thing for some.....but for me...I'm learning...and I gotta ask to be able to learn....so I thank you in advance for your help.

Yours,

Kirk