CREATE DATABASE `itunes`;
USE `itunes`;
CREATE TABLE `tracks` ( id int(11), name VARCHAR(80), artist VARCHAR(80), album VARCHAR(80), grouping VARCHAR(80), genre VARCHAR(80), kind VARCHAR(80), size int, total_time int, track_number VARCHAR(80), year VARCHAR(80), date_modified DATETIME, date_added DATETIME, bit_rate int, sample_rate int, play_count int, play_date VARCHAR(80), play_date_utc DATETIME, disabled VARCHAR(80), track_type VARCHAR(80), location TEXT, file_folder_count VARCHAR(80), library_folder_count VARCHAR(80), compilation VARCHAR(80), comments TEXT, rating VARCHAR(80), disc_number VARCHAR(80), disc_count VARCHAR(80), composer VARCHAR(80), track_count VARCHAR(80), normalization VARCHAR(80), bpm VARCHAR(80), volume_ajustment VARCHAR(80), equalizer VARCHAR(80), artwork_count VARCHAR(80), persistant_id VARCHAR(80), file_creator VARCHAR(80), file_type VARCHAR(80), release_date DATETIME, podcast VARCHAR(80), movie VARCHAR(80), has_video VARCHAR(80), unplayed VARCHAR(80), PRIMARY KEY (id) ) TYPE=MyISAM;
CREATE TABLE `playlists` (id int(11), name VARCHAR(80),PRIMARY KEY (id) ) TYPE=MyISAM;
CREATE TABLE `track_playlist` (id int(11) NOT NULL AUTO_INCREMENT, track_id int(11), playlist_id int(11),PRIMARY KEY (id) ) TYPE=MyISAM;
CREATE INDEX `id_indexes` ON `track_playlist` (track_id,playlist_id);

INSERT into `tracks` ( id name artist album grouping genre kind size total_time track_number year date_modified date_added bit_rate sample_rate play_count play_date play_date_utc disabled track_type location file_folder_count library_folder_count rating composer compilation disc_count disc_number track_count comments normalization bpm volume_ajustment equalizer artwork_count persistant_id file_creator file_type podcast release_date movie has_video unplayed ERROR: , ) VALUES ( "" , );

INSERT into `playlists` (name,id) VALUES ( "", "" );

INSERT into `track_playlist`( track_id, playlist_id ) VALUES ( "", "" );