-- Smart Agent final DB alignment for shared hosting.

-- Your users table already has these columns.
-- If phpMyAdmin says Duplicate column, ignore it and continue.
ALTER TABLE users ADD COLUMN latitude DECIMAL(10,7) NULL;
ALTER TABLE users ADD COLUMN longitude DECIMAL(10,7) NULL;
ALTER TABLE users ADD COLUMN mobility_mode VARCHAR(32) NULL DEFAULT 'pedestrian';
ALTER TABLE users ADD COLUMN status_note VARCHAR(255) NULL;

-- Incidents compatibility with existing PHP code.
ALTER TABLE incidents ADD COLUMN assigned_team VARCHAR(120) NULL;
ALTER TABLE incidents ADD COLUMN photo_path VARCHAR(255) NULL;
