-- -----------------------------------------------------

-- Table `stratum`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `stratum` (

  `id` TEXT NOT NULL ,

  PRIMARY KEY (`id`) ,

  CONSTRAINT `fk_named_place_record10`

    FOREIGN KEY (`id` )

    REFERENCES `record` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `plot_stratum`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `plot_stratum` (

  `id` TEXT NOT NULL ,

  `stratum` TEXT NOT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `fk_plot_stratum_stratum1` (`stratum` ASC) ,

  CONSTRAINT `fk_subplot_location10`

    FOREIGN KEY (`id` )

    REFERENCES `location` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_plot_stratum_stratum1`

    FOREIGN KEY (`stratum` )

    REFERENCES `stratum` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;