In the attached files, you will find a detailed description of the database tables pgdating_db_connections and the connections between them pgdating_db_structure.mwb

Product Structure

Overview:

Section	Description
`config.php`	Main configuration file defining constants.
`application/config`	General site settings.
`application/config/install.php`	Settings for module installation.
`Router.php`	Library managing routing for the application.
`Pg_theme.php`	Theme configurations and styles.

Technical documentation (2012)

A prefix is added to the name of each table during the installation process.

General settings

Basic settings

settings: Contains all the primary settings of the website.
elements: Fields and settings for the form builder.
maintenance: Pages for server warnings and maintenance notices.
language: Installed site languages and their parameters.
menu: Website menu configurations.
distance_spr: Reference table for search distances.
cron: Cron job schedules. Scripts executed before the scheduled time will not run.
ip_country: IP addresses associated with countries.
block_ip: List of IP addresses or countries blocked from accessing the site.
ip_cache: Cache for IP addresses.
server_errors: Pages displaying server errors.
servers: List of site servers and domains.
seo_files_assoc: SEO page names for different languages.
metatags: Metadata for site pages (title, keywords, description).

Design and Templates

special_logotype: Special and holiday logos.
templates: Site templates.
themes: Site themes.
color_theme: Color themes for the site.
slider_picture: Images for the slider on the index page.
video_site: Videos for the index page.
carousel: Carousel with user photos.

Users

User tables

user: Table containing basic user data (name, surname, login, password, email, etc.).
mailbox: User mailbox.
mailbox_attaches: Files attached to user emails.
user_mailbox_settings: Settings for cleaning up user mailboxes.
shoutbox_messages: User messages in the shoutbox.
account_alerts: Messages sent by the site administrator to users.
kisslist: Virtual kisses between users.
kisslist_spr: Reference table for types of kisses.
blacklist: User's blacklist.
hotlist: User's friends list.
hotlist_spr: Reference table for types of friends.
user_upload: Table for user-uploaded files (photos, audio, video).
audio_files_info: Information about uploaded audio files.
servers: Main server parameters, including file upload configurations.
user_albums: User multimedia albums.
country_spr: Country reference table.
region_spr: Region reference table.
city_spr: City reference table.
profile_visit: Table for user profile visit statistics.
subscribe_user: User subscriptions to notifications.
subscribe_system: Types of notifications.
user_voip: Information on user VOIP calls.
user_rating: User ratings.
user_pair: ID of the user's pair for partner profiles.
user_ip: Visitor IP addresses.
active_sessions: Information on current user sessions.
user_topten: Top users.
user_percent: Information on profile completion percentages.
user_vkontakte_connect: Settings for the VKontakte Connect application.
user_facebook_connect: Settings for the Facebook Connect application.
user_match: Desired partner attributes for users.
org_user_site_profiles: User profiles on other sites (organizer).
org_user_home_options: User page settings (organizer).
org_user_layouts: Color and design settings for the user page (organizer).
org_user_bookmarks: User bookmarks (organizer).
org_user_calendar_actions: Events in the user's calendar (organizer).
notifications_user: User notifications.
notifications: Reference table for notification types.

Authentication and permissions

Authentication and group permissions

active_sessions: Stores user session information.
groups: User groups on the site.
group_period: Periods for user groups.
billing_user_period: User's association with a group period.
modules: Contains information about modules.
module_file: Information about module files.
group_module: Stores module associations with groups.
user_group: Stores user group associations.
groups_permissions: Quantitative values of permissions for groups.
permissions: List of permission values for groups.

Wall and Events

Wall and Event tables

events: Table for user wall events.
comments: Comments on walls and user photos.
comment_type: Types of comments.
comment_count: Comment statistics.
likes: Likes on user photos in galleries and walls.

Payment systems

Payment configuration

billing_systems: Service table storing general payment system settings.
billing_sys_*: Tables for individual payment system settings.
Examples:
- billing_sys_2checkout: 2Checkout payment system settings.
- billing_sys_paypal: PayPal payment system settings.
- billing_sys_webmoney: WebMoney payment system settings.
billing_periods_ccbill: Period settings for the CCBill payment system.
billing_user_account: Current account balance of the user.
billing_send_requests: List of payment attempts (successful and unsuccessful).
billing_entry: User payment statistics.
billing_unit: Payment currency.
payment_services_settings: Settings for paid site services.