Return to qry CVS log

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

Annotation of 43BSD/ingres/demo/qry, revision 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.