-- 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" text NOT NULL,

  "count" integer NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_collection_source100" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*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" text NOT NULL,

  "entry" text NOT NULL,

  "sort_order" integer DEFAULT NULL,

  PRIMARY KEY ("id","entry"),

  /*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),

  /*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),

  /*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*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 */;

--