Dateien hier ablegen

SQL upload ( 0 ) x-

Server: rdbms.strato.de »Datenbank: DB685940
Seitenbezogene EinstellungenKlicken Sie auf die Leiste, um zum Anfang der Seite zu scrollen
Drücken Sie Strg+Enter, um die Abfrage auszuführen Drücken Sie Enter, um die Abfrage auszuführen
aufsteigend
absteigend
Reihenfolge:
SQL Debugger
Zähler
Ausführungsreihenfolge
Nötige Zeit
Sortieren nach:
Abfragen umgruppieren
Abfragen voneinander lösen
Zuklappen Aufklappen Nachverfolgung anzeigen Nachverfolgung ausblenden Zähler Nötige Zeit
Lesezeichen
Aktualisieren
Hinzufügen
Keine Lesezeichen
Lesezeichen hinzufügen
Optionen
Standard festlegen





Zuklappen Aufklappen Erneut abfragen Bearbeiten Erklären Messen Lesezeichen Abfrage fehlgeschlagen Datenbank Abfragezeit
6
DB685940
{"j_tabs":{"DB685940.gs_batterien":1,"DB685940.gs_berechtigung":1,"DB685940.gs_italienisch_deutsch":1,"DB685940.gs_kostenstellen":1,"DB685940.gs_ksv":1,"DB685940.gs_ksv_kal":1,"DB685940.gs_ksv_kal_jahr":1,"DB685940.gs_ksv_kal_sicherung":1,"DB685940.gs_ksv_tel":1,"DB685940.gs_lv_daten":1,"DB685940.gs_rcg_db":1,"DB685940.gs_rezepte":1,"DB685940.gs_ver-kal":1,"DB685940.lz_administration_log":1,"DB685940.lz_alerts":1,"DB685940.lz_auto_replies":1,"DB685940.lz_chat_archive":1,"DB685940.lz_chat_files":1,"DB685940.lz_chat_forwards":1,"DB685940.lz_chat_posts":1,"DB685940.lz_chat_requests":1,"DB685940.lz_com_chat_localizations":1,"DB685940.lz_com_chat_providers":1,"DB685940.lz_com_chat_types":1,"DB685940.lz_com_chat_vouchers":1,"DB685940.lz_config":1,"DB685940.lz_data_cache":1,"DB685940.lz_data_updates":1,"DB685940.lz_events":1,"DB685940.lz_event_actions":1,"DB685940.lz_event_action_internals":1,"DB685940.lz_event_action_overlays":1,"DB685940.lz_event_action_receivers":1,"DB685940.lz_event_action_senders":1,"DB685940.lz_event_action_website_pushs":1,"DB685940.lz_event_funnels":1,"DB685940.lz_event_goals":1,"DB685940.lz_event_triggers":1,"DB685940.lz_event_urls":1,"DB685940.lz_feedbacks":1,"DB685940.lz_feedback_criteria":1,"DB685940.lz_feedback_criteria_config":1,"DB685940.lz_filters":1,"DB685940.lz_goals":1,"DB685940.lz_groups":1,"DB685940.lz_group_members":1,"DB685940.lz_images":1,"DB685940.lz_info":1,"DB685940.lz_knowledgebase_queries":1,"DB685940.lz_knowledgebase_views":1,"DB685940.lz_mailboxes":1,"DB685940.lz_operators":1,"DB685940.lz_operator_logins":1,"DB685940.lz_operator_status":1,"DB685940.lz_overlay_boxes":1,"DB685940.lz_predefined":1,"DB685940.lz_profiles":1,"DB685940.lz_profile_pictures":1,"DB685940.lz_push_messages":1,"DB685940.lz_resources":1,"DB685940.lz_signatures":1,"DB685940.lz_social_media_channels":1,"DB685940.lz_stats_aggs":1,"DB685940.lz_stats_aggs_availabilities":1,"DB685940.lz_stats_aggs_browsers":1,"DB685940.lz_stats_aggs_chats":1,"DB685940.lz_stats_aggs_cities":1,"DB685940.lz_stats_aggs_countries":1,"DB685940.lz_stats_aggs_crawlers":1,"DB685940.lz_stats_aggs_domains":1,"DB685940.lz_stats_aggs_durations":1,"DB685940.lz_stats_aggs_feedbacks":1,"DB685940.lz_stats_aggs_goals":1,"DB685940.lz_stats_aggs_goals_queries":1,"DB685940.lz_stats_aggs_isps":1,"DB685940.lz_stats_aggs_knowledgebase":1,"DB685940.lz_stats_aggs_languages":1,"DB685940.lz_stats_aggs_pages":1,"DB685940.lz_stats_aggs_pages_entrance":1,"DB685940.lz_stats_aggs_pages_exit":1,"DB685940.lz_stats_aggs_queries":1,"DB685940.lz_stats_aggs_referrers":1,"DB685940.lz_stats_aggs_regions":1,"DB685940.lz_stats_aggs_resolutions":1,"DB685940.lz_stats_aggs_search_engines":1,"DB685940.lz_stats_aggs_systems":1,"DB685940.lz_stats_aggs_tickets":1,"DB685940.lz_stats_aggs_visitors":1,"DB685940.lz_stats_aggs_visits":1,"DB685940.lz_tickets":1,"DB685940.lz_ticket_attachments":1,"DB685940.lz_ticket_comments":1,"DB685940.lz_ticket_customs":1,"DB685940.lz_ticket_editors":1,"DB685940.lz_ticket_emails":1,"DB685940.lz_ticket_logs":1,"DB685940.lz_ticket_messages":1,"DB685940.lz_ticket_subs":1,"DB685940.lz_ticket_watcher":1,"DB685940.lz_user_data":1,"DB685940.lz_visitors":1,"DB685940.lz_visitor_browsers":1,"DB685940.lz_visitor_browser_urls":1,"DB685940.lz_visitor_chats":1,"DB685940.lz_visitor_chat_operators":1,"DB685940.lz_visitor_comments":1,"DB685940.lz_visitor_data_browsers":1,"DB685940.lz_visitor_data_cities":1,"DB685940.lz_visitor_data_crawlers":1,"DB685940.lz_visitor_data_domains":1,"DB685940.lz_visitor_data_isps":1,"DB685940.lz_visitor_data_pages":1,"DB685940.lz_visitor_data_paths":1,"DB685940.lz_visitor_data_queries":1,"DB685940.lz_visitor_data_regions":1,"DB685940.lz_visitor_data_resolutions":1,"DB685940.lz_visitor_data_systems":1,"DB685940.lz_visitor_data_titles":1,"DB685940.lz_visitor_goals":1,"DB685940.lz_website_pushs":1,"DB685940.mein_verein":1,"DB685940.mein_verein-1":1,"DB685940.mein_verein-bak":1,"DB685940.pma__bookmark":1,"DB685940.pma__central_columns":1,"DB685940.pma__column_info":1,"DB685940.pma__designer_settings":1,"DB685940.pma__export_templates":1,"DB685940.pma__favorite":1,"DB685940.pma__history":1,"DB685940.pma__navigationhiding":1,"DB685940.pma__pdf_pages":1,"DB685940.pma__recent":1,"DB685940.pma__relation":1,"DB685940.pma__savedsearches":1,"DB685940.pma__table_coords":1,"DB685940.pma__table_info":1,"DB685940.pma__table_uiprefs":1,"DB685940.pma__tracking":1,"DB685940.pma__userconfig":1,"DB685940.pma__usergroups":1,"DB685940.pma__users":1,"DB685940.vereine_personal_neu":1},"h_tabs":{"DB685940.gs_batterien":1,"DB685940.gs_berechtigung":1,"DB685940.gs_italienisch_deutsch":1,"DB685940.gs_kostenstellen":1,"DB685940.gs_ksv":1,"DB685940.gs_ksv_kal":1,"DB685940.gs_ksv_kal_jahr":1,"DB685940.gs_ksv_kal_sicherung":1,"DB685940.gs_ksv_tel":1,"DB685940.gs_lv_daten":1,"DB685940.gs_rcg_db":1,"DB685940.gs_rezepte":1,"DB685940.gs_ver-kal":1,"DB685940.lz_administration_log":1,"DB685940.lz_alerts":1,"DB685940.lz_auto_replies":1,"DB685940.lz_chat_archive":1,"DB685940.lz_chat_files":1,"DB685940.lz_chat_forwards":1,"DB685940.lz_chat_posts":1,"DB685940.lz_chat_requests":1,"DB685940.lz_com_chat_localizations":1,"DB685940.lz_com_chat_providers":1,"DB685940.lz_com_chat_types":1,"DB685940.lz_com_chat_vouchers":1,"DB685940.lz_config":1,"DB685940.lz_data_cache":1,"DB685940.lz_data_updates":1,"DB685940.lz_events":1,"DB685940.lz_event_actions":1,"DB685940.lz_event_action_internals":1,"DB685940.lz_event_action_overlays":1,"DB685940.lz_event_action_receivers":1,"DB685940.lz_event_action_senders":1,"DB685940.lz_event_action_website_pushs":1,"DB685940.lz_event_funnels":1,"DB685940.lz_event_goals":1,"DB685940.lz_event_triggers":1,"DB685940.lz_event_urls":1,"DB685940.lz_feedbacks":1,"DB685940.lz_feedback_criteria":1,"DB685940.lz_feedback_criteria_config":1,"DB685940.lz_filters":1,"DB685940.lz_goals":1,"DB685940.lz_groups":1,"DB685940.lz_group_members":1,"DB685940.lz_images":1,"DB685940.lz_info":1,"DB685940.lz_knowledgebase_queries":1,"DB685940.lz_knowledgebase_views":1,"DB685940.lz_mailboxes":1,"DB685940.lz_operators":1,"DB685940.lz_operator_logins":1,"DB685940.lz_operator_status":1,"DB685940.lz_overlay_boxes":1,"DB685940.lz_predefined":1,"DB685940.lz_profiles":1,"DB685940.lz_profile_pictures":1,"DB685940.lz_push_messages":1,"DB685940.lz_resources":1,"DB685940.lz_signatures":1,"DB685940.lz_social_media_channels":1,"DB685940.lz_stats_aggs":1,"DB685940.lz_stats_aggs_availabilities":1,"DB685940.lz_stats_aggs_browsers":1,"DB685940.lz_stats_aggs_chats":1,"DB685940.lz_stats_aggs_cities":1,"DB685940.lz_stats_aggs_countries":1,"DB685940.lz_stats_aggs_crawlers":1,"DB685940.lz_stats_aggs_domains":1,"DB685940.lz_stats_aggs_durations":1,"DB685940.lz_stats_aggs_feedbacks":1,"DB685940.lz_stats_aggs_goals":1,"DB685940.lz_stats_aggs_goals_queries":1,"DB685940.lz_stats_aggs_isps":1,"DB685940.lz_stats_aggs_knowledgebase":1,"DB685940.lz_stats_aggs_languages":1,"DB685940.lz_stats_aggs_pages":1,"DB685940.lz_stats_aggs_pages_entrance":1,"DB685940.lz_stats_aggs_pages_exit":1,"DB685940.lz_stats_aggs_queries":1,"DB685940.lz_stats_aggs_referrers":1,"DB685940.lz_stats_aggs_regions":1,"DB685940.lz_stats_aggs_resolutions":1,"DB685940.lz_stats_aggs_search_engines":1,"DB685940.lz_stats_aggs_systems":1,"DB685940.lz_stats_aggs_tickets":1,"DB685940.lz_stats_aggs_visitors":1,"DB685940.lz_stats_aggs_visits":1,"DB685940.lz_tickets":1,"DB685940.lz_ticket_attachments":1,"DB685940.lz_ticket_comments":1,"DB685940.lz_ticket_customs":1,"DB685940.lz_ticket_editors":1,"DB685940.lz_ticket_emails":1,"DB685940.lz_ticket_logs":1,"DB685940.lz_ticket_messages":1,"DB685940.lz_ticket_subs":1,"DB685940.lz_ticket_watcher":1,"DB685940.lz_user_data":1,"DB685940.lz_visitors":1,"DB685940.lz_visitor_browsers":1,"DB685940.lz_visitor_browser_urls":1,"DB685940.lz_visitor_chats":1,"DB685940.lz_visitor_chat_operators":1,"DB685940.lz_visitor_comments":1,"DB685940.lz_visitor_data_browsers":1,"DB685940.lz_visitor_data_cities":1,"DB685940.lz_visitor_data_crawlers":1,"DB685940.lz_visitor_data_domains":1,"DB685940.lz_visitor_data_isps":1,"DB685940.lz_visitor_data_pages":1,"DB685940.lz_visitor_data_paths":1,"DB685940.lz_visitor_data_queries":1,"DB685940.lz_visitor_data_regions":1,"DB685940.lz_visitor_data_resolutions":1,"DB685940.lz_visitor_data_systems":1,"DB685940.lz_visitor_data_titles":1,"DB685940.lz_visitor_goals":1,"DB685940.lz_website_pushs":1,"DB685940.mein_verein":1,"DB685940.mein_verein-1":1,"DB685940.mein_verein-bak":1,"DB685940.pma__bookmark":1,"DB685940.pma__central_columns":1,"DB685940.pma__column_info":1,"DB685940.pma__designer_settings":1,"DB685940.pma__export_templates":1,"DB685940.pma__favorite":1,"DB685940.pma__history":1,"DB685940.pma__navigationhiding":1,"DB685940.pma__pdf_pages":1,"DB685940.pma__recent":1,"DB685940.pma__relation":1,"DB685940.pma__savedsearches":1,"DB685940.pma__table_coords":1,"DB685940.pma__table_info":1,"DB685940.pma__table_uiprefs":1,"DB685940.pma__tracking":1,"DB685940.pma__userconfig":1,"DB685940.pma__usergroups":1,"DB685940.pma__users":1,"DB685940.vereine_personal_neu":1}}
[]
{"gs_batterien":"gro","gs_berechtigung":"url","gs_italienisch_deutsch":"deutsch","gs_kostenstellen":"stelle1","gs_ksv":"name","gs_ksv_kal":"gruppe","gs_ksv_kal_jahr":"gruppe","gs_ksv_kal_sicherung":"gruppe","gs_ksv_tel":"ANRede","gs_lv_daten":"nam","gs_rcg_db":"vor","gs_rezepte":"gruppe","gs_ver-kal":"username","lz_administration_log":"id","lz_alerts":"id","lz_auto_replies":"id","lz_chat_archive":"chat_id","lz_chat_files":"id","lz_chat_forwards":"id","lz_chat_posts":"id","lz_chat_requests":"id","lz_com_chat_localizations":"id","lz_com_chat_providers":"id","lz_com_chat_types":"id","lz_com_chat_vouchers":"id","lz_config":"key","lz_data_cache":"key","lz_events":"id","lz_event_actions":"id","lz_event_action_internals":"id","lz_event_action_overlays":"id","lz_event_action_receivers":"id","lz_event_action_senders":"id","lz_event_action_website_pushs":"id","lz_event_funnels":"eid","lz_event_goals":"event_id","lz_event_triggers":"id","lz_event_urls":"id","lz_feedbacks":"id","lz_feedback_criteria":"fid","lz_feedback_criteria_config":"id","lz_filters":"creator","lz_goals":"title","lz_groups":"id","lz_group_members":"user_id","lz_images":"button_type","lz_info":"version","lz_knowledgebase_queries":"id","lz_knowledgebase_views":"id","lz_mailboxes":"id","lz_operators":"id","lz_operator_logins":"id","lz_operator_status":"internal_id","lz_overlay_boxes":"id","lz_predefined":"id","lz_profiles":"id","lz_profile_pictures":"id","lz_push_messages":"id","lz_resources":"id","lz_signatures":"id","lz_social_media_channels":"id","lz_stats_aggs_availabilities":"user_id","lz_stats_aggs_chats":"user_id","lz_stats_aggs_countries":"country","lz_stats_aggs_feedbacks":"operator_id","lz_stats_aggs_knowledgebase":"res_id","lz_stats_aggs_languages":"language","lz_stats_aggs_tickets":"user_id","lz_tickets":"id","lz_ticket_attachments":"res_id","lz_ticket_comments":"id","lz_ticket_customs":"ticket_id","lz_ticket_editors":"ticket_id","lz_ticket_emails":"email_id","lz_ticket_logs":"ticket_id","lz_ticket_messages":"id","lz_ticket_subs":"id","lz_ticket_watcher":"operator_id","lz_user_data":"id","lz_visitors":"id","lz_visitor_browsers":"id","lz_visitor_browser_urls":"browser_id","lz_visitor_chats":"visitor_id","lz_visitor_chat_operators":"user_id","lz_visitor_comments":"id","lz_visitor_data_browsers":"browser","lz_visitor_data_cities":"city","lz_visitor_data_crawlers":"crawler","lz_visitor_data_domains":"domain","lz_visitor_data_isps":"isp","lz_visitor_data_paths":"path","lz_visitor_data_queries":"query","lz_visitor_data_regions":"region","lz_visitor_data_resolutions":"resolution","lz_visitor_data_systems":"system","lz_visitor_data_titles":"title","lz_visitor_goals":"visitor_id","lz_website_pushs":"id","mein_verein":"ANREDE","mein_verein-1":"ANREDE","mein_verein-bak":"ANREDE","pma__bookmark":"dbase","pma__central_columns":"db_name","pma__column_info":"db_name","pma__designer_settings":"username","pma__export_templates":"username","pma__favorite":"username","pma__history":"username","pma__navigationhiding":"username","pma__pdf_pages":"db_name","pma__recent":"username","pma__relation":"master_db","pma__savedsearches":"username","pma__table_coords":"db_name","pma__table_info":"db_name","pma__table_uiprefs":"username","pma__tracking":"db_name","pma__userconfig":"username","pma__usergroups":"usergroup","pma__users":"username","vereine_personal_neu":"vor"}
-1
1
Unbenannt *
v Tabellen-Liste anzeigen/ausblenden Zeige als Vollbild Tabellen aus anderen Datenbanken hinzufügen Neue Seite Öffne Seite Seite speichern Seite speichern als Seiten löschen Erzeuge Tabelle Erzeuge Verknüpfung Anzuzeigende Spalte auswählen Neuladen Hilfe Winklige Verbindung / Direkte Verbindung Am Gitter anordnen v Alles klein/groß Wechseln klein/groß Beziehungen anzeigen an/aus Schema exportieren > Verschiebe Menü > Text anheften
v v
DB685940.gs_batterien
DB685940.gs_berechtigung
DB685940.gs_italienisch_deutsch
DB685940.gs_kostenstellen
DB685940.gs_ksv
DB685940.gs_ksv_kal
DB685940.gs_ksv_kal_jahr
DB685940.gs_ksv_kal_sicherung
DB685940.gs_ksv_tel
DB685940.gs_lv_daten
DB685940.gs_rcg_db
DB685940.gs_rezepte
DB685940.gs_ver-kal
DB685940.lz_administration_log
DB685940.lz_alerts
DB685940.lz_auto_replies
DB685940.lz_chat_archive
DB685940.lz_chat_files
DB685940.lz_chat_forwards
DB685940.lz_chat_posts
DB685940.lz_chat_requests
DB685940.lz_com_chat_localizations
DB685940.lz_com_chat_providers
DB685940.lz_com_chat_types
DB685940.lz_com_chat_vouchers
DB685940.lz_config
DB685940.lz_data_cache
DB685940.lz_data_updates
DB685940.lz_events
DB685940.lz_event_actions
DB685940.lz_event_action_internals
DB685940.lz_event_action_overlays
DB685940.lz_event_action_receivers
DB685940.lz_event_action_senders
DB685940.lz_event_action_website_pushs
DB685940.lz_event_funnels
DB685940.lz_event_goals
DB685940.lz_event_triggers
DB685940.lz_event_urls
DB685940.lz_feedbacks
DB685940.lz_feedback_criteria
DB685940.lz_feedback_criteria_config
DB685940.lz_filters
DB685940.lz_goals
DB685940.lz_groups
DB685940.lz_group_members
DB685940.lz_images
DB685940.lz_info
DB685940.lz_knowledgebase_queries
DB685940.lz_knowledgebase_views
DB685940.lz_mailboxes
DB685940.lz_operators
DB685940.lz_operator_logins
DB685940.lz_operator_status
DB685940.lz_overlay_boxes
DB685940.lz_predefined
DB685940.lz_profiles
DB685940.lz_profile_pictures
DB685940.lz_push_messages
DB685940.lz_resources
DB685940.lz_signatures
DB685940.lz_social_media_channels
DB685940.lz_stats_aggs
DB685940.lz_stats_aggs_availabilities
DB685940.lz_stats_aggs_browsers
DB685940.lz_stats_aggs_chats
DB685940.lz_stats_aggs_cities
DB685940.lz_stats_aggs_countries
DB685940.lz_stats_aggs_crawlers
DB685940.lz_stats_aggs_domains
DB685940.lz_stats_aggs_durations
DB685940.lz_stats_aggs_feedbacks
DB685940.lz_stats_aggs_goals
DB685940.lz_stats_aggs_goals_queries
DB685940.lz_stats_aggs_isps
DB685940.lz_stats_aggs_knowledgebase
DB685940.lz_stats_aggs_languages
DB685940.lz_stats_aggs_pages
DB685940.lz_stats_aggs_pages_entrance
DB685940.lz_stats_aggs_pages_exit
DB685940.lz_stats_aggs_queries
DB685940.lz_stats_aggs_referrers
DB685940.lz_stats_aggs_regions
DB685940.lz_stats_aggs_resolutions
DB685940.lz_stats_aggs_search_engines
DB685940.lz_stats_aggs_systems
DB685940.lz_stats_aggs_tickets
DB685940.lz_stats_aggs_visitors
DB685940.lz_stats_aggs_visits
DB685940.lz_tickets
DB685940.lz_ticket_attachments
DB685940.lz_ticket_comments
DB685940.lz_ticket_customs
DB685940.lz_ticket_editors
DB685940.lz_ticket_emails
DB685940.lz_ticket_logs
DB685940.lz_ticket_messages
DB685940.lz_ticket_subs
DB685940.lz_ticket_watcher
DB685940.lz_user_data
DB685940.lz_visitors
DB685940.lz_visitor_browsers
DB685940.lz_visitor_browser_urls
DB685940.lz_visitor_chats
DB685940.lz_visitor_chat_operators
DB685940.lz_visitor_comments
DB685940.lz_visitor_data_browsers
DB685940.lz_visitor_data_cities
DB685940.lz_visitor_data_crawlers
DB685940.lz_visitor_data_domains
DB685940.lz_visitor_data_isps
DB685940.lz_visitor_data_pages
DB685940.lz_visitor_data_paths
DB685940.lz_visitor_data_queries
DB685940.lz_visitor_data_regions
DB685940.lz_visitor_data_resolutions
DB685940.lz_visitor_data_systems
DB685940.lz_visitor_data_titles
DB685940.lz_visitor_goals
DB685940.lz_website_pushs
DB685940.mein_verein
DB685940.mein_verein-1
DB685940.mein_verein-bak
DB685940.pma__bookmark
DB685940.pma__central_columns
DB685940.pma__column_info
DB685940.pma__designer_settings
DB685940.pma__export_templates
DB685940.pma__favorite
DB685940.pma__history
DB685940.pma__navigationhiding
DB685940.pma__pdf_pages
DB685940.pma__recent
DB685940.pma__relation
DB685940.pma__savedsearches
DB685940.pma__table_coords
DB685940.pma__table_info
DB685940.pma__table_uiprefs
DB685940.pma__tracking
DB685940.pma__userconfig
DB685940.pma__usergroups
DB685940.pma__users
DB685940.vereine_personal_neu
Anzahl Tabellen: 143
v DB685940 gs_batterien
* num : int(3)
* pre : decimal(4,2)
* gro : varchar(10)
* vol : decimal(3,1)
* lei : int(3)
* typ : varchar(15)
* lnr : int(3)
* stk_a : int(3)
* stk_h : int(3)
* nein : varchar(5)
* hh : int(3)
* prg : varchar(30)
* user : varchar(30)
* serial : varchar(40)
* art : varchar(10)
v DB685940 gs_berechtigung
* lfd_nr : int(4)
* url : varchar(100)
* programm : varchar(40)
* serial : varchar(40)
* vorname : varchar(30)
* name : varchar(30)
* kd_nr : varchar(40)
* vertrag_nr : varchar(15)
* id : varchar(10)
* username : varchar(40)
* passwort : varchar(25)
* passwort_alt : varchar(25)
* tel : varchar(20)
* fax : varchar(20)
* db : varchar(10)
* email : varchar(40)
* email_alias : varchar(40)
* umleitung : varchar(100)
* eingang : varchar(20)
* ausgang : varchar(20)
* frage : varchar(30)
* bemerkung : varchar(50)
* info : varchar(50)
* type : int(1)
* wer : char(3)
v DB685940 gs_italienisch_deutsch
* id : int(4)
* deutsch : varchar(50)
* italienisch : varchar(50)
* spalte4 : varchar(50)
* spalte5 : varchar(50)
* spalte6 : varchar(50)
* spalte7 : varchar(50)
* aussprache : varchar(50)
* bemerkung : varchar(50)
* info : varchar(50)
* type : int(4)
* satz_deu : varchar(80)
* satz_ita : varchar(80)
* satz_was : varchar(50)
v DB685940 gs_kostenstellen
* stelle1 : varchar(30)
* stelle2 : varchar(30)
* stelle3 : varchar(30)
* werk : varchar(4)
* text : varchar(60)
* lastadd : date
v DB685940 gs_ksv
* name : char(15)
* vorname : char(15)
* datum : date
* geb : date
* info : char(15)
* was : char(30)
* kategorie : char(10)
* sex : char(10)
* mannschaft : char(40)
* jahr : char(4)
* volle : int(3)
* abr : int(3)
* gesamt : int(3)
* f : int(2)
* vol1 : int(3)
* abr1 : int(3)
* ges1 : int(3)
* f1 : int(2)
* vol2 : int(3)
* abr2 : int(3)
* ges2 : int(3)
* f2 : int(2)
* durch : char(2)
* hilf1 : char(15)
* hilf2 : char(15)
* hilf3 : char(55)
v DB685940 gs_ksv_kal
* id : int(10)
* gruppe : varchar(20)
* veranstaltung : varchar(25)
* raum : varchar(25)
* name : varchar(25)
* datum : date
* monat : varchar(20)
* tag : varchar(20)
* uhrzeit : varchar(5)
* wirt : varchar(20)
* info : varchar(30)
v DB685940 gs_ksv_kal_jahr
* id : int(10)
* gruppe : varchar(20)
* veranstaltung : varchar(25)
* raum : varchar(25)
* name : varchar(25)
* datum : date
* monat : varchar(20)
* tag : varchar(20)
* uhrzeit : varchar(5)
* wirt : varchar(20)
* info : varchar(30)
v DB685940 gs_ksv_kal_sicherung
* id : int(10)
* gruppe : varchar(20)
* veranstaltung : varchar(25)
* raum : varchar(25)
* name : varchar(25)
* datum : date
* monat : varchar(20)
* tag : varchar(20)
* uhrzeit : varchar(5)
* wirt : varchar(20)
* info : varchar(30)
v DB685940 gs_ksv_tel
* DBINDEX : int(11)
* NummeR : int(11)
* ANRede : char(30)
* NACHNAMEFIRMA : char(50)
* VORNAME : char(50)
* STRASSE : char(50)
* LAND : char(5)
* PLZ : char(10)
* ORT : char(50)
* TELEFON1 : char(40)
* FAX : char(40)
* MOBILTELEFON : char(40)
* EMAIL : char(50)
* SORT_FUNKTION : int(3)
* FUNKTION : char(30)
v DB685940 gs_lv_daten
* nam : varchar(15)
* vor : varchar(15)
* dat : date
* was : char(2)
* v : int(3)
* a : int(3)
* g : int(3)
* f : int(2)
* vol1 : int(3)
* abr1 : int(3)
* ges1 : int(3)
* f1 : int(2)
* vol2 : int(3)
* abr2 : int(3)
* ges2 : int(3)
* f2 : int(2)
* durch : int(1)
* lfd : int(2)
* hilf1 : char(3)
* hilf2 : char(3)
* hilf3 : char(3)
* p_nr : int(2)
* wurf : int(2)
* fehl : int(2)
* id : int(4)
v DB685940 gs_rcg_db
* id : int(4)
* vor : varchar(15)
* nam : varchar(20)
* jahr : int(4)
* k_name : varchar(40)
* hilf1 : char(3)
* hilf2 : char(3)
* motto : char(70)
* status : int(1)
* funktion1 : varchar(20)
* funktion2 : varchar(15)
* gruppe : varchar(30)
v DB685940 gs_rezepte
* id : int(10)
* type : int(10)
* gruppe : varchar(80)
* untertitel : varchar(80)
* bild : varchar(150)
* datei : varchar(150)
* zutaten : text
* zubereitung : text
* datum : datetime
* zaehler : int(10)
v DB685940 gs_ver-kal
* id : int(11)
* username : varchar(255)
* stamp : datetime
* subject : varchar(255)
* description : blob
v DB685940 lz_administration_log
* id : varchar(32)
* type : varchar(32)
* value : text
* trace : text
* time : int(10) unsigned
* user : varchar(32)
v DB685940 lz_alerts
* id : varchar(32)
* created : int(10) unsigned
* receiver_user_id : varchar(32)
* receiver_browser_id : varchar(32)
* event_action_id : varchar(32)
* text : mediumtext
* displayed : tinyint(1) unsigned
* accepted : tinyint(1) unsigned
v DB685940 lz_auto_replies
* id : varchar(32)
* resource_id : varchar(32)
* owner_id : varchar(32)
* tags : varchar(255)
* search_type : tinyint(1) unsigned
* answer : text
* new_window : tinyint(1) unsigned
* language : varchar(7)
* send : tinyint(1) unsigned
* waiting : tinyint(1) unsigned
* inactivity_internal : int(11)
* inactivity_external : int(11)
* inactivity_close : tinyint(1) unsigned
* title : varchar(128)
v DB685940 lz_chat_archive
* time : int(11) unsigned
* endtime : int(11) unsigned
* closed : int(11) unsigned
* chat_id : varchar(64)
* external_id : varchar(32)
* fullname : varchar(255)
* internal_id : varchar(32)
* group_id : varchar(32)
* area_code : varchar(255)
* html : longtext
* plaintext : longtext
* transcript_text : text
* transcript_html : text
* email : varchar(255)
* company : varchar(255)
* phone : varchar(255)
* call_me_back : tinyint(1) unsigned
* iso_language : varchar(8)
* iso_country : varchar(5)
* host : varchar(64)
* ip : varchar(64)
* gzip : tinyint(1) unsigned
* transcript_sent : tinyint(1) unsigned
* transcript_receiver : varchar(255)
* question : varchar(255)
* customs : text
* subject : text
* voucher_id : varchar(32)
* wait : int(11) unsigned
* duration : int(11) unsigned
* accepted : tinyint(1) unsigned
* ended : tinyint(1) unsigned
* chat_type : tinyint(1) unsigned
* ref_url : varchar(2048)
v DB685940 lz_chat_files
* id : varchar(64)
* created : int(10) unsigned
* file_name : varchar(255)
* file_mask : varchar(255)
* file_id : varchar(255)
* chat_id : int(10) unsigned
* visitor_id : varchar(32)
* browser_id : varchar(32)
* operator_id : varchar(32)
* error : varchar(255)
* permission : tinyint(1)
* download : tinyint(1) unsigned
* closed : tinyint(1) unsigned
v DB685940 lz_chat_forwards
* id : varchar(32)
* created : int(10) unsigned
* initiator_operator_id : varchar(32)
* sender_operator_id : varchar(32)
* target_operator_id : varchar(32)
* target_group_id : varchar(32)
* visitor_id : varchar(32)
* browser_id : varchar(32)
* chat_id : int(11) unsigned
* info_text : mediumtext
* processed : tinyint(1) unsigned
* received : tinyint(1) unsigned
* invite : tinyint(1) unsigned
* auto : tinyint(1) unsigned
* closed : tinyint(1) unsigned
v DB685940 lz_chat_posts
* id : varchar(32)
* chat_id : varchar(32)
* time : int(11) unsigned
* micro : int(11) unsigned
* sender : varchar(65)
* receiver : varchar(65)
* receiver_group : varchar(32)
* receiver_original : varchar(32)
* text : mediumtext
* translation : mediumtext
* translation_iso : varchar(10)
* received : tinyint(1) unsigned
* persistent : tinyint(1) unsigned
* repost : tinyint(1) unsigned
* sender_name : varchar(255)
* browser_id : varchar(16)
v DB685940 lz_chat_requests
* id : varchar(32)
* created : int(10) unsigned
* sender_system_id : varchar(32)
* sender_group_id : varchar(32)
* receiver_user_id : varchar(32)
* receiver_browser_id : varchar(32)
* event_action_id : varchar(32)
* text : mediumtext
* displayed : tinyint(1) unsigned
* accepted : tinyint(1) unsigned
* declined : tinyint(1) unsigned
* closed : tinyint(1) unsigned
* canceled : varchar(32)
v DB685940 lz_com_chat_localizations
* id : varchar(32)
* tid : varchar(32)
* language : varchar(5)
* title : text
* description : text
* terms : longtext
* email_voucher_created : text
* email_voucher_paid : text
* email_voucher_update : text
* extension_request : text
v DB685940 lz_com_chat_providers
* id : varchar(32)
* name : varchar(32)
* account : varchar(128)
* URL : varchar(256)
v DB685940 lz_com_chat_types
* id : varchar(32)
* number_of_chats : int(10) unsigned
* number_of_chats_void : tinyint(1) unsigned
* total_length : int(10) unsigned
* total_length_void : tinyint(1) unsigned
* auto_expire : int(10) unsigned
* auto_expire_void : tinyint(1) unsigned
* delete : tinyint(1) unsigned
* price : double unsigned
* currency : varchar(5)
v DB685940 lz_com_chat_vouchers
* id : varchar(32)
* extends : varchar(32)
* tid : varchar(32)
* email : varchar(128)
* info : text
* voided : tinyint(1) unsigned
* paid : tinyint(1) unsigned
* created : int(10) unsigned
* first_used : int(10) unsigned
* last_used : int(10) unsigned
* expires : int(10) unsigned
* edited : int(10) unsigned
* chat_time : int(10) unsigned
* chat_time_max : int(10) unsigned
* chat_sessions : int(10) unsigned
* chat_sessions_max : int(10) unsigned
* chat_list : text
* visitor_id : varchar(32)
* business_type : tinyint(1) unsigned
* company : varchar(255)
* tax_id : varchar(255)
* firstname : varchar(255)
* lastname : varchar(255)
* address_1 : varchar(255)
* address_2 : varchar(255)
* city : varchar(255)
* state : varchar(255)
* zip : varchar(255)
* country : varchar(5)
* phone : varchar(255)
* tn_id : varchar(255)
* price : double unsigned
* currency : varchar(5)
* vat : double unsigned
* payer_id : varchar(255)
* payment_details : text
* language : varchar(5)
v DB685940 lz_config
* key : varchar(32)
* value : text
v DB685940 lz_data_cache
* key : varchar(32)
* data : longtext
* time : int(11)
v DB685940 lz_data_updates
* update_tickets : bigint(20) unsigned
* update_archive : bigint(20) unsigned
* update_feedbacks : bigint(20) unsigned
* update_emails : bigint(20) unsigned
* update_events : bigint(20) unsigned
* update_vouchers : bigint(20) unsigned
* update_filters : bigint(20) unsigned
* update_reports : bigint(20) unsigned
v DB685940 lz_events
* id : varchar(32)
* name : varchar(32)
* created : int(10) unsigned
* creator : varchar(32)
* edited : int(10) unsigned
* editor : varchar(32)
* pages_visited : int(10) unsigned
* time_on_site : int(10) unsigned
* max_trigger_amount : int(10) unsigned
* trigger_again_after : int(10) unsigned
* trigger_again_page : tinyint(1) unsigned
* not_declined : tinyint(1) unsigned
* not_accepted : tinyint(1) unsigned
* not_in_chat : tinyint(1) unsigned
* is_in_chat : tinyint(1) unsigned
* priority : int(10) unsigned
* is_active : tinyint(1) unsigned
* search_phrase : varchar(255)
* exclude_mobile : tinyint(1) unsigned
* exclude_countries : varchar(128)
* data_conditions : text
v DB685940 lz_event_actions
* id : varchar(32)
* eid : varchar(32)
* type : tinyint(2) unsigned
* value : mediumtext
v DB685940 lz_event_action_internals
* id : varchar(32)
* created : int(10) unsigned
* trigger_id : varchar(32)
* receiver_user_id : varchar(32)
v DB685940 lz_event_action_overlays
* id : varchar(32)
* action_id : varchar(32)
* position : varchar(2)
* speed : tinyint(1)
* slide : tinyint(1)
* margin_left : int(11)
* margin_top : int(11)
* margin_right : int(11)
* margin_bottom : int(11)
* style : varchar(32)
* close_on_click : tinyint(1) unsigned
* shadow : tinyint(1) unsigned
* shadow_x : tinyint(4)
* shadow_y : tinyint(4)
* shadow_blur : tinyint(3) unsigned
* shadow_color : varchar(6)
* width : int(10) unsigned
* height : int(10) unsigned
* background : tinyint(1) unsigned
* background_opacity : double unsigned
* background_color : varchar(6)
v DB685940 lz_event_action_receivers
* id : varchar(32)
* action_id : varchar(32)
* receiver_id : varchar(32)
v DB685940 lz_event_action_senders
* id : varchar(32)
* pid : varchar(32)
* user_id : varchar(32)
* group_id : varchar(32)
* priority : tinyint(2) unsigned
v DB685940 lz_event_action_website_pushs
* id : varchar(32)
* action_id : varchar(32)
* target_url : varchar(2056)
* ask : tinyint(1)
v DB685940 lz_event_funnels
* eid : varchar(32)
* uid : varchar(32)
* ind : smallint(5) unsigned
v DB685940 lz_event_goals
* event_id : varchar(32)
* goal_id : int(10) unsigned
v DB685940 lz_event_triggers
* id : varchar(32)
* receiver_user_id : varchar(32)
* receiver_browser_id : varchar(32)
* action_id : varchar(32)
* time : int(10) unsigned
* triggered : int(10) unsigned
v DB685940 lz_event_urls
* id : varchar(32)
* eid : varchar(32)
* url : varchar(2048)
* referrer : varchar(2048)
* time_on_site : int(10) unsigned
* blacklist : tinyint(1) unsigned
v DB685940 lz_feedbacks
* id : varchar(32)
* created : int(10) unsigned
* chat_id : varchar(32)
* ticket_id : varchar(32)
* resource_id : varchar(32)
* user_id : varchar(32)
* operator_id : varchar(32)
* group_id : varchar(32)
* data_id : varchar(32)
* ip_hash : varchar(32)
v DB685940 lz_feedback_criteria
* fid : varchar(32)
* cid : varchar(32)
* value : varchar(512)
v DB685940 lz_feedback_criteria_config
* id : varchar(32)
* type : tinyint(1) unsigned
* name : varchar(32)
* title : varchar(128)
v DB685940 lz_filters
* creator : varchar(32)
* created : int(10) unsigned
* type : tinyint(1) unsigned
* editor : varchar(32)
* edited : int(10) unsigned
* ip : varchar(64)
* expiredate : int(10)
* visitor_id : varchar(32)
* reason : text
* name : varchar(255)
* id : varchar(32)
* active : tinyint(1) unsigned
* exertion : tinyint(1) unsigned
* languages : text
* countries : text
* allow_chats : tinyint(1) unsigned
* allow_tickets : tinyint(1) unsigned
* allow_tracking : tinyint(1) unsigned
* email : varchar(128)
* subject : varchar(128)
v DB685940 lz_goals
* id : int(10) unsigned
* title : varchar(255)
* description : text
* conversion : tinyint(1) unsigned
* ind : int(10) unsigned
v DB685940 lz_groups
* id : varchar(32)
* name : varchar(64)
* owner : varchar(32)
* dynamic : tinyint(1) unsigned
* description : text
* external : tinyint(1) unsigned
* internal : tinyint(1) unsigned
* created : int(10) unsigned
* email : varchar(255)
* standard : tinyint(1) unsigned
* opening_hours : text
* functions : varchar(32)
* chat_inputs_hidden : text
* ticket_inputs_hidden : text
* chat_inputs_required : text
* ticket_inputs_required : text
* chat_inputs_masked : text
* ticket_inputs_masked : text
* chat_inputs_cap : text
* ticket_inputs_cap : text
* max_chats : int(10)
* visitor_filters : text
* chat_vouchers_required : text
* pre_chat_js : text
* post_chat_js : text
* ticket_email_out : varchar(32)
* ticket_email_in : text
* ticket_handle_unknown : tinyint(1) unsigned
* chat_email_out : varchar(32)
* ticket_assignment : text
* priorities : text
* priority_sleep : tinyint(1) unsigned
* position : smallint(5) unsigned
v DB685940 lz_group_members
* user_id : varchar(32)
* group_id : varchar(32)
* persistent : tinyint(1) unsigned
v DB685940 lz_images
* id : int(10) unsigned
* button_type : varchar(32)
* image_type : varchar(32)
* online : tinyint(1) unsigned
* data : longtext
v DB685940 lz_info
* version : varchar(15)
* chat_id : int(11) unsigned
* ticket_id : int(11) unsigned
* gtspan : int(11) unsigned
v DB685940 lz_knowledgebase_queries
* id : varchar(32)
* time : int(10) unsigned
* query : int(10) unsigned
* ip_hash : varchar(32)
v DB685940 lz_knowledgebase_views
* id : varchar(32)
* time : int(10) unsigned
* res_id : varchar(32)
v DB685940 lz_mailboxes
* id : varchar(32)
* email : varchar(255)
* exec_operator_id : varchar(32)
* username : varchar(128)
* password : varchar(128)
* type : varchar(16)
* host : varchar(128)
* port : mediumint(8) unsigned
* delete : smallint(5)
* authentication : varchar(32)
* sender_name : varchar(255)
* ssl : tinyint(1) unsigned
* default : tinyint(1) unsigned
* last_connect : int(10) unsigned
* connect_frequency : int(10) unsigned
* framework : varchar(16)
v DB685940 lz_operators
* id : varchar(32)
* system_id : varchar(32)
* client_system_id : varchar(32)
* token : varchar(32)
* fullname : varchar(255)
* description : varchar(255)
* email : varchar(255)
* permissions : varchar(48)
* webspace : int(10) unsigned
* first_active : int(10) unsigned
* last_active : int(10) unsigned
* password : varchar(32)
* password_change_request : tinyint(1) unsigned
* status : tinyint(1) unsigned
* level : tinyint(1) unsigned
* ip : varchar(64)
* typing : varchar(32)
* visitor_file_sizes : mediumtext
* last_chat_allocation : int(10) unsigned
* groups : text
* groups_status : text
* groups_hidden : text
* reposts : text
* languages : varchar(255)
* auto_accept_chats : tinyint(1) unsigned
* login_ip_range : varchar(255)
* websites_users : text
* websites_config : text
* sign_off : tinyint(1) unsigned
* bot : tinyint(1) unsigned
* wm : tinyint(1) unsigned
* wmohca : tinyint(1) unsigned
* lweb : tinyint(1) unsigned
* lapp : tinyint(1) unsigned
* mobile_os : varchar(32)
* mobile_device_id : varchar(4096)
* mobile_background : tinyint(1) unsigned
* mobile_ex : text
* max_chats : tinyint(1)
* ldap : tinyint(1)
v DB685940 lz_operator_logins
* id : varchar(32)
* user_id : varchar(32)
* ip : varchar(64)
* time : int(11) unsigned
* password : varchar(32)
v DB685940 lz_operator_status
* time : int(11) unsigned
* confirmed : int(11) unsigned
* internal_id : varchar(32)
* status : tinyint(1) unsigned
v DB685940 lz_overlay_boxes
* id : varchar(32)
* created : int(10) unsigned
* receiver_user_id : varchar(32)
* receiver_browser_id : varchar(32)
* event_action_id : varchar(32)
* url : text
* content : text
* displayed : tinyint(1) unsigned
* closed : tinyint(1) unsigned
v DB685940 lz_predefined
* id : varchar(32)
* internal_id : varchar(32)
* group_id : varchar(32)
* lang_iso : varchar(5)
* invitation_manual : mediumtext
* invitation_auto : mediumtext
* welcome : mediumtext
* welcome_call_me_back : mediumtext
* website_push_manual : mediumtext
* website_push_auto : mediumtext
* chat_info : mediumtext
* call_me_back_info : mediumtext
* ticket_info : mediumtext
* browser_ident : tinyint(1) unsigned
* is_default : tinyint(1) unsigned
* auto_welcome : tinyint(1) unsigned
* editable : tinyint(1) unsigned
* email_chat_transcript : mediumtext
* email_ticket_responder : mediumtext
* email_ticket_reply : mediumtext
* queue_message : mediumtext
* queue_message_time : int(11)
* subject_chat_transcript : varchar(255)
* subject_ticket_responder : varchar(255)
* subject_ticket_reply : varchar(255)
* email_chat_transcript_html : text
* email_ticket_responder_html : text
* email_ticket_reply_html : text
v DB685940 lz_profiles
* id : varchar(32)
* edited : int(11)
* first_name : varchar(255)
* last_name : varchar(255)
* email : varchar(255)
* company : varchar(255)
* phone : varchar(255)
* fax : varchar(255)
* street : varchar(255)
* zip : varchar(255)
* department : varchar(255)
* city : varchar(255)
* country : varchar(255)
* gender : tinyint(1)
* languages : varchar(1024)
* comments : longtext
* public : tinyint(1)
v DB685940 lz_profile_pictures
* id : varchar(32)
* internal_id : varchar(32)
* time : int(11)
* webcam : tinyint(1)
* data : mediumtext
v DB685940 lz_push_messages
* id : varchar(32)
* created : int(10) unsigned
* device_id : varchar(4096)
* device_hash : varchar(32)
* device_os : varchar(32)
* chat_id : varchar(32)
* chat_partner_id : varchar(32)
* push_key : tinyint(3) unsigned
* push_value : varchar(255)
* IP : varchar(64)
* sent : tinyint(1) unsigned
v DB685940 lz_resources
* id : varchar(32)
* owner : varchar(32)
* editor : varchar(32)
* value : longtext
* edited : int(11) unsigned
* title : varchar(255)
* created : int(11) unsigned
* type : tinyint(1) unsigned
* discarded : tinyint(1) unsigned
* parentid : varchar(32)
* size : bigint(20) unsigned
* tags : varchar(255)
* languages : varchar(32)
* kb_public : tinyint(1) unsigned
* kb_bot : tinyint(1) unsigned
* shortcut_word : varchar(32)
v DB685940 lz_signatures
* id : varchar(32)
* name : varchar(256)
* signature : text
* operator_id : varchar(32)
* group_id : varchar(32)
* default : tinyint(1) unsigned
v DB685940 lz_social_media_channels
* id : varchar(32)
* name : varchar(32)
* group_id : varchar(32)
* page_id : varchar(32)
* type : varchar(16)
* stream_type : int(10) unsigned
* token : text
* token_expire : int(10) unsigned
* last_connect : int(10) unsigned
* data_since : varchar(32)
* connect_frequency : int(10) unsigned
* track : text
v DB685940 lz_stats_aggs
* year : smallint(4) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* time : int(10) unsigned
* mtime : int(10) unsigned
* sessions : int(10) unsigned
* visitors_unique : int(10) unsigned
* conversions : int(10) unsigned
* aggregated : int(10) unsigned
* chats_forwards : int(10) unsigned
* chats_posts_internal : int(10) unsigned
* chats_posts_external : int(10) unsigned
* avg_time_site : double unsigned
v DB685940 lz_stats_aggs_availabilities
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* hour : tinyint(2) unsigned
* user_id : varchar(32)
* group_id : varchar(32)
* status : tinyint(1) unsigned
* seconds : int(4) unsigned
v DB685940 lz_stats_aggs_browsers
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* browser : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_chats
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* hour : tinyint(2) unsigned
* user_id : varchar(32)
* group_id : varchar(32)
* amount : int(10) unsigned
* accepted : int(10) unsigned
* declined : int(10) unsigned
* avg_duration : double unsigned
* avg_waiting_time : double unsigned
* avg_response_time : double unsigned
* chat_posts : int(10) unsigned
* multi : tinyint(1) unsigned
* invites : int(10) unsigned
* invites_auto : int(10) unsigned
* invites_accepted : int(10) unsigned
* invites_declined : int(10) unsigned
v DB685940 lz_stats_aggs_cities
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* city : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_countries
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* country : varchar(2)
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_crawlers
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* crawler : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_domains
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* domain : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_durations
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* duration : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_feedbacks
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* operator_id : varchar(32)
* group_id : varchar(32)
* amount : int(10) unsigned
* ca : double unsigned
* cb : double unsigned
* cc : double unsigned
* cd : double unsigned
v DB685940 lz_stats_aggs_goals
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* goal : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_goals_queries
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* goal : int(10) unsigned
* query : int(10) unsigned
* amount : int(10) unsigned
* type : tinyint(1) unsigned
v DB685940 lz_stats_aggs_isps
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* isp : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_knowledgebase
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* res_id : varchar(32)
* views : int(10) unsigned
* rate_amount : int(10) unsigned
* rate_positive : int(10) unsigned
v DB685940 lz_stats_aggs_languages
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* language : varchar(5)
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_pages
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* url : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_pages_entrance
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* url : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_pages_exit
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* url : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_queries
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* query : int(10) unsigned
* amount : int(10) unsigned
* type : tinyint(1) unsigned
v DB685940 lz_stats_aggs_referrers
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* referrer : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_regions
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* region : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_resolutions
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* resolution : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_search_engines
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* domain : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_systems
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* system : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_stats_aggs_tickets
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* hour : tinyint(2) unsigned
* user_id : varchar(32)
* group_id : varchar(32)
* amount : int(10) unsigned
* open : int(10) unsigned
* in_progress : int(10) unsigned
* closed : int(10) unsigned
* deleted : int(10) unsigned
* messages : int(10) unsigned
* responses : int(10) unsigned
* avg_response_time : double unsigned
* resolves : int(10) unsigned
* avg_resolve_time : double unsigned
v DB685940 lz_stats_aggs_visitors
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* hour : tinyint(3) unsigned
* visitors_unique : int(10) unsigned
* page_impressions : int(10) unsigned
* visitors_recurring : int(10) unsigned
* bounces : int(10) unsigned
* search_engine : int(10) unsigned
* from_referrer : int(10) unsigned
* browser_instances : int(10) unsigned
* js : int(10) unsigned
* on_chat_page : int(10) unsigned
v DB685940 lz_stats_aggs_visits
* year : smallint(5) unsigned
* month : tinyint(3) unsigned
* day : tinyint(3) unsigned
* visits : int(10) unsigned
* amount : int(10) unsigned
v DB685940 lz_tickets
* id : varchar(32)
* user_id : varchar(32)
* target_group_id : varchar(32)
* hash : varchar(32)
* channel_type : tinyint(1) unsigned
* sub_channel : varchar(32)
* iso_language : varchar(5)
* deleted : tinyint(1) unsigned
* last_update : int(10) unsigned
* wait_begin : int(10)
* channel_id : varchar(32)
* channel_conversation_id : varchar(128)
* auto_status_time : int(10) unsigned
* auto_status_status : tinyint(1) unsigned
* priority : tinyint(1)
v DB685940 lz_ticket_attachments
* res_id : varchar(32)
* parent_id : varchar(255)
v DB685940 lz_ticket_comments
* id : varchar(32)
* created : int(10) unsigned
* time : int(10) unsigned
* ticket_id : varchar(32)
* message_id : varchar(32)
* operator_id : varchar(32)
* comment : text
v DB685940 lz_ticket_customs
* ticket_id : varchar(32)
* message_id : varchar(32)
* custom_id : varchar(32)
* value : varchar(255)
v DB685940 lz_ticket_editors
* ticket_id : varchar(32)
* editor_id : varchar(32)
* group_id : varchar(32)
* status : tinyint(1) unsigned
* sub_status : varchar(32)
* time : int(10) unsigned
v DB685940 lz_ticket_emails
* email_id : varchar(255)
* mailbox_id : varchar(32)
* sender_email : varchar(255)
* sender_name : varchar(255)
* sender_replyto : varchar(255)
* receiver_email : varchar(255)
* created : int(10) unsigned
* edited : int(10) unsigned
* deleted : tinyint(1) unsigned
* subject : varchar(255)
* body : text
* body_html : longtext
* group_id : varchar(32)
* editor_id : varchar(32)
v DB685940 lz_ticket_logs
* created : int(10) unsigned
* time : int(10) unsigned
* ticket_id : varchar(32)
* operator_id : varchar(32)
* action : smallint(5) unsigned
* value_old : text
* value_new : text
* message_id : varchar(32)
v DB685940 lz_ticket_messages
* id : varchar(32)
* time : int(11) unsigned
* created : int(11) unsigned
* ticket_id : varchar(32)
* text : mediumtext
* fullname : varchar(255)
* email : varchar(255)
* company : varchar(255)
* ip : varchar(64)
* phone : varchar(255)
* call_me_back : tinyint(1) unsigned
* country : varchar(5)
* type : tinyint(1) unsigned
* sender_id : varchar(32)
* channel_id : varchar(255)
* hash : varchar(32)
* subject : varchar(512)
v DB685940 lz_ticket_subs
* id : varchar(32)
* type : tinyint(1) unsigned
* parent_id : varchar(32)
v DB685940 lz_ticket_watcher
* ticket_id : int(10) unsigned
* operator_id : varchar(32)
* created : int(10) unsigned
v DB685940 lz_user_data
* id : varchar(32)
* create : int(10) unsigned
* h_fullname : varchar(254)
* h_email : varchar(254)
* h_company : varchar(254)
* h_phone : varchar(254)
* h_customs : text
* h_text : text
v DB685940 lz_visitors
* id : varchar(32)
* entrance : int(10) unsigned
* last_active : int(10) unsigned
* host : varchar(255)
* ip : varchar(64)
* system : int(11) unsigned
* browser : int(11) unsigned
* visits : int(11) unsigned
* visit_id : varchar(7)
* visit_latest : tinyint(1) unsigned
* visit_last : int(10) unsigned
* resolution : int(11) unsigned
* language : varchar(5)
* country : varchar(2)
* city : int(10) unsigned
* region : int(10) unsigned
* isp : int(10) unsigned
* timezone : varchar(24)
* latitude : double
* longitude : double
* geo_result : int(10) unsigned
* js : tinyint(1) unsigned
* signature : varchar(32)
v DB685940 lz_visitor_browsers
* id : varchar(32)
* visitor_id : varchar(32)
* visit_id : varchar(7)
* data_id : varchar(32)
* created : int(10) unsigned
* last_active : int(10) unsigned
* last_update : varchar(2)
* is_chat : tinyint(1) unsigned
* query : int(10) unsigned
* url_entrance : int(10) unsigned
* url_exit : int(10) unsigned
* pre_message : mediumtext
* overlay : tinyint(1) unsigned
* overlay_container : tinyint(1) unsigned
v DB685940 lz_visitor_browser_urls
* browser_id : varchar(32)
* entrance : int(10) unsigned
* referrer : int(10) unsigned
* url : int(10) unsigned
* params : text
* untouched : text
* title : text
* ref_untouched : text
* is_entrance : tinyint(1) unsigned
* is_exit : tinyint(1) unsigned
* area_code : varchar(255)
v DB685940 lz_visitor_chats
* visitor_id : varchar(32)
* browser_id : varchar(32)
* visit_id : varchar(32)
* chat_id : int(11) unsigned
* priority : tinyint(1) unsigned
* call_me_back : tinyint(1) unsigned
* status : tinyint(1) unsigned
* typing : tinyint(1) unsigned
* waiting : tinyint(1) unsigned
* area_code : varchar(255)
* first_active : int(10) unsigned
* last_active : int(10) unsigned
* qpenalty : int(10) unsigned
* request_operator : varchar(32)
* request_group : varchar(32)
* allocated : int(11) unsigned
* archive_created : tinyint(1) unsigned
* internal_active : tinyint(1) unsigned
* internal_closed : tinyint(1) unsigned
* internal_declined : tinyint(1) unsigned
* external_active : tinyint(1) unsigned
* external_close : tinyint(1) unsigned
* exit : int(11) unsigned
* queue_message_shown : tinyint(1) unsigned
* chat_ticket_id : varchar(32)
* response_time : int(11) unsigned
* chat_posts : int(11) unsigned
* queue_posts : text
* init_chat_with : varchar(32)
* translation : varchar(16)
v DB685940 lz_visitor_chat_operators
* chat_id : int(10) unsigned
* user_id : varchar(32)
* declined : tinyint(1) unsigned
* dtime : int(10) unsigned
* ltime : int(10) unsigned
* jtime : int(10) unsigned
* status : tinyint(1) unsigned
* alloc : tinyint(1) unsigned
v DB685940 lz_visitor_comments
* id : varchar(32)
* visitor_id : varchar(32)
* created : int(10) unsigned
* operator_id : varchar(32)
* comment : text
v DB685940 lz_visitor_data_browsers
* id : int(11) unsigned
* browser : varchar(255)
* type : tinyint(1) unsigned
v DB685940 lz_visitor_data_cities
* id : int(11)
* city : varchar(255)
v DB685940 lz_visitor_data_crawlers
* id : int(10) unsigned
* crawler : varchar(255)
v DB685940 lz_visitor_data_domains
* id : bigint(10) unsigned
* domain : varchar(255)
* external : tinyint(1) unsigned
* search : tinyint(1) unsigned
v DB685940 lz_visitor_data_isps
* id : int(11)
* isp : varchar(255)
v DB685940 lz_visitor_data_pages
* id : bigint(10) unsigned
* domain : int(10) unsigned
* path : int(10) unsigned
* title : int(10) unsigned
v DB685940 lz_visitor_data_paths
* id : int(10) unsigned
* path : varchar(255)
v DB685940 lz_visitor_data_queries
* id : int(10) unsigned
* query : varchar(255)
v DB685940 lz_visitor_data_regions
* id : int(11)
* region : varchar(255)
v DB685940 lz_visitor_data_resolutions
* id : int(11)
* resolution : varchar(32)
v DB685940 lz_visitor_data_systems
* id : int(10) unsigned
* system : varchar(255)
v DB685940 lz_visitor_data_titles
* id : int(10) unsigned
* title : varchar(255)
* confirmed : int(10) unsigned
v DB685940 lz_visitor_goals
* visitor_id : varchar(32)
* goal_id : int(10) unsigned
* time : int(10) unsigned
* first_visit : tinyint(1) unsigned
* query : int(10) unsigned
v DB685940 lz_website_pushs
* id : varchar(32)
* created : int(10) unsigned
* sender_system_id : varchar(32)
* receiver_user_id : varchar(32)
* receiver_browser_id : varchar(32)
* text : mediumtext
* ask : tinyint(1) unsigned
* target_url : varchar(2048)
* displayed : tinyint(1) unsigned
* accepted : tinyint(1) unsigned
* declined : tinyint(1) unsigned
v DB685940 mein_verein
* DBINDEX : int(11)
* ART : int(11)
* NUMMER : int(11)
* ANREDE : char(30)
* TITEL : char(30)
* NACHNAMEFIRMA : char(50)
* VORNAME : char(50)
* ZUSATZ : char(50)
* STRASSE : char(50)
* LAND : char(5)
* PLZ : char(10)
* ORT : char(50)
* TELEFON1 : char(40)
* TELEFON2 : char(40)
* FAX : char(40)
* MOBILTELEFON : char(40)
* EMAIL : char(50)
* WEBSEITE : char(50)
* DEBITORENNUMMER : char(10)
* ANMERKUNGEN : blob
* INDIVIDUELL1 : char(50)
* INDIVIDUELL2 : char(50)
* INDIVIDUELL3 : char(50)
* INDIVIDUELL4 : char(50)
* INDIVIDUELL5 : char(50)
* GEBURTSTAG : date
* FAMILIENSTATUS : int(11)
* EINTRITTSDATUM : date
* AUSTRITTSDATUM : date
* AKTIVVON : date
* AKTIVBIS : date
* ANSPRECHPARTNER_ANREDE : char(30)
* ANSPRECHPARTNER_TITEL : char(30)
* ANSPRECHPARTNER_NACHNAME : char(30)
* ANSPRECHPARTNER_VORNAME : char(20)
* ANSPRECHPARTNER_POSITION : char(30)
* ANSPRECHPARTNER_TELEFON1 : char(40)
* ANSPRECHPARTNER_TELEFON2 : char(40)
* ANSPRECHPARTNER_FAX : char(40)
* ANSPRECHPARTNER_MOBILTELEFON : char(40)
* ANSPRECHPARTNER_EMAIL : char(50)
* SORT_FUNKTION : int(3)
* FUNKTION : char(30)
v DB685940 mein_verein-1
* DBINDEX : int(11)
* ART : int(11)
* NUMMER : int(11)
* ANREDE : char(30)
* TITEL : char(30)
* NACHNAMEFIRMA : char(50)
* VORNAME : char(50)
* ZUSATZ : char(50)
* STRASSE : char(50)
* LAND : char(5)
* PLZ : char(10)
* ORT : char(50)
* TELEFON1 : char(40)
* TELEFON2 : char(40)
* FAX : char(40)
* MOBILTELEFON : char(40)
* EMAIL : char(50)
* WEBSEITE : char(50)
* DEBITORENNUMMER : char(10)
* ANMERKUNGEN : blob
* INDIVIDUELL1 : char(50)
* INDIVIDUELL2 : char(50)
* INDIVIDUELL3 : char(50)
* INDIVIDUELL4 : char(50)
* INDIVIDUELL5 : char(50)
* GEBURTSTAG : date
* FAMILIENSTATUS : int(11)
* EINTRITTSDATUM : date
* AUSTRITTSDATUM : date
* AKTIVVON : date
* AKTIVBIS : date
* ANSPRECHPARTNER_ANREDE : char(30)
* ANSPRECHPARTNER_TITEL : char(30)
* ANSPRECHPARTNER_NACHNAME : char(30)
* ANSPRECHPARTNER_VORNAME : char(20)
* ANSPRECHPARTNER_POSITION : char(30)
* ANSPRECHPARTNER_TELEFON1 : char(40)
* ANSPRECHPARTNER_TELEFON2 : char(40)
* ANSPRECHPARTNER_FAX : char(40)
* ANSPRECHPARTNER_MOBILTELEFON : char(40)
* ANSPRECHPARTNER_EMAIL : char(50)
* FUNKTION : char(30)
v DB685940 mein_verein-bak
* DBINDEX : int(11)
* ART : int(11)
* NUMMER : int(11)
* ANREDE : char(30)
* TITEL : char(30)
* NACHNAMEFIRMA : char(50)
* VORNAME : char(50)
* ZUSATZ : char(50)
* STRASSE : char(50)
* LAND : char(5)
* PLZ : char(10)
* ORT : char(50)
* TELEFON1 : char(40)
* TELEFON2 : char(40)
* FAX : char(40)
* MOBILTELEFON : char(40)
* EMAIL : char(50)
* WEBSEITE : char(50)
* DEBITORENNUMMER : char(10)
* ANMERKUNGEN : blob
* INDIVIDUELL1 : char(50)
* INDIVIDUELL2 : char(50)
* INDIVIDUELL3 : char(50)
* INDIVIDUELL4 : char(50)
* INDIVIDUELL5 : char(50)
* GEBURTSTAG : date
* FAMILIENSTATUS : int(11)
* EINTRITTSDATUM : date
* AUSTRITTSDATUM : date
* AKTIVVON : date
* AKTIVBIS : date
* ANSPRECHPARTNER_ANREDE : char(30)
* ANSPRECHPARTNER_TITEL : char(30)
* ANSPRECHPARTNER_NACHNAME : char(30)
* ANSPRECHPARTNER_VORNAME : char(20)
* ANSPRECHPARTNER_POSITION : char(30)
* ANSPRECHPARTNER_TELEFON1 : char(40)
* ANSPRECHPARTNER_TELEFON2 : char(40)
* ANSPRECHPARTNER_FAX : char(40)
* ANSPRECHPARTNER_MOBILTELEFON : char(40)
* ANSPRECHPARTNER_EMAIL : char(50)
* FUNKTION : varchar(30)
v DB685940 pma__bookmark
* id : int(10) unsigned
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v DB685940 pma__central_columns
* db_name : varchar(64)
* col_name : varchar(64)
* col_type : varchar(64)
* col_length : text
* col_collation : varchar(64)
* col_isNull : tinyint(1)
* col_extra : varchar(255)
* col_default : text
v DB685940 pma__column_info
* id : int(5) unsigned
* db_name : varchar(64)
* table_name : varchar(64)
* column_name : varchar(64)
* comment : varchar(255)
* mimetype : varchar(255)
* transformation : varchar(255)
* transformation_options : varchar(255)
* input_transformation : varchar(255)
* input_transformation_options : varchar(255)
v DB685940 pma__designer_settings
* username : varchar(64)
* settings_data : text
v DB685940 pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v DB685940 pma__favorite
* username : varchar(64)
* tables : text
v DB685940 pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v DB685940 pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v DB685940 pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v DB685940 pma__recent
* username : varchar(64)
* tables : text
v DB685940 pma__relation
* master_db : varchar(64)
* master_table : varchar(64)
* master_field : varchar(64)
* foreign_db : varchar(64)
* foreign_table : varchar(64)
* foreign_field : varchar(64)
v DB685940 pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v DB685940 pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v DB685940 pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v DB685940 pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v DB685940 pma__tracking
* db_name : varchar(64)
* table_name : varchar(64)
* version : int(10) unsigned
* date_created : datetime
* date_updated : datetime
* schema_snapshot : text
* schema_sql : text
* data_sql : longtext
* tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
* tracking_active : int(1) unsigned
v DB685940 pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v DB685940 pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v DB685940 pma__users
* username : varchar(64)
* usergroup : varchar(64)
v DB685940 vereine_personal_neu
* id : int(4)
* vor : varchar(20)
* nam : varchar(20)
* str : varchar(25)
* plz : int(5)
* ort : varchar(30)
* geb : date
* kontakt : varchar(40)
* tel : varchar(20)
* telgesch : varchar(20)
* mobil : varchar(20)
* fax : varchar(20)
* email : varchar(40)
* url : varchar(40)
* eintritt : date
* hilf1 : char(3)
* hilf2 : char(3)
* hilf3 : char(3)
* tot : date
* zugriff : char(3)
* funktion1 : varchar(40)
* funktion2 : varchar(40)
* stat : varchar(40)
* lfd : int(3)
* nr : int(5)
* verein : varchar(40)
* kurz : varchar(5)
Erzeuge Verknüpfung
FOREIGN KEY
on delete
on update
Verknüpfung löschen