comparison SQLite/Plugins/PrepareIndex.sql @ 262:b0c65094b299

adding support for revisions in attachments
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Apr 2021 14:46:42 +0200
parents e184dcadf163
children
comparison
equal deleted inserted replaced
261:34e2b93a7ac1 262:b0c65094b299
41 compressedSize INTEGER, 41 compressedSize INTEGER,
42 uncompressedSize INTEGER, 42 uncompressedSize INTEGER,
43 compressionType INTEGER, 43 compressionType INTEGER,
44 uncompressedHash TEXT, 44 uncompressedHash TEXT,
45 compressedHash TEXT, 45 compressedHash TEXT,
46 revision INTEGER,
46 PRIMARY KEY(id, fileType) 47 PRIMARY KEY(id, fileType)
47 ); 48 );
48 49
49 CREATE TABLE Changes( 50 CREATE TABLE Changes(
50 seq INTEGER PRIMARY KEY AUTOINCREMENT, 51 seq INTEGER PRIMARY KEY AUTOINCREMENT,