-- Garrisons at backbone landing sites (docs/DECISIONS.md E6). Units of owner_town_id's operator standing in a landing site that the -- operator's alliance holds. They defend the site (on top of its static defence) and draw the OWNER's power (state.unitDraw), because -- a site has no power budget of its own. Same shape as `stationed`, whose host is a POP; a site is not a POP (E1), hence a table of its own. -- Written only by commands/events inside their transaction; the bot ledger counts these units as alive. CREATE TABLE site_stationed ( site_id INTEGER NOT NULL REFERENCES landing_sites(id), owner_town_id INTEGER NOT NULL REFERENCES towns(id), unit TEXT NOT NULL, count INTEGER NOT NULL CHECK (count > 0), PRIMARY KEY (site_id, owner_town_id, unit) ); CREATE INDEX site_stationed_owner ON site_stationed(owner_town_id);