Changes between Initial Version and Version 1 of Bd_carthage_BV

Timestamp:

May 10, 2012 5:35:26 PM (13 years ago)

Author:

celine

Comment:

--

Bd_carthage_BV

@@ +1 @@
+back to first page[..][[BR]]
+
+{{{
+#!sql
+alter table bd_carthage2011.sous_secteur add column bv character varying(20);
+update bd_carthage2011.sous_secteur set bv='Autre' where bv is null;
+update bd_carthage2011.sous_secteur set bv='Hérault' where c_ss_sect in ('Y23','Y21','Y22','Y20');
+update bd_carthage2011.sous_secteur set bv='Arc-Touloubre' where c_ss_sect in ('Y40','Y41','Y42');
+update bd_carthage2011.sous_secteur set bv='Vilaine-Oust' where c_ss_sect in ('J70','J71','J72','J73','J74','J75','J76','J77','J78','J79','J80','J81','J82','J83','J84','J85','J86','J87','J88','J93','J90','J92','J91');
+
+alter table bd_carthage2011.zone_hydrographique add column bv character varying(20);
+update bd_carthage2011.zone_hydrographique set bv='Autre' where bv is null;
+update bd_carthage2011.zone_hydrographique set bv='Hérault' where code_zone in ('Y200','Y201','Y202','Y203','Y210','Y211','Y212','Y213','Y214','Y220','Y221','Y222','Y223','Y224','Y230','Y231','Y233','Y234','Y232','Y235',
+'Y236','Y237','Y300');
+}}}