+--
+-- TABLE gserver
+--
+CREATE TABLE IF NOT EXISTS `gserver` (
+ `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
+ `url` varchar(255) NOT NULL DEFAULT '',
+ `nurl` varchar(255) NOT NULL DEFAULT '',
+ `version` varchar(255) NOT NULL DEFAULT '',
+ `site_name` varchar(255) NOT NULL DEFAULT '',
+ `info` text NOT NULL,
+ `register_policy` tinyint(1) NOT NULL DEFAULT 0,
+ `poco` varchar(255) NOT NULL DEFAULT '',
+ `noscrape` varchar(255) NOT NULL DEFAULT '',
+ `network` varchar(32) NOT NULL DEFAULT '',
+ `platform` varchar(255) NOT NULL DEFAULT '',
+ `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `last_poco_query` datetime DEFAULT '0000-00-00 00:00:00',
+ `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
+ `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
+ INDEX `nurl` (`nurl`)
+) DEFAULT CHARSET=utf8;
+