[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.7_to_1.3.8.php,1.5,1.6

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/sql/updates
In directory internal.geeklog.net:/tmp/cvs-serv17235/sql/updates

Modified Files:
	mysql_1.3.7_to_1.3.8.php 
Log Message:
Added a "Privacy Options" block to the Preferences which let the user chose not to receive emails (from Admins and/or other users) and show up in the Who's Online block.


Index: mysql_1.3.7_to_1.3.8.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/updates/mysql_1.3.7_to_1.3.8.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** mysql_1.3.7_to_1.3.8.php	22 Jun 2003 15:47:13 -0000	1.5
--- mysql_1.3.7_to_1.3.8.php	22 Jun 2003 22:07:43 -0000	1.6
***************
*** 5,9 ****
  $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD pwrequestid varchar(16) DEFAULT NULL";
  
! $_SQL[] = "ALTER TABLE {$_TABLES['userinfo']}  ADD lastlogin VARCHAR( 10 ) NOT NULL";
  
  $_SQL[] = "CREATE TABLE {$_TABLES['speedlimit']} (
--- 5,12 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD pwrequestid varchar(16) DEFAULT NULL";
  
! $_SQL[] = "ALTER TABLE {$_TABLES['userinfo']} ADD lastlogin VARCHAR( 10 ) NOT NULL";
! 
! $_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD emailfromuser tinyint(1) NOT NULL default '1'";
! $_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD showonline tinyint(1) NOT NULL default '1'";
  
  $_SQL[] = "CREATE TABLE {$_TABLES['speedlimit']} (