Hello,
I have a problem with a customer database that is very strange. This
is part of the DB's schema:
- BEGIN -
CREATE TABLE IF NOT EXISTS user_identity (
id INTEGER PRIMARY KEY,
shortName TEXT,
domainName TEXT,
Hallo,
On Mon, Mar 12, 2012 at 11:16 PM, Petite Abeille
petite.abei...@gmail.com wrote:
On Mar 12, 2012, at 11:11 PM, Alex Queiroz wrote:
id INTEGER PRIMARY KEY,
CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByID' ON
'user_identity' (id ASC
Hello,
On Mon, Mar 12, 2012 at 11:34 PM, Petite Abeille
petite.abei...@gmail.com wrote:
Hmmm… really? That would be most peculiar...
Indeed. I have now run this:
sqlite PRAGMA integrity_check;
rowid 192697 missing from index userIdentityByUcgID
rowid 192701 missing from index
Hello,
On Mon, Mar 12, 2012 at 11:52 PM, Simon Slavin slav...@bigfraud.org wrote:
On 12 Mar 2012, at 10:11pm, Alex Queiroz asand...@gmail.com wrote:
- If I try to reindex the table, it fails;
- If I drop the index and try to add it again, it fails.
For both the above ...
What command