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