-- MySQL dump 10.9
--
-- Host: localhost    Database: comboscreen 
-- ------------------------------------------------------
-- Server version	4.0.18-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Table structure for table `clone`
--

DROP TABLE IF EXISTS `clone`;
CREATE TABLE `clone` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(25) default NULL,
  `prim_hyb_bottle` int(9) default NULL,
  `islarge` tinyint(1) default NULL,
  `cloner` varchar(30) default NULL,
  `panel` int(2) default NULL,
  `filter` int(3) default NULL,
  `date_scored` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `filter_set`
--

DROP TABLE IF EXISTS `filter_set`;
CREATE TABLE `filter_set` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `filter_type_id` int(9) default NULL,
  `genus` varchar(20) default NULL,
  `species` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `filter_type`
--

DROP TABLE IF EXISTS `filter_type`;
CREATE TABLE `filter_type` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(25) default NULL,
  `panels` varchar(6) default '251403',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `hyb_bottle`
--

DROP TABLE IF EXISTS `hyb_bottle`;
CREATE TABLE `hyb_bottle` (
  `id` int(9) NOT NULL auto_increment,
  `pool_id` int(9) default NULL,
  `filter_set_id` int(9) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `hyb_bottle_filter`
--

DROP TABLE IF EXISTS `hyb_bottle_filter`;
CREATE TABLE `hyb_bottle_filter` (
  `id` int(11) NOT NULL auto_increment,
  `hyb_bottle_id` int(11) NOT NULL default '0',
  `filter_number` int(11) NOT NULL default '0',
  `scored` int(11) NOT NULL default '0',
  `filename` varchar(128) default NULL,
  `panel1_ul_x` int(11) default NULL,
  `panel1_ul_y` int(11) default NULL,
  `panel1_lr_x` int(11) default NULL,
  `panel1_lr_y` int(11) default NULL,
  `panel1_transform` double default NULL,
  `panel2_ul_x` int(11) default NULL,
  `panel2_ul_y` int(11) default NULL,
  `panel2_lr_x` int(11) default NULL,
  `panel2_lr_y` int(11) default NULL,
  `panel2_transform` double default NULL,
  `panel3_ul_x` int(11) default NULL,
  `panel3_ul_y` int(11) default NULL,
  `panel3_lr_x` int(11) default NULL,
  `panel3_lr_y` int(11) default NULL,
  `panel3_transform` double default NULL,
  `panel4_ul_x` int(11) default NULL,
  `panel4_ul_y` int(11) default NULL,
  `panel4_lr_x` int(11) default NULL,
  `panel4_lr_y` int(11) default NULL,
  `panel4_transform` double default NULL,
  `panel5_ul_x` int(11) default NULL,
  `panel5_ul_y` int(11) default NULL,
  `panel5_lr_x` int(11) default NULL,
  `panel5_lr_y` int(11) default NULL,
  `panel5_transform` double default NULL,
  `panel6_ul_x` int(11) default NULL,
  `panel6_ul_y` int(11) default NULL,
  `panel6_lr_x` int(11) default NULL,
  `panel6_lr_y` int(11) default NULL,
  `panel6_transform` double default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Table structure for table `image`
--

DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `file` mediumblob,
  `user` varchar(30) default NULL
) TYPE=MyISAM;
  
--
-- Table structure for table `image_paths`
--

DROP TABLE IF EXISTS `image_paths`;
CREATE TABLE `image_paths` (
  `path` mediumblob, 
  `id` int(11) default NULL
) TYPE=MyISAM; 

--
-- Table structure for table `pool`
--

DROP TABLE IF EXISTS `pool`;
CREATE TABLE `pool` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(35) default NULL,
  `description` varchar(35) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table 'stamping_plate'
--

DROP TABLE IF EXISTS 'stamping_plate';
CREATE TABLE 'stamping_plate' (
  `id` int(9) NOT NULL auto_increment, 
  `name` varchar(40) default NULL,
  `filter_type_id` int(9) default NULL,
  `filter` int(3) default NULL,
  `panel` int(3) default NULL,
  `pattern` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;