diff --git a/src/main/resources/update/1_3.sql b/src/main/resources/update/1_3.sql index aa0c0bc..59ab009 100644 --- a/src/main/resources/update/1_3.sql +++ b/src/main/resources/update/1_3.sql @@ -1,5 +1,8 @@ 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'; +UPDATE ISSUE_COMMENT SET ACTION = 'comment' WHERE ACTION IS NULL; + +ALTER TABLE ISSUE_COMMENT ALTER COLUMN ACTION VARCHAR(20) NOT NULL; + +UPDATE ISSUE_COMMENT SET ACTION = 'close_comment' WHERE ACTION = 'close'; +UPDATE ISSUE_COMMENT SET ACTION = 'reopen_comment' WHERE ACTION = 'reopen';