CREATE TABLE mob_gps (
    mob_id  varchar(128),
    time    datetime,
    lat     varchar(64),
    lng     varchar(64),
    gps_info    text,
    primary key (mob_id, time)
);

CREATE TABLE mob_gps_recent (
    mob_id  varchar(128),
    time    datetime,
    lat     varchar(64),
    lng     varchar(64),
    gps_info    text,
    primary key (mob_id)
);