[BACK]Return to DEMO CVS log [TXT] [DIR] Up to [CSRG BSD Unix] / 42BSD / ingres / demo

Annotation of 42BSD/ingres/demo/DEMO, revision 1.1

1.1     ! root        1: e�demodb�
�
        !             2: ��if x$1 = x goto error
        !             3: if ! { creatdb $1 } exit
        !             4: ingres -s $1 < /mnt/ingres/demo/qry
        !             5: echo   database $1 created
        !             6: exit
        !             7: : error
        !             8: echo no database name
        !             9: dept~
        !            10: ����#Book                &7
        !            11: Candy               &
Furniture           Major Appliances    Jewelry             &!+Children's           AJunior's            :Men's               �<Sportswear          &
        !            12: cGiftwrap            &b&Bargain             Linens              �?Women's             &1Toys                #FWomen's             &
        !            13: IChildren's          &
        !            14: "Stationary          &!/Junior Miss         �Women's              employee�
�p����Jones, Tim          �.���VSmith, Paul         p!��#Evans, Michael      � ���Thomas, Tom         '���
Edwards, Peter      (#����Collins, Joanne     X
        !            15: ��7James, Mary         �.���Thompson, Bob       �2���bWilliams, Judy      (#��� Smythe, Carol       Z#���!Hayes, Evelyn       t'����Bullock, J.D.       xi��%Bailey, Chas M.     �  ��KSchmidt, Herman     �+��^ Wallace, Maggie J.  ���gChoy, Wanda         �+7���Ferro, Tony         557��%Raveen, Lemont      �.��cWilliams, Bruce     >4!���Zugnoni, Arthur A.  �M����&Brunet, Paul C.     
        !            16: E����Iwano, Masahiro     =���2Onstad, Richard     K"
��
        !            17: Ross, Stanley       $>���Ross, Stuart        #/��item~
        !            18: ����XEarrings            ��vTowels, Bath        ���+Maze                1E&�YjClock Book          1��}1 lb Box            
        !            19: �d*4Jacket              <�,&�Jean                A9�&!&Shirt               :��!xTwin Sheet           ��-&Boy's Jean Suit     +��&!yQueen Sheet         _X�eSlacks              ?@E&sGold Ring           �
        !            20: �2 lb Box, Mix       
        !            21: �&K*wSqueeze Ball        1��&YWash Cloth          &K?�Bellbottoms         +�&X!ABC Blocks          &��&}kThe 'Feel' Book     #��YySki Jumpsuit        A�}parts~
        !            22: •���&&central processor   pink    
        !            23: &memory              gray     disk drive          black   �tape drive          black   �&tapes               gray    &�line printer        yellow  Bl-p paper           white   _terminals           blue    
paper tape reader   black   kpaper tape punch    black   �  terminal paper      white   ^&
        !            24: byte-soap           clear   �card reader         gray    G&card punch          gray    �&qry(���Ccreate item (
        !            25:        number is i2,
        !            26:        name is c20,
        !            27:        dept is i2,
        !            28:        price is i2,
        !            29:        qoh is i2,
        !            30:        supplier is i2)
        !            31: 
        !            32: create sale (
        !            33:        number is c6,
        !            34:        date is c8,
        !            35:        store is i2,
        !            36:        dept is i2,
        !            37:        item is i2,
        !            38:        quantity is i2,
        !            39:        employee is i2,
        !            40:        credit is c8)
        !            41: 
        !            42: create employee (
        !            43:        number is i2,
        !            44:        name is c20,
        !            45:        salary is i2,
        !            46:        manager is i2,
        !            47:        birthdate is i2,
        !            48:        startdate is i2)
        !            49: 
        !            50: create dept (
        !            51:        number is i2,
        !            52:        name is c20,
        !            53:        store is i2,
        !            54:        floor is i2,
        !            55:        manager is i2)
        !            56: 
        !            57: create supplier (
        !            58:        number is i2,
        !            59:        name is c15,
        !            60:        city is c15,
        !            61:        state is c6)
        !            62: 
        !            63: create store (
        !            64:        number is i2,
        !            65:        city is c15,
        !            66:        state is c6)
        !            67: 
        !            68: create parts (
        !            69:        pnum is i2,
        !            70:        pname is c20,
        !            71:        color is c8,
        !            72:        weight is i2,
        !            73:        qoh is i2)
        !            74: 
        !            75: create supply (
        !            76:        snum is i2,
        !            77:        pnum is i2,
        !            78:        jnum is i2,
        !            79:        shipdate is c8,
        !            80:        quan is i2)
        !            81: 
        !            82: 
        !            83: copy item (number is i2,
        !            84:        name is c20,
        !            85:        dept is i2,
        !            86:        price is i2,
        !            87:        qoh is i2,
        !            88:        supplier is i2)
        !            89: from "{pathname}/demo/item"
        !            90: 
        !            91: copy sale (
        !            92:        number is c6,
        !            93:        date is c8,
        !            94:        store is i2,
        !            95:        dept is i2,
        !            96:        item is i2,
        !            97:        quantity is i2,
        !            98:        employee is i2,
        !            99:        credit is c8)
        !           100: from "{pathname}/demo/sale"
        !           101: 
        !           102: copy employee (
        !           103:        number is i2,
        !           104:        name is c20,
        !           105:        salary is i2,
        !           106:        manager is i2,
        !           107:        birthdate is i2,
        !           108:        startdate is i2)
        !           109: from "{pathname}/demo/employee"
        !           110: 
        !           111: copy dept (
        !           112:        number is i2,
        !           113:        name is c20,
        !           114:        store is i2,
        !           115:        floor is i2,
        !           116:        manager is i2)
        !           117: from "{pathname}/demo/dept"
        !           118: 
        !           119: copy supplier (
        !           120:        number is i2,
        !           121:        name is c15,
        !           122:        city is c15,
        !           123:        state is c6)
        !           124: from "{pathname}/demo/supplier"
        !           125: 
        !           126: copy store (
        !           127:        number is i2,
        !           128:        city is c15,
        !           129:        state is c6)
        !           130: from "{pathname}/demo/store"
        !           131: 
        !           132: copy parts (
        !           133:        pnum is i2,
        !           134:        pname is c20,
        !           135:        color is c8,
        !           136:        weight is i2,
        !           137:        qoh is i2)
        !           138: from "{pathname}/demo/parts"
        !           139: 
        !           140: copy supply (
        !           141:        snum is i2,
        !           142:        pnum is i2,
        !           143:        jnum is i2,
        !           144:        shipdate is c8,
        !           145:        quan is i2)
        !           146: from "{pathname}/demo/supply"
        !           147: 
        !           148: range of i is item
        !           149: define permit all on i to all
        !           150: 
        !           151: range of s is sale
        !           152: define permit all on s to all
        !           153: 
        !           154: range of e is employee
        !           155: define permit all on e to all
        !           156: 
        !           157: range of d is dept
        !           158: define permit all on d to all
        !           159: 
        !           160: range of s is supplier
        !           161: define permit all on s to all
        !           162: 
        !           163: range of s is store
        !           164: define permit all on s to all
        !           165: 
        !           166: range of p is parts
        !           167: define permit all on p to all
        !           168: 
        !           169: range of s is supply
        !           170: define permit all on s to all
        !           171: \g
        !           172: nsale~
        !           173: C���&10058175-01-15v�0000000010058175-01-15x&�0000000010058275-01-15&V2435654010058675-01-16+#5409683110058675-01-161j#5409683110059275-01-17:&&�0000000010059375-01-18
        !           174: 
1165213310059475-01-18<4&�12591815store~
        !           175: Ε��ESan Francisco  Calif Oakland        Calif El Cerrito     Calif 2supplier~
        !           176: Z���
        !           177: &�Koret          Los Angeles    Calif �Cannon         Atlanta        Ga    !Levi-Strauss   San Francisco  Calif YFisher-Price   Boston         Mass  }Playskool      Dallas         Tex   *Whitman's      Denver         Colo  White Stag     White Plains   Neb   supply�
�p��p&�&&�73-12-31&�&�74-05-31 �&�73-12-31�&�74-05-31&z�75-02-01�z�75-02-010z        �75-02-01��&�74-10-10��73-12-31&>�74-06-18�&�73-12-31 �&&�74-07-01&�74-11-15�75-01-22�75-01-10�75-01-10K�&�75-06-01&��75-06-01 ��75-06-01&C�75-07-01&�
        !           178: �76-01-01���75-07-01&�        �75-07-01�
unix.superglobalmegacorp.com

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