Mercurial > hg > orthanc-databases
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, |