changed primary_clanid value from integer to decimal