[Tickets #8664] Some errors are produced when the script create.msde.sql is executed in MSSQL 2005

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8664
------------------------------------------------------------------------------
  Ticket             | 8664
  Created By         | emma.varela at usc.es
  Summary            | Some errors are produced when the script
                     | create.msde.sql is executed in MSSQL 2005
  Queue              | Horde Base
  Version            | 3.3.5
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


emma.varela at usc.es (2009-10-28 06:02) wrote:

* Some errors are produced when the script create.msde.sql is executed  
in MSSQL 2005:

1- SQL Server does not support the UNSIGNED attribute on integer types.

2- The column 'attribute_value' of the table  
'horde_datatree_attributes' is a type of data that is not valid to be  
used as column of key in an index. This is because varchar(MAX)  
columns cannot be specified as a key column in an index.

* Also there is a problem with the script turba.mssql.sql in the turba module:

BLOB data type is not available.
It is necessary to change BLOB type for IMAGE type.