18 lines
654 B
SQL
18 lines
654 B
SQL
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;
|