· 6 years ago · Jan 27, 2020, 02:04 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 11.2
6-- Dumped by pg_dump version 12.1
7
8-- Started on 2020-01-27 03:00:21
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET idle_in_transaction_session_timeout = 0;
13SET client_encoding = 'UTF8';
14SET standard_conforming_strings = on;a
15SELECT pg_catalog.set_config('search_path', '', false);
16SET check_function_bodies = false;
17SET xmloption = content;
18SET client_min_messages = warning;
19SET row_security = off;
20
21--
22-- TOC entry 1 (class 3079 OID 16384)
23-- Name: adminpack; Type: EXTENSION; Schema: -; Owner: -
24--
25
26CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;
27
28
29--
30-- TOC entry 3173 (class 0 OID 0)
31-- Dependencies: 1
32-- Name: EXTENSION adminpack; Type: COMMENT; Schema: -; Owner:
33--
34
35COMMENT ON EXTENSION adminpack IS 'administrative functions for PostgreSQL';
36
37
38SET default_tablespace = '';
39
40--
41-- TOC entry 204 (class 1259 OID 16468)
42-- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres
43--
44
45CREATE TABLE public.auth_group (
46 id integer NOT NULL,
47 name character varying(150) NOT NULL
48);
49
50
51ALTER TABLE public.auth_group OWNER TO postgres;
52
53--
54-- TOC entry 203 (class 1259 OID 16466)
55-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
56--
57
58CREATE SEQUENCE public.auth_group_id_seq
59 AS integer
60 START WITH 1
61 INCREMENT BY 1
62 NO MINVALUE
63 NO MAXVALUE
64 CACHE 1;
65
66
67ALTER TABLE public.auth_group_id_seq OWNER TO postgres;
68
69--
70-- TOC entry 3174 (class 0 OID 0)
71-- Dependencies: 203
72-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
73--
74
75ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;
76
77
78--
79-- TOC entry 206 (class 1259 OID 16478)
80-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres
81--
82
83CREATE TABLE public.auth_group_permissions (
84 id integer NOT NULL,
85 group_id integer NOT NULL,
86 permission_id integer NOT NULL
87);
88
89
90ALTER TABLE public.auth_group_permissions OWNER TO postgres;
91
92--
93-- TOC entry 205 (class 1259 OID 16476)
94-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
95--
96
97CREATE SEQUENCE public.auth_group_permissions_id_seq
98 AS integer
99 START WITH 1
100 INCREMENT BY 1
101 NO MINVALUE
102 NO MAXVALUE
103 CACHE 1;
104
105
106ALTER TABLE public.auth_group_permissions_id_seq OWNER TO postgres;
107
108--
109-- TOC entry 3175 (class 0 OID 0)
110-- Dependencies: 205
111-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
112--
113
114ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id;
115
116
117--
118-- TOC entry 202 (class 1259 OID 16460)
119-- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres
120--
121
122CREATE TABLE public.auth_permission (
123 id integer NOT NULL,
124 name character varying(255) NOT NULL,
125 content_type_id integer NOT NULL,
126 codename character varying(100) NOT NULL
127);
128
129
130ALTER TABLE public.auth_permission OWNER TO postgres;
131
132--
133-- TOC entry 201 (class 1259 OID 16458)
134-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
135--
136
137CREATE SEQUENCE public.auth_permission_id_seq
138 AS integer
139 START WITH 1
140 INCREMENT BY 1
141 NO MINVALUE
142 NO MAXVALUE
143 CACHE 1;
144
145
146ALTER TABLE public.auth_permission_id_seq OWNER TO postgres;
147
148--
149-- TOC entry 3176 (class 0 OID 0)
150-- Dependencies: 201
151-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
152--
153
154ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;
155
156
157--
158-- TOC entry 208 (class 1259 OID 16486)
159-- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres
160--
161
162CREATE TABLE public.auth_user (
163 id integer NOT NULL,
164 password character varying(128) NOT NULL,
165 last_login timestamp with time zone,
166 is_superuser boolean NOT NULL,
167 username character varying(150) NOT NULL,
168 first_name character varying(30) NOT NULL,
169 last_name character varying(150) NOT NULL,
170 email character varying(254) NOT NULL,
171 is_staff boolean NOT NULL,
172 is_active boolean NOT NULL,
173 date_joined timestamp with time zone NOT NULL
174);
175
176
177ALTER TABLE public.auth_user OWNER TO postgres;
178
179--
180-- TOC entry 210 (class 1259 OID 16496)
181-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres
182--
183
184CREATE TABLE public.auth_user_groups (
185 id integer NOT NULL,
186 user_id integer NOT NULL,
187 group_id integer NOT NULL
188);
189
190
191ALTER TABLE public.auth_user_groups OWNER TO postgres;
192
193--
194-- TOC entry 209 (class 1259 OID 16494)
195-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
196--
197
198CREATE SEQUENCE public.auth_user_groups_id_seq
199 AS integer
200 START WITH 1
201 INCREMENT BY 1
202 NO MINVALUE
203 NO MAXVALUE
204 CACHE 1;
205
206
207ALTER TABLE public.auth_user_groups_id_seq OWNER TO postgres;
208
209--
210-- TOC entry 3177 (class 0 OID 0)
211-- Dependencies: 209
212-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
213--
214
215ALTER SEQUENCE public.auth_user_groups_id_seq OWNED BY public.auth_user_groups.id;
216
217
218--
219-- TOC entry 207 (class 1259 OID 16484)
220-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
221--
222
223CREATE SEQUENCE public.auth_user_id_seq
224 AS integer
225 START WITH 1
226 INCREMENT BY 1
227 NO MINVALUE
228 NO MAXVALUE
229 CACHE 1;
230
231
232ALTER TABLE public.auth_user_id_seq OWNER TO postgres;
233
234--
235-- TOC entry 3178 (class 0 OID 0)
236-- Dependencies: 207
237-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
238--
239
240ALTER SEQUENCE public.auth_user_id_seq OWNED BY public.auth_user.id;
241
242
243--
244-- TOC entry 212 (class 1259 OID 16504)
245-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres
246--
247
248CREATE TABLE public.auth_user_user_permissions (
249 id integer NOT NULL,
250 user_id integer NOT NULL,
251 permission_id integer NOT NULL
252);
253
254
255ALTER TABLE public.auth_user_user_permissions OWNER TO postgres;
256
257--
258-- TOC entry 211 (class 1259 OID 16502)
259-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
260--
261
262CREATE SEQUENCE public.auth_user_user_permissions_id_seq
263 AS integer
264 START WITH 1
265 INCREMENT BY 1
266 NO MINVALUE
267 NO MAXVALUE
268 CACHE 1;
269
270
271ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO postgres;
272
273--
274-- TOC entry 3179 (class 0 OID 0)
275-- Dependencies: 211
276-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
277--
278
279ALTER SEQUENCE public.auth_user_user_permissions_id_seq OWNED BY public.auth_user_user_permissions.id;
280
281
282--
283-- TOC entry 214 (class 1259 OID 16564)
284-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres
285--
286
287CREATE TABLE public.django_admin_log (
288 id integer NOT NULL,
289 action_time timestamp with time zone NOT NULL,
290 object_id text,
291 object_repr character varying(200) NOT NULL,
292 action_flag smallint NOT NULL,
293 change_message text NOT NULL,
294 content_type_id integer,
295 user_id integer NOT NULL,
296 CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
297);
298
299
300ALTER TABLE public.django_admin_log OWNER TO postgres;
301
302--
303-- TOC entry 213 (class 1259 OID 16562)
304-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
305--
306
307CREATE SEQUENCE public.django_admin_log_id_seq
308 AS integer
309 START WITH 1
310 INCREMENT BY 1
311 NO MINVALUE
312 NO MAXVALUE
313 CACHE 1;
314
315
316ALTER TABLE public.django_admin_log_id_seq OWNER TO postgres;
317
318--
319-- TOC entry 3180 (class 0 OID 0)
320-- Dependencies: 213
321-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
322--
323
324ALTER SEQUENCE public.django_admin_log_id_seq OWNED BY public.django_admin_log.id;
325
326
327--
328-- TOC entry 200 (class 1259 OID 16450)
329-- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres
330--
331
332CREATE TABLE public.django_content_type (
333 id integer NOT NULL,
334 app_label character varying(100) NOT NULL,
335 model character varying(100) NOT NULL
336);
337
338
339ALTER TABLE public.django_content_type OWNER TO postgres;
340
341--
342-- TOC entry 199 (class 1259 OID 16448)
343-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
344--
345
346CREATE SEQUENCE public.django_content_type_id_seq
347 AS integer
348 START WITH 1
349 INCREMENT BY 1
350 NO MINVALUE
351 NO MAXVALUE
352 CACHE 1;
353
354
355ALTER TABLE public.django_content_type_id_seq OWNER TO postgres;
356
357--
358-- TOC entry 3181 (class 0 OID 0)
359-- Dependencies: 199
360-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
361--
362
363ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id;
364
365
366--
367-- TOC entry 198 (class 1259 OID 16439)
368-- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres
369--
370
371CREATE TABLE public.django_migrations (
372 id integer NOT NULL,
373 app character varying(255) NOT NULL,
374 name character varying(255) NOT NULL,
375 applied timestamp with time zone NOT NULL
376);
377
378
379ALTER TABLE public.django_migrations OWNER TO postgres;
380
381--
382-- TOC entry 197 (class 1259 OID 16437)
383-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
384--
385
386CREATE SEQUENCE public.django_migrations_id_seq
387 AS integer
388 START WITH 1
389 INCREMENT BY 1
390 NO MINVALUE
391 NO MAXVALUE
392 CACHE 1;
393
394
395ALTER TABLE public.django_migrations_id_seq OWNER TO postgres;
396
397--
398-- TOC entry 3182 (class 0 OID 0)
399-- Dependencies: 197
400-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
401--
402
403ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id;
404
405
406--
407-- TOC entry 215 (class 1259 OID 16595)
408-- Name: django_session; Type: TABLE; Schema: public; Owner: postgres
409--
410
411CREATE TABLE public.django_session (
412 session_key character varying(40) NOT NULL,
413 session_data text NOT NULL,
414 expire_date timestamp with time zone NOT NULL
415);
416
417
418ALTER TABLE public.django_session OWNER TO postgres;
419
420--
421-- TOC entry 235 (class 1259 OID 16807)
422-- Name: lekarze_city; Type: TABLE; Schema: public; Owner: postgres
423--
424
425CREATE TABLE public.lekarze_city (
426 id integer NOT NULL,
427 name character varying(50) NOT NULL,
428 country_id integer NOT NULL
429);
430
431
432ALTER TABLE public.lekarze_city OWNER TO postgres;
433
434--
435-- TOC entry 234 (class 1259 OID 16805)
436-- Name: lekarze_city_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
437--
438
439CREATE SEQUENCE public.lekarze_city_id_seq
440 AS integer
441 START WITH 1
442 INCREMENT BY 1
443 NO MINVALUE
444 NO MAXVALUE
445 CACHE 1;
446
447
448ALTER TABLE public.lekarze_city_id_seq OWNER TO postgres;
449
450--
451-- TOC entry 3183 (class 0 OID 0)
452-- Dependencies: 234
453-- Name: lekarze_city_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
454--
455
456ALTER SEQUENCE public.lekarze_city_id_seq OWNED BY public.lekarze_city.id;
457
458
459--
460-- TOC entry 233 (class 1259 OID 16797)
461-- Name: lekarze_country; Type: TABLE; Schema: public; Owner: postgres
462--
463
464CREATE TABLE public.lekarze_country (
465 id integer NOT NULL,
466 name character varying(50) NOT NULL
467);
468
469
470ALTER TABLE public.lekarze_country OWNER TO postgres;
471
472--
473-- TOC entry 232 (class 1259 OID 16795)
474-- Name: lekarze_country_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
475--
476
477CREATE SEQUENCE public.lekarze_country_id_seq
478 AS integer
479 START WITH 1
480 INCREMENT BY 1
481 NO MINVALUE
482 NO MAXVALUE
483 CACHE 1;
484
485
486ALTER TABLE public.lekarze_country_id_seq OWNER TO postgres;
487
488--
489-- TOC entry 3184 (class 0 OID 0)
490-- Dependencies: 232
491-- Name: lekarze_country_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
492--
493
494ALTER SEQUENCE public.lekarze_country_id_seq OWNED BY public.lekarze_country.id;
495
496
497--
498-- TOC entry 219 (class 1259 OID 16615)
499-- Name: lekarze_department; Type: TABLE; Schema: public; Owner: postgres
500--
501
502CREATE TABLE public.lekarze_department (
503 id integer NOT NULL,
504 name character varying(50),
505 hospital_id integer NOT NULL
506);
507
508
509ALTER TABLE public.lekarze_department OWNER TO postgres;
510
511--
512-- TOC entry 218 (class 1259 OID 16613)
513-- Name: lekarze_department_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
514--
515
516CREATE SEQUENCE public.lekarze_department_id_seq
517 AS integer
518 START WITH 1
519 INCREMENT BY 1
520 NO MINVALUE
521 NO MAXVALUE
522 CACHE 1;
523
524
525ALTER TABLE public.lekarze_department_id_seq OWNER TO postgres;
526
527--
528-- TOC entry 3185 (class 0 OID 0)
529-- Dependencies: 218
530-- Name: lekarze_department_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
531--
532
533ALTER SEQUENCE public.lekarze_department_id_seq OWNED BY public.lekarze_department.id;
534
535
536--
537-- TOC entry 243 (class 1259 OID 16986)
538-- Name: lekarze_exchange; Type: TABLE; Schema: public; Owner: postgres
539--
540
541CREATE TABLE public.lekarze_exchange (
542 id integer NOT NULL,
543 status smallint NOT NULL,
544 who_id integer,
545 whom_id integer,
546 myshift_id integer,
547 yourshift_id integer
548);
549
550
551ALTER TABLE public.lekarze_exchange OWNER TO postgres;
552
553--
554-- TOC entry 242 (class 1259 OID 16984)
555-- Name: lekarze_exchange_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
556--
557
558CREATE SEQUENCE public.lekarze_exchange_id_seq
559 AS integer
560 START WITH 1
561 INCREMENT BY 1
562 NO MINVALUE
563 NO MAXVALUE
564 CACHE 1;
565
566
567ALTER TABLE public.lekarze_exchange_id_seq OWNER TO postgres;
568
569--
570-- TOC entry 3186 (class 0 OID 0)
571-- Dependencies: 242
572-- Name: lekarze_exchange_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
573--
574
575ALTER SEQUENCE public.lekarze_exchange_id_seq OWNED BY public.lekarze_exchange.id;
576
577
578--
579-- TOC entry 217 (class 1259 OID 16607)
580-- Name: lekarze_hospital; Type: TABLE; Schema: public; Owner: postgres
581--
582
583CREATE TABLE public.lekarze_hospital (
584 id integer NOT NULL,
585 name character varying(50),
586 address character varying(50),
587 city_id integer NOT NULL
588);
589
590
591ALTER TABLE public.lekarze_hospital OWNER TO postgres;
592
593--
594-- TOC entry 216 (class 1259 OID 16605)
595-- Name: lekarze_hospital_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
596--
597
598CREATE SEQUENCE public.lekarze_hospital_id_seq
599 AS integer
600 START WITH 1
601 INCREMENT BY 1
602 NO MINVALUE
603 NO MAXVALUE
604 CACHE 1;
605
606
607ALTER TABLE public.lekarze_hospital_id_seq OWNER TO postgres;
608
609--
610-- TOC entry 3187 (class 0 OID 0)
611-- Dependencies: 216
612-- Name: lekarze_hospital_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
613--
614
615ALTER SEQUENCE public.lekarze_hospital_id_seq OWNED BY public.lekarze_hospital.id;
616
617
618--
619-- TOC entry 237 (class 1259 OID 16836)
620-- Name: lekarze_shift; Type: TABLE; Schema: public; Owner: postgres
621--
622
623CREATE TABLE public.lekarze_shift (
624 shift_id integer NOT NULL,
625 shift_name character varying(255),
626 start_date timestamp with time zone,
627 end_date timestamp with time zone,
628 department_id integer NOT NULL,
629 staff_name_id integer NOT NULL,
630 shift_type_id integer NOT NULL
631);
632
633
634ALTER TABLE public.lekarze_shift OWNER TO postgres;
635
636--
637-- TOC entry 236 (class 1259 OID 16834)
638-- Name: lekarze_shift_shift_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
639--
640
641CREATE SEQUENCE public.lekarze_shift_shift_id_seq
642 AS integer
643 START WITH 1
644 INCREMENT BY 1
645 NO MINVALUE
646 NO MAXVALUE
647 CACHE 1;
648
649
650ALTER TABLE public.lekarze_shift_shift_id_seq OWNER TO postgres;
651
652--
653-- TOC entry 3188 (class 0 OID 0)
654-- Dependencies: 236
655-- Name: lekarze_shift_shift_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
656--
657
658ALTER SEQUENCE public.lekarze_shift_shift_id_seq OWNED BY public.lekarze_shift.shift_id;
659
660
661--
662-- TOC entry 241 (class 1259 OID 16893)
663-- Name: lekarze_shiftcounter; Type: TABLE; Schema: public; Owner: postgres
664--
665
666CREATE TABLE public.lekarze_shiftcounter (
667 id integer NOT NULL,
668 date timestamp with time zone,
669 counter smallint NOT NULL,
670 shift_type_id integer NOT NULL,
671 department_id integer
672);
673
674
675ALTER TABLE public.lekarze_shiftcounter OWNER TO postgres;
676
677--
678-- TOC entry 240 (class 1259 OID 16891)
679-- Name: lekarze_shiftcounter_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
680--
681
682CREATE SEQUENCE public.lekarze_shiftcounter_id_seq
683 AS integer
684 START WITH 1
685 INCREMENT BY 1
686 NO MINVALUE
687 NO MAXVALUE
688 CACHE 1;
689
690
691ALTER TABLE public.lekarze_shiftcounter_id_seq OWNER TO postgres;
692
693--
694-- TOC entry 3189 (class 0 OID 0)
695-- Dependencies: 240
696-- Name: lekarze_shiftcounter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
697--
698
699ALTER SEQUENCE public.lekarze_shiftcounter_id_seq OWNED BY public.lekarze_shiftcounter.id;
700
701
702--
703-- TOC entry 239 (class 1259 OID 16856)
704-- Name: lekarze_shifttype; Type: TABLE; Schema: public; Owner: postgres
705--
706
707CREATE TABLE public.lekarze_shifttype (
708 id integer NOT NULL,
709 name character varying(50),
710 start_date time without time zone,
711 end_date time without time zone
712);
713
714
715ALTER TABLE public.lekarze_shifttype OWNER TO postgres;
716
717--
718-- TOC entry 238 (class 1259 OID 16854)
719-- Name: lekarze_shifttype_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
720--
721
722CREATE SEQUENCE public.lekarze_shifttype_id_seq
723 AS integer
724 START WITH 1
725 INCREMENT BY 1
726 NO MINVALUE
727 NO MAXVALUE
728 CACHE 1;
729
730
731ALTER TABLE public.lekarze_shifttype_id_seq OWNER TO postgres;
732
733--
734-- TOC entry 3190 (class 0 OID 0)
735-- Dependencies: 238
736-- Name: lekarze_shifttype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
737--
738
739ALTER SEQUENCE public.lekarze_shifttype_id_seq OWNED BY public.lekarze_shifttype.id;
740
741
742--
743-- TOC entry 221 (class 1259 OID 16630)
744-- Name: schedule_calendar; Type: TABLE; Schema: public; Owner: postgres
745--
746
747CREATE TABLE public.schedule_calendar (
748 id integer NOT NULL,
749 name character varying(200) NOT NULL,
750 slug character varying(200) NOT NULL
751);
752
753
754ALTER TABLE public.schedule_calendar OWNER TO postgres;
755
756--
757-- TOC entry 220 (class 1259 OID 16628)
758-- Name: schedule_calendar_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
759--
760
761CREATE SEQUENCE public.schedule_calendar_id_seq
762 AS integer
763 START WITH 1
764 INCREMENT BY 1
765 NO MINVALUE
766 NO MAXVALUE
767 CACHE 1;
768
769
770ALTER TABLE public.schedule_calendar_id_seq OWNER TO postgres;
771
772--
773-- TOC entry 3191 (class 0 OID 0)
774-- Dependencies: 220
775-- Name: schedule_calendar_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
776--
777
778ALTER SEQUENCE public.schedule_calendar_id_seq OWNED BY public.schedule_calendar.id;
779
780
781--
782-- TOC entry 223 (class 1259 OID 16638)
783-- Name: schedule_calendarrelation; Type: TABLE; Schema: public; Owner: postgres
784--
785
786CREATE TABLE public.schedule_calendarrelation (
787 id integer NOT NULL,
788 object_id integer NOT NULL,
789 distinction character varying(20) NOT NULL,
790 inheritable boolean NOT NULL,
791 calendar_id integer NOT NULL,
792 content_type_id integer NOT NULL
793);
794
795
796ALTER TABLE public.schedule_calendarrelation OWNER TO postgres;
797
798--
799-- TOC entry 222 (class 1259 OID 16636)
800-- Name: schedule_calendarrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
801--
802
803CREATE SEQUENCE public.schedule_calendarrelation_id_seq
804 AS integer
805 START WITH 1
806 INCREMENT BY 1
807 NO MINVALUE
808 NO MAXVALUE
809 CACHE 1;
810
811
812ALTER TABLE public.schedule_calendarrelation_id_seq OWNER TO postgres;
813
814--
815-- TOC entry 3192 (class 0 OID 0)
816-- Dependencies: 222
817-- Name: schedule_calendarrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
818--
819
820ALTER SEQUENCE public.schedule_calendarrelation_id_seq OWNED BY public.schedule_calendarrelation.id;
821
822
823--
824-- TOC entry 225 (class 1259 OID 16646)
825-- Name: schedule_event; Type: TABLE; Schema: public; Owner: postgres
826--
827
828CREATE TABLE public.schedule_event (
829 id integer NOT NULL,
830 start timestamp with time zone NOT NULL,
831 "end" timestamp with time zone NOT NULL,
832 title character varying(255) NOT NULL,
833 description text NOT NULL,
834 created_on timestamp with time zone NOT NULL,
835 updated_on timestamp with time zone NOT NULL,
836 end_recurring_period timestamp with time zone,
837 calendar_id integer NOT NULL,
838 creator_id integer,
839 rule_id integer,
840 color_event character varying(10) NOT NULL
841);
842
843
844ALTER TABLE public.schedule_event OWNER TO postgres;
845
846--
847-- TOC entry 224 (class 1259 OID 16644)
848-- Name: schedule_event_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
849--
850
851CREATE SEQUENCE public.schedule_event_id_seq
852 AS integer
853 START WITH 1
854 INCREMENT BY 1
855 NO MINVALUE
856 NO MAXVALUE
857 CACHE 1;
858
859
860ALTER TABLE public.schedule_event_id_seq OWNER TO postgres;
861
862--
863-- TOC entry 3193 (class 0 OID 0)
864-- Dependencies: 224
865-- Name: schedule_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
866--
867
868ALTER SEQUENCE public.schedule_event_id_seq OWNED BY public.schedule_event.id;
869
870
871--
872-- TOC entry 227 (class 1259 OID 16657)
873-- Name: schedule_eventrelation; Type: TABLE; Schema: public; Owner: postgres
874--
875
876CREATE TABLE public.schedule_eventrelation (
877 id integer NOT NULL,
878 object_id integer NOT NULL,
879 distinction character varying(20) NOT NULL,
880 content_type_id integer NOT NULL,
881 event_id integer NOT NULL
882);
883
884
885ALTER TABLE public.schedule_eventrelation OWNER TO postgres;
886
887--
888-- TOC entry 226 (class 1259 OID 16655)
889-- Name: schedule_eventrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
890--
891
892CREATE SEQUENCE public.schedule_eventrelation_id_seq
893 AS integer
894 START WITH 1
895 INCREMENT BY 1
896 NO MINVALUE
897 NO MAXVALUE
898 CACHE 1;
899
900
901ALTER TABLE public.schedule_eventrelation_id_seq OWNER TO postgres;
902
903--
904-- TOC entry 3194 (class 0 OID 0)
905-- Dependencies: 226
906-- Name: schedule_eventrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
907--
908
909ALTER SEQUENCE public.schedule_eventrelation_id_seq OWNED BY public.schedule_eventrelation.id;
910
911
912--
913-- TOC entry 229 (class 1259 OID 16665)
914-- Name: schedule_occurrence; Type: TABLE; Schema: public; Owner: postgres
915--
916
917CREATE TABLE public.schedule_occurrence (
918 id integer NOT NULL,
919 title character varying(255) NOT NULL,
920 description text NOT NULL,
921 start timestamp with time zone NOT NULL,
922 "end" timestamp with time zone NOT NULL,
923 cancelled boolean NOT NULL,
924 original_start timestamp with time zone NOT NULL,
925 original_end timestamp with time zone NOT NULL,
926 created_on timestamp with time zone NOT NULL,
927 updated_on timestamp with time zone NOT NULL,
928 event_id integer NOT NULL
929);
930
931
932ALTER TABLE public.schedule_occurrence OWNER TO postgres;
933
934--
935-- TOC entry 228 (class 1259 OID 16663)
936-- Name: schedule_occurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
937--
938
939CREATE SEQUENCE public.schedule_occurrence_id_seq
940 AS integer
941 START WITH 1
942 INCREMENT BY 1
943 NO MINVALUE
944 NO MAXVALUE
945 CACHE 1;
946
947
948ALTER TABLE public.schedule_occurrence_id_seq OWNER TO postgres;
949
950--
951-- TOC entry 3195 (class 0 OID 0)
952-- Dependencies: 228
953-- Name: schedule_occurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
954--
955
956ALTER SEQUENCE public.schedule_occurrence_id_seq OWNED BY public.schedule_occurrence.id;
957
958
959--
960-- TOC entry 231 (class 1259 OID 16676)
961-- Name: schedule_rule; Type: TABLE; Schema: public; Owner: postgres
962--
963
964CREATE TABLE public.schedule_rule (
965 id integer NOT NULL,
966 name character varying(32) NOT NULL,
967 description text NOT NULL,
968 frequency character varying(10) NOT NULL,
969 params text NOT NULL
970);
971
972
973ALTER TABLE public.schedule_rule OWNER TO postgres;
974
975--
976-- TOC entry 230 (class 1259 OID 16674)
977-- Name: schedule_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
978--
979
980CREATE SEQUENCE public.schedule_rule_id_seq
981 AS integer
982 START WITH 1
983 INCREMENT BY 1
984 NO MINVALUE
985 NO MAXVALUE
986 CACHE 1;
987
988
989ALTER TABLE public.schedule_rule_id_seq OWNER TO postgres;
990
991--
992-- TOC entry 3196 (class 0 OID 0)
993-- Dependencies: 230
994-- Name: schedule_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
995--
996
997ALTER SEQUENCE public.schedule_rule_id_seq OWNED BY public.schedule_rule.id;
998
999
1000--
1001-- TOC entry 2832 (class 2604 OID 16471)
1002-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: postgres
1003--
1004
1005ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass);
1006
1007
1008--
1009-- TOC entry 2833 (class 2604 OID 16481)
1010-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: postgres
1011--
1012
1013ALTER TABLE ONLY public.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_group_permissions_id_seq'::regclass);
1014
1015
1016--
1017-- TOC entry 2831 (class 2604 OID 16463)
1018-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: postgres
1019--
1020
1021ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass);
1022
1023
1024--
1025-- TOC entry 2834 (class 2604 OID 16489)
1026-- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: postgres
1027--
1028
1029ALTER TABLE ONLY public.auth_user ALTER COLUMN id SET DEFAULT nextval('public.auth_user_id_seq'::regclass);
1030
1031
1032--
1033-- TOC entry 2835 (class 2604 OID 16499)
1034-- Name: auth_user_groups id; Type: DEFAULT; Schema: public; Owner: postgres
1035--
1036
1037ALTER TABLE ONLY public.auth_user_groups ALTER COLUMN id SET DEFAULT nextval('public.auth_user_groups_id_seq'::regclass);
1038
1039
1040--
1041-- TOC entry 2836 (class 2604 OID 16507)
1042-- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: postgres
1043--
1044
1045ALTER TABLE ONLY public.auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_user_user_permissions_id_seq'::regclass);
1046
1047
1048--
1049-- TOC entry 2837 (class 2604 OID 16567)
1050-- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: postgres
1051--
1052
1053ALTER TABLE ONLY public.django_admin_log ALTER COLUMN id SET DEFAULT nextval('public.django_admin_log_id_seq'::regclass);
1054
1055
1056--
1057-- TOC entry 2830 (class 2604 OID 16453)
1058-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: postgres
1059--
1060
1061ALTER TABLE ONLY public.django_content_type ALTER COLUMN id SET DEFAULT nextval('public.django_content_type_id_seq'::regclass);
1062
1063
1064--
1065-- TOC entry 2829 (class 2604 OID 16442)
1066-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: postgres
1067--
1068
1069ALTER TABLE ONLY public.django_migrations ALTER COLUMN id SET DEFAULT nextval('public.django_migrations_id_seq'::regclass);
1070
1071
1072--
1073-- TOC entry 2848 (class 2604 OID 16810)
1074-- Name: lekarze_city id; Type: DEFAULT; Schema: public; Owner: postgres
1075--
1076
1077ALTER TABLE ONLY public.lekarze_city ALTER COLUMN id SET DEFAULT nextval('public.lekarze_city_id_seq'::regclass);
1078
1079
1080--
1081-- TOC entry 2847 (class 2604 OID 16800)
1082-- Name: lekarze_country id; Type: DEFAULT; Schema: public; Owner: postgres
1083--
1084
1085ALTER TABLE ONLY public.lekarze_country ALTER COLUMN id SET DEFAULT nextval('public.lekarze_country_id_seq'::regclass);
1086
1087
1088--
1089-- TOC entry 2840 (class 2604 OID 16618)
1090-- Name: lekarze_department id; Type: DEFAULT; Schema: public; Owner: postgres
1091--
1092
1093ALTER TABLE ONLY public.lekarze_department ALTER COLUMN id SET DEFAULT nextval('public.lekarze_department_id_seq'::regclass);
1094
1095
1096--
1097-- TOC entry 2852 (class 2604 OID 16989)
1098-- Name: lekarze_exchange id; Type: DEFAULT; Schema: public; Owner: postgres
1099--
1100
1101ALTER TABLE ONLY public.lekarze_exchange ALTER COLUMN id SET DEFAULT nextval('public.lekarze_exchange_id_seq'::regclass);
1102
1103
1104--
1105-- TOC entry 2839 (class 2604 OID 16610)
1106-- Name: lekarze_hospital id; Type: DEFAULT; Schema: public; Owner: postgres
1107--
1108
1109ALTER TABLE ONLY public.lekarze_hospital ALTER COLUMN id SET DEFAULT nextval('public.lekarze_hospital_id_seq'::regclass);
1110
1111
1112--
1113-- TOC entry 2849 (class 2604 OID 16839)
1114-- Name: lekarze_shift shift_id; Type: DEFAULT; Schema: public; Owner: postgres
1115--
1116
1117ALTER TABLE ONLY public.lekarze_shift ALTER COLUMN shift_id SET DEFAULT nextval('public.lekarze_shift_shift_id_seq'::regclass);
1118
1119
1120--
1121-- TOC entry 2851 (class 2604 OID 16896)
1122-- Name: lekarze_shiftcounter id; Type: DEFAULT; Schema: public; Owner: postgres
1123--
1124
1125ALTER TABLE ONLY public.lekarze_shiftcounter ALTER COLUMN id SET DEFAULT nextval('public.lekarze_shiftcounter_id_seq'::regclass);
1126
1127
1128--
1129-- TOC entry 2850 (class 2604 OID 16859)
1130-- Name: lekarze_shifttype id; Type: DEFAULT; Schema: public; Owner: postgres
1131--
1132
1133ALTER TABLE ONLY public.lekarze_shifttype ALTER COLUMN id SET DEFAULT nextval('public.lekarze_shifttype_id_seq'::regclass);
1134
1135
1136--
1137-- TOC entry 2841 (class 2604 OID 16633)
1138-- Name: schedule_calendar id; Type: DEFAULT; Schema: public; Owner: postgres
1139--
1140
1141ALTER TABLE ONLY public.schedule_calendar ALTER COLUMN id SET DEFAULT nextval('public.schedule_calendar_id_seq'::regclass);
1142
1143
1144--
1145-- TOC entry 2842 (class 2604 OID 16641)
1146-- Name: schedule_calendarrelation id; Type: DEFAULT; Schema: public; Owner: postgres
1147--
1148
1149ALTER TABLE ONLY public.schedule_calendarrelation ALTER COLUMN id SET DEFAULT nextval('public.schedule_calendarrelation_id_seq'::regclass);
1150
1151
1152--
1153-- TOC entry 2843 (class 2604 OID 16649)
1154-- Name: schedule_event id; Type: DEFAULT; Schema: public; Owner: postgres
1155--
1156
1157ALTER TABLE ONLY public.schedule_event ALTER COLUMN id SET DEFAULT nextval('public.schedule_event_id_seq'::regclass);
1158
1159
1160--
1161-- TOC entry 2844 (class 2604 OID 16660)
1162-- Name: schedule_eventrelation id; Type: DEFAULT; Schema: public; Owner: postgres
1163--
1164
1165ALTER TABLE ONLY public.schedule_eventrelation ALTER COLUMN id SET DEFAULT nextval('public.schedule_eventrelation_id_seq'::regclass);
1166
1167
1168--
1169-- TOC entry 2845 (class 2604 OID 16668)
1170-- Name: schedule_occurrence id; Type: DEFAULT; Schema: public; Owner: postgres
1171--
1172
1173ALTER TABLE ONLY public.schedule_occurrence ALTER COLUMN id SET DEFAULT nextval('public.schedule_occurrence_id_seq'::regclass);
1174
1175
1176--
1177-- TOC entry 2846 (class 2604 OID 16679)
1178-- Name: schedule_rule id; Type: DEFAULT; Schema: public; Owner: postgres
1179--
1180
1181ALTER TABLE ONLY public.schedule_rule ALTER COLUMN id SET DEFAULT nextval('public.schedule_rule_id_seq'::regclass);
1182
1183
1184--
1185-- TOC entry 3128 (class 0 OID 16468)
1186-- Dependencies: 204
1187-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: postgres
1188--
1189
1190COPY public.auth_group (id, name) FROM stdin;
1191\.
1192
1193
1194--
1195-- TOC entry 3130 (class 0 OID 16478)
1196-- Dependencies: 206
1197-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
1198--
1199
1200COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
1201\.
1202
1203
1204--
1205-- TOC entry 3126 (class 0 OID 16460)
1206-- Dependencies: 202
1207-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: postgres
1208--
1209
1210COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
12111 Can add log entry 1 add_logentry
12122 Can change log entry 1 change_logentry
12133 Can delete log entry 1 delete_logentry
12144 Can view log entry 1 view_logentry
12155 Can add permission 2 add_permission
12166 Can change permission 2 change_permission
12177 Can delete permission 2 delete_permission
12188 Can view permission 2 view_permission
12199 Can add group 3 add_group
122010 Can change group 3 change_group
122111 Can delete group 3 delete_group
122212 Can view group 3 view_group
122313 Can add user 4 add_user
122414 Can change user 4 change_user
122515 Can delete user 4 delete_user
122616 Can view user 4 view_user
122717 Can add content type 5 add_contenttype
122818 Can change content type 5 change_contenttype
122919 Can delete content type 5 delete_contenttype
123020 Can view content type 5 view_contenttype
123121 Can add session 6 add_session
123222 Can change session 6 change_session
123323 Can delete session 6 delete_session
123424 Can view session 6 view_session
123525 Can add hospital 7 add_hospital
123626 Can change hospital 7 change_hospital
123727 Can delete hospital 7 delete_hospital
123828 Can view hospital 7 view_hospital
123929 Can add department 8 add_department
124030 Can change department 8 change_department
124131 Can delete department 8 delete_department
124232 Can view department 8 view_department
124333 Can add calendar 9 add_calendar
124434 Can change calendar 9 change_calendar
124535 Can delete calendar 9 delete_calendar
124636 Can view calendar 9 view_calendar
124737 Can add calendar relation 10 add_calendarrelation
124838 Can change calendar relation 10 change_calendarrelation
124939 Can delete calendar relation 10 delete_calendarrelation
125040 Can view calendar relation 10 view_calendarrelation
125141 Can add event 11 add_event
125242 Can change event 11 change_event
125343 Can delete event 11 delete_event
125444 Can view event 11 view_event
125545 Can add event relation 12 add_eventrelation
125646 Can change event relation 12 change_eventrelation
125747 Can delete event relation 12 delete_eventrelation
125848 Can view event relation 12 view_eventrelation
125949 Can add occurrence 13 add_occurrence
126050 Can change occurrence 13 change_occurrence
126151 Can delete occurrence 13 delete_occurrence
126252 Can view occurrence 13 view_occurrence
126353 Can add rule 14 add_rule
126454 Can change rule 14 change_rule
126555 Can delete rule 14 delete_rule
126656 Can view rule 14 view_rule
126757 Can add country 15 add_country
126858 Can change country 15 change_country
126959 Can delete country 15 delete_country
127060 Can view country 15 view_country
127161 Can add city 16 add_city
127262 Can change city 16 change_city
127363 Can delete city 16 delete_city
127464 Can view city 16 view_city
127565 Can add shift 17 add_shift
127666 Can change shift 17 change_shift
127767 Can delete shift 17 delete_shift
127868 Can view shift 17 view_shift
127969 Can add shift type 18 add_shifttype
128070 Can change shift type 18 change_shifttype
128171 Can delete shift type 18 delete_shifttype
128272 Can view shift type 18 view_shifttype
128373 Can add shift counter 19 add_shiftcounter
128474 Can change shift counter 19 change_shiftcounter
128575 Can delete shift counter 19 delete_shiftcounter
128676 Can view shift counter 19 view_shiftcounter
128777 Can add exchange 20 add_exchange
128878 Can change exchange 20 change_exchange
128979 Can delete exchange 20 delete_exchange
129080 Can view exchange 20 view_exchange
1291\.
1292
1293
1294--
1295-- TOC entry 3132 (class 0 OID 16486)
1296-- Dependencies: 208
1297-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: postgres
1298--
1299
1300COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
13018 pbkdf2_sha256$180000$QSFF0ua9v9tI$TPVUiML7uRw023vrZaxnwIhM4TOecHpq+1cA7Ipw52M= \N f matsta Mateusz Starzyk nieistotny@mail.com f t 2020-01-26 16:27:59.68353+01
13026 pbkdf2_sha256$180000$g4f1k48BbizB$GS3VfcB8L//SLfZzT6oqfCt7V97KAezRWbJfkTndLdU= 2020-01-26 16:29:01.827084+01 f matbes Mateusz Bess nieistotny@mail.com f t 2020-01-26 16:27:16.096037+01
130310 pbkdf2_sha256$180000$ynBI2IquCgZv$PGtDA7xni7vLXfAEaU6pnW5qGI3hk/bvtqo6bRyTyd0= 2020-01-26 16:29:29.252653+01 f hubryc Hubert Rychlicki nieistotny@mail.com f t 2020-01-26 16:28:45.991179+01
13047 pbkdf2_sha256$180000$WNlmA0QGAhIA$FMLAN946b1nVHMGxIS1OW5yjQZ8sqPxRVlWGcvNiv4k= 2020-01-26 16:29:53.434036+01 f jakgie Jakub Gierszewski nieistotny@mail.com f t 2020-01-26 16:27:38.046292+01
13059 pbkdf2_sha256$180000$4iv1XVGhNtrV$fZlw5RBWwvCrg9gSdZpgEsAGw/31FKldxIzxIWWzZi4= 2020-01-26 16:30:17.325403+01 f sambyt Samuel Bytner nieistotny@mail.com f t 2020-01-26 16:28:17.808567+01
13061 pbkdf2_sha256$180000$3jcbfVEXcXBV$6E3N20MtVQEoKzt4vRUjmsMX3/DPgOq3p8602utUd0g= 2020-01-26 19:33:40.639756+01 t admin admin admin t t 2020-01-22 16:13:16+01
13075 pbkdf2_sha256$180000$dPUYVngPHGoL$n8ojCh3N2vJlfhGgwkljpDWYNHxYrcbhfZbTMJugUrw= 2020-01-26 19:36:31.779545+01 f mickac Michał Kaczyński kaczynski.mp@gmail.com f t 2020-01-26 16:24:47.586543+01
1308\.
1309
1310
1311--
1312-- TOC entry 3134 (class 0 OID 16496)
1313-- Dependencies: 210
1314-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: postgres
1315--
1316
1317COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
1318\.
1319
1320
1321--
1322-- TOC entry 3136 (class 0 OID 16504)
1323-- Dependencies: 212
1324-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
1325--
1326
1327COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
1328\.
1329
1330
1331--
1332-- TOC entry 3138 (class 0 OID 16564)
1333-- Dependencies: 214
1334-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: postgres
1335--
1336
1337COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
13381 2020-01-23 13:14:35.759656+01 30 Michał Kaczyński 3 7 1
13392 2020-01-23 13:14:35.767656+01 29 Michał Kaczyński 3 7 1
13403 2020-01-23 13:14:35.769656+01 28 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13414 2020-01-23 13:14:35.771656+01 27 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13425 2020-01-23 13:14:35.774656+01 26 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13436 2020-01-23 13:14:35.776657+01 25 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13447 2020-01-23 13:14:35.778657+01 24 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13458 2020-01-23 13:14:35.780657+01 23 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
13469 2020-01-23 13:14:35.782657+01 22 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
134710 2020-01-23 13:14:35.783657+01 21 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
134811 2020-01-23 13:14:35.785657+01 20 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
134912 2020-01-23 13:14:35.787657+01 19 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135013 2020-01-23 13:14:35.788657+01 18 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135114 2020-01-23 13:14:35.790657+01 17 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135215 2020-01-23 13:14:35.792658+01 16 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135316 2020-01-23 13:14:35.794658+01 15 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135417 2020-01-23 13:14:35.796658+01 14 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135518 2020-01-23 13:14:35.797658+01 13 Szpital Uniwersytecki im. dr Antoniego Jurasza 3 7 1
135619 2020-01-24 01:04:25.078625+01 1 Onkologia 3 8 1
135720 2020-01-25 14:10:04.496123+01 1 Test 1 [{"added": {}}] 17 1
135821 2020-01-25 16:18:04.844414+01 1 7:00am - 7:00pm 1 [{"added": {}}] 18 1
135922 2020-01-25 16:18:32.91602+01 2 7:00pm - 7:00am 1 [{"added": {}}] 18 1
136023 2020-01-25 16:18:55.47931+01 3 7:00am - 7:00am 1 [{"added": {}}] 18 1
136124 2020-01-25 18:04:19.60903+01 3 7:00am - 7:00am (24h) 2 [{"changed": {"fields": ["Name"]}}] 18 1
136225 2020-01-25 18:04:25.846387+01 2 7:00pm - 7:00am (12h) 2 [{"changed": {"fields": ["Name"]}}] 18 1
136326 2020-01-25 18:04:31.126689+01 1 7:00am - 7:00pm (12h) 2 [{"changed": {"fields": ["Name"]}}] 18 1
136427 2020-01-25 19:34:45.051347+01 1 admin 2 [{"changed": {"fields": ["First name", "Last name"]}}] 4 1
136528 2020-01-25 20:13:05.194908+01 19 Test 3 17 1
136629 2020-01-25 20:13:05.199908+01 18 test3 3 17 1
136730 2020-01-25 20:13:05.201909+01 17 Test 3 17 1
136831 2020-01-25 20:13:05.204909+01 16 Test2 3 17 1
136932 2020-01-25 20:13:05.207909+01 15 Test 3 17 1
137033 2020-01-25 20:35:04.999397+01 25 Test2 3 17 1
137134 2020-01-25 20:35:05.008397+01 24 Test 3 17 1
137235 2020-01-25 20:35:05.017398+01 23 Test 3 17 1
137336 2020-01-25 20:35:05.030398+01 22 Test 3 17 1
137437 2020-01-25 20:35:05.045399+01 21 Test 3 17 1
137538 2020-01-25 20:35:05.0564+01 20 Test 3 17 1
137639 2020-01-25 20:35:33.862047+01 4 2020-01-25 18:00:00+00:00 3 19 1
137740 2020-01-25 20:35:33.867048+01 3 2020-01-25 18:00:00+00:00 3 19 1
137841 2020-01-25 20:35:33.870048+01 2 2020-01-25 06:00:00+00:00 3 19 1
137942 2020-01-25 20:37:38.39617+01 26 Test 3 17 1
138043 2020-01-25 20:42:11.784807+01 27 Test 3 17 1
138144 2020-01-25 20:42:27.546709+01 5 2020-01-25 06:00:00+00:00 3 19 1
138245 2020-01-26 15:41:34.327217+01 9 2020-01-26 06:00:00+00:00 3 19 1
138346 2020-01-26 15:41:34.334217+01 8 2020-01-26 06:00:00+00:00 3 19 1
138447 2020-01-26 15:41:34.337217+01 7 2020-01-25 06:00:00+00:00 3 19 1
138548 2020-01-26 15:41:34.340217+01 6 2020-01-25 06:00:00+00:00 3 19 1
138649 2020-01-26 15:41:44.111776+01 31 Test 3 17 1
138750 2020-01-26 15:41:44.117777+01 30 Test 3 17 1
138851 2020-01-26 15:41:44.120777+01 29 Test 3 17 1
138952 2020-01-26 15:41:44.123777+01 28 My Shift 3 17 1
139053 2020-01-26 16:01:00.436914+01 1 chuj 3 8 1
139154 2020-01-26 16:05:58.239948+01 33 Test 3 17 1
139255 2020-01-26 16:05:58.246948+01 32 Test 3 17 1
139356 2020-01-26 16:06:07.619484+01 11 2020-01-26 18:00:00+00:00 3 19 1
139457 2020-01-26 16:06:07.623484+01 10 2020-01-26 06:00:00+00:00 3 19 1
139558 2020-01-26 16:24:37.727979+01 3 matbes 3 4 1
139659 2020-01-26 16:24:37.733979+01 2 mickac 3 4 1
1397\.
1398
1399
1400--
1401-- TOC entry 3124 (class 0 OID 16450)
1402-- Dependencies: 200
1403-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: postgres
1404--
1405
1406COPY public.django_content_type (id, app_label, model) FROM stdin;
14071 admin logentry
14082 auth permission
14093 auth group
14104 auth user
14115 contenttypes contenttype
14126 sessions session
14137 lekarze hospital
14148 lekarze department
14159 schedule calendar
141610 schedule calendarrelation
141711 schedule event
141812 schedule eventrelation
141913 schedule occurrence
142014 schedule rule
142115 lekarze country
142216 lekarze city
142317 lekarze shift
142418 lekarze shifttype
142519 lekarze shiftcounter
142620 lekarze exchange
1427\.
1428
1429
1430--
1431-- TOC entry 3122 (class 0 OID 16439)
1432-- Dependencies: 198
1433-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: postgres
1434--
1435
1436COPY public.django_migrations (id, app, name, applied) FROM stdin;
14371 contenttypes 0001_initial 2020-01-22 16:11:21.255703+01
14382 auth 0001_initial 2020-01-22 16:11:21.406712+01
14393 admin 0001_initial 2020-01-22 16:11:21.657726+01
14404 admin 0002_logentry_remove_auto_add 2020-01-22 16:11:21.704729+01
14415 admin 0003_logentry_add_action_flag_choices 2020-01-22 16:11:21.72173+01
14426 contenttypes 0002_remove_content_type_name 2020-01-22 16:11:21.758732+01
14437 auth 0002_alter_permission_name_max_length 2020-01-22 16:11:21.768733+01
14448 auth 0003_alter_user_email_max_length 2020-01-22 16:11:21.784734+01
14459 auth 0004_alter_user_username_opts 2020-01-22 16:11:21.802735+01
144610 auth 0005_alter_user_last_login_null 2020-01-22 16:11:21.819736+01
144711 auth 0006_require_contenttypes_0002 2020-01-22 16:11:21.822736+01
144812 auth 0007_alter_validators_add_error_messages 2020-01-22 16:11:21.839737+01
144913 auth 0008_alter_user_username_max_length 2020-01-22 16:11:21.877739+01
145014 auth 0009_alter_user_last_name_max_length 2020-01-22 16:11:21.89574+01
145115 auth 0010_alter_group_name_max_length 2020-01-22 16:11:21.909741+01
145216 auth 0011_update_proxy_permissions 2020-01-22 16:11:21.921742+01
145317 sessions 0001_initial 2020-01-22 16:11:21.952743+01
145418 lekarze 0001_initial 2020-01-23 12:52:55.778301+01
145519 schedule 0001_initial 2020-01-23 14:22:19.203071+01
145620 schedule 0002_event_color_event 2020-01-23 14:22:19.36108+01
145721 schedule 0003_auto_20160715_0028 2020-01-23 14:22:19.562092+01
145822 schedule 0006_update_text_fields_empty_string 2020-01-23 14:22:19.598094+01
145923 schedule 0004_text_fields_not_null 2020-01-23 14:22:19.719101+01
146024 schedule 0005_verbose_name_plural_for_calendar 2020-01-23 14:22:19.731102+01
146125 schedule 0007_merge_text_fields 2020-01-23 14:22:19.735102+01
146226 schedule 0008_gfk_index 2020-01-23 14:22:19.889111+01
146327 schedule 0009_merge_20180108_2303 2020-01-23 14:22:19.897111+01
146428 schedule 0010_events_set_missing_calendar 2020-01-23 14:22:19.923112+01
146529 schedule 0011_event_calendar_not_null 2020-01-23 14:22:19.965115+01
146630 schedule 0012_auto_20191025_1852 2020-01-23 14:22:20.028118+01
146731 lekarze 0002_auto_20200124_0103 2020-01-24 01:11:45.898839+01
146832 lekarze 0003_shift 2020-01-25 14:09:08.48392+01
146933 lekarze 0004_shifttype 2020-01-25 16:11:27.205671+01
147034 lekarze 0005_shift_shift_type 2020-01-25 16:16:01.831378+01
147135 lekarze 0006_auto_20200125_1615 2020-01-25 16:16:01.931384+01
147236 lekarze 0007_shiftcounter 2020-01-25 20:04:31.159507+01
147337 lekarze 0008_shiftcounter_shift_type 2020-01-25 20:07:27.226577+01
147438 lekarze 0009_auto_20200125_2020 2020-01-25 20:25:37.624945+01
147539 lekarze 0010_shifttype_department 2020-01-26 16:00:36.951571+01
147640 lekarze 0011_auto_20200126_1544 2020-01-26 16:00:37.042576+01
147741 lekarze 0012_auto_20200126_1554 2020-01-26 16:00:37.090579+01
147842 lekarze 0013_remove_shiftcounter_department 2020-01-26 16:00:37.126581+01
147943 lekarze 0014_shiftcounter_department 2020-01-26 16:00:37.154583+01
148044 lekarze 0015_exchange 2020-01-26 17:07:28.171+01
148145 lekarze 0016_auto_20200126_1849 2020-01-26 18:49:13.24619+01
1482\.
1483
1484
1485--
1486-- TOC entry 3139 (class 0 OID 16595)
1487-- Dependencies: 215
1488-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: postgres
1489--
1490
1491COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
1492c5s7bcbvxo1h9dojhxpsou45ru7n3ikn Zjk1MTMwODRhOTdjNDA1MjQ2NmQ0YmM4NmFkOWM1MDA1NjMwNGNiMzp7Il9hdXRoX3VzZXJfaWQiOiI1IiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiI1Njk3ZDgwYWI3MDEyYmQwZjc3YjRkOTkxN2ViNjhkNjBlMzYzZTBmIn0= 2020-02-09 19:36:31.783545+01
1493\.
1494
1495
1496--
1497-- TOC entry 3159 (class 0 OID 16807)
1498-- Dependencies: 235
1499-- Data for Name: lekarze_city; Type: TABLE DATA; Schema: public; Owner: postgres
1500--
1501
1502COPY public.lekarze_city (id, name, country_id) FROM stdin;
15031 Bydgoszcz 1
15042 Toruń 1
15053 Gdańsk 1
1506\.
1507
1508
1509--
1510-- TOC entry 3157 (class 0 OID 16797)
1511-- Dependencies: 233
1512-- Data for Name: lekarze_country; Type: TABLE DATA; Schema: public; Owner: postgres
1513--
1514
1515COPY public.lekarze_country (id, name) FROM stdin;
15161 Poland
1517\.
1518
1519
1520--
1521-- TOC entry 3143 (class 0 OID 16615)
1522-- Dependencies: 219
1523-- Data for Name: lekarze_department; Type: TABLE DATA; Schema: public; Owner: postgres
1524--
1525
1526COPY public.lekarze_department (id, name, hospital_id) FROM stdin;
15273 Onkologia 32
15284 Onkologia 33
1529\.
1530
1531
1532--
1533-- TOC entry 3167 (class 0 OID 16986)
1534-- Dependencies: 243
1535-- Data for Name: lekarze_exchange; Type: TABLE DATA; Schema: public; Owner: postgres
1536--
1537
1538COPY public.lekarze_exchange (id, status, who_id, whom_id, myshift_id, yourshift_id) FROM stdin;
15391 0 1 5 34 35
15402 0 5 10 40 37
1541\.
1542
1543
1544--
1545-- TOC entry 3141 (class 0 OID 16607)
1546-- Dependencies: 217
1547-- Data for Name: lekarze_hospital; Type: TABLE DATA; Schema: public; Owner: postgres
1548--
1549
1550COPY public.lekarze_hospital (id, name, address, city_id) FROM stdin;
155132 Jurasz Marii Curie-Skłodowskiej 9 1
155233 Szpital adres 2
1553\.
1554
1555
1556--
1557-- TOC entry 3161 (class 0 OID 16836)
1558-- Dependencies: 237
1559-- Data for Name: lekarze_shift; Type: TABLE DATA; Schema: public; Owner: postgres
1560--
1561
1562COPY public.lekarze_shift (shift_id, shift_name, start_date, end_date, department_id, staff_name_id, shift_type_id) FROM stdin;
156334 Test 2020-01-26 07:00:00+01 2020-01-27 07:00:00+01 3 1 3
156435 Test 2020-01-26 07:00:00+01 2020-01-27 07:00:00+01 3 5 3
156536 Test 2020-01-26 07:00:00+01 2020-01-27 07:00:00+01 3 6 3
156637 Test 2020-01-26 07:00:00+01 2020-01-27 07:00:00+01 3 10 3
156738 Test 2020-01-26 07:00:00+01 2020-01-27 07:00:00+01 3 7 3
156839 Test 2020-01-26 19:00:00+01 2020-01-27 07:00:00+01 3 9 2
156940 My Shift 2020-01-28 19:00:00+01 2020-01-29 07:00:00+01 3 5 2
1570\.
1571
1572
1573--
1574-- TOC entry 3165 (class 0 OID 16893)
1575-- Dependencies: 241
1576-- Data for Name: lekarze_shiftcounter; Type: TABLE DATA; Schema: public; Owner: postgres
1577--
1578
1579COPY public.lekarze_shiftcounter (id, date, counter, shift_type_id, department_id) FROM stdin;
158012 2020-01-26 07:00:00+01 5 3 3
158113 2020-01-26 19:00:00+01 1 2 3
158214 2020-01-28 19:00:00+01 1 2 3
1583\.
1584
1585
1586--
1587-- TOC entry 3163 (class 0 OID 16856)
1588-- Dependencies: 239
1589-- Data for Name: lekarze_shifttype; Type: TABLE DATA; Schema: public; Owner: postgres
1590--
1591
1592COPY public.lekarze_shifttype (id, name, start_date, end_date) FROM stdin;
15933 7:00am - 7:00am (24h) 07:00:00 07:00:00
15942 7:00pm - 7:00am (12h) 19:00:00 07:00:00
15951 7:00am - 7:00pm (12h) 07:00:00 19:00:00
1596\.
1597
1598
1599--
1600-- TOC entry 3145 (class 0 OID 16630)
1601-- Dependencies: 221
1602-- Data for Name: schedule_calendar; Type: TABLE DATA; Schema: public; Owner: postgres
1603--
1604
1605COPY public.schedule_calendar (id, name, slug) FROM stdin;
1606\.
1607
1608
1609--
1610-- TOC entry 3147 (class 0 OID 16638)
1611-- Dependencies: 223
1612-- Data for Name: schedule_calendarrelation; Type: TABLE DATA; Schema: public; Owner: postgres
1613--
1614
1615COPY public.schedule_calendarrelation (id, object_id, distinction, inheritable, calendar_id, content_type_id) FROM stdin;
1616\.
1617
1618
1619--
1620-- TOC entry 3149 (class 0 OID 16646)
1621-- Dependencies: 225
1622-- Data for Name: schedule_event; Type: TABLE DATA; Schema: public; Owner: postgres
1623--
1624
1625COPY public.schedule_event (id, start, "end", title, description, created_on, updated_on, end_recurring_period, calendar_id, creator_id, rule_id, color_event) FROM stdin;
1626\.
1627
1628
1629--
1630-- TOC entry 3151 (class 0 OID 16657)
1631-- Dependencies: 227
1632-- Data for Name: schedule_eventrelation; Type: TABLE DATA; Schema: public; Owner: postgres
1633--
1634
1635COPY public.schedule_eventrelation (id, object_id, distinction, content_type_id, event_id) FROM stdin;
1636\.
1637
1638
1639--
1640-- TOC entry 3153 (class 0 OID 16665)
1641-- Dependencies: 229
1642-- Data for Name: schedule_occurrence; Type: TABLE DATA; Schema: public; Owner: postgres
1643--
1644
1645COPY public.schedule_occurrence (id, title, description, start, "end", cancelled, original_start, original_end, created_on, updated_on, event_id) FROM stdin;
1646\.
1647
1648
1649--
1650-- TOC entry 3155 (class 0 OID 16676)
1651-- Dependencies: 231
1652-- Data for Name: schedule_rule; Type: TABLE DATA; Schema: public; Owner: postgres
1653--
1654
1655COPY public.schedule_rule (id, name, description, frequency, params) FROM stdin;
1656\.
1657
1658
1659--
1660-- TOC entry 3197 (class 0 OID 0)
1661-- Dependencies: 203
1662-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1663--
1664
1665SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);
1666
1667
1668--
1669-- TOC entry 3198 (class 0 OID 0)
1670-- Dependencies: 205
1671-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1672--
1673
1674SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);
1675
1676
1677--
1678-- TOC entry 3199 (class 0 OID 0)
1679-- Dependencies: 201
1680-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1681--
1682
1683SELECT pg_catalog.setval('public.auth_permission_id_seq', 80, true);
1684
1685
1686--
1687-- TOC entry 3200 (class 0 OID 0)
1688-- Dependencies: 209
1689-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1690--
1691
1692SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);
1693
1694
1695--
1696-- TOC entry 3201 (class 0 OID 0)
1697-- Dependencies: 207
1698-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1699--
1700
1701SELECT pg_catalog.setval('public.auth_user_id_seq', 10, true);
1702
1703
1704--
1705-- TOC entry 3202 (class 0 OID 0)
1706-- Dependencies: 211
1707-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1708--
1709
1710SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false);
1711
1712
1713--
1714-- TOC entry 3203 (class 0 OID 0)
1715-- Dependencies: 213
1716-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1717--
1718
1719SELECT pg_catalog.setval('public.django_admin_log_id_seq', 59, true);
1720
1721
1722--
1723-- TOC entry 3204 (class 0 OID 0)
1724-- Dependencies: 199
1725-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1726--
1727
1728SELECT pg_catalog.setval('public.django_content_type_id_seq', 20, true);
1729
1730
1731--
1732-- TOC entry 3205 (class 0 OID 0)
1733-- Dependencies: 197
1734-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1735--
1736
1737SELECT pg_catalog.setval('public.django_migrations_id_seq', 45, true);
1738
1739
1740--
1741-- TOC entry 3206 (class 0 OID 0)
1742-- Dependencies: 234
1743-- Name: lekarze_city_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1744--
1745
1746SELECT pg_catalog.setval('public.lekarze_city_id_seq', 3, true);
1747
1748
1749--
1750-- TOC entry 3207 (class 0 OID 0)
1751-- Dependencies: 232
1752-- Name: lekarze_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1753--
1754
1755SELECT pg_catalog.setval('public.lekarze_country_id_seq', 1, true);
1756
1757
1758--
1759-- TOC entry 3208 (class 0 OID 0)
1760-- Dependencies: 218
1761-- Name: lekarze_department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1762--
1763
1764SELECT pg_catalog.setval('public.lekarze_department_id_seq', 4, true);
1765
1766
1767--
1768-- TOC entry 3209 (class 0 OID 0)
1769-- Dependencies: 242
1770-- Name: lekarze_exchange_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1771--
1772
1773SELECT pg_catalog.setval('public.lekarze_exchange_id_seq', 2, true);
1774
1775
1776--
1777-- TOC entry 3210 (class 0 OID 0)
1778-- Dependencies: 216
1779-- Name: lekarze_hospital_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1780--
1781
1782SELECT pg_catalog.setval('public.lekarze_hospital_id_seq', 33, true);
1783
1784
1785--
1786-- TOC entry 3211 (class 0 OID 0)
1787-- Dependencies: 236
1788-- Name: lekarze_shift_shift_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1789--
1790
1791SELECT pg_catalog.setval('public.lekarze_shift_shift_id_seq', 40, true);
1792
1793
1794--
1795-- TOC entry 3212 (class 0 OID 0)
1796-- Dependencies: 240
1797-- Name: lekarze_shiftcounter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1798--
1799
1800SELECT pg_catalog.setval('public.lekarze_shiftcounter_id_seq', 14, true);
1801
1802
1803--
1804-- TOC entry 3213 (class 0 OID 0)
1805-- Dependencies: 238
1806-- Name: lekarze_shifttype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1807--
1808
1809SELECT pg_catalog.setval('public.lekarze_shifttype_id_seq', 3, true);
1810
1811
1812--
1813-- TOC entry 3214 (class 0 OID 0)
1814-- Dependencies: 220
1815-- Name: schedule_calendar_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1816--
1817
1818SELECT pg_catalog.setval('public.schedule_calendar_id_seq', 1, false);
1819
1820
1821--
1822-- TOC entry 3215 (class 0 OID 0)
1823-- Dependencies: 222
1824-- Name: schedule_calendarrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1825--
1826
1827SELECT pg_catalog.setval('public.schedule_calendarrelation_id_seq', 1, false);
1828
1829
1830--
1831-- TOC entry 3216 (class 0 OID 0)
1832-- Dependencies: 224
1833-- Name: schedule_event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1834--
1835
1836SELECT pg_catalog.setval('public.schedule_event_id_seq', 1, false);
1837
1838
1839--
1840-- TOC entry 3217 (class 0 OID 0)
1841-- Dependencies: 226
1842-- Name: schedule_eventrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1843--
1844
1845SELECT pg_catalog.setval('public.schedule_eventrelation_id_seq', 1, false);
1846
1847
1848--
1849-- TOC entry 3218 (class 0 OID 0)
1850-- Dependencies: 228
1851-- Name: schedule_occurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1852--
1853
1854SELECT pg_catalog.setval('public.schedule_occurrence_id_seq', 1, false);
1855
1856
1857--
1858-- TOC entry 3219 (class 0 OID 0)
1859-- Dependencies: 230
1860-- Name: schedule_rule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
1861--
1862
1863SELECT pg_catalog.setval('public.schedule_rule_id_seq', 1, false);
1864
1865
1866--
1867-- TOC entry 2866 (class 2606 OID 16593)
1868-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
1869--
1870
1871ALTER TABLE ONLY public.auth_group
1872 ADD CONSTRAINT auth_group_name_key UNIQUE (name);
1873
1874
1875--
1876-- TOC entry 2871 (class 2606 OID 16520)
1877-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
1878--
1879
1880ALTER TABLE ONLY public.auth_group_permissions
1881 ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);
1882
1883
1884--
1885-- TOC entry 2874 (class 2606 OID 16483)
1886-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1887--
1888
1889ALTER TABLE ONLY public.auth_group_permissions
1890 ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);
1891
1892
1893--
1894-- TOC entry 2868 (class 2606 OID 16473)
1895-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1896--
1897
1898ALTER TABLE ONLY public.auth_group
1899 ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
1900
1901
1902--
1903-- TOC entry 2861 (class 2606 OID 16511)
1904-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
1905--
1906
1907ALTER TABLE ONLY public.auth_permission
1908 ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);
1909
1910
1911--
1912-- TOC entry 2863 (class 2606 OID 16465)
1913-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1914--
1915
1916ALTER TABLE ONLY public.auth_permission
1917 ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);
1918
1919
1920--
1921-- TOC entry 2882 (class 2606 OID 16501)
1922-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1923--
1924
1925ALTER TABLE ONLY public.auth_user_groups
1926 ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);
1927
1928
1929--
1930-- TOC entry 2885 (class 2606 OID 16535)
1931-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
1932--
1933
1934ALTER TABLE ONLY public.auth_user_groups
1935 ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);
1936
1937
1938--
1939-- TOC entry 2876 (class 2606 OID 16491)
1940-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1941--
1942
1943ALTER TABLE ONLY public.auth_user
1944 ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
1945
1946
1947--
1948-- TOC entry 2888 (class 2606 OID 16509)
1949-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1950--
1951
1952ALTER TABLE ONLY public.auth_user_user_permissions
1953 ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);
1954
1955
1956--
1957-- TOC entry 2891 (class 2606 OID 16549)
1958-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
1959--
1960
1961ALTER TABLE ONLY public.auth_user_user_permissions
1962 ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);
1963
1964
1965--
1966-- TOC entry 2879 (class 2606 OID 16587)
1967-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
1968--
1969
1970ALTER TABLE ONLY public.auth_user
1971 ADD CONSTRAINT auth_user_username_key UNIQUE (username);
1972
1973
1974--
1975-- TOC entry 2894 (class 2606 OID 16573)
1976-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1977--
1978
1979ALTER TABLE ONLY public.django_admin_log
1980 ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);
1981
1982
1983--
1984-- TOC entry 2856 (class 2606 OID 16457)
1985-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
1986--
1987
1988ALTER TABLE ONLY public.django_content_type
1989 ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);
1990
1991
1992--
1993-- TOC entry 2858 (class 2606 OID 16455)
1994-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1995--
1996
1997ALTER TABLE ONLY public.django_content_type
1998 ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);
1999
2000
2001--
2002-- TOC entry 2854 (class 2606 OID 16447)
2003-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2004--
2005
2006ALTER TABLE ONLY public.django_migrations
2007 ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);
2008
2009
2010--
2011-- TOC entry 2898 (class 2606 OID 16602)
2012-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2013--
2014
2015ALTER TABLE ONLY public.django_session
2016 ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);
2017
2018
2019--
2020-- TOC entry 2948 (class 2606 OID 16814)
2021-- Name: lekarze_city lekarze_city_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
2022--
2023
2024ALTER TABLE ONLY public.lekarze_city
2025 ADD CONSTRAINT lekarze_city_name_key UNIQUE (name);
2026
2027
2028--
2029-- TOC entry 2950 (class 2606 OID 16812)
2030-- Name: lekarze_city lekarze_city_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2031--
2032
2033ALTER TABLE ONLY public.lekarze_city
2034 ADD CONSTRAINT lekarze_city_pkey PRIMARY KEY (id);
2035
2036
2037--
2038-- TOC entry 2942 (class 2606 OID 16804)
2039-- Name: lekarze_country lekarze_country_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
2040--
2041
2042ALTER TABLE ONLY public.lekarze_country
2043 ADD CONSTRAINT lekarze_country_name_key UNIQUE (name);
2044
2045
2046--
2047-- TOC entry 2944 (class 2606 OID 16802)
2048-- Name: lekarze_country lekarze_country_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2049--
2050
2051ALTER TABLE ONLY public.lekarze_country
2052 ADD CONSTRAINT lekarze_country_pkey PRIMARY KEY (id);
2053
2054
2055--
2056-- TOC entry 2905 (class 2606 OID 16620)
2057-- Name: lekarze_department lekarze_department_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2058--
2059
2060ALTER TABLE ONLY public.lekarze_department
2061 ADD CONSTRAINT lekarze_department_pkey PRIMARY KEY (id);
2062
2063
2064--
2065-- TOC entry 2967 (class 2606 OID 16991)
2066-- Name: lekarze_exchange lekarze_exchange_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2067--
2068
2069ALTER TABLE ONLY public.lekarze_exchange
2070 ADD CONSTRAINT lekarze_exchange_pkey PRIMARY KEY (id);
2071
2072
2073--
2074-- TOC entry 2902 (class 2606 OID 16612)
2075-- Name: lekarze_hospital lekarze_hospital_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2076--
2077
2078ALTER TABLE ONLY public.lekarze_hospital
2079 ADD CONSTRAINT lekarze_hospital_pkey PRIMARY KEY (id);
2080
2081
2082--
2083-- TOC entry 2953 (class 2606 OID 16841)
2084-- Name: lekarze_shift lekarze_shift_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2085--
2086
2087ALTER TABLE ONLY public.lekarze_shift
2088 ADD CONSTRAINT lekarze_shift_pkey PRIMARY KEY (shift_id);
2089
2090
2091--
2092-- TOC entry 2963 (class 2606 OID 16898)
2093-- Name: lekarze_shiftcounter lekarze_shiftcounter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2094--
2095
2096ALTER TABLE ONLY public.lekarze_shiftcounter
2097 ADD CONSTRAINT lekarze_shiftcounter_pkey PRIMARY KEY (id);
2098
2099
2100--
2101-- TOC entry 2958 (class 2606 OID 16863)
2102-- Name: lekarze_shifttype lekarze_shifttype_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
2103--
2104
2105ALTER TABLE ONLY public.lekarze_shifttype
2106 ADD CONSTRAINT lekarze_shifttype_name_key UNIQUE (name);
2107
2108
2109--
2110-- TOC entry 2960 (class 2606 OID 16861)
2111-- Name: lekarze_shifttype lekarze_shifttype_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2112--
2113
2114ALTER TABLE ONLY public.lekarze_shifttype
2115 ADD CONSTRAINT lekarze_shifttype_pkey PRIMARY KEY (id);
2116
2117
2118--
2119-- TOC entry 2907 (class 2606 OID 16635)
2120-- Name: schedule_calendar schedule_calendar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2121--
2122
2123ALTER TABLE ONLY public.schedule_calendar
2124 ADD CONSTRAINT schedule_calendar_pkey PRIMARY KEY (id);
2125
2126
2127--
2128-- TOC entry 2910 (class 2606 OID 16754)
2129-- Name: schedule_calendar schedule_calendar_slug_ba17e861_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
2130--
2131
2132ALTER TABLE ONLY public.schedule_calendar
2133 ADD CONSTRAINT schedule_calendar_slug_ba17e861_uniq UNIQUE (slug);
2134
2135
2136--
2137-- TOC entry 2916 (class 2606 OID 16643)
2138-- Name: schedule_calendarrelation schedule_calendarrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2139--
2140
2141ALTER TABLE ONLY public.schedule_calendarrelation
2142 ADD CONSTRAINT schedule_calendarrelation_pkey PRIMARY KEY (id);
2143
2144
2145--
2146-- TOC entry 2922 (class 2606 OID 16654)
2147-- Name: schedule_event schedule_event_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2148--
2149
2150ALTER TABLE ONLY public.schedule_event
2151 ADD CONSTRAINT schedule_event_pkey PRIMARY KEY (id);
2152
2153
2154--
2155-- TOC entry 2931 (class 2606 OID 16662)
2156-- Name: schedule_eventrelation schedule_eventrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2157--
2158
2159ALTER TABLE ONLY public.schedule_eventrelation
2160 ADD CONSTRAINT schedule_eventrelation_pkey PRIMARY KEY (id);
2161
2162
2163--
2164-- TOC entry 2935 (class 2606 OID 16673)
2165-- Name: schedule_occurrence schedule_occurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2166--
2167
2168ALTER TABLE ONLY public.schedule_occurrence
2169 ADD CONSTRAINT schedule_occurrence_pkey PRIMARY KEY (id);
2170
2171
2172--
2173-- TOC entry 2939 (class 2606 OID 16684)
2174-- Name: schedule_rule schedule_rule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
2175--
2176
2177ALTER TABLE ONLY public.schedule_rule
2178 ADD CONSTRAINT schedule_rule_pkey PRIMARY KEY (id);
2179
2180
2181--
2182-- TOC entry 2864 (class 1259 OID 16594)
2183-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: postgres
2184--
2185
2186CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);
2187
2188
2189--
2190-- TOC entry 2869 (class 1259 OID 16531)
2191-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: postgres
2192--
2193
2194CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);
2195
2196
2197--
2198-- TOC entry 2872 (class 1259 OID 16532)
2199-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: postgres
2200--
2201
2202CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);
2203
2204
2205--
2206-- TOC entry 2859 (class 1259 OID 16517)
2207-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: postgres
2208--
2209
2210CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);
2211
2212
2213--
2214-- TOC entry 2880 (class 1259 OID 16547)
2215-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: postgres
2216--
2217
2218CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);
2219
2220
2221--
2222-- TOC entry 2883 (class 1259 OID 16546)
2223-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: postgres
2224--
2225
2226CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);
2227
2228
2229--
2230-- TOC entry 2886 (class 1259 OID 16561)
2231-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: postgres
2232--
2233
2234CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);
2235
2236
2237--
2238-- TOC entry 2889 (class 1259 OID 16560)
2239-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: postgres
2240--
2241
2242CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);
2243
2244
2245--
2246-- TOC entry 2877 (class 1259 OID 16588)
2247-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: postgres
2248--
2249
2250CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);
2251
2252
2253--
2254-- TOC entry 2892 (class 1259 OID 16584)
2255-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: postgres
2256--
2257
2258CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);
2259
2260
2261--
2262-- TOC entry 2895 (class 1259 OID 16585)
2263-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: postgres
2264--
2265
2266CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);
2267
2268
2269--
2270-- TOC entry 2896 (class 1259 OID 16604)
2271-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: postgres
2272--
2273
2274CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);
2275
2276
2277--
2278-- TOC entry 2899 (class 1259 OID 16603)
2279-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: postgres
2280--
2281
2282CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);
2283
2284
2285--
2286-- TOC entry 2945 (class 1259 OID 16833)
2287-- Name: lekarze_city_country_id_774a8bb4; Type: INDEX; Schema: public; Owner: postgres
2288--
2289
2290CREATE INDEX lekarze_city_country_id_774a8bb4 ON public.lekarze_city USING btree (country_id);
2291
2292
2293--
2294-- TOC entry 2946 (class 1259 OID 16832)
2295-- Name: lekarze_city_name_9fb3a5ba_like; Type: INDEX; Schema: public; Owner: postgres
2296--
2297
2298CREATE INDEX lekarze_city_name_9fb3a5ba_like ON public.lekarze_city USING btree (name varchar_pattern_ops);
2299
2300
2301--
2302-- TOC entry 2940 (class 1259 OID 16826)
2303-- Name: lekarze_country_name_4650b837_like; Type: INDEX; Schema: public; Owner: postgres
2304--
2305
2306CREATE INDEX lekarze_country_name_4650b837_like ON public.lekarze_country USING btree (name varchar_pattern_ops);
2307
2308
2309--
2310-- TOC entry 2903 (class 1259 OID 16626)
2311-- Name: lekarze_department_hospital_id_52d6ff47; Type: INDEX; Schema: public; Owner: postgres
2312--
2313
2314CREATE INDEX lekarze_department_hospital_id_52d6ff47 ON public.lekarze_department USING btree (hospital_id);
2315
2316
2317--
2318-- TOC entry 2965 (class 1259 OID 17020)
2319-- Name: lekarze_exchange_myshift_id_54e80b6b; Type: INDEX; Schema: public; Owner: postgres
2320--
2321
2322CREATE INDEX lekarze_exchange_myshift_id_54e80b6b ON public.lekarze_exchange USING btree (myshift_id);
2323
2324
2325--
2326-- TOC entry 2968 (class 1259 OID 17008)
2327-- Name: lekarze_exchange_who_id_b218e731; Type: INDEX; Schema: public; Owner: postgres
2328--
2329
2330CREATE INDEX lekarze_exchange_who_id_b218e731 ON public.lekarze_exchange USING btree (who_id);
2331
2332
2333--
2334-- TOC entry 2969 (class 1259 OID 17009)
2335-- Name: lekarze_exchange_whom_id_202f5a7a; Type: INDEX; Schema: public; Owner: postgres
2336--
2337
2338CREATE INDEX lekarze_exchange_whom_id_202f5a7a ON public.lekarze_exchange USING btree (whom_id);
2339
2340
2341--
2342-- TOC entry 2970 (class 1259 OID 17021)
2343-- Name: lekarze_exchange_yourshift_id_b844b66f; Type: INDEX; Schema: public; Owner: postgres
2344--
2345
2346CREATE INDEX lekarze_exchange_yourshift_id_b844b66f ON public.lekarze_exchange USING btree (yourshift_id);
2347
2348
2349--
2350-- TOC entry 2900 (class 1259 OID 16820)
2351-- Name: lekarze_hospital_city_id_2341f248; Type: INDEX; Schema: public; Owner: postgres
2352--
2353
2354CREATE INDEX lekarze_hospital_city_id_2341f248 ON public.lekarze_hospital USING btree (city_id);
2355
2356
2357--
2358-- TOC entry 2951 (class 1259 OID 16852)
2359-- Name: lekarze_shift_department_id_62561e0d; Type: INDEX; Schema: public; Owner: postgres
2360--
2361
2362CREATE INDEX lekarze_shift_department_id_62561e0d ON public.lekarze_shift USING btree (department_id);
2363
2364
2365--
2366-- TOC entry 2954 (class 1259 OID 16878)
2367-- Name: lekarze_shift_shift_type_id_8ceb1261; Type: INDEX; Schema: public; Owner: postgres
2368--
2369
2370CREATE INDEX lekarze_shift_shift_type_id_8ceb1261 ON public.lekarze_shift USING btree (shift_type_id);
2371
2372
2373--
2374-- TOC entry 2955 (class 1259 OID 16853)
2375-- Name: lekarze_shift_staff_name_id_fb063ee2; Type: INDEX; Schema: public; Owner: postgres
2376--
2377
2378CREATE INDEX lekarze_shift_staff_name_id_fb063ee2 ON public.lekarze_shift USING btree (staff_name_id);
2379
2380
2381--
2382-- TOC entry 2961 (class 1259 OID 16983)
2383-- Name: lekarze_shiftcounter_department_id_094d2b8d; Type: INDEX; Schema: public; Owner: postgres
2384--
2385
2386CREATE INDEX lekarze_shiftcounter_department_id_094d2b8d ON public.lekarze_shiftcounter USING btree (department_id);
2387
2388
2389--
2390-- TOC entry 2964 (class 1259 OID 16905)
2391-- Name: lekarze_shiftcounter_shift_Type_id_dade3f97; Type: INDEX; Schema: public; Owner: postgres
2392--
2393
2394CREATE INDEX "lekarze_shiftcounter_shift_Type_id_dade3f97" ON public.lekarze_shiftcounter USING btree (shift_type_id);
2395
2396
2397--
2398-- TOC entry 2956 (class 1259 OID 16864)
2399-- Name: lekarze_shifttype_name_d96f8060_like; Type: INDEX; Schema: public; Owner: postgres
2400--
2401
2402CREATE INDEX lekarze_shifttype_name_d96f8060_like ON public.lekarze_shifttype USING btree (name varchar_pattern_ops);
2403
2404
2405--
2406-- TOC entry 2908 (class 1259 OID 16755)
2407-- Name: schedule_calendar_slug_ba17e861_like; Type: INDEX; Schema: public; Owner: postgres
2408--
2409
2410CREATE INDEX schedule_calendar_slug_ba17e861_like ON public.schedule_calendar USING btree (slug varchar_pattern_ops);
2411
2412
2413--
2414-- TOC entry 2911 (class 1259 OID 16751)
2415-- Name: schedule_calendarrelatio_content_type_id_object_i_3378a516_idx; Type: INDEX; Schema: public; Owner: postgres
2416--
2417
2418CREATE INDEX schedule_calendarrelatio_content_type_id_object_i_3378a516_idx ON public.schedule_calendarrelation USING btree (content_type_id, object_id);
2419
2420
2421--
2422-- TOC entry 2912 (class 1259 OID 16702)
2423-- Name: schedule_calendarrelation_calendar_id_0a50be2e; Type: INDEX; Schema: public; Owner: postgres
2424--
2425
2426CREATE INDEX schedule_calendarrelation_calendar_id_0a50be2e ON public.schedule_calendarrelation USING btree (calendar_id);
2427
2428
2429--
2430-- TOC entry 2913 (class 1259 OID 16703)
2431-- Name: schedule_calendarrelation_content_type_id_f2a42f5b; Type: INDEX; Schema: public; Owner: postgres
2432--
2433
2434CREATE INDEX schedule_calendarrelation_content_type_id_f2a42f5b ON public.schedule_calendarrelation USING btree (content_type_id);
2435
2436
2437--
2438-- TOC entry 2914 (class 1259 OID 16749)
2439-- Name: schedule_calendarrelation_object_id_1743bce6; Type: INDEX; Schema: public; Owner: postgres
2440--
2441
2442CREATE INDEX schedule_calendarrelation_object_id_1743bce6 ON public.schedule_calendarrelation USING btree (object_id);
2443
2444
2445--
2446-- TOC entry 2917 (class 1259 OID 16714)
2447-- Name: schedule_event_calendar_id_eb1c700f; Type: INDEX; Schema: public; Owner: postgres
2448--
2449
2450CREATE INDEX schedule_event_calendar_id_eb1c700f ON public.schedule_event USING btree (calendar_id);
2451
2452
2453--
2454-- TOC entry 2918 (class 1259 OID 16715)
2455-- Name: schedule_event_creator_id_d2ffab6e; Type: INDEX; Schema: public; Owner: postgres
2456--
2457
2458CREATE INDEX schedule_event_creator_id_d2ffab6e ON public.schedule_event USING btree (creator_id);
2459
2460
2461--
2462-- TOC entry 2919 (class 1259 OID 16735)
2463-- Name: schedule_event_end_674c5848; Type: INDEX; Schema: public; Owner: postgres
2464--
2465
2466CREATE INDEX schedule_event_end_674c5848 ON public.schedule_event USING btree ("end");
2467
2468
2469--
2470-- TOC entry 2920 (class 1259 OID 16736)
2471-- Name: schedule_event_end_recurring_period_672addcf; Type: INDEX; Schema: public; Owner: postgres
2472--
2473
2474CREATE INDEX schedule_event_end_recurring_period_672addcf ON public.schedule_event USING btree (end_recurring_period);
2475
2476
2477--
2478-- TOC entry 2923 (class 1259 OID 16734)
2479-- Name: schedule_event_rule_id_90b83d31; Type: INDEX; Schema: public; Owner: postgres
2480--
2481
2482CREATE INDEX schedule_event_rule_id_90b83d31 ON public.schedule_event USING btree (rule_id);
2483
2484
2485--
2486-- TOC entry 2924 (class 1259 OID 16737)
2487-- Name: schedule_event_start_a11492a7; Type: INDEX; Schema: public; Owner: postgres
2488--
2489
2490CREATE INDEX schedule_event_start_a11492a7 ON public.schedule_event USING btree (start);
2491
2492
2493--
2494-- TOC entry 2925 (class 1259 OID 16740)
2495-- Name: schedule_event_start_end_89f30672_idx; Type: INDEX; Schema: public; Owner: postgres
2496--
2497
2498CREATE INDEX schedule_event_start_end_89f30672_idx ON public.schedule_event USING btree (start, "end");
2499
2500
2501--
2502-- TOC entry 2926 (class 1259 OID 16726)
2503-- Name: schedule_eventrelation_content_type_id_d4187723; Type: INDEX; Schema: public; Owner: postgres
2504--
2505
2506CREATE INDEX schedule_eventrelation_content_type_id_d4187723 ON public.schedule_eventrelation USING btree (content_type_id);
2507
2508
2509--
2510-- TOC entry 2927 (class 1259 OID 16752)
2511-- Name: schedule_eventrelation_content_type_id_object_id_c1b1e893_idx; Type: INDEX; Schema: public; Owner: postgres
2512--
2513
2514CREATE INDEX schedule_eventrelation_content_type_id_object_id_c1b1e893_idx ON public.schedule_eventrelation USING btree (content_type_id, object_id);
2515
2516
2517--
2518-- TOC entry 2928 (class 1259 OID 16727)
2519-- Name: schedule_eventrelation_event_id_8c57a7b4; Type: INDEX; Schema: public; Owner: postgres
2520--
2521
2522CREATE INDEX schedule_eventrelation_event_id_8c57a7b4 ON public.schedule_eventrelation USING btree (event_id);
2523
2524
2525--
2526-- TOC entry 2929 (class 1259 OID 16750)
2527-- Name: schedule_eventrelation_object_id_e22334a2; Type: INDEX; Schema: public; Owner: postgres
2528--
2529
2530CREATE INDEX schedule_eventrelation_object_id_e22334a2 ON public.schedule_eventrelation USING btree (object_id);
2531
2532
2533--
2534-- TOC entry 2932 (class 1259 OID 16738)
2535-- Name: schedule_occurrence_end_ae255624; Type: INDEX; Schema: public; Owner: postgres
2536--
2537
2538CREATE INDEX schedule_occurrence_end_ae255624 ON public.schedule_occurrence USING btree ("end");
2539
2540
2541--
2542-- TOC entry 2933 (class 1259 OID 16733)
2543-- Name: schedule_occurrence_event_id_ade47cd8; Type: INDEX; Schema: public; Owner: postgres
2544--
2545
2546CREATE INDEX schedule_occurrence_event_id_ade47cd8 ON public.schedule_occurrence USING btree (event_id);
2547
2548
2549--
2550-- TOC entry 2936 (class 1259 OID 16739)
2551-- Name: schedule_occurrence_start_b28eeb2f; Type: INDEX; Schema: public; Owner: postgres
2552--
2553
2554CREATE INDEX schedule_occurrence_start_b28eeb2f ON public.schedule_occurrence USING btree (start);
2555
2556
2557--
2558-- TOC entry 2937 (class 1259 OID 16741)
2559-- Name: schedule_occurrence_start_end_5fc98870_idx; Type: INDEX; Schema: public; Owner: postgres
2560--
2561
2562CREATE INDEX schedule_occurrence_start_end_5fc98870_idx ON public.schedule_occurrence USING btree (start, "end");
2563
2564
2565--
2566-- TOC entry 2973 (class 2606 OID 16526)
2567-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2568--
2569
2570ALTER TABLE ONLY public.auth_group_permissions
2571 ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
2572
2573
2574--
2575-- TOC entry 2972 (class 2606 OID 16521)
2576-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2577--
2578
2579ALTER TABLE ONLY public.auth_group_permissions
2580 ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
2581
2582
2583--
2584-- TOC entry 2971 (class 2606 OID 16512)
2585-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2586--
2587
2588ALTER TABLE ONLY public.auth_permission
2589 ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
2590
2591
2592--
2593-- TOC entry 2975 (class 2606 OID 16541)
2594-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2595--
2596
2597ALTER TABLE ONLY public.auth_user_groups
2598 ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;
2599
2600
2601--
2602-- TOC entry 2974 (class 2606 OID 16536)
2603-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2604--
2605
2606ALTER TABLE ONLY public.auth_user_groups
2607 ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2608
2609
2610--
2611-- TOC entry 2977 (class 2606 OID 16555)
2612-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2613--
2614
2615ALTER TABLE ONLY public.auth_user_user_permissions
2616 ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;
2617
2618
2619--
2620-- TOC entry 2976 (class 2606 OID 16550)
2621-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2622--
2623
2624ALTER TABLE ONLY public.auth_user_user_permissions
2625 ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2626
2627
2628--
2629-- TOC entry 2978 (class 2606 OID 16574)
2630-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2631--
2632
2633ALTER TABLE ONLY public.django_admin_log
2634 ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
2635
2636
2637--
2638-- TOC entry 2979 (class 2606 OID 16579)
2639-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2640--
2641
2642ALTER TABLE ONLY public.django_admin_log
2643 ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2644
2645
2646--
2647-- TOC entry 2990 (class 2606 OID 16827)
2648-- Name: lekarze_city lekarze_city_country_id_774a8bb4_fk_lekarze_country_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2649--
2650
2651ALTER TABLE ONLY public.lekarze_city
2652 ADD CONSTRAINT lekarze_city_country_id_774a8bb4_fk_lekarze_country_id FOREIGN KEY (country_id) REFERENCES public.lekarze_country(id) DEFERRABLE INITIALLY DEFERRED;
2653
2654
2655--
2656-- TOC entry 2981 (class 2606 OID 16621)
2657-- Name: lekarze_department lekarze_department_hospital_id_52d6ff47_fk_lekarze_hospital_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2658--
2659
2660ALTER TABLE ONLY public.lekarze_department
2661 ADD CONSTRAINT lekarze_department_hospital_id_52d6ff47_fk_lekarze_hospital_id FOREIGN KEY (hospital_id) REFERENCES public.lekarze_hospital(id) DEFERRABLE INITIALLY DEFERRED;
2662
2663
2664--
2665-- TOC entry 2998 (class 2606 OID 17010)
2666-- Name: lekarze_exchange lekarze_exchange_myshift_id_54e80b6b_fk_lekarze_shift_shift_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2667--
2668
2669ALTER TABLE ONLY public.lekarze_exchange
2670 ADD CONSTRAINT lekarze_exchange_myshift_id_54e80b6b_fk_lekarze_shift_shift_id FOREIGN KEY (myshift_id) REFERENCES public.lekarze_shift(shift_id) DEFERRABLE INITIALLY DEFERRED;
2671
2672
2673--
2674-- TOC entry 2996 (class 2606 OID 16997)
2675-- Name: lekarze_exchange lekarze_exchange_who_id_b218e731_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2676--
2677
2678ALTER TABLE ONLY public.lekarze_exchange
2679 ADD CONSTRAINT lekarze_exchange_who_id_b218e731_fk_auth_user_id FOREIGN KEY (who_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2680
2681
2682--
2683-- TOC entry 2997 (class 2606 OID 17002)
2684-- Name: lekarze_exchange lekarze_exchange_whom_id_202f5a7a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2685--
2686
2687ALTER TABLE ONLY public.lekarze_exchange
2688 ADD CONSTRAINT lekarze_exchange_whom_id_202f5a7a_fk_auth_user_id FOREIGN KEY (whom_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2689
2690
2691--
2692-- TOC entry 2999 (class 2606 OID 17015)
2693-- Name: lekarze_exchange lekarze_exchange_yourshift_id_b844b66f_fk_lekarze_s; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2694--
2695
2696ALTER TABLE ONLY public.lekarze_exchange
2697 ADD CONSTRAINT lekarze_exchange_yourshift_id_b844b66f_fk_lekarze_s FOREIGN KEY (yourshift_id) REFERENCES public.lekarze_shift(shift_id) DEFERRABLE INITIALLY DEFERRED;
2698
2699
2700--
2701-- TOC entry 2980 (class 2606 OID 16821)
2702-- Name: lekarze_hospital lekarze_hospital_city_id_2341f248_fk_lekarze_city_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2703--
2704
2705ALTER TABLE ONLY public.lekarze_hospital
2706 ADD CONSTRAINT lekarze_hospital_city_id_2341f248_fk_lekarze_city_id FOREIGN KEY (city_id) REFERENCES public.lekarze_city(id) DEFERRABLE INITIALLY DEFERRED;
2707
2708
2709--
2710-- TOC entry 2991 (class 2606 OID 16842)
2711-- Name: lekarze_shift lekarze_shift_department_id_62561e0d_fk_lekarze_department_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2712--
2713
2714ALTER TABLE ONLY public.lekarze_shift
2715 ADD CONSTRAINT lekarze_shift_department_id_62561e0d_fk_lekarze_department_id FOREIGN KEY (department_id) REFERENCES public.lekarze_department(id) DEFERRABLE INITIALLY DEFERRED;
2716
2717
2718--
2719-- TOC entry 2993 (class 2606 OID 16873)
2720-- Name: lekarze_shift lekarze_shift_shift_type_id_8ceb1261_fk_lekarze_shifttype_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2721--
2722
2723ALTER TABLE ONLY public.lekarze_shift
2724 ADD CONSTRAINT lekarze_shift_shift_type_id_8ceb1261_fk_lekarze_shifttype_id FOREIGN KEY (shift_type_id) REFERENCES public.lekarze_shifttype(id) DEFERRABLE INITIALLY DEFERRED;
2725
2726
2727--
2728-- TOC entry 2992 (class 2606 OID 16847)
2729-- Name: lekarze_shift lekarze_shift_staff_name_id_fb063ee2_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2730--
2731
2732ALTER TABLE ONLY public.lekarze_shift
2733 ADD CONSTRAINT lekarze_shift_staff_name_id_fb063ee2_fk_auth_user_id FOREIGN KEY (staff_name_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2734
2735
2736--
2737-- TOC entry 2995 (class 2606 OID 16978)
2738-- Name: lekarze_shiftcounter lekarze_shiftcounter_department_id_094d2b8d_fk_lekarze_d; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2739--
2740
2741ALTER TABLE ONLY public.lekarze_shiftcounter
2742 ADD CONSTRAINT lekarze_shiftcounter_department_id_094d2b8d_fk_lekarze_d FOREIGN KEY (department_id) REFERENCES public.lekarze_department(id) DEFERRABLE INITIALLY DEFERRED;
2743
2744
2745--
2746-- TOC entry 2994 (class 2606 OID 16906)
2747-- Name: lekarze_shiftcounter lekarze_shiftcounter_shift_type_id_5c9c1da3_fk_lekarze_s; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2748--
2749
2750ALTER TABLE ONLY public.lekarze_shiftcounter
2751 ADD CONSTRAINT lekarze_shiftcounter_shift_type_id_5c9c1da3_fk_lekarze_s FOREIGN KEY (shift_type_id) REFERENCES public.lekarze_shifttype(id) DEFERRABLE INITIALLY DEFERRED;
2752
2753
2754--
2755-- TOC entry 2982 (class 2606 OID 16692)
2756-- Name: schedule_calendarrelation schedule_calendarrel_calendar_id_0a50be2e_fk_schedule_; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2757--
2758
2759ALTER TABLE ONLY public.schedule_calendarrelation
2760 ADD CONSTRAINT schedule_calendarrel_calendar_id_0a50be2e_fk_schedule_ FOREIGN KEY (calendar_id) REFERENCES public.schedule_calendar(id) DEFERRABLE INITIALLY DEFERRED;
2761
2762
2763--
2764-- TOC entry 2983 (class 2606 OID 16697)
2765-- Name: schedule_calendarrelation schedule_calendarrel_content_type_id_f2a42f5b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2766--
2767
2768ALTER TABLE ONLY public.schedule_calendarrelation
2769 ADD CONSTRAINT schedule_calendarrel_content_type_id_f2a42f5b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
2770
2771
2772--
2773-- TOC entry 2984 (class 2606 OID 16756)
2774-- Name: schedule_event schedule_event_calendar_id_eb1c700f_fk_schedule_calendar_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2775--
2776
2777ALTER TABLE ONLY public.schedule_event
2778 ADD CONSTRAINT schedule_event_calendar_id_eb1c700f_fk_schedule_calendar_id FOREIGN KEY (calendar_id) REFERENCES public.schedule_calendar(id) DEFERRABLE INITIALLY DEFERRED;
2779
2780
2781--
2782-- TOC entry 2985 (class 2606 OID 16761)
2783-- Name: schedule_event schedule_event_creator_id_d2ffab6e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2784--
2785
2786ALTER TABLE ONLY public.schedule_event
2787 ADD CONSTRAINT schedule_event_creator_id_d2ffab6e_fk_auth_user_id FOREIGN KEY (creator_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;
2788
2789
2790--
2791-- TOC entry 2986 (class 2606 OID 16766)
2792-- Name: schedule_event schedule_event_rule_id_90b83d31_fk_schedule_rule_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2793--
2794
2795ALTER TABLE ONLY public.schedule_event
2796 ADD CONSTRAINT schedule_event_rule_id_90b83d31_fk_schedule_rule_id FOREIGN KEY (rule_id) REFERENCES public.schedule_rule(id) DEFERRABLE INITIALLY DEFERRED;
2797
2798
2799--
2800-- TOC entry 2987 (class 2606 OID 16716)
2801-- Name: schedule_eventrelation schedule_eventrelati_content_type_id_d4187723_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2802--
2803
2804ALTER TABLE ONLY public.schedule_eventrelation
2805 ADD CONSTRAINT schedule_eventrelati_content_type_id_d4187723_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;
2806
2807
2808--
2809-- TOC entry 2988 (class 2606 OID 16721)
2810-- Name: schedule_eventrelation schedule_eventrelation_event_id_8c57a7b4_fk_schedule_event_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2811--
2812
2813ALTER TABLE ONLY public.schedule_eventrelation
2814 ADD CONSTRAINT schedule_eventrelation_event_id_8c57a7b4_fk_schedule_event_id FOREIGN KEY (event_id) REFERENCES public.schedule_event(id) DEFERRABLE INITIALLY DEFERRED;
2815
2816
2817--
2818-- TOC entry 2989 (class 2606 OID 16728)
2819-- Name: schedule_occurrence schedule_occurrence_event_id_ade47cd8_fk_schedule_event_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
2820--
2821
2822ALTER TABLE ONLY public.schedule_occurrence
2823 ADD CONSTRAINT schedule_occurrence_event_id_ade47cd8_fk_schedule_event_id FOREIGN KEY (event_id) REFERENCES public.schedule_event(id) DEFERRABLE INITIALLY DEFERRED;
2824
2825
2826-- Completed on 2020-01-27 03:00:21
2827
2828--
2829-- PostgreSQL database dump complete
2830--