Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/SQL/PrepareIndex.sql @ 470:11c6bcc9d1f2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
cleanup
author Alain Mazy <am@osimis.io>
date Mon, 05 Feb 2024 18:26:37 +0100
parents da0586c5cbd8
children f18e46d7dbf8 6667bd31beaf
comparison
equal deleted inserted replaced
469:302f3c2b1c34 470:11c6bcc9d1f2
1 -- This SQL file creates a DB in version.revision 6.2 directly 1 -- This SQL file creates a DB in Rev2 directly
2 -- It is also run after upgrade scripts to create new tables and or create/replace triggers and functions. 2 -- It is also run after upgrade scripts to create new tables and or create/replace triggers and functions.
3 -- This script is self contained, it contains everything that needs to be run to create an Orthanc DB. 3 -- This script is self contained, it contains everything that needs to be run to create an Orthanc DB.
4 -- Note to developers: 4 -- Note to developers:
5 -- - it is and must stay idempotent. 5 -- - it is and must stay idempotent.
6 -- - it is executed when the DB is "locked", only one Orthanc instance can execute it at a given time. 6 -- - it is executed when the DB is "locked", only one Orthanc instance can execute it at a given time.