|
-- @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);
|