From f4bcf833ecb4c139544bf6de5fadabca56e016e9 Mon Sep 17 00:00:00 2001
From: Adam- <Adam-@5417fbe8-f217-4b02-8779-1006273d7864>
Date: Sun, 28 Mar 2010 07:57:05 +0000
Subject: Finish rest of BotServ SQL stuff

git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/trunk@2839 5417fbe8-f217-4b02-8779-1006273d7864
---
 data/tables.sql | 32 ++++++++++++++++++++++++++++++--
 1 file changed, 30 insertions(+), 2 deletions(-)

(limited to 'data')

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;
 
 -- --------------------------------------------------------
@@ -234,6 +249,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'
 --
-- 
cgit