Changes between Version 11 and Version 12 of INTEGRATING operation

Timestamp:

Dec 7, 2010 2:30:23 PM (14 years ago)

Author:

celine

Comment:

--

INTEGRATING operation

@@ -98 +98 @@
  * Integrating operations from 4.WRBD_NDP_dbase Historical Lakes and all burr silvers 
 {{{
-copy wrbd.operation_op(op_folio_no,op_st_id,
+alter table wrbd.operation_op add column op_datasource character(30);
+alter table wrbd.operation_op add column op_nbdaysfishing numeric;
+alter table wrbd.operation_op add column op_nbnightsbeforelifting numeric;
+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_notrecorded,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 ';';