tududi/backend/migrations/20251124000001-add-defer-until-to-tasks.js
Chris b2a5a4c63e
Feat add defer until date (#592)
* Add defer until datetime

* fixup! Add defer until datetime

* fixup! fixup! Add defer until datetime

* fixup! fixup! fixup! Add defer until datetime

* fixup! fixup! fixup! fixup! Add defer until datetime

* fixup! fixup! fixup! fixup! fixup! Add defer until datetime

* fixup! fixup! fixup! fixup! fixup! fixup! Add defer until datetime
2025-11-24 21:57:30 +02:00

26 lines
785 B
JavaScript

'use strict';
const { safeAddColumns, safeAddIndex } = require('../utils/migration-utils');
module.exports = {
async up(queryInterface, Sequelize) {
await safeAddColumns(queryInterface, 'tasks', [
{
name: 'defer_until',
definition: {
type: Sequelize.DATE,
allowNull: true,
comment:
'Date and time when the task becomes visible/actionable',
},
},
]);
await safeAddIndex(queryInterface, 'tasks', ['defer_until']);
},
async down(queryInterface) {
await queryInterface.removeIndex('tasks', ['defer_until']);
await queryInterface.removeColumn('tasks', 'defer_until');
},
};