Blue Flower

Zuordnung der einzelnen Tabellen in Gruppen

Benutzer
 prefix_usergroups
 prefix_users
 prefix_user_keys
  Benutzer: Gruppen (Zugewiesene Gruppen)
Benutzer

   
 prefix_user_notes   Benutzerhinweise   benutzerl liste info
 prefix_user_profiles   (Benutzer-Kontodetails)    
 prefix_user_usergroup_map   Zuordnungstabelle Benutzer <-> Gruppe    
 prefix_viewlevels   Zuordnung Gruppe <-> Zugriffsrechte    
 prefix_fields    Felder    
SELECT * FROM `prefix_fields` WHERE `context` LIKE 'com_users.user'
 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
SELECT * FROM `prefix_assets` WHERE `name` LIKE '%com_users.%'
Name: com_users.xx 

 

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.%'