Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase2.sql @ 192:c56dc32266e0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
refactoring getfile
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 13 Nov 2012 11:29:43 +0100
parents b6cef9d45cc3
children 530a25320461
comparison
equal deleted inserted replaced
191:bff0b77b02fa 192:c56dc32266e0
25 PRIMARY KEY(id, type) 25 PRIMARY KEY(id, type)
26 ); 26 );
27 27
28 CREATE TABLE AttachedFiles( 28 CREATE TABLE AttachedFiles(
29 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, 29 id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE,
30 name TEXT, 30 contentName TEXT,
31 uuid TEXT, 31 uuid TEXT,
32 compressedSize INTEGER, 32 compressedSize INTEGER,
33 uncompressedSize INTEGER, 33 uncompressedSize INTEGER,
34 compressionType INTEGER, 34 compressionType INTEGER,
35 PRIMARY KEY(id, name) 35 PRIMARY KEY(id, contentName)
36 ); 36 );
37 37
38 CREATE TABLE Changes( 38 CREATE TABLE Changes(
39 seq INTEGER PRIMARY KEY AUTOINCREMENT, 39 seq INTEGER PRIMARY KEY AUTOINCREMENT,
40 changeType INTEGER, 40 changeType INTEGER,