From dd9eb96421b47f0e6f822a4d3c2896071fb33f93 Mon Sep 17 00:00:00 2001 From: David Stainton <dstainton415@gmail.com> Date: Tue, 19 Jan 2016 15:35:16 +0100 Subject: [PATCH] Update magic-folder db schema to use REAL instead of NUMBER of TIMESTAMP --- src/allmydata/magicfolderdb.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/allmydata/magicfolderdb.py b/src/allmydata/magicfolderdb.py index 982b5fe2..fdda3f06 100644 --- a/src/allmydata/magicfolderdb.py +++ b/src/allmydata/magicfolderdb.py @@ -17,12 +17,12 @@ CREATE TABLE local_files path VARCHAR(1024) PRIMARY KEY, -- UTF-8 filename relative to local magic folder dir -- note that size is before mtime and ctime here, but after in function parameters size INTEGER, -- ST_SIZE, or NULL if the file has been deleted - mtime NUMBER, -- ST_MTIME - ctime NUMBER, -- ST_CTIME + mtime REAL, -- ST_MTIME + ctime REAL, -- ST_CTIME version INTEGER, last_uploaded_uri VARCHAR(256), -- URI:CHK:... last_downloaded_uri VARCHAR(256), -- URI:CHK:... - last_downloaded_timestamp TIMESTAMP + last_downloaded_timestamp REAL ); """ -- 2.45.2