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;
-- --------------------------------------------------------
