Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 1 
<?xml version="1.0" encoding="UTF-8" ?>
2 
<XMLDB PATH="question/type/calculated/db" VERSION="20120122" COMMENT="XMLDB file for Moodle question/type/calculated. This question type also relies on the question_numerical_units table created by the numerical question type, and the dataset tables created by lib/db/install.xml."
3 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4 
    xsi:noNamespaceSchemaLocation="../../../../lib/xmldb/xmldb.xsd"
5 
>
6 
  <TABLES>
7 
    <TABLE NAME="question_calculated" COMMENT="Options for questions of type calculated">
8 
      <FIELDS>
9 
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
10 
        <FIELD NAME="question" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
11 
        <FIELD NAME="answer" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
12 
        <FIELD NAME="tolerance" TYPE="char" LENGTH="20" NOTNULL="true" DEFAULT="0.0" SEQUENCE="false"/>
13 
        <FIELD NAME="tolerancetype" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
14 
        <FIELD NAME="correctanswerlength" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="2" SEQUENCE="false"/>
15 
        <FIELD NAME="correctanswerformat" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="2" SEQUENCE="false"/>
16 
      </FIELDS>
17 
      <KEYS>
18 
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
19 
        <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id"/>
20 
      </KEYS>
21 
      <INDEXES>
22 
        <INDEX NAME="answer" UNIQUE="false" FIELDS="answer"/>
23 
      </INDEXES>
24 
    </TABLE>
25 
    <TABLE NAME="question_calculated_options" COMMENT="Options for questions of type calculated">
26 
      <FIELDS>
27 
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
28 
        <FIELD NAME="question" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
29 
        <FIELD NAME="synchronize" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
30 
        <FIELD NAME="single" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If 0 it multiple response (checkboxes). Otherwise it is radio buttons."/>
31 
        <FIELD NAME="shuffleanswers" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Whether the choices can be randomly shuffled."/>
32 
        <FIELD NAME="correctfeedback" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Feedback shown for any correct response."/>
33 
        <FIELD NAME="correctfeedbackformat" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
34 
        <FIELD NAME="partiallycorrectfeedback" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Feedback shown for any partially correct response."/>
35 
        <FIELD NAME="partiallycorrectfeedbackformat" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
36 
        <FIELD NAME="incorrectfeedback" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Feedback shown for any incorrect response."/>
37 
        <FIELD NAME="incorrectfeedbackformat" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
38 
        <FIELD NAME="answernumbering" TYPE="char" LENGTH="10" NOTNULL="true" DEFAULT="abc" SEQUENCE="false" COMMENT="Indicates how and whether the choices should be numbered."/>
39 
        <FIELD NAME="shownumcorrect" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="If true, then when the user gets a multiple-response question partially correct, tell them how many choices they got correct alongside the feedback."/>
40 
      </FIELDS>
41 
      <KEYS>
42 
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
43 
        <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id"/>
44 
      </KEYS>
45 
    </TABLE>
46 
    <TABLE NAME="question_dataset_definitions" COMMENT="Organises and stores properties for dataset items">
47 
      <FIELDS>
48 
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
49 
        <FIELD NAME="category" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
50 
        <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
51 
        <FIELD NAME="type" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
52 
        <FIELD NAME="options" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
53 
        <FIELD NAME="itemcount" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
54 
      </FIELDS>
55 
      <KEYS>
56 
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
57 
        <KEY NAME="category" TYPE="foreign" FIELDS="category" REFTABLE="question_categories" REFFIELDS="id"/>
58 
      </KEYS>
59 
    </TABLE>
60 
    <TABLE NAME="question_dataset_items" COMMENT="Individual dataset items">
61 
      <FIELDS>
62 
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
63 
        <FIELD NAME="definition" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
64 
        <FIELD NAME="itemnumber" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
65 
        <FIELD NAME="value" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
66 
      </FIELDS>
67 
      <KEYS>
68 
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
69 
      </KEYS>
70 
      <INDEXES>
71 
        <INDEX NAME="definition" UNIQUE="false" FIELDS="definition"/>
72 
      </INDEXES>
73 
    </TABLE>
74 
    <TABLE NAME="question_datasets" COMMENT="Many-many relation between questions and dataset definitions">
75 
      <FIELDS>
76 
        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
77 
        <FIELD NAME="question" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
78 
        <FIELD NAME="datasetdefinition" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
79 
      </FIELDS>
80 
      <KEYS>
81 
        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
82 
        <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id"/>
83 
        <KEY NAME="datasetdefinition" TYPE="foreign" FIELDS="datasetdefinition" REFTABLE="question_dataset_definitions" REFFIELDS="id"/>
84 
      </KEYS>
85 
      <INDEXES>
86 
        <INDEX NAME="question-datasetdefinition" UNIQUE="false" FIELDS="question, datasetdefinition"/>
87 
      </INDEXES>
88 
    </TABLE>
89 
  </TABLES>
90 
</XMLDB>