db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suavi Ali Demir <dem...@yahoo.com>
Subject Re: Unable to create the second table in the SQL script
Date Tue, 28 Dec 2004 07:43:25 GMT
Should the default value be a quoted string? 0 is
probably not valid as a default value here.

defaultpageid     varchar(48) default 0 not null,

Ali



--- Nonick Me <nonick4me2004@yahoo.com> 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.
>  
> ==== test.sql ===
> connect 'jdbc:derby:rollerdb;create=true';
> create table usercookie (
>     id              varchar(48)  not null primary
> key,
>     username        varchar(255) not null,
>     cookieid        varchar(100) not null,
>     datecreated     timestamp    not null
> );
> create table website (
>     id                varchar(48) not null primary
> key,
>     name              varchar(255) not null,
>     description       varchar(255) not null,
>     userid            varchar(48) not null,
>     defaultpageid     varchar(48) default 0 not
> null,
>     weblogdayid       varchar(48) not null,
>     ignorewords       text,
>     enablebloggerapi  bit default 0 not null,
>     editorpage        varchar(255) null,
>     bloggercatid      varchar(48) null,
>     defaultcatid      varchar(48) null,
>     allowcomments     bit default 1 not null,
>     emailcomments     bit default 0 not null,
>     emailfromaddress  varchar(255) null,
>     editortheme       varchar(255) null,
>     locale            varchar(20) null,
>     timezone          varchar(50) null,
>     defaultplugins    varchar(255) null,
>     pinnedtomain      bit default 0 not null,
>     isenabled         bit default 1 not null
> );
> 
> 
> 
> 		
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Mail - 250MB free storage. Do more. Manage
less.


Mime
View raw message