![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to DEMO CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [CSRG BSD Unix] / 42BSD / ingres / demo|
Return to DEMO CVS log | Up to [CSRG BSD Unix] / 42BSD / ingres / demo |
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 A Junior's : Men's � < Sportswear &
12: c Giftwrap & b & Bargain Linens � ? Women's & 1 Toys # F Women's &
13: I Children's &
14: " Stationary & ! / Junior Miss � Women's employee �
�p�� �� Jones, Tim �.� ��VSmith, Paul p! ��# Evans, Michael � ��� Thomas, Tom '� ��
Edwards, Peter (#� ��� Collins, Joanne X
15: ��7 James, Mary �.� �� Thompson, Bob �2� ��b Williams, 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: ���� X Earrings � � v Towels, Bath � �� + Maze 1 E&� Y j Clock Book 1 � � } 1 lb Box
19: � d * 4 Jacket < � ,& � Jean A 9�&! &Shirt : ��! x Twin Sheet �� -&Boy's Jean Suit + ��&! y Queen Sheet _X� e Slacks ? @E& s Gold Ring �
20: � 2 lb Box, Mix
21: �&K * w Squeeze Ball 1 � �&Y Wash Cloth & K ?� Bellbottoms + �&X! ABC Blocks & � �&} k The 'Feel' Book # � � Y y Ski Jumpsuit A �} parts ~
22: �� �&& central processor pink
23: & memory gray disk drive black � tape drive black �& tapes gray & � line printer yellow B l-p paper white _ terminals blue
paper tape reader black k paper 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-15 v � 0000000010058175-01-15 x & � 0000000010058275-01-15 & V2435654010058675-01-16 + # 5409683110058675-01-16 1 j # 5409683110059275-01-17 : && � 0000000010059375-01-18
174:
1165213310059475-01-18 < 4 & � 12591815store ~
175: �� E San Francisco Calif Oakland Calif El Cerrito Calif 2supplier ~
176: Z���
177: &� Koret Los Angeles Calif � Cannon Atlanta Ga ! Levi-Strauss San Francisco Calif Y Fisher-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-010 z �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�
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.