Update view for new status_stats table

1 files changed, 12 insertions, 1 deletions

diff --git a/install.sql b/install.sql
index 5fe7c82..4f73907 100644
--- a/install.sql
+++ b/install.sql
@@ -13,13 +13,24 @@ CREATE USER ambassador;
 
 -- Now, create the view that ambassador actually uses
 CREATE VIEW public_toots AS
-  SELECT *
+  SELECT 
+   statuses.id, statuses.reblog_of_id, statuses.account_id,
+   statuses.updated_at, status_stats.favourites_count
     FROM statuses
+    LEFT OUTER JOIN status_stats
+     ON statuses.id = status_stats.status_id
    WHERE visibility = 0
 ;
 
+-- Change 13104 to your ambassador's account ID
+CREATE VIEW blocks_ambassador AS
+  SELECT account_id
+    FROM blocks
+    WHERE target_account_id = 13104;
+
 -- Make sure the role doesn't have access to anything undesireable
 REVOKE ALL FROM ambassador;
 
 -- Let ambassador select from the view
 GRANT SELECT ON public_toots TO ambassador;
+GRANT SELECT ON blocks_ambassador TO ambassador;