-----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-----
