add column valid to service and location table to handle deletion