3 -- Host: localhost Database: brain
4 -- ------------------------------------------------------
5 -- Server version 4.0.20
8 -- Table structure for table `ircd_log`
11 CREATE TABLE ircd_log (
12 id bigint(20) NOT NULL auto_increment,
13 category_id bigint(20) NOT NULL default '0',
14 nick bigint(20) default NULL,
15 host bigint(20) default NULL,
16 source bigint(20) default NULL,
17 dtime bigint(20) NOT NULL default '0',
22 -- Dumping data for table `ircd_log`
27 -- Table structure for table `ircd_log_categories`
30 CREATE TABLE ircd_log_categories (
31 category_id bigint(20) NOT NULL default '0',
32 category text NOT NULL,
33 PRIMARY KEY (category_id)
37 -- Dumping data for table `ircd_log_categories`
40 INSERT INTO ircd_log_categories VALUES (1,'Oper');
41 INSERT INTO ircd_log_categories VALUES (2,'Kill');
42 INSERT INTO ircd_log_categories VALUES (3,'Server Link');
43 INSERT INTO ircd_log_categories VALUES (4,'G/Z/K/E Line');
44 INSERT INTO ircd_log_categories VALUES (5,'Connect');
45 INSERT INTO ircd_log_categories VALUES (6,'Disconnect');
46 INSERT INTO ircd_log_categories VALUES (7,'Flooding');
47 INSERT INTO ircd_log_categories VALUES (8,'Load Module');
50 -- Table structure for table `ircd_log_actors`
53 CREATE TABLE ircd_log_actors (
54 id bigint(20) NOT NULL auto_increment,
60 -- Dumping data for table `ircd_log_actors`
65 -- Table structure for table `ircd_log_hosts`
68 CREATE TABLE ircd_log_hosts (
69 id bigint(20) NOT NULL auto_increment,
75 -- Dumping data for table `ircd_log_hosts`