rogee
de9ac92ede
- Add MaxMind GeoLite2-City mmdb auto-download and IP-based geo lookup (covers all 249 countries globally, replacing limited 8-country regex) - Add RenameOptions with 5 toggleable fields (flag/alias/country/city/index) stored as rename_options_json on collections - Collection rename pipeline uses DetectGeoWithServer(name, server) which tries GeoIP lookup first, falls back to name-based regex matching - Chinese country/city names + emoji flag prefix - Country-city dedup: skip city when it equals country (e.g. 香港/香港) - URI fragment encoding: url.QueryEscape -> url.PathEscape (%20 not +) - Egress cache key excludes name field so renamed nodes still match cache - Frontend: 5 toggle buttons in collection edit form, default all on - Migrations: 0004 (source alias + collection rename_enabled), 0005 (collection rename_options_json)
6 lines
189 B
SQL
6 lines
189 B
SQL
-- +goose Up
|
|
ALTER TABLE collections ADD COLUMN rename_options_json TEXT NOT NULL DEFAULT '';
|
|
|
|
-- +goose Down
|
|
-- SQLite does not support DROP COLUMN before 3.35; harmless if left in place.
|