· 8 years ago · Jun 25, 2018, 04:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.7
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Mar 20, 2015 at 01:43 AM
7-- Server version: 5.5.34-cll-lve
8-- PHP Version: 5.4.23
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `wrpracti_bookinfo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `countries`
27--
28
29CREATE TABLE IF NOT EXISTS `countries` (
30 `COUNTRY_ID` varchar(2) NOT NULL,
31 `COUNTRY_NAME` varchar(40) DEFAULT NULL,
32 `REGION_ID` decimal(10,0) DEFAULT NULL,
33 PRIMARY KEY (`COUNTRY_ID`),
34 KEY `COUNTR_REG_FK` (`REGION_ID`)
35) ENGINE=MyISAM DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `countries`
39--
40
41INSERT INTO `countries` (`COUNTRY_ID`, `COUNTRY_NAME`, `REGION_ID`) VALUES
42('AR', 'Argentina', '2'),
43('AU', 'Australia', '3'),
44('BE', 'Belgium', '1'),
45('BR', 'Brazil', '2'),
46('CA', 'Canada', '2'),
47('CH', 'Switzerland', '1'),
48('CN', 'China', '3'),
49('DE', 'Germany', '1'),
50('DK', 'Denmark', '1'),
51('EG', 'Egypt', '4'),
52('FR', 'France', '1'),
53('HK', 'HongKong', '3'),
54('IL', 'Israel', '4'),
55('IN', 'India', '3'),
56('IT', 'Italy', '1'),
57('JP', 'Japan', '3'),
58('KW', 'Kuwait', '4'),
59('MX', 'Mexico', '2'),
60('NG', 'Nigeria', '4'),
61('NL', 'Netherlands', '1'),
62('SG', 'Singapore', '3'),
63('UK', 'United Kingdom', '1'),
64('US', 'United States of America', '2'),
65('ZM', 'Zambia', '4'),
66('ZW', 'Zimbabwe', '4');
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `departments`
72--
73
74CREATE TABLE IF NOT EXISTS `departments` (
75 `DEPARTMENT_ID` decimal(4,0) NOT NULL DEFAULT '0',
76 `DEPARTMENT_NAME` varchar(30) NOT NULL,
77 `MANAGER_ID` decimal(6,0) DEFAULT NULL,
78 `LOCATION_ID` decimal(4,0) DEFAULT NULL,
79 PRIMARY KEY (`DEPARTMENT_ID`),
80 KEY `DEPT_MGR_FK` (`MANAGER_ID`),
81 KEY `DEPT_LOCATION_IX` (`LOCATION_ID`)
82) ENGINE=MyISAM DEFAULT CHARSET=latin1;
83
84--
85-- Dumping data for table `departments`
86--
87
88INSERT INTO `departments` (`DEPARTMENT_ID`, `DEPARTMENT_NAME`, `MANAGER_ID`, `LOCATION_ID`) VALUES
89('10', 'Administration', '200', '1700'),
90('20', 'Marketing', '201', '1800'),
91('30', 'Purchasing', '114', '1700'),
92('40', 'Human Resources', '203', '2400'),
93('50', 'Shipping', '121', '1500'),
94('60', 'IT', '103', '1400'),
95('70', 'Public Relations', '204', '2700'),
96('80', 'Sales', '145', '2500'),
97('90', 'Executive', '100', '1700'),
98('100', 'Finance', '108', '1700'),
99('110', 'Accounting', '205', '1700'),
100('120', 'Treasury', '0', '1700'),
101('130', 'Corporate Tax', '0', '1700'),
102('140', 'Control And Credit', '0', '1700'),
103('150', 'Shareholder Services', '0', '1700'),
104('160', 'Benefits', '0', '1700'),
105('170', 'Manufacturing', '0', '1700'),
106('180', 'Construction', '0', '1700'),
107('190', 'Contracting', '0', '1700'),
108('200', 'Operations', '0', '1700'),
109('210', 'IT Support', '0', '1700'),
110('220', 'NOC', '0', '1700'),
111('230', 'IT Helpdesk', '0', '1700'),
112('240', 'Government Sales', '0', '1700'),
113('250', 'Retail Sales', '0', '1700'),
114('260', 'Recruiting', '0', '1700'),
115('270', 'Payroll', '0', '1700');
116
117-- --------------------------------------------------------
118
119--
120-- Table structure for table `employees`
121--
122
123CREATE TABLE IF NOT EXISTS `employees` (
124 `EMPLOYEE_ID` decimal(6,0) NOT NULL DEFAULT '0',
125 `FIRST_NAME` varchar(20) DEFAULT NULL,
126 `LAST_NAME` varchar(25) NOT NULL,
127 `EMAIL` varchar(25) NOT NULL,
128 `PHONE_NUMBER` varchar(20) DEFAULT NULL,
129 `HIRE_DATE` date NOT NULL,
130 `JOB_ID` varchar(10) NOT NULL,
131 `SALARY` decimal(8,2) DEFAULT NULL,
132 `COMMISSION_PCT` decimal(2,2) DEFAULT NULL,
133 `MANAGER_ID` decimal(6,0) DEFAULT NULL,
134 `DEPARTMENT_ID` decimal(4,0) DEFAULT NULL,
135 PRIMARY KEY (`EMPLOYEE_ID`),
136 UNIQUE KEY `EMP_EMAIL_UK` (`EMAIL`),
137 KEY `EMP_DEPARTMENT_IX` (`DEPARTMENT_ID`),
138 KEY `EMP_JOB_IX` (`JOB_ID`),
139 KEY `EMP_MANAGER_IX` (`MANAGER_ID`),
140 KEY `EMP_NAME_IX` (`LAST_NAME`,`FIRST_NAME`)
141) ENGINE=MyISAM DEFAULT CHARSET=latin1;
142
143--
144-- Dumping data for table `employees`
145--
146
147INSERT INTO `employees` (`EMPLOYEE_ID`, `FIRST_NAME`, `LAST_NAME`, `EMAIL`, `PHONE_NUMBER`, `HIRE_DATE`, `JOB_ID`, `SALARY`, `COMMISSION_PCT`, `MANAGER_ID`, `DEPARTMENT_ID`) VALUES
148('100', 'Steven', 'King', 'SKING', '515.123.4567', '1987-06-17', 'AD_PRES', '24000.00', '0.00', '0', '90'),
149('101', 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568', '1987-06-18', 'AD_VP', '17000.00', '0.00', '100', '90'),
150('102', 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569', '1987-06-19', 'AD_VP', '17000.00', '0.00', '100', '90'),
151('103', 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567', '1987-06-20', 'IT_PROG', '9000.00', '0.00', '102', '60'),
152('104', 'Bruce', 'Ernst', 'BERNST', '590.423.4568', '1987-06-21', 'IT_PROG', '6000.00', '0.00', '103', '60'),
153('105', 'David', 'Austin', 'DAUSTIN', '590.423.4569', '1987-06-22', 'IT_PROG', '4800.00', '0.00', '103', '60'),
154('106', 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560', '1987-06-23', 'IT_PROG', '4800.00', '0.00', '103', '60'),
155('107', 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567', '1987-06-24', 'IT_PROG', '4200.00', '0.00', '103', '60'),
156('108', 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569', '1987-06-25', 'FI_MGR', '12000.00', '0.00', '101', '100'),
157('109', 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169', '1987-06-26', 'FI_ACCOUNT', '9000.00', '0.00', '108', '100'),
158('110', 'John', 'Chen', 'JCHEN', '515.124.4269', '1987-06-27', 'FI_ACCOUNT', '8200.00', '0.00', '108', '100'),
159('111', 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369', '1987-06-28', 'FI_ACCOUNT', '7700.00', '0.00', '108', '100'),
160('112', 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469', '1987-06-29', 'FI_ACCOUNT', '7800.00', '0.00', '108', '100'),
161('113', 'Luis', 'Popp', 'LPOPP', '515.124.4567', '1987-06-30', 'FI_ACCOUNT', '6900.00', '0.00', '108', '100'),
162('114', 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561', '1987-07-01', 'PU_MAN', '11000.00', '0.00', '100', '30'),
163('115', 'Alexander', 'Khoo', 'AKHOO', '515.127.4562', '1987-07-02', 'PU_CLERK', '3100.00', '0.00', '114', '30'),
164('116', 'Shelli', 'Baida', 'SBAIDA', '515.127.4563', '1987-07-03', 'PU_CLERK', '2900.00', '0.00', '114', '30'),
165('117', 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564', '1987-07-04', 'PU_CLERK', '2800.00', '0.00', '114', '30'),
166('118', 'Guy', 'Himuro', 'GHIMURO', '515.127.4565', '1987-07-05', 'PU_CLERK', '2600.00', '0.00', '114', '30'),
167('119', 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566', '1987-07-06', 'PU_CLERK', '2500.00', '0.00', '114', '30'),
168('120', 'Matthew', 'Weiss', 'MWEISS', '650.123.1234', '1987-07-07', 'ST_MAN', '8000.00', '0.00', '100', '50'),
169('121', 'Adam', 'Fripp', 'AFRIPP', '650.123.2234', '1987-07-08', 'ST_MAN', '8200.00', '0.00', '100', '50'),
170('122', 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234', '1987-07-09', 'ST_MAN', '7900.00', '0.00', '100', '50'),
171('123', 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234', '1987-07-10', 'ST_MAN', '6500.00', '0.00', '100', '50'),
172('124', 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234', '1987-07-11', 'ST_MAN', '5800.00', '0.00', '100', '50'),
173('125', 'Julia', 'Nayer', 'JNAYER', '650.124.1214', '1987-07-12', 'ST_CLERK', '3200.00', '0.00', '120', '50'),
174('126', 'Irene', 'Mikkilineni', 'IMIKKILI', '650.124.1224', '1987-07-13', 'ST_CLERK', '2700.00', '0.00', '120', '50'),
175('127', 'James', 'Landry', 'JLANDRY', '650.124.1334', '1987-07-14', 'ST_CLERK', '2400.00', '0.00', '120', '50'),
176('128', 'Steven', 'Markle', 'SMARKLE', '650.124.1434', '1987-07-15', 'ST_CLERK', '2200.00', '0.00', '120', '50'),
177('129', 'Laura', 'Bissot', 'LBISSOT', '650.124.5234', '1987-07-16', 'ST_CLERK', '3300.00', '0.00', '121', '50'),
178('130', 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234', '1987-07-17', 'ST_CLERK', '2800.00', '0.00', '121', '50'),
179('131', 'James', 'Marlow', 'JAMRLOW', '650.124.7234', '1987-07-18', 'ST_CLERK', '2500.00', '0.00', '121', '50'),
180('132', 'TJ', 'Olson', 'TJOLSON', '650.124.8234', '1987-07-19', 'ST_CLERK', '2100.00', '0.00', '121', '50'),
181('133', 'Jason', 'Mallin', 'JMALLIN', '650.127.1934', '1987-07-20', 'ST_CLERK', '3300.00', '0.00', '122', '50'),
182('134', 'Michael', 'Rogers', 'MROGERS', '650.127.1834', '1987-07-21', 'ST_CLERK', '2900.00', '0.00', '122', '50'),
183('135', 'Ki', 'Gee', 'KGEE', '650.127.1734', '1987-07-22', 'ST_CLERK', '2400.00', '0.00', '122', '50'),
184('136', 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634', '1987-07-23', 'ST_CLERK', '2200.00', '0.00', '122', '50'),
185('137', 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234', '1987-07-24', 'ST_CLERK', '3600.00', '0.00', '123', '50'),
186('138', 'Stephen', 'Stiles', 'SSTILES', '650.121.2034', '1987-07-25', 'ST_CLERK', '3200.00', '0.00', '123', '50'),
187('139', 'John', 'Seo', 'JSEO', '650.121.2019', '1987-07-26', 'ST_CLERK', '2700.00', '0.00', '123', '50'),
188('140', 'Joshua', 'Patel', 'JPATEL', '650.121.1834', '1987-07-27', 'ST_CLERK', '2500.00', '0.00', '123', '50'),
189('141', 'Trenna', 'Rajs', 'TRAJS', '650.121.8009', '1987-07-28', 'ST_CLERK', '3500.00', '0.00', '124', '50'),
190('142', 'Curtis', 'Davies', 'CDAVIES', '650.121.2994', '1987-07-29', 'ST_CLERK', '3100.00', '0.00', '124', '50'),
191('143', 'Randall', 'Matos', 'RMATOS', '650.121.2874', '1987-07-30', 'ST_CLERK', '2600.00', '0.00', '124', '50'),
192('144', 'Peter', 'Vargas', 'PVARGAS', '650.121.2004', '1987-07-31', 'ST_CLERK', '2500.00', '0.00', '124', '50'),
193('145', 'John', 'Russell', 'JRUSSEL', '011.44.1344.429268', '1987-08-01', 'SA_MAN', '14000.00', '0.40', '100', '80'),
194('146', 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268', '1987-08-02', 'SA_MAN', '13500.00', '0.30', '100', '80'),
195('147', 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278', '1987-08-03', 'SA_MAN', '12000.00', '0.30', '100', '80'),
196('148', 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268', '1987-08-04', 'SA_MAN', '11000.00', '0.30', '100', '80'),
197('149', 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018', '1987-08-05', 'SA_MAN', '10500.00', '0.20', '100', '80'),
198('150', 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268', '1987-08-06', 'SA_REP', '10000.00', '0.30', '145', '80'),
199('151', 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268', '1987-08-07', 'SA_REP', '9500.00', '0.25', '145', '80'),
200('152', 'Peter', 'Hall', 'PHALL', '011.44.1344.478968', '1987-08-08', 'SA_REP', '9000.00', '0.25', '145', '80'),
201('153', 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718', '1987-08-09', 'SA_REP', '8000.00', '0.20', '145', '80'),
202('154', 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668', '1987-08-10', 'SA_REP', '7500.00', '0.20', '145', '80'),
203('155', 'Oliver', 'Tuvault', 'OTUVAULT', '011.44.1344.486508', '1987-08-11', 'SA_REP', '7000.00', '0.15', '145', '80'),
204('156', 'Janette', 'King', 'JKING', '011.44.1345.429268', '1987-08-12', 'SA_REP', '10000.00', '0.35', '146', '80'),
205('157', 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268', '1987-08-13', 'SA_REP', '9500.00', '0.35', '146', '80'),
206('158', 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268', '1987-08-14', 'SA_REP', '9000.00', '0.35', '146', '80'),
207('159', 'Lindsey', 'Smith', 'LSMITH', '011.44.1345.729268', '1987-08-15', 'SA_REP', '8000.00', '0.30', '146', '80'),
208('160', 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268', '1987-08-16', 'SA_REP', '7500.00', '0.30', '146', '80'),
209('161', 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268', '1987-08-17', 'SA_REP', '7000.00', '0.25', '146', '80'),
210('162', 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268', '1987-08-18', 'SA_REP', '10500.00', '0.25', '147', '80'),
211('163', 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268', '1987-08-19', 'SA_REP', '9500.00', '0.15', '147', '80'),
212('164', 'Mattea', 'Marvins', 'MMARVINS', '011.44.1346.329268', '1987-08-20', 'SA_REP', '7200.00', '0.10', '147', '80'),
213('165', 'David', 'Lee', 'DLEE', '011.44.1346.529268', '1987-08-21', 'SA_REP', '6800.00', '0.10', '147', '80'),
214('166', 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268', '1987-08-22', 'SA_REP', '6400.00', '0.10', '147', '80'),
215('167', 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268', '1987-08-23', 'SA_REP', '6200.00', '0.10', '147', '80'),
216('168', 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268', '1987-08-24', 'SA_REP', '11500.00', '0.25', '148', '80'),
217('169', 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268', '1987-08-25', 'SA_REP', '10000.00', '0.20', '148', '80'),
218('170', 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268', '1987-08-26', 'SA_REP', '9600.00', '0.20', '148', '80'),
219('171', 'William', 'Smith', 'WSMITH', '011.44.1343.629268', '1987-08-27', 'SA_REP', '7400.00', '0.15', '148', '80'),
220('172', 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268', '1987-08-28', 'SA_REP', '7300.00', '0.15', '148', '80'),
221('173', 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268', '1987-08-29', 'SA_REP', '6100.00', '0.10', '148', '80'),
222('174', 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267', '1987-08-30', 'SA_REP', '11000.00', '0.30', '149', '80'),
223('175', 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266', '1987-08-31', 'SA_REP', '8800.00', '0.25', '149', '80'),
224('176', 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265', '1987-09-01', 'SA_REP', '8600.00', '0.20', '149', '80'),
225('177', 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264', '1987-09-02', 'SA_REP', '8400.00', '0.20', '149', '80'),
226('178', 'Kimberely', 'Grant', 'KGRANT', '011.44.1644.429263', '1987-09-03', 'SA_REP', '7000.00', '0.15', '149', '0'),
227('179', 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262', '1987-09-04', 'SA_REP', '6200.00', '0.10', '149', '80'),
228('180', 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876', '1987-09-05', 'SH_CLERK', '3200.00', '0.00', '120', '50'),
229('181', 'Jean', 'Fleaur', 'JFLEAUR', '650.507.9877', '1987-09-06', 'SH_CLERK', '3100.00', '0.00', '120', '50'),
230('182', 'Martha', 'Sullivan', 'MSULLIVA', '650.507.9878', '1987-09-07', 'SH_CLERK', '2500.00', '0.00', '120', '50'),
231('183', 'Girard', 'Geoni', 'GGEONI', '650.507.9879', '1987-09-08', 'SH_CLERK', '2800.00', '0.00', '120', '50'),
232('184', 'Nandita', 'Sarchand', 'NSARCHAN', '650.509.1876', '1987-09-09', 'SH_CLERK', '4200.00', '0.00', '121', '50'),
233('185', 'Alexis', 'Bull', 'ABULL', '650.509.2876', '1987-09-10', 'SH_CLERK', '4100.00', '0.00', '121', '50'),
234('186', 'Julia', 'Dellinger', 'JDELLING', '650.509.3876', '1987-09-11', 'SH_CLERK', '3400.00', '0.00', '121', '50'),
235('187', 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876', '1987-09-12', 'SH_CLERK', '3000.00', '0.00', '121', '50'),
236('188', 'Kelly', 'Chung', 'KCHUNG', '650.505.1876', '1987-09-13', 'SH_CLERK', '3800.00', '0.00', '122', '50'),
237('189', 'Jennifer', 'Dilly', 'JDILLY', '650.505.2876', '1987-09-14', 'SH_CLERK', '3600.00', '0.00', '122', '50'),
238('190', 'Timothy', 'Gates', 'TGATES', '650.505.3876', '1987-09-15', 'SH_CLERK', '2900.00', '0.00', '122', '50'),
239('191', 'Randall', 'Perkins', 'RPERKINS', '650.505.4876', '1987-09-16', 'SH_CLERK', '2500.00', '0.00', '122', '50'),
240('192', 'Sarah', 'Bell', 'SBELL', '650.501.1876', '1987-09-17', 'SH_CLERK', '4000.00', '0.00', '123', '50'),
241('193', 'Britney', 'Everett', 'BEVERETT', '650.501.2876', '1987-09-18', 'SH_CLERK', '3900.00', '0.00', '123', '50'),
242('194', 'Samuel', 'McCain', 'SMCCAIN', '650.501.3876', '1987-09-19', 'SH_CLERK', '3200.00', '0.00', '123', '50'),
243('195', 'Vance', 'Jones', 'VJONES', '650.501.4876', '1987-09-20', 'SH_CLERK', '2800.00', '0.00', '123', '50'),
244('196', 'Alana', 'Walsh', 'AWALSH', '650.507.9811', '1987-09-21', 'SH_CLERK', '3100.00', '0.00', '124', '50'),
245('197', 'Kevin', 'Feeney', 'KFEENEY', '650.507.9822', '1987-09-22', 'SH_CLERK', '3000.00', '0.00', '124', '50'),
246('198', 'Donald', 'OConnell', 'DOCONNEL', '650.507.9833', '1987-09-23', 'SH_CLERK', '2600.00', '0.00', '124', '50'),
247('199', 'Douglas', 'Grant', 'DGRANT', '650.507.9844', '1987-09-24', 'SH_CLERK', '2600.00', '0.00', '124', '50'),
248('200', 'Jennifer', 'Whalen', 'JWHALEN', '515.123.4444', '1987-09-25', 'AD_ASST', '4400.00', '0.00', '101', '10'),
249('201', 'Michael', 'Hartstein', 'MHARTSTE', '515.123.5555', '1987-09-26', 'MK_MAN', '13000.00', '0.00', '100', '20'),
250('202', 'Pat', 'Fay', 'PFAY', '603.123.6666', '1987-09-27', 'MK_REP', '6000.00', '0.00', '201', '20'),
251('203', 'Susan', 'Mavris', 'SMAVRIS', '515.123.7777', '1987-09-28', 'HR_REP', '6500.00', '0.00', '101', '40'),
252('204', 'Hermann', 'Baer', 'HBAER', '515.123.8888', '1987-09-29', 'PR_REP', '10000.00', '0.00', '101', '70'),
253('205', 'Shelley', 'Higgins', 'SHIGGINS', '515.123.8080', '1987-09-30', 'AC_MGR', '12000.00', '0.00', '101', '110'),
254('206', 'William', 'Gietz', 'WGIETZ', '515.123.8181', '1987-10-01', 'AC_ACCOUNT', '8300.00', '0.00', '205', '110');
255
256-- --------------------------------------------------------
257
258--
259-- Table structure for table `job_history`
260--
261
262CREATE TABLE IF NOT EXISTS `job_history` (
263 `EMPLOYEE_ID` decimal(6,0) NOT NULL,
264 `START_DATE` date NOT NULL,
265 `END_DATE` date NOT NULL,
266 `JOB_ID` varchar(10) NOT NULL,
267 `DEPARTMENT_ID` decimal(4,0) DEFAULT NULL,
268 PRIMARY KEY (`EMPLOYEE_ID`,`START_DATE`),
269 KEY `JHIST_DEPARTMENT_IX` (`DEPARTMENT_ID`),
270 KEY `JHIST_EMPLOYEE_IX` (`EMPLOYEE_ID`),
271 KEY `JHIST_JOB_IX` (`JOB_ID`)
272) ENGINE=MyISAM DEFAULT CHARSET=latin1;
273
274--
275-- Dumping data for table `job_history`
276--
277
278INSERT INTO `job_history` (`EMPLOYEE_ID`, `START_DATE`, `END_DATE`, `JOB_ID`, `DEPARTMENT_ID`) VALUES
279('102', '1993-01-13', '1998-07-24', 'IT_PROG', '60'),
280('101', '1989-09-21', '1993-10-27', 'AC_ACCOUNT', '110'),
281('101', '1993-10-28', '1997-03-15', 'AC_MGR', '110'),
282('201', '1996-02-17', '1999-12-19', 'MK_REP', '20'),
283('114', '1998-03-24', '1999-12-31', 'ST_CLERK', '50'),
284('122', '1999-01-01', '1999-12-31', 'ST_CLERK', '50'),
285('200', '1987-09-17', '1993-06-17', 'AD_ASST', '90'),
286('176', '1998-03-24', '1998-12-31', 'SA_REP', '80'),
287('176', '1999-01-01', '1999-12-31', 'SA_MAN', '80'),
288('200', '1994-07-01', '1998-12-31', 'AC_ACCOUNT', '90'),
289('0', '0000-00-00', '0000-00-00', '', '0');
290
291-- --------------------------------------------------------
292
293--
294-- Table structure for table `jobs`
295--
296
297CREATE TABLE IF NOT EXISTS `jobs` (
298 `JOB_ID` varchar(10) NOT NULL DEFAULT '',
299 `JOB_TITLE` varchar(35) NOT NULL,
300 `MIN_SALARY` decimal(6,0) DEFAULT NULL,
301 `MAX_SALARY` decimal(6,0) DEFAULT NULL,
302 PRIMARY KEY (`JOB_ID`)
303) ENGINE=MyISAM DEFAULT CHARSET=latin1;
304
305--
306-- Dumping data for table `jobs`
307--
308
309INSERT INTO `jobs` (`JOB_ID`, `JOB_TITLE`, `MIN_SALARY`, `MAX_SALARY`) VALUES
310('AD_PRES', 'President', '20000', '40000'),
311('AD_VP', 'Administration Vice President', '15000', '30000'),
312('AD_ASST', 'Administration Assistant', '3000', '6000'),
313('FI_MGR', 'Finance Manager', '8200', '16000'),
314('FI_ACCOUNT', 'Accountant', '4200', '9000'),
315('AC_MGR', 'Accounting Manager', '8200', '16000'),
316('AC_ACCOUNT', 'Public Accountant', '4200', '9000'),
317('SA_MAN', 'Sales Manager', '10000', '20000'),
318('SA_REP', 'Sales Representative', '6000', '12000'),
319('PU_MAN', 'Purchasing Manager', '8000', '15000'),
320('PU_CLERK', 'Purchasing Clerk', '2500', '5500'),
321('ST_MAN', 'Stock Manager', '5500', '8500'),
322('ST_CLERK', 'Stock Clerk', '2000', '5000'),
323('SH_CLERK', 'Shipping Clerk', '2500', '5500'),
324('IT_PROG', 'Programmer', '4000', '10000'),
325('MK_MAN', 'Marketing Manager', '9000', '15000'),
326('MK_REP', 'Marketing Representative', '4000', '9000'),
327('HR_REP', 'Human Resources Representative', '4000', '9000'),
328('PR_REP', 'Public Relations Representative', '4500', '10500');
329
330-- --------------------------------------------------------
331
332--
333-- Table structure for table `locations`
334--
335
336CREATE TABLE IF NOT EXISTS `locations` (
337 `LOCATION_ID` decimal(4,0) NOT NULL DEFAULT '0',
338 `STREET_ADDRESS` varchar(40) DEFAULT NULL,
339 `POSTAL_CODE` varchar(12) DEFAULT NULL,
340 `CITY` varchar(30) NOT NULL,
341 `STATE_PROVINCE` varchar(25) DEFAULT NULL,
342 `COUNTRY_ID` varchar(2) DEFAULT NULL,
343 PRIMARY KEY (`LOCATION_ID`),
344 KEY `LOC_CITY_IX` (`CITY`),
345 KEY `LOC_COUNTRY_IX` (`COUNTRY_ID`),
346 KEY `LOC_STATE_PROVINCE_IX` (`STATE_PROVINCE`)
347) ENGINE=MyISAM DEFAULT CHARSET=latin1;
348
349--
350-- Dumping data for table `locations`
351--
352
353INSERT INTO `locations` (`LOCATION_ID`, `STREET_ADDRESS`, `POSTAL_CODE`, `CITY`, `STATE_PROVINCE`, `COUNTRY_ID`) VALUES
354('1000', '1297 Via Cola di Rie', '989', 'Roma', '', 'IT'),
355('1100', '93091 Calle della Testa', '10934', 'Venice', '', 'IT'),
356('1200', '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture', 'JP'),
357('1300', '9450 Kamiya-cho', '6823', 'Hiroshima', '', 'JP'),
358('1400', '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'),
359('1500', '2011 Interiors Blvd', '99236', 'South San Francisco', 'California', 'US'),
360('1600', '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey', 'US'),
361('1700', '2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'),
362('1800', '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario', 'CA'),
363('1900', '6092 Boxwood St', 'YSW 9T2', 'Whitehorse', 'Yukon', 'CA'),
364('2000', '40-5-12 Laogianggen', '190518', 'Beijing', '', 'CN'),
365('2100', '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra', 'IN'),
366('2200', '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales', 'AU'),
367('2300', '198 Clementi North', '540198', 'Singapore', '', 'SG'),
368('2400', '8204 Arthur St', '', 'London', '', 'UK'),
369('2500', '"Magdalen Centre', ' The Oxford ', 'OX9 9ZB', 'Oxford', 'Ox'),
370('2600', '9702 Chester Road', '9629850293', 'Stretford', 'Manchester', 'UK'),
371('2700', 'Schwanthalerstr. 7031', '80925', 'Munich', 'Bavaria', 'DE'),
372('2800', 'Rua Frei Caneca 1360', '01307-002', 'Sao Paulo', 'Sao Paulo', 'BR'),
373('2900', '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve', 'CH'),
374('3000', 'Murtenstrasse 921', '3095', 'Bern', 'BE', 'CH'),
375('3100', 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht', 'NL'),
376('3200', 'Mariano Escobedo 9991', '11932', 'Mexico City', '"Distrito Federal', '"');
377
378-- --------------------------------------------------------
379
380--
381-- Table structure for table `regions`
382--
383
384CREATE TABLE IF NOT EXISTS `regions` (
385 `REGION_ID` decimal(5,0) NOT NULL,
386 `REGION_NAME` varchar(25) DEFAULT NULL,
387 PRIMARY KEY (`REGION_ID`),
388 UNIQUE KEY `sss` (`REGION_NAME`)
389) ENGINE=MyISAM DEFAULT CHARSET=latin1;
390
391--
392-- Dumping data for table `regions`
393--
394
395INSERT INTO `regions` (`REGION_ID`, `REGION_NAME`) VALUES
396('1', 'Europe\r'),
397('2', 'Americas\r'),
398('3', 'Asia\r'),
399('4', 'Middle East and Africa\r');
400
401/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
402/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
403/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;