#1514: V8.0.1__RELEASE-RemoveMGC.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql Tipo: Migración SQL Flyway · Base de datos: PostgreSQL · Fuente: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql 169 líneas · 164 código · 0 comentarios · 5 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_plugin_calendar_event
ALTER TABLE t_pf_history
ALTER TABLE t_pf_history
ALTER TABLE t_pf_history
ALTER TABLE t_pf_history_attr
ALTER TABLE t_pf_history_attr
ALTER TABLE t_pf_history_attr
ALTER TABLE t_pf_history_attr
ALTER TABLE t_pf_history_attr
ALTER TABLE t_pf_history_attr
Contenido SQL
ALTER TABLE t_plugin_calendar_event ADD COLUMN original_ics_entry TEXT;
ALTER TABLE t_pf_history ALTER COLUMN createdat DROP NOT NULL; -- se usa modifiedat en su lugar.
ALTER TABLE t_pf_history ALTER COLUMN createdby DROP NOT NULL; -- se usa modifiedby en su lugar.
ALTER TABLE t_pf_history ALTER COLUMN updatecounter DROP NOT NULL;
ALTER TABLE t_pf_history_attr ALTER COLUMN value TYPE varchar(50000);
ALTER TABLE t_pf_history_attr ALTER COLUMN createdat DROP NOT NULL; -- se usa parent.modifiedat en su lugar.
ALTER TABLE t_pf_history_attr ALTER COLUMN createdby DROP NOT NULL; -- se usa parent.modifieby en su lugar.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedat DROP NOT NULL; -- se usa parent.modifiedat en su lugar.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedby DROP NOT NULL; -- se usa parent.modifieby en su lugar.
ALTER TABLE t_pf_history_attr ALTER COLUMN updatecounter DROP NOT NULL;
ALTER TABLE t_pf_history_attr ALTER COLUMN type DROP NOT NULL;
ALTER TABLE t_pf_history_attr ALTER COLUMN withdata DROP NOT NULL;
ALTER TABLE t_configuration ALTER COLUMN intvalue TYPE bigint;
ALTER TABLE t_configuration RENAME COLUMN intvalue TO longvalue;
-- Plugins sin scripts propios de flyway:
ALTER TABLE t_plugin_calendar_event ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_calendar_event ALTER COLUMN calendar_fk TYPE bigint;
ALTER TABLE t_plugin_calendar_event ALTER COLUMN team_event_fk_creator TYPE bigint;
ALTER TABLE t_plugin_calendar_event_attachment ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_calendar_event_attendee ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_calendar_event_attendee ALTER COLUMN address_id TYPE bigint;
ALTER TABLE t_plugin_calendar_event_attendee ALTER COLUMN user_id TYPE bigint;
ALTER TABLE t_plugin_liqui_entry ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_lm_license ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_marketing_address_campaign ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_marketing_address_campaign_value ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_marketing_address_campaign_value ALTER COLUMN address_fk TYPE bigint;
ALTER TABLE t_plugin_marketing_address_campaign_value ALTER COLUMN address_campaign_fk TYPE bigint;
ALTER TABLE t_plugin_memo ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_memo ALTER COLUMN owner_fk TYPE bigint;
ALTER TABLE t_plugin_todo ALTER COLUMN pk TYPE bigint;
ALTER TABLE t_plugin_todo ALTER COLUMN reporter_fk TYPE bigint;
ALTER TABLE t_plugin_todo ALTER COLUMN assignee_fk TYPE bigint;
Historial Git
f2226ef27 Configuración probada.
4a2b8b991 Trabajo de migración en curso... (todas las pruebas de todos los paquetes: OK).
313bed1ec Fusionar rama remota 'origin/master' en mgc-remove