diff options
| -rw-r--r-- | data/tables.sql | 696 |
1 files changed, 282 insertions, 414 deletions
diff --git a/data/tables.sql b/data/tables.sql index 217612b5c..92e44a8a1 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -1,568 +1,436 @@ --- $Id$ +-- +-- mysqldump --skip-opt --compact --comments --add-drop-table --create-options --disable-keys --no-data --routines -u anope -panope anope > tables.sql +-- --- If you need to create your db, uncomment the following lines. --- --- CREATE DATABASE anope; --- USE anope; --- --- Tabellenstruktur für Tabelle `anope_bs_badwords` --- +-- +-- Table structure for table `anope_bs_badwords` +-- +DROP TABLE IF EXISTS `anope_bs_badwords`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_bs_badwords` ( - `channel` varchar(255) NOT NULL default '', + `channel` varchar(255) NOT NULL DEFAULT '', `word` varchar(255) NOT NULL, `type` varchar(50) NOT NULL, - UNIQUE KEY `channel` (`channel`,`word`) + UNIQUE KEY `channel` (`channel`,`word`), + CONSTRAINT `anope_bs_badwords_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_bs_badwords` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_bs_core` --- +-- +-- Table structure for table `anope_bs_core` +-- +DROP TABLE IF EXISTS `anope_bs_core`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_bs_core` ( - `nick` varchar(255) NOT NULL default '', - `user` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', + `user` varchar(255) NOT NULL DEFAULT '', `host` text NOT NULL, `rname` text NOT NULL, `flags` text NOT NULL, - `created` int(11) NOT NULL default '0', - `chancount` int(11) NOT NULL default '0', - PRIMARY KEY (`nick`) + `created` int(11) NOT NULL DEFAULT '0', + `chancount` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`nick`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_bs_core` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_bs_info_metadata` --- +-- +-- Table structure for table `anope_bs_info_metadata` +-- +DROP TABLE IF EXISTS `anope_bs_info_metadata`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_bs_info_metadata` ( - `botname` varchar(255) NOT NULL default '', - `name` varchar(255) NOT NULL default '', + `botname` varchar(255) NOT NULL DEFAULT '', + `name` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, - UNIQUE KEY `botname` (`botname`,`name`) + UNIQUE KEY `botname` (`botname`,`name`), + CONSTRAINT `anope_bs_info_metadata_ibfk_1` FOREIGN KEY (`botname`) REFERENCES `anope_bs_core` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_bs_info_metadata` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_commands` --- +-- +-- Table structure for table `anope_commands` +-- +DROP TABLE IF EXISTS `anope_commands`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_commands` ( - `nick` varchar(255) NOT NULL default '', - `service` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', + `service` varchar(255) NOT NULL DEFAULT '', `command` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_commands` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_access` --- +-- +-- Table structure for table `anope_cs_access` +-- +DROP TABLE IF EXISTS `anope_cs_access`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_access` ( - `level` int(11) NOT NULL default '0', - `display` varchar(255) NOT NULL default '', - `channel` varchar(255) NOT NULL default '', - `last_seen` int(11) NOT NULL default '0', - `creator` varchar(255) NOT NULL default '', - UNIQUE KEY `channel` (`channel`,`display`) + `level` int(11) NOT NULL DEFAULT '0', + `display` varchar(255) NOT NULL DEFAULT '', + `channel` varchar(255) NOT NULL DEFAULT '', + `last_seen` int(11) NOT NULL DEFAULT '0', + `creator` varchar(255) NOT NULL DEFAULT '', + UNIQUE KEY `channel` (`channel`,`display`), + CONSTRAINT `anope_cs_access_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_access` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_akick` --- +-- +-- Table structure for table `anope_cs_akick` +-- +DROP TABLE IF EXISTS `anope_cs_akick`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_akick` ( - `channel` varchar(255) NOT NULL default '', - `flags` varchar(255) NOT NULL default '', - `mask` varchar(255) NOT NULL default '', + `channel` varchar(255) NOT NULL DEFAULT '', + `flags` varchar(255) NOT NULL DEFAULT '', + `mask` varchar(255) NOT NULL DEFAULT '', `reason` text NOT NULL, - `creator` varchar(255) NOT NULL default '', - `created` int(11) NOT NULL default '0', - `last_used` int(11) NOT NULL default '0', - UNIQUE KEY `channel` (`channel`,`mask`) + `creator` varchar(255) NOT NULL DEFAULT '', + `created` int(11) NOT NULL DEFAULT '0', + `last_used` int(11) NOT NULL DEFAULT '0', + UNIQUE KEY `channel` (`channel`,`mask`), + CONSTRAINT `anope_cs_akick_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_akick` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_info` --- +-- +-- Table structure for table `anope_cs_info` +-- +DROP TABLE IF EXISTS `anope_cs_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_info` ( - `name` varchar(255) NOT NULL default '', + `name` varchar(255) NOT NULL DEFAULT '', `founder` text NOT NULL, `successor` text NOT NULL, `descr` text NOT NULL, `url` text NOT NULL, `email` text NOT NULL, - `time_registered` int(11) unsigned NOT NULL default '0', - `last_used` int(10) unsigned NOT NULL default '0', + `time_registered` int(11) unsigned NOT NULL DEFAULT '0', + `last_used` int(10) unsigned NOT NULL DEFAULT '0', `last_topic` text NOT NULL, `last_topic_setter` text NOT NULL, - `last_topic_time` int(11) unsigned NOT NULL default '0', + `last_topic_time` int(11) unsigned NOT NULL DEFAULT '0', `flags` text NOT NULL, `forbidby` text NOT NULL, `forbidreason` text NOT NULL, - `bantype` smallint(6) NOT NULL default '0', + `bantype` smallint(6) NOT NULL DEFAULT '0', `mlock_on` text NOT NULL, `mlock_off` text NOT NULL, `mlock_params` text NOT NULL, `entry_message` text NOT NULL, - `memomax` smallint(5) unsigned NOT NULL default '0', - `botnick` varchar(255) NOT NULL default '', + `memomax` smallint(5) unsigned NOT NULL DEFAULT '0', + `botnick` varchar(255) NOT NULL DEFAULT '', `botflags` text NOT NULL, - `capsmin` smallint(6) NOT NULL default '0', - `capspercent` smallint(6) NOT NULL default '0', - `floodlines` smallint(6) NOT NULL default '0', - `floodsecs` smallint(6) NOT NULL default '0', - `repeattimes` smallint(6) NOT NULL default '0', - PRIMARY KEY (`name`) + `capsmin` smallint(6) NOT NULL DEFAULT '0', + `capspercent` smallint(6) NOT NULL DEFAULT '0', + `floodlines` smallint(6) NOT NULL DEFAULT '0', + `floodsecs` smallint(6) NOT NULL DEFAULT '0', + `repeattimes` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_info` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_info_metadata` --- +-- +-- Table structure for table `anope_cs_info_metadata` +-- +DROP TABLE IF EXISTS `anope_cs_info_metadata`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_info_metadata` ( - `channel` varchar(255) NOT NULL default '', - `name` varchar(255) NOT NULL default '', + `channel` varchar(255) NOT NULL DEFAULT '', + `name` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, - UNIQUE KEY `channel` (`channel`,`name`) + UNIQUE KEY `channel` (`channel`,`name`), + CONSTRAINT `anope_cs_info_metadata_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_info_metadata` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_levels` --- +-- +-- Table structure for table `anope_cs_levels` +-- +DROP TABLE IF EXISTS `anope_cs_levels`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_levels` ( - `channel` varchar(255) NOT NULL default '', - `position` int(11) NOT NULL default '0', - `level` int(11) NOT NULL default '0', - UNIQUE KEY `channel` (`channel`,`position`) + `channel` varchar(255) NOT NULL DEFAULT '', + `position` int(11) NOT NULL DEFAULT '0', + `level` int(11) NOT NULL DEFAULT '0', + UNIQUE KEY `channel` (`channel`,`position`), + CONSTRAINT `anope_cs_levels_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_levels` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_cs_ttb` --- +-- +-- Table structure for table `anope_cs_ttb` +-- +DROP TABLE IF EXISTS `anope_cs_ttb`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_cs_ttb` ( - `channel` varchar(255) NOT NULL default '', - `ttb_id` int(11) NOT NULL default '0', - `value` int(11) NOT NULL default '0', - UNIQUE KEY `channel` (`channel`,`ttb_id`) + `channel` varchar(255) NOT NULL DEFAULT '', + `ttb_id` int(11) NOT NULL DEFAULT '0', + `value` int(11) NOT NULL DEFAULT '0', + UNIQUE KEY `channel` (`channel`,`ttb_id`), + CONSTRAINT `anope_cs_ttb_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_cs_ttb` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_extra` --- +-- +-- Table structure for table `anope_extra` +-- +DROP TABLE IF EXISTS `anope_extra`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_extra` ( `data` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_extra` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_info` --- +-- +-- Table structure for table `anope_info` +-- +DROP TABLE IF EXISTS `anope_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_info` ( - `version` int(11) default NULL, - `date` datetime default NULL + `version` int(11) DEFAULT NULL, + `date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_info` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_metadata` --- +-- +-- Table structure for table `anope_metadata` +-- +DROP TABLE IF EXISTS `anope_metadata`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_metadata` ( - `name` varchar(255) NOT NULL default '', + `name` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, - PRIMARY KEY (`name`) + PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_metadata` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ms_info` --- +-- +-- Table structure for table `anope_ms_info` +-- +DROP TABLE IF EXISTS `anope_ms_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ms_info` ( `receiver` varchar(255) NOT NULL, - `number` int(11) NOT NULL default '0', - `flags` int(11) NOT NULL default '0', - `time` int(11) NOT NULL default '0', + `number` int(11) NOT NULL DEFAULT '0', + `flags` int(11) NOT NULL DEFAULT '0', + `time` int(11) NOT NULL DEFAULT '0', `sender` text NOT NULL, `text` blob NOT NULL, - `serv` enum('NICK','CHAN') NOT NULL default 'NICK', - UNIQUE KEY `receiver` (`receiver`,`number`) + `serv` enum('NICK','CHAN') NOT NULL DEFAULT 'NICK', + UNIQUE KEY `receiver` (`receiver`,`number`), + CONSTRAINT `anope_ms_info_ibfk_1` FOREIGN KEY (`receiver`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ms_info` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_access` --- +-- +-- Table structure for table `anope_ns_access` +-- +DROP TABLE IF EXISTS `anope_ns_access`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_access` ( - `display` varchar(255) NOT NULL default '', + `display` varchar(255) NOT NULL DEFAULT '', `access` varchar(160) NOT NULL, - UNIQUE KEY `display` (`display`,`access`) + UNIQUE KEY `display` (`display`,`access`), + CONSTRAINT `anope_ns_access_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_access` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_alias` --- +-- +-- Table structure for table `anope_ns_alias` +-- +DROP TABLE IF EXISTS `anope_ns_alias`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_alias` ( - `nick` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', `last_quit` text NOT NULL, `last_realname` text NOT NULL, `last_usermask` text NOT NULL, - `time_registered` int(11) unsigned NOT NULL default '0', - `last_seen` int(10) unsigned NOT NULL default '0', + `time_registered` int(11) unsigned NOT NULL DEFAULT '0', + `last_seen` int(10) unsigned NOT NULL DEFAULT '0', `flags` text NOT NULL, - `display` varchar(255) NOT NULL default '', - PRIMARY KEY (`nick`), - KEY `display` (`display`) + `display` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`nick`), + KEY `display` (`display`), + CONSTRAINT `anope_ns_alias_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_alias` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_alias_metadata` --- +-- +-- Table structure for table `anope_ns_alias_metadata` +-- +DROP TABLE IF EXISTS `anope_ns_alias_metadata`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_alias_metadata` ( - `nick` varchar(255) NOT NULL default '', - `name` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', + `name` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, - PRIMARY KEY (`name`), - KEY `nick` (`nick`) + PRIMARY KEY (`name`), + KEY `nick` (`nick`), + CONSTRAINT `anope_ns_alias_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_alias` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_alias_metadata` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_core` --- +-- +-- Table structure for table `anope_ns_core` +-- +DROP TABLE IF EXISTS `anope_ns_core`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_core` ( - `display` varchar(255) NOT NULL default '', + `display` varchar(255) NOT NULL DEFAULT '', `pass` text NOT NULL, `email` text NOT NULL, `greet` text NOT NULL, - `icq` int(10) unsigned NOT NULL default '0', + `icq` int(10) unsigned NOT NULL DEFAULT '0', `url` text NOT NULL, `flags` text NOT NULL, - `language` smallint(5) unsigned NOT NULL default '0', - `channelcount` smallint(5) unsigned NOT NULL default '0', - `memomax` smallint(5) unsigned NOT NULL default '0', - PRIMARY KEY (`display`) + `language` smallint(5) unsigned NOT NULL DEFAULT '0', + `channelcount` smallint(5) unsigned NOT NULL DEFAULT '0', + `memomax` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`display`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_core` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_core_metadata` --- +-- +-- Table structure for table `anope_ns_core_metadata` +-- +DROP TABLE IF EXISTS `anope_ns_core_metadata`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_core_metadata` ( - `nick` varchar(255) NOT NULL default '', - `name` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', + `name` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, - PRIMARY KEY (`name`), - KEY `nick` (`nick`) + PRIMARY KEY (`name`), + KEY `nick` (`nick`), + CONSTRAINT `anope_ns_core_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_core_metadata` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_ns_request` --- +-- +-- Table structure for table `anope_ns_request` +-- +DROP TABLE IF EXISTS `anope_ns_request`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_ns_request` ( - `nick` varchar(255) NOT NULL default '', + `nick` varchar(255) NOT NULL DEFAULT '', `passcode` text NOT NULL, `password` text NOT NULL, `email` text NOT NULL, - `requested` int(11) NOT NULL default '0', - PRIMARY KEY (`nick`) + `requested` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`nick`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_ns_request` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_os_akills` --- +-- +-- Table structure for table `anope_os_akills` +-- +DROP TABLE IF EXISTS `anope_os_akills`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_os_akills` ( `user` varchar(255) NOT NULL, `host` varchar(255) NOT NULL, `xby` text NOT NULL, `reason` text NOT NULL, - `seton` int(11) NOT NULL default '0', - `expire` int(11) NOT NULL default '0', + `seton` int(11) NOT NULL DEFAULT '0', + `expire` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `user` (`user`,`host`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_os_akills` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_os_core` --- +-- +-- Table structure for table `anope_os_core` +-- +DROP TABLE IF EXISTS `anope_os_core`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_os_core` ( - `maxusercnt` int(11) NOT NULL default '0', - `maxusertime` int(11) NOT NULL default '0', - `akills_count` int(11) NOT NULL default '0', - `sglines_count` int(11) NOT NULL default '0', - `sqlines_count` int(11) NOT NULL default '0', - `szlines_count` int(11) NOT NULL default '0' + `maxusercnt` int(11) NOT NULL DEFAULT '0', + `maxusertime` int(11) NOT NULL DEFAULT '0', + `akills_count` int(11) NOT NULL DEFAULT '0', + `sglines_count` int(11) NOT NULL DEFAULT '0', + `sqlines_count` int(11) NOT NULL DEFAULT '0', + `szlines_count` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_os_core` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_os_exceptions` --- +-- +-- Table structure for table `anope_os_exceptions` +-- +DROP TABLE IF EXISTS `anope_os_exceptions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_os_exceptions` ( `mask` varchar(255) NOT NULL, - `limit` int(11) NOT NULL default '0', + `limit` int(11) NOT NULL DEFAULT '0', `who` text NOT NULL, `reason` text NOT NULL, - `time` int(11) NOT NULL default '0', - `expires` int(11) NOT NULL default '0' + `time` int(11) NOT NULL DEFAULT '0', + `expires` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_os_exceptions` --- - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `anope_os_sxlines` --- +-- +-- Table structure for table `anope_os_sxlines` +-- +DROP TABLE IF EXISTS `anope_os_sxlines`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `anope_os_sxlines` ( `type` varchar(20) NOT NULL, `mask` varchar(255) NOT NULL, `xby` text NOT NULL, `reason` text NOT NULL, - `seton` int(11) NOT NULL default '0', - `expire` int(11) NOT NULL default '0' + `seton` int(11) NOT NULL DEFAULT '0', + `expire` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; --- --- Daten für Tabelle `anope_os_sxlines` --- - - --- --- Constraints der exportierten Tabellen --- - --- --- Constraints der Tabelle `anope_bs_badwords` --- -ALTER TABLE `anope_bs_badwords` - ADD CONSTRAINT `anope_bs_badwords_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_bs_info_metadata` --- -ALTER TABLE `anope_bs_info_metadata` - ADD CONSTRAINT `anope_bs_info_metadata_ibfk_1` FOREIGN KEY (`botname`) REFERENCES `anope_bs_core` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_cs_access` --- -ALTER TABLE `anope_cs_access` - ADD CONSTRAINT `anope_cs_access_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_cs_akick` --- -ALTER TABLE `anope_cs_akick` - ADD CONSTRAINT `anope_cs_akick_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_cs_info_metadata` --- -ALTER TABLE `anope_cs_info_metadata` - ADD CONSTRAINT `anope_cs_info_metadata_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_cs_levels` --- -ALTER TABLE `anope_cs_levels` - ADD CONSTRAINT `anope_cs_levels_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_cs_ttb` --- -ALTER TABLE `anope_cs_ttb` - ADD CONSTRAINT `anope_cs_ttb_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_ms_info` --- -ALTER TABLE `anope_ms_info` - ADD CONSTRAINT `anope_ms_info_ibfk_1` FOREIGN KEY (`receiver`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_ns_access` --- -ALTER TABLE `anope_ns_access` - ADD CONSTRAINT `anope_ns_access_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_ns_alias` --- -ALTER TABLE `anope_ns_alias` - ADD CONSTRAINT `anope_ns_alias_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_ns_alias_metadata` --- -ALTER TABLE `anope_ns_alias_metadata` - ADD CONSTRAINT `anope_ns_alias_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_alias` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE; - --- --- Constraints der Tabelle `anope_ns_core_metadata` --- -ALTER TABLE `anope_ns_core_metadata` - ADD CONSTRAINT `anope_ns_core_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE; +-- +-- Dumping routines for database 'anope' +-- |