--
-- File generated with SQLiteStudio v3.4.17 on Fri Jul 11 10:33:53 2025
--
-- Text encoding used: UTF-8
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: package
CREATE TABLE IF NOT EXISTS package (id INT NOT NULL, Name VARCHAR (50) NOT NULL, URL VARCHAR (255), program REFERENCES program (NAME), PRIMARY KEY (id));
INSERT INTO package (id, Name, URL, program) VALUES (2, 'fsap', 'http://home.cc.umanitoba.ca/~psgendb', 'bachrest');
INSERT INTO package (id, Name, URL, program) VALUES (1, 'fasta', 'http://www.fasta.org', 'ssearch');

-- Table: program
CREATE TABLE IF NOT EXISTS program (package REFERENCES package (id), NAME TEXT (100) NOT NULL ON CONFLICT ABORT UNIQUE ON CONFLICT ABORT);
INSERT INTO program (package, NAME) VALUES (1, 'ssearch');
INSERT INTO program (package, NAME) VALUES (1, 'fasta');
INSERT INTO program (package, NAME) VALUES (2, 'numseq');
INSERT INTO program (package, NAME) VALUES (2, 'bachrest');

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;
