Vorhandene Spalten in der branches-Tabelle:
- id (int(11))
- name (varchar(100))
- address (text)
- phone (varchar(50))
- fritzbox_ip (varchar(50))
- fritzbox_username (varchar(100))
- fritzbox_password (varchar(255))
- vpn_config (text)
- vpn_username (varchar(255))
- vpn_password (varchar(255))
- vpn_enabled (tinyint(1))
- sip_server (varchar(255))
- sip_domain (varchar(255))
- sip_username (varchar(255))
- sip_password (varchar(255))
- sip_port (varchar(10))
- sip_enabled (tinyint(1))
- asterisk_server (varchar(255))
- asterisk_port (varchar(10))
- asterisk_username (varchar(255))
- asterisk_password (varchar(255))
- webrtc_enabled (tinyint(1))
- created_at (datetime)
- updated_at (datetime)
- street (varchar(255))
- postal_code (varchar(20))
- city (varchar(255))
- email (varchar(255))
- notes (text)
- fritzbox_port (varchar(10))

Daten für Branch ID 1:
- id: 1
- name: DTec-Shop Freudenstadt
- address: NULL
- phone: +4974415202909
- fritzbox_ip: 35e7mnkxh0pe5ypo.myfritz.net
- fritzbox_username: halim.kahraman
- fritzbox_password: kahramha75513
- vpn_config: NULL
- vpn_username: NULL
- vpn_password: NULL
- vpn_enabled: 0
- sip_server: NULL
- sip_domain: NULL
- sip_username: NULL
- sip_password: NULL
- sip_port: 5060
- sip_enabled: 0
- asterisk_server: NULL
- asterisk_port: 8088
- asterisk_username: NULL
- asterisk_password: NULL
- webrtc_enabled: 0
- created_at: 2025-05-16 12:59:29
- updated_at: 2025-05-16 16:22:07
- street: Loßburger Str. 10
- postal_code: 72250
- city: Freudenstadt
- email: shop@dtec-group.de
- notes: DTec Filiale Freudenstadt
- fritzbox_port: 43415