src/interfaces/jdbc/example/corba/stock.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

--
-- This creates the database for the stock example
-- $Id: stock.sql,v 1.1 1999/01/25 21:22:04 scrappy Exp $
--
drop table stock;

create table stock (
	id int4,
	avail int4,
	ordered int4,
	valid bool,
	description text
);

create index stock_id on stock(id);

copy stock from stdin;
1	19	0	t	Dell Latitude XPi P133 Laptop
2	3	2	t	Iomega Zip Plus drive
3	2	0	f	Iomega Ext/Par drive
4	0	4	t	Iomega Ext USB drive
5	200	0	t	Blank Unbranded CDR media
6	20	30	t	Iomega Zip media 100Mb
\.

grant all on stock to public;
grant all on stock_id to public;