fix: [#56] db migration for imported users

josecelano · josecelano · commit b29d4d71ceba · 2022-11-30T13:57:50.000Z
Imported users from DB version v1.0.0 (only SQLite) do not have a
"date_registered" field. WE have to copy that behavior in MySQL even if
we do not have users imported from from previous versions in MySQL.

Support for MySQL was added after the version v1.0.0.
diff --git a/migrations/mysql/20221109092556_torrust_user_date_registered_allow_null.sql b/migrations/mysql/20221109092556_torrust_user_date_registered_allow_null.sql
@@ -1 +1 @@
-ALTER TABLE torrust_users CHANGE date_registered date_registered DATETIME NOT NULL
+ALTER TABLE torrust_users CHANGE date_registered date_registered DATETIME DEFAULT NULL

Original file line number	Diff line number	Diff line change
`@@ -1 +1 @@`
`1`		`-ALTER TABLE torrust_users CHANGE date_registered date_registered DATETIME NOT NULL`
	`1`	`+ALTER TABLE torrust_users CHANGE date_registered date_registered DATETIME DEFAULT NULL`