change order : delete all 'missing' or 'deleted' files from the file system first, commit, and then add all the new ones. Also alter column type, from smallint to int of trip_id because the trip id could have now 8 digits, so need 4 bytes. because of the alteration of those columns, views had to be dropped and recreated. Have tested it on my machine, works fine. I've also re download again the entire soop-trv dataset, so all the files will be removed from the database. will be a good way to see how fast this will work. but should be fine. no need to drop the schema. ready for deployment