1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
DROP DATABASE seq_demo;
CREATE DATABASE seq_demo;
USE seq_demo;
CREATE TABLE prot (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
seq TEXT NOT NULL,
bin BLOB NOT NULL,
len INT UNSIGNED NOT NULL
);
CREATE TABLE annot (
prot_id INT UNSIGNED NOT NULL,
gi INT UNSIGNED NOT NULL PRIMARY KEY,
db ENUM("gb","emb","dbj","prf","ref","pdb","pir","sp") NOT NULL,
descr TEXT NOT NULL,
INDEX (prot_id),
INDEX (db)
);
CREATE TABLE sp (
gi INT UNSIGNED NOT NULL,
acc VARCHAR(10),
name VARCHAR(10),
PRIMARY KEY (gi)
);
|
