diff options
author | madt1m <blackjuniper@protonmail.com> | 2018-07-20 16:56:26 +0200 |
---|---|---|
committer | madt1m <blackjuniper@protonmail.com> | 2018-07-20 16:56:26 +0200 |
commit | 4cebfbabadfb6f500cf762923187017c47295961 (patch) | |
tree | 3e2b6ee4aec89d833c5c53ba9e203b2d9f723b7e | |
parent | 7f464b89296881f4d9ec032378c4418e832d17e3 (diff) | |
download | mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.tar.gz mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.tar.bz2 mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.zip |
session: Implemented SessionDB Schema
-rw-r--r-- | mitmproxy/io/sql/session_create.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mitmproxy/io/sql/session_create.sql b/mitmproxy/io/sql/session_create.sql new file mode 100644 index 00000000..8387981c --- /dev/null +++ b/mitmproxy/io/sql/session_create.sql @@ -0,0 +1,26 @@ +CREATE TABLE FLOW ( +FID INTEGER PRIMARY KEY, +MID INTEGER, +BID INTEGER, +CONTENT BLOB +); + +CREATE TABLE META ( +MID INTEGER PRIMARY KEY, +INTERCEPTED INTEGER, +MARKED INTEGER, +MODE VARCHAR(20) +); + +CREATE TABLE BODY ( +BID INTEGER, +BREQ BLOB, +BRES BLOB +); + +CREATE TABLE ANNOTATION ( +AID INTEGER PRIMARY KEY, +FID INTEGER, +TYPE VARCHAR(20), +CONTENT BLOB +);
\ No newline at end of file |