On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote:
> HI > I'm not sure what is wrong with my CREATE TABLE syntax, Please advice > > There is no index on ifname in table equipment_interfaces. > > mysql> CREATE TABLE equipment ( > -> equipID CHAR(20) NOT NULL, > -> assetNumber CHAR(20), > -> serialNumber CHAR(50), > -> description BLOB, > -> barcode CHAR(20), > -> room CHAR(20), > -> area CHAR(20), > -> owner CHAR(100), > -> createDate DATE, > -> PRIMARY KEY (equipID) > -> ) TYPE=INNODB; > Query OK, 0 rows affected (0.00 sec) > > mysql> CREATE TABLE equipment_interfaces ( > -> equipID CHAR(20) NOT NULL, > -> ifName CHAR(20) NOT NULL, > -> ifType ENUM("10Mbs","100Mbs","1Gb","CDDI","FDDI"), > -> ifNet CHAR(50), > -> ifIPv4addr CHAR(20), > -> INDEX (equipID), > -> FOREIGN KEY (equipID) REFERENCES equipment (equipID) ON > DELETE CASCADE, > -> PRIMARY KEY (equipID, ifName) > -> ) TYPE=INNODB; > Query OK, 0 rows affected (0.01 sec) > > *************************************************************************** > ******************************************************************** mysql> > CREATE TABLE equipment_interfaces_IPv4alias ( > -> equipID CHAR(20) NOT NULL, > -> ifName CHAR(20) NOT NULL, > -> ifIPv4alias CHAR(20) NOT NULL, > -> INDEX (equipID), > -> FOREIGN KEY (equipID) REFERENCES equipment (equipID) ON > DELETE CASCADE, > -> INDEX (ifName), > -> FOREIGN KEY (ifName) REFERENCES equipment_interfaces > (ifName) ON DELETE CASCADE, > -> PRIMARY KEY (equipID, ifName, ifIPv4alias) > -> ) TYPE=INNODB; > ERROR 1005: Can't create table > './test/equipment_interfaces_IPv4alias.frm' (errno: 150) > mysql> > *************************************************************************** > ********************************************************************** > > [vinita@mungah] vinita [1:54] perror 150 > Error code 150: Unknown error: 150 > > -- > > > warm regards > Vinita Vigine Murugiah > Email : [EMAIL PROTECTED] Ph : (03) 8344 1273 > > > > --------------------------------------------------------------------- > 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 > -- _/ _/ _/_/_/ ----- 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