You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by fa...@apache.org on 2009/06/15 22:26:37 UTC
svn commit: r784964 - /incubator/vcl/trunk/mysql/vcl.sql
Author: fapeeler
Date: Mon Jun 15 20:26:37 2009
New Revision: 784964
URL: http://svn.apache.org/viewvc?rev=784964&view=rev
Log:
VCL-3
removed unused database keys
request.imageid
reservation.start
reservation.end
reservation.daterequested
reservation.datemodified
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=784964&r1=784963&r2=784964&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Mon Jun 15 20:26:37 2009
@@ -655,7 +655,6 @@
CREATE TABLE IF NOT EXISTS `request` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`stateid` tinyint(3) unsigned NOT NULL default '0',
- `imageid` smallint(5) unsigned NOT NULL default '0',
`userid` mediumint(8) unsigned NOT NULL default '0',
`reservationid` mediumint(8) unsigned NOT NULL default '0',
`laststateid` tinyint(3) unsigned NOT NULL default '0',
@@ -689,10 +688,6 @@
`imageid` smallint(5) unsigned NOT NULL default '0',
`imagerevisionid` mediumint(8) unsigned NOT NULL default '0',
`managementnodeid` smallint(5) unsigned NOT NULL default '1',
- `start` datetime NOT NULL default '0000-00-00 00:00:00',
- `end` datetime NOT NULL default '0000-00-00 00:00:00',
- `daterequested` datetime NOT NULL default '0000-00-00 00:00:00',
- `datemodified` datetime default NULL,
`remoteIP` varchar(15) default NULL,
`lastcheck` datetime default '0000-00-00 00:00:00',
`pw` varchar(10) default NULL,