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/30 18:19:20 UTC
svn commit: r1208529 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
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,