webring/migrations/003_add_slug_column.down.sql
Damir Modyarov f12e106049
feat: Implement slugs and id reordering (#2)
* fix: Make data API route paths consistent

* feat: Implement redirect for current website

* feat: Implement slugs and id reordering

* feat: Implement slug validation

* fix: Add constant zero ID to public site data for compatibility

* fix: Make slug length limited when validating

* docs: Update routes in README.md

* feat: Implement gapless reordering

* fix: Add IDs back to public data

* feat: Implement ID/slug collision checks
2025-06-19 14:34:18 +03:00

5 lines
173 B
SQL

ALTER TABLE sites DROP CONSTRAINT sites_unique_id;
ALTER TABLE sites DROP CONSTRAINT sites_pkey;
ALTER TABLE sites ADD PRIMARY KEY (id);
ALTER TABLE sites DROP COLUMN slug;