We want to add a new column
LastModifiedBy to all tables in an existing schema.
Value is updated by the application platform on all inserts/updates and is populated with the application user (not database user) running the transaction.
Column values cannot be
NULL (our schema is like this).
What default value would you put in here when upgrading existing customer databases? A dummy value, or add a new "migration" user, or something else?