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