diff options
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 470 |
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; + |