Mercurial > hg > orthanc
view OrthancServer/Sources/Database/InstallLabelsTable.sql @ 5934:892ee42584bb
merge
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Mon, 16 Dec 2024 18:09:11 +0100 |
parents | f7adfb22e20e |
children |
line wrap: on
line source
-- Orthanc - A Lightweight, RESTful DICOM Store -- Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics -- Department, University Hospital of Liege, Belgium -- Copyright (C) 2017-2023 Osimis S.A., Belgium -- Copyright (C) 2024-2024 Orthanc Team SRL, Belgium -- Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium -- -- This program is free software: you can redistribute it and/or -- modify it under the terms of the GNU General Public License as -- published by the Free Software Foundation, either version 3 of the -- License, or (at your option) any later version. -- -- This program is distributed in the hope that it will be useful, but -- WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -- General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with this program. If not, see <http://www.gnu.org/licenses/>. CREATE TABLE Labels( id INTEGER REFERENCES Resources(internalId) ON DELETE CASCADE, label TEXT NOT NULL, PRIMARY KEY(id, label) -- Prevents duplicates ); CREATE INDEX LabelsIndex1 ON Labels(id); CREATE INDEX LabelsIndex2 ON Labels(label); -- This index allows efficient lookups