Return to table.sql CVS log

Up to [local] / botnow

Annotation of botnow/table.sql, Revision 1.1.1.1

1.1       bountyht    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 VARCHAR(100),
                     11:   captcha INTEGER
                     12: );
                     13: CREATE TABLE shell (
                     14:   id INTEGER PRIMARY KEY,
                     15:   hashid VARCHAR(100),
                     16:   ircid INTEGER,
                     17:   wwwid INTEGER,
                     18:   smtpid INTEGER,
                     19:   username VARCHAR(32),
                     20:   email VARCHAR(100),
                     21:   password VARCHAR(100),
                     22:   localtime VARCHAR(100),
                     23:   captcha INTEGER
                     24: );
                     25: CREATE TABLE www (
                     26:   id INTEGER PRIMARY KEY,
                     27:   hashid VARCHAR(100),
                     28:   hashirc VARCHAR(100),
                     29:   hashbnc VARCHAR(100),
                     30:   hashshell VARCHAR(100),
                     31:   hashsmtp VARCHAR(100),
                     32:   cookie VARCHAR(1024),
                     33:   passphrase VARCHAR(100),
                     34:   remoteaddr VARCHAR(50),
                     35:   httpxforwarded VARCHAR(100),
                     36:   time VARCHAR(100),
                     37:   useragent VARCHAR(200),
                     38:   upgradeinsecure INTEGER,
                     39:   host VARCHAR(100),
                     40:   dnt INTEGER,
                     41:   connection VARCHAR(100),
                     42:   cachecontrol VARCHAR(100),
                     43:   acceptlanguage VARCHAR(100),
                     44:   acceptencoding VARCHAR(100),
                     45:   accept VARCHAR(200),
                     46:   jstime VARCHAR(100),
                     47:   timezoneoffset VARCHAR(100),
                     48:   timezone VARCHAR(100),
                     49:   screenwidth INTEGER,
                     50:   screenheight INTEGER,
                     51:   colordepth INTEGER
                     52: );
                     53: CREATE TABLE irc (
                     54:   id INTEGER PRIMARY KEY,
                     55:   hashid VARCHAR(100),
                     56:   hostmask VARCHAR(100),
                     57:   nick VARCHAR(32),
                     58:   realname VARCHAR(100),
                     59:   ip VARCHAR(50),
                     60:   server VARCHAR(100),
                     61:   identified INTEGER,
                     62:   ctcpversion VARCHAR(100),
                     63:   ctcptime VARCHAR(100),
                     64:   localtime VARCHAR(100),
                     65:   oper INTEGER,
                     66:   idle INTEGER,
                     67:   ssl INTEGER,
                     68:   epochtime INTEGER,
                     69:   chans VARCHAR(200),
                     70:   date VARCHAR(100)
                     71: );
                     72: CREATE TABLE smtp (
                     73:   id INTEGER PRIMARY KEY,
                     74:   hashid VARCHAR(100),
                     75:   sentfrom VARCHAR(100),
                     76:   returnpath VARCHAR(100),
                     77:   deliveredto VARCHAR(100),
                     78:   received VARCHAR(1000),
                     79:   dkim VARCHAR(1000),
                     80:   date VARCHAR(100),
                     81:   other VARCHAR(5000),
                     82:   content VARCHAR(100),
                     83:   mime VARCHAR(100),
                     84:   subject VARCHAR(100)
                     85: );