"Fossies" - the Fresh Open Source Software Archive

Member "icinga2-2.10.5/lib/db_ido_pgsql/schema/upgrade/2.8.1.sql" (23 May 2019, 821 Bytes) of package /linux/misc/icinga2-2.10.5.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 -- -----------------------------------------
    2 -- upgrade path for Icinga 2.8.1 (fix for fresh 2.8.0 installation only)
    3 --
    4 -- -----------------------------------------
    5 -- Copyright (c) 2018 Icinga Development Team (https://icinga.com/)
    6 --
    7 -- Please check https://docs.icinga.com for upgrading information!
    8 -- -----------------------------------------
    9 
   10 ALTER TABLE icinga_downtimehistory DROP CONSTRAINT IF EXISTS UQ_downtimehistory;
   11 ALTER TABLE icinga_scheduleddowntime DROP CONSTRAINT IF EXISTS UQ_scheduleddowntime;
   12 ALTER TABLE icinga_commenthistory DROP CONSTRAINT IF EXISTS UQ_commenthistory;
   13 ALTER TABLE icinga_comments DROP CONSTRAINT IF EXISTS UQ_comments;
   14 
   15 -- -----------------------------------------
   16 -- set dbversion (same as 2.8.0)
   17 -- -----------------------------------------
   18 
   19 SELECT updatedbversion('1.14.3');