--
-- PostgreSQL database dump
--

-- Started on 2008-09-05 14:08:50

SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1635 (class 0 OID 0)
-- Dependencies: 4
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- TOC entry 270 (class 2612 OID 16386)
-- 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;

--
-- TOC entry 1276 (class 1259 OID 134238)
-- Dependencies: 4
-- Name: customer; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE customer (
    id_customer integer NOT NULL,
    name character varying(50) NOT NULL,
    last_name character varying(50) NOT NULL,
    company character varying(50),
    phone integer,
    address character varying(50)
);


ALTER TABLE public.customer OWNER TO postgres;

--
-- TOC entry 1275 (class 1259 OID 134236)
-- Dependencies: 1276 4
-- Name: customer_id_customer_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE customer_id_customer_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.customer_id_customer_seq OWNER TO postgres;

--
-- TOC entry 1637 (class 0 OID 0)
-- Dependencies: 1275
-- Name: customer_id_customer_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE customer_id_customer_seq OWNED BY customer.id_customer;


--
-- TOC entry 1638 (class 0 OID 0)
-- Dependencies: 1275
-- Name: customer_id_customer_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('customer_id_customer_seq', 6, true);


--
-- TOC entry 1282 (class 1259 OID 134267)
-- Dependencies: 4
-- Name: detail_sales; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE detail_sales (
    id_detail integer NOT NULL,
    id_master integer,
    quantity integer,
    id_product integer
);


ALTER TABLE public.detail_sales OWNER TO postgres;

--
-- TOC entry 1281 (class 1259 OID 134265)
-- Dependencies: 1282 4
-- Name: detail_sales_id_detail_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE detail_sales_id_detail_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.detail_sales_id_detail_seq OWNER TO postgres;

--
-- TOC entry 1639 (class 0 OID 0)
-- Dependencies: 1281
-- Name: detail_sales_id_detail_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE detail_sales_id_detail_seq OWNED BY detail_sales.id_detail;


--
-- TOC entry 1640 (class 0 OID 0)
-- Dependencies: 1281
-- Name: detail_sales_id_detail_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('detail_sales_id_detail_seq', 61, true);


--
-- TOC entry 1280 (class 1259 OID 134255)
-- Dependencies: 4
-- Name: master_sales; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE master_sales (
    id_master integer NOT NULL,
    date_sale date,
    id_customer integer NOT NULL
);


ALTER TABLE public.master_sales OWNER TO postgres;

--
-- TOC entry 1279 (class 1259 OID 134253)
-- Dependencies: 4 1280
-- Name: master_sales_id_master_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE master_sales_id_master_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.master_sales_id_master_seq OWNER TO postgres;

--
-- TOC entry 1641 (class 0 OID 0)
-- Dependencies: 1279
-- Name: master_sales_id_master_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE master_sales_id_master_seq OWNED BY master_sales.id_master;


--
-- TOC entry 1642 (class 0 OID 0)
-- Dependencies: 1279
-- Name: master_sales_id_master_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('master_sales_id_master_seq', 62, true);


--
-- TOC entry 1278 (class 1259 OID 134245)
-- Dependencies: 4
-- Name: product; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE product (
    id_product integer NOT NULL,
    name character varying(50) NOT NULL,
    price numeric,
    industry character varying(50)
);


ALTER TABLE public.product OWNER TO postgres;

--
-- TOC entry 1277 (class 1259 OID 134243)
-- Dependencies: 4 1278
-- Name: product_id_product_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE product_id_product_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.product_id_product_seq OWNER TO postgres;

--
-- TOC entry 1643 (class 0 OID 0)
-- Dependencies: 1277
-- Name: product_id_product_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE product_id_product_seq OWNED BY product.id_product;


--
-- TOC entry 1644 (class 0 OID 0)
-- Dependencies: 1277
-- Name: product_id_product_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- TOC entry 1613 (class 2604 OID 134240)
-- Dependencies: 1276 1275 1276
-- Name: id_customer; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE customer ALTER COLUMN id_customer SET DEFAULT nextval('customer_id_customer_seq'::regclass);


--
-- TOC entry 1616 (class 2604 OID 134269)
-- Dependencies: 1281 1282 1282
-- Name: id_detail; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE detail_sales ALTER COLUMN id_detail SET DEFAULT nextval('detail_sales_id_detail_seq'::regclass);


--
-- TOC entry 1615 (class 2604 OID 134257)
-- Dependencies: 1279 1280 1280
-- Name: id_master; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE master_sales ALTER COLUMN id_master SET DEFAULT nextval('master_sales_id_master_seq'::regclass);


--
-- TOC entry 1614 (class 2604 OID 134247)
-- Dependencies: 1278 1277 1278
-- Name: id_product; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE product ALTER COLUMN id_product SET DEFAULT nextval('product_id_product_seq'::regclass);


--
-- TOC entry 1628 (class 0 OID 134238)
-- Dependencies: 1276
-- Data for Name: customer; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (2, 'Carlos', 'Lopez', 'Crokan Pollo', NULL, NULL);
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (4, 'Maria', 'Juarez', 'UAJMS', 2312311, NULL);
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (5, 'Luis', 'Torrez', 'none', NULL, NULL);
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (6, 'Hugo', 'Ojeda', 'none', NULL, 'San Marco 123');
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (3, 'Nadia', 'Ramos', 'PREFECTURA DE TARIJA', NULL, 'Av. La Paz 342');
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (1, 'Juan', 'Paez', 'UAJMS', NULL, 'Ecuador 987');
INSERT INTO customer (id_customer, name, last_name, company, phone, address) VALUES (0, 'Customer', 'New', '- ', NULL, NULL);


--
-- TOC entry 1631 (class 0 OID 134267)
-- Dependencies: 1282
-- Data for Name: detail_sales; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (56, 60, 63, 3);
INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (57, 60, 14, 9);
INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (58, 61, 21, 3);
INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (59, 61, 45, 8);
INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (60, 62, 147, 3);
INSERT INTO detail_sales (id_detail, id_master, quantity, id_product) VALUES (61, 62, 63, 2);


--
-- TOC entry 1630 (class 0 OID 134255)
-- Dependencies: 1280
-- Data for Name: master_sales; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO master_sales (id_master, date_sale, id_customer) VALUES (60, '2008-09-26', 5);
INSERT INTO master_sales (id_master, date_sale, id_customer) VALUES (61, '2008-09-27', 1);
INSERT INTO master_sales (id_master, date_sale, id_customer) VALUES (62, '2008-09-30', 2);


--
-- TOC entry 1629 (class 0 OID 134245)
-- Dependencies: 1278
-- Data for Name: product; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO product (id_product, name, price, industry) VALUES (1, 'Milk', 10, 'Pil Tarija');
INSERT INTO product (id_product, name, price, industry) VALUES (2, 'Bred', 20, 'Lactal');
INSERT INTO product (id_product, name, price, industry) VALUES (3, 'CD', 50, 'HP');
INSERT INTO product (id_product, name, price, industry) VALUES (4, 'Soda', 50, 'La Cascada');
INSERT INTO product (id_product, name, price, industry) VALUES (5, 'Wine', 30, 'Kolberg');
INSERT INTO product (id_product, name, price, industry) VALUES (6, 'Burgers', 10, 'Fridosa');
INSERT INTO product (id_product, name, price, industry) VALUES (7, 'Medical pill', 50, 'BioFarm');
INSERT INTO product (id_product, name, price, industry) VALUES (8, 'Yogurt', 22, 'Prolac');
INSERT INTO product (id_product, name, price, industry) VALUES (9, 'Chickens Legs', 23, 'La Granja');


--
-- TOC entry 1618 (class 2606 OID 134242)
-- Dependencies: 1276 1276
-- Name: customer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY customer
    ADD CONSTRAINT customer_pkey PRIMARY KEY (id_customer);


--
-- TOC entry 1624 (class 2606 OID 134271)
-- Dependencies: 1282 1282
-- Name: detail_sales_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY detail_sales
    ADD CONSTRAINT detail_sales_pkey PRIMARY KEY (id_detail);


--
-- TOC entry 1622 (class 2606 OID 134259)
-- Dependencies: 1280 1280
-- Name: master_sales_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY master_sales
    ADD CONSTRAINT master_sales_pkey PRIMARY KEY (id_master);


--
-- TOC entry 1620 (class 2606 OID 134252)
-- Dependencies: 1278 1278
-- Name: product_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY product
    ADD CONSTRAINT product_pkey PRIMARY KEY (id_product);


--
-- TOC entry 1626 (class 2606 OID 134272)
-- Dependencies: 1280 1621 1282
-- Name: detail_sales_id_master_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY detail_sales
    ADD CONSTRAINT detail_sales_id_master_fkey FOREIGN KEY (id_master) REFERENCES master_sales(id_master);


--
-- TOC entry 1627 (class 2606 OID 134277)
-- Dependencies: 1619 1282 1278
-- Name: detail_sales_id_product_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY detail_sales
    ADD CONSTRAINT detail_sales_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id_product);


--
-- TOC entry 1625 (class 2606 OID 134260)
-- Dependencies: 1617 1280 1276
-- Name: master_sales_id_customer_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY master_sales
    ADD CONSTRAINT master_sales_id_customer_fkey FOREIGN KEY (id_customer) REFERENCES customer(id_customer);


--
-- TOC entry 1636 (class 0 OID 0)
-- Dependencies: 4
-- 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 postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2008-09-05 14:08:51

--
-- PostgreSQL database dump complete
--