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`),