1
create table usage (application text, entry text, timestamp datetime);
2
insert into usage (application, entry, timestamp) values ("testapp.desktop", "One", datetime('now', 'utc'));
3
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Two", datetime('now', 'utc'));
4
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Two", datetime('now', 'utc', '-1 day'));
5
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc'));
6
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc', '-1 day'));
7
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc', '-2 day'));
8
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc'));
9
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-1 day'));
10
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-2 day'));
11
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-3 day'));