"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/38.sql" (15 Sep 2021, 518 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 INSERT INTO `ttipo_modulo` VALUES (38,'web_server_status_code_string',9,'Remote HTTP module to check server status code','mod_web_data.png');
    4 
    5 ALTER TABLE trecon_task add column `rcmd_enabled` TINYINT(1) UNSIGNED DEFAULT 0 AFTER `wmi_enabled`;
    6 
    7 CREATE TABLE `tnode_relations` (
    8     `id` int(10) unsigned NOT NULL auto_increment,
    9     `gateway` VARCHAR(100) NOT NULL,
   10     `imei` VARCHAR(100) NOT NULL,
   11     `node_address` VARCHAR(60) NOT NULL,
   12     PRIMARY KEY (`id`)
   13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   14 
   15 COMMIT;