diff --git a/src/main/resources/update/1_3.sql b/src/main/resources/update/1_3.sql index 8001b9e..aa0c0bc 100644 --- a/src/main/resources/update/1_3.sql +++ b/src/main/resources/update/1_3.sql @@ -1 +1,5 @@ ALTER TABLE ACCOUNT ADD COLUMN IMAGE VARCHAR(100); + +ALTER TABLE COMMENT ALTER COLUMN ACTION VARCHAR(20); +UPDATE COMMENT SET ACTION = 'close_comment' WHERE ACTION = 'close'; +UPDATE COMMENT SET ACTION = 'reopen_comment' WHERE ACTION = 'reopen';