diff options
Diffstat (limited to 'migrations/2018-05-01-183232_simplified-post-view')
-rw-r--r-- | migrations/2018-05-01-183232_simplified-post-view/down.sql | 1 | ||||
-rw-r--r-- | migrations/2018-05-01-183232_simplified-post-view/up.sql | 11 |
2 files changed, 0 insertions, 12 deletions
diff --git a/migrations/2018-05-01-183232_simplified-post-view/down.sql b/migrations/2018-05-01-183232_simplified-post-view/down.sql deleted file mode 100644 index 0f14732f38..0000000000 --- a/migrations/2018-05-01-183232_simplified-post-view/down.sql +++ /dev/null @@ -1 +0,0 @@ -DROP VIEW simple_posts; diff --git a/migrations/2018-05-01-183232_simplified-post-view/up.sql b/migrations/2018-05-01-183232_simplified-post-view/up.sql deleted file mode 100644 index 280fef8700..0000000000 --- a/migrations/2018-05-01-183232_simplified-post-view/up.sql +++ /dev/null @@ -1,11 +0,0 @@ --- Creates a view for listing posts akin to the post table before --- splitting out users. This exists to avoid having to do joining --- logic and such inside of the application. - -CREATE VIEW simple_posts AS - SELECT p.id AS id, - thread_id, body, posted, user_id, - users.name AS author_name, - users.email AS author_email - FROM posts p - JOIN users ON users.id = p.user_id; |