Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 8b1395f1 by Tony Chemit at 2022-02-15T12:20:06+01:00 Ne pas renseigner Trip.logbookProgram lors de la migration v7 → v9 - Closes #2163 - - - - - 2 changed files: - core/persistence/resources/src/main/resources/db/migration/v9/9.0/01_2_adapt_program-H2.sql - core/persistence/resources/src/main/resources/db/migration/v9/9.0/01_2_adapt_program-PG.sql Changes: ===================================== core/persistence/resources/src/main/resources/db/migration/v9/9.0/01_2_adapt_program-H2.sql ===================================== @@ -25,8 +25,8 @@ ALTER TABLE ll_common.Trip ADD COLUMN logbookProgram VARCHAR(255); ALTER TABLE ps_common.Trip ADD COLUMN observationsProgram VARCHAR(255); ALTER TABLE ps_common.Trip ADD COLUMN logbookProgram VARCHAR(255); -UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), logbookProgram = '${Program_LL_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; -UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), logbookProgram = '${Program_PS_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; +UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; +UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_observationsProgram FOREIGN KEY(observationsProgram) REFERENCES ll_common.Program; ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_logbookProgram FOREIGN KEY(logbookProgram) REFERENCES ll_common.Program; ===================================== core/persistence/resources/src/main/resources/db/migration/v9/9.0/01_2_adapt_program-PG.sql ===================================== @@ -25,8 +25,8 @@ ALTER TABLE ll_common.Trip ADD COLUMN logbookProgram VARCHAR(255); ALTER TABLE ps_common.Trip ADD COLUMN observationsProgram VARCHAR(255); ALTER TABLE ps_common.Trip ADD COLUMN logbookProgram VARCHAR(255); -UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), logbookProgram = '${Program_LL_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; -UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), logbookProgram = '${Program_PS_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; +UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; +UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP}; ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_observationsProgram FOREIGN KEY(observationsProgram) REFERENCES ll_common.Program; ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_logbookProgram FOREIGN KEY(logbookProgram) REFERENCES ll_common.Program; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/8b1395f1296b1b16a7e39c04d8... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/8b1395f1296b1b16a7e39c04d8... You're receiving this email because of your account on gitlab.com.