#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 : Migration Flyway SQL · Base de données : PostgreSQL · Source : projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.11__RELEASE_remove_old_tables.sql 121 lignes · 119 code · 0 commentaires · 2 vides
Script de migration de base de données Flyway pour PostgreSQL. Contient des instructions SQL DDL/DML pour l'évolution du schéma.
Modifications de tables
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
Contenu SQL
-- Suppression des anciennes 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;
-- Cette table doit être supprimée plus tard (utilisée par les plugins) DROP TABLE IF EXISTS t_tenant;
-- t_tenant est supprimée et n'est plus utilisée, on la supprime :
-- Ne pas la supprimer maintenant, toutes les contraintes doivent d'abord être traitées (ex : 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
Historique Git
63cc65ae0 Flyway stuff, Employee.timed-attrs