Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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)
- ) 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',
- 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)
- ) 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement