freenetis-addresses-github/db_structure.sql @ master
| 8aa82b90 | david | /*
|
|
* This file is part of open source system FreenetIS
|
|||
* and it is released under GPLv3 licence.
|
|||
*
|
|||
* More info about licence can be found:
|
|||
* http://www.gnu.org/licenses/gpl-3.0.html
|
|||
*
|
|||
* More info about project can be found:
|
|||
* http://www.freenetis.org/
|
|||
*
|
|||
*/
|
|||
| 5898e047 | David Raška | CREATE DATABASE `addresses` DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;
|
|
| 58269f85 | jeffraska | USE `addresses`;
|
|
| ec7a7d3d | david | CREATE TABLE IF NOT EXISTS `addresses` (
|
|
| 8aa82b90 | david | `country` int(11) NOT NULL,
|
|
| ec7a7d3d | david | `town_name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
|
`town_quarter` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
|||
`district_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,
|
|||
| 58269f85 | jeffraska | `jstk_y` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
|
`jstk_x` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
|||
| 8aa82b90 | david | UNIQUE KEY `FULLTEXT` (`town_name`,`town_quarter`,`district_name`,`street`,`number`,`zip_code`,`country`),
|
|
KEY `country` (`country`),
|
|||
| ec7a7d3d | david | FULLTEXT KEY `town_name` (`town_name`),
|
|
FULLTEXT KEY `town_quarter` (`town_quarter`),
|
|||
FULLTEXT KEY `district_name` (`district_name`),
|
|||
FULLTEXT KEY `street` (`street`),
|
|||
FULLTEXT KEY `number` (`number`),
|
|||
FULLTEXT KEY `zip_code` (`zip_code`)
|
|||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
|||
CREATE TABLE IF NOT EXISTS `addresses_tmp` (
|
|||
| 8aa82b90 | david | `country` int(11) NOT NULL,
|
|
| ec7a7d3d | david | `town_name` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
|
`town_quarter` varchar(50) COLLATE utf8_czech_ci NOT NULL,
|
|||
`district_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,
|
|||
| 58269f85 | jeffraska | `jstk_y` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
|
`jstk_x` varchar(15) COLLATE utf8_czech_ci NOT NULL,
|
|||
| 8aa82b90 | david | UNIQUE KEY `FULLTEXT` (`town_name`,`town_quarter`,`district_name`,`street`,`number`,`zip_code`,`country`),
|
|
KEY `country` (`country`),
|
|||
| ec7a7d3d | david | FULLTEXT KEY `town_name` (`town_name`),
|
|
FULLTEXT KEY `town_quarter` (`town_quarter`),
|
|||
FULLTEXT KEY `district_name` (`district_name`),
|
|||
FULLTEXT KEY `street` (`street`),
|
|||
FULLTEXT KEY `number` (`number`),
|
|||
FULLTEXT KEY `zip_code` (`zip_code`)
|
|||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
|||
CREATE TABLE IF NOT EXISTS `config` (
|
|||
`name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
|
|||
`value` text COLLATE utf8_czech_ci NOT NULL,
|
|||
PRIMARY KEY (`name`)
|
|||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|