Changes between Version 10 and Version 11 of CookBook RHT_UGA

Timestamp:

Nov 4, 2011 10:44:45 AM (13 years ago)

Author:

celine

Comment:

--

CookBook RHT_UGA

@@ -116 +116 @@
 {{{
 #!sql
-insert into uga2010.id_drain(gid,id_drain,uga) values ('3067','3224','RhoneMediterranee'),('11638','11467','RhoneMediterranee'),('22455','22419','RhoneMediterranee'),('24629','24470','Corse'),('26919','26772','Corse'),('71671','501772','Rhin');   -- 6 lignes
+insert into uga2010.id_drain(gid,id_drain,uga) values ('3067','3224','Rhone-Mediterranee'),('11638','11467','Rhone-Mediterranee'),('22455','22419','Rhone-Mediterranee'),('24629','24470','Corse'),('26919','26772','Corse'),('71671','501772','Rhin');   -- 6 lignes
 insert into uga2010.id_drain(gid,id_drain) values ('51479','301049'),('53501','303129'),('53521','303155'),('53471','303111'),('53481','303125'),('53531','303174'),('53571','303204'),('53695','303128'),('53710','303381'),('54108','303716'),('55321','304896'),('56267','305902'),('56268','305940'),('57509','307077'),('57623','307258'),('57860','307371'),('61605','311335'),('61606','311248'),('61639','311340'),('61759','311471'),('61766','311476'),('61767','311394'),('61885','311500'),('61904','311604'),('61922','311676'),('61924','311490'),('61925','311640'),('61939','311667');
 UPDATE uga2010.id_drain set uga='Seine-Normandie' where uga IS NULL; --28 lignes