Changes between Version 19 and Version 20 of Cookbook CCM21_Europe

Timestamp:

Mar 10, 2011 11:50:55 AM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_Europe

@@ -184 +184 @@
 }}}
 ||!SeineNormandie||332670, 337665||A mettre dans area France||
+
+{{{
+---SeineNormandie
+insert into europe.wso(wso_id) values ('332670'),('337665'),('342310');
+UPDATE europe.wso set area='France' where area IS NULL;
+---Corse
+insert into europe.wso(wso_id) values ('263289'),('261207'),('261251');
+UPDATE europe.wso set area='France' where area IS NULL;
+---RMC
+insert into europe.wso(wso_id) values ('238201'),('434444'),('434159'),('433693'),('432880'),('432326'),('433584'),('434407'),('440607'),('432933');
+UPDATE europe.wso set area='France' where area IS NULL;
+---Garonne
+insert into europe.wso(wso_id) values ('394204');
+UPDATE europe.wso set area='France' where area IS NULL;
+---Bretagne
+insert into europe.wso(wso_id) values ('353376'),('352555');
+UPDATE europe.wso set area='France' where area IS NULL;
+}}}
+
+{{{
+delete from europe.wso where wso_id='291126' and area='Spain';
+delete from europe.wso where wso_id='442494' and area='Spain';
+delete from europe.wso where wso_id='445532' and area='Spain';
+delete from europe.wso where wso_id='510766' and area='Spain';
+delete from europe.wso where wso_id='442508' and area='Spain';
+delete from europe.wso where wso_id='129681' and area='Italy';
+delete from europe.wso where wso_id='129487' and area='RhoneMediterranee';
+delete from europe.wso where wso_id='442353' and area='RhoneMediterranee';
+insert into europe.wso(wso_id) values ('442529');
+UPDATE europe.wso set area='RhoneMediterranee' where area IS NULL;
+insert into uga2010.wso(wso_id) values ('442529');
+UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL;
+}}}