[modules db table] Add default to content db field in mysql (already like that is postgresql and sqlsrv)

[andrepereiradasilva]

Summary of Changes

Add empty default value to #__modules content db field in mysql (already like that is postgresql and sqlsrv).

Testing Instructions

Mainly code review. But you can also:

• On update

  • Run the update query for your db system manually and check the db field now as a default value.

• On install

  • Use latest staging, apply patch
  • Delete configuration.php file and install as usual. Check all fine and the db field are correctly created.

Documentation Changes Required

None.

Notes

Although the issue was found on 4.0 because of a more strict sql_mode, this also applies in 3.x since this db field should always have a default value.

[yvesh]

I have tested this item ✅ successfully on 5e2d504

code review

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13035.}

[alikon]

I have tested this item ✅ successfully on 5e2d504

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13035.}

[jeckodevelopment]

I have tested this item ✅ successfully on 5e2d504

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13035.}

[jeckodevelopment]

RTC

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13035.}

[wilsonge]

What is this field used for? If it's not used I'd rather remove it in postgres and mssql than keep junk

[brianteeman]

@wilsonge it is the field that stores the content of any custom_html module