Anope Stable Branch

git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/stable@1902 5417fbe8-f217-4b02-8779-1006273d7864

1 files changed, 129 insertions, 0 deletions

diff --git a/Changes.mysql b/Changes.mysql
new file mode 100644
index 000000000..b51e2e306
--- /dev/null
+++ b/Changes.mysql
@@ -0,0 +1,129 @@
+Anope Version 1.8.0
+-------------------
+ALTER TABLE `anope_ns_access` DROP INDEX display;
+
+Anope Version 1.7.24
+--------------------
+- NONE
+
+Anope Version 1.7.23b
+--------------------
+- NONE
+
+Anope Version 1.7.23
+--------------------
+- NONE
+
+Anope Version 1.7.22
+--------------------
+- NONE
+
+Anope Version 1.7.21
+--------------------
+- NONE
+
+Anope Version 1.7.20
+--------------------
+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
+--------------------
+- NONE
+
+Anope Version 1.7.18
+--------------------
+- DROP TABLE IF EXISTS `anope_os_status`
+- ALTER TABLE `anope_bs_core` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_cs_access` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_cs_akicks` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_cs_badwords` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_cs_levels` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_cs_ttb` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_hs_core` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_ms_info` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_ns_access` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_ns_request` CHANGE `active` `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_akills` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_exceptions` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_news` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_sglines` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_sqlines` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+- ALTER TABLE `anope_os_szlines` ADD `active` TINYINT( 1 ) DEFAULT '1' NOT NULL
+
+Anope Version 1.7.17
+--------------------
+- CREATE TABLE anope_cs_ttb (
+   ct_id int(11) NOT NULL auto_increment,
+   channel varchar(255) NOT NULL default '',
+   ttb_id int(11) NOT NULL default '0',
+   value int(11) NOT NULL default '0',
+   PRIMARY KEY  (ct_id)
+  ) TYPE=MyISAM
+- ALTER TABLE anope_cs_info DROP ttb
+
+Anope Version 1.7.16
+--------------------
+- NONE
+
+Anope Version 1.7.15
+--------------------
+- NONE
+
+Anope Version 1.7.14
+--------------------
+- NONE
+
+Anope Version 1.7.13
+--------------------
+- NONE
+
+Anope Version 1.7.12
+--------------------
+- NONE
+
+Anope Version 1.7.11
+--------------------
+- NONE
+
+Anope Version 1.7.10
+--------------------
+- NONE
+
+Anope Version 1.7.9
+-------------------
+- DROP TABLE IF EXISTS anope_os_cache
+
+Anope Version 1.7.8
+-------------------
+- NONE
+
+Anope Version 1.7.7
+-------------------
+- ALTER TABLE anope_ns_alias CHANGE status status int(11) unsigned NOT NULL default '0'