1 CREATE TABLE bnc (
2   id INTEGER PRIMARY KEY,
3   hashid VARCHAR(100),
4   ircid INTEGER,
5   wwwid INTEGER,
6   smtpid INTEGER,
7   username VARCHAR(32),
8   email VARCHAR(100),
9   password VARCHAR(100),
10   localtime INTEGER DEFAULT (unixepoch()),
11   datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
12   captcha INTEGER
13 );
14 CREATE TABLE shell (
15   id INTEGER PRIMARY KEY,
16   hashid VARCHAR(100),
17   ircid INTEGER,
18   wwwid INTEGER,
19   smtpid INTEGER,
20   username VARCHAR(32),
21   email VARCHAR(100),
22   password VARCHAR(100),
23   localtime INTEGER DEFAULT (unixepoch()),
24   datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
25   captcha INTEGER
26 );
27 CREATE TABLE mail (
28   id INTEGER PRIMARY KEY,
29   hashid VARCHAR(100),
30   ircid INTEGER,
31   wwwid INTEGER,
32   smtpid INTEGER,
33   username VARCHAR(32),
34   email VARCHAR(100),
35   password VARCHAR(100),
36   localtime INTEGER DEFAULT (unixepoch()),
37   datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
38   captcha INTEGER
39 );
40 CREATE TABLE vpn (
41   id INTEGER PRIMARY KEY,
42   hashid VARCHAR(100),
43   ircid INTEGER,
44   wwwid INTEGER,
45   smtpid INTEGER,
46   username VARCHAR(32),
47   email VARCHAR(100),
48   password VARCHAR(100),
49   localtime INTEGER DEFAULT (unixepoch()),
50   datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
51   captcha INTEGER
52 );
53 CREATE TABLE www (
54   id INTEGER PRIMARY KEY,
55   hashid VARCHAR(100),
56   hashirc VARCHAR(100),
57   hashbnc VARCHAR(100),
58   hashshell VARCHAR(100),
59   hashsmtp VARCHAR(100),
60   cookie VARCHAR(1024),
61   passphrase VARCHAR(100),
62   remoteaddr VARCHAR(50),
63   httpxforwarded VARCHAR(100),
64   time VARCHAR(100),
65   useragent VARCHAR(200),
66   upgradeinsecure INTEGER,
67   host VARCHAR(100),
68   dnt INTEGER,
69   connection VARCHAR(100),
70   cachecontrol VARCHAR(100),
71   acceptlanguage VARCHAR(100),
72   acceptencoding VARCHAR(100),
73   accept VARCHAR(200),
74   jstime VARCHAR(100),
75   timezoneoffset VARCHAR(100),
76   timezone VARCHAR(100),
77   screenwidth INTEGER,
78   screenheight INTEGER,
79   colordepth INTEGER
80 );
81 CREATE TABLE irc (
82   id INTEGER PRIMARY KEY,
83   hashid VARCHAR(100),
84   hostmask VARCHAR(100),
85   nick VARCHAR(32),
86   realname VARCHAR(100),
87   ip VARCHAR(50),
88   server VARCHAR(100),
89   identified INTEGER,
90   ctcpversion VARCHAR(100),
91   ctcptime VARCHAR(100),
92   localtime INTEGER DEFAULT (unixepoch()),
93   datetime VARCHAR(25) AS (datetime(localtime, 'unixepoch')),
94   oper INTEGER,
95   idle INTEGER,
96   ssl INTEGER,
97   epochtime INTEGER,
98   chans VARCHAR(200),
99   date VARCHAR(100)
100 );
101 CREATE TABLE smtp (
102   id INTEGER PRIMARY KEY,
103   hashid VARCHAR(100),
104   sentfrom VARCHAR(100),
105   returnpath VARCHAR(100),
106   deliveredto VARCHAR(100),
107   received VARCHAR(1000),
108   dkim VARCHAR(1000),
109   date VARCHAR(100),
110   other VARCHAR(5000),
111   content VARCHAR(100),
112   mime VARCHAR(100),
113   subject VARCHAR(100)
114 );