#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 Migration SQL, projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql 18 lignes · 15 code · 0 commentaires · 3 vides
Objectif : Migration de base de données Flyway : V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql. V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql fait partie de l'application open-source de gestion de projet ProjectForge.
Source (100 premières lignes)
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);
Historique Git
f99817436 Les images des adresses sont désormais dans une entité séparée. Améliore les performances grâce au chargement différé, si un grand nombre d'images sont disponibles.
f99817436
Les images des adresses sont désormais dans une entité séparée. Améliore les performances grâce au chargement différé, si un grand nombre d'images sont disponibles.
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);