{"table_name":"gabc_analytics","full_table_name":"wp_gabc_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_gabc_analytics ( id bigint(20) NOT NULL AUTO_INCREMENT, notice_id bigint(20) NOT NULL, event_type varchar(20) NOT NULL, event_date date NOT NULL, count bigint(20) NOT NULL DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY notice_event_date (notice_id, event_type, event_date), KEY notice_id (notice_id), KEY event_date (event_date) ) $charset_collate;\"; dbDelta( $analytics_sql );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"notice_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"event_date","type":"date","nullable":false,"primary_key":false},{"name":"count","type":"bigint(20)","nullable":false,"primary_key":false}],"plugin":{"slug":"gridxflex-announcement-bars","name":"Gridxflex Announcement Bars with CTA","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/gridxflex-announcement-bars/"}}