-- PostgreSQL
--
-- RCS Revision
--   $Id: addresses.pgsql,v 1.1 1999/01/12 03:23:00 roberts Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'addresses'
--
CREATE TABLE addresses (
  tag varchar(10) NOT NULL,
  label varchar(10), 
  main varchar(1),
  address1 varchar(40),
  address2 varchar(40),
  city varchar(20),
  state varchar(30),
  pcode varchar(15)
);

CREATE INDEX addresses_tag_idx ON addresses (tag); 

--
-- Dumping data for table 'contacts'
--
