ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
class.ilMDLOMUpdateSteps.php
Go to the documentation of this file.
1<?php
2
19declare(strict_types=1);
20
21class ilMDLOMUpdateSteps implements ilDatabaseUpdateSteps
22{
23 protected \ilDBInterface $db;
24
25 public function prepare(\ilDBInterface $db): void
26 {
27 $this->db = $db;
28 }
29
34 public function step_1(): void
35 {
36 if (!$this->db->tableColumnExists('il_meta_general', 'general_aggl')) {
37 $this->db->addTableColumn(
38 'il_meta_general',
39 'general_aggl',
40 [
41 'type' => ilDBConstants::T_TEXT,
42 'length' => 16,
43 ]
44 );
45 }
46 }
47
52 public function step_2(): void
53 {
54 if (!$this->db->tableColumnExists('il_meta_contribute', 'c_date_descr')) {
55 $this->db->addTableColumn(
56 'il_meta_contribute',
57 'c_date_descr',
58 [
59 'type' => ilDBConstants::T_CLOB,
60 ]
61 );
62 }
63 if (!$this->db->tableColumnExists('il_meta_contribute', 'descr_lang')) {
64 $this->db->addTableColumn(
65 'il_meta_contribute',
66 'descr_lang',
67 [
68 'type' => ilDBConstants::T_TEXT,
69 'length' => 2
70 ]
71 );
72 }
73 }
74
79 public function step_3(): void
80 {
81 if (!$this->db->tableColumnExists('il_meta_annotation', 'a_date_descr')) {
82 $this->db->addTableColumn(
83 'il_meta_annotation',
84 'a_date_descr',
85 [
86 'type' => ilDBConstants::T_CLOB,
87 ]
88 );
89 }
90 if (!$this->db->tableColumnExists('il_meta_annotation', 'date_descr_lang')) {
91 $this->db->addTableColumn(
92 'il_meta_annotation',
93 'date_descr_lang',
94 [
95 'type' => ilDBConstants::T_TEXT,
96 'length' => 2
97 ]
98 );
99 }
100 }
101
106 public function step_4(): void
107 {
108 if (!$this->db->tableColumnExists('il_meta_educational', 'tlt_descr')) {
109 $this->db->addTableColumn(
110 'il_meta_educational',
111 'tlt_descr',
112 [
113 'type' => ilDBConstants::T_CLOB,
114 ]
115 );
116 }
117 if (!$this->db->tableColumnExists('il_meta_educational', 'tlt_descr_lang')) {
118 $this->db->addTableColumn(
119 'il_meta_educational',
120 'tlt_descr_lang',
121 [
122 'type' => ilDBConstants::T_TEXT,
123 'length' => 2
124 ]
125 );
126 }
127 }
128
133 public function step_5(): void
134 {
135 if (!$this->db->tableColumnExists('il_meta_technical', 'duration_descr')) {
136 $this->db->addTableColumn(
137 'il_meta_technical',
138 'duration_descr',
139 [
140 'type' => ilDBConstants::T_CLOB,
141 ]
142 );
143 }
144 if (!$this->db->tableColumnExists('il_meta_technical', 'duration_descr_lang')) {
145 $this->db->addTableColumn(
146 'il_meta_technical',
147 'duration_descr_lang',
148 [
149 'type' => ilDBConstants::T_TEXT,
150 'length' => 2
151 ]
152 );
153 }
154 }
155
159 public function step_6(): void
160 {
161 if (!$this->db->tableExists('il_meta_coverage')) {
162 $this->db->createTable(
163 'il_meta_coverage',
164 [
165 'meta_coverage_id' => [
166 'type' => ilDBConstants::T_INTEGER,
167 'notnull' => true,
168 'default' => 0
169 ],
170 'rbac_id' => [
171 'type' => ilDBConstants::T_INTEGER,
172 ],
173 'obj_id' => [
174 'type' => ilDBConstants::T_INTEGER,
175 ],
176 'obj_type' => [
177 'type' => ilDBConstants::T_TEXT,
178 'length' => 6
179 ],
180 'parent_type' => [
181 'type' => ilDBConstants::T_TEXT,
182 'length' => 16
183 ],
184 'parent_id' => [
185 'type' => ilDBConstants::T_INTEGER,
186 ],
187 'coverage' => [
188 'type' => ilDBConstants::T_TEXT,
189 'length' => 4000
190 ],
191 'coverage_language' => [
192 'type' => ilDBConstants::T_TEXT,
193 'length' => 2,
194 'fixed' => true
195 ]
196 ]
197 );
198
199 $this->db->createSequence('il_meta_coverage');
200 $this->db->addPrimaryKey('il_meta_coverage', ['meta_coverage_id']);
201 }
202 }
203
207 public function step_7(): void
208 {
209 if (!$this->db->tableExists('il_meta_meta_schema')) {
210 $this->db->createTable(
211 'il_meta_meta_schema',
212 [
213 'meta_meta_schema_id' => [
214 'type' => ilDBConstants::T_INTEGER,
215 'notnull' => true,
216 'default' => 0
217 ],
218 'rbac_id' => [
219 'type' => ilDBConstants::T_INTEGER,
220 ],
221 'obj_id' => [
222 'type' => ilDBConstants::T_INTEGER,
223 ],
224 'obj_type' => [
225 'type' => ilDBConstants::T_TEXT,
226 'length' => 6
227 ],
228 'parent_type' => [
229 'type' => ilDBConstants::T_TEXT,
230 'length' => 16
231 ],
232 'parent_id' => [
233 'type' => ilDBConstants::T_INTEGER,
234 ],
235 'meta_data_schema' => [
236 'type' => ilDBConstants::T_TEXT,
237 'length' => 16
238 ]
239 ]
240 );
241
242 $this->db->createSequence('il_meta_meta_schema');
243 $this->db->addPrimaryKey('il_meta_meta_schema', ['meta_meta_schema_id']);
244 }
245 }
246
250 public function step_8(): void
251 {
252 if (!$this->db->tableExists('il_meta_or_composite')) {
253 $this->db->createTable(
254 'il_meta_or_composite',
255 [
256 'meta_or_composite_id' => [
257 'type' => ilDBConstants::T_INTEGER,
258 'notnull' => true,
259 'default' => 0
260 ],
261 'rbac_id' => [
262 'type' => ilDBConstants::T_INTEGER,
263 ],
264 'obj_id' => [
265 'type' => ilDBConstants::T_INTEGER,
266 ],
267 'obj_type' => [
268 'type' => ilDBConstants::T_TEXT,
269 'length' => 6
270 ],
271 'parent_type' => [
272 'type' => ilDBConstants::T_TEXT,
273 'length' => 16
274 ],
275 'parent_id' => [
276 'type' => ilDBConstants::T_INTEGER,
277 ],
278 'type' => [
279 'type' => ilDBConstants::T_TEXT,
280 'length' => 16
281 ],
282 'name' => [
283 'type' => ilDBConstants::T_TEXT,
284 'length' => 32
285 ],
286 'min_version' => [
287 'type' => ilDBConstants::T_TEXT,
288 'length' => 255
289 ],
290 'max_version' => [
291 'type' => ilDBConstants::T_TEXT,
292 'length' => 255
293 ]
294 ]
295 );
296
297 $this->db->createSequence('il_meta_or_composite');
298 $this->db->addPrimaryKey('il_meta_or_composite', ['meta_or_composite_id']);
299 }
300 }
301
305 public function step_9(): void
306 {
307 if (!$this->db->tableExists('il_meta_lr_type')) {
308 $this->db->createTable(
309 'il_meta_lr_type',
310 [
311 'meta_lr_type_id' => [
312 'type' => ilDBConstants::T_INTEGER,
313 'notnull' => true,
314 'default' => 0
315 ],
316 'rbac_id' => [
317 'type' => ilDBConstants::T_INTEGER,
318 ],
319 'obj_id' => [
320 'type' => ilDBConstants::T_INTEGER,
321 ],
322 'obj_type' => [
323 'type' => ilDBConstants::T_TEXT,
324 'length' => 6
325 ],
326 'parent_type' => [
327 'type' => ilDBConstants::T_TEXT,
328 'length' => 16
329 ],
330 'parent_id' => [
331 'type' => ilDBConstants::T_INTEGER,
332 ],
333 'learning_resource_type' => [
334 'type' => ilDBConstants::T_TEXT,
335 'length' => 32
336 ]
337 ]
338 );
339
340 $this->db->createSequence('il_meta_lr_type');
341 $this->db->addPrimaryKey('il_meta_lr_type', ['meta_lr_type_id']);
342 }
343 }
344
348 public function step_10(): void
349 {
350 if (!$this->db->tableExists('il_meta_end_usr_role')) {
351 $this->db->createTable(
352 'il_meta_end_usr_role',
353 [
354 'meta_end_usr_role_id' => [
355 'type' => ilDBConstants::T_INTEGER,
356 'notnull' => true,
357 'default' => 0
358 ],
359 'rbac_id' => [
360 'type' => ilDBConstants::T_INTEGER,
361 ],
362 'obj_id' => [
363 'type' => ilDBConstants::T_INTEGER,
364 ],
365 'obj_type' => [
366 'type' => ilDBConstants::T_TEXT,
367 'length' => 6
368 ],
369 'parent_type' => [
370 'type' => ilDBConstants::T_TEXT,
371 'length' => 16
372 ],
373 'parent_id' => [
374 'type' => ilDBConstants::T_INTEGER,
375 ],
376 'intended_end_user_role' => [
377 'type' => ilDBConstants::T_TEXT,
378 'length' => 16
379 ]
380 ]
381 );
382
383 $this->db->createSequence('il_meta_end_usr_role');
384 $this->db->addPrimaryKey('il_meta_end_usr_role', ['meta_end_usr_role_id']);
385 }
386 }
387
391 public function step_11(): void
392 {
393 if (!$this->db->tableExists('il_meta_context')) {
394 $this->db->createTable(
395 'il_meta_context',
396 [
397 'meta_context_id' => [
398 'type' => ilDBConstants::T_INTEGER,
399 'notnull' => true,
400 'default' => 0
401 ],
402 'rbac_id' => [
403 'type' => ilDBConstants::T_INTEGER,
404 ],
405 'obj_id' => [
406 'type' => ilDBConstants::T_INTEGER,
407 ],
408 'obj_type' => [
409 'type' => ilDBConstants::T_TEXT,
410 'length' => 6
411 ],
412 'parent_type' => [
413 'type' => ilDBConstants::T_TEXT,
414 'length' => 16
415 ],
416 'parent_id' => [
417 'type' => ilDBConstants::T_INTEGER,
418 ],
419 'context' => [
420 'type' => ilDBConstants::T_TEXT,
421 'length' => 16
422 ]
423 ]
424 );
425
426 $this->db->createSequence('il_meta_context');
427 $this->db->addPrimaryKey('il_meta_context', ['meta_context_id']);
428 }
429 }
430}
ilMDLOMUpdateSteps\step_2
step_2()
Add two columns to the il_meta_contribute table to store the descrption of the date and its language.
Definition: class.ilMDLOMUpdateSteps.php:52
ilMDLOMUpdateSteps\step_3
step_3()
Add two columns to the il_meta_annotation table to store the description of the date and its language...
Definition: class.ilMDLOMUpdateSteps.php:79
ilMDLOMUpdateSteps\prepare
prepare(\ilDBInterface $db)
Prepare the execution of the steps.
Definition: class.ilMDLOMUpdateSteps.php:25
ilMDLOMUpdateSteps\step_11
step_11()
Add a new table for the non-unique context.
Definition: class.ilMDLOMUpdateSteps.php:391
ilMDLOMUpdateSteps\step_9
step_9()
Add a new table for the non-unique learning resource type.
Definition: class.ilMDLOMUpdateSteps.php:305
ilMDLOMUpdateSteps\step_4
step_4()
Add two columns to the il_meta_educational table to store the description of the typical learning tim...
Definition: class.ilMDLOMUpdateSteps.php:106
ilMDLOMUpdateSteps\step_8
step_8()
Add a new table for the non-unique or-composite in requirements.
Definition: class.ilMDLOMUpdateSteps.php:250
ilMDLOMUpdateSteps\step_6
step_6()
Add a new table for the non-unique coverage.
Definition: class.ilMDLOMUpdateSteps.php:159
ilMDLOMUpdateSteps\step_5
step_5()
Add two columns to the il_meta_technical table to store the description of the duration and its langu...
Definition: class.ilMDLOMUpdateSteps.php:133
ilMDLOMUpdateSteps\step_10
step_10()
Add a new table for the non-unique intented end user role.
Definition: class.ilMDLOMUpdateSteps.php:348
ilMDLOMUpdateSteps\step_1
step_1()
Add a column to the il_meta_general table to store the 'Aggregation Level' element.
Definition: class.ilMDLOMUpdateSteps.php:34
ilMDLOMUpdateSteps\step_7
step_7()
Add a new table for the non-unique metadata schema.
Definition: class.ilMDLOMUpdateSteps.php:207
ilDBInterface
Interface ilDBInterface.
Definition: interface.ilDBInterface.php:30
ilDatabaseUpdateSteps
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
Definition: interface.ilDatabaseUpdateSteps.php:44