| ... |
... |
@@ -66,6 +66,9 @@ INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, l |
|
66
|
66
|
INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, label1, label2, label3) values ('fr.ird.referential.common.WeightMeasureMethod#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Visual estimate', 'Estimation visuelle', 'Estimación visual');
|
|
67
|
67
|
INSERT INTO common.WeightMeasureMethod(topiaId, topiaVersion, topiaCreateDate, lastUpdateDate, status, needComment, label1, label2, label3) values ('fr.ird.referential.common.WeightMeasureMethod#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Estimate with sounder', 'Estimation au sondeur', 'Estimación con la ecosonda');
|
|
68
|
68
|
|
|
|
69
|
+INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, homeid, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8, iso2code, iso3code) VALUES ('fr.ird.referential.common.Country#1609197326325#0.9797981297337345', 1, '2020-12-28 23:13:40.571', '2020-12-28 23:15:26.372', '92', null, null, 'f', 1, 'Philippines', 'Philippines', 'Filipinas', null, null, null, null, null, 'PH', 'PHL');
|
|
|
70
|
+INSERT INTO common.country(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, homeid, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8, iso2code, iso3code) VALUES ('fr.ird.referential.common.Country#1609197447702#0.5128194152482344', 1, '2020-12-28 23:16:24.312', '2020-12-28 23:17:27.702', '93', null, null, 'f', 1, 'Oman', 'Oman', 'Omán', null, null, null, null, null, 'OM', 'OMN');
|
|
|
71
|
+
|
|
69
|
72
|
UPDATE common.country SET iso2code = 'MR', iso3code = 'MRT', topiaVersion = topiaVersion + 1, lastUpdateDate = '2019-01-15 00:00:00.0' WHERE topiaId = 'fr.ird.referential.common.Country#1464000000000#0.00054';
|
|
70
|
73
|
UPDATE common.country SET iso2code = 'PR', iso3code = 'PRI', topiaVersion = topiaVersion + 1, lastUpdateDate = '2019-01-15 00:00:00.0' WHERE topiaId = 'fr.ird.referential.common.Country#1464000000000#0.00076';
|
|
71
|
74
|
|