move deferrable to after on update/on delete

[bflyblue]

Postgresql requires that deferrable appear after on update/on delete, the current order fails with:

error: alter table "smtp_servers" add constraint "smtp_servers_email_channel_foreign" foreign key ("email_channel") references "email_channels" ("id") deferrable initially deferred  on update cascade on delete cascade - syntax error at or near "on"

Moving the deferred clause to the end works as intended.

[kibertoad]

can you add a test that fails without this change?

[bflyblue]

@kibertoad I'm new to the ecosystem so the test might not be great, but I hope it's sufficient to demonstrate the issue.

It fails with error: alter table "table_a" add constraint "table_a_b_id_foreign" foreign key ("b_id") references "table_b" ("id") deferrable initially deferred on update cascade on delete cascade - syntax error at or near "on" before the change.

[kibertoad]

Released in 1.0.2