Re: [vchkpw] Re: Mysql table

2007-09-23 Thread Rick Widmer
Tom Collins wrote: I think we'll get better domain alias support if you pull column > `domain` out of table `Domains` and add it to the table `domain_alias`. I agree. This makes it easy to make sure domain names are unique. > I'm not sure we need to have a "master" and "alias" -- the names c

Re: [vchkpw] Re: Mysql table

2007-09-22 Thread Rick Macdougall
Rick Widmer wrote: I wasn't quite ready for this, but it has been on my list for a long time... since it has come up, let me throw up this database structure for comment. I have reduced the number of tables (in a full installation) and made it relational.- CREATE TABLE relay( ip_addr

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Tom Collins
On Sep 21, 2007, at 4:32 PM, Rick Widmer wrote: Comments? I think we'll get better domain alias support if you pull column `domain` out of table `Domains` and add it to the table `domain_alias`. "Domain name" to "domain on the system" is a many to one relationship, so the name should be i

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Widmer
I wasn't quite ready for this, but it has been on my list for a long time... since it has come up, let me throw up this database structure for comment. I have reduced the number of tables (in a full installation) and made it relational.- CREATE TABLE Domains( domain_idbi

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Macdougall
Robin Bowes wrote: Rick Macdougall wrote: Robin Bowes wrote: Tom Collins wrote: I understand what you're proposing, but I would suggest that it would add complexity for little gain. Of course, that would need benchmarking to establish which is the faster method. If someone can give me a large

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Macdougall
Robin Bowes wrote: Tom Collins wrote: I understand what you're proposing, but I would suggest that it would add complexity for little gain. Of course, that would need benchmarking to establish which is the faster method. If someone can give me a large dataset, I'm happy to crunch some numbers.