#1 Wrong Table Definition in mysql 0.2.4c

closed
None
5
2006-02-22
2006-02-22
Anonymous
No

create table geodb_coordinates (
loc_id integer not null references
geodb_locations,
lon double precision,
lat double precision,
coord_type integer not null check
(coord_type=200100000),
coord_type integer not null check
(coord_type=200100000),
coord_subtype integer,
valid_since date,
date_type_since integer,
valid_until date not null,
date_type_until integer not null
) TYPE=InnoDB CHARACTER SET utf8;

Dublicate Entry:
coord_type integer not null check
(coord_type=200100000),

Discussion

  • Thomas Mack

    Thomas Mack - 2006-02-22
    • assigned_to: nobody --> mack3457
     
  • Thomas Mack

    Thomas Mack - 2006-02-22
    • status: open --> closed
     
  • Thomas Mack

    Thomas Mack - 2006-02-22

    Logged In: YES
    user_id=249926

    Fixed for oncoming version 0.2.4d

    Quick solution: remove second line stating:
    coord_type integer not null check (coord_type=200100000),

    Or change complete table creation to:

    create table geodb_coordinates (
    loc_id integer not null references
    geodb_locations,
    lon double precision,
    lat double precision,
    coord_type integer not null check (coord_type=200100000),
    coord_subtype integer,
    valid_since date,
    date_type_since integer,
    valid_until date not null,
    date_type_until integer not null
    ) TYPE=InnoDB CHARACTER SET utf8;

    Thomas

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks