CREATE TABLE phpbb_quiz ( `quiz_id` int(10) NOT NULL default '0', `quiz_name` varchar(200) NOT NULL default '', `quiz_author` int(10) NOT NULL default '0', `quiz_enabled` int(1) NOT NULL default '0', `quiz_category` int(5) NOT NULL default '0', `quiz_type` varchar(20) NOT NULL default '0', `quiz_plays` int(5) NOT NULL default '0');
CREATE TABLE phpbb_quiz_categories ( `category_id` int(5) NOT NULL default '0', `category_password` VARCHAR( 100 ) NOT NULL default '', `category_name` varchar(140) NOT NULL default '', `category_permissions` int(1) NOT NULL default '0', `category_description` varchar(255) NOT NULL default '');
CREATE TABLE phpbb_quiz_statistics ( `stats_id` int(5) NOT NULL default '', `quiz_id` int(10) NOT NULL default '', `user_id` int(10) NOT NULL default '', `stats_correct` INT(5) NOT NULL default '0', `stats_incorrect` INT(5) NOT NULL default '0', `stats_percentage` INT(3) NOT NULL default '0');
CREATE TABLE phpbb_quiz_multiple_choice_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_alternates` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_true_false_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_input_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL)
ALTER TABLE phpbb_sessions ADD `session_quiz_categories` VARCHAR( 255 ) NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_show_answers', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Register_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Count_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Requirement', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Play_Once', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Min_Max_Questions', '5,10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Mod', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Banned', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Moderators', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Stats_Display', '10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Mod_Submit', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Currency', 'user_points')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Incorrect', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Correct', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Tax', '2')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_CashMOD_On', '1')