d70e0a1fed
- poets.pin_order; editorial list in db/featured.sql, applied after every import - home page shows the pinned row first, like Ganjoor - Faiz is not included: his work is under copyright until 2035, so not in divan-data Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
11 lines
509 B
SQL
11 lines
509 B
SQL
-- Poets pinned to the top of the home page ("مقبول شعرا"), in this order.
|
|
-- Applied by api/src/import.ts after every import. Ids/URLs are stable divan-data ids.
|
|
UPDATE poets SET pin_order = NULL;
|
|
UPDATE poets SET pin_order = v.ord FROM (VALUES
|
|
('/p238', 1), -- محمد اقبال
|
|
('/p266', 2), -- مرزا غالب
|
|
('/p303', 3), -- میر تقی میر
|
|
('/p99', 4), -- خواجہ میر درد
|
|
('/p102', 5) -- داغ دہلوی
|
|
) AS v(url, ord) WHERE poets.url = v.url;
|