Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
#
# 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;