From 085671219c2d477006db815efc03038178b989a4 Mon Sep 17 00:00:00 2001 From: peavey Date: Sun, 14 Jan 2007 23:12:17 +0000 Subject: SQLite3 schema for sql logging module. git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@6343 e03df62e-2008-0410-955e-edbf42e46eb7 --- extras/m_sqllog.sqlite3.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 extras/m_sqllog.sqlite3.sql (limited to 'extras') diff --git a/extras/m_sqllog.sqlite3.sql b/extras/m_sqllog.sqlite3.sql new file mode 100644 index 000000000..a0772e5e3 --- /dev/null +++ b/extras/m_sqllog.sqlite3.sql @@ -0,0 +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 +); + -- cgit v1.2.3