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

[jfthomps]

Author: jfthomps
Date: Tue Jun 13 15:03:14 2017
New Revision: 1798608

URL: http://svn.apache.org/viewvc?rev=1798608&view=rev
Log:
VCL-981 - create a new theme that is more responsive for mobile devices

vcl.sql: changed affiliation.theme to allow NULL and default to NULL
update-vcl.sql: changed adding affiliation.theme to allow NULL and default to 
NULL; added update to set theme to NULL where it is currently an empty string

Modified:
    vcl/trunk/mysql/update-vcl.sql
    vcl/trunk/mysql/vcl.sql

Modified: vcl/trunk/mysql/update-vcl.sql
URL: 
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1798608&r1=1798607&r2=1798608&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Tue Jun 13 15:03:14 2017
@@ -762,9 +762,11 @@ END $$
 --  Table structure for table `affiliation`
 --
 
-ALTER TABLE `affiliation` CHANGE `sitewwwaddress` `sitewwwaddress` 
varchar(128) DEFAULT NULL;
+ALTER TABLE `affiliation` CHANGE `sitewwwaddress` `sitewwwaddress` 
varchar(128) default NULL;
 CALL AddUniqueIndex('affiliation', 'name');
-CALL AddColumnIfNotExists('affiliation', 'theme', "varchar(50) NOT NULL 
default 'default'");
+CALL AddColumnIfNotExists('affiliation', 'theme', "varchar(50) default NULL");
+ALTER TABLE `affiliation` CHANGE `theme` `theme` varchar(50) default NULL;
+UPDATE affiliation SET theme = NULL where theme = '';
 
 -- --------------------------------------------------------
 

Modified: vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1798608&r1=1798607&r2=1798608&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Tue Jun 13 15:03:14 2017
@@ -70,7 +70,7 @@ CREATE TABLE IF NOT EXISTS `affiliation`
   `sitewwwaddress` varchar(128) default NULL,
   `helpaddress` varchar(32) default NULL,
   `shibonly` tinyint(1) unsigned NOT NULL default '0',
-  `theme` varchar(50) NOT NULL default 'default',
+  `theme` varchar(50) default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;