WIP[patch] add lock by country.

added missing sql