Difference between revisions of "RQP question type"

Jump to: navigation, search
 
(Database tables)
Line 2: Line 2:
  
 
==Database tables==
 
==Database tables==
 +
 +
===quiz_rqp===
 +
 +
;id :int(10) unsigned NOT NULL auto_increment,
 +
;question :int(10) unsigned NOT NULL default '0',
 +
;type :int(10) unsigned NOT NULL default '0',
 +
;source :longblob NOT NULL default '',
 +
;format :varchar(255) NOT NULL default '',
 +
;flags :tinyint(3) unsigned NOT NULL default '0',
 +
;maxscore :int(10) unsigned NOT NULL default '1',
 +
 +
===quiz_rqp_servers===
 +
 +
;id :int(10) unsigned NOT NULL auto_increment,
 +
;typeid :int(10) unsigned NOT NULL default '0',
 +
;url :varchar(255) NOT NULL default '',
 +
;can_render :tinyint(2) unsigned NOT NULL default '0',
 +
;can_author :tinyint(2) unsigned NOT NULL default '0',
 +
 +
===quiz_rqp_states===
 +
 +
;id :int(10) unsigned NOT NULL auto_increment,
 +
;stateid :int(10) unsigned NOT NULL default '0',
 +
;responses :text NOT NULL default '',
 +
;persistent_data :text NOT NULL default '',
 +
;template_vars :text NOT NULL default '',
 +
 +
===quiz_rqp_types===
 +
 +
;id int(10) :unsigned NOT NULL auto_increment,
 +
;name :varchar(255) NOT NULL default '',
  
 
==Response storage==
 
==Response storage==

Revision as of 00:18, 7 February 2006

Database tables

quiz_rqp

id 
int(10) unsigned NOT NULL auto_increment,
question 
int(10) unsigned NOT NULL default '0',
type 
int(10) unsigned NOT NULL default '0',
source 
longblob NOT NULL default ,
format 
varchar(255) NOT NULL default ,
flags 
tinyint(3) unsigned NOT NULL default '0',
maxscore 
int(10) unsigned NOT NULL default '1',

quiz_rqp_servers

id 
int(10) unsigned NOT NULL auto_increment,
typeid 
int(10) unsigned NOT NULL default '0',
url 
varchar(255) NOT NULL default ,
can_render 
tinyint(2) unsigned NOT NULL default '0',
can_author 
tinyint(2) unsigned NOT NULL default '0',

quiz_rqp_states

id 
int(10) unsigned NOT NULL auto_increment,
stateid 
int(10) unsigned NOT NULL default '0',
responses 
text NOT NULL default ,
persistent_data 
text NOT NULL default ,
template_vars 
text NOT NULL default ,

quiz_rqp_types

id int(10) 
unsigned NOT NULL auto_increment,
name 
varchar(255) NOT NULL default ,

Response storage

Question->options

State->options