summaryrefslogtreecommitdiff
path: root/extras/m_sqllog.pgschema.sql
diff options
context:
space:
mode:
authorbrain <brain@e03df62e-2008-0410-955e-edbf42e46eb7>2007-01-15 00:45:23 +0000
committerbrain <brain@e03df62e-2008-0410-955e-edbf42e46eb7>2007-01-15 00:45:23 +0000
commit6b23783b71e98bae6aced7144c6730f028873cb6 (patch)
tree4d1a5f8f6831ab5adb6499c55099cce708256723 /extras/m_sqllog.pgschema.sql
parentf927c17c606bb6f13376a683f2f6776fc4c3e4c9 (diff)
Rename all these so that the names reflect the database server theyre used with more accurately -- for example, the old mysql ones were just .schema.sql, and
the postgres ones were .pgschema.sql. Theyre now .mysql.sql, .postgresql.sql and .sqlite3.sql git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@6345 e03df62e-2008-0410-955e-edbf42e46eb7
Diffstat (limited to 'extras/m_sqllog.pgschema.sql')
-rw-r--r--extras/m_sqllog.pgschema.sql51
1 files changed, 0 insertions, 51 deletions
diff --git a/extras/m_sqllog.pgschema.sql b/extras/m_sqllog.pgschema.sql
deleted file mode 100644
index 2e40dd90d..000000000
--- a/extras/m_sqllog.pgschema.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);