1 files changed, 16 insertions, 0 deletions
diff --git a/catquery.py b/catquery.py
new file mode 100644
index 0000000..7b3bc5c
--- /dev/null
+++ b/catquery.py
@@ -0,0 +1,16 @@
+DB_SCHEMA =  \
+"""
+CREATE TABLE IF NOT EXISTS
+    events(
+            id INTEGER PRIMARY KEY AUTOINCREMENT,
+            type TEXT,
+            remarks TEXT,
+            correspond TEXT
+            )
+"""
+
+QUERY_INSERT_EVENT = \
+"""
+INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)
+
+"""