#1 DDL for Derby database

[PDoubleYa]

Attached is the ashkelon.sql, from Ashkelon 0.8.9, for
Derby 10.1.

So far I have tested loading this script into an
embedded Derby database.

I started with the Postgres SQL file, then modified
datatypes not supported in Derby. In this version, TEXT
and unbounded VARCHAR became VARCHAR(32672)--the max
for a VARCHAR in Derby. I did this blindly, could be
tuned to reduce the size in some/all cases.

Regards
Patrick

[PDoubleYa]

Logged In: YES
user_id=588606

On second thought, let me hold this for a second--I want to
use foreign key references in Derby, which I now have
working, because I want to be able to read the full metadata
including table relationships using the JDBC metadata APIs.
However, this causes some changes in how inserts and deletes
take place. I'll need to bundle up those changes and submit
that diff as well. Stay tuned.

Patrick