/*
SQLyog - Free MySQL GUI v5.0
Host - 4.0.23a : Database - cisred_Cele_2_8
*********************************************************************
Server version : 4.0.23a
*/


create database if not exists `cisred_Cele_2_8`;

/*Table structure for table `batches` */

CREATE TABLE `batches` (
  `id` bigint(20) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `parameters` varchar(255) NOT NULL default '',
  `datasource` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

/*Table structure for table `ensembl_gene_names` */

CREATE TABLE `ensembl_gene_names` (
  `ensembl_id` varchar(20) default NULL,
  `xref_id` varchar(50) default NULL,
  `name` varchar(100) default NULL,
  `description` varchar(200) default NULL,
  KEY `idx_name` (`name`(20)),
  KEY `idx_xref_id` (`xref_id`(20))
) TYPE=MyISAM;

/*Table structure for table `features` */

CREATE TABLE `features` (
  `id` bigint(20) NOT NULL auto_increment,
  `batch_id` int(11) NOT NULL default '0',
  `seqname` varchar(255) NOT NULL default '',
  `source` varchar(255) NOT NULL default '',
  `feature` varchar(255) NOT NULL default '',
  `start` int(10) unsigned NOT NULL default '0',
  `end` int(10) unsigned NOT NULL default '0',
  `score` double default NULL,
  `mi_score` double default NULL,
  `strand` char(1) NOT NULL default '',
  `frame` char(1) NOT NULL default '',
  `ensembl_gene_id` varchar(100) NOT NULL default '',
  `consensus` varchar(255) default NULL,
  `reverse_consensus` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `index1` (`seqname`,`start`,`end`),
  KEY `index2` (`feature`),
  KEY `index3` (`ensembl_gene_id`)
) TYPE=InnoDB;

/*Table structure for table `group_content` */

CREATE TABLE `group_content` (
  `group_id` bigint(20) NOT NULL default '-1',
  `feature_id` bigint(20) NOT NULL default '0',
  `orientation` int(10) NOT NULL default '1',
  `valid_from` datetime NOT NULL default '0000-00-00 00:00:00',
  `valid_to` datetime default NULL,
  KEY `index1` (`group_id`),
  KEY `index2` (`feature_id`)
) TYPE=InnoDB;

/*Table structure for table `pattern` */

CREATE TABLE `pattern` (
  `id` bigint(20) NOT NULL default '0',
  `score` double NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

/*Table structure for table `pattern_content` */

CREATE TABLE `pattern_content` (
  `pattern_id` bigint(20) NOT NULL default '0',
  `group_id` bigint(20) NOT NULL default '0',
  `group_count` int(20) NOT NULL default '0',
  PRIMARY KEY  (`pattern_id`,`group_id`)
) TYPE=InnoDB;

/*Table structure for table `pattern_instance` */

CREATE TABLE `pattern_instance` (
  `id` bigint(20) NOT NULL default '0',
  `pattern_id` bigint(20) NOT NULL default '0',
  `region_id` bigint(20) NOT NULL default '0'
) TYPE=InnoDB;

/*Table structure for table `pattern_instance_content` */

CREATE TABLE `pattern_instance_content` (
  `pattern_instance_id` bigint(20) NOT NULL default '0',
  `feature_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`pattern_instance_id`,`feature_id`)
) TYPE=InnoDB;

/*Table structure for table `search_region` */

CREATE TABLE `search_region` (
  `id` bigint(20) NOT NULL auto_increment,
  `batch_id` bigint(20) NOT NULL default '0',
  `ensembl_gene_id` varchar(128) default NULL,
  `chromosome` varchar(32) NOT NULL default '',
  `start` int(10) unsigned NOT NULL default '0',
  `end` int(10) unsigned NOT NULL default '0',
  `strand` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

/*Table structure for table `sitesequences` */

CREATE TABLE `sitesequences` (
  `feature_id` bigint(20) NOT NULL default '0',
  `sequence` varchar(128) NOT NULL default '',
  `source_annotation` varchar(128) default NULL,
  `source_type` varchar(128) default NULL,
  `source_db` varchar(128) NOT NULL default '',
  `source_chromosome` varchar(32) NOT NULL default '',
  `source_start` int(10) unsigned NOT NULL default '0',
  `source_end` int(10) unsigned NOT NULL default '0',
  `source_strand` char(1) NOT NULL default '',
  `taxonomy_id` bigint(20) unsigned NOT NULL default '0',
  KEY `index1` (`feature_id`),
  KEY `index2` (`source_annotation`),
  CONSTRAINT `sitesequences_ibfk_1` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;

/*Table structure for table `snp_in_sitesequence` */

CREATE TABLE `snp_in_sitesequence` (
  `feature_id` int(10) unsigned NOT NULL default '0',
  `source_annotation` varchar(45) NOT NULL default '',
  `refseq_snp_id` varchar(45) NOT NULL default '',
  `snp_offset` int(10) unsigned NOT NULL default '0',
  `strand` char(1) NOT NULL default '',
  PRIMARY KEY  (`feature_id`,`source_annotation`,`refseq_snp_id`)
) TYPE=InnoDB;

/*Table structure for table `taxonomy` */

CREATE TABLE `taxonomy` (
  `id` int(11) unsigned NOT NULL default '0',
  `species` char(50) NOT NULL default '',
  KEY `index1` (`id`)
) TYPE=InnoDB;