Changeset 6684

Show
Ignore:
Timestamp:
10/02/08 11:01:31 (2 months ago)
Author:
dduponchelle
Message:

Centreon SQL Script updated to introduce new feature (ACL Actions Access).

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/centreon/www/install/sql/Update-DB-2.0_to_2.1.sql

    r6674 r6684  
    33UPDATE `contact` SET `contact_location` = '0'; 
    44UPDATE `host` SET `host_location` = '0'; 
     5INSERT INTO `topology` (`topology_id`, `topology_name`, `topology_icone`, `topology_parent`, `topology_page`, `topology_order`, `topology_group`, `topology_url`, `topology_url_opt`, `topology_popup`, `topology_modules`, `topology_show`, `topology_style_class`, `topology_style_id`, `topology_OnClick`) VALUES(NULL, 'Actions Access', './img/icones/16x16/wrench.gif', 502, 50204, 25, 1, './include/options/accessLists/actionsACL/actionsConfig.php', NULL, '0', '0', '1', NULL, NULL, NULL); 
     6 
     7-- -------------------------------------------------------- 
     8 
     9--  
     10-- Structure de la table `acl_actions` 
     11--  
     12 
     13CREATE TABLE `acl_actions` ( 
     14  `acl_action_id` int(11) NOT NULL auto_increment, 
     15  `acl_action_name` varchar(255) default NULL, 
     16  `acl_action_description` varchar(255) default NULL, 
     17  `acl_action_activate` enum('0','1','2') default NULL, 
     18  PRIMARY KEY  (`acl_action_id`) 
     19) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     20 
     21-- -------------------------------------------------------- 
     22 
     23--  
     24-- Structure de la table `acl_actions_rules` 
     25--  
     26 
     27CREATE TABLE `acl_actions_rules` ( 
     28  `aar_id` int(11) NOT NULL auto_increment, 
     29  `acl_action_rule_id` int(11) default NULL, 
     30  `acl_action_name` varchar(255) default NULL, 
     31  PRIMARY KEY  (`aar_id`) 
     32) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     33 
     34-- -------------------------------------------------------- 
     35 
     36--  
     37-- Structure de la table `acl_group_actions_relations` 
     38--  
     39 
     40CREATE TABLE `acl_group_actions_relations` ( 
     41  `agar_id` int(11) NOT NULL auto_increment, 
     42  `acl_action_id` int(11) default NULL, 
     43  `acl_group_id` int(11) default NULL, 
     44  PRIMARY KEY  (`agar_id`), 
     45  KEY `acl_action_id` (`acl_action_id`), 
     46  KEY `acl_group_id` (`acl_group_id`) 
     47) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     48 
     49-- --------------------------------------------------------