[Bio] / Clearinghouse / schema.sql Repository:
ViewVC logotype

View of /Clearinghouse/schema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Thu Jun 12 16:54:16 2008 UTC (11 years, 4 months ago) by olson
Branch: MAIN
CVS Tags: HEAD
Add subsystem registry.

--
-- Table structure for table `accession`
--

DROP TABLE IF EXISTS `accession`;
CREATE TABLE `accession` (
  `id` int(11) NOT NULL auto_increment,
  `who` text,
  `accession_date` int(11) default NULL,
  `comments` text,
  `source` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `clearing_house`
--

DROP TABLE IF EXISTS `clearing_house`;
CREATE TABLE `clearing_house` (
  `id` int(11) NOT NULL auto_increment,
  `accession_id` int(11) default NULL,
  `type` text,
  `meta_data` text,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `contig`
--

DROP TABLE IF EXISTS `contig`;
CREATE TABLE `contig` (
  `id` int(11) NOT NULL auto_increment,
  `contig_name` varchar(255) default NULL,
  `checksum` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `feature`
--

DROP TABLE IF EXISTS `feature`;
CREATE TABLE `feature` (
  `id` int(11) NOT NULL auto_increment,
  `genome` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `location` text,
  `feature_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `file_table`
--

DROP TABLE IF EXISTS `file_table`;
CREATE TABLE `file_table` (
  `file` varchar(200) NOT NULL,
  `fileno` int(11) default NULL,
  PRIMARY KEY  (`file`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `genome_id`
--

DROP TABLE IF EXISTS `genome_id`;
CREATE TABLE `genome_id` (
  `id` int(11) NOT NULL auto_increment,
  `taxon` text,
  `checksum` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `locks`
--

DROP TABLE IF EXISTS `locks`;
CREATE TABLE `locks` (
  `name` text,
  `lock` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `meta_data`
--

DROP TABLE IF EXISTS `meta_data`;
CREATE TABLE `meta_data` (
  `ch_id` int(11) default NULL,
  `tag` text,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `metagenome_registry`
--

DROP TABLE IF EXISTS `metagenome_registry`;
CREATE TABLE `metagenome_registry` (
  `id` int(11) NOT NULL auto_increment,
  `tax_id` varchar(60) default NULL,
  `name` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `next_feature_id`
--

DROP TABLE IF EXISTS `next_feature_id`;
CREATE TABLE `next_feature_id` (
  `genome_id` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `next_id` int(11) default NULL,
  PRIMARY KEY  (`genome_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `next_genome_id`
--

DROP TABLE IF EXISTS `next_genome_id`;
CREATE TABLE `next_genome_id` (
  `taxon` varchar(255) default NULL,
  `next_id` int(11) default NULL,
  UNIQUE KEY `taxon` (`taxon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `subsystem_accession`;
CREATE TABLE `subsystem_accession` (
	id		INTEGER PRIMARY KEY NOT NULL,
	ss_name		TEXT,
	creation_time	TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	UNIQUE KEY ss_name(ss_name(255))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `next_metagenome_id`
--

DROP TABLE IF EXISTS `next_metagenome_id`;
CREATE TABLE `next_metagenome_id` (
  `next_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `package_location`
--

DROP TABLE IF EXISTS `package_location`;
CREATE TABLE `package_location` (
  `id` int(11) NOT NULL auto_increment,
  `ch_id` int(11) default NULL,
  `pathname` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `pin_seeks`
--

DROP TABLE IF EXISTS `pin_seeks`;
CREATE TABLE `pin_seeks` (
  `fid` varchar(32) NOT NULL,
  `cutoff` double default NULL,
  `fileno` int(11) default NULL,
  `seek` int(11) default NULL,
  `len` int(11) default NULL,
  KEY `fid` (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `types`
--

DROP TABLE IF EXISTS `types`;
CREATE TABLE `types` (
  `type` varchar(255) NOT NULL,
  PRIMARY KEY  (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3