--liquibase formatted sql
--changeset patrick.thomlinson:add-user-settings-to-shipper-account-shipper

ALTER TABLE `shippers` 
ADD COLUMN `username` varchar(50) NULL AFTER `access_key`,
ADD COLUMN `password` varchar(50) NULL AFTER `username`;
ALTER TABLE `account_shippers` 
ADD COLUMN `username` varchar(50) NULL AFTER `account_id`,
ADD COLUMN `password` varchar(50) NULL AFTER `username`;

UPDATE `shippers` SET `username` = 'Cloudy34', `password` = 'freightSRC1' WHERE id = 11;