 
 
 -- -----------------------------------------------------
--- Table `parteitool`.`aenderungsantrag_unterstuetzer`
--- -----------------------------------------------------
-CREATE  TABLE IF NOT EXISTS `parteitool`.`aenderungsantrag_unterstuetzer` (
+-- 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 ,

  INDEX `fk_antrag` (`antrag_id` ASC) ,
  CONSTRAINT `fk_antrag`
    FOREIGN KEY (`antrag_id` )
    REFERENCES `parteitool`.`antrag` (`id` )
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_unterstuetzer`
    FOREIGN KEY (`unterstuetzer_id` )
    REFERENCES `parteitool`.`person` (`id` )
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `parteitool`.`aenderungsantrag`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `parteitool`.`aenderungsantrag` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `antrag_id` INT NULL ,
  `revision_name` VARCHAR(45) NULL ,

  PRIMARY KEY (`id`) ,
  CONSTRAINT `fk_texte_veranstaltung1`
    FOREIGN KEY (`veranstaltung_id` )
    REFERENCES `veranstaltung` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_texte_person1`
    FOREIGN KEY (`edit_person` )
    REFERENCES `person` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `cache`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `cache` (
  `id` CHAR(32) NOT NULL ,
  `datum` TIMESTAMP NULL ,
  `daten` LONGBLOB NULL ,
