Changes between Version 43 and Version 44 of WRBD

Timestamp:

Dec 3, 2010 4:50:08 PM (14 years ago)

Author:

cedric

Comment:

--

WRBD

@@ -329 +329 @@
 );
 
-
+alter table wrbd.operation_op add column op_nb_sets numeric;
+alter table wrbd.operation_op rename column op_num_fishing  to op_nb_pass;
+alter table wrbd.operation_op add column op_density numeric;
+alter table wrbd.operation_op add column op_equipment character varying(40);
+update wrbd.operation_op set op_equipment='Handset';
+alter table wrbd.operation_op rename column op_num_fishing  to op_nb_pass;
+alter table  wrbd.operation_op add column op_nbfem integer;
+alter table  wrbd.operation_op add column op_nbmal integer;
+alter table  wrbd.operation_op add column op_nbind integer;
 copy wrbd.operation_op from 'C:/base/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ; 
 copy wrbd.operation_op from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Operation_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';'  ;