--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;



--
-- Data for Name: trade_name; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY trade_name (id, descr, trade_name_foreign) FROM stdin;
1	Evolution	f
\.
--
-- Data for Name: article; Type: TABLE DATA; Schema: public; Owner: evolution
--




--
-- Data for Name: article_group; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY article_group (id, descr, parent_id) FROM stdin;
1	Kapsel- und Tablettprodukte	1
2	Tropfen	\N
3	Pulvermischung	\N
4	Trinkampullen	\N
5	Kurprogramme	\N
6	Kosmetik	\N
7	Körperpflege	\N
9	Prospekte	\N
8	Werbeartikel	\N
10	Akademie	\N
\.






--
-- Data for Name: cc_org; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY cc_org (id, org) FROM stdin;
1	Mastercard
2	Visa
\.





--
-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY country (country_code, country_post_code, name, tel_code, freight_art_id, vat1, vat2, vat3, vat4, vat5, vatbonus, tax_id, "comment", default_store_id) FROM stdin;
AT	A	Österreich	43   	\N	10	20	0	0	0	0	0	\N	\N
\.





--
-- Data for Name: language; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY "language" (id, descr) FROM stdin;
1	Deutsch
2	Englisch
\.



--
-- Data for Name: level_address; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY level_address (id, descr) FROM stdin;
1	Herr
2	Frau
\.


--
-- Data for Name: options; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY options (trade_margin_customer, trade_margin_vip, trade_margin_distributor, customer_service) FROM stdin;
25	5	0	10
\.


--
-- Data for Name: order_header; Type: TABLE DATA; Schema: public; Owner: evolution
--




--
-- Data for Name: order_status; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY order_status (id, descr, next_process) FROM stdin;
20	akzeptierte Bestellung	offenen Betrag einfordern
10	offene Bestellung	Bestellungen akzeptieren
30	in Bezahlung befindliche   Bestellung	Zahlungeingänge überprüfen
40	zur Auslieferung freigegebene Bestellung	Rechnung und Lieferschein erstellen
50	Bestellung zur Lieferung bereit	Bestellung ausliefern
60	Bestellung ausgeliefert	\N
90	Vestellung storniert	\N
\.


--
-- Data for Name: order_status_history; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY order_status_history (id, order_id, from_order_status, to_order_status, from_payment_status, to_payment_status, status_changed_date, status_changed_by) FROM stdin;
\.


--
-- Data for Name: order_type; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY order_type (id, descr) FROM stdin;
3	normal
2	internet
1	abo
\.


--
-- Data for Name: payment_method; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY payment_method (id, descr) FROM stdin;
1	Kreditkarte
2	Bankeinzug
3	Vorauskassa
4	Nachnahme
5	Provisionsminderung
\.







--
-- Data for Name: shipping; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY shipping (id, descr) FROM stdin;
1	Post
2	Bahn
3	Selbstabholer
\.




--
-- Data for Name: title; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY title (id, descr) FROM stdin;
1	Dr.
\.


--
-- Distributor Typen
--

COPY distributor_type (id, descr) FROM stdin;
e	evolution
c	customer
d	distributor
m	manager
\.


--
-- Data for Name: user_roles; Type: TABLE DATA; Schema: public; Owner: evolution
--

COPY user_roles (id, descr, dist_type) FROM stdin;
0	admin	e
100	Kunde	c
200	VIP Kunde	c
300	Distributor	d
1	Call Center Agent	e
2	Evolution Mitarbeiter	e
1400	Royal Platin	m
1300	Royal Diamond	m
1200	Präsident	m
1100	Vizepräsident	m
1000	Exectuive Director	m
800	Executive Manager	m
900	Director	m
700	Sales Manager	m
600	Manager	m
500	Teamleader	d
400	Consultant	d
\.


