R: [otrs] OTRS and MS SQL Server
COSTA Dave - Lievitalia S.p.A.
dco at italia.lesaffre.com
Thu Feb 8 15:04:04 GMT 2007
Hi,
in order to let the MSSQL sripts work I had to do these mods:
- First of all the scripts work only on SQL 2005, due to the "var(max)"
function
which was introduced with this latest version
- Changed "system_user" in "system_user2", as suggested on OTRS site
- the otrs-schema-post.mssql.sql script has been heavily modded.
- Since script otrs-schema-post.mssql.sql gave some errors on foreign
keys I had to modify
Two tables:
table "standard_attachment" column "id" changed from "smallin"t
to "int"
table "auto_response" column "id" changed from "smallin"t to
"int
There will be 3 messages following with the corrected scripts.
Hope this helps.
Best regards
Dave
More information about the otrs
mailing list