db再作成

$ sqlite3 tsunami.db
sqlite> .database
sqlite> .exit

$ ls
  tsunami.db

$ sqlite3 tsunami.db
sqlite>
sqlite>create table intersection (id integer primary key, latitude REAL,longitude REAL);
sqlite>create table street (id integer primary key, distance real, intersec_id_1 integer, intersec_id_2 integer);
sqlite>create table elevation (id integer primary key, elevation integer, position_top REAL,position_left REAL,position_bottom REAL,position_right REAL);
sqlite>
sqlite>create index idx_intersection_01 on intersection(latitude);
sqlite>create index idx_intersection_02 on intersection(longitude);
sqlite>create unique index idx_street_01 ON street(intersec_id_1,intersec_id_2);
sqlite>create index idx_elevation_01 on elevation(elevation);
sqlite>create index idx_elevation_02 on elevation(position_top);
sqlite>create index idx_elevation_03 on elevation(position_left);
sqlite>create index idx_elevation_04 on elevation(position_bottom);
sqlite>create index idx_elevation_05 on elevation(position_right);
sqlite> .exit

insert into intersection values (交差点番号,緯度,軽度);
insert into street values (道路番号,距離,交差点番号1,交差点番号2);
insert into elevation values (標高座標番号,標高,緯度上,経度左,緯度下,経度右);
Merge branch 'master' of https://github.com/KyousuK/Tsunami.Android