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

Annotation of /Babel/bin/Add_OLD_SEED_Table.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (view) (download)

1 : wilke 1.1
2 :     CREATE TABLE ACH_OLD_SEED ( _id int NOT NULL AUTO_INCREMENT,
3 :     _mtime timestamp(14) NOT NULL,
4 :     _ctime timestamp(14) NOT NULL,
5 :     md5 varchar(32) NOT NULL,
6 :     ID varchar(32),
7 :     xxx varchar(16),
8 :     function varchar(500),
9 :     source integer,
10 :     organism integer,
11 :     organism_group integer,
12 :     KEY (md5),
13 :     PRIMARY KEY (_id)
14 :     );
15 :     CREATE INDEX OLD_SEED_id ON ACH_OLD_SEED (id);
16 :     CREATE INDEX OLD_SEED_organismGroup ON ACH_OLD_SEED (organism_group);
17 :     CREATE INDEX OLD_SEED_md5 ON ACH_OLD_SEED (md5);
18 :    
19 :    

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3