   INDEX `fk_personen_fraktionen1_idx` (`ris_fraktion` ASC),
   CONSTRAINT `fk_personen_fraktionen1`
     FOREIGN KEY (`ris_fraktion`)
-    REFERENCES `ris2`.`fraktionen` (`id`)
+    REFERENCES `fraktionen` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION,
   CONSTRAINT `fk_personen_stadtraete1`
     FOREIGN KEY (`ris_stadtraetIn`)
-    REFERENCES `ris2`.`stadtraetInnen` (`id`)
+    REFERENCES `stadtraetInnen` (`id`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB

  INDEX `fk_antraege_history_referate1_idx` (`referat_id` ASC),
  CONSTRAINT `bezirksausschuss`
    FOREIGN KEY (`ba_nr`)
    REFERENCES `ris2`.`bezirksausschuesse` (`ba_nr`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_history_vorgaenge1`
    FOREIGN KEY (`vorgang_id`)
    REFERENCES `ris2`.`vorgaenge` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_antraege_history_referate1`
    FOREIGN KEY (`referat_id`)
    REFERENCES `ris2`.`referate` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4;


-- -----------------------------------------------------
-- Table `ris2`.`antraege_vorlagen`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ris2`.`antraege_vorlagen` (
  `antrag1` INT(11) NOT NULL,
  `antrag2` INT(11) NOT NULL,
  `datum` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

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

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