   INDEX `fk_termine_history_bezirksausschuesse1_idx` (`ba_nr` ASC),
   CONSTRAINT `fk_termine_history_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`.`antraege_stadtraetInnen`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `ris2`.`antraege_stadtraetInnen` (
+    REFERENCES `bezirksausschuesse` (`ba_nr`)
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION)
+ENGINE = InnoDB
+DEFAULT CHARACTER SET = utf8mb4;
+
+
+-- -----------------------------------------------------
+-- Table `antraege_stadtraetInnen`
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS `antraege_stadtraetInnen` (
   `antrag_id` INT(11) NOT NULL,
   `stadtraetIn_id` INT(11) NOT NULL,
   `gefunden_am` TIMESTAMP NULL DEFAULT NULL,

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema ris2
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema ris2
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `ris2` DEFAULT CHARACTER SET utf8 ;
USE `ris2` ;

-- -----------------------------------------------------
-- Table `ris2`.`bezirksausschuesse`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ris2`.`bezirksausschuesse` (
  `ba_nr` SMALLINT(6) NOT NULL,
  `ris_id` INT(11) NOT NULL,
  `name` VARCHAR(100) NULL DEFAULT NULL,

  INDEX `fk_antraege_referate1_idx` (`referat_id` ASC),
  CONSTRAINT `fk_antraege_bezirksausschuesse1`
    FOREIGN KEY (`ba_nr`)
    REFERENCES `bezirksausschuesse` (`ba_nr`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_vorgaenge1`
    FOREIGN KEY (`vorgang_id`)
    REFERENCES `vorgaenge` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_referate1`
    FOREIGN KEY (`referat_id`)
    REFERENCES `referate` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4;


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