TGS11 — Product country support, regions, and ordinal GridRank

TGS11 introduces structured country and region data for products, a new ordinal ranking field on gridRank, and a firstClaimedAt timestamp on roots.

Products can now declare which countries they are available in, and every country links to a UN M49 sub-region (e.g. South America, Eastern Asia) for regional grouping and filtering.

AddedregionsNew table of UN M49 sub-regions: id, name, slug, m49Code, parentRegionId.
AddedsupportsCountriesNew join table declaring which countries a product is available in (productId → countryId).
Addedcountries.regionIdLinks each country to its UN M49 sub-region.
AddedgridRank.ranking1-based ordinal position — lower is better. Recommended for Top-N lists and threshold filters. Sort with order_by: { ranking: Asc }. A missing gridRank record means unranked, not rank 0; rankings update every 24 hours.
Addedroots.firstClaimedAtDate this profile was first claimed by a user on The Grid. Complements the existing firstPublicValidation / lastPublicValidation fields.

Known limitation: country.region.parentRegion cannot be traversed in a single query yet — query parentRegionId and match it yourself.