7 lines
246 B
SQL
7 lines
246 B
SQL
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; |