 
 
 -- -----------------------------------------------------
--- Table `parteitool`.`antrag_unterstuetzer`
--- -----------------------------------------------------
-CREATE  TABLE IF NOT EXISTS `parteitool`.`antrag_unterstuetzer` (
+-- Table `antrag_unterstuetzer`
+-- -----------------------------------------------------
+CREATE  TABLE IF NOT EXISTS `antrag_unterstuetzer` (
   `antrag_id` INT NOT NULL ,
   `unterstuetzer_id` INT NOT NULL ,
   `rolle` ENUM('initiator', 'unterstuetzt', 'mag', 'magnicht') NOT NULL ,

  INDEX `fk_aenderungsantrag_kommentar_aenderungsantrag1` (`aenderungsantrag_id` ASC) ,
  CONSTRAINT `fk_aenderungsantrag_kommentar_person1`
    FOREIGN KEY (`verfasser_id` )
    REFERENCES `parteitool`.`person` (`id` )
    ON DELETE SET NULL
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_aenderungsantrag_kommentar_aenderungsantrag1`
    FOREIGN KEY (`aenderungsantrag_id` )
    REFERENCES `parteitool`.`aenderungsantrag` (`id` )
    ON DELETE SET NULL
    ON UPDATE NO ACTION)
ENGINE = InnoDB



-- -----------------------------------------------------
-- Table `aenderungsantrag_unterstuetzer`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `aenderungsantrag_unterstuetzer` (
  `aenderungsantrag_id` INT NOT NULL ,
  `unterstuetzer_id` INT NOT NULL ,
  `rolle` ENUM('initiator', 'unterstuetzer', 'mag', 'magnicht') NOT NULL ,
