/*
Navicat MySQL Data Transfer

Source Server         : antec
Source Server Version : 50038
Source Host           : antec:3306
Source Database       : flowdx

Target Server Type    : MYSQL
Target Server Version : 50038
File Encoding         : 65001

Date: 2009-10-01 13:57:23
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `agents`
-- ----------------------------
DROP TABLE IF EXISTS `agents`;
CREATE TABLE `agents` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `role` text character set utf8 NOT NULL,
  `notes` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of agents
-- ----------------------------

-- ----------------------------
-- Table structure for `analyses`
-- ----------------------------
DROP TABLE IF EXISTS `analyses`;
CREATE TABLE `analyses` (
  `id` int(11) NOT NULL auto_increment,
  `wsfile` int(11),
  `fcsfiles` text,
  `gatefiles` text,
  `expid` int(11) NOT NULL,
  `date` datetime,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of analyses
-- ----------------------------

-- ----------------------------
-- Table structure for `assays`
-- ----------------------------
DROP TABLE IF EXISTS `assays`;
CREATE TABLE `assays` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of assays
-- ----------------------------

-- ----------------------------
-- Table structure for `wspfiles`
-- ----------------------------
DROP TABLE IF EXISTS `wspfiles`;
CREATE TABLE `wspfiles` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `assayid` int(11),
  `agentid` int(11),
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of wspfiles
-- ----------------------------


-- ----------------------------
-- Table structure for `popmaskfiles`
-- ----------------------------
DROP TABLE IF EXISTS `popmaskfiles`;
CREATE TABLE `popmaskfiles` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `analysisid` int(11),
  `populationid` int(11),
  `samplename` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of popmaskfiles
-- ----------------------------

-- ----------------------------
-- Table structure for `populations`
-- ----------------------------
DROP TABLE IF EXISTS `populations`;
CREATE TABLE `populations` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `groupname` varchar(255),
  `assayid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of populations
-- ----------------------------

-- ----------------------------
-- Table structure for `fdfiles`
-- ----------------------------
DROP TABLE IF EXISTS `fdfiles`;
CREATE TABLE `fdfiles` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `ftype` varchar(255) default NULL,
  `acqdate` date default NULL,
  `timepoint` varchar(255) default NULL,
  `patientid` varchar(255) default NULL,
  `role` varchar(255) default NULL,
  `assay` varchar(255) default NULL,
  `location` varchar(255) default NULL,
  `agentid` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;