Fork: 0
johnpearcey / gitbucket_jkp
Transfer to URL with SHA Find file
Newer
Older
gitbucket_jkp / src / main / resources / update / 1_3.sql
@takezoe takezoe on 16 Jul 2013 339 bytes Change ISSUE_COMMENT.ACTION to NOT NULL.
Raw Blame History 
ALTER TABLE ACCOUNT ADD COLUMN IMAGE VARCHAR(100);

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';