Changeset 23776 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Apr 9, 2009, 1:54:17 PM (17 years ago)

Author:

bills

Message:

remove prod_id from rcInterest

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1271 +1271 @@
     dest_id     BIGINT,
     target_id   BIGINT,
-    prod_id     BIGINT,
     state       VARCHAR(64),
     PRIMARY KEY(int_id),
     FOREIGN KEY(dest_id) REFERENCES rcDestination(dest_id),
     FOREIGN KEY(target_id) REFERENCES distTarget(target_id),
-    FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;