Sorry! I'm not that experienced with databases as you probably realised!
url_visit | CREATE TABLE `url_visit` (
`urlid` mediumint(9) NOT NULL auto_increment,
`url_scheme_ID` int(11) NOT NULL default '0',
`url_server_ID` int(11) NOT NULL default '0',
`url_path_ID` int(11) NOT NULL default '0',
`query` text,
`category` varchar(50) default NULL,
PRIMARY KEY (`urlid`),
KEY `url_scheme_ID` (`url_scheme_ID`,`url_server_ID`,`url_path_ID`)
) TYPE=MyISAM
>
>I can't tell from a DESCRIBE output. Please post the results of SHOW
>CREATE TABLE url_visit;
>
>Thanks!
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>
>
>
> "J S"
> <vervoom@hotmail. To: SGreen@stripped
> com> cc:
>mysql@stripped
> Fax to:
> 06/23/2004 09:57 Subject: Re: load data
>into 2 tables and set id
> AM
>
>
>
>
>
>
>Hi Shawn,
>
>Here's the url_Schemes table (it's the same as the url_paths and
>url_servers). This means url_scheme_ID is part of a unique constraint/key ?
>
>mysql> desc url_schemes;
>+--------+-------------+------+-----+---------+----------------+
>| Field | Type | Null | Key | Default | Extra |
>+--------+-------------+------+-----+---------+----------------+
>| ID | int(11) | | MUL | NULL | auto_increment |
>| scheme | varchar(20) | | PRI | | |
>+--------+-------------+------+-----+---------+----------------+
>2 rows in set (0.00 sec)
>
>mysql> desc url_visit;
>+---------------+--------------+------+-----+---------+----------------+
>| Field | Type | Null | Key | Default | Extra |
>+---------------+--------------+------+-----+---------+----------------+
>| urlid | mediumint(9) | | PRI | NULL | auto_increment |
>| url_scheme_ID | int(11) | | MUL | 0 | |
>| url_server_ID | int(11) | | | 0 | |
>| url_path_ID | int(11) | | | 0 | |
>| query | text | YES | | NULL | |
>| category | varchar(50) | YES | | NULL | |
>+---------------+--------------+------+-----+---------+----------------+
>6 rows in set (0.00 sec)
>
>mysql> select * from url_schemes;
>+----+--------+
>| ID | scheme |
>+----+--------+
>| 1 | http |
>| 2 | tcp |
>| 3 | - |
>| 4 | ftp |
>| 5 | https |
>+----+--------+
>5 rows in set (0.00 sec)
>
> >
>------ previous responses clipped for space ---------
>
>
>
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
