EN · DE · RU · FR · ES
← Index · ← File index · ← Prev · Next → · 📄 source

#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 lines · 15 code · 0 comments · 3 blank
Purpose: Flyway database migration: V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql. V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql is part of the ProjectForge open-source project management application.

Source (first 100 lines)

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 History

f99817436 Images of addresses now in separate entity. Improves the performance due to lazy loading, if a lot of images are available.


f99817436

Images of addresses now in separate entity. Improves the performance due to lazy loading, if a lot of images are available.

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);