fire-map-server/setup.sql at master · neuwcodebox/fire-map-server · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
create table reports (
	id serial not null primary key,
	user_id text not null,
	user_pwd text not null,
	latitude double precision not null,
	longitude double precision not null,
	created_time timestamp not null,
	lvl integer not null,
	description text,
	img_path text
);
create table bad_reports (
	id serial not null primary key,
	report_id integer not null,
	reason text
);
create table shelters (
	id serial not null primary key,
	name text,
	latitude double precision not null,
    longitude double precision not null,
    info text,
    recent_good integer not null,
    recent_bad integer not null
);
create table user_shelters (
	id serial not null primary key,
	name text,
	latitude double precision not null,
    longitude double precision not null,
    info text,
    evidence text
);