20200510140704_domains.js 721 B

123456789101112131415161718192021222324252627282930313233
  1. const models = require("../models");
  2. async function up(knex) {
  3. await models.createUserTable(knex);
  4. await models.createIPTable(knex);
  5. await models.createDomainTable(knex);
  6. await models.createHostTable(knex);
  7. await models.createLinkTable(knex);
  8. await models.createVisitTable(knex);
  9. await Promise.all([
  10. async () => {
  11. try {
  12. await knex.schema.alterTable("domains", (table) => {
  13. table.dropUnique([], "domains_user_id_unique");
  14. });
  15. } catch (ignored) {
  16. }
  17. },
  18. await knex.schema.alterTable("domains", (table) => {
  19. table.uuid("uuid").defaultTo(knex.fn.uuid());
  20. }),
  21. ]);
  22. }
  23. async function down() {
  24. // do nothing
  25. }
  26. module.exports = {
  27. up,
  28. down
  29. }