--liquibase formatted sql

--changeset damon.overboe:organization-rename-bobcat
UPDATE `organization` SET name = 'BOBCAT COMPANY' WHERE id = 4;

--changeset damon.overboe:orgs-rename-for-golive-20171010-#151827420
ALTER TABLE organization ADD COLUMN qb_name VARCHAR(200) AFTER is_deleted;
UPDATE organization SET name = 'AGCO', qb_name = 'AGCO TRANSPORTATION' WHERE id = 48;
UPDATE organization SET name = 'ARROWHEAD CONTAINERS', qb_name = 'ARROWHEAD CONTAINERS INC' WHERE id = 2;
UPDATE organization SET name = 'BETZ EXTINGUISHER SERVICE', qb_name = 'BETZ EXTINGUISHER SERVICE' WHERE id = 50;
UPDATE organization SET name = 'BMP DESIGN INC', qb_name = 'BMP DESIGN INC' WHERE id = 3;
UPDATE organization SET name = 'BOBCAT COMPANY', qb_name = 'BOBCAT TRANSPORTATION' WHERE id = 4;
UPDATE organization SET name = 'BOBCAT CONTAINER RETURNS', qb_name = 'BOBCAT TRANSPORTATION' WHERE id = 47;
UPDATE organization SET name = 'BOBCAT SURPLUS RETURNS', qb_name = 'BOBCAT TRANSPORTATION' WHERE id = 46;
UPDATE organization SET name = 'BOULDER TECH', qb_name = 'BOULDER TECHNOLOGIES LLC' WHERE id = 5;
UPDATE organization SET name = 'BRICKTOWN TECH DBA RESULTS', qb_name = 'RESULTS COMPUTER LLC' WHERE id = 6;
UPDATE organization SET name = 'BURNS EQUIPMENT', qb_name = 'BURNS EQUIPMENT COMPANY INC' WHERE id = 7;
UPDATE organization SET name = 'CERAMEX', qb_name = 'CERAMEX' WHERE id = 8;
UPDATE organization SET name = 'CLEAN DIESEL TECHNOLOGIES, INC', qb_name = 'CLEAN DIESEL TECHNOLOGIES, INC' WHERE id = 45;
UPDATE organization SET name = 'CNH REMAN COREVIEW', qb_name = 'CNH REMAN COREVIEW' WHERE id = 9;
UPDATE organization SET name = 'CNHR', qb_name = 'CNHR' WHERE id = 10;
UPDATE organization SET name = 'CONCURRENT', qb_name = 'CONCURRENT' WHERE id = 11;
UPDATE organization SET name = 'CONEQUIP', qb_name = 'CONEQUIP PARTS & EQUIP' WHERE id = 12;
UPDATE organization SET name = 'COOK TRACTOR', qb_name = 'COOK TRACTOR CO, INC.' WHERE id = 13;
UPDATE organization SET name = 'CSI DESIGNS (CENTRAL STATES INDUSTRIAL)', qb_name = 'CSI DESIGNS' WHERE id = 15;
UPDATE organization SET name = 'DJRJ CUSTOM PACKAGING LLC', qb_name = 'DJRJ CUSTOM PACKAGING LLC' WHERE id = 51;
UPDATE organization SET name = 'DOOSAN', qb_name = 'DOOSAN' WHERE id = 16;
UPDATE organization SET name = 'GLOBAL RECOVERY (GRC)', qb_name = 'GLOBAL RECOVERY CORP' WHERE id = 18;
UPDATE organization SET name = 'H & R CONSTRUCTION PARTS', qb_name = 'H & R CONSTRUCTION PARTS' WHERE id = 19;
UPDATE organization SET name = 'HIGH TECH INDUSTRIES', qb_name = 'HIGH TECH INDUSTRIES, LLC' WHERE id = 20;
UPDATE organization SET name = 'IDEA CO.', qb_name = 'IDEA CO.' WHERE id = 21;
UPDATE organization SET name = 'INMOTION WHOLESALE DISTRIBUTORS', qb_name = 'INMOTION WHOLESALE DISTRIBUTORS' WHERE id = 52;
UPDATE organization SET name = 'INDUSTRIAL SURPLUS SUPPLY', qb_name = 'INDUSTRIAL SURPLUS SUPPLY' WHERE id = 23;
UPDATE organization SET name = 'ISUZU MOTORS AMERICA LLC', qb_name = 'ISUZU MOTORS AMERICA LLC' WHERE id = 25;
UPDATE organization SET name = 'MGI TRANSPORT', qb_name = 'MGI TRANSPORT INC' WHERE id = 27;
UPDATE organization SET name = 'N & S TRACTOR', qb_name = 'N&S TRACTOR' WHERE id = 28;
UPDATE organization SET name = 'NAVISTAR', qb_name = 'NAVISTAR' WHERE id = 29;
UPDATE organization SET name = 'NEWSTREAM ENTERPRISES', qb_name = 'NEWSTREAM' WHERE id = 49;
UPDATE organization SET name = 'PROMOTER ADVERTISING PRODUCTS', qb_name = 'PROMOTER ADVERTISING PROD' WHERE id = 31;
UPDATE organization SET name = 'RIDEWELL SUSPENSIONS', qb_name = 'RIDEWELL SUSPENSIONS' WHERE id = 33;
UPDATE organization SET name = 'SOUTHERN MISSOURI CONTAINERS', qb_name = 'SOUTHERN MISSOURI CONTAINERS' WHERE id = 35;
UPDATE organization SET name = 'SRC AUTOMOTIVE', qb_name = 'SRC AUTOMOTIVE' WHERE id = 36;
UPDATE organization SET name = 'SRC ELECTRICAL', qb_name = 'SRC ELECTRICAL LLC' WHERE id = 37;
UPDATE organization SET name = 'SRC HEAVY DUTY', qb_name = 'SRC HEAVYDUTY' WHERE id = 38;
UPDATE organization SET name = 'SRC LEXINGTON', qb_name = 'SRC LEXINGTON' WHERE id = 39;
UPDATE organization SET name = 'SRC LOGISTICS', qb_name = 'SRC LOGISTICS' WHERE id = 44;
UPDATE organization SET name = 'SRC POWER SYSTEMS', qb_name = 'SRC POWER SYSTEMS' WHERE id = 40;
UPDATE organization SET name = 'WESTERN OVERSEAS', qb_name = 'WESTERN OVERSEAS CORP.' WHERE id = 41;
UPDATE organization SET name = 'YANMAR', qb_name = 'YANMAR' WHERE id = 42;
UPDATE organization SET name = 'YANMAR AMERICA PARTS DIVISION', qb_name = 'YANMAR' WHERE id = 43;

--changeset lewis.stone:orgs-rename-for-SE-SALES-20171228-#153944523
UPDATE organization SET qb_name = 'SE SALES' WHERE id = 23;
