source: subversion/applications/utils/little-osm/planet.sql @ 29923

Last change on this file since 29923 was 1519, checked in by imi, 13 years ago

little-osm now uses mysql geometry extension

File size: 453 bytes
Line 
1CREATE DATABASE /*!32312 IF NOT EXISTS*/ `little-osm`;
2USE `little-osm`;
3
4DROP TABLE IF EXISTS `data`;
5CREATE TABLE `data` (
6  `uid` int(10) unsigned NOT NULL default '0',
7  `tags` text,
8  `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
9  `reference` text,
10  `min` point NOT NULL,
11  `max` point NOT NULL,
12  KEY `Index_1` (`uid`),
13  spatial (`min`),
14  spatial (`max`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Note: See TracBrowser for help on using the repository browser.