server/lib/db/migrations/20180311_add_github_to_comments.js from jsperf/jsperf.com

server/lib/db/migrations/20180311_add_github_to_comments.js

Summary

Maintainability

1 hr

Test Coverage

Issues
Source
Stats

Issues

module.exports = {
  up: function (genericQuery) {
    return genericQuery(`
      ALTER TABLE comments ADD COLUMN authorGitHub varchar(39) NOT NULL AFTER author, ADD INDEX gh_username (authorGitHub);
    `);
  },

  down: function (genericQuery) {
    return genericQuery(`
      ALTER TABLE comments DROP COLUMN authorGithub, DROP INDEX gh_username;
    `);
  }
};