CREATE PROCEDURE `DSC_GetListOfCityForUser`(IN `UserID` INT, IN `UserType` INT)
	LANGUAGE SQL
	NOT DETERMINISTIC
	CONTAINS SQL
	SQL SECURITY DEFINER
	COMMENT ''
BEGIN
	IF UserType = 1 THEN
		select city.id, city.name from city order by city.name;
	ELSE
		SELECT city.id, city.name from city, DCS_User WHERE city.id= DCS_User.CityId and DCS_User.ID = UserID  order by city.name;
	END IF;
END