Added missing foreign key constraints related to the status tables.
Fixed username size - should be 255 like the other databases.
Format files - Added NOT NULL to all the primary keys to make it consistent - Applied formating so that it similar to all database creation scripts.
Fixed bug with the harvestUri being set to 455 when it should be 512 like in the create scripts.
Fix bug with oracle column modification - wrong syntax - it was failing.
Move DDL from migrate default to db scripts as each DB can be different.
   - Updated oracle scripts to use varchar2 instead of varchar
   - Also fixed some missing defaults for users.security