"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/36.sql" (15 Sep 2021, 505 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 ALTER TABLE `tmetaconsole_setup` ADD COLUMN `server_uid` TEXT NOT NULL default '';
    4 SET @st_oum744 = (SELECT IF(
    5     (SELECT COUNT(*) FROM tconfig WHERE token LIKE 'server_unique_identifier') > 0,
    6     "SELECT 1",
    7     "INSERT INTO `tconfig` (`token`, `value`) VALUES ('server_unique_identifier', replace(uuid(),'-',''))"
    8 ));
    9 
   10 PREPARE pr_oum744 FROM @st_oum744;
   11 EXECUTE pr_oum744;
   12 DEALLOCATE PREPARE pr_oum744;
   13 
   14 ALTER TABLE `tpolicies` ADD COLUMN `force_apply` tinyint(1) default 0;
   15 
   16 COMMIT;