about summary refs log tree commit diff
path: root/web/converse/migrations/2018-04-08-133240_create_posts/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'web/converse/migrations/2018-04-08-133240_create_posts/up.sql')
-rw-r--r--web/converse/migrations/2018-04-08-133240_create_posts/up.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/web/converse/migrations/2018-04-08-133240_create_posts/up.sql b/web/converse/migrations/2018-04-08-133240_create_posts/up.sql
new file mode 100644
index 000000000000..7cf601fa2c54
--- /dev/null
+++ b/web/converse/migrations/2018-04-08-133240_create_posts/up.sql
@@ -0,0 +1,13 @@
+CREATE TABLE threads (
+  id SERIAL PRIMARY KEY,
+  title VARCHAR NOT NULL,
+  body TEXT NOT NULL,
+  posted TIMESTAMPTZ NOT NULL
+);
+
+CREATE TABLE posts (
+  id SERIAL PRIMARY KEY,
+  thread SERIAL REFERENCES threads (id),
+  body TEXT NOT NULL,
+  posted TIMESTAMPTZ NOT NULL
+);