summaryrefslogtreecommitdiff
path: root/extras
diff options
context:
space:
mode:
authorDaniel De Graaf <danieldg@inspircd.org>2010-08-03 21:37:48 -0400
committerDaniel De Graaf <danieldg@inspircd.org>2010-08-03 21:37:48 -0400
commit6b8f8eb33e0a3926125b7e3b1575599ab9020d44 (patch)
treef9e0e7ea70f380122eb6a25c9300a49b057e4014 /extras
parent11f88ab2cc6dd6c932d8984ba4063c93b59aa166 (diff)
Update a number of docs issues
Diffstat (limited to 'extras')
-rw-r--r--extras/m_sqllog.mssql.sql42
-rw-r--r--extras/m_sqllog.mysql.sql78
-rw-r--r--extras/m_sqllog.postgresql.sql51
-rw-r--r--extras/m_sqllog.sqlite3.sql34
4 files changed, 0 insertions, 205 deletions
diff --git a/extras/m_sqllog.mssql.sql b/extras/m_sqllog.mssql.sql
deleted file mode 100644
index 25882dc2e..000000000
--- a/extras/m_sqllog.mssql.sql
+++ /dev/null
@@ -1,42 +0,0 @@
-CREATE TABLE [dbo].[ircd_log] (
- [id] int IDENTITY(1, 1) NOT NULL,
- [category_id] int DEFAULT 0 NOT NULL,
- [nick] int NULL,
- [host] int NULL,
- [source] int NULL,
- [dtime] int DEFAULT 0 NOT NULL,
- PRIMARY KEY CLUSTERED ([id])
-)
-
-
-CREATE TABLE [dbo].[ircd_log_categories] (
- [category_id] int DEFAULT 0 NOT NULL,
- [category] varchar(255) NOT NULL,
- PRIMARY KEY CLUSTERED ([category_id])
-)
-
-
-/* Data for the `dbo.ircd_log_categories` table (Records 1 - 8) */
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (1, N'Oper')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (2, N'Kill')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (3, N'Server Link')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (4, N'G/Z/K/E Line')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (5, N'Connect')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (6, N'Disconnect')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (7, N'Flooding')
-INSERT INTO [dbo].[ircd_log_categories] ([category_id], [category]) VALUES (8, N'Load Module')
-
-
-CREATE TABLE [dbo].[ircd_log_actors] (
- [id] int IDENTITY(1, 1) NOT NULL,
- [actor] varchar(255) NULL,
- PRIMARY KEY CLUSTERED ([id])
-)
-
-
-CREATE TABLE [dbo].[ircd_log_hosts] (
- [id] int IDENTITY(1, 1) NOT NULL,
- [hostname] varchar(255) NULL,
- PRIMARY KEY CLUSTERED ([id])
-)
-
diff --git a/extras/m_sqllog.mysql.sql b/extras/m_sqllog.mysql.sql
deleted file mode 100644
index 0793b0543..000000000
--- a/extras/m_sqllog.mysql.sql
+++ /dev/null
@@ -1,78 +0,0 @@
--- 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
deleted file mode 100644
index 2e40dd90d..000000000
--- a/extras/m_sqllog.postgresql.sql
+++ /dev/null
@@ -1,51 +0,0 @@
---
--- 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
deleted file mode 100644
index a0772e5e3..000000000
--- a/extras/m_sqllog.sqlite3.sql
+++ /dev/null
@@ -1,34 +0,0 @@
-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
-);
-