Re: [PATCH][merge-tracking]Create mergeinfo.db with proper schema in case it does not exist.

On Thu, Dec 21, 2006 at 06:27:36PM +0530, Kamesh Jayachandran wrote:
> Create mergeinfo.db with the necessary schema if the db does not exist with
> one.
>

It's annoying that SQLite doesn't give us any way to tell whether it's
created a blank database for us, but I'd prefer that we use SQLite's
built-in support for user schema version numbers rather than assume that
a SQLITE_ERROR return means that we should create the schema afresh.

That is, after connecting to the database, issue a

  PRAGMA user_version;

command. If it returns zero, create the database schema and then issue

  PRAGME user_version = 1;

to record that we've created the schema.

I'm assuming that we'd tie the mergeinfo schema version to the
repository format number, so we wouldn't actually use the user_version
value as a proper format number, just a created/not-created indicator.

Regards,
Malcolm