Remove unused data/tables.sql

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

1 files changed, 0 insertions, 432 deletions

diff --git a/data/tables.sql b/data/tables.sql
deleted file mode 100644
index f02f1d1c3..000000000
--- a/data/tables.sql
+++ /dev/null
@@ -1,432 +0,0 @@
-
--- If you need to create your db, uncomment the following lines.
--- 
--- CREATE DATABASE anope;
--- USE anope;
-
--- 
--- Table structure for table 'anope_bs_core'
--- 
-
-DROP TABLE IF EXISTS anope_bs_core;
-CREATE TABLE anope_bs_core (
-  bs_id int(11) NOT NULL auto_increment,
-  nick varchar(255) NOT NULL default '',
-  `user` text NOT NULL,
-  host text NOT NULL,
-  rname text NOT NULL,
-  flags int(11) NOT NULL default '0',
-  created int(11) NOT NULL default '0',
-  chancount int(11) NOT NULL default '0',
-  active int(1) NOT NULL default '1',
-  PRIMARY KEY  (bs_id),
-  UNIQUE KEY nick (nick)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_access'
--- 
-
-DROP TABLE IF EXISTS anope_cs_access;
-CREATE TABLE anope_cs_access (
-  ca_id int(11) NOT NULL auto_increment,
-  in_use int(11) NOT NULL default '0',
-  `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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (ca_id),
-  UNIQUE KEY channel (channel,display)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_akicks'
--- 
-
-DROP TABLE IF EXISTS anope_cs_akicks;
-CREATE TABLE anope_cs_akicks (
-  ck_id int(11) NOT NULL auto_increment,
-  channel varchar(255) NOT NULL default '',
-  flags int(11) NOT NULL default '0',
-  dmask varchar(255) NOT NULL,
-  reason text NOT NULL,
-  creator text NOT NULL,
-  addtime int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (ck_id),
-  UNIQUE KEY channel (channel,dmask)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_badwords'
--- 
-
-DROP TABLE IF EXISTS anope_cs_badwords;
-CREATE TABLE anope_cs_badwords (
-  cw_id int(11) NOT NULL auto_increment,
-  channel varchar(255) NOT NULL default '',
-  word varchar(255) NOT NULL,
-  `type` int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (cw_id),
-  UNIQUE KEY channel (channel,word)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_info'
--- 
-
-DROP TABLE IF EXISTS anope_cs_info;
-CREATE TABLE anope_cs_info (
-  ci_id int(11) NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
-  founder text NOT NULL,
-  successor text NOT NULL,
-  founderpass tinyblob NOT NULL,
-  descr text NOT NULL,
-  url text NOT NULL,
-  email text NOT NULL,
-  time_registered int(10) 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(10) unsigned NOT NULL default '0',
-  flags int(10) unsigned NOT NULL default '0',
-  forbidby text NOT NULL,
-  forbidreason text NOT NULL,
-  bantype smallint(6) NOT NULL default '0',
-  accesscount smallint(6) NOT NULL default '0',
-  akickcount smallint(6) NOT NULL default '0',
-  mlock_on int(10) unsigned NOT NULL default '0',
-  mlock_off int(10) unsigned NOT NULL default '0',
-  mlock_limit int(10) unsigned NOT NULL default '0',
-  mlock_key text NOT NULL,
-  mlock_flood text NOT NULL,
-  mlock_redirect text NOT NULL,
-  entry_message text NOT NULL,
-  memomax smallint(5) unsigned NOT NULL default '0',
-  botnick varchar(255) NOT NULL default '',
-  botflags int(10) unsigned NOT NULL default '0',
-  bwcount smallint(6) NOT NULL default '0',
-  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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (ci_id),
-  UNIQUE KEY `name` (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_levels'
--- 
-
-DROP TABLE IF EXISTS anope_cs_levels;
-CREATE TABLE anope_cs_levels (
-  cl_id int(11) NOT NULL auto_increment,
-  channel varchar(255) NOT NULL default '',
-  position int(11) NOT NULL default '0',
-  `level` int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (cl_id),
-  UNIQUE KEY channel (channel,position)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_cs_ttb'
--- 
-
-DROP TABLE IF EXISTS anope_cs_ttb;
-CREATE TABLE anope_cs_ttb (
-  ct_id int(11) NOT NULL auto_increment,
-  channel varchar(255) NOT NULL default '',
-  ttb_id int(11) NOT NULL default '0',
-  `value` int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (ct_id),
-  UNIQUE KEY channel (channel,ttb_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_hs_core'
--- 
-
-DROP TABLE IF EXISTS anope_hs_core;
-CREATE TABLE anope_hs_core (
-  bs_id int(11) NOT NULL auto_increment,
-  nick varchar(255) NOT NULL default '',
-  vident text NOT NULL,
-  vhost text NOT NULL,
-  creator text NOT NULL,
-  `time` int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (bs_id),
-  UNIQUE KEY nick (nick)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_info'
--- 
-
-DROP TABLE IF EXISTS anope_info;
-CREATE TABLE anope_info (
-  version int(11) default NULL,
-  `date` datetime default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_ms_info'
--- 
-
-DROP TABLE IF EXISTS anope_ms_info;
-CREATE TABLE anope_ms_info (
-  nm_id int(11) NOT NULL auto_increment,
-  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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (nm_id),
-  UNIQUE KEY nm_id (nm_id,serv),
-  KEY receiver (receiver,serv)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_ns_access'
--- 
-
-DROP TABLE IF EXISTS anope_ns_access;
-CREATE TABLE anope_ns_access (
-  na_id int(11) NOT NULL auto_increment,
-  display varchar(255) NOT NULL default '',
-  access text NOT NULL,
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (na_id),
-  UNIQUE KEY display (display)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_ns_alias'
--- 
-
-DROP TABLE IF EXISTS anope_ns_alias;
-CREATE TABLE anope_ns_alias (
-  na_id int(11) NOT NULL auto_increment,
-  display varchar(255) NOT NULL default '',
-  nick varchar(255) NOT NULL default '',
-  time_registered int(10) unsigned NOT NULL default '0',
-  last_seen int(10) unsigned NOT NULL default '0',
-  `status` int(11) unsigned NOT NULL default '0',
-  last_usermask text NOT NULL,
-  last_realname text NOT NULL,
-  last_quit text NOT NULL,
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (na_id),
-  UNIQUE KEY nick (nick)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_ns_core'
--- 
-
-DROP TABLE IF EXISTS anope_ns_core;
-CREATE TABLE anope_ns_core (
-  nc_id int(11) NOT NULL auto_increment,
-  display varchar(255) NOT NULL default '',
-  pass tinyblob NOT NULL,
-  email text NOT NULL,
-  icq int(10) unsigned NOT NULL default '0',
-  url text NOT NULL,
-  flags int(11) NOT NULL default '0',
-  `language` smallint(5) unsigned NOT NULL default '0',
-  accesscount smallint(6) NOT NULL default '0',
-  memocount smallint(5) unsigned NOT NULL default '0',
-  memomax smallint(5) unsigned NOT NULL default '0',
-  channelcount smallint(5) unsigned NOT NULL default '0',
-  greet text NOT NULL,
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (nc_id),
-  UNIQUE KEY display (display)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_ns_request'
--- 
-
-DROP TABLE IF EXISTS anope_ns_request;
-CREATE TABLE anope_ns_request (
-  nr_id int(11) NOT NULL auto_increment,
-  nick varchar(255) NOT NULL default '',
-  passcode text NOT NULL,
-  `password` tinyblob NOT NULL,
-  email text NOT NULL,
-  requested int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (nr_id),
-  UNIQUE KEY nick (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 (
-  ok_id int(11) NOT NULL auto_increment,
-  `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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (ok_id),
-  UNIQUE KEY `user` (`user`,host)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_core'
--- 
-
-DROP TABLE IF EXISTS anope_os_core;
-CREATE TABLE anope_os_core (
-  oc_id int(11) NOT NULL auto_increment,
-  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',
-  PRIMARY KEY  (oc_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_exceptions'
--- 
-
-DROP TABLE IF EXISTS anope_os_exceptions;
-CREATE TABLE anope_os_exceptions (
-  oe_id int(11) NOT NULL auto_increment,
-  mask varchar(255) NOT NULL,
-  lim 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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (oe_id),
-  UNIQUE KEY mask (mask)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_news'
--- 
-
-DROP TABLE IF EXISTS anope_os_news;
-CREATE TABLE anope_os_news (
-  on_id int(11) NOT NULL auto_increment,
-  `type` int(11) NOT NULL default '0',
-  num int(11) NOT NULL default '0',
-  ntext text NOT NULL,
-  who text NOT NULL,
-  `time` int(11) NOT NULL default '0',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (on_id),
-  UNIQUE KEY `type` (`type`,num,`time`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_sglines'
--- 
-
-DROP TABLE IF EXISTS anope_os_sglines;
-CREATE TABLE anope_os_sglines (
-  og_id int(11) NOT NULL auto_increment,
-  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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (og_id),
-  UNIQUE KEY mask (mask)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_sqlines'
--- 
-
-DROP TABLE IF EXISTS anope_os_sqlines;
-CREATE TABLE anope_os_sqlines (
-  og_id int(11) NOT NULL auto_increment,
-  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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (og_id),
-  UNIQUE KEY mask (mask)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- --------------------------------------------------------
-
--- 
--- Table structure for table 'anope_os_szlines'
--- 
-
-DROP TABLE IF EXISTS anope_os_szlines;
-CREATE TABLE anope_os_szlines (
-  og_id int(11) NOT NULL auto_increment,
-  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',
-  active tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (og_id),
-  UNIQUE KEY mask (mask)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;