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/10/20 16:58:40 UTC
svn commit: r1186841 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
Author: jfthomps
Date: Thu Oct 20 14:58:40 2011
New Revision: 1186841
URL: http://svn.apache.org/viewvc?rev=1186841&view=rev
Log:
No JIRA
added autocapture field to imagerevision table
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=1186841&r1=1186840&r2=1186841&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Thu Oct 20 14:58:40 2011
@@ -280,6 +280,14 @@ CREATE TABLE IF NOT EXISTS `connectmetho
-- --------------------------------------------------------
+--
+-- Table structure for table `imagerevision`
+--
+
+CALL AddColumnIfNotExists('imagerevision', 'autocaptured', "tinyint(1) unsigned NOT NULL default '0'");
+
+-- --------------------------------------------------------
+
--
-- Table structure for table `loginlog`
--
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1186841&r1=1186840&r2=1186841&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu Oct 20 14:58:40 2011
@@ -436,6 +436,7 @@ CREATE TABLE IF NOT EXISTS `imagerevisio
`production` tinyint(1) unsigned NOT NULL,
`comments` text,
`imagename` varchar(75) NOT NULL,
+ `autocaptured` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `production` (`production`,`imagename`),
UNIQUE KEY `imageid` (`imageid`,`revision`),