CREATE TABLE `character_choices` (
	`character` integer NOT NULL,
	`id` text NOT NULL,
	`choice` integer NOT NULL,
	PRIMARY KEY(`character`, `id`, `choice`),
	FOREIGN KEY (`character`) REFERENCES `character`(`id`) ON UPDATE cascade ON DELETE cascade
);