From 07c616c764ec972836a1e2f746d4cc9a0b3d7731 Mon Sep 17 00:00:00 2001 From: Jannik Schönartz Date: Sun, 2 Dec 2018 23:52:52 +0000 Subject: [sequelize] Change clientid constraint onDelete Set NULL to cascade. Delete unnessesary ipxe file. --- server/migrations/20180805054700-create-backend_x_client.js | 6 +++--- server/migrations/20180805054700-create-backend_x_group.js | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) (limited to 'server/migrations') diff --git a/server/migrations/20180805054700-create-backend_x_client.js b/server/migrations/20180805054700-create-backend_x_client.js index ce2c3fe..9fe8cac 100644 --- a/server/migrations/20180805054700-create-backend_x_client.js +++ b/server/migrations/20180805054700-create-backend_x_client.js @@ -13,9 +13,9 @@ module.exports = { } }, clientId: { - allowNull: true, + allowNull: false, type: Sequelize.INTEGER, - onDelete: 'SET NULL', + onDelete: 'cascade', references: { model: 'clients', key: 'id' @@ -23,7 +23,7 @@ module.exports = { }, externalId: { primaryKey: true, - allowNull: true, + allowNull: false, type: Sequelize.INTEGER }, externalType: { diff --git a/server/migrations/20180805054700-create-backend_x_group.js b/server/migrations/20180805054700-create-backend_x_group.js index d187e24..26c2c42 100644 --- a/server/migrations/20180805054700-create-backend_x_group.js +++ b/server/migrations/20180805054700-create-backend_x_group.js @@ -13,9 +13,9 @@ module.exports = { } }, groupId: { - allowNull: true, + allowNull: false, type: Sequelize.INTEGER, - onDelete: 'SET NULL', + onDelete: 'cascade', references: { model: 'groups', key: 'id' @@ -23,7 +23,7 @@ module.exports = { }, externalId: { primaryKey: true, - allowNull: true, + allowNull: false, type: Sequelize.INTEGER }, externalType: { -- cgit v1.2.3-55-g7522