Hi All,

I have successfully parsed the dmoz dump files into mysql.
There are 4 tables: structure, content_description, content_links and datatypes.

Structure table has fields: catid, name, title.....
I set the primary key as CATID and it works fine.

When I tried to do the same for the rest of the tables such as datatypes (with fields: catid, type, resource) i always got this error:

SQL query: Edit

ALTER TABLE `datatypes` ADD PRIMARY KEY ( `catid` ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

same goes to other tables (content_links with fields: catid,topic,type, resource).


Another problem, the 3rd table (content_description) has the following fields: externalpage, title, description,ages, mediadate,priority.

the question is which one of these fields should be the PK here?

hope to get your feedbacks....
thanks a lot..