Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 231:8098448bd827

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
export log
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 30 Nov 2012 12:18:44 +0100
parents 4453a010d0db
children bd009f0b1931
comparison
equal deleted inserted replaced
230:ae2367145b49 231:8098448bd827
41 internalId INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, 41 internalId INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,
42 resourceType INTEGER, 42 resourceType INTEGER,
43 date TEXT 43 date TEXT
44 ); 44 );
45 45
46 CREATE TABLE ExportedInstances( 46 CREATE TABLE ExportedResources(
47 seq INTEGER PRIMARY KEY AUTOINCREMENT, 47 seq INTEGER PRIMARY KEY AUTOINCREMENT,
48 resourceType INTEGER,
49 publicId TEXT,
48 remoteModality TEXT, 50 remoteModality TEXT,
49 publicId TEXT,
50 patientId TEXT, 51 patientId TEXT,
51 studyInstanceUid TEXT, 52 studyInstanceUid TEXT,
52 seriesInstanceUid TEXT, 53 seriesInstanceUid TEXT,
53 sopInstanceUid TEXT, 54 sopInstanceUid TEXT,
54 date TEXT 55 date TEXT