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)');
|
