ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
class.ilDatabasePostgresTestsDataOutputs.php
Go to the documentation of this file.
1 <?php
2 require_once('./Services/Database/test/Implementations/data/class.ilDatabaseCommonTestsDataOutputs.php');
3 
9 class ilDatabasePostgresTestsDataOutputs extends ilDatabaseCommonTestsDataOutputs {
10 
15  public function getCreationQueryBuildByILIAS($table_name) {
16  return "CREATE TABLE $table_name (id INT NOT NULL, is_online SMALLINT DEFAULT NULL, is_default SMALLINT DEFAULT 1, latitude FLOAT8 DEFAULT NULL, longitude FLOAT8 DEFAULT NULL, elevation FLOAT8 DEFAULT NULL, address VARCHAR(256) DEFAULT NULL NULL, init_mob_id INT DEFAULT NULL, comment_mob_id INT DEFAULT NULL, container_id INT DEFAULT NULL, big_data TEXT)";
17  }
18 
19 
23  public function getPrimaryInfo($table_name = '') {
24  return array(
25  'name' => $table_name . '_pk',
26  'fields' => array(
27  'id' => array(
28  'position' => 1,
29  'sorting' => 'ascending',
30  ),
31  ),
32  );
33  }
34 
35 
41  public function getIndexInfo($with_fulltext = false, $table_name = '') {
42  return array(
43  0 => array(
44  'name' => $table_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 
61  public function getTableConstraints($table_name = '') {
62  return array(
63  0 => $table_name . '_pk',
64  );
65  }
66 
67 
72  public function getNativeTableIndices($table_name = '', $fulltext = false) {
73  if ($fulltext) {
74  return array(
75  0 => $table_name . '_i1',
76  1 => $table_name . '_i2',
77  );
78  }
79 
80  return array(
81  0 => $table_name . '_i1',
82  );
83  }
84 
85 
86  public function getTableFieldDefinition() {
87  return array(
88  0 => array(
89  'notnull' => false,
90  'nativetype' => 'int4',
91  'length' => 4,
92  'unsigned' => false,
93  'default' => null,
94  'type' => 'integer',
95  'mdb2type' => 'integer',
96  ),
97  );
98  }
99 
100 
105  public function getListTables($table_name) {
106  $tables = parent::getListTables($table_name);
107  unset($tables[0]);
108  return $tables;
109  }
110 
111 
116  public function getTableSequences($table_name) {
117  return array(
118  0 => 'addressbook_mlist',
119  1 => 'addressbook_mlist_ass',
120  2 => 'adm_settings_template',
121  3 => 'adv_md_record',
122  4 => 'adv_mdf_definition',
123  5 => 'aicc_object',
124  6 => 'aicc_units',
125  7 => 'ass_log',
126  8 => 'benchmark',
127  9 => 'booking_entry',
128  10 => 'booking_object',
129  11 => 'booking_reservation',
130  12 => 'booking_reservation_group',
131  13 => 'booking_schedule',
132  14 => 'bookmark_data',
133  15 => 'bookmark_social_bm',
134  16 => 'cal_categories',
135  17 => 'cal_ch_group',
136  18 => 'cal_entries',
137  19 => 'cal_notification',
138  20 => 'cal_rec_exclusion',
139  21 => 'cal_recurrence_rules',
140  22 => 'chatroom_admconfig',
141  23 => 'chatroom_history',
142  24 => 'chatroom_prooms',
143  25 => 'chatroom_psessions',
144  26 => 'chatroom_sessions',
145  27 => 'chatroom_settings',
146  28 => 'chatroom_smilies',
147  29 => 'chatroom_uploads',
148  30 => 'cmi_comment',
149  31 => 'cmi_correct_response',
150  32 => 'cmi_interaction',
151  33 => 'cmi_node',
152  34 => 'cmi_objective',
153  35 => 'conditions',
154  36 => 'cp_node',
155  37 => 'crs_archives',
156  38 => 'crs_f_definitions',
157  39 => 'crs_file',
158  40 => 'crs_objective_lm',
159  41 => 'crs_objective_qst',
160  42 => 'crs_objective_tst',
161  43 => 'crs_objectives',
162  44 => 'crs_start',
163  45 => 'didactic_tpl_a',
164  46 => 'didactic_tpl_fp',
165  47 => 'didactic_tpl_settings',
166  48 => 'ecs_cmap_rule',
167  49 => 'ecs_cms_data',
168  50 => 'ecs_container_mapping',
169  51 => 'ecs_course_assignments',
170  52 => 'ecs_crs_mapping_atts',
171  53 => 'ecs_events',
172  54 => 'ecs_remote_user',
173  55 => 'ecs_server',
174  56 => 'event',
175  57 => 'event_appointment',
176  58 => 'event_file',
177  59 => 'exc_assignment',
178  60 => 'exc_crit',
179  61 => 'exc_crit_cat',
180  62 => 'exc_returned',
181  63 => 'frm_data',
182  64 => 'frm_notification',
183  65 => 'frm_posts',
184  66 => 'frm_posts_deleted',
185  67 => 'frm_posts_tree',
186  68 => 'frm_threads',
187  69 => 'glossary_definition',
188  70 => 'glossary_term',
189  71 => 'help_module',
190  72 => 'help_tooltip',
191  73 => 'history',
192  74 => 'il_bibl_attribute',
193  75 => 'il_bibl_entry',
194  76 => 'il_bibl_settings',
195  77 => 'il_blog_posting',
196  78 => 'il_custom_block',
197  79 => 'il_dcl_data',
198  80 => 'il_dcl_field',
199  81 => 'il_dcl_field_prop_s_b',
200  82 => 'il_dcl_record',
201  83 => 'il_dcl_record_field',
202  84 => 'il_dcl_stloc1_value',
203  85 => 'il_dcl_stloc2_value',
204  86 => 'il_dcl_stloc3_value',
205  87 => 'il_dcl_table',
206  88 => 'il_dcl_view',
207  89 => 'il_exc_team',
208  90 => 'il_exc_team_log',
209  91 => 'il_external_feed_block',
210  92 => 'il_gc_memcache_server',
211  93 => 'il_md_cpr_selections',
212  94 => 'il_meta_annotation',
213  95 => 'il_meta_classification',
214  96 => 'il_meta_contribute',
215  97 => 'il_meta_description',
216  98 => 'il_meta_educational',
217  99 => 'il_meta_entity',
218  100 => 'il_meta_format',
219  101 => 'il_meta_general',
220  102 => 'il_meta_identifier',
221  103 => 'il_meta_identifier_',
222  104 => 'il_meta_keyword',
223  105 => 'il_meta_language',
224  106 => 'il_meta_lifecycle',
225  107 => 'il_meta_location',
226  108 => 'il_meta_meta_data',
227  109 => 'il_meta_relation',
228  110 => 'il_meta_requirement',
229  111 => 'il_meta_rights',
230  112 => 'il_meta_tar',
231  113 => 'il_meta_taxon',
232  114 => 'il_meta_taxon_path',
233  115 => 'il_meta_technical',
234  116 => 'il_new_item_grp',
235  117 => 'il_news_item',
236  118 => 'il_poll_answer',
237  119 => 'il_qpl_qst_fq_res',
238  120 => 'il_qpl_qst_fq_res_unit',
239  121 => 'il_qpl_qst_fq_ucat',
240  122 => 'il_qpl_qst_fq_unit',
241  123 => 'il_qpl_qst_fq_var',
242  124 => 'il_rating_cat',
243  125 => $table_name,
244  126 => 'il_wiki_page',
245  127 => 'ldap_rg_mapping',
246  128 => 'ldap_role_assignments',
247  129 => 'ldap_server_settings',
248  130 => 'link_check',
249  131 => 'lm_data',
250  132 => 'lm_menu',
251  133 => 'loc_tst_assignments',
252  134 => 'mail',
253  135 => 'mail_man_tpl',
254  136 => 'mail_obj_data',
255  137 => 'media_item',
256  138 => 'mep_item',
257  139 => 'note',
258  140 => 'notification_data',
259  141 => 'notification_osd',
260  142 => 'obj_stat_log',
261  143 => 'object_data',
262  144 => 'object_reference',
263  145 => 'object_reference_ws',
264  146 => 'openid_provider',
265  147 => 'orgu_types',
266  148 => 'page_layout',
267  149 => 'page_style_usage',
268  150 => 'pg_amd_page_list',
269  151 => 'prg_settings',
270  152 => 'prg_translations',
271  153 => 'prg_type',
272  154 => 'prg_type_adv_md_rec',
273  155 => 'prg_usr_assignments',
274  156 => 'prg_usr_progress',
275  157 => 'qpl_a_cloze',
276  158 => 'qpl_a_errortext',
277  159 => 'qpl_a_essay',
278  160 => 'qpl_a_imagemap',
279  161 => 'qpl_a_matching',
280  162 => 'qpl_a_mc',
281  163 => 'qpl_a_mdef',
282  164 => 'qpl_a_mterm',
283  165 => 'qpl_a_ordering',
284  166 => 'qpl_a_sc',
285  167 => 'qpl_a_textsubset',
286  168 => 'qpl_fb_generic',
287  169 => 'qpl_fb_specific',
288  170 => 'qpl_hint_tracking',
289  171 => 'qpl_hints',
290  172 => 'qpl_num_range',
291  173 => 'qpl_questionpool',
292  174 => 'qpl_questions',
293  175 => 'qpl_sol_sug',
294  176 => 'rbac_log',
295  177 => 'rbac_operations',
296  178 => 'reg_er_assignments',
297  179 => 'reg_registration_codes',
298  180 => 'role_desktop_items',
299  181 => 'sahs_sc13_seq_node',
300  182 => 'sahs_sc13_seq_templts',
301  183 => 'sahs_sc13_tree_node',
302  184 => 'sc_resource_dependen',
303  185 => 'sc_resource_file',
304  186 => 'scorm_object',
305  187 => 'search_data',
306  188 => 'shib_role_assignment',
307  189 => 'skl_level',
308  190 => 'skl_profile',
309  191 => 'skl_self_eval',
310  192 => 'skl_tree_node',
311  193 => 'sty_media_query',
312  194 => 'style_parameter',
313  195 => 'style_template',
314  196 => 'svy_anonymous',
315  197 => 'svy_answer',
316  198 => 'svy_category',
317  199 => 'svy_constraint',
318  200 => 'svy_finished',
319  201 => 'svy_inv_usr',
320  202 => 'svy_material',
321  203 => 'svy_phrase',
322  204 => 'svy_phrase_cat',
323  205 => 'svy_qblk',
324  206 => 'svy_qblk_qst',
325  207 => 'svy_qpl',
326  208 => 'svy_qst_constraint',
327  209 => 'svy_qst_matrixrows',
328  210 => 'svy_qst_oblig',
329  211 => 'svy_qtype',
330  212 => 'svy_question',
331  213 => 'svy_relation',
332  214 => 'svy_settings',
333  215 => 'svy_svy',
334  216 => 'svy_svy_qst',
335  217 => 'svy_times',
336  218 => 'svy_variable',
337  219 => 'sysc_groups',
338  220 => 'sysc_tasks',
339  221 => 'tax_node',
340  222 => 'tos_acceptance_track',
341  223 => 'tos_versions',
342  224 => 'tst_active',
343  225 => 'tst_manual_fb',
344  226 => 'tst_mark',
345  227 => 'tst_rnd_cpy',
346  228 => 'tst_rnd_qpl_title',
347  229 => 'tst_rnd_quest_set_qpls',
348  230 => 'tst_solutions',
349  231 => 'tst_test_defaults',
350  232 => 'tst_test_question',
351  233 => 'tst_test_result',
352  234 => 'tst_test_rnd_qst',
353  235 => 'tst_tests',
354  236 => 'tst_times',
355  237 => 'udf_definition',
356  238 => 'usr_account_codes',
357  239 => 'usr_data_multi',
358  240 => 'usr_ext_profile_page',
359  241 => 'usr_portfolio_page',
360  242 => 'webr_items',
361  243 => 'webr_params',
362  244 => 'write_event',
363  245 => 'xhtml_page',
364  246 => 'xmlnestedset',
365  247 => 'xmlnestedsettmp',
366  248 => 'xmltags',
367  249 => 'xmlvalue',
368  );
369  }
370 }
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
ilDatabaseCommonTestsDataOutputs
Class ilDatabaseCommonTestsDataOutputs.
Definition: class.ilDatabaseCommonTestsDataOutputs.php:8