{"slug":"wapp-author-hub","name":"WAPP Author Hub","description":"Author box with E-E-A-T SEO schema, custom author page, subscriber system, notification bell and scheduled email digests.","author":"UASTEND GROUP","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/wapp-author-hub/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"author_subscribers","full_table_name":"wp_author_subscribers","description":"Stores author subscribers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wappauhu_notif_read","full_table_name":"wp_wappauhu_notif_read","description":"Stores wappauhu notif read data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"notification_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"read_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wappauhu_notif_read ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, notification_id bigint(20) NOT NULL, read_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_user_notif (user_id, notification_id) ) $c;\");"},{"table_name":"wappauhu_notifications","full_table_name":"wp_wappauhu_notifications","description":"Stores wappauhu notifications data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"author_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wappauhu_notifications ( id bigint(20) NOT NULL AUTO_INCREMENT, author_id bigint(20) NOT NULL, post_id bigint(20) NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY author_id (author_id) ) $c;\");"},{"table_name":"wappauhu_subscribers","full_table_name":"wp_wappauhu_subscribers","description":"Stores wappauhu subscribers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"author_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"subscriber_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"subscriber_email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"subscriber_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"subscription_date","type":"datetime","nullable":true,"primary_key":false},{"name":"unsubscribe_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"last_digest_date","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wappauhu_subscribers ( id bigint(20) NOT NULL AUTO_INCREMENT, author_id bigint(20) NOT NULL, subscriber_id bigint(20) DEFAULT 0, subscriber_email varchar(100) NOT NULL, subscriber_name varchar(100) DEFAULT '', subscription_date datetime DEFAULT CURRENT_TIMESTAMP, unsubscribe_key varchar(64) NOT NULL, last_digest_date datetime DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (id), UNIQUE KEY uq_author_sub (author_id, subscriber_email) ) $c;\");"}],"table_count":4}