old_contents: var dbm = require('db-migrate');
  var type = dbm.dataType;
  
  exports.up = function(db, callback) {
    db.runSql("CREATE TABLE IF NOT EXISTS `badge` ("
              + "id               BIGINT AUTO_INCREMENT PRIMARY KEY,"
              + "name             VARCHAR(128) UNIQUE NOT NULL,"
              + "status           ENUM('draft', 'template', 'published', 'archived') NOT NULL"
              + ") ENGINE=InnoDB;", callback);
  };
  
  exports.down = function(db, callback) {
    db.runSql("DROP TABLE IF EXISTS `badge`;", callback);
  };
  
new_contents: var dbm = require('db-migrate');
  var type = dbm.dataType;
  
  exports.up = function(db, callback) {
    db.runSql("CREATE TABLE IF NOT EXISTS `badge` ("
              + "id               BIGINT AUTO_INCREMENT PRIMARY KEY,"
              + "name             VARCHAR(128) NOT NULL,"
              + "status           ENUM('draft', 'template', 'published', 'archived') NOT NULL"
              + ") ENGINE=InnoDB;", callback);
  };
  
  exports.down = function(db, callback) {
    db.runSql("DROP TABLE IF EXISTS `badge`;", callback);
  };
  
subject: Remove UNIQUE constraint until we're sure we need it, as it's easier to add later than remove