azkaban-aplcache

mysql table for dependency instance (#1612) added sql script

1/23/2018 10:01:23 PM

Details

diff --git a/azkaban-db/src/main/sql/create.execution_dependencies.sql b/azkaban-db/src/main/sql/create.execution_dependencies.sql
new file mode 100644
index 0000000..7d97e37
--- /dev/null
+++ b/azkaban-db/src/main/sql/create.execution_dependencies.sql
@@ -0,0 +1,16 @@
+CREATE TABLE execution_dependencies(
+  trigger_instance_id varchar(64),
+  dep_name varchar(128),
+  starttime datetime not null,
+  endtime datetime,
+  dep_status tinyint not null,
+  cancelleation_cause tinyint not null,
+
+  project_id INT not null,
+  project_version INT not null,
+  flow_id varchar(128) not null,
+  flow_version INT not null,
+  project_json MEDIUMTEXT not null,
+  flow_exec_id INT not null,
+  primary key(trigger_instance_id, dep_name)
+);
\ No newline at end of file