"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/48.sql" (15 Sep 2021, 2354 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 `unified` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
    4 ALTER TABLE `tlayout` ADD COLUMN `auto_adjust` INTEGER UNSIGNED NOT NULL default 0;
    5 ALTER TABLE `tlayout_data` ADD COLUMN `title` TEXT default '';
    6 
    7 CREATE TABLE IF NOT EXISTS `talert_execution_queue` (
    8     `id` int(10) unsigned NOT NULL auto_increment,
    9     `id_alert_template_module` int(10) unsigned NOT NULL,
   10     `alert_mode` tinyint(1) NOT NULL,
   11     `data` mediumtext NOT NULL,
   12     `extra_macros` text,
   13     `utimestamp` bigint(20) NOT NULL default '0',
   14     PRIMARY KEY (`id`)
   15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   16 
   17 CREATE TABLE IF NOT EXISTS `tsync_queue` (
   18     `id` serial,
   19     `sql` MEDIUMTEXT,
   20     `target` bigint(20) unsigned NOT NULL,
   21     `utimestamp` bigint(20) default '0',
   22     `operation` text,
   23     `table` text,
   24     `error` MEDIUMTEXT,
   25     PRIMARY KEY (`id`)
   26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   27 
   28 UPDATE `tlink` SET `link` = 'https://pandorafms.com/manual/' WHERE `id_link` = 0000000001;
   29 
   30 UPDATE `tuser_task`
   31 SET parameters='a:7:{i:0;a:7:{s:11:"description";s:30:"Template pending to be created";s:5:"table";s:16:"treport_template";s:8:"field_id";s:9:"id_report";s:10:"field_name";s:4:"name";s:8:"required";b:1;s:4:"type";s:3:"int";s:9:"acl_group";s:8:"id_group";}i:1;a:7:{s:11:"description";s:6:"Agents";s:5:"table";s:7:"tagente";s:8:"field_id";s:9:"id_agente";s:10:"field_name";s:6:"nombre";s:8:"multiple";b:1;s:4:"type";s:3:"int";s:9:"acl_group";s:8:"id_grupo";}i:2;a:2:{s:11:"description";s:16:"Report per agent";s:10:"select_two";b:1;}i:3;a:2:{s:11:"description";s:11:"Report name";s:4:"type";s:6:"string";}i:4;a:2:{s:11:"description";s:47:"Send to e-mail addresses (separated by a comma)";s:4:"type";s:4:"text";}i:5;a:2:{s:11:"description";s:7:"Subject";s:8:"optional";i:1;}i:6;a:3:{s:11:"description";s:7:"Message";s:4:"type";s:4:"text";s:8:"optional";i:1;}}i:7;a:2:{s:11:"description";s:11:"Report Type";s:4:"type";s:11:"report_type";}}'
   32 WHERE id=2;
   33 
   34 UPDATE `tuser_task_scheduled` SET 
   35     `args` = REPLACE (`args`, 'a:8', 'a:9'),
   36     `args`= REPLACE(`args`, 's:15:"first_execution"', 'i:2;s:0:"";i:7;s:3:"PDF";s:15:"first_execution"')
   37     WHERE `id_user_task` = 2;
   38 
   39 UPDATE `tconfig` SET `value` = 0 WHERE `token` = 'centralized_management';
   40 
   41 DELETE ta FROM `tagente` ta LEFT JOIN `tgrupo` tg on ta.`id_grupo` = tg.`id_grupo` WHERE tg.`id_grupo` IS NULL;
   42 
   43 COMMIT;