+----------+ n+-----------+ 1+----------+
| Campaign |----| Test Exec |----| Test Def |
+----------+ |-----------| |----------|
| status | | title |
| comment | | desc |
| timer | +----------+
| … | |
+-----------+ |
| |
| |
|n |n
+-----------+ 1+----------+
| Step Exec |----| Step Def |
|-----------| |----------|
| status | | action |
| comment | | expected |
| exec_by | +----------+
| … |
+-----------+
CREATE TABLE IF NOT EXISTS plugin_testmanagement_step(
id INT(11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,
action TEXT,
expected TEXT
);
CREATE TABLE IF NOT EXISTS plugin_testmanagement_changeset_value_stepdef(
changeset_value_id INT(11) NOT NULL,
step_id INT(11) UNSIGNED,
PRIMARY KEY(changeset_value_id, step_id),
INDEX reverse_idx(step_id, changeset_value_id)
);