CONN-1424:update Oracle sql scripts to keep primary key datatype consistent and fix datatypes and constraints required