Changeset 6685

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

SQL error removed in Centstorage SQL update script.

Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r6677 r6685  
    3131  KEY `action_log_id` (`action_log_id`) 
    3232) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    33  
    34 -- -------------------------------------------------------- 
    35  
    36 --  
    37 -- Structure de la table `acl_actions` 
    38 --  
    39  
    40 CREATE TABLE `acl_actions` ( 
    41   `acl_action_id` int(11) NOT NULL auto_increment, 
    42   `acl_action_name` varchar(255) default NULL, 
    43   `acl_action_description` varchar(255) default NULL, 
    44   `acl_action_activate` enum('0','1','2') default NULL, 
    45   PRIMARY KEY  (`acl_action_id`) 
    46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
    47  
    48 -- -------------------------------------------------------- 
    49  
    50 --  
    51 -- Structure de la table `acl_actions_rules` 
    52 --  
    53  
    54 CREATE TABLE `acl_actions_rules` ( 
    55   `aar_id` int(11) NOT NULL auto_increment, 
    56   `acl_action_rule_id` int(11) default NULL, 
    57   `acl_action_name` varchar(255) default NULL, 
    58   PRIMARY KEY  (`aar_id`) 
    59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
    60  
    61 -- -------------------------------------------------------- 
    62  
    63 --  
    64 -- Structure de la table `acl_group_actions_relations` 
    65 --  
    66  
    67 CREATE TABLE `acl_group_actions_relations` ( 
    68   `agar_id` int(11) NOT NULL auto_increment, 
    69   `acl_action_id` int(11) default NULL, 
    70   `acl_group_id` int(11) default NULL, 
    71   PRIMARY KEY  (`agar_id`), 
    72   KEY `acl_action_id` (`acl_action_id`), 
    73   KEY `acl_group_id` (`acl_group_id`) 
    74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
    75  
    76 -- --------------------------------------------------------