/****** Object:  Table [dbo].[authors]    Script Date: 8/31/2006 3:39:04 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[authors]
GO

/****** Object:  Table [dbo].[authors]    Script Date: 8/31/2006 3:39:04 PM ******/
CREATE TABLE [dbo].[authors] (
	[au_id] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[au_fname] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[au_lname] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[phone] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[address] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[city] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[zip] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[authors] WITH NOCHECK ADD 
	CONSTRAINT [authors_pk] PRIMARY KEY  CLUSTERED 
	(
		[au_id]
	)  ON [PRIMARY] 
GO

insert into authors values ('A01','Sarah','Buchman','718-496-7223','75 West 205 St','Bronx','NY','10468')
insert into authors values ('A02','Wendy','Heydemark','303-986-7020','2922 Baseline Rd','Boulder','CO','80303')
insert into authors values ('A03','Hallie','Hull','415-549-4278','3800 Waldo Ave, #14F','San Francisco','CA','94123')
insert into authors values ('A04','Klee','Hull','415-549-4278','3800 Waldo Ave, #14F','San Francisco','CA','94123')
insert into authors values ('A05','Christian','Kells','212-771-4680','114 Horatio St','New York','NY','10014')
insert into authors values ('A06','','Kellsey','650-836-7128','390 Serra Mall','Palo Alto','CA','94305')
insert into authors values ('A07','Paddy','O''Furniture','941-925-0752','1442 Main St','Sarasota','FL','34236')
insert into authors values ('A08','Sam','Schwartz','111-111-1111','123 Ave A','Brooklyn','NY','11111')
insert into authors values ('A09','Joe','Cohen','111-111-1112','123 Geshamk St.','Brooklyn','NY','11111')
insert into authors values ('A10','Sue','Schwartz','111-111-1113','456 Freilach St.','Brooklyn','NY','11112')
insert into authors values ('A11','Sam','Cohen','111-111-1114','789 VusMachDir St','Brooklyn','NY','11113')
insert into authors values ('A12','Jill','Cohen','888-888-8881','123 Actor Ave','Los Angeles','CA','88888')
insert into authors values ('A13','Andrea','Cohen','888-888-8882','345 Movie Place','Los Angeles','CA','88889')
insert into authors values ('A14','Andrea','Schwartz','888-888-8883','678 Director Blvd','Los Angeles','CA','88888')
insert into authors values ('A15','Andrea','Smith','888-888-8884','901 Movieland Ave','Los Angeles','CA','88888')
insert into authors values ('A16','Yankee','Schwartz','111-111-1115','101 2nd Ave','New York','NY','10015')
insert into authors values ('A17','Sylvester','Schwartz','111-111-1116','203 3rd Ave','New York','NY','10014')
insert into authors values ('A18','John','Schmidt','222-222-2221','303 4th Ave','New York','NY','10014')
insert into authors values ('A19','John','Dear','222-222-2222','404 5th Ave','New York','NY','10015')
insert into authors values ('A20','Sam','Shulman','444-444-4441','101 Dairy Lane','Milwaukee','WI','55555')
insert into authors values ('A21','Joan','Shulman','444-444-4441','101 Dairy Lane','Milwaukee','WI','55555')
insert into authors values ('A22','Jack','Shulman','444-444-4441','101 Dairy Lane','Milwaukee','WI','55555')
insert into authors values ('A23','Alan','Siegel','333-333-3331','101 Comp St','Passaic','NJ','22221')
insert into authors values ('A24','Sam','Calahan','333-333-3332','101 Jones St','Morristown','NJ','22229')
insert into authors values ('A25','John','Camden','333-333-3333','304 Charles Ave','Passaic','NJ','22223')