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,
