e7f619f7c V7.0.0.3_*RELEASE.sql: Misplaced spaces removed.
3f70598d3 New CalEvent now usable on demand (config value calendar.useNewCalendarEvents=true). Flyway migration scripts added for creating new table t_calendar_events.
cb88d9344 V7.0.0.3*.sql prepared.
e7f619f7c
V7.0.0.3_*RELEASE.sql: Misplaced spaces removed.e7f619f7c63194308128a905a9590e60c25c9c09
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
index 2cdb3049b..44aa935ab 100644
--- a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
@@ -11,7 +11,7 @@ CREATE TABLE t_calendar_event (
start_date TIMESTAMP WITHOUT TIME ZONE,
tenant_id INTEGER,
calendar_fk INTEGER NOT NULL,
- uid CHARACTER VARYING(1000) ,
+ uid CHARACTER VARYING(1000),
ics CHARACTER VARYING(10000),
subject CHARACTER VARYING(1000),
location CHARACTER VARYING(1000),
3f70598d3
New CalEvent now usable on demand (config value calendar.useNewCalendarEvents=true). Flyway migration scripts added for creating new table t_calendar_events.3f70598d3e106c8b9de487bfa5a3e54abeceb110
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
index e76a5dca7..2cdb3049b 100644
--- a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
@@ -1,42 +1,46 @@
-- T_CALENDAR
---CREATE TABLE t_calendar_event (
--- pk INTEGER NOT NULL,
--- created TIMESTAMP WITHOUT TIME ZONE,
--- deleted BOOLEAN NOT NULL,
--- last_update TIMESTAMP WITHOUT TIME ZONE,
--- all_day BOOLEAN,
--- end_date TIMESTAMP WITHOUT TIME ZONE,
--- start_date TIMESTAMP WITHOUT TIME ZONE,
--- tenant_id INTEGER,
--- calendar_id INTEGER NOT NULL,
--- uid CHARACTER VARYING(255) NOT NULL,
--- dt_stamp TIMESTAMP WITHOUT TIME ZONE,
--- ownership BOOLEAN
---);
-
---ALTER TABLE t_calendar_event
--- ADD CONSTRAINT t_calendar_event_pkey PRIMARY KEY (pk);
-
---ALTER TABLE t_calendar_event
--- ADD CONSTRAINT unique_t_calendar_event_uid_calendar_fk UNIQUE (uid, calendar_fk);
-
---CREATE INDEX idx_fk_t_calendar_event_calendar_fk
--- ON t_calendar_event (calendar_id);
-
---CREATE INDEX idx_fk_t_calendar_event_tenant_id
--- ON t_calendar_event (tenant_id);
-
---CREATE INDEX idx_cal_end_date
--- ON tcalendar_event (calendar_id, end_date);
-
---CREATE INDEX idx_cal_start_date
--- ON t_calendar_event (calendar_id, start_date);
-
---CREATE INDEX idx_cal_time
--- ON t_calendar_event (calendar_id, start_date, end_date);
-
---ALTER TABLE t_calendar_event
--- ADD CONSTRAINT t_calendar_event_tenant_fk FOREIGN KEY (tenant_id) REFERENCES t_tenant (pk);
-
---ALTER TABLE t_calendar_event
--- ADD CONSTRAINT t_calendar_event_calendar_fk FOREIGN KEY (calendar_id) REFERENCES t_calendar (pk);
+alter table t_plugin_calendar rename to t_calendar;
+
+CREATE TABLE t_calendar_event (
+ pk INTEGER NOT NULL,
+ created TIMESTAMP WITHOUT TIME ZONE,
+ deleted BOOLEAN NOT NULL,
+ last_update TIMESTAMP WITHOUT TIME ZONE,
+ allday BOOLEAN,
+ end_date TIMESTAMP WITHOUT TIME ZONE,
+ start_date TIMESTAMP WITHOUT TIME ZONE,
+ tenant_id INTEGER,
+ calendar_fk INTEGER NOT NULL,
cb88d9344
V7.0.0.3*.sql prepared.cb88d93440ad3e88691d4baeaecbac988a446533
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
new file mode 100644
index 000000000..e76a5dca7
--- /dev/null
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.3__7.0.0.3-RELEASE.sql
@@ -0,0 +1,42 @@
+-- T_CALENDAR
+--CREATE TABLE t_calendar_event (
+-- pk INTEGER NOT NULL,
+-- created TIMESTAMP WITHOUT TIME ZONE,
+-- deleted BOOLEAN NOT NULL,
+-- last_update TIMESTAMP WITHOUT TIME ZONE,
+-- all_day BOOLEAN,
+-- end_date TIMESTAMP WITHOUT TIME ZONE,
+-- start_date TIMESTAMP WITHOUT TIME ZONE,
+-- tenant_id INTEGER,
+-- calendar_id INTEGER NOT NULL,
+-- uid CHARACTER VARYING(255) NOT NULL,
+-- dt_stamp TIMESTAMP WITHOUT TIME ZONE,
+-- ownership BOOLEAN
+--);
+
+--ALTER TABLE t_calendar_event
+-- ADD CONSTRAINT t_calendar_event_pkey PRIMARY KEY (pk);
+
+--ALTER TABLE t_calendar_event
+-- ADD CONSTRAINT unique_t_calendar_event_uid_calendar_fk UNIQUE (uid, calendar_fk);
+
+--CREATE INDEX idx_fk_t_calendar_event_calendar_fk
+-- ON t_calendar_event (calendar_id);
+
+--CREATE INDEX idx_fk_t_calendar_event_tenant_id
+-- ON t_calendar_event (tenant_id);
+
+--CREATE INDEX idx_cal_end_date
+-- ON tcalendar_event (calendar_id, end_date);
+
+--CREATE INDEX idx_cal_start_date
+-- ON t_calendar_event (calendar_id, start_date);
+
+--CREATE INDEX idx_cal_time
+-- ON t_calendar_event (calendar_id, start_date, end_date);
+
+--ALTER TABLE t_calendar_event
+-- ADD CONSTRAINT t_calendar_event_tenant_fk FOREIGN KEY (tenant_id) REFERENCES t_tenant (pk);
+
+--ALTER TABLE t_calendar_event
+-- ADD CONSTRAINT t_calendar_event_calendar_fk FOREIGN KEY (calendar_id) REFERENCES t_calendar (pk);