Subversion Repositories cheapmusic

#
# Masters
#
DROP TABLE IF EXISTS `masters`;
CREATE TABLE `masters` (
  `id` INT UNSIGNED NOT NULL,
  `rid` INT UNSIGNED NOT NULL,
  `year` SMALLINT,
  `title` VARCHAR(1024),
  `genres` VARCHAR(1024),
  `styles` VARCHAR(1024),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE INDEX mastersRId on masters(rid);
CREATE INDEX mastersTitle on masters(title);

#
# Master artists
#
DROP TABLE IF EXISTS `masterArtists`;
CREATE TABLE `masterArtists` (
  `id` INT UNSIGNED NOT NULL,
  `aid` INT UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE INDEX masterArtistsId on masterArtists(id);
CREATE INDEX masterArtistsAId on masterArtists(aid);






#SELECT id, name, LENGTH(name) AS mlen FROM masterVariations ORDER BY mlen DESC LIMIT 1;