From deepak@npac.syr.eduMon Feb  8 19:22:44 1999
Date: Mon, 8 Feb 1999 19:20:39 -0500 (EST)
From: Deepak Ramanathan <deepak@npac.syr.edu>
To: Deepak Ramanathan <deepak@npac.syr.edu>

/****** Object:  Table dbo.emp    Script Date: 2/8/99 7:20:36 PM ******/
if exists (select * from sysobjects where id = object_id('dbo.emp') and 
sysstat & 0xf = 3)
	drop table dbo.emp
GO

/****** Object:  Table dbo.emp    Script Date: 2/8/99 7:20:36 PM ******/
CREATE TABLE dbo.emp (
	intID int IDENTITY (1, 1) NOT NULL ,
	empID varchar (20) NOT NULL ,
	fname varchar (100) NULL ,
	lname varchar (100) NULL ,
	mname varchar (100) NULL ,
	emploc varchar (200) NULL ,
	mgrname varchar (70) NULL ,
	address1 varchar (200) NULL ,
	address2 varchar (200) NULL ,
	address3 varchar (200) NULL ,
	city varchar (50) NULL ,
	state varchar (50) NULL ,
	zipcode varchar (50) NULL ,
	offphone varchar (50) NULL ,
	homephone varchar (255) NULL ,
	faxphone varchar (255) NULL ,
	cellphone varchar (255) NULL ,
	email varchar (255) NULL ,
	costcenter varchar (255) NULL ,
	cardnumber varchar (255) NULL ,
	cardname varchar (255) NULL ,
	expdate varchar (255) NULL ,
	cardtype varchar (255) NULL ,
	custallow varchar (255) NULL ,
	empgroup varchar (40) NULL 
)
GO




Deepak Ramanathan
Webmaster - Northeast Parallel Architectures Center
deepak@npac.syr.edu
http://www.npac.syr.edu/users/deepak