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);