blob: 96b0aad1bf499ba63ba10e927064534019fb2cdd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
CREATE TABLE icinga_user_inheritance (
user_id INT(10) UNSIGNED NOT NULL,
parent_user_id INT(10) UNSIGNED NOT NULL,
weight MEDIUMINT UNSIGNED DEFAULT NULL,
PRIMARY KEY (user_id, parent_user_id),
UNIQUE KEY unique_order (user_id, weight),
CONSTRAINT icinga_user_inheritance_user
FOREIGN KEY host (user_id)
REFERENCES icinga_user (id)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT icinga_user_inheritance_parent_user
FOREIGN KEY host (parent_user_id)
REFERENCES icinga_user (id)
ON DELETE RESTRICT
ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
