![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to installPEOPLE.sqlsybase CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / DistributedEO|
Return to installPEOPLE.sqlsybase CVS log | Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / DistributedEO |
1.1 root 1: use EOFTest
2: go
3:
4: drop table EMPLOYEE
5: drop table DEPARTMENT
6: drop table FACILITY
7: drop table EMP_PROJECT
8: drop table PROJECT
9: drop table EMP_PHOTO
10: drop table EMP_QUOTE
11: drop table JOB_TITLE
12: drop table EMP_EQUIPMENT
13: drop table UNIQUE_KEY
14: go
15:
16:
17: /******************************************************************************
18: * Create the tables.
19: ******************************************************************************/
20: create table EMPLOYEE (
21: EMP_ID int,
22: DEPT_ID int null,
23: LAST_NAME varchar(40),
24: FIRST_NAME varchar(40),
25: PHONE char(12) null,
26: ADDRESS varchar(40) null,
27: CITY varchar(20) null,
28: STATE char(2) null,
29: ZIP char(5) null,
30: TITLE_ID int null,
31: HIRE_DATE datetime null,
32: MANAGER int null,
33: SALARY float null,
34: LOCK varchar(40) null
35: )
36: grant all on EMPLOYEE to public
37: go
38:
39: create table DEPARTMENT (
40: DEPT_ID int,
41: DEPARTMENT_NAME varchar(30),
42: LOCATION_ID int
43: )
44: grant all on DEPARTMENT to public
45: go
46:
47: create table FACILITY (
48: LOCATION_ID int,
49: LOCATION varchar(30),
50: PHOTO image null
51: )
52: grant all on FACILITY to public
53: go
54:
55: create table EMP_PROJECT (
56: EMP_ID int,
57: PROJECT_ID int,
58: )
59: grant all on EMP_PROJECT to public
60: go
61:
62: create table PROJECT (
63: PROJECT_ID int,
64: PROJECT_NAME varchar(30),
65: SUMMARY_IMAGE image null
66: )
67: grant all on PROJECT to public
68: go
69:
70: create table EMP_PHOTO (
71: EMP_ID int,
72: PHOTO image null
73: )
74: grant all on EMP_PHOTO to public
75: go
76:
77: create table EMP_QUOTE (
78: EMP_ID int,
79: QUOTE image null
80: )
81: grant all on EMP_QUOTE to public
82: go
83:
84: create table JOB_TITLE (
85: TITLE_ID int,
86: TITLE varchar(30),
87: TITLE_TYPE varchar(12)
88: )
89: grant all on JOB_TITLE to public
90: go
91:
92: create table EMP_EQUIPMENT (
93: ASSET_TAG int,
94: DESCRIPTION varchar(100) null,
95: SERIAL_NUMBER varchar(20) null,
96: EMP_ID int null
97: )
98: grant all on EMP_EQUIPMENT to public
99: go
100:
101:
102: /******************************************************************************
103: * Insert values.
104: ******************************************************************************/
105: begin transaction
106: go
107:
108: insert into FACILITY values(1101, 'Waterfront One', null)
109: insert into FACILITY values(1103, 'Hillside 1', null)
110: insert into FACILITY values(1106, 'Hillside 2', null)
111: insert into FACILITY values(1207, 'Embarcadero', null)
112: insert into FACILITY values(1104, 'Arcada', null)
113: go
114:
115: insert into EMP_PROJECT values (101, 501)
116: insert into EMP_PROJECT values (102, 503)
117: insert into EMP_PROJECT values (103, 507)
118: insert into EMP_PROJECT values (104, 510)
119: insert into EMP_PROJECT values (105, 512)
120: insert into EMP_PROJECT values (106, 501)
121: insert into EMP_PROJECT values (107, 503)
122: insert into EMP_PROJECT values (108, 507)
123: insert into EMP_PROJECT values (109, 510)
124: insert into EMP_PROJECT values (110, 512)
125: insert into EMP_PROJECT values (111, 501)
126: insert into EMP_PROJECT values (112, 503)
127: insert into EMP_PROJECT values (113, 507)
128: insert into EMP_PROJECT values (114, 510)
129: insert into EMP_PROJECT values (115, 512)
130: insert into EMP_PROJECT values (116, 501)
131: insert into EMP_PROJECT values (117, 503)
132: insert into EMP_PROJECT values (118, 507)
133: insert into EMP_PROJECT values (119, 510)
134: insert into EMP_PROJECT values (120, 512)
135: insert into EMP_PROJECT values (121, 501)
136: insert into EMP_PROJECT values (122, 503)
137: insert into EMP_PROJECT values (123, 507)
138: insert into EMP_PROJECT values (124, 510)
139: insert into EMP_PROJECT values (125, 512)
140: insert into EMP_PROJECT values (126, 501)
141: insert into EMP_PROJECT values (127, 503)
142: insert into EMP_PROJECT values (128, 507)
143: insert into EMP_PROJECT values (129, 510)
144: insert into EMP_PROJECT values (130, 512)
145: insert into EMP_PROJECT values (131, 501)
146: insert into EMP_PROJECT values (132, 503)
147: insert into EMP_PROJECT values (133, 507)
148: insert into EMP_PROJECT values (134, 510)
149: insert into EMP_PROJECT values (135, 512)
150: insert into EMP_PROJECT values (136, 501)
151: insert into EMP_PROJECT values (137, 503)
152: insert into EMP_PROJECT values (138, 507)
153: insert into EMP_PROJECT values (139, 510)
154: insert into EMP_PROJECT values (140, 512)
155: insert into EMP_PROJECT values (141, 501)
156: insert into EMP_PROJECT values (142, 503)
157: insert into EMP_PROJECT values (143, 507)
158: insert into EMP_PROJECT values (144, 510)
159: insert into EMP_PROJECT values (145, 512)
160: insert into EMP_PROJECT values (146, 501)
161: insert into EMP_PROJECT values (147, 503)
162: insert into EMP_PROJECT values (148, 507)
163: insert into EMP_PROJECT values (149, 510)
164: insert into EMP_PROJECT values (150, 512)
165: insert into EMP_PROJECT values (151, 501)
166: insert into EMP_PROJECT values (152, 503)
167: insert into EMP_PROJECT values (153, 507)
168: insert into EMP_PROJECT values (154, 510)
169: insert into EMP_PROJECT values (155, 512)
170: insert into EMP_PROJECT values (156, 501)
171: insert into EMP_PROJECT values (157, 503)
172: insert into EMP_PROJECT values (158, 507)
173: insert into EMP_PROJECT values (159, 510)
174: insert into EMP_PROJECT values (160, 512)
175: insert into EMP_PROJECT values (161, 501)
176: insert into EMP_PROJECT values (162, 503)
177: insert into EMP_PROJECT values (163, 507)
178: insert into EMP_PROJECT values (164, 510)
179: insert into EMP_PROJECT values (165, 512)
180: insert into EMP_PROJECT values (166, 501)
181: insert into EMP_PROJECT values (167, 503)
182: insert into EMP_PROJECT values (168, 507)
183: insert into EMP_PROJECT values (169, 510)
184: insert into EMP_PROJECT values (170, 512)
185: insert into EMP_PROJECT values (171, 501)
186: insert into EMP_PROJECT values (172, 503)
187: insert into EMP_PROJECT values (173, 507)
188: insert into EMP_PROJECT values (174, 510)
189: insert into EMP_PROJECT values (175, 512)
190: insert into EMP_PROJECT values (176, 501)
191: insert into EMP_PROJECT values (177, 503)
192: insert into EMP_PROJECT values (178, 507)
193: insert into EMP_PROJECT values (179, 510)
194: insert into EMP_PROJECT values (180, 512)
195: insert into EMP_PROJECT values (181, 501)
196: insert into EMP_PROJECT values (182, 503)
197: insert into EMP_PROJECT values (183, 507)
198: insert into EMP_PROJECT values (184, 510)
199: insert into EMP_PROJECT values (185, 512)
200: insert into EMP_PROJECT values (186, 501)
201: insert into EMP_PROJECT values (187, 503)
202: insert into EMP_PROJECT values (188, 507)
203: insert into EMP_PROJECT values (189, 510)
204: insert into EMP_PROJECT values (190, 512)
205: insert into EMP_PROJECT values (191, 501)
206: insert into EMP_PROJECT values (192, 503)
207: insert into EMP_PROJECT values (193, 507)
208: insert into EMP_PROJECT values (194, 510)
209: insert into EMP_PROJECT values (195, 512)
210: insert into EMP_PROJECT values (196, 501)
211: insert into EMP_PROJECT values (197, 503)
212: insert into EMP_PROJECT values (198, 507)
213: insert into EMP_PROJECT values (199, 510)
214: insert into EMP_PROJECT values (200, 512)
215: insert into EMP_PROJECT values (201, 501)
216: insert into EMP_PROJECT values (202, 503)
217: insert into EMP_PROJECT values (203, 507)
218: insert into EMP_PROJECT values (204, 510)
219: insert into EMP_PROJECT values (205, 512)
220: insert into EMP_PROJECT values (206, 501)
221: insert into EMP_PROJECT values (207, 503)
222: insert into EMP_PROJECT values (208, 507)
223: insert into EMP_PROJECT values (209, 510)
224: insert into EMP_PROJECT values (210, 512)
225: insert into EMP_PROJECT values (211, 501)
226: insert into EMP_PROJECT values (212, 503)
227: insert into EMP_PROJECT values (213, 507)
228: insert into EMP_PROJECT values (214, 510)
229: insert into EMP_PROJECT values (215, 512)
230: insert into EMP_PROJECT values (216, 501)
231: insert into EMP_PROJECT values (217, 503)
232: insert into EMP_PROJECT values (218, 507)
233: insert into EMP_PROJECT values (219, 510)
234: insert into EMP_PROJECT values (220, 512)
235: insert into EMP_PROJECT values (221, 501)
236: insert into EMP_PROJECT values (222, 503)
237: insert into EMP_PROJECT values (223, 507)
238: insert into EMP_PROJECT values (224, 510)
239: insert into EMP_PROJECT values (225, 512)
240: go
241:
242:
243: insert into PROJECT values( 501, 'BankLink Financials', null)
244: insert into PROJECT values( 503, 'Crossover Environment', null)
245: insert into PROJECT values( 507, 'Net DesignWorks', null)
246: insert into PROJECT values( 510, 'InfoVault', null)
247: insert into PROJECT values( 512, 'Customer Satisfaction', null)
248: go
249:
250:
251: insert into DEPARTMENT values (100, 'General and Administration', 1104)
252: insert into DEPARTMENT values (101, 'Office of the President', 1207)
253: insert into DEPARTMENT values (104, 'Reception', 1104)
254: insert into DEPARTMENT values (105, 'Adminstration', 1103)
255: insert into DEPARTMENT values (200, 'Production and Design', 1103)
256: insert into DEPARTMENT values (201, 'Art Design', 1104)
257: insert into DEPARTMENT values (202, 'Hardware Engineering', 1106)
258: insert into DEPARTMENT values (203, 'System Software', 1106)
259: insert into DEPARTMENT values (204, 'User Software', 1101)
260: insert into DEPARTMENT values (250, 'Production', 1106)
261: insert into DEPARTMENT values (252, 'Logistics', 1101)
262: insert into DEPARTMENT values (300, 'Sales and Marketing', 1207)
263: insert into DEPARTMENT values (320, 'Domestic Marketing', 1207)
264: insert into DEPARTMENT values (330, 'International Marketing', 1207)
265: insert into DEPARTMENT values (350, 'Sales', 1207)
266: insert into DEPARTMENT values (400, 'Customer Service', 1106)
267: insert into DEPARTMENT values (405, 'Service Logistics', 1106)
268: insert into DEPARTMENT values (410, 'Customer Front-Line', 1106)
269: insert into DEPARTMENT values (420, 'Customer Back-Line', 1106)
270: insert into DEPARTMENT values (500, 'Personnel', 1101)
271: insert into DEPARTMENT values (900, 'Public Relations', 1104)
272: go
273:
274:
275: insert into JOB_TITLE values (1, 'President', 'Salaried')
276: insert into JOB_TITLE values (2, 'Vice President', 'Salaried')
277: insert into JOB_TITLE values (3, 'Director', 'Salaried')
278: insert into JOB_TITLE values (4, 'MANAGER', 'Salaried')
279: insert into JOB_TITLE values (5, 'Engineer', 'Hourly')
280: insert into JOB_TITLE values (6, 'Designer', 'Hourly')
281: insert into JOB_TITLE values (7, 'Sales Representative', 'Salaried')
282: insert into JOB_TITLE values (8, 'Administrator', 'Hourly')
283: insert into JOB_TITLE values (9, 'Customer Representative', 'Hourly')
284: insert into JOB_TITLE values (10, 'Product MANAGER', 'Salaried')
285: insert into JOB_TITLE values (11, 'Benefits and Compensation', 'Hourly')
286: insert into JOB_TITLE values (12, 'Associate', 'Hourly')
287: go
288:
289: insert into EMPLOYEE values ( 101, 101, 'Winston', 'James', '415-323-7265',
290: '6269 Washington Ave.', 'Woodside', 'CA', '94160', 1,
291: 'Jan 14 1989 12:00:00:000AM', 101, 5700.00, null )
292:
293: insert into EMPLOYEE values ( 102, 200, 'Veasey', 'Kai', '415-323-261 ',
294: '3401 Strand St.', 'Woodside', 'CA', '94153', 2,
295: 'Aug 19 1991 12:00:00:000AM', 1, 4600.00, null )
296:
297: insert into EMPLOYEE values ( 103, 400, 'MacAskill', 'Debra', '415-328-4407',
298: '3495 Middlefield Ave.', 'Mountain View', 'CA', '94245', 2,
299: 'Nov 19 1992 12:00:00:000AM', 101, 4300.00, null )
300:
301: insert into EMPLOYEE values ( 104, 104, 'Oswald', 'Lesley', '415-321-564 ',
302: '6751 Chowen St.', 'Sunnyvale', 'CA', '94234', 4,
303: 'Jun 20 1994 12:00:00:000AM', 101, 4200.00, null )
304:
305: insert into EMPLOYEE values ( 105, 320,'Scheer', 'Janine', '415-327-9345',
306: '295 Poplar Road', 'San Jose', 'CA', '94226', 4,
307: 'Jan 5 1990 12:00:00:000AM', 107, 5700.00, null )
308:
309: insert into EMPLOYEE values ( 106, 500, 'Maselli', 'John', '415-328-9769',
310: '3494 Pelican Ave.', 'Palo Alto', 'CA', '94226', 2,
311: 'Apr 16 1992 12:00:00:000AM', 101, 4900.00, null )
312:
313: insert into EMPLOYEE values ( 107, 300, 'Lunau', 'Ken', '415-322-2815',
314: '7163 York Road', 'Woodside', 'CA', '94174', 2,
315: 'Dec 12 1991 12:00:00:000AM', 101, 5600.00, null )
316:
317: insert into EMPLOYEE values ( 108, 203, 'DeKeyser', 'John', '415-326-9241',
318: '5633 High Road', 'Mountain View', 'CA', '94228', 3,
319: 'Nov 18 1989 12:00:00:000AM', 102, 5200.00, null )
320:
321: insert into EMPLOYEE values ( 109, 900, 'Windgate', 'Mark', '415-321-3718',
322: '4615 Oak Ave.', 'Oakland', 'CA', '94194', 2,
323: 'Feb 20 1990 12:00:00:000AM', 101, 4000.00, null )
324:
325: insert into EMPLOYEE values ( 110, 400,'Walsh', 'Phyllis', '415-327-2599',
326: '3746 Oak Road', 'Palo Alto', 'CA', '94165', 5,
327: 'Aug 14 1991 12:00:00:000AM', 103, 4900.00, null )
328:
329: insert into EMPLOYEE values ( 111, 203, 'Quan', 'Merianne', '415-323-9827',
330: '7503 Washington Blvd.', 'Redwood City', 'CA', '94223', 5,
331: 'Apr 6 1988 12:00:00:000AM', 102, 4700.00, null )
332:
333: insert into EMPLOYEE values ( 112, 300, 'Kanzaki', 'Mark', '415-324-7911',
334: '2709 Kristen St.', 'Woodside', 'CA', '94219', 3,
335: 'Apr 5 1988 12:00:00:000AM', 107, 4500.00, null )
336:
337: insert into EMPLOYEE values ( 113, 400, 'Helton', 'Dung', '415-320-6474',
338: '4397 Schoman Road', 'Woodside', 'CA', '94173', 5,
339: 'Oct 9 1990 12:00:00:000AM', 103, 5600.00, null )
340:
341: insert into EMPLOYEE values ( 114, 200, 'Thiry', 'Greg', '415-326-4613',
342: '3883 Drew Road', 'Redwood City', 'CA', '94198', 10,
343: 'Mar 13 1988 12:00:00:000AM', 102, 4700.00, null )
344:
345: insert into EMPLOYEE values ( 115, 400,'Gath', 'Jon', '415-322-1987',
346: '502 Johnson St.', 'Santa Clara', 'CA', '94209', 5,
347: 'Nov 4 1989 12:00:00:000AM', 103, 5100.00, null )
348:
349: insert into EMPLOYEE values ( 116, 203, 'Kallimani', 'Yoshinori', '415-322-6335',
350: '7099 Knuth Ave.', 'San Jose', 'CA', '94214', 3,
351: 'Dec 26 1990 12:00:00:000AM', 102, 4200.00, null )
352:
353: insert into EMPLOYEE values ( 117, 405, 'Hojnowski', 'Gregor', '415-323-2994',
354: '5215 Strand Way', 'Pacific Heights', 'CA', '94209', 5,
355: 'Oct 25 1992 12:00:00:000AM', 103, 5200.00, null )
356:
357: insert into EMPLOYEE values ( 118, 300, 'Tautz', 'Denise', '415-322-3937',
358: '7851 Oak Trail', 'Woodside', 'CA', '94181', 10,
359: 'Mar 3 1992 12:00:00:000AM', 107, 5100.00, null )
360:
361: insert into EMPLOYEE values ( 119, 500, 'Upson', 'Alex', '415-323-11 ',
362: '1440 Addams Circle', 'Mountain View', 'CA', '94193', 4,
363: 'Sep 9 1989 12:00:00:000AM', 106, 4900.00, null )
364:
365: insert into EMPLOYEE values ( 120, 350,'Riley', 'Michael', '415-323-2795',
366: '7747 Pope Road', 'Redwood City', 'CA', '94195', 7,
367: 'Feb 3 1991 12:00:00:000AM', 107, 4300.00, null )
368: go
369:
370: insert into EMPLOYEE values ( 121, 252, 'Kammerer', 'Sanjay', '415-328-3042',
371: '7331 Walnut Ave.', 'Palo Alto', 'CA', '94178', 5,
372: 'Jan 9 1990 12:00:00:000AM', 102, 4700.00, null )
373:
374: insert into EMPLOYEE values ( 122, 405, 'Affinito', 'Jon', '415-326-515 ',
375: '639 Schoman Ave.', 'Woodside', 'CA', '94239', 5,
376: 'May 1 1988 12:00:00:000AM', 103, 5000.00, null )
377:
378: insert into EMPLOYEE values ( 123, 400, 'Liu', 'Tom', '415-321-1766',
379: '3342 Main St.', 'Sunnyvale', 'CA', '94219', 5,
380: 'Jan 6 1989 12:00:00:000AM', 103, 4700.00, null )
381:
382: insert into EMPLOYEE values ( 124, 410, 'Walton', 'Jennifer', '415-324-4697',
383: '2673 France St.', 'Santa Clara', 'CA', '94157', 4,
384: 'Jan 18 1990 12:00:00:000AM', 103, 5700.00, null )
385:
386: insert into EMPLOYEE values ( 125, 101,'Page', 'Paul', '415-320-8100',
387: '2754 Johnson Ave.', 'Redwood City', 'CA', '94170', 4,
388: 'Aug 18 1992 12:00:00:000AM', 101, 4200.00, null )
389:
390: insert into EMPLOYEE values ( 126, 105, 'Seng', 'Paul', '415-320-7249',
391: '4876 High Road', 'Half Moon Bay', 'CA', '94171', 6,
392: 'Jul 2 1988 12:00:00:000AM', 101, 5000.00, null )
393:
394: insert into EMPLOYEE values ( 127, 101, 'Nelson', 'Andrew', '415-323-1072',
395: '562 Knuth Circle', 'Palo Alto', 'CA', '94164', 11,
396: 'Nov 14 1988 12:00:00:000AM', 101, 5300.00, null )
397:
398: insert into EMPLOYEE values ( 128, 252, 'Tucker', 'Karen', '415-323-1180',
399: '1952 Lutece St.', 'Atherton', 'CA', '94195', 5,
400: 'Nov 12 1989 12:00:00:000AM', 102, 5700.00, null )
401:
402: insert into EMPLOYEE values ( 129, 410, 'Tavana', 'Jim', '415-321-4763',
403: '7067 Broad Road', 'Woodside', 'CA', '94236', 4,
404: 'May 5 1992 12:00:00:000AM', 103, 5500.00, null )
405:
406: insert into EMPLOYEE values ( 130, 250,'Paquette', 'Satch', '415-326-4537',
407: '6972 York Road', 'Pacific Heights', 'CA', '94158', 5,
408: 'Apr 27 1992 12:00:00:000AM', 102, 4800.00, null )
409:
410: insert into EMPLOYEE values ( 131, 350, 'Egner', 'Andy', '415-322-8602',
411: '4106 Poplar St.', 'Redwood City', 'CA', '94246', 7,
412: 'Sep 3 1990 12:00:00:000AM', 107, 5700.00, null )
413:
414: insert into EMPLOYEE values ( 132, 104, 'Page', 'Opal', '415-323-4670',
415: '859 Poplar St.', 'Redwood City', 'CA', '94218', 6,
416: 'Mar 27 1989 12:00:00:000AM', 101, 5300.00, null )
417:
418: insert into EMPLOYEE values ( 133, 203, 'Bay', 'Rosalie', '415-320-3763',
419: '6535 Juneberry Ave.', 'Mountain View', 'CA', '94243', 4,
420: 'Feb 5 1992 12:00:00:000AM', 102, 4300.00, null )
421:
422: insert into EMPLOYEE values ( 134, 300, 'Fisk', 'George', '415-326-4655',
423: '4346 Connell Circle', 'Atherton', 'CA', '94211', 3,
424: 'May 1 1991 12:00:00:000AM', 107, 5700.00, null )
425:
426: insert into EMPLOYEE values ( 135, 252,'Hecker', 'Junko', '415-321-7489',
427: '3930 York Ave.', 'Redwood City', 'CA', '94178', 5,
428: 'Jan 24 1988 12:00:00:000AM', 102, 4700.00, null )
429:
430: insert into EMPLOYEE values ( 136, 101, 'Walsh', 'Guiseppe', '415-328-2963',
431: '1209 High Road', 'Atherton', 'CA', '94172', 10,
432: 'Nov 28 1992 12:00:00:000AM', 101, 4200.00, null )
433:
434: insert into EMPLOYEE values ( 137, 105, 'Davidson', 'Cary', '415-322-7699',
435: '4773 York St.', 'Santa Clara', 'CA', '94160', 3,
436: 'May 23 1989 12:00:00:000AM', 101, 5600.00, null )
437:
438: insert into EMPLOYEE values ( 138, 250, 'Burt', 'Elida', '415-324-444 ',
439: '939 Middlefield St.', 'Santa Clara', 'CA', '94232', 5,
440: 'Apr 6 1988 12:00:00:000AM', 102, 4500.00, null )
441:
442: insert into EMPLOYEE values ( 139, 900, 'Kelleher', 'Leonard', '415-328-569 ',
443: '3481 Knox St.', 'Palo Alto', 'CA', '94246', 12,
444: 'Jul 27 1990 12:00:00:000AM', 109, 4600.00, null )
445:
446: insert into EMPLOYEE values ( 140, 203,'Henriquez', 'Dave', '415-320-6936',
447: '3790 Market Road', 'Belmont', 'CA', '94219', 5,
448: 'Oct 10 1992 12:00:00:000AM', 102, 5700.00, null )
449: go
450:
451: insert into EMPLOYEE values ( 141, 252, 'Fuster', 'Manny', '415-325-3468',
452: '6688 Poplar Blvd.', 'Millbrae', 'CA', '94187', 4,
453: 'Dec 15 1990 12:00:00:000AM', 102, 5100.00, null )
454:
455: insert into EMPLOYEE values ( 142, 104, 'Cleary', 'Kathi', '415-320-3912',
456: '2746 Schoman St.', 'Redwood City', 'CA', '94150', 11,
457: 'Nov 23 1991 12:00:00:000AM', 101, 5100.00, null )
458:
459: insert into EMPLOYEE values ( 143, 350, 'Moore', 'Debra', '415-326-5087',
460: '4126 Lutece Ave.', 'San Jose', 'CA', '94237', 7,
461: 'Apr 4 1991 12:00:00:000AM', 107, 5000.00, null )
462:
463: insert into EMPLOYEE values ( 144, 100, 'Hopkins', 'Chris', '415-321-8620',
464: '1482 Elm Ave.', 'Oakland', 'CA', '94198', 7,
465: 'Aug 13 1991 12:00:00:000AM', 101, 5300.00, null )
466:
467: insert into EMPLOYEE values ( 145, 204,'Self', 'Jack', '415-325-767 ',
468: '7044 Walnut Road', 'Half Moon Bay', 'CA', '94164', 4,
469: 'Nov 5 1990 12:00:00:000AM', 102, 5500.00, null )
470:
471: insert into EMPLOYEE values ( 146, 500, 'Cerbone', 'Mark', '415-322-2943',
472: '7137 Juneberry Road', 'San Francisco', 'CA', '94172', 3,
473: 'May 13 1991 12:00:00:000AM', 106, 4300.00, null )
474:
475: insert into EMPLOYEE values ( 147, 202, 'Ralston', 'Anne', '415-323-4177',
476: '3599 Beech Ave.', 'Palo Alto', 'CA', '94169', 5,
477: 'Jul 20 1991 12:00:00:000AM', 102, 5000.00, null )
478:
479: insert into EMPLOYEE values ( 148, 250, 'Henry', 'John', '415-322-5562',
480: '7645 Lancaster Ave.', 'Belmont', 'CA', '94231', 5,
481: 'Jan 14 1991 12:00:00:000AM', 102, 4500.00, null )
482:
483: insert into EMPLOYEE values ( 149, 200, 'Kinney', 'Alex', '415-327-8472',
484: '4044 Hanson St.', 'Mountain View', 'CA', '94239', 6,
485: 'Sep 24 1990 12:00:00:000AM', 102, 5300.00, null )
486:
487: insert into EMPLOYEE values ( 150, 420,'Moore', 'James', '415-325-4316',
488: '6425 Broad Ave.', 'Redwood City', 'CA', '94244', 5,
489: 'Aug 23 1989 12:00:00:000AM', 103, 5600.00, null )
490:
491: insert into EMPLOYEE values ( 151, 105, 'Nguyen', 'Jorg', '415-322-2523',
492: '5531 Knuth St.', 'Pacific Heights', 'CA', '94192', 11,
493: 'Feb 27 1990 12:00:00:000AM', 101, 5600.00, null )
494:
495: insert into EMPLOYEE values ( 152, 330, 'Veasey', 'David', '415-320-1483',
496: '3999 Juneberry Road', 'Belmont', 'CA', '94177', 10,
497: 'Dec 8 1992 12:00:00:000AM', 107, 4400.00, null )
498:
499: insert into EMPLOYEE values ( 153, 350, 'Morse', 'Guy', '415-328-6708',
500: '1276 Middlefield Ave.', 'Atherton', 'CA', '94234', 7,
501: 'Apr 4 1991 12:00:00:000AM', 107, 4000.00, null )
502:
503: insert into EMPLOYEE values ( 154, 350, 'Fordam', 'Donna', '415-320-2744',
504: '7712 Chowen St.', 'Oakland', 'CA', '94215', 7,
505: 'Mar 21 1990 12:00:00:000AM', 107, 4800.00, null )
506:
507: insert into EMPLOYEE values ( 155, 320,'Walsh', 'James', '415-323-7264',
508: '3532 Anderson St.', 'San Francisco', 'CA', '94179', 10,
509: 'Aug 23 1990 12:00:00:000AM', 107, 4200.00, null )
510:
511: insert into EMPLOYEE values ( 156, 420, 'Fukasawa', 'Ben', '415-327-4471',
512: '5337 Kristen Blvd.', 'Palo Alto', 'CA', '94207', 5,
513: 'Sep 23 1989 12:00:00:000AM', 103, 4300.00, null )
514:
515: insert into EMPLOYEE values ( 157, 200, 'Yu', 'Martin', '415-321-9787',
516: '7580 High Ave.', 'Palo Alto', 'CA', '94186', 3,
517: 'Dec 26 1991 12:00:00:000AM', 102, 4800.00, null )
518:
519: insert into EMPLOYEE values ( 158, 201, 'Hodor', 'Lee', '415-328-151 ',
520: '2669 Sparrow Ave.', 'Belmont', 'CA', '94194', 6,
521: 'Feb 22 1988 12:00:00:000AM', 102, 4000.00, null )
522:
523: insert into EMPLOYEE values ( 159, 203, 'Naroff', 'Unjieng,', '415-322-8693',
524: '5176 Lincoln St.', 'San Francisco', 'CA', '94168', 5,
525: 'Jan 5 1990 12:00:00:000AM', 102, 5300.00, null )
526:
527: insert into EMPLOYEE values ( 160, 330,'Lee', 'Eric', '415-326-9238',
528: '3234 Connell St.', 'San Francisco', 'CA', '94198', 3,
529: 'Jan 22 1989 12:00:00:000AM', 107, 4900.00, null )
530: go
531:
532: insert into EMPLOYEE values ( 161, 330, 'Barber', 'Bart', '415-320-7854',
533: '7277 Shorebird St.', 'Half Moon Bay', 'CA', '94243', 10,
534: 'Jul 18 1991 12:00:00:000AM', 107, 4200.00, null )
535:
536: insert into EMPLOYEE values ( 162, 900, 'Patel', 'Jim', '415-322-3915',
537: '2767 Drew St.', 'Sunnyvale', 'CA', '94214', 12,
538: 'Jul 12 1992 12:00:00:000AM', 109, 5400.00, null )
539:
540: insert into EMPLOYEE values ( 163, 900, 'Vergnot', 'Glenn', '415-324-287 ',
541: '6882 Connell St.', 'San Francisco', 'CA', '94236', 3,
542: 'Aug 18 1991 12:00:00:000AM', 109, 4300.00, null )
543:
544: insert into EMPLOYEE values ( 164, 104, 'Hertz', 'Christian', '415-321-3157',
545: '1884 Pope St.', 'San Jose', 'CA', '94208', 3,
546: 'Oct 12 1989 12:00:00:000AM', 101, 4000.00, null )
547:
548: insert into EMPLOYEE values ( 165, 350,'Etcheverry', 'Jon', '415-328-714 ',
549: '2996 Lutece St.', 'Belmont', 'CA', '94216', 7,
550: 'Feb 21 1988 12:00:00:000AM', 107, 4200.00, null )
551:
552: insert into EMPLOYEE values ( 166, 101, 'Burt', 'Alice', '415-320-3192',
553: '5114 Lancaster St.', 'Pacific Heights', 'CA', '94241', 3,
554: 'Oct 14 1992 12:00:00:000AM', 101, 5200.00, null )
555:
556: insert into EMPLOYEE values ( 167, 350, 'Novak', 'Russ', '415-326-281 ',
557: '6478 Spruce Trail', 'Mountain View', 'CA', '94185', 7,
558: 'Apr 13 1989 12:00:00:000AM', 107, 4900.00, null )
559:
560: insert into EMPLOYEE values ( 168, 202, 'Francis', 'Vicki', '415-321-8842',
561: '2391 Broadway Ave.', 'Redwood City', 'CA', '94220', 5,
562: 'Jul 24 1991 12:00:00:000AM', 102, 4200.00, null )
563:
564: insert into EMPLOYEE values ( 169, 201, 'Jochims', 'Hal', '415-324-8628',
565: '6030 State Ave.', 'Palo Alto', 'CA', '94217', 6,
566: 'Jul 21 1992 12:00:00:000AM', 102, 4200.00, null )
567:
568: insert into EMPLOYEE values ( 170, 900,'Tucker', 'Tom', '415-328-2067',
569: '3258 Wallace St.', 'Mountain View', 'CA', '94246', 12,
570: 'Mar 18 1988 12:00:00:000AM', 109, 4600.00, null )
571:
572: insert into EMPLOYEE values ( 171, 252, 'Herald', 'Ellen', '415-321-1238',
573: '674 Addams Road', 'San Francisco', 'CA', '94228', 5,
574: 'Feb 5 1990 12:00:00:000AM', 102, 5300.00, null )
575:
576: insert into EMPLOYEE values ( 172, 405, 'Anthony', 'Mitch', '415-322-3205',
577: '5062 Hanson Trail', 'Half Moon Bay', 'CA', '94218', 5,
578: 'May 26 1991 12:00:00:000AM', 103, 4600.00, null )
579:
580: insert into EMPLOYEE values ( 173, 350, 'Fuster', 'Lane', '415-320-9534',
581: '7796 Main Ave.', 'Sunnyvale', 'CA', '94163', 7,
582: 'Jan 25 1988 12:00:00:000AM', 107, 4300.00, null )
583:
584: insert into EMPLOYEE values ( 174, 350, 'Dunham', 'Jim', '415-320-691 ',
585: '3866 Lancaster St.', 'Mountain View', 'CA', '94190', 7,
586: 'Jul 9 1988 12:00:00:000AM', 107, 4700.00, null )
587:
588: insert into EMPLOYEE values ( 175, 300,'Ferrante', 'Kristen', '415-324-6344',
589: '6086 Broad Blvd.', 'Sunnyvale', 'CA', '94216', 4,
590: 'Apr 14 1990 12:00:00:000AM', 107, 5100.00, null )
591:
592: insert into EMPLOYEE values ( 176, 202, 'Manross', 'Ken', '415-325-8979',
593: '2452 Lincoln Blvd.', 'Pacific Heights', 'CA', '94228', 5,
594: 'Feb 18 1988 12:00:00:000AM', 102, 5600.00, null )
595:
596: insert into EMPLOYEE values ( 177, 105, 'Dahlbeck', 'Olivier', '415-326-2780',
597: '3510 Wallace Trail', 'Millbrae', 'CA', '94187', 5,
598: 'Mar 12 1988 12:00:00:000AM', 101, 4600.00, null )
599:
600: insert into EMPLOYEE values ( 178, 400, 'Meyer', 'Bonnie', '415-324-140 ',
601: '1885 Kristen St.', 'Belmont', 'CA', '94155', 5,
602: 'Jan 14 1991 12:00:00:000AM', 103, 4900.00, null )
603:
604: insert into EMPLOYEE values ( 179, 203, 'Lappin', 'Denise', '415-320-2072',
605: '6441 Spruce St.', 'Palo Alto', 'CA', '94198', 5,
606: 'May 20 1992 12:00:00:000AM', 102, 5200.00, null )
607:
608: insert into EMPLOYEE values ( 180, 100,'Magennis', 'Jerry', '415-320-3085',
609: '2457 Chowen St.', 'Redwood City', 'CA', '94224', 8,
610: 'Dec 28 1989 12:00:00:000AM', 101, 4300.00, null )
611: go
612:
613: insert into EMPLOYEE values ( 181, 202, 'Law', 'Mike', '415-320-4077',
614: '1683 Roberts Blvd.', 'Oakland', 'CA', '94174', 5,
615: 'Jul 13 1990 12:00:00:000AM', 102, 4700.00, null )
616:
617: insert into EMPLOYEE values ( 182, 350, 'Jackson', 'Thomas', '415-320-5390',
618: '3279 Hanson St.', 'Belmont', 'CA', '94177', 7,
619: 'Jun 8 1991 12:00:00:000AM', 107, 5300.00, null )
620:
621: insert into EMPLOYEE values ( 183, 320, 'Rokovich', 'Dung', '415-320-7176',
622: '4656 Anderson St.', 'Palo Alto', 'CA', '94210', 10,
623: 'Jun 26 1991 12:00:00:000AM', 107, 5300.00, null )
624:
625: insert into EMPLOYEE values ( 184, 105, 'White', 'Curits', '415-320-6492',
626: '175 Kristen St.', 'Belmont', 'CA', '94180', 9,
627: 'Jan 25 1989 12:00:00:000AM', 101, 5000.00, null )
628:
629: insert into EMPLOYEE values ( 185, 420,'Yee', 'Peggy', '415-328-1314',
630: '4885 France Ave.', 'Half Moon Bay', 'CA', '94239', 4,
631: 'Aug 16 1990 12:00:00:000AM', 103, 4600.00, null )
632:
633: insert into EMPLOYEE values ( 186, 900, 'Derrickson', 'Joy', '415-327-5048',
634: '5708 Elm Ave.', 'Redwood City', 'CA', '94231', 12,
635: 'Aug 15 1988 12:00:00:000AM', 109, 4700.00, null )
636:
637: insert into EMPLOYEE values ( 187, 330, 'Steenkamer', 'Jerry', '415-324-4072',
638: '3861 Washington St.', 'San Jose', 'CA', '94238', 4,
639: 'Oct 6 1991 12:00:00:000AM', 107, 5200.00, null )
640:
641: insert into EMPLOYEE values ( 188, 252, 'Sridhara', 'Dieter', '415-321-5690',
642: '3025 Lancaster Blvd.', 'Atherton', 'CA', '94233', 5,
643: 'Jun 7 1988 12:00:00:000AM', 102, 4900.00, null )
644:
645: insert into EMPLOYEE values ( 189, 100, 'Mikkelsen', 'Rob', '415-321-6689',
646: '4027 Shorebird Ave.', 'Woodside', 'CA', '94188', 9,
647: 'May 12 1991 12:00:00:000AM', 101, 4400.00, null )
648:
649: insert into EMPLOYEE values ( 190, 500,'Yee', 'Kollivakkam', '415-324-1358',
650: '3271 Knuth St.', 'Palo Alto', 'CA', '94217', 4,
651: 'Jan 10 1988 12:00:00:000AM', 106, 4800.00, null )
652:
653: insert into EMPLOYEE values ( 191, 204, 'Guerrero', 'Stephen', '415-321-6736',
654: '6368 Anderson St.', 'Palo Alto', 'CA', '94173', 5,
655: 'Jun 3 1992 12:00:00:000AM', 102, 4600.00, null )
656:
657: insert into EMPLOYEE values ( 192, 420, 'Page', 'Michael', '415-321-1199',
658: '7713 Middlefield Ave.', 'Atherton', 'CA', '94194', 5,
659: 'Nov 23 1988 12:00:00:000AM', 103, 4500.00, null )
660:
661: insert into EMPLOYEE values ( 193, 350, 'McClung', 'Chad', '415-327-1329',
662: '2902 Connell Ave.', 'Sunnyvale', 'CA', '94181', 7,
663: 'Aug 25 1988 12:00:00:000AM', 107, 4200.00, null )
664:
665: insert into EMPLOYEE values ( 194, 104, 'Perka', 'Sam', '415-326-1256',
666: '61 Knox St.', 'Santa Clara', 'CA', '94191', 9,
667: 'Nov 23 1988 12:00:00:000AM', 101, 4900.00, null )
668:
669: insert into EMPLOYEE values ( 195, 420, 'Sickinghe', 'Sherman', '415-325-2233',
670: '4865 France St.', 'Atherton', 'CA', '94207', 5,
671: 'Jul 19 1989 12:00:00:000AM', 103, 4500.00, null )
672:
673: insert into EMPLOYEE values ( 196, 250, 'Welch', 'Robin', '415-328-1833',
674: '7631 Knox Road', 'Mountain View', 'CA', '94153', 5,
675: 'Oct 21 1991 12:00:00:000AM', 102, 4100.00, null )
676:
677: insert into EMPLOYEE values ( 197, 105, 'Nardin', 'Larry', '415-321-2064',
678: '6179 Main St.', 'Tiberon', 'CA', '94157', 8,
679: 'Dec 13 1992 12:00:00:000AM', 101, 4600.00, null )
680:
681: insert into EMPLOYEE values ( 198, 100, 'Zamarripa', 'Drew', '415-320-2956',
682: '6542 State St.', 'Pacific Heights', 'CA', '94163', 10,
683: 'Jul 18 1991 12:00:00:000AM', 101, 5400.00, null )
684:
685: insert into EMPLOYEE values ( 199, 500, 'Edwards', 'John', '415-328-186 ',
686: '1318 Chowen St.', 'Mountain View', 'CA', '94198', 4,
687: 'Jun 12 1989 12:00:00:000AM', 106, 5100.00, null )
688:
689: insert into EMPLOYEE values ( 200, 202,'Schrey', 'Scott', '415-323-3258',
690: '4033 Knox Road', 'Woodside', 'CA', '94206', 5,
691: 'Nov 2 1989 12:00:00:000AM', 102, 4000.00, null )
692: go
693:
694: insert into EMPLOYEE values ( 201, 320, 'Jackson', 'Mike', '415-323-8048',
695: '6956 Spruce St.', 'Mountain View', 'CA', '94187', 10,
696: 'Apr 14 1992 12:00:00:000AM', 107, 4700.00, null )
697:
698: insert into EMPLOYEE values ( 202, 252, 'Mostofi', 'Richard', '415-324-3019',
699: '1704 Lancaster Road', 'Palo Alto', 'CA', '94206', 5,
700: 'Aug 12 1989 12:00:00:000AM', 102, 4500.00, null )
701:
702: insert into EMPLOYEE values ( 203, 410, 'Bonidy', 'Salvatore', '415-322-582 ',
703: '3116 Knuth Ave.', 'Half Moon Bay', 'CA', '94245', 5,
704: 'Apr 14 1992 12:00:00:000AM', 103, 5200.00, null )
705:
706: insert into EMPLOYEE values ( 204, 101, 'Janssen', 'Gene', '415-327-7614',
707: '648 Washington Way', 'San Jose', 'CA', '94175', 8,
708: 'Apr 17 1988 12:00:00:000AM', 1, 4300.00, null )
709:
710: insert into EMPLOYEE values ( 205, 252,'Scott', 'Ken', '415-325-3118',
711: '5936 Strand Road', 'Palo Alto', 'CA', '94150', 5,
712: 'Jul 13 1989 12:00:00:000AM', 102, 5700.00, null )
713:
714: insert into EMPLOYEE values ( 206, 101, 'Droulers', 'Matt', '415-322-213 ',
715: '4617 Roberts Blvd.', 'Sunnyvale', 'CA', '94232', 7,
716: 'Nov 23 1990 12:00:00:000AM', 101, 4400.00, null )
717:
718: insert into EMPLOYEE values ( 207, 202, 'Pinkerton', 'Matt', '415-324-6350',
719: '7803 Sparrow Road', 'Woodside', 'CA', '94245', 4,
720: 'Jul 6 1991 12:00:00:000AM', 102, 5600.00, null )
721:
722: insert into EMPLOYEE values ( 208, 202, 'Campetelli', 'Margaret', '415-321-2664',
723: '7435 Strand Blvd.', 'Redwood City', 'CA', '94200', 5,
724: 'Sep 19 1992 12:00:00:000AM', 102, 5200.00, null )
725:
726: insert into EMPLOYEE values ( 209, 410, 'Lee', 'Jerry', '415-325-9499',
727: '1484 Adams St.', 'Tiberon', 'CA', '94191', 5,
728: 'Jan 11 1991 12:00:00:000AM', 103, 5000.00, null )
729:
730: insert into EMPLOYEE values ( 210, 250,'Bucher', 'Fred', '415-323-8440',
731: '7048 Knox Road', 'Palo Alto', 'CA', '94243', 3,
732: 'May 18 1988 12:00:00:000AM', 102, 4000.00, null )
733:
734: insert into EMPLOYEE values ( 211, 400, 'Farah', 'David', '415-322-2744',
735: '1691 Pelican St.', 'San Francisco', 'CA', '94242', 5,
736: 'Mar 17 1988 12:00:00:000AM', 103, 4600.00, null )
737:
738: insert into EMPLOYEE values ( 212, 350, 'Avenell', 'Perry', '415-328-1319',
739: '5910 Lutece Road', 'Palo Alto', 'CA', '94172', 7,
740: 'May 9 1992 12:00:00:000AM', 107, 5500.00, null )
741:
742: insert into EMPLOYEE values ( 213, 200, 'Butler', 'Mike', '415-327-8235',
743: '5872 Regent Ave.', 'Palo Alto', 'CA', '94226', 11,
744: 'May 5 1990 12:00:00:000AM', 102, 5400.00, null )
745:
746: insert into EMPLOYEE values ( 214, 405, 'Graves', 'David', '415-323-6928',
747: '5706 Shorebird Road', 'Sunnyvale', 'CA', '94173', 5,
748: 'Nov 14 1992 12:00:00:000AM', 103, 4100.00, null )
749:
750: insert into EMPLOYEE values ( 215, 350,'Hourvitz', 'Keith', '415-326-7210',
751: '1092 Pelican St.', 'Sunnyvale', 'CA', '94185', 7,
752: 'Mar 6 1989 12:00:00:000AM', 107, 5400.00, null )
753:
754: insert into EMPLOYEE values ( 216, 105, 'Messer', 'Tushar', '415-322-2698',
755: '7117 Drew Road', 'Tiberon', 'CA', '94201', 3,
756: 'Feb 21 1990 12:00:00:000AM', 101, 4800.00, null )
757:
758: insert into EMPLOYEE values ( 217, 101, 'Bumgarner', 'Kristen', '415-321-2840',
759: '2039 Adams St.', 'Belmont', 'CA', '94174', 9,
760: 'Apr 17 1988 12:00:00:000AM', 101, 5600.00, null )
761:
762: insert into EMPLOYEE values ( 218, 201, 'Derrickson', 'Ben', '415-322-5122',
763: '513 Connell St.', 'Tiberon', 'CA', '94176', 6,
764: 'Aug 15 1988 12:00:00:000AM', 102, 4900.00, null )
765:
766: insert into EMPLOYEE values ( 219, 101, 'Rushin', 'Mark', '415-323-5883',
767: '5391 Addams St.', 'Redwood City', 'CA', '94221', 6,
768: 'Oct 14 1989 12:00:00:000AM', 101, 4900.00, null )
769: go
770:
771: insert into EMPLOYEE values ( 220, 100,'Graffagnino', 'Susan', '415-323-3617',
772: '5999 Walnut Circle', 'Tiberon', 'CA', '94239', 7,
773: 'Jan 6 1992 12:00:00:000AM', 101, 4400.00, null )
774:
775: insert into EMPLOYEE values ( 221, 202, 'Gibbons', 'Jim', '415-326-9370',
776: '2305 Emerson St.', 'Millbrae', 'CA', '94188', 4,
777: 'Nov 13 1988 12:00:00:000AM', 102, 4700.00, null )
778:
779: insert into EMPLOYEE values ( 222, 101, 'Wasmeier', 'Ken', '415-326-6257',
780: '7802 Schoman St.', 'Atherton', 'CA', '94159', 8,
781: 'Nov 5 1990 12:00:00:000AM', 101, 5300.00, null )
782:
783: insert into EMPLOYEE values ( 223, 405, 'Joseph', 'Ralph', '415-325-6536',
784: '3635 France St.', 'San Jose', 'CA', '94199', 5,
785: 'May 15 1989 12:00:00:000AM', 103, 4100.00, null )
786:
787: insert into EMPLOYEE values ( 224, 201, 'Fried', 'Joel', '415-320-9111',
788: '1493 Roberts St.', 'Palo Alto', 'CA', '94196', 6,
789: 'Apr 2 1989 12:00:00:000AM', 102, 5200.00, null )
790:
791: insert into EMPLOYEE values ( 225, 410,'Blumenfeld', 'Linda', '415-321-2818',
792: '4373 Roberts St.', 'Mountain View', 'CA', '94195', 5,
793: 'Jun 11 1991 12:00:00:000AM', 103, 5700.00, null )
794: go
795:
796: insert into EMP_PHOTO(EMP_ID) values (101)
797: insert into EMP_PHOTO(EMP_ID) values (102)
798: insert into EMP_PHOTO(EMP_ID) values (103)
799: insert into EMP_PHOTO(EMP_ID) values (104)
800: insert into EMP_PHOTO(EMP_ID) values (105)
801: insert into EMP_PHOTO(EMP_ID) values (106)
802: insert into EMP_PHOTO(EMP_ID) values (107)
803: insert into EMP_PHOTO(EMP_ID) values (108)
804: insert into EMP_PHOTO(EMP_ID) values (109)
805: insert into EMP_PHOTO(EMP_ID) values (110)
806: insert into EMP_PHOTO(EMP_ID) values (111)
807: insert into EMP_PHOTO(EMP_ID) values (112)
808: insert into EMP_PHOTO(EMP_ID) values (113)
809: insert into EMP_PHOTO(EMP_ID) values (114)
810: insert into EMP_PHOTO(EMP_ID) values (115)
811: insert into EMP_PHOTO(EMP_ID) values (116)
812: insert into EMP_PHOTO(EMP_ID) values (117)
813: insert into EMP_PHOTO(EMP_ID) values (118)
814: insert into EMP_PHOTO(EMP_ID) values (119)
815: insert into EMP_PHOTO(EMP_ID) values (120)
816: go
817: insert into EMP_PHOTO(EMP_ID) values (121)
818: insert into EMP_PHOTO(EMP_ID) values (122)
819: insert into EMP_PHOTO(EMP_ID) values (123)
820: insert into EMP_PHOTO(EMP_ID) values (124)
821: insert into EMP_PHOTO(EMP_ID) values (125)
822: insert into EMP_PHOTO(EMP_ID) values (126)
823: insert into EMP_PHOTO(EMP_ID) values (127)
824: insert into EMP_PHOTO(EMP_ID) values (128)
825: insert into EMP_PHOTO(EMP_ID) values (129)
826: insert into EMP_PHOTO(EMP_ID) values (130)
827: insert into EMP_PHOTO(EMP_ID) values (131)
828: insert into EMP_PHOTO(EMP_ID) values (132)
829: insert into EMP_PHOTO(EMP_ID) values (133)
830: insert into EMP_PHOTO(EMP_ID) values (134)
831: insert into EMP_PHOTO(EMP_ID) values (135)
832: insert into EMP_PHOTO(EMP_ID) values (136)
833: insert into EMP_PHOTO(EMP_ID) values (137)
834: insert into EMP_PHOTO(EMP_ID) values (138)
835: insert into EMP_PHOTO(EMP_ID) values (139)
836: insert into EMP_PHOTO(EMP_ID) values (140)
837: go
838: insert into EMP_PHOTO(EMP_ID) values (141)
839: insert into EMP_PHOTO(EMP_ID) values (142)
840: insert into EMP_PHOTO(EMP_ID) values (143)
841: insert into EMP_PHOTO(EMP_ID) values (144)
842: insert into EMP_PHOTO(EMP_ID) values (145)
843: insert into EMP_PHOTO(EMP_ID) values (146)
844: insert into EMP_PHOTO(EMP_ID) values (147)
845: insert into EMP_PHOTO(EMP_ID) values (148)
846: insert into EMP_PHOTO(EMP_ID) values (149)
847: insert into EMP_PHOTO(EMP_ID) values (150)
848: insert into EMP_PHOTO(EMP_ID) values (151)
849: insert into EMP_PHOTO(EMP_ID) values (152)
850: insert into EMP_PHOTO(EMP_ID) values (153)
851: insert into EMP_PHOTO(EMP_ID) values (154)
852: insert into EMP_PHOTO(EMP_ID) values (155)
853: insert into EMP_PHOTO(EMP_ID) values (156)
854: insert into EMP_PHOTO(EMP_ID) values (157)
855: insert into EMP_PHOTO(EMP_ID) values (158)
856: insert into EMP_PHOTO(EMP_ID) values (159)
857: insert into EMP_PHOTO(EMP_ID) values (160)
858: go
859: insert into EMP_PHOTO(EMP_ID) values (161)
860: insert into EMP_PHOTO(EMP_ID) values (162)
861: insert into EMP_PHOTO(EMP_ID) values (163)
862: insert into EMP_PHOTO(EMP_ID) values (164)
863: insert into EMP_PHOTO(EMP_ID) values (165)
864: insert into EMP_PHOTO(EMP_ID) values (166)
865: insert into EMP_PHOTO(EMP_ID) values (167)
866: insert into EMP_PHOTO(EMP_ID) values (168)
867: insert into EMP_PHOTO(EMP_ID) values (169)
868: insert into EMP_PHOTO(EMP_ID) values (170)
869: insert into EMP_PHOTO(EMP_ID) values (171)
870: insert into EMP_PHOTO(EMP_ID) values (172)
871: insert into EMP_PHOTO(EMP_ID) values (173)
872: insert into EMP_PHOTO(EMP_ID) values (174)
873: insert into EMP_PHOTO(EMP_ID) values (175)
874: insert into EMP_PHOTO(EMP_ID) values (176)
875: insert into EMP_PHOTO(EMP_ID) values (177)
876: insert into EMP_PHOTO(EMP_ID) values (178)
877: insert into EMP_PHOTO(EMP_ID) values (179)
878: insert into EMP_PHOTO(EMP_ID) values (180)
879: go
880: insert into EMP_PHOTO(EMP_ID) values (181)
881: insert into EMP_PHOTO(EMP_ID) values (182)
882: insert into EMP_PHOTO(EMP_ID) values (183)
883: insert into EMP_PHOTO(EMP_ID) values (184)
884: insert into EMP_PHOTO(EMP_ID) values (185)
885: insert into EMP_PHOTO(EMP_ID) values (186)
886: insert into EMP_PHOTO(EMP_ID) values (187)
887: insert into EMP_PHOTO(EMP_ID) values (188)
888: insert into EMP_PHOTO(EMP_ID) values (189)
889: insert into EMP_PHOTO(EMP_ID) values (190)
890: insert into EMP_PHOTO(EMP_ID) values (191)
891: insert into EMP_PHOTO(EMP_ID) values (192)
892: insert into EMP_PHOTO(EMP_ID) values (193)
893: insert into EMP_PHOTO(EMP_ID) values (194)
894: insert into EMP_PHOTO(EMP_ID) values (195)
895: insert into EMP_PHOTO(EMP_ID) values (196)
896: insert into EMP_PHOTO(EMP_ID) values (197)
897: insert into EMP_PHOTO(EMP_ID) values (198)
898: insert into EMP_PHOTO(EMP_ID) values (199)
899: insert into EMP_PHOTO(EMP_ID) values (200)
900: go
901: insert into EMP_PHOTO(EMP_ID) values (201)
902: insert into EMP_PHOTO(EMP_ID) values (202)
903: insert into EMP_PHOTO(EMP_ID) values (203)
904: insert into EMP_PHOTO(EMP_ID) values (204)
905: insert into EMP_PHOTO(EMP_ID) values (205)
906: insert into EMP_PHOTO(EMP_ID) values (206)
907: insert into EMP_PHOTO(EMP_ID) values (207)
908: insert into EMP_PHOTO(EMP_ID) values (208)
909: insert into EMP_PHOTO(EMP_ID) values (209)
910: insert into EMP_PHOTO(EMP_ID) values (210)
911: insert into EMP_PHOTO(EMP_ID) values (211)
912: insert into EMP_PHOTO(EMP_ID) values (212)
913: insert into EMP_PHOTO(EMP_ID) values (213)
914: insert into EMP_PHOTO(EMP_ID) values (214)
915: insert into EMP_PHOTO(EMP_ID) values (215)
916: insert into EMP_PHOTO(EMP_ID) values (216)
917: insert into EMP_PHOTO(EMP_ID) values (217)
918: insert into EMP_PHOTO(EMP_ID) values (218)
919: insert into EMP_PHOTO(EMP_ID) values (219)
920: insert into EMP_PHOTO(EMP_ID) values (220)
921: insert into EMP_PHOTO(EMP_ID) values (221)
922: insert into EMP_PHOTO(EMP_ID) values (222)
923: insert into EMP_PHOTO(EMP_ID) values (223)
924: insert into EMP_PHOTO(EMP_ID) values (224)
925: insert into EMP_PHOTO(EMP_ID) values (225)
926: go
927:
928:
929:
930:
931: insert into EMP_EQUIPMENT values (1100, 'NeXTstation 8/105', '984-9749', 119)
932: insert into EMP_EQUIPMENT values (1101, 'NeXTstation 8/105', '929-22249', 149)
933: insert into EMP_EQUIPMENT values (1102, 'NeXTstation Color 8/105', '397-40272', 166)
934: insert into EMP_EQUIPMENT values (1103, 'NeXTstation Color 16/200', '233-86445', 127)
935: insert into EMP_EQUIPMENT values (1104, 'NeXTstation 16/400', '207-53910', 131)
936: insert into EMP_EQUIPMENT values (1105, 'NeXTstation Color Turbo 16/200', '508-67548', 147)
937: insert into EMP_EQUIPMENT values (1106, 'NeXTstation 16/200', '436-80755', 161)
938: insert into EMP_EQUIPMENT values (1107, 'NeXTstation Color Turbo 16/200', '543-37393', 156)
939: insert into EMP_EQUIPMENT values (1108, 'NeXTstation 16/200', '547-30645', 218)
940: insert into EMP_EQUIPMENT values (1109, 'NeXTstation 8/105', '476-93085', 178)
941: insert into EMP_EQUIPMENT values (1110, 'NeXTDimension', '336-24689', 137)
942: insert into EMP_EQUIPMENT values (1111, 'NeXTstation Turbo 16/400', '549-35596', 193)
943: insert into EMP_EQUIPMENT values (1112, 'NeXTstation Color 8/105', '26-33143', 144)
944: insert into EMP_EQUIPMENT values (1113, 'NeXTstation Color Turbo 8/105', '393-60933', 164)
945: insert into EMP_EQUIPMENT values (1114, 'NeXTstation Color 8/105', '748-91478', 184)
946: insert into EMP_EQUIPMENT values (1115, 'NeXTDimension', '754-23106', 140)
947: insert into EMP_EQUIPMENT values (1116, 'NeXTstation Color Turbo 16/400', '372-28680', 152)
948: insert into EMP_EQUIPMENT values (1117, 'NeXTstation Color 16/400', '13-44241', 211)
949: insert into EMP_EQUIPMENT values (1118, 'NeXTstation Color Turbo 16/200', '539-51330', 214)
950: insert into EMP_EQUIPMENT values (1119, 'NeXTstation Color 16/200', '418-68918', 103)
951: insert into EMP_EQUIPMENT values (1120, 'NeXTstation 16/200', '809-46727', 143)
952: go
953: insert into EMP_EQUIPMENT values (1121, 'NeXTstation 8/105', '279-2385', 118)
954: insert into EMP_EQUIPMENT values (1122, 'NeXTstation Color Turbo 16/200', '414-69939', 179)
955: insert into EMP_EQUIPMENT values (1123, 'NeXTstation Color Turbo 16/200', '796-69543', 188)
956: insert into EMP_EQUIPMENT values (1124, 'NeXTstation Color Turbo 16/200', '537-89239', 154)
957: insert into EMP_EQUIPMENT values (1125, 'NeXTstation 16/400', '541-23964', 198)
958: insert into EMP_EQUIPMENT values (1126, 'NeXTstation Turbo 16/400', '178-21075', 113)
959: insert into EMP_EQUIPMENT values (1127, 'NeXTstation 16/200', '243-74685', 183)
960: insert into EMP_EQUIPMENT values (1128, 'NeXTstation 16/400', '702-51108', 138)
961: insert into EMP_EQUIPMENT values (1129, 'NeXTstation 16/200', '193-79563', 171)
962: insert into EMP_EQUIPMENT values (1130, 'NeXTstation Color 16/200', '595-86545', 160)
963: insert into EMP_EQUIPMENT values (1131, 'NeXTstation Color 16/200', '226-22739', 210)
964: insert into EMP_EQUIPMENT values (1132, 'NeXTstation Turbo 16/400', '98-6934', 204)
965: insert into EMP_EQUIPMENT values (1133, 'NeXTstation 16/400', '513-28929', 134)
966: insert into EMP_EQUIPMENT values (1134, 'NeXTstation 8/105', '349-4738', 163)
967: insert into EMP_EQUIPMENT values (1135, 'NeXTstation Color Turbo 16/200', '941-66087', 132)
968: insert into EMP_EQUIPMENT values (1136, 'NeXTstation Color 16/400', '382-65389', 114)
969: insert into EMP_EQUIPMENT values (1137, 'NeXTstation 16/400', '664-62232', 117)
970: insert into EMP_EQUIPMENT values (1138, 'NeXTstation Color 8/105', '5-36913', 136)
971: insert into EMP_EQUIPMENT values (1139, 'NeXTstation Color 16/400', '370-90496', 153)
972: insert into EMP_EQUIPMENT values (1140, 'NeXTDimension', '984-7872', 169)
973: go
974: insert into EMP_EQUIPMENT values (1141, 'NeXTstation Color 16/400', '277-34231', 145)
975: insert into EMP_EQUIPMENT values (1142, 'NeXTstation 16/400', '753-51711', 150)
976: insert into EMP_EQUIPMENT values (1143, 'NeXTstation Color Turbo 8/105', '123-7629', 155)
977: insert into EMP_EQUIPMENT values (1144, 'NeXTstation 16/400', '800-3038', 124)
978: insert into EMP_EQUIPMENT values (1145, 'NeXTstation Color 8/105', '486-77628', 180)
979: insert into EMP_EQUIPMENT values (1146, 'NeXTstation 8/105', '824-13576', 187)
980: insert into EMP_EQUIPMENT values (1147, 'NeXTstation Color 8/105', '626-42240', 209)
981: insert into EMP_EQUIPMENT values (1148, 'NeXTstation Color Turbo 8/105', '781-27064', 129)
982: insert into EMP_EQUIPMENT values (1149, 'NeXTstation Color Turbo 16/200', '914-13130', 162)
983: insert into EMP_EQUIPMENT values (1150, 'NeXTstation Turbo 16/400', '95-49295', 174)
984: insert into EMP_EQUIPMENT values (1151, 'NeXTstation Color 8/105', '647-96907', 221)
985: insert into EMP_EQUIPMENT values (1152, 'NeXTDimension', '117-87463', 224)
986: insert into EMP_EQUIPMENT values (1153, 'NeXTstation Color Turbo 16/200', '670-29606', 106)
987: insert into EMP_EQUIPMENT values (1154, 'NeXTstation 16/400', '332-52077', 148)
988: insert into EMP_EQUIPMENT values (1155, 'NeXTstation Color 16/200', '852-63799', 199)
989: insert into EMP_EQUIPMENT values (1156, 'NeXTstation Color 8/105', '440-37613', 115)
990: insert into EMP_EQUIPMENT values (1157, 'NeXTstation Color Turbo 16/400', '298-58959', 122)
991: insert into EMP_EQUIPMENT values (1158, 'NeXTstation Color Turbo 8/105', '164-40348', 165)
992: insert into EMP_EQUIPMENT values (1159, 'NeXTstation Color Turbo 8/105', '975-497', 151)
993: insert into EMP_EQUIPMENT values (1160, 'NeXTstation Color 16/200', '741-12300', 186)
994: go
995: insert into EMP_EQUIPMENT values (1161, 'NeXTstation 8/105', '126-40700', 135)
996: insert into EMP_EQUIPMENT values (1162, 'NeXTstation 16/200', '923-50658', 102)
997: insert into EMP_EQUIPMENT values (1163, 'NeXTstation Color Turbo 16/200', '705-40124', 105)
998: insert into EMP_EQUIPMENT values (1164, 'NeXTstation Color 16/400', '985-27011', 128)
999: insert into EMP_EQUIPMENT values (1165, 'NeXTstation 16/400', '83-84294', 142)
1000: insert into EMP_EQUIPMENT values (1166, 'NeXTstation 16/400', '233-32050', 215)
1001: insert into EMP_EQUIPMENT values (1167, 'NeXTstation 16/400', '226-34036', 107)
1002: insert into EMP_EQUIPMENT values (1168, 'NeXTDimension', '524-60536', 176)
1003: insert into EMP_EQUIPMENT values (1169, 'NeXTstation 8/105', '104-65265', 205)
1004: insert into EMP_EQUIPMENT values (1170, 'NeXTstation Color Turbo 16/400', '794-54450', 222)
1005: insert into EMP_EQUIPMENT values (1171, 'NeXTstation Color 16/200', '550-87024', 190)
1006: insert into EMP_EQUIPMENT values (1172, 'NeXTstation 16/200', '75-57330', 175)
1007: insert into EMP_EQUIPMENT values (1173, 'NeXTstation 16/200', '709-24372', 217)
1008: insert into EMP_EQUIPMENT values (1174, 'NeXTstation Color Turbo 16/200', '388-38271', 173)
1009: insert into EMP_EQUIPMENT values (1175, 'NeXTstation 8/105', '98-76041', 197)
1010: insert into EMP_EQUIPMENT values (1176, 'NeXTstation Color Turbo 8/105', '767-36932', 158)
1011: insert into EMP_EQUIPMENT values (1177, 'NeXTstation 8/105', '595-13623', 139)
1012: insert into EMP_EQUIPMENT values (1178, 'NeXTstation 8/105', '664-82207', 104)
1013: insert into EMP_EQUIPMENT values (1179, 'NeXTDimension', '830-38108', 225)
1014: insert into EMP_EQUIPMENT values (1180, 'NeXTstation Color 16/200', '281-5023', 141)
1015: go
1016: insert into EMP_EQUIPMENT values (1181, 'NeXTstation Color Turbo 16/200', '388-51896', 208)
1017: insert into EMP_EQUIPMENT values (1182, 'NeXTDimension', '813-75150', 109)
1018: insert into EMP_EQUIPMENT values (1183, 'NeXTstation Color 8/105', '576-43283', 112)
1019: insert into EMP_EQUIPMENT values (1184, 'NeXTstation 16/200', '563-21410', 146)
1020: insert into EMP_EQUIPMENT values (1185, 'NeXTstation Color 8/105', '384-26683', 219)
1021: insert into EMP_EQUIPMENT values (1186, 'NeXTDimension', '449-97816', 157)
1022: insert into EMP_EQUIPMENT values (1187, 'NeXTstation 8/105', '853-64862', 206)
1023: insert into EMP_EQUIPMENT values (1188, 'NeXTstation 8/105', '621-8809', 207)
1024: insert into EMP_EQUIPMENT values (1189, 'NeXTstation 16/200', '162-25658', 111)
1025: insert into EMP_EQUIPMENT values (1190, 'NeXTstation Color 8/105', '621-29151', 120)
1026: insert into EMP_EQUIPMENT values (1191, 'NeXTstation Color Turbo 16/400', '63-38117', 192)
1027: insert into EMP_EQUIPMENT values (1192, 'NeXTstation Color Turbo 16/200', '704-39748', 181)
1028: insert into EMP_EQUIPMENT values (1193, 'NeXTstation 8/105', '785-84375', 201)
1029: insert into EMP_EQUIPMENT values (1194, 'NeXTstation Color 16/400', '652-37816', 213)
1030: insert into EMP_EQUIPMENT values (1195, 'NeXTstation Color 16/200', '886-84102', 172)
1031: insert into EMP_EQUIPMENT values (1196, 'NeXTstation Color Turbo 16/200', '831-87177', 108)
1032: insert into EMP_EQUIPMENT values (1197, 'NeXTstation Color Turbo 16/200', '739-26210', 177)
1033: insert into EMP_EQUIPMENT values (1198, 'NeXTstation 16/200', '396-71735', 125)
1034: insert into EMP_EQUIPMENT values (1199, 'NeXTstation 16/400', '34-79809', 126)
1035: insert into EMP_EQUIPMENT values (1200, 'NeXTstation Color 8/105', '334-59161', 185)
1036: go
1037: insert into EMP_EQUIPMENT values (1201, 'NeXTDimension', '524-41124', 212)
1038: insert into EMP_EQUIPMENT values (1202, 'NeXTstation Color 8/105', '836-89146', 110)
1039: insert into EMP_EQUIPMENT values (1203, 'NeXTstation Color 16/400', '608-57474', 223)
1040: insert into EMP_EQUIPMENT values (1204, 'NeXTstation Color Turbo 16/200', '722-85049', 202)
1041: insert into EMP_EQUIPMENT values (1205, 'NeXTstation Color Turbo 16/400', '532-78167', 189)
1042: insert into EMP_EQUIPMENT values (1206, 'NeXTstation Turbo 16/400', '16-926', 196)
1043: insert into EMP_EQUIPMENT values (1207, 'NeXTstation Turbo 16/400', '518-18514', 133)
1044: insert into EMP_EQUIPMENT values (1208, 'NeXTDimension', '384-72591', 167)
1045: insert into EMP_EQUIPMENT values (1209, 'NeXTDimension', '334-21983', 203)
1046: insert into EMP_EQUIPMENT values (1210, 'NeXTstation Color Turbo 16/200', '391-49812', 194)
1047: insert into EMP_EQUIPMENT values (1211, 'NeXTstation Turbo 16/400', '6-87480', 121)
1048: insert into EMP_EQUIPMENT values (1212, 'NeXTstation Color Turbo 16/200', '197-13972', 130)
1049: insert into EMP_EQUIPMENT values (1213, 'NeXTstation Color 16/400', '33-39584', 200)
1050: insert into EMP_EQUIPMENT values (1214, 'NeXTstation Color 16/200', '992-3848', 195)
1051: insert into EMP_EQUIPMENT values (1215, 'NeXTstation Color Turbo 8/105', '277-10448', 101)
1052: insert into EMP_EQUIPMENT values (1216, 'NeXTstation Color Turbo 16/400', '975-77088', 191)
1053: insert into EMP_EQUIPMENT values (1217, 'NeXTstation Turbo 16/400', '294-32339', 220)
1054: insert into EMP_EQUIPMENT values (1218, 'NeXTDimension', '618-27833', 182)
1055: insert into EMP_EQUIPMENT values (1219, 'NeXTstation 16/400', '103-83650', 123)
1056: insert into EMP_EQUIPMENT values (1220, 'NeXTstation Color Turbo 16/200', '756-14950', 170)
1057: insert into EMP_EQUIPMENT values (1221, 'NeXTstation 16/400', '436-91312', 216)
1058: insert into EMP_EQUIPMENT values (1222, 'NeXTstation Color Turbo 16/200', '489-13117', 159)
1059: insert into EMP_EQUIPMENT values (1223, 'NeXTstation Color Turbo 8/105', '579-12221', 168)
1060: insert into EMP_EQUIPMENT values (1224, 'NeXTstation 16/400', '551-13204', 116)
1061: go
1062:
1063: insert into EMP_QUOTE(EMP_ID) select EMP_ID from EMPLOYEE
1064: go
1065:
1066: commit transaction
1067: go
1068:
1069:
1070: /******************************************************************************
1071: * Create table indexes.
1072: ******************************************************************************/
1073: create unique INDEX EMP_INDEX1 on EMPLOYEE(EMP_ID)
1074: go
1075:
1076: create unique INDEX DEPT_INDEX1 on DEPARTMENT(DEPT_ID)
1077: go
1078:
1079: create unique INDEX FACILITY_INDEX1 on FACILITY(LOCATION_ID)
1080: go
1081:
1082: create unique INDEX EMPPROJ_INDEX1 on EMP_PROJECT(EMP_ID,PROJECT_ID)
1083: go
1084:
1085: create unique INDEX PROJ_INDEX1 on PROJECT(PROJECT_ID)
1086: go
1087:
1088: create unique INDEX EMP_PHOTO_INDEX1 on EMP_PHOTO(EMP_ID)
1089: go
1090:
1091: create unique INDEX EMP_QUOTE_INDEX1 on EMP_QUOTE(EMP_ID)
1092: go
1093:
1094: create unique INDEX JOB_TITLE_INDEX1 on JOB_TITLE(TITLE_ID)
1095: go
1096:
1097: create unique INDEX ASSET_INDEX1 on EMP_EQUIPMENT(ASSET_TAG)
1098: go
1099:
1100:
1101: /******************************************************************************
1102: * Create the UNIQUE_KEY table, which stores the MAX_KEY for each ENTITY_NAME.
1103: ******************************************************************************/
1104: create table UNIQUE_KEY (
1105: ENTITY_NAME varchar(100),
1106: MAX_KEY int
1107: )
1108: go
1109:
1110: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMPLOYEE',max(EMP_ID) from EMPLOYEE
1111: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'DEPARTMENT',max(DEPT_ID) from DEPARTMENT
1112: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'FACILITY',max(LOCATION_ID) from FACILITY
1113: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'PROJECT',max(PROJECT_ID) from PROJECT
1114: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'JOB_TITLE',max(TITLE_ID) from JOB_TITLE
1115: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMP_EQUIPMENT',max(ASSET_TAG) from EMP_EQUIPMENT
1116: go
1117:
1118: create unique INDEX UNIQUE_KEY_INDEX1 on UNIQUE_KEY(ENTITY_NAME)
1119: go
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.