Subversion Repositories cheapmusic

Rev

Rev 18 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

#
# Releases
#
LOAD DATA LOCAL INFILE 'out/releases.load' REPLACE
INTO TABLE releases
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n';

#
# Release Artists
#
LOAD DATA LOCAL INFILE 'out/releaseArtists.load' REPLACE
INTO TABLE releaseArtists
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n';

#
# Release Labels
#
LOAD DATA LOCAL INFILE 'out/releaseLabels.load' REPLACE
INTO TABLE releaseLabels
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n';

#
# Release Tracks
#
LOAD DATA LOCAL INFILE 'out/releaseTracks.load' REPLACE
INTO TABLE releaseTracks
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n'
(id, @track_comp_data)
SET track=COMPRESS(@track_comp_data);