1. CREATE TYPE arch AS ENUM('x32','x64');
2.  
3. CREATE TABLE system_op
4. (
5.   id serial NOT NULL,
6.   nazwa character varying(150) NOT NULL,
7.   architektura arch NOT NULL,
8.   CONSTRAINT system_op_pkey PRIMARY KEY (id)
9. );
10.  
11.  
12.   CREATE TABLE statusy
13. (
14.   id serial NOT NULL,
15.   opis character varying(15) NOT NULL,
16.   CONSTRAINT statusy_pkey PRIMARY KEY (id)
17. );
18.  
19. CREATE TABLE kategoria
20. (
21.   id serial NOT NULL,
22.   opis character varying(50) NOT NULL,
23.   CONSTRAINT Kategoria_pkey PRIMARY KEY (id)
24. );
25.  
26.  
27. CREATE TABLE sl_org
28. (
29.   id serial NOT NULL,
30.   nazwa character varying(150) NOT NULL,
31.   CONSTRAINT sl_org_pkey PRIMARY KEY (id)
32. );
33.  
34.  
35.   CREATE TABLE komputery
36. (
37.   id serial NOT NULL,
38.   nazwa character varying(150) NOT NULL,
39.   lokalizacja integer NOT NULL,
40.   system_op integer NOT NULL,
41.   system_op2 integer,
42.   nr_inw character varying(30) NOT NULL,
43.   CONSTRAINT komputery_pkey PRIMARY KEY (id),
44.   CONSTRAINT fk_komputery_system_op FOREIGN KEY (system_op)
45.       REFERENCES system_op (id) MATCH SIMPLE
46.       ON UPDATE NO ACTION ON DELETE NO ACTION,
47.   CONSTRAINT fk_komputery_system_op2 FOREIGN KEY (system_op2)
48.       REFERENCES system_op (id) MATCH SIMPLE
49.       ON UPDATE NO ACTION ON DELETE NO ACTION,
50. CONSTRAINT fk_komputery_sl_org FOREIGN KEY (lokalizacja)
51.       REFERENCES sl_org (id) MATCH SIMPLE
52.       ON UPDATE NO ACTION ON DELETE NO ACTION
53. );
54.  
55. CREATE TABLE users
56. (
57.   id serial NOT NULL,
58.   login character varying(50) NOT NULL,
59.   password character varying(30) NOT NULL,
60.   name character varying(250) NOT NULL,
61.   komorka integer NOT NULL,
62.   funkcja character varying(150),
63.   CONSTRAINT users_pkey PRIMARY KEY (id),
64.   CONSTRAINT fk_users_sl_org FOREIGN KEY (komorka)
65.       REFERENCES sl_org (id) MATCH SIMPLE
66.       ON UPDATE NO ACTION ON DELETE NO ACTION
67. );
68.  
69.  
70. CREATE TABLE uprawnienia
71. (
72.   id serial NOT NULL,
73.   uzytkownik integer NOT NULL,
74.   administracja character varying(1) NOT NULL,
75.   kon_kier character varying(1) NOT NULL,
76.   kier_help character varying(1) NOT NULL,
77.   raporty character varying(1) NOT NULL,
78.   CONSTRAINT uprawnienia_pkey PRIMARY KEY (id),
79.   CONSTRAINT fk_uprawnienia_users FOREIGN KEY (uzytkownik)
80.       REFERENCES users (id) MATCH SIMPLE
81.       ON UPDATE NO ACTION ON DELETE NO ACTION
82. );
83.  
84.  
85.  
86. CREATE TABLE upr_zgl
87. (
88.   user_id integer NOT NULL,
89.   kategoria_id integer NOT NULL,
90.   CONSTRAINT upr_zgl_pkey PRIMARY KEY (user_id, kategoria_id),
91.   CONSTRAINT fk_upr_zgl_kategoria FOREIGN KEY (kategoria_id)
92.       REFERENCES kategoria (id) MATCH SIMPLE
93.       ON UPDATE NO ACTION ON DELETE NO ACTION,
94.   CONSTRAINT fk_upr_zgl_users FOREIGN KEY (user_id)
95.       REFERENCES users (id) MATCH SIMPLE
96.       ON UPDATE NO ACTION ON DELETE NO ACTION
97. );
98.  
99. CREATE TABLE zgloszenie
100. (
101.   id serial NOT NULL,
102.   zglaszajacy integer NOT NULL,
103.   kategoria integer NOT NULL,
104.   komputer integer,
105.   status integer,
106.   odpowiedzialny integer,
107.   data_zgloszenia timestamp(2) without time zone,
108.   termin_rozwiazania timestamp(2) without time zone,
109.   data_rozwiazania timestamp(2) without time zone,
110.   opis character varying(250) NOT NULL,
111.   wyjasnienie character varying(250),
112.   CONSTRAINT zgloszenie_pkey PRIMARY KEY (id),
113.   CONSTRAINT fk_zgloszenie_kategoria FOREIGN KEY (kategoria)
114.       REFERENCES kategoria (id) MATCH SIMPLE
115.       ON UPDATE NO ACTION ON DELETE NO ACTION,
116.   CONSTRAINT fk_zgloszenie_komputery FOREIGN KEY (komputer)
117.       REFERENCES komputery (id) MATCH SIMPLE
118.       ON UPDATE NO ACTION ON DELETE NO ACTION,
119.   CONSTRAINT fk_zgloszenie_statusy FOREIGN KEY (status)
120.       REFERENCES statusy (id) MATCH SIMPLE
121.       ON UPDATE NO ACTION ON DELETE NO ACTION,
122.   CONSTRAINT fk_zgloszenie_user_02 FOREIGN KEY (odpowiedzialny)
123.       REFERENCES users (id) MATCH SIMPLE
124.       ON UPDATE NO ACTION ON DELETE NO ACTION,
125.   CONSTRAINT fk_zgloszenie_users_01 FOREIGN KEY (zglaszajacy)
126.       REFERENCES users (id) MATCH SIMPLE
127.       ON UPDATE NO ACTION ON DELETE NO ACTION
128. );
129.  
130.  
131.  
132.  
133.  
134.  
135.