CREATE TYPE [dbo].[id] FROM [varchar](11) NOT NULL
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[authors](
	[au_id] [dbo].[id] NOT NULL,
	[au_lname] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[au_fname] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[phone] [char](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[address] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[city] [varchar](20) 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,
	[contract] [bit] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[publishers](
	[pub_id] [char](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[pub_name] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[city] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[state] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[country] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
