{"table_name":"ddwppwa_notification_log","full_table_name":"wp_ddwppwa_notification_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_ddwppwa_notification_log ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `notification_id` bigint(20) NOT NULL DEFAULT 0, `type` varchar(50) NOT NULL DEFAULT 'manual', `title` varchar(200) NOT NULL DEFAULT '', `body` varchar(255) NOT NULL DEFAULT '', `url` varchar(255) NOT NULL DEFAULT '', `target` varchar(190) NOT NULL DEFAULT '', `status` varchar(20) NOT NULL DEFAULT 'pending', `message_id` varchar(190) NOT NULL DEFAULT '', `recipients` int(11) NOT NULL DEFAULT 0, `clicks` int(11) NOT NULL DEFAULT 0, `error` text NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY type (type), KEY status (status), KEY created_at (created_at) ) $charset_collate;\"; dbDelta( $log_table );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"notification_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"body","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"target","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message_id","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"recipients","type":"int(11)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"error","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"devdiggers-pwa","name":"Progressive Web App – PWA, Web Push Notifications and Offline Mode","active_installs":10,"version":"1.1.1","wp_org_url":"https://wordpress.org/plugins/devdiggers-pwa/"}}