Changeset 854 for branches/prototype-v0/zoo-project/zoo-kernel/sql
- Timestamp:
- Nov 21, 2017, 10:24:14 AM (6 years ago)
- Location:
- branches/prototype-v0/zoo-project/zoo-kernel/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/prototype-v0/zoo-project/zoo-kernel/sql/schema.sql
r839 r854 31 31 -- Create a dedicated schema to store all tables 32 32 -- Uncomment the following 2 lines to activate the schema use 33 -- CREATE SCHEMA zoo;34 -- SET search_path TO zoo;33 -- CREATE SCHEMA process; 34 -- SET search_path TO process; 35 35 -------------------------------------------------------------------------------- 36 36 -- Services table … … 45 45 creation_time timestamp with time zone default now(), 46 46 end_time timestamp with time zone default NULL, 47 -- queue_duration ,48 -- run_duration ,49 47 progress int, 50 message TEXT, 51 -- data_lifetime timestamp with time zone default now() + interval '48 hours', 52 rps_step int4 default 0 48 message TEXT 53 49 ); 54 50 -------------------------------------------------------------------------------- … … 56 52 -- Used to store the response provided by a services running asynchronously 57 53 create table responses ( 58 uuid text references process(uuid) ON DELETE CASCADE,54 uuid text references services(uuid) ON DELETE CASCADE, 59 55 content text, 60 56 creation_time timestamp with time zone default now() -
branches/prototype-v0/zoo-project/zoo-kernel/sql/zoo_collectiondb.sql
r839 r854 314 314 abstract, 315 315 (SELECT service_type FROM CollectionDB.zoo_ServiceTypes WHERE id = (SELECT service_type_id FROM CollectionDB.zoo_DeploymentMetadata WHERE id = (SELECT deployment_metadata_id FROM CollectionDB.PrivateMetadataDeploymentmetadataAssignment WHERE private_metadata_id=(SELECT id FROM CollectionDB.zoo_PrivateMetadata WHERE id = CollectionDB.ows_Process.private_metadata_id)))) as service_type, 316 (SELECT executable_name as service_provider FROM CollectionDB.zoo_DeploymentMetadata WHERE id = (SELECT deployment_metadata_id FROM CollectionDB.PrivateMetadataDeploymentmetadataAssignment WHERE private_metadata_id=(SELECT id FROM CollectionDB.zoo_PrivateMetadata WHERE id = CollectionDB.ows_Process.private_metadata_id))) 316 (SELECT executable_name as service_provider FROM CollectionDB.zoo_DeploymentMetadata WHERE id = (SELECT deployment_metadata_id FROM CollectionDB.PrivateMetadataDeploymentmetadataAssignment WHERE private_metadata_id=(SELECT id FROM CollectionDB.zoo_PrivateMetadata WHERE id = CollectionDB.ows_Process.private_metadata_id))) as service_provider, 317 317 availability 318 318 FROM CollectionDB.ows_Process
Note: See TracChangeset
for help on using the changeset viewer.