Merge pull request #409 from dementati/feat/397-398-metricity-db-and-api

Added metricity db connection and user bot API

1 files changed, 30 insertions, 0 deletions

diff --git a/postgres/init.sql b/postgres/init.sql
new file mode 100644
index 00000000..922ce1ad
--- /dev/null
+++ b/postgres/init.sql
@@ -0,0 +1,30 @@
+CREATE DATABASE metricity;
+
+\c metricity;
+
+CREATE TABLE users (
+    id varchar,
+    verified_at timestamp,
+    primary key(id)
+);
+
+INSERT INTO users VALUES (
+    0,
+    current_timestamp
+);
+
+CREATE TABLE messages (
+    id varchar,
+    author_id varchar references users(id),
+    primary key(id)
+);
+
+INSERT INTO messages VALUES(
+    0,
+    0
+);
+
+INSERT INTO messages VALUES(
+    1,
+    0
+);