gistfile1.txt

CREATE TABLE `servers` (
  `id` int(11) NOT NULL auto_increment,
  `subdomain` varchar(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `cpu` varchar(255) NOT NULL,
  `workdir` varchar(100) NOT NULL,
  `mode` varchar(3) NOT NULL,
  `monitoring` int(1) default '0',
  `status_webserver` int(1) default '0',
  `status_ping` int(1) default '0',
  `status_conversions` int(4) default '0',
  `status_downloads` int(4) default '0',
  `status_socket` int(1) default '0',
  `hostname` varchar(100) default '',
  `contact_id` int(3) default '0',
  `api` int(1) default '0',
  `yt_cookies` varchar(1000) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1