-- -- PostgreSQL database dump -- -- Started on 2008-02-22 01:20:44 SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- TOC entry 1844 (class 1262 OID 16439) -- Name: hr; Type: DATABASE; Schema: -; Owner: - -- CREATE DATABASE hr WITH TEMPLATE = template0 ENCODING = 'UTF8'; \connect hr SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- TOC entry 1845 (class 0 OID 0) -- Dependencies: 3 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON SCHEMA public IS 'standard public schema'; -- -- TOC entry 338 (class 2612 OID 16386) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - -- CREATE PROCEDURAL LANGUAGE plpgsql; SET search_path = public, pg_catalog; -- -- TOC entry 273 (class 1247 OID 16405) -- Dependencies: 3 1510 -- Name: breakpoint; Type: TYPE; Schema: public; Owner: - -- CREATE TYPE breakpoint AS ( func oid, linenumber integer, targetname text ); SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1515 (class 1259 OID 16671) -- Dependencies: 3 -- Name: countries; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE countries ( country_id character(2) NOT NULL, country_name character varying(40), region_id double precision ); -- -- TOC entry 1847 (class 0 OID 0) -- Dependencies: 1515 -- Name: TABLE countries; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE countries IS 'country table. Contains 25 rows. References with locations table.'; -- -- TOC entry 1848 (class 0 OID 0) -- Dependencies: 1515 -- Name: COLUMN countries.country_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN countries.country_id IS 'Primary key of countries table.'; -- -- TOC entry 1849 (class 0 OID 0) -- Dependencies: 1515 -- Name: COLUMN countries.country_name; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN countries.country_name IS 'Country name'; -- -- TOC entry 1850 (class 0 OID 0) -- Dependencies: 1515 -- Name: COLUMN countries.region_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN countries.region_id IS 'Region ID for the country. Foreign key to region_id column in the departments table.'; -- -- TOC entry 1517 (class 1259 OID 16678) -- Dependencies: 3 -- Name: departments; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE departments ( department_id integer NOT NULL, department_name character varying(30) NOT NULL, manager_id integer, location_id integer ); -- -- TOC entry 1851 (class 0 OID 0) -- Dependencies: 1517 -- Name: TABLE departments; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE departments IS 'Departments table that shows details of departments where employees work. Contains 27 rows; references with locations, employees, and job_history tables.'; -- -- TOC entry 1852 (class 0 OID 0) -- Dependencies: 1517 -- Name: COLUMN departments.department_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN departments.department_id IS 'Primary key column of departments table.'; -- -- TOC entry 1853 (class 0 OID 0) -- Dependencies: 1517 -- Name: COLUMN departments.department_name; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN departments.department_name IS 'A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting. '; -- -- TOC entry 1854 (class 0 OID 0) -- Dependencies: 1517 -- Name: COLUMN departments.manager_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN departments.manager_id IS 'Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.'; -- -- TOC entry 1855 (class 0 OID 0) -- Dependencies: 1517 -- Name: COLUMN departments.location_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN departments.location_id IS 'Location id where a department is located. Foreign key to location_id column of locations table.'; -- -- TOC entry 1519 (class 1259 OID 16686) -- Dependencies: 1795 3 -- Name: employees; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE employees ( employee_id integer NOT NULL, first_name character varying(20), last_name character varying(25) NOT NULL, email character varying(25) NOT NULL, phone_number character varying(20), hire_date date NOT NULL, job_id character varying(10) NOT NULL, salary numeric(8,2), commission_pct numeric(2,2), manager_id integer, department_id integer, CONSTRAINT emp_salary_min CHECK ((salary > (0)::numeric)) ); -- -- TOC entry 1856 (class 0 OID 0) -- Dependencies: 1519 -- Name: TABLE employees; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE employees IS 'employees table. Contains 107 rows. References with departments, jobs, job_history tables. Contains a self reference.'; -- -- TOC entry 1857 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.employee_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.employee_id IS 'Primary key of employees table.'; -- -- TOC entry 1858 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.first_name; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.first_name IS 'First name of the employee. A not null column.'; -- -- TOC entry 1859 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.last_name; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.last_name IS 'Last name of the employee. A not null column.'; -- -- TOC entry 1860 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.email; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.email IS 'Email id of the employee'; -- -- TOC entry 1861 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.phone_number; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.phone_number IS 'Phone number of the employee; includes country code and area code'; -- -- TOC entry 1862 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.hire_date; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.hire_date IS 'Date when the employee started on this job. A not null column.'; -- -- TOC entry 1863 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.job_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.job_id IS 'Current job of the employee; foreign key to job_id column of the jobs table. A not null column.'; -- -- TOC entry 1864 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.salary; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.salary IS 'Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)'; -- -- TOC entry 1865 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.commission_pct; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.commission_pct IS 'Commission percentage of the employee; Only employees in sales department elgible for commission percentage'; -- -- TOC entry 1866 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.manager_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.manager_id IS 'Manager id of the employee; has same domain as manager_id in departments table. Foreign key to employee_id column of employees table. (useful for reflexive joins and CONNECT BY query)'; -- -- TOC entry 1867 (class 0 OID 0) -- Dependencies: 1519 -- Name: COLUMN employees.department_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN employees.department_id IS 'Department id where employee works; foreign key to department_id column of the departments table'; -- -- TOC entry 1521 (class 1259 OID 16700) -- Dependencies: 3 -- Name: jobs; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE jobs ( job_id character varying(10) NOT NULL, job_title character varying(35) NOT NULL, min_salary numeric(6,0), max_salary numeric(6,0) ); -- -- TOC entry 1868 (class 0 OID 0) -- Dependencies: 1521 -- Name: TABLE jobs; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE jobs IS 'jobs table with job titles and salary ranges. Contains 19 rows. References with employees and job_history table.'; -- -- TOC entry 1869 (class 0 OID 0) -- Dependencies: 1521 -- Name: COLUMN jobs.job_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN jobs.job_id IS 'Primary key of jobs table.'; -- -- TOC entry 1870 (class 0 OID 0) -- Dependencies: 1521 -- Name: COLUMN jobs.job_title; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN jobs.job_title IS 'A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT'; -- -- TOC entry 1871 (class 0 OID 0) -- Dependencies: 1521 -- Name: COLUMN jobs.min_salary; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN jobs.min_salary IS 'Minimum salary for a job title.'; -- -- TOC entry 1872 (class 0 OID 0) -- Dependencies: 1521 -- Name: COLUMN jobs.max_salary; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN jobs.max_salary IS 'Maximum salary for a job title'; -- -- TOC entry 1523 (class 1259 OID 16707) -- Dependencies: 3 -- Name: locations; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locations ( location_id integer NOT NULL, street_address character varying(40), postal_code character varying(12), city character varying(30) NOT NULL, state_province character varying(25), country_id character(2) ); -- -- TOC entry 1873 (class 0 OID 0) -- Dependencies: 1523 -- Name: TABLE locations; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE locations IS 'Locations table that contains specific address of a specific office, warehouse, and/or production site of a company. Does not store addresses / locations of customers. Contains 23 rows; references with the departments and countries tables.'; -- -- TOC entry 1874 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.location_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.location_id IS 'Primary key of locations table'; -- -- TOC entry 1875 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.street_address; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.street_address IS 'Street address of an office, warehouse, or production site of a company. Contains building number and street name'; -- -- TOC entry 1876 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.postal_code; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.postal_code IS 'Postal code of the location of an office, warehouse, or production site of a company. '; -- -- TOC entry 1877 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.city; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.city IS 'A not null column that shows city where an office, warehouse, or production site of a company is located. '; -- -- TOC entry 1878 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.state_province; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.state_province IS 'State or Province where an office, warehouse, or production site of a company is located.'; -- -- TOC entry 1879 (class 0 OID 0) -- Dependencies: 1523 -- Name: COLUMN locations.country_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN locations.country_id IS 'Country where an office, warehouse, or production site of a company is located. Foreign key to country_id column of the countries table.'; -- -- TOC entry 1524 (class 1259 OID 16713) -- Dependencies: 3 -- Name: regions; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE regions ( region_id double precision NOT NULL, region_name character varying(25) ); -- -- TOC entry 1525 (class 1259 OID 16780) -- Dependencies: 1601 3 -- Name: emp_details_view; Type: VIEW; Schema: public; Owner: - -- CREATE VIEW emp_details_view AS SELECT e.employee_id, e.job_id, e.manager_id, e.department_id, d.location_id, l.country_id, e.first_name, e.last_name, e.salary, e.commission_pct, d.department_name, j.job_title, l.city, l.state_province, c.country_name, r.region_name FROM employees e, departments d, jobs j, locations l, countries c, regions r WHERE (((((e.department_id = d.department_id) AND (d.location_id = l.location_id)) AND (l.country_id = c.country_id)) AND (c.region_id = r.region_id)) AND ((j.job_id)::text = (e.job_id)::text)); -- -- TOC entry 275 (class 1247 OID 16408) -- Dependencies: 3 1511 -- Name: frame; Type: TYPE; Schema: public; Owner: - -- CREATE TYPE frame AS ( level integer, targetname text, func oid, linenumber integer, args text ); -- -- TOC entry 1520 (class 1259 OID 16695) -- Dependencies: 1796 3 -- Name: job_history; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE job_history ( employee_id integer NOT NULL, start_date date NOT NULL, end_date date NOT NULL, job_id character varying(10) NOT NULL, department_id integer, CONSTRAINT jhist_date_interval CHECK ((end_date > start_date)) ); -- -- TOC entry 1880 (class 0 OID 0) -- Dependencies: 1520 -- Name: TABLE job_history; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON TABLE job_history IS 'Table that stores job history of the employees. If an employee changes departments within the job or changes jobs within the department, new rows get inserted into this table with old job information of the employee. Contains a complex primary key: employee_id+start_date. Contains 25 rows. References with jobs, employees, and departments tables.'; -- -- TOC entry 1881 (class 0 OID 0) -- Dependencies: 1520 -- Name: COLUMN job_history.employee_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN job_history.employee_id IS 'A not null column in the complex primary key employee_id+start_date. Foreign key to employee_id column of the employee table'; -- -- TOC entry 1882 (class 0 OID 0) -- Dependencies: 1520 -- Name: COLUMN job_history.start_date; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN job_history.start_date IS 'A not null column in the complex primary key employee_id+start_date. Must be less than the end_date of the job_history table. (enforced by constraint jhist_date_interval)'; -- -- TOC entry 1883 (class 0 OID 0) -- Dependencies: 1520 -- Name: COLUMN job_history.end_date; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN job_history.end_date IS 'Last day of the employee in this job role. A not null column. Must be greater than the start_date of the job_history table. (enforced by constraint jhist_date_interval)'; -- -- TOC entry 1884 (class 0 OID 0) -- Dependencies: 1520 -- Name: COLUMN job_history.job_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN job_history.job_id IS 'Job role in which the employee worked in the past; foreign key to job_id column in the jobs table. A not null column.'; -- -- TOC entry 1885 (class 0 OID 0) -- Dependencies: 1520 -- Name: COLUMN job_history.department_id; Type: COMMENT; Schema: public; Owner: - -- COMMENT ON COLUMN job_history.department_id IS 'Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table'; -- -- TOC entry 317 (class 1247 OID 16417) -- Dependencies: 3 1514 -- Name: proxyinfo; Type: TYPE; Schema: public; Owner: - -- CREATE TYPE proxyinfo AS ( serverversionstr text, serverversionnum integer, proxyapiver integer, serverprocessid integer ); -- -- TOC entry 313 (class 1247 OID 16411) -- Dependencies: 3 1512 -- Name: targetinfo; Type: TYPE; Schema: public; Owner: - -- CREATE TYPE targetinfo AS ( target oid, schema oid, nargs integer, argtypes oidvector, targetname name, argmodes "char"[], argnames text[], targetlang oid, fqname text, returnsset boolean, returntype oid ); -- -- TOC entry 315 (class 1247 OID 16414) -- Dependencies: 3 1513 -- Name: var; Type: TYPE; Schema: public; Owner: - -- CREATE TYPE var AS ( name text, varclass character(1), linenumber integer, isunique boolean, isconst boolean, isnotnull boolean, dtype oid, value text ); -- -- TOC entry 21 (class 1255 OID 16419) -- Dependencies: 3 -- Name: pldbg_abort_target(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_abort_target(session integer) RETURNS SETOF boolean AS '$libdir/pldbgapi', 'pldbg_abort_target' LANGUAGE c STRICT; -- -- TOC entry 22 (class 1255 OID 16420) -- Dependencies: 3 -- Name: pldbg_attach_to_port(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_attach_to_port(portnumber integer) RETURNS integer AS '$libdir/pldbgapi', 'pldbg_attach_to_port' LANGUAGE c STRICT; -- -- TOC entry 23 (class 1255 OID 16421) -- Dependencies: 3 273 -- Name: pldbg_continue(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_continue(session integer) RETURNS breakpoint AS '$libdir/pldbgapi', 'pldbg_continue' LANGUAGE c STRICT; -- -- TOC entry 24 (class 1255 OID 16422) -- Dependencies: 3 -- Name: pldbg_create_listener(); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_create_listener() RETURNS integer AS '$libdir/pldbgapi', 'pldbg_create_listener' LANGUAGE c STRICT; -- -- TOC entry 25 (class 1255 OID 16423) -- Dependencies: 3 -- Name: pldbg_deposit_value(integer, text, integer, text); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_deposit_value(session integer, varname text, linenumber integer, value text) RETURNS boolean AS '$libdir/pldbgapi', 'pldbg_deposit_value' LANGUAGE c STRICT; -- -- TOC entry 26 (class 1255 OID 16424) -- Dependencies: 3 -- Name: pldbg_drop_breakpoint(integer, oid, integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_drop_breakpoint(session integer, func oid, linenumber integer) RETURNS boolean AS '$libdir/pldbgapi', 'pldbg_drop_breakpoint' LANGUAGE c STRICT; -- -- TOC entry 27 (class 1255 OID 16425) -- Dependencies: 273 3 -- Name: pldbg_get_breakpoints(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_breakpoints(session integer) RETURNS SETOF breakpoint AS '$libdir/pldbgapi', 'pldbg_get_breakpoints' LANGUAGE c STRICT; -- -- TOC entry 30 (class 1255 OID 16428) -- Dependencies: 3 317 -- Name: pldbg_get_proxy_info(); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_proxy_info() RETURNS proxyinfo AS '$libdir/pldbgapi', 'pldbg_get_proxy_info' LANGUAGE c STRICT; -- -- TOC entry 28 (class 1255 OID 16426) -- Dependencies: 3 -- Name: pldbg_get_source(integer, oid); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_source(session integer, func oid) RETURNS text AS '$libdir/pldbgapi', 'pldbg_get_source' LANGUAGE c STRICT; -- -- TOC entry 29 (class 1255 OID 16427) -- Dependencies: 3 275 -- Name: pldbg_get_stack(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_stack(session integer) RETURNS SETOF frame AS '$libdir/pldbgapi', 'pldbg_get_stack' LANGUAGE c STRICT; -- -- TOC entry 39 (class 1255 OID 16437) -- Dependencies: 313 3 -- Name: pldbg_get_target_info(text, "char"); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_target_info(signature text, targettype "char") RETURNS targetinfo AS '$libdir/targetinfo', 'pldbg_get_target_info' LANGUAGE c STRICT; -- -- TOC entry 31 (class 1255 OID 16429) -- Dependencies: 3 315 -- Name: pldbg_get_variables(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_get_variables(session integer) RETURNS SETOF var AS '$libdir/pldbgapi', 'pldbg_get_variables' LANGUAGE c STRICT; -- -- TOC entry 32 (class 1255 OID 16430) -- Dependencies: 273 3 -- Name: pldbg_select_frame(integer, integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_select_frame(session integer, frame integer) RETURNS breakpoint AS '$libdir/pldbgapi', 'pldbg_select_frame' LANGUAGE c STRICT; -- -- TOC entry 33 (class 1255 OID 16431) -- Dependencies: 3 -- Name: pldbg_set_breakpoint(integer, oid, integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_set_breakpoint(session integer, func oid, linenumber integer) RETURNS boolean AS '$libdir/pldbgapi', 'pldbg_set_breakpoint' LANGUAGE c STRICT; -- -- TOC entry 34 (class 1255 OID 16432) -- Dependencies: 3 -- Name: pldbg_set_global_breakpoint(integer, oid, integer, integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_set_global_breakpoint(session integer, func oid, linenumber integer, targetpid integer) RETURNS boolean AS '$libdir/pldbgapi', 'pldbg_set_global_breakpoint' LANGUAGE c; -- -- TOC entry 35 (class 1255 OID 16433) -- Dependencies: 3 273 -- Name: pldbg_step_into(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_step_into(session integer) RETURNS breakpoint AS '$libdir/pldbgapi', 'pldbg_step_into' LANGUAGE c STRICT; -- -- TOC entry 36 (class 1255 OID 16434) -- Dependencies: 273 3 -- Name: pldbg_step_over(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_step_over(session integer) RETURNS breakpoint AS '$libdir/pldbgapi', 'pldbg_step_over' LANGUAGE c STRICT; -- -- TOC entry 37 (class 1255 OID 16435) -- Dependencies: 273 3 -- Name: pldbg_wait_for_breakpoint(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_wait_for_breakpoint(session integer) RETURNS breakpoint AS '$libdir/pldbgapi', 'pldbg_wait_for_breakpoint' LANGUAGE c STRICT; -- -- TOC entry 38 (class 1255 OID 16436) -- Dependencies: 3 -- Name: pldbg_wait_for_target(integer); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION pldbg_wait_for_target(session integer) RETURNS integer AS '$libdir/pldbgapi', 'pldbg_wait_for_target' LANGUAGE c STRICT; -- -- TOC entry 20 (class 1255 OID 16418) -- Dependencies: 3 -- Name: plpgsql_oid_debug(oid); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION plpgsql_oid_debug(functionoid oid) RETURNS integer AS '$libdir/plugins/plugin_debugger', 'plpgsql_oid_debug' LANGUAGE c STRICT; -- -- TOC entry 1516 (class 1259 OID 16676) -- Dependencies: 3 1517 -- Name: departments_department_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE departments_department_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1886 (class 0 OID 0) -- Dependencies: 1516 -- Name: departments_department_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE departments_department_id_seq OWNED BY departments.department_id; -- -- TOC entry 1887 (class 0 OID 0) -- Dependencies: 1516 -- Name: departments_department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('departments_department_id_seq', 1, false); -- -- TOC entry 1518 (class 1259 OID 16684) -- Dependencies: 3 1519 -- Name: employees_employee_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE employees_employee_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1888 (class 0 OID 0) -- Dependencies: 1518 -- Name: employees_employee_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE employees_employee_id_seq OWNED BY employees.employee_id; -- -- TOC entry 1889 (class 0 OID 0) -- Dependencies: 1518 -- Name: employees_employee_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('employees_employee_id_seq', 1, false); -- -- TOC entry 1522 (class 1259 OID 16705) -- Dependencies: 3 1523 -- Name: locations_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE locations_location_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1890 (class 0 OID 0) -- Dependencies: 1522 -- Name: locations_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE locations_location_id_seq OWNED BY locations.location_id; -- -- TOC entry 1891 (class 0 OID 0) -- Dependencies: 1522 -- Name: locations_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('locations_location_id_seq', 1, false); -- -- TOC entry 1793 (class 2604 OID 16681) -- Dependencies: 1516 1517 1517 -- Name: department_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE departments ALTER COLUMN department_id SET DEFAULT nextval('departments_department_id_seq'::regclass); -- -- TOC entry 1794 (class 2604 OID 16689) -- Dependencies: 1518 1519 1519 -- Name: employee_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE employees ALTER COLUMN employee_id SET DEFAULT nextval('employees_employee_id_seq'::regclass); -- -- TOC entry 1797 (class 2604 OID 16710) -- Dependencies: 1523 1522 1523 -- Name: location_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE locations ALTER COLUMN location_id SET DEFAULT nextval('locations_location_id_seq'::regclass); -- -- TOC entry 1835 (class 0 OID 16671) -- Dependencies: 1515 -- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO countries (country_id, country_name, region_id) VALUES ('AR', 'Argentina', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('AU', 'Australia', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('BE', 'Belgium', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('BR', 'Brazil', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('CA', 'Canada', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('CH', 'Switzerland', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('CN', 'China', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DE', 'Germany', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DK', 'Denmark', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('EG', 'Egypt', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('FR', 'France', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('HK', 'HongKong', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IL', 'Israel', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IN', 'India', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IT', 'Italy', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('JP', 'Japan', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('KW', 'Kuwait', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('MX', 'Mexico', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('NG', 'Nigeria', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('NL', 'Netherlands', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('SG', 'Singapore', 3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('UK', 'United Kingdom', 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('US', 'United States of America', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZM', 'Zambia', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZW', 'Zimbabwe', 4); -- -- TOC entry 1836 (class 0 OID 16678) -- Dependencies: 1517 -- Data for Name: departments; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (10, 'Administration', 200, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (20, 'Marketing', 201, 1800); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (30, 'Purchasing', 114, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (40, 'Human Resources', 203, 2400); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (50, 'Shipping', 121, 1500); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (60, 'IT', 103, 1400); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (70, 'Public Relations', 204, 2700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (80, 'Sales', 145, 2500); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (90, 'Executive', 100, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (100, 'Finance', 108, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (110, 'Accounting', 205, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (120, 'Treasury', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (130, 'Corporate Tax', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (140, 'Control And Credit', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (150, 'Shareholder Services', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (160, 'Benefits', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (170, 'Manufacturing', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (180, 'Construction', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (190, 'Contracting', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (200, 'Operations', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (210, 'IT Support', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (220, 'NOC', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (230, 'IT Helpdesk', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (240, 'Government Sales', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (250, 'Retail Sales', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (260, 'Recruiting', NULL, 1700); INSERT INTO departments (department_id, department_name, manager_id, location_id) VALUES (270, 'Payroll', NULL, 1700); -- -- TOC entry 1837 (class 0 OID 16686) -- Dependencies: 1519 -- Data for Name: employees; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (100, 'Steven', 'King', 'SKING', '515.123.4567', '1987-06-17', 'AD_PRES', 24000.00, NULL, NULL, 90); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568', '1989-09-21', 'AD_VP', 17000.00, NULL, 100, 90); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569', '1993-01-13', 'AD_VP', 17000.00, NULL, 100, 90); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567', '1990-01-03', 'IT_PROG', 9000.00, NULL, 102, 60); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568', '1991-05-21', 'IT_PROG', 6000.00, NULL, 103, 60); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (105, 'David', 'Austin', 'DAUSTIN', '590.423.4569', '1997-06-25', 'IT_PROG', 4800.00, NULL, 103, 60); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560', '1998-02-05', 'IT_PROG', 4800.00, NULL, 103, 60); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567', '1999-02-07', 'IT_PROG', 4200.00, NULL, 103, 60); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569', '1994-08-17', 'FI_MGR', 12000.00, NULL, 101, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169', '1994-08-16', 'FI_ACCOUNT', 9000.00, NULL, 108, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (110, 'John', 'Chen', 'JCHEN', '515.124.4269', '1997-09-28', 'FI_ACCOUNT', 8200.00, NULL, 108, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369', '1997-09-30', 'FI_ACCOUNT', 7700.00, NULL, 108, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469', '1998-03-07', 'FI_ACCOUNT', 7800.00, NULL, 108, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (113, 'Luis', 'Popp', 'LPOPP', '515.124.4567', '1999-12-07', 'FI_ACCOUNT', 6900.00, NULL, 108, 100); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (114, 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561', '1994-12-07', 'PU_MAN', 11000.00, NULL, 100, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562', '1995-05-18', 'PU_CLERK', 3100.00, NULL, 114, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (116, 'Shelli', 'Baida', 'SBAIDA', '515.127.4563', '1997-12-24', 'PU_CLERK', 2900.00, NULL, 114, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564', '1997-07-24', 'PU_CLERK', 2800.00, NULL, 114, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565', '1998-11-15', 'PU_CLERK', 2600.00, NULL, 114, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566', '1999-08-10', 'PU_CLERK', 2500.00, NULL, 114, 30); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234', '1996-07-18', 'ST_MAN', 8000.00, NULL, 100, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (121, 'Adam', 'Fripp', 'AFRIPP', '650.123.2234', '1997-04-10', 'ST_MAN', 8200.00, NULL, 100, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (122, 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234', '1995-05-01', 'ST_MAN', 7900.00, NULL, 100, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (123, 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234', '1997-10-10', 'ST_MAN', 6500.00, NULL, 100, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (124, 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234', '1999-11-16', 'ST_MAN', 5800.00, NULL, 100, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (125, 'Julia', 'Nayer', 'JNAYER', '650.124.1214', '1997-07-16', 'ST_CLERK', 3200.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (126, 'Irene', 'Mikkilineni', 'IMIKKILI', '650.124.1224', '1998-09-28', 'ST_CLERK', 2700.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (127, 'James', 'Landry', 'JLANDRY', '650.124.1334', '1999-01-14', 'ST_CLERK', 2400.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (128, 'Steven', 'Markle', 'SMARKLE', '650.124.1434', '2000-03-08', 'ST_CLERK', 2200.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (129, 'Laura', 'Bissot', 'LBISSOT', '650.124.5234', '1997-08-20', 'ST_CLERK', 3300.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (130, 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234', '1997-10-30', 'ST_CLERK', 2800.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (131, 'James', 'Marlow', 'JAMRLOW', '650.124.7234', '1997-02-16', 'ST_CLERK', 2500.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (132, 'TJ', 'Olson', 'TJOLSON', '650.124.8234', '1999-04-10', 'ST_CLERK', 2100.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (133, 'Jason', 'Mallin', 'JMALLIN', '650.127.1934', '1996-06-14', 'ST_CLERK', 3300.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (134, 'Michael', 'Rogers', 'MROGERS', '650.127.1834', '1998-08-26', 'ST_CLERK', 2900.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (135, 'Ki', 'Gee', 'KGEE', '650.127.1734', '1999-12-12', 'ST_CLERK', 2400.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (136, 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634', '2000-02-06', 'ST_CLERK', 2200.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (137, 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234', '1995-07-14', 'ST_CLERK', 3600.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (138, 'Stephen', 'Stiles', 'SSTILES', '650.121.2034', '1997-10-26', 'ST_CLERK', 3200.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (139, 'John', 'Seo', 'JSEO', '650.121.2019', '1998-02-12', 'ST_CLERK', 2700.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (140, 'Joshua', 'Patel', 'JPATEL', '650.121.1834', '1998-04-06', 'ST_CLERK', 2500.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (141, 'Trenna', 'Rajs', 'TRAJS', '650.121.8009', '1995-10-17', 'ST_CLERK', 3500.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (142, 'Curtis', 'Davies', 'CDAVIES', '650.121.2994', '1997-01-29', 'ST_CLERK', 3100.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (143, 'Randall', 'Matos', 'RMATOS', '650.121.2874', '1998-03-15', 'ST_CLERK', 2600.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (144, 'Peter', 'Vargas', 'PVARGAS', '650.121.2004', '1998-07-09', 'ST_CLERK', 2500.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (145, 'John', 'Russell', 'JRUSSEL', '011.44.1344.429268', '1996-10-01', 'SA_MAN', 14000.00, 0.40, 100, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (146, 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268', '1997-01-05', 'SA_MAN', 13500.00, 0.30, 100, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (147, 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278', '1997-03-10', 'SA_MAN', 12000.00, 0.30, 100, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (148, 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268', '1999-10-15', 'SA_MAN', 11000.00, 0.30, 100, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (149, 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018', '2000-01-29', 'SA_MAN', 10500.00, 0.20, 100, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (150, 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268', '1997-01-30', 'SA_REP', 10000.00, 0.30, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (151, 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268', '1997-03-24', 'SA_REP', 9500.00, 0.25, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (152, 'Peter', 'Hall', 'PHALL', '011.44.1344.478968', '1997-08-20', 'SA_REP', 9000.00, 0.25, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (153, 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718', '1998-03-30', 'SA_REP', 8000.00, 0.20, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (154, 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668', '1998-12-09', 'SA_REP', 7500.00, 0.20, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (155, 'Oliver', 'Tuvault', 'OTUVAULT', '011.44.1344.486508', '1999-11-23', 'SA_REP', 7000.00, 0.15, 145, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (156, 'Janette', 'King', 'JKING', '011.44.1345.429268', '1996-01-30', 'SA_REP', 10000.00, 0.35, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (157, 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268', '1996-03-04', 'SA_REP', 9500.00, 0.35, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (158, 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268', '1996-08-01', 'SA_REP', 9000.00, 0.35, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (159, 'Lindsey', 'Smith', 'LSMITH', '011.44.1345.729268', '1997-03-10', 'SA_REP', 8000.00, 0.30, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (160, 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268', '1997-12-15', 'SA_REP', 7500.00, 0.30, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (161, 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268', '1998-11-03', 'SA_REP', 7000.00, 0.25, 146, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (162, 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268', '1997-11-11', 'SA_REP', 10500.00, 0.25, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (163, 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268', '1999-03-19', 'SA_REP', 9500.00, 0.15, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (164, 'Mattea', 'Marvins', 'MMARVINS', '011.44.1346.329268', '2000-01-24', 'SA_REP', 7200.00, 0.10, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (165, 'David', 'Lee', 'DLEE', '011.44.1346.529268', '2000-02-23', 'SA_REP', 6800.00, 0.10, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (166, 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268', '2000-03-24', 'SA_REP', 6400.00, 0.10, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (167, 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268', '2000-04-21', 'SA_REP', 6200.00, 0.10, 147, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (168, 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268', '1997-03-11', 'SA_REP', 11500.00, 0.25, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (169, 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268', '1998-03-23', 'SA_REP', 10000.00, 0.20, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (170, 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268', '1998-01-24', 'SA_REP', 9600.00, 0.20, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (171, 'William', 'Smith', 'WSMITH', '011.44.1343.629268', '1999-02-23', 'SA_REP', 7400.00, 0.15, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (172, 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268', '1999-03-24', 'SA_REP', 7300.00, 0.15, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (173, 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268', '2000-04-21', 'SA_REP', 6100.00, 0.10, 148, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (174, 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267', '1996-05-11', 'SA_REP', 11000.00, 0.30, 149, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (175, 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266', '1997-03-19', 'SA_REP', 8800.00, 0.25, 149, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (176, 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265', '1998-03-24', 'SA_REP', 8600.00, 0.20, 149, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (177, 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264', '1998-04-23', 'SA_REP', 8400.00, 0.20, 149, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (178, 'Kimberely', 'Grant', 'KGRANT', '011.44.1644.429263', '1999-05-24', 'SA_REP', 7000.00, 0.15, 149, NULL); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (179, 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262', '2000-01-04', 'SA_REP', 6200.00, 0.10, 149, 80); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (180, 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876', '1998-01-24', 'SH_CLERK', 3200.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (181, 'Jean', 'Fleaur', 'JFLEAUR', '650.507.9877', '1998-02-23', 'SH_CLERK', 3100.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (182, 'Martha', 'Sullivan', 'MSULLIVA', '650.507.9878', '1999-06-21', 'SH_CLERK', 2500.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (183, 'Girard', 'Geoni', 'GGEONI', '650.507.9879', '2000-02-03', 'SH_CLERK', 2800.00, NULL, 120, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (184, 'Nandita', 'Sarchand', 'NSARCHAN', '650.509.1876', '1996-01-27', 'SH_CLERK', 4200.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (185, 'Alexis', 'Bull', 'ABULL', '650.509.2876', '1997-02-20', 'SH_CLERK', 4100.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (186, 'Julia', 'Dellinger', 'JDELLING', '650.509.3876', '1998-06-24', 'SH_CLERK', 3400.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (187, 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876', '1999-02-07', 'SH_CLERK', 3000.00, NULL, 121, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (188, 'Kelly', 'Chung', 'KCHUNG', '650.505.1876', '1997-06-14', 'SH_CLERK', 3800.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (189, 'Jennifer', 'Dilly', 'JDILLY', '650.505.2876', '1997-08-13', 'SH_CLERK', 3600.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (190, 'Timothy', 'Gates', 'TGATES', '650.505.3876', '1998-07-11', 'SH_CLERK', 2900.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (191, 'Randall', 'Perkins', 'RPERKINS', '650.505.4876', '1999-12-19', 'SH_CLERK', 2500.00, NULL, 122, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (192, 'Sarah', 'Bell', 'SBELL', '650.501.1876', '1996-02-04', 'SH_CLERK', 4000.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (193, 'Britney', 'Everett', 'BEVERETT', '650.501.2876', '1997-03-03', 'SH_CLERK', 3900.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (194, 'Samuel', 'McCain', 'SMCCAIN', '650.501.3876', '1998-07-01', 'SH_CLERK', 3200.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (195, 'Vance', 'Jones', 'VJONES', '650.501.4876', '1999-03-17', 'SH_CLERK', 2800.00, NULL, 123, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (196, 'Alana', 'Walsh', 'AWALSH', '650.507.9811', '1998-04-24', 'SH_CLERK', 3100.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (197, 'Kevin', 'Feeney', 'KFEENEY', '650.507.9822', '1998-05-23', 'SH_CLERK', 3000.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (198, 'Donald', 'OConnell', 'DOCONNEL', '650.507.9833', '1999-06-21', 'SH_CLERK', 2600.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (199, 'Douglas', 'Grant', 'DGRANT', '650.507.9844', '2000-01-13', 'SH_CLERK', 2600.00, NULL, 124, 50); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (200, 'Jennifer', 'Whalen', 'JWHALEN', '515.123.4444', '1987-09-17', 'AD_ASST', 4400.00, NULL, 101, 10); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (201, 'Michael', 'Hartstein', 'MHARTSTE', '515.123.5555', '1996-02-17', 'MK_MAN', 13000.00, NULL, 100, 20); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (202, 'Pat', 'Fay', 'PFAY', '603.123.6666', '1997-08-17', 'MK_REP', 6000.00, NULL, 201, 20); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (203, 'Susan', 'Mavris', 'SMAVRIS', '515.123.7777', '1994-06-07', 'HR_REP', 6500.00, NULL, 101, 40); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (204, 'Hermann', 'Baer', 'HBAER', '515.123.8888', '1994-06-07', 'PR_REP', 10000.00, NULL, 101, 70); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (205, 'Shelley', 'Higgins', 'SHIGGINS', '515.123.8080', '1994-06-07', 'AC_MGR', 12000.00, NULL, 101, 110); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) VALUES (206, 'William', 'Gietz', 'WGIETZ', '515.123.8181', '1994-06-07', 'AC_ACCOUNT', 8300.00, NULL, 205, 110); -- -- TOC entry 1838 (class 0 OID 16695) -- Dependencies: 1520 -- Data for Name: job_history; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (101, '1989-09-21', '1993-10-27', 'AC_ACCOUNT', 110); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (101, '1993-10-28', '1997-03-15', 'AC_MGR', 110); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (102, '1993-01-13', '1998-07-24', 'IT_PROG', 60); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (114, '1998-03-24', '1999-12-31', 'ST_CLERK', 50); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (122, '1999-01-01', '1999-12-31', 'ST_CLERK', 50); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (176, '1998-03-24', '1998-12-31', 'SA_REP', 80); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (176, '1999-01-01', '1999-12-31', 'SA_MAN', 80); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (200, '1987-09-17', '1993-06-17', 'AD_ASST', 90); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (200, '1994-07-01', '1998-12-31', 'AC_ACCOUNT', 90); INSERT INTO job_history (employee_id, start_date, end_date, job_id, department_id) VALUES (201, '1996-02-17', '1999-12-19', 'MK_REP', 20); -- -- TOC entry 1839 (class 0 OID 16700) -- Dependencies: 1521 -- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('AC_ACCOUNT', 'Public Accountant', 4200, 9000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('AC_MGR', 'Accounting Manager', 8200, 16000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('AD_ASST', 'Administration Assistant', 3000, 6000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('AD_PRES', 'President', 20000, 40000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('AD_VP', 'Administration Vice President', 15000, 30000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('FI_ACCOUNT', 'Accountant', 4200, 9000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('FI_MGR', 'Finance Manager', 8200, 16000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('HR_REP', 'Human Resources Representative', 4000, 9000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('IT_PROG', 'Programmer', 4000, 10000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('MK_MAN', 'Marketing Manager', 9000, 15000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('MK_REP', 'Marketing Representative', 4000, 9000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('PR_REP', 'Public Relations Representative', 4500, 10500); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('PU_CLERK', 'Purchasing Clerk', 2500, 5500); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('PU_MAN', 'Purchasing Manager', 8000, 15000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('SA_MAN', 'Sales Manager', 10000, 20000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('SA_REP', 'Sales Representative', 6000, 12000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('SH_CLERK', 'Shipping Clerk', 2500, 5500); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('ST_CLERK', 'Stock Clerk', 2000, 5000); INSERT INTO jobs (job_id, job_title, min_salary, max_salary) VALUES ('ST_MAN', 'Stock Manager', 5500, 8500); -- -- TOC entry 1840 (class 0 OID 16707) -- Dependencies: 1523 -- Data for Name: locations; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1000, '1297 Via Cola di Rie', '00989', 'Roma', NULL, 'IT'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1100, '93091 Calle della Testa', '10934', 'Venice', NULL, 'IT'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1200, '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture', 'JP'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1300, '9450 Kamiya-cho', '6823', 'Hiroshima', NULL, 'JP'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1400, '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1500, '2011 Interiors Blvd', '99236', 'South San Francisco', 'California', 'US'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1600, '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey', 'US'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1700, '2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1800, '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario', 'CA'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (1900, '6092 Boxwood St', 'YSW 9T2', 'Whitehorse', 'Yukon', 'CA'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2000, '40-5-12 Laogianggen', '190518', 'Beijing', NULL, 'CN'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2100, '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra', 'IN'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2200, '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales', 'AU'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2300, '198 Clementi North', '540198', 'Singapore', NULL, 'SG'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2400, '8204 Arthur St', NULL, 'London', NULL, 'UK'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2500, 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB', 'Oxford', 'Oxford', 'UK'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2600, '9702 Chester Road', '09629850293', 'Stretford', 'Manchester', 'UK'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2700, 'Schwanthalerstr. 7031', '80925', 'Munich', 'Bavaria', 'DE'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2800, 'Rua Frei Caneca 1360 ', '01307-002', 'Sao Paulo', 'Sao Paulo', 'BR'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (2900, '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve', 'CH'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (3000, 'Murtenstrasse 921', '3095', 'Bern', 'BE', 'CH'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (3100, 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht', 'NL'); INSERT INTO locations (location_id, street_address, postal_code, city, state_province, country_id) VALUES (3200, 'Mariano Escobedo 9991', '11932', 'Mexico City', 'Distrito Federal,', 'MX'); -- -- TOC entry 1841 (class 0 OID 16713) -- Dependencies: 1524 -- Data for Name: regions; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO regions (region_id, region_name) VALUES (1, 'Europe'); INSERT INTO regions (region_id, region_name) VALUES (2, 'Americas'); INSERT INTO regions (region_id, region_name) VALUES (3, 'Asia'); INSERT INTO regions (region_id, region_name) VALUES (4, 'Middle East and Africa'); -- -- TOC entry 1799 (class 2606 OID 16675) -- Dependencies: 1515 1515 -- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY countries ADD CONSTRAINT countries_pkey PRIMARY KEY (country_id); -- -- TOC entry 1801 (class 2606 OID 16683) -- Dependencies: 1517 1517 -- Name: departments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY departments ADD CONSTRAINT departments_pkey PRIMARY KEY (department_id); -- -- TOC entry 1805 (class 2606 OID 16694) -- Dependencies: 1519 1519 -- Name: emp_email_uk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY employees ADD CONSTRAINT emp_email_uk UNIQUE (email); -- -- TOC entry 1810 (class 2606 OID 16692) -- Dependencies: 1519 1519 -- Name: employees_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY employees ADD CONSTRAINT employees_pkey PRIMARY KEY (employee_id); -- -- TOC entry 1815 (class 2606 OID 16699) -- Dependencies: 1520 1520 1520 -- Name: job_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY job_history ADD CONSTRAINT job_history_pkey PRIMARY KEY (employee_id, start_date); -- -- TOC entry 1817 (class 2606 OID 16704) -- Dependencies: 1521 1521 -- Name: jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY jobs ADD CONSTRAINT jobs_pkey PRIMARY KEY (job_id); -- -- TOC entry 1822 (class 2606 OID 16712) -- Dependencies: 1523 1523 -- Name: locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY locations ADD CONSTRAINT locations_pkey PRIMARY KEY (location_id); -- -- TOC entry 1824 (class 2606 OID 16717) -- Dependencies: 1524 1524 -- Name: regions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY regions ADD CONSTRAINT regions_pkey PRIMARY KEY (region_id); -- -- TOC entry 1802 (class 1259 OID 16719) -- Dependencies: 1517 -- Name: dept_location_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX dept_location_ix ON departments USING btree (location_id); -- -- TOC entry 1803 (class 1259 OID 16720) -- Dependencies: 1519 -- Name: emp_department_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emp_department_ix ON employees USING btree (department_id); -- -- TOC entry 1806 (class 1259 OID 16721) -- Dependencies: 1519 -- Name: emp_job_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emp_job_ix ON employees USING btree (job_id); -- -- TOC entry 1807 (class 1259 OID 16722) -- Dependencies: 1519 -- Name: emp_manager_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emp_manager_ix ON employees USING btree (manager_id); -- -- TOC entry 1808 (class 1259 OID 16723) -- Dependencies: 1519 1519 -- Name: emp_name_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emp_name_ix ON employees USING btree (last_name, first_name); -- -- TOC entry 1811 (class 1259 OID 16724) -- Dependencies: 1520 -- Name: jhist_department_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX jhist_department_ix ON job_history USING btree (department_id); -- -- TOC entry 1812 (class 1259 OID 16725) -- Dependencies: 1520 -- Name: jhist_employee_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX jhist_employee_ix ON job_history USING btree (employee_id); -- -- TOC entry 1813 (class 1259 OID 16726) -- Dependencies: 1520 -- Name: jhist_job_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX jhist_job_ix ON job_history USING btree (job_id); -- -- TOC entry 1818 (class 1259 OID 16727) -- Dependencies: 1523 -- Name: loc_city_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX loc_city_ix ON locations USING btree (city); -- -- TOC entry 1819 (class 1259 OID 16728) -- Dependencies: 1523 -- Name: loc_country_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX loc_country_ix ON locations USING btree (country_id); -- -- TOC entry 1820 (class 1259 OID 16729) -- Dependencies: 1523 -- Name: loc_state_province_ix; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX loc_state_province_ix ON locations USING btree (state_province); -- -- TOC entry 1825 (class 2606 OID 16775) -- Dependencies: 1515 1524 1823 -- Name: countries_region_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY countries ADD CONSTRAINT countries_region_id_fkey FOREIGN KEY (region_id) REFERENCES regions(region_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1827 (class 2606 OID 16770) -- Dependencies: 1523 1821 1517 -- Name: departments_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY departments ADD CONSTRAINT departments_location_id_fkey FOREIGN KEY (location_id) REFERENCES locations(location_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1826 (class 2606 OID 16745) -- Dependencies: 1519 1517 1809 -- Name: departments_manager_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY departments ADD CONSTRAINT departments_manager_id_fkey FOREIGN KEY (manager_id) REFERENCES employees(employee_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1828 (class 2606 OID 16735) -- Dependencies: 1519 1517 1800 -- Name: employees_department_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY employees ADD CONSTRAINT employees_department_id_fkey FOREIGN KEY (department_id) REFERENCES departments(department_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1830 (class 2606 OID 16760) -- Dependencies: 1521 1519 1816 -- Name: employees_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY employees ADD CONSTRAINT employees_job_id_fkey FOREIGN KEY (job_id) REFERENCES jobs(job_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1829 (class 2606 OID 16750) -- Dependencies: 1519 1519 1809 -- Name: employees_manager_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY employees ADD CONSTRAINT employees_manager_id_fkey FOREIGN KEY (manager_id) REFERENCES employees(employee_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1831 (class 2606 OID 16740) -- Dependencies: 1800 1520 1517 -- Name: job_history_department_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY job_history ADD CONSTRAINT job_history_department_id_fkey FOREIGN KEY (department_id) REFERENCES departments(department_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1832 (class 2606 OID 16755) -- Dependencies: 1519 1520 1809 -- Name: job_history_employee_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY job_history ADD CONSTRAINT job_history_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES employees(employee_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1833 (class 2606 OID 16765) -- Dependencies: 1521 1520 1816 -- Name: job_history_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY job_history ADD CONSTRAINT job_history_job_id_fkey FOREIGN KEY (job_id) REFERENCES jobs(job_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1834 (class 2606 OID 16730) -- Dependencies: 1798 1515 1523 -- Name: locations_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY locations ADD CONSTRAINT locations_country_id_fkey FOREIGN KEY (country_id) REFERENCES countries(country_id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- -- TOC entry 1846 (class 0 OID 0) -- Dependencies: 3 -- 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; -- Completed on 2008-02-22 01:20:44 -- -- PostgreSQL database dump complete --