Ensembl/ensembl-hive

View on GitHub
sql/patch_2012-10-05.sql

Summary

Maintainability
Test Coverage

# Adding an 'EMPTY' status:

ALTER TABLE analysis_stats MODIFY COLUMN status enum('BLOCKED', 'LOADING', 'SYNCHING', 'EMPTY', 'READY', 'WORKING', 'ALL_CLAIMED', 'DONE', 'FAILED') DEFAULT 'EMPTY' NOT NULL;

ALTER TABLE analysis_stats_monitor MODIFY COLUMN status enum('BLOCKED', 'LOADING', 'SYNCHING', 'EMPTY', 'READY', 'WORKING', 'ALL_CLAIMED', 'DONE', 'FAILED') DEFAULT 'EMPTY' NOT NULL;