[dev] [cvs] commit: horde/docs CHANGES horde/scripts/sql create.msde.sql create.mysql.sql create.oci8.sql create.pgsql.sql create.sql create.xml horde_datatree.mssql.sql horde_datatree.mysql.sql horde_datatree.pgsql.sql horde_datatree.sql horde/scripts/upgrades ...

[Chuck Hagenbuch]

Quoting Jan Schneider <jan at horde.org>:

>> chuck       2007-09-30 00:06:10 EDT
>>
>>   Modified files:
>>     docs                 CHANGES
>>     scripts/sql          create.msde.sql create.mysql.sql
>>                          create.oci8.sql create.pgsql.sql
>>                          create.sql create.xml
>>                          horde_datatree.mssql.sql
>>                          horde_datatree.mysql.sql
>>                          horde_datatree.pgsql.sql
>>                          horde_datatree.sql
>>     scripts/upgrades     3.1_to_3.2.msde.sql 3.1_to_3.2.mysql.sql
>>                          3.1_to_3.2.oci8.sql 3.1_to_3.2.pgsql.sql
>>                          3.1_to_3.2.sql 3.1_to_3.2.sybase.sql
>>   Log:
>>   [cjh] Add an index on horde_datatree_attribute.attribute_value to improve
>>   DataTree performance (Andrew Morgan <morgan at orst.edu>).
>
> How about if we make the index at least 255 chars wide, this is the
> default size we use for user names?

Okay by me - I kept the length of 12 for MySQL but since specifying  
the length of an index doesn't seem to be SQL standard it's not there  
for other dbs.

-chuck