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 2011/11/03 19:49:51 UTC
svn commit: r1197268 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
Author: jfthomps
Date: Thu Nov 3 18:49:50 2011
New Revision: 1197268
URL: http://svn.apache.org/viewvc?rev=1197268&view=rev
Log:
changed computer.RAM and image.minram from smallint to mediumint
Modified:
incubator/vcl/trunk/mysql/update-vcl.sql
incubator/vcl/trunk/mysql/vcl.sql
Modified: incubator/vcl/trunk/mysql/update-vcl.sql
URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-vcl.sql?rev=1197268&r1=1197267&r2=1197268&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Thu Nov 3 18:49:50 2011
@@ -241,6 +241,9 @@ SET @nextimageid_noimage = CONCAT('ALTER
PREPARE nextimageid_noimage FROM @nextimageid_noimage;
EXECUTE nextimageid_noimage;
+-- change RAM to mediumint
+ALTER TABLE `computer` CHANGE `RAM` `RAM` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0';
+
-- --------------------------------------------------------
--
@@ -281,6 +284,15 @@ CREATE TABLE IF NOT EXISTS `connectmetho
-- --------------------------------------------------------
--
+-- Table structure for table `image`
+--
+
+-- change minram to mediumint
+ALTER TABLE `image` CHANGE `minram` `minram` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0';
+
+-- --------------------------------------------------------
+
+--
-- Table structure for table `imagerevision`
--
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1197268&r1=1197267&r2=1197268&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu Nov 3 18:49:50 2011
@@ -197,7 +197,7 @@ CREATE TABLE IF NOT EXISTS `computer` (
`currentimageid` smallint(5) unsigned NOT NULL default '4',
`nextimageid` smallint(5) unsigned NOT NULL default '4',
`imagerevisionid` mediumint(8) unsigned NOT NULL default '4',
- `RAM` smallint(5) unsigned NOT NULL default '0',
+ `RAM` mediumint(8) unsigned NOT NULL default '0',
`procnumber` tinyint(5) unsigned NOT NULL default '1',
`procspeed` smallint(5) unsigned NOT NULL default '0',
`network` smallint(5) unsigned NOT NULL default '100',
@@ -374,7 +374,7 @@ CREATE TABLE IF NOT EXISTS `image` (
`platformid` tinyint(3) unsigned NOT NULL default '0',
`OSid` tinyint(3) unsigned NOT NULL default '0',
`imagemetaid` smallint(5) unsigned default NULL,
- `minram` smallint(5) unsigned NOT NULL default '0',
+ `minram` mediumint(8) unsigned NOT NULL default '0',
`minprocnumber` tinyint(3) unsigned NOT NULL default '0',
`minprocspeed` smallint(5) unsigned NOT NULL default '0',
`minnetwork` smallint(3) unsigned NOT NULL default '0',