wp_ireplay_channels

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_ireplay_channels ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, remote_channel_id BIGINT UNSIGNED DEFAULT NULL, handle VARCHAR(63) NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, channel_type ENUM('webtv','webradio') NOT NULL DEFAULT 'webtv', primary_language VARCHAR(10) DEFAULT 'en', age_classification VARCHAR(5) DEFAULT '4+', scheduling_mode ENUM('weighted_random','manual') DEFAULT 'weighted_random', is_public TINYINT(1) DEFAULT 0, is_active TINYINT(1) DEFAULT 0, thumbnail_url VARCHAR(512) DEFAULT NULL, banner_url VARCHAR(512) DEFAULT NULL, schedule_status VARCHAR(20) DEFAULT 'inactive', ready_asset_count INT DEFAULT 0, ready_duration_seconds DOUBLE DEFAULT 0, viewer_count INT DEFAULT 0, playlist_url VARCHAR(512) DEFAULT NULL, overlay_cta_url VARCHAR(512) DEFAULT NULL, overlay_cta_label VARCHAR(255) DEFAULT NULL, overlay_show_qr TINYINT(1) DEFAULT 1, sync_status ENUM('synced','pending','error') DEFAULT 'pending', sync_error TEXT, last_synced_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY uk_handle (handle), KEY idx_remote (remote_channel_id), KEY idx_sync (sync_status) ) $charset_collate;"; // Assets table $sql[] = "CREATE TABLE wp_ireplay_assets ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, remote_asset_id BIGINT UNSIGNED DEFAULT NULL, channel_id BIGINT UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, description TEXT, duration_seconds DOUBLE DEFAULT 0, weight TINYINT DEFAULT 5, tags VARCHAR(500) DEFAULT NULL, media_type ENUM('video','audio') NOT NULL DEFAULT 'video', original_filename VARCHAR(255) DEFAULT NULL, filesize_bytes BIGINT DEFAULT 0, upload_status ENUM('uploading','pending','transcoding','downloading','ready','error') DEFAULT 'uploading', transcode_job_id BIGINT UNSIGNED DEFAULT NULL, transcode_progress TINYINT DEFAULT 0, segment_count INT DEFAULT 0, basename VARCHAR(255) DEFAULT NULL, thumbnail_url VARCHAR(512) DEFAULT NULL, local_dir VARCHAR(512) DEFAULT NULL, segment_url_prefix VARCHAR(512) DEFAULT NULL, error_message TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, KEY idx_channel (channel_id), KEY idx_remote (remote_asset_id), KEY idx_status (upload_status) ) $charset_collate;"; // Schedule cache $sql[] = "CREATE TABLE wp_ireplay_schedule_cache ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, channel_id BIGINT UNSIGNED NOT NULL, start_unix BIGINT NOT NULL, duration DOUBLE NOT NULL, asset_id BIGINT UNSIGNED DEFAULT NULL, asset_title VARCHAR(255) DEFAULT NULL, asset_thumbnail VARCHAR(512) DEFAULT NULL, fetched_at DATETIME DEFAULT CURRENT_TIMESTAMP, KEY idx_channel_time (channel_id, start_unix) ) $charset_collate;"; // Usage cache $sql[] = "CREATE TABLE wp_ireplay_usage_cache ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, channel_id BIGINT UNSIGNED NOT NULL, date DATE NOT NULL, peak_concurrent INT DEFAULT 0, total_minutes DOUBLE DEFAULT 0, total_sessions INT DEFAULT 0, fetched_at DATETIME DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY uk_channel_date (channel_id, date) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_ireplay_channels`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from iReplay TV Channel and Radio Station