Mercurial > hg > orthanc-databases

comparison MySQL/Plugins/GetLastChangeIndex.sql @ 87:48d445f756db db-changes

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new extension implemented for MySQL: GetLastChangeIndex
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 10 Jan 2019 20:39:36 +0100
parents
children 740d9829f52e
comparison
equal deleted inserted replaced
86:d16e94157efe 87:48d445f756db
1 CREATE TABLE GlobalIntegers(
2 property INTEGER PRIMARY KEY,
3 value BIGINT
4 );
5
6
7 INSERT INTO GlobalIntegers
8 SELECT 0, COALESCE(MAX(seq), 0) FROM Changes;
9
10
11 CREATE TRIGGER ChangeAdded
12 AFTER INSERT ON Changes
13 FOR EACH ROW
14 BEGIN
15 UPDATE GlobalIntegers SET value = new.seq WHERE property = 0@
16 END;