-- PostgreSQL
--
-- RCS Revision
--   $Id: attachments.pgsql,v 1.1 1999/07/13 20:41:38 roberts Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'attachments'
--
CREATE SEQUENCE attachments_seq START 1;

CREATE TABLE attachments (
  _rowid int DEFAULT nextval('attachments_seq') PRIMARY KEY,
  at_sid int DEFAULT '0' NOT NULL,
  at_fname varchar(45) DEFAULT '' NOT NULL,
  at_tech varchar(10),
  at_date int,
  at_comment varchar(100)
);

CREATE INDEX attachments_at_sid_idx ON attachments(at_sid);

CREATE INDEX attachments_at_fname_idx ON attachments(at_fname);
