--
--



--
-- Name: Erfahrungsstufen_ID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Erfahrungsstufen_ID_seq', 4, true);


--
-- Name: Fotos_ID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Fotos_ID_seq', 3, true);


--
-- Name: Kamera_ID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Kamera_ID_seq', 4, true);


--
-- Name: Mitarbeiter_Erfahrung_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Mitarbeiter_Erfahrung_seq', 1, false);


--
-- Name: Mitarbeiter_PersonID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Mitarbeiter_PersonID_seq', 1, false);


--
-- Name: Person_ID_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('Person_ID_seq', 8, true);


--
-- Data for Name: Erfahrungsstufen; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Erfahrungsstufen VALUES (1, 'Anfaenger');
INSERT INTO Erfahrungsstufen VALUES (2, 'Fortgeschrittener');
INSERT INTO Erfahrungsstufen VALUES (3, 'Profi');


--
-- Data for Name: Personen; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Personen VALUES (1, 'Schweitzer', 'Albert', '1973-03-01');
INSERT INTO Personen VALUES (2, 'Carlos', 'Rob', '1975-07-12');
INSERT INTO Personen VALUES (3, 'Mueller', 'Peter', '1963-10-09');
INSERT INTO Personen VALUES (4, 'Zappa', 'Frank', '1955-11-04');
INSERT INTO Personen VALUES (5, 'Taylor', 'Tim', '1980-03-04');
INSERT INTO Personen VALUES (6, 'Wurst', 'Hans', '1974-02-01');
INSERT INTO Personen VALUES (7, 'Miese', 'Peter', '1983-05-06');
INSERT INTO Personen VALUES (8, 'Koenig', 'Dieter', '1967-06-11');


--
-- Data for Name: Mitarbeiter; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Mitarbeiter VALUES (1, 45000, 3);
INSERT INTO Mitarbeiter VALUES (2, 37000, 3);
INSERT INTO Mitarbeiter VALUES (3, 50000, 2);
INSERT INTO Mitarbeiter VALUES (4, 60000, 3);
INSERT INTO Mitarbeiter VALUES (5, 55000, 2);
INSERT INTO Mitarbeiter VALUES (6, 15000, 1);
INSERT INTO Mitarbeiter VALUES (7, 50000, 2);


--
-- Data for Name: Fotographen; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Fotographen VALUES (3);
INSERT INTO Fotographen VALUES (7);
INSERT INTO Fotographen VALUES (6);


--
-- Data for Name: Kameras; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Kameras VALUES (1, 'Canon', '6d');
INSERT INTO Kameras VALUES (2, 'Canon', '650d');
INSERT INTO Kameras VALUES (3, 'Nikon', 'D3200');
INSERT INTO Kameras VALUES (4, 'Nikon', 'D700');


--
-- Data for Name: Fotos; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Fotos VALUES (1, '(123,234)', '2013-05-14 15:40:47.161073+02', 3, 1);
INSERT INTO Fotos VALUES (2, '(3123.98000000000002,67.9869999999999948)', '2013-05-14 15:40:47.170802+02', 6, 3);
INSERT INTO Fotos VALUES (3, '(615.649999999999977,691.950000000000045)', '2013-05-14 15:42:33.031867+02', 7, 2);


--
-- Data for Name: Fotoabzuege; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Fotoabzuege VALUES (1, '2013-05-14 15:43:38.348346+02', '(640,320)');


--
-- Data for Name: Kunden; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Kunden VALUES (8, 'Werbung');


--
-- Data for Name: Seniors; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Seniors VALUES (1, 45, 34000);
INSERT INTO Seniors VALUES (2, 457, 40000);


--
-- Data for Name: Managed; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Managed VALUES (1, 3, '2013-01-01', NULL);
INSERT INTO Managed VALUES (2, 6, '2012-09-01', '2013-03-31');
INSERT INTO Managed VALUES (1, 6, '2013-04-01', NULL);
INSERT INTO Managed VALUES (2, 7, '2013-01-01', NULL);


--
-- Data for Name: Verkaeufer; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Verkaeufer VALUES (4, 'Werbung');
INSERT INTO Verkaeufer VALUES (5, 'Portrait');


--
-- Data for Name: Verkaufen; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO Verkaufen VALUES (3200.99, 8, 4, 1);
INSERT INTO Verkaufen VALUES (999.98, 8, 5, 3);


--
--

