diff options
| author | Navan Chauhan <navanchauhan@gmail.com> | 2020-09-22 17:24:49 +0530 |
|---|---|---|
| committer | Navan Chauhan <navanchauhan@gmail.com> | 2020-09-22 17:24:49 +0530 |
| commit | 9d7455d631e9fab286b79fc2307e9934991c10c0 (patch) | |
| tree | 6b7d9b655f6e4abb7d87ab15b8b91901f91aae44 /db | |
| parent | 854cc0b53af56776fa967dd7793525eb0e22e051 (diff) | |
added initial sql setup
Diffstat (limited to 'db')
| -rw-r--r-- | db/init.sql | 1 |
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) |