diff options
author | Pietro Francesco Tirenna <pietrotirenna.pt@gmail.com> | 2018-07-24 16:26:10 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-07-24 16:26:10 +0200 |
commit | 9c949bd2f852fb5f5a314e6faa45e4869571628c (patch) | |
tree | bf2718f6ca8bd1088ccc9945c7d1b9be4ff62a59 /mitmproxy/io | |
parent | 16e07996d983483bb732269c921e89e8bda6ee20 (diff) | |
parent | 8c7793b91a2a182ec7d7831f2c03283dad3488cc (diff) | |
download | mitmproxy-9c949bd2f852fb5f5a314e6faa45e4869571628c.tar.gz mitmproxy-9c949bd2f852fb5f5a314e6faa45e4869571628c.tar.bz2 mitmproxy-9c949bd2f852fb5f5a314e6faa45e4869571628c.zip |
Merge pull request #3252 from madt1m/session-db
Session - Hybrid DB
Diffstat (limited to 'mitmproxy/io')
-rw-r--r-- | mitmproxy/io/sql/session_create.sql | 20 |
1 files changed, 20 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..bfc98b94 --- /dev/null +++ b/mitmproxy/io/sql/session_create.sql @@ -0,0 +1,20 @@ +CREATE TABLE flow ( +id VARCHAR(36) PRIMARY KEY, +content BLOB +); + +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 annotation ( +id INTEGER PRIMARY KEY, +flow_id VARCHAR(36), +type VARCHAR(16), +content BLOB, +FOREIGN KEY(flow_id) REFERENCES flow(id) +); |