-
Notifications
You must be signed in to change notification settings - Fork 0
/
tabele.sql
58 lines (50 loc) · 1.58 KB
/
tabele.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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
DROP TABLE IF EXISTS priljubljene;
DROP TABLE IF EXISTS nepremicnine;
DROP TABLE IF EXISTS agencije;
DROP TABLE IF EXISTS regije;
DROP TABLE IF EXISTS uporabniki;
CREATE TABLE regije (
id serial PRIMARY KEY,
regija text NOT NULL
);
CREATE TABLE agencije (
id serial PRIMARY KEY,
agencija text NOT NULL
);
CREATE TABLE nepremicnine (
id serial PRIMARY KEY,
ime text NOT NULL,
vrsta text NOT NULL,
opis text NOT NULL,
leto_izgradnje integer,
zemljisce text,
velikost real NOT NULL,
cena real NOT NULL,
agencija integer REFERENCES agencije(id),
regija integer REFERENCES regije(id)
);
CREATE TABLE uporabniki(
id serial PRIMARY KEY,
ime text NOT NULL,
priimek text NOT NULL,
email text NOT NULL UNIQUE,
uporabnisko_ime text NOT NULL UNIQUE,
geslo text NOT NULL
--CONSTRAINT blabla UNIQUE(kire stolpce) lahko tudi tak delas
);
CREATE TABLE priljubljene(
uporabnik integer REFERENCES uporabniki(id),
nepremicnina integer REFERENCES nepremicnine(id)
);
GRANT ALL ON DATABASE sem2020_domenfb TO sabrinac;
GRANT ALL ON SCHEMA public TO sabrinac;
GRANT ALL ON ALL TABLES IN SCHEMA public TO sabrinac;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO sabrinac;
GRANT ALL ON DATABASE sem2020_domenfb TO timotejg;
GRANT ALL ON SCHEMA public TO timotejg;
GRANT ALL ON ALL TABLES IN SCHEMA public TO timotejg;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO timotejg;
--GRANT SELECT ON DATABASE sem2020_domenfb TO javnost;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO javnost;
GRANT INSERT ON ALL TABLES IN SCHEMA public TO javnost;
GRANT DELETE ON "public"."priljubljene" TO javnost;