aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2017-10-01-193613_create_posts
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2017-10-01-193613_create_posts')
-rw-r--r--migrations/2017-10-01-193613_create_posts/down.sql2
-rw-r--r--migrations/2017-10-01-193613_create_posts/up.sql7
2 files changed, 9 insertions, 0 deletions
diff --git a/migrations/2017-10-01-193613_create_posts/down.sql b/migrations/2017-10-01-193613_create_posts/down.sql
new file mode 100644
index 0000000..e1d6323
--- /dev/null
+++ b/migrations/2017-10-01-193613_create_posts/down.sql
@@ -0,0 +1,2 @@
+-- Drop posts table
+DROP TABLE posts
diff --git a/migrations/2017-10-01-193613_create_posts/up.sql b/migrations/2017-10-01-193613_create_posts/up.sql
new file mode 100644
index 0000000..c0c36e5
--- /dev/null
+++ b/migrations/2017-10-01-193613_create_posts/up.sql
@@ -0,0 +1,7 @@
+-- Create posts table
+CREATE TABLE posts (
+ id SERIAL PRIMARY KEY,
+ title VARCHAR NOT NULL,
+ body TEXT NOT NULL,
+ published BOOLEAN NOT NULL DEFAULT 'f'
+)