From f2acdbc3820f0f4f5ef76a0a64e73d2a320df91f Mon Sep 17 00:00:00 2001
From: peavey <peavey@e03df62e-2008-0410-955e-edbf42e46eb7>
Date: Mon, 16 Jul 2007 17:30:04 +0000
Subject: OOPS! We try again, since I'm smoking craq. LF is 0x0a NOT CR.

git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@7456 e03df62e-2008-0410-955e-edbf42e46eb7
---
 extras/m_sqllog.mysql.sql       | 79 ++++++++++++++++++++++++++++++++++++++++-
 extras/m_sqllog.postgresql.sql  | 52 ++++++++++++++++++++++++++-
 extras/m_sqllog.sqlite3.sql     | 35 +++++++++++++++++-
 extras/m_sqloper.mysql.sql      | 25 ++++++++++++-
 extras/m_sqloper.postgresql.sql | 15 +++++++-
 extras/m_sqloper.sqlite3.sql    |  8 ++++-
 6 files changed, 208 insertions(+), 6 deletions(-)

(limited to 'extras')

diff --git a/extras/m_sqllog.mysql.sql b/extras/m_sqllog.mysql.sql
index ce413bf82..0793b0543 100644
--- a/extras/m_sqllog.mysql.sql
+++ b/extras/m_sqllog.mysql.sql
@@ -1 +1,78 @@
--- 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
+-- 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`
+--
+
+
diff --git a/extras/m_sqllog.postgresql.sql b/extras/m_sqllog.postgresql.sql
index 561dba16d..2e40dd90d 100644
--- a/extras/m_sqllog.postgresql.sql
+++ b/extras/m_sqllog.postgresql.sql
@@ -1 +1,51 @@
---
-- 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
+--
+-- 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);
diff --git a/extras/m_sqllog.sqlite3.sql b/extras/m_sqllog.sqlite3.sql
index 020cda1d3..a0772e5e3 100644
--- a/extras/m_sqllog.sqlite3.sql
+++ b/extras/m_sqllog.sqlite3.sql
@@ -1 +1,34 @@
-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
+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
+);
+
diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index ee993c771..293a2aa70 100644
--- a/extras/m_sqloper.mysql.sql
+++ b/extras/m_sqloper.mysql.sql
@@ -1 +1,24 @@
--- 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
+-- 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`
+--
+
+
diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
index 199a656f6..fd640949f 100644
--- a/extras/m_sqloper.postgresql.sql
+++ b/extras/m_sqloper.postgresql.sql
@@ -1 +1,14 @@
---
-- 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
+--
+-- 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);
+
diff --git a/extras/m_sqloper.sqlite3.sql b/extras/m_sqloper.sqlite3.sql
index e33f77a93..1bb2937b8 100644
--- a/extras/m_sqloper.sqlite3.sql
+++ b/extras/m_sqloper.sqlite3.sql
@@ -1 +1,7 @@
-CREATE TABLE ircd_opers (
id integer primary key,
username text,
password text,
hostname text,
type text);

\ No newline at end of file
+CREATE TABLE ircd_opers (
+id integer primary key,
+username text,
+password text,
+hostname text,
+type text);
+
-- 
cgit v1.2.3