"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/21.sql" (15 Sep 2021, 746 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 `tservice` ADD COLUMN `is_favourite` tinyint(1) NOT NULL default 0;
    4 UPDATE tservice SET `is_favourite` = 1 WHERE `name` REGEXP '^[_|.|\[|\(]';
    5 
    6 ALTER TABLE tlayout_data ADD COLUMN `show_last_value` tinyint(1) UNSIGNED NULL default '0';
    7 ALTER TABLE tlayout_template_data ADD COLUMN `show_last_value` tinyint(1) UNSIGNED NULL default '0';
    8 ALTER TABLE tlayout MODIFY `name` varchar(600) NOT NULL;
    9 
   10 ALTER TABLE tmetaconsole_setup ADD COLUMN `meta_dbuser` text;
   11 ALTER TABLE tmetaconsole_setup ADD COLUMN `meta_dbpass` text;
   12 ALTER TABLE tmetaconsole_setup ADD COLUMN `meta_dbhost` text;
   13 ALTER TABLE tmetaconsole_setup ADD COLUMN `meta_dbport` text;
   14 ALTER TABLE tmetaconsole_setup ADD COLUMN `meta_dbname` text;
   15 
   16 COMMIT;