#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 Type: Flyway SQL Migration · Database: PostgreSQL · Source: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.11__RELEASE_remove_old_tables.sql 121 lines · 119 code · 0 comments · 2 blank
Flyway database migration script for PostgreSQL. Contains SQL DDL/DML statements for schema evolution.
Table Alterations
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 Content
-- Remove old tables:
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;
-- Must remove this table later (is used by plugins) DROP TABLE IF EXISTS t_tenant;
-- t_tenant is removed and not in use anymore, drop it:
-- Don't drop it now, all constraints must be handled first (e.g. 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 History
63cc65ae0 Flyway stuff, Employee.timed-attrs