#1514: V8.0.1__RELEASE-RemoveMGC.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql Type : Migration Flyway SQL · Base de données : PostgreSQL · Source : projectforge-business/src/main/resources/flyway/migrate/postgresql/V8.0.1__RELEASE-RemoveMGC.sql 169 lignes · 164 code · 0 commentaires · 5 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_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
Contenu SQL
ALTER TABLE t_plugin_calendar_event ADD COLUMN original_ics_entry TEXT;
ALTER TABLE t_pf_history ALTER COLUMN createdat DROP NOT NULL; -- modifiedat est utilisé à la place.
ALTER TABLE t_pf_history ALTER COLUMN createdby DROP NOT NULL; -- modifiedby est utilisé à la place.
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 est utilisé à la place.
ALTER TABLE t_pf_history_attr ALTER COLUMN createdby DROP NOT NULL; -- parent.modifiedby est utilisé à la place.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedat DROP NOT NULL; -- parent.modifiedat est utilisé à la place.
ALTER TABLE t_pf_history_attr ALTER COLUMN modifiedby DROP NOT NULL; -- parent.modifiedby est utilisé à la place.
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 sans scripts flyway propres :
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;
Historique Git
f2226ef27 Configuration testée.
4a2b8b991 Migration en cours... (tous les tests de tous les packages : OK).
313bed1ec Fusion de la branche distante 'origin/master' dans mgc-remove