PostText/migrations/5/down.sql

29 lines
496 B
MySQL
Raw Permalink Normal View History

2022-08-22 15:00:45 +00:00
ALTER TABLE remarks
RENAME TO replies;
ALTER TABLE replies
2022-08-22 16:27:08 +00:00
RENAME remark_id
TO reply_id;
2022-08-22 15:00:45 +00:00
ALTER TABLE replies
2022-08-22 16:27:08 +00:00
RENAME remark_date
TO reply_date;
2022-08-22 15:00:45 +00:00
ALTER TABLE replies
2022-08-22 16:27:08 +00:00
RENAME remark_author
TO reply_author;
2022-08-22 15:00:45 +00:00
ALTER TABLE replies
2022-08-22 16:27:08 +00:00
RENAME remark_body
TO reply_body;
ALTER TABLE replies
RENAME CONSTRAINT remarks_thread_id_fkey
TO replies_thread_id_fkey;
ALTER INDEX remarks_pkey
RENAME TO replies_pkey;
ALTER SEQUENCE remarks_remark_id_seq
RENAME TO replies_reply_id_seq;