-DROP TABLE IF EXISTS tmp_sectors;
-
-CREATE TEMPORARY TABLE IF NOT EXISTS tmp_sectors (
- id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
- sect CHAR(1) NOT NULL,
- subsector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
- subsubsector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
- name VARCHAR(256) NOT NULL DEFAULT '',
- PRIMARY KEY(id)
-) CHARSET=utf8;
-
-LOAD DATA LOCAL INFILE 'rome-v3.csv' INTO TABLE tmp_sectors FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
-(sect, subsector, subsubsector, name);
-
-ALTER TABLE tmp_sectors ADD INDEX (sect);
-ALTER TABLE tmp_sectors ADD INDEX (subsector);
-ALTER TABLE tmp_sectors ADD INDEX (subsubsector);
-ALTER TABLE tmp_sectors ADD INDEX (name);
-