#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 Tipo: Migración SQL Flyway · Base de datos: PostgreSQL · Fuente: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.11__RELEASE_remove_old_tables.sql 121 líneas · 119 código · 0 comentarios · 2 en blanco
Script de migración de base de datos Flyway para PostgreSQL. Contiene sentencias SQL DDL/DML para la evolución del esquema.
Alteraciones de tablas
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
Contenido SQL
-- Eliminar tablas antiguas:
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;
-- Esta tabla debe eliminarse más adelante (la usan los plugins) DROP TABLE IF EXISTS t_tenant;
-- t_tenant se eliminó y ya no se usa, eliminar:
-- No eliminarla ahora, primero deben manejarse todas las restricciones (ej. 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
Historial Git
63cc65ae0 Cosas de Flyway, Employee.timed-attrs