dbXapp 2.0
RAD, CMS, Module und Runtime-IDE fuer dbXapp
Loading...
Searching...
No Matches
dbxMedia.dd.php
Go to the documentation of this file.
1<?php
2
3/* =========================================================
4 TABLE
5 ========================================================= */
6$table['server']='dbxMedia.db3';
7$table['table']='media';
8$table['datadic']='dbxMedia';
9$table['primary']='';
10$table['language']='0';
11$table['version']='1.0';
12$table['autosync']='0';
13$table['cache']='0';
14$table['trash']='1';
15$table['trace']='1';
16$table['update_sql']='';
17$table['default_sort']='title';
18$table['form-dd-table']='';
19$table['read']='*';
20$table['create']='admin';
21$table['update']='admin';
22$table['delete']='admin';
23$table['read_owner']='*';
24$table['create_owner']='owner,admin';
25$table['update_owner']='owner,admin';
26$table['delete_owner']='owner,admin';
27
28
29/* =========================================================
30 FIELDS
31 ========================================================= */
32$field['name']='id';
33$field['type']='int';
34$field['index']='PRI';
35$field['length']='11';
36$field['default']='';
37$field['label']='id';
38$field['rules']='int';
39$field['tooltip']='';
40$field['errormsg']='';
41$field['placeholder']='';
42$field['convert']='';
43$field['protect']='0';
44$field['group']='';
45$field['mask']='';
46$field['data']='';
47$field['options']='';
48$field['tpl']='';
49$field['js']='';
50$field['prompt']='';
51$fields[]=$field;
52
53$field['name']='create_date';
54$field['type']='datetime';
55$field['index']='';
56$field['length']='-1';
57$field['default']='';
58$field['label']='create_date';
59$field['rules']='datetime';
60$field['tooltip']='';
61$field['errormsg']='';
62$field['placeholder']='';
63$field['convert']='';
64$field['protect']='0';
65$field['group']='';
66$field['mask']='';
67$field['data']='';
68$field['options']='';
69$field['tpl']='';
70$field['js']='';
71$field['prompt']='';
72$fields[]=$field;
73
74$field['name']='create_uid';
75$field['type']='int';
76$field['index']='';
77$field['length']='11';
78$field['default']='0';
79$field['label']='create_uid';
80$field['rules']='int';
81$field['tooltip']='';
82$field['errormsg']='';
83$field['placeholder']='';
84$field['convert']='';
85$field['protect']='0';
86$field['group']='';
87$field['mask']='';
88$field['data']='';
89$field['options']='';
90$field['tpl']='';
91$field['js']='';
92$field['prompt']='';
93$fields[]=$field;
94
95$field['name']='update_date';
96$field['type']='datetime';
97$field['index']='';
98$field['length']='-1';
99$field['default']='';
100$field['label']='update_date';
101$field['rules']='datetime';
102$field['tooltip']='';
103$field['errormsg']='';
104$field['placeholder']='';
105$field['convert']='';
106$field['protect']='0';
107$field['group']='';
108$field['mask']='';
109$field['data']='';
110$field['options']='';
111$field['tpl']='';
112$field['js']='';
113$field['prompt']='';
114$fields[]=$field;
115
116$field['name']='update_uid';
117$field['type']='int';
118$field['index']='';
119$field['length']='11';
120$field['default']='0';
121$field['label']='update_uid';
122$field['rules']='int';
123$field['tooltip']='';
124$field['errormsg']='';
125$field['placeholder']='';
126$field['convert']='';
127$field['protect']='0';
128$field['group']='';
129$field['mask']='';
130$field['data']='';
131$field['options']='';
132$field['tpl']='';
133$field['js']='';
134$field['prompt']='';
135$fields[]=$field;
136
137$field['name']='owner';
138$field['type']='int';
139$field['index']='';
140$field['length']='11';
141$field['default']='';
142$field['label']='owner';
143$field['rules']='int';
144$field['tooltip']='';
145$field['errormsg']='';
146$field['placeholder']='';
147$field['convert']='';
148$field['protect']='0';
149$field['group']='';
150$field['mask']='';
151$field['data']='';
152$field['options']='';
153$field['tpl']='';
154$field['js']='';
155$field['prompt']='';
156$fields[]=$field;
157
158$field['name']='active';
159$field['type']='int';
160$field['index']='';
161$field['length']='1';
162$field['default']='1';
163$field['label']='active';
164$field['rules']='int';
165$field['tooltip']='';
166$field['errormsg']='';
167$field['placeholder']='';
168$field['convert']='';
169$field['protect']='0';
170$field['group']='';
171$field['mask']='';
172$field['data']='';
173$field['options']='';
174$field['tpl']='';
175$field['js']='';
176$field['prompt']='';
177$fields[]=$field;
178
179$field['name']='content_id';
180$field['type']='int';
181$field['index']='MUL';
182$field['length']='11';
183$field['default']='0';
184$field['label']='content_id';
185$field['rules']='int';
186$field['tooltip']='';
187$field['errormsg']='';
188$field['placeholder']='';
189$field['convert']='';
190$field['protect']='0';
191$field['group']='';
192$field['mask']='';
193$field['data']='';
194$field['options']='';
195$field['tpl']='';
196$field['js']='';
197$field['prompt']='';
198$fields[]=$field;
199
200$field['name']='folder_id';
201$field['type']='int';
202$field['index']='MUL';
203$field['length']='11';
204$field['default']='0';
205$field['label']='folder_id';
206$field['rules']='int';
207$field['tooltip']='';
208$field['errormsg']='';
209$field['placeholder']='';
210$field['convert']='';
211$field['protect']='0';
212$field['group']='';
213$field['mask']='';
214$field['data']='';
215$field['options']='';
216$field['tpl']='';
217$field['js']='';
218$field['prompt']='';
219$fields[]=$field;
220
221$field['name']='slot';
222$field['type']='varchar';
223$field['index']='';
224$field['length']='32';
225$field['default']='gallery';
226$field['label']='slot';
227$field['rules']='varchar';
228$field['tooltip']='';
229$field['errormsg']='';
230$field['placeholder']='hero, gallery, teaser';
231$field['convert']='';
232$field['protect']='0';
233$field['group']='';
234$field['mask']='';
235$field['data']='';
236$field['options']='';
237$field['tpl']='';
238$field['js']='';
239$field['prompt']='';
240$fields[]=$field;
241
242$field['name']='title';
243$field['type']='varchar';
244$field['index']='';
245$field['length']='160';
246$field['default']='';
247$field['label']='title';
248$field['rules']='varchar';
249$field['tooltip']='';
250$field['errormsg']='';
251$field['placeholder']='';
252$field['convert']='';
253$field['protect']='0';
254$field['group']='';
255$field['mask']='';
256$field['data']='';
257$field['options']='';
258$field['tpl']='';
259$field['js']='';
260$field['prompt']='';
261$fields[]=$field;
262
263$field['name']='alt';
264$field['type']='varchar';
265$field['index']='';
266$field['length']='254';
267$field['default']='';
268$field['label']='alt';
269$field['rules']='varchar';
270$field['tooltip']='';
271$field['errormsg']='';
272$field['placeholder']='';
273$field['convert']='';
274$field['protect']='0';
275$field['group']='';
276$field['mask']='';
277$field['data']='';
278$field['options']='';
279$field['tpl']='';
280$field['js']='';
281$field['prompt']='';
282$fields[]=$field;
283
284$field['name']='caption';
285$field['type']='text';
286$field['index']='';
287$field['length']='-1';
288$field['default']='';
289$field['label']='caption';
290$field['rules']='text';
291$field['tooltip']='';
292$field['errormsg']='';
293$field['placeholder']='';
294$field['convert']='';
295$field['protect']='0';
296$field['group']='';
297$field['mask']='';
298$field['data']='';
299$field['options']='';
300$field['tpl']='';
301$field['js']='';
302$field['prompt']='';
303$fields[]=$field;
304
305$field['name']='file_name';
306$field['type']='varchar';
307$field['index']='';
308$field['length']='254';
309$field['default']='';
310$field['label']='file_name';
311$field['rules']='varchar';
312$field['tooltip']='';
313$field['errormsg']='';
314$field['placeholder']='';
315$field['convert']='';
316$field['protect']='0';
317$field['group']='';
318$field['mask']='';
319$field['data']='';
320$field['options']='';
321$field['tpl']='';
322$field['js']='';
323$field['prompt']='';
324$fields[]=$field;
325
326$field['name']='file_path';
327$field['type']='varchar';
328$field['index']='';
329$field['length']='254';
330$field['default']='';
331$field['label']='file_path';
332$field['rules']='varchar';
333$field['tooltip']='';
334$field['errormsg']='';
335$field['placeholder']='';
336$field['convert']='';
337$field['protect']='0';
338$field['group']='';
339$field['mask']='';
340$field['data']='';
341$field['options']='';
342$field['tpl']='';
343$field['js']='';
344$field['prompt']='';
345$fields[]=$field;
346
347$field['name']='mime';
348$field['type']='varchar';
349$field['index']='';
350$field['length']='80';
351$field['default']='';
352$field['label']='mime';
353$field['rules']='varchar';
354$field['tooltip']='';
355$field['errormsg']='';
356$field['placeholder']='';
357$field['convert']='';
358$field['protect']='0';
359$field['group']='';
360$field['mask']='';
361$field['data']='';
362$field['options']='';
363$field['tpl']='';
364$field['js']='';
365$field['prompt']='';
366$fields[]=$field;
367
368$field['name']='size';
369$field['type']='int';
370$field['index']='';
371$field['length']='11';
372$field['default']='0';
373$field['label']='size';
374$field['rules']='int';
375$field['tooltip']='';
376$field['errormsg']='';
377$field['placeholder']='';
378$field['convert']='';
379$field['protect']='0';
380$field['group']='';
381$field['mask']='';
382$field['data']='';
383$field['options']='';
384$field['tpl']='';
385$field['js']='';
386$field['prompt']='';
387$fields[]=$field;
388
389$field['name']='width';
390$field['type']='int';
391$field['index']='';
392$field['length']='11';
393$field['default']='0';
394$field['label']='width';
395$field['rules']='int';
396$field['tooltip']='';
397$field['errormsg']='';
398$field['placeholder']='';
399$field['convert']='';
400$field['protect']='0';
401$field['group']='';
402$field['mask']='';
403$field['data']='';
404$field['options']='';
405$field['tpl']='';
406$field['js']='';
407$field['prompt']='';
408$fields[]=$field;
409
410$field['name']='height';
411$field['type']='int';
412$field['index']='';
413$field['length']='11';
414$field['default']='0';
415$field['label']='height';
416$field['rules']='int';
417$field['tooltip']='';
418$field['errormsg']='';
419$field['placeholder']='';
420$field['convert']='';
421$field['protect']='0';
422$field['group']='';
423$field['mask']='';
424$field['data']='';
425$field['options']='';
426$field['tpl']='';
427$field['js']='';
428$field['prompt']='';
429$fields[]=$field;
430
431$field['name']='tags';
432$field['type']='varchar';
433$field['index']='';
434$field['length']='254';
435$field['default']='';
436$field['label']='tags';
437$field['rules']='varchar';
438$field['tooltip']='';
439$field['errormsg']='';
440$field['placeholder']='';
441$field['convert']='';
442$field['protect']='0';
443$field['group']='';
444$field['mask']='';
445$field['data']='';
446$field['options']='';
447$field['tpl']='';
448$field['js']='';
449$field['prompt']='';
450$fields[]=$field;
451
452$field['name']='usage';
453$field['type']='varchar';
454$field['index']='';
455$field['length']='32';
456$field['default']='';
457$field['label']='usage';
458$field['rules']='varchar';
459$field['tooltip']='Verwendung des Mediums, z.B. hero, gallery, teaser.';
460$field['errormsg']='';
461$field['placeholder']='hero, gallery, teaser';
462$field['convert']='';
463$field['protect']='0';
464$field['group']='';
465$field['mask']='';
466$field['data']='';
467$field['options']='hero,gallery,teaser,footer,download';
468$field['tpl']='';
469$field['js']='';
470$field['prompt']='';
471$fields[]=$field;
472
473$field['name']='template';
474$field['type']='varchar';
475$field['index']='';
476$field['length']='80';
477$field['default']='';
478$field['label']='template';
479$field['rules']='varchar';
480$field['tooltip']='Medien-Template, z.B. image-hero oder image-gallery.';
481$field['errormsg']='';
482$field['placeholder']='image-hero';
483$field['convert']='';
484$field['protect']='0';
485$field['group']='';
486$field['mask']='';
487$field['data']='';
488$field['options']='image-hero,image-gallery,image-teaser,video-hero,video-gallery,file-gallery';
489$field['tpl']='';
490$field['js']='';
491$field['prompt']='';
492$fields[]=$field;
493
494$field['name']='sorter';
495$field['type']='varchar';
496$field['index']='';
497$field['length']='32';
498$field['default']='';
499$field['label']='sorter';
500$field['rules']='varchar';
501$field['tooltip']='Sortierung innerhalb des Medienbereichs.';
502$field['errormsg']='';
503$field['placeholder']='';
504$field['convert']='';
505$field['protect']='0';
506$field['group']='';
507$field['mask']='';
508$field['data']='';
509$field['options']='';
510$field['tpl']='';
511$field['js']='';
512$field['prompt']='';
513$fields[]=$field;
514
515$field['name']='thumb_file_path';
516$field['type']='varchar';
517$field['index']='';
518$field['length']='254';
519$field['default']='';
520$field['label']='thumb_file_path';
521$field['rules']='varchar';
522$field['tooltip']='Pfad zum automatisch erzeugten Thumbnail.';
523$field['errormsg']='';
524$field['placeholder']='';
525$field['convert']='';
526$field['protect']='0';
527$field['group']='';
528$field['mask']='';
529$field['data']='';
530$field['options']='';
531$field['tpl']='';
532$field['js']='';
533$field['prompt']='';
534$fields[]=$field;
535
536$field['name']='thumb_width';
537$field['type']='int';
538$field['index']='';
539$field['length']='11';
540$field['default']='0';
541$field['label']='thumb_width';
542$field['rules']='int';
543$field['tooltip']='Thumbnail-Breite.';
544$field['errormsg']='';
545$field['placeholder']='';
546$field['convert']='';
547$field['protect']='0';
548$field['group']='';
549$field['mask']='';
550$field['data']='';
551$field['options']='';
552$field['tpl']='';
553$field['js']='';
554$field['prompt']='';
555$fields[]=$field;
556
557$field['name']='thumb_height';
558$field['type']='int';
559$field['index']='';
560$field['length']='11';
561$field['default']='0';
562$field['label']='thumb_height';
563$field['rules']='int';
564$field['tooltip']='Thumbnail-Hoehe.';
565$field['errormsg']='';
566$field['placeholder']='';
567$field['convert']='';
568$field['protect']='0';
569$field['group']='';
570$field['mask']='';
571$field['data']='';
572$field['options']='';
573$field['tpl']='';
574$field['js']='';
575$field['prompt']='';
576$fields[]=$field;
577
578$field['name']='media_type';
579$field['type']='varchar';
580$field['index']='';
581$field['length']='32';
582$field['default']='';
583$field['label']='media_type';
584$field['rules']='varchar';
585$field['tooltip']='Medientyp image, video oder file.';
586$field['errormsg']='';
587$field['placeholder']='';
588$field['convert']='';
589$field['protect']='0';
590$field['group']='';
591$field['mask']='';
592$field['data']='';
593$field['options']='image,video,external_video,file';
594$field['tpl']='';
595$field['js']='';
596$field['prompt']='';
597$fields[]=$field;
598
599$field['name']='storage_type';
600$field['type']='varchar';
601$field['index']='';
602$field['length']='32';
603$field['default']='local';
604$field['label']='storage_type';
605$field['rules']='varchar';
606$field['tooltip']='Speicherart local oder external.';
607$field['errormsg']='';
608$field['placeholder']='';
609$field['convert']='';
610$field['protect']='0';
611$field['group']='';
612$field['mask']='';
613$field['data']='';
614$field['options']='local,external';
615$field['tpl']='';
616$field['js']='';
617$field['prompt']='';
618$fields[]=$field;
619
620$field['name']='media_folder';
621$field['type']='varchar';
622$field['index']='MUL';
623$field['length']='254';
624$field['default']='';
625$field['label']='media_folder';
626$field['rules']='varchar';
627$field['tooltip']='Organisationsordner innerhalb der Medienbibliothek.';
628$field['errormsg']='';
629$field['placeholder']='img/allgemein';
630$field['convert']='';
631$field['protect']='0';
632$field['group']='';
633$field['mask']='';
634$field['data']='';
635$field['options']='';
636$field['tpl']='';
637$field['js']='';
638$field['prompt']='';
639$fields[]=$field;
640
641$field['name']='provider';
642$field['type']='varchar';
643$field['index']='';
644$field['length']='80';
645$field['default']='';
646$field['label']='provider';
647$field['rules']='varchar';
648$field['tooltip']='Provider fuer externe Medien.';
649$field['errormsg']='';
650$field['placeholder']='youtube';
651$field['convert']='';
652$field['protect']='0';
653$field['group']='';
654$field['mask']='';
655$field['data']='';
656$field['options']='';
657$field['tpl']='';
658$field['js']='';
659$field['prompt']='';
660$fields[]=$field;
661
662$field['name']='provider_id';
663$field['type']='varchar';
664$field['index']='';
665$field['length']='160';
666$field['default']='';
667$field['label']='provider_id';
668$field['rules']='varchar';
669$field['tooltip']='Externe Provider-ID.';
670$field['errormsg']='';
671$field['placeholder']='';
672$field['convert']='';
673$field['protect']='0';
674$field['group']='';
675$field['mask']='';
676$field['data']='';
677$field['options']='';
678$field['tpl']='';
679$field['js']='';
680$field['prompt']='';
681$fields[]=$field;
682
683$field['name']='external_url';
684$field['type']='varchar';
685$field['index']='';
686$field['length']='254';
687$field['default']='';
688$field['label']='external_url';
689$field['rules']='varchar';
690$field['tooltip']='Original-URL einer externen Ressource.';
691$field['errormsg']='';
692$field['placeholder']='';
693$field['convert']='';
694$field['protect']='0';
695$field['group']='';
696$field['mask']='';
697$field['data']='';
698$field['options']='';
699$field['tpl']='';
700$field['js']='';
701$field['prompt']='';
702$fields[]=$field;
703
704$field['name']='embed_url';
705$field['type']='varchar';
706$field['index']='';
707$field['length']='254';
708$field['default']='';
709$field['label']='embed_url';
710$field['rules']='varchar';
711$field['tooltip']='Embed-URL einer externen Ressource.';
712$field['errormsg']='';
713$field['placeholder']='';
714$field['convert']='';
715$field['protect']='0';
716$field['group']='';
717$field['mask']='';
718$field['data']='';
719$field['options']='';
720$field['tpl']='';
721$field['js']='';
722$field['prompt']='';
723$fields[]=$field;
724
725
726/* =========================================================
727 INDEXES
728 ========================================================= */
729$index['name']='pk_media';
730$index['type']='PRIMARY';
731$index['fields']='id';
732$index['unique']='1';
733$index['comment']='from field index PRI';
734$indexes[]=$index;
735
736$index['name']='idx_media_content';
737$index['type']='INDEX';
738$index['fields']='content_id';
739$index['unique']='0';
740$index['comment']='Content relation';
741$indexes[]=$index;
742
743$index['name']='idx_media_folder';
744$index['type']='INDEX';
745$index['fields']='folder_id';
746$index['unique']='0';
747$index['comment']='Folder relation';
748$indexes[]=$index;
749
750$index['name']='idx_media_media_folder';
751$index['type']='INDEX';
752$index['fields']='media_folder';
753$index['unique']='0';
754$index['comment']='Media library folder';
755$indexes[]=$index;
$table
$table['server']
Definition .dd.php:6
$indexes
$indexes[]
Definition .dd.php:167
$index
$index['name']
Definition .dd.php:162
$fields
$fields[]
Definition config.dd.php:16
$field
$field
Definition config.dd.php:4