{"slug":"dynamic-surveys","name":"Dynamic Surveys","description":"Create and manage simple surveys with real-time results display using beautiful pie charts.","author":"Md. Maruf Khan","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/dynamic-surveys/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dynamic_surveys","full_table_name":"wp_dynamic_surveys","description":"Stores dynamic surveys data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"question","type":"text","nullable":false,"primary_key":false},{"name":"options","type":"longtext","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"survey_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"option_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dynamic_surveys ( id mediumint(9) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, question text NOT NULL, options longtext NOT NULL, status varchar(20) DEFAULT 'open', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; // Define votes table $sql_votes = \"CREATE TABLE IF NOT EXISTS wp_dynamic_surveys_votes ( id mediumint(9) NOT NULL AUTO_INCREMENT, survey_id mediumint(9) NOT NULL, user_id bigint(20) NOT NULL, option_id varchar(32) NOT NULL, ip_address varchar(45), created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY survey_user (survey_id, user_id), KEY survey_ip (survey_id, ip_address) ) $charset_collate;\"; // Include WordPress upgrade functions if (!function_exists('dbDelta')) { require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"dynamic_surveys_votes","full_table_name":"wp_dynamic_surveys_votes","description":"Stores dynamic surveys votes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":2}