ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
class.ilDatabaseCommonTestsDataOutputs.php
Go to the documentation of this file.
1<?php
2
8abstract class ilDatabaseCommonTestsDataOutputs {
9
15 public function getIndexInfo($with_fulltext = false, $table_name = '') {
16 if ($with_fulltext) {
17 return array(
18 0 => array(
19 'name' => 'i1',
20 'fulltext' => false,
21 'fields' => array(
22 'init_mob_id' => array(
23 'position' => 1,
24 'sorting' => 'ascending',
25 ),
26 ),
27 ),
28 1 => array(
29 'name' => 'i2',
30 'fulltext' => true,
31 'fields' => array(
32 'address' => array(
33 'position' => 1,
34 'sorting' => null,
35 ),
36 ),
37 ),
38 );
39 } else {
40 return array(
41 0 => array(
42 'name' => 'i1',
43 'fulltext' => false,
44 'fields' => array(
45 'init_mob_id' => array(
46 'position' => 1,
47 'sorting' => 'ascending',
48 ),
49 ),
50 ),
51 );
52 }
53 }
54
55
59 public function getPrimaryInfo($table_name = '') {
60 return array(
61 'name' => 'primary',
62 'fields' => array(
63 'id' => array(
64 'position' => 1,
65 'sorting' => 'ascending',
66 ),
67 ),
68 );
69 }
70
71
75 public static $analyzer_field_info = array(
76 'id' => array(
77 'notnull' => true,
78 'nativetype' => 'int',
79 'length' => 4,
80 'unsigned' => 0,
81 'default' => '',
82 'fixed' => null,
83 'autoincrement' => null,
84 'type' => 'integer',
85 'alt_types' => '',
86 ),
87 'is_online' => array(
88 'notnull' => false,
89 'nativetype' => 'tinyint',
90 'length' => 1,
91 'unsigned' => 0,
92 'default' => null,
93 'fixed' => null,
94 'autoincrement' => null,
95 'type' => 'integer',
96 'alt_types' => 'boolean1 ',
97 ),
98 'is_default' => array(
99 'notnull' => false,
100 'nativetype' => 'tinyint',
101 'length' => 1,
102 'unsigned' => 0,
103 'default' => '1',
104 'fixed' => null,
105 'autoincrement' => null,
106 'type' => 'integer',
107 'alt_types' => 'boolean1 ',
108 ),
109 'latitude' => array(
110 'notnull' => false,
111 'nativetype' => 'double',
112 'length' => null,
113 'unsigned' => 0,
114 'default' => null,
115 'fixed' => null,
116 'autoincrement' => null,
117 'type' => 'float',
118 'alt_types' => '',
119 ),
120 'longitude' => array(
121 'notnull' => false,
122 'nativetype' => 'double',
123 'length' => null,
124 'unsigned' => 0,
125 'default' => null,
126 'fixed' => null,
127 'autoincrement' => null,
128 'type' => 'float',
129 'alt_types' => '',
130 ),
131 'elevation' => array(
132 'notnull' => false,
133 'nativetype' => 'double',
134 'length' => null,
135 'unsigned' => 0,
136 'default' => null,
137 'fixed' => null,
138 'autoincrement' => null,
139 'type' => 'float',
140 'alt_types' => '',
141 ),
142 'address' => array(
143 'notnull' => false,
144 'nativetype' => 'varchar',
145 'length' => '256',
146 'unsigned' => null,
147 'default' => null,
148 'fixed' => false,
149 'autoincrement' => null,
150 'type' => 'text',
151 'alt_types' => '',
152 ),
153 'init_mob_id' => array(
154 'notnull' => false,
155 'nativetype' => 'int',
156 'length' => 4,
157 'unsigned' => 0,
158 'default' => null,
159 'fixed' => null,
160 'autoincrement' => null,
161 'type' => 'integer',
162 'alt_types' => '',
163 ),
164 'comment_mob_id' => array(
165 'notnull' => false,
166 'nativetype' => 'varchar',
167 'length' => '250',
168 'unsigned' => null,
169 'default' => null,
170 'fixed' => false,
171 'autoincrement' => null,
172 'type' => 'text',
173 'alt_types' => '',
174 ),
175 'container_id' => array(
176 'notnull' => false,
177 'nativetype' => 'int',
178 'length' => 4,
179 'unsigned' => 0,
180 'default' => null,
181 'fixed' => null,
182 'autoincrement' => null,
183 'type' => 'integer',
184 'alt_types' => '',
185 ),
186 'big_data' => array(
187 'notnull' => false,
188 'nativetype' => 'longtext',
189 'length' => null,
190 'unsigned' => null,
191 'default' => null,
192 'fixed' => false,
193 'autoincrement' => null,
194 'type' => 'clob',
195 'alt_types' => 'text ',
196 ),
197 );
201 public static $insert_sql_output = array(
202 'id' => '58',
203 'is_online' => '1',
204 'is_default' => '0',
205 'latitude' => '47.05983',
206 'longitude' => '7.624028',
207 'elevation' => '2.56',
208 'address' => 'Farbweg 9, 3400 Burgdorf',
209 'init_mob_id' => '78',
210 'comment_mob_id' => '69',
211 'container_id' => '456',
212 'big_data' => null,
213 );
217 public static $select_usr_data_output = array(
218 'usr_id' => '6',
219 'login' => 'root',
220 'is_self_registered' => '0',
221 );
225 public static $select_usr_data_2_output = array(
226 array(
227 'usr_id' => '6',
228 'login' => 'root',
229 'is_self_registered' => '0',
230 ),
231 array(
232 'usr_id' => '13',
233 'login' => 'anonymous',
234 'is_self_registered' => '0',
235 ),
236 );
240 public static $output_after_native_update = array(
241 'id' => '56',
242 'is_online' => '1',
243 'is_default' => '0',
244 'latitude' => '47.05983',
245 'longitude' => '7.624028',
246 'elevation' => '2.56',
247 'address' => 'Farbweg 9, 3400 Burgdorf',
248 'init_mob_id' => '2222',
249 'comment_mob_id' => '69',
250 'container_id' => '456',
251 'big_data' => null,
252 );
256 public static $output_after_native_input = array(
257 'id' => '56',
258 'is_online' => '1',
259 'is_default' => '0',
260 'latitude' => '47.05983',
261 'longitude' => '7.624028',
262 'elevation' => '2.56',
263 'address' => 'Farbweg 9, 3400 Burgdorf',
264 'init_mob_id' => '78',
265 'comment_mob_id' => '69',
266 'container_id' => '456',
267 'big_data' => 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.',
268 );
269
270
275 abstract public function getCreationQueryBuildByILIAS($table_name);
276
277
281 public function getTableFieldDefinition() {
282 return array(
283 0 => array(
284 'notnull' => false,
285 'nativetype' => 'int',
286 'length' => 4,
287 'unsigned' => 0,
288 'default' => null,
289 'type' => 'integer',
290 'mdb2type' => 'integer',
291 ),
292 );
293 }
294
295
299 public static $table_index_definition_output = array(
300 'fields' => array(
301 'init_mob_id' => array(
302 'position' => 1,
303 'sorting' => 'ascending',
304 ),
305 ),
306 );
310 public static $table_constraint_definition_output = array(
311 'primary' => true,
312 'fields' => array(
313 'id' => array(
314 'position' => 1,
315 'sorting' => 'ascending',
316 ),
317 ),
318 );
319
320
325 public function getTableSequences($table_name) {
326 $array = array(
327 0 => 'addressbook_mlist_ass',
328 1 => 'addressbook_mlist',
329 2 => 'adm_settings_template',
330 3 => 'adv_md_record',
331 4 => 'adv_mdf_definition',
332 5 => 'aicc_object',
333 6 => 'aicc_units',
334 7 => 'ass_log',
335 8 => 'benchmark',
336 9 => 'booking_entry',
337 10 => 'booking_object',
338 11 => 'booking_reservation_group',
339 12 => 'booking_reservation',
340 13 => 'booking_schedule',
341 14 => 'bookmark_data',
342 15 => 'bookmark_social_bm',
343 16 => 'cal_categories',
344 17 => 'cal_ch_group',
345 18 => 'cal_entries',
346 19 => 'cal_notification',
347 20 => 'cal_rec_exclusion',
348 21 => 'cal_recurrence_rules',
349 22 => 'chatroom_admconfig',
350 23 => 'chatroom_history',
351 24 => 'chatroom_prooms',
352 25 => 'chatroom_psessions',
353 26 => 'chatroom_sessions',
354 27 => 'chatroom_settings',
355 28 => 'chatroom_smilies',
356 29 => 'chatroom_uploads',
357 30 => 'cmi_comment',
358 31 => 'cmi_correct_response',
359 32 => 'cmi_interaction',
360 33 => 'cmi_node',
361 34 => 'cmi_objective',
362 35 => 'conditions',
363 36 => 'cp_node',
364 37 => 'crs_archives',
365 38 => 'crs_f_definitions',
366 39 => 'crs_file',
367 40 => 'crs_objective_lm',
368 41 => 'crs_objective_qst',
369 42 => 'crs_objective_tst',
370 43 => 'crs_objectives',
371 44 => 'crs_start',
372 45 => 'didactic_tpl_a',
373 46 => 'didactic_tpl_fp',
374 47 => 'didactic_tpl_settings',
375 48 => 'ecs_cmap_rule',
376 49 => 'ecs_cms_data',
377 50 => 'ecs_container_mapping',
378 51 => 'ecs_course_assignments',
379 52 => 'ecs_crs_mapping_atts',
380 53 => 'ecs_events',
381 54 => 'ecs_remote_user',
382 55 => 'ecs_server',
383 56 => 'event_appointment',
384 57 => 'event_file',
385 58 => 'event',
386 59 => 'exc_assignment',
387 60 => 'exc_crit_cat',
388 61 => 'exc_crit',
389 62 => 'exc_returned',
390 64 => 'frm_data',
391 65 => 'frm_notification',
392 66 => 'frm_posts_deleted',
393 67 => 'frm_posts',
394 68 => 'frm_posts_tree',
395 69 => 'frm_threads',
396 70 => 'glossary_definition',
397 71 => 'glossary_term',
398 72 => 'help_module',
399 73 => 'help_tooltip',
400 74 => 'history',
401 75 => 'il_bibl_attribute',
402 76 => 'il_bibl_entry',
403 77 => 'il_bibl_settings',
404 78 => 'il_blog_posting',
405 79 => 'il_custom_block',
406 80 => 'il_dcl_data',
407 81 => 'il_dcl_field_prop',
408 82 => 'il_dcl_field',
409 83 => 'il_dcl_record_field',
410 84 => 'il_dcl_record',
411 85 => 'il_dcl_stloc1_value',
412 86 => 'il_dcl_stloc2_value',
413 87 => 'il_dcl_stloc3_value',
414 88 => 'il_dcl_table',
415 89 => 'il_dcl_view',
416 90 => 'il_exc_team_log',
417 91 => 'il_exc_team',
418 92 => 'il_external_feed_block',
419 93 => 'il_gc_memcache_server',
420 94 => 'il_md_cpr_selections',
421 95 => 'il_meta_annotation',
422 96 => 'il_meta_classification',
423 97 => 'il_meta_contribute',
424 98 => 'il_meta_description',
425 99 => 'il_meta_educational',
426 100 => 'il_meta_entity',
427 101 => 'il_meta_format',
428 102 => 'il_meta_general',
429 103 => 'il_meta_identifier_',
430 104 => 'il_meta_identifier',
431 105 => 'il_meta_keyword',
432 106 => 'il_meta_language',
433 107 => 'il_meta_lifecycle',
434 108 => 'il_meta_location',
435 109 => 'il_meta_meta_data',
436 110 => 'il_meta_relation',
437 111 => 'il_meta_requirement',
438 112 => 'il_meta_rights',
439 113 => 'il_meta_tar',
440 114 => 'il_meta_taxon_path',
441 115 => 'il_meta_taxon',
442 116 => 'il_meta_technical',
443 117 => 'il_new_item_grp',
444 118 => 'il_news_item',
445 119 => 'il_poll_answer',
446 120 => 'il_qpl_qst_fq_res',
447 121 => 'il_qpl_qst_fq_res_unit',
448 122 => 'il_qpl_qst_fq_ucat',
449 123 => 'il_qpl_qst_fq_unit',
450 124 => 'il_qpl_qst_fq_var',
451 125 => 'il_rating_cat',
452 126 => $table_name,
453 127 => 'il_wiki_page',
454 128 => 'ldap_rg_mapping',
455 129 => 'ldap_role_assignments',
456 130 => 'ldap_server_settings',
457 131 => 'link_check',
458 132 => 'lm_data',
459 133 => 'lm_menu',
460 134 => 'loc_tst_assignments',
461 135 => 'mail_man_tpl',
462 136 => 'mail_obj_data',
463 137 => 'mail',
464 138 => 'media_item',
465 139 => 'mep_item',
466 140 => 'note',
467 141 => 'notification_data',
468 142 => 'notification_osd',
469 143 => 'obj_stat_log',
470 144 => 'object_data',
471 145 => 'object_reference',
472 146 => 'object_reference_ws',
473 147 => 'openid_provider',
474 148 => 'orgu_types',
475 149 => 'page_layout',
476 150 => 'page_style_usage',
477 151 => 'pg_amd_page_list',
478 152 => 'prg_settings',
479 153 => 'prg_translations',
480 154 => 'prg_type_adv_md_rec',
481 155 => 'prg_type',
482 156 => 'prg_usr_assignments',
483 157 => 'prg_usr_progress',
484 158 => 'qpl_a_cloze',
485 159 => 'qpl_a_errortext',
486 160 => 'qpl_a_essay',
487 161 => 'qpl_a_imagemap',
488 162 => 'qpl_a_matching',
489 163 => 'qpl_a_mc',
490 164 => 'qpl_a_mdef',
491 165 => 'qpl_a_mterm',
492 166 => 'qpl_a_ordering',
493 167 => 'qpl_a_sc',
494 168 => 'qpl_a_textsubset',
495 169 => 'qpl_fb_generic',
496 170 => 'qpl_fb_specific',
497 171 => 'qpl_hint_tracking',
498 172 => 'qpl_hints',
499 173 => 'qpl_num_range',
500 174 => 'qpl_questionpool',
501 175 => 'qpl_questions',
502 176 => 'qpl_sol_sug',
503 177 => 'rbac_log',
504 178 => 'rbac_operations',
505 179 => 'reg_er_assignments',
506 180 => 'reg_registration_codes',
507 181 => 'role_desktop_items',
508 182 => 'sahs_sc13_seq_node',
509 183 => 'sahs_sc13_seq',
510 184 => 'sahs_sc13_seq_templts',
511 185 => 'sahs_sc13_tree_node',
512 186 => 'sc_resource_dependen',
513 187 => 'sc_resource_file',
514 188 => 'scorm_object',
515 189 => 'search_data',
516 190 => 'shib_role_assignment',
517 191 => 'skl_level',
518 192 => 'skl_profile',
519 193 => 'skl_self_eval',
520 194 => 'skl_tree_node',
521 195 => 'sty_media_query',
522 196 => 'style_parameter',
523 197 => 'style_template',
524 198 => 'svy_anonymous',
525 199 => 'svy_answer',
526 200 => 'svy_category',
527 201 => 'svy_constraint',
528 202 => 'svy_finished',
529 203 => 'svy_inv_usr',
530 204 => 'svy_material',
531 205 => 'svy_phrase_cat',
532 206 => 'svy_phrase',
533 207 => 'svy_qblk_qst',
534 208 => 'svy_qblk',
535 209 => 'svy_qpl',
536 210 => 'svy_qst_constraint',
537 211 => 'svy_qst_matrixrows',
538 212 => 'svy_qst_oblig',
539 213 => 'svy_qtype',
540 214 => 'svy_question',
541 215 => 'svy_relation',
542 216 => 'svy_settings',
543 217 => 'svy_svy_qst',
544 218 => 'svy_svy',
545 219 => 'svy_times',
546 220 => 'svy_variable',
547 221 => 'sysc_groups',
548 222 => 'sysc_tasks',
549 223 => 'tax_node',
550 224 => 'tos_acceptance_track',
551 225 => 'tos_versions',
552 226 => 'tst_active',
553 227 => 'tst_manual_fb',
554 228 => 'tst_mark',
555 229 => 'tst_rnd_cpy',
556 230 => 'tst_rnd_qpl_title',
557 231 => 'tst_rnd_quest_set_qpls',
558 232 => 'tst_solutions',
559 233 => 'tst_test_defaults',
560 234 => 'tst_test_question',
561 235 => 'tst_test_result',
562 236 => 'tst_test_rnd_qst',
563 237 => 'tst_tests',
564 238 => 'tst_times',
565 239 => 'udf_definition',
566 240 => 'usr_account_codes',
567 241 => 'usr_data_multi',
568 242 => 'usr_ext_profile_page',
569 243 => 'usr_portfolio_page',
570 244 => 'webr_items',
571 245 => 'webr_params',
572 246 => 'write_event',
573 247 => 'xhtml_page',
574 248 => 'xmlnestedset',
575 249 => 'xmlnestedsettmp',
576 250 => 'xmltags',
577 251 => 'xmlvalue',
578 );
579
580 return array_values($array);
581 }
582
583
588 public function getNativeTableIndices($table_name = '', $fulltext = false) {
589 if ($fulltext) {
590 return array(
591 0 => 'i1',
592 1 => 'i2',
593 );
594 }
595
596 return array(
597 0 => 'i1',
598 );
599 }
600
601
605 public function getTableConstraints($table_name = '') {
606 return array(
607 0 => 'primary',
608 );
609 }
610
611
615 public function getTableFields() {
616 return array(
617 0 => 'id',
618 1 => 'is_online',
619 2 => 'is_default',
620 3 => 'latitude',
621 4 => 'longitude',
622 5 => 'elevation',
623 6 => 'address',
624 7 => 'init_mob_id',
625 8 => 'comment_mob_id',
626 9 => 'container_id',
627 10 => 'big_data',
628 );
629 }
630
631
636 public function getListTables($table_name) {
637 return array(
638 0 => 'abstraction_progress',
639 1 => 'acc_access_key',
640 2 => 'acc_cache',
641 3 => 'acc_user_access_key',
642 4 => 'acl_ws',
643 5 => 'addressbook_mlist',
644 6 => 'addressbook_mlist_ass',
645 7 => 'adl_shared_data',
646 8 => 'adm_set_templ_hide_tab',
647 9 => 'adm_set_templ_value',
648 10 => 'adm_settings_template',
649 11 => 'adv_md_obj_rec_select',
650 12 => 'adv_md_record',
651 13 => 'adv_md_record_objs',
652 14 => 'adv_md_substitutions',
653 15 => 'adv_md_values_date',
654 16 => 'adv_md_values_datetime',
655 17 => 'adv_md_values_float',
656 18 => 'adv_md_values_int',
657 19 => 'adv_md_values_location',
658 20 => 'adv_md_values_text',
659 21 => 'adv_mdf_definition',
660 22 => 'aicc_course',
661 23 => 'aicc_object',
662 24 => 'aicc_units',
663 25 => 'ass_log',
664 26 => 'background_task',
665 27 => 'badge_badge',
666 28 => 'badge_image_templ_type',
667 29 => 'badge_image_template',
668 30 => 'badge_user_badge',
669 31 => 'benchmark',
670 32 => 'booking_entry',
671 33 => 'booking_obj_assignment',
672 34 => 'booking_object',
673 35 => 'booking_reservation',
674 36 => 'booking_schedule',
675 37 => 'booking_schedule_slot',
676 38 => 'booking_settings',
677 39 => 'booking_user',
678 40 => 'bookmark_data',
679 41 => 'bookmark_tree',
680 42 => 'buddylist',
681 43 => 'buddylist_requests',
682 44 => 'cache_clob',
683 45 => 'cache_text',
684 46 => 'cal_auth_token',
685 47 => 'cal_cat_assignments',
686 48 => 'cal_categories',
687 49 => 'cal_categories_hidden',
688 50 => 'cal_ch_group',
689 51 => 'cal_ch_settings',
690 52 => 'cal_entries',
691 53 => 'cal_entry_responsible',
692 54 => 'cal_notification',
693 55 => 'cal_rec_exclusion',
694 56 => 'cal_recurrence_rules',
695 57 => 'cal_registrations',
696 58 => 'cal_shared',
697 59 => 'cal_shared_status',
698 60 => 'catch_write_events',
699 61 => 'chatroom_admconfig',
700 62 => 'chatroom_bans',
701 63 => 'chatroom_history',
702 64 => 'chatroom_proomaccess',
703 65 => 'chatroom_prooms',
704 66 => 'chatroom_psessions',
705 67 => 'chatroom_sessions',
706 68 => 'chatroom_settings',
707 69 => 'chatroom_smilies',
708 70 => 'chatroom_uploads',
709 71 => 'chatroom_users',
710 72 => 'cmi_comment',
711 73 => 'cmi_correct_response',
712 74 => 'cmi_custom',
713 75 => 'cmi_gobjective',
714 76 => 'cmi_interaction',
715 77 => 'cmi_node',
716 78 => 'cmi_objective',
717 79 => 'conditions',
718 80 => 'container_reference',
719 81 => 'container_settings',
720 82 => 'container_sorting',
721 83 => 'container_sorting_bl',
722 84 => 'container_sorting_set',
723 85 => 'content_object',
724 86 => 'copg_multilang',
725 87 => 'copg_multilang_lang',
726 88 => 'copg_pc_def',
727 89 => 'copg_pobj_def',
728 90 => 'copg_section_timings',
729 91 => 'copy_wizard_options',
730 92 => 'cp_auxilaryresource',
731 93 => 'cp_condition',
732 94 => 'cp_datamap',
733 95 => 'cp_dependency',
734 96 => 'cp_file',
735 97 => 'cp_hidelmsui',
736 98 => 'cp_item',
737 99 => 'cp_manifest',
738 100 => 'cp_mapinfo',
739 101 => 'cp_node',
740 102 => 'cp_objective',
741 103 => 'cp_organization',
742 104 => 'cp_package',
743 105 => 'cp_resource',
744 106 => 'cp_rule',
745 107 => 'cp_sequencing',
746 108 => 'cp_suspend',
747 109 => 'cp_tree',
748 110 => 'cron_job',
749 111 => 'crs_archives',
750 113 => 'crs_f_definitions',
751 114 => 'crs_file',
752 115 => 'crs_groupings',
753 116 => 'crs_items',
754 117 => 'crs_lm_history',
755 118 => 'crs_objective_lm',
756 119 => 'crs_objective_qst',
757 120 => 'crs_objective_status',
758 121 => 'crs_objective_status_p',
759 122 => 'crs_objective_tst',
760 123 => 'crs_objectives',
761 124 => 'crs_settings',
762 125 => 'crs_start',
763 126 => 'crs_timings_planed',
764 127 => 'crs_timings_usr_accept',
765 128 => 'crs_user_data',
766 129 => 'crs_waiting_list',
767 130 => 'ctrl_calls',
768 131 => 'ctrl_classfile',
769 132 => 'ctrl_structure',
770 133 => 'data_cache',
771 134 => 'dav_lock',
772 135 => 'dav_property',
773 136 => 'dbk_translations',
774 137 => 'desktop_item',
775 138 => 'didactic_tpl_a',
776 139 => 'didactic_tpl_abr',
777 140 => 'didactic_tpl_alp',
778 141 => 'didactic_tpl_alr',
779 142 => 'didactic_tpl_en',
780 143 => 'didactic_tpl_fp',
781 144 => 'didactic_tpl_objs',
782 145 => 'didactic_tpl_sa',
783 146 => 'didactic_tpl_settings',
784 147 => 'ecs_cmap_rule',
785 148 => 'ecs_cms_data',
786 149 => 'ecs_cms_tree',
787 150 => 'ecs_community',
788 151 => 'ecs_container_mapping',
789 152 => 'ecs_course_assignments',
790 153 => 'ecs_crs_mapping_atts',
791 154 => 'ecs_data_mapping',
792 155 => 'ecs_events',
793 156 => 'ecs_export',
794 157 => 'ecs_import',
795 158 => 'ecs_node_mapping_a',
796 159 => 'ecs_part_settings',
797 160 => 'ecs_remote_user',
798 161 => 'ecs_server',
799 162 => 'event',
800 163 => 'event_appointment',
801 164 => 'event_file',
802 165 => 'event_items',
803 166 => 'event_participants',
804 167 => 'exc_assignment',
805 168 => 'exc_assignment_peer',
806 169 => 'exc_crit',
807 170 => 'exc_crit_cat',
808 171 => 'exc_data',
809 172 => 'exc_idl',
810 173 => 'exc_mem_ass_status',
811 174 => 'exc_members',
812 175 => 'exc_returned',
813 176 => 'exc_usr_tutor',
814 177 => 'export_file_info',
815 178 => 'export_options',
816 179 => 'file_based_lm',
817 180 => 'file_data',
818 181 => 'file_usage',
819 182 => 'frm_data',
820 183 => 'frm_drafts_history',
821 184 => 'frm_notification',
822 185 => 'frm_posts',
823 186 => 'frm_posts_deleted',
824 187 => 'frm_posts_drafts',
825 188 => 'frm_posts_tree',
826 189 => 'frm_settings',
827 190 => 'frm_thread_access',
828 191 => 'frm_threads',
829 192 => 'frm_user_read',
830 193 => 'glo_advmd_col_order',
831 194 => 'glo_glossaries',
832 195 => 'glo_term_reference',
833 196 => 'glossary',
834 197 => 'glossary_definition',
835 198 => 'glossary_term',
836 199 => 'grp_settings',
837 200 => 'help_map',
838 201 => 'help_module',
839 202 => 'help_tooltip',
840 203 => 'history',
841 204 => 'il_bibl_attribute',
842 205 => 'il_bibl_data',
843 206 => 'il_bibl_entry',
844 207 => 'il_bibl_overview_model',
845 208 => 'il_bibl_settings',
846 209 => 'il_block_setting',
847 210 => 'il_blog',
848 211 => 'il_blog_posting',
849 212 => 'il_certificate',
850 213 => 'il_cld_data',
851 214 => 'il_component',
852 215 => 'il_custom_block',
853 216 => 'il_dcl_data',
854 217 => 'il_dcl_datatype',
855 218 => 'il_dcl_datatype_prop',
856 219 => 'il_dcl_field',
857 220 => 'il_dcl_field_prop',
858 221 => 'il_dcl_field_prop_b',
859 222 => 'il_dcl_field_prop_s_b',
860 223 => 'il_dcl_record',
861 224 => 'il_dcl_record_field',
862 225 => 'il_dcl_stloc1_value',
863 226 => 'il_dcl_stloc2_value',
864 227 => 'il_dcl_stloc3_value',
865 228 => 'il_dcl_table',
866 229 => 'il_dcl_tableview',
867 230 => 'il_dcl_tfield_set',
868 231 => 'il_dcl_tview_set',
869 232 => 'il_disk_quota',
870 233 => 'il_event_handling',
871 234 => 'il_exc_team',
872 235 => 'il_exc_team_log',
873 236 => 'il_external_feed_block',
874 237 => 'il_gc_memcache_server',
875 238 => 'il_html_block',
876 239 => 'il_md_cpr_selections',
877 240 => 'il_media_cast_data',
878 241 => 'il_media_cast_data_ord',
879 242 => 'il_meta_annotation',
880 243 => 'il_meta_classification',
881 244 => 'il_meta_contribute',
882 245 => 'il_meta_description',
883 246 => 'il_meta_educational',
884 247 => 'il_meta_entity',
885 248 => 'il_meta_format',
886 249 => 'il_meta_general',
887 250 => 'il_meta_identifier',
888 251 => 'il_meta_identifier_',
889 252 => 'il_meta_keyword',
890 253 => 'il_meta_language',
891 254 => 'il_meta_lifecycle',
892 255 => 'il_meta_location',
893 256 => 'il_meta_meta_data',
894 257 => 'il_meta_relation',
895 258 => 'il_meta_requirement',
896 259 => 'il_meta_rights',
897 260 => 'il_meta_tar',
898 261 => 'il_meta_taxon',
899 262 => 'il_meta_taxon_path',
900 263 => 'il_meta_technical',
901 264 => 'il_new_item_grp',
902 265 => 'il_news_item',
903 266 => 'il_news_read',
904 267 => 'il_news_subscription',
905 268 => 'il_object_def',
906 269 => 'il_object_group',
907 270 => 'il_object_sub_type',
908 271 => 'il_object_subobj',
909 272 => 'il_plugin',
910 273 => 'il_pluginslot',
911 274 => 'il_poll',
912 275 => 'il_poll_answer',
913 276 => 'il_poll_vote',
914 277 => 'il_qpl_qst_fq_res',
915 278 => 'il_qpl_qst_fq_res_unit',
916 279 => 'il_qpl_qst_fq_ucat',
917 280 => 'il_qpl_qst_fq_unit',
918 281 => 'il_qpl_qst_fq_var',
919 282 => 'il_rating',
920 283 => 'il_rating_cat',
921 284 => 'il_request_token',
922 285 => 'il_subscribers',
923 286 => 'il_tag',
924 287 => 'il_translations',
925 288 => $table_name,
926 289 => 'il_verification',
927 290 => 'il_wac_secure_path',
928 291 => 'il_wiki_contributor',
929 292 => 'il_wiki_data',
930 293 => 'il_wiki_imp_pages',
931 294 => 'il_wiki_missing_page',
932 295 => 'il_wiki_page',
933 296 => 'int_link',
934 297 => 'item_group_item',
935 298 => 'itgr_data',
936 299 => 'last_visited',
937 300 => 'ldap_attribute_mapping',
938 301 => 'ldap_rg_mapping',
939 302 => 'ldap_role_assignments',
940 303 => 'ldap_server_settings',
941 304 => 'license_data',
942 305 => 'link_check',
943 306 => 'link_check_report',
944 307 => 'lm_data',
945 308 => 'lm_data_transl',
946 309 => 'lm_glossaries',
947 310 => 'lm_menu',
948 311 => 'lm_read_event',
949 312 => 'lm_tree',
950 313 => 'lng_data',
951 314 => 'lng_log',
952 315 => 'lng_modules',
953 316 => 'lo_access',
954 317 => 'loc_rnd_qpl',
955 318 => 'loc_settings',
956 319 => 'loc_tst_assignments',
957 320 => 'loc_tst_run',
958 321 => 'loc_user_results',
959 322 => 'log_components',
960 323 => 'loginname_history',
961 324 => 'mail',
962 325 => 'mail_attachment',
963 326 => 'mail_cron_orphaned',
964 327 => 'mail_man_tpl',
965 328 => 'mail_obj_data',
966 329 => 'mail_options',
967 330 => 'mail_saved',
968 331 => 'mail_template',
969 332 => 'mail_tpl_ctx',
970 333 => 'mail_tree',
971 334 => 'map_area',
972 335 => 'mass_info_settings',
973 336 => 'mass_members',
974 337 => 'mass_settings',
975 338 => 'media_item',
976 339 => 'member_agreement',
977 340 => 'member_noti',
978 341 => 'member_noti_user',
979 342 => 'mep_data',
980 343 => 'mep_item',
981 344 => 'mep_tree',
982 345 => 'mob_parameter',
983 346 => 'mob_usage',
984 347 => 'module_class',
985 348 => 'note',
986 349 => 'note_settings',
987 350 => 'notification',
988 351 => 'notification_channels',
989 352 => 'notification_data',
990 353 => 'notification_listener',
991 354 => 'notification_osd',
992 355 => 'notification_queue',
993 356 => 'notification_types',
994 357 => 'notification_usercfg',
995 358 => 'obj_content_master_lng',
996 359 => 'obj_lp_stat',
997 360 => 'obj_members',
998 361 => 'obj_stat',
999 362 => 'obj_stat_log',
1000 363 => 'obj_stat_tmp',
1001 364 => 'obj_type_stat',
1002 365 => 'obj_user_data_hist',
1003 366 => 'obj_user_stat',
1004 367 => 'object_data',
1005 368 => 'object_data_del',
1006 369 => 'object_description',
1007 370 => 'object_reference',
1008 371 => 'object_reference_ws',
1009 372 => 'object_translation',
1010 373 => 'openid_provider',
1011 374 => 'orgu_data',
1012 375 => 'orgu_path_storage',
1013 376 => 'orgu_types',
1014 377 => 'orgu_types_adv_md_rec',
1015 378 => 'orgu_types_trans',
1016 379 => 'osc_activity',
1017 380 => 'osc_conversation',
1018 381 => 'osc_messages',
1019 382 => 'page_anchor',
1020 383 => 'page_editor_settings',
1021 384 => 'page_history',
1022 385 => 'page_layout',
1023 386 => 'page_object',
1024 387 => 'page_pc_usage',
1025 388 => 'page_qst_answer',
1026 389 => 'page_question',
1027 390 => 'page_style_usage',
1028 391 => 'personal_clipboard',
1029 392 => 'personal_pc_clipboard',
1030 393 => 'pg_amd_page_list',
1031 394 => 'preview_data',
1032 395 => 'prg_settings',
1033 396 => 'prg_translations',
1034 397 => 'prg_type',
1035 398 => 'prg_type_adv_md_rec',
1036 399 => 'prg_usr_assignments',
1037 400 => 'prg_usr_progress',
1038 401 => 'qpl_a_cloze',
1039 402 => 'qpl_a_cloze_combi_res',
1040 403 => 'qpl_a_errortext',
1041 404 => 'qpl_a_essay',
1042 405 => 'qpl_a_imagemap',
1043 406 => 'qpl_a_kprim',
1044 407 => 'qpl_a_lome',
1045 408 => 'qpl_a_matching',
1046 409 => 'qpl_a_mc',
1047 410 => 'qpl_a_mdef',
1048 411 => 'qpl_a_mterm',
1049 412 => 'qpl_a_ordering',
1050 413 => 'qpl_a_sc',
1051 414 => 'qpl_a_textsubset',
1052 415 => 'qpl_fb_generic',
1053 416 => 'qpl_fb_specific',
1054 417 => 'qpl_hint_tracking',
1055 418 => 'qpl_hints',
1056 419 => 'qpl_num_range',
1057 420 => 'qpl_qst_cloze',
1058 421 => 'qpl_qst_errortext',
1059 422 => 'qpl_qst_essay',
1060 423 => 'qpl_qst_fileupload',
1061 424 => 'qpl_qst_flash',
1062 425 => 'qpl_qst_horder',
1063 426 => 'qpl_qst_imagemap',
1064 427 => 'qpl_qst_javaapplet',
1065 428 => 'qpl_qst_kprim',
1066 429 => 'qpl_qst_lome',
1067 430 => 'qpl_qst_matching',
1068 431 => 'qpl_qst_mc',
1069 432 => 'qpl_qst_numeric',
1070 433 => 'qpl_qst_ordering',
1071 434 => 'qpl_qst_sc',
1072 435 => 'qpl_qst_skl_assigns',
1073 436 => 'qpl_qst_skl_sol_expr',
1074 437 => 'qpl_qst_textsubset',
1075 438 => 'qpl_qst_type',
1076 439 => 'qpl_questionpool',
1077 440 => 'qpl_questions',
1078 441 => 'qpl_sol_sug',
1079 442 => 'rbac_fa',
1080 443 => 'rbac_log',
1081 444 => 'rbac_operations',
1082 445 => 'rbac_pa',
1083 446 => 'rbac_ta',
1084 447 => 'rbac_templates',
1085 448 => 'rbac_ua',
1086 449 => 'rcat_settings',
1087 450 => 'read_event',
1088 451 => 'reg_access_limit',
1089 452 => 'reg_er_assignments',
1090 453 => 'reg_registration_codes',
1091 454 => 'remote_course_settings',
1092 464 => 'rfil_settings',
1093 465 => 'rglo_settings',
1094 466 => 'rgrp_settings',
1095 467 => 'rlm_settings',
1096 468 => 'role_data',
1097 469 => 'role_desktop_items',
1098 470 => 'rtst_settings',
1099 471 => 'rwik_settings',
1100 472 => 'sahs_lm',
1101 473 => 'sahs_sc13_sco',
1102 474 => 'sahs_sc13_seq_assign',
1103 475 => 'sahs_sc13_seq_cond',
1104 476 => 'sahs_sc13_seq_course',
1105 477 => 'sahs_sc13_seq_item',
1106 478 => 'sahs_sc13_seq_mapinfo',
1107 479 => 'sahs_sc13_seq_node',
1108 480 => 'sahs_sc13_seq_obj',
1109 481 => 'sahs_sc13_seq_rule',
1110 482 => 'sahs_sc13_seq_templ',
1111 483 => 'sahs_sc13_seq_templts',
1112 484 => 'sahs_sc13_seq_tree',
1113 485 => 'sahs_sc13_tree',
1114 486 => 'sahs_sc13_tree_node',
1115 487 => 'sahs_user',
1116 488 => 'sc_item',
1117 489 => 'sc_manifest',
1118 490 => 'sc_organization',
1119 491 => 'sc_organizations',
1120 492 => 'sc_resource',
1121 493 => 'sc_resource_dependen',
1122 494 => 'sc_resource_file',
1123 495 => 'sc_resources',
1124 496 => 'scorm_object',
1125 497 => 'scorm_tracking',
1126 498 => 'scorm_tree',
1127 499 => 'search_command_queue',
1128 500 => 'search_data',
1129 501 => 'service_class',
1130 502 => 'settings',
1131 503 => 'settings_deactivated_s',
1132 504 => 'shib_role_assignment',
1133 505 => 'skl_assigned_material',
1134 506 => 'skl_level',
1135 507 => 'skl_personal_skill',
1136 508 => 'skl_profile',
1137 509 => 'skl_profile_level',
1138 510 => 'skl_profile_user',
1139 511 => 'skl_self_eval',
1140 512 => 'skl_self_eval_level',
1141 513 => 'skl_skill_resource',
1142 514 => 'skl_templ_ref',
1143 515 => 'skl_tree',
1144 516 => 'skl_tree_node',
1145 517 => 'skl_usage',
1146 518 => 'skl_user_has_level',
1147 519 => 'skl_user_skill_level',
1148 520 => 'sty_media_query',
1149 521 => 'style_char',
1150 522 => 'style_color',
1151 523 => 'style_data',
1152 524 => 'style_folder_styles',
1153 525 => 'style_parameter',
1154 526 => 'style_setting',
1155 527 => 'style_template',
1156 528 => 'style_template_class',
1157 529 => 'style_usage',
1158 530 => 'svy_360_appr',
1159 531 => 'svy_360_rater',
1160 532 => 'svy_anonymous',
1161 533 => 'svy_answer',
1162 534 => 'svy_category',
1163 535 => 'svy_constraint',
1164 536 => 'svy_finished',
1165 537 => 'svy_inv_usr',
1166 538 => 'svy_material',
1167 539 => 'svy_phrase',
1168 540 => 'svy_phrase_cat',
1169 541 => 'svy_qblk',
1170 542 => 'svy_qblk_qst',
1171 543 => 'svy_qpl',
1172 544 => 'svy_qst_constraint',
1173 545 => 'svy_qst_matrix',
1174 546 => 'svy_qst_matrixrows',
1175 547 => 'svy_qst_mc',
1176 548 => 'svy_qst_metric',
1177 549 => 'svy_qst_oblig',
1178 550 => 'svy_qst_sc',
1179 551 => 'svy_qst_text',
1180 552 => 'svy_qtype',
1181 553 => 'svy_quest_skill',
1182 554 => 'svy_question',
1183 555 => 'svy_relation',
1184 556 => 'svy_settings',
1185 557 => 'svy_skill_threshold',
1186 558 => 'svy_svy',
1187 559 => 'svy_svy_qst',
1188 560 => 'svy_times',
1189 561 => 'svy_variable',
1190 562 => 'sysc_groups',
1191 563 => 'sysc_tasks',
1192 564 => 'syst_style_cat',
1193 565 => 'table_properties',
1194 566 => 'table_templates',
1195 567 => 'tax_data',
1196 568 => 'tax_node',
1197 569 => 'tax_node_assignment',
1198 570 => 'tax_tree',
1199 571 => 'tax_usage',
1200 572 => 'tos_acceptance_track',
1201 573 => 'tos_versions',
1202 574 => 'tree',
1203 575 => 'tree_workspace',
1204 576 => 'tst_active',
1205 577 => 'tst_addtime',
1206 578 => 'tst_dyn_quest_set_cfg',
1207 579 => 'tst_invited_user',
1208 580 => 'tst_manual_fb',
1209 581 => 'tst_mark',
1210 582 => 'tst_pass_result',
1211 583 => 'tst_qst_solved',
1212 584 => 'tst_result_cache',
1213 585 => 'tst_rnd_cpy',
1214 586 => 'tst_rnd_qpl_title',
1215 587 => 'tst_rnd_quest_set_cfg',
1216 588 => 'tst_rnd_quest_set_qpls',
1217 589 => 'tst_seq_qst_answstatus',
1218 590 => 'tst_seq_qst_checked',
1219 591 => 'tst_seq_qst_optional',
1220 592 => 'tst_seq_qst_postponed',
1221 593 => 'tst_seq_qst_tracking',
1222 594 => 'tst_sequence',
1223 595 => 'tst_skl_thresholds',
1224 596 => 'tst_solutions',
1225 597 => 'tst_test_defaults',
1226 598 => 'tst_test_question',
1227 599 => 'tst_test_result',
1228 600 => 'tst_test_rnd_qst',
1229 601 => 'tst_tests',
1230 602 => 'tst_times',
1231 603 => 'udf_clob',
1232 604 => 'udf_data',
1233 605 => 'udf_definition',
1234 606 => 'udf_text',
1235 607 => 'user_action_activation',
1236 608 => 'usr_account_codes',
1237 609 => 'usr_cron_mail_reminder',
1238 610 => 'usr_data',
1239 611 => 'usr_data_multi',
1240 612 => 'usr_ext_profile_page',
1241 613 => 'usr_form_settings',
1242 614 => 'usr_portf_acl',
1243 615 => 'usr_portfolio',
1244 616 => 'usr_portfolio_page',
1245 617 => 'usr_pref',
1246 618 => 'usr_pwassist',
1247 619 => 'usr_search',
1248 620 => 'usr_sess_istorage',
1249 621 => 'usr_session',
1250 622 => 'usr_session_log',
1251 623 => 'usr_session_stats',
1252 624 => 'usr_session_stats_raw',
1253 625 => 'ut_lp_coll_manual',
1254 626 => 'ut_lp_collections',
1255 627 => 'ut_lp_defaults',
1256 628 => 'ut_lp_marks',
1257 629 => 'ut_lp_settings',
1258 630 => 'ut_lp_user_status',
1259 631 => 'ut_online',
1260 632 => 'webr_items',
1261 633 => 'webr_params',
1262 634 => 'wfe_det_listening',
1263 635 => 'wfe_startup_events',
1264 636 => 'wfe_static_inputs',
1265 637 => 'wfe_workflows',
1266 638 => 'wiki_page_template',
1267 639 => 'wiki_stat',
1268 640 => 'wiki_stat_page',
1269 641 => 'wiki_stat_page_user',
1270 642 => 'wiki_stat_user',
1271 643 => 'wiki_user_html_export',
1272 644 => 'write_event',
1273 645 => 'xhtml_page',
1274 648 => 'xmlnestedset',
1275 649 => 'xmlnestedsettmp',
1276 650 => 'xmlparam',
1277 651 => 'xmltags',
1278 652 => 'xmlvalue',
1279 );
1280 }
1281}
php
An exception for terminatinating execution or to throw for unit testing.
ilDatabaseCommonTestsDataOutputs
Class ilDatabaseCommonTestsDataOutputs.
Definition: class.ilDatabaseCommonTestsDataOutputs.php:8
ilDatabaseCommonTestsDataOutputs\getCreationQueryBuildByILIAS
getCreationQueryBuildByILIAS($table_name)
ilDatabaseCommonTestsDataOutputs\getIndexInfo
getIndexInfo($with_fulltext=false, $table_name='')
Definition: class.ilDatabaseCommonTestsDataOutputs.php:15