Database Schema

Database Schema

wp_oads_impressions

sqlid          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
ad_id       BIGINT UNSIGNED NOT NULL
page_url    VARCHAR(500)
section     VARCHAR(100)
visitor_ip  VARCHAR(45)
user_agent  VARCHAR(500)
created_at  DATETIME DEFAULT CURRENT_TIMESTAMP

INDEX idx_ad_id (ad_id)
INDEX idx_created (created_at)
INDEX idx_section (section)

wp_oads_clicks

sqlid          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
ad_id       BIGINT UNSIGNED NOT NULL
page_url    VARCHAR(500)
section     VARCHAR(100)
visitor_ip  VARCHAR(45)
user_agent  VARCHAR(500)
referrer    VARCHAR(500)
created_at  DATETIME DEFAULT CURRENT_TIMESTAMP

wp_oads_zones

sqlid              BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
name            VARCHAR(100)
slug            VARCHAR(100) UNIQUE
max_width       INT UNSIGNED
max_height      INT UNSIGNED
fill_priority   ENUM('direct','house','remnant')
adsense_code    TEXT
created_at      DATETIME DEFAULT CURRENT_TIMESTAMP

wp_oads_groups

sqlid              BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
name            VARCHAR(100)
rotation_type   ENUM('random','roundrobin','ab')
ab_winner       BIGINT UNSIGNED DEFAULT 0
created_at      DATETIME DEFAULT CURRENT_TIMESTAMP