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