1 DROP TRIGGER IF EXISTS post_aggregates_featured_local ON post;
3 DROP TRIGGER IF EXISTS post_aggregates_featured_community ON post;
5 DROP FUNCTION post_aggregates_featured_community;
7 DROP FUNCTION post_aggregates_featured_local;
10 ADD stickied boolean NOT NULL DEFAULT FALSE;
15 stickied = featured_community;
18 DROP COLUMN featured_community;
21 DROP COLUMN featured_local;
23 ALTER TABLE post_aggregates
24 ADD stickied boolean NOT NULL DEFAULT FALSE;
29 stickied = featured_community;
31 ALTER TABLE post_aggregates
32 DROP COLUMN featured_community;
34 ALTER TABLE post_aggregates
35 DROP COLUMN featured_local;
37 ALTER TABLE mod_feature_post RENAME COLUMN featured TO stickied;
39 ALTER TABLE mod_feature_post
40 DROP COLUMN is_featured_community;
42 ALTER TABLE mod_feature_post
43 ALTER COLUMN stickied DROP NOT NULL;
45 ALTER TABLE mod_feature_post RENAME TO mod_sticky_post;
47 CREATE FUNCTION post_aggregates_stickied ()
55 stickied = NEW.stickied
62 CREATE TRIGGER post_aggregates_stickied
65 WHEN (OLD.stickied IS DISTINCT FROM NEW.stickied)
66 EXECUTE PROCEDURE post_aggregates_stickied ();