Zuordnung der einzelnen Tabellen in Gruppen
| Benutzer | ||||
| prefix_usergroups prefix_users prefix_user_keys |
Benutzer: Gruppen (Zugewiesene Gruppen) Benutzer |
|||
| prefix_user_notes | Benutzerhinweise |  |
||
| prefix_user_profiles | (Benutzer-Kontodetails) | |||
| prefix_user_usergroup_map | Zuordnungstabelle Benutzer <-> Gruppe | |||
| prefix_viewlevels | Zuordnung Gruppe <-> Zugriffsrechte | |||
| prefix_fields | Felder | |
||
| prefix_fields_groups | Feldgruppen | SELECT * FROM `prefix_fields_groups` WHERE `context` LIKE 'com_users.user'; | ||
| prefix_fields_categories | SELECT * FROM `prefix_fields_categories` WHERE `field_id` in (SELECT `id` FROM `prefix_fields_groups` WHERE `context` LIKE 'com_users.user') | |||
| prefix_assets | Hinweiskategorien | Hinweiskategorien sind dieser Tabelle abgelegt |
||
| Kontakte | ||||
| contact_details | Kontakte | |||
| assets | Kontake-Kategorie | SELECT * FROM `prefix_assets` WHERE `name` LIKE '%com_contact.category.%' xxxxx |
||
| Artikel |
||||
| content | Artikel | |||
| categories | Kategorien | |||
| contentitem_tag_map content_frontpage content_rating content_types |
Startseite type_alias: com_content.article |
|||
| Historie | ||||
| ucm_history | Artikel-Versionen für die Wiederherstellung | |||
| ucm_content | Version für immer sichern | |||
| ucm_base | ??? | |||
| Werbe-Banner | ||||
| banners banner_clients banner_tracks |
Banner Kunden Aufrufe |
|||
| Bannerstatistik | ||||
| banner_tracks | alle Aufrufe und klick auf die Banner | |||
| Links | ||||
| weblinks | ||||
| Menüs | ||||
| modules | Modul-Tabelle | SELECT * FROM `up_modules` WHERE `module`= 'mod_menu'
|
||
| menu_types | Haupt-Menüs zu denen die Menüeinträge zugewiesen sind | |||
| menu | Module | |||
| modules_menu | Zuweisung wo die Menüs angezeigt werden | |||
| Vis Forms | ||
| viscreator | ||
| visfields | ||
| visforms | ||
| visformsadd | ||
| visformsddr | ||
| visformsdoubleoptin | ||
| visformsdoubleoptindata | ||
| visformsmailattachments | ||
| visformsms | ||
| visforms_1 visforms_2 .. visforms_n |
||
| visforms_1_save visforms_2_save .. visforms_n_save |
||
| visforms_lowest_compat_version | ||
| visforms_spambot_attempts | ||
| visforms_utf8_conversion | ||
| vispdf | ||
| visverificationcodes |
| DP Calender | ||||
| dpcalendar_bookings | ||||
| dpcalendar_caldav_calendarchanges | ||||
| dpcalendar_caldav_calendarinstances | ||||
| dpcalendar_caldav_calendarobjects | ||||
| dpcalendar_caldav_calendars | ||||
| dpcalendar_caldav_calendarsubscriptions | ||||
| dpcalendar_caldav_groupmembers | ||||
| dpcalendar_caldav_principals | ||||
| dpcalendar_caldav_propertystorage | ||||
| dpcalendar_caldav_schedulingobjects | ||||
| dpcalendar_countries | ||||
| dpcalendar_coupons | ||||
| dpcalendar_events | ||||
| dpcalendar_events_location | ||||
| dpcalendar_extcalendars | ||||
| dpcalendar_locations | ||||
| dpcalendar_taxrates | ||||
| dpcalendar_tickets | ||||
| assets | Kategorieen: ; |
SELECT * FROM `prefix_assets` WHERE `name` LIKE '%com_dpcalendar.%' | ||
| categories | SELECT * FROM `prefix_categories` WHERE `name` LIKE '%com_dpcalendar.category.%' | |||
