#1511: V8.0.11__RELEASE_remove_old_tables.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.11__RELEASE_remove_old_tables.sql Typ: Flyway SQL-Migration · Datenbank: PostgreSQL · Quelle: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.11__RELEASE_remove_old_tables.sql 121 Zeilen · 119 Code · 0 Kommentare · 2 Leerzeilen
Flyway-Datenbankmigrationsskript für PostgreSQL. Enthält SQL-DDL/DML-Anweisungen für die Schemaentwicklung.
Tabellenänderungen
ALTER TABLE t_address
ALTER TABLE t_addressbook
ALTER TABLE t_book
ALTER TABLE t_calendar
ALTER TABLE t_calendar_event
ALTER TABLE t_configuration
ALTER TABLE t_contract
ALTER TABLE t_employee_leave_account_entry
ALTER TABLE t_employee_remaining_leave
ALTER TABLE t_employee_vacation
SQL-Inhalt
-- Alte Tabellen entfernen:
DROP TABLE IF EXISTS t_plugin_poll_result;
DROP TABLE IF EXISTS t_plugin_poll_attendee;
DROP TABLE IF EXISTS t_plugin_skill_rating;
DROP TABLE IF EXISTS t_plugin_skill_training_attendee;
DROP TABLE IF EXISTS t_plugin_skill_training;
DROP TABLE IF EXISTS t_plugin_skill;
DROP TABLE IF EXISTS t_plugin_financialfairplay_accounting;
DROP TABLE IF EXISTS t_plugin_financialfairplay_debt;
DROP TABLE IF EXISTS t_plugin_financialfairplay_event_attendee;
DROP TABLE IF EXISTS t_plugin_financialfairplay_event;
DROP TABLE IF EXISTS t_plugin_poll_event;
DROP TABLE IF EXISTS t_plugin_poll;
DROP TABLE IF EXISTS t_imported_meb_entry;
DROP TABLE IF EXISTS t_meb_entry;
DROP TABLE IF EXISTS t_plugin_employee_configuration_attrdata;
DROP TABLE IF EXISTS t_plugin_employee_configuration_attr;
DROP TABLE IF EXISTS t_plugin_employee_configuration_timedattrdata;
DROP TABLE IF EXISTS t_plugin_employee_configuration_timedattr;
DROP TABLE IF EXISTS t_plugin_employee_configuration_timed;
DROP TABLE IF EXISTS t_plugin_employee_configuration;
DROP TABLE IF EXISTS tb_base_ghistory_attr_data;
DROP TABLE IF EXISTS tb_base_ghistory_attr;
DROP TABLE IF EXISTS tb_base_ghistory;
DROP TABLE IF EXISTS t_personal_contact;
DROP TABLE IF EXISTS t_contactentry;
DROP TABLE IF EXISTS t_contact;
DROP TABLE IF EXISTS t_employee_vacation_calendar;
DROP TABLE IF EXISTS t_plugin_bank_account_balance;
DROP TABLE IF EXISTS t_plugin_bank_account_record;
DROP TABLE IF EXISTS t_plugin_bank_account;
DROP TABLE IF EXISTS t_plugin_plugintemplate;
DROP TABLE IF EXISTS t_tenant_user;
-- Diese Tabelle muss später entfernt werden (wird von Plugins verwendet) DROP TABLE IF EXISTS t_tenant;
-- t_tenant ist entfernt und nicht mehr in Verwendung, daher löschen:
-- Jetzt noch nicht löschen, alle Constraints müssen zuerst behandelt werden (z.B. t_address.unique(tenant_id, uid)):
-- ALTER TABLE t_address DROP COLUMN tenant_id;
-- ALTER TABLE t_addressbook DROP COLUMN tenant_id;
-- ALTER TABLE t_book DROP COLUMN tenant_id;
-- ALTER TABLE t_calendar DROP COLUMN tenant_id;
-- ALTER TABLE t_calendar_event DROP COLUMN tenant_id;
-- ALTER TABLE t_configuration DROP COLUMN tenant_id;
-- ALTER TABLE t_contract DROP COLUMN tenant_id;
-- ALTER TABLE t_employee_leave_account_entry DROP COLUMN tenant_id;
-- ALTER TABLE t_employee_remaining_leave
Git-Verlauf
63cc65ae0 Flyway-Sachen, Employee.timed-attrs