chore(dictionary): drop out-of-band hnc_lemma_<N> columns #73

Merged

raisondetredev merged 2 commits from refs/pull/73/head into main

2026-07-02 01:29:00 +02:00

raisondetredev commented

2026-07-01 23:26:16 +02:00

(Migrated from codeberg.org)

Optional cleanup. Drops the hnc_lemma_100/500/1000/2000 columns (no "words") — added outside the migration tree, populated inconsistently (a top-500 word can show hnc_lemma_500 = false), and referenced by no deployed RPC or client code. The authoritative frequency data (hnc_lemma_words_<N> + hnc_rank) is untouched.

IF EXISTS → idempotent. Destructive but only of the unused/inconsistent family. Apply last, after confirming the feature works — it's cosmetic and unrelated to functionality.

Optional cleanup. Drops the `hnc_lemma_100/500/1000/2000` columns (no "words") — added outside the migration tree, populated inconsistently (a top-500 word can show `hnc_lemma_500 = false`), and referenced by **no** deployed RPC or client code. The authoritative frequency data (`hnc_lemma_words_<N>` + `hnc_rank`) is untouched. `IF EXISTS` → idempotent. Destructive but only of the unused/inconsistent family. **Apply last**, after confirming the feature works — it's cosmetic and unrelated to functionality.