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 12 Jul 2013 244 bytes Expand column COMMENT.ACTION to VARCHAR(20).
Raw Blame History 
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';