ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
class.ilDatabaseCommonTestsDataOutputs.php
Go to the documentation of this file.
1 <?php
2 
8 abstract 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 }
ilDatabaseCommonTestsDataOutputs\getCreationQueryBuildByILIAS
getCreationQueryBuildByILIAS($table_name)
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
ilDatabaseCommonTestsDataOutputs\getIndexInfo
getIndexInfo($with_fulltext=false, $table_name='')
Definition: class.ilDatabaseCommonTestsDataOutputs.php:15
ilDatabaseCommonTestsDataOutputs
Class ilDatabaseCommonTestsDataOutputs.
Definition: class.ilDatabaseCommonTestsDataOutputs.php:8