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: );
CVSweb