Template:ItemData

This page declares the Cargo Items table — the queryable index behind the Items browser, {{#cargo_query:}}, and Special:Drilldown/Items. Rows are written by the AlterAeonData extension (Item::cargoStore) when an (Item) page is saved; this page only defines the schema. Columns mirror Item::facets() plus one signed numeric column per affect token — keep in sync with AFFECT_COLUMNS in aawiki_files/extensions/AlterAeonData/src/Item.php (note int is stored in the intelligence column — int is an SQL keyword). The per-affect columns are (hidden): fully queryable (where=damroll > 2) but kept out of the drilldown facet list.

After a schema change, (re)create the table: cargoRecreateData --table Items, then the AlterAeonData cargoBackfillItems.php maintenance script. This template defines the table "Items". View table.