From 9d7455d631e9fab286b79fc2307e9934991c10c0 Mon Sep 17 00:00:00 2001 From: Navan Chauhan Date: Tue, 22 Sep 2020 17:24:49 +0530 Subject: added initial sql setup --- db/init.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 db/init.sql 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) -- cgit v1.2.3