howto chang table prefix on the fly

2008-10-24 Thread paydjo
I build application for multi user that separate table for every user.
there would be user1_posts, user2_posts, user3_posts,  ..., userX_posts
X = user.id

is it possible to change tablePrefix on the fly ?

-- 
http://paydjo.net/

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Re: howto chang table prefix on the fly

2008-10-24 Thread wirtsi

That sounds like a terribe design idea. Why don't you use the users id
as foreign key in posts (ie user_id)?

On 24 Okt., 09:34, paydjo [EMAIL PROTECTED] wrote:
 I build application for multi user that separate table for every user.
 there would be user1_posts, user2_posts, user3_posts,  ..., userX_posts
 X = user.id

 is it possible to change tablePrefix on the fly ?

 --http://paydjo.net/
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



Re: howto chang table prefix on the fly

2008-10-24 Thread paydjo
On Fri, Oct 24, 2008 at 5:09 PM, wirtsi [EMAIL PROTECTED]wrote:


 That sounds like a terribe design idea. Why don't you use the users id
 as foreign key in posts (ie user_id)?


its for performance.
wordpress mu inspirated my team for this database design.

the problem is I can't change tablePrefix on the fly.
is it possible to change database.php like config object ?



 On 24 Okt., 09:34, paydjo [EMAIL PROTECTED] wrote:
  I build application for multi user that separate table for every user.
  there would be user1_posts, user2_posts, user3_posts,  ..., userX_posts
  X = user.id
 
  is it possible to change tablePrefix on the fly ?
 
  --http://paydjo.net/
 



-- 
http://paydjo.net/

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---