6 files changed, 6 insertions, 208 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
diff --git a/extras/m_sqllog.postgresql.sql b/extras/m_sqllog.postgresql.sql
index 2e40dd90d..561dba16d 100644
--- a/extras/m_sqllog.postgresql.sql
+++ b/extras/m_sqllog.postgresql.sql
@@ -1,51 +1 @@
---
--- PostgreSQL database dump
---
-
-CREATE TABLE ircd_log (
-    id serial NOT NULL,
-    category_id bigint,
-    nick bigint,
-    host bigint,
-    source bigint,
-    dtime bigint DEFAULT 0 NOT NULL
-);
-ALTER TABLE ONLY ircd_log
-    ADD CONSTRAINT ircd_log_pkey PRIMARY KEY (id);
-
-
-
-CREATE TABLE ircd_log_actors (
-    id serial NOT NULL,
-    actor text
-);
-ALTER TABLE ONLY ircd_log_actors
-    ADD CONSTRAINT ircd_log_actors_pkey PRIMARY KEY (id);
-
-
-
-CREATE TABLE ircd_log_categories (
-    category_id serial NOT NULL,
-    category text NOT NULL
-);
-
-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');
-
-ALTER TABLE ONLY ircd_log_categories
-    ADD CONSTRAINT ircd_log_categories_pkey PRIMARY KEY (category_id);
-
-
-
-CREATE TABLE ircd_log_hosts (
-    id serial NOT NULL,
-    hostname text
-);
-ALTER TABLE ONLY ircd_log_hosts
-    ADD CONSTRAINT ircd_log_hosts_pkey PRIMARY KEY (id);
+--
-- PostgreSQL database dump
--

CREATE TABLE ircd_log (
    id serial NOT NULL,
    category_id bigint,
    nick bigint,
    host bigint,
    source bigint,
    dtime bigint DEFAULT 0 NOT NULL
);
ALTER TABLE ONLY ircd_log
    ADD CONSTRAINT ircd_log_pkey PRIMARY KEY (id);



CREATE TABLE ircd_log_actors (
    id serial NOT NULL,
    actor text
);
ALTER TABLE ONLY ircd_log_actors
    ADD CONSTRAINT ircd_log_actors_pkey PRIMARY KEY (id);



CREATE TABLE ircd_log_categories (
    category_id serial NOT NULL,
    category text NOT NULL
);

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');

ALTER TABLE ONLY ircd_log_categories
    ADD CONSTRAINT ircd_log_categories_pkey PRIMARY KEY (category_id);



CREATE TABLE ircd_log_hosts (
    id serial NOT NULL,
    hostname text
);
ALTER TABLE ONLY ircd_log_hosts
    ADD CONSTRAINT ircd_log_hosts_pkey PRIMARY KEY (id);
\ No newline at end of file
diff --git a/extras/m_sqllog.sqlite3.sql b/extras/m_sqllog.sqlite3.sql
index a0772e5e3..020cda1d3 100644
--- a/extras/m_sqllog.sqlite3.sql
+++ b/extras/m_sqllog.sqlite3.sql
@@ -1,34 +1 @@
-CREATE TABLE ircd_log (
-id integer primary key,
-category_id integer,
-nick integer,
-host integer,
-source integer,
-dtime integer);
-
-
-CREATE TABLE ircd_log_categories (
-  category_id integer primary key,
-  category text NOT NULL
-);
-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');
-
-
-CREATE TABLE ircd_log_actors (
-  id integer primary key,
-  actor text
-);
-
-
-CREATE TABLE ircd_log_hosts (
-  id integer primary key,
-  hostname text
-);
-
+CREATE TABLE ircd_log (
id integer primary key,
category_id integer,
nick integer,
host integer,
source integer,
dtime integer);


CREATE TABLE ircd_log_categories (
  category_id integer primary key,
  category text NOT NULL
);
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');


CREATE TABLE ircd_log_actors (
  id integer primary key,
  actor text
);


CREATE TABLE ircd_log_hosts (
  id integer primary key,
  hostname text
);

\ No newline at end of file
diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index 293a2aa70..ee993c771 100644
--- a/extras/m_sqloper.mysql.sql
+++ b/extras/m_sqloper.mysql.sql
@@ -1,24 +1 @@
--- MySQL dump 9.11
---
--- Host: localhost    Database: brain
--- ------------------------------------------------------
--- Server version	4.0.20
-
---
--- Table structure for table `ircd_opers`
---
-
-CREATE TABLE ircd_opers (
-  id bigint(20) NOT NULL auto_increment,
-  username text,
-  password text,
-  hostname text,
-  type text,
-  PRIMARY KEY  (id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table `ircd_opers`
---
-
-
+-- MySQL dump 9.11
--
-- Host: localhost    Database: brain
-- ------------------------------------------------------
-- Server version	4.0.20

--
-- Table structure for table `ircd_opers`
--

CREATE TABLE ircd_opers (
  id bigint(20) NOT NULL auto_increment,
  username text,
  password text,
  hostname text,
  type text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `ircd_opers`
--


\ No newline at end of file
diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
index fd640949f..199a656f6 100644
--- a/extras/m_sqloper.postgresql.sql
+++ b/extras/m_sqloper.postgresql.sql
@@ -1,14 +1 @@
---
--- PostgreSQL database dump
---
-
-CREATE TABLE ircd_opers (
-    id serial NOT NULL,
-    username text,
-    "password" text,
-    hostname text,
-    "type" text
-);
-ALTER TABLE ONLY ircd_opers
-    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);
-
+--
-- PostgreSQL database dump
--

CREATE TABLE ircd_opers (
    id serial NOT NULL,
    username text,
    "password" text,
    hostname text,
    "type" text
);
ALTER TABLE ONLY ircd_opers
    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);

\ No newline at end of file
diff --git a/extras/m_sqloper.sqlite3.sql b/extras/m_sqloper.sqlite3.sql
index 1bb2937b8..e33f77a93 100644
--- a/extras/m_sqloper.sqlite3.sql
+++ b/extras/m_sqloper.sqlite3.sql
@@ -1,7 +1 @@
-CREATE TABLE ircd_opers (
-id integer primary key,
-username text,
-password text,
-hostname text,
-type text);
-
+CREATE TABLE ircd_opers (
id integer primary key,
username text,
password text,
hostname text,
type text);

\ No newline at end of file