Hi Florent,
Florent Guiliani schrieb:
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 :(
So you have to upgrade orcale. :)
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.
No. On a fresh inital setup the trigger starts with 1. So the default
admin id is 1 (because it's the first created user).
-=> You have to reset your trigger counter.
Florent,
Martin
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769
http://www.otrs.com/ :: Communication with success!
_______________________________________________
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
