341 lines
8.4 KiB
SQL
341 lines
8.4 KiB
SQL
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
\restrict qPYCKqc0gA0nEvolSKRPL74eJMR5SZBNcEw7S0IbNZuXEYe9ClpV3DwQtHZJYdY
|
|
|
|
-- Dumped from database version 18.4 (Debian 18.4-1.pgdg13+1)
|
|
-- Dumped by pg_dump version 18.4 (Debian 18.4-1.pgdg13+1)
|
|
|
|
SET statement_timeout = 0;
|
|
SET lock_timeout = 0;
|
|
SET idle_in_transaction_session_timeout = 0;
|
|
SET transaction_timeout = 0;
|
|
SET client_encoding = 'UTF8';
|
|
SET standard_conforming_strings = on;
|
|
SELECT pg_catalog.set_config('search_path', '', false);
|
|
SET check_function_bodies = false;
|
|
SET xmloption = content;
|
|
SET client_min_messages = warning;
|
|
SET row_security = off;
|
|
|
|
--
|
|
-- Name: global_id_seq; Type: SEQUENCE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE SEQUENCE public.global_id_seq
|
|
START WITH 1000000
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER SEQUENCE public.global_id_seq OWNER TO tsindt;
|
|
|
|
SET default_tablespace = '';
|
|
|
|
SET default_table_access_method = heap;
|
|
|
|
--
|
|
-- Name: media; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.media (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
description text,
|
|
media text,
|
|
mediatype text,
|
|
externalid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.media OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: productgroups; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.productgroups (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
description text,
|
|
parentgroupid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.productgroups OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: products; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.products (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
externalid text,
|
|
description text,
|
|
productgroupid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.products OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: properties; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.properties (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) CONSTRAINT propertys_id_not_null NOT NULL,
|
|
label text,
|
|
description text,
|
|
propertytypeid bigint,
|
|
productid bigint,
|
|
productgroupid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.properties OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: propertytypegroups; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.propertytypegroups (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
description text,
|
|
parentgroupid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.propertytypegroups OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: propertytypes; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public.propertytypes (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
description text,
|
|
propertytypegroupid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public.propertytypes OWNER TO tsindt;
|
|
|
|
--
|
|
-- Name: values; Type: TABLE; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
CREATE TABLE public."values" (
|
|
id bigint DEFAULT nextval('public.global_id_seq'::regclass) NOT NULL,
|
|
label text,
|
|
description text,
|
|
propertyid bigint
|
|
);
|
|
|
|
|
|
ALTER TABLE public."values" OWNER TO tsindt;
|
|
|
|
--
|
|
-- Data for Name: media; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.media (id, label, description, media, mediatype, externalid) FROM stdin;
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: productgroups; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.productgroups (id, label, description, parentgroupid) FROM stdin;
|
|
1000007 Simply CPQ Product catalog root 0
|
|
1000008 Catalog Product catalog 1000007
|
|
1000009 Components Components catalog 1000007
|
|
1000028 Radio Radios for Home Stereo 1000008
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.products (id, label, externalid, description, productgroupid) FROM stdin;
|
|
1000040 Transitorradio AEG 4711 modern radio 1000028
|
|
1000049 Röhrenradio Siemens 0815 Old radio 1000028
|
|
1000058 Hifiradio Kennwood 5969 Hifi stereo radio 1000028
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: properties; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.properties (id, label, description, propertytypeid, productid, productgroupid) FROM stdin;
|
|
1000024 Colour System wide colors 1000003 0 1000008
|
|
1000029 Colour System wide colors 1000003 0 1000028
|
|
1000033 voltage Voltage for home usage 1000010 0 1000028
|
|
1000041 Colour System wide colors 1000003 1000040 1000028
|
|
1000045 voltage Voltage for home usage 1000010 1000040 1000028
|
|
1000050 Colour System wide colors 1000003 1000049 1000028
|
|
1000054 voltage Voltage for home usage 1000010 1000049 1000028
|
|
1000059 Colour System wide colors 1000003 1000058 1000028
|
|
1000063 voltage Voltage for home usage 1000010 1000058 1000028
|
|
1000067 Colour System wide colors 1000003 1000058 1000028
|
|
1000071 voltage Voltage for home usage 1000010 1000058 1000028
|
|
1000075 Colour System wide colors 1000003 1000058 1000028
|
|
1000079 voltage Voltage for home usage 1000010 1000058 1000028
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: propertytypegroups; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.propertytypegroups (id, label, description, parentgroupid) FROM stdin;
|
|
1000000 Simply CPQ Root Gruppe für den Merkmalspool 0
|
|
1000001 System Property Types Systemweite Property-Typen werden hier abgelegt 1000000
|
|
1000002 Product Property Types Produkt-relevante Property-Typen werden hier abgelegt 1000000
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: propertytypes; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public.propertytypes (id, label, description, propertytypegroupid) FROM stdin;
|
|
1000003 Colour System wide colors 1000002
|
|
1000010 voltage Voltage for home usage 1000002
|
|
\.
|
|
|
|
|
|
--
|
|
-- Data for Name: values; Type: TABLE DATA; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
COPY public."values" (id, label, description, propertyid) FROM stdin;
|
|
1000004 Red Color Red 1000003
|
|
1000005 Green Color Green 1000003
|
|
1000006 Blue Color Blue 1000003
|
|
1000011 12 V 1000010
|
|
1000012 24 V 1000010
|
|
1000013 110 V 1000010
|
|
1000014 240 V 1000010
|
|
1000015 440 V 1000010
|
|
1000025 Red Color Red 1000024
|
|
1000026 Green Color Green 1000024
|
|
1000027 Blue Color Blue 1000024
|
|
1000030 Red Color Red 1000029
|
|
1000031 Green Color Green 1000029
|
|
1000032 Blue Color Blue 1000029
|
|
1000034 12 V 1000033
|
|
1000035 24 V 1000033
|
|
1000037 240 V 1000033
|
|
1000039 Yellow Color Yellow 1000003
|
|
1000042 Red Color Red 1000041
|
|
1000043 Green Color Green 1000041
|
|
1000044 Blue Color Blue 1000041
|
|
1000046 12 V 1000045
|
|
1000047 24 V 1000045
|
|
1000048 240 V 1000045
|
|
1000051 Red Color Red 1000050
|
|
1000052 Green Color Green 1000050
|
|
1000053 Blue Color Blue 1000050
|
|
1000055 12 V 1000054
|
|
1000056 24 V 1000054
|
|
1000057 240 V 1000054
|
|
1000060 Red Color Red 1000059
|
|
1000061 Green Color Green 1000059
|
|
1000062 Blue Color Blue 1000059
|
|
1000064 12 V 1000063
|
|
1000065 24 V 1000063
|
|
1000066 240 V 1000063
|
|
1000068 Red Color Red 1000067
|
|
1000069 Green Color Green 1000067
|
|
1000070 Blue Color Blue 1000067
|
|
1000072 12 V 1000071
|
|
1000073 24 V 1000071
|
|
1000074 240 V 1000071
|
|
1000076 Red Color Red 1000075
|
|
1000077 Green Color Green 1000075
|
|
1000078 Blue Color Blue 1000075
|
|
1000080 12 V 1000079
|
|
1000081 24 V 1000079
|
|
1000082 240 V 1000079
|
|
\.
|
|
|
|
|
|
--
|
|
-- Name: global_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.global_id_seq', 1000082, true);
|
|
|
|
|
|
--
|
|
-- Name: media media_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.media
|
|
ADD CONSTRAINT media_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: productgroups productgroups_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.productgroups
|
|
ADD CONSTRAINT productgroups_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.products
|
|
ADD CONSTRAINT products_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: properties propertys_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.properties
|
|
ADD CONSTRAINT propertys_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: propertytypegroups propertytypegroups_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.propertytypegroups
|
|
ADD CONSTRAINT propertytypegroups_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: propertytypes propertytypes_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public.propertytypes
|
|
ADD CONSTRAINT propertytypes_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- Name: values values_pkey; Type: CONSTRAINT; Schema: public; Owner: tsindt
|
|
--
|
|
|
|
ALTER TABLE ONLY public."values"
|
|
ADD CONSTRAINT values_pkey PRIMARY KEY (id);
|
|
|
|
|
|
--
|
|
-- PostgreSQL database dump complete
|
|
--
|
|
|
|
\unrestrict qPYCKqc0gA0nEvolSKRPL74eJMR5SZBNcEw7S0IbNZuXEYe9ClpV3DwQtHZJYdY
|
|
|