make schema sqlite3 friendly

sqlite3 wont create an auto incrementing field using
postgresql conventions (serial PRIMARY KEY)