Using Laravel migrations with AWS Redshift database

I am using Laravel 5.3. I can connect successfully to my Redshift database.

However I discovered that the Laravel migrations feature does not work with Redshift because Laravel creates a 'migration' table within the schema which has a 'serial' type column. Redshift does not support the 'serial' type.

[Illuminate\Database\QueryException]
SQLSTATE[0A000]: Feature not supported: 7 ERROR: Column "migrations.id" has unsupported type "serial". (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))

                                                                                                          [PDOException]                                                        

SQLSTATE[0A000]: Feature not supported: 7 ERROR: Column "migrations.id" has unsupported type "serial".

Is there anyway around this so that I can use migrations with Redshift?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2fZmC4F
via IFTTT