1 files changed, 8 insertions, 0 deletions
diff --git a/db/create_table.py b/db/create_table.py
new file mode 100644
index 0000000..168fb16
--- /dev/null
+++ b/db/create_table.py
@@ -0,0 +1,8 @@
+import psycopg2
+import os
+
+conn = psycopg2.connect(os.environ.get("DATABASE_URL") or "dbname=questbook user=postgres")
+conn.cursor().execute("create table messages (id int, email varchar(255), name varchar(255), message varchar(2048))")
+conn.commit()
+
+