Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 252:bd009f0b1931

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
db version
author Sebastien Jodogne <s.jodogne@gmail.com>
date Wed, 05 Dec 2012 12:50:25 +0100
parents 8098448bd827
children 2354560daf2f
comparison
equal deleted inserted replaced
251:4dc9d00c359c 252:bd009f0b1931
83 AFTER DELETE ON Resources 83 AFTER DELETE ON Resources
84 FOR EACH ROW WHEN (SELECT COUNT(*) FROM Resources WHERE parentId = old.parentId) = 0 84 FOR EACH ROW WHEN (SELECT COUNT(*) FROM Resources WHERE parentId = old.parentId) = 0
85 BEGIN 85 BEGIN
86 DELETE FROM Resources WHERE internalId = old.parentId; 86 DELETE FROM Resources WHERE internalId = old.parentId;
87 END; 87 END;
88
89 -- Set the version of the database schema
90 -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration
91 INSERT INTO GlobalProperties VALUES (1, "2");