I have the following (beside some others) table defined:
CREATE TABLE IF NOT EXISTS weights (
id INTEGER PRIMARY KEY,
categoryID INTEGER NOT NULL,
measureDate DATE DEFAULT (DATE('now')),
weight FLOAT NOT NULL,
fat FLOAT,
water FLOAT,
muscle FLOAT,
UNIQUE (
categoryID,
measureDate
)
);
When using
.indices
but when using:
.indices weights
I get:
sqlite_autoindex_weights_1
Should it not be shown in the first instance also?
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
