WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
U...' at line 20]CREATE TABLE IF NOT EXISTS wp_author_followers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
author_id bigint(20) unsigned NOT NULL,
follower_id bigint(20) unsigned NOT NULL DEFAULT 0,
follower_type varchar(20) DEFAULT 'user',
push_token_hash varchar(64) DEFAULT NULL,
fallback_fingerprint varchar(64) DEFAULT NULL,
device_id varchar(64) DEFAULT NULL,
status tinyint(1) unsigned NOT NULL DEFAULT 1,
language varchar(10) NOT NULL DEFAULT 'en',
notification_pref tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
follow_date datetime DEFAULT CURRENT_TIMESTAMP,
unfollow_date datetime DEFAULT NULL,
unsubscribe_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY unique_follow (author_id, follower_id, language),
UNIQUE KEY unique_push_token_author (push_token_hash, author_id),
UNIQUE KEY unique_fallback_author (fallback_fingerprint, author_id),
UNIQUE KEY unique_unsubscribe_token (unsubscribe_token),
KEY idx_author_status (author_id, status),
KEY idx_follower_status (follower_id, status),
KEY idx_language (language),
KEY idx_push_token (push_token_hash),
KEY idx_fallback (fallback_fingerprint),
KEY idx_created (created_at),
KEY idx_engagement (engagement_score),
KEY idx_unsubscribe (unsubscribe_token)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, stat...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notification_queue (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL,
author_id bigint(20) unsigned NOT NULL,
recipient_id bigint(20) unsigned NOT NULL,
push_token_hash varchar(64) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
type varchar(20) NOT NULL DEFAULT 'push',
channel_try tinyint(1) unsigned NOT NULL DEFAULT 0,
delivery_priority tinyint(1) unsigned NOT NULL DEFAULT 0,
status tinyint(1) unsigned NOT NULL DEFAULT 0,
error_message text DEFAULT NULL,
retry_count tinyint(1) unsigned NOT NULL DEFAULT 0,
max_retries tinyint(1) unsigned NOT NULL DEFAULT 3,
scheduled_at datetime DEFAULT NULL,
processed_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_status (status),
KEY idx_recipient (recipient_id, status),
KEY idx_push_token (push_token_hash),
KEY idx_priority (delivery_priority, status),
KEY idx_created (created_at),
KEY idx_scheduled (scheduled_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (us...' at line 21]CREATE TABLE IF NOT EXISTS wp_uafs_notifications (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
author_id bigint(20) unsigned NOT NULL DEFAULT 0,
title varchar(255) NOT NULL,
message text NOT NULL,
url varchar(500) DEFAULT NULL,
author varchar(255) DEFAULT NULL,
thumbnail varchar(500) DEFAULT NULL,
is_read tinyint(1) unsigned NOT NULL DEFAULT 0,
is_important tinyint(1) unsigned NOT NULL DEFAULT 0,
is_saved tinyint(1) unsigned NOT NULL DEFAULT 0,
is_hidden tinyint(1) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
notification_type varchar(20) DEFAULT 'inapp',
read_at datetime DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_read (user_id, is_read),
KEY idx_user_created (user_id, created_at),
KEY idx_push_token (push_token_hash),
KEY idx_created (created_at),
KEY idx_important (is_important),
KEY idx_saved (is_saved)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_...' at line 16]CREATE TABLE IF NOT EXISTS wp_uafs_push_tokens (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
token text NOT NULL,
token_hash varchar(64) NOT NULL,
device_info varchar(255) DEFAULT NULL,
language varchar(10) NOT NULL DEFAULT 'en',
is_active tinyint(1) unsigned NOT NULL DEFAULT 1,
engagement_score float DEFAULT 0,
last_used timestamp NULL DEFAULT NULL,
expires_at timestamp NULL DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
UNIQUE KEY token_hash (token_hash),
KEY idx_user_active (user_id, is_active),
KEY idx_expires (expires_at),
KEY idx_engagement (engagement_score),
KEY idx_language (language)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (c...' at line 17]CREATE TABLE IF NOT EXISTS wp_najibul_notification_analytics (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT 0,
notification_id bigint(20) unsigned NOT NULL DEFAULT 0,
push_token_hash varchar(64) DEFAULT NULL,
action_type varchar(20) NOT NULL,
time_of_day int(11) NOT NULL DEFAULT 0,
day_of_week int(11) NOT NULL DEFAULT 0,
response_time int(11) DEFAULT 0,
engagement_score float DEFAULT 0,
device_type varchar(20) DEFAULT NULL,
browser varchar(20) DEFAULT NULL,
location_country varchar(5) DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user_action (user_id, action_type),
KEY idx_created (created_at),
KEY idx_notification (notification_id),
KEY idx_token (push_token_hash)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Invalid default value for 'expires_at']CREATE TABLE IF NOT EXISTS wp_najibul_process_locks (
lock_key varchar(50) NOT NULL,
locked_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at datetime DEFAULT NULL
PRIMARY KEY (id)
,
KEY idx_expires (expires_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_t...' at line 14]CREATE TABLE IF NOT EXISTS wp_nfs_interaction_log (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id bigint(20) NOT NULL DEFAULT 0,
notification_id bigint(20) NOT NULL DEFAULT 0,
action varchar(20) NOT NULL,
type varchar(50) NOT NULL,
weight int(11) NOT NULL DEFAULT 0,
timestamp int(11) NOT NULL,
fingerprint varchar(64) DEFAULT NULL,
push_token varchar(64) DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
PRIMARY KEY (id)
,
KEY idx_user (user_id),
KEY idx_action (action),
KEY idx_type (type),
KEY idx_timestamp (timestamp)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;