Martin Edenhofer a écrit :
Hi Florent,
Florent Guiliani schrieb:
current_timestamp doesn't exist, Oracle use instead sysdate.
after replaced all current_timestamp with sysdate, others statments
are invalids because some right-quote are missing.
Here is the patch in attachment.
No. It works fine for me. Just use it like:
shell> cat scripts/database/otrs-schema.oracle.sql | sqlplus "user/pw"
shell> cat cripts/database/initial_insert.sql | sqlplus "user/pw"
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.
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
