"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/6.sql" (15 Sep 2021, 693 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 tagente MODIFY COLUMN `cascade_protection_module` int(10) unsigned NOT NULL default '0';
    4 
    5 CREATE TABLE IF NOT EXISTS treset_pass_history (
    6     id int(10) unsigned NOT NULL auto_increment,
    7     id_user varchar(60) NOT NULL,
    8     reset_moment datetime NOT NULL,
    9     success tinyint(1) NOT NULL,
   10     PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   11 
   12 
   13 ALTER TABLE tserver ADD COLUMN exec_proxy tinyint(1) UNSIGNED NOT NULL default 0;
   14 
   15 ALTER TABLE tevent_response ADD COLUMN server_to_exec int(10) unsigned NOT NULL DEFAULT 0;
   16 
   17 INSERT INTO tmodule VALUES (8, 'Wux module');
   18 
   19 INSERT INTO ttipo_modulo VALUES (25,'web_analysis', 8, 'Web analysis data', 'module-wux.png');
   20 
   21 COMMIT;