[PHP-DB] Breeders database

[Russell Griechen]

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.

Advertising

# 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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php