[Bio] / Babel / bin / Add_OLD_SEED_Table.sql Repository:
ViewVC logotype

View of /Babel/bin/Add_OLD_SEED_Table.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Thu Jul 15 20:29:53 2010 UTC (9 years, 10 months ago) by wilke
Branch: MAIN
CVS Tags: mgrast_dev_08112011, mgrast_dev_08022011, mgrast_dev_03052011, mgrast_dev_05262011, mgrast_dev_04082011, mgrast_dev_12152011, mgrast_dev_06072011, mgrast_dev_10262011, mgrast_dev_02212011, mgrast_release_3_0, mgrast_dev_03252011, 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_dev_04052011, mgrast_dev_02222011
*** empty log message ***

CREATE TABLE ACH_OLD_SEED ( _id int NOT NULL AUTO_INCREMENT,                                                   
_mtime timestamp(14) NOT NULL, 
_ctime timestamp(14) NOT NULL,
md5 varchar(32) NOT NULL,
ID varchar(32), 
xxx varchar(16),
function varchar(500), 
source integer,
organism integer,
organism_group integer,
KEY (md5),
PRIMARY KEY (_id) 
);
CREATE INDEX OLD_SEED_id ON ACH_OLD_SEED (id);                                                                     
CREATE INDEX OLD_SEED_organismGroup ON ACH_OLD_SEED (organism_group);
CREATE INDEX OLD_SEED_md5 ON ACH_OLD_SEED (md5);



MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3