1 DROP TRIGGER IF EXISTS post_aggregates_stickied ON post;
3 DROP FUNCTION post_aggregates_stickied;
6 ADD featured_community boolean NOT NULL DEFAULT FALSE;
9 ADD featured_local boolean NOT NULL DEFAULT FALSE;
14 featured_community = stickied;
19 ALTER TABLE post_aggregates
20 ADD featured_community boolean NOT NULL DEFAULT FALSE;
22 ALTER TABLE post_aggregates
23 ADD featured_local boolean NOT NULL DEFAULT FALSE;
28 featured_community = stickied;
30 ALTER TABLE post_aggregates
33 ALTER TABLE mod_sticky_post RENAME COLUMN stickied TO featured;
35 ALTER TABLE mod_sticky_post
36 ALTER COLUMN featured SET NOT NULL;
38 ALTER TABLE mod_sticky_post
39 ADD is_featured_community boolean NOT NULL DEFAULT TRUE;
41 ALTER TABLE mod_sticky_post RENAME TO mod_feature_post;
43 CREATE FUNCTION post_aggregates_featured_community ()
51 featured_community = NEW.featured_community
58 CREATE FUNCTION post_aggregates_featured_local ()
66 featured_local = NEW.featured_local
73 CREATE TRIGGER post_aggregates_featured_community
74 AFTER UPDATE ON public.post
76 WHEN (old.featured_community IS DISTINCT FROM new.featured_community)
77 EXECUTE FUNCTION public.post_aggregates_featured_community ();
79 CREATE TRIGGER post_aggregates_featured_local
80 AFTER UPDATE ON public.post
82 WHEN (old.featured_local IS DISTINCT FROM new.featured_local)
83 EXECUTE FUNCTION public.post_aggregates_featured_local ();