Updated DDL for SQL backend

[Benoit Gregoire]

On Thursday 26 October 2006 22:43, Phil Longstaff wrote:
> 3) All object ids are (or should be) GUIDs.  A GUID is represented by a
> set of 4 int fields.   I use this instead of varbinary because it isn't
> variable length.  I don't use any text type because I don't want any
> issues with 0x00 as a char in a GUID. 

Fair enough, it's fixed length.  But it will make for really ugly SQL for 
JOINS, with the only benefit of saving four bytes.  I think using a varbinary 
is much preferable (and just as portable).