Return to qry CVS log

Up to [CSRG BSD Unix] / 43BSD / ingres / demo

Annotation of 43BSD/ingres/demo/qry, revision 1.1.1.1

1.1       root        1: create item (
                      2:        number is i2,
                      3:        name is c20,
                      4:        dept is i2,
                      5:        price is i2,
                      6:        qoh is i2,
                      7:        supplier is i2)
                      8: 
                      9: create sale (
                     10:        number is c6,
                     11:        date is c8,
                     12:        store is i2,
                     13:        dept is i2,
                     14:        item is i2,
                     15:        quantity is i2,
                     16:        employee is i2,
                     17:        credit is c8)
                     18: 
                     19: create employee (
                     20:        number is i2,
                     21:        name is c20,
                     22:        salary is i2,
                     23:        manager is i2,
                     24:        birthdate is i2,
                     25:        startdate is i2)
                     26: 
                     27: create dept (
                     28:        number is i2,
                     29:        name is c20,
                     30:        store is i2,
                     31:        floor is i2,
                     32:        manager is i2)
                     33: 
                     34: create supplier (
                     35:        number is i2,
                     36:        name is c15,
                     37:        city is c15,
                     38:        state is c6)
                     39: 
                     40: create store (
                     41:        number is i2,
                     42:        city is c15,
                     43:        state is c6)
                     44: 
                     45: create parts (
                     46:        pnum is i2,
                     47:        pname is c20,
                     48:        color is c8,
                     49:        weight is i2,
                     50:        qoh is i2)
                     51: 
                     52: create supply (
                     53:        snum is i2,
                     54:        pnum is i2,
                     55:        jnum is i2,
                     56:        shipdate is c8,
                     57:        quan is i2)
                     58: 
                     59: 
                     60: copy item (number is c6,
                     61:        name is c20,
                     62:        dept is c6,
                     63:        price is c6,
                     64:        qoh is c6,
                     65:        supplier is c6)
                     66: from "{pathname}/demo/item"
                     67: 
                     68: copy sale (
                     69:        number is c6,
                     70:        date is c8,
                     71:        store is c6,
                     72:        dept is c6,
                     73:        item is c6,
                     74:        quantity is c6,
                     75:        employee is c6,
                     76:        credit is c8)
                     77: from "{pathname}/demo/sale"
                     78: 
                     79: copy employee (
                     80:        number is c6,
                     81:        name is c20,
                     82:        salary is c6,
                     83:        manager is c6,
                     84:        birthdate is c6,
                     85:        startdate is c6)
                     86: from "{pathname}/demo/employee"
                     87: 
                     88: copy dept (
                     89:        number is c6,
                     90:        name is c20,
                     91:        store is c6,
                     92:        floor is c6,
                     93:        manager is c6)
                     94: from "{pathname}/demo/dept"
                     95: 
                     96: copy supplier (
                     97:        number is c6,
                     98:        name is c15,
                     99:        city is c15,
                    100:        state is c6)
                    101: from "{pathname}/demo/supplier"
                    102: 
                    103: copy store (
                    104:        number is c6,
                    105:        city is c15,
                    106:        state is c6)
                    107: from "{pathname}/demo/store"
                    108: 
                    109: copy parts (
                    110:        pnum is c6,
                    111:        pname is c20,
                    112:        color is c8,
                    113:        weight is c6,
                    114:        qoh is c6)
                    115: from "{pathname}/demo/parts"
                    116: 
                    117: copy supply (
                    118:        snum is c6,
                    119:        pnum is c6,
                    120:        jnum is c6,
                    121:        shipdate is c8,
                    122:        quan is c6)
                    123: from "{pathname}/demo/supply"
                    124: 
                    125: range of i is item
                    126: define permit all on i to all
                    127: 
                    128: range of s is sale
                    129: define permit all on s to all
                    130: 
                    131: range of e is employee
                    132: define permit all on e to all
                    133: 
                    134: range of d is dept
                    135: define permit all on d to all
                    136: 
                    137: range of s is supplier
                    138: define permit all on s to all
                    139: 
                    140: range of s is store
                    141: define permit all on s to all
                    142: 
                    143: range of p is parts
                    144: define permit all on p to all
                    145: 
                    146: range of s is supply
                    147: define permit all on s to all
                    148: \g

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