"Fossies" - the Fresh Open Source Software Archive

Member "icingaweb2-2.9.2/etc/schema/mysql-upgrades/2.0.0beta3-2.0.0rc1.sql" (28 Jul 2021, 1096 Bytes) of package /linux/www/icingaweb2-2.9.2.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;