mirror of
https://github.com/stashapp/stash.git
synced 2025-12-06 08:26:00 +01:00
7eae751d1c
* add rating100 fields to represent rating range 1-100 * deprecate existing (1-5) rating fields * add half- and quarter-star options for rating system * add decimal rating system option Co-authored-by: WithoutPants <53250216+WithoutPants@users.noreply.github.com>
6 lines
No EOL
409 B
SQL
6 lines
No EOL
409 B
SQL
UPDATE `scenes` SET `rating` = (`rating` * 20) WHERE `rating` < 6;
|
|
UPDATE `galleries` SET `rating` = (`rating` * 20) WHERE `rating` < 6;
|
|
UPDATE `images` SET `rating` = (`rating` * 20) WHERE `rating` < 6;
|
|
UPDATE `movies` SET `rating` = (`rating` * 20) WHERE `rating` < 6;
|
|
UPDATE `performers` SET `rating` = (`rating` * 20) WHERE `rating` < 6;
|
|
UPDATE `studios` SET `rating` = (`rating` * 20) WHERE `rating` < 6; |