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)
);
$