| 1 |
efrain |
1 |
<?xml version="1.0" encoding="UTF-8" ?>
|
|
|
2 |
<XMLDB PATH="mod/scorm/db" VERSION="20230406" COMMENT="XMLDB file for Moodle mod/scorm"
|
|
|
3 |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
|
4 |
xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
|
|
|
5 |
>
|
|
|
6 |
<TABLES>
|
|
|
7 |
<TABLE NAME="scorm" COMMENT="each table is one SCORM module and its configuration">
|
|
|
8 |
<FIELDS>
|
|
|
9 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
10 |
<FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
11 |
<FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
12 |
<FIELD NAME="scormtype" TYPE="char" LENGTH="50" NOTNULL="true" DEFAULT="local" SEQUENCE="false" COMMENT="local, external or repository"/>
|
|
|
13 |
<FIELD NAME="reference" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
14 |
<FIELD NAME="intro" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
15 |
<FIELD NAME="introformat" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
16 |
<FIELD NAME="version" TYPE="char" LENGTH="9" NOTNULL="true" SEQUENCE="false"/>
|
|
|
17 |
<FIELD NAME="maxgrade" TYPE="float" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
18 |
<FIELD NAME="grademethod" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
19 |
<FIELD NAME="whatgrade" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
20 |
<FIELD NAME="maxattempt" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
21 |
<FIELD NAME="forcecompleted" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
22 |
<FIELD NAME="forcenewattempt" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
23 |
<FIELD NAME="lastattemptlock" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
24 |
<FIELD NAME="masteryoverride" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
25 |
<FIELD NAME="displayattemptstatus" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
26 |
<FIELD NAME="displaycoursestructure" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
27 |
<FIELD NAME="updatefreq" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Define when the package must be automatically update"/>
|
|
|
28 |
<FIELD NAME="sha1hash" TYPE="char" LENGTH="40" NOTNULL="false" SEQUENCE="false" COMMENT="package content or ext path hash"/>
|
|
|
29 |
<FIELD NAME="md5hash" TYPE="char" LENGTH="32" NOTNULL="true" SEQUENCE="false" COMMENT="MD5 Hash of package file"/>
|
|
|
30 |
<FIELD NAME="revision" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="revison number"/>
|
|
|
31 |
<FIELD NAME="launch" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
32 |
<FIELD NAME="skipview" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
33 |
<FIELD NAME="hidebrowse" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
34 |
<FIELD NAME="hidetoc" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
35 |
<FIELD NAME="nav" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
36 |
<FIELD NAME="navpositionleft" TYPE="int" LENGTH="10" NOTNULL="false" DEFAULT="-100" SEQUENCE="false"/>
|
|
|
37 |
<FIELD NAME="navpositiontop" TYPE="int" LENGTH="10" NOTNULL="false" DEFAULT="-100" SEQUENCE="false"/>
|
|
|
38 |
<FIELD NAME="auto" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
39 |
<FIELD NAME="popup" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
40 |
<FIELD NAME="options" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
41 |
<FIELD NAME="width" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="100" SEQUENCE="false"/>
|
|
|
42 |
<FIELD NAME="height" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="600" SEQUENCE="false"/>
|
|
|
43 |
<FIELD NAME="timeopen" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
44 |
<FIELD NAME="timeclose" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
45 |
<FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
46 |
<FIELD NAME="completionstatusrequired" TYPE="int" LENGTH="1" NOTNULL="false" SEQUENCE="false"/>
|
|
|
47 |
<FIELD NAME="completionscorerequired" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false"/>
|
|
|
48 |
<FIELD NAME="completionstatusallscos" TYPE="int" LENGTH="1" NOTNULL="false" SEQUENCE="false"/>
|
|
|
49 |
<FIELD NAME="autocommit" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
50 |
</FIELDS>
|
|
|
51 |
<KEYS>
|
|
|
52 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
53 |
</KEYS>
|
|
|
54 |
<INDEXES>
|
|
|
55 |
<INDEX NAME="course" UNIQUE="false" FIELDS="course"/>
|
|
|
56 |
</INDEXES>
|
|
|
57 |
</TABLE>
|
|
|
58 |
<TABLE NAME="scorm_scoes" COMMENT="each SCO part of the SCORM module">
|
|
|
59 |
<FIELDS>
|
|
|
60 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
61 |
<FIELD NAME="scorm" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
62 |
<FIELD NAME="manifest" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
63 |
<FIELD NAME="organization" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
64 |
<FIELD NAME="parent" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
65 |
<FIELD NAME="identifier" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
66 |
<FIELD NAME="launch" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
67 |
<FIELD NAME="scormtype" TYPE="char" LENGTH="5" NOTNULL="true" SEQUENCE="false"/>
|
|
|
68 |
<FIELD NAME="title" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
69 |
<FIELD NAME="sortorder" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="order of scoes"/>
|
|
|
70 |
</FIELDS>
|
|
|
71 |
<KEYS>
|
|
|
72 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
73 |
<KEY NAME="scorm" TYPE="foreign" FIELDS="scorm" REFTABLE="scorm" REFFIELDS="id"/>
|
|
|
74 |
</KEYS>
|
|
|
75 |
</TABLE>
|
|
|
76 |
<TABLE NAME="scorm_scoes_data" COMMENT="Contains variable data get from packages">
|
|
|
77 |
<FIELDS>
|
|
|
78 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
79 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
80 |
<FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
81 |
<FIELD NAME="value" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
82 |
</FIELDS>
|
|
|
83 |
<KEYS>
|
|
|
84 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
85 |
<KEY NAME="scorm_scoes_data_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
86 |
</KEYS>
|
|
|
87 |
</TABLE>
|
|
|
88 |
<TABLE NAME="scorm_seq_objective" COMMENT="SCORM2004 objective description">
|
|
|
89 |
<FIELDS>
|
|
|
90 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
91 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
92 |
<FIELD NAME="primaryobj" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
93 |
<FIELD NAME="objectiveid" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
94 |
<FIELD NAME="satisfiedbymeasure" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
95 |
<FIELD NAME="minnormalizedmeasure" TYPE="float" LENGTH="11" NOTNULL="true" DEFAULT="0.0000" SEQUENCE="false" DECIMALS="4"/>
|
|
|
96 |
</FIELDS>
|
|
|
97 |
<KEYS>
|
|
|
98 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
99 |
<KEY NAME="scorm_objective_uniq" TYPE="unique" FIELDS="scoid, id"/>
|
|
|
100 |
<KEY NAME="scorm_objective_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
101 |
</KEYS>
|
|
|
102 |
</TABLE>
|
|
|
103 |
<TABLE NAME="scorm_seq_mapinfo" COMMENT="SCORM2004 objective mapinfo description">
|
|
|
104 |
<FIELDS>
|
|
|
105 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
106 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
107 |
<FIELD NAME="objectiveid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
108 |
<FIELD NAME="targetobjectiveid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
109 |
<FIELD NAME="readsatisfiedstatus" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
110 |
<FIELD NAME="readnormalizedmeasure" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="1" SEQUENCE="false"/>
|
|
|
111 |
<FIELD NAME="writesatisfiedstatus" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
112 |
<FIELD NAME="writenormalizedmeasure" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
113 |
</FIELDS>
|
|
|
114 |
<KEYS>
|
|
|
115 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
116 |
<KEY NAME="scorm_mapinfo_uniq" TYPE="unique" FIELDS="scoid, id, objectiveid"/>
|
|
|
117 |
<KEY NAME="scorm_mapinfo_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
118 |
<KEY NAME="scorm_mapinfo_objectiveid" TYPE="foreign" FIELDS="objectiveid" REFTABLE="scorm_seq_objective" REFFIELDS="id" COMMENT="The relative objective"/>
|
|
|
119 |
</KEYS>
|
|
|
120 |
</TABLE>
|
|
|
121 |
<TABLE NAME="scorm_seq_ruleconds" COMMENT="SCORM2004 rule conditions">
|
|
|
122 |
<FIELDS>
|
|
|
123 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
124 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
125 |
<FIELD NAME="conditioncombination" TYPE="char" LENGTH="3" NOTNULL="true" DEFAULT="all" SEQUENCE="false"/>
|
|
|
126 |
<FIELD NAME="ruletype" TYPE="int" LENGTH="2" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
127 |
<FIELD NAME="action" TYPE="char" LENGTH="25" NOTNULL="true" SEQUENCE="false"/>
|
|
|
128 |
</FIELDS>
|
|
|
129 |
<KEYS>
|
|
|
130 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
131 |
<KEY NAME="scorm_ruleconds_un" TYPE="unique" FIELDS="scoid, id"/>
|
|
|
132 |
<KEY NAME="scorm_ruleconds_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
133 |
</KEYS>
|
|
|
134 |
</TABLE>
|
|
|
135 |
<TABLE NAME="scorm_seq_rulecond" COMMENT="SCORM2004 rule condition">
|
|
|
136 |
<FIELDS>
|
|
|
137 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
138 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
139 |
<FIELD NAME="ruleconditionsid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
140 |
<FIELD NAME="refrencedobjective" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
141 |
<FIELD NAME="measurethreshold" TYPE="float" LENGTH="11" NOTNULL="true" DEFAULT="0.0000" SEQUENCE="false" DECIMALS="4"/>
|
|
|
142 |
<FIELD NAME="operator" TYPE="char" LENGTH="5" NOTNULL="true" DEFAULT="noOp" SEQUENCE="false"/>
|
|
|
143 |
<FIELD NAME="cond" TYPE="char" LENGTH="30" NOTNULL="true" DEFAULT="always" SEQUENCE="false"/>
|
|
|
144 |
</FIELDS>
|
|
|
145 |
<KEYS>
|
|
|
146 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
147 |
<KEY NAME="scorm_rulecond_uniq" TYPE="unique" FIELDS="id, scoid, ruleconditionsid"/>
|
|
|
148 |
<KEY NAME="scorm_rulecond_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
149 |
<KEY NAME="scorm_rulecond_ruleconditionsid" TYPE="foreign" FIELDS="ruleconditionsid" REFTABLE="scorm_seq_ruleconds" REFFIELDS="id" COMMENT="The relative rulecondition"/>
|
|
|
150 |
</KEYS>
|
|
|
151 |
</TABLE>
|
|
|
152 |
<TABLE NAME="scorm_seq_rolluprule" COMMENT="SCORM2004 sequencing rule">
|
|
|
153 |
<FIELDS>
|
|
|
154 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
155 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
156 |
<FIELD NAME="childactivityset" TYPE="char" LENGTH="15" NOTNULL="true" SEQUENCE="false"/>
|
|
|
157 |
<FIELD NAME="minimumcount" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
158 |
<FIELD NAME="minimumpercent" TYPE="float" LENGTH="11" NOTNULL="true" DEFAULT="0.0000" SEQUENCE="false" DECIMALS="4"/>
|
|
|
159 |
<FIELD NAME="conditioncombination" TYPE="char" LENGTH="3" NOTNULL="true" DEFAULT="all" SEQUENCE="false"/>
|
|
|
160 |
<FIELD NAME="action" TYPE="char" LENGTH="15" NOTNULL="true" SEQUENCE="false"/>
|
|
|
161 |
</FIELDS>
|
|
|
162 |
<KEYS>
|
|
|
163 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
164 |
<KEY NAME="scorm_rolluprule_uniq" TYPE="unique" FIELDS="scoid, id"/>
|
|
|
165 |
<KEY NAME="scorm_rolluprule_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
166 |
</KEYS>
|
|
|
167 |
</TABLE>
|
|
|
168 |
<TABLE NAME="scorm_seq_rolluprulecond" COMMENT="SCORM2004 sequencing rule">
|
|
|
169 |
<FIELDS>
|
|
|
170 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
171 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
172 |
<FIELD NAME="rollupruleid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
173 |
<FIELD NAME="operator" TYPE="char" LENGTH="5" NOTNULL="true" DEFAULT="noOp" SEQUENCE="false"/>
|
|
|
174 |
<FIELD NAME="cond" TYPE="char" LENGTH="25" NOTNULL="true" SEQUENCE="false"/>
|
|
|
175 |
</FIELDS>
|
|
|
176 |
<KEYS>
|
|
|
177 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
178 |
<KEY NAME="scorm_rulluprulecond_uniq" TYPE="unique" FIELDS="scoid, rollupruleid, id"/>
|
|
|
179 |
<KEY NAME="scorm_rolluprulecond_scoid" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The relative sco"/>
|
|
|
180 |
<KEY NAME="scorm_rolluprulecond_rolluprule" TYPE="foreign" FIELDS="rollupruleid" REFTABLE="scorm_seq_rolluprule" REFFIELDS="id" COMMENT="The relative rolluprule"/>
|
|
|
181 |
</KEYS>
|
|
|
182 |
</TABLE>
|
|
|
183 |
<TABLE NAME="scorm_aicc_session" COMMENT="Used by AICC HACP to store session information">
|
|
|
184 |
<FIELDS>
|
|
|
185 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
186 |
<FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="id from user table"/>
|
|
|
187 |
<FIELD NAME="scormid" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="id from scorm table"/>
|
|
|
188 |
<FIELD NAME="hacpsession" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="sessionid used to authenticate AICC HACP communication"/>
|
|
|
189 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="false" DEFAULT="0" SEQUENCE="false" COMMENT="id from scorm_scoes table"/>
|
|
|
190 |
<FIELD NAME="scormmode" TYPE="char" LENGTH="50" NOTNULL="false" SEQUENCE="false"/>
|
|
|
191 |
<FIELD NAME="scormstatus" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false"/>
|
|
|
192 |
<FIELD NAME="attempt" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false"/>
|
|
|
193 |
<FIELD NAME="lessonstatus" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false"/>
|
|
|
194 |
<FIELD NAME="sessiontime" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false"/>
|
|
|
195 |
<FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="time this session was created"/>
|
|
|
196 |
<FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="time this session was last used"/>
|
|
|
197 |
</FIELDS>
|
|
|
198 |
<KEYS>
|
|
|
199 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
200 |
<KEY NAME="scormid" TYPE="foreign" FIELDS="scormid" REFTABLE="scorm" REFFIELDS="id"/>
|
|
|
201 |
<KEY NAME="userid" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
|
|
|
202 |
</KEYS>
|
|
|
203 |
</TABLE>
|
|
|
204 |
<TABLE NAME="scorm_attempt" COMMENT="List of SCORM attempts made by user.">
|
|
|
205 |
<FIELDS>
|
|
|
206 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
207 |
<FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
208 |
<FIELD NAME="scormid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="The id of the scorm table"/>
|
|
|
209 |
<FIELD NAME="attempt" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="1" SEQUENCE="false" COMMENT="The attempt number"/>
|
|
|
210 |
</FIELDS>
|
|
|
211 |
<KEYS>
|
|
|
212 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
213 |
<KEY NAME="user" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id" COMMENT="The id field of the user table"/>
|
|
|
214 |
<KEY NAME="scorm" TYPE="foreign" FIELDS="scormid" REFTABLE="scorm" REFFIELDS="id" COMMENT="The id of the scormtable"/>
|
|
|
215 |
</KEYS>
|
|
|
216 |
</TABLE>
|
|
|
217 |
<TABLE NAME="scorm_element" COMMENT="List of scorm elements.">
|
|
|
218 |
<FIELDS>
|
|
|
219 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
220 |
<FIELD NAME="element" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="Name of SCORM element"/>
|
|
|
221 |
</FIELDS>
|
|
|
222 |
<KEYS>
|
|
|
223 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
224 |
</KEYS>
|
|
|
225 |
<INDEXES>
|
|
|
226 |
<INDEX NAME="element" UNIQUE="true" FIELDS="element"/>
|
|
|
227 |
</INDEXES>
|
|
|
228 |
</TABLE>
|
|
|
229 |
<TABLE NAME="scorm_scoes_value" COMMENT="Values passed from SCORM package">
|
|
|
230 |
<FIELDS>
|
|
|
231 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
232 |
<FIELD NAME="scoid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="The id of the scorm_scoes table"/>
|
|
|
233 |
<FIELD NAME="attemptid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="id from scorm_attempt"/>
|
|
|
234 |
<FIELD NAME="elementid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="id from scorm_element"/>
|
|
|
235 |
<FIELD NAME="value" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="Value passed from SCORM package"/>
|
|
|
236 |
<FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Time value last changed."/>
|
|
|
237 |
</FIELDS>
|
|
|
238 |
<KEYS>
|
|
|
239 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
240 |
<KEY NAME="scoe" TYPE="foreign" FIELDS="scoid" REFTABLE="scorm_scoes" REFFIELDS="id" COMMENT="The id of the scorm_scoes table"/>
|
|
|
241 |
<KEY NAME="attempt" TYPE="foreign" FIELDS="attemptid" REFTABLE="scorm_attempt" REFFIELDS="id" COMMENT="id from scorm_attempt"/>
|
|
|
242 |
<KEY NAME="element" TYPE="foreign" FIELDS="elementid" REFTABLE="scorm_element" REFFIELDS="id" COMMENT="id from scorm_element"/>
|
|
|
243 |
</KEYS>
|
|
|
244 |
</TABLE>
|
|
|
245 |
</TABLES>
|
|
|
246 |
</XMLDB>
|