Comment 5 for bug 660307

Revision history for this message
Rocko (rockorequin) wrote :

I guess so... but in the particular case I found, it wouldn't create the tables at all. The activity.sqlite file that wouldn't work at all had only two tables, uri and schema_version:

sqlite> .schema uri
CREATE TABLE uri
   (id INTEGER PRIMARY KEY, value VARCHAR UNIQUE);
CREATE UNIQUE INDEX uri_value ON uri(value);

sqlite> .schema schema_version
CREATE TABLE schema_version
   (schema VARCHAR PRIMARY KEY ON CONFLICT REPLACE, version INT);

uri was empty and schema_version contained just "core|1".

However, this looks like the correct format for uri and schema_version according to my current (working) activity.sqlite file.