setup_myisam_opengeodb

setup_myisam_opengeodb.sql

SET NAMES 'utf8';

BEGIN;
/*
 * Table structure for table 'geodb_type_names'
 */

create table geodb_type_names (
  type_id              integer not null,
  type_locale          varchar(5) not null,
  name                 varchar(255) not null,             /* varchar(500)? */
unique (type_id, type_locale)
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_locations'
 */

create table geodb_locations (
  loc_id               integer not null primary key,
  loc_type             integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_hierarchies'
 */

create table geodb_hierarchies (
  loc_id               integer not null,
  level                integer not null,
  id_lvl1              integer not null,
  id_lvl2              integer,
  id_lvl3              integer,
  id_lvl4              integer,
  id_lvl5              integer,
  id_lvl6              integer,
  id_lvl7              integer,
  id_lvl8              integer,
  id_lvl9              integer,
  valid_since          date,
  date_type_since      integer,
  valid_until          date not null,
  date_type_until      integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_coordinates'
 */

create table geodb_coordinates (
  loc_id               integer not null,
  coord_type           integer not null,
  lat                  double precision,
  lon                  double precision,
  coord_subtype        integer,
  valid_since          date,
  date_type_since      integer,
  valid_until          date not null,
  date_type_until      integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_textdata'
 */

create table geodb_textdata (
  loc_id               integer not null,
  text_type            integer not null,
  text_val             varchar(255) not null,                  /* varchar(2000)? */
  text_locale          varchar(5),                          /* ISO 639-1 */
  is_native_lang       smallint(1),
  is_default_name      smallint(1),
  valid_since          date,
  date_type_since      integer,
  valid_until          date not null,
  date_type_until      integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_intdata'
 */

create table geodb_intdata (
  loc_id               integer not null,
  int_type             integer not null,
  int_val              bigint not null,
  valid_since          date,
  date_type_since      integer,
  valid_until          date not null,
  date_type_until      integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_floatdata'
 */

create table geodb_floatdata (
  loc_id               integer not null,
  float_type           integer not null,
  float_val            double precision not null,    /* double / float??? */
  valid_since          date,
  date_type_since      integer,
  valid_until          date not null,
  date_type_until      integer not null
) ENGINE=MyISAM CHARACTER SET utf8;

/*
 * Table structure for table 'geodb_changelog'
 */

create table geodb_changelog (
  id                   integer not null primary key,
  datum                date not null,
  beschreibung         text not null,
  autor                varchar(50) not null,
  version              varchar(8)
) ENGINE=MyISAM CHARACTER SET utf8;
COMMIT;