I am developing an extension that will be probably used by 1000+ stores and needs to add 1 extra field into table sales_flat_order.
ALTER TABLE `".$obj->getTable('sales_flat_order')."` ADD `new_field` TINYINT NULL DEFAULT NULL
sales_flat_order is very important table I am wondering if there ANY risk with this operation? If there is any even tiny risk for that, than I will rather create extra table with fields
order_id | new_field.