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