diff options
| author | geniusdex geniusdex@31f1291d-b8d6-0310-a050-a5561fc1590b <geniusdex geniusdex@31f1291d-b8d6-0310-a050-a5561fc1590b@5417fbe8-f217-4b02-8779-1006273d7864> | 2007-09-02 14:11:27 +0000 |
|---|---|---|
| committer | geniusdex geniusdex@31f1291d-b8d6-0310-a050-a5561fc1590b <geniusdex geniusdex@31f1291d-b8d6-0310-a050-a5561fc1590b@5417fbe8-f217-4b02-8779-1006273d7864> | 2007-09-02 14:11:27 +0000 |
| commit | 00e6e4d38294516d68f94411d0be39aeeee6ec85 (patch) | |
| tree | b54f6193a33f740b2d9328ac4de24005e71e645d /Changes.mysql | |
| parent | 113eaa042eaa7b71485de588a082fab096d56c76 (diff) | |
BUILD : 1.7.19 (1299) BUGS : NOTES : Added MySQL indexes to decrease the MySQL load during database operations
git-svn-id: svn://svn.anope.org/anope/trunk@1299 31f1291d-b8d6-0310-a050-a5561fc1590b
git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/trunk@1017 5417fbe8-f217-4b02-8779-1006273d7864
Diffstat (limited to 'Changes.mysql')
| -rw-r--r-- | Changes.mysql | 29 |
1 files changed, 28 insertions, 1 deletions
diff --git a/Changes.mysql b/Changes.mysql index 7d341dde0..86f040ef0 100644 --- a/Changes.mysql +++ b/Changes.mysql @@ -1,6 +1,33 @@ Anope Version S V N -------------------- -- NONE +ALTER TABLE `anope_ns_request` DROP INDEX `nick_index` ; +ALTER TABLE `anope_ns_core` DROP INDEX `display_index` ; +ALTER TABLE `anope_ns_access` ADD UNIQUE (`display`) ; +ALTER TABLE `anope_ms_info` ADD UNIQUE (`nm_id` , `serv`) ; +ALTER TABLE `anope_ns_alias` DROP INDEX `nick_index` ; +ALTER TABLE `anope_cs_info` DROP INDEX `name_index` ; +ALTER TABLE `anope_cs_access` ADD UNIQUE (`channel` , `display`) ; +ALTER TABLE `anope_cs_levels` ADD UNIQUE (`channel` , `position`) ; +ALTER TABLE `anope_cs_akicks` CHANGE `dmask` `dmask` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_cs_akicks` ADD UNIQUE (`channel` , `dmask`) ; +ALTER TABLE `anope_cs_badwords` CHANGE `word` `word` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_cs_badwords` ADD UNIQUE (`channel` , `word`) ; +ALTER TABLE `anope_cs_ttb` ADD UNIQUE (`channel` , `ttb_id`) ; +ALTER TABLE `anope_os_akills` CHANGE `user` `user` VARCHAR( 255 ) NOT NULL , CHANGE `host` `host` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_os_akills` ADD UNIQUE (`user` , `host`) ; +ALTER TABLE `anope_os_sglines` CHANGE `mask` `mask` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_os_sglines` ADD UNIQUE (`mask`) ; +ALTER TABLE `anope_os_sqlines` CHANGE `mask` `mask` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_os_sqlines` ADD UNIQUE (`mask`) ; +ALTER TABLE `anope_os_szlines` CHANGE `mask` `mask` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_os_szlines` ADD UNIQUE (`mask`) ; +ALTER TABLE `anope_os_news` ADD UNIQUE (`type` , `num` , `time`) ; +ALTER TABLE `anope_os_exceptions` CHANGE `mask` `mask` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_os_exceptions` ADD UNIQUE (`mask`) ; +ALTER TABLE `anope_hs_core` DROP INDEX `nick_index` ; +ALTER TABLE `anope_bs_core` DROP INDEX `nick_index` ; +ALTER TABLE `anope_ms_info` CHANGE `receiver` `receiver` VARCHAR( 255 ) NOT NULL ; +ALTER TABLE `anope_ms_info` ADD INDEX ( `receiver` , `serv` ) ; Anope Version 1.7.19 -------------------- |