diff options
author | madt1m <pietrotirenna.pt@gmail.com> | 2018-07-24 11:14:39 +0200 |
---|---|---|
committer | madt1m <pietrotirenna.pt@gmail.com> | 2018-07-24 11:58:33 +0200 |
commit | 68eb07b668b44074271b358b25e48ffd2b4726e0 (patch) | |
tree | f1511aadd514fe12727f5b9196aa1ddcbc60a8fe /mitmproxy/io | |
parent | 3b5cdf7f67e030fa0887bc309068b727f20918e3 (diff) | |
download | mitmproxy-68eb07b668b44074271b358b25e48ffd2b4726e0.tar.gz mitmproxy-68eb07b668b44074271b358b25e48ffd2b4726e0.tar.bz2 mitmproxy-68eb07b668b44074271b358b25e48ffd2b4726e0.zip |
session: modified schema. Now SessionDB uses tempfile module for temp session
Diffstat (limited to 'mitmproxy/io')
-rw-r--r-- | mitmproxy/io/sql/session_create.sql | 36 |
1 files changed, 15 insertions, 21 deletions
diff --git a/mitmproxy/io/sql/session_create.sql b/mitmproxy/io/sql/session_create.sql index 8387981c..bfc98b94 100644 --- a/mitmproxy/io/sql/session_create.sql +++ b/mitmproxy/io/sql/session_create.sql @@ -1,26 +1,20 @@ -CREATE TABLE FLOW ( -FID INTEGER PRIMARY KEY, -MID INTEGER, -BID INTEGER, -CONTENT BLOB +CREATE TABLE flow ( +id VARCHAR(36) PRIMARY KEY, +content BLOB ); -CREATE TABLE META ( -MID INTEGER PRIMARY KEY, -INTERCEPTED INTEGER, -MARKED INTEGER, -MODE VARCHAR(20) +CREATE TABLE body ( +id INTEGER PRIMARY KEY, +flow_id VARCHAR(36), +type_id INTEGER, +content BLOB, +FOREIGN KEY(flow_id) REFERENCES flow(id) ); -CREATE TABLE BODY ( -BID INTEGER, -BREQ BLOB, -BRES BLOB +CREATE TABLE annotation ( +id INTEGER PRIMARY KEY, +flow_id VARCHAR(36), +type VARCHAR(16), +content BLOB, +FOREIGN KEY(flow_id) REFERENCES flow(id) ); - -CREATE TABLE ANNOTATION ( -AID INTEGER PRIMARY KEY, -FID INTEGER, -TYPE VARCHAR(20), -CONTENT BLOB -);
\ No newline at end of file |