Changed date and locationid column types to int.