## 1. Schema

- [x] 1.1 `db/schema.sql`: add `products` and `orders` tables; add idempotent `ALTER TABLE tags ADD COLUMN IF NOT EXISTS product_id BIGINT REFERENCES products(id)` and `order_id BIGINT REFERENCES orders(id)`; run `make db-up`
- [x] 1.2 `make generate` (sqlc adds `Product`/`Order` models, extends `Tag`); verify build

## 2. Registry Seed

- [x] 2.1 `frontend/cmd/seed-registry/main.go`: read `db/preset_tag_ids.txt` (skip comment lines), `InsertTag` each ID, skip unique-violations, report counts
- [x] 2.2 Makefile `seed-registry` target (cwd frontend, schema path aware); README note

## 3. Verification

- [x] 3.1 `make seed-registry` on fresh DB → 100 tags; re-run → no errors (idempotent)
- [x] 3.2 Bind a real ID (register owner, add tag with one of the 100 IDs) → bound; made-up code → rejected
- [x] 3.3 Existing suites still pass (`/tmp/verify.sh` Phase 1 + `/tmp/verify2.sh` Phase 2) with TEST codes
- [x] 3.4 `openspec validate tag-registry-product-link`; commit
