Changeset 54 for kladr/sql

Show
Ignore:
Timestamp:
01/14/08 12:33:19 (4 years ago)
Author:
teiko
Message:

Более удачные индексы и побавлено поле корпуса к таблице домов

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • kladr/sql/kladr2mysql.sql

    r43 r54  
    107107   INDEX (type), 
    108108   UNIQUE INDEX (code), 
    109    INDEX (parent_region, name), 
    110    INDEX (parent_city, name), 
    111    INDEX (parent_settlement, name), 
    112    INDEX (parent_city, parent_settlement, name) 
     109   INDEX (parent_region, parent_city, parent_settlement, name), 
     110   INDEX (parent_city, parent_settlement, name), 
     111   INDEX (parent_settlement, name) 
    113112) TYPE = innodb; 
    114 INSERT LOW_PRIORITY INTO streets(name, type, _index, code) 
     113INSERT INTO streets(name, type, _index, code) 
    115114    SELECT SQL_BIG_RESULT STREET.name, types.id, _index, LEFT(code,15) 
    116115    FROM STREET 
    …… 
    125124   id INT(1) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
    126125   name VARCHAR(40) NOT NULL, 
     126   korp CHAR(1) NOT NULL, 
    127127   type INT(1) UNSIGNED NOT NULL, 
    128128   _index CHAR(6) NOT NULL, 
    …… 
    138138   UNIQUE INDEX (code) 
    139139) TYPE = innodb; 
    140 INSERT LOW_PRIORITY INTO buildings(name, type, _index, code) 
    141     SELECT SQL_BIG_RESULT DOMA.name, types.id, _index, code 
     140INSERT INTO buildings(name, korp, type, _index, code) 
     141    SELECT SQL_BIG_RESULT DOMA.name, DOMA.korp, types.id, _index, code 
    142142    FROM DOMA 
    143143        INNER JOIN types ON DOMA.socr = types.short_name