mirror of
https://github.com/anope/anope.git
synced 2026-06-12 19:14:47 +02:00
Adam
166 lines
4.9 KiB
SQL
166 lines
4.9 KiB
SQL
Anope Version 1.8.9
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.8
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.7
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.6
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.5
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.4
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.3
|
|
-------------------
|
|
ALTER TABLE `anope_ns_access` DROP INDEX `display` ;
|
|
|
|
Anope Version 1.8.2
|
|
-------------------
|
|
- NONE
|
|
|
|
Anope Version 1.8.1
|
|
-------------------
|
|
- NONE
|
|
|
|
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'
|