#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 Migración SQL,
projectforge-business/src/main/resources/flyway/migrate/postgresql/V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql
18 líneas · 15 código · 0 comentarios · 3 en blanco
Propósito: Migración de base de datos Flyway: V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql. V7.0.0.20__7.0.0.20-RELEASE-AddressImages.sql es parte de la aplicación de gestión de proyectos de código abierto ProjectForge.
Fuente (primeras 100 líneas)
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);
Historial Git
f99817436 Las imágenes de las direcciones ahora están en una entidad separada. Mejora el rendimiento gracias a la carga diferida, si hay muchas imágenes disponibles.
f99817436
Las imágenes de las direcciones ahora están en una entidad separada. Mejora el rendimiento gracias a la carga diferida, si hay muchas imágenes 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);