Changeset 23776

Timestamp:

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

Author:

bills

Message:

remove prod_id from rcInterest

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• dbconfig/rc.md (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -993 +993 @@
 
 -- Version 1.1.52
+
+-- drop unneeded column and the associated constraint
+ALTER TABLE rcInterest DROP FOREIGN KEY rcInterest_ibfk_3;
+ALTER TABLE rcInterest DROP COLUMN prod_id;
+
+

trunk/dbconfig/rc.md

@@ -30 +30 @@
     int_id      S64         0       # Primary Key
     dest_id     S64         0       # fkey(dest_id) ref rcDestination(dest_id)
-    prod_id     S64         0       # fkey(prod_id) ref rcDSProduct(prod_id)
     name        STR         64
     state       STR         64

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;