Finish rest of BotServ SQL stuff

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

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'
 --