I'm currently designing the schema of my database for an application. and there's this table that has a default content or records. i'm torn between what type should i use for its key, because im always using autonumber, i was thinking that because i have a default content for this table, might better to use a unique id instead so per database deployment, the id will always be the same for every installation. is that assumption valid?

Also, when should i use uniqueidentier over an autonumber for a primary key?