Subversion Repositories cheapmusic

Rev

Rev 44 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
18 - 1 
#
2 
# Releases
3 
#
4 
LOAD DATA LOCAL INFILE 'out/releases.load' REPLACE
5 
INTO TABLE releases
6 
FIELDS TERMINATED BY ','
7 
OPTIONALLY ENCLOSED BY '"'
8 
ESCAPED BY ''
9 
LINES TERMINATED BY '\n';
10 
 
11 
#
12 
# Release Artists
13 
#
14 
LOAD DATA LOCAL INFILE 'out/releaseArtists.load' REPLACE
15 
INTO TABLE releaseArtists
16 
FIELDS TERMINATED BY ','
17 
OPTIONALLY ENCLOSED BY '"'
18 
ESCAPED BY ''
19 
LINES TERMINATED BY '\n';
20 
 
21 
#
22 
# Release Labels
23 
#
24 
LOAD DATA LOCAL INFILE 'out/releaseLabels.load' REPLACE
25 
INTO TABLE releaseLabels
26 
FIELDS TERMINATED BY ','
27 
OPTIONALLY ENCLOSED BY '"'
28 
ESCAPED BY ''
29 
LINES TERMINATED BY '\n';
30 
 
31 
#
32 
# Release Tracks
33 
#
34 
LOAD DATA LOCAL INFILE 'out/releaseTracks.load' REPLACE
35 
INTO TABLE releaseTracks
36 
FIELDS TERMINATED BY ','
37 
OPTIONALLY ENCLOSED BY '"'
38 
ESCAPED BY ''
39 
LINES TERMINATED BY '\n'
40 
(id, @track_comp_data)
41 
SET track=COMPRESS(@track_comp_data);
58 - 42 
 
43 
#
44 
# Barcodes
45 
#
46 
LOAD DATA LOCAL INFILE 'out/barcodes.load' REPLACE
47 
INTO TABLE barcodes
48 
FIELDS TERMINATED BY ','
49 
OPTIONALLY ENCLOSED BY '"'
50 
ESCAPED BY ''
51 
LINES TERMINATED BY '\n';