wp_itunes
StaticStores itunes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ipod_track_id | int(10) | NO |
| ipod_track_name | varchar(255) | NO |
| ipod_track_artist | varchar(255) | NO |
| ipod_track_album | varchar(255) | NO |
| ipod_track_genre | varchar(255) | NO |
| ipod_track_kind | varchar(255) | NO |
| ipod_track_size | int(15) | NO |
| ipod_track_total_time | int(15) | NO |
| ipod_track_number | int(4) | NO |
| ipod_track_date_modified | datetime | NO |
| ipod_track_date_added | datetime | NO |
| ipod_track_bitrate | int(4) | NO |
| ipod_track_play_count | int(10) | NO |
| ipod_track_play_date | int(15) | NO |
| ipod_track_play_date_utc | datetime | NO |
| ipod_track_rating | int(10) | NO |
| ipod_track_normalization | int(10) | NO |
| ipod_track_location | varchar(255) | NO |
| ipod_track_file_folder_count | int(2) | NO |
| ipod_track_library_folder_count | int(2) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_itunes` ( `ipod_track_id` int(10) NOT NULL auto_increment, `ipod_track_name` varchar(255) NOT NULL default '', `ipod_track_artist` varchar(255) NOT NULL default '', `ipod_track_album` varchar(255) NOT NULL default '', `ipod_track_genre` varchar(255) NOT NULL default '', `ipod_track_kind` varchar(255) NOT NULL default '', `ipod_track_size` int(15) NOT NULL default '0', `ipod_track_total_time` int(15) NOT NULL default '0', `ipod_track_number` int(4) NOT NULL default '0', `ipod_track_date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `ipod_track_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `ipod_track_bitrate` int(4) NOT NULL default '0', `ipod_track_play_count` int(10) NOT NULL default '0', `ipod_track_play_date` int(15) NOT NULL default '0', `ipod_track_play_date_utc` datetime NOT NULL default '0000-00-00 00:00:00', `ipod_track_rating` int(10) NOT NULL default '0', `ipod_track_normalization` int(10) NOT NULL default '0', `ipod_track_location` varchar(255) NOT NULL default '', `ipod_track_file_folder_count` int(2) NOT NULL default '0', `ipod_track_library_folder_count` int(2) NOT NULL default '0', PRIMARY KEY (`ipod_track_id`) ) ENGINE
Safe to delete?
If you have uninstalled iTunes-Data, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_itunes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.