Added sequence for customerID and changed various code