CREATE TABLE `tests`(
    `id` int(4) UNSIGNED NOT NULL auto_increment,
    `name` varchar(65) NOT NULL default '',
    `description` text NOT NULL default '',
    `quiz` text NOT NULL default '',
    `tag` varchar(65) NOT NULL default '',
    `allowed` tinyint(1) UNSIGNED NOT NULL default 0,
    PRIMARY KEY (`id`)
) CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `results`(
    `id` int(4) UNSIGNED NOT NULL auto_increment,
    `submitter` varchar(65) NOT NULL default '',
    `time` timestamp NOT NULL default current_timestamp,
    `answered` text NOT NULL default '',
    PRIMARY KEY (`id`)
) CHARACTER SET utf8 COLLATE utf8_general_ci;