Breeders database
| From: | Russell Griechen | Date: | Wed, 25 Sep 2002 16:53:21 +0000 |
| Subject: | Breeders database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21978@lists.php.net to get a copy of this message | ||
Here is the kernel ...What other attributes/indexes in the table would
I need to generate a 5 generation pedigree...I am still trying to find
those queries.
# Host: localhost Database : hounds
# --------------------------------------------------------
#
# Table structure for table 'hound'
#
DROP TABLE IF EXISTS hound;
CREATE TABLE hound (
id bigint(21) NOT NULL auto_increment,
name varchar(100) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'hound'
#
# --------------------------------------------------------
#
# Table structure for table 'parent'
#
DROP TABLE IF EXISTS parent;
CREATE TABLE parent (
id bigint(21) NOT NULL auto_increment,
sireid bigint(21) DEFAULT '0' NOT NULL,
damid bigint(21) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'parent'
#
Russell Griechen