[dreamwidth/dw-free] acdf26: Support Ubuntu 20.04 and MySQL 8

[github]

Branch: refs/heads/update-dbs Home: https://github.com/dreamwidth/dw-free Commit: acdf264e9c9c5b4e2e0a25dbf041536ea1246fa9 https://github.com/dreamwidth/dw-free/commit/acdf264e9c9c5b4e2e0a25dbf041536ea1246fa9 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-23 (Sat, 23 Jan 2021)

Changed paths: A bin/dump-data.pl A bin/dump-tablecreates.pl R bin/dumpsql.pl M bin/upgrading/base-data.sql M bin/upgrading/moods.dat A bin/upgrading/proplists-local.dat M bin/upgrading/proplists.dat M bin/upgrading/update-db-general.pl M cgi-bin/DW/Auth/Challenge.pm M cgi-bin/DW/VirtualGiftTransaction.pm M cgi-bin/LJ/Global/Defaults.pm M cgi-bin/LJ/User/Account.pm M cgi-bin/LJ/User/Administration.pm A doc/dependencies-system-20.04 M t/console-moodthemes.t M t/post.t M t/userpic-keyword-select.t

Log Message:

---

Support Ubuntu 20.04 and MySQL 8

This modernizes a few things to support more recent versions of MySQL and Ubuntu. DO NOT RUN IN PRODUCTION YET.

[dreamwidth/dw-free] 3ead09: The has_subs table is unused

[github]

Branch: refs/heads/update-dbs Home: https://github.com/dreamwidth/dw-free Commit: 3ead092930452273a61dfbe7b3bb4a091d793c87 https://github.com/dreamwidth/dw-free/commit/3ead092930452273a61dfbe7b3bb4a091d793c87 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-23 (Sat, 23 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl M cgi-bin/LJ/DB.pm

Log Message:

---

The has_subs table is unused

[dreamwidth/dw-free] fb9410: Use latin1 encoding, even with binary collation co...

[github]

Branch: refs/heads/update-dbs Home: https://github.com/dreamwidth/dw-free Commit: fb9410c60747a6926f49f1f10a7aed78dd6a3b0d https://github.com/dreamwidth/dw-free/commit/fb9410c60747a6926f49f1f10a7aed78dd6a3b0d Author: Mark Smith mark@dreamwidth.org Date: 2021-01-23 (Sat, 23 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl

Log Message:

---

Use latin1 encoding, even with binary collation columns

[dreamwidth/dw-free] 68f43f: Remove unused tables subsprop, subsproplist

[github]

Branch: refs/heads/update-dbs Home: https://github.com/dreamwidth/dw-free Commit: 68f43fdca33c3269e685ff6af80286cade930c81 https://github.com/dreamwidth/dw-free/commit/68f43fdca33c3269e685ff6af80286cade930c81 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-23 (Sat, 23 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl M cgi-bin/LJ/DB.pm

Log Message:

---

Remove unused tables subsprop, subsproplist