"Fossies" - the Fresh Open Source Software Archive 
Member "icingaweb2-2.11.4/schema/mysql-upgrades/2.0.0beta3-2.0.0rc1.sql" (26 Jan 2023, 1096 Bytes) of package /linux/www/icingaweb2-2.11.4.tar.gz:
As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style:
standard) with prefixed line numbers.
Alternatively you can here
view or
download the uninterpreted source code file.
1 # Icinga Web 2 | (c) 2014 Icinga Development Team | GPLv2+
2
3 DROP TABLE `icingaweb_group_membership`;
4 DROP TABLE `icingaweb_group`;
5
6 CREATE TABLE `icingaweb_group`(
7 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
8 `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
9 `parent` int(10) unsigned NULL DEFAULT NULL,
10 `ctime` timestamp NULL DEFAULT NULL,
11 `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
12 PRIMARY KEY (`id`),
13 UNIQUE KEY `idx_name` (`name`),
14 CONSTRAINT `fk_icingaweb_group_parent_id` FOREIGN KEY (`parent`)
15 REFERENCES `icingaweb_group` (`id`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18 CREATE TABLE `icingaweb_group_membership`(
19 `group_id` int(10) unsigned NOT NULL,
20 `username` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
21 `ctime` timestamp NULL DEFAULT NULL,
22 `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
23 PRIMARY KEY (`group_id`,`username`),
24 CONSTRAINT `fk_icingaweb_group_membership_icingaweb_group` FOREIGN KEY (`group_id`)
25 REFERENCES `icingaweb_group` (`id`)
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;