Changeset 854 for branches/prototype-v0/zoo-project/zoo-kernel/sql/schema.sql

Timestamp:

Nov 21, 2017, 10:24:14 AM (6 years ago)

Author:

djay

Message:

HPC support update. Add inputs for create options in Gdal_Dem.

File:

• branches/prototype-v0/zoo-project/zoo-kernel/sql/schema.sql (modified) (3 diffs)

branches/prototype-v0/zoo-project/zoo-kernel/sql/schema.sql

@@ -31 +31 @@
 -- Create a dedicated schema to store all tables
 -- Uncomment the following 2 lines to activate the schema use
--- CREATE SCHEMA zoo;
--- SET search_path TO zoo;
+-- CREATE SCHEMA process;
+-- SET search_path TO process;
 --------------------------------------------------------------------------------
 -- Services table
@@ -45 +45 @@
        creation_time timestamp with time zone default now(),
        end_time timestamp with time zone default NULL,
-       -- queue_duration ,
-       -- run_duration ,
        progress int,
-       message TEXT,
-       -- data_lifetime timestamp with time zone default now() + interval '48 hours',
-       rps_step int4 default 0
+       message TEXT
 );
 --------------------------------------------------------------------------------
@@ -56 +52 @@
 -- Used to store the response provided by a services running asynchronously
 create table responses (
-       uuid text references process(uuid) ON DELETE CASCADE,
+       uuid text references services(uuid) ON DELETE CASCADE,
        content text,
        creation_time timestamp with time zone default now()