Subversion Repositories cheapmusic

Rev

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

Rev Author Line No. Line
18 - 1 
#
2 
# Artists
3 
#
4 
LOAD DATA LOCAL INFILE 'out/artists.load' REPLACE
5 
INTO TABLE artists
6 
FIELDS TERMINATED BY ','
7 
OPTIONALLY ENCLOSED BY '"'
8 
ESCAPED BY ''
9 
LINES TERMINATED BY '\n';
10 
 
11 
#
12 
# Artist Urls
13 
#
14 
LOAD DATA LOCAL INFILE 'out/artistUrls.load' REPLACE
15 
INTO TABLE artistUrls
16 
FIELDS TERMINATED BY ','
17 
OPTIONALLY ENCLOSED BY '"'
18 
ESCAPED BY ''
19 
LINES TERMINATED BY '\n';
20 
 
21 
#
22 
# Artist Groups
23 
#
24 
LOAD DATA LOCAL INFILE 'out/artistGroups.load' REPLACE
25 
INTO TABLE artistGroups
26 
FIELDS TERMINATED BY ','
27 
OPTIONALLY ENCLOSED BY '"'
28 
ESCAPED BY ''
29 
LINES TERMINATED BY '\n';
30 
 
31 
#
32 
# Artist (Group) Members
33 
#
34 
LOAD DATA LOCAL INFILE 'out/artistMembers.load' REPLACE
35 
INTO TABLE artistMembers
36 
FIELDS TERMINATED BY ','
37 
OPTIONALLY ENCLOSED BY '"'
38 
ESCAPED BY ''
39 
LINES TERMINATED BY '\n';
40 
 
41 
#
42 
# Artist Aliases
43 
#
44 
LOAD DATA LOCAL INFILE 'out/artistAliases.load' REPLACE
45 
INTO TABLE artistAliases
46 
FIELDS TERMINATED BY ','
47 
OPTIONALLY ENCLOSED BY '"'
48 
ESCAPED BY ''
49 
LINES TERMINATED BY '\n';
50 
 
51 
#
52 
# Artist Name Variations
53 
#
54 
LOAD DATA LOCAL INFILE 'out/artistVariations.load' REPLACE
55 
INTO TABLE artistVariations
56 
FIELDS TERMINATED BY ','
57 
OPTIONALLY ENCLOSED BY '"'
58 
ESCAPED BY ''
59 
LINES TERMINATED BY '\n';
60 
 
61 
#
62 
# Artist Profiles
63 
#
64 
LOAD DATA LOCAL INFILE 'out/artistProfiles.load' REPLACE
65 
INTO TABLE artistProfiles
66 
FIELDS TERMINATED BY ','
67 
OPTIONALLY ENCLOSED BY '"'
68 
ESCAPED BY ''
69 
LINES TERMINATED BY '\n'
70 
(id, @profile_comp_data)
71 
SET profile=COMPRESS(@profile_comp_data);