-
Notifications
You must be signed in to change notification settings - Fork 0
/
init.sql
36 lines (35 loc) · 1.17 KB
/
init.sql
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
34
35
36
CREATE TABLE IF NOT EXISTS public.wifi
(
id SERIAL NOT NULL PRIMARY KEY,
user_id integer NOT NULL,
name character varying(255) NOT NULL,
bssid character varying(255) NOT NULL,
distance float NOT NULL,
level integer NOT NULL,
security character varying(255) NOT NULL,
frequency float NOT NULL,
lat float NOT NULL,
lng float NOT NULL,
accuracy float NOT NULL,
city character varying(50) NOT NULL,
zipcode character varying(50) NOT NULL,
street_name character varying(100) NOT NULL,
street_number character varying(50) NOT NULL,
country_code character varying(10) NOT NULL,
created_at character varying(50) NOT NULL,
updated_at character varying(50) NOT NULL,
CONSTRAINT user_fk FOREIGN KEY (user_id)
REFERENCES public.users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID
);
CREATE TABLE IF NOT EXISTS public.users
(
id SERIAL NOT NULL PRIMARY KEY,
username character varying(100) NOT NULL,
login character varying(100) NOT NULL,
password character varying(255) NOT NULL,
created_at character varying(50) NOT NULL,
updated_at character varying(50) NOT NULL,
);