-- -- PostgreSQL database dump -- SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; -- -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres -- CREATE PROCEDURAL LANGUAGE plpgsql; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: spr_group; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE spr_group ( group_id integer NOT NULL, group_name character varying(255) NOT NULL, group_sysname character varying(50) NOT NULL ); ALTER TABLE public.spr_group OWNER TO postgres; -- -- Name: spr_group_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE spr_group_group_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.spr_group_group_id_seq OWNER TO postgres; -- -- Name: spr_group_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE spr_group_group_id_seq OWNED BY spr_group.group_id; -- -- Name: spr_group_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('spr_group_group_id_seq', 6, true); -- -- Name: spr_user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE spr_user ( user_id integer NOT NULL, user_login character varying(25) NOT NULL, user_password character varying(250), user_name character varying(250) NOT NULL, user_sign character varying(250) NOT NULL ); ALTER TABLE public.spr_user OWNER TO postgres; -- -- Name: spr_usergroup; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE spr_usergroup ( usergroup_id integer NOT NULL, usergroup_user_id integer NOT NULL, usergroup_group_id integer NOT NULL ); ALTER TABLE public.spr_usergroup OWNER TO postgres; -- -- Name: spr_user_group_user_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE spr_user_group_user_group_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.spr_user_group_user_group_id_seq OWNER TO postgres; -- -- Name: spr_user_group_user_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE spr_user_group_user_group_id_seq OWNED BY spr_usergroup.usergroup_id; -- -- Name: spr_user_group_user_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('spr_user_group_user_group_id_seq', 48, true); -- -- Name: spr_user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE spr_user_user_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.spr_user_user_id_seq OWNER TO postgres; -- -- Name: spr_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE spr_user_user_id_seq OWNED BY spr_user.user_id; -- -- Name: spr_user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('spr_user_user_id_seq', 37, true); -- -- Name: group_id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE spr_group ALTER COLUMN group_id SET DEFAULT nextval('spr_group_group_id_seq'::regclass); -- -- Name: user_id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE spr_user ALTER COLUMN user_id SET DEFAULT nextval('spr_user_user_id_seq'::regclass); -- -- Name: usergroup_id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE spr_usergroup ALTER COLUMN usergroup_id SET DEFAULT nextval('spr_user_group_user_group_id_seq'::regclass); -- -- Data for Name: spr_group; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY spr_group (group_id, group_name, group_sysname) FROM stdin; 1 Administrator ADMINISTRATOR 2 Manager MANAGER 3 Storeman STOREMAN 4 Analyst ANALYST 5 Guest GUEST \. -- -- Data for Name: spr_user; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY spr_user (user_id, user_login, user_password, user_name, user_sign) FROM stdin; 2 manager d41d8cd98f00b204e9800998ecf8427e Manager - 1 admin d41d8cd98f00b204e9800998ecf8427e Admin - 3 storeman d41d8cd98f00b204e9800998ecf8427e Storeman - 4 analyst d41d8cd98f00b204e9800998ecf8427e\n Analyst - 5 boss d41d8cd98f00b204e9800998ecf8427e Boss - \. -- -- Data for Name: spr_usergroup; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY spr_usergroup (usergroup_id, usergroup_user_id, usergroup_group_id) FROM stdin; 14 1 1 18 3 3 20 4 4 22 5 2 24 5 3 28 5 4 \. -- -- Name: spr_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY spr_group ADD CONSTRAINT spr_group_pkey PRIMARY KEY (group_id); -- -- Name: spr_user_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY spr_usergroup ADD CONSTRAINT spr_user_group_pkey PRIMARY KEY (usergroup_id); -- -- Name: spr_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY spr_user ADD CONSTRAINT spr_user_pkey PRIMARY KEY (user_id); -- -- Name: idx_group_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX idx_group_id ON spr_usergroup USING btree (usergroup_group_id); -- -- Name: idx_user_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX idx_user_id ON spr_usergroup USING btree (usergroup_user_id); -- -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --