15 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
22 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
35 -- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres
40     name character varying(80) NOT NULL  field
47 -- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
61 -- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
68 -- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres
81 -- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
95 -- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
102 -- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres
107     name character varying(255) NOT NULL,  field
116 -- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
130 -- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
137 -- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres
158 -- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres
171 -- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
185 -- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
192 -- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
206 -- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
213 -- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres
226 -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
240 -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
247 -- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres
266 -- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
280 -- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
287 -- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres
300 -- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
314 -- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
321 -- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres
327     name character varying(255) NOT NULL,  field
335 -- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
349 -- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
356 -- Name: django_session; Type: TABLE; Schema: public; Owner: postgres
369 -- Name: timetracker_billingperiod; Type: TABLE; Schema: public; Owner: postgres
385 -- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
399 -- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
406 -- Name: timetracker_project; Type: TABLE; Schema: public; Owner: postgres
411     name character varying(200) NOT NULL,  field
422 -- Name: timetracker_project_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
436 -- Name: timetracker_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
443 -- Name: timetracker_project_members; Type: TABLE; Schema: public; Owner: postgres
456 -- Name: timetracker_project_members_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
470 -- Name: timetracker_project_members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgr…
477 -- Name: timetracker_worklog; Type: TABLE; Schema: public; Owner: postgres
495 -- Name: timetracker_worklog_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
509 -- Name: timetracker_worklog_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
516 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
523 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
530 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
537 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
544 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
551 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
558 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
565 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
572 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
579 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
586 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
593 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
600 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
607 -- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: postgres
610 INSERT INTO auth_group (id, name) VALUES (2, 'Kunden');
611 INSERT INTO auth_group (id, name) VALUES (3, 'Projektleiter');
612 INSERT INTO auth_group (id, name) VALUES (1, 'Mitarbeiter');
613 INSERT INTO auth_group (id, name) VALUES (4, 'Billing');
617 -- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
624 -- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
642 -- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
649 -- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: postgres
652 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (1, 'Can add project', 1, …
653 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (2, 'Can change project', …
654 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (3, 'Can delete project', …
655 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (4, 'Can add work log', 2,…
656 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (5, 'Can change work log',…
657 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (6, 'Can delete work log',…
658 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (7, 'Can add billing perio…
659 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (8, 'Can change billing pe…
660 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (9, 'Can delete billing pe…
661 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (10, 'Can add log entry', …
662 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (11, 'Can change log entry…
663 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (12, 'Can delete log entry…
664 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (13, 'Can add permission',…
665 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (14, 'Can change permissio…
666 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (15, 'Can delete permissio…
667 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (16, 'Can add group', 6, '…
668 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (17, 'Can change group', 6…
669 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (18, 'Can delete group', 6…
670 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (19, 'Can add user', 7, 'a…
671 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (20, 'Can change user', 7,…
672 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (21, 'Can delete user', 7,…
673 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (22, 'Can add content type…
674 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (23, 'Can change content t…
675 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (24, 'Can delete content t…
676 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (25, 'Can add session', 9,…
677 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (26, 'Can change session',…
678 INSERT INTO auth_permission (id, name, content_type_id, codename) VALUES (27, 'Can delete session',…
682 -- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
689 -- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: postgres
700 -- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: postgres
710 -- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
717 -- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
724 -- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
733 -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
740 -- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: postgres
767 -- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
774 -- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: postgres
789 -- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
796 -- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: postgres
799 INSERT INTO django_migrations (id, app, name, applied) VALUES (1, 'contenttypes', '0001_initial', '…
800 INSERT INTO django_migrations (id, app, name, applied) VALUES (2, 'auth', '0001_initial', '2016-03-…
801 INSERT INTO django_migrations (id, app, name, applied) VALUES (3, 'admin', '0001_initial', '2016-03…
802 INSERT INTO django_migrations (id, app, name, applied) VALUES (4, 'admin', '0002_logentry_remove_au…
803 INSERT INTO django_migrations (id, app, name, applied) VALUES (5, 'contenttypes', '0002_remove_cont…
804 INSERT INTO django_migrations (id, app, name, applied) VALUES (6, 'auth', '0002_alter_permission_na…
805 INSERT INTO django_migrations (id, app, name, applied) VALUES (7, 'auth', '0003_alter_user_email_ma…
806 INSERT INTO django_migrations (id, app, name, applied) VALUES (8, 'auth', '0004_alter_user_username…
807 INSERT INTO django_migrations (id, app, name, applied) VALUES (9, 'auth', '0005_alter_user_last_log…
808 INSERT INTO django_migrations (id, app, name, applied) VALUES (10, 'auth', '0006_require_contenttyp…
809 INSERT INTO django_migrations (id, app, name, applied) VALUES (11, 'auth', '0007_alter_validators_a…
810 INSERT INTO django_migrations (id, app, name, applied) VALUES (12, 'sessions', '0001_initial', '201…
811 INSERT INTO django_migrations (id, app, name, applied) VALUES (13, 'timetracker', '0001_initial', '…
812 INSERT INTO django_migrations (id, app, name, applied) VALUES (14, 'timetracker', '0002_billingperi…
813 INSERT INTO django_migrations (id, app, name, applied) VALUES (15, 'timetracker', '0003_local_datet…
814 INSERT INTO django_migrations (id, app, name, applied) VALUES (16, 'timetracker', '0004_worklog_bil…
815 INSERT INTO django_migrations (id, app, name, applied) VALUES (17, 'timetracker', '0005_billing_per…
819 -- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
826 -- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: postgres
833 -- Data for Name: timetracker_billingperiod; Type: TABLE DATA; Schema: public; Owner: postgres
839 -- Name: timetracker_billingperiod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
846 -- Data for Name: timetracker_project; Type: TABLE DATA; Schema: public; Owner: postgres
852 -- Name: timetracker_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
859 -- Data for Name: timetracker_project_members; Type: TABLE DATA; Schema: public; Owner: postgres
865 -- Name: timetracker_project_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
872 -- Data for Name: timetracker_worklog; Type: TABLE DATA; Schema: public; Owner: postgres
878 -- Name: timetracker_worklog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
885 -- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
889     ADD CONSTRAINT auth_group_name_key UNIQUE (name);
893 -- Name: auth_group_permissions_group_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: po…
901 -- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
909 -- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
917 -- Name: auth_permission_content_type_id_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: po…
925 -- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
933 -- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
941 -- Name: auth_user_groups_user_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
949 -- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
957 -- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
965 -- Name: auth_user_user_permissions_user_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner:…
973 -- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
981 -- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
989 -- Name: django_content_type_app_label_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: post…
997 -- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1005 -- Name: django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1013 -- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1021 -- Name: timetracker_billingperiod_identifier_key; Type: CONSTRAINT; Schema: public; Owner: postgres
1029 -- Name: timetracker_billingperiod_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1037 -- Name: timetracker_project_members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1045 -- Name: timetracker_project_members_project_id_786577ed_uniq; Type: CONSTRAINT; Schema: public; Ow…
1053 -- Name: timetracker_project_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
1057     ADD CONSTRAINT timetracker_project_name_key UNIQUE (name);
1061 -- Name: timetracker_project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1069 -- Name: timetracker_worklog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
1077 -- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: postgres
1080 CREATE INDEX auth_group_name_a6ea08ec_like ON auth_group USING btree (name varchar_pattern_ops);
1084 -- Name: auth_group_permissions_0e939a4f; Type: INDEX; Schema: public; Owner: postgres
1091 -- Name: auth_group_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres
1098 -- Name: auth_permission_417f1b1c; Type: INDEX; Schema: public; Owner: postgres
1105 -- Name: auth_user_groups_0e939a4f; Type: INDEX; Schema: public; Owner: postgres
1112 -- Name: auth_user_groups_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
1119 -- Name: auth_user_user_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres
1126 -- Name: auth_user_user_permissions_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
1133 -- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: postgres
1140 -- Name: django_admin_log_417f1b1c; Type: INDEX; Schema: public; Owner: postgres
1147 -- Name: django_admin_log_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
1154 -- Name: django_session_de54fa62; Type: INDEX; Schema: public; Owner: postgres
1161 -- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: postgres
1168 -- Name: timetracker_billingperiod_b098ad43; Type: INDEX; Schema: public; Owner: postgres
1175 -- Name: timetracker_billingperiod_identifier_8432361f_like; Type: INDEX; Schema: public; Owner: po…
1182 -- Name: timetracker_project_members_b098ad43; Type: INDEX; Schema: public; Owner: postgres
1189 -- Name: timetracker_project_members_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
1196 -- Name: timetracker_project_name_daf0136a_like; Type: INDEX; Schema: public; Owner: postgres
1199 CREATE INDEX timetracker_project_name_daf0136a_like ON timetracker_project USING btree (name varcha…
1203 -- Name: timetracker_worklog_3c1a7956; Type: INDEX; Schema: public; Owner: postgres
1210 -- Name: timetracker_worklog_b098ad43; Type: INDEX; Schema: public; Owner: postgres
1217 -- Name: timetracker_worklog_e8701ad4; Type: INDEX; Schema: public; Owner: postgres
1224 -- Name: auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id; Type: FK CONSTRAINT; Sche…
1232 -- Name: auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: pu…
1240 -- Name: auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id; Type: FK CONSTRAINT; Sche…
1248 -- Name: auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; …
1256 -- Name: auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Ow…
1264 -- Name: auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id; Type: FK CONSTRAINT; Sche…
1272 -- Name: auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: …
1280 -- Name: django_admin_content_type_id_c4bce8eb_fk_django_content_type_id; Type: FK CONSTRAINT; Sche…
1288 -- Name: django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Ow…
1296 -- Name: time_billing_period_id_c4b944d1_fk_timetracker_billingperiod_id; Type: FK CONSTRAINT; Sche…
1304 -- Name: timetracker_billi_project_id_8dd7b2e2_fk_timetracker_project_id; Type: FK CONSTRAINT; Sche…
1312 -- Name: timetracker_proje_project_id_85632ed8_fk_timetracker_project_id; Type: FK CONSTRAINT; Sche…
1320 -- Name: timetracker_project_members_user_id_62b48c3e_fk_auth_user_id; Type: FK CONSTRAINT; Schema:…
1328 -- Name: timetracker_workl_project_id_69fa76d5_fk_timetracker_project_id; Type: FK CONSTRAINT; Sche…
1336 -- Name: timetracker_worklog_user_id_c74c8c68_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public;…
1344 -- Name: public; Type: ACL; Schema: -; Owner: postgres