[mb-devel] Why create the constraints after table creation?

Steve Wyles steve at inhouse.co.uk
Sun Oct 22 07:50:32 UTC 2006


On Sat, 21 Oct 2006, Matt Perry wrote:

> I'm taking my first stroll through the mb_server source and I noticed
> something odd with the SQL.  Why are the tables being created and then
> the constraints and primary keys added afterwards in other files?  Was
> there a practical reason for this as opposed to adding those as part
> of the create table statement?

The contraints aren't always required, for instance they aren't used in 
replicated slaves.

Steve



More information about the MusicBrainz-devel mailing list