Drop files here

SQL upload ( 0 ) x-

Server: rdbms.strato.de »Database: DB685940
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time
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_tel":1,"DB685940.gs_lv_daten":1,"DB685940.gs_mein_verein":1,"DB685940.gs_rcg_db":1,"DB685940.gs_rezepte":1,"DB685940.mein_verein":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_tel":1,"DB685940.gs_lv_daten":1,"DB685940.gs_mein_verein":1,"DB685940.gs_rcg_db":1,"DB685940.gs_rezepte":1,"DB685940.mein_verein":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_tel":"ANREDE","gs_lv_daten":"nam","gs_mein_verein":"Anrede","gs_rcg_db":"vor","gs_rezepte":"gruppe","mein_verein":"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
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
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_tel
DB685940.gs_lv_daten
DB685940.gs_mein_verein
DB685940.gs_rcg_db
DB685940.gs_rezepte
DB685940.mein_verein
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
Number of tables: 33
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(25)
* veranstaltung : varchar(25)
* raum : varchar(25)
* name : varchar(25)
* datum : date
* monat : varchar(20)
* tag : varchar(20)
* uhrzeit : varchar(5)
* wirt : varchar(28)
* 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_tel
* NUMMER : int(5)
* ANREDE : char(5)
* VORNAME : char(40)
* NACHNAME : char(40)
* STRASSE : char(40)
* LAND : char(5)
* PLZ : char(10)
* ORT : char(40)
* TELEFON : char(40)
* FAX : char(40)
* MOBIL : char(40)
* E_MAIL : char(50)
* FUNKTION : char(40)
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_mein_verein
* Nr : int(3)
* Anrede : varchar(5)
* Vorname : char(50)
* Nachname : char(50)
* Strasse : char(50)
* PLZ : char(10)
* Ort : char(50)
* E_Mail : char(50)
* Webseite : char(50)
* Telefon : char(40)
* Mobil : char(40)
* Geburtstag : date
* Mitglied_seit : date
* Funktion : char(50)
* Gruendungsmitglied : varchar(2)
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 mein_verein
* Nr : int(3)
* Anrede : varchar(5)
* Vorname : char(50)
* Nachname : char(50)
* Straße : char(50)
* PLZ : char(10)
* Ort : char(50)
* E-Mail : char(50)
* Webseite : char(50)
* Telefon : char(40)
* Mobil : char(40)
* Geburtstag : date
* Mitglied seit : date
* Ebene 2 : char(50)
* Gründungsmitglied : varchar(2)
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)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship