1 -- @tag: remove_terms_add_payment_id
2 -- @description: In betroffenen Tabellen die veraltete Spalte »terms« löschen und dort, wo sie fehlt, payment_id ergänzen
3 -- @depends: release_3_2_0
5 ALTER TABLE delivery_orders ADD COLUMN payment_id INTEGER;
6 ALTER TABLE delivery_orders ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
12 LEFT JOIN oe ON rl.from_id = oe.id
13 WHERE (rl.from_table = 'oe')
14 AND (rl.to_table = 'delivery_orders')
15 AND (rl.to_id = delivery_orders.id)
16 ORDER BY rl.itime DESC
20 ALTER TABLE ar DROP COLUMN terms;
21 ALTER TABLE customer DROP COLUMN terms;
22 ALTER TABLE delivery_orders DROP COLUMN terms;
23 ALTER TABLE vendor DROP COLUMN terms;