From cc49ce55c8fdc5237d1b45c75df991cb958b46d9 Mon Sep 17 00:00:00 2001 From: Claudius Coenen Date: Mon, 16 Oct 2017 10:12:39 +0200 Subject: Fix #521 by converting content fields to LONGTEXT in MySQL, to prevent truncation of data. --- lib/migrations/20171009121200-longtext-for-mysql.js | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 lib/migrations/20171009121200-longtext-for-mysql.js (limited to 'lib/migrations') diff --git a/lib/migrations/20171009121200-longtext-for-mysql.js b/lib/migrations/20171009121200-longtext-for-mysql.js new file mode 100644 index 00000000..61b409ca --- /dev/null +++ b/lib/migrations/20171009121200-longtext-for-mysql.js @@ -0,0 +1,16 @@ +'use strict' +module.exports = { + up: function (queryInterface, Sequelize) { + queryInterface.changeColumn('Notes', 'content', {type: Sequelize.TEXT('long')}) + queryInterface.changeColumn('Revisions', 'patch', {type: Sequelize.TEXT('long')}) + queryInterface.changeColumn('Revisions', 'content', {type: Sequelize.TEXT('long')}) + queryInterface.changeColumn('Revisions', 'latContent', {type: Sequelize.TEXT('long')}) + }, + + down: function (queryInterface, Sequelize) { + queryInterface.changeColumn('Notes', 'content', {type: Sequelize.TEXT}) + queryInterface.changeColumn('Revisions', 'patch', {type: Sequelize.TEXT}) + queryInterface.changeColumn('Revisions', 'content', {type: Sequelize.TEXT}) + queryInterface.changeColumn('Revisions', 'latContent', {type: Sequelize.TEXT}) + } +} -- cgit v1.2.3