Changes between Version 13 and Version 14 of INTEGRATING operation

Timestamp:

Dec 7, 2010 2:33:50 PM (14 years ago)

Author:

celine

Comment:

--

INTEGRATING operation

@@ -103 +103 @@
 alter table wrbd.operation_op add column op_silvereelcatchwt numeric;
 
-copy wrbd.operation_op(op_folio_no,op_st_id,op_date,op_year,op_datasource,op_equipment,op_nbnets,op_nbdaysfishing,op_nbnightsbeforelifting,op_glass,op_elver,op_yellow,op_silver,op_not_recorded,op_num_fishing,op_p1,op_p2,op_p3,op_p4,op_p5,op_distribution,op_main_survey_target,op_silvereelcatchwt) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Operation_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv header delimiter as ';';
+copy wrbd.operation_op(op_folio_no,op_st_id,op_date,op_year,op_datasource,op_equipment,op_nbnets,op_nbdaysfishing,op_nbnightsbeforelifting,op_glass,op_elver,op_yellow,op_silver,op_not_recorded,op_nb_pass,op_p1,op_p2,op_p3,op_p4,op_p5,op_distribution,op_main_survey_target,op_silvereelcatchwt) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Operation_4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv header delimiter as ';';