Add Primary Key Constraint with tests

[marcotas]

• Create

In Column

table.bigInteger('id').primary();
// or 
table.bigInteger('id').primary('custom_name')

In Table

table.primary(['id', 'customer_id']);
// or
table.primary(['id', ...], name: 'custom_name_pkey');

• Update

Column

Adding a column

table.bigInteger('id').primary();
// or 
table.bigInteger('id').primary('custom_name')

Updating existing column

table.bigInteger('id').primary().change();
// or 
table.bigInteger('id').primary('custom_name').change();

Table

table.primary(['id', 'customer_id']);
// or
table.primary(['id'], name: 'custom_name_pkey');

• Rename

table.renamePrimary('existing', 'new_name');

• Drop

table.dropPrimary(columns: ['id']);
// or
table.dropPrimary(name: 'some_custom_pk');