"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/2.sql" (15 Sep 2021, 786 Bytes) of package /linux/misc/pandorafms_console-7.0NG.757.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 START TRANSACTION;
    2 
    3 SET @st_oum706 = (SELECT IF(
    4     (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'treport_content' AND table_schema = DATABASE() AND column_name = 'historical_db') > 0,
    5     "SELECT 1",
    6     "ALTER TABLE treport_content ADD COLUMN historical_db tinyint(1) UNSIGNED NOT NULL default 0"
    7 ));
    8 
    9 PREPARE pr_oum706 FROM @st_oum706;
   10 EXECUTE pr_oum706;
   11 DEALLOCATE PREPARE pr_oum706;
   12 
   13 SET @st_oum706 = (SELECT IF(
   14     (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'tpolicy_modules' AND table_schema = DATABASE() AND column_name = 'ip_target') > 0,
   15     "SELECT 1",
   16     "ALTER TABLE tpolicy_modules ADD COLUMN ip_target varchar(100) default ''"
   17 ));
   18 
   19 PREPARE pr_oum706 FROM @st_oum706;
   20 EXECUTE pr_oum706;
   21 DEALLOCATE PREPARE pr_oum706;
   22 
   23 COMMIT;
   24