WFLY-4022 Rename the PARTITION column to PARTITION_NAME

Also change all long data types to bigint

Users will need to alter existing tables when migrating to Wildfly 9
Add more database specific table creation scripts
Merge pull request #6877 from stuartwdouglas/WFLY-4022

WFLY-4022 Rename the PARTITION column to PARTITION_NAME