[OSM-dev] SQL to create OSM DB

[Jan-Benedict Glaw]

On Wed, 2006-10-04 16:32:42 +0200, Joerg Ostertag (OSM Munich/Germany) <openstreetmap at ostertag.name> wrote:
> DROP TABLE IF EXISTS `area_segments`;
> CREATE TABLE `area_segments` (
>   `id` bigint(64) NOT NULL DEFAULT '0',
>   `segment_id` int(11) DEFAULT NULL,
>   `version` bigint(20) NOT NULL DEFAULT '0',
>   `sequence_id` int(11) NOT NULL AUTO_INCREMENT,
>   PRIMARY KEY (`id`,`version`,`sequence_id`),
>   KEY `area_segments_id_idx` (`id`),
>   KEY `area_segments_segment_id_idx` (`segment_id`),
>   KEY `area_segments_id_version_idx` (`id`,`version`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Wasn't it announced that we're now at UTF-8? So this must be wrong :)

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
Signature of:                 Gib Dein Bestes. Dann übertriff Dich selbst!
the second  :
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20061004/2ba34d26/attachment.pgp>