You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2009/07/06 21:34:59 UTC
svn commit: r791580 - /incubator/vcl/trunk/mysql/vcl.sql
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;
-- --------------------------------------------------------