File: GetLastChangeIndex.sql

package info (click to toggle)
orthanc-mysql 5.0%2Bdfsg-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,388 kB
  • sloc: cpp: 18,094; python: 388; sql: 201; makefile: 30; sh: 13
file content (20 lines) | stat: -rw-r--r-- 411 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
CREATE TABLE IF NOT EXISTS GlobalIntegers(
       property INTEGER PRIMARY KEY,
       value BIGINT
       );


DELETE FROM GlobalIntegers WHERE property = 0;

INSERT INTO GlobalIntegers
SELECT 0, COALESCE(MAX(seq), 0) FROM Changes;


DROP TRIGGER IF EXISTS ChangeAdded;

CREATE TRIGGER ChangeAdded
AFTER INSERT ON Changes
FOR EACH ROW
BEGIN
  UPDATE GlobalIntegers SET value = new.seq WHERE property = 0@
END;