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
);
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
);