From 8fbe70fe00bd0c46f19e16a7a1544aa693968f14 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Zden=C4=9Bk=20Salvet?= Date: Fri, 3 Jun 2005 08:20:15 +0000 Subject: [PATCH] DB schema for new FTP backend. --- .../config/glite-jp-primary-dbsetup.sql | 46 ++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 org.glite.jp.primary/config/glite-jp-primary-dbsetup.sql diff --git a/org.glite.jp.primary/config/glite-jp-primary-dbsetup.sql b/org.glite.jp.primary/config/glite-jp-primary-dbsetup.sql new file mode 100644 index 0000000..8aa788e --- /dev/null +++ b/org.glite.jp.primary/config/glite-jp-primary-dbsetup.sql @@ -0,0 +1,46 @@ +create table jobs ( + jobid char(32) binary not null, + dg_jobid varchar(255) binary not null, + owner char(32) binary not null, + + reg_time datetime not null; + + primary key (jobid), + unique (dg_jobid), + index (owner), + index (owner,reg_time) +); + +create table files ( + jobid char(32) binary not null, + filename varchar(255) binary not null, + int_path mediumblob null, + ext_url mediumblob null, + + state char(32) binary not null, + deadline datetime null; + ul_userid char(32) binary not null, + + primary key (jobid,filename), + index (ext_url) +); + +create table attrs ( + jobid char(32) binary not null, + name varchar(255) binary not null, + value mediumblob null, + + primary key (jobid,name) +); + +create table users ( + userid char(32) binary not null, + cert_subj varchar(255) binary not null, + + primary key (userid), + unique (cert_subj) +); + +create table backend_info ( + version char(32) binary not null +); -- 1.8.2.3