10 lines
251 B
MySQL
10 lines
251 B
MySQL
|
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;
|