#1514: V8.0.1__RELEASE-RemoveMGC.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql Type: Flyway SQL Migration · Database: PostgreSQL · Source: projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql 169 lines · 164 code · 0 comments · 5 blank
Flyway database migration script for PostgreSQL. Contains SQL DDL/DML statements for schema evolution.
Table Alterations
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 Content
ALTER TABLE t_plugin_calendar_event ADD COLUMN original_ics_entry TEXT;
ALTER TABLE t_pf_history ALTER COLUMN createdat DROP NOT NULL; -- modifiedat is used instead.
ALTER TABLE t_pf_history ALTER COLUMN createdby DROP NOT NULL; -- modifiedby is used instead.
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 is used instead.
ALTER TABLE t_pf_history_attr ALTER COLUMN createdby DROP NOT NULL; -- parent.modifieby is used instead.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedat DROP NOT NULL; -- parent.modifiedat is used instead.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedby DROP NOT NULL; -- parent.modifieby is used instead.
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 without own flyway scripts:
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 History
f2226ef27 Setup tested.
4a2b8b991 Migration stuff in progress... (all tests of all packages: OK).
313bed1ec Merge remote-tracking branch 'origin/master' into mgc-remove