diff options
| author | dane dane@31f1291d-b8d6-0310-a050-a5561fc1590b <dane dane@31f1291d-b8d6-0310-a050-a5561fc1590b@5417fbe8-f217-4b02-8779-1006273d7864> | 2004-03-29 02:15:57 +0000 |
|---|---|---|
| committer | dane dane@31f1291d-b8d6-0310-a050-a5561fc1590b <dane dane@31f1291d-b8d6-0310-a050-a5561fc1590b@5417fbe8-f217-4b02-8779-1006273d7864> | 2004-03-29 02:15:57 +0000 |
| commit | b678823ca28b337e5e675977fcd12171748001e2 (patch) | |
| tree | 291dac2e78985d23e4c8ccba615458d4289c62ea /data/tables.sql | |
| parent | 811ce266630864719df94f757cde407c2b0cdd7d (diff) | |
BUILD : 1.6.0 (6) BUGS : none NOTES : Removed estra table definition from tables.sql. Minor fixes.
git-svn-id: svn://svn.anope.org/anope/trunk@6 31f1291d-b8d6-0310-a050-a5561fc1590b
git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/trunk@3 5417fbe8-f217-4b02-8779-1006273d7864
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 87 |
1 files changed, 0 insertions, 87 deletions
diff --git a/data/tables.sql b/data/tables.sql index 533a4c6e8..db9cbe8c1 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -381,90 +381,3 @@ CREATE TABLE anope_os_szlines ( 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; - |
