kivitendo/sql/Pg-upgrade2/letter_cleanup.sql @ bf5e6c6a
| 7196276b | Moritz Bunkus | -- @tag: letter_cleanup
|
|
-- @description: Tabelle »letter«: Unbenutzte Spalten entfernen und andere Spalten umbenennen
|
|||
-- @depends: release_3_4_0
|
|||
ALTER TABLE letter RENAME COLUMN vc_id TO customer_id;
|
|||
ALTER TABLE letter_draft RENAME COLUMN vc_id TO customer_id;
|
|||
ALTER TABLE letter
|
|||
DROP COLUMN close,
|
|||
DROP COLUMN company_name,
|
|||
DROP COLUMN employee_position,
|
|||
DROP COLUMN jobnumber,
|
|||
DROP COLUMN page_created_for,
|
|||
DROP COLUMN rcv_address,
|
|||
DROP COLUMN rcv_city,
|
|||
DROP COLUMN rcv_contact,
|
|||
DROP COLUMN rcv_country,
|
|||
DROP COLUMN rcv_countrycode,
|
|||
DROP COLUMN rcv_name,
|
|||
DROP COLUMN rcv_zipcode,
|
|||
DROP COLUMN salesman_position,
|
|||
DROP COLUMN text_created_for,
|
|||
ADD FOREIGN KEY (customer_id) REFERENCES customer (id);
|
|||
ALTER TABLE letter_draft
|
|||
DROP COLUMN close,
|
|||
DROP COLUMN company_name,
|
|||
DROP COLUMN employee_position,
|
|||
DROP COLUMN jobnumber,
|
|||
DROP COLUMN page_created_for,
|
|||
DROP COLUMN rcv_address,
|
|||
DROP COLUMN rcv_city,
|
|||
DROP COLUMN rcv_contact,
|
|||
DROP COLUMN rcv_country,
|
|||
DROP COLUMN rcv_countrycode,
|
|||
DROP COLUMN rcv_name,
|
|||
DROP COLUMN rcv_zipcode,
|
|||
DROP COLUMN salesman_position,
|
|||
DROP COLUMN text_created_for,
|
|||
ADD FOREIGN KEY (customer_id) REFERENCES customer (id);
|