Re: Multi-user bookmark system

2005-05-06 Thread Lieven De Keyzer
From: Peter Brawley <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Lieven De Keyzer <[EMAIL PROTECTED]> Subject: Re: Multi-user bookmark system Date: Fri, 06 May 2005 11:07:48 -0500 Lieven, Here it is. Removing the FK looks to me like an incorrect fix to the transitive dependen

Re: Multi-user bookmark system

2005-05-06 Thread Lieven De Keyzer
Peter, From: Peter Brawley <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Lieven De Keyzer <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Multi-user bookmark system Date: Fri, 06 May 2005 10:09:12 -0500 Lieven, If a folder belongs to an account, why not use the accoun

Re: Multi-user bookmark system

2005-05-06 Thread Peter Brawley
Lieven, If a folder belongs to an account, why not use the account PK as a FK in folders? See http://www.intelligententerprise.com/001020/celko1_1.jhtml for ideas about SQL representation of trees. Peter Brawley http://www.artfulsoftware.com - Lieven De Keyzer wrote: I'm writing a web-appli