#1506: V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql
projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql SQL-Migration, projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql 18 Zeilen · 15 Code · 0 Kommentare · 3 leer
Zweck: Flyway-Datenbankmigration: V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql. V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql ist Teil der Open-Source-Projektmanagement-Anwendung ProjectForge.
Quelle (erste 100 Zeilen)
ALTER TABLE T_ADDRESS ADD COLUMN image BOOLEAN;
ALTER TABLE T_ADDRESS ADD COLUMN image_last_update TIMESTAMP WITHOUT TIME ZONE;
CREATE TABLE T_ADDRESS_IMAGE (
pk INTEGER NOT NULL,
address_fk INTEGER NOT NULL,
last_update TIMESTAMP WITHOUT TIME ZONE,
image BYTEA,
image_preview BYTEA
);
ALTER TABLE T_ADDRESS_IMAGE
ADD CONSTRAINT t_address_image_pkey PRIMARY KEY (pk);
ALTER TABLE T_ADDRESS_IMAGE
ADD CONSTRAINT fk_address_image_address FOREIGN KEY (address_fk) REFERENCES t_address (pk);
CREATE INDEX idx_fk_t_address_image_address_fk
ON T_ADDRESS_IMAGE (address_fk);
Git-Verlauf
f99817436 Bilder von Adressen jetzt in separater Entität. Verbessert die Leistung durch verzögertes Laden, wenn viele Bilder verfügbar sind.
f99817436
Bilder von Adressen jetzt in separater Entität. Verbessert die Leistung durch verzögertes Laden, wenn viele Bilder verfügbar sind.
f99817436c3d846cd5f00b3e8ceef94232f69817
diff --git a/projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql b/projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql
new file mode 100644
index 000000000..19283c1c1
--- /dev/null
+++ b/projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql
@@ -0,0 +1,18 @@
+ALTER TABLE T_ADDRESS ADD COLUMN image BOOLEAN;
+ALTER TABLE T_ADDRESS ADD COLUMN image_last_update TIMESTAMP WITHOUT TIME ZONE;
+
+CREATE TABLE T_ADDRESS_IMAGE (
+ pk INTEGER NOT NULL,
+ address_fk INTEGER NOT NULL,
+ last_update TIMESTAMP WITHOUT TIME ZONE,
+ image BYTEA,
+ image_preview BYTEA
+);
+
+ALTER TABLE T_ADDRESS_IMAGE
+ ADD CONSTRAINT t_address_image_pkey PRIMARY KEY (pk);
+ALTER TABLE T_ADDRESS_IMAGE
+ ADD CONSTRAINT fk_address_image_address FOREIGN KEY (address_fk) REFERENCES t_address (pk);
+
+CREATE INDEX idx_fk_t_address_image_address_fk
+ ON T_ADDRESS_IMAGE (address_fk);