Changes between Version 5 and Version 6 of INTEGRATING fish

Timestamp:

Dec 6, 2010 2:02:19 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING fish

@@ -31 +31 @@
 alter table wrbd.fish_fi add column fi_id serial PRIMARY KEY;
 
--- pour aller rajouter les op_id dans la table poissons 
-select * from wrbd.operation_op order by op_date; -- un pb de date
-update wrbd.operation_op set op_date='2009-09-27' where op_date='0009-09-27'
-select * from wrbd.fish_fi left join (select * from wrbd.operation_op where op_nbtotal>0)as ope 
-on (fi_date,fi_st_id)=(ope.op_date,ope.op_st_id)  ; --2357
-select count(*) from wrbd.fish_fi; -- 2208
--- voir les changements dans operation pour règler le pb de jointure
+-- pour aller rajouter les op_id dans la table poissons ticket #75
+
 }}}