Use the latest verson of InnoDB, it supports foreign key constraints.
See the documentation for more info on how to declare foreign keys.
Steve Meyers
On Fri, 2001-10-26 at 06:13, McGrotty, Charles wrote:
> Hello,
>
> I have tables in a user administration database and need to link different
> tables with FK's.
>
> How do I do this?
>
> for example:
>
> I have two tables, one called applications, the other called
> forum_moderators.
>
> Applications Catches all form submissions.
> Forum_Moderators hold the details of active/current moderators
>
> I want to link these two tables by rsm_id in applications, and fk_rsm_id in
> forum_mod's.
>
> How would i do this in MySQL and or PHP?
>
>
> Table Structure:
> for those that need a clearer picture of my layout, I have supplied the SQL
> statement to create the tables
>
> #--------------------------------------------------------
> #
> # Table structure for table 'applications'
> #
>
> DROP TABLE IF EXISTS applications;
>
> CREATE TABLE `applications` (
> `rsm_id` tinyint(4) NOT NULL auto_increment,
> `first_name` varchar(20) NOT NULL default '',
> `last_name` varchar(20) NOT NULL default '',
> `city` varchar(10) NOT NULL default '',
> `state` char(2) NOT NULL default '',
> `dob` varchar(10) NOT NULL default '',
> `forum_nick` varchar(20) NOT NULL default '',
> `forum_select1` varchar(30) NOT NULL default '',
> `forum_select2` varchar(30) NOT NULL default '',
> `forum_select3` varchar(30) NOT NULL default '',
> `bio` blob NOT NULL,
> `email_addr` varchar(100) NOT NULL default '',
> `processed` set('0','1') NOT NULL default '',
> `add_date` date NOT NULL default '0000-00-00',
> `accept_denied` set('A','D') NOT NULL default '',
> `acc_dec_date` date NOT NULL default '0000-00-00',
> PRIMARY KEY (`rsm_id`),
> UNIQUE KEY `email_addr` (`email_addr`),
> UNIQUE KEY `forum_nick` (`forum_nick`),
> UNIQUE KEY `rsm_id` (`rsm_id`),
> KEY `rsm_id_2` (`rsm_id`),
> KEY `forum_nick_2` (`forum_nick`),
> KEY `email_addr_2` (`email_addr`)
> #--------------------------------------------------------
>
> #
> # Table structure for table 'forum_moderators'
> #
>
> DROP TABLE IF EXISTS forum_moderators;
> CREATE TABLE `forum_moderators` (
> `formod_id` tinyint(4) NOT NULL auto_increment,
> `name` varchar(40) NOT NULL default '',
> `city` varchar(10) NOT NULL default '',
> `state` char(2) NOT NULL default '',
> `forum_nick` varchar(20) NOT NULL default '',
> `mod_forum_1` varchar(30) NOT NULL default '',
> `mod_forum_2` varchar(30) NOT NULL default '',
> `mod_forum_3` varchar(30) NOT NULL default '',
> `email_addr` varchar(100) NOT NULL default '',
> `tremination_date` date default NULL,
> `fk_rsm_id` tinyint(4) NOT NULL default '0',
> PRIMARY KEY (`formod_id`),
> UNIQUE KEY `formod_id` (`formod_id`,`forum_nick`),
> KEY `formod_id_2` (`formod_id`)
> ) TYPE=MyISAM;
> #--------------------------------------------------------
> #--------------------------------------------------------
>
> Regards,
> Charlie
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
