[vwnc] Store foreign key constraints

To detect Store insert errors I'd like to add foreign key constraints
wherever possible.  I'm wondering if inside Store.Broker there's
messages I need to override so I can create the constraints inside
StoreForMySQL.

If not, I've been able to guess at a number of them.  After publishing
some TW_Blessing.pkgID values that don't seem to relate to
TW_Package.primaryKey.  Is that the right relationship?

--
Visit <http://tggagne.blogspot.com/> for more great reading.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

The blessings pkgID can point to either a package or a bundle (see recType) and so doesn't lend itself well to a foreign key constraint. There might be other things like that as well.

At 10:24 AM 4/23/2008, Thomas Gagné wrote:

To detect Store insert errors I'd like to add foreign key constraints
wherever possible.  I'm wondering if inside Store.Broker there's
messages I need to override so I can create the constraints inside
StoreForMySQL.

If not, I've been able to guess at a number of them.  After publishing
some TW_Blessing.pkgID values that don't seem to relate to
TW_Package.primaryKey.  Is that the right relationship?

--
Visit < http://tggagne.blogspot.com/> for more great reading.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc