Updated DDL for SQL backend

[Derek Atkins]

Phil Longstaff <plongstaff at rogers.com> writes:

> Hi Daniel,
>
> thanks.  I made some modifications to fix most of the problems.  I have
> both PostgreSQL and MySQL set up on my machine so I can test both dbs.
> One compatibility problem I have run into is that pgsql doesn't support
> BLOB as a data type (they have bytea instead).  This is needed for the
> kvp slot binary type.

I think it's safe to ignore the kvp BINARY type.  I don't think it's
used anywhere.  It /may/ also be safe to ignore the kvp LIST type,
but I'm not as sure that that's never used.  I'm fairly confident,
but not 100% sure.

> Thanks for the offer of help.  I plan to concentrate on the core objects
> and on SQLite/MySQL.   If you want to do the business objects and pgsql,
> then great.

Cool..

> Phil

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available