| 1 |
efrain |
1 |
<?xml version="1.0" encoding="UTF-8" ?>
|
|
|
2 |
<XMLDB PATH="mod/hvp/db" VERSION="20190731" COMMENT="XMLDB file for Moodle mod/hvp"
|
|
|
3 |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
|
4 |
xsi:noNamespaceSchemaLocation="../../../lib/xmldb/xmldb.xsd"
|
|
|
5 |
>
|
|
|
6 |
<TABLES>
|
|
|
7 |
<TABLE NAME="hvp" COMMENT="Activity data">
|
|
|
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="intro" TYPE="text" NOTNULL="false" SEQUENCE="false"/>
|
|
|
13 |
<FIELD NAME="introformat" TYPE="int" LENGTH="4" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
14 |
<FIELD NAME="json_content" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="The content in json format"/>
|
|
|
15 |
<FIELD NAME="embed_type" TYPE="char" LENGTH="127" NOTNULL="true" SEQUENCE="false"/>
|
|
|
16 |
<FIELD NAME="disable" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
17 |
<FIELD NAME="main_library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="The library we first instanciate for this node"/>
|
|
|
18 |
<FIELD NAME="content_type" TYPE="char" LENGTH="127" NOTNULL="false" SEQUENCE="false" COMMENT="Content type as defined in h5p.json"/>
|
|
|
19 |
<FIELD NAME="authors" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="List of authors in json format"/>
|
|
|
20 |
<FIELD NAME="source" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false" COMMENT="Link to the source, could also be citation"/>
|
|
|
21 |
<FIELD NAME="year_from" TYPE="int" LENGTH="4" NOTNULL="false" SEQUENCE="false" COMMENT="Start year for copyright"/>
|
|
|
22 |
<FIELD NAME="year_to" TYPE="int" LENGTH="4" NOTNULL="false" SEQUENCE="false" COMMENT="End year for copyright"/>
|
|
|
23 |
<FIELD NAME="license" TYPE="char" LENGTH="63" NOTNULL="false" SEQUENCE="false" COMMENT="License name of the content"/>
|
|
|
24 |
<FIELD NAME="license_version" TYPE="char" LENGTH="15" NOTNULL="false" SEQUENCE="false" COMMENT="Version of the license used for the content"/>
|
|
|
25 |
<FIELD NAME="changes" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="List of changes in json format"/>
|
|
|
26 |
<FIELD NAME="license_extras" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Extra licensing terms"/>
|
|
|
27 |
<FIELD NAME="author_comments" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Comments for the editor"/>
|
|
|
28 |
<FIELD NAME="default_language" TYPE="char" LENGTH="32" NOTNULL="false" SEQUENCE="false" COMMENT="Default language for common fields"/>
|
|
|
29 |
<FIELD NAME="filtered" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Filtered version of json_content"/>
|
|
|
30 |
<FIELD NAME="slug" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="Human readable content identifier that is unique"/>
|
|
|
31 |
<FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
32 |
<FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
33 |
<FIELD NAME="completionpass" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
34 |
<FIELD NAME="shared" TYPE="int" LENGTH="10" NOTNULL="true" DEFAULT="0" SEQUENCE="false"/>
|
|
|
35 |
<FIELD NAME="synced" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false"/>
|
|
|
36 |
<FIELD NAME="hub_id" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false"/>
|
|
|
37 |
<FIELD NAME="a11y_title" TYPE="char" LENGTH="255" NOTNULL="false" SEQUENCE="false"/>
|
|
|
38 |
</FIELDS>
|
|
|
39 |
<KEYS>
|
|
|
40 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
41 |
</KEYS>
|
|
|
42 |
</TABLE>
|
|
|
43 |
<TABLE NAME="hvp_xapi_results" COMMENT="Stored xAPI events">
|
|
|
44 |
<FIELDS>
|
|
|
45 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
46 |
<FIELD NAME="content_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
47 |
<FIELD NAME="user_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
48 |
<FIELD NAME="parent_id" TYPE="int" LENGTH="10" NOTNULL="false" SEQUENCE="false"/>
|
|
|
49 |
<FIELD NAME="interaction_type" TYPE="char" LENGTH="127" NOTNULL="true" SEQUENCE="false"/>
|
|
|
50 |
<FIELD NAME="description" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
51 |
<FIELD NAME="correct_responses_pattern" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
52 |
<FIELD NAME="response" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
53 |
<FIELD NAME="additionals" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
54 |
<FIELD NAME="raw_score" TYPE="int" LENGTH="6" NOTNULL="false" SEQUENCE="false"/>
|
|
|
55 |
<FIELD NAME="max_score" TYPE="int" LENGTH="6" NOTNULL="false" SEQUENCE="false"/>
|
|
|
56 |
</FIELDS>
|
|
|
57 |
<KEYS>
|
|
|
58 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
59 |
</KEYS>
|
|
|
60 |
<INDEXES>
|
|
|
61 |
<INDEX NAME="results" UNIQUE="false" FIELDS="content_id, user_id"/>
|
|
|
62 |
</INDEXES>
|
|
|
63 |
</TABLE>
|
|
|
64 |
<TABLE NAME="hvp_content_user_data" COMMENT="Stores user data about the content">
|
|
|
65 |
<FIELDS>
|
|
|
66 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
67 |
<FIELD NAME="user_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Id for the user answering this H5P"/>
|
|
|
68 |
<FIELD NAME="hvp_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Id of hvp content in the 'hvp' table"/>
|
|
|
69 |
<FIELD NAME="sub_content_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Subcontent id of hvp content, 0 if this is not subcontent"/>
|
|
|
70 |
<FIELD NAME="data_id" TYPE="char" LENGTH="127" NOTNULL="false" SEQUENCE="false" COMMENT="The data type identifier"/>
|
|
|
71 |
<FIELD NAME="data" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="The actual user data that was stored."/>
|
|
|
72 |
<FIELD NAME="preloaded" TYPE="int" LENGTH="1" NOTNULL="true" SEQUENCE="false"/>
|
|
|
73 |
<FIELD NAME="delete_on_content_change" TYPE="int" LENGTH="1" NOTNULL="true" SEQUENCE="false"/>
|
|
|
74 |
</FIELDS>
|
|
|
75 |
<KEYS>
|
|
|
76 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
77 |
</KEYS>
|
|
|
78 |
</TABLE>
|
|
|
79 |
<TABLE NAME="hvp_libraries" COMMENT="Stores information about libraries.">
|
|
|
80 |
<FIELDS>
|
|
|
81 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" COMMENT="Primary Key: The id of the library"/>
|
|
|
82 |
<FIELD NAME="machine_name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="The library machine name"/>
|
|
|
83 |
<FIELD NAME="title" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="The human readable name of this library"/>
|
|
|
84 |
<FIELD NAME="major_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
85 |
<FIELD NAME="minor_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
86 |
<FIELD NAME="patch_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
87 |
<FIELD NAME="runnable" TYPE="int" LENGTH="1" NOTNULL="true" SEQUENCE="false" COMMENT="Can this library be started by the module? i.e. not a dependency."/>
|
|
|
88 |
<FIELD NAME="fullscreen" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Display fullscreen button"/>
|
|
|
89 |
<FIELD NAME="embed_types" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
90 |
<FIELD NAME="preloaded_js" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Comma separated list of scripts to load."/>
|
|
|
91 |
<FIELD NAME="preloaded_css" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Comma separated list of stylesheets to load."/>
|
|
|
92 |
<FIELD NAME="drop_library_css" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="List of libraries that should not have CSS included if this library is used. Comma separated list."/>
|
|
|
93 |
<FIELD NAME="semantics" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="The semantics definition in json format"/>
|
|
|
94 |
<FIELD NAME="restricted" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Restricts the ability to create new content using this library"/>
|
|
|
95 |
<FIELD NAME="tutorial_url" TYPE="char" LENGTH="1000" NOTNULL="false" SEQUENCE="false" COMMENT="URL to a tutorial for this library"/>
|
|
|
96 |
<FIELD NAME="has_icon" TYPE="int" LENGTH="1" NOTNULL="true" DEFAULT="0" SEQUENCE="false" COMMENT="Whether or not this library contains an icon.svg"/>
|
|
|
97 |
<FIELD NAME="add_to" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Plugin configuration data"/>
|
|
|
98 |
<FIELD NAME="metadata_settings" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Metadata settings"/>
|
|
|
99 |
</FIELDS>
|
|
|
100 |
<KEYS>
|
|
|
101 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
102 |
</KEYS>
|
|
|
103 |
<INDEXES>
|
|
|
104 |
<INDEX NAME="meta" UNIQUE="false" FIELDS="machine_name, major_version, minor_version, patch_version, runnable"/>
|
|
|
105 |
</INDEXES>
|
|
|
106 |
</TABLE>
|
|
|
107 |
<TABLE NAME="hvp_libraries_hub_cache" COMMENT="Caches content types from the H5P hub.">
|
|
|
108 |
<FIELDS>
|
|
|
109 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true" COMMENT="Primary Key: The id of the library"/>
|
|
|
110 |
<FIELD NAME="machine_name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="The library machine name"/>
|
|
|
111 |
<FIELD NAME="major_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
112 |
<FIELD NAME="minor_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
113 |
<FIELD NAME="patch_version" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
|
|
|
114 |
<FIELD NAME="h5p_major_version" TYPE="int" LENGTH="4" NOTNULL="false" SEQUENCE="false" COMMENT="The major version required of H5P core"/>
|
|
|
115 |
<FIELD NAME="h5p_minor_version" TYPE="int" LENGTH="4" NOTNULL="false" SEQUENCE="false" COMMENT="The minor version required of H5P core"/>
|
|
|
116 |
<FIELD NAME="title" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="The human readable name of this library"/>
|
|
|
117 |
<FIELD NAME="summary" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="Short description of library"/>
|
|
|
118 |
<FIELD NAME="description" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="Long description of library"/>
|
|
|
119 |
<FIELD NAME="icon" TYPE="char" LENGTH="511" NOTNULL="true" SEQUENCE="false" COMMENT="URL to icon"/>
|
|
|
120 |
<FIELD NAME="created_at" TYPE="int" LENGTH="11" NOTNULL="true" SEQUENCE="false" COMMENT="Time that the library was uploaded"/>
|
|
|
121 |
<FIELD NAME="updated_at" TYPE="int" LENGTH="11" NOTNULL="true" SEQUENCE="false" COMMENT="Time that the library has its latest update"/>
|
|
|
122 |
<FIELD NAME="is_recommended" TYPE="int" LENGTH="1" NOTNULL="true" SEQUENCE="false" COMMENT="Whether the library is recommended by the HUB moderators"/>
|
|
|
123 |
<FIELD NAME="popularity" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="How many times the library has been downloaded"/>
|
|
|
124 |
<FIELD NAME="screenshots" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Screenshot URLs json encoded"/>
|
|
|
125 |
<FIELD NAME="license" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Library license(s) json encoded"/>
|
|
|
126 |
<FIELD NAME="example" TYPE="char" LENGTH="511" NOTNULL="true" SEQUENCE="false" COMMENT="URL to example content for this library"/>
|
|
|
127 |
<FIELD NAME="tutorial" TYPE="char" LENGTH="511" NOTNULL="false" SEQUENCE="false" COMMENT="Tutorial URL"/>
|
|
|
128 |
<FIELD NAME="keywords" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Keywords for library json encoded"/>
|
|
|
129 |
<FIELD NAME="categories" TYPE="text" NOTNULL="false" SEQUENCE="false" COMMENT="Categories for library json encoded"/>
|
|
|
130 |
<FIELD NAME="owner" TYPE="char" LENGTH="511" NOTNULL="false" SEQUENCE="false" COMMENT="Owner of the library"/>
|
|
|
131 |
</FIELDS>
|
|
|
132 |
<KEYS>
|
|
|
133 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
134 |
</KEYS>
|
|
|
135 |
</TABLE>
|
|
|
136 |
<TABLE NAME="hvp_content_hub_cache" COMMENT="Caches content metadata options from the H5P OER Hub.">
|
|
|
137 |
<FIELDS>
|
|
|
138 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
139 |
<FIELD NAME="language" TYPE="char" LENGTH="31" NOTNULL="true" SEQUENCE="false"/>
|
|
|
140 |
<FIELD NAME="json" TYPE="text" NOTNULL="true" SEQUENCE="false"/>
|
|
|
141 |
<FIELD NAME="last_checked" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
142 |
</FIELDS>
|
|
|
143 |
<KEYS>
|
|
|
144 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
145 |
</KEYS>
|
|
|
146 |
<INDEXES>
|
|
|
147 |
<INDEX NAME="language" UNIQUE="true" FIELDS="language"/>
|
|
|
148 |
</INDEXES>
|
|
|
149 |
</TABLE>
|
|
|
150 |
<TABLE NAME="hvp_libraries_libraries" COMMENT="Library dependencies">
|
|
|
151 |
<FIELDS>
|
|
|
152 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
153 |
<FIELD NAME="library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Primary Key: The id of a H5P library."/>
|
|
|
154 |
<FIELD NAME="required_library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="The dependency to load"/>
|
|
|
155 |
<FIELD NAME="dependency_type" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" COMMENT="'preloaded, dynamic, or editor'"/>
|
|
|
156 |
</FIELDS>
|
|
|
157 |
<KEYS>
|
|
|
158 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
159 |
</KEYS>
|
|
|
160 |
</TABLE>
|
|
|
161 |
<TABLE NAME="hvp_libraries_languages" COMMENT="Translations for libraries">
|
|
|
162 |
<FIELDS>
|
|
|
163 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
164 |
<FIELD NAME="library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
165 |
<FIELD NAME="language_code" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
166 |
<FIELD NAME="language_json" TYPE="text" NOTNULL="true" SEQUENCE="false" COMMENT="The translations defined in json format"/>
|
|
|
167 |
</FIELDS>
|
|
|
168 |
<KEYS>
|
|
|
169 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
170 |
</KEYS>
|
|
|
171 |
</TABLE>
|
|
|
172 |
<TABLE NAME="hvp_libraries_cachedassets" COMMENT="Use to know which caches to clear when a library is updated">
|
|
|
173 |
<FIELDS>
|
|
|
174 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
175 |
<FIELD NAME="library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
176 |
<FIELD NAME="hash" TYPE="char" LENGTH="64" NOTNULL="true" SEQUENCE="false"/>
|
|
|
177 |
</FIELDS>
|
|
|
178 |
<KEYS>
|
|
|
179 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
180 |
</KEYS>
|
|
|
181 |
<INDEXES>
|
|
|
182 |
<INDEX NAME="relation" UNIQUE="true" FIELDS="library_id, hash"/>
|
|
|
183 |
</INDEXES>
|
|
|
184 |
</TABLE>
|
|
|
185 |
<TABLE NAME="hvp_contents_libraries" COMMENT="Store which library is used in which content.">
|
|
|
186 |
<FIELDS>
|
|
|
187 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
188 |
<FIELD NAME="hvp_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Identifier for a content found from the 'hvp' table"/>
|
|
|
189 |
<FIELD NAME="library_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="The identifier of a H5P library this content uses"/>
|
|
|
190 |
<FIELD NAME="dependency_type" TYPE="char" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="dynamic, preloaded or editor"/>
|
|
|
191 |
<FIELD NAME="drop_css" TYPE="int" LENGTH="1" NOTNULL="true" SEQUENCE="false" COMMENT="1 if the preloaded css from the dependency is to be excluded"/>
|
|
|
192 |
<FIELD NAME="weight" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Determines the order in which the preloaded libraries will be loaded"/>
|
|
|
193 |
</FIELDS>
|
|
|
194 |
<KEYS>
|
|
|
195 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
196 |
</KEYS>
|
|
|
197 |
<INDEXES>
|
|
|
198 |
<INDEX NAME="meta" UNIQUE="false" FIELDS="drop_css"/>
|
|
|
199 |
</INDEXES>
|
|
|
200 |
</TABLE>
|
|
|
201 |
<TABLE NAME="hvp_events" COMMENT="Keep track of logged H5P events">
|
|
|
202 |
<FIELDS>
|
|
|
203 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
204 |
<FIELD NAME="user_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
205 |
<FIELD NAME="created_at" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
206 |
<FIELD NAME="type" TYPE="char" LENGTH="63" NOTNULL="true" SEQUENCE="false"/>
|
|
|
207 |
<FIELD NAME="sub_type" TYPE="char" LENGTH="63" NOTNULL="true" SEQUENCE="false"/>
|
|
|
208 |
<FIELD NAME="content_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
209 |
<FIELD NAME="content_title" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false"/>
|
|
|
210 |
<FIELD NAME="library_name" TYPE="char" LENGTH="127" NOTNULL="true" SEQUENCE="false"/>
|
|
|
211 |
<FIELD NAME="library_version" TYPE="char" LENGTH="31" NOTNULL="true" SEQUENCE="false"/>
|
|
|
212 |
</FIELDS>
|
|
|
213 |
<KEYS>
|
|
|
214 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
215 |
</KEYS>
|
|
|
216 |
</TABLE>
|
|
|
217 |
<TABLE NAME="hvp_tmpfiles" COMMENT="Keep track of files uploaded before content is saved">
|
|
|
218 |
<FIELDS>
|
|
|
219 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
220 |
</FIELDS>
|
|
|
221 |
<KEYS>
|
|
|
222 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
223 |
</KEYS>
|
|
|
224 |
</TABLE>
|
|
|
225 |
<TABLE NAME="hvp_counters" COMMENT="A set of global counters to keep track of H5P usage">
|
|
|
226 |
<FIELDS>
|
|
|
227 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
228 |
<FIELD NAME="type" TYPE="char" LENGTH="63" NOTNULL="true" SEQUENCE="false"/>
|
|
|
229 |
<FIELD NAME="library_name" TYPE="char" LENGTH="127" NOTNULL="true" SEQUENCE="false"/>
|
|
|
230 |
<FIELD NAME="library_version" TYPE="char" LENGTH="31" NOTNULL="true" SEQUENCE="false"/>
|
|
|
231 |
<FIELD NAME="num" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
|
|
|
232 |
</FIELDS>
|
|
|
233 |
<KEYS>
|
|
|
234 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
235 |
</KEYS>
|
|
|
236 |
<INDEXES>
|
|
|
237 |
<INDEX NAME="realkey" UNIQUE="false" FIELDS="type, library_name, library_version"/>
|
|
|
238 |
</INDEXES>
|
|
|
239 |
</TABLE>
|
|
|
240 |
<TABLE NAME="hvp_auth" COMMENT="Stores tokens for authenticating users for different actions">
|
|
|
241 |
<FIELDS>
|
|
|
242 |
<FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
|
|
|
243 |
<FIELD NAME="user_id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false" COMMENT="Id of the user that created the token"/>
|
|
|
244 |
<FIELD NAME="created_at" TYPE="int" LENGTH="11" NOTNULL="true" SEQUENCE="false" COMMENT="Timestamp for when token was created"/>
|
|
|
245 |
<FIELD NAME="secret" TYPE="char" LENGTH="64" NOTNULL="true" SEQUENCE="false" COMMENT="Secret used to generate the authentication token"/>
|
|
|
246 |
</FIELDS>
|
|
|
247 |
<KEYS>
|
|
|
248 |
<KEY NAME="primary" TYPE="primary" FIELDS="id"/>
|
|
|
249 |
</KEYS>
|
|
|
250 |
<INDEXES>
|
|
|
251 |
<INDEX NAME="user_id" UNIQUE="true" FIELDS="user_id"/>
|
|
|
252 |
</INDEXES>
|
|
|
253 |
</TABLE>
|
|
|
254 |
</TABLES>
|
|
|
255 |
</XMLDB>
|