[geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.4.2.php, 1.32, 1.33

[Blaine Lang]

Update of /cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv5696

Modified Files:
	mysql_1.4.1_to_1.4.2.php 
Log Message:
Added user 'batch admin' feature to send out account reminders to users that have not frequented the site recently

Index: mysql_1.4.1_to_1.4.2.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.4.1_to_1.4.2.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -C2 -d -r1.32 -r1.33
*** mysql_1.4.1_to_1.4.2.php	10 Oct 2007 03:38:43 -0000	1.32
--- mysql_1.4.1_to_1.4.2.php	25 Nov 2007 05:19:09 -0000	1.33
***************
*** 6,9 ****
--- 6,11 ----
  // change former default values to '' so users dont all have edt for no reason
  $_SQL[] = "UPDATE `{$_TABLES['userprefs']}` set tzid = ''";
+ // Add new field to track the number of reminders to login and use the site or account may be deleted
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD `num_reminders` TINYINT( 1 ) NOT NULL default 0";
  // User submissions may have body text.
  $_SQL[] = "ALTER TABLE `{$_TABLES['storysubmission']}` ADD bodytext TEXT AFTER introtext";