{"table_name":"bksh_backups","full_table_name":"wp_bksh_backups","description":"Stores bksh backups data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_bksh_backups ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, backup_id VARCHAR(36) NOT NULL, label VARCHAR(255) NOT NULL DEFAULT '', type VARCHAR(20) NOT NULL DEFAULT 'full', status VARCHAR(20) NOT NULL DEFAULT 'pending', size BIGINT(20) NOT NULL DEFAULT 0, file_path TEXT, storage VARCHAR(50) NOT NULL DEFAULT 'local', storage_path TEXT, includes LONGTEXT, site_url VARCHAR(255), wp_version VARCHAR(20), php_version VARCHAR(20), db_version VARCHAR(20), notes TEXT, log LONGTEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, started_at DATETIME, completed_at DATETIME, duration_secs INT UNSIGNED, PRIMARY KEY (id), UNIQUE KEY backup_id (backup_id) ) $charset;\"; $sql2 = \"CREATE TABLE IF NOT EXISTS wp_bksh_schedules ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, type VARCHAR(20) NOT NULL DEFAULT 'full', frequency VARCHAR(20) NOT NULL DEFAULT 'daily', time_of_day TIME NOT NULL DEFAULT '02:00:00', day_of_week TINYINT(1), day_of_month TINYINT(2), storage VARCHAR(50) NOT NULL DEFAULT 'local', retention INT(3) NOT NULL DEFAULT 7, active TINYINT(1) NOT NULL DEFAULT 1, last_run DATETIME, next_run DATETIME, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\"; // Direct table creation for maximum reliability (avoiding dbDelta issues on some hosts) // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Schema creation in activation hook // phpcs:disable WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- activation hook table creation $wpdb->query( $sql1 );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"backup_id","type":"VARCHAR(36)","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"size","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":true,"primary_key":false},{"name":"storage","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"storage_path","type":"TEXT","nullable":true,"primary_key":false},{"name":"includes","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"site_url","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"wp_version","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"php_version","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"db_version","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"log","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"completed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"duration_secs","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"frequency","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"time_of_day","type":"TIME","nullable":false,"primary_key":false},{"name":"day_of_week","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"day_of_month","type":"TINYINT(2)","nullable":true,"primary_key":false},{"name":"storage","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"retention","type":"INT(3)","nullable":false,"primary_key":false},{"name":"active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"last_run","type":"DATETIME","nullable":true,"primary_key":false},{"name":"next_run","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"backshift","name":"BackShift — Backup & Migration","active_installs":0,"version":"2.0.9","wp_org_url":"https://wordpress.org/plugins/backshift/"}}