vcl-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jftho...@apache.org
Subject svn commit: r1197268 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
Date Thu, 03 Nov 2011 18:49:51 GMT
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',



Mime
View raw message