frontend/migrations/060_add_planner_additional_parameters.py

UP_SQL = """
CREATE TABLE planner_additional_parameters (
  id INT PRIMARY KEY AUTO_INCREMENT,
  plan_id INT NOT NULL,
  hostname_regex VARCHAR(255) NOT NULL,
  param_type VARCHAR(32) NOT NULL,
  application_order INT NOT NULL
) ENGINE = InnoDB;

ALTER TABLE planner_additional_parameters
ADD CONSTRAINT planner_additional_parameters_plan_ibfk
FOREIGN KEY (plan_id) REFERENCES planner_plans (id);

ALTER TABLE planner_additional_parameters
ADD CONSTRAINT planner_additional_parameters_unique
UNIQUE KEY (plan_id, hostname_regex, param_type);


CREATE TABLE planner_additional_parameter_values (
  id INT PRIMARY KEY AUTO_INCREMENT,
  additional_parameter_id INT NOT NULL,
  `key` VARCHAR(255) NOT NULL,
  value VARCHAR(255) NOT NULL
) ENGINE = InnoDB;

ALTER TABLE planner_additional_parameter_values
ADD CONSTRAINT planner_additional_parameter_values_additional_parameter_ibfk
FOREIGN KEY (additional_parameter_id)
  REFERENCES planner_additional_parameters (id);

ALTER TABLE planner_additional_parameter_values
ADD CONSTRAINT planner_additional_parameter_values_unique
UNIQUE KEY (additional_parameter_id, `key`);
"""

DOWN_SQL = """
ALTER TABLE planner_additional_parameter_values
DROP FOREIGN KEY planner_additional_parameter_values_additional_parameter_ibfk;

DROP TABLE planner_additional_parameter_values;


ALTER TABLE planner_additional_parameters
DROP FOREIGN KEY planner_additional_parameters_plan_ibfk;

DROP TABLE planner_additional_parameters;
"""