Mercurial > hg > orthanc-databases
comparison PostgreSQL/Plugins/PrepareIndex.sql @ 366:cd9521e04249 attach-custom-data
DatabaseBackendAdapterV4: added support for customData + revision when not already done
author | Alain Mazy <am@osimis.io> |
---|---|
date | Thu, 15 Sep 2022 18:12:34 +0200 |
parents | 7cea966b6829 |
children |
comparison
equal
deleted
inserted
replaced
365:7671fa7f099e | 366:cd9521e04249 |
---|---|
28 | 28 |
29 CREATE TABLE Metadata( | 29 CREATE TABLE Metadata( |
30 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, | 30 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, |
31 type INTEGER NOT NULL, | 31 type INTEGER NOT NULL, |
32 value TEXT, | 32 value TEXT, |
33 -- revision INTEGER, -- new in v4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase) | |
33 PRIMARY KEY(id, type) | 34 PRIMARY KEY(id, type) |
34 ); | 35 ); |
35 | 36 |
36 CREATE TABLE AttachedFiles( | 37 CREATE TABLE AttachedFiles( |
37 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, | 38 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, |
40 compressedSize BIGINT, | 41 compressedSize BIGINT, |
41 uncompressedSize BIGINT, | 42 uncompressedSize BIGINT, |
42 compressionType INTEGER, | 43 compressionType INTEGER, |
43 uncompressedHash VARCHAR(40), | 44 uncompressedHash VARCHAR(40), |
44 compressedHash VARCHAR(40), | 45 compressedHash VARCHAR(40), |
46 -- revision BIGINT, -- new in v 4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase) | |
47 -- customData TEXT, -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase) | |
45 PRIMARY KEY(id, fileType) | 48 PRIMARY KEY(id, fileType) |
46 ); | 49 ); |
47 | 50 |
48 CREATE TABLE Changes( | 51 CREATE TABLE Changes( |
49 seq BIGSERIAL NOT NULL PRIMARY KEY, | 52 seq BIGSERIAL NOT NULL PRIMARY KEY, |
110 RETURNS TRIGGER AS $body$ | 113 RETURNS TRIGGER AS $body$ |
111 BEGIN | 114 BEGIN |
112 INSERT INTO DeletedFiles VALUES | 115 INSERT INTO DeletedFiles VALUES |
113 (old.uuid, old.filetype, old.compressedSize, | 116 (old.uuid, old.filetype, old.compressedSize, |
114 old.uncompressedSize, old.compressionType, | 117 old.uncompressedSize, old.compressionType, |
115 old.uncompressedHash, old.compressedHash); | 118 old.uncompressedHash, old.compressedHash |
119 -- old.customData -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase) | |
120 ); | |
116 RETURN NULL; | 121 RETURN NULL; |
117 END; | 122 END; |
118 $body$ LANGUAGE plpgsql; | 123 $body$ LANGUAGE plpgsql; |
119 | 124 |
120 CREATE TRIGGER AttachedFileDeleted | 125 CREATE TRIGGER AttachedFileDeleted |