Welcome to CiviCRM SE, Could you please tell why you want to add 'is_active' field to country table? Can't you just disable the countries from appearing in drop down(or include only countries that you need in your system) from CiviCRM >> Administer >> Localization >> Languages, Currency, Locations?

Only top voted, non community-wiki answers of a minimum length are eligible