- Add index on contactgroupmembers.contact_id column.
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
| | |
| | | CHANGELOG Roundcube Webmail |
| | | =========================== |
| | | |
| | | - Fix problem with contactgroupmembers table creation on MySQL 4.x, add index on contact_id column |
| | | - Add LDAP SASL bind and proxy authentication (#1486692) |
| | | - Add variable for 'Today' label in date_today option (#1486120) |
| | | - Fix dont_override setting does not override existing user preferences (#1487664) |
| | |
| | | CONSTRAINT [DF_contactgroupmembers_created] DEFAULT (getdate()) FOR [created]
|
| | | GO
|
| | |
|
| | | CREATE INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]
|
| | | GO
|
| | |
|
| | | ALTER TABLE [dbo].[identities] ADD
|
| | | CONSTRAINT [DF_identities_user] DEFAULT ('0') FOR [user_id],
|
| | |
| | |
|
| | | ALTER TABLE [dbo].[contacts] ADD [words] [text] COLLATE Latin1_General_CI_AI NULL
|
| | | GO
|
| | | CREATE INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]
|
| | | GO
|
| | |
| | | CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) |
| | | REFERENCES `contactgroups`(`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| | | CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) |
| | | REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| | | REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| | | INDEX `contactgroupmembers_contact_index` (`contact_id`) |
| | | ) /*!40000 ENGINE=INNODB */; |
| | | |
| | | |
| | |
| | | -- Updates from version 0.5.* |
| | | |
| | | ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`; |
| | | ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` (`contact_id`); |
| | | |
| | |
| | | PRIMARY KEY (contactgroup_id, contact_id) |
| | | ); |
| | | |
| | | CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); |
| | | |
| | | -- |
| | | -- Sequence "cache_ids" |
| | | -- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres |
| | |
| | | |
| | | TRUNCATE messages; |
| | | |
| | | |
| | | -- Updates from version 0.5.x |
| | | |
| | | ALTER TABLE contacts ADD words TEXT NULL; |
| | | |
| | | CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); |
| | |
| | | PRIMARY KEY (contactgroup_id, contact_id) |
| | | ); |
| | | |
| | | CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id); |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | |
| | | DROP TABLE contacts_tmp; |
| | | |
| | | DELETE FROM messages; |
| | | CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id); |