Florent Guiliani | 7 Dec 2005 15:19

Re: inital_insert.sql and Oracle

Florent Guiliani a écrit :

> I'm using Oracle 8.1.7.4 and current_timestamp or initial_insert.sql 
> are not working :(
>
> Another defect in otrs-schema-post.oracle.sql:
> ALTER TABLE valid ADD CONSTRAINT fk_valid_create_by_id FOREIGN KEY 
> (create_by) REFERENCES system_user(id);
>
> This statments failed because after initial_insert.sql, the table 
> system_user contains the Admin user and his ID is 3 not 1.

Perhaps this failure is due to my many attemps to execute the script... 
never mind I will update system_user manuelly...

But if OTRS is using current_timestamp so OTRS is not supporting Oracle 8 ?

Florent,

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev


Gmane