Re^2: newbie table structure

Thanks.

I think I'll try your code but I do have a few questions.

What is "engine_id", "name" and "homepage"? I don't know what information you're expecting to be in these fields. And why is useragent and integer in SEARCH_ENGINE when it's not an integer?

Thanks.

Comment on Re^2: newbie table structure

Replies are listed 'Best First'.
Re^3: newbie table structure by Corion (Patriarch) on Jan 29, 2005 at 19:53 UTC
I added "name" and "homepage" as ideas for additional information you might want to store for each search engine - I should have said that. Having a central location to store that data allows you to easily update the information without having several places where you need to change it. The `engine_id` in the table `visits` points to the search engine that visited you. That `useragent` is an `int` in the search engine table is an error - it should be `char(250)` or something like that.	[reply]

Replies are listed 'Best First'.

Re^3: newbie table structure
by Corion (Patriarch) on Jan 29, 2005 at 19:53 UTC

I added "name" and "homepage" as ideas for additional information you might want to store for each search engine - I should have said that. Having a central location to store that data allows you to easily update the information without having several places where you need to change it.

The engine_id in the table visits points to the search engine that visited you. That useragent is an int in the search engine table is an error - it should be char(250) or something like that.

[reply]