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
