Mercurial > hg > orthanc-indexer
view Sources/PrepareDatabase.sql @ 26:2f410de7715d default tip
added CITATION.cff
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Sat, 06 Apr 2024 17:20:59 +0200 |
parents | 6b08fcddd900 |
children |
line wrap: on
line source
CREATE TABLE Files( path TEXT PRIMARY KEY NOT NULL, time INTEGER NOT NULL, size INTEGER NOT NULL, isDicom INTEGER NOT NULL, instanceId TEXT NOT NULL ); CREATE TABLE Attachments( uuid TEXT PRIMARY KEY NOT NULL, instanceId NOT NULL ); CREATE INDEX InstancesIndex ON Files(instanceId);