modify lookups to have id as auto increment primary key.