summaryrefslogtreecommitdiff
path: root/extras
diff options
context:
space:
mode:
Diffstat (limited to 'extras')
-rw-r--r--extras/m_sqllog.mysql.sql79
-rw-r--r--extras/m_sqllog.postgresql.sql52
-rw-r--r--extras/m_sqllog.sqlite3.sql35
-rw-r--r--extras/m_sqloper.mysql.sql25
-rw-r--r--extras/m_sqloper.postgresql.sql15
-rw-r--r--extras/m_sqloper.sqlite3.sql8
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
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-26 07:26:39 +0000