Merge branch 'maint/7.0'
[ninja.git] / sql / mysql / ninja_db_v9_to_v10.sql
bloba3a7a056a17bf64d3b15947ed940789f6a9be5ad
1 INSERT INTO `ninja_saved_filters` (`username`, `filter_name`, `filter_table`, `filter`, `filter_description`) VALUES
2 (NULL,'acknowledged hosts','hosts','[hosts] acknowledged = 1','acknowledged hosts'),
3 (NULL,'acknowledged services','services','[services] acknowledged = 1','acknowledged services'),
4 (NULL,'host groups with problems','hostgroups','[hostgroups] (worst_host_state != 0 or worst_service_state != 0)','host groups with problems'),
5 (NULL,'service groups with problems','servicegroups','[servicegroups] worst_service_state != 0','service groups with problems'),
6 (NULL,'unhandled host problems','hosts','[hosts] state != 0 and acknowledged = 0','unhandled host problems'),
7 (NULL,'unhandled problems','services','[services] in \"unhandled service problems\"\nor host in \"unhandled host problems\"','unhandled problems'),
8 (NULL,'unhandled service problems','services','[services] state != 0 and acknowledged = 0','unhandled service problems');