![[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.