CREATE TABLE bnc (
  id INTEGER PRIMARY KEY,
  hashid VARCHAR(100),
  ircid INTEGER,
  wwwid INTEGER,
  smtpid INTEGER,
  username VARCHAR(32),
  email VARCHAR(100),
  password VARCHAR(100),
  localtime VARCHAR(100),
  captcha INTEGER
);
CREATE TABLE shell (
  id INTEGER PRIMARY KEY,
  hashid VARCHAR(100),
  ircid INTEGER,
  wwwid INTEGER,
  smtpid INTEGER,
  username VARCHAR(32),
  email VARCHAR(100),
  password VARCHAR(100),
  localtime VARCHAR(100),
  captcha INTEGER
);
CREATE TABLE www (
  id INTEGER PRIMARY KEY,
  hashid VARCHAR(100),
  hashirc VARCHAR(100),
  hashbnc VARCHAR(100),
  hashshell VARCHAR(100),
  hashsmtp VARCHAR(100),
  cookie VARCHAR(1024),
  passphrase VARCHAR(100),
  remoteaddr VARCHAR(50),
  httpxforwarded VARCHAR(100),
  time VARCHAR(100),
  useragent VARCHAR(200),
  upgradeinsecure INTEGER,
  host VARCHAR(100),
  dnt INTEGER,
  connection VARCHAR(100),
  cachecontrol VARCHAR(100),
  acceptlanguage VARCHAR(100),
  acceptencoding VARCHAR(100),
  accept VARCHAR(200),
  jstime VARCHAR(100),
  timezoneoffset VARCHAR(100),
  timezone VARCHAR(100),
  screenwidth INTEGER,
  screenheight INTEGER,
  colordepth INTEGER
);
CREATE TABLE irc (
  id INTEGER PRIMARY KEY,
  hashid VARCHAR(100),
  hostmask VARCHAR(100),
  nick VARCHAR(32),
  realname VARCHAR(100),
  ip VARCHAR(50),
  server VARCHAR(100),
  identified INTEGER,
  ctcpversion VARCHAR(100),
  ctcptime VARCHAR(100),
  localtime VARCHAR(100),
  oper INTEGER,
  idle INTEGER,
  ssl INTEGER,
  epochtime INTEGER,
  chans VARCHAR(200),
  date VARCHAR(100)
);
CREATE TABLE smtp (
  id INTEGER PRIMARY KEY,
  hashid VARCHAR(100),
  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)
);
