"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/32.sql" (15 Sep 2021, 2699 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 `tdatabase` MODIFY `last_error` text;
    4 ALTER TABLE `tdatabase` MODIFY `host` VARCHAR(255) DEFAULT '';
    5 ALTER TABLE `tdatabase` ADD COLUMN `label` VARCHAR(255) DEFAULT '';
    6 ALTER TABLE `tdatabase` MODIFY `os_user` VARCHAR(255) DEFAULT '';
    7 ALTER TABLE `tdatabase` MODIFY `db_port` INT UNSIGNED NOT NULL DEFAULT 3306;
    8 ALTER TABLE `tdatabase` MODIFY `os_port` INT UNSIGNED NOT NULL DEFAULT 22;
    9 ALTER TABLE `tdatabase` ADD COLUMN `ssh_key` TEXT;
   10 ALTER TABLE `tdatabase` ADD COLUMN `ssh_pubkey` TEXT;
   11 
   12 UPDATE `tdatabase` set `label`=`host`;
   13 
   14 UPDATE `tlayout_data` SET `height` = 70 , `width` = 70 WHERE `height` = 0 && `width` = 0 && image NOT LIKE '%dot%' && ((`type` IN (0,5)) ||
   15 (`type` = 10 && `image` IS NOT NULL && `image` != '' && `image` != 'none') ||
   16 (`type` = 11 && `image` IS NOT NULL && `image` != '' && `image` != 'none' && `show_statistics` = 0));
   17 
   18 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_enabled', 0);
   19 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_user', '');
   20 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_pass', '');
   21 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_hostname', '');
   22 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_api_pass', '');
   23 INSERT INTO `tconfig` (`token`, `value`) VALUES ('integria_req_timeout', 5);
   24 INSERT INTO `tconfig` (`token`, `value`) VALUES ('default_group', '');
   25 INSERT INTO `tconfig` (`token`, `value`) VALUES ('default_criticity', '');
   26 INSERT INTO `tconfig` (`token`, `value`) VALUES ('default_creator', '');
   27 INSERT INTO `tconfig` (`token`, `value`) VALUES ('default_owner', '');
   28 INSERT INTO `tconfig` (`token`, `value`) VALUES ('incident_type', '');
   29 INSERT INTO `tconfig` (`token`, `value`) VALUES ('incident_status', '');
   30 INSERT INTO `tconfig` (`token`, `value`) VALUES ('incident_title', '');
   31 INSERT INTO `tconfig` (`token`, `value`) VALUES ('incident_content', '');
   32 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_default_group', '');
   33 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_default_criticity', '');
   34 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_default_creator', '');
   35 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_default_owner', '');
   36 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_incident_type', '');
   37 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_incident_status', '');
   38 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_incident_title', '');
   39 INSERT INTO `tconfig` (`token`, `value`) VALUES ('cr_incident_content', '');
   40 
   41 ALTER TABLE `treport_content` ADD COLUMN `uncompressed_module` TINYINT DEFAULT '0';
   42 ALTER TABLE `treport_content_template` ADD COLUMN `uncompressed_module` TINYINT DEFAULT '0';
   43 
   44 COMMIT;