· 7 years ago · Oct 09, 2018, 03:00 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.1.3
6-- Dumped by pg_dump version 9.1.3
7-- Started on 2012-11-03 22:41:22
8
9SET statement_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14
15--
16-- TOC entry 169 (class 3079 OID 11639)
17-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
18--
19
20CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21
22
23--
24-- TOC entry 1893 (class 0 OID 0)
25-- Dependencies: 169
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32SET search_path = public, pg_catalog;
33
34SET default_tablespace = '';
35
36SET default_with_oids = false;
37
38--
39-- TOC entry 166 (class 1259 OID 16537)
40-- Dependencies: 6
41-- Name: cargos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
42--
43
44CREATE TABLE cargos (
45 cargo_id character varying(10),
46 cargo_titulo character varying(35) NOT NULL,
47 sueldo_min integer,
48 sueldo_max integer
49);
50
51
52ALTER TABLE public.cargos OWNER TO postgres;
53
54--
55-- TOC entry 162 (class 1259 OID 16523)
56-- Dependencies: 6
57-- Name: departamentos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
58--
59
60CREATE TABLE departamentos (
61 departamento_id integer,
62 departamento_nombre character varying(30) NOT NULL,
63 gerente_id integer,
64 ubicacion_id integer
65);
66
67
68ALTER TABLE public.departamentos OWNER TO postgres;
69
70--
71-- TOC entry 163 (class 1259 OID 16526)
72-- Dependencies: 1874 6
73-- Name: empleados; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
74--
75
76CREATE TABLE empleados (
77 empleado_id integer,
78 nombres character varying(20),
79 apellidos character varying(25) NOT NULL,
80 email character varying(25) NOT NULL,
81 telefono character varying(20),
82 fecha_contrato date NOT NULL,
83 cargo_id character varying(10) NOT NULL,
84 sueldo numeric(8,2),
85 porc_comision numeric(2,2),
86 gerente_id integer,
87 departamento_id integer,
88 CONSTRAINT emp_salary_min CHECK ((sueldo > (0)::numeric))
89);
90
91
92ALTER TABLE public.empleados OWNER TO postgres;
93
94--
95-- TOC entry 164 (class 1259 OID 16530)
96-- Dependencies: 6
97-- Name: job_grades; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
98--
99
100CREATE TABLE job_grades (
101 grade_level character varying(3),
102 lowest_sal integer,
103 highest_sal integer
104);
105
106
107ALTER TABLE public.job_grades OWNER TO postgres;
108
109--
110-- TOC entry 165 (class 1259 OID 16533)
111-- Dependencies: 1875 6
112-- Name: job_history; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
113--
114
115CREATE TABLE job_history (
116 employee_id integer NOT NULL,
117 start_date date NOT NULL,
118 end_date date NOT NULL,
119 job_id character varying(10) NOT NULL,
120 department_id integer,
121 CONSTRAINT jhist_date_interval CHECK ((end_date > start_date))
122);
123
124
125ALTER TABLE public.job_history OWNER TO postgres;
126
127--
128-- TOC entry 161 (class 1259 OID 16520)
129-- Dependencies: 6
130-- Name: paises; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
131--
132
133CREATE TABLE paises (
134 pais_id character(2) NOT NULL,
135 pais_nombre character varying(40),
136 region_id integer
137);
138
139
140ALTER TABLE public.paises OWNER TO postgres;
141
142--
143-- TOC entry 168 (class 1259 OID 16543)
144-- Dependencies: 6
145-- Name: regiones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
146--
147
148CREATE TABLE regiones (
149 region_id integer NOT NULL,
150 region_nombre character varying(25)
151);
152
153
154ALTER TABLE public.regiones OWNER TO postgres;
155
156--
157-- TOC entry 167 (class 1259 OID 16540)
158-- Dependencies: 6
159-- Name: ubicaciones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
160--
161
162CREATE TABLE ubicaciones (
163 ubicacion_id integer,
164 direccion character varying(40),
165 codigo_postal character varying(12),
166 ciudad character varying(30) NOT NULL,
167 provincia_estatal character varying(25),
168 pais_id character(2)
169);
170
171
172ALTER TABLE public.ubicaciones OWNER TO postgres;
173
174--
175-- TOC entry 1885 (class 0 OID 16537)
176-- Dependencies: 166
177-- Data for Name: cargos; Type: TABLE DATA; Schema: public; Owner: postgres
178--
179
180COPY cargos (cargo_id, cargo_titulo, sueldo_min, sueldo_max) FROM stdin;
181AD_PRES President 20000 40000
182AD_VP Administration Vice President 15000 30000
183AD_ASST Administration Assistant 3000 6000
184FI_MGR Finance Manager 8200 16000
185FI_ACCOUNT Accountant 4200 9000
186AC_MGR Accounting Manager 8200 16000
187AC_ACCOUNT Public Accountant 4200 9000
188SA_MAN Sales Manager 10000 20000
189SA_REP Sales Representative 6000 12000
190PU_MAN Purchasing Manager 8000 15000
191PU_CLERK Purchasing Clerk 2500 5500
192ST_MAN Stock Manager 5500 8500
193ST_CLERK Stock Clerk 2000 5000
194SH_CLERK Shipping Clerk 2500 5500
195IT_PROG Programmer 4000 10000
196MK_MAN Marketing Manager 9000 15000
197MK_REP Marketing Representative 4000 9000
198HR_REP Human Resources Representative 4000 9000
199PR_REP Public Relations Representative 4500 10500
200\.
201
202
203--
204-- TOC entry 1881 (class 0 OID 16523)
205-- Dependencies: 162
206-- Data for Name: departamentos; Type: TABLE DATA; Schema: public; Owner: postgres
207--
208
209COPY departamentos (departamento_id, departamento_nombre, gerente_id, ubicacion_id) FROM stdin;
21010 Administration 200 1700
21120 Marketing 201 1800
21230 Purchasing 114 1700
21340 Human Resources 203 2400
21450 Shipping 121 1500
21560 IT 103 1400
21670 Public Relations 204 2700
21780 Sales 145 2500
21890 Executive 100 1700
219100 Finance 108 1700
220110 Accounting 205 1700
221120 Treasury \N 1700
222130 Corporate Tax \N 1700
223140 Control And Credit \N 1700
224150 Shareholder Services \N 1700
225160 Benefits \N 1700
226170 Manufacturing \N 1700
227180 Construction \N 1700
228190 Contracting \N 1700
229200 Operations \N 1700
230210 IT Support \N 1700
231220 NOC \N 1700
232230 IT Helpdesk \N 1700
233240 Government Sales \N 1700
234250 Retail Sales \N 1700
235260 Recruiting \N 1700
236270 Payroll \N 1700
237\.
238
239
240--
241-- TOC entry 1882 (class 0 OID 16526)
242-- Dependencies: 163
243-- Data for Name: empleados; Type: TABLE DATA; Schema: public; Owner: postgres
244--
245
246COPY empleados (empleado_id, nombres, apellidos, email, telefono, fecha_contrato, cargo_id, sueldo, porc_comision, gerente_id, departamento_id) FROM stdin;
247100 Steven King SKING 515.123.4567 1987-06-17 AD_PRES 24000.00 \N \N 90
248101 Neena Kochhar NKOCHHAR 515.123.4568 1989-09-21 AD_VP 17000.00 \N 100 90
249102 Lex De Haan LDEHAAN 515.123.4569 1993-01-13 AD_VP 17000.00 \N 100 90
250103 Alexander Hunold AHUNOLD 590.423.4567 1990-01-03 IT_PROG 9000.00 \N 102 60
251104 Bruce Ernst BERNST 590.423.4568 1991-05-21 IT_PROG 6000.00 \N 103 60
252105 David Austin DAUSTIN 590.423.4569 1997-06-25 IT_PROG 4800.00 \N 103 60
253106 Valli Pataballa VPATABAL 590.423.4560 1998-02-05 IT_PROG 4800.00 \N 103 60
254107 Diana Lorentz DLORENTZ 590.423.5567 1999-02-07 IT_PROG 4200.00 \N 103 60
255108 Nancy Greenberg NGREENBE 515.124.4569 1994-08-17 FI_MGR 12000.00 \N 101 100
256109 Daniel Faviet DFAVIET 515.124.4169 1994-08-16 FI_ACCOUNT 9000.00 \N 108 100
257110 John Chen JCHEN 515.124.4269 1997-09-28 FI_ACCOUNT 8200.00 \N 108 100
258111 Ismael Sciarra ISCIARRA 515.124.4369 1997-09-30 FI_ACCOUNT 7700.00 \N 108 100
259112 Jose Manuel Urman JMURMAN 515.124.4469 1998-03-07 FI_ACCOUNT 7800.00 \N 108 100
260113 Luis Popp LPOPP 515.124.4567 1999-12-07 FI_ACCOUNT 6900.00 \N 108 100
261114 Den Raphaely DRAPHEAL 515.127.4561 1994-12-07 PU_MAN 11000.00 \N 100 30
262115 Alexander Khoo AKHOO 515.127.4562 1995-05-18 PU_CLERK 3100.00 \N 114 30
263116 Shelli Baida SBAIDA 515.127.4563 1997-12-24 PU_CLERK 2900.00 \N 114 30
264117 Sigal Tobias STOBIAS 515.127.4564 1997-07-24 PU_CLERK 2800.00 \N 114 30
265118 Guy Himuro GHIMURO 515.127.4565 1998-11-15 PU_CLERK 2600.00 \N 114 30
266119 Karen Colmenares KCOLMENA 515.127.4566 1999-08-10 PU_CLERK 2500.00 \N 114 30
267120 Matthew Weiss MWEISS 650.123.1234 1996-07-18 ST_MAN 8000.00 \N 100 50
268121 Adam Fripp AFRIPP 650.123.2234 1997-04-10 ST_MAN 8200.00 \N 100 50
269122 Payam Kaufling PKAUFLIN 650.123.3234 1995-05-01 ST_MAN 7900.00 \N 100 50
270123 Shanta Vollman SVOLLMAN 650.123.4234 1997-10-10 ST_MAN 6500.00 \N 100 50
271124 Kevin Mourgos KMOURGOS 650.123.5234 1999-11-16 ST_MAN 5800.00 \N 100 50
272125 Julia Nayer JNAYER 650.124.1214 1997-07-16 ST_CLERK 3200.00 \N 120 50
273126 Irene Mikkilineni IMIKKILI 650.124.1224 1998-09-28 ST_CLERK 2700.00 \N 120 50
274127 James Landry JLANDRY 650.124.1334 1999-01-14 ST_CLERK 2400.00 \N 120 50
275128 Steven Markle SMARKLE 650.124.1434 2000-03-08 ST_CLERK 2200.00 \N 120 50
276129 Laura Bissot LBISSOT 650.124.5234 1997-08-20 ST_CLERK 3300.00 \N 121 50
277130 Mozhe Atkinson MATKINSO 650.124.6234 1997-10-30 ST_CLERK 2800.00 \N 121 50
278131 James Marlow JAMRLOW 650.124.7234 1997-02-16 ST_CLERK 2500.00 \N 121 50
279132 TJ Olson TJOLSON 650.124.8234 1999-04-10 ST_CLERK 2100.00 \N 121 50
280133 Jason Mallin JMALLIN 650.127.1934 1996-06-14 ST_CLERK 3300.00 \N 122 50
281134 Michael Rogers MROGERS 650.127.1834 1998-08-26 ST_CLERK 2900.00 \N 122 50
282135 Ki Gee KGEE 650.127.1734 1999-12-12 ST_CLERK 2400.00 \N 122 50
283136 Hazel Philtanker HPHILTAN 650.127.1634 2000-02-06 ST_CLERK 2200.00 \N 122 50
284137 Renske Ladwig RLADWIG 650.121.1234 1995-07-14 ST_CLERK 3600.00 \N 123 50
285138 Stephen Stiles SSTILES 650.121.2034 1997-10-26 ST_CLERK 3200.00 \N 123 50
286139 John Seo JSEO 650.121.2019 1998-02-12 ST_CLERK 2700.00 \N 123 50
287140 Joshua Patel JPATEL 650.121.1834 1998-04-06 ST_CLERK 2500.00 \N 123 50
288141 Trenna Rajs TRAJS 650.121.8009 1995-10-17 ST_CLERK 3500.00 \N 124 50
289142 Curtis Davies CDAVIES 650.121.2994 1997-01-29 ST_CLERK 3100.00 \N 124 50
290143 Randall Matos RMATOS 650.121.2874 1998-03-15 ST_CLERK 2600.00 \N 124 50
291144 Peter Vargas PVARGAS 650.121.2004 1998-07-09 ST_CLERK 2500.00 \N 124 50
292145 John Russell JRUSSEL 011.44.1344.429268 1996-10-01 SA_MAN 14000.00 0.40 100 80
293146 Karen Partners KPARTNER 011.44.1344.467268 1997-01-05 SA_MAN 13500.00 0.30 100 80
294147 Alberto Errazuriz AERRAZUR 011.44.1344.429278 1997-03-10 SA_MAN 12000.00 0.30 100 80
295148 Gerald Cambrault GCAMBRAU 011.44.1344.619268 1999-10-15 SA_MAN 11000.00 0.30 100 80
296149 Eleni Zlotkey EZLOTKEY 011.44.1344.429018 2000-01-29 SA_MAN 10500.00 0.20 100 80
297150 Peter Tucker PTUCKER 011.44.1344.129268 1997-01-30 SA_REP 10000.00 0.30 145 80
298151 David Bernstein DBERNSTE 011.44.1344.345268 1997-03-24 SA_REP 9500.00 0.25 145 80
299152 Peter Hall PHALL 011.44.1344.478968 1997-08-20 SA_REP 9000.00 0.25 145 80
300153 Christopher Olsen COLSEN 011.44.1344.498718 1998-03-30 SA_REP 8000.00 0.20 145 80
301154 Nanette Cambrault NCAMBRAU 011.44.1344.987668 1998-12-09 SA_REP 7500.00 0.20 145 80
302155 Oliver Tuvault OTUVAULT 011.44.1344.486508 1999-11-23 SA_REP 7000.00 0.15 145 80
303156 Janette King JKING 011.44.1345.429268 1996-01-30 SA_REP 10000.00 0.35 146 80
304157 Patrick Sully PSULLY 011.44.1345.929268 1996-03-04 SA_REP 9500.00 0.35 146 80
305158 Allan McEwen AMCEWEN 011.44.1345.829268 1996-08-01 SA_REP 9000.00 0.35 146 80
306159 Lindsey Smith LSMITH 011.44.1345.729268 1997-03-10 SA_REP 8000.00 0.30 146 80
307160 Louise Doran LDORAN 011.44.1345.629268 1997-12-15 SA_REP 7500.00 0.30 146 80
308161 Sarath Sewall SSEWALL 011.44.1345.529268 1998-11-03 SA_REP 7000.00 0.25 146 80
309162 Clara Vishney CVISHNEY 011.44.1346.129268 1997-11-11 SA_REP 10500.00 0.25 147 80
310163 Danielle Greene DGREENE 011.44.1346.229268 1999-03-19 SA_REP 9500.00 0.15 147 80
311164 Mattea Marvins MMARVINS 011.44.1346.329268 2000-01-24 SA_REP 7200.00 0.10 147 80
312165 David Lee DLEE 011.44.1346.529268 2000-02-23 SA_REP 6800.00 0.10 147 80
313166 Sundar Ande SANDE 011.44.1346.629268 2000-03-24 SA_REP 6400.00 0.10 147 80
314167 Amit Banda ABANDA 011.44.1346.729268 2000-04-21 SA_REP 6200.00 0.10 147 80
315168 Lisa Ozer LOZER 011.44.1343.929268 1997-03-11 SA_REP 11500.00 0.25 148 80
316169 Harrison Bloom HBLOOM 011.44.1343.829268 1998-03-23 SA_REP 10000.00 0.20 148 80
317170 Tayler Fox TFOX 011.44.1343.729268 1998-01-24 SA_REP 9600.00 0.20 148 80
318171 William Smith WSMITH 011.44.1343.629268 1999-02-23 SA_REP 7400.00 0.15 148 80
319172 Elizabeth Bates EBATES 011.44.1343.529268 1999-03-24 SA_REP 7300.00 0.15 148 80
320173 Sundita Kumar SKUMAR 011.44.1343.329268 2000-04-21 SA_REP 6100.00 0.10 148 80
321174 Ellen Abel EABEL 011.44.1644.429267 1996-05-11 SA_REP 11000.00 0.30 149 80
322175 Alyssa Hutton AHUTTON 011.44.1644.429266 1997-03-19 SA_REP 8800.00 0.25 149 80
323176 Jonathon Taylor JTAYLOR 011.44.1644.429265 1998-03-24 SA_REP 8600.00 0.20 149 80
324177 Jack Livingston JLIVINGS 011.44.1644.429264 1998-04-23 SA_REP 8400.00 0.20 149 80
325178 Kimberely Grant KGRANT 011.44.1644.429263 1999-05-24 SA_REP 7000.00 0.15 149 \N
326179 Charles Johnson CJOHNSON 011.44.1644.429262 2000-01-04 SA_REP 6200.00 0.10 149 80
327180 Winston Taylor WTAYLOR 650.507.9876 1998-01-24 SH_CLERK 3200.00 \N 120 50
328181 Jean Fleaur JFLEAUR 650.507.9877 1998-02-23 SH_CLERK 3100.00 \N 120 50
329182 Martha Sullivan MSULLIVA 650.507.9878 1999-06-21 SH_CLERK 2500.00 \N 120 50
330183 Girard Geoni GGEONI 650.507.9879 2000-02-03 SH_CLERK 2800.00 \N 120 50
331184 Nandita Sarchand NSARCHAN 650.509.1876 1996-01-27 SH_CLERK 4200.00 \N 121 50
332185 Alexis Bull ABULL 650.509.2876 1997-02-20 SH_CLERK 4100.00 \N 121 50
333186 Julia Dellinger JDELLING 650.509.3876 1998-06-24 SH_CLERK 3400.00 \N 121 50
334187 Anthony Cabrio ACABRIO 650.509.4876 1999-02-07 SH_CLERK 3000.00 \N 121 50
335188 Kelly Chung KCHUNG 650.505.1876 1997-06-14 SH_CLERK 3800.00 \N 122 50
336189 Jennifer Dilly JDILLY 650.505.2876 1997-08-13 SH_CLERK 3600.00 \N 122 50
337190 Timothy Gates TGATES 650.505.3876 1998-07-11 SH_CLERK 2900.00 \N 122 50
338191 Randall Perkins RPERKINS 650.505.4876 1999-12-19 SH_CLERK 2500.00 \N 122 50
339192 Sarah Bell SBELL 650.501.1876 1996-02-04 SH_CLERK 4000.00 \N 123 50
340193 Britney Everett BEVERETT 650.501.2876 1997-03-03 SH_CLERK 3900.00 \N 123 50
341194 Samuel McCain SMCCAIN 650.501.3876 1998-07-01 SH_CLERK 3200.00 \N 123 50
342195 Vance Jones VJONES 650.501.4876 1999-03-17 SH_CLERK 2800.00 \N 123 50
343196 Alana Walsh AWALSH 650.507.9811 1998-04-24 SH_CLERK 3100.00 \N 124 50
344197 Kevin Feeney KFEENEY 650.507.9822 1998-05-23 SH_CLERK 3000.00 \N 124 50
345198 Donald OConnell DOCONNEL 650.507.9833 1999-06-21 SH_CLERK 2600.00 \N 124 50
346199 Douglas Grant DGRANT 650.507.9844 2000-01-13 SH_CLERK 2600.00 \N 124 50
347200 Jennifer Whalen JWHALEN 515.123.4444 1987-09-17 AD_ASST 4400.00 \N 101 10
348201 Michael Hartstein MHARTSTE 515.123.5555 1996-02-17 MK_MAN 13000.00 \N 100 20
349202 Pat Fay PFAY 603.123.6666 1997-08-17 MK_REP 6000.00 \N 201 20
350203 Susan Mavris SMAVRIS 515.123.7777 1994-06-07 HR_REP 6500.00 \N 101 40
351204 Hermann Baer HBAER 515.123.8888 1994-06-07 PR_REP 10000.00 \N 101 70
352205 Shelley Higgins SHIGGINS 515.123.8080 1994-06-07 AC_MGR 12000.00 \N 101 110
353206 William Gietz WGIETZ 515.123.8181 1994-06-07 AC_ACCOUNT 8300.00 \N 205 110
354\.
355
356
357--
358-- TOC entry 1883 (class 0 OID 16530)
359-- Dependencies: 164
360-- Data for Name: job_grades; Type: TABLE DATA; Schema: public; Owner: postgres
361--
362
363COPY job_grades (grade_level, lowest_sal, highest_sal) FROM stdin;
364A 1000 2999
365B 3000 5999
366C 6000 9999
367D 10000 14999
368E 15000 24999
369F 25000 40000
370\.
371
372
373--
374-- TOC entry 1884 (class 0 OID 16533)
375-- Dependencies: 165
376-- Data for Name: job_history; Type: TABLE DATA; Schema: public; Owner: postgres
377--
378
379COPY job_history (employee_id, start_date, end_date, job_id, department_id) FROM stdin;
380102 1993-01-13 1998-07-24 IT_PROG 60
381101 1989-09-21 1993-10-27 AC_ACCOUNT 110
382101 1993-10-28 1997-03-15 AC_MGR 110
383201 1996-02-17 1999-12-19 MK_REP 20
384114 1998-03-24 1999-12-31 ST_CLERK 50
385122 1999-01-01 1999-12-31 ST_CLERK 50
386200 1987-09-17 1993-06-17 AD_ASST 90
387176 1998-03-24 1998-12-31 SA_REP 80
388176 1999-01-01 1999-12-31 SA_MAN 80
389200 1994-07-01 1998-12-31 AC_ACCOUNT 90
390\.
391
392
393--
394-- TOC entry 1880 (class 0 OID 16520)
395-- Dependencies: 161
396-- Data for Name: paises; Type: TABLE DATA; Schema: public; Owner: postgres
397--
398
399COPY paises (pais_id, pais_nombre, region_id) FROM stdin;
400IT Italy 1
401JP Japan 3
402US United States of America 2
403CA Canada 2
404CN China 3
405IN India 3
406AU Australia 3
407ZW Zimbabwe 4
408SG Singapore 3
409UK United Kingdom 1
410FR France 1
411DE Germany 1
412ZM Zambia 4
413EG Egypt 4
414BR Brazil 2
415CH Switzerland 1
416NL Netherlands 1
417MX Mexico 2
418KW Kuwait 4
419IL Israel 4
420DK Denmark 1
421HK HongKong 3
422NG Nigeria 4
423AR Argentina 2
424BE Belgium 1
425\.
426
427
428--
429-- TOC entry 1887 (class 0 OID 16543)
430-- Dependencies: 168
431-- Data for Name: regiones; Type: TABLE DATA; Schema: public; Owner: postgres
432--
433
434COPY regiones (region_id, region_nombre) FROM stdin;
4351 Europe
4362 Americas
4373 Asia
4384 Middle East and Africa
439\.
440
441
442--
443-- TOC entry 1886 (class 0 OID 16540)
444-- Dependencies: 167
445-- Data for Name: ubicaciones; Type: TABLE DATA; Schema: public; Owner: postgres
446--
447
448COPY ubicaciones (ubicacion_id, direccion, codigo_postal, ciudad, provincia_estatal, pais_id) FROM stdin;
4491000 1297 Via Cola di Rie 00989 Roma \N IT
4501100 93091 Calle della Testa 10934 Venice \N IT
4511200 2017 Shinjuku-ku 1689 Tokyo Tokyo Prefecture JP
4521300 9450 Kamiya-cho 6823 Hiroshima \N JP
4531400 2014 Jabberwocky Rd 26192 Southlake Texas US
4541500 2011 Interiors Blvd 99236 South San Francisco California US
4551600 2007 Zagora St 50090 South Brunswick New Jersey US
4561700 2004 Charade Rd 98199 Seattle Washington US
4571800 147 Spadina Ave M5V 2L7 Toronto Ontario CA
4581900 6092 Boxwood St YSW 9T2 Whitehorse Yukon CA
4592000 40-5-12 Laogianggen 190518 Beijing \N CN
4602100 1298 Vileparle (E) 490231 Bombay Maharashtra IN
4612200 12-98 Victoria Street 2901 Sydney New South Wales AU
4622300 198 Clementi North 540198 Singapore \N SG
4632400 8204 Arthur St \N London \N UK
4642500 Magdalen Centre, The Oxford Science Park OX9 9ZB Oxford Oxford UK
4652600 9702 Chester Road 09629850293 Stretford Manchester UK
4662700 Schwanthalerstr. 7031 80925 Munich Bavaria DE
4672800 Rua Frei Caneca 1360 01307-002 Sao Paulo Sao Paulo BR
4682900 20 Rue des Corps-Saints 1730 Geneva Geneve CH
4693000 Murtenstrasse 921 3095 Bern BE CH
4703100 Pieter Breughelstraat 837 3029SK Utrecht Utrecht NL
4713200 Mariano Escobedo 9991 11932 Mexico City Distrito Federal, MX
472\.
473
474
475--
476-- TOC entry 1877 (class 2606 OID 16547)
477-- Dependencies: 161 161
478-- Name: country_c_id_pk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
479--
480
481ALTER TABLE ONLY paises
482 ADD CONSTRAINT country_c_id_pk PRIMARY KEY (pais_id);
483
484
485--
486-- TOC entry 1879 (class 2606 OID 16549)
487-- Dependencies: 163 163
488-- Name: emp_email_uk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
489--
490
491ALTER TABLE ONLY empleados
492 ADD CONSTRAINT emp_email_uk UNIQUE (email);
493
494
495--
496-- TOC entry 1892 (class 0 OID 0)
497-- Dependencies: 6
498-- Name: public; Type: ACL; Schema: -; Owner: postgres
499--
500
501REVOKE ALL ON SCHEMA public FROM PUBLIC;
502REVOKE ALL ON SCHEMA public FROM postgres;
503GRANT ALL ON SCHEMA public TO postgres;
504GRANT ALL ON SCHEMA public TO PUBLIC;
505
506
507-- Completed on 2012-11-03 22:41:22
508
509--
510-- PostgreSQL database dump complete
511--