Tony CHEMIT pushed to branch develop at ultreiaio / ird-t3

Commits:

3 changed files:

Changes:

  • t3-domain/src/main/resources/db/migration/V2_0_14_add-harbour-ocean-link.sql
    ... ... @@ -19,4 +19,4 @@
    19 19 
     -- #L%
    20 20 
     ---
    21 21 
     ALTER TABLE Harbour ADD COLUMN ocean VARCHAR(255);
    22 
    -ALTER TABLE Harbour ADD CONSTRAINT fk_harbour_country FOREIGN KEY (ocean) REFERENCES Ocean(topiaid);
    22 
    +ALTER TABLE Harbour ADD CONSTRAINT fk_harbour_ocean FOREIGN KEY (ocean) REFERENCES Ocean(topiaid);

  • t3-domain/src/main/resources/db/migration/V3_0_01_add-Harbour-country-link.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- T3 :: Domain
    4 
    +-- %%
    5 
    +-- Copyright (C) 2010 - 2018 IRD, Code Lutin, Ultreia.io
    6 
    +-- %%
    7 
    +-- This program is free software: you can redistribute it and/or modify
    8 
    +-- it under the terms of the GNU Affero General Public License as published by
    9 
    +-- the Free Software Foundation, either version 3 of the License, or
    10 
    +-- (at your option) any later version.
    11 
    +--
    12 
    +-- This program is distributed in the hope that it will be useful,
    13 
    +-- but WITHOUT ANY WARRANTY; without even the implied warranty of
    14 
    +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    15 
    +-- GNU General Public License for more details.
    16 
    +--
    17 
    +-- You should have received a copy of the GNU Affero General Public License
    18 
    +-- along with this program.  If not, see <http://www.gnu.org/licenses/>.
    19 
    +-- #L%
    20 
    +---
    21 
    +ALTER TABLE Harbour ADD COLUMN country VARCHAR(255);
    22 
    +ALTER TABLE Harbour ADD CONSTRAINT fk_harbour_Country FOREIGN KEY (country) REFERENCES Country(topiaid);
    23 
    +
    24 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528740#0.8780508585333283' where code = 1;
    25 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.24216094850648695' where code = 2;
    26 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.11903016892439633' where code = 3;
    27 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 4;
    28 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 5;
    29 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 6;
    30 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113028#0.11467445384123376' where code = 7;
    31 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 8;
    32 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113029#0.8621983866234215' where code = 9;
    33 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528740#0.04603851706526396' where code = 10;
    34 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 11;
    35 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 14;
    36 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 16;
    37 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113028#0.11467445384123376' where code = 27;
    38 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 30;
    39 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 31;
    40 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528740#0.04603851706526396' where code = 38;
    41 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528741#0.7360505737754338' where code = 42;
    42 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528741#0.6225105985304237' where code = 43;
    43 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 44;
    44 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113033#0.5474507294589145' where code = 45;
    45 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113037#0.6515538789983367' where code = 48;
    46 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528742#0.061432903319870724' where code = 50;
    47 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528742#0.4712204602899017' where code = 54;
    48 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528742#0.4712204602899017' where code = 55;
    49 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 57;
    50 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 58;
    51 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.5504627641283989' where code = 70;
    52 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528741#0.6193885943455354' where code = 80;
    53 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 95;
    54 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 96;
    55 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 97;
    56 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 98;
    57 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 99;
    58 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 100;
    59 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 101;
    60 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113056#0.03837967322542368' where code = 102;
    61 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 103;
    62 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 104;
    63 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528743#0.7311735564355363' where code = 105;
    64 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113041#0.6156662257157167' where code = 107;
    65 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528741#0.6908104250386179' where code = 108;
    66 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528738#0.29786909155244845' where code = 109;
    67 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528739#0.021872879219458463' where code = 111;
    68 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1427896113017#0.3956845303354538' where code = 112;
    69 
    +UPDATE Harbour set country = 'fr.ird.t3.entities.reference.Country#1297580528741#0.6193885943455354' where code = 113;
    70 
    +

  • t3-domain/src/main/xmi/t3-persistence.zargo
    No preview for this file type

    • —
    View it on GitLab.
    You're receiving this email because of your account on gitlab.com. If you'd like to receive fewer emails, you can adjust your notification settings.