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)
+);