Xx3mVAiD

1CREATE TABLE IF NOT EXISTS `gnshash` (
2 `hashID` INT(5) unsigned NOT NULL AUTO_INCREMENT,
3 `postID` INT(5) unsigned NOT NULL DEFAULT '0',
4 `hash` VARCHART(40) unsigned NOT NULL DEFAULT '0',
5 `relevance` int(2) unsigned NOT NULL DEFAULT '0',
6PRIMARY KEY (`postID`)
7INDEX hashes (hash)
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9ALTER TABLE `news` ADD `blurb` VARCHART(250) UNSIGNED NOT NULL DEFAULT '0' AFTER `body`; 
10ALTER TABLE `news` ADD `bigimage` VARCHART(500) UNSIGNED NOT NULL DEFAULT '0' AFTER `blurb`;
11ALTER TABLE `news` ADD `smallimage` VARCHART(500) UNSIGNED NOT NULL DEFAULT '0' AFTER `bigimage`;
12ALTER TABLE `news` ADD `geo` ENUM('corecolonies', 'innerexpan', 'midouter', 'corecolonies & innerexpan & midouter', 'corecolonies & innerexpan', 'corecolonies & midouter', 'innerexpan & midouter') UNSIGNED NOT NULL DEFAULT '0' AFTER `smallimage`;