Mercurial > hg > orthanc-databases
comparison SQLite/Plugins/PrepareIndex.sql @ 256:e184dcadf163
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, |