Subversion Repositories cheapmusic

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
18 - 1 
#
2 
# Masters
3 
#
4 
DROP TABLE IF EXISTS `masters`;
5 
CREATE TABLE `masters` (
6 
  `id` INT UNSIGNED NOT NULL,
7 
  `rid` INT UNSIGNED NOT NULL,
8 
  `year` SMALLINT,
9 
  `title` VARCHAR(1024),
10 
  `genres` VARCHAR(1024),
11 
  `styles` VARCHAR(1024),
12 
  PRIMARY KEY (`id`)
13 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14 
 
15 
LOAD DATA LOCAL INFILE 'out/masters.load' REPLACE
16 
INTO TABLE masters
17 
FIELDS TERMINATED BY ','
18 
OPTIONALLY ENCLOSED BY '"'
19 
ESCAPED BY ''
20 
LINES TERMINATED BY '\n';
21 
 
22 
CREATE INDEX mastersRId on masters(rid);
23 
CREATE INDEX mastersTitle on masters(title);
24 
 
25 
#
26 
# Master artists
27 
#
28 
DROP TABLE IF EXISTS `masterArtists`;
29 
CREATE TABLE `masterArtists` (
30 
  `id` INT UNSIGNED NOT NULL,
31 
  `aid` INT UNSIGNED NOT NULL
32 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33 
 
34 
LOAD DATA LOCAL INFILE 'out/masterArtists.load' REPLACE
35 
INTO TABLE masterArtists
36 
FIELDS TERMINATED BY ','
37 
OPTIONALLY ENCLOSED BY '"'
38 
ESCAPED BY ''
39 
LINES TERMINATED BY '\n';
40 
 
41 
CREATE INDEX masterArtistsId on masterArtists(id);
42 
CREATE INDEX masterArtistsAId on masterArtists(aid);
43 
 
44 
 
45 
 
46 
 
47 
 
48 
 
49 
#SELECT id, name, LENGTH(name) AS mlen FROM masterVariations ORDER BY mlen DESC LIMIT 1;
50