"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/22.sql" (27 Mar 2019, 743 Bytes) of package /linux/misc/pandorafms_console-7.0NG.733.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 `talert_commands` ADD COLUMN `id_group` mediumint(8) unsigned NULL default 0;
    4 
    5 ALTER TABLE `tusuario` DROP COLUMN `flash_chart`;
    6 
    7 ALTER TABLE `tusuario` ADD COLUMN `default_custom_view` int(10) unsigned NULL default '0';
    8 
    9 ALTER TABLE tlayout_template MODIFY `name` varchar(600) NOT NULL;
   10 
   11 CREATE TABLE IF NOT EXISTS `tagent_custom_fields_filter` (
   12     `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   13     `name` varchar(600) NOT NULL,
   14     `id_group` int(10) unsigned default '0',
   15     `id_custom_field` varchar(600) default '',
   16     `id_custom_fields_data` varchar(600) default '',
   17     `id_status` varchar(600) default '',
   18     `module_search` varchar(600) default '',
   19     PRIMARY KEY(`id`)
   20 ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
   21 
   22 COMMIT;