/****** Object: Table [dbo].[Music_Categories] Script Date: 2/2/2000 11:59:06 PM ******/
if exists (select * from sysobjects
		where id = object_id(N'[dbo].[Music_Categories]') and
			OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Music_Categories]
GO

CREATE TABLE [dbo].[Music_Categories] (
	[Category] [smallint] IDENTITY (0, 1) NOT NULL ,
	[Description] [varchar] (50) NOT NULL ,
	[Comments] [varchar] (8000) NOT NULL ,
	[SortOrder] [smallint] NOT NULL
		CONSTRAINT [DF_Music_Categories_SortOrder] DEFAULT (0),
	CONSTRAINT [PK_Music_Categories] PRIMARY KEY  NONCLUSTERED 
	(
		[Category]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO