Return to installPEOPLE.sqlsybase CVS log

Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / PeopleDBScripts

Annotation of Examples/EnterpriseObjects/PeopleDBScripts/installPEOPLE.sqlsybase, revision 1.1

1.1     ! root        1: /******************************************************************************
        !             2: * Create the PEOPLE database by pasting this file into an isql terminal window.
        !             3: ******************************************************************************/
        !             4: use master
        !             5: go
        !             6: drop database PEOPLE
        !             7: go
        !             8: 
        !             9: create database PEOPLE
        !            10: go
        !            11: use PEOPLE
        !            12: go
        !            13: 
        !            14: /******************************************************************************
        !            15: * Cut below this banner to just drop the tables.
        !            16: * 
        !            17: ******************************************************************************/
        !            18: drop table EMPLOYEE 
        !            19: go
        !            20: drop table DEPARTMENT 
        !            21: go
        !            22: drop table FACILITY
        !            23: go
        !            24: drop table EMP_PROJECT
        !            25: go
        !            26: drop table PROJECT
        !            27: go
        !            28: drop table EMP_PHOTO 
        !            29: go
        !            30: drop table EMP_QUOTE 
        !            31: go
        !            32: drop table JOB_TITLE 
        !            33: go
        !            34: drop table EMP_EQUIPMENT 
        !            35: go
        !            36: drop table UNIQUE_KEY 
        !            37: go
        !            38: 
        !            39: 
        !            40: /******************************************************************************
        !            41: *  Create the tables.
        !            42: ******************************************************************************/
        !            43: create table EMPLOYEE (
        !            44: EMP_ID int,
        !            45: DEPT_ID int null,
        !            46: LAST_NAME varchar(40),
        !            47: FIRST_NAME varchar(40),
        !            48: PHONE char(12) null,
        !            49: ADDRESS varchar(40) null,
        !            50: CITY varchar(20) null,
        !            51: STATE char(2) null,
        !            52: ZIP char(5) null,
        !            53: TITLE_ID int null,
        !            54: HIRE_DATE datetime null,
        !            55: MANAGER int null,
        !            56: SALARY float null
        !            57: )
        !            58: go
        !            59: 
        !            60: grant all on EMPLOYEE to public
        !            61: go
        !            62: 
        !            63: create table DEPARTMENT (
        !            64: DEPT_ID int,
        !            65: DEPARTMENT_NAME varchar(30),
        !            66: LOCATION_ID int 
        !            67: )
        !            68: go
        !            69: 
        !            70: grant all on DEPARTMENT to public
        !            71: go
        !            72: 
        !            73: create table FACILITY (
        !            74: LOCATION_ID int,
        !            75: LOCATION varchar(30),
        !            76: PHOTO image null
        !            77: )
        !            78: go
        !            79: 
        !            80: grant all on FACILITY to public
        !            81: go
        !            82: 
        !            83: create table EMP_PROJECT (
        !            84: EMP_ID int,
        !            85: PROJECT_ID int,
        !            86: )
        !            87: go
        !            88: 
        !            89: grant all on EMP_PROJECT to public
        !            90: go
        !            91: 
        !            92: create table PROJECT (
        !            93: PROJECT_ID int,
        !            94: PROJECT_NAME varchar(30),
        !            95: SUMMARY_IMAGE image null
        !            96: )
        !            97: go
        !            98: 
        !            99: grant all on PROJECT to public
        !           100: go
        !           101: 
        !           102: create table EMP_PHOTO (
        !           103: EMP_ID int,
        !           104: PHOTO image null
        !           105: )
        !           106: go
        !           107: 
        !           108: grant all on EMP_PHOTO to public
        !           109: go
        !           110: 
        !           111: create table EMP_QUOTE (
        !           112: EMP_ID int,
        !           113: QUOTE image null
        !           114: )
        !           115: go
        !           116: 
        !           117: grant all on EMP_QUOTE to public
        !           118: go
        !           119: 
        !           120: create table JOB_TITLE (
        !           121: TITLE_ID int,
        !           122: TITLE varchar(30),
        !           123: TITLE_TYPE varchar(12)
        !           124: )
        !           125: go
        !           126: 
        !           127: grant all on JOB_TITLE to public
        !           128: go
        !           129: 
        !           130: create table EMP_EQUIPMENT (
        !           131: ASSET_TAG int,
        !           132: DESCRIPTION varchar(100) null,
        !           133: SERIAL_NUMBER varchar(20) null,
        !           134: EMP_ID int null
        !           135: )
        !           136: go
        !           137: 
        !           138: grant all on EMP_EQUIPMENT to public
        !           139: go
        !           140: 
        !           141: 
        !           142: /******************************************************************************
        !           143: *  Insert values.
        !           144: ******************************************************************************/
        !           145: begin transaction
        !           146: go
        !           147: 
        !           148: insert into  FACILITY values(1101, 'Waterfront One', null)
        !           149: go
        !           150: 
        !           151: insert into  FACILITY values(1103, 'Hillside 1', null)
        !           152: go
        !           153: 
        !           154: insert into  FACILITY values(1106, 'Hillside 2', null)
        !           155: go
        !           156: 
        !           157: insert into  FACILITY values(1207, 'Embarcadero', null)
        !           158: go
        !           159: 
        !           160: insert into  FACILITY values(1104, 'Arcada', null)
        !           161: go
        !           162: 
        !           163: insert into EMP_PROJECT values (101, 501) 
        !           164: go
        !           165: 
        !           166: insert into EMP_PROJECT values (102, 503) 
        !           167: go
        !           168: 
        !           169: insert into EMP_PROJECT values (103, 507) 
        !           170: go
        !           171: 
        !           172: insert into EMP_PROJECT values (104, 510) 
        !           173: go
        !           174: 
        !           175: insert into EMP_PROJECT values (105, 512) 
        !           176: go
        !           177: 
        !           178: insert into EMP_PROJECT values (106, 501) 
        !           179: go
        !           180: 
        !           181: insert into EMP_PROJECT values (107, 503) 
        !           182: go
        !           183: 
        !           184: insert into EMP_PROJECT values (108, 507) 
        !           185: go
        !           186: 
        !           187: insert into EMP_PROJECT values (109, 510) 
        !           188: go
        !           189: 
        !           190: insert into EMP_PROJECT values (110, 512) 
        !           191: go
        !           192: 
        !           193: insert into EMP_PROJECT values (111, 501) 
        !           194: go
        !           195: 
        !           196: insert into EMP_PROJECT values (112, 503) 
        !           197: go
        !           198: 
        !           199: insert into EMP_PROJECT values (113, 507) 
        !           200: go
        !           201: 
        !           202: insert into EMP_PROJECT values (114, 510) 
        !           203: go
        !           204: 
        !           205: insert into EMP_PROJECT values (115, 512) 
        !           206: go
        !           207: 
        !           208: insert into EMP_PROJECT values (116, 501) 
        !           209: go
        !           210: 
        !           211: insert into EMP_PROJECT values (117, 503) 
        !           212: go
        !           213: 
        !           214: insert into EMP_PROJECT values (118, 507) 
        !           215: go
        !           216: 
        !           217: insert into EMP_PROJECT values (119, 510) 
        !           218: go
        !           219: 
        !           220: insert into EMP_PROJECT values (120, 512) 
        !           221: go
        !           222: 
        !           223: insert into EMP_PROJECT values (121, 501) 
        !           224: go
        !           225: 
        !           226: insert into EMP_PROJECT values (122, 503) 
        !           227: go
        !           228: 
        !           229: insert into EMP_PROJECT values (123, 507) 
        !           230: go
        !           231: 
        !           232: insert into EMP_PROJECT values (124, 510) 
        !           233: go
        !           234: 
        !           235: insert into EMP_PROJECT values (125, 512) 
        !           236: go
        !           237: 
        !           238: insert into EMP_PROJECT values (126, 501) 
        !           239: go
        !           240: 
        !           241: insert into EMP_PROJECT values (127, 503) 
        !           242: go
        !           243: 
        !           244: insert into EMP_PROJECT values (128, 507) 
        !           245: go
        !           246: 
        !           247: insert into EMP_PROJECT values (129, 510) 
        !           248: go
        !           249: 
        !           250: insert into EMP_PROJECT values (130, 512) 
        !           251: go
        !           252: 
        !           253: insert into EMP_PROJECT values (131, 501) 
        !           254: go
        !           255: 
        !           256: insert into EMP_PROJECT values (132, 503) 
        !           257: go
        !           258: 
        !           259: insert into EMP_PROJECT values (133, 507) 
        !           260: go
        !           261: 
        !           262: insert into EMP_PROJECT values (134, 510) 
        !           263: go
        !           264: 
        !           265: insert into EMP_PROJECT values (135, 512) 
        !           266: go
        !           267: 
        !           268: insert into EMP_PROJECT values (136, 501) 
        !           269: go
        !           270: 
        !           271: insert into EMP_PROJECT values (137, 503) 
        !           272: go
        !           273: 
        !           274: insert into EMP_PROJECT values (138, 507) 
        !           275: go
        !           276: 
        !           277: insert into EMP_PROJECT values (139, 510) 
        !           278: go
        !           279: 
        !           280: insert into EMP_PROJECT values (140, 512) 
        !           281: go
        !           282: 
        !           283: insert into EMP_PROJECT values (141, 501) 
        !           284: go
        !           285: 
        !           286: insert into EMP_PROJECT values (142, 503) 
        !           287: go
        !           288: 
        !           289: insert into EMP_PROJECT values (143, 507) 
        !           290: go
        !           291: 
        !           292: insert into EMP_PROJECT values (144, 510) 
        !           293: go
        !           294: 
        !           295: insert into EMP_PROJECT values (145, 512) 
        !           296: go
        !           297: 
        !           298: insert into EMP_PROJECT values (146, 501) 
        !           299: go
        !           300: 
        !           301: insert into EMP_PROJECT values (147, 503) 
        !           302: go
        !           303: 
        !           304: insert into EMP_PROJECT values (148, 507) 
        !           305: go
        !           306: 
        !           307: insert into EMP_PROJECT values (149, 510) 
        !           308: go
        !           309: 
        !           310: insert into EMP_PROJECT values (150, 512) 
        !           311: go
        !           312: 
        !           313: insert into EMP_PROJECT values (151, 501) 
        !           314: go
        !           315: 
        !           316: insert into EMP_PROJECT values (152, 503) 
        !           317: go
        !           318: 
        !           319: insert into EMP_PROJECT values (153, 507) 
        !           320: go
        !           321: 
        !           322: insert into EMP_PROJECT values (154, 510) 
        !           323: go
        !           324: 
        !           325: insert into EMP_PROJECT values (155, 512) 
        !           326: go
        !           327: 
        !           328: insert into EMP_PROJECT values (156, 501) 
        !           329: go
        !           330: 
        !           331: insert into EMP_PROJECT values (157, 503) 
        !           332: go
        !           333: 
        !           334: insert into EMP_PROJECT values (158, 507) 
        !           335: go
        !           336: 
        !           337: insert into EMP_PROJECT values (159, 510) 
        !           338: go
        !           339: 
        !           340: insert into EMP_PROJECT values (160, 512) 
        !           341: go
        !           342: 
        !           343: insert into EMP_PROJECT values (161, 501) 
        !           344: go
        !           345: 
        !           346: insert into EMP_PROJECT values (162, 503) 
        !           347: go
        !           348: 
        !           349: insert into EMP_PROJECT values (163, 507) 
        !           350: go
        !           351: 
        !           352: insert into EMP_PROJECT values (164, 510) 
        !           353: go
        !           354: 
        !           355: insert into EMP_PROJECT values (165, 512) 
        !           356: go
        !           357: 
        !           358: insert into EMP_PROJECT values (166, 501) 
        !           359: go
        !           360: 
        !           361: insert into EMP_PROJECT values (167, 503) 
        !           362: go
        !           363: 
        !           364: insert into EMP_PROJECT values (168, 507) 
        !           365: go
        !           366: 
        !           367: insert into EMP_PROJECT values (169, 510) 
        !           368: go
        !           369: 
        !           370: insert into EMP_PROJECT values (170, 512) 
        !           371: go
        !           372: 
        !           373: insert into EMP_PROJECT values (171, 501) 
        !           374: go
        !           375: 
        !           376: insert into EMP_PROJECT values (172, 503) 
        !           377: go
        !           378: 
        !           379: insert into EMP_PROJECT values (173, 507) 
        !           380: go
        !           381: 
        !           382: insert into EMP_PROJECT values (174, 510) 
        !           383: go
        !           384: 
        !           385: insert into EMP_PROJECT values (175, 512) 
        !           386: go
        !           387: 
        !           388: insert into EMP_PROJECT values (176, 501) 
        !           389: go
        !           390: 
        !           391: insert into EMP_PROJECT values (177, 503) 
        !           392: go
        !           393: 
        !           394: insert into EMP_PROJECT values (178, 507) 
        !           395: go
        !           396: 
        !           397: insert into EMP_PROJECT values (179, 510) 
        !           398: go
        !           399: 
        !           400: insert into EMP_PROJECT values (180, 512) 
        !           401: go
        !           402: 
        !           403: insert into EMP_PROJECT values (181, 501) 
        !           404: go
        !           405: 
        !           406: insert into EMP_PROJECT values (182, 503) 
        !           407: go
        !           408: 
        !           409: insert into EMP_PROJECT values (183, 507) 
        !           410: go
        !           411: 
        !           412: insert into EMP_PROJECT values (184, 510) 
        !           413: go
        !           414: 
        !           415: insert into EMP_PROJECT values (185, 512) 
        !           416: go
        !           417: 
        !           418: insert into EMP_PROJECT values (186, 501) 
        !           419: go
        !           420: 
        !           421: insert into EMP_PROJECT values (187, 503) 
        !           422: go
        !           423: 
        !           424: insert into EMP_PROJECT values (188, 507) 
        !           425: go
        !           426: 
        !           427: insert into EMP_PROJECT values (189, 510) 
        !           428: go
        !           429: 
        !           430: insert into EMP_PROJECT values (190, 512) 
        !           431: go
        !           432: 
        !           433: insert into EMP_PROJECT values (191, 501) 
        !           434: go
        !           435: 
        !           436: insert into EMP_PROJECT values (192, 503) 
        !           437: go
        !           438: 
        !           439: insert into EMP_PROJECT values (193, 507) 
        !           440: go
        !           441: 
        !           442: insert into EMP_PROJECT values (194, 510) 
        !           443: go
        !           444: 
        !           445: insert into EMP_PROJECT values (195, 512) 
        !           446: go
        !           447: 
        !           448: insert into EMP_PROJECT values (196, 501) 
        !           449: go
        !           450: 
        !           451: insert into EMP_PROJECT values (197, 503) 
        !           452: go
        !           453: 
        !           454: insert into EMP_PROJECT values (198, 507) 
        !           455: go
        !           456: 
        !           457: insert into EMP_PROJECT values (199, 510) 
        !           458: go
        !           459: 
        !           460: insert into EMP_PROJECT values (200, 512) 
        !           461: go
        !           462: 
        !           463: insert into EMP_PROJECT values (201, 501) 
        !           464: go
        !           465: 
        !           466: insert into EMP_PROJECT values (202, 503) 
        !           467: go
        !           468: 
        !           469: insert into EMP_PROJECT values (203, 507) 
        !           470: go
        !           471: 
        !           472: insert into EMP_PROJECT values (204, 510) 
        !           473: go
        !           474: 
        !           475: insert into EMP_PROJECT values (205, 512) 
        !           476: go
        !           477: 
        !           478: insert into EMP_PROJECT values (206, 501) 
        !           479: go
        !           480: 
        !           481: insert into EMP_PROJECT values (207, 503) 
        !           482: go
        !           483: 
        !           484: insert into EMP_PROJECT values (208, 507) 
        !           485: go
        !           486: 
        !           487: insert into EMP_PROJECT values (209, 510) 
        !           488: go
        !           489: 
        !           490: insert into EMP_PROJECT values (210, 512) 
        !           491: go
        !           492: 
        !           493: insert into EMP_PROJECT values (211, 501) 
        !           494: go
        !           495: 
        !           496: insert into EMP_PROJECT values (212, 503) 
        !           497: go
        !           498: 
        !           499: insert into EMP_PROJECT values (213, 507) 
        !           500: go
        !           501: 
        !           502: insert into EMP_PROJECT values (214, 510) 
        !           503: go
        !           504: 
        !           505: insert into EMP_PROJECT values (215, 512) 
        !           506: go
        !           507: 
        !           508: insert into EMP_PROJECT values (216, 501) 
        !           509: go
        !           510: 
        !           511: insert into EMP_PROJECT values (217, 503) 
        !           512: go
        !           513: 
        !           514: insert into EMP_PROJECT values (218, 507) 
        !           515: go
        !           516: 
        !           517: insert into EMP_PROJECT values (219, 510) 
        !           518: go
        !           519: 
        !           520: insert into EMP_PROJECT values (220, 512) 
        !           521: go
        !           522: 
        !           523: insert into EMP_PROJECT values (221, 501) 
        !           524: go
        !           525: 
        !           526: insert into EMP_PROJECT values (222, 503) 
        !           527: go
        !           528: 
        !           529: insert into EMP_PROJECT values (223, 507) 
        !           530: go
        !           531: 
        !           532: insert into EMP_PROJECT values (224, 510) 
        !           533: go
        !           534: 
        !           535: insert into EMP_PROJECT values (225, 512)
        !           536: go
        !           537: 
        !           538: 
        !           539: insert into PROJECT values( 501, 'BankLink Financials', null)
        !           540: go
        !           541: 
        !           542: insert into PROJECT values( 503, 'Crossover Environment', null)
        !           543: go
        !           544: 
        !           545: insert into PROJECT values( 507, 'Net DesignWorks', null)
        !           546: go
        !           547: 
        !           548: insert into PROJECT values( 510, 'InfoVault', null)
        !           549: go
        !           550: 
        !           551: insert into PROJECT values( 512, 'Customer Satisfaction', null)
        !           552: go
        !           553: 
        !           554: 
        !           555: insert into  DEPARTMENT values (100, 'General and Administration', 1104)
        !           556: go
        !           557: 
        !           558: insert into  DEPARTMENT values (101, 'Office of the President', 1207)
        !           559: go
        !           560: 
        !           561: insert into  DEPARTMENT values (104, 'Reception', 1104)
        !           562: go
        !           563: 
        !           564: insert into  DEPARTMENT values (105, 'Adminstration', 1103)
        !           565: go
        !           566: 
        !           567: insert into  DEPARTMENT values (200, 'Production and Design', 1103)
        !           568: go
        !           569: 
        !           570: insert into  DEPARTMENT values (201, 'Art Design', 1104)
        !           571: go
        !           572: 
        !           573: insert into  DEPARTMENT values (202, 'Hardware Engineering', 1106)
        !           574: go
        !           575: 
        !           576: insert into  DEPARTMENT values (203, 'System Software', 1106)
        !           577: go
        !           578: 
        !           579: insert into  DEPARTMENT values (204, 'User Software', 1101)
        !           580: go
        !           581: 
        !           582: insert into  DEPARTMENT values (250, 'Production', 1106)
        !           583: go
        !           584: 
        !           585: insert into  DEPARTMENT values (252, 'Logistics', 1101)
        !           586: go
        !           587: 
        !           588: insert into  DEPARTMENT values (300, 'Sales and Marketing', 1207)
        !           589: go
        !           590: 
        !           591: insert into  DEPARTMENT values (320, 'Domestic Marketing', 1207)
        !           592: go
        !           593: 
        !           594: insert into  DEPARTMENT values (330, 'International Marketing', 1207)
        !           595: go
        !           596: 
        !           597: insert into  DEPARTMENT values (350, 'Sales', 1207)
        !           598: go
        !           599: 
        !           600: insert into  DEPARTMENT values (400, 'Customer Service', 1106)
        !           601: go
        !           602: 
        !           603: insert into  DEPARTMENT values (405, 'Service Logistics', 1106)
        !           604: go
        !           605: 
        !           606: insert into  DEPARTMENT values (410, 'Customer Front-Line', 1106)
        !           607: go
        !           608: 
        !           609: insert into  DEPARTMENT values (420, 'Customer Back-Line', 1106)
        !           610: go
        !           611: 
        !           612: insert into  DEPARTMENT values (500, 'Personnel', 1101)
        !           613: go
        !           614: 
        !           615: insert into  DEPARTMENT values (900, 'Public Relations', 1104)
        !           616: go
        !           617: 
        !           618: 
        !           619: insert into JOB_TITLE values (1, 'President', 'Salaried')
        !           620: go
        !           621: 
        !           622: insert into JOB_TITLE values (2, 'Vice President', 'Salaried')
        !           623: go
        !           624: 
        !           625: insert into JOB_TITLE values (3, 'Director', 'Salaried')
        !           626: go
        !           627: 
        !           628: insert into JOB_TITLE values (4, 'MANAGER', 'Salaried')
        !           629: go
        !           630: 
        !           631: insert into JOB_TITLE values (5, 'Engineer', 'Hourly')
        !           632: go
        !           633: 
        !           634: insert into JOB_TITLE values (6, 'Designer', 'Hourly')
        !           635: go
        !           636: 
        !           637: insert into JOB_TITLE values (7, 'Sales Representative', 'Salaried')
        !           638: go
        !           639: 
        !           640: insert into JOB_TITLE values (8, 'Administrator', 'Hourly')
        !           641: go
        !           642: 
        !           643: insert into JOB_TITLE values (9, 'Customer Representative', 'Hourly')
        !           644: go
        !           645: 
        !           646: insert into JOB_TITLE values (10, 'Product MANAGER', 'Salaried')
        !           647: go
        !           648: 
        !           649: insert into JOB_TITLE values (11, 'Benefits and Compensation', 'Hourly')
        !           650: go
        !           651: 
        !           652: insert into JOB_TITLE values (12, 'Associate', 'Hourly')
        !           653: go
        !           654: 
        !           655: 
        !           656: insert into EMPLOYEE values ( 101, 101, 'Winston', 'James', '415-323-7265',
        !           657:  '6269 Washington Ave.', 'Woodside', 'CA', '94160', 1,
        !           658:  'Jan 14 1989 12:00:00:000AM', 101, 5700.00 )
        !           659: 
        !           660: go
        !           661: 
        !           662: insert into EMPLOYEE values ( 102, 200, 'Veasey', 'Kai', '415-323-261 ',
        !           663:  '3401 Strand St.', 'Woodside', 'CA', '94153', 2,
        !           664:  'Aug 19 1991 12:00:00:000AM', 1, 4600.00 )
        !           665: 
        !           666: go
        !           667: 
        !           668: insert into EMPLOYEE values ( 103, 400, 'MacAskill', 'Debra', '415-328-4407',
        !           669:  '3495 Middlefield Ave.', 'Mountain View', 'CA', '94245', 2,
        !           670:  'Nov 19 1992 12:00:00:000AM', 101, 4300.00 )
        !           671: 
        !           672: go
        !           673: 
        !           674: insert into EMPLOYEE values ( 104, 104, 'Oswald', 'Lesley', '415-321-564 ',
        !           675:  '6751 Chowen St.', 'Sunnyvale', 'CA', '94234', 4,
        !           676:  'Jun 20 1994 12:00:00:000AM', 101, 4200.00 )
        !           677: 
        !           678: go
        !           679: 
        !           680: insert into EMPLOYEE values ( 105, 320,'Scheer', 'Janine', '415-327-9345',
        !           681:  '295 Poplar Road', 'San Jose', 'CA', '94226', 4,
        !           682:  'Jan  5 1990 12:00:00:000AM', 107, 5700.00 )
        !           683: 
        !           684: go
        !           685: 
        !           686: insert into EMPLOYEE values ( 106, 500, 'Maselli', 'John', '415-328-9769',
        !           687:  '3494 Pelican Ave.', 'Palo Alto', 'CA', '94226', 2,
        !           688:  'Apr 16 1992 12:00:00:000AM', 101, 4900.00 )
        !           689: 
        !           690: go
        !           691: 
        !           692: insert into EMPLOYEE values ( 107, 300, 'Lunau', 'Ken', '415-322-2815',
        !           693:  '7163 York Road', 'Woodside', 'CA', '94174', 2,
        !           694:  'Dec 12 1991 12:00:00:000AM', 101, 5600.00 )
        !           695: 
        !           696: go
        !           697: 
        !           698: insert into EMPLOYEE values ( 108, 203, 'DeKeyser', 'John', '415-326-9241',
        !           699:  '5633 High Road', 'Mountain View', 'CA', '94228', 3,
        !           700:  'Nov 18 1989 12:00:00:000AM', 102, 5200.00 )
        !           701: 
        !           702: go
        !           703: 
        !           704: insert into EMPLOYEE values ( 109, 900, 'Windgate', 'Mark', '415-321-3718',
        !           705:  '4615 Oak Ave.', 'Oakland', 'CA', '94194', 2,
        !           706:  'Feb 20 1990 12:00:00:000AM', 101, 4000.00 )
        !           707: 
        !           708: go
        !           709: 
        !           710: insert into EMPLOYEE values ( 110, 400,'Walsh', 'Phyllis', '415-327-2599',
        !           711:  '3746 Oak Road', 'Palo Alto', 'CA', '94165', 5,
        !           712:  'Aug 14 1991 12:00:00:000AM', 103, 4900.00 )
        !           713: 
        !           714: go
        !           715: 
        !           716: 
        !           717: insert into EMPLOYEE values ( 111, 203, 'Quan', 'Merianne', '415-323-9827',
        !           718:  '7503 Washington Blvd.', 'Redwood City', 'CA', '94223', 5,
        !           719:  'Apr  6 1988 12:00:00:000AM', 102, 4700.00 )
        !           720: 
        !           721: go
        !           722: 
        !           723: insert into EMPLOYEE values ( 112, 300, 'Kanzaki', 'Mark', '415-324-7911',
        !           724:  '2709 Kristen St.', 'Woodside', 'CA', '94219', 3,
        !           725:  'Apr  5 1988 12:00:00:000AM', 107, 4500.00 )
        !           726: go
        !           727: 
        !           728: insert into EMPLOYEE values ( 113, 400, 'Helton', 'Dung', '415-320-6474',
        !           729:  '4397 Schoman Road', 'Woodside', 'CA', '94173', 5,
        !           730:  'Oct  9 1990 12:00:00:000AM', 103, 5600.00 )
        !           731: 
        !           732: go
        !           733: 
        !           734: insert into EMPLOYEE values ( 114, 200, 'Thiry', 'Greg', '415-326-4613',
        !           735:  '3883 Drew Road', 'Redwood City', 'CA', '94198', 10,
        !           736:  'Mar 13 1988 12:00:00:000AM', 102, 4700.00 )
        !           737: 
        !           738: go
        !           739: 
        !           740: insert into EMPLOYEE values ( 115, 400,'Gath', 'Jon', '415-322-1987',
        !           741:  '502 Johnson St.', 'Santa Clara', 'CA', '94209', 5,
        !           742:  'Nov  4 1989 12:00:00:000AM', 103, 5100.00 )
        !           743: 
        !           744: go
        !           745: 
        !           746: insert into EMPLOYEE values ( 116, 203, 'Kallimani', 'Yoshinori', '415-322-6335',
        !           747:  '7099 Knuth Ave.', 'San Jose', 'CA', '94214', 3,
        !           748:  'Dec 26 1990 12:00:00:000AM', 102, 4200.00 )
        !           749: 
        !           750: go
        !           751: 
        !           752: insert into EMPLOYEE values ( 117, 405, 'Hojnowski', 'Gregor', '415-323-2994',
        !           753:  '5215 Strand Way', 'Pacific Heights', 'CA', '94209', 5,
        !           754:  'Oct 25 1992 12:00:00:000AM', 103, 5200.00 )
        !           755: 
        !           756: go
        !           757: 
        !           758: insert into EMPLOYEE values ( 118, 300, 'Tautz', 'Denise', '415-322-3937',
        !           759:  '7851 Oak Trail', 'Woodside', 'CA', '94181', 10,
        !           760:  'Mar  3 1992 12:00:00:000AM', 107, 5100.00 )
        !           761: 
        !           762: go
        !           763: 
        !           764: insert into EMPLOYEE values ( 119, 500, 'Upson', 'Alex', '415-323-11  ',
        !           765:  '1440 Addams Circle', 'Mountain View', 'CA', '94193', 4,
        !           766:  'Sep  9 1989 12:00:00:000AM', 106, 4900.00 )
        !           767: 
        !           768: go
        !           769: 
        !           770: insert into EMPLOYEE values ( 120, 350,'Riley', 'Michael', '415-323-2795',
        !           771:  '7747 Pope Road', 'Redwood City', 'CA', '94195', 7,
        !           772:  'Feb  3 1991 12:00:00:000AM', 107, 4300.00 )
        !           773: 
        !           774: go
        !           775: 
        !           776: 
        !           777: insert into EMPLOYEE values ( 121, 252, 'Kammerer', 'Sanjay', '415-328-3042',
        !           778:  '7331 Walnut Ave.', 'Palo Alto', 'CA', '94178', 5,
        !           779:  'Jan  9 1990 12:00:00:000AM', 102, 4700.00 )
        !           780: 
        !           781: go
        !           782: 
        !           783: insert into EMPLOYEE values ( 122, 405, 'Affinito', 'Jon', '415-326-515 ',
        !           784:  '639 Schoman Ave.', 'Woodside', 'CA', '94239', 5,
        !           785:  'May  1 1988 12:00:00:000AM', 103, 5000.00 )
        !           786: 
        !           787: go
        !           788: 
        !           789: insert into EMPLOYEE values ( 123, 400, 'Liu', 'Tom', '415-321-1766',
        !           790:  '3342 Main St.', 'Sunnyvale', 'CA', '94219', 5,
        !           791:  'Jan  6 1989 12:00:00:000AM', 103, 4700.00 )
        !           792: 
        !           793: go
        !           794: 
        !           795: insert into EMPLOYEE values ( 124, 410, 'Walton', 'Jennifer', '415-324-4697',
        !           796:  '2673 France St.', 'Santa Clara', 'CA', '94157', 4,
        !           797:  'Jan 18 1990 12:00:00:000AM', 103, 5700.00 )
        !           798: 
        !           799: go
        !           800: insert into EMPLOYEE values ( 125, 101,'Page', 'Paul', '415-320-8100',
        !           801:  '2754 Johnson Ave.', 'Redwood City', 'CA', '94170', 4,
        !           802:  'Aug 18 1992 12:00:00:000AM', 101, 4200.00 )
        !           803: 
        !           804: go
        !           805: 
        !           806: insert into EMPLOYEE values ( 126, 105, 'Seng', 'Paul', '415-320-7249',
        !           807:  '4876 High Road', 'Half Moon Bay', 'CA', '94171', 6,
        !           808:  'Jul  2 1988 12:00:00:000AM', 101, 5000.00 )
        !           809: 
        !           810: go
        !           811: 
        !           812: insert into EMPLOYEE values ( 127, 101, 'Nelson', 'Andrew', '415-323-1072',
        !           813:  '562 Knuth Circle', 'Palo Alto', 'CA', '94164', 11,
        !           814:  'Nov 14 1988 12:00:00:000AM', 101, 5300.00 )
        !           815: 
        !           816: go
        !           817: 
        !           818: insert into EMPLOYEE values ( 128, 252, 'Tucker', 'Karen', '415-323-1180',
        !           819:  '1952 Lutece St.', 'Atherton', 'CA', '94195', 5,
        !           820:  'Nov 12 1989 12:00:00:000AM', 102, 5700.00 )
        !           821: 
        !           822: go
        !           823: 
        !           824: insert into EMPLOYEE values ( 129, 410, 'Tavana', 'Jim', '415-321-4763',
        !           825:  '7067 Broad Road', 'Woodside', 'CA', '94236', 4,
        !           826:  'May  5 1992 12:00:00:000AM', 103, 5500.00 )
        !           827: 
        !           828: go
        !           829: 
        !           830: insert into EMPLOYEE values ( 130, 250,'Paquette', 'Satch', '415-326-4537',
        !           831:  '6972 York Road', 'Pacific Heights', 'CA', '94158', 5,
        !           832:  'Apr 27 1992 12:00:00:000AM', 102, 4800.00 )
        !           833: 
        !           834: go
        !           835: 
        !           836: insert into EMPLOYEE values ( 131, 350, 'Egner', 'Andy', '415-322-8602',
        !           837:  '4106 Poplar St.', 'Redwood City', 'CA', '94246', 7,
        !           838:  'Sep  3 1990 12:00:00:000AM', 107, 5700.00 )
        !           839: 
        !           840: go
        !           841: 
        !           842: insert into EMPLOYEE values ( 132, 104, 'Page', 'Opal', '415-323-4670',
        !           843:  '859 Poplar St.', 'Redwood City', 'CA', '94218', 6,
        !           844:  'Mar 27 1989 12:00:00:000AM', 101, 5300.00 )
        !           845: 
        !           846: go
        !           847: 
        !           848: insert into EMPLOYEE values ( 133, 203, 'Bay', 'Rosalie', '415-320-3763',
        !           849:  '6535 Juneberry Ave.', 'Mountain View', 'CA', '94243', 4,
        !           850:  'Feb  5 1992 12:00:00:000AM', 102, 4300.00 )
        !           851: 
        !           852: go
        !           853: 
        !           854: insert into EMPLOYEE values ( 134, 300, 'Fisk', 'George', '415-326-4655',
        !           855:  '4346 Connell Circle', 'Atherton', 'CA', '94211', 3,
        !           856:  'May  1 1991 12:00:00:000AM', 107, 5700.00 )
        !           857: 
        !           858: go
        !           859: 
        !           860: insert into EMPLOYEE values ( 135, 252,'Hecker', 'Junko', '415-321-7489',
        !           861:  '3930 York Ave.', 'Redwood City', 'CA', '94178', 5,
        !           862:  'Jan 24 1988 12:00:00:000AM', 102, 4700.00 )
        !           863: 
        !           864: go
        !           865: 
        !           866: insert into EMPLOYEE values ( 136, 101, 'Walsh', 'Guiseppe', '415-328-2963',
        !           867:  '1209 High Road', 'Atherton', 'CA', '94172', 10,
        !           868:  'Nov 28 1992 12:00:00:000AM', 101, 4200.00 )
        !           869: 
        !           870: go
        !           871: 
        !           872: insert into EMPLOYEE values ( 137, 105, 'Davidson', 'Cary', '415-322-7699',
        !           873:  '4773 York St.', 'Santa Clara', 'CA', '94160', 3,
        !           874:  'May 23 1989 12:00:00:000AM', 101, 5600.00 )
        !           875: 
        !           876: go
        !           877: 
        !           878: insert into EMPLOYEE values ( 138, 250, 'Burt', 'Elida', '415-324-444 ',
        !           879:  '939 Middlefield St.', 'Santa Clara', 'CA', '94232', 5,
        !           880:  'Apr  6 1988 12:00:00:000AM', 102, 4500.00 )
        !           881: 
        !           882: go
        !           883: 
        !           884: insert into EMPLOYEE values ( 139, 900, 'Kelleher', 'Leonard', '415-328-569 ',
        !           885:  '3481 Knox St.', 'Palo Alto', 'CA', '94246', 12,
        !           886:  'Jul 27 1990 12:00:00:000AM', 109, 4600.00 )
        !           887: 
        !           888: go
        !           889: 
        !           890: insert into EMPLOYEE values ( 140, 203,'Henriquez', 'Dave', '415-320-6936',
        !           891:  '3790 Market Road', 'Belmont', 'CA', '94219', 5,
        !           892:  'Oct 10 1992 12:00:00:000AM', 102, 5700.00 )
        !           893: 
        !           894: go
        !           895: 
        !           896: 
        !           897: insert into EMPLOYEE values ( 141, 252, 'Fuster', 'Manny', '415-325-3468',
        !           898:  '6688 Poplar Blvd.', 'Millbrae', 'CA', '94187', 4,
        !           899:  'Dec 15 1990 12:00:00:000AM', 102, 5100.00 )
        !           900: 
        !           901: go
        !           902: 
        !           903: insert into EMPLOYEE values ( 142, 104, 'Cleary', 'Kathi', '415-320-3912',
        !           904:  '2746 Schoman St.', 'Redwood City', 'CA', '94150', 11,
        !           905:  'Nov 23 1991 12:00:00:000AM', 101, 5100.00 )
        !           906: 
        !           907: go
        !           908: 
        !           909: insert into EMPLOYEE values ( 143, 350, 'Moore', 'Debra', '415-326-5087',
        !           910:  '4126 Lutece Ave.', 'San Jose', 'CA', '94237', 7,
        !           911:  'Apr  4 1991 12:00:00:000AM', 107, 5000.00 )
        !           912: 
        !           913: go
        !           914: 
        !           915: insert into EMPLOYEE values ( 144, 100, 'Hopkins', 'Chris', '415-321-8620',
        !           916:  '1482 Elm Ave.', 'Oakland', 'CA', '94198', 7,
        !           917:  'Aug 13 1991 12:00:00:000AM', 101, 5300.00 )
        !           918: 
        !           919: go
        !           920: 
        !           921: insert into EMPLOYEE values ( 145, 204,'Self', 'Jack', '415-325-767 ',
        !           922:  '7044 Walnut Road', 'Half Moon Bay', 'CA', '94164', 4,
        !           923:  'Nov  5 1990 12:00:00:000AM', 102, 5500.00 )
        !           924: 
        !           925: go
        !           926: 
        !           927: insert into EMPLOYEE values ( 146, 500, 'Cerbone', 'Mark', '415-322-2943',
        !           928:  '7137 Juneberry Road', 'San Francisco', 'CA', '94172', 3,
        !           929:  'May 13 1991 12:00:00:000AM', 106, 4300.00 )
        !           930: 
        !           931: go
        !           932: 
        !           933: insert into EMPLOYEE values ( 147, 202, 'Ralston', 'Anne', '415-323-4177',
        !           934:  '3599 Beech Ave.', 'Palo Alto', 'CA', '94169', 5,
        !           935:  'Jul 20 1991 12:00:00:000AM', 102, 5000.00 )
        !           936: 
        !           937: go
        !           938: 
        !           939: insert into EMPLOYEE values ( 148, 250, 'Henry', 'John', '415-322-5562',
        !           940:  '7645 Lancaster Ave.', 'Belmont', 'CA', '94231', 5,
        !           941:  'Jan 14 1991 12:00:00:000AM', 102, 4500.00 )
        !           942: 
        !           943: go
        !           944: 
        !           945: insert into EMPLOYEE values ( 149, 200, 'Kinney', 'Alex', '415-327-8472',
        !           946:  '4044 Hanson St.', 'Mountain View', 'CA', '94239', 6,
        !           947:  'Sep 24 1990 12:00:00:000AM', 102, 5300.00 )
        !           948: 
        !           949: go
        !           950: 
        !           951: insert into EMPLOYEE values ( 150, 420,'Moore', 'James', '415-325-4316',
        !           952:  '6425 Broad Ave.', 'Redwood City', 'CA', '94244', 5,
        !           953:  'Aug 23 1989 12:00:00:000AM', 103, 5600.00 )
        !           954: 
        !           955: go
        !           956: 
        !           957: 
        !           958: insert into EMPLOYEE values ( 151, 105, 'Nguyen', 'Jorg', '415-322-2523',
        !           959:  '5531 Knuth St.', 'Pacific Heights', 'CA', '94192', 11,
        !           960:  'Feb 27 1990 12:00:00:000AM', 101, 5600.00 )
        !           961: 
        !           962: go
        !           963: 
        !           964: insert into EMPLOYEE values ( 152, 330, 'Veasey', 'David', '415-320-1483',
        !           965:  '3999 Juneberry Road', 'Belmont', 'CA', '94177', 10,
        !           966:  'Dec  8 1992 12:00:00:000AM', 107, 4400.00 )
        !           967: 
        !           968: go
        !           969: 
        !           970: insert into EMPLOYEE values ( 153, 350, 'Morse', 'Guy', '415-328-6708',
        !           971:  '1276 Middlefield Ave.', 'Atherton', 'CA', '94234', 7,
        !           972:  'Apr  4 1991 12:00:00:000AM', 107, 4000.00 )
        !           973: 
        !           974: go
        !           975: 
        !           976: insert into EMPLOYEE values ( 154, 350, 'Fordam', 'Donna', '415-320-2744',
        !           977:  '7712 Chowen St.', 'Oakland', 'CA', '94215', 7,
        !           978:  'Mar 21 1990 12:00:00:000AM', 107, 4800.00 )
        !           979: 
        !           980: go
        !           981: 
        !           982: insert into EMPLOYEE values ( 155, 320,'Walsh', 'James', '415-323-7264',
        !           983:  '3532 Anderson St.', 'San Francisco', 'CA', '94179', 10,
        !           984:  'Aug 23 1990 12:00:00:000AM', 107, 4200.00 )
        !           985: 
        !           986: go
        !           987: 
        !           988: insert into EMPLOYEE values ( 156, 420, 'Fukasawa', 'Ben', '415-327-4471',
        !           989:  '5337 Kristen Blvd.', 'Palo Alto', 'CA', '94207', 5,
        !           990:  'Sep 23 1989 12:00:00:000AM', 103, 4300.00 )
        !           991: 
        !           992: go
        !           993: 
        !           994: insert into EMPLOYEE values ( 157, 200, 'Yu', 'Martin', '415-321-9787',
        !           995:  '7580 High Ave.', 'Palo Alto', 'CA', '94186', 3,
        !           996:  'Dec 26 1991 12:00:00:000AM', 102, 4800.00 )
        !           997: 
        !           998: go
        !           999: 
        !          1000: insert into EMPLOYEE values ( 158, 201, 'Hodor', 'Lee', '415-328-151 ',
        !          1001:  '2669 Sparrow Ave.', 'Belmont', 'CA', '94194', 6,
        !          1002:  'Feb 22 1988 12:00:00:000AM', 102, 4000.00 )
        !          1003: 
        !          1004: go
        !          1005: 
        !          1006: insert into EMPLOYEE values ( 159, 203, 'Naroff', 'Unjieng,', '415-322-8693',
        !          1007:  '5176 Lincoln St.', 'San Francisco', 'CA', '94168', 5,
        !          1008:  'Jan  5 1990 12:00:00:000AM', 102, 5300.00 )
        !          1009: 
        !          1010: go
        !          1011: 
        !          1012: insert into EMPLOYEE values ( 160, 330,'Lee', 'Eric', '415-326-9238',
        !          1013:  '3234 Connell St.', 'San Francisco', 'CA', '94198', 3,
        !          1014:  'Jan 22 1989 12:00:00:000AM', 107, 4900.00 )
        !          1015: 
        !          1016: go
        !          1017: 
        !          1018: insert into EMPLOYEE values ( 161, 330, 'Barber', 'Bart', '415-320-7854',
        !          1019:  '7277 Shorebird St.', 'Half Moon Bay', 'CA', '94243', 10,
        !          1020:  'Jul 18 1991 12:00:00:000AM', 107, 4200.00 )
        !          1021: 
        !          1022: go
        !          1023: 
        !          1024: insert into EMPLOYEE values ( 162, 900, 'Patel', 'Jim', '415-322-3915',
        !          1025:  '2767 Drew St.', 'Sunnyvale', 'CA', '94214', 12,
        !          1026:  'Jul 12 1992 12:00:00:000AM', 109, 5400.00 )
        !          1027: 
        !          1028: go
        !          1029: 
        !          1030: insert into EMPLOYEE values ( 163, 900, 'Vergnot', 'Glenn', '415-324-287 ',
        !          1031:  '6882 Connell St.', 'San Francisco', 'CA', '94236', 3,
        !          1032:  'Aug 18 1991 12:00:00:000AM', 109, 4300.00 )
        !          1033: 
        !          1034: go
        !          1035: 
        !          1036: insert into EMPLOYEE values ( 164, 104, 'Hertz', 'Christian', '415-321-3157',
        !          1037:  '1884 Pope St.', 'San Jose', 'CA', '94208', 3,
        !          1038:  'Oct 12 1989 12:00:00:000AM', 101, 4000.00 )
        !          1039: 
        !          1040: go
        !          1041: 
        !          1042: insert into EMPLOYEE values ( 165, 350,'Etcheverry', 'Jon', '415-328-714 ',
        !          1043:  '2996 Lutece St.', 'Belmont', 'CA', '94216', 7,
        !          1044:  'Feb 21 1988 12:00:00:000AM', 107, 4200.00 )
        !          1045: 
        !          1046: go
        !          1047: 
        !          1048: insert into EMPLOYEE values ( 166, 101, 'Burt', 'Alice', '415-320-3192',
        !          1049:  '5114 Lancaster St.', 'Pacific Heights', 'CA', '94241', 3,
        !          1050:  'Oct 14 1992 12:00:00:000AM', 101, 5200.00 )
        !          1051: 
        !          1052: go
        !          1053: 
        !          1054: insert into EMPLOYEE values ( 167, 350, 'Novak', 'Russ', '415-326-281 ',
        !          1055:  '6478 Spruce Trail', 'Mountain View', 'CA', '94185', 7,
        !          1056:  'Apr 13 1989 12:00:00:000AM', 107, 4900.00 )
        !          1057: 
        !          1058: go
        !          1059: 
        !          1060: insert into EMPLOYEE values ( 168, 202, 'Francis', 'Vicki', '415-321-8842',
        !          1061:  '2391 Broadway Ave.', 'Redwood City', 'CA', '94220', 5,
        !          1062:  'Jul 24 1991 12:00:00:000AM', 102, 4200.00 )
        !          1063: 
        !          1064: go
        !          1065: 
        !          1066: insert into EMPLOYEE values ( 169, 201, 'Jochims', 'Hal', '415-324-8628',
        !          1067:  '6030 State Ave.', 'Palo Alto', 'CA', '94217', 6,
        !          1068:  'Jul 21 1992 12:00:00:000AM', 102, 4200.00 )
        !          1069: 
        !          1070: go
        !          1071: 
        !          1072: insert into EMPLOYEE values ( 170, 900,'Tucker', 'Tom', '415-328-2067',
        !          1073:  '3258 Wallace St.', 'Mountain View', 'CA', '94246', 12,
        !          1074:  'Mar 18 1988 12:00:00:000AM', 109, 4600.00 )
        !          1075: 
        !          1076: go
        !          1077: 
        !          1078: 
        !          1079: insert into EMPLOYEE values ( 171, 252, 'Herald', 'Ellen', '415-321-1238',
        !          1080:  '674 Addams Road', 'San Francisco', 'CA', '94228', 5,
        !          1081:  'Feb  5 1990 12:00:00:000AM', 102, 5300.00 )
        !          1082: 
        !          1083: go
        !          1084: 
        !          1085: insert into EMPLOYEE values ( 172, 405, 'Anthony', 'Mitch', '415-322-3205',
        !          1086:  '5062 Hanson Trail', 'Half Moon Bay', 'CA', '94218', 5,
        !          1087:  'May 26 1991 12:00:00:000AM', 103, 4600.00 )
        !          1088: 
        !          1089: go
        !          1090: 
        !          1091: insert into EMPLOYEE values ( 173, 350, 'Fuster', 'Lane', '415-320-9534',
        !          1092:  '7796 Main Ave.', 'Sunnyvale', 'CA', '94163', 7,
        !          1093:  'Jan 25 1988 12:00:00:000AM', 107, 4300.00 )
        !          1094: 
        !          1095: go
        !          1096: 
        !          1097: insert into EMPLOYEE values ( 174, 350, 'Dunham', 'Jim', '415-320-691 ',
        !          1098:  '3866 Lancaster St.', 'Mountain View', 'CA', '94190', 7,
        !          1099:  'Jul  9 1988 12:00:00:000AM', 107, 4700.00 )
        !          1100: 
        !          1101: go
        !          1102: 
        !          1103: insert into EMPLOYEE values ( 175, 300,'Ferrante', 'Kristen', '415-324-6344',
        !          1104:  '6086 Broad Blvd.', 'Sunnyvale', 'CA', '94216', 4,
        !          1105:  'Apr 14 1990 12:00:00:000AM', 107, 5100.00 )
        !          1106: 
        !          1107: go
        !          1108: 
        !          1109: insert into EMPLOYEE values ( 176, 202, 'Manross', 'Ken', '415-325-8979',
        !          1110:  '2452 Lincoln Blvd.', 'Pacific Heights', 'CA', '94228', 5,
        !          1111:  'Feb 18 1988 12:00:00:000AM', 102, 5600.00 )
        !          1112: 
        !          1113: go
        !          1114: 
        !          1115: insert into EMPLOYEE values ( 177, 105, 'Dahlbeck', 'Olivier', '415-326-2780',
        !          1116:  '3510 Wallace Trail', 'Millbrae', 'CA', '94187', 5,
        !          1117:  'Mar 12 1988 12:00:00:000AM', 101, 4600.00 )
        !          1118: 
        !          1119: go
        !          1120: 
        !          1121: insert into EMPLOYEE values ( 178, 400, 'Meyer', 'Bonnie', '415-324-140 ',
        !          1122:  '1885 Kristen St.', 'Belmont', 'CA', '94155', 5,
        !          1123:  'Jan 14 1991 12:00:00:000AM', 103, 4900.00 )
        !          1124: 
        !          1125: go
        !          1126: 
        !          1127: insert into EMPLOYEE values ( 179, 203, 'Lappin', 'Denise', '415-320-2072',
        !          1128:  '6441 Spruce St.', 'Palo Alto', 'CA', '94198', 5,
        !          1129:  'May 20 1992 12:00:00:000AM', 102, 5200.00 )
        !          1130: 
        !          1131: go
        !          1132: 
        !          1133: insert into EMPLOYEE values ( 180, 100,'Magennis', 'Jerry', '415-320-3085',
        !          1134:  '2457 Chowen St.', 'Redwood City', 'CA', '94224', 8,
        !          1135:  'Dec 28 1989 12:00:00:000AM', 101, 4300.00 )
        !          1136: 
        !          1137: go
        !          1138: 
        !          1139: 
        !          1140: insert into EMPLOYEE values ( 181, 202, 'Law', 'Mike', '415-320-4077',
        !          1141:  '1683 Roberts Blvd.', 'Oakland', 'CA', '94174', 5,
        !          1142:  'Jul 13 1990 12:00:00:000AM', 102, 4700.00 )
        !          1143: 
        !          1144: go
        !          1145: 
        !          1146: insert into EMPLOYEE values ( 182, 350, 'Jackson', 'Thomas', '415-320-5390',
        !          1147:  '3279 Hanson St.', 'Belmont', 'CA', '94177', 7,
        !          1148:  'Jun  8 1991 12:00:00:000AM', 107, 5300.00 )
        !          1149: 
        !          1150: go
        !          1151: 
        !          1152: insert into EMPLOYEE values ( 183, 320, 'Rokovich', 'Dung', '415-320-7176',
        !          1153:  '4656 Anderson St.', 'Palo Alto', 'CA', '94210', 10,
        !          1154:  'Jun 26 1991 12:00:00:000AM', 107, 5300.00 )
        !          1155: 
        !          1156: go
        !          1157: 
        !          1158: insert into EMPLOYEE values ( 184, 105, 'White', 'Curits', '415-320-6492',
        !          1159:  '175 Kristen St.', 'Belmont', 'CA', '94180', 9,
        !          1160:  'Jan 25 1989 12:00:00:000AM', 101, 5000.00 )
        !          1161: 
        !          1162: go
        !          1163: 
        !          1164: insert into EMPLOYEE values ( 185, 420,'Yee', 'Peggy', '415-328-1314',
        !          1165:  '4885 France Ave.', 'Half Moon Bay', 'CA', '94239', 4,
        !          1166:  'Aug 16 1990 12:00:00:000AM', 103, 4600.00 )
        !          1167: 
        !          1168: go
        !          1169: 
        !          1170: insert into EMPLOYEE values ( 186, 900, 'Derrickson', 'Joy', '415-327-5048',
        !          1171:  '5708 Elm Ave.', 'Redwood City', 'CA', '94231', 12,
        !          1172:  'Aug 15 1988 12:00:00:000AM', 109, 4700.00 )
        !          1173: 
        !          1174: go
        !          1175: 
        !          1176: insert into EMPLOYEE values ( 187, 330, 'Steenkamer', 'Jerry', '415-324-4072',
        !          1177:  '3861 Washington St.', 'San Jose', 'CA', '94238', 4,
        !          1178:  'Oct  6 1991 12:00:00:000AM', 107, 5200.00 )
        !          1179: 
        !          1180: go
        !          1181: 
        !          1182: insert into EMPLOYEE values ( 188, 252, 'Sridhara', 'Dieter', '415-321-5690',
        !          1183:  '3025 Lancaster Blvd.', 'Atherton', 'CA', '94233', 5,
        !          1184:  'Jun  7 1988 12:00:00:000AM', 102, 4900.00 )
        !          1185: 
        !          1186: go
        !          1187: 
        !          1188: insert into EMPLOYEE values ( 189, 100, 'Mikkelsen', 'Rob', '415-321-6689',
        !          1189:  '4027 Shorebird Ave.', 'Woodside', 'CA', '94188', 9,
        !          1190:  'May 12 1991 12:00:00:000AM', 101, 4400.00 )
        !          1191: 
        !          1192: go
        !          1193: 
        !          1194: insert into EMPLOYEE values ( 190, 500,'Yee', 'Kollivakkam', '415-324-1358',
        !          1195:  '3271 Knuth St.', 'Palo Alto', 'CA', '94217', 4,
        !          1196:  'Jan 10 1988 12:00:00:000AM', 106, 4800.00 )
        !          1197: 
        !          1198: go
        !          1199: 
        !          1200: 
        !          1201: insert into EMPLOYEE values ( 191, 204, 'Guerrero', 'Stephen', '415-321-6736',
        !          1202:  '6368 Anderson St.', 'Palo Alto', 'CA', '94173', 5,
        !          1203:  'Jun  3 1992 12:00:00:000AM', 102, 4600.00 )
        !          1204: 
        !          1205: go
        !          1206: 
        !          1207: insert into EMPLOYEE values ( 192, 420, 'Page', 'Michael', '415-321-1199',
        !          1208:  '7713 Middlefield Ave.', 'Atherton', 'CA', '94194', 5,
        !          1209:  'Nov 23 1988 12:00:00:000AM', 103, 4500.00 )
        !          1210: 
        !          1211: go
        !          1212: 
        !          1213: insert into EMPLOYEE values ( 193, 350, 'McClung', 'Chad', '415-327-1329',
        !          1214:  '2902 Connell Ave.', 'Sunnyvale', 'CA', '94181', 7,
        !          1215:  'Aug 25 1988 12:00:00:000AM', 107, 4200.00 )
        !          1216: 
        !          1217: go
        !          1218: 
        !          1219: insert into EMPLOYEE values ( 194, 104, 'Perka', 'Sam', '415-326-1256',
        !          1220:  '61 Knox St.', 'Santa Clara', 'CA', '94191', 9,
        !          1221:  'Nov 23 1988 12:00:00:000AM', 101, 4900.00 )
        !          1222: 
        !          1223: go
        !          1224: 
        !          1225: insert into EMPLOYEE values ( 195, 420, 'Sickinghe', 'Sherman', '415-325-2233',
        !          1226:  '4865 France St.', 'Atherton', 'CA', '94207', 5,
        !          1227:  'Jul 19 1989 12:00:00:000AM', 103, 4500.00 )
        !          1228: 
        !          1229: go
        !          1230: 
        !          1231: insert into EMPLOYEE values ( 196, 250, 'Welch', 'Robin', '415-328-1833',
        !          1232:  '7631 Knox Road', 'Mountain View', 'CA', '94153', 5,
        !          1233:  'Oct 21 1991 12:00:00:000AM', 102, 4100.00 )
        !          1234: 
        !          1235: go
        !          1236: 
        !          1237: insert into EMPLOYEE values ( 197, 105, 'Nardin', 'Larry', '415-321-2064',
        !          1238:  '6179 Main St.', 'Tiberon', 'CA', '94157', 8,
        !          1239:  'Dec 13 1992 12:00:00:000AM', 101, 4600.00 )
        !          1240: 
        !          1241: go
        !          1242: 
        !          1243: insert into EMPLOYEE values ( 198, 100, 'Zamarripa', 'Drew', '415-320-2956',
        !          1244:  '6542 State St.', 'Pacific Heights', 'CA', '94163', 10,
        !          1245:  'Jul 18 1991 12:00:00:000AM', 101, 5400.00 )
        !          1246: 
        !          1247: go
        !          1248: 
        !          1249: insert into EMPLOYEE values ( 199, 500, 'Edwards', 'John', '415-328-186 ',
        !          1250:  '1318 Chowen St.', 'Mountain View', 'CA', '94198', 4,
        !          1251:  'Jun 12 1989 12:00:00:000AM', 106, 5100.00 )
        !          1252: 
        !          1253: go
        !          1254: 
        !          1255: insert into EMPLOYEE values ( 200, 202,'Schrey', 'Scott', '415-323-3258',
        !          1256:  '4033 Knox Road', 'Woodside', 'CA', '94206', 5,
        !          1257:  'Nov  2 1989 12:00:00:000AM', 102, 4000.00 )
        !          1258: 
        !          1259: go
        !          1260: 
        !          1261: 
        !          1262: insert into EMPLOYEE values ( 201, 320, 'Jackson', 'Mike', '415-323-8048',
        !          1263:  '6956 Spruce St.', 'Mountain View', 'CA', '94187', 10,
        !          1264:  'Apr 14 1992 12:00:00:000AM', 107, 4700.00 )
        !          1265: 
        !          1266: go
        !          1267: 
        !          1268: insert into EMPLOYEE values ( 202, 252, 'Mostofi', 'Richard', '415-324-3019',
        !          1269:  '1704 Lancaster Road', 'Palo Alto', 'CA', '94206', 5,
        !          1270:  'Aug 12 1989 12:00:00:000AM', 102, 4500.00 )
        !          1271: 
        !          1272: go
        !          1273: 
        !          1274: insert into EMPLOYEE values ( 203, 410, 'Bonidy', 'Salvatore', '415-322-582 ',
        !          1275:  '3116 Knuth Ave.', 'Half Moon Bay', 'CA', '94245', 5,
        !          1276:  'Apr 14 1992 12:00:00:000AM', 103, 5200.00 )
        !          1277: 
        !          1278: go
        !          1279: 
        !          1280: insert into EMPLOYEE values ( 204, 101, 'Janssen', 'Gene', '415-327-7614',
        !          1281:  '648 Washington Way', 'San Jose', 'CA', '94175', 8,
        !          1282:  'Apr 17 1988 12:00:00:000AM', 1, 4300.00 )
        !          1283: 
        !          1284: go
        !          1285: 
        !          1286: insert into EMPLOYEE values ( 205, 252,'Scott', 'Ken', '415-325-3118',
        !          1287:  '5936 Strand Road', 'Palo Alto', 'CA', '94150', 5,
        !          1288:  'Jul 13 1989 12:00:00:000AM', 102, 5700.00 )
        !          1289: 
        !          1290: go
        !          1291: 
        !          1292: insert into EMPLOYEE values ( 206, 101, 'Droulers', 'Matt', '415-322-213 ',
        !          1293:  '4617 Roberts Blvd.', 'Sunnyvale', 'CA', '94232', 7,
        !          1294:  'Nov 23 1990 12:00:00:000AM', 101, 4400.00 )
        !          1295: 
        !          1296: go
        !          1297: 
        !          1298: insert into EMPLOYEE values ( 207, 202, 'Pinkerton', 'Matt', '415-324-6350',
        !          1299:  '7803 Sparrow Road', 'Woodside', 'CA', '94245', 4,
        !          1300:  'Jul  6 1991 12:00:00:000AM', 102, 5600.00 )
        !          1301: 
        !          1302: go
        !          1303: 
        !          1304: insert into EMPLOYEE values ( 208, 202, 'Campetelli', 'Margaret', '415-321-2664',
        !          1305:  '7435 Strand Blvd.', 'Redwood City', 'CA', '94200', 5,
        !          1306:  'Sep 19 1992 12:00:00:000AM', 102, 5200.00 )
        !          1307: 
        !          1308: go
        !          1309: 
        !          1310: insert into EMPLOYEE values ( 209, 410, 'Lee', 'Jerry', '415-325-9499',
        !          1311:  '1484 Adams St.', 'Tiberon', 'CA', '94191', 5,
        !          1312:  'Jan 11 1991 12:00:00:000AM', 103, 5000.00 )
        !          1313: 
        !          1314: go
        !          1315: 
        !          1316: insert into EMPLOYEE values ( 210, 250,'Bucher', 'Fred', '415-323-8440',
        !          1317:  '7048 Knox Road', 'Palo Alto', 'CA', '94243', 3,
        !          1318:  'May 18 1988 12:00:00:000AM', 102, 4000.00 )
        !          1319: 
        !          1320: go
        !          1321: 
        !          1322: 
        !          1323: insert into EMPLOYEE values ( 211, 400, 'Farah', 'David', '415-322-2744',
        !          1324:  '1691 Pelican St.', 'San Francisco', 'CA', '94242', 5,
        !          1325:  'Mar 17 1988 12:00:00:000AM', 103, 4600.00 )
        !          1326: 
        !          1327: go
        !          1328: 
        !          1329: insert into EMPLOYEE values ( 212, 350, 'Avenell', 'Perry', '415-328-1319',
        !          1330:  '5910 Lutece Road', 'Palo Alto', 'CA', '94172', 7,
        !          1331:  'May  9 1992 12:00:00:000AM', 107, 5500.00 )
        !          1332: 
        !          1333: go
        !          1334: 
        !          1335: insert into EMPLOYEE values ( 213, 200, 'Butler', 'Mike', '415-327-8235',
        !          1336:  '5872 Regent Ave.', 'Palo Alto', 'CA', '94226', 11,
        !          1337:  'May  5 1990 12:00:00:000AM', 102, 5400.00 )
        !          1338: 
        !          1339: go
        !          1340: 
        !          1341: insert into EMPLOYEE values ( 214, 405, 'Graves', 'David', '415-323-6928',
        !          1342:  '5706 Shorebird Road', 'Sunnyvale', 'CA', '94173', 5,
        !          1343:  'Nov 14 1992 12:00:00:000AM', 103, 4100.00 )
        !          1344: 
        !          1345: go
        !          1346: 
        !          1347: insert into EMPLOYEE values ( 215, 350,'Hourvitz', 'Keith', '415-326-7210',
        !          1348:  '1092 Pelican St.', 'Sunnyvale', 'CA', '94185', 7,
        !          1349:  'Mar  6 1989 12:00:00:000AM', 107, 5400.00 )
        !          1350: 
        !          1351: go
        !          1352: 
        !          1353: insert into EMPLOYEE values ( 216, 105, 'Messer', 'Tushar', '415-322-2698',
        !          1354:  '7117 Drew Road', 'Tiberon', 'CA', '94201', 3,
        !          1355:  'Feb 21 1990 12:00:00:000AM', 101, 4800.00 )
        !          1356: 
        !          1357: go
        !          1358: 
        !          1359: insert into EMPLOYEE values ( 217, 101, 'Bumgarner', 'Kristen', '415-321-2840',
        !          1360:  '2039 Adams St.', 'Belmont', 'CA', '94174', 9,
        !          1361:  'Apr 17 1988 12:00:00:000AM', 101, 5600.00 )
        !          1362: 
        !          1363: go
        !          1364: 
        !          1365: insert into EMPLOYEE values ( 218, 201, 'Derrickson', 'Ben', '415-322-5122',
        !          1366:  '513 Connell St.', 'Tiberon', 'CA', '94176', 6,
        !          1367:  'Aug 15 1988 12:00:00:000AM', 102, 4900.00 )
        !          1368: 
        !          1369: go
        !          1370: 
        !          1371: insert into EMPLOYEE values ( 219, 101, 'Rushin', 'Mark', '415-323-5883',
        !          1372:  '5391 Addams St.', 'Redwood City', 'CA', '94221', 6,
        !          1373:  'Oct 14 1989 12:00:00:000AM', 101, 4900.00 )
        !          1374: 
        !          1375: go
        !          1376: 
        !          1377: insert into EMPLOYEE values ( 220, 100,'Graffagnino', 'Susan', '415-323-3617',
        !          1378:  '5999 Walnut Circle', 'Tiberon', 'CA', '94239', 7,
        !          1379:  'Jan  6 1992 12:00:00:000AM', 101, 4400.00 )
        !          1380: 
        !          1381: go
        !          1382: 
        !          1383: 
        !          1384: insert into EMPLOYEE values ( 221, 202, 'Gibbons', 'Jim', '415-326-9370',
        !          1385:  '2305 Emerson St.', 'Millbrae', 'CA', '94188', 4,
        !          1386:  'Nov 13 1988 12:00:00:000AM', 102, 4700.00 )
        !          1387: 
        !          1388: go
        !          1389: 
        !          1390: insert into EMPLOYEE values ( 222, 101, 'Wasmeier', 'Ken', '415-326-6257',
        !          1391:  '7802 Schoman St.', 'Atherton', 'CA', '94159', 8,
        !          1392:  'Nov  5 1990 12:00:00:000AM', 101, 5300.00 )
        !          1393: 
        !          1394: go
        !          1395: 
        !          1396: insert into EMPLOYEE values ( 223, 405, 'Joseph', 'Ralph', '415-325-6536',
        !          1397:  '3635 France St.', 'San Jose', 'CA', '94199', 5,
        !          1398:  'May 15 1989 12:00:00:000AM', 103, 4100.00 )
        !          1399: 
        !          1400: go
        !          1401: 
        !          1402: insert into EMPLOYEE values ( 224, 201, 'Fried', 'Joel', '415-320-9111',
        !          1403:  '1493 Roberts St.', 'Palo Alto', 'CA', '94196', 6,
        !          1404:  'Apr  2 1989 12:00:00:000AM', 102, 5200.00 )
        !          1405: 
        !          1406: go
        !          1407: 
        !          1408: insert into EMPLOYEE values ( 225, 410,'Blumenfeld', 'Linda', '415-321-2818',
        !          1409:  '4373 Roberts St.', 'Mountain View', 'CA', '94195', 5,
        !          1410:  'Jun 11 1991 12:00:00:000AM', 103, 5700.00 )
        !          1411: 
        !          1412: go
        !          1413: 
        !          1414: insert into EMP_PHOTO(EMP_ID) values (101)
        !          1415: insert into EMP_PHOTO(EMP_ID) values (102)
        !          1416: insert into EMP_PHOTO(EMP_ID) values (103)
        !          1417: insert into EMP_PHOTO(EMP_ID) values (104)
        !          1418: insert into EMP_PHOTO(EMP_ID) values (105)
        !          1419: insert into EMP_PHOTO(EMP_ID) values (106)
        !          1420: insert into EMP_PHOTO(EMP_ID) values (107)
        !          1421: insert into EMP_PHOTO(EMP_ID) values (108)
        !          1422: insert into EMP_PHOTO(EMP_ID) values (109)
        !          1423: insert into EMP_PHOTO(EMP_ID) values (110)
        !          1424: insert into EMP_PHOTO(EMP_ID) values (111)
        !          1425: insert into EMP_PHOTO(EMP_ID) values (112)
        !          1426: insert into EMP_PHOTO(EMP_ID) values (113)
        !          1427: insert into EMP_PHOTO(EMP_ID) values (114)
        !          1428: insert into EMP_PHOTO(EMP_ID) values (115)
        !          1429: insert into EMP_PHOTO(EMP_ID) values (116)
        !          1430: insert into EMP_PHOTO(EMP_ID) values (117)
        !          1431: insert into EMP_PHOTO(EMP_ID) values (118)
        !          1432: insert into EMP_PHOTO(EMP_ID) values (119)
        !          1433: insert into EMP_PHOTO(EMP_ID) values (120)
        !          1434: insert into EMP_PHOTO(EMP_ID) values (121)
        !          1435: insert into EMP_PHOTO(EMP_ID) values (122)
        !          1436: insert into EMP_PHOTO(EMP_ID) values (123)
        !          1437: insert into EMP_PHOTO(EMP_ID) values (124)
        !          1438: insert into EMP_PHOTO(EMP_ID) values (125)
        !          1439: insert into EMP_PHOTO(EMP_ID) values (126)
        !          1440: insert into EMP_PHOTO(EMP_ID) values (127)
        !          1441: insert into EMP_PHOTO(EMP_ID) values (128)
        !          1442: insert into EMP_PHOTO(EMP_ID) values (129)
        !          1443: insert into EMP_PHOTO(EMP_ID) values (130)
        !          1444: insert into EMP_PHOTO(EMP_ID) values (131)
        !          1445: insert into EMP_PHOTO(EMP_ID) values (132)
        !          1446: insert into EMP_PHOTO(EMP_ID) values (133)
        !          1447: insert into EMP_PHOTO(EMP_ID) values (134)
        !          1448: insert into EMP_PHOTO(EMP_ID) values (135)
        !          1449: insert into EMP_PHOTO(EMP_ID) values (136)
        !          1450: insert into EMP_PHOTO(EMP_ID) values (137)
        !          1451: insert into EMP_PHOTO(EMP_ID) values (138)
        !          1452: insert into EMP_PHOTO(EMP_ID) values (139)
        !          1453: insert into EMP_PHOTO(EMP_ID) values (140)
        !          1454: insert into EMP_PHOTO(EMP_ID) values (141)
        !          1455: insert into EMP_PHOTO(EMP_ID) values (142)
        !          1456: insert into EMP_PHOTO(EMP_ID) values (143)
        !          1457: insert into EMP_PHOTO(EMP_ID) values (144)
        !          1458: insert into EMP_PHOTO(EMP_ID) values (145)
        !          1459: insert into EMP_PHOTO(EMP_ID) values (146)
        !          1460: insert into EMP_PHOTO(EMP_ID) values (147)
        !          1461: insert into EMP_PHOTO(EMP_ID) values (148)
        !          1462: insert into EMP_PHOTO(EMP_ID) values (149)
        !          1463: insert into EMP_PHOTO(EMP_ID) values (150)
        !          1464: insert into EMP_PHOTO(EMP_ID) values (151)
        !          1465: insert into EMP_PHOTO(EMP_ID) values (152)
        !          1466: insert into EMP_PHOTO(EMP_ID) values (153)
        !          1467: insert into EMP_PHOTO(EMP_ID) values (154)
        !          1468: insert into EMP_PHOTO(EMP_ID) values (155)
        !          1469: insert into EMP_PHOTO(EMP_ID) values (156)
        !          1470: insert into EMP_PHOTO(EMP_ID) values (157)
        !          1471: insert into EMP_PHOTO(EMP_ID) values (158)
        !          1472: insert into EMP_PHOTO(EMP_ID) values (159)
        !          1473: insert into EMP_PHOTO(EMP_ID) values (160)
        !          1474: insert into EMP_PHOTO(EMP_ID) values (161)
        !          1475: insert into EMP_PHOTO(EMP_ID) values (162)
        !          1476: insert into EMP_PHOTO(EMP_ID) values (163)
        !          1477: insert into EMP_PHOTO(EMP_ID) values (164)
        !          1478: insert into EMP_PHOTO(EMP_ID) values (165)
        !          1479: insert into EMP_PHOTO(EMP_ID) values (166)
        !          1480: insert into EMP_PHOTO(EMP_ID) values (167)
        !          1481: insert into EMP_PHOTO(EMP_ID) values (168)
        !          1482: insert into EMP_PHOTO(EMP_ID) values (169)
        !          1483: insert into EMP_PHOTO(EMP_ID) values (170)
        !          1484: insert into EMP_PHOTO(EMP_ID) values (171)
        !          1485: insert into EMP_PHOTO(EMP_ID) values (172)
        !          1486: insert into EMP_PHOTO(EMP_ID) values (173)
        !          1487: insert into EMP_PHOTO(EMP_ID) values (174)
        !          1488: insert into EMP_PHOTO(EMP_ID) values (175)
        !          1489: insert into EMP_PHOTO(EMP_ID) values (176)
        !          1490: insert into EMP_PHOTO(EMP_ID) values (177)
        !          1491: insert into EMP_PHOTO(EMP_ID) values (178)
        !          1492: insert into EMP_PHOTO(EMP_ID) values (179)
        !          1493: insert into EMP_PHOTO(EMP_ID) values (180)
        !          1494: insert into EMP_PHOTO(EMP_ID) values (181)
        !          1495: insert into EMP_PHOTO(EMP_ID) values (182)
        !          1496: insert into EMP_PHOTO(EMP_ID) values (183)
        !          1497: insert into EMP_PHOTO(EMP_ID) values (184)
        !          1498: insert into EMP_PHOTO(EMP_ID) values (185)
        !          1499: insert into EMP_PHOTO(EMP_ID) values (186)
        !          1500: insert into EMP_PHOTO(EMP_ID) values (187)
        !          1501: insert into EMP_PHOTO(EMP_ID) values (188)
        !          1502: insert into EMP_PHOTO(EMP_ID) values (189)
        !          1503: insert into EMP_PHOTO(EMP_ID) values (190)
        !          1504: insert into EMP_PHOTO(EMP_ID) values (191)
        !          1505: insert into EMP_PHOTO(EMP_ID) values (192)
        !          1506: insert into EMP_PHOTO(EMP_ID) values (193)
        !          1507: insert into EMP_PHOTO(EMP_ID) values (194)
        !          1508: insert into EMP_PHOTO(EMP_ID) values (195)
        !          1509: insert into EMP_PHOTO(EMP_ID) values (196)
        !          1510: insert into EMP_PHOTO(EMP_ID) values (197)
        !          1511: insert into EMP_PHOTO(EMP_ID) values (198)
        !          1512: insert into EMP_PHOTO(EMP_ID) values (199)
        !          1513: insert into EMP_PHOTO(EMP_ID) values (200)
        !          1514: insert into EMP_PHOTO(EMP_ID) values (201)
        !          1515: insert into EMP_PHOTO(EMP_ID) values (202)
        !          1516: insert into EMP_PHOTO(EMP_ID) values (203)
        !          1517: insert into EMP_PHOTO(EMP_ID) values (204)
        !          1518: insert into EMP_PHOTO(EMP_ID) values (205)
        !          1519: insert into EMP_PHOTO(EMP_ID) values (206)
        !          1520: insert into EMP_PHOTO(EMP_ID) values (207)
        !          1521: insert into EMP_PHOTO(EMP_ID) values (208)
        !          1522: insert into EMP_PHOTO(EMP_ID) values (209)
        !          1523: insert into EMP_PHOTO(EMP_ID) values (210)
        !          1524: insert into EMP_PHOTO(EMP_ID) values (211)
        !          1525: insert into EMP_PHOTO(EMP_ID) values (212)
        !          1526: insert into EMP_PHOTO(EMP_ID) values (213)
        !          1527: insert into EMP_PHOTO(EMP_ID) values (214)
        !          1528: insert into EMP_PHOTO(EMP_ID) values (215)
        !          1529: insert into EMP_PHOTO(EMP_ID) values (216)
        !          1530: insert into EMP_PHOTO(EMP_ID) values (217)
        !          1531: insert into EMP_PHOTO(EMP_ID) values (218)
        !          1532: insert into EMP_PHOTO(EMP_ID) values (219)
        !          1533: insert into EMP_PHOTO(EMP_ID) values (220)
        !          1534: insert into EMP_PHOTO(EMP_ID) values (221)
        !          1535: insert into EMP_PHOTO(EMP_ID) values (222)
        !          1536: insert into EMP_PHOTO(EMP_ID) values (223)
        !          1537: insert into EMP_PHOTO(EMP_ID) values (224)
        !          1538: insert into EMP_PHOTO(EMP_ID) values (225)
        !          1539: go
        !          1540: 
        !          1541: 
        !          1542: 
        !          1543: 
        !          1544: insert into EMP_EQUIPMENT values (1100, 'NeXTstation 8/105', '984-9749', 119)
        !          1545: go
        !          1546: 
        !          1547: insert into EMP_EQUIPMENT values (1101, 'NeXTstation 8/105', '929-22249', 149)
        !          1548: go
        !          1549: 
        !          1550: insert into EMP_EQUIPMENT values (1102, 'NeXTstation Color 8/105', '397-40272', 166)
        !          1551: go
        !          1552: 
        !          1553: insert into EMP_EQUIPMENT values (1103, 'NeXTstation Color 16/200', '233-86445', 127)
        !          1554: go
        !          1555: 
        !          1556: insert into EMP_EQUIPMENT values (1104, 'NeXTstation 16/400', '207-53910', 131)
        !          1557: go
        !          1558: 
        !          1559: insert into EMP_EQUIPMENT values (1105, 'NeXTstation  Color Turbo 16/200', '508-67548', 147)
        !          1560: go
        !          1561: 
        !          1562: insert into EMP_EQUIPMENT values (1106, 'NeXTstation 16/200', '436-80755', 161)
        !          1563: go
        !          1564: 
        !          1565: insert into EMP_EQUIPMENT values (1107, 'NeXTstation  Color Turbo 16/200', '543-37393', 156)
        !          1566: go
        !          1567: 
        !          1568: insert into EMP_EQUIPMENT values (1108, 'NeXTstation 16/200', '547-30645', 218)
        !          1569: go
        !          1570: 
        !          1571: insert into EMP_EQUIPMENT values (1109, 'NeXTstation 8/105', '476-93085', 178)
        !          1572: go
        !          1573: 
        !          1574: insert into EMP_EQUIPMENT values (1110, 'NeXTDimension', '336-24689', 137)
        !          1575: go
        !          1576: 
        !          1577: insert into EMP_EQUIPMENT values (1111, 'NeXTstation Turbo 16/400', '549-35596', 193)
        !          1578: go
        !          1579: 
        !          1580: insert into EMP_EQUIPMENT values (1112, 'NeXTstation Color 8/105', '26-33143', 144)
        !          1581: go
        !          1582: 
        !          1583: insert into EMP_EQUIPMENT values (1113, 'NeXTstation  Color Turbo 8/105', '393-60933', 164)
        !          1584: go
        !          1585: 
        !          1586: insert into EMP_EQUIPMENT values (1114, 'NeXTstation Color 8/105', '748-91478', 184)
        !          1587: go
        !          1588: 
        !          1589: insert into EMP_EQUIPMENT values (1115, 'NeXTDimension', '754-23106', 140)
        !          1590: go
        !          1591: 
        !          1592: insert into EMP_EQUIPMENT values (1116, 'NeXTstation  Color Turbo 16/400', '372-28680', 152)
        !          1593: go
        !          1594: 
        !          1595: insert into EMP_EQUIPMENT values (1117, 'NeXTstation Color 16/400', '13-44241', 211)
        !          1596: go
        !          1597: 
        !          1598: insert into EMP_EQUIPMENT values (1118, 'NeXTstation  Color Turbo 16/200', '539-51330', 214)
        !          1599: go
        !          1600: 
        !          1601: insert into EMP_EQUIPMENT values (1119, 'NeXTstation Color 16/200', '418-68918', 103)
        !          1602: go
        !          1603: 
        !          1604: insert into EMP_EQUIPMENT values (1120, 'NeXTstation 16/200', '809-46727', 143)
        !          1605: go
        !          1606: 
        !          1607: insert into EMP_EQUIPMENT values (1121, 'NeXTstation 8/105', '279-2385', 118)
        !          1608: go
        !          1609: 
        !          1610: insert into EMP_EQUIPMENT values (1122, 'NeXTstation  Color Turbo 16/200', '414-69939', 179)
        !          1611: go
        !          1612: 
        !          1613: insert into EMP_EQUIPMENT values (1123, 'NeXTstation  Color Turbo 16/200', '796-69543', 188)
        !          1614: go
        !          1615: 
        !          1616: insert into EMP_EQUIPMENT values (1124, 'NeXTstation  Color Turbo 16/200', '537-89239', 154)
        !          1617: go
        !          1618: 
        !          1619: insert into EMP_EQUIPMENT values (1125, 'NeXTstation 16/400', '541-23964', 198)
        !          1620: go
        !          1621: 
        !          1622: insert into EMP_EQUIPMENT values (1126, 'NeXTstation Turbo 16/400', '178-21075', 113)
        !          1623: go
        !          1624: 
        !          1625: insert into EMP_EQUIPMENT values (1127, 'NeXTstation 16/200', '243-74685', 183)
        !          1626: go
        !          1627: 
        !          1628: insert into EMP_EQUIPMENT values (1128, 'NeXTstation 16/400', '702-51108', 138)
        !          1629: go
        !          1630: 
        !          1631: insert into EMP_EQUIPMENT values (1129, 'NeXTstation 16/200', '193-79563', 171)
        !          1632: go
        !          1633: 
        !          1634: insert into EMP_EQUIPMENT values (1130, 'NeXTstation Color 16/200', '595-86545', 160)
        !          1635: go
        !          1636: 
        !          1637: insert into EMP_EQUIPMENT values (1131, 'NeXTstation Color 16/200', '226-22739', 210)
        !          1638: go
        !          1639: 
        !          1640: insert into EMP_EQUIPMENT values (1132, 'NeXTstation Turbo 16/400', '98-6934', 204)
        !          1641: go
        !          1642: 
        !          1643: insert into EMP_EQUIPMENT values (1133, 'NeXTstation 16/400', '513-28929', 134)
        !          1644: go
        !          1645: 
        !          1646: insert into EMP_EQUIPMENT values (1134, 'NeXTstation 8/105', '349-4738', 163)
        !          1647: go
        !          1648: 
        !          1649: insert into EMP_EQUIPMENT values (1135, 'NeXTstation  Color Turbo 16/200', '941-66087', 132)
        !          1650: go
        !          1651: 
        !          1652: insert into EMP_EQUIPMENT values (1136, 'NeXTstation Color 16/400', '382-65389', 114)
        !          1653: go
        !          1654: 
        !          1655: insert into EMP_EQUIPMENT values (1137, 'NeXTstation 16/400', '664-62232', 117)
        !          1656: go
        !          1657: 
        !          1658: insert into EMP_EQUIPMENT values (1138, 'NeXTstation Color 8/105', '5-36913', 136)
        !          1659: go
        !          1660: 
        !          1661: insert into EMP_EQUIPMENT values (1139, 'NeXTstation Color 16/400', '370-90496', 153)
        !          1662: go
        !          1663: 
        !          1664: insert into EMP_EQUIPMENT values (1140, 'NeXTDimension', '984-7872', 169)
        !          1665: go
        !          1666: 
        !          1667: insert into EMP_EQUIPMENT values (1141, 'NeXTstation Color 16/400', '277-34231', 145)
        !          1668: go
        !          1669: 
        !          1670: insert into EMP_EQUIPMENT values (1142, 'NeXTstation 16/400', '753-51711', 150)
        !          1671: go
        !          1672: 
        !          1673: insert into EMP_EQUIPMENT values (1143, 'NeXTstation  Color Turbo 8/105', '123-7629', 155)
        !          1674: go
        !          1675: 
        !          1676: insert into EMP_EQUIPMENT values (1144, 'NeXTstation 16/400', '800-3038', 124)
        !          1677: go
        !          1678: 
        !          1679: insert into EMP_EQUIPMENT values (1145, 'NeXTstation Color 8/105', '486-77628', 180)
        !          1680: go
        !          1681: 
        !          1682: insert into EMP_EQUIPMENT values (1146, 'NeXTstation 8/105', '824-13576', 187)
        !          1683: go
        !          1684: 
        !          1685: insert into EMP_EQUIPMENT values (1147, 'NeXTstation Color 8/105', '626-42240', 209)
        !          1686: go
        !          1687: 
        !          1688: insert into EMP_EQUIPMENT values (1148, 'NeXTstation  Color Turbo 8/105', '781-27064', 129)
        !          1689: go
        !          1690: 
        !          1691: insert into EMP_EQUIPMENT values (1149, 'NeXTstation  Color Turbo 16/200', '914-13130', 162)
        !          1692: go
        !          1693: 
        !          1694: insert into EMP_EQUIPMENT values (1150, 'NeXTstation Turbo 16/400', '95-49295', 174)
        !          1695: go
        !          1696: 
        !          1697: insert into EMP_EQUIPMENT values (1151, 'NeXTstation Color 8/105', '647-96907', 221)
        !          1698: go
        !          1699: 
        !          1700: insert into EMP_EQUIPMENT values (1152, 'NeXTDimension', '117-87463', 224)
        !          1701: go
        !          1702: 
        !          1703: insert into EMP_EQUIPMENT values (1153, 'NeXTstation  Color Turbo 16/200', '670-29606', 106)
        !          1704: go
        !          1705: 
        !          1706: insert into EMP_EQUIPMENT values (1154, 'NeXTstation 16/400', '332-52077', 148)
        !          1707: go
        !          1708: 
        !          1709: insert into EMP_EQUIPMENT values (1155, 'NeXTstation Color 16/200', '852-63799', 199)
        !          1710: go
        !          1711: 
        !          1712: insert into EMP_EQUIPMENT values (1156, 'NeXTstation Color 8/105', '440-37613', 115)
        !          1713: go
        !          1714: 
        !          1715: insert into EMP_EQUIPMENT values (1157, 'NeXTstation  Color Turbo 16/400', '298-58959', 122)
        !          1716: go
        !          1717: 
        !          1718: insert into EMP_EQUIPMENT values (1158, 'NeXTstation  Color Turbo 8/105', '164-40348', 165)
        !          1719: go
        !          1720: 
        !          1721: insert into EMP_EQUIPMENT values (1159, 'NeXTstation  Color Turbo 8/105', '975-497', 151)
        !          1722: go
        !          1723: 
        !          1724: insert into EMP_EQUIPMENT values (1160, 'NeXTstation Color 16/200', '741-12300', 186)
        !          1725: go
        !          1726: 
        !          1727: insert into EMP_EQUIPMENT values (1161, 'NeXTstation 8/105', '126-40700', 135)
        !          1728: go
        !          1729: 
        !          1730: insert into EMP_EQUIPMENT values (1162, 'NeXTstation 16/200', '923-50658', 102)
        !          1731: go
        !          1732: 
        !          1733: insert into EMP_EQUIPMENT values (1163, 'NeXTstation  Color Turbo 16/200', '705-40124', 105)
        !          1734: go
        !          1735: 
        !          1736: insert into EMP_EQUIPMENT values (1164, 'NeXTstation Color 16/400', '985-27011', 128)
        !          1737: go
        !          1738: 
        !          1739: insert into EMP_EQUIPMENT values (1165, 'NeXTstation 16/400', '83-84294', 142)
        !          1740: go
        !          1741: 
        !          1742: insert into EMP_EQUIPMENT values (1166, 'NeXTstation 16/400', '233-32050', 215)
        !          1743: go
        !          1744: 
        !          1745: insert into EMP_EQUIPMENT values (1167, 'NeXTstation 16/400', '226-34036', 107)
        !          1746: go
        !          1747: 
        !          1748: insert into EMP_EQUIPMENT values (1168, 'NeXTDimension', '524-60536', 176)
        !          1749: go
        !          1750: 
        !          1751: insert into EMP_EQUIPMENT values (1169, 'NeXTstation 8/105', '104-65265', 205)
        !          1752: go
        !          1753: 
        !          1754: insert into EMP_EQUIPMENT values (1170, 'NeXTstation  Color Turbo 16/400', '794-54450', 222)
        !          1755: go
        !          1756: 
        !          1757: insert into EMP_EQUIPMENT values (1171, 'NeXTstation Color 16/200', '550-87024', 190)
        !          1758: go
        !          1759: 
        !          1760: insert into EMP_EQUIPMENT values (1172, 'NeXTstation 16/200', '75-57330', 175)
        !          1761: go
        !          1762: 
        !          1763: insert into EMP_EQUIPMENT values (1173, 'NeXTstation 16/200', '709-24372', 217)
        !          1764: go
        !          1765: 
        !          1766: insert into EMP_EQUIPMENT values (1174, 'NeXTstation  Color Turbo 16/200', '388-38271', 173)
        !          1767: go
        !          1768: 
        !          1769: insert into EMP_EQUIPMENT values (1175, 'NeXTstation 8/105', '98-76041', 197)
        !          1770: go
        !          1771: 
        !          1772: insert into EMP_EQUIPMENT values (1176, 'NeXTstation  Color Turbo 8/105', '767-36932', 158)
        !          1773: go
        !          1774: 
        !          1775: insert into EMP_EQUIPMENT values (1177, 'NeXTstation 8/105', '595-13623', 139)
        !          1776: go
        !          1777: 
        !          1778: insert into EMP_EQUIPMENT values (1178, 'NeXTstation 8/105', '664-82207', 104)
        !          1779: go
        !          1780: 
        !          1781: insert into EMP_EQUIPMENT values (1179, 'NeXTDimension', '830-38108', 225)
        !          1782: go
        !          1783: 
        !          1784: insert into EMP_EQUIPMENT values (1180, 'NeXTstation Color 16/200', '281-5023', 141)
        !          1785: go
        !          1786: 
        !          1787: insert into EMP_EQUIPMENT values (1181, 'NeXTstation  Color Turbo 16/200', '388-51896', 208)
        !          1788: go
        !          1789: 
        !          1790: insert into EMP_EQUIPMENT values (1182, 'NeXTDimension', '813-75150', 109)
        !          1791: go
        !          1792: 
        !          1793: insert into EMP_EQUIPMENT values (1183, 'NeXTstation Color 8/105', '576-43283', 112)
        !          1794: go
        !          1795: 
        !          1796: insert into EMP_EQUIPMENT values (1184, 'NeXTstation 16/200', '563-21410', 146)
        !          1797: go
        !          1798: 
        !          1799: insert into EMP_EQUIPMENT values (1185, 'NeXTstation Color 8/105', '384-26683', 219)
        !          1800: go
        !          1801: 
        !          1802: insert into EMP_EQUIPMENT values (1186, 'NeXTDimension', '449-97816', 157)
        !          1803: go
        !          1804: 
        !          1805: insert into EMP_EQUIPMENT values (1187, 'NeXTstation 8/105', '853-64862', 206)
        !          1806: go
        !          1807: 
        !          1808: insert into EMP_EQUIPMENT values (1188, 'NeXTstation 8/105', '621-8809', 207)
        !          1809: go
        !          1810: 
        !          1811: insert into EMP_EQUIPMENT values (1189, 'NeXTstation 16/200', '162-25658', 111)
        !          1812: go
        !          1813: 
        !          1814: insert into EMP_EQUIPMENT values (1190, 'NeXTstation Color 8/105', '621-29151', 120)
        !          1815: go
        !          1816: 
        !          1817: insert into EMP_EQUIPMENT values (1191, 'NeXTstation  Color Turbo 16/400', '63-38117', 192)
        !          1818: go
        !          1819: 
        !          1820: insert into EMP_EQUIPMENT values (1192, 'NeXTstation  Color Turbo 16/200', '704-39748', 181)
        !          1821: go
        !          1822: 
        !          1823: insert into EMP_EQUIPMENT values (1193, 'NeXTstation 8/105', '785-84375', 201)
        !          1824: go
        !          1825: 
        !          1826: insert into EMP_EQUIPMENT values (1194, 'NeXTstation Color 16/400', '652-37816', 213)
        !          1827: go
        !          1828: 
        !          1829: insert into EMP_EQUIPMENT values (1195, 'NeXTstation Color 16/200', '886-84102', 172)
        !          1830: go
        !          1831: 
        !          1832: insert into EMP_EQUIPMENT values (1196, 'NeXTstation  Color Turbo 16/200', '831-87177', 108)
        !          1833: go
        !          1834: 
        !          1835: insert into EMP_EQUIPMENT values (1197, 'NeXTstation  Color Turbo 16/200', '739-26210', 177)
        !          1836: go
        !          1837: 
        !          1838: insert into EMP_EQUIPMENT values (1198, 'NeXTstation 16/200', '396-71735', 125)
        !          1839: go
        !          1840: 
        !          1841: insert into EMP_EQUIPMENT values (1199, 'NeXTstation 16/400', '34-79809', 126)
        !          1842: go
        !          1843: 
        !          1844: insert into EMP_EQUIPMENT values (1200, 'NeXTstation Color 8/105', '334-59161', 185)
        !          1845: go
        !          1846: 
        !          1847: insert into EMP_EQUIPMENT values (1201, 'NeXTDimension', '524-41124', 212)
        !          1848: go
        !          1849: 
        !          1850: insert into EMP_EQUIPMENT values (1202, 'NeXTstation Color 8/105', '836-89146', 110)
        !          1851: go
        !          1852: 
        !          1853: insert into EMP_EQUIPMENT values (1203, 'NeXTstation Color 16/400', '608-57474', 223)
        !          1854: go
        !          1855: 
        !          1856: insert into EMP_EQUIPMENT values (1204, 'NeXTstation  Color Turbo 16/200', '722-85049', 202)
        !          1857: go
        !          1858: 
        !          1859: insert into EMP_EQUIPMENT values (1205, 'NeXTstation  Color Turbo 16/400', '532-78167', 189)
        !          1860: go
        !          1861: 
        !          1862: insert into EMP_EQUIPMENT values (1206, 'NeXTstation Turbo 16/400', '16-926', 196)
        !          1863: go
        !          1864: 
        !          1865: insert into EMP_EQUIPMENT values (1207, 'NeXTstation Turbo 16/400', '518-18514', 133)
        !          1866: go
        !          1867: 
        !          1868: insert into EMP_EQUIPMENT values (1208, 'NeXTDimension', '384-72591', 167)
        !          1869: go
        !          1870: 
        !          1871: insert into EMP_EQUIPMENT values (1209, 'NeXTDimension', '334-21983', 203)
        !          1872: go
        !          1873: 
        !          1874: insert into EMP_EQUIPMENT values (1210, 'NeXTstation  Color Turbo 16/200', '391-49812', 194)
        !          1875: go
        !          1876: 
        !          1877: insert into EMP_EQUIPMENT values (1211, 'NeXTstation Turbo 16/400', '6-87480', 121)
        !          1878: go
        !          1879: 
        !          1880: insert into EMP_EQUIPMENT values (1212, 'NeXTstation  Color Turbo 16/200', '197-13972', 130)
        !          1881: go
        !          1882: 
        !          1883: insert into EMP_EQUIPMENT values (1213, 'NeXTstation Color 16/400', '33-39584', 200)
        !          1884: go
        !          1885: 
        !          1886: insert into EMP_EQUIPMENT values (1214, 'NeXTstation Color 16/200', '992-3848', 195)
        !          1887: go
        !          1888: 
        !          1889: insert into EMP_EQUIPMENT values (1215, 'NeXTstation  Color Turbo 8/105', '277-10448', 101)
        !          1890: go
        !          1891: 
        !          1892: insert into EMP_EQUIPMENT values (1216, 'NeXTstation  Color Turbo 16/400', '975-77088', 191)
        !          1893: go
        !          1894: 
        !          1895: insert into EMP_EQUIPMENT values (1217, 'NeXTstation Turbo 16/400', '294-32339', 220)
        !          1896: go
        !          1897: 
        !          1898: insert into EMP_EQUIPMENT values (1218, 'NeXTDimension', '618-27833', 182)
        !          1899: go
        !          1900: 
        !          1901: insert into EMP_EQUIPMENT values (1219, 'NeXTstation 16/400', '103-83650', 123)
        !          1902: go
        !          1903: 
        !          1904: insert into EMP_EQUIPMENT values (1220, 'NeXTstation  Color Turbo 16/200', '756-14950', 170)
        !          1905: go
        !          1906: 
        !          1907: insert into EMP_EQUIPMENT values (1221, 'NeXTstation 16/400', '436-91312', 216)
        !          1908: go
        !          1909: 
        !          1910: insert into EMP_EQUIPMENT values (1222, 'NeXTstation  Color Turbo 16/200', '489-13117', 159)
        !          1911: go
        !          1912: 
        !          1913: insert into EMP_EQUIPMENT values (1223, 'NeXTstation  Color Turbo 8/105', '579-12221', 168)
        !          1914: go
        !          1915: 
        !          1916: insert into EMP_EQUIPMENT values (1224, 'NeXTstation 16/400', '551-13204', 116)
        !          1917: go
        !          1918: 
        !          1919: insert into EMP_QUOTE(EMP_ID) select EMP_ID from EMPLOYEE
        !          1920: go
        !          1921: 
        !          1922: commit transaction
        !          1923: go
        !          1924: 
        !          1925: 
        !          1926: /******************************************************************************
        !          1927: *  Create table indexes.
        !          1928: ******************************************************************************/
        !          1929: create unique INDEX EMP_INDEX1 on EMPLOYEE(EMP_ID)
        !          1930: go
        !          1931: 
        !          1932: create unique INDEX DEPT_INDEX1 on DEPARTMENT(DEPT_ID)
        !          1933: go
        !          1934: 
        !          1935: create unique INDEX FACILITY_INDEX1 on FACILITY(LOCATION_ID)
        !          1936: go
        !          1937: 
        !          1938: create unique INDEX EMPPROJ_INDEX1 on EMP_PROJECT(EMP_ID,PROJECT_ID)
        !          1939: go
        !          1940: 
        !          1941: create unique INDEX PROJ_INDEX1 on PROJECT(PROJECT_ID)
        !          1942: go
        !          1943: 
        !          1944: create unique INDEX EMP_PHOTO_INDEX1 on EMP_PHOTO(EMP_ID)
        !          1945: go
        !          1946: 
        !          1947: create unique INDEX EMP_QUOTE_INDEX1 on EMP_QUOTE(EMP_ID)
        !          1948: go
        !          1949: 
        !          1950: create unique INDEX JOB_TITLE_INDEX1 on JOB_TITLE(TITLE_ID)
        !          1951: go
        !          1952: 
        !          1953: create unique INDEX ASSET_INDEX1 on EMP_EQUIPMENT(ASSET_TAG)
        !          1954: go
        !          1955: 
        !          1956: 
        !          1957: /******************************************************************************
        !          1958: * Create the UNIQUE_KEY table, which stores the MAX_KEY for each ENTITY_NAME.
        !          1959: ******************************************************************************/
        !          1960: create table UNIQUE_KEY (
        !          1961: ENTITY_NAME varchar(100),
        !          1962: MAX_KEY int
        !          1963: )
        !          1964: go
        !          1965: 
        !          1966: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMPLOYEE',max(EMP_ID) from EMPLOYEE
        !          1967: go
        !          1968: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'DEPARTMENT',max(DEPT_ID) from DEPARTMENT
        !          1969: go
        !          1970: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'FACILITY',max(LOCATION_ID) from FACILITY
        !          1971: go
        !          1972: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'PROJECT',max(PROJECT_ID) from PROJECT
        !          1973: go
        !          1974: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'JOB_TITLE',max(TITLE_ID) from JOB_TITLE
        !          1975: go
        !          1976: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMP_EQUIPMENT',max(ASSET_TAG) from EMP_EQUIPMENT
        !          1977: go
        !          1978: 
        !          1979: create unique INDEX UNIQUE_KEY_INDEX1 on UNIQUE_KEY(ENTITY_NAME)
        !          1980: go

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.