-- PostgreSQL
--
-- RCS Revision
--   $Id: resources.pgsql,v 1.4 1999/12/06 19:43:04 roberts Exp $
--
-- Host: localhost    Database: keystone
----------------------------------------------------------

--
-- Table structure for table 'resources'
--
CREATE TABLE resources (
	r_tag		varchar(10) PRIMARY KEY,
	r_ptag		varchar(10) NOT NULL,
	r_multi		int,
	r_serno		varchar(25) NOT NULL,
	r_mctag		varchar(20) NOT NULL,
	r_mcphone	varchar(10),
	r_mcadd		varchar(10),
	r_model		varchar(20),
	r_class		varchar(2),
	r_loc		varchar(10),
	r_qoh    	int,
	r_desc		varchar(80),
	r_status 	varchar(1),
	r_currtech	varchar(10),
	r_ctag		varchar(20) NOT NULL,
	r_cphone	varchar(10),
	r_cadd		varchar(10),
	r_u1val		varchar(50),
	r_u2val		varchar(50),
	r_u3val		varchar(50),
	r_u4val		varchar(50),
	r_u5val		varchar(50)
);

CREATE INDEX resources_ptag_idx  ON resources (r_ptag);
CREATE INDEX resources_ctag_idx  ON resources (r_ctag);
CREATE INDEX resources_mctag_idx ON resources (r_mctag);
CREATE INDEX resources_serno_idx ON resources (r_serno);

--
-- Dumping data for table 'resources'
--
