#1005 Can't create table hostgroups_members (errno: 150)
Bonjour,
je n'arrive pas à trouver où est l'erreur. la clef étrangère est du même type que les autres...
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
-- -----------------------------------------------------
-- Table `host`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `host` (
`host_id` INT(11) NOT NULL ,
`host_object_id` INT(11) NOT NULL ,
`client` VARCHAR(45) NULL ,
`site` VARCHAR(45) NULL ,
`host_name` VARCHAR(45) NULL ,
`host_critical` VARCHAR(10) NULL ,
PRIMARY KEY (`host_id`, `host_object_id`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `hostgroups`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hostgroups` (
`hostgroup_object_id` INT(11) NOT NULL ,
`hostgroup_id` INT(11) NOT NULL ,
`alias` VARCHAR(255) NULL ,
PRIMARY KEY (`hostgroup_object_id`, `hostgroup_id`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `hostgroups_members`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hostgroups_members` (
`host_object_id` INT(11) NOT NULL ,
`hostgroup_id` INT(11) NOT NULL ,
INDEX `host_object_id` (`host_object_id` ASC) ,
INDEX `hostgroup_id` (`hostgroup_id` ASC) ,
CONSTRAINT `host_object_id`
FOREIGN KEY (`host_object_id` )
REFERENCES `nagios_host` (`host_object_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `hostgroup_id`
FOREIGN KEY (`hostgroup_id` )
REFERENCES `nagios_hostgroups` (`hostgroup_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB; |
Merci de votre aide
