   INDEX `fk_fraktionen_bezirksausschuesse1_idx` (`ba_nr` ASC),
   CONSTRAINT `fk_fraktionen_bezirksausschuesse1`
     FOREIGN KEY (`ba_nr`)
-    REFERENCES `ris2`.`bezirksausschuesse` (`ba_nr`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION)
-ENGINE = InnoDB
-DEFAULT CHARACTER SET = utf8mb4;
-
-
--- -----------------------------------------------------
--- Table `ris2`.`stadtraetInnen`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `ris2`.`stadtraetInnen` (
+    REFERENCES `bezirksausschuesse` (`ba_nr`)
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION)
+ENGINE = InnoDB
+DEFAULT CHARACTER SET = utf8mb4;
+
+
+-- -----------------------------------------------------
+-- Table `stadtraetInnen`
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS `stadtraetInnen` (
   `id` INT(11) NOT NULL,
   `gewaehlt_am` DATE NULL DEFAULT NULL,
   `bio` MEDIUMTEXT NOT NULL,

  INDEX `fk_antraege_personen_antraege1_idx` (`antrag_id` ASC),
  CONSTRAINT `fk_antraege_personen_antraege1`
    FOREIGN KEY (`antrag_id`)
    REFERENCES `ris2`.`antraege` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_personen_ris_personen1`
    FOREIGN KEY (`person_id`)
    REFERENCES `ris2`.`personen` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `ris2`.`gremien_history`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ris2`.`gremien_history` (
  `id` INT(11) NOT NULL,
  `datum_letzte_aenderung` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ba_nr` SMALLINT(6) NULL DEFAULT NULL,

  INDEX `fk_antraege_ergebnisse_vorgaenge1_idx` (`vorgang_id` ASC),
  CONSTRAINT `fk_antraege_ergebnisse_antraege1`
    FOREIGN KEY (`antrag_id`)
    REFERENCES `antraege` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_ergebnisse_gremien1`
    FOREIGN KEY (`gremium_id`)
    REFERENCES `gremien` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_ergebnisse_termine1`
    FOREIGN KEY (`sitzungstermin_id`)
    REFERENCES `termine` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_ergebnisse_vorgaenge1`
    FOREIGN KEY (`vorgang_id`)
    REFERENCES `vorgaenge` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
