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;