RE: help design the table

2009-12-23 Thread Jerry Schwartz
>-Original Message- >From: Mikhail Berman [mailto:mikhail...@gmail.com] >Sent: Wednesday, December 23, 2009 9:16 AM >To: Eva >Cc: mysql@lists.mysql.com >Subject: Re: help design the table > >Hi Eva, > >It seems to me that you might want to have two tables th

Re: help design the table

2009-12-23 Thread Mikhail Berman
Hi Eva, It seems to me that you might want to have two tables that will describe data in your database * - DOMAINS * - IPS DOMAINS table should contain two fields: * `domain_key` - auto-increment * `domain_name` - varchar(20) IPS table should contain three fields domain_key - int(10) - being

help design the table

2009-12-23 Thread Eva
Hello, I have a table, which has a column named as "domain", each domain has some IPs, each IP has two attributes: "disabled","noticed". For example, the table: domainIP www.aol.com 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1 But I don't know how to control the IP's att