File: stock.sql

package info (click to toggle)
libpgjava 8.1-405-1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 3,484 kB
  • ctags: 4,266
  • sloc: java: 32,071; xml: 3,017; sql: 21; makefile: 18; sh: 10
file content (27 lines) | stat: -rw-r--r-- 578 bytes parent folder | download 
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
-- $PostgreSQL: pgjdbc/example/corba/stock.sql,v 1.2 2003/11/29 22:41:21 pgsql 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;