From 6b8f8eb33e0a3926125b7e3b1575599ab9020d44 Mon Sep 17 00:00:00 2001 From: Daniel De Graaf Date: Tue, 3 Aug 2010 21:37:48 -0400 Subject: Update a number of docs issues --- extras/m_sqllog.mssql.sql | 42 ----------------------- extras/m_sqllog.mysql.sql | 78 ------------------------------------------ extras/m_sqllog.postgresql.sql | 51 --------------------------- extras/m_sqllog.sqlite3.sql | 34 ------------------ 4 files changed, 205 deletions(-) delete mode 100644 extras/m_sqllog.mssql.sql delete mode 100644 extras/m_sqllog.mysql.sql delete mode 100644 extras/m_sqllog.postgresql.sql delete mode 100644 extras/m_sqllog.sqlite3.sql (limited to 'extras') 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 -); - -- cgit v1.2.3