-- $Id: update-project-2005-06-23.mysql,v 1.5 2005-11-06 19:45:39 killes Exp $

ALTER TABLE project_issues CHANGE state sid int(10) unsigned NOT NULL default '0';

CREATE TABLE project_issue_state (
  sid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  weight tinyint(2) DEFAULT '0' NOT NULL,
  author_has tinyint(2) DEFAULT '0' NOT NULL,
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

INSERT INTO project_issue_state VALUES (1, 'active', -13, 0);
INSERT INTO project_issue_state VALUES (2, 'fixed', 1, 0);
INSERT INTO project_issue_state VALUES (3, 'duplicate', 4, 0);
INSERT INTO project_issue_state VALUES (4, 'postponed', 6, 0);
INSERT INTO project_issue_state VALUES (5, 'won\'t fix', 9, 0);
INSERT INTO project_issue_state VALUES (6, 'by design', 11, 0);
INSERT INTO project_issue_state VALUES (7, 'closed', 13, 1);
INSERT INTO project_issue_state VALUES (8, 'patch (code needs review)', -8, 0);
INSERT INTO project_issue_state VALUES (13, 'patch (code needs work)', -6, 0);
INSERT INTO project_issue_state VALUES (14, 'patch (ready to commit)', -2, 0);