Added in support for OperServ and MemoServ into SQL

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

1 files changed, 83 insertions, 0 deletions

diff --git a/data/tables.sql b/data/tables.sql
index 6b1394e56..14d612c56 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -172,6 +172,8 @@ CREATE TABLE anope_cs_info (
   PRIMARY KEY  (name)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+-- --------------------------------------------------------
+
 --
 -- Table structure for table 'anope_cs_info_metadata'
 --
@@ -219,6 +221,87 @@ CREATE TABLE anope_bs_core (
 -- --------------------------------------------------------
 
 --
+-- Table structure for table 'anope_ms_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'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- 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'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- 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=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- 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=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- 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=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table 'anope_metadata'
 --