Changeset 3a5476d1 in github for SQL/mssql.upgrade.sql


Ignore:
Timestamp:
Feb 23, 2011 3:13:02 AM (2 years ago)
Author:
alecpl <alec@…>
Branches:
master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8
Children:
041f66e
Parents:
5744bfa
Message:
  • Add index on contactgroupmembers.contact_id column. Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
File:
1 edited

Legend:

Unmodified
Added
Removed

  • SQL/mssql.upgrade.sql

    r3e26373 r3a5476d1  
    102102ALTER TABLE [dbo].[contacts] ADD [words] [text] COLLATE Latin1_General_CI_AI NULL  
    103103GO 
     104CREATE  INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY] 
     105GO 
Note: See TracChangeset for help on using the changeset viewer.