{"table_name":"dgd_race_tracker_race_sessions","full_table_name":"wp_dgd_race_tracker_race_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_dgd_race_tracker_race_sessions ( id bigint(20) NOT NULL AUTO_INCREMENT, race_name varchar(255) NOT NULL, start_time datetime DEFAULT CURRENT_TIMESTAMP, end_time datetime NULL, planned_end_time datetime NULL, first_lap_extra_time decimal(10, 2) NOT NULL DEFAULT 0 COMMENT 'in seconds', target_offset_time decimal(10, 2) NOT NULL DEFAULT 0 COMMENT 'in seconds', rotation_sequence longtext NULL, total_laps int(11) DEFAULT 0, notes longtext NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; // Drivers table $sql_drivers = \"CREATE TABLE IF NOT EXISTS wp_dgd_race_tracker_drivers ( id bigint(20) NOT NULL AUTO_INCREMENT, race_id bigint(20) NOT NULL, driver_order int(11) NOT NULL DEFAULT 0, driver_name varchar(255) NOT NULL, avg_lap_time decimal(10, 2) NULL COMMENT 'in seconds', total_laps int(11) DEFAULT 0, total_time decimal(15, 2) DEFAULT 0 COMMENT 'in seconds', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY race_id (race_id) ) $charset_collate;\"; // Lap Times table $sql_laps = \"CREATE TABLE IF NOT EXISTS wp_dgd_race_tracker_lap_times ( id bigint(20) NOT NULL AUTO_INCREMENT, driver_id bigint(20) NOT NULL, race_id bigint(20) NOT NULL, lap_number int(11) NOT NULL, lap_time decimal(10, 2) NOT NULL COMMENT 'in seconds', recorded_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY driver_id (driver_id), KEY race_id (race_id), KEY lap_number (lap_number) ) $charset_collate;\"; // Driver Rotations table $sql_rotations = \"CREATE TABLE IF NOT EXISTS wp_dgd_race_tracker_driver_rotations ( id bigint(20) NOT NULL AUTO_INCREMENT, race_id bigint(20) NOT NULL, from_driver_id bigint(20) NOT NULL, to_driver_id bigint(20) NOT NULL, switched_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY race_id (race_id), KEY from_driver_id (from_driver_id), KEY to_driver_id (to_driver_id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_races );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"race_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"start_time","type":"datetime","nullable":true,"primary_key":false},{"name":"end_time","type":"datetime","nullable":true,"primary_key":false},{"name":"planned_end_time","type":"datetime","nullable":true,"primary_key":false},{"name":"first_lap_extra_time","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"target_offset_time","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"rotation_sequence","type":"longtext","nullable":true,"primary_key":false},{"name":"total_laps","type":"int(11)","nullable":true,"primary_key":false},{"name":"notes","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"race_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"driver_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"driver_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"avg_lap_time","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"total_laps","type":"int(11)","nullable":true,"primary_key":false},{"name":"total_time","type":"decimal(15, 2)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"driver_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"race_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"lap_number","type":"int(11)","nullable":false,"primary_key":false},{"name":"lap_time","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"recorded_at","type":"datetime","nullable":true,"primary_key":false},{"name":"race_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"from_driver_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"to_driver_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"switched_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"dgd-race-tracker","name":"DGD Race Tracker","active_installs":0,"version":"0.1.5","wp_org_url":"https://wordpress.org/plugins/dgd-race-tracker/"}}