[otrs] Adding a database field

I need to add an expiration date to the customer_user table. I need to figure out how to add the expiration date to the Customer_User interface and automatically set a user to invalid when that date arrives? Any ideas from anyone on how to do this?