AnsweredAssumed Answered

Alfresco 1.4.0 Preview - ORA-00904

Question asked by jmi on Sep 11, 2006
Latest reply on Sep 13, 2006 by andy
The next generated sql is worst

create table alf_audit_date (id number(19,0) not null, date date not null, day_of_year number(10,0) not null, day_of_month number(10,0) not null, day_of_week number(10,0) not null, week_of_year number(10,0) not null, week_of_month number(10,0) not null, month number(10,0) not null, quarter number(10,0) not null, halfYear number(10,0) not null, year number(10,0) not null, primary key (id))

Oracle doesn't like: date date not null

So please, use another key halfdate if you want.

Outcomes