Is that any reason why we couldn't use "varchar" in the sql data base instead of the currently designated "text"?
Code: Select all
$sql[] = "CREATE TABLE " . QUIZ_MULTIPLE_CHOICE_TABLE . " (
`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);";
$sql[] = "CREATE TABLE " . QUIZ_TRUE_FALSE_TABLE . " (
`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);";
$sql[] = "CREATE TABLE " . QUIZ_INPUT_TABLE . " (
`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)";