this code is equivalent between postgresql and mysql:

mysql:

create table crawford_addresses (
    id int(10) auto_increment primary key, ... );

postgresql:

 create table "crawford_addresses" (

    id serial , primary key ("id"), ... );