Hi!
I have two tables:
CREATE TABLE `pokoje` (
  `nrpok_p` char(10) NOT NULL default '',
  `nip_h` int(10) NOT NULL default '0',
  `lozka_p` char(2) default NULL,
  `tv_p` char(1) default NULL,
  `lazienka_p` char(1) default NULL,
  `cena_p` int(10) default NULL,
  `zaliczka_p` int(10) default NULL,
  PRIMARY KEY  (`nrpok_p`,`nip_h`),
  KEY `nip_h_index` (`nip_h`,`nrpok_p`),
  FOREIGN KEY (`nip_h`) REFERENCES `hotele` (`nip_h`) ON DELETE CASCADE
) TYPE=InnoDB;

 CREATE TABLE `rezerwacje` (
  `id_r` int(10) NOT NULL default '0',
  `pesel_k` int(11) default NULL,
  `nip_h` int(10) NOT NULL default '0',
  `nrpok_p` char(10) NOT NULL default '',
  `data_r` date default NULL,
  `od_r` date default NULL,
  `do_r` date default NULL,
  `cena_r` int(10) default NULL,
  `zaliczka_r` int(5) default NULL,
  `zaplac_r` char(1) default NULL,
  `wplaczal_r` char(1) default NULL,
  PRIMARY KEY  (`id_r`),
  KEY `nip_h_index` (`nip_h`,`nrpok_p`)
) TYPE=InnoDB;

Now, when I try:
alter table rezerwacje add foreign key (nip_h,nrpok_p) references
pokoje(nip_h,nrpok_p);
I get:
ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)

Why?



-- 
_/        _/  _/_/_/  -----     Rafał Jank [EMAIL PROTECTED]     -----
 _/  _/  _/  _/   _/         Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/    ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
   _/  _/  _/         --------==*  http://szukaj.wp.pl *==----------

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to