svn commit: r1309391 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql

[jfthomps]

Author: jfthomps
Date: Wed Apr  4 14:03:07 2012
New Revision: 1309391

URL: http://svn.apache.org/viewvc?rev=1309391&view=rev
Log:
VCL-418
simplify adding LDAP authentication

added affiliation.theme

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=1309391&r1=1309390&r2=1309391&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Wed Apr  4 14:03:07 2012
@@ -372,6 +372,7 @@ END$$
 --
 
 CALL AddUniqueIndex('affiliation', 'name');
+CALL AddColumnIfNotExists('affiliation', 'theme', "varchar(50) NOT NULL 
default 'default'");
 
 -- --------------------------------------------------------
 

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1309391&r1=1309390&r2=1309391&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Wed Apr  4 14:03:07 2012
@@ -48,6 +48,7 @@ CREATE TABLE IF NOT EXISTS `affiliation`
   `sitewwwaddress` varchar(56) default NULL,
   `helpaddress` varchar(32) default NULL,
   `shibonly` tinyint(1) unsigned NOT NULL default '0',
+  `theme` varchar(50) NOT NULL default 'default',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -1289,7 +1290,7 @@ INSERT INTO `adminlevel` (`id`, `name`) 
 -- Dumping data for table `affiliation`
 -- 
 
-INSERT INTO `affiliation` (`id`, `name`, `dataUpdateText`) VALUES 
+INSERT INTO `affiliation` (`id`, `name`, `dataUpdateText`, `theme`) VALUES 
 (1, 'Local', ''),
 (2, 'Global', '');