Changes between Version 4 and Version 5 of uga2010.wso1

Timestamp:

May 27, 2011 11:42:43 AM (14 years ago)

Author:

celine

Comment:

--

uga2010.wso1

@@ -107 +107 @@
     UPDATE uga2010.wso1 set uga='Meuse' where uga IS NULL; --888 lignes   
 }}}
+
+
+{{{
+ALTER TABLE uga2010.wso1 RENAME wso1_id TO wso1_idd
+ALTER TABLE uga2010.wso1 RENAME wso_id TO wso_idd
+ALTER TABLE uga2010.wso1 RENAME uga TO uga1
+
+drop view if exists uga2010.ugawso1
+CREATE VIEW uga2010.ugawso1 AS select * from ccm21.riversegments r inner join uga2010.wso1 u on u.wso1_idd=r.wso1_id
+}}}