From 63825bf7b37b1694e32a5f2a3db258e9d10e2f65 Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Wed, 22 Jul 2009 21:08:23 +0000
Subject: [PATCH] fix for users.calendar calculation

---
 sql/3_0_1-to-3_0_2_upgrade.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/3_0_1-to-3_0_2_upgrade.sql b/sql/3_0_1-to-3_0_2_upgrade.sql
index 6ee8a5b62..e5720b342 100644
--- a/sql/3_0_1-to-3_0_2_upgrade.sql
+++ b/sql/3_0_1-to-3_0_2_upgrade.sql
@@ -205,6 +205,6 @@ CREATE TABLE `users_facility` (
 #IfMissingColumn users calendar
 ALTER TABLE `users` 
   ADD `calendar` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 = appears in calendar';
-UPDATE users SET calendar = 1 WHERE authorized = 1 AND info NOT LIKE '%Nocalendar%';
+UPDATE users SET calendar = 1 WHERE authorized = 1 AND ( info IS NULL OR info NOT LIKE '%Nocalendar%' );
 #EndIf
 
-- 
2.11.4.GIT