move carrier.sql to sms_carrier.sql

1 files changed, 61 insertions, 0 deletions

diff --git a/db/sms_carrier.sql b/db/sms_carrier.sql
new file mode 100644
index 000000000..932f7c8bb
--- /dev/null
+++ b/db/sms_carrier.sql
@@ -0,0 +1,61 @@
+insert into sms_carrier
+    (name, email_pattern, created)
+values
+    ('3 River Wireless', '%s@sms.3rivers.net', now()),
+    ('7-11 Speakout', '%s@cingularme.com', now()),
+    ('Airtel (Karnataka, India)', '%s@airtelkk.com', now()),
+    ('Alaska Communications Systems', '%s@msg.acsalaska.com', now()),
+    ('Alltel Wireless', '%s@message.alltel.com', now()),
+    ('AT&T Wireless', '%s@txt.att.net', now()),
+    ('Bell Mobility (Canada)', '%s@txt.bell.ca', now()),
+    ('Boost Mobile', '%s@myboostmobile.com', now()),
+    ('Cellular One (Dobson)', '%s@mobile.celloneusa.com', now()),
+    ('Cincinnati Bell Wireless', '%s@gocbw.com', now()),
+    ('Cingular (Postpaid)', '%s@cingularme.com', now()),
+    ('Centennial Wireless', '%s@cwemail.com', now()),
+    ('Cingular (GoPhone prepaid)', '%s@cingularme.com', now()),
+    ('Claro (Nicaragua)', '%s@ideasclaro-ca.com', now()),
+    ('Comcel', '%s@comcel.com.co', now()),
+    ('Cricket', '%s@sms.mycricket.com', now()),
+    ('CTI', '%s@sms.ctimovil.com.ar', now()),
+    ('Emtel (Mauritius)', '%s@emtelworld.net', now()),
+    ('Fido (Canada)', '%s@fido.ca', now()),
+    ('General Communications Inc.', '%s@msg.gci.net', now()),
+    ('Globalstar', '%s@msg.globalstarusa.com', now()),
+    ('Helio', '%s@myhelio.com', now()),
+    ('Illinois Valley Cellular', '%s@ivctext.com', now()),
+    ('i wireless', '%s.iws@iwspcs.net', now()),
+    ('Meteor (Ireland)', '%s@sms.mymeteor.ie', now()),
+    ('Mero Mobile (Nepal)', '%s@sms.spicenepal.com', now()),
+    ('MetroPCS', '%s@mymetropcs.com', now()),
+    ('Movicom', '%s@movimensaje.com.ar', now()),
+    ('Mobitel (Sri Lanka)', '%s@sms.mobitel.lk', now()),
+    ('Movistar (Colombia)', '%s@movistar.com.co', now()),
+    ('MTN (South Africa)', '%s@sms.co.za', now()),
+    ('MTS (Canada)', '%s@text.mtsmobility.com', now()),
+    ('Nextel (Argentina)', '%s@nextel.net.ar', now()),
+    ('Orange (Poland)', '%s@orange.pl', now()),
+    ('Orange (UK)', '%s@orange.net', now()),
+    ('Personal (Argentina)', '%s@personal-net.com.ar', now()),
+    ('Plus GSM (Poland)', '%s@text.plusgsm.pl', now()),
+    ('President''s Choice (Canada)', '%s@txt.bell.ca', now()),
+    ('Qwest', '%s@qwestmp.com', now()),
+    ('Rogers (Canada)', '%s@pcs.rogers.com', now()),
+    ('Sasktel (Canada)', '%s@sms.sasktel.com', now()),
+    ('Setar Mobile email (Aruba)', '%s@mas.aw', now()),
+    ('Solo Mobile', '%s@txt.bell.ca', now()),
+    ('Sprint (PCS)', '%s@messaging.sprintpcs.com', now()),
+    ('Sprint (Nextel)', '%s@page.nextel.com', now()),
+    ('Suncom', '%s@tms.suncom.com', now()),
+    ('T-Mobile', '%s@tmomail.net', now()),
+    ('T-Mobile (Austria)', '%s@sms.t-mobile.at', now()),
+    ('Telus Mobility (Canada)', '%s@msg.telus.com', now()),
+    ('Thumb Cellular', '%s@sms.thumbcellular.com', now()),
+    ('Tigo (Formerly Ola)', '%s@sms.tigo.com.co', now()),
+    ('Unicel', '%s@utext.com', now()),
+    ('US Cellular', '%s@email.uscc.net', now()),
+    ('Verizon', '%s@vtext.com', now()),
+    ('Virgin Mobile (Canada)', '%s@vmobile.ca', now()),
+    ('Virgin Mobile (USA)', '%s@vmobl.com', now()),
+    ('Vodafone NZ (txt ''R'' to 901 to enable first)', '%s@sms.vodafone.net.nz', now()),
+    ('YCC', '%s@sms.ycc.ru', now());