Mac binaries

[jabaws.git] / website / archive / binaries / mac / src / fasta34 / create_seq_demo.sql

diff --git a/website/archive/binaries/mac/src/fasta34/create_seq_demo.sql b/website/archive/binaries/mac/src/fasta34/create_seq_demo.sql
new file mode 100644 (file)
index 0000000..35188a0
--- /dev/null
+++ b/website/archive/binaries/mac/src/fasta34/create_seq_demo.sql
@@ -0,0 +1,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)
+);