diff options
Diffstat (limited to 'migrations/2018-05-01-183232_simplified-post-view/up.sql')
-rw-r--r-- | migrations/2018-05-01-183232_simplified-post-view/up.sql | 11 |
1 files changed, 0 insertions, 11 deletions
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; |