#Database
MariaDB 10.6 with the schemafreundea_website
.
#Tables
#Content
| Table |
Description |
hp_sites |
|
| Page content (title, description, meta tags, content) |
|
hp_events |
|
| Club events (name, description, date, location, organizer) |
|
hp_events_fremd |
|
| External events |
|
hp_characters |
|
| Characters (nickname, image URLs, description, visibility, sorting) |
|
hp_header |
|
| Header images (including special event variants) |
|
hp_downloads |
|
| Download files with counter |
|
hp_newsletter |
|
| Newsletter articles |
|
hp_press |
|
| Press articles |
|
#FAQ
| Table |
Description |
hp_qa |
|
| General FAQ |
|
hp_qa_rd |
|
| RhönDance FAQ |
|
hp_qa_rent_suit |
|
| Fursuit Rental FAQ |
|
#Fursuit Rental
| Table |
Description |
rent_fursuits |
|
| Inventory (Name, Rental Prices, Availability, Weight/Size Limits) |
|
rent_fursuit_type |
|
| Suit Types |
|
rent_fursuit_parts |
|
| Suit Components |
|
rent_fursuit_x_parts |
|
| Suit-to-Part Assignment |
|
#Photos
| Table |
Description |
event_link_archive |
|
| Photo Archive Metadata |
|
event_links |
|
| Photo Links per Event |
|
#Users & Security
| Table |
Description |
users |
|
| User system (Telegram auth with metadata) |
|
hp_userdata |
|
| Old user system (nickname, Telegram handle) |
|
security_keys |
|
| API/security keys |
|
#Payments
| Table |
Description |
Zahlungsbestaetigung |
|
| Payment confirmations (badge numbers, status) |
|
Zahlungserinnerungen |
|
| Payment reminders/invoices |
|
#Configuration
The database connection is defined inlib/config.php
(INI format):
db[driver] = 'mysql'
db[user] = ''
db[password] = ''
db[server] = 'localhost'
db[port] = '3306'
db[database] = 'freundea_website'