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!