[racktables-users] Re: DEFAULT_PORT_OIF_IDS
- From: Denis Ovsienko <infrastation@xxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Sun, 31 Jul 2011 22:44:31 +0400
> ALTER TABLE `PortInnerInterface` ADD UNIQUE (`default_oif_id` );
This is wrong. In practice the same OIF may be default for several IIFs (e.g.
10GBase-SR for SFP+ and XFP).
> ALTER TABLE PortInnerInterface ADD CONSTRAINT
> `PortInnerInterface-FK-default_oif_id` FOREIGN KEY (`default_oif_id`)
> REFERENCES `Dictionary` (`dict_key`) ON DELETE CASCADE;
This won't work, because Dictionary is normally MyISAM (this blocks several
other foreign keys as well). It is likely to finally become InnoDB in next
releases, but now it is MyISAM.
--
Denis Ovsienko
Other related posts:
