a891b6b604
* fix: add column id to user_permissions and group_permissions * fix: don't drop ext * fix: put back default value
32 lines
813 B
JavaScript
32 lines
813 B
JavaScript
"use strict";
|
|
|
|
module.exports = {
|
|
async up(queryInterface, Sequelize) {
|
|
await queryInterface.sequelize.transaction(async (transaction) => {
|
|
await queryInterface.sequelize.query(
|
|
`CREATE EXTENSION IF NOT EXISTS "uuid-ossp";`,
|
|
{ transaction }
|
|
);
|
|
await queryInterface.addColumn(
|
|
"user_permissions",
|
|
"id",
|
|
{
|
|
type: Sequelize.UUID,
|
|
defaultValue: Sequelize.literal("uuid_generate_v4()"),
|
|
allowNull: false,
|
|
},
|
|
{ transaction }
|
|
);
|
|
await queryInterface.addConstraint("user_permissions", {
|
|
type: "PRIMARY KEY",
|
|
fields: ["id"],
|
|
transaction,
|
|
});
|
|
});
|
|
},
|
|
|
|
async down(queryInterface, Sequelize) {
|
|
await queryInterface.removeColumn("user_permissions", "id");
|
|
},
|
|
};
|