{"slug":"arena-scheduler","name":"Arena Scheduler","description":"An easy and professional way to organize and schedule arena activities.","author":"Lars Ledin","active_installs":0,"version":"1.0.18","wp_org_url":"https://wordpress.org/plugins/arena-scheduler/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"arena","full_table_name":"wp_arena","description":"Stores arena data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE wp_arena ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), interval_time INT(11) NULL, start_time VARCHAR(255) NULL, end_time VARCHAR(255) NULL, is_default TINYINT(4) NULL, status INT(11) DEFAULT 1, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)\"; // Execute the SQL query to create the table require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"arena_categories","full_table_name":"wp_arena_categories","description":"Stores arena categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE wp_arena_categories ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NULL, color VARCHAR(255) NULL, text_color VARCHAR(255) DEFAULT '#000000', is_default TINYINT(4) NULL, status INT(11) DEFAULT 1, created_at DATETIME DEFAULT CURRENT_TIMESTAMP)\"; // Execute the SQL query to create the table require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"arena_scheduled_timesheet","full_table_name":"wp_arena_scheduled_timesheet","description":"Stores arena scheduled timesheet data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE wp_arena_scheduled_timesheet ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, arena_id INT(10) UNSIGNED, timeslot_id BIGINT(15) UNSIGNED, category INT(10) UNSIGNED, comment VARCHAR(255) NULL, scheduled_date DATE, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (arena_id) REFERENCES {$arena_table}(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (category) REFERENCES {$arena_categories}(id) ON DELETE CASCADE ON UPDATE CASCADE)\"; // Execute the SQL query to create the table require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"}],"table_count":3}