Hi
Thank you for reading my post.
can some one please check and see what is wrong with this scripts ?
im sure that they should execute but derby return errors like :
org.apache.derby.client.am.SqlException: Constraints
'SQL060103004635123' and 'SQL060103004635121' have the same set of
columns, which is not allowed.
create table WEBSITES (USERID integer not null unique, WEBSITEID bigint
not null unique, DOMAINNAME varchar(255) not null unique, DESCRIPTION
varchar(255), PPVIEW double, PPCLICK double, PPWEEK double, totalClick
bigint, totalView bigint, active smallint, primary key (WEBSITEID));
create table CATEGORIES (CATEGORYID integer not null unique,
CATEGORYNAME varchar(255) not null unique, CATEGORYDESCRIPTION
varchar(255), categorytotalClick bigint, categoryTotalView bigint,
primary key (CATEGORYID));
create table WEBSITES_CATEGORIES (WEBSITEID bigint not null, CATEGORYID
integer not null, primary key (WEBSITEID, CATEGORYID));
create index Index14 on WEBSITES (active);
create index Index13 on WEBSITES (DOMAINNAME);
create index Index12 on WEBSITES (WEBSITEID);
create index Index1 on WEBSITES (USERID);
create index Index12 on CATEGORIES (CATEGORYNAME);
create index Index1 on CATEGORIES (CATEGORYID);
alter table WEBSITES_CATEGORIES add constraint FK_WEBSITES_C_4649
foreign key (CATEGORYID) references CATEGORIES;
alter table WEBSITES_CATEGORIES add constraint FK_WEBSITES_C_5733
foreign key (WEBSITEID) references WEBSITES;
