· 8 years ago · May 20, 2018, 02:24 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.8
6-- Dumped by pg_dump version 9.6.8
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
20--
21
22CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
23
24
25--
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32--
33-- Name: name_log_insert(); Type: FUNCTION; Schema: public; Owner: postgres
34--
35
36CREATE FUNCTION public.name_log_insert() RETURNS trigger
37 LANGUAGE plpgsql
38 AS $$
39BEGIN
40 INSERT INTO klientas_log (senas_vardas, naujas_vardas, klientas_id) VALUES(concat_ws(' ', OLD.vardas, OLD.pavarde),concat_ws(' ', NEW.vardas, NEW.pavarde), OLD.id);
41RETURN NULL;
42END
43$$;
44
45
46ALTER FUNCTION public.name_log_insert() OWNER TO postgres;
47
48--
49-- Name: tikrinti_darbuotoju_limita(); Type: FUNCTION; Schema: public; Owner: biglogin
50--
51
52CREATE FUNCTION public.tikrinti_darbuotoju_limita() RETURNS trigger
53 LANGUAGE plpgsql
54 AS $$BEGIN
55IF ((SELECT count(*)
56 FROM parduotuves_darbuotojas
57 WHERE darbuotojas = NEW.darbuotojas) >= 4) THEN
58 RAISE EXCEPTION 'Darbuotojas gali tureti max 4 darbus';
59 END IF;
60
61RETURN NEW;
62END;
63$$;
64
65
66ALTER FUNCTION public.tikrinti_darbuotoju_limita() OWNER TO biglogin;
67
68SET default_tablespace = '';
69
70SET default_with_oids = false;
71
72--
73-- Name: parduotuves_darbuotojas; Type: TABLE; Schema: public; Owner: biglogin
74--
75
76CREATE TABLE public.parduotuves_darbuotojas (
77 parduotuve integer NOT NULL,
78 darbuotojas integer NOT NULL,
79 pasamdymo_data timestamp without time zone DEFAULT now() NOT NULL,
80 alga double precision DEFAULT 400 NOT NULL
81);
82
83
84ALTER TABLE public.parduotuves_darbuotojas OWNER TO biglogin;
85
86--
87-- Name: alga_minimumas; Type: VIEW; Schema: public; Owner: biglogin
88--
89
90CREATE VIEW public.alga_minimumas AS
91 SELECT parduotuves_darbuotojas.parduotuve,
92 parduotuves_darbuotojas.darbuotojas,
93 parduotuves_darbuotojas.pasamdymo_data,
94 parduotuves_darbuotojas.alga
95 FROM public.parduotuves_darbuotojas
96 WHERE (parduotuves_darbuotojas.alga = (400)::double precision);
97
98
99ALTER TABLE public.alga_minimumas OWNER TO biglogin;
100
101--
102-- Name: preke; Type: TABLE; Schema: public; Owner: biglogin
103--
104
105CREATE TABLE public.preke (
106 id integer NOT NULL,
107 kaina double precision,
108 tipas integer NOT NULL,
109 pirkimas integer NOT NULL,
110 parduotuve integer,
111 CONSTRAINT kaina_above_zero CHECK ((kaina > (0)::double precision))
112);
113
114
115ALTER TABLE public.preke OWNER TO biglogin;
116
117--
118-- Name: brangi_preke; Type: VIEW; Schema: public; Owner: biglogin
119--
120
121CREATE VIEW public.brangi_preke AS
122 SELECT preke.id,
123 preke.kaina,
124 preke.tipas,
125 preke.pirkimas
126 FROM public.preke
127 WHERE (preke.kaina >= (1000)::double precision);
128
129
130ALTER TABLE public.brangi_preke OWNER TO biglogin;
131
132--
133-- Name: darbuotojas; Type: TABLE; Schema: public; Owner: postgres
134--
135
136CREATE TABLE public.darbuotojas (
137 id integer NOT NULL,
138 vardas text NOT NULL,
139 pavarde text NOT NULL,
140 asmens_kodas text NOT NULL,
141 salis text NOT NULL,
142 CONSTRAINT ak_check CHECK ((char_length(asmens_kodas) = 11))
143);
144
145
146ALTER TABLE public.darbuotojas OWNER TO postgres;
147
148--
149-- Name: darbuotojai_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
150--
151
152CREATE SEQUENCE public.darbuotojai_id_seq
153 START WITH 1
154 INCREMENT BY 1
155 NO MINVALUE
156 NO MAXVALUE
157 CACHE 1;
158
159
160ALTER TABLE public.darbuotojai_id_seq OWNER TO postgres;
161
162--
163-- Name: darbuotojai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
164--
165
166ALTER SEQUENCE public.darbuotojai_id_seq OWNED BY public.darbuotojas.id;
167
168
169--
170-- Name: didele_alga; Type: VIEW; Schema: public; Owner: biglogin
171--
172
173CREATE VIEW public.didele_alga AS
174 SELECT parduotuves_darbuotojas.parduotuve,
175 parduotuves_darbuotojas.darbuotojas,
176 parduotuves_darbuotojas.pasamdymo_data,
177 parduotuves_darbuotojas.alga
178 FROM public.parduotuves_darbuotojas
179 WHERE (parduotuves_darbuotojas.alga >= (1000)::double precision);
180
181
182ALTER TABLE public.didele_alga OWNER TO biglogin;
183
184--
185-- Name: gamintojas; Type: TABLE; Schema: public; Owner: biglogin
186--
187
188CREATE TABLE public.gamintojas (
189 id integer NOT NULL,
190 pavadinimas text NOT NULL
191);
192
193
194ALTER TABLE public.gamintojas OWNER TO biglogin;
195
196--
197-- Name: gamintojai_id_seq; Type: SEQUENCE; Schema: public; Owner: biglogin
198--
199
200CREATE SEQUENCE public.gamintojai_id_seq
201 START WITH 1
202 INCREMENT BY 1
203 NO MINVALUE
204 NO MAXVALUE
205 CACHE 1;
206
207
208ALTER TABLE public.gamintojai_id_seq OWNER TO biglogin;
209
210--
211-- Name: gamintojai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biglogin
212--
213
214ALTER SEQUENCE public.gamintojai_id_seq OWNED BY public.gamintojas.id;
215
216
217--
218-- Name: klientas; Type: TABLE; Schema: public; Owner: postgres
219--
220
221CREATE TABLE public.klientas (
222 id integer NOT NULL,
223 vardas text NOT NULL,
224 pavarde text NOT NULL,
225 salis text,
226 email text NOT NULL
227);
228
229
230ALTER TABLE public.klientas OWNER TO postgres;
231
232--
233-- Name: klientai_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
234--
235
236CREATE SEQUENCE public.klientai_id_seq
237 START WITH 1
238 INCREMENT BY 1
239 NO MINVALUE
240 NO MAXVALUE
241 CACHE 1;
242
243
244ALTER TABLE public.klientai_id_seq OWNER TO postgres;
245
246--
247-- Name: klientai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
248--
249
250ALTER SEQUENCE public.klientai_id_seq OWNED BY public.klientas.id;
251
252
253--
254-- Name: klientas_log; Type: TABLE; Schema: public; Owner: postgres
255--
256
257CREATE TABLE public.klientas_log (
258 id integer NOT NULL,
259 senas_vardas text,
260 naujas_vardas text,
261 klientas_id integer
262);
263
264
265ALTER TABLE public.klientas_log OWNER TO postgres;
266
267--
268-- Name: klientai_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
269--
270
271CREATE SEQUENCE public.klientai_log_id_seq
272 START WITH 1
273 INCREMENT BY 1
274 NO MINVALUE
275 NO MAXVALUE
276 CACHE 1;
277
278
279ALTER TABLE public.klientai_log_id_seq OWNER TO postgres;
280
281--
282-- Name: klientai_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
283--
284
285ALTER SEQUENCE public.klientai_log_id_seq OWNED BY public.klientas_log.id;
286
287
288--
289-- Name: pirkimas; Type: TABLE; Schema: public; Owner: biglogin
290--
291
292CREATE TABLE public.pirkimas (
293 id integer NOT NULL,
294 status text DEFAULT 'ruosiamas'::text NOT NULL,
295 klientas integer NOT NULL,
296 data timestamp with time zone DEFAULT now() NOT NULL,
297 pristatymo_adr text,
298 CONSTRAINT adr_check CHECK ((pristatymo_adr ~~* '%lietuva%'::text)),
299 CONSTRAINT status_check CHECK ((status = ANY (ARRAY['pristatytas'::text, 'issiustas'::text, 'ruosiamas'::text])))
300);
301
302
303ALTER TABLE public.pirkimas OWNER TO biglogin;
304
305--
306-- Name: lojaliausias_klientas; Type: MATERIALIZED VIEW; Schema: public; Owner: biglogin
307--
308
309CREATE MATERIALIZED VIEW public.lojaliausias_klientas AS
310 SELECT klientas.id,
311 klientas.vardas,
312 klientas.pavarde,
313 sum(preke.kaina) AS viso_nupirko
314 FROM ((public.pirkimas
315 JOIN public.klientas ON ((klientas.id = pirkimas.klientas)))
316 JOIN public.preke ON ((preke.pirkimas = pirkimas.id)))
317 GROUP BY klientas.id, klientas.vardas, klientas.pavarde
318 WITH NO DATA;
319
320
321ALTER TABLE public.lojaliausias_klientas OWNER TO biglogin;
322
323--
324-- Name: parduotuve; Type: TABLE; Schema: public; Owner: biglogin
325--
326
327CREATE TABLE public.parduotuve (
328 id integer NOT NULL,
329 pavadinimas text,
330 adresas text,
331 ikurimo_data timestamp with time zone DEFAULT now()
332);
333
334
335ALTER TABLE public.parduotuve OWNER TO biglogin;
336
337--
338-- Name: parduotuves_id_seq; Type: SEQUENCE; Schema: public; Owner: biglogin
339--
340
341CREATE SEQUENCE public.parduotuves_id_seq
342 START WITH 1
343 INCREMENT BY 1
344 NO MINVALUE
345 NO MAXVALUE
346 CACHE 1;
347
348
349ALTER TABLE public.parduotuves_id_seq OWNER TO biglogin;
350
351--
352-- Name: parduotuves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biglogin
353--
354
355ALTER SEQUENCE public.parduotuves_id_seq OWNED BY public.parduotuve.id;
356
357
358--
359-- Name: pigi_preke; Type: VIEW; Schema: public; Owner: biglogin
360--
361
362CREATE VIEW public.pigi_preke AS
363 SELECT preke.id,
364 preke.kaina,
365 preke.tipas,
366 preke.pirkimas
367 FROM public.preke
368 WHERE (preke.kaina < (1000)::double precision);
369
370
371ALTER TABLE public.pigi_preke OWNER TO biglogin;
372
373--
374-- Name: prekes_id_seq; Type: SEQUENCE; Schema: public; Owner: biglogin
375--
376
377CREATE SEQUENCE public.prekes_id_seq
378 START WITH 1
379 INCREMENT BY 1
380 NO MINVALUE
381 NO MAXVALUE
382 CACHE 1;
383
384
385ALTER TABLE public.prekes_id_seq OWNER TO biglogin;
386
387--
388-- Name: prekes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biglogin
389--
390
391ALTER SEQUENCE public.prekes_id_seq OWNED BY public.pirkimas.id;
392
393
394--
395-- Name: prekes_id_seq1; Type: SEQUENCE; Schema: public; Owner: biglogin
396--
397
398CREATE SEQUENCE public.prekes_id_seq1
399 START WITH 1
400 INCREMENT BY 1
401 NO MINVALUE
402 NO MAXVALUE
403 CACHE 1;
404
405
406ALTER TABLE public.prekes_id_seq1 OWNER TO biglogin;
407
408--
409-- Name: prekes_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: biglogin
410--
411
412ALTER SEQUENCE public.prekes_id_seq1 OWNED BY public.preke.id;
413
414
415--
416-- Name: prekes_tipas; Type: TABLE; Schema: public; Owner: biglogin
417--
418
419CREATE TABLE public.prekes_tipas (
420 id integer NOT NULL,
421 pavadinimas text NOT NULL,
422 aprasymas text,
423 gamintojas integer NOT NULL
424);
425
426
427ALTER TABLE public.prekes_tipas OWNER TO biglogin;
428
429--
430-- Name: prekes_tipai_id_seq; Type: SEQUENCE; Schema: public; Owner: biglogin
431--
432
433CREATE SEQUENCE public.prekes_tipai_id_seq
434 START WITH 1
435 INCREMENT BY 1
436 NO MINVALUE
437 NO MAXVALUE
438 CACHE 1;
439
440
441ALTER TABLE public.prekes_tipai_id_seq OWNER TO biglogin;
442
443--
444-- Name: prekes_tipai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biglogin
445--
446
447ALTER SEQUENCE public.prekes_tipai_id_seq OWNED BY public.prekes_tipas.id;
448
449
450--
451-- Name: darbuotojas id; Type: DEFAULT; Schema: public; Owner: postgres
452--
453
454ALTER TABLE ONLY public.darbuotojas ALTER COLUMN id SET DEFAULT nextval('public.darbuotojai_id_seq'::regclass);
455
456
457--
458-- Name: gamintojas id; Type: DEFAULT; Schema: public; Owner: biglogin
459--
460
461ALTER TABLE ONLY public.gamintojas ALTER COLUMN id SET DEFAULT nextval('public.gamintojai_id_seq'::regclass);
462
463
464--
465-- Name: klientas id; Type: DEFAULT; Schema: public; Owner: postgres
466--
467
468ALTER TABLE ONLY public.klientas ALTER COLUMN id SET DEFAULT nextval('public.klientai_id_seq'::regclass);
469
470
471--
472-- Name: klientas_log id; Type: DEFAULT; Schema: public; Owner: postgres
473--
474
475ALTER TABLE ONLY public.klientas_log ALTER COLUMN id SET DEFAULT nextval('public.klientai_log_id_seq'::regclass);
476
477
478--
479-- Name: parduotuve id; Type: DEFAULT; Schema: public; Owner: biglogin
480--
481
482ALTER TABLE ONLY public.parduotuve ALTER COLUMN id SET DEFAULT nextval('public.parduotuves_id_seq'::regclass);
483
484
485--
486-- Name: pirkimas id; Type: DEFAULT; Schema: public; Owner: biglogin
487--
488
489ALTER TABLE ONLY public.pirkimas ALTER COLUMN id SET DEFAULT nextval('public.prekes_id_seq'::regclass);
490
491
492--
493-- Name: preke id; Type: DEFAULT; Schema: public; Owner: biglogin
494--
495
496ALTER TABLE ONLY public.preke ALTER COLUMN id SET DEFAULT nextval('public.prekes_id_seq1'::regclass);
497
498
499--
500-- Name: prekes_tipas id; Type: DEFAULT; Schema: public; Owner: biglogin
501--
502
503ALTER TABLE ONLY public.prekes_tipas ALTER COLUMN id SET DEFAULT nextval('public.prekes_tipai_id_seq'::regclass);
504
505
506--
507-- Name: darbuotojai_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
508--
509
510SELECT pg_catalog.setval('public.darbuotojai_id_seq', 1, true);
511
512
513--
514-- Data for Name: darbuotojas; Type: TABLE DATA; Schema: public; Owner: postgres
515--
516
517COPY public.darbuotojas (id, vardas, pavarde, asmens_kodas, salis) FROM stdin;
5181 Romas Kalanta 38814121543 Lietuva
519\.
520
521
522--
523-- Name: gamintojai_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biglogin
524--
525
526SELECT pg_catalog.setval('public.gamintojai_id_seq', 1, true);
527
528
529--
530-- Data for Name: gamintojas; Type: TABLE DATA; Schema: public; Owner: biglogin
531--
532
533COPY public.gamintojas (id, pavadinimas) FROM stdin;
5341 Big FActory
535\.
536
537
538--
539-- Name: klientai_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
540--
541
542SELECT pg_catalog.setval('public.klientai_id_seq', 2, true);
543
544
545--
546-- Name: klientai_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
547--
548
549SELECT pg_catalog.setval('public.klientai_log_id_seq', 7, true);
550
551
552--
553-- Data for Name: klientas; Type: TABLE DATA; Schema: public; Owner: postgres
554--
555
556COPY public.klientas (id, vardas, pavarde, salis, email) FROM stdin;
5571 rokas asd test a@a.lt
558\.
559
560
561--
562-- Data for Name: klientas_log; Type: TABLE DATA; Schema: public; Owner: postgres
563--
564
565COPY public.klientas_log (id, senas_vardas, naujas_vardas, klientas_id) FROM stdin;
5661 asd dasd \N
5672 asd dasd \N
5683 123 123 555 666 \N
5695 rokas,asd rokas,asddd \N
5706 rokas asd rokas testas123 \N
5717 rokas asd rokas porapapa \N
572\.
573
574
575--
576-- Data for Name: parduotuve; Type: TABLE DATA; Schema: public; Owner: biglogin
577--
578
579COPY public.parduotuve (id, pavadinimas, adresas, ikurimo_data) FROM stdin;
5801 Comprehendo Test 1 2018-05-15 08:55:57.575839+03
5812 Test 2 TEst 3 2018-05-15 08:56:15.598992+03
5823 Big shop asd 2018-05-15 08:56:30.010644+03
583\.
584
585
586--
587-- Data for Name: parduotuves_darbuotojas; Type: TABLE DATA; Schema: public; Owner: biglogin
588--
589
590COPY public.parduotuves_darbuotojas (parduotuve, darbuotojas, pasamdymo_data, alga) FROM stdin;
5911 1 2018-05-15 08:56:48.572474 400
5922 1 2018-05-15 08:56:55.044784 400
593\.
594
595
596--
597-- Name: parduotuves_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biglogin
598--
599
600SELECT pg_catalog.setval('public.parduotuves_id_seq', 3, true);
601
602
603--
604-- Data for Name: pirkimas; Type: TABLE DATA; Schema: public; Owner: biglogin
605--
606
607COPY public.pirkimas (id, status, klientas, data, pristatymo_adr) FROM stdin;
6082 ruosiamas 1 2018-05-15 09:40:53.218121+03 asd asd, Lietuva
609\.
610
611
612--
613-- Data for Name: preke; Type: TABLE DATA; Schema: public; Owner: biglogin
614--
615
616COPY public.preke (id, kaina, tipas, pirkimas, parduotuve) FROM stdin;
6172 100 1 2 2
618\.
619
620
621--
622-- Name: prekes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biglogin
623--
624
625SELECT pg_catalog.setval('public.prekes_id_seq', 2, true);
626
627
628--
629-- Name: prekes_id_seq1; Type: SEQUENCE SET; Schema: public; Owner: biglogin
630--
631
632SELECT pg_catalog.setval('public.prekes_id_seq1', 2, true);
633
634
635--
636-- Name: prekes_tipai_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biglogin
637--
638
639SELECT pg_catalog.setval('public.prekes_tipai_id_seq', 1, true);
640
641
642--
643-- Data for Name: prekes_tipas; Type: TABLE DATA; Schema: public; Owner: biglogin
644--
645
646COPY public.prekes_tipas (id, pavadinimas, aprasymas, gamintojas) FROM stdin;
6471 preke1 \N 1
648\.
649
650
651--
652-- Name: parduotuve parduotuves_pkey; Type: CONSTRAINT; Schema: public; Owner: biglogin
653--
654
655ALTER TABLE ONLY public.parduotuve
656 ADD CONSTRAINT parduotuves_pkey PRIMARY KEY (id);
657
658
659--
660-- Name: parduotuves_statistika; Type: MATERIALIZED VIEW; Schema: public; Owner: postgres
661--
662
663CREATE MATERIALIZED VIEW public.parduotuves_statistika AS
664 SELECT parduotuve.pavadinimas AS parduotuve,
665 count(preke.*) AS parduotu_prekiu_sk
666 FROM (public.preke
667 JOIN public.parduotuve ON ((preke.parduotuve = parduotuve.id)))
668 WHERE (preke.pirkimas IS NOT NULL)
669 GROUP BY parduotuve.id
670 WITH NO DATA;
671
672
673ALTER TABLE public.parduotuves_statistika OWNER TO postgres;
674
675--
676-- Name: parduotuves_darbuotojas alga_daugiau_uz_0; Type: CHECK CONSTRAINT; Schema: public; Owner: biglogin
677--
678
679ALTER TABLE public.parduotuves_darbuotojas
680 ADD CONSTRAINT alga_daugiau_uz_0 CHECK ((alga > (0)::double precision)) NOT VALID;
681
682
683--
684-- Name: darbuotojas darbuotojai_asmens_kodas_salis_key; Type: CONSTRAINT; Schema: public; Owner: postgres
685--
686
687ALTER TABLE ONLY public.darbuotojas
688 ADD CONSTRAINT darbuotojai_asmens_kodas_salis_key UNIQUE (asmens_kodas, salis);
689
690
691--
692-- Name: gamintojas gamintojai_pkey; Type: CONSTRAINT; Schema: public; Owner: biglogin
693--
694
695ALTER TABLE ONLY public.gamintojas
696 ADD CONSTRAINT gamintojai_pkey PRIMARY KEY (id);
697
698
699--
700-- Name: darbuotojas id; Type: CONSTRAINT; Schema: public; Owner: postgres
701--
702
703ALTER TABLE ONLY public.darbuotojas
704 ADD CONSTRAINT id PRIMARY KEY (id);
705
706
707--
708-- Name: klientas_log klientai_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
709--
710
711ALTER TABLE ONLY public.klientas_log
712 ADD CONSTRAINT klientai_log_pkey PRIMARY KEY (id);
713
714
715--
716-- Name: klientas klientai_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
717--
718
719ALTER TABLE ONLY public.klientas
720 ADD CONSTRAINT klientai_pkey PRIMARY KEY (id);
721
722
723--
724-- Name: klientas klientas_email; Type: CONSTRAINT; Schema: public; Owner: postgres
725--
726
727ALTER TABLE ONLY public.klientas
728 ADD CONSTRAINT klientas_email UNIQUE (email);
729
730
731--
732-- Name: parduotuves_darbuotojas parduotuves_darbuotojai_pkey; Type: CONSTRAINT; Schema: public; Owner: biglogin
733--
734
735ALTER TABLE ONLY public.parduotuves_darbuotojas
736 ADD CONSTRAINT parduotuves_darbuotojai_pkey PRIMARY KEY (darbuotojas, parduotuve);
737
738
739--
740-- Name: pirkimas prekes_pkey; Type: CONSTRAINT; Schema: public; Owner: biglogin
741--
742
743ALTER TABLE ONLY public.pirkimas
744 ADD CONSTRAINT prekes_pkey PRIMARY KEY (id);
745
746
747--
748-- Name: preke prekes_pkey1; Type: CONSTRAINT; Schema: public; Owner: biglogin
749--
750
751ALTER TABLE ONLY public.preke
752 ADD CONSTRAINT prekes_pkey1 PRIMARY KEY (id);
753
754
755--
756-- Name: prekes_tipas prekes_tipai_pkey; Type: CONSTRAINT; Schema: public; Owner: biglogin
757--
758
759ALTER TABLE ONLY public.prekes_tipas
760 ADD CONSTRAINT prekes_tipai_pkey PRIMARY KEY (id);
761
762
763--
764-- Name: klientai_vardas_pavarde_idx; Type: INDEX; Schema: public; Owner: postgres
765--
766
767CREATE INDEX klientai_vardas_pavarde_idx ON public.klientas USING btree (vardas, pavarde);
768
769
770--
771-- Name: pav_ind; Type: INDEX; Schema: public; Owner: biglogin
772--
773
774CREATE INDEX pav_ind ON public.prekes_tipas USING btree (pavadinimas);
775
776
777--
778-- Name: parduotuves_darbuotojas darbu_limitas; Type: TRIGGER; Schema: public; Owner: biglogin
779--
780
781CREATE TRIGGER darbu_limitas BEFORE INSERT ON public.parduotuves_darbuotojas FOR EACH ROW EXECUTE PROCEDURE public.tikrinti_darbuotoju_limita();
782
783
784--
785-- Name: klientas name_change; Type: TRIGGER; Schema: public; Owner: postgres
786--
787
788CREATE TRIGGER name_change BEFORE UPDATE OF vardas, pavarde ON public.klientas FOR EACH ROW EXECUTE PROCEDURE public.name_log_insert();
789
790
791--
792-- Name: prekes_tipas gamintojas_fk; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
793--
794
795ALTER TABLE ONLY public.prekes_tipas
796 ADD CONSTRAINT gamintojas_fk FOREIGN KEY (gamintojas) REFERENCES public.gamintojas(id);
797
798
799--
800-- Name: klientas_log klientas_log_klientas_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
801--
802
803ALTER TABLE ONLY public.klientas_log
804 ADD CONSTRAINT klientas_log_klientas_id_fkey FOREIGN KEY (klientas_id) REFERENCES public.klientas(id);
805
806
807--
808-- Name: parduotuves_darbuotojas parduotuves_darbuotojai_darbuotojas_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
809--
810
811ALTER TABLE ONLY public.parduotuves_darbuotojas
812 ADD CONSTRAINT parduotuves_darbuotojai_darbuotojas_fkey FOREIGN KEY (darbuotojas) REFERENCES public.darbuotojas(id);
813
814
815--
816-- Name: parduotuves_darbuotojas parduotuves_darbuotojai_parduotuve_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
817--
818
819ALTER TABLE ONLY public.parduotuves_darbuotojas
820 ADD CONSTRAINT parduotuves_darbuotojai_parduotuve_fkey FOREIGN KEY (parduotuve) REFERENCES public.parduotuve(id);
821
822
823--
824-- Name: pirkimas pirkimai_klientas_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
825--
826
827ALTER TABLE ONLY public.pirkimas
828 ADD CONSTRAINT pirkimai_klientas_fkey FOREIGN KEY (klientas) REFERENCES public.klientas(id);
829
830
831--
832-- Name: preke prekes_parduotuve_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
833--
834
835ALTER TABLE ONLY public.preke
836 ADD CONSTRAINT prekes_parduotuve_fkey FOREIGN KEY (parduotuve) REFERENCES public.parduotuve(id);
837
838
839--
840-- Name: preke prekes_pirkimas_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
841--
842
843ALTER TABLE ONLY public.preke
844 ADD CONSTRAINT prekes_pirkimas_fkey FOREIGN KEY (pirkimas) REFERENCES public.pirkimas(id);
845
846
847--
848-- Name: prekes_tipas prekes_tipai_gamintojas_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
849--
850
851ALTER TABLE ONLY public.prekes_tipas
852 ADD CONSTRAINT prekes_tipai_gamintojas_fkey FOREIGN KEY (gamintojas) REFERENCES public.gamintojas(id);
853
854
855--
856-- Name: preke prekes_tipas_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biglogin
857--
858
859ALTER TABLE ONLY public.preke
860 ADD CONSTRAINT prekes_tipas_fkey FOREIGN KEY (tipas) REFERENCES public.prekes_tipas(id);
861
862
863--
864-- Name: lojaliausias_klientas; Type: MATERIALIZED VIEW DATA; Schema: public; Owner: biglogin
865--
866
867REFRESH MATERIALIZED VIEW public.lojaliausias_klientas;
868
869
870--
871-- Name: parduotuves_statistika; Type: MATERIALIZED VIEW DATA; Schema: public; Owner: postgres
872--
873
874REFRESH MATERIALIZED VIEW public.parduotuves_statistika;
875
876
877--
878-- PostgreSQL database dump complete
879--