aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--mitmproxy/io/sql/session_create.sql26
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