Changeset 23776 for trunk/dbconfig

Timestamp:

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

Author:

bills

Message:

remove prod_id from rcInterest

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• rc.md (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