Return to table.sql CVS log

Up to [local] / botnow

Annotation of botnow/table.sql, Revision 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: );