diff options
| author | Jochen Topf <jochen@topf.org> | 2013-01-24 19:12:20 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2013-01-24 19:12:20 +0100 |
| commit | 4bfa3306d07f006fb85a26de261c2052b256694a (patch) | |
| tree | 50a1288370a86140ed2f7f3b412f26f387e8422d /sources | |
| parent | ceb79b1e639597a930d466e34f3d113f6e51c3d4 (diff) | |
| download | taginfo-4bfa3306d07f006fb85a26de261c2052b256694a.tar taginfo-4bfa3306d07f006fb85a26de261c2052b256694a.tar.gz | |
Only include date in history_stats table
Diffstat (limited to 'sources')
| -rw-r--r-- | sources/master/history_update.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sources/master/history_update.sql b/sources/master/history_update.sql index 4aabb21..609d340 100644 --- a/sources/master/history_update.sql +++ b/sources/master/history_update.sql @@ -10,5 +10,5 @@ ATTACH DATABASE '__DIR__/taginfo-master.db' AS master; -INSERT INTO history_stats (udate, key, value) SELECT datetime('now'), key, value FROM master.master_stats; +INSERT INTO history_stats (udate, key, value) SELECT substr(datetime('now'), 1, 10), key, value FROM master.master_stats; |