14 lines
605 B
SQL
14 lines
605 B
SQL
alter table posts rename column private to draft;
|
|
|
|
alter table posts rename column is_pinned to profile_pinned;
|
|
alter table posts rename column stickied to pinned;
|
|
alter table posts rename column stickied_utc to pinned_utc;
|
|
alter table comments rename column stickied to pinned;
|
|
alter table comments rename column stickied_utc to pinned_utc;
|
|
|
|
alter index post_is_pinned_idx rename to post_profile_pinned_idx;
|
|
alter index posts_stickied_idx rename to post_pinned_idex;
|
|
alter index post_sticked_utc_idx rename to post_pinned_utc_idex;
|
|
|
|
alter index comment_sticked_utc_idx rename to comment_pinned_utc_idex;
|