title: Can I use anything other than BIGINT as Primary Key data type in SQLite?
body: <p>I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality.  However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid).  Is there any way around this?</p>
  
  <p>Note: I should specify that this is in the context of an app using NHibernate.  It is not strictly speaking the case that one can't create a table in SQLite with an INT datatype, but the behavior when you save and retrieve the data seems to indicate that it's being stored and/or retrieved as Int64.</p>