Comment 18 for bug 653327

Revision history for this message
Tony Whitmore (tonywhitmore) wrote :

Thanks for the suggestion Mr. Cheese. Unfortunately, the photos table doesn't have a date column:

tony@bok:~/Photos$ sqlite3 ./photos.db
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from photos where date<0;
Error: no such column: date
sqlite> .schema photos
CREATE TABLE photos (
 id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
 time INTEGER NOT NULL,
 base_uri STRING NOT NULL,
 filename STRING NOT NULL,
 description TEXT NOT NULL,
 roll_id INTEGER NOT NULL,
 default_version_id INTEGER NOT NULL,
 rating INTEGER NULL
);