Changes between Version 35 and Version 36 of INTEGRATING fish

Timestamp:

Dec 13, 2010 2:42:41 PM (14 years ago)

Author:

cedric

Comment:

--

INTEGRATING fish

@@ -322 +322 @@
 update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(9,2,2,13,0.003,20) where op_id=14;
 update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(0,2,0,2,0.007,2) where op_id=2;
-update wrbd.operation_op set (op_p1,op_p2,op_p3,op_nbtotal,op_density,op_totalestim) =(17,15,3,35,0.097,49) where op_id=5;
-}}}
+update wrbd.operation_op set (op_p1,op_p2,op_p3,op
+_nbtotal,op_density,op_totalestim) =(17,15,3,35,0.097,49) where op_id=5;
+}}}
+
+Adding a constraint
+
+{{{
+alter table wrbd.fish_fi add  CONSTRAINT c_fk_fi_op_id FOREIGN KEY (fi_op_id)
+      REFERENCES wrbd.operation_op (op_id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+}}}