[Openfirst-cvscommit] members/setup setup.mssql,1.4,1.5 setup.mysql,1.13,1.14

[<xt...@us...>]

Update of /cvsroot/openfirst/members/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv15293

Modified Files:
	setup.mssql setup.mysql 
Log Message:
Update setup scripts to prevent cell phone carriers from being listed multiple times.  Bug reported by Stephanie Closs.

Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mssql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** setup.mssql	5 Oct 2003 15:25:37 -0000	1.4
--- setup.mssql	8 Oct 2003 22:46:20 -0000	1.5
***************
*** 2,5 ****
--- 2,6 ----
  UPDATE ofirst_config SET modulenavigation='<a href="$basepath/members/workspace.php">My Workspace</a> | <a href="$basepath/members/phpicalendar/month.php">Team Calendar</a> | <a href="$basepath/members/divisions.php">Team Divisions</a> | <a href="$basepath/members/profile.php">Member List</a> | <a href="$basepath/members/links.php">Site Links</a> | <a href="$basepath/members/skills.php">My Skills</a> | <a href="$basepath/members/updateprofile.php">My Profile</a> | <a href="$basepath/members/logout.php">Logout</a>',adminnavigation='<a href="$basepath/members/adduser.php">Add Users</a> | <a href="$basepath/members/phpicalendar/admin.php">Administrate Calendar</a> | <a href="$basepath/config/">Site Configuration</a>' where modulename='members';
  ALTER TABLE ofirst_members ADD (cellphonenumber TEXT, cellphonecarrier TEXT, cellphonesms BOOL, hiddenfields TEXT);
+ DROP TABLE IF EXISTS ofirst_cellphonecarriers;
  CREATE TABLE ofirst_cellphonecarriers (smsaddress TEXT, fullname TEXT);
  INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.celloneusa.com', 'CellularOne (Dobson)');

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mysql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** setup.mysql	5 Oct 2003 15:25:37 -0000	1.13
--- setup.mysql	8 Oct 2003 22:46:20 -0000	1.14
***************
*** 2,5 ****
--- 2,6 ----
  UPDATE ofirst_config SET modulenavigation='<a href="$basepath/members/workspace.php">My Workspace</a> | <a href="$basepath/members/phpicalendar/month.php">Team Calendar</a> | <a href="$basepath/members/divisions.php">Team Divisions</a> | <a href="$basepath/members/profile.php">Member List</a> | <a href="$basepath/members/links.php">Site Links</a> | <a href="$basepath/members/skills.php">My Skills</a> | <a href="$basepath/members/updateprofile.php">My Profile</a> | <a href="$basepath/members/logout.php">Logout</a>',adminnavigation='<a href="$basepath/members/adduser.php">Add Users</a> | <a href="$basepath/members/phpicalendar/admin.php">Administrate Calendar</a> | <a href="$basepath/config/">Site Configuration</a>' where modulename='members';
  ALTER TABLE ofirst_members ADD (cellphonenumber TEXT, cellphonecarrier TEXT, cellphonesms BOOL, hiddenfields TEXT);
+ DROP TABLE IF EXISTS ofirst_cellphonecarriers;
  CREATE TABLE ofirst_cellphonecarriers (smsaddress TEXT, fullname TEXT);
  INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.celloneusa.com', 'CellularOne (Dobson)');