[FIX] base_import: example files

SQL dump:
- Recent export with -O to remove owners
- correct poor Ramzy name

purchase order CSV:
- use correct column names
- remove destination and pricelist columns
- first file should not contain order lines
- second file should be same as first + lines

1 files changed, 59 insertions, 39 deletions

diff --git a/addons/base_import/static/csv/database_import_test.sql b/addons/base_import/static/csv/database_import_test.sql
index 1f79179145e..13a735d106d 100644
--- a/addons/base_import/static/csv/database_import_test.sql
+++ b/addons/base_import/static/csv/database_import_test.sql
@@ -2,12 +2,30 @@
 -- PostgreSQL database dump
 --
 
+-- Dumped from database version 9.5.2
+-- Dumped by pg_dump version 9.5.2
+
 SET statement_timeout = 0;
+SET lock_timeout = 0;
 SET client_encoding = 'UTF8';
-SET standard_conforming_strings = off;
+SET standard_conforming_strings = on;
 SET check_function_bodies = false;
 SET client_min_messages = warning;
-SET escape_string_warning = off;
+SET row_security = off;
+
+--
+-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
+--
+
+CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
+
+
+--
+-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
+--
+
+COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
+
 
 SET search_path = public, pg_catalog;
 
@@ -16,7 +34,7 @@ SET default_tablespace = '';
 SET default_with_oids = false;
 
 --
--- Name: companies; Type: TABLE; Schema: public; Owner: fp; Tablespace: 
+-- Name: companies; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE companies (
@@ -25,38 +43,27 @@ CREATE TABLE companies (
 );
 
 
-ALTER TABLE public.companies OWNER TO fp;
-
 --
--- Name: companies_id_seq; Type: SEQUENCE; Schema: public; Owner: fp
+-- Name: companies_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
 CREATE SEQUENCE companies_id_seq
     START WITH 1
     INCREMENT BY 1
-    NO MAXVALUE
     NO MINVALUE
+    NO MAXVALUE
     CACHE 1;
 
 
-ALTER TABLE public.companies_id_seq OWNER TO fp;
-
 --
--- Name: companies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fp
+-- Name: companies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
 --
 
 ALTER SEQUENCE companies_id_seq OWNED BY companies.id;
 
 
 --
--- Name: companies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fp
---
-
-SELECT pg_catalog.setval('companies_id_seq', 3, true);
-
-
---
--- Name: persons; Type: TABLE; Schema: public; Owner: fp; Tablespace: 
+-- Name: persons; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE persons (
@@ -66,52 +73,41 @@ CREATE TABLE persons (
 );
 
 
-ALTER TABLE public.persons OWNER TO fp;
-
 --
--- Name: persons_id_seq; Type: SEQUENCE; Schema: public; Owner: fp
+-- Name: persons_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
 CREATE SEQUENCE persons_id_seq
     START WITH 1
     INCREMENT BY 1
-    NO MAXVALUE
     NO MINVALUE
+    NO MAXVALUE
     CACHE 1;
 
 
-ALTER TABLE public.persons_id_seq OWNER TO fp;
-
 --
--- Name: persons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fp
+-- Name: persons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
 --
 
 ALTER SEQUENCE persons_id_seq OWNED BY persons.id;
 
 
 --
--- Name: persons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: fp
---
-
-SELECT pg_catalog.setval('persons_id_seq', 4, true);
-
-
---
--- Name: id; Type: DEFAULT; Schema: public; Owner: fp
+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY companies ALTER COLUMN id SET DEFAULT nextval('companies_id_seq'::regclass);
 
 
 --
--- Name: id; Type: DEFAULT; Schema: public; Owner: fp
+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY persons ALTER COLUMN id SET DEFAULT nextval('persons_id_seq'::regclass);
 
 
 --
--- Data for Name: companies; Type: TABLE DATA; Schema: public; Owner: fp
+-- Data for Name: companies; Type: TABLE DATA; Schema: public; Owner: -
 --
 
 COPY companies (id, company_name) FROM stdin;
@@ -122,19 +118,33 @@ COPY companies (id, company_name) FROM stdin;
 
 
 --
--- Data for Name: persons; Type: TABLE DATA; Schema: public; Owner: fp
+-- Name: companies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
+--
+
+SELECT pg_catalog.setval('companies_id_seq', 3, true);
+
+
+--
+-- Data for Name: persons; Type: TABLE DATA; Schema: public; Owner: -
 --
 
 COPY persons (id, company_id, person_name) FROM stdin;
 1	1	Fabien
 2	1	Laurence
 3	2	Eric
-4	3	Ramsy
+4	3	Ramzy
 \.
 
 
 --
--- Name: companies_pkey; Type: CONSTRAINT; Schema: public; Owner: fp; Tablespace: 
+-- Name: persons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
+--
+
+SELECT pg_catalog.setval('persons_id_seq', 4, true);
+
+
+--
+-- Name: companies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY companies
@@ -142,7 +152,7 @@ ALTER TABLE ONLY companies
 
 
 --
--- Name: persons_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: fp
+-- Name: persons_company_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY persons
@@ -150,6 +160,16 @@ ALTER TABLE ONLY persons
 
 
 --
+-- Name: public; Type: ACL; Schema: -; Owner: -
+--
+
+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;
+
+
+--
 -- PostgreSQL database dump complete
 --