On Tue, Jun 7, 2011 at 5:41 PM, Joe Goldthwaite <[email protected]> wrote:

> I didn't realize that the Schema was just a
> place for the developer to leave a note. I assumed that it was the sqlite's
> internal database schema that was being used to describe some internal
> control tables or something like that.
>
>
PRAGMA user_version is just a number that the application can set to
whatever it wants.  But PRAGMA schema_version is used internally by SQLite.
If you set it manually, you can potentially corrupt the database file.  So
don't change it unless you really know what you are doing.

-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to