[Opentaps-dataimport-commits] [dataimport commits] r43 - versions/0.9/trunk/script/mysql

[Leon T. <le...@gr...>]

Author: leon
Date: 2007-01-10 14:27:02 -0800 (Wed, 10 Jan 2007)
New Revision: 43

Modified:
   versions/0.9/trunk/script/mysql/importBOMExample.sql
Log:
Delete trivial self-referential entries

Modified: versions/0.9/trunk/script/mysql/importBOMExample.sql
===================================================================
--- versions/0.9/trunk/script/mysql/importBOMExample.sql	2007-01-10 00:55:34 UTC (rev 42)
+++ versions/0.9/trunk/script/mysql/importBOMExample.sql	2007-01-10 22:27:02 UTC (rev 43)
@@ -18,3 +18,6 @@
 PRODUCT_ASSOC_TYPE_ID = 'MANUF_COMPONENT',
 FROM_DATE = '2007-01-01 00:00:00.0',
 QUANTITY = @quantity
+;
+
+delete from PRODUCT_ASSOC where PRODUCT_ID = PRODUCT_ID_TO and PRODUCT_ASSOC_TYPE_ID = 'MANUF_COMPONENT' and FROM_DATE = '2007-01-01 00:00:00.0';