Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase2.sql @ 197:530a25320461

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
removal of text as ids in sqlite db
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 27 Nov 2012 14:59:55 +0100
parents c56dc32266e0
children
comparison
equal deleted inserted replaced
196:6d0225a26fd8 197:530a25320461
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 contentName TEXT, 30 fileType INTEGER,
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, contentName) 35 PRIMARY KEY(id, fileType)
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,