db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nonick Me <nonick4me2...@yahoo.com>
Subject Unable to create the second table
Date Tue, 28 Dec 2004 05:12:18 GMT
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!?
 The all-new My Yahoo!  Get yours free!    
View raw message