Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe
Commits:
-
8b1395f1
by Tony Chemit at 2022-02-15T12:20:06+01:00
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:
| ... | ... | @@ -25,8 +25,8 @@ ALTER TABLE ll_common.Trip ADD COLUMN logbookProgram VARCHAR(255); |
| 25 | 25 | ALTER TABLE ps_common.Trip ADD COLUMN observationsProgram VARCHAR(255);
|
| 26 | 26 | ALTER TABLE ps_common.Trip ADD COLUMN logbookProgram VARCHAR(255);
|
| 27 | 27 | |
| 28 | -UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), logbookProgram = '${Program_LL_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 29 | -UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), logbookProgram = '${Program_PS_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 28 | +UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 29 | +UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 30 | 30 | |
| 31 | 31 | ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_observationsProgram FOREIGN KEY(observationsProgram) REFERENCES ll_common.Program;
|
| 32 | 32 | ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_logbookProgram FOREIGN KEY(logbookProgram) REFERENCES ll_common.Program;
|
| ... | ... | @@ -25,8 +25,8 @@ ALTER TABLE ll_common.Trip ADD COLUMN logbookProgram VARCHAR(255); |
| 25 | 25 | ALTER TABLE ps_common.Trip ADD COLUMN observationsProgram VARCHAR(255);
|
| 26 | 26 | ALTER TABLE ps_common.Trip ADD COLUMN logbookProgram VARCHAR(255);
|
| 27 | 27 | |
| 28 | -UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), logbookProgram = '${Program_LL_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 29 | -UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), logbookProgram = '${Program_PS_9}', topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 28 | +UPDATE ll_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ll.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 29 | +UPDATE ps_common.Trip SET observationsProgram = REPLACE(program, '.common.', '.ps.common.'), topiaVersion = topiaVersion + 1, lastUpdateDate = ${CURRENT_TIMESTAMP};
|
|
| 30 | 30 | |
| 31 | 31 | ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_observationsProgram FOREIGN KEY(observationsProgram) REFERENCES ll_common.Program;
|
| 32 | 32 | ALTER TABLE ll_common.Trip ADD CONSTRAINT fk_ll_common_Trip_logbookProgram FOREIGN KEY(logbookProgram) REFERENCES ll_common.Program;
|