aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorNavan Chauhan <navanchauhan@gmail.com>2020-09-22 17:24:49 +0530
committerNavan Chauhan <navanchauhan@gmail.com>2020-09-22 17:24:49 +0530
commit9d7455d631e9fab286b79fc2307e9934991c10c0 (patch)
tree6b7d9b655f6e4abb7d87ab15b8b91901f91aae44 /db
parent854cc0b53af56776fa967dd7793525eb0e22e051 (diff)
added initial sql setup
Diffstat (limited to 'db')
-rw-r--r--db/init.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/init.sql b/db/init.sql
new file mode 100644
index 0000000..743ed71
--- /dev/null
+++ b/db/init.sql
@@ -0,0 +1 @@
+create table curieweb ( id varchar(16) primary key, email nvarchar(255) NOT NULL, protein LONGBLOB NOT NULL, protein_name VARCHAR(255), ligand_pdbqt LONGBLOB, ligand_smile VARCHAR(255), ligand_name VARCHAR(255), config LONGBLOB NOT NULL, date DATE, description VARCHAR(255), done TINYINT DEFAULT 0, pdb VARCHAR(4),csv longblob)