Upgrading to Beaker 0.13¶

ALTER TABLE tg_group
    MODIFY group_name VARCHAR(16) NOT NULL,
    ADD COLUMN ldap BOOLEAN NOT NULL DEFAULT 0,
    ADD INDEX (ldap),
    ADD COLUMN root_password VARCHAR(255) AFTER display_name;

ALTER TABLE user_group
    ADD is_owner BOOLEAN DEFAULT FALSE;

ALTER TABLE job
    ADD COLUMN group_id int(11) default NULL AFTER owner_id,
    ADD CONSTRAINT `job_group_id_fk` FOREIGN KEY (group_id)
        REFERENCES `tg_group` (group_id);

ALTER TABLE tg_group
    MODIFY group_name VARCHAR(16) DEFAULT NULL,
    DROP COLUMN ldap,
    DROP COLUMN root_password;

ALTER TABLE user_group
    DROP COLUMN is_owner;

ALTER TABLE job
    DROP FOREIGN KEY job_group_id_fk, DROP COLUMN group_id;

ALTER TABLE job
    ADD INDEX (status),
    ADD INDEX (result);
ALTER TABLE recipe_set
    ADD INDEX (status),
    ADD INDEX (result),
    ADD INDEX (priority);
ALTER TABLE recipe
    ADD INDEX (status),
    ADD INDEX (result);

ALTER TABLE job
    DROP INDEX status,
    DROP INDEX result;
ALTER TABLE recipe_set
    DROP INDEX status,
    DROP INDEX result,
    DROP INDEX priority;
ALTER TABLE recipe
    DROP INDEX status,
    DROP INDEX result;

DELETE FROM system_status_duration
USING system_status_duration
LEFT JOIN (
    SELECT system_id, MAX(start_time) start_time
    FROM system_status_duration
    GROUP BY system_id) x
    ON system_status_duration.system_id = x.system_id
        AND system_status_duration.start_time = x.start_time
WHERE finish_time IS NULL
    AND x.start_time IS NULL;