Re: help with table structure

2004-10-12 Thread Justin Smith
Chris W. Parker wrote: interesting you say that because i was going to do this same thing except not as completely as i probably should (which i think is what you are suggesting). what i mean is, my extra table of addresses was going to be merely shipping addresses for the customer and nothing else

Re: help with table structure

2004-10-12 Thread Justin Smith
What you have so far looks good, but what I learned from doing my ecomm project was that it is beneficial to make a separate table for anything and everything that you might have more than one of... Addresses, phone numbers, and email addresses are all great candidates for breaking out into an

Re: MySQL Databases in Subdirectories?

2004-10-08 Thread Justin Smith
nance (backups, etc.) a chore. Ruben Safir Secretary NYLXS wrote: How does that help? The database itself should be allowed to organize everything. Ruben On Thu, Oct 07, 2004 at 04:57:39PM -0700, Justin Smith wrote: Is it possible to create a database in a lower-level subdirectory of MySQL&#

MySQL Databases in Subdirectories?

2004-10-07 Thread Justin Smith
Is it possible to create a database in a lower-level subdirectory of MySQL's data directory? We have almost 100,000 sites, and we would like to have a separate database for each site. However, it's very impractical from a filesystem maintenance standpoint to have 100,000 subdirectories of MyS