Initial Anope Import

git-svn-id: svn://svn.anope.org/anope/trunk@1 31f1291d-b8d6-0310-a050-a5561fc1590b


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

1 files changed, 470 insertions, 0 deletions

diff --git a/data/tables.sql b/data/tables.sql
new file mode 100644
index 000000000..533a4c6e8
--- /dev/null
+++ b/data/tables.sql
@@ -0,0 +1,470 @@
+
+-- If you need to create your db, uncomment the following lines.
+-- create database anope;
+-- use anope;
+
+--
+-- 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
+) TYPE=MyISAM;
+
+--
+-- 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',
+  PRIMARY KEY  (bs_id),
+  UNIQUE KEY nick (nick),
+  KEY nick_index (nick(10))
+) TYPE=MyISAM;
+
+--
+-- 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',
+  PRIMARY KEY  (ca_id)
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  reason text NOT NULL,
+  creator text NOT NULL,
+  addtime int(11) NOT NULL default '0',
+  PRIMARY KEY  (ck_id)
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  type int(11) NOT NULL default '0',
+  PRIMARY KEY  (cw_id)
+) TYPE=MyISAM;
+
+--
+-- 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',
+  ttb smallint(6) 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),
+  KEY name_index (name(10))
+) TYPE=MyISAM;
+
+--
+-- 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',
+  PRIMARY KEY  (cl_id)
+) TYPE=MyISAM;
+
+--
+-- 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',
+  PRIMARY KEY  (bs_id),
+  UNIQUE KEY nick (nick),
+  KEY nick_index (nick(10))
+) TYPE=MyISAM;
+
+--
+-- 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 text 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',
+  PRIMARY KEY  (nm_id)
+) TYPE=MyISAM;
+
+--
+-- 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,
+  PRIMARY KEY  (na_id)
+) TYPE=MyISAM;
+
+--
+-- 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 smallint(6) 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),
+  KEY nick_index (nick(10))
+) TYPE=MyISAM;
+
+--
+-- 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',
+  channelmax 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),
+  KEY display_index (display(10))
+) TYPE=MyISAM;
+
+--
+-- 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 int(1) NOT NULL default '1',
+  PRIMARY KEY  (nr_id),
+  UNIQUE KEY nick (nick),
+  KEY nick_index (nick(10))
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  host text NOT NULL,
+  xby text NOT NULL,
+  reason text NOT NULL,
+  seton int(11) NOT NULL default '0',
+  expire int(11) NOT NULL default '0',
+  PRIMARY KEY  (ok_id)
+) TYPE=MyISAM;
+
+--
+-- 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)
+) TYPE=MyISAM;
+
+--
+-- 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 text 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',
+  PRIMARY KEY  (oe_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `anope_os_hcache`
+--
+
+DROP TABLE IF EXISTS anope_os_hcache;
+CREATE TABLE anope_os_hcache (
+  oh_id int(11) NOT NULL auto_increment,
+  mask text NOT NULL,
+  status int(11) NOT NULL default '0',
+  used int(11) NOT NULL default '0',
+  PRIMARY KEY  (oh_id)
+) TYPE=MyISAM;
+
+--
+-- 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',
+  PRIMARY KEY  (on_id)
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  xby text NOT NULL,
+  reason text NOT NULL,
+  seton int(11) NOT NULL default '0',
+  expire int(11) NOT NULL default '0',
+  PRIMARY KEY  (og_id)
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  xby text NOT NULL,
+  reason text NOT NULL,
+  seton int(11) NOT NULL default '0',
+  expire int(11) NOT NULL default '0',
+  PRIMARY KEY  (og_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `anope_os_status`
+--
+
+DROP TABLE IF EXISTS anope_os_status;
+CREATE TABLE anope_os_status (
+  os_id int(11) NOT NULL auto_increment,
+  host text NOT NULL,
+  status int(11) NOT NULL default '0',
+  used int(11) NOT NULL default '0',
+  PRIMARY KEY  (os_id)
+) TYPE=MyISAM;
+
+--
+-- 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 text NOT NULL,
+  xby text NOT NULL,
+  reason text NOT NULL,
+  seton int(11) NOT NULL default '0',
+  expire int(11) NOT NULL default '0',
+  PRIMARY KEY  (og_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `bugs`
+--
+
+DROP TABLE IF EXISTS bugs;
+CREATE TABLE bugs (
+  b_id int(9) NOT NULL auto_increment,
+  b_moduleid int(9) NOT NULL default '0',
+  b_title varchar(40) NOT NULL default '',
+  b_desc text NOT NULL,
+  b_reporter varchar(15) NOT NULL default '',
+  PRIMARY KEY  (b_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `modules`
+--
+
+DROP TABLE IF EXISTS modules;
+CREATE TABLE modules (
+  m_id int(9) NOT NULL auto_increment,
+  m_name varchar(30) NOT NULL default '',
+  m_category enum('OperServ','NickServ','MemoServ','ChanServ','BotServ','HostServ','HelpServ','Misc') NOT NULL default 'Misc',
+  m_description longtext NOT NULL,
+  m_activated enum('0','1') NOT NULL default '0',
+  m_owner varchar(15) NOT NULL default '',
+  m_path varchar(40) NOT NULL default '',
+  m_updated date NOT NULL default '0000-00-00',
+  m_official enum('0','1') NOT NULL default '0',
+  m_version varchar(5) NOT NULL default '',
+  PRIMARY KEY  (m_id)
+) TYPE=MyISAM PACK_KEYS=0;
+
+--
+-- Table structure for table `requests`
+--
+
+DROP TABLE IF EXISTS requests;
+CREATE TABLE requests (
+  r_id int(3) NOT NULL auto_increment,
+  r_title varchar(30) NOT NULL default '',
+  r_category enum('OperServ','NickServ','MemoServ','ChanServ','BotServ','HostServ','HelpServ','Misc') NOT NULL default 'Misc',
+  r_description longtext NOT NULL,
+  r_owner varchar(15) NOT NULL default 'Anonymous',
+  r_assigned varchar(15) NOT NULL default '',
+  PRIMARY KEY  (r_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `uploaded`
+--
+
+DROP TABLE IF EXISTS uploaded;
+CREATE TABLE uploaded (
+  mu_id int(9) NOT NULL auto_increment,
+  mu_name varchar(30) NOT NULL default '',
+  mu_category enum('OperServ','NickServ','MemoServ','ChanServ','BotServ','HostServ','HelpServ','Misc') NOT NULL default 'Misc',
+  mu_description longtext NOT NULL,
+  mu_activated enum('0','1') NOT NULL default '0',
+  mu_owner varchar(15) NOT NULL default '',
+  mu_path varchar(40) NOT NULL default '',
+  mu_updated date NOT NULL default '0000-00-00',
+  mu_official enum('0','1') NOT NULL default '0',
+  mu_version varchar(5) NOT NULL default '',
+  PRIMARY KEY  (mu_id)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS users;
+CREATE TABLE users (
+  u_id int(9) NOT NULL auto_increment,
+  u_username varchar(15) NOT NULL default '',
+  u_password varchar(32) NOT NULL default '',
+  u_email varchar(40) NOT NULL default '',
+  u_location varchar(40) NOT NULL default '',
+  u_status enum('normal','coder','admin','root') NOT NULL default 'normal',
+  u_confirmed enum('0','1') NOT NULL default '1',
+  u_registered date NOT NULL default '0000-00-00',
+  u_lastvisit date NOT NULL default '0000-00-00',
+  u_hideemail enum('0','1') NOT NULL default '0',
+  PRIMARY KEY  (u_id)
+) TYPE=MyISAM PACK_KEYS=0;
+