1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
CREATE TABLE jos_quiz_t_question (
c_id int(10) unsigned NOT NULL auto_increment,
c_quiz_id int(10) unsigned NOT NULL default '0',
c_point tinyint(3) unsigned NOT NULL default '0',
c_attempts tinyint(3) unsigned NOT NULL default '1',
c_question text NOT NULL,
c_image varchar(255) NOT NULL default '',
c_type tinyint(4) NOT NULL default '0',
ordering int(11) default '0',
c_right_message text,
c_wrong_message text,
c_feedback int(11) NOT NULL default '0',
cq_id int(11) NOT NULL default '0',
c_ques_cat int(11) NOT NULL default '0',
c_random char(1) NOT NULL default '0',
PRIMARY KEY (c_id),
KEY c_quiz_id (c_quiz_id)
) ENGINE=MyISAM AUTO_INCREMENT=777 DEFAULT CHARSET=utf8;
INSERT INTO jos_quiz_t_question VALUES (133, 0, 2, 0, '<div class="question"><span class="chiffre">1.10.3</span>A quelle distance d\'un véhicule immobile ou d\'un obstacle, faut il placer un sabot?</div>', '', 1, 0, '', '', 0, 0, 44, '1'); |
Partager