How to Host Multiple Databases
Most accounts with ISPs are for a limited number of MySQL databases - usually
This is not a limitation for PedigreePoint which allows for multiple breed "databases" since
each one is stored as a table within the database.
Follow these steps to create and make multiple breed databases available on your web site:
Create table for each breed database
To create a pedigree table use the following script but instead of `second`, use a different name for your other breed tables.
CREATE TABLE `second` (
`PedigreeId` int(11) NOT NULL auto_increment,
`Name` varchar(64) default NULL,
`SireId` int(11) default NULL,
`DamId` int(11) default NULL,
`Sex` varchar(10) default NULL,
`DOB` date default NULL,
`PreTitle` varchar(32) default NULL,
`PostTitle` varchar(32) default NULL,
`RegNo` varchar(64) default NULL,
`Color` varchar(64) default NULL,
`Photo` varchar(64) default NULL,
`_Marks` int(11) default 0,
PRIMARY KEY (`PedigreeId`)
The above script needs to be copied and pasted into your phpMyAdmin console windows as shown below:
Create second source of data
In Pedigree Publisher, create another database file (.DB). When you export data using the TOOLS-Export PedigreePoint command make sure that the "Table Name:" field is set to the name of your newly created PedigreePoint table. The screen shot below shows Table Name as 'pedigree "second" so that's what we show here:
The PedigreePoint export file created by this step can be uploaded as for other uploads which are described here.
Modify Search Page
The file pp_search.htm nees to be modified to offer your second database as a choice to the user. The search dialog looks like the following:
The Database combo needs to be edited to offer your second database as an option. The best way to do this is to edit the raw HTML. The sample below shows what the HTML should look like for two choices. Note that for each option the value="database" is the name of the actual MySQL table which is normally but pedigree, but if you had multiple you would probably name them after the breed like nova for Nova Scotia Duck Tolling Retriever. The text between the <option> and </option> (start and end tags) is the text that is shown to the user for that option. Within the <option> tag inlcude the word selected to make that option the default.