CREATE TABLE `character` ( `id` text PRIMARY KEY NOT NULL, `name` text NOT NULL, `owner` integer NOT NULL, `options` text NOT NULL, FOREIGN KEY (`owner`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE cascade );