[Bio] / FortyEightMeta / tax-schema.sql Repository:
ViewVC logotype

View of /FortyEightMeta/tax-schema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.4 - (download) (annotate)
Wed Jun 11 21:16:42 2008 UTC (11 years, 9 months ago) by olson
Branch: MAIN
CVS Tags: mgrast_dev_08112011, mgrast_dev_08022011, mgrast_dev_05262011, mgrast_dev_04082011, mgrast_version_3_2, mgrast_dev_12152011, mgrast_dev_06072011, mgrast_rel_2008_0806, mgrast_dev_10262011, mgrast_dev_02212011, mgrast_rel_2008_0923, mgrast_release_3_0, mgrast_dev_03252011, mgrast_rel_2008_0924, mgrast_rel_2008_1110_v2, mgrast_rel_2008_0625, mgrast_release_3_0_4, mgrast_release_3_0_2, mgrast_release_3_0_3, mgrast_release_3_0_1, mgrast_dev_03312011, mgrast_release_3_1_2, mgrast_release_3_1_1, mgrast_release_3_1_0, mgrast_dev_04132011, mgrast_dev_04012011, mgrast_rel_2008_0919, mgrast_rel_2008_1110, myrast_33, mgrast_rel_2008_0917, mgrast_dev_04052011, mgrast_dev_02222011, HEAD
Changes since 1.3: +1 -1 lines
Commit of initial MGRAST2 code.


DROP TABLE IF EXISTS seq_db CASCADE;
CREATE TABLE seq_db (
	dbid		INTEGER,
	name 		VARCHAR(256) DEFAULT NULL,
	version		VARCHAR(100),
	tax_db_name	VARCHAR(100),
	PRIMARY KEY  (dbid)
);
create index seq_db_name on seq_db(name);

--
-- Table structure for table rdp_to_tax
--

DROP TABLE IF EXISTS rdp_to_tax;
CREATE TABLE rdp_to_tax (
  dbid integer default NULL,
  seq_num varchar(32) default NULL ,
  tax_str varchar(160) default NULL,

	FOREIGN KEY (dbid) REFERENCES seq_db(dbid)
);
create index rdp_to_tax_dbid on rdp_to_tax(dbid, seq_num);
create index rdp_to_tax_str on rdp_to_tax(tax_str);

DROP TABLE IF EXISTS ss_to_tax;
CREATE TABLE ss_to_tax (
  name varchar(255) default NULL,
  tax_str varchar(160) default NULL 
) ;
create index ss_to_tax_name on ss_to_tax(name);
create index ss_to_tax_tax_str on ss_to_tax(tax_str);

--
-- Table structure for table tax_item
--

DROP TABLE IF EXISTS tax_item;
CREATE TABLE tax_item (
  id serial,
  dbkey varchar(5) default NULL ,
  str varchar(1000) default NULL,
  PRIMARY KEY  (id)
) ;
create index tax_item_str on tax_item(str);
create index tax_item_dbkey on tax_item(dbkey);

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3