summaryrefslogtreecommitdiff
path: root/extras/m_sqllog.mysql.sql
diff options
context:
space:
mode:
authorpeavey <peavey@e03df62e-2008-0410-955e-edbf42e46eb7>2007-07-16 17:14:45 +0000
committerpeavey <peavey@e03df62e-2008-0410-955e-edbf42e46eb7>2007-07-16 17:14:45 +0000
commitbab14f0dd2345c9d7dcbc47c918563709e1ac094 (patch)
tree753a23cfc9fc08c6697e80b3e686f074aa911d85 /extras/m_sqllog.mysql.sql
parent3abff3a37550cc1d88dd4d1fd7ed526e89309a53 (diff)
'svn propset -R svn:eol-style CR *' Set to UNIX-style always. Binaries are auto skipped by svn.
git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@7454 e03df62e-2008-0410-955e-edbf42e46eb7
Diffstat (limited to 'extras/m_sqllog.mysql.sql')
-rw-r--r--extras/m_sqllog.mysql.sql79
1 files changed, 1 insertions, 78 deletions
diff --git a/extras/m_sqllog.mysql.sql b/extras/m_sqllog.mysql.sql
index 0793b0543..ce413bf82 100644
--- a/extras/m_sqllog.mysql.sql
+++ b/extras/m_sqllog.mysql.sql
@@ -1,78 +1 @@
--- MySQL dump 9.11
---
--- Host: localhost Database: brain
--- ------------------------------------------------------
--- Server version 4.0.20
-
---
--- Table structure for table `ircd_log`
---
-
-CREATE TABLE ircd_log (
- id bigint(20) NOT NULL auto_increment,
- category_id bigint(20) NOT NULL default '0',
- nick bigint(20) default NULL,
- host bigint(20) default NULL,
- source bigint(20) default NULL,
- dtime bigint(20) NOT NULL default '0',
- PRIMARY KEY (id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `ircd_log`
---
-
-
---
--- Table structure for table `ircd_log_categories`
---
-
-CREATE TABLE ircd_log_categories (
- category_id bigint(20) NOT NULL default '0',
- category text NOT NULL,
- PRIMARY KEY (category_id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `ircd_log_categories`
---
-
-INSERT INTO ircd_log_categories VALUES (1,'Oper');
-INSERT INTO ircd_log_categories VALUES (2,'Kill');
-INSERT INTO ircd_log_categories VALUES (3,'Server Link');
-INSERT INTO ircd_log_categories VALUES (4,'G/Z/K/E Line');
-INSERT INTO ircd_log_categories VALUES (5,'Connect');
-INSERT INTO ircd_log_categories VALUES (6,'Disconnect');
-INSERT INTO ircd_log_categories VALUES (7,'Flooding');
-INSERT INTO ircd_log_categories VALUES (8,'Load Module');
-
---
--- Table structure for table `ircd_log_actors`
---
-
-CREATE TABLE ircd_log_actors (
- id bigint(20) NOT NULL auto_increment,
- actor text,
- PRIMARY KEY (id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `ircd_log_actors`
---
-
-
---
--- Table structure for table `ircd_log_hosts`
---
-
-CREATE TABLE ircd_log_hosts (
- id bigint(20) NOT NULL auto_increment,
- hostname text,
- PRIMARY KEY (id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `ircd_log_hosts`
---
-
-
+-- MySQL dump 9.11 -- -- Host: localhost Database: brain -- ------------------------------------------------------ -- Server version 4.0.20 -- -- Table structure for table `ircd_log` -- CREATE TABLE ircd_log ( id bigint(20) NOT NULL auto_increment, category_id bigint(20) NOT NULL default '0', nick bigint(20) default NULL, host bigint(20) default NULL, source bigint(20) default NULL, dtime bigint(20) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `ircd_log` -- -- -- Table structure for table `ircd_log_categories` -- CREATE TABLE ircd_log_categories ( category_id bigint(20) NOT NULL default '0', category text NOT NULL, PRIMARY KEY (category_id) ) TYPE=MyISAM; -- -- Dumping data for table `ircd_log_categories` -- INSERT INTO ircd_log_categories VALUES (1,'Oper'); INSERT INTO ircd_log_categories VALUES (2,'Kill'); INSERT INTO ircd_log_categories VALUES (3,'Server Link'); INSERT INTO ircd_log_categories VALUES (4,'G/Z/K/E Line'); INSERT INTO ircd_log_categories VALUES (5,'Connect'); INSERT INTO ircd_log_categories VALUES (6,'Disconnect'); INSERT INTO ircd_log_categories VALUES (7,'Flooding'); INSERT INTO ircd_log_categories VALUES (8,'Load Module'); -- -- Table structure for table `ircd_log_actors` -- CREATE TABLE ircd_log_actors ( id bigint(20) NOT NULL auto_increment, actor text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `ircd_log_actors` -- -- -- Table structure for table `ircd_log_hosts` -- CREATE TABLE ircd_log_hosts ( id bigint(20) NOT NULL auto_increment, hostname text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `ircd_log_hosts` -- \ No newline at end of file