[OSM-dev] SQL to create OSM DB

[Jan-Benedict Glaw]

On Wed, 2006-10-04 21:46:39 +0200, Jan-Benedict Glaw <jbglaw at lug-owl.de> wrote:
> 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 :)

Uh, no, unfortunately not... Some DB dumps were UTF-8ified, but not
the DB itself. So this scheme is probably right :)  Sorry for the
noise.

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
  Signature of:                        Lauf nicht vor Deinem Glück davon:
  the second  :                             Es könnte hinter Dir stehen!
-------------- 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/20061005/92c02da1/attachment.pgp>