FASTA

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
PRAGMA foreign_keys = ON;
PRAGMA foreign_keys;
DROP TABLE if exists Sequence;
DROP TABLE if exists SubSequence;
CREATE TABLE Sequence (
ID INTEGER RIMARY KEY,
description TEXT,
string TEXT
);
CREATE TABLE SubSequence (
ID INTEGER RIMARY KEY,
string TEXT,
position INTEGER,
FOREIGN KEY(baseString) REFERENCES Sequence(ID)
);
$