-- Table structure for table `party_list`

--

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `party_list` (

  `id` varbinary(767) NOT NULL,

  `count` int(11) NOT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_collection_source100` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `party_list`

--

/*!40000 ALTER TABLE `party_list` DISABLE KEYS */;

/*!40000 ALTER TABLE `party_list` ENABLE KEYS */;

--

-- Table structure for table `party_list_entry`

--

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `party_list_entry` (

  `id` varbinary(767) NOT NULL,

  `entry` varbinary(767) NOT NULL,

  `sort_order` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`,`entry`),

  KEY `fk_party_list_has_party_party1_idx` (`entry`),

  KEY `fk_party_list_has_party_party_list1_idx` (`id`),

  CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `party_list_entry`

--

/*!40000 ALTER TABLE `party_list_entry` DISABLE KEYS */;

/*!40000 ALTER TABLE `party_list_entry` ENABLE KEYS */;

--