Changes between Version 14 and Version 15 of model building

Timestamp:

May 21, 2010 4:23:30 PM (15 years ago)

Author:

cedric

Comment:

--

model building

@@ -36 +36 @@
 }}} 
  * The idea __here__ is to have some variables describing the variation in ''' recruitment '''
- * The sea_cd => this one is obvious, and will describe varying recruitments into the Baltic, the Mediterranean, North sea
-  
-[[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg)]]
+ * The sea_cd => this one is obvious, and will describe varying recruitments into the Baltic, the Mediterranean, North sea, unfortunately sea_cd is repeated and probably needs grouping with other variable 
+ [[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg)]] [[BR]]
+This will create a new column in ccm21.seoutlets
+{{{
+#!sql
+ALTER TABLE ccm21.seaoutlets ADD COLUMN area_cd character varying(3);
+UPDATE ccm21.seaoutlets set area_cd= system_cd||sea_cd;
+}}}