CREATE TABLE util_phone_carrier
(
    id          int(4) AUTO_INCREMENT
        PRIMARY KEY,
    code        varchar(20)            NOT NULL,
    description varchar(80) DEFAULT '' NULL,
    fromlen     int(4)      DEFAULT 0  NULL,
    messagelen  int(4)      DEFAULT 0  NULL,
    totallen    int(4)      DEFAULT 0  NULL,
    emailsuffix varchar(40)            NULL,
    ranking     int                    NOT NULL
);

INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (1, 'unknown', 'unknown', 0, 0, 0, '', 0);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (8, 'Boost', 'Boost', 30, 120, 120, '@myboostmobile.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (11, 'CellularOne West', 'CellularOne West', 20, 120, 120, '@mycellone.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (13, 'AT&T', 'AT&T', 20, 160, 160, '@txt.att.net', 10);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (14, 'Cingular', 'Cingular', 20, 160, 160, '@txt.att.net', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (24, 'Metro PCS', 'Metro PCS', 20, 120, 120, '@mymetropcs.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (28, 'Nextel', 'Nextel', 50, 126, 126, '@messaging.nextel.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (31, 'Pacific Bell Cingula', 'Pacific Bell Cingular', 20, 120, 120, '@mobile.mycingular.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (32, 'Pagenet', 'Pagenet', 20, 220, 240, '@pagenet.net', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (35, 'PSC Wireless', 'PSC Wireless', 20, 150, 150, '@sms.pscel.com', 10);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (36, 'Qwest', 'Qwest', 14, 100, 100, '@qwestmp.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (37, 'Safaricom', 'Safaricom', 15, 160, 160, '@safaricomsms.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (42, 'Sprint PCS', 'Sprint PCS', 15, 160, 160, '@messaging.sprintpcs.com', 10);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (46, 'T-Mobile USA', 'T-Mobile USA', 30, 160, 160, '@tmomail.net', 10);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (50, 'TIM', 'TIM', 30, 350, 350, '@timnet.com', 100);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (52, 'Verizon Wireless', 'Verizon Wireless', 34, 140, 140, '@vtext.com', 10);
INSERT INTO mbes_utilities.util_phone_carrier (id, code, description, fromlen, messagelen, totallen, emailsuffix, ranking) VALUES (56, 'Virgin Mobile USA', 'Virgin Mobile USA', 20, 160, 160, '@vmobl.com', 10);
