Subversion Repositories cheapmusic

#
# Labels
#
DROP TABLE IF EXISTS `labels`;
CREATE TABLE `labels` (
  `id` INT UNSIGNED NOT NULL,
  `name` VARCHAR(1024),
  `parentlabel` VARCHAR(1024),
  `sublabel` VARCHAR(4096),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE INDEX labelsName on labels(name);

#
# Label Urls
#
DROP TABLE IF EXISTS `labelUrls`;
CREATE TABLE `labelUrls` (
  `id` INT UNSIGNED NOT NULL,
  `url` VARCHAR(1024)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE INDEX labelUrlsId on labelUrls(id);






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