mirror of
https://github.com/Icinga/icingaweb2-module-director.git
synced 2026-06-05 06:43:11 -04:00
b6af283732
Add SPDX license headers and mark source files as GPL-3.0-or-later to preserve the option to relicense under later GPL versions.
20 lines
598 B
SQL
20 lines
598 B
SQL
-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>
|
|
-- SPDX-License-Identifier: GPL-3.0-or-later
|
|
|
|
DROP TABLE director_datalist_value;
|
|
|
|
CREATE TABLE director_datalist_entry (
|
|
list_id integer NOT NULL,
|
|
entry_name character varying(255) DEFAULT NULL,
|
|
entry_value text DEFAULT NULL,
|
|
format enum_property_format,
|
|
PRIMARY KEY (list_id, entry_name),
|
|
CONSTRAINT director_datalist_entry_datalist
|
|
FOREIGN KEY (list_id)
|
|
REFERENCES director_datalist (id)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE
|
|
);
|
|
|
|
CREATE INDEX datalist_entry_datalist ON director_datalist_entry (list_id);
|
|
|