X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Finitializers%2Fmigrations%2F0200-video-published-at.ts;h=d8c7b42a767176cfbb98bea3b7be774d905cedd0;hb=0882c8e6509b2a4ea48f6c48ecb2aa4aa371500a;hp=edaf4a145c0f37d6c9a61ac8bca9c7d6c9e1efc5;hpb=2922e048de95738b3319054ce0778f873a34a0ee;p=github%2FChocobozzz%2FPeerTube.git

diff --git a/server/initializers/migrations/0200-video-published-at.ts b/server/initializers/migrations/0200-video-published-at.ts
index edaf4a145..d8c7b42a7 100644
--- a/server/initializers/migrations/0200-video-published-at.ts
+++ b/server/initializers/migrations/0200-video-published-at.ts
@@ -1,15 +1,15 @@
 import * as Sequelize from 'sequelize'
 
 async function up (utils: {
-  transaction: Sequelize.Transaction,
-  queryInterface: Sequelize.QueryInterface,
+  transaction: Sequelize.Transaction
+  queryInterface: Sequelize.QueryInterface
   sequelize: Sequelize.Sequelize
 }): Promise<void> {
 
   {
     const data = {
       type: Sequelize.DATE,
-      allowNull: false,
+      allowNull: true,
       defaultValue: Sequelize.NOW
     }
     await utils.queryInterface.addColumn('video', 'publishedAt', data)
@@ -20,6 +20,16 @@ async function up (utils: {
     await utils.sequelize.query(query)
   }
 
+  // Sequelize does not alter the column with NOW as default value
+  {
+    const data = {
+      type: Sequelize.DATE,
+      allowNull: false,
+      defaultValue: Sequelize.NOW
+    }
+    await utils.queryInterface.changeColumn('video', 'publishedAt', data)
+  }
+
 }
 
 function down (options) {