Changes between Version 22 and Version 23 of Cookbook CCM21_Europe

Timestamp:

Mar 18, 2011 4:22:29 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_Europe

@@ -219 +219 @@
 delete from europe.wso where wso_id='291112' and area='Italy';
 delete from europe.wso where wso_id='442529' and area='Spain';
-delete from europe.wso where wso_id='130439' and area='Italy';
+delete from uga2010.wso where wso_id='130439' and uga='RhoneMediterranee';
+delete from europe.wso where wso_id='130439' and area='France';
+delete from europe.wso where wso_id='130439' and area='RhoneMediterranee';
 insert into europe.wso(wso_id) values ('130439');
-UPDATE europe.wso set area='France' where area IS NULL;
+UPDATE europe.wso set area='Italy' where area IS NULL;
 delete from uga2010.wso where wso_id='442353' and uga='RhoneMediterranee';
 }}}