"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/4.sql" (15 Sep 2021, 621 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 tusuario add autorefresh_white_list text not null default '';
    4 ALTER TABLE tserver_export MODIFY name varchar(600) BINARY NOT NULL default '';
    5 
    6 CREATE TABLE IF NOT EXISTS `tpolicy_groups` (
    7     `id` int(10) unsigned NOT NULL auto_increment,
    8     `id_policy` int(10) unsigned default '0',
    9     `id_group` int(10) unsigned default '0',
   10     `policy_applied` tinyint(1) unsigned default '0',
   11     `pending_delete` tinyint(1) unsigned default '0',
   12     `last_apply_utimestamp` int(10) unsigned NOT NULL default 0,
   13     PRIMARY KEY  (`id`),
   14     UNIQUE (`id_policy`, `id_group`)
   15 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
   16 
   17 COMMIT;