Commit Diff
Diff:
e72bf83fdc57c15dd0e7b891d2a1f4653ac6ba19
de94df3c2d2ee7c309ae605ebd410aab8ba5d5b6
Commit:
de94df3c2d2ee7c309ae605ebd410aab8ba5d5b6
Tree:
0a2beb6d38f7ec647ab727b4346a8f3f8183c8d9
Author:
jrmu <jrmu@ircnow.org>
Committer:
jrmu <jrmu@ircnow.org>
Date:
Sun Oct 11 13:03:38 2020 UTC
Message:
Added table SQL
blob - /dev/null
blob + 14a44e14aff4af4d01d92629da87531b3617548e (mode 644)
--- /dev/null
+++ table.sql
@@ -0,0 +1,82 @@
+CREATE TABLE bnc (
+ uid VARCHAR(100), -- user@domain.com, for single sign on
+ vhost VARCHAR(100) PRIMARY KEY,
+ oldnick VARCHAR(32),
+ username VARCHAR(32),
+ realname VARCHAR(100),
+ email VARCHAR(100),
+ password VARCHAR(100),
+ ip VARCHAR(40),
+ server VARCHAR(100),
+ identified INTEGER,
+ ctcpversion VARCHAR(100),
+ ctcptime VARCHAR(100),
+ localtime VARCHAR(100),
+ oper INTEGER,
+ idle INTEGER,
+ ssl INTEGER,
+ epochtime INTEGER,
+ captcha INTEGER,
+ chans VARCHAR(100),
+ date VARCHAR(100)
+);
+CREATE TABLE www (
+ id INTEGER PRIMARY KEY,
+ useragent VARCHAR(200),
+ httpaccept VARCHAR(150),
+ plugins VARCHAR(200),
+ offset VARCHAR(10),
+ timezone VARCHAR(30),
+ screen VARCHAR(100),
+ systemfonts VARCHAR(200),
+ cookie VARCHAR(200),
+ supercookie VARCHAR(200),
+ canvashash VARCHAR(50),
+ webglhash VARCHAR(50),
+ webglvendor VARCHAR(50),
+ dnt INTEGER,
+ lang VARCHAR(50),
+ platform VARCHAR(100),
+ touch VARCHAR(100),
+ adblocker INTEGER,
+ audiocontext VARCHAR(100),
+ cpu VARCHAR(100),
+ concurrency INTEGER,
+ memory INTEGER
+);
+CREATE TABLE irc (
+ id INTEGER PRIMARY KEY,
+ uid VARCHAR(100),
+ vhost VARCHAR(100),
+ username VARCHAR(32),
+ ident VARCHAR(32),
+ realname VARCHAR(100),
+ email VARCHAR(100),
+ password VARCHAR(100),
+ ip VARCHAR(40),
+ server VARCHAR(100),
+ identified INTEGER,
+ ctcpversion VARCHAR(100),
+ ctcptime VARCHAR(100),
+ localtime VARCHAR(100),
+ oper INTEGER,
+ idle INTEGER,
+ ssl INTEGER,
+ epochtime INTEGER,
+ captcha INTEGER,
+ chans VARCHAR(100),
+ date VARCHAR(100)
+);
+CREATE TABLE smtp (
+ id INTEGER PRIMARY KEY,
+ sentfrom VARCHAR(100),
+ returnpath VARCHAR(100),
+ deliveredto VARCHAR(100),
+ received VARCHAR(1000),
+ dkim VARCHAR(1000),
+ date VARCHAR(100),
+ other VARCHAR(5000),
+ content VARCHAR(100),
+ mime VARCHAR(100),
+ subject VARCHAR(100)
+);