{"table_name":"arshid6social_polls","full_table_name":"wp_arshid6social_polls","description":"Stores arshid6social polls data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_arshid6social_polls ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, activity_id BIGINT UNSIGNED NOT NULL DEFAULT 0, user_id BIGINT UNSIGNED NOT NULL, question TEXT NOT NULL, poll_type VARCHAR(20) NOT NULL DEFAULT 'single', anonymous TINYINT(1) NOT NULL DEFAULT 0, allow_change_vote TINYINT(1) NOT NULL DEFAULT 1, results_visibility VARCHAR(20) NOT NULL DEFAULT 'always', allow_voter_suggest TINYINT(1) NOT NULL DEFAULT 0, end_date DATETIME DEFAULT NULL, start_date DATETIME DEFAULT NULL, status VARCHAR(20) NOT NULL DEFAULT 'open', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY activity_id (activity_id), KEY user_id (user_id), KEY status (status) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"activity_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"question","type":"TEXT","nullable":false,"primary_key":false},{"name":"poll_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"anonymous","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"allow_change_vote","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"results_visibility","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"allow_voter_suggest","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"end_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"start_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"6arshid-social-community","name":"6Arshid Social Community","active_installs":0,"version":"1.8.3","wp_org_url":"https://wordpress.org/plugins/6arshid-social-community/"}}