[Gemstracker-svn] SF.net SVN: gemstracker:[314] branches/1.5.0-pulse/library/configs/db/ patches.sql

[<gem...@li...>]

Revision: 314
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=314&view=rev
Author:   michieltcs
Date:     2011-11-29 14:55:15 +0000 (Tue, 29 Nov 2011)
Log Message:
-----------
Set defaults for non-null columns in gems__user_logins

Modified Paths:
--------------
    branches/1.5.0-pulse/library/configs/db/patches.sql

Modified: branches/1.5.0-pulse/library/configs/db/patches.sql
===================================================================
--- branches/1.5.0-pulse/library/configs/db/patches.sql	2011-11-29 11:38:22 UTC (rev 313)
+++ branches/1.5.0-pulse/library/configs/db/patches.sql	2011-11-29 14:55:15 UTC (rev 314)
@@ -353,3 +353,7 @@
       grc_changed, grc_changed_by, grc_created, grc_created_by)
     VALUES
         ('stop', 'Stop surveys', 0, 2, 0, 0, 0, 0, 1, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1);
+
+-- PATCH: Defaults for non-null columns
+ALTER TABLE `gems__user_logins` CHANGE `gul_login` `gul_login` varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' not null default '';
+ALTER TABLE `gems__user_logins` CHANGE `gul_id_organization` `gul_id_organization` bigint not null default 0;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.