--liquibase formatted sql
--changeset patrick.thomlinson:add-shippers

CREATE TABLE shippers (
    `id` INT,
    `code` VARCHAR(10) CHARACTER SET utf8,
    `custom` VARCHAR(6) CHARACTER SET utf8,
    `name` VARCHAR(35) CHARACTER SET utf8,
    `account_id` VARCHAR(9) CHARACTER SET utf8,
    `active` INT,
    `type` VARCHAR(3) CHARACTER SET utf8,
    `is_p44` INT,
    `quickbooks_name` VARCHAR(35) CHARACTER SET utf8,
    `access_key` VARCHAR(16) CHARACTER SET utf8
);
INSERT INTO shippers VALUES (1,'RDWY','RDWY','Yellow / Roadway',NULL,1,'LTL',1,'YRC',NULL);
INSERT INTO shippers VALUES (2,'ABFS','ABFS','ABF Freight',NULL,1,'LTL',1,'ABFS',NULL);
INSERT INTO shippers VALUES (3,'DAFG2','DAFG','Dayton Freight Lines, Inc','12345678',1,'LTL',1,'DF',NULL);
INSERT INTO shippers VALUES (4,'EXLA','EXLA','Estes Express',NULL,1,'LTL',1,'ESTES EXPRESS LINES',NULL);
INSERT INTO shippers VALUES (5,'HMES','HMES','Holland Motor Express',NULL,1,'LTL',1,'USF HOLLAND, INC',NULL);
INSERT INTO shippers VALUES (6,'SAIA','SAIA','SAIA Motor Freight',NULL,1,'LTL',1,'SAIA FREIGHT LINE',NULL);
INSERT INTO shippers VALUES (8,'MANUAL','MANUAL','MANUAL',NULL,1,'LTL',1,'???',NULL);
INSERT INTO shippers VALUES (9,'FXFE','FXFE','FedEx Freight Economy',NULL,1,'LTL',1,'FEDA',NULL);
INSERT INTO shippers VALUES (10,'FXNL','FXNL','FedEx National LTL',NULL,1,'LTL',1,'FEDA',NULL);
INSERT INTO shippers VALUES (11,'UPS','UPS','UPS','R95229',1,'PCL',0,'UPS','2C9E3074AA68A258');
INSERT INTO shippers VALUES (12,'FEDEX','FEDEX','FedEx Parcel','429322723',1,'PCL',0,'FEDEX',NULL);
INSERT INTO shippers VALUES (13,'CW00021035',NULL,'Allstates World Cargo',NULL,1,'LTL',0,'ALLSTATES WORLD CARGO',NULL);
INSERT INTO shippers VALUES (14,'CW00021122',NULL,'B Line Inc.',NULL,1,'LTL',0,'B Line Inc.',NULL);
INSERT INTO shippers VALUES (15,'CW00021123',NULL,'Bestway International Inc.',NULL,1,'LTL',0,'Bestway International Inc.',NULL);
INSERT INTO shippers VALUES (16,'CW00021138',NULL,'Brock, LLC',NULL,1,'LTL',0,'BROCK TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (17,'CW00021127',NULL,'C.H.Robinson Co.Inc',NULL,1,'LTL',0,'CH ROBINSON WORLD WIDE INC',NULL);
INSERT INTO shippers VALUES (18,'CW00021101',NULL,'Cal-Ark, Inc',NULL,1,'LTL',0,'CAL-ARK, INC',NULL);
INSERT INTO shippers VALUES (19,'CW00021114',NULL,'Caneda Trnsport Inc.',NULL,1,'LTL',0,'CANEDA TRANSPORT INC',NULL);
INSERT INTO shippers VALUES (20,'CW00021165',NULL,'Cayenne Express Inc.',NULL,1,'LTL',0,'CAYENNE EXPRESS INC.',NULL);
INSERT INTO shippers VALUES (21,'CW00021042',NULL,'Ceva',NULL,1,'LTL',0,'CEVA',NULL);
INSERT INTO shippers VALUES (22,'CW00021131',NULL,'CFI',NULL,1,'LTL',0,'CFI',NULL);
INSERT INTO shippers VALUES (23,'CW00021179',NULL,'Christenson Transportation',NULL,1,'LTL',0,'CHRISTENSON TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (24,'CW00021116',NULL,'Cropper Trucking, LLC',NULL,1,'LTL',0,'CROPPER TRUCKING LLC',NULL);
INSERT INTO shippers VALUES (25,'CW00021184',NULL,'Customer Pickup',NULL,1,'LTL',0,'CUSTOMER PICKUP',NULL);
INSERT INTO shippers VALUES (26,'CW00021166',NULL,'D&D Sexton',NULL,1,'LTL',0,'D&D Sexton',NULL);
INSERT INTO shippers VALUES (27,'CW00021104',NULL,'DHL Express',NULL,1,'LTL',0,'DHL EXPRESS',NULL);
INSERT INTO shippers VALUES (28,NULL,NULL,'Dugan Truck Line LLC',NULL,1,'LTL',0,'DUGAN TRUCK LINE LLC',NULL);
INSERT INTO shippers VALUES (29,'CW00021045',NULL,'Earl L. Henderson Trucking Co, Inc',NULL,1,'LTL',0,'EARL L. HENDERSON TRUCKING CO., INC',NULL);
INSERT INTO shippers VALUES (30,'CW00021014',NULL,'Express 2000, Incorporated',NULL,1,'LTL',0,'EXPRESS 2000',NULL);
INSERT INTO shippers VALUES (31,'CW00021111',NULL,'Forry Transport Inc',NULL,1,'LTL',0,'FORRY TRANSPORT INC',NULL);
INSERT INTO shippers VALUES (32,'CW00021152',NULL,'GP Transportation',NULL,1,'LTL',0,'GP TRANSPORT INC',NULL);
INSERT INTO shippers VALUES (33,'CW00021151',NULL,'GSA International LTD',NULL,1,'LTL',0,'GSA INTERNATIONAL LTD',NULL);
INSERT INTO shippers VALUES (34,'CW00021136',NULL,'GSIS Freight Coverage',NULL,1,'LTL',0,'GSIS FREIGHT COVERAGE',NULL);
INSERT INTO shippers VALUES (35,'CW00021180',NULL,'Hicks Transportation',NULL,1,'LTL',0,'HICKS TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (36,'CW00021139',NULL,'Honolulu Freight Service',NULL,1,'LTL',0,'HONOLULU FREIGHT SERVICE',NULL);
INSERT INTO shippers VALUES (37,'CW00021106',NULL,'Huntington Woods',NULL,1,'LTL',0,'HUNTINGTON WOODS LOGISTICS',NULL);
INSERT INTO shippers VALUES (38,'CW00021113',NULL,'Indiana Western Express',NULL,1,'LTL',0,'INDIANA WESTERN EXPRESS',NULL);
INSERT INTO shippers VALUES (39,'CW00021150',NULL,'Integrity Express Logistics',NULL,1,'LTL',0,'INTEGRITY EXPRESS LOGISTICS',NULL);
INSERT INTO shippers VALUES (40,'CW00021050',NULL,'Jacobson Transport',NULL,1,'LTL',0,'JACOBSON TRANSPORT',NULL);
INSERT INTO shippers VALUES (41,'CW00021164',NULL,'James Transportation',NULL,1,'LTL',0,'JAMES TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (42,'CW00021174',NULL,'Kings Eagle Inc',NULL,1,'LTL',0,'Kings Eagle Inc',NULL);
INSERT INTO shippers VALUES (43,'CW00021125',NULL,'Main Line Hauling Co LLC',NULL,1,'LTL',0,'MAIN LINE HAULING',NULL);
INSERT INTO shippers VALUES (44,'CW00021051',NULL,'Marisol International',NULL,1,'LTL',0,'MARISOL INTERNATIONAL',NULL);
INSERT INTO shippers VALUES (45,'CW00021120',NULL,'Marleon International',NULL,1,'LTL',0,'MARLEON INTERNATIONAL',NULL);
INSERT INTO shippers VALUES (46,'CW00021172',NULL,'Marvin Keller Trucking',NULL,1,'LTL',0,'MARVIN KELLER TRUCKING',NULL);
INSERT INTO shippers VALUES (47,'CW00021053',NULL,'Mercer Transportation CO. Inc.',NULL,1,'LTL',0,'MERCER TRANSPORTATION  CO. INC.',NULL);
INSERT INTO shippers VALUES (48,'CW00021105',NULL,'MGI',NULL,1,'LTL',0,'MGI FREIGHT SOLUTIONS',NULL);
INSERT INTO shippers VALUES (49,'CW00021147',NULL,'Millenial Transport Services LLC',NULL,1,'LTL',0,'MILLENNIAL TRANSPORT SERVICES',NULL);
INSERT INTO shippers VALUES (50,'CW00021058',NULL,'Missouri Truck Load Services',NULL,1,'LTL',0,'MISSOURI TRUCK LOAD SERVICES',NULL);
INSERT INTO shippers VALUES (51,'CW00021161',NULL,'Mister P Express',NULL,1,'LTL',0,'MISTER P EXPRESS',NULL);
INSERT INTO shippers VALUES (52,'CW00021107',NULL,'Nelson Freight Service Inc',NULL,1,'LTL',0,'Nelson Freight Service Inc',NULL);
INSERT INTO shippers VALUES (53,'CW00021173',NULL,'Nixa Trucking Inc.',NULL,1,'LTL',0,'NIXA TRUCKING INC.',NULL);
INSERT INTO shippers VALUES (54,'CW00021175',NULL,'Nolan Transportation Group LLC',NULL,1,'LTL',0,'NOLAN TRANSPORTATION GROUP LLC',NULL);
INSERT INTO shippers VALUES (55,'CW00021064',NULL,'Ozark Motor Lines',NULL,1,'LTL',0,'OZARK MOTOR LINES',NULL);
INSERT INTO shippers VALUES (56,'CW00021065',NULL,'Panther Expedite',NULL,1,'LTL',0,'PANTHER EXPEDITE',NULL);
INSERT INTO shippers VALUES (57,'CW00021178',NULL,'PBJ Express Inc.',NULL,1,'LTL',0,'PBJ EXPRESS INC.',NULL);
INSERT INTO shippers VALUES (58,'CW00021171',NULL,'Perfecta Express',NULL,1,'LTL',0,'PERFECTA EXPRESS',NULL);
INSERT INTO shippers VALUES (59,'CW00021141',NULL,'Phipps Trucking LLC',NULL,1,'LTL',0,'PHIPPS TRUCKING LLC',NULL);
INSERT INTO shippers VALUES (60,'CW00021129',NULL,'Pilot Air Freight Corp.',NULL,1,'LTL',0,'PILOT AIR FREIGHT CORP',NULL);
INSERT INTO shippers VALUES (61,'CW00021067',NULL,'Pottle''s Transportation',NULL,1,'LTL',0,'POTTLE''S TRANSPORTATION, LLC',NULL);
INSERT INTO shippers VALUES (62,'CW00021124',NULL,'Queen City Express',NULL,1,'LTL',0,'QUEEN CITY EXPRESS',NULL);
INSERT INTO shippers VALUES (63,'CW00021002',NULL,'R & L Carriers Inc',NULL,1,'LTL',0,'R & L CARRIERS INC',NULL);
INSERT INTO shippers VALUES (64,'CW00021086',NULL,'RBX, Inc.',NULL,1,'LTL',0,'RBX, INC.',NULL);
INSERT INTO shippers VALUES (65,'CW00021070',NULL,'RBX, INC.',NULL,1,'LTL',0,'RBX, INC.',NULL);
INSERT INTO shippers VALUES (66,'CW00021092',NULL,'Reaves Delivery',NULL,1,'LTL',0,'REAVES DELIVERY',NULL);
INSERT INTO shippers VALUES (67,'CW00021103',NULL,'Replogle Farms',NULL,1,'LTL',0,'REPLOGLE FARMS',NULL);
INSERT INTO shippers VALUES (68,'CW00021091',NULL,'Roadrunner Transportation',NULL,1,'LTL',0,'ROADRUNNER TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (69,'CW00021162',NULL,'S & T Transport',NULL,1,'LTL',0,'S & T TRANSPORT',NULL);
INSERT INTO shippers VALUES (70,'CW00021110',NULL,'Schneider Logistics Inc.',NULL,1,'LTL',0,'SCHNEIDER NATIONAL',NULL);
INSERT INTO shippers VALUES (71,'CW00021098',NULL,'SRC Logistics Inc.',NULL,1,'LTL',0,'SRC LOGISTICS INC.',NULL);
INSERT INTO shippers VALUES (72,'CW00021169',NULL,'Starex Transport',NULL,1,'LTL',0,'STAREX TRANSPORT',NULL);
INSERT INTO shippers VALUES (73,'CW00021076',NULL,'Steelman Transportation',NULL,1,'LTL',0,'STEELMAN TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (74,'CW00021160',NULL,'Strong Transportation',NULL,1,'LTL',0,'STRONG TRANSPORTATION',NULL);
INSERT INTO shippers VALUES (75,'CW00021077',NULL,'TCSI-Transland, INC.',NULL,1,'LTL',0,'TCSI-TRANSLAND, INC.',NULL);
INSERT INTO shippers VALUES (76,'CW00021142',NULL,'Time-DC',NULL,1,'LTL',0,'TIME-DC',NULL);
INSERT INTO shippers VALUES (77,'CW00021181',NULL,'Transport Distribution Co.',NULL,1,'LTL',0,'TRANSPORT DISTRIBUTION CO.',NULL);
INSERT INTO shippers VALUES (78,'CW00021081',NULL,'US Customs And Border Protection',NULL,1,'LTL',0,'US CUSTOMS AND BORDER PROTECTION',NULL);
INSERT INTO shippers VALUES (79,'CW00021108',NULL,'UPS SCS',NULL,1,'LTL',0,'UPS SUPPLY CHAIN SOLUTIONS',NULL);
INSERT INTO shippers VALUES (80,'CW00021100',NULL,'V. Graham & Sons Trucking',NULL,1,'LTL',0,'V. GRAHAM & SONS TRUCKING',NULL);
INSERT INTO shippers VALUES (81,'CW00021176',NULL,'Vela Transport',NULL,1,'LTL',0,'VELA TRANSPORT',NULL);
INSERT INTO shippers VALUES (82,'CW00021182',NULL,'Vision Transportation Systems, Inc.',NULL,1,'LTL',0,'VISION TRANSPORTATION SYSTEM, INC',NULL);
INSERT INTO shippers VALUES (83,'CW00021163',NULL,'Vito LLC',NULL,1,'LTL',0,'VITO LLC',NULL);
INSERT INTO shippers VALUES (84,'CW00021083',NULL,'Wagner Trucking',NULL,1,'LTL',0,'WAGNER TRUCKING',NULL);
INSERT INTO shippers VALUES (85,'CW00021170',NULL,'Waller Truck Co., Inc.',NULL,1,'LTL',0,'WALLER TRUCK CO., INC.',NULL);
INSERT INTO shippers VALUES (86,'CW00021084',NULL,'Western Overseas Corporation',NULL,1,'LTL',0,'WESTERN OVERSEAS CORPORATION',NULL);
INSERT INTO shippers VALUES (87,'CW00021148',NULL,'Wiles OTRLLC/DBA Bestway OTR',NULL,1,'LTL',0,'WILES OTRLLC/DBA BESTWAY OTR',NULL);
INSERT INTO shippers VALUES (88,'CW00021167',NULL,'Woody Bogler',NULL,1,'LTL',0,'Woody Bogler',NULL);
INSERT INTO shippers VALUES (89,'CW00021154',NULL,'Yowell Transportation Service Inc.',NULL,1,'LTL',0,'YOWELL TRANSPORTATION SERVICE INC.',NULL);
INSERT INTO shippers VALUES (90,'CW00021177',NULL,'Zero Mountain Logistics',NULL,1,'LTL',0,'ZERO MOUNTAIN LOGISTICS',NULL);
