Mercurial > hg > orthanc

comparison OrthancServer/InstallTrackAttachmentsSize.sql @ 3019:8336204d95dc db-changes

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
refactoring computation of disk size for recycling
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 14 Dec 2018 18:07:40 +0100
parents e3b5c07146a3
children
comparison
equal deleted inserted replaced
3018:e3b5c07146a3 3019:8336204d95dc
1 CREATE TABLE GlobalIntegers( 1 CREATE TABLE GlobalIntegers(
2 key INTEGER PRIMARY KEY, 2 key INTEGER PRIMARY KEY,
3 value INTEGER); 3 value INTEGER);
4 4
5 INSERT INTO GlobalProperties VALUES (6, 1); -- GlobalProperty_DatabaseTracksSizeOfAttachments 5 INSERT INTO GlobalProperties VALUES (6, 1); -- GlobalProperty_GetTotalSizeIsFast
6 6
7 INSERT INTO GlobalIntegers SELECT 0, IFNULL(SUM(compressedSize), 0) FROM AttachedFiles; 7 INSERT INTO GlobalIntegers SELECT 0, IFNULL(SUM(compressedSize), 0) FROM AttachedFiles;
8 INSERT INTO GlobalIntegers SELECT 1, IFNULL(SUM(uncompressedSize), 0) FROM AttachedFiles; 8 INSERT INTO GlobalIntegers SELECT 1, IFNULL(SUM(uncompressedSize), 0) FROM AttachedFiles;
9 9
10 CREATE TRIGGER AttachedFileIncrementSize 10 CREATE TRIGGER AttachedFileIncrementSize