Author: jfthomps
Date: Wed Nov 30 17:19:20 2011
New Revision: 1208529

URL: http://svn.apache.org/viewvc?rev=1208529&view=rev
Log:
VCL-311
add more fields to edit computer page

changed computer.location from varchar(10) to varchar(255)

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=1208529&r1=1208528&r2=1208529&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Wed Nov 30 17:19:20 2011
@@ -256,6 +256,7 @@ EXECUTE nextimageid_noimage;
 
 -- change RAM to mediumint
 ALTER TABLE `computer` CHANGE `RAM` `RAM` MEDIUMINT UNSIGNED NOT NULL DEFAULT 
'0';
+ALTER TABLE `computer` CHANGE `location` `location` VARCHAR(255) NULL DEFAULT 
NULL;
 
 -- --------------------------------------------------------
 

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1208529&r1=1208528&r2=1208529&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Wed Nov 30 17:19:20 2011
@@ -212,7 +212,7 @@ CREATE TABLE IF NOT EXISTS `computer` (
   `deleted` tinyint(1) unsigned NOT NULL default '0',
   `notes` text,
   `lastcheck` datetime default NULL,
-  `location` varchar(10) default NULL,
+  `location` varchar(255) default NULL,
   `dsa` mediumtext,
   `dsapub` mediumtext,
   `rsa` mediumtext,


Reply via email to