Revize 58269f85
Přidáno uživatelem David Raška před asi 10 roky(ů)
| db_structure.sql | ||
|---|---|---|
|
|
||
|
CREATE DATABASE `addresses` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
|
||
|
|
||
|
USE `addresses`;
|
||
|
|
||
|
CREATE TABLE IF NOT EXISTS `addresses` (
|
||
|
`country` int(11) NOT NULL,
|
||
|
`town_name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
||
| ... | ... | |
|
`street` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`number` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`zip_code` varchar(10) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`jstk_y` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`jstk_x` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
UNIQUE KEY `FULLTEXT` (`town_name`,`town_quarter`,`district_name`,`street`,`number`,`zip_code`,`country`),
|
||
|
KEY `country` (`country`),
|
||
|
FULLTEXT KEY `town_name` (`town_name`),
|
||
| ... | ... | |
|
`street` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`number` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`zip_code` varchar(10) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`jstk_y` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
`jstk_x` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
||
|
UNIQUE KEY `FULLTEXT` (`town_name`,`town_quarter`,`district_name`,`street`,`number`,`zip_code`,`country`),
|
||
|
KEY `country` (`country`),
|
||
|
FULLTEXT KEY `town_name` (`town_name`),
|
||
Také k dispozici: Unified diff
Changes:
- Progress of preparing and importing is not printed in CRON mode
- Server now return GPS position of address point
- Server now searches in both town district and town qurters