public static function vInit()
{
DirectDB::mQuery("\n\t\t\t\tCREATE TABLE IF NOT EXISTS `" . self::$sTable . "` (\n\t\t\t\t\taddress_hash varchar(32) NOT NULL,\n\t\t\t\t\taddress_stub varchar(64) NOT NULL,\n\t\t\t\t\tfetched DATETIME,\n\t\t\t\t\tx varchar(32),\n\t\t\t\t\ty varchar(32),\n\t\t\t\t\tresponse mediumtext,\n\t\t\t\t\tPRIMARY KEY (`address_hash`)\n\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n\t\t\t");
}
public static function vInit()
{
DirectDB::mQuery("\n\t\t\t\tCREATE TABLE IF NOT EXISTS ads_htmls (\n\t\t\t\t\tid int(9) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\tfetched datetime,\n\t\t\t\t\tparsed tinyint(1),\n\t\t\t\t\tlist varchar(32),\n\t\t\t\t\tdomain_hash varchar(32),\n\t\t\t\t\turl_hash varchar(32),\n\t\t\t\t\thtml_hash varchar(32),\n\t\t\t\t\thtml longtext,\n\t\t\t\t\turl text,\n\t\t\t\t\tINDEX (url_hash),\n\t\t\t\t\tPRIMARY KEY (id)\n\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n\t\t\t");
DirectDB::mQuery("\n\t\t\t\tCREATE TABLE IF NOT EXISTS ads (\n\t\t\t\t\tid int(9) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\thtml_id int(9),\n\t\t\t\t\tcreated datetime,\n\t\t\t\t\tchanged datetime,\n\t\t\t\t\tjson_data longtext,\n\t\t\t\t\tPRIMARY KEY (id)\n\t\t\t\t) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n\t\t\t");
}
