12 lines
817 B
SQL
12 lines
817 B
SQL
-- Update amount columns to 3 decimal places
|
|
ALTER TABLE customers MODIFY COLUMN balance DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE stock_items MODIFY COLUMN purchase_price DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE stock_items MODIFY COLUMN sale_price DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoices MODIFY COLUMN total_amount DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoices MODIFY COLUMN vat_amount DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoices MODIFY COLUMN total_with_vat DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoices MODIFY COLUMN paid_amount DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoice_items MODIFY COLUMN unit_price DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE invoice_items MODIFY COLUMN total_price DECIMAL(15,3) DEFAULT 0.000;
|
|
ALTER TABLE payments MODIFY COLUMN amount DECIMAL(15,3) DEFAULT 0.000;
|