Changes between Version 6 and Version 7 of INTEGRATING stations

Timestamp:

Dec 6, 2010 11:34:34 AM (14 years ago)

Author:

celine

Comment:

--

INTEGRATING stations

@@ -124 +124 @@
 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 ';'  ; 
+-- 966 lines
 
 alter table wrbd.operation_op add column op_nbsets numeric;
@@ -131 +132 @@
 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;
@@ -142 +142 @@
 copy wrbd.operation_op(op_st_id,op_year,op_equipment,op_area,op_nbsets,op_nb_pass,op_density,op_totalestim,op_totalweight,op_total,op_nbfem,op_nbmal,op_nbimmat) from 'C:/base/8WFD_river_survey_operations.csv' with csv delimiter as ';' header ; 
 copy wrbd.operation_op from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/8WFD_river_survey_operations.csv' with csv delimiter as ';'  ; 
+--984 lines
 
 alter table wrbd.operation_op add column op_id serial;