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.
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.