 --
 
 CREATE TABLE IF NOT EXISTS `project` (
-  `id` int(11) NOT NULL auto_increment,
-  `name` varchar(255) collate utf8_bin NOT NULL,
-  `url` varchar(255) collate utf8_bin NOT NULL,
-  `signature` varchar(1000) collate utf8_bin NOT NULL,
-  `authenticator` varchar(255) collate utf8_bin NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) COLLATE utf8_bin NOT NULL,
+  `url` varchar(255) COLLATE utf8_bin NOT NULL,
+  `signature` varchar(1000) COLLATE utf8_bin NOT NULL,
+  `authenticator` varchar(255) COLLATE utf8_bin NOT NULL,
   `share` tinyint(4) NOT NULL,
-  `detach` tinyint(1) NOT NULL default '0',
-  `update` tinyint(1) NOT NULL default '0',
-  `votes` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`id`)
+  `detach` tinyint(1) NOT NULL DEFAULT '0',
+  `update` tinyint(1) NOT NULL DEFAULT '0',
+  `dont_request_more_work` tinyint(1) NOT NULL DEFAULT '0',
+  `detach_when_done` int(11) NOT NULL DEFAULT '0',
+  `suspend` int(11) NOT NULL DEFAULT '0',
+  `no_cpu` tinyint(1) NOT NULL DEFAULT '0',
+  `no_cuda` tinyint(1) NOT NULL DEFAULT '0',
+  `no_ati` tinyint(1) NOT NULL DEFAULT '0',
+  `votes` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
-
---
--- Dumping data for table `project`
---
-
 
 -- --------------------------------------------------------
 

--

CREATE TABLE IF NOT EXISTS `host` (
  `id` int(11) NOT NULL auto_increment,
  `poolid` int(11) default NULL,
  `username` varchar(255) collate utf8_bin NOT NULL,
  `supplier` varchar(255) collate utf8_bin NOT NULL,
  `CPID` varchar(255) collate utf8_bin default NULL,
  `host_cpid` varchar(255) collate utf8_bin NOT NULL,
  `venue` varchar(254) collate utf8_bin default NULL,
  `p_ncpus` int(11) NOT NULL,
  `p_vendor` varchar(255) collate utf8_bin NOT NULL,
  `p_model` varchar(255) collate utf8_bin NOT NULL,
  `p_fpops` float NOT NULL,
  `p_iops` float NOT NULL,
  `os_name` varchar(255) collate utf8_bin NOT NULL,
  `os_version` varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `poolid` (`poolid`),
  KEY `CPID` (`CPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

--
-- Dumping data for table `host`
--


-- --------------------------------------------------------


--

CREATE TABLE IF NOT EXISTS `stats_host` (
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id` int(11) NOT NULL,
  `host_cpid` varchar(255) COLLATE utf8_bin NOT NULL,
  `supplier` varchar(255) COLLATE utf8_bin NOT NULL,
  `project` varchar(255) COLLATE utf8_bin NOT NULL,
  `total_credit` float NOT NULL,
  `expavg_credit` float NOT NULL,
  `expavg_time` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

