Changes between Version 14 and Version 15 of INTEGRATING fish

Timestamp:

Dec 6, 2010 3:23:32 PM (14 years ago)

Author:

celine

Comment:

--

INTEGRATING fish

@@ -43 +43 @@
 {{{
 ALTER TABLE wrbd.fish_fi ADD COLUMN fi_op_nbdays integer;
-copy wrbd.fish_fi(fi_folio_no,fi_st_id,fi_fishid,fi_date,fi_year,fi_individual_life,fi_retained,fi_length,fi_op_nbdays) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv delimiter as ';' header ; 
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_weight numeric;
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_eye_diameter numeric;
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_black_spots_on_lateral_line character(10);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_colour character(10);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_metallic_colour character(10);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_pectoral_fin_length numeric;
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_measured_live_or_frozen character(10);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_sexe character(20);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_age character(20);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_pigment_stage character(20);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_anguillicola character(20);
+ALTER TABLE wrbd.fish_fi ADD COLUMN fi_anguillicola_nos numeric;
+
+
+
+
+copy wrbd.fish_fi(fi_folio_no,fi_st_id,fi_fishid,fi_date,fi_year,fi_individual_life,fi_retained,fi_length,fi_weight,fi_eye_diameter,fi_black_spots_on_lateral_line,fi_colour,fi_metallic_colour,fi_pectoral_fin_length_fi_measured_live_or_frozen,fi_sexe,fi_age,fi_pigment_stage,fi_anguillicola,fi_anguillicola_nos,fi_op_nbdays) from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/4.WRBD_NDP_dbase_Historical_Lakes_and_all_burr_silvers.csv' with csv delimiter as ';' header ; 
 }}}