postgres change SQL column type from int to big int

[RealZimboGuy]

in reference to the postgres database initialise script. is it possible to change the two main references from SERIAL to BIGSERIAL the SERIAL is limited to the standard signed 32 byte integer value of 2,147,483,647. this is more an issue for the workflow actions as a large number of actions brings the max workflows you can potentially have. ie in the case of 40 actions you have a max workflows of 53,687,091

    create table if not exists nflow_workflow_action (
      id serial not null,

and

    create table if not exists nflow_workflow (
      id serial primary key,

the archive tables will also need to be updated.

I could have a look at testing the change and doing a PR ?