Mercurial > hg > orthanc-indexer
view Sources/PrepareDatabase.sql @ 22:5a24f4147d67
using WindowsResources.py from Orthanc framework
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 26 Mar 2024 13:27:19 +0100 |
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);