frontend/migrations/123_add_static_labels_tables.py

UP_SQL = """
CREATE TABLE afe_static_labels (
  id int(11) NOT NULL auto_increment,
  name varchar(750) default NULL,
  kernel_config varchar(255) default NULL,
  platform tinyint(1) default '0',
  invalid tinyint(1) NOT NULL,
  only_if_needed tinyint(1) NOT NULL,
  atomic_group_id int(11) default NULL,
  PRIMARY KEY (id),
  UNIQUE KEY name (name(50)),
  KEY atomic_group_id (atomic_group_id),
  CONSTRAINT afe_static_labels_idfk_1
  FOREIGN KEY (atomic_group_id)
    REFERENCES afe_atomic_groups (id) ON DELETE NO ACTION
) ENGINE=InnoDB;

CREATE TABLE afe_static_hosts_labels (
  id int(11) NOT NULL auto_increment,
  host_id int(11) default NULL,
  staticlabel_id int(11) default NULL,
  PRIMARY KEY (id),
  UNIQUE KEY hosts_labels_both_ids (staticlabel_id,host_id),
  KEY hosts_labels_host_id (host_id),
  CONSTRAINT static_hosts_labels_host_id_fk
  FOREIGN KEY (host_id)
    REFERENCES afe_hosts (id) ON DELETE NO ACTION,
  CONSTRAINT static_hosts_labels_label_id_fk
  FOREIGN KEY (staticlabel_id)
    REFERENCES afe_static_labels (id) ON DELETE NO ACTION
) ENGINE=InnoDB;
"""

DOWN_SQL = """
DROP TABLE IF EXISTS afe_static_labels;
DROP TABLE IF EXISTS afe_static_hosts_labels;
"""