10 lines
251 B
SQL
10 lines
251 B
SQL
ALTER TABLE invoices
|
|
ADD COLUMN amount_invoiced DECIMAL(10,2) NOT NULL,
|
|
ADD COLUMN amount_received DECIMAL(10,2) NOT NULL,
|
|
ADD COLUMN comments TEXT;
|
|
|
|
ALTER TABLE invoices
|
|
DROP COLUMN amount_invoiced,
|
|
DROP COLUMN amount_received,
|
|
DROP COLUMN comments;
|