Hi Tim,
Foreign key definitions are parsed but ignored by MyISAM tables.
Try InnoDB or PBXT (http://www.primebase.com/xt) :)
On Feb 21, 2007, at 9:35 AM, Tim Johnson wrote:
On Wednesday 21 February 2007 17:01, Rolando Edwards wrote:
SHOW CREATE TABLE providers\G
Hi Rolando:
That doesn't do it on my machine (linux, ver 4.0.2)
Here's what I see
mysql> SHOW CREATE TABLE providers\G
*************************** 1. row ***************************
Table: providers
Create Table: CREATE TABLE `providers` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '**',
`nick_name` varchar(10) NOT NULL default '**',
`email_address` varchar(80) NOT NULL default '**',
`start_date` date NOT NULL default '0000-00-00',
`company_ID` int(11) NOT NULL default '0',
`status` int(6) default NULL,
`modified` timestamp(10) NOT NULL,
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM
1 row in set (0.00 sec)
As you can see there is no reference info for column `status`
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]