Subversion Repositories cheapmusic

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

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

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

#
# Artist (Group) Members
#
LOAD DATA LOCAL INFILE 'out/artistMembers.load' REPLACE
INTO TABLE artistMembers
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n';

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

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

#
# Artist Profiles
#
LOAD DATA LOCAL INFILE 'out/artistProfiles.load' REPLACE
INTO TABLE artistProfiles
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY '\n'
(id, @profile_comp_data)
SET profile=COMPRESS(@profile_comp_data);