-- Oracle Table Definition
--
-- RCS Revision
--   $Id: addresses.oracle,v 1.1 1999/02/02 17:07:57 roberts Exp $
--
CREATE TABLE addresses (
    tag varchar2(10) NOT NULL,
    label varchar2(10), 
    main varchar2(1),
    address1 varchar2(40),
    address2 varchar2(40),
    city varchar2(20),
    state varchar2(30),
    pcode varchar2(15)
);

CREATE INDEX addresses_tag_idx ON addresses (tag); 
