I have a default installation of links sql working. (sort off.. still have some problems, but I'm working through them one by one).
The first customisation I need to do is setup a white pages.
This will allow members to list the following items.
First_Name, Last_Name, Address_1, Address_2, City, State, Country, Phone, Fax, Email, URL, Description
The first 9 fields are custom. I have figured out how to add them to the database but am not too happy about modifying the fields as is.
My questions are :-
* Do I have to modify lsql_Links and add these 9 fields to every row in the table? The rest of my directory has about 700,000 entries from DMOZ and I don't want to pad each of those entries with the White Pages structure. Any way in which I can set this up a bit more optimally?
* Can I setup a category in such a way in which it uses an alternative table for its links? Say the category White_Pages/Hong_Kong and White_Pages/Singapore use the table lsql_whitepages_links for their links?
More questions later :)
The first customisation I need to do is setup a white pages.
This will allow members to list the following items.
First_Name, Last_Name, Address_1, Address_2, City, State, Country, Phone, Fax, Email, URL, Description
The first 9 fields are custom. I have figured out how to add them to the database but am not too happy about modifying the fields as is.
My questions are :-
* Do I have to modify lsql_Links and add these 9 fields to every row in the table? The rest of my directory has about 700,000 entries from DMOZ and I don't want to pad each of those entries with the White Pages structure. Any way in which I can set this up a bit more optimally?
* Can I setup a category in such a way in which it uses an alternative table for its links? Say the category White_Pages/Hong_Kong and White_Pages/Singapore use the table lsql_whitepages_links for their links?
More questions later :)