#1514: V8.0.1__RELEASE-RemoveMGC.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql Typ: Flyway-SQL-Migration · Datenbank: PostgreSQL · Quelle: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql 169 Zeilen · 164 Code · 0 Kommentare · 5 Leerzeilen
Flyway-Datenbankmigrationsskript für PostgreSQL. Enthält SQL-DDL/DML-Anweisungen für die Schemaentwicklung.
Tabellenänderungen
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
SQL-Inhalt
ALTER TABLE t_plugin_calendar_event ADD COLUMN original_ics_entry TEXT;
ALTER TABLE t_pf_history ALTER COLUMN createdat DROP NOT NULL; -- modifiedat wird stattdessen verwendet.
ALTER TABLE t_pf_history ALTER COLUMN createdby DROP NOT NULL; -- modifiedby wird stattdessen verwendet.
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; -- parent.modifiedat wird stattdessen verwendet.
ALTER TABLE t_pf_history_attr ALTER COLUMN createdby DROP NOT NULL; -- parent.modifiedby wird stattdessen verwendet.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedat DROP NOT NULL; -- parent.modifiedat wird stattdessen verwendet.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedby DROP NOT NULL; -- parent.modifiedby wird stattdessen verwendet.
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 ohne eigene Flyway-Skripte:
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;
Git-Verlauf
f2226ef27 Setup getestet.
4a2b8b991 Migration in Arbeit... (alle Tests aller Pakete: OK).
313bed1ec Merge-Remote-Branch 'origin/master' in mgc-remove