Mercurial > hg > orthanc-databases

comparison SQLite/Plugins/PrepareIndex.sql @ 256:e184dcadf163

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
handling of revisions in metadata
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 16 Apr 2021 17:13:33 +0200
parents 7cea966b6829
children b0c65094b299
comparison
equal deleted inserted replaced
255:d663d9e44f8d 256:e184dcadf163
28 28
29 CREATE TABLE Metadata( 29 CREATE TABLE Metadata(
30 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, 30 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,
31 type INTEGER, 31 type INTEGER,
32 value TEXT, 32 value TEXT,
33 revision INTEGER,
33 PRIMARY KEY(id, type) 34 PRIMARY KEY(id, type)
34 ); 35 );
35 36
36 CREATE TABLE AttachedFiles( 37 CREATE TABLE AttachedFiles(
37 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, 38 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,