--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.0
-- Dumped by pg_dump version 9.6.0

-- Started on 2017-06-15 18:50:53

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 1 (class 3079 OID 12387)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 2149 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 186 (class 1259 OID 24689)
-- Name: Invoice; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE "Invoice" (
    "iID" integer NOT NULL,
    "Details" character varying(24) NOT NULL,
    "Price" double precision NOT NULL,
    "Discount" integer NOT NULL,
    "Processed" boolean NOT NULL,
    "Approved" boolean NOT NULL,
    "uID" integer NOT NULL
);


ALTER TABLE "Invoice" OWNER TO postgres;

--
-- TOC entry 187 (class 1259 OID 24701)
-- Name: Product; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE "Product" (
    "pID" integer NOT NULL,
    "Name" character varying(24) NOT NULL
);


ALTER TABLE "Product" OWNER TO postgres;

--
-- TOC entry 185 (class 1259 OID 24684)
-- Name: User; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE "User" (
    "uID" integer NOT NULL,
    "Username" character varying(24) NOT NULL,
    "Password" character varying(24) NOT NULL,
    "Admin" boolean NOT NULL,
    "Superadmin" boolean NOT NULL
);


ALTER TABLE "User" OWNER TO postgres;

--
-- TOC entry 190 (class 1259 OID 24712)
-- Name: invoice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE invoice_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE invoice_id_seq OWNER TO postgres;

--
-- TOC entry 189 (class 1259 OID 24710)
-- Name: product_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE product_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE product_id_seq OWNER TO postgres;

--
-- TOC entry 188 (class 1259 OID 24708)
-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE user_id_seq OWNER TO postgres;

--
-- TOC entry 2138 (class 0 OID 24689)
-- Dependencies: 186
-- Data for Name: Invoice; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO "Invoice" VALUES (4, 'Webcam', 250.5, 0, false, false, 7);
INSERT INTO "Invoice" VALUES (2, 'Smartphone', 765.20000000000005, 5, true, true, 5);
INSERT INTO "Invoice" VALUES (5, 'Monitor', 632.39999999999998, 0, false, false, 8);
INSERT INTO "Invoice" VALUES (0, 'Laptop', 1350.5999999999999, 0, false, false, 3);
INSERT INTO "Invoice" VALUES (8, 'ArduinoUNO', 200.5, 0, false, false, 4);
INSERT INTO "Invoice" VALUES (7, 'PC', 1850.4000000000001, 0, false, false, 3);
INSERT INTO "Invoice" VALUES (6, 'Headset', 465.69999999999999, 0, false, false, 9);
INSERT INTO "Invoice" VALUES (9, 'Modem', 245.5, 0, false, false, 5);
INSERT INTO "Invoice" VALUES (10, 'DummyInvoice', 224.69999999999999, 15, true, true, 6);
INSERT INTO "Invoice" VALUES (3, 'Tastatura', 214.30000000000001, 25, true, true, 6);
INSERT INTO "Invoice" VALUES (1, 'Mouse', 25.699999999999999, 0, false, false, 4);


--
-- TOC entry 2139 (class 0 OID 24701)
-- Dependencies: 187
-- Data for Name: Product; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO "Product" VALUES (1, 'Mouse');
INSERT INTO "Product" VALUES (3, 'Tastatura');
INSERT INTO "Product" VALUES (2, 'Smartphone');
INSERT INTO "Product" VALUES (0, 'Laptop');
INSERT INTO "Product" VALUES (4, 'Webcam');
INSERT INTO "Product" VALUES (8, 'ArduinoUNO');
INSERT INTO "Product" VALUES (5, 'Monitor');
INSERT INTO "Product" VALUES (7, 'PC');
INSERT INTO "Product" VALUES (6, 'Headset');
INSERT INTO "Product" VALUES (9, 'Modem');


--
-- TOC entry 2137 (class 0 OID 24684)
-- Dependencies: 185
-- Data for Name: User; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO "User" VALUES (0, 'Eduard', 'password1', true, true);
INSERT INTO "User" VALUES (4, 'Alex', 'password5', false, false);
INSERT INTO "User" VALUES (8, 'Tudor', 'password9', false, false);
INSERT INTO "User" VALUES (9, 'Mihai', 'password10', false, false);
INSERT INTO "User" VALUES (5, 'Radu', 'password6', false, false);
INSERT INTO "User" VALUES (6, 'Ungureanu', 'password7', false, false);
INSERT INTO "User" VALUES (1, 'Biro', 'password2', true, false);
INSERT INTO "User" VALUES (7, 'Remus', 'password8', false, false);
INSERT INTO "User" VALUES (2, 'Catalin', 'password3', true, false);
INSERT INTO "User" VALUES (3, 'Sebi', 'password4', false, false);


--
-- TOC entry 2150 (class 0 OID 0)
-- Dependencies: 190
-- Name: invoice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('invoice_id_seq', 10, true);


--
-- TOC entry 2151 (class 0 OID 0)
-- Dependencies: 189
-- Name: product_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('product_id_seq', 9, true);


--
-- TOC entry 2152 (class 0 OID 0)
-- Dependencies: 188
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('user_id_seq', 9, true);


--
-- TOC entry 2016 (class 2606 OID 24724)
-- Name: Invoice Invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY "Invoice"
    ADD CONSTRAINT "Invoices_pkey" PRIMARY KEY ("iID");


--
-- TOC entry 2018 (class 2606 OID 24722)
-- Name: Product Products_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY "Product"
    ADD CONSTRAINT "Products_pkey" PRIMARY KEY ("pID");


--
-- TOC entry 2014 (class 2606 OID 24715)
-- Name: User Users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY "User"
    ADD CONSTRAINT "Users_pkey" PRIMARY KEY ("uID");


--
-- TOC entry 2019 (class 2606 OID 24725)
-- Name: Invoice Invoices_BuyerID_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY "Invoice"
    ADD CONSTRAINT "Invoices_BuyerID_fkey" FOREIGN KEY ("uID") REFERENCES "User"("uID");


-- Completed on 2017-06-15 18:50:53

--
-- PostgreSQL database dump complete
--