[BACK]Return to DEMO CVS log [TXT] [DIR] Up to [CSRG BSD Unix] / 42BSD / ingres / demo
File:  [CSRG BSD Unix] / 42BSD / ingres / demo / DEMO
Revision 1.1.1.1 (vendor branch): download - view: text, annotated - select for diffs
Tue Apr 24 16:12:53 2018 UTC (8 years, 1 month ago) by root
Branches: MAIN, BSD
CVS tags: HEAD, BSD42
BSD 4.2

e�demodb�
�
��if x$1 = x goto error
if ! { creatdb $1 } exit
ingres -s $1 < /mnt/ingres/demo/qry
echo	database $1 created
exit
: error
echo no database name
dept~
����#Book                7
Candy               
Furniture           Major Appliances    Jewelry             !+Children's           AJunior's            :Men's               �<Sportswear          
cGiftwrap            bBargain             Linens              �?Women's             &1Toys                #FWomen's             
IChildren's          
"Stationary          !/Junior Miss         �Women's              employee�
�p����Jones, Tim          �.���VSmith, Paul         p!��#Evans, Michael      � ���Thomas, Tom         '���
Edwards, Peter      (#����Collins, Joanne     X
��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.     
E����Iwano, Masahiro     =���2Onstad, Richard     K"
��
Ross, Stanley       $>���Ross, Stuart        #/��item~
����XEarrings            ��vTowels, Bath        ���+Maze                1E�YjClock Book          1��}1 lb Box            
�d*4Jacket              <�,�Jean                A9�!Shirt               :��!xTwin Sheet           ��-Boy's Jean Suit     +��!yQueen Sheet         _X�eSlacks              ?@EsGold Ring           �
�2 lb Box, Mix       
�K*wSqueeze Ball        1��YWash Cloth          K?�Bellbottoms         +�X!ABC Blocks          ��}kThe 'Feel' Book     #��YySki Jumpsuit        A�}parts~
•���central processor   pink    
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   ^
byte-soap           clear   �card reader         gray    Gcard punch          gray    �qry(���Ccreate item (
	number is i2,
	name is c20,
	dept is i2,
	price is i2,
	qoh is i2,
	supplier is i2)

create sale (
	number is c6,
	date is c8,
	store is i2,
	dept is i2,
	item is i2,
	quantity is i2,
	employee is i2,
	credit is c8)

create employee (
	number is i2,
	name is c20,
	salary is i2,
	manager is i2,
	birthdate is i2,
	startdate is i2)

create dept (
	number is i2,
	name is c20,
	store is i2,
	floor is i2,
	manager is i2)

create supplier (
	number is i2,
	name is c15,
	city is c15,
	state is c6)

create store (
	number is i2,
	city is c15,
	state is c6)

create parts (
	pnum is i2,
	pname is c20,
	color is c8,
	weight is i2,
	qoh is i2)

create supply (
	snum is i2,
	pnum is i2,
	jnum is i2,
	shipdate is c8,
	quan is i2)


copy item (number is i2,
	name is c20,
	dept is i2,
	price is i2,
	qoh is i2,
	supplier is i2)
from "{pathname}/demo/item"

copy sale (
	number is c6,
	date is c8,
	store is i2,
	dept is i2,
	item is i2,
	quantity is i2,
	employee is i2,
	credit is c8)
from "{pathname}/demo/sale"

copy employee (
	number is i2,
	name is c20,
	salary is i2,
	manager is i2,
	birthdate is i2,
	startdate is i2)
from "{pathname}/demo/employee"

copy dept (
	number is i2,
	name is c20,
	store is i2,
	floor is i2,
	manager is i2)
from "{pathname}/demo/dept"

copy supplier (
	number is i2,
	name is c15,
	city is c15,
	state is c6)
from "{pathname}/demo/supplier"

copy store (
	number is i2,
	city is c15,
	state is c6)
from "{pathname}/demo/store"

copy parts (
	pnum is i2,
	pname is c20,
	color is c8,
	weight is i2,
	qoh is i2)
from "{pathname}/demo/parts"

copy supply (
	snum is i2,
	pnum is i2,
	jnum is i2,
	shipdate is c8,
	quan is i2)
from "{pathname}/demo/supply"

range of i is item
define permit all on i to all

range of s is sale
define permit all on s to all

range of e is employee
define permit all on e to all

range of d is dept
define permit all on d to all

range of s is supplier
define permit all on s to all

range of s is store
define permit all on s to all

range of p is parts
define permit all on p to all

range of s is supply
define permit all on s to all
\g
nsale~
C���10058175-01-15v�0000000010058175-01-15x�0000000010058275-01-15V2435654010058675-01-16+#5409683110058675-01-161j#5409683110059275-01-17:�0000000010059375-01-18

1165213310059475-01-18<4�12591815store~
��ESan Francisco  Calif Oakland        Calif El Cerrito     Calif 2supplier~
Z���
�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-31z�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-01C�75-07-01�
�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.