PostText/migrations/5/up.sql

29 lines
495 B
MySQL
Raw Permalink Normal View History

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