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

-- Table `party_list`

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

CREATE  TABLE IF NOT EXISTS `party_list` (

  `list_id` TEXT NOT NULL ,

  `party` TEXT NOT NULL ,

  `sort_order` INT(11) NULL ,

  PRIMARY KEY (`list_id`, `party`) ,

  INDEX `fk_party_list_party1` (`party` ASC) ,

  INDEX `party_list_sorted` (`list_id` ASC, `sort_order` ASC) ,

  CONSTRAINT `fk_collection_source101`

    FOREIGN KEY ()

    REFERENCES `record` ()

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_party_list_party1`

    FOREIGN KEY (`party` )

    REFERENCES `party` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;