-- Map fields for existing national-administrator accounts.
-- Run in phpMyAdmin after uploading the corrected strategic-board files.
-- Safe to execute repeatedly.

START TRANSACTION;

UPDATE users SET country='Canada', latitude=56.1304000, longitude=-106.3468000, status_note='Administration nationale · Canada' WHERE email='canada.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='United States', latitude=39.8283000, longitude=-98.5795000, status_note='Administration nationale · United States' WHERE email='usa.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='France', latitude=46.2276000, longitude=2.2137000, status_note='Administration nationale · France' WHERE email='france.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='Japan', latitude=36.2048000, longitude=138.2529000, status_note='Administration nationale · Japan' WHERE email='japan.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='Brazil', latitude=-14.2350000, longitude=-51.9253000, status_note='Administration nationale · Brazil' WHERE email='brazil.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='India', latitude=20.5937000, longitude=78.9629000, status_note='Administration nationale · India' WHERE email='india.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='South Africa', latitude=-30.5595000, longitude=22.9375000, status_note='Administration nationale · South Africa' WHERE email='southafrica.admin@humanity.test' AND role='admin_national';
UPDATE users SET country='Australia', latitude=-25.2744000, longitude=133.7751000, status_note='Administration nationale · Australia' WHERE email='australia.admin@humanity.test' AND role='admin_national';

COMMIT;

SELECT id, full_name, email, role, country, city, latitude, longitude, mobility_mode, status_note
FROM users
WHERE role='admin_national'
ORDER BY country, full_name;
