db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Unable to create the second table
Date Tue, 28 Dec 2004 17:28:34 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nonick Me wrote:
> I'm trying to run the following SQL script.  The first table is created
> but not for the second table.  Could anybody see why ?  I could not
see it.
>

Also Derby does not support text datatype (use clob instead) or bit
datatype (use smallint instead).

> create table website (
>     ignorewords       text,
>     enablebloggerapi  bit default 0 not null,
>     allowcomments     bit default 1 not null,
>     emailcomments     bit default 0 not null,
>     pinnedtomain      bit default 0 not null,
>     isenabled         bit default 1 not null
> );

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFB0ZbnIv0S4qsbfuQRAmQaAJwL51SC2xWWOAIr/2V0FqH4jlWzvwCfVFZX
bm71IEGxDxQ96WvTMa6T9rU=
=CAfR
-----END PGP SIGNATURE-----


Mime
View raw message