~ubuntu-branches/ubuntu/hardy/libpgjava/hardy

« back to all changes in this revision

Viewing changes to src/interfaces/jdbc/example/corba/stock.sql

Committer: Bazaar Package Importer
Author(s): Stefan Gybas
Date: 2002-02-06 23:43:06 UTC
Revision ID: james.westby@ubuntu.com-20020206234306-hsg7suqr8q56qg40

Tags: upstream-7.2

Import upstream version 7.2

files added:

src/interfaces

src/interfaces/jdbc

src/interfaces/jdbc/CHANGELOG

src/interfaces/jdbc/Implementation

src/interfaces/jdbc/Makefile

src/interfaces/jdbc/README

src/interfaces/jdbc/build.xml

src/interfaces/jdbc/example

src/interfaces/jdbc/example/ImageViewer.java

src/interfaces/jdbc/example/Unicode.java

src/interfaces/jdbc/example/basic.java

src/interfaces/jdbc/example/blobtest.java

src/interfaces/jdbc/example/corba

src/interfaces/jdbc/example/corba/StockClient.java

src/interfaces/jdbc/example/corba/StockDB.java

src/interfaces/jdbc/example/corba/StockDispenserImpl.java

src/interfaces/jdbc/example/corba/StockItemImpl.java

src/interfaces/jdbc/example/corba/StockServer.java

src/interfaces/jdbc/example/corba/readme

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

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

src/interfaces/jdbc/example/datestyle.java

src/interfaces/jdbc/example/metadata.java

src/interfaces/jdbc/example/psql.java

src/interfaces/jdbc/example/threadsafe.java

src/interfaces/jdbc/jdbc.jpx

src/interfaces/jdbc/org

src/interfaces/jdbc/org/postgresql

src/interfaces/jdbc/org/postgresql/Connection.java

src/interfaces/jdbc/org/postgresql/Driver.java.in

src/interfaces/jdbc/org/postgresql/Field.java

src/interfaces/jdbc/org/postgresql/PG_Stream.java

src/interfaces/jdbc/org/postgresql/PostgresqlDataSource.java

src/interfaces/jdbc/org/postgresql/ResultSet.java

src/interfaces/jdbc/org/postgresql/Statement.java

src/interfaces/jdbc/org/postgresql/core

src/interfaces/jdbc/org/postgresql/core/BytePoolDim1.java

src/interfaces/jdbc/org/postgresql/core/BytePoolDim2.java

src/interfaces/jdbc/org/postgresql/core/Encoding.java

src/interfaces/jdbc/org/postgresql/core/MemoryPool.java

src/interfaces/jdbc/org/postgresql/core/ObjectPool.java

src/interfaces/jdbc/org/postgresql/core/QueryExecutor.java

src/interfaces/jdbc/org/postgresql/core/SimpleObjectPool.java

src/interfaces/jdbc/org/postgresql/errors.properties

src/interfaces/jdbc/org/postgresql/errors_de.properties

src/interfaces/jdbc/org/postgresql/errors_fr.properties

src/interfaces/jdbc/org/postgresql/errors_it.properties

src/interfaces/jdbc/org/postgresql/errors_nl.properties

src/interfaces/jdbc/org/postgresql/errors_zh_TW.properties

src/interfaces/jdbc/org/postgresql/fastpath

src/interfaces/jdbc/org/postgresql/fastpath/Fastpath.java

src/interfaces/jdbc/org/postgresql/fastpath/FastpathArg.java

src/interfaces/jdbc/org/postgresql/geometric

src/interfaces/jdbc/org/postgresql/geometric/PGbox.java

src/interfaces/jdbc/org/postgresql/geometric/PGcircle.java

src/interfaces/jdbc/org/postgresql/geometric/PGline.java

src/interfaces/jdbc/org/postgresql/geometric/PGlseg.java

src/interfaces/jdbc/org/postgresql/geometric/PGpath.java

src/interfaces/jdbc/org/postgresql/geometric/PGpoint.java

src/interfaces/jdbc/org/postgresql/geometric/PGpolygon.java

src/interfaces/jdbc/org/postgresql/jdbc1

src/interfaces/jdbc/org/postgresql/jdbc1/CallableStatement.java

src/interfaces/jdbc/org/postgresql/jdbc1/Connection.java

src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java

src/interfaces/jdbc/org/postgresql/jdbc1/PreparedStatement.java

src/interfaces/jdbc/org/postgresql/jdbc1/ResultSet.java

src/interfaces/jdbc/org/postgresql/jdbc1/ResultSetMetaData.java

src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java

src/interfaces/jdbc/org/postgresql/jdbc2

src/interfaces/jdbc/org/postgresql/jdbc2/Array.java

src/interfaces/jdbc/org/postgresql/jdbc2/CallableStatement.java

src/interfaces/jdbc/org/postgresql/jdbc2/Connection.java

src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java

src/interfaces/jdbc/org/postgresql/jdbc2/PBatchUpdateException.java

src/interfaces/jdbc/org/postgresql/jdbc2/PreparedStatement.java

src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java

src/interfaces/jdbc/org/postgresql/jdbc2/ResultSetMetaData.java

src/interfaces/jdbc/org/postgresql/jdbc2/Statement.java

src/interfaces/jdbc/org/postgresql/jdbc2/UpdateableResultSet.java

src/interfaces/jdbc/org/postgresql/largeobject

src/interfaces/jdbc/org/postgresql/largeobject/BlobInputStream.java

src/interfaces/jdbc/org/postgresql/largeobject/BlobOutputStream.java

src/interfaces/jdbc/org/postgresql/largeobject/LargeObject.java

src/interfaces/jdbc/org/postgresql/largeobject/LargeObjectManager.java

src/interfaces/jdbc/org/postgresql/largeobject/PGblob.java

src/interfaces/jdbc/org/postgresql/largeobject/PGclob.java

src/interfaces/jdbc/org/postgresql/test

src/interfaces/jdbc/org/postgresql/test/JDBC2Tests.java

src/interfaces/jdbc/org/postgresql/test/README

src/interfaces/jdbc/org/postgresql/test/jdbc2

src/interfaces/jdbc/org/postgresql/test/jdbc2/ANTTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/BatchExecuteTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/BlobTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/ConnectionTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/DateTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/DriverTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/EncodingTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/JBuilderTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/MiscTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/TimeTest.java

src/interfaces/jdbc/org/postgresql/test/jdbc2/TimestampTest.java

src/interfaces/jdbc/org/postgresql/util

src/interfaces/jdbc/org/postgresql/util/MD5Digest.java

src/interfaces/jdbc/org/postgresql/util/MessageTranslator.java

src/interfaces/jdbc/org/postgresql/util/PGbytea.java

src/interfaces/jdbc/org/postgresql/util/PGmoney.java

src/interfaces/jdbc/org/postgresql/util/PGobject.java

src/interfaces/jdbc/org/postgresql/util/PGtokenizer.java

src/interfaces/jdbc/org/postgresql/util/PSQLException.java

src/interfaces/jdbc/org/postgresql/util/Serialize.java

src/interfaces/jdbc/org/postgresql/util/UnixCrypt.java

src/interfaces/jdbc/org/postgresql/xa

src/interfaces/jdbc/org/postgresql/xa/ClientConnection.java

src/interfaces/jdbc/org/postgresql/xa/TwoPhaseConnection.java

src/interfaces/jdbc/org/postgresql/xa/TxConnection.java

src/interfaces/jdbc/org/postgresql/xa/XAConnectionImpl.java

src/interfaces/jdbc/org/postgresql/xa/XADataSourceImpl.java

src/interfaces/jdbc/utils

src/interfaces/jdbc/utils/CheckVersion.java

src/interfaces/jdbc/utils/buildDriver

src/interfaces/jdbc/utils/changelog.pl

Show diffs side-by-side

added added

removed removed

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

-- 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;

Older »