# CocoaMySQL dump
# Version 0.5
# http://cocoamysql.sourceforge.net
#
# Host: 192.168.0.24 (MySQL 5.0.24a-community)
# Database: menagerie
# Generation Time: 2006-11-09 17:42:39 +0100
# ************************************************************

# Dump of table tier
# ------------------------------------------------------------

CREATE TABLE `tier` (
  `name` varchar(20) collate latin1_general_ci default NULL,
  `besitzer` varchar(20) collate latin1_general_ci default NULL,
  `spezies` varchar(20) collate latin1_general_ci default NULL,
  `geschlecht` char(1) collate latin1_general_ci default NULL,
  `geboren` date default NULL,
  `gestorben` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Fluffy","Harold","cat","w","1993-02-04","1999-02-04");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Claws","Gwen","cat","m","1994-03-17","2000-06-01");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Buffy","Harold","dog","w","1989-05-03","2003-03-02");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Fang","Benny","dog","m","1990-08-27","2000-09-27");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Bowser","Diane","cat","m","1998-08-31","2001-07-29");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Chirpy","Gwen","bird","w","1989-09-11","2001-12-12");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Whistler","Gwen","bird","","1997-12-01","2002-04-03");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Slim","Benny","snake","m","1996-04-29","1997-03-02");
INSERT INTO `tier` (`name`,`besitzer`,`spezies`,`geschlecht`,`geboren`,`gestorben`) VALUES ("Puffball","Diane","hamster","w","1997-03-30","2000-05-30");