diff options
| -rw-r--r-- | data/tables.sql | 598 |
1 files changed, 256 insertions, 342 deletions
diff --git a/data/tables.sql b/data/tables.sql index b4bee54c4..c4a6b0ee7 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -1,472 +1,386 @@ --- $Id$ -- If you need to create your db, uncomment the following lines. -- -- CREATE DATABASE anope; -- USE anope; --- --- Table structure for table `anope_bs_badwords` --- - -DROP TABLE IF EXISTS `anope_bs_badwords`; -CREATE TABLE `anope_bs_badwords` ( - `channel` varchar(255) NOT NULL DEFAULT '', - `word` varchar(255) NOT NULL, - `type` varchar(50) NOT NULL, - UNIQUE KEY `channel` (`channel`,`word`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `anope_bs_core` --- - -DROP TABLE IF EXISTS `anope_bs_core`; -CREATE TABLE `anope_bs_core` ( - `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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- --- Table structure for table `anope_bs_info_metadata` +-- Table structure for table 'anope_extra' -- -DROP TABLE IF EXISTS `anope_bs_info_metadata`; -CREATE TABLE `anope_bs_info_metadata` ( - `botname` varchar(255) NOT NULL DEFAULT '', - `name` varchar(255) NOT NULL DEFAULT '', - `value` text NOT NULL, - UNIQUE KEY `botname` (`botname`,`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_extra; +CREATE TABLE anope_extra ( + data text NOT NULL default '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_commands` +-- Table structure for table 'anope_commands' -- -DROP TABLE IF EXISTS `anope_commands`; -CREATE TABLE `anope_commands` ( - `nick` varchar(255) NOT NULL DEFAULT '', - `service` varchar(255) NOT NULL DEFAULT '', - `command` text NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_commands; +CREATE TABLE anope_commands ( + nick varchar(255) NOT NULL default '', + service varchar(255) NOT NULL default '', + command text NOT NULL default '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `anope_cs_access` +-- +-- Table structure for table 'anope_ns_core' -- -DROP TABLE IF EXISTS `anope_cs_access`; -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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- +DROP TABLE IF EXISTS anope_ns_core; +CREATE TABLE anope_ns_core ( + display varchar(255) NOT NULL default '', + pass text NOT NULL, + email text NOT NULL default '', + greet text NOT NULL default '', + icq int(10) unsigned NOT NULL default '0', + url text NOT NULL default '', + flags text NOT NULL default '', + 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=MyISAM DEFAULT CHARSET=latin1; -- --- Table structure for table `anope_cs_akick` +-- Table structure for table 'anope_ns_core_metadata' -- -DROP TABLE IF EXISTS `anope_cs_akick`; -CREATE TABLE `anope_cs_akick` ( - `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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- +DROP TABLE IF EXISTS anope_ns_core_metadata; +CREATE TABLE anope_ns_core_metadata ( + nick varchar(255) NOT NULL default '', + name varchar(255) NOT NULL default '', + value text NOT NULL default '', + PRIMARY KEY (name) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +-- --------------------------------------------------------- +-- +-- Table structure for table 'anope_ns_alias' -- --- Table structure for table `anope_cs_info` --- - -DROP TABLE IF EXISTS `anope_cs_info`; -CREATE TABLE `anope_cs_info` ( - `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', - `last_topic` text NOT NULL, - `last_topic_setter` text NOT NULL, - `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', - `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 '', - `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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- -------------------------------------------------------- +DROP TABLE IF EXISTS anope_ns_alias; +CREATE TABLE anope_ns_alias ( + 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', + flags text NOT NULL default '', + display varchar(255) NOT NULL default '', + PRIMARY KEY (nick) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --- Table structure for table `anope_cs_info_metadata` +-- Table structure for table 'anope_ns_alias_metadata' -- -DROP TABLE IF EXISTS `anope_cs_info_metadata`; -CREATE TABLE `anope_cs_info_metadata` ( - `channel` varchar(255) NOT NULL DEFAULT '', - `name` varchar(255) NOT NULL DEFAULT '', - `value` text NOT NULL, - UNIQUE KEY `channel` (`channel`,`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_ns_alias_metadata; +CREATE TABLE anope_ns_alias_metadata ( + nick varchar(255) NOT NULL default '', + name varchar(255) NOT NULL default '', + value text NOT NULL default '', + PRIMARY KEY (name) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `anope_cs_levels` +-- +-- Table structure for table 'anope_ns_access' -- -DROP TABLE IF EXISTS `anope_cs_levels`; -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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_ns_access; +CREATE TABLE anope_ns_access ( + display varchar(255) NOT NULL default '', + access varchar(160) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; --- -------------------------------------------------------- +-- --------------------------------------------------------- --- --- Table structure for table `anope_cs_ttb` +-- +-- Table structure for table 'anope_ns_request' -- -DROP TABLE IF EXISTS `anope_cs_ttb`; -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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_ns_request; +CREATE TABLE anope_ns_request ( + 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) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `anope_extra` --- +-- +-- Table structure for table 'anope_cs_access' +-- -DROP TABLE IF EXISTS `anope_extra`; -CREATE TABLE `anope_extra` ( - `data` text NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_access; +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,display) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_info` +-- Table structure for table 'anope_cs_akick' -- -DROP TABLE IF EXISTS `anope_info`; -CREATE TABLE `anope_info` ( - `version` int(11) DEFAULT NULL, - `date` datetime DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_akick; +CREATE TABLE anope_cs_akick ( + channel varchar(255) NOT NULL default '', + flags varchar(255) NOT NULL default '', + mask varchar(255) NOT NULL default '', + reason text NOT NULL default '', + 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) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_metadata` +-- Table structure for table 'anope_bs_badwords' -- -DROP TABLE IF EXISTS `anope_metadata`; -CREATE TABLE `anope_metadata` ( - `name` varchar(255) NOT NULL DEFAULT '', - `value` text NOT NULL, - PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_bs_badwords; +CREATE TABLE anope_bs_badwords ( + channel varchar(255) NOT NULL default '', + word varchar(255) NOT NULL, + type varchar(50) NOT NULL, + UNIQUE KEY channel (channel,word) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `anope_ms_info` --- +-- +-- Table structure for table 'anope_cs_info' +-- -DROP TABLE IF EXISTS `anope_ms_info`; -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', - `sender` text NOT NULL, - `text` blob NOT NULL, - `serv` enum('NICK','CHAN') NOT NULL DEFAULT 'NICK', - UNIQUE KEY `receiver` (`receiver`,`number`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_info; +CREATE TABLE anope_cs_info ( + 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', + last_topic text NOT NULL, + last_topic_setter text NOT NULL, + last_topic_time int(11) unsigned NOT NULL default '0', + flags text NOT NULL default '', + forbidby text NOT NULL, + forbidreason text NOT NULL, + bantype smallint(6) NOT NULL default '0', + mlock_on text NOT NULL default '', + mlock_off text NOT NULL default '', + mlock_params text NOT NULL default '', + entry_message text NOT NULL, + memomax smallint(5) unsigned NOT NULL default '0', + botnick varchar(255) NOT NULL default '', + botflags text NOT NULL default '', + 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=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_ns_access` +-- Table structure for table 'anope_cs_info_metadata' -- -DROP TABLE IF EXISTS `anope_ns_access`; -CREATE TABLE `anope_ns_access` ( - `display` varchar(255) NOT NULL DEFAULT '', - `access` varchar(160) NOT NULL, - UNIQUE KEY `display` (`display`,`access`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_info_metadata; +CREATE TABLE anope_cs_info_metadata ( + channel varchar(255) NOT NULL default '', + name varchar(255) NOT NULL default '', + value text NOT NULL default '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- --- --- Table structure for table `anope_ns_alias` --- +-- +-- Table structure for table 'anope_cs_levels' +-- -DROP TABLE IF EXISTS `anope_ns_alias`; -CREATE TABLE `anope_ns_alias` ( - `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', - `flags` text NOT NULL, - `display` varchar(255) NOT NULL DEFAULT '', - PRIMARY KEY (`nick`), - KEY `display` (`display`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_levels; +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) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_ns_alias_metadata` +-- Table structure for table 'anope_cs_ttb' -- -DROP TABLE IF EXISTS `anope_ns_alias_metadata`; -CREATE TABLE `anope_ns_alias_metadata` ( - `nick` varchar(255) NOT NULL DEFAULT '', - `name` varchar(255) NOT NULL DEFAULT '', - `value` text NOT NULL, - PRIMARY KEY (`name`), - KEY `nick` (`nick`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_cs_ttb; +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) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_ns_core` +-- Table structure for table 'anope_bs_core' -- -DROP TABLE IF EXISTS `anope_ns_core`; -CREATE TABLE `anope_ns_core` ( - `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', - `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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_bs_core; +CREATE TABLE anope_bs_core ( + nick varchar(255) NOT NULL default '', + user varchar(255) NOT NULL default '', + host text NOT NULL default '', + rname text NOT NULL default '', + flags text NOT NULL default '', + created int(11) NOT NULL default '0', + chancount int(11) NOT NULL default '0', + PRIMARY KEY (nick) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_ns_core_metadata` +-- Table structure for table 'anope_bs_info_metadata' -- -DROP TABLE IF EXISTS `anope_ns_core_metadata`; -CREATE TABLE `anope_ns_core_metadata` ( - `nick` varchar(255) NOT NULL DEFAULT '', - `name` varchar(255) NOT NULL DEFAULT '', - `value` text NOT NULL, - PRIMARY KEY (`name`), - KEY `nick` (`nick`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_bs_info_metadata; +CREATE TABLE anope_bs_info_metadata ( + botname varchar(255) NOT NULL default '', + name varchar(255) NOT NULL default '', + value text NOT NULL default '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_ns_request` +-- Table structure for table 'anope_ms_info' -- -DROP TABLE IF EXISTS `anope_ns_request`; -CREATE TABLE `anope_ns_request` ( - `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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_ms_info; +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', + sender text NOT NULL, + text blob NOT NULL, + serv enum('NICK','CHAN') NOT NULL default 'NICK' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_os_akills` +-- Table structure for table 'anope_os_akills' -- -DROP TABLE IF EXISTS `anope_os_akills`; -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', - UNIQUE KEY `user` (`user`,`host`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_os_akills; +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' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_os_core` +-- Table structure for table 'anope_os_core' -- -DROP TABLE IF EXISTS `anope_os_core`; -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' -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_os_core; +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' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_os_exceptions` +-- Table structure for table 'anope_os_exceptions' -- -DROP TABLE IF EXISTS `anope_os_exceptions`; -CREATE TABLE `anope_os_exceptions` ( - `mask` varchar(255) NOT NULL, - `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' -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_os_exceptions; +CREATE TABLE anope_os_exceptions ( + mask varchar(255) NOT NULL, + `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' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- --- Table structure for table `anope_os_sxlines` +-- Table structure for table 'anope_os_sxlines' -- -DROP TABLE IF EXISTS `anope_os_sxlines`; -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' -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +DROP TABLE IF EXISTS anope_os_sxlines; +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' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; --- --- Constraints for dumped tables --- - --- --- Constraints for table `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 for table `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 for table `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 for table `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 for table `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 for table `anope_cs_levels` +-- Table structure for table 'anope_metadata' -- -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 for table `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; +DROP TABLE IF EXISTS anope_metadata; +CREATE TABLE anope_metadata ( + name varchar(255) NOT NULL default '', + value text NOT NULL default '', + PRIMARY KEY (name) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; --- --- Constraints for table `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 for table `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 for table `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; +-- +-- Table structure for table 'anope_info' +-- --- --- Constraints for table `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; +DROP TABLE IF EXISTS anope_info; +CREATE TABLE anope_info ( + version int(11) default NULL, + date datetime default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; --- --- Constraints for table `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; |