Author: jfthomps
Date: Mon Jul  6 19:34:58 2009
New Revision: 791580

URL: http://svn.apache.org/viewvc?rev=791580&view=rev
Log:
VCL-78

added imageid to blockComputers table

Modified:
    incubator/vcl/trunk/mysql/vcl.sql

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=791580&r1=791579&r2=791580&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Mon Jul  6 19:34:58 2009
@@ -69,8 +69,10 @@
 CREATE TABLE IF NOT EXISTS `blockComputers` (
   `blockTimeid` mediumint(8) unsigned NOT NULL default '0',
   `computerid` smallint(5) unsigned NOT NULL default '0',
+  `imageid` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`blockTimeid`,`computerid`),
-  KEY `computerid` (`computerid`)
+  KEY `computerid` (`computerid`),
+  KEY `imageid` (`imageid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------


Reply via email to