Skip to content

Replace Database queries inside JSONs with designated columns

Moe requested to merge archive-and-sub-as-columns into dev

Some queries rely on data from the "details" column, which is stored in JSON. This merge will make those parameters into their own column in their respective tables. This change should also auto migrate users with the old database framework.

Major Changes :

  • sub parameter will be removed from Users details column. It will be replaced with subAccount as its own column.
  • archive parameter in Videos details will be made its own column. This feature was never exposed to regular users and will have no migration for any systems using it.

Merge request reports