· 7 years ago · Oct 09, 2018, 03:00 AM
1f69fd93e9544f78eaa31ecf6e62cc6278a8fca4b089384b654bc65120f19af06
2--
3-- PostgreSQL database dump
4--
5
6-- Dumped from database version 9.1.3
7-- Dumped by pg_dump version 9.1.3
8-- Started on 2012-11-03 22:41:22
9
10SET statement_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15
16--
17-- TOC entry 169 (class 3079 OID 11639)
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- TOC entry 1893 (class 0 OID 0)
26-- Dependencies: 169
27-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
28--
29
30COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
31
32
33SET search_path = public, pg_catalog;
34
35SET default_tablespace = '';
36
37SET default_with_oids = false;
38
39--
40-- TOC entry 166 (class 1259 OID 16537)
41-- Dependencies: 6
42-- Name: cargos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
43--
44
45CREATE TABLE cargos (
46 cargo_id character varying(10),
47 cargo_titulo character varying(35) NOT NULL,
48 sueldo_min integer,
49 sueldo_max integer
50);
51
52
53ALTER TABLE public.cargos OWNER TO postgres;
54
55--
56-- TOC entry 162 (class 1259 OID 16523)
57-- Dependencies: 6
58-- Name: departamentos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
59--
60
61CREATE TABLE departamentos (
62 departamento_id integer,
63 departamento_nombre character varying(30) NOT NULL,
64 gerente_id integer,
65 ubicacion_id integer
66);
67
68
69ALTER TABLE public.departamentos OWNER TO postgres;
70
71--
72-- TOC entry 163 (class 1259 OID 16526)
73-- Dependencies: 1874 6
74-- Name: empleados; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
75--
76
77CREATE TABLE empleados (
78 empleado_id integer,
79 nombres character varying(20),
80 apellidos character varying(25) NOT NULL,
81 email character varying(25) NOT NULL,
82 telefono character varying(20),
83 fecha_contrato date NOT NULL,
84 cargo_id character varying(10) NOT NULL,
85 sueldo numeric(8,2),
86 porc_comision numeric(2,2),
87 gerente_id integer,
88 departamento_id integer,
89 CONSTRAINT emp_salary_min CHECK ((sueldo > (0)::numeric))
90);
91
92
93ALTER TABLE public.empleados OWNER TO postgres;
94
95--
96-- TOC entry 164 (class 1259 OID 16530)
97-- Dependencies: 6
98-- Name: job_grades; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
99--
100
101CREATE TABLE job_grades (
102 grade_level character varying(3),
103 lowest_sal integer,
104 highest_sal integer
105);
106
107
108ALTER TABLE public.job_grades OWNER TO postgres;
109
110--
111-- TOC entry 165 (class 1259 OID 16533)
112-- Dependencies: 1875 6
113-- Name: job_history; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
114--
115
116CREATE TABLE job_history (
117 employee_id integer NOT NULL,
118 start_date date NOT NULL,
119 end_date date NOT NULL,
120 job_id character varying(10) NOT NULL,
121 department_id integer,
122 CONSTRAINT jhist_date_interval CHECK ((end_date > start_date))
123);
124
125
126ALTER TABLE public.job_history OWNER TO postgres;
127
128--
129-- TOC entry 161 (class 1259 OID 16520)
130-- Dependencies: 6
131-- Name: paises; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
132--
133
134CREATE TABLE paises (
135 pais_id character(2) NOT NULL,
136 pais_nombre character varying(40),
137 region_id integer
138);
139
140
141ALTER TABLE public.paises OWNER TO postgres;
142
143--
144-- TOC entry 168 (class 1259 OID 16543)
145-- Dependencies: 6
146-- Name: regiones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
147--
148
149CREATE TABLE regiones (
150 region_id integer NOT NULL,
151 region_nombre character varying(25)
152);
153
154
155ALTER TABLE public.regiones OWNER TO postgres;
156
157--
158-- TOC entry 167 (class 1259 OID 16540)
159-- Dependencies: 6
160-- Name: ubicaciones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
161--
162
163CREATE TABLE ubicaciones (
164 ubicacion_id integer,
165 direccion character varying(40),
166 codigo_postal character varying(12),
167 ciudad character varying(30) NOT NULL,
168 provincia_estatal character varying(25),
169 pais_id character(2)
170);
171
172
173ALTER TABLE public.ubicaciones OWNER TO postgres;
174
175--
176-- TOC entry 1885 (class 0 OID 16537)
177-- Dependencies: 166
178-- Data for Name: cargos; Type: TABLE DATA; Schema: public; Owner: postgres
179--
180
181COPY cargos (cargo_id, cargo_titulo, sueldo_min, sueldo_max) FROM stdin;
182AD_PRES President 20000 40000
183AD_VP Administration Vice President 15000 30000
184AD_ASST Administration Assistant 3000 6000
185FI_MGR Finance Manager 8200 16000
186FI_ACCOUNT Accountant 4200 9000
187AC_MGR Accounting Manager 8200 16000
188AC_ACCOUNT Public Accountant 4200 9000
189SA_MAN Sales Manager 10000 20000
190SA_REP Sales Representative 6000 12000
191PU_MAN Purchasing Manager 8000 15000
192PU_CLERK Purchasing Clerk 2500 5500
193ST_MAN Stock Manager 5500 8500
194ST_CLERK Stock Clerk 2000 5000
195SH_CLERK Shipping Clerk 2500 5500
196IT_PROG Programmer 4000 10000
197MK_MAN Marketing Manager 9000 15000
198MK_REP Marketing Representative 4000 9000
199HR_REP Human Resources Representative 4000 9000
200PR_REP Public Relations Representative 4500 10500
201\.
202
203
204--
205-- TOC entry 1881 (class 0 OID 16523)
206-- Dependencies: 162
207-- Data for Name: departamentos; Type: TABLE DATA; Schema: public; Owner: postgres
208--
209
210COPY departamentos (departamento_id, departamento_nombre, gerente_id, ubicacion_id) FROM stdin;
21110 Administration 200 1700
21220 Marketing 201 1800
21330 Purchasing 114 1700
21440 Human Resources 203 2400
21550 Shipping 121 1500
21660 IT 103 1400
21770 Public Relations 204 2700
21880 Sales 145 2500
21990 Executive 100 1700
220100 Finance 108 1700
221110 Accounting 205 1700
222120 Treasury \N 1700
223130 Corporate Tax \N 1700
224140 Control And Credit \N 1700
225150 Shareholder Services \N 1700
226160 Benefits \N 1700
227170 Manufacturing \N 1700
228180 Construction \N 1700
229190 Contracting \N 1700
230200 Operations \N 1700
231210 IT Support \N 1700
232220 NOC \N 1700
233230 IT Helpdesk \N 1700
234240 Government Sales \N 1700
235250 Retail Sales \N 1700
236260 Recruiting \N 1700
237270 Payroll \N 1700
238\.
239
240
241--
242-- TOC entry 1882 (class 0 OID 16526)
243-- Dependencies: 163
244-- Data for Name: empleados; Type: TABLE DATA; Schema: public; Owner: postgres
245--
246
247COPY empleados (empleado_id, nombres, apellidos, email, telefono, fecha_contrato, cargo_id, sueldo, porc_comision, gerente_id, departamento_id) FROM stdin;
248100 Steven King SKING 515.123.4567 1987-06-17 AD_PRES 24000.00 \N \N 90
249101 Neena Kochhar NKOCHHAR 515.123.4568 1989-09-21 AD_VP 17000.00 \N 100 90
250102 Lex De Haan LDEHAAN 515.123.4569 1993-01-13 AD_VP 17000.00 \N 100 90
251103 Alexander Hunold AHUNOLD 590.423.4567 1990-01-03 IT_PROG 9000.00 \N 102 60
252104 Bruce Ernst BERNST 590.423.4568 1991-05-21 IT_PROG 6000.00 \N 103 60
253105 David Austin DAUSTIN 590.423.4569 1997-06-25 IT_PROG 4800.00 \N 103 60
254106 Valli Pataballa VPATABAL 590.423.4560 1998-02-05 IT_PROG 4800.00 \N 103 60
255107 Diana Lorentz DLORENTZ 590.423.5567 1999-02-07 IT_PROG 4200.00 \N 103 60
256108 Nancy Greenberg NGREENBE 515.124.4569 1994-08-17 FI_MGR 12000.00 \N 101 100
257109 Daniel Faviet DFAVIET 515.124.4169 1994-08-16 FI_ACCOUNT 9000.00 \N 108 100
258110 John Chen JCHEN 515.124.4269 1997-09-28 FI_ACCOUNT 8200.00 \N 108 100
259111 Ismael Sciarra ISCIARRA 515.124.4369 1997-09-30 FI_ACCOUNT 7700.00 \N 108 100
260112 Jose Manuel Urman JMURMAN 515.124.4469 1998-03-07 FI_ACCOUNT 7800.00 \N 108 100
261113 Luis Popp LPOPP 515.124.4567 1999-12-07 FI_ACCOUNT 6900.00 \N 108 100
262114 Den Raphaely DRAPHEAL 515.127.4561 1994-12-07 PU_MAN 11000.00 \N 100 30
263115 Alexander Khoo AKHOO 515.127.4562 1995-05-18 PU_CLERK 3100.00 \N 114 30
264116 Shelli Baida SBAIDA 515.127.4563 1997-12-24 PU_CLERK 2900.00 \N 114 30
265117 Sigal Tobias STOBIAS 515.127.4564 1997-07-24 PU_CLERK 2800.00 \N 114 30
266118 Guy Himuro GHIMURO 515.127.4565 1998-11-15 PU_CLERK 2600.00 \N 114 30
267119 Karen Colmenares KCOLMENA 515.127.4566 1999-08-10 PU_CLERK 2500.00 \N 114 30
268120 Matthew Weiss MWEISS 650.123.1234 1996-07-18 ST_MAN 8000.00 \N 100 50
269121 Adam Fripp AFRIPP 650.123.2234 1997-04-10 ST_MAN 8200.00 \N 100 50
270122 Payam Kaufling PKAUFLIN 650.123.3234 1995-05-01 ST_MAN 7900.00 \N 100 50
271123 Shanta Vollman SVOLLMAN 650.123.4234 1997-10-10 ST_MAN 6500.00 \N 100 50
272124 Kevin Mourgos KMOURGOS 650.123.5234 1999-11-16 ST_MAN 5800.00 \N 100 50
273125 Julia Nayer JNAYER 650.124.1214 1997-07-16 ST_CLERK 3200.00 \N 120 50
274126 Irene Mikkilineni IMIKKILI 650.124.1224 1998-09-28 ST_CLERK 2700.00 \N 120 50
275127 James Landry JLANDRY 650.124.1334 1999-01-14 ST_CLERK 2400.00 \N 120 50
276128 Steven Markle SMARKLE 650.124.1434 2000-03-08 ST_CLERK 2200.00 \N 120 50
277129 Laura Bissot LBISSOT 650.124.5234 1997-08-20 ST_CLERK 3300.00 \N 121 50
278130 Mozhe Atkinson MATKINSO 650.124.6234 1997-10-30 ST_CLERK 2800.00 \N 121 50
279131 James Marlow JAMRLOW 650.124.7234 1997-02-16 ST_CLERK 2500.00 \N 121 50
280132 TJ Olson TJOLSON 650.124.8234 1999-04-10 ST_CLERK 2100.00 \N 121 50
281133 Jason Mallin JMALLIN 650.127.1934 1996-06-14 ST_CLERK 3300.00 \N 122 50
282134 Michael Rogers MROGERS 650.127.1834 1998-08-26 ST_CLERK 2900.00 \N 122 50
283135 Ki Gee KGEE 650.127.1734 1999-12-12 ST_CLERK 2400.00 \N 122 50
284136 Hazel Philtanker HPHILTAN 650.127.1634 2000-02-06 ST_CLERK 2200.00 \N 122 50
285137 Renske Ladwig RLADWIG 650.121.1234 1995-07-14 ST_CLERK 3600.00 \N 123 50
286138 Stephen Stiles SSTILES 650.121.2034 1997-10-26 ST_CLERK 3200.00 \N 123 50
287139 John Seo JSEO 650.121.2019 1998-02-12 ST_CLERK 2700.00 \N 123 50
288140 Joshua Patel JPATEL 650.121.1834 1998-04-06 ST_CLERK 2500.00 \N 123 50
289141 Trenna Rajs TRAJS 650.121.8009 1995-10-17 ST_CLERK 3500.00 \N 124 50
290142 Curtis Davies CDAVIES 650.121.2994 1997-01-29 ST_CLERK 3100.00 \N 124 50
291143 Randall Matos RMATOS 650.121.2874 1998-03-15 ST_CLERK 2600.00 \N 124 50
292144 Peter Vargas PVARGAS 650.121.2004 1998-07-09 ST_CLERK 2500.00 \N 124 50
293145 John Russell JRUSSEL 011.44.1344.429268 1996-10-01 SA_MAN 14000.00 0.40 100 80
294146 Karen Partners KPARTNER 011.44.1344.467268 1997-01-05 SA_MAN 13500.00 0.30 100 80
295147 Alberto Errazuriz AERRAZUR 011.44.1344.429278 1997-03-10 SA_MAN 12000.00 0.30 100 80
296148 Gerald Cambrault GCAMBRAU 011.44.1344.619268 1999-10-15 SA_MAN 11000.00 0.30 100 80
297149 Eleni Zlotkey EZLOTKEY 011.44.1344.429018 2000-01-29 SA_MAN 10500.00 0.20 100 80
298150 Peter Tucker PTUCKER 011.44.1344.129268 1997-01-30 SA_REP 10000.00 0.30 145 80
299151 David Bernstein DBERNSTE 011.44.1344.345268 1997-03-24 SA_REP 9500.00 0.25 145 80
300152 Peter Hall PHALL 011.44.1344.478968 1997-08-20 SA_REP 9000.00 0.25 145 80
301153 Christopher Olsen COLSEN 011.44.1344.498718 1998-03-30 SA_REP 8000.00 0.20 145 80
302154 Nanette Cambrault NCAMBRAU 011.44.1344.987668 1998-12-09 SA_REP 7500.00 0.20 145 80
303155 Oliver Tuvault OTUVAULT 011.44.1344.486508 1999-11-23 SA_REP 7000.00 0.15 145 80
304156 Janette King JKING 011.44.1345.429268 1996-01-30 SA_REP 10000.00 0.35 146 80
305157 Patrick Sully PSULLY 011.44.1345.929268 1996-03-04 SA_REP 9500.00 0.35 146 80
306158 Allan McEwen AMCEWEN 011.44.1345.829268 1996-08-01 SA_REP 9000.00 0.35 146 80
307159 Lindsey Smith LSMITH 011.44.1345.729268 1997-03-10 SA_REP 8000.00 0.30 146 80
308160 Louise Doran LDORAN 011.44.1345.629268 1997-12-15 SA_REP 7500.00 0.30 146 80
309161 Sarath Sewall SSEWALL 011.44.1345.529268 1998-11-03 SA_REP 7000.00 0.25 146 80
310162 Clara Vishney CVISHNEY 011.44.1346.129268 1997-11-11 SA_REP 10500.00 0.25 147 80
311163 Danielle Greene DGREENE 011.44.1346.229268 1999-03-19 SA_REP 9500.00 0.15 147 80
312164 Mattea Marvins MMARVINS 011.44.1346.329268 2000-01-24 SA_REP 7200.00 0.10 147 80
313165 David Lee DLEE 011.44.1346.529268 2000-02-23 SA_REP 6800.00 0.10 147 80
314166 Sundar Ande SANDE 011.44.1346.629268 2000-03-24 SA_REP 6400.00 0.10 147 80
315167 Amit Banda ABANDA 011.44.1346.729268 2000-04-21 SA_REP 6200.00 0.10 147 80
316168 Lisa Ozer LOZER 011.44.1343.929268 1997-03-11 SA_REP 11500.00 0.25 148 80
317169 Harrison Bloom HBLOOM 011.44.1343.829268 1998-03-23 SA_REP 10000.00 0.20 148 80
318170 Tayler Fox TFOX 011.44.1343.729268 1998-01-24 SA_REP 9600.00 0.20 148 80
319171 William Smith WSMITH 011.44.1343.629268 1999-02-23 SA_REP 7400.00 0.15 148 80
320172 Elizabeth Bates EBATES 011.44.1343.529268 1999-03-24 SA_REP 7300.00 0.15 148 80
321173 Sundita Kumar SKUMAR 011.44.1343.329268 2000-04-21 SA_REP 6100.00 0.10 148 80
322174 Ellen Abel EABEL 011.44.1644.429267 1996-05-11 SA_REP 11000.00 0.30 149 80
323175 Alyssa Hutton AHUTTON 011.44.1644.429266 1997-03-19 SA_REP 8800.00 0.25 149 80
324176 Jonathon Taylor JTAYLOR 011.44.1644.429265 1998-03-24 SA_REP 8600.00 0.20 149 80
325177 Jack Livingston JLIVINGS 011.44.1644.429264 1998-04-23 SA_REP 8400.00 0.20 149 80
326178 Kimberely Grant KGRANT 011.44.1644.429263 1999-05-24 SA_REP 7000.00 0.15 149 \N
327179 Charles Johnson CJOHNSON 011.44.1644.429262 2000-01-04 SA_REP 6200.00 0.10 149 80
328180 Winston Taylor WTAYLOR 650.507.9876 1998-01-24 SH_CLERK 3200.00 \N 120 50
329181 Jean Fleaur JFLEAUR 650.507.9877 1998-02-23 SH_CLERK 3100.00 \N 120 50
330182 Martha Sullivan MSULLIVA 650.507.9878 1999-06-21 SH_CLERK 2500.00 \N 120 50
331183 Girard Geoni GGEONI 650.507.9879 2000-02-03 SH_CLERK 2800.00 \N 120 50
332184 Nandita Sarchand NSARCHAN 650.509.1876 1996-01-27 SH_CLERK 4200.00 \N 121 50
333185 Alexis Bull ABULL 650.509.2876 1997-02-20 SH_CLERK 4100.00 \N 121 50
334186 Julia Dellinger JDELLING 650.509.3876 1998-06-24 SH_CLERK 3400.00 \N 121 50
335187 Anthony Cabrio ACABRIO 650.509.4876 1999-02-07 SH_CLERK 3000.00 \N 121 50
336188 Kelly Chung KCHUNG 650.505.1876 1997-06-14 SH_CLERK 3800.00 \N 122 50
337189 Jennifer Dilly JDILLY 650.505.2876 1997-08-13 SH_CLERK 3600.00 \N 122 50
338190 Timothy Gates TGATES 650.505.3876 1998-07-11 SH_CLERK 2900.00 \N 122 50
339191 Randall Perkins RPERKINS 650.505.4876 1999-12-19 SH_CLERK 2500.00 \N 122 50
340192 Sarah Bell SBELL 650.501.1876 1996-02-04 SH_CLERK 4000.00 \N 123 50
341193 Britney Everett BEVERETT 650.501.2876 1997-03-03 SH_CLERK 3900.00 \N 123 50
342194 Samuel McCain SMCCAIN 650.501.3876 1998-07-01 SH_CLERK 3200.00 \N 123 50
343195 Vance Jones VJONES 650.501.4876 1999-03-17 SH_CLERK 2800.00 \N 123 50
344196 Alana Walsh AWALSH 650.507.9811 1998-04-24 SH_CLERK 3100.00 \N 124 50
345197 Kevin Feeney KFEENEY 650.507.9822 1998-05-23 SH_CLERK 3000.00 \N 124 50
346198 Donald OConnell DOCONNEL 650.507.9833 1999-06-21 SH_CLERK 2600.00 \N 124 50
347199 Douglas Grant DGRANT 650.507.9844 2000-01-13 SH_CLERK 2600.00 \N 124 50
348200 Jennifer Whalen JWHALEN 515.123.4444 1987-09-17 AD_ASST 4400.00 \N 101 10
349201 Michael Hartstein MHARTSTE 515.123.5555 1996-02-17 MK_MAN 13000.00 \N 100 20
350202 Pat Fay PFAY 603.123.6666 1997-08-17 MK_REP 6000.00 \N 201 20
351203 Susan Mavris SMAVRIS 515.123.7777 1994-06-07 HR_REP 6500.00 \N 101 40
352204 Hermann Baer HBAER 515.123.8888 1994-06-07 PR_REP 10000.00 \N 101 70
353205 Shelley Higgins SHIGGINS 515.123.8080 1994-06-07 AC_MGR 12000.00 \N 101 110
354206 William Gietz WGIETZ 515.123.8181 1994-06-07 AC_ACCOUNT 8300.00 \N 205 110
355\.
356
357
358--
359-- TOC entry 1883 (class 0 OID 16530)
360-- Dependencies: 164
361-- Data for Name: job_grades; Type: TABLE DATA; Schema: public; Owner: postgres
362--
363
364COPY job_grades (grade_level, lowest_sal, highest_sal) FROM stdin;
365A 1000 2999
366B 3000 5999
367C 6000 9999
368D 10000 14999
369E 15000 24999
370F 25000 40000
371\.
372
373
374--
375-- TOC entry 1884 (class 0 OID 16533)
376-- Dependencies: 165
377-- Data for Name: job_history; Type: TABLE DATA; Schema: public; Owner: postgres
378--
379
380COPY job_history (employee_id, start_date, end_date, job_id, department_id) FROM stdin;
381102 1993-01-13 1998-07-24 IT_PROG 60
382101 1989-09-21 1993-10-27 AC_ACCOUNT 110
383101 1993-10-28 1997-03-15 AC_MGR 110
384201 1996-02-17 1999-12-19 MK_REP 20
385114 1998-03-24 1999-12-31 ST_CLERK 50
386122 1999-01-01 1999-12-31 ST_CLERK 50
387200 1987-09-17 1993-06-17 AD_ASST 90
388176 1998-03-24 1998-12-31 SA_REP 80
389176 1999-01-01 1999-12-31 SA_MAN 80
390200 1994-07-01 1998-12-31 AC_ACCOUNT 90
391\.
392
393
394--
395-- TOC entry 1880 (class 0 OID 16520)
396-- Dependencies: 161
397-- Data for Name: paises; Type: TABLE DATA; Schema: public; Owner: postgres
398--
399
400COPY paises (pais_id, pais_nombre, region_id) FROM stdin;
401IT Italy 1
402JP Japan 3
403US United States of America 2
404CA Canada 2
405CN China 3
406IN India 3
407AU Australia 3
408ZW Zimbabwe 4
409SG Singapore 3
410UK United Kingdom 1
411FR France 1
412DE Germany 1
413ZM Zambia 4
414EG Egypt 4
415BR Brazil 2
416CH Switzerland 1
417NL Netherlands 1
418MX Mexico 2
419KW Kuwait 4
420IL Israel 4
421DK Denmark 1
422HK HongKong 3
423NG Nigeria 4
424AR Argentina 2
425BE Belgium 1
426\.
427
428
429--
430-- TOC entry 1887 (class 0 OID 16543)
431-- Dependencies: 168
432-- Data for Name: regiones; Type: TABLE DATA; Schema: public; Owner: postgres
433--
434
435COPY regiones (region_id, region_nombre) FROM stdin;
4361 Europe
4372 Americas
4383 Asia
4394 Middle East and Africa
440\.
441
442
443--
444-- TOC entry 1886 (class 0 OID 16540)
445-- Dependencies: 167
446-- Data for Name: ubicaciones; Type: TABLE DATA; Schema: public; Owner: postgres
447--
448
449COPY ubicaciones (ubicacion_id, direccion, codigo_postal, ciudad, provincia_estatal, pais_id) FROM stdin;
4501000 1297 Via Cola di Rie 00989 Roma \N IT
4511100 93091 Calle della Testa 10934 Venice \N IT
4521200 2017 Shinjuku-ku 1689 Tokyo Tokyo Prefecture JP
4531300 9450 Kamiya-cho 6823 Hiroshima \N JP
4541400 2014 Jabberwocky Rd 26192 Southlake Texas US
4551500 2011 Interiors Blvd 99236 South San Francisco California US
4561600 2007 Zagora St 50090 South Brunswick New Jersey US
4571700 2004 Charade Rd 98199 Seattle Washington US
4581800 147 Spadina Ave M5V 2L7 Toronto Ontario CA
4591900 6092 Boxwood St YSW 9T2 Whitehorse Yukon CA
4602000 40-5-12 Laogianggen 190518 Beijing \N CN
4612100 1298 Vileparle (E) 490231 Bombay Maharashtra IN
4622200 12-98 Victoria Street 2901 Sydney New South Wales AU
4632300 198 Clementi North 540198 Singapore \N SG
4642400 8204 Arthur St \N London \N UK
4652500 Magdalen Centre, The Oxford Science Park OX9 9ZB Oxford Oxford UK
4662600 9702 Chester Road 09629850293 Stretford Manchester UK
4672700 Schwanthalerstr. 7031 80925 Munich Bavaria DE
4682800 Rua Frei Caneca 1360 01307-002 Sao Paulo Sao Paulo BR
4692900 20 Rue des Corps-Saints 1730 Geneva Geneve CH
4703000 Murtenstrasse 921 3095 Bern BE CH
4713100 Pieter Breughelstraat 837 3029SK Utrecht Utrecht NL
4723200 Mariano Escobedo 9991 11932 Mexico City Distrito Federal, MX
473\.
474
475
476--
477-- TOC entry 1877 (class 2606 OID 16547)
478-- Dependencies: 161 161
479-- Name: country_c_id_pk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
480--
481
482ALTER TABLE ONLY paises
483 ADD CONSTRAINT country_c_id_pk PRIMARY KEY (pais_id);
484
485
486--
487-- TOC entry 1879 (class 2606 OID 16549)
488-- Dependencies: 163 163
489-- Name: emp_email_uk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
490--
491
492ALTER TABLE ONLY empleados
493 ADD CONSTRAINT emp_email_uk UNIQUE (email);
494
495
496--
497-- TOC entry 1892 (class 0 OID 0)
498-- Dependencies: 6
499-- Name: public; Type: ACL; Schema: -; Owner: postgres
500--
501
502REVOKE ALL ON SCHEMA public FROM PUBLIC;
503REVOKE ALL ON SCHEMA public FROM postgres;
504GRANT ALL ON SCHEMA public TO postgres;
505GRANT ALL ON SCHEMA public TO PUBLIC;
506
507
508-- Completed on 2012-11-03 22:41:22
509
510--
511-- PostgreSQL database dump complete
512--