diff options
Diffstat (limited to 'data')
| -rw-r--r-- | data/tables.sql | 32 |
1 files changed, 30 insertions, 2 deletions
diff --git a/data/tables.sql b/data/tables.sql index 9e989b19f..e42128edb 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -120,6 +120,8 @@ CREATE TABLE anope_ns_request ( PRIMARY KEY (nick) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; +-- -------------------------------------------------------- + -- -- Table structure for table 'anope_cs_access' -- @@ -136,6 +138,20 @@ CREATE TABLE anope_cs_access ( -- -------------------------------------------------------- +-- +-- 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=MyISAM DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + -- -- Table structure for table 'anope_cs_info' -- @@ -182,8 +198,7 @@ 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 '', - PRIMARY KEY (name) + value text NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- @@ -235,6 +250,19 @@ CREATE TABLE anope_bs_core ( -- -------------------------------------------------------- -- +-- Table structure for table 'anope_bs_info_metadata' +-- + +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_ms_info' -- |