ALTER TABLE books
    ADD COLUMN IF NOT EXISTS amazon_gross DECIMAL(10,2) NOT NULL DEFAULT 0.00
    AFTER ebook_price;

ALTER TABLE book_sales
    ADD COLUMN IF NOT EXISTS amazon_quantity INT UNSIGNED NOT NULL DEFAULT 0
    AFTER direct_quantity;