[mb-devel] Re: Why create the constraints after table creation?
Robert Kaye
rob at eorbit.net
Mon Oct 23 21:17:56 UTC 2006
On Oct 22, 2006, at 8:40 AM, Matt Perry wrote:
> On Sun, 22 Oct 2006, Steve Wyles wrote:
>
>> On Sat, 21 Oct 2006, Matt Perry wrote:
>>
>> The contraints aren't always required, for instance they aren't
>> used in replicated slaves.
>
> Since the SQL essentially acts as documentation it would make more
> sense to combine the statements into create table and just drop all
> the constraints on slaves.
I see what you're saying -- but keeping them separate is desirable
for greater overall flexibility. I think the best way to fix the
documentation problem is by writing actual documentation, rather than
having to rely on SQL statements as our core docs.
Anyone feel like drawing some graphs?
--
--ruaok Somewhere in Texas a village is *still* missing its idiot.
Robert Kaye -- rob at eorbit.net -- http://mayhem-chaos.net
More information about the MusicBrainz-devel
mailing list