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 /mitmproxy/io | |
| parent | 7f464b89296881f4d9ec032378c4418e832d17e3 (diff) | |
| download | mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.tar.gz mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.tar.bz2 mitmproxy-4cebfbabadfb6f500cf762923187017c47295961.zip | |
session: Implemented SessionDB Schema
Diffstat (limited to 'mitmproxy/io')
| -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 |