diff options
| -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, 12 insertions, 0 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 new file mode 100644 index 000000000000..0f14732f3845 --- /dev/null +++ b/migrations/2018-05-01-183232_simplified-post-view/down.sql @@ -0,0 +1 @@ +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 new file mode 100644 index 000000000000..280fef87003e --- /dev/null +++ b/migrations/2018-05-01-183232_simplified-post-view/up.sql @@ -0,0 +1,11 @@ +-- 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; |