# MySQL dump 4.0
#
# Host: localhost    Database: keystone
#--------------------------------------------------------

#
# Table structure for table 'resources'
#
CREATE TABLE resources (
	r_tag		varchar(10) DEFAULT '' NOT NULL,
	r_ptag		varchar(10) DEFAULT '' NOT NULL,
	r_multi		int(1),
	r_serno		varchar(25) DEFAULT '' NOT NULL,
	r_mctag		varchar(20) DEFAULT '' NOT NULL,
	r_mcphone	varchar(10),
	r_mcadd		varchar(10),
	r_model		varchar(20),
	r_class		char(2),
	r_loc		varchar(10),
	r_qoh    	int(5),
	r_desc		varchar(80),
	r_status 	char(1),
	r_currtech	varchar(10),
	r_ctag		varchar(20) DEFAULT '' 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),
	KEY tag (r_tag),
	Key ptag (r_ptag),
	key serno (r_serno),
	key cont (r_ctag),
	key mcont (r_mctag),
	PRIMARY KEY (r_tag)
);

