Date index for Apr 2002

Hi all,

we have just installed Achievo 0.9.0 with Oracle in our intranet and we 
have found a few problems in the SQL to set up the database:

- Oracle does not have a TIME field type; you should replace TIME with DATE;
- in the PROJECT table you should change the field CONTACT to be NULLable; 
otherwise when creating a new project the insert statement will fail.

With this two little tweaks we could start using Achievo successfully, even 
if we haven't really stress it, yet.

At the end of this messagge you could find some constraints that I have 
applied to the Achievo db.

Hope this will be helpful to someone.

Regards,

Giulio Cesare Solaroli

-------------------------------------------

ALTER TABLE CONTACT ADD
CONSTRAINT CONTACT_customer_FK FOREIGN KEY
(COMPANY) REFERENCES CUSTOMER (ID)
/
ALTER TABLE CONTRACT ADD CONSTRAINT
CONTRACT_customer_FK FOREIGN KEY (CUSTOMER)
REFERENCES CUSTOMER (ID)
/
ALTER TABLE PHASE ADD CONSTRAINT
PHASE_project_FK FOREIGN KEY (PROJECTID)
REFERENCES PROJECT (ID)
/
ALTER TABLE PROJECT ADD CONSTRAINT
PROJECT_customer_FK FOREIGN KEY (CUSTOMER)
REFERENCES CUSTOMER (ID)
/
ALTER TABLE PROJECT_NOTES ADD CONSTRAINT
PROJECT_NOTES_project_FK FOREIGN KEY
(PROJECTID) REFERENCES PROJECT (ID)
/