[Openfirst-cvscommit] members/setup setup.mysql,1.11,1.12 setup.mssql,1.2,1.3
Brought to you by:
xtimg
Menu
▾
▴
[Openfirst-cvscommit] members/setup setup.mysql,1.11,1.12 setup.mssql,1.2,1.3
|
From: <xt...@us...> - 2003-10-05 13:23:13
|
Update of /cvsroot/openfirst/members/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv2036/setup
Modified Files:
setup.mysql setup.mssql
Log Message:
Add cell phone information gathering to profiles with sufficient information so that it may be used to send SMS messages to members.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mysql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** setup.mysql 26 Sep 2003 03:28:21 -0000 1.11
--- setup.mysql 5 Oct 2003 13:23:07 -0000 1.12
***************
*** 1,4 ****
--- 1,62 ----
INSERT INTO ofirst_config SET modulename='members',showonmenu='0',active='0';
UPDATE ofirst_config SET modulenavigation='<a href="$basepath/members/workspace.php">My Workspace</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/config/">Site Configuration</a>' where modulename='members';
+ ALTER TABLE ofirst_members ADD (cellphonenumber TEXT, cellphonecarrier TEXT, cellphonesms BOOL, hiddenfields TEXT);
+ CREATE TABLE ofirst_cellphonecarriers (smsaddress TEXT, fullname TEXT);
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.celloneusa.com', 'CellularOne (Dobson)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('csouth1.com', 'Cellular South');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('blueskyfrog.com', 'Blue Sky Frog');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('blsdcs.net', 'BellSouth Mobility');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.beemail.ru', 'BeeLine GSM');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.att.net', 'AT&T Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('paging.acswireless.com', 'Ameritech (ACSWireless)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('message.alltell.com', 'Alltell');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tbayteltxt.net', 'TBaytel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('txt.bellmobility.ca', 'Bell Mobility PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('txt.bellmobility.ca', 'Bell Mobility Pagers');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('fido.ca', 'FIDO PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.rogers.com', 'Rogers AT&T Wireless PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.rogers.com', 'Rogers AT&T Wireless paging (Blackberry)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('msg.telus.com', 'Telus Mobility PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('page.metrocall.com', 'Metrocall Pager');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.mymeteor.ie', 'Meteor');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('text.mtsmobility.ca', 'Manitoba Telecom Systems');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('smsmail.lmt.lv', 'LMT');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.kyivstar.net', 'Kyivstar');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('jp-t.ne.jp', 'J-Phone');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('ideacellular.net', 'Idea Cellular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.goldentele.com', 'Golden Telecom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.edgewireless.com', 'Edge Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.orange.nl', 'Dutchtone/Orange-NL');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Cingular IM Plus/Bellsouth IPS Cellphones');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Cingular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('page.mobilfone.com', 'Mobilfone');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('wirefree.informe.ca', 'NBTel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.netcom.no', 'Netcom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.nextel.com', 'Nextel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('npiwireless.com', 'NPI Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.ntelos.com', 'NTELOS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('optusmobile.com.au', 'Optus');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Pacific Bell Cingular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pagenet.net', 'Pagenet');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.rogers.com', 'PCS Rogers AT&T Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('ptel.net', 'Powertel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.pscel.com', 'PSC Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('qwestmp.com', 'Qwest');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.sprintpcs.com', 'Sprint PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.sprintpcs.com', 'Sprint PCS - Short Mail');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tms.suncom.com', 'SunCom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.surewest.com', 'SureWest Communications');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('t-d1-sms.de', 'T-Mobile Germany');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tmomail.net', T-Mobile USA'');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('movistar.net', 'Telefonica Movistar');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.umc.com.ua', 'UMC');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vtext.com', 'Verizon Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('airtouchpaging.com', 'Verizon Wireless (formerly Airtouch)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('myairmail.com', 'Verizon Wireless (myairmail.com)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pager.irkutsk.ru', 'Vessotel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vxtras.com', 'Virgin Mobile UK');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vmobl.com', 'Virgin Mobile USA');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('airmessage.net', 'Weblink Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('wyndtell.com', 'WyndTell');
CREATE TABLE IF NOT EXISTS ofirst_workspace_users (quota BIGINT, user CHAR(128), virtfspath TEXT, frozen INT(1));
CREATE TABLE IF NOT EXISTS ofirst_workspace_files(size BIGINT, name TEXT, location TEXT, owner TEXT, division TEXT, permissions TEXT, date TEXT, description TEXT, filetype TEXT);
Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/members/setup/setup.mssql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** setup.mssql 28 Sep 2003 14:05:42 -0000 1.2
--- setup.mssql 5 Oct 2003 13:23:07 -0000 1.3
***************
*** 1,4 ****
--- 1,62 ----
INSERT INTO ofirst_config SET modulename='members',showonmenu='0',active='0';
UPDATE ofirst_config SET modulenavigation='<a href="$basepath/members/workspace.php">My Workspace</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/config/">Site Configuration</a>' where modulename='members';
+ ALTER TABLE ofirst_members ADD (cellphonenumber TEXT, cellphonecarrier TEXT, cellphonesms BOOL);
+ CREATE TABLE ofirst_cellphonecarriers (smsaddress TEXT, fullname TEXT);
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.celloneusa.com', 'CellularOne (Dobson)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('csouth1.com', 'Cellular South');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('blueskyfrog.com', 'Blue Sky Frog');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('blsdcs.net', 'BellSouth Mobility');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.beemail.ru', 'BeeLine GSM');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.att.net', 'AT&T Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('paging.acswireless.com', 'Ameritech (ACSWireless)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('message.alltell.com', 'Alltell');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tbayteltxt.net', 'TBaytel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('txt.bellmobility.ca', 'Bell Mobility PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('txt.bellmobility.ca', 'Bell Mobility Pagers');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('fido.ca', 'FIDO PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.rogers.com', 'Rogers AT&T Wireless PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.rogers.com', 'Rogers AT&T Wireless paging (Blackberry)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('msg.telus.com', 'Telus Mobility PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('page.metrocall.com', 'Metrocall Pager');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.mymeteor.ie', 'Meteor');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('text.mtsmobility.ca', 'Manitoba Telecom Systems');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('smsmail.lmt.lv', 'LMT');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.kyivstar.net', 'Kyivstar');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('jp-t.ne.jp', 'J-Phone');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('ideacellular.net', 'Idea Cellular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.goldentele.com', 'Golden Telecom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.edgewireless.com', 'Edge Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.orange.nl', 'Dutchtone/Orange-NL');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Cingular IM Plus/Bellsouth IPS Cellphones');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Cingular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('page.mobilfone.com', 'Mobilfone');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('wirefree.informe.ca', 'NBTel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.netcom.no', 'Netcom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.nextel.com', 'Nextel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('npiwireless.com', 'NPI Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.ntelos.com', 'NTELOS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('optusmobile.com.au', 'Optus');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.mycingular.com', 'Pacific Bell Cingular');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pagenet.net', 'Pagenet');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pcs.rogers.com', 'PCS Rogers AT&T Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('ptel.net', 'Powertel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.pscel.com', 'PSC Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('qwestmp.com', 'Qwest');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.sprintpcs.com', 'Sprint PCS');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('messaging.sprintpcs.com', 'Sprint PCS - Short Mail');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tms.suncom.com', 'SunCom');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('mobile.surewest.com', 'SureWest Communications');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('t-d1-sms.de', 'T-Mobile Germany');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('tmomail.net', T-Mobile USA'');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('movistar.net', 'Telefonica Movistar');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('sms.umc.com.ua', 'UMC');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vtext.com', 'Verizon Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('airtouchpaging.com', 'Verizon Wireless (formerly Airtouch)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('myairmail.com', 'Verizon Wireless (myairmail.com)');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('pager.irkutsk.ru', 'Vessotel');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vxtras.com', 'Virgin Mobile UK');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('vmobl.com', 'Virgin Mobile USA');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('airmessage.net', 'Weblink Wireless');
+ INSERT INTO ofirst_cellphonecarriers (smsaddress, fullname) VALUES ('wyndtell.com', 'WyndTell');
CREATE TABLE IF NOT EXISTS ofirst_workspace_users (quota BIGINT, user CHAR(128), virtfspath TEXT, frozen INT(1));
CREATE TABLE IF NOT EXISTS ofirst_workspace_files(size BIGINT, name TEXT, location TEXT, owner TEXT, division TEXT, permissions TEXT, date TEXT, description TEXT, filetype TEXT);
|
