diff options
| -rw-r--r-- | extras/m_sqllog.sqlite3.sql | 34 |
1 files changed, 34 insertions, 0 deletions
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 +); + |