DataInventory

Details

diff --git a/database/migrations/1584139902145_modify_submission_dates_nullable_schema.js b/database/migrations/1584139902145_modify_submission_dates_nullable_schema.js
new file mode 100644
index 0000000..086c5dc
--- /dev/null
+++ b/database/migrations/1584139902145_modify_submission_dates_nullable_schema.js
@@ -0,0 +1,26 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class ModifySubmissionDatesNullableSchema extends Schema {
+  up () {
+    this.alter('submissions', (table) => {
+      // alter table
+      table.date('upload_date').nullable().alter()
+      table.date('creation_date').nullable().alter()
+      table.date('published_date').nullable().alter()
+    })
+  }
+
+  down () {
+    this.alter('submissions', (table) => {
+      // reverse alternations
+      table.date('upload_date').notNullable().alter()
+      table.date('creation_date').notNullable().alter()
+      table.date('published_date').notNullable().alter()
+    })
+  }
+}
+
+module.exports = ModifySubmissionDatesNullableSchema